Pranay Pandey

11 years of experience in Implementing Data Warehousing and Business Analytics Application, Data Analysis, Data Mapping and ETL. Good exposure to Business Intelligence Applications specifically using Oracle Business Intelligence (ODI/PLSQL/SQL). Developed SQL procedures and scripts to load and validate data as part of the ETL build.

Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles. Strong knowledge in developing ODI interfaces/Mappings, packages, procedures, sequences and scenarios, Load Plans, performance tuning and debugging the ODI Mappings. Over 11 years of experience in the IT industry in database and ETL.

Comprehensive experience with the implementation of large scale ETL processes using Oracle Data Integrator (Version 11g & 12C): using Interfaces/Mappings, Variables, Sequences, Procedures, Scenarios, Packages, Load Plans and Knowledge Modules, configuration and management of ODI agents (local, standalone & J2EE).

Experience in ODI release management - coordinating the DEV > TEST > PROD movement. Strong in SQL and PL/SQL, writing complex queries and performance tuning. Worked extensively on UNIX shell scripting to automate and facilitate data processing activities and events.

Experienced and proficient in installation and configuration of Oracle database, Data Integrator and Business Intelligence. Worked alongside Business Analysts and clients during requirement gathering phases of all projects taken up. Effectively managed clients during the whole lifecycle of the projects - esp. during UAT.

Possess sound understanding of data warehousing concepts. Deployed at client site ICICI Bank as BI-Consultant, having expertise in Oracle, excellent exposure of PL/SQL, ODI (ETL Tool), and DWH. Worked in enhancement tasks to understand the changes required to the existing system and have designed and implemented the changes as per business requirements.

Adapt at all stages of project lifecycle viz.

Requirements Gathering, Design, Coding & Unit Testing, SIT, UAT, Prod Deployment and Support. Created/modified Metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layer.

Experience in client handling and working onsite.

Senior Consultant at Apps Associates (I) Pvt Ltd. (2022-06-10 – Present)

Project 1: American Tower Corp. - Project involves Complete Maintenance/Enhancement/Prod Support for all Integrations through ODI for all US and International Markets. Refreshing of Complete Data warehousing Models and Reports Based on Business takes Critical Decision with their Respective Entities. Duration: 06th Nov 2023 – Till Now. Tools/Software: ODI 12c, SQL developer, Bit Bucket, Source tree, Winscp. Database: Oracle 11g/Oracle 12c. Operating System: Windows 10.

• Responsible for All New Maintenance Request from Business for Addition in Process Flow as per Requirement Document Shared by Business Team and Collaboration with Reporting Team for Extension of Same for Business Purpose.
• Load Monitoring for US and International Loads and Fixing the Issue in Case of Failure to Ensure Timely Completion of Loads Before Business Starts.
• Responsible for Performance Tunning of Loads in case same use to take time to get complete.
• SQL Tunning through Indexes/ Partition as when required to Improve Load Performance In case of Data Volume Increase.
• Immediate Production Fix as per requirement to Ensure all Facts and Dimension should get Refreshed along with their Reports.
• Creation of Complex ODI Mapping/Procedure/Package and PLSQL Logic Implementation.
• Exception Handling in Process to Avoid Load Failure.
• Preparation of Development Approach Document and Sharing Same with Onsite for Sign off and Development Initiation.
• Preparation of Test Case (Sample & Regression) for SIT & UAT for Further Prod Deployment.
• Creation of Service Now-PCR (Change Request) with Deployment Artifacts on SVN Tools/Bit-Bucket/Git/ SourceTree along with Co-ordination to Approving Authorities.
• Regular Connect with Onsite Team with Updating Load Status, Suggestion in case of any Load Performance and Sharing Load Status Mail to All Onsite Member.
• Creation of SOX Audit Document and PBC Document Required by Audit Team Monthly/Quarterly.
• Sharing Analysis for all Incident and Production Observation Raised by Business.
• Updating Status of Incident Ticket on Weekly Ticket Status Meeting.
• Daily Co-ordination with Onsite Team on Production Status Call.
• Enhancement in Production Load Plan as an when Required to Ensure Timely Completion of Loads.
• Co-ordination with Application Admins and Oracle DBA for Requests Related to Table Performance & Load Execution in Production Ad-Hoc.
• End to End Process Flow Development with Final Production Deployment and GO-LIVE Declaration.
• Preparation of Technical Design Document as Per Requirement of Client and Project.
• 24/7 Support as and when Required by Client.
• Daily Connect with Team Members in case of any New POC's and Process Enhancement.
• Working with Essbase team for Cubes Refresh and Prod Observation on same.
• Preparation of SOX Documentation for Audit Purpose QTLY.

