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
SQL
Data-warehousing
Python
Snowflake
Bitbucket, GIT
JIRA
Db2
Azure Cloud
Autosys- Scheduling Tool
GAMMA Tool
SourceTree
Shell Script
Informatica
Procedures
Bamboo
TCM
Azure Pipelines
HVR
DBT basics
MS Office
Client Relationships
Problem-Solving
Integrity and Honesty
Analytical Thinking
Databricks
Airflow
PowerBI
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