Senior Consultant
KPI Partners
(Internet and Information Technology, 50-250 employees)
Keywords
Extract Transform Load (ETL)
Data Warehousing
Data Science
Big Data
Data Integration
Python (Programming Language)
Machine Learning
Microsoft Azure
Oracle Business Intelligence Enterprise Edition
Oracle Data Service Integrator
Skills
Accomplished IT professional Over 20+ years of experience in design, architect and implementing Digital transformation and Data Analytics products and services in large enterprises across the globe and wide range of industries.
•Expertise in Data Engineering projects using Big data technologies Kafka, Apache Spark, Python, HBase, Hive, RDS, Redshift.
• In depth knowledge of Statistics, Machine Learning Algorithms, Hypothesis testing, Regression Analysis, Clustering, ML Libraries in Python for Data Science projects.
• Skilled in deploying Cloud Computing Platforms on AWS, Azure, GCP for Big data projects.
• Completed 12 months of Executive Post Graduation Program in Data Science at IIITB, Bangalore, Pursuing MS, Data Science at LJMU, UK.
• Expertise in Analytics projects such as platform Upgrades, Migration, Building Data Warehouses from Base up, Lift and Shift of Data warehouses, sourcing multiple source systems types (Oracle, SQL Server, json, csv File systems), automating of large number of data loads in parallel using scheduling tools, multiple downstream systems using ETL tool ODI and real time integration with Goldengate.
• Improved ETL run time from 18 hours to 4 hours for Global Semiconductor client.
• Expertise in SQL Performance tuning of Large and some of most complex Data loading for enterprises, performance increase from ETL run times from 30 hours to 6 hours.
• Extensively involved in DR Sites setup, DR Testing, Data Validation and UAT for highly complex data integration and analytics projects for large Oil and Gas customer.
• Well versed with Agile Project Management tools (Jira) for complex data integration and analytics projects for global customers.
• Architected Cloud based IOT Solution for one of large Indian Machine tool manufacturing group for remote monitoring of machines at customer locations across India.
• As Engineering Manager lead a team of 10+ developers with responsibility of product development in multiple product releases of Oracle Agile PLM Analytics (OPLA) solution on Oracle analytics platforms ODI and OBIEE, supported deployment at large fortune 500 customers for Hitech, Medical device, CPG customers.
• Lead Design and Development large Banking data warehouse project spanning multiple years of development, maintenance and support.
• In depth knowledge in RDBMS Systems (Oracle, Microsoft SQL Server, PostgreSQL) and performance tuning of complex database systems.
•Worked with customer, project team and stake holders to manage the scope, deliverables.
•Expertise in Data Engineering projects using Big data technologies Kafka, Apache Spark, Python, HBase, Hive, RDS, Redshift.
• In depth knowledge of Statistics, Machine Learning Algorithms, Hypothesis testing, Regression Analysis, Clustering, ML Libraries in Python for Data Science projects.
• Skilled in deploying Cloud Computing Platforms on AWS, Azure, GCP for Big data projects.
• Completed 12 months of Executive Post Graduation Program in Data Science at IIITB, Bangalore, Pursuing MS, Data Science at LJMU, UK.
• Expertise in Analytics projects such as platform Upgrades, Migration, Building Data Warehouses from Base up, Lift and Shift of Data warehouses, sourcing multiple source systems types (Oracle, SQL Server, json, csv File systems), automating of large number of data loads in parallel using scheduling tools, multiple downstream systems using ETL tool ODI and real time integration with Goldengate.
• Improved ETL run time from 18 hours to 4 hours for Global Semiconductor client.
• Expertise in SQL Performance tuning of Large and some of most complex Data loading for enterprises, performance increase from ETL run times from 30 hours to 6 hours.
• Extensively involved in DR Sites setup, DR Testing, Data Validation and UAT for highly complex data integration and analytics projects for large Oil and Gas customer.
• Well versed with Agile Project Management tools (Jira) for complex data integration and analytics projects for global customers.
• Architected Cloud based IOT Solution for one of large Indian Machine tool manufacturing group for remote monitoring of machines at customer locations across India.
• As Engineering Manager lead a team of 10+ developers with responsibility of product development in multiple product releases of Oracle Agile PLM Analytics (OPLA) solution on Oracle analytics platforms ODI and OBIEE, supported deployment at large fortune 500 customers for Hitech, Medical device, CPG customers.
• Lead Design and Development large Banking data warehouse project spanning multiple years of development, maintenance and support.
• In depth knowledge in RDBMS Systems (Oracle, Microsoft SQL Server, PostgreSQL) and performance tuning of complex database systems.
•Worked with customer, project team and stake holders to manage the scope, deliverables.
Project history
10/2021
-
Present
USA
* Technologies: ODI 11g / 12c, OBIEE 11g / 12c,
Goldengate, Oracle 19, PLSQL, Cognos, Tidal,
Citrix Desktops, Dev, QA and Prod Environments,
DR Servers
* Architecture of client's overall data strategy,
various sources, Data Integration systems, targets
and downstream systems.
* Lead ETL tool upgrades (ODI 11g to ODI 12c) of
North America and Canada Region, Data
warehouses integration with JD Edwards.
Including 200+ Batch and Real time ETL data
loads
* Lead Migration of Data Warehouse from Cognos
to Oracle Data Analytics Platforms ODI and OBIEE
using existing North America Warehouse
template.
* Technologies: ODI 11g / 12c, OBIEE 11g / 12c,
Goldengate, Oracle 19, PLSQL, Cognos, Tidal,
Citrix Desktops, Dev, QA and Prod Environments,
DR Servers
* Architecture of client's overall data strategy,
various sources, Data Integration systems, targets
and downstream systems.
* Lead ETL tool upgrades (ODI 11g to ODI 12c) of
North America and Canada Region, Data
warehouses integration with JD Edwards.
Including 200+ Batch and Real time ETL data
loads
* Lead Migration of Data Warehouse from Cognos
to Oracle Data Analytics Platforms ODI and OBIEE
using existing North America Warehouse
template.
03/2021
-
09/2021
Senior Consultant
KPI Partners
(Semiconductor), USA
* Technology: ODI 11g / 12c, OBIEE 11g / 12c,
Oracle, PLSQL, Jenkins, Bitbuckets, Jira
* Worked with customer sponsor, business and
technical team and helped with optimum
solution approach for the project
* Lead ETL tool upgrade / Customizations /
performance optimization of Oracle Product
Lifecycle analytics (OPLA) Solution for US based
Semiconductor Company (On semi)
* Achieved huge performance improvement up to
4 times in ETL Run time, i.e. from existing 18 hours
to 4 hours by optimizing and restructuring ETL
code. Customer appreciation for the
commendable results.
* Technology: ODI 11g / 12c, OBIEE 11g / 12c,
Oracle, PLSQL, Jenkins, Bitbuckets, Jira
* Worked with customer sponsor, business and
technical team and helped with optimum
solution approach for the project
* Lead ETL tool upgrade / Customizations /
performance optimization of Oracle Product
Lifecycle analytics (OPLA) Solution for US based
Semiconductor Company (On semi)
* Achieved huge performance improvement up to
4 times in ETL Run time, i.e. from existing 18 hours
to 4 hours by optimizing and restructuring ETL
code. Customer appreciation for the
commendable results.
09/2018
-
03/2021
GM Software
Ace Micromatic Manufacturing Intelligence Technologies
Technologies, Bangalore
* Architected cloud based Industrial IOT solution to
support customers across the nation and
remotely monitor the machines for ACE group
companies.
* Lead implementation of Industry 4.0 solutions for
L&T Boiler Plant Hazira, Micromatic Grinding, Ace
Designers, Wipro Aero Bangalore and Auto CNC
Bangalore, Sona industries Noida .
* Lead Evaluation / standardize Project
management process, tools across organization.
Standardize product development and change
management.
* Architected cloud based Industrial IOT solution to
support customers across the nation and
remotely monitor the machines for ACE group
companies.
* Lead implementation of Industry 4.0 solutions for
L&T Boiler Plant Hazira, Micromatic Grinding, Ace
Designers, Wipro Aero Bangalore and Auto CNC
Bangalore, Sona industries Noida .
* Lead Evaluation / standardize Project
management process, tools across organization.
Standardize product development and change
management.
03/2013
-
08/2018
Co-Founder and Head Business Analytics
Converbiz Technologies
* As head of Analytics supported design and
development of analytics for multiple products
and solutions for large customers.
development of analytics for multiple products
and solutions for large customers.
06/2007
-
12/2012
Senior Engineering Manager
Oracle India Pvt ltd
* Lead engineering team of 10 people in building End
to End Product Oracle Lifecycle solution integrated
with Oracle Agile PLM Source Systems
* Supported implementation / deployment of OPLA
(Oracle Lifecycle Analytics ) for customers such as
Cisco, Dell, Philip Morris International, Herbal Life,
Synaptics, Ranbaxy .
to End Product Oracle Lifecycle solution integrated
with Oracle Agile PLM Source Systems
* Supported implementation / deployment of OPLA
(Oracle Lifecycle Analytics ) for customers such as
Cisco, Dell, Philip Morris International, Herbal Life,
Synaptics, Ranbaxy .
04/2003
-
05/2007
Project Manager
iGate Global Solutions
* As Project Lead managed a large banking data
warehouse development project, offshore
development team size of 50+, managed their
performance, multiple projects including
development, maintenance and production
support.
warehouse development project, offshore
development team size of 50+, managed their
performance, multiple projects including
development, maintenance and production
support.
Certifications
Local Availability
Only available for remote work
