Mangesh Balpande Email and Phone Number

Professional Experience Client: Praxair Inc. Duration: Jun 2016 – Nov 2017 Title: Lead ODI Developer Project: Global Procurement Data Integration and Post-Implementation Support. The purpose of the project is to integrate global procurement data for several business units located in various countries around the world and enable BI reporting & analytics. Implementation was done using Oracle data integrator (ODI) for data extraction, transformation & loading (ETL) from disparate sources into an enterprise data warehouse (EDW), and Oracle BI (OBIEE) was used for business reporting & analytics. Responsibilities • Developing ODI Interfaces, Packages, Variables and Procedures. • Designing complex ODI Load plan structures using CASE statements, including serialization and parallelism, also worked on ODI exception handling where all are maintaining generic behavior. • Resolving the production issue of ODI. • Delegate the tasks to the team with regards to development, testing, migrating, and implementing the mappings across various environments. • Designing complex ODI Load plan structures using CASE statements, including serialization and parallelism, also worked on ODI exception handling where all are maintaining generic behavior. • Implemented SCD & CDC for CR. • Delegate the tickets to the team to resolve issue. • Worked on critical tickets & improve the performance of ODI JOBS • Resolving the production issue of ODI. • Delegate the tasks to the team with regards to development, testing, migrating, and implementing the mappings across various environments

Client: State Bank of India General (SBIG) Duration: Dec 2015 – Jul 2016 Title: ODI/ETL Consultant Project: Implementation of Oracle data integrator (ODI) for data extraction, transformation and loading (ETL) for BI reporting and analysis in Banking domain. Responsibilities • Installed, configured and setup ODI on Weblogic server 10.3.6. • Implemented ODI ETL jobs that fetched high-volume data from source systems and loaded to the data warehouse. Including automated dependency management, exception handling for reporting data. • Performed technical requirements analysis, solution designed and development of ETL/ELT programs that integrated data from different types of sources. • Developed and tested several interfaces, packages, variables, sequences, user functions, scenarios and procedures in ODI. • Planned, executed and monitored ETL jobs and quickly resolved any issues encountered within SLAs. • Performed root cause analysis, reviewed logs and debugged jobs and packages to resolve load issues. • Implemented ODI ETL standards and best practice to ensure quality solution and minimal defects. • Worked closely with business leads and functional SMEs as single point of contact for troubleshooting and resolving issues with data warehouse load and BI reporting. • Designed ETL specifications for data integration from source system to staging, and staging to enterprise data warehouse (EDW). • Provided technical help to team members in BI repository (RPD) creation and development of reports and dashboards.

Client: Yes Bank Duration: Dec 2014 – Dec 2015 Title: Data Warehouse Consultant Project: Implementation of Oracle data integrator (ODI) for data extraction, transformation and loading (ETL) with Golden Gate replication of data from different sources in near real-time for reporting and analysis in Banking domain. Responsibilities • Installed, configured and setup ODI. Performed system analysis and documentation. • Configured ODI Standalone agent. Started and stopped agent services. • Configured master repository, work repository architectures and developed ODI Interfaces, Packages, Variables and Procedures. • Debugged and resolved data issues in preproduction and production environment. • Designed complex ODI load plan structures using CASE statements, serialization, parallelism and exception handling, where generic behaviour is maintained. • Completed Oracle Golden Gate configuration and setup on source and staging environments for data replication process.

Client: Reserve Bank of India (RBI) Duration: Jun 2012 – Dec 2014 Title: Data Warehouse BI Developer Projects: RBI Automated Data Flow for Regulatory Returns Oracle Financial Service Application (OFSA) Implementation Responsibilities • Installed, configured and setup ODI. Performed system analysis and documentation. • Configured ODI Standalone agent. Started and stopped agent services. • Configured master repository, work repository architectures and developed ODI Interfaces, Packages, Variables and Procedures. • Worked as liaison between offshore and onsite teams. Clarified requirements and communication. • Implemented design in development. Performed developer testing, deployed to QA and production. • Performed gap analysis for missing criteria. • Designed BI data repository (RPD) to meet the business reporting requirements. • Debugged and resolved data issues in preproduction and production environment. • Designed complex ODI load plan structures using CASE statements, serialization, parallelism and exception handling, where generic behaviour is maintained. • Rebuilt Congo’s reports in OBIEE 11g. • Analysed OBIEE reports for performance and implemented improvements. • Created documentation for unit test cases and dependencies.