Building data lake platform code for replication of huge tables. Roles: Design and Development Technologies: OCI Data flow, Python, PySpark, SparkSQL, delta lake, OCI  Building data lake platform code using PySpark, SparkSQL, delta lake (Databricks API) and OCI Data Flow (OCI fully managed spark service) which can be adopted by all the projects in organization for replicating huge tables (few billion rows).  Worked on various APIs – HouseKeeping, Logging, Data Compare, Incremental Extract etc.  Integrating it with existing ODI replication architecture.

Blended reporting based on multiple sources - License, Order, Contracts and invoices to help business look at active and expired contracts to take decision on Customer License migrations. Roles: Project Lead, Requirement Analysis, Design and Development Technologies: ODI, OBIEE, PL/SQL  Worked with multiple dev teams to understand the flow and functionality of different modules of Oracle ERP and designed data model for these reports.  Eliminated manual effort of 3 teams (Global Migrations, Global Assignments and License Inventory businesses) from pulling reports from different systems( Oracle on-premise and Fusion cloud) and manually merging data

Reporting to serve various Inventory business needs like Aging, On hand and Spend. Being built from scratch as source system changes from Oracle E-business suite (On-premise) to Oracle Fusion cloud. Roles: Project Lead, Requirement Analysis, Design and Development Technologies: ODI, OBIEE, PL/SQL, OJet  Leading the project from requirements phase, and played a pivotal role in designing Data Model with data coming from various sources (Oracle ERP system and external parties).  Built ETL, obiee reports and OJet application for transactional requirements from report data.

Custom reporting application to automate manual process done by Order Management analysts to build KPIs on Order Booking Volumes, Input Quality and Turn around Time. Roles: Data Model Design & Development Technologies: PL/SQL , OBIEE  Took the responsibility to clearly understand complex flows in each system, data relations and architecture solution to build custom facts and dimensions. ETL – PL/SQL and obiee for reporting. Project saves manual effort of 5 people for 7 days a month.

Reporting on Oracle Employee Travel data. Roles: Data Model Design & Development Technologies: ODI, OBIEE  Built an in-house reporting tool to replace an existing 10 year contract with a third party vendor for Travel Reporting of Oracle Employee data which saves 100K USD per year.  Involved in ODI, OBIEE development and worked on an Apex application to upload data corrections. Successfully implemented the project with high quality code ahead of timelines.

Building data lake platform code for replication. Technologies: OCI Data flow, Python, PySpark, SparkSQL, delta lake, OCI Roles: Design and Development Building data lake platform code using PySpark, SparkSQL, delta lake (Databricks API) and OCI Data Flow (OCI fully managed spark service) to build organizational data lake. Worked on development and testing of various APIs - Housekeeping, Logging, Data Compare, Incremental Extract etc. Integrating it with existing ODI replication architecture.