Senior Consultant at Apps Associates (I) Pvt Ltd. (2022-06-10 – 2023-09-30)

Project 2: ATC India – Mulesoft Data Integration &

• Oracle Billing &

• Revenue Management System - Project involves Integration of Data from ATC Siterra Operational System, which hold all information related to Tower Infrastructure service provided to Telecom Providers to Oracle Billing &

• Revenue Management (OBRM) System through ODI 12c and PLSQL along with Generating Reporting through Oracle BI Tools. Here for different billing Modules that are IP (Infrastructure &

• Power – Hold Information Related to Asset, Site, Tenant and Hold-Exit (No. of Tenant &

• Asset Hold/UnHold or Exit) &

• PF (Power &

• Fuel– Hold Information Related to Electricity &

• Diesel Usage and Consumption) data batches are generated through BI Reporting Technology for Particular Month and Shared to Oracle Billing &

• Revenue Management (OBRM) Team for Billing to Customer for Particular Billing Month.

Tools/Software: ODI 12c, BI Publisher, SQL developer, Bit Bucket, Source tree, Winscp, Putty, MobaXtrem.

Database: Oracle 11g/Oracle 12c/Oracle 19c.

Operating System: Windows 10.

• Responsible for fixing daily and Real-time Critical Production Observations of IP, PF & O&M (Operation & Maintenance) Interface Billing Data.
• Involved in all Requirement & Understanding provided by Business Analyst and Client through BRD and develop new code/logic or change in existing Code/Logic in ODI 12C/PLSQL to implement the requirements for billing impact.
• Creation of Complex ODI Mapping and PLSQL Logic Implementation.
• Complete involvement in Providing Critical Billing Batch/Data Generation for IP(Asset,Site,Tenant & Hold Exit) & PF(EB(Electricity-Board),DG(Diesel Generator),FEM, Rates & Outage)and Fixing of Data Issue in Real Time so that Batch should get processed in Client Fixed Billing Day.
• Preparation of Test Case (Sample & Regression) for SIT & UAT.
• Creation of Service Now-PCR (Change Request) with Deployment Artifacts on SVN Tools along with Co-ordination to Approving Authorities.
• Performance Tuning in ETL Jobs and Table Maintenance done as required when billing incremental interface process performance degrades.
• Responsible for final Production Deployment and GO-Live declaration.
• Worked on BI Reports for Generation of Billing Batches also Documents Preparation for new development of BIP Reports.
• Preparation of Technical Design Documents as per requirement of Client.
• Upfront Involvement in ODI Job Monitoring for Billing Interface and Fixing of Issue in case of Failure.
• Supported on Weekend/Holidays for Generation of Billing Batches.

Sr.Associate/Sr.Consultant at PwC India (PricewaterHouseCoopersService LLP) (2021-07-05 – 2022-05-31)

Project 2: FDM (Financial Data Mart) Transformation & OWB Remediation - Project involves platform modernization from OWB to ODI tool and Creation of new ETL Mappings for Ledgers and ATM Balances in ODI 12c. Client: RBS-Royal Bank of Scotland. Tools/Software: ODI 12c, OWB 12C, SQL developer, GIT Hub, Winscp, Putty, HP Server Automation. Database: Oracle 11g/Oracle 12c. Operating System: Windows 10.

B.E (Computer Engineering).