Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
SUNIT PADHY

SUNIT PADHY

Colonia

Summary

Data and analytics Engineering leader in Chief Data Office with 20 years of experience leading end-to-end data ecosystems of a leading Reinsurance and Global investment firm, from application development and system design to business intelligence, analytics, and reporting. Combines deep expertise in data architecture with modern platforms such as AI/ML and AWS Cloud to build scalable, compliant, and business-aligned solutions across advertising, publishing, finance, banking, and higher education.

Known for translating complex technical concepts into clear, actionable insights for senior stakeholders while driving Agile transformation, data literacy, and a culture of informed decision-making. Experienced in leading high-performing teams, setting data strategy, and governing enterprise analytics environments that support financial planning, operational performance, and executive decision support.

Over the course of the career, I have held responsibilities spanning solution design and architecture (15+ years), IT project management (5+ years), and supervisory leadership (6+ years), consistently trusted by executives to shape data strategy and execute complex transformation roadmaps

Experienced with financial management, strategic planning, and risk assessment. Utilizes comprehensive knowledge to drive operational efficiency and support business growth. Track record of leading cross-functional teams and implementing impactful initiatives.

Overview

20
20
years of professional experience
1
1
Certification

Work History

AVP,Data Strategy and Engineering

KKR (Kohlberg Kravis Roberts & Co)
New York
07.2021 - Current
  • Lead data engineering and development teams to optimize data architecture,pipeline development, automation, and delivery within a leading Reinsurance and global investment firm. Collaborate closely with business,product, and technical stakeholders to resolve data pipeline issues and enhance platform functionality.
  • Lead cross-functional teams in designing and implementing scalable data solutions by designing the Unified data platform using Iceberg Technologies, enhancing overall data integrity and accessibility.
  • Automated ETL/ELT workflows for monthly and quarterly reinsurance close and Retrocession settlement statements, ensuring complete and reconciled data for fund withheld,expenses(losses, and commissions) and revenue(premium) in the general ledger.
  • Led design and development of comprehensive consolidated data store (single version of truth) for asset management business, establishing clear relationships across securities, positions, holdings, and portfolio transaction data spanning all accounts.
  • Responsible for assembling complex data sets (In force/Transaction and settlement), maintaining robust data pipelines and reconciliation among all three systems for 160+ reinsurance deals and sub deals.
  • Support with risk experience analysis, actuarial reserve calculations, and general ledger posting using double-entry bookkeeping.
  • Executed strategic initiatives to optimize data pipeline performance (from Hortonworks to AWS Serverless), reducing processing time by 30% and increasing efficiency.
  • Designed and implemented end-to-end data pipelines ingesting policy admin, ceded premium, treaty, and claims data into a governed warehouse/lakehouse to support reinsurance analytics and reporting.
  • Designed and implemented the AI/ML model (Claude Sonnet 3.7) Framework to identify the Cedant/Counterparty file format issue
  • Designed Generative AI platform using RAG (Retrieval-Augmented Generation) technique for our Policy Holders.
  • Lead software development best practices such as CI/CD, code reviews, testing, and change management to deliver high-quality, efficient data solutions. Also manages incidents, change requests, and communication with stakeholders while driving ongoing improvements in speed and quality.
  • Implemented data quality checks on treaty, exposure, and claims feeds, identifying discrepancies early and reducing reinsurance reporting issues and late adjustments.
  • Expert in designing and implementing enterprise data architectures leveraging AWS (Redshift, Glue, Lambda), Spark, Python, SQL, and modern data technologies such as Iceberg.

AWS Data Architect ,Cloud & Data Solutions

Dow jones
New Jersey
03.2020 - 06.2021
  • Leads program and solution strategy for multi-cloud platforms, specializing in AWS stack with PySpark ETL on EMR clusters and cloud programs "Insite" (Presale) and "Itero" (PostSale). Architected entire system design and drives Agile project management (Scrum) across full project lifecycles, ensuring alignment from inception through post-release support.
  • Manages technical analysis, feasibility assessments, and scope definition while communicating status, risks, and mitigation strategies to executive leadership. Oversees software release milestones and guarantees delivery per requirements. Designs and implements AWS, Google Cloud, and MongoDB solutions that meet stringent SLAs, including proposing optimized MongoDB structures for middleware and UI.
  • Hands-on leader of AWS architecture utilizing EC2, S3, Data Lake, EMR with PySpark and Airflow scheduling. Employs AWS CloudFormation and CloudFront to support UI and middleware teams. Expertise also includes HDFS, emrfs, Google BigQuery, Node.js, and Git for robust cloud-native deployments.
  • Improved database performance by optimizing queries, indexing strategies, and overall architecture design.

Data Application Leader

