I am a Senior Consultant and is Proficient with Business Intelligence & Analytics using Oracle BI tech stack. Over these years have mainly involved in understanding the overall reporting & analytics needs of the various leaders across multiple organizations or departments in terms of metrics, KPI's, facts, financial numbers that the business is interested and then designing & architecting the BI solutions for it using Oracle BI technologies, which includes Oracle Analytics/Oracle Business Intelligence Applications (OBIA), Oracle Analytics Server (OAS), Oracle Data Integrator (ODI) and Oracle DV. Also, currently I am pursuing Master of Management in Analytics (MMA) degree from Smith School of Business, Queens University, Kingston, Ontario, Canada. Professional Summary: • Lead the Data Modelling and development of various star schemas, snowflake schemas for multiple domains like Employee Expenses, HR, Finance, Projects, Procurement & Spend, Automotive and four legacy systems.• Lead the ETL design & Development using ODI from multiple ERP systems or databases like PSA HR, PSA Finance, PSA RM, Oracle EBS, Oracle Fusion.• Lead the integration of Multiple Legacy systems into the enterprise Datawarehouse using ODI & OAS.• Lead the design of Key Metrics and KPI’s in OBIEE & OAS.• Lead the BI Reports and Dashboards Design & Development in OBIEE, OAS & Oracle DV.• Developed BI Publisher reports • Lead the Security Design of BI reporting system.• Lead the Data load and Monitoring design and development.• Lead the Support team to manage day to day issues in the BI system.• Have the experience of leading and managing the BI teams as Project Leader in the present organization and previous organizations for multiple BI projects.• Also have the knowledge of SCRUM & Agile concepts and methodologyCore Competencies:Have worked with Oracle BI technologies, which includes. • Oracle Analytics/Oracle Business Intelligence Applications (OBIA), • Oracle Analytics Server (OAS), • Oracle Business Intelligence Enterprise Edition (OBIEE) 12c,• Oracle BI Publisher and • Oracle DV.Also proficient in the ETL tools like • Oracle Data Integrator 11g/12c,• Informatica 9.0.1, SQL & PL/SQL• Have a fair development experience in SSIS.• Have an incredibly good expertise in SQL & PL/SQL.Also, as part of current on-going MMA masters degree learning the below tools,• Linear Regression Model, Predictive Modelling in Python & R• Palisade tools like @Risk, Precision Tree, Stats Tools• Simul8 • Tableau, Snowflake,PowerBI
