Kshitiz Shrivastava, Developer in Toronto, ON, Canada
Kshitiz is available for hire
Hire Kshitiz

Kshitiz Shrivastava

Verified Expert  in Engineering

ETL Architect and Developer Developer

Toronto, ON, Canada

Toptal member since April 1, 2025

Bio

Kshitiz is a results-driven technology leader with 18+ years of experience in infrastructure modernization, data analytics, and business intelligence (BI) strategy. He has a proven track record of modernizing enterprise BI infrastructures and leading multi-million-dollar government, retail, CPG, insurance, and finance projects. Kshitiz specializes in ETL architecture, Oracle EPM infrastructure, data analytics, and cloud transformation.

Portfolio

Government of Ontario
Informatica, Oracle, Oracle Hyperion Planning, Oracle BI Publisher...
Iconomics
Oracle Hyperion Planning, Oracle Data Integrator (ODI), Informatica...
Tata Consultancy Services
Informatica, IBM Cognos, Jira, Autosys, Microsoft Power BI, Tableau, Erwin...

Experience

  • PL/SQL - 18 years
  • Oracle - 18 years
  • Informatica - 18 years
  • Data Visualization - 10 years
  • Oracle Data Integrator (ODI) - 9 years
  • Oracle Hyperion Planning - 9 years
  • Oracle OEM 13c - 9 years
  • Tableau - 4 years

Availability

Full-time

Preferred Environment

Informatica, Oracle, Oracle Data Integrator (ODI), Tableau, Oracle Hyperion Planning, Azure Data Factory (ADF)

The most amazing...

...project I've participated in reduced infrastructure costs by 50% by consolidating Hyperion and Oracle Data Integrator (ODI) infrastructure.

Work Experience

Principal BI Consultant | EPM Infrastructure Lead | ETL Architect | ETL Developer

2018 - PRESENT
Government of Ontario
  • Reduced infrastructure costs by 50% by consolidating systems.
  • Improved data processing times by 30% by optimizing data pipelines and PL/SQL code.
  • Led enterprise performance management (EPM) upgrades in complex clustered, load-balanced, and multiplatform environments.
  • Conducted Informatica and Oracle Data Integrator (ODI) upgrades.
  • Migrated Hyperion's Essbase from a physical server to a virtual machine, reducing the operating cost of the environment by 20%.
  • Spearheaded the migration of on-prem Hyperion applications to Azure Cloud.
Technologies: Informatica, Oracle, Oracle Hyperion Planning, Oracle BI Publisher, Oracle OEM 13c, WordPress, Azure, Batch Scripting, Unix Shell Scripting, Oracle ODI, Software Engineering, Data Visualization, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), PL/SQL, Oracle Data Integrator (ODI)

Principal BI Consultant

2015 - 2018
Iconomics
  • Led EPM infrastructure upgrade projects in complex clustered and load-balanced Windows and Solaris environments.
  • Researched Change Data Capture features in SQL Server environments for reporting.
  • Conducted research and evaluation of Oracle Cloud and Oracle Analytics Cloud (OAC) to lift and shift Oracle Business Intelligence Enterprise Edition 11g (OBIEE).
  • Supported Hyperion EPM infrastructure and applications, including data integration and loading using ODI and FDMEE.
Technologies: Oracle Hyperion Planning, Oracle Data Integrator (ODI), Informatica, Oracle Analytics Cloud (OAC), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Cloud, SQL Server Integration Services (SSIS), Change Data Capture, SQL Server DBA, SAP, FDMEE

ETL Architect | Informatica Lead Developer | Cognos Support Specialist

2006 - 2014
Tata Consultancy Services
  • Led the BI system merger when Kraft Foods acquired Cadbury.
  • Managed the BI system split when Kraft Foods split into Mondelez.
  • Conducted the Informatica upgrade from 8.6 to 9.5 and designed and developed ETL processes for indirect sales reporting.
Technologies: Informatica, IBM Cognos, Jira, Autosys, Microsoft Power BI, Tableau, Erwin, Batch Scripting, Unix Shell Scripting, Software Engineering, Data Visualization