Laureate Education Inc.
New Jersey
04.2015 - 03.2020
  • Leads solution strategy for multi-cloud platforms including Oracle Integration, AWS, Big Data, and Cognos to support the "Enrollment to Graduation" program across 25+ universities and 875K students. Directs a team of data engineers managing integrations involving 10+ legacy systems, including Microsoft Dynamics, Oracle Cloud, Ellucian, SharePoint, Azure, Salesforce, Snowflake, and Cognos BI.
  • Drove $1M+ operational cost savings by modernizing legacy systems, facilitating a seamless transition to a student services portal. Applies both Agile and Waterfall methodologies to deliver projects on time and within scope. Hands-on leader in designing cloud architecture utilizing AWS EC2, S3, RDS, CloudFront, CloudFormation, Data Lake, and Oracle Integration Cloud, focusing on security, user management, and data analytics.
  • Technical environment includes Oracle ESB Suites, Big Data Hadoop, Informatica, SOA, Postman, Webservices, and Git.
  • Led the architecture and implementation of data warehousing solutions, optimizing reporting capabilities for internal and external stakeholders.
  • Developed and executed data integration strategies for legacy systems, ensuring seamless connectivity with modern platforms.

Various Positions,Business Intelligence & Oracle

Infosys Technologies Limited
Dallas
03.2010 - 03.2015
  • Led technical strategy and solution design in Enterprise Information Management (EIM), collaborating with cross-functional teams to align BI initiatives with corporate goals. Provided end-to-end oversight of the Software Development Lifecycle, from requirements gathering through rollout, ensuring high-quality deliverables and timely milestone achievement.
  • Designed and managed IBM Cognos BI metadata architectures and Framework Manager models, driving efficient report development and standardization. Authored best practices and BI templates to streamline reporting and executive communications. Expert in Oracle SQL/PLSQL, Cognos Suite, Informatica integration, and data modeling practices.
  • Led technical strategy and solution design in Enterprise Information Management (EIM), collaborating with cross-functional teams to align BI initiatives with corporate goals.
  • Facilitated training sessions for end-users on BI tools and data reporting practices, enabling informed decision-making.

Oracle and Senior BI Developer

Tech Mahindra
India
04.2008 - 03.2010
  • Designed and executed BI strategies to empower users with actionable insights for informed decision-making. Developed and maintained six universes and a single integrated enterprise data warehouse, ensuring consistency and reliability across data sources. Expertise includes BOXIR2, BOX6, Oracle 9i, and Informatica for data integration and analytics.

Oracle BI Developer

Tech Mahindra
India
07.2007 - 03.2008

BO Administrator

Tech Mahindra
India
05.2006 - 07.2007

Education

Master of Science - Big Data Analytics

Walden University
Minneapolis, MN
06-2020

Bachelor of Electrical Engineering - Computer And Information Systems

Indira Gandhi Institute of Technology
India, India
01-2006

Skills

  • All Domain: Insurance/Finance/Education and Publishing
  • Insurance / Reinsurance Domains: policy, claims, ceded premium, treaty structures, loss reserves, profit commissions
  • Cloud: Amazon AWS Data Architecture/Oracle Cloud integration (Process and Integration Cloud services)
  • AI Tools:LovableDev,Cursor(Vibe Coding),Chat GPT, Prompt Engineering
  • AI Generalist(AI for everything) : Compare the models, Image generation,4x Faster typing,Video summary,Attend meeting on your behalf,Research the topic,Researching the data,,Preparing presentation, MCP and connectors
  • Primary Skills: Big Data,Pyspark, AWS S3,Glue,EMR,Redshift, Snowflake,Iceberg,Google Big Query,Oracle Integration Cloud Service, Oracle Business Process Management, Informatica, Cognos 8x, 102,1021, Business Objects,Tableau
  • Database: Redshift,MySQL,Oracle 12c/11g/10g,Snowflake, MongoDB, SQL Server
  • Languages: PLSQL,Python, SQL
  • Scheduling Tools: Control M, Airflow,Cron
  • Other Tools: VS Code, PLSQL Developer, DBeaver,Aqua Studio,MS Office,MS Visual Studio,Mermaid chart, RStudio,QuickSight, and Athena

Certification

  • The Oracle Certified Professional Certified, 2011
  • Business Object Level-1 Certified, 2008
  • Cognos Certified BI Author & Cognos Administrator, 2012
  • Certified AWS Solution Architect Associate,2020
  • Certified AWS Data Analytics Speciality,2020
  • Certified AWS Developer Associate,2021
  • Certified AWS SysOps Administrator,2021
  • Migration Training (BO Corporation), 2007
  • Certified SAFe- Practitioner Professional, 2017
  • Certified Retail Banking & Security Overview

Languages

Hindi
Full Professional
English
Full Professional

Timeline

AVP,Data Strategy and Engineering

KKR (Kohlberg Kravis Roberts & Co)
07.2021 - Current

AWS Data Architect ,Cloud & Data Solutions

Dow jones
03.2020 - 06.2021

Data Application Leader

Laureate Education Inc.
04.2015 - 03.2020

Various Positions,Business Intelligence & Oracle

Infosys Technologies Limited
03.2010 - 03.2015

Oracle and Senior BI Developer

Tech Mahindra
04.2008 - 03.2010

Oracle BI Developer

Tech Mahindra
07.2007 - 03.2008

BO Administrator

Tech Mahindra
05.2006 - 07.2007

Bachelor of Electrical Engineering - Computer And Information Systems

Indira Gandhi Institute of Technology

Master of Science - Big Data Analytics

Walden University