Piyush Kumar

WORK HISTORY

EDUCATION

ABOUT PIYUSH KUMAR

Principal Consultant at Oracle Consulting with over 17 years of professional experience in Data Warehousing and Business Intelligence, primarily around Information Management, Data Integration, and Enterprise Reporting.• Expertise in Solution Design, IT Delivery, and Development with industry experience in Life Sciences, Financial Services, Government and Public Sector with exposure to Telecom, Retails and Insurance Industries.• Experience working alongside businesses not only to manage and maintain their data but also to help derive meaningful insights from various datasets, often combining them.• Extensively worked on Extraction, Transformation, and Loading data from various sources like Oracle EBS, Fusion, EPM, SQL Server, and Flat files to various Targets including Oracle Autonomous Databases (ADW, ATP).• Expertise in building reports aligned to different Modules including Finance (AP, AR, and GL), SCM, and HR.• Responsible for all activities related to the development, implementation, administration, and support of ETL processes for large-scale data warehouses using ODI, ODI Marketplace, and Informatica Power Center 9.6.1.• Experience and knowledge with analytics components and design methodologies including Data Lake, Enterprise Data warehousing, Kimball methodology, and dimensional modeling.• Extensive experience in ETL design, development, and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 8.x/9.x/11.x.• Experience in developing an Interactive Dashboard using OACS (Oracle Analytics Cloud), OBIEE, and Tableau.• Extensive experience in setting up DR environment across different regions in Oracle cloud using Autonomous Data Guard • Well versed in developing the complex SQL queries, unions, multiple table joins, and experience with Views.• Experience in database programming in PL/SQL (Stored Procedures, Packages, Functions, and Triggers, etc.).• Well versed in UNIX shell scripting.• Exposure to Data Mining, Predictive Analytics, and Machine Learning.• Excellent communication, documentation, and presentation skills to adapt to technical and non-technical audiences, utilizing MS Office Suite.