Experience

Hyperion EPM Infrastructure Modernization

This project involved leading the upgrade of Hyperion's EPM from 11.2.10 to 11.2.18 in a clustered environment spanning multiple platforms. I handled the pre-upgrade assessment, conducting a thorough system analysis, including compatibility checks, infrastructure readiness, and impact assessment on integrations with databases, FDMEE, ODI, and external reporting tools. I also devised a comprehensive backup and rollback strategy to minimize downtime and mitigate risks.

I then executed the upgrade, performing in-place upgrades on both Windows and Linux nodes, applying patches, reconfiguring WebLogic, updating database schemas, and ensuring seamless integration with existing applications. Post-upgrade testing involved conducting rigorous functional, performance, and regression testing across planning, Essbase, and reporting modules to confirm data integrity and system performance.

The upgrade was successful as it minimized disruptions in business operations while ensuring a stable, high-performing EPM environment with enhanced security and extended Oracle support.

Cadbury and Kraft Foods BI Systems Merger

I successfully led the integration of Cadbury's BI systems with Kraft's by migrating and converting data from Cadbury's systems to Kraft's SAP environment. The project involved installing and configuring Informatica libraries on Kraft's SAP systems and designing and implementing optimized data extraction processes for all Cadbury products to support custom business reporting.

This project involved strong collaboration with IS project teams and key stakeholders to assess system-driven changes, define migration strategies, and align change management efforts. I ensured a seamless data transition, improved reporting accuracy, and minimized business disruptions during the integration.

Kraft and Mondelez BI Systems Split

I led Mondelez's data transition process during its split from Kraft, ensuring a seamless migration of critical business data, including actuals, forecasts, and trade planning, from Kraft to Mondelez systems. I worked closely with the IS project teams to analyze data dependencies, define migration strategies, and implement integration solutions. The project successfully minimized operational disruptions, ensured data accuracy, and enabled Mondelez to establish independent reporting and planning capabilities post-split.

Education

2002 - 2006

Bachelor's Degree in Information Technology

Shri Govindram Seksaria Institute of Technology (SGSITS) - Indore, MP, India

Certifications

MARCH 2025 - PRESENT

Create Mapping Data Flows in Azure Data Factory

Coursera

MARCH 2025 - PRESENT

Informatica Data Management Cloud (IDMC) Foundation

Informatica

MARCH 2025 - PRESENT

Azure DevOps for Beginners

LinkedIn

MARCH 2025 - PRESENT

Academy Accreditation – Databricks Fundamentals

Databricks

MARCH 2025 - PRESENT

Microsoft Certified – Azure Data Fundamentals

Microsoft

FEBRUARY 2025 - PRESENT

Tableau Desktop Specialist

Tableau

FEBRUARY 2022 - PRESENT

Oracle Cloud Platform Enterprise Analytics 2021 Certified Specialist

Oracle

FEBRUARY 2022 - PRESENT

Oracle Autonomous Database Cloud 2021 Certified Specialist

Oracle

AUGUST 2020 - PRESENT

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle

AUGUST 2020 - PRESENT

Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate

Oracle

MARCH 2019 - PRESENT

Informatica Developer Specialist

Informatica

Skills

Tools

Oracle OEM 13c, Tableau, Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), IBM Cognos, Jira, Autosys, Microsoft Power BI, Erwin, Hyperion

Paradigms

Oracle ODI, ETL, Azure DevOps

Platforms

Oracle Data Integrator (ODI), Oracle, WordPress, Azure, Oracle Analytics Cloud (OAC), Databricks

Storage

PL/SQL, Oracle Cloud, SQL Server Integration Services (SSIS), SQL Server DBA, Azure Cloud Services

Languages

Java

Other

Informatica, Software Engineering, Unix Shell Scripting, Batch Scripting, Oracle Hyperion Planning, Azure Data Factory (ADF), Change Data Capture, SAP, Data Visualization, Informatica Cloud, Oracle Hyperion EPM, Information Technology, FDMEE

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring