Summary
Overview
Work History
Education
Skills
Certification
Hobbies
Timeline
Generic
Kartik Jaitly

Kartik Jaitly

Data Analyst
Bangalore

Summary

Experienced Data Analyst with 8 years in transforming data into actionable insights and efficiently storing it. Proficient in building data pipelines, optimizing data models, and leading migrations from on-premise systems to cloud environments. Experienced in Power BI for data visualization and reporting, and skilled in Python scripting for automations and SnowSQL wrappers. Known for adaptability, effective team leadership, and meeting tight deadlines. Proven track record of enhancing business performance across various industries, with a focus on driving innovation and delivering results for Nordic companies.

Overview

9
9
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Technical Delivery Manager

Morgan Stanley
Bengaluru
11.2021 - Current
  • Data Pipeline Development: Built efficient pipelines to integrate diverse data sources into data warehouse, speeding up data availability and enhancing decision-making.
  • Optimized Data Modeling: Designed data models for improved storage and faster data retrieval, driving better business intelligence from complex datasets.
  • Access Entitlement Framework: Created a secure, role-based access framework for multiple investment divisions, streamlining user management and ensuring regulatory compliance.
  • Cloud Migration to Snowflake: Led migration from DB2 to Snowflake, boosting query performance by 30%, reducing costs, and enabling scalable cloud infrastructure.
  • Code Hygiene & Scalability: Ensured clean, maintainable code with best practices, accelerating development and supporting future scalability with minimal downtime.
  • Production Support: Proactively resolved real-time production issues, minimizing disruptions and maintaining business continuity.
  • Python Scripting for Cloud: Developed Python scripts to automate and manage data movement in cloud systems, enhancing data flow and operational efficiency.

Consultant

Deloitte USI
Gurugram
11.2020 - 11.2021
  • Client Collaboration and Requirement Gathering: Collaborated with clients to gather requirements and implement solutions aligned with business expectations, ensuring successful project outcomes.
  • Credit Card Cashback System Development : Led the development of a bank's credit card cashback system, optimizing user eligibility and increasing business revenue by 7% within a few months.
  • OLAP Systems Development and Maintenance : Developed and maintained OLAP systems to efficiently load data for reporting and analytics, enhancing decision-making capabilities.
  • Data Preparation and Consistency: Primed and prepared data to ensure accuracy and consistency for analysis and reporting purposes.
  • Team Leadership: Directed and managed a cross-functional team of 4-5 members, ensuring seamless project execution and delivery.
  • Onshore-Offshore Coordination: Worked in an onshore-offshore model, coordinating efforts across different time zones to ensure continuous progress and timely delivery of business solutions.

Senior Systems Engineer

Infosys Limited
Chandigarh
11.2015 - 11.2020
  • Banking and Healthcare Domains: Gained experience delivering tailored data-driven solutions, enhancing decision-making and operational efficiency in both sectors.
  • Data Pipeline Development: Built and optimized data pipelines using Informatica, improving data flow efficiency by 30% and integration speed by 25% across systems.
  • Test Data Management: Managed Test Data with a focus on accuracy and reliability, resulting in a 25% reduction in testing errors and ensuring smoother development cycles.
  • UAT Environment Creation: Created and configured a User Acceptance Testing (UAT) environment for a healthcare firm, facilitating successful validation of a new product and accelerating the launch by 6 weeks.
  • Power BI Reporting: Developed Power BI reports for a banking client, utilising data feeds from Thomson Reuters, which provided actionable insights that supported strategic decision-making and improved report generation time by 20%.
  • Application Prototyping: Built prototypes of ticket booking and management systems using Python, demonstrating strong problem-solving skills and contributing to a 35% improvement in application development efficiency.

Education

Bachelor of Technology - Computer Science

Kurukshetra University, NC College of Engineering
Panipat
05.2011 - 05.2015

Skills

ETL , ELT

Certification

Azure Data Fundamentals

Hobbies

  • Music: Passionate musician skilled in singing and multiple instruments.
  • Sports: Active in various sports including basketball, cricket, volleyball, and table tennis.
  • Animal Welfare: Dedicated animal lover and actively involved with an NGO.
  • Philanthropy: Engaged philanthropist involved in growing trees and supporting environmental causes.

Timeline

Technical Delivery Manager

Morgan Stanley
11.2021 - Current

Consultant

Deloitte USI
11.2020 - 11.2021

Senior Systems Engineer

Infosys Limited
11.2015 - 11.2020

Bachelor of Technology - Computer Science

Kurukshetra University, NC College of Engineering
05.2011 - 05.2015
Kartik JaitlyData Analyst