Preetish Kharche
Pune
Summary
Technical Lead with over 11+ years of experience in data solutions at Datafortune Software Solutions. Successfully led migration of 60 million records, resulting in a 75% reduction in job runtimes. Expertise in Snowflake, data analytics, business intelligence, data warehousing, and Data Migration project using technologies like Snowflake, SQL, Informatica Cloud, PostgreSQL etc and data visualization using Power BI. Strong collaborative skills focused on delivering effective data solutions.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Technical Lead
Datafortune Software Solutions Private Limited
04.2020 - Current
- Led a team of six junior software engineers in migrating 60 million car insurance records to Snowflake data warehouse.
- Executed data load processes in Snowflake, including Bulk Loading and Snowpipe.
- Transformed data during load and managed Snowflake unload processes to S3 and Azure.
- Implemented SCD Type 2 approach for table loads, using hash key validation methods.
- Employed High Water Mark and Low Water Mark methods for efficient delta record calculation.
- Optimized IICS tasks into DBT models, reducing job runtime from four hours to one hour.
- Configured Airflow for monitoring operational processes, enhancing system efficiency.
- Developed Power BI dashboards for clear visualization of business requirements.
Sr. BI Developer
Datafortune Software Solutions Private Limited
04.2017 - 03.2020
- Designed data pipelines for telecommunications project, optimizing data processing and streamlining operations.
- Developed and optimized data loading workflows with MongoDB and Python to enhance data management.
- Created RDBMS DataMart using star schema, implementing Fact and Dimension tables for efficient data handling.
- Developed SSIS ETL packages for integrating multiple data sources, enabling client editing of customer files via web portal.
- Generated automated email reports through SSRS, showcasing customer data with time-driven subscriptions.
- Evaluated alternative solutions to inform design decisions with justifications based on research findings.
- Conducted research to improve processes, delivering scalable and efficient data flow solutions.
BI Developer
Datafortune Software Solutions Private Limited
01.2014 - 03.2017
- Executed data processing and analytics solutions for automobile insurance project, boosting operational efficiency.
- Engaged in full Software Development Life Cycle (SDLC), encompassing requirement gathering to system testing.
- Managed accounting reports for multiple OEMs, ensuring data accuracy while resolving ETL failures.
- Developed SSIS ETL packages to integrate SQL Server, PostgreCMS, flat files, and Excel data sources.
- Automated package execution using Control and Data Flow tasks via SQL Server Agent Jobs.
- Created tailored SSRS reports with sub reports, drill-down capabilities, and parameter-based filters.
- Employed T-SQL queries, User-Defined Functions, and Stored Procedures for customized reporting solutions.
Education
B.Tech -
Rajiv Gandhi College of Engineering, Research And
ChandrapurSkills
- Snowflake and Informatica IICS
- Airflow orchestration
- DBT for data transformation
- Power BI visualization
- MS SQL Server management
- MSBI solutions
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Looker analytics
- Data warehousing architecture
- Database design principles
- Data modeling techniques
Certification
- Microsoft 70-461 (Querying Microsoft SQL Server)
- Microsoft 70-767 (Implementing a Data Warehouse using SQL)
- Snowflake SnowPro Core
Languages
Marathi English Hindi
Timeline
Technical Lead
Datafortune Software Solutions Private Limited
04.2020 - Current
Sr. BI Developer
Datafortune Software Solutions Private Limited
04.2017 - 03.2020
BI Developer
Datafortune Software Solutions Private Limited
01.2014 - 03.2017
B.Tech -
Rajiv Gandhi College of Engineering, Research And
Similar Profiles
Rajasekhar Reddy VegapaRajasekhar Reddy Vegapa
Software Engineer at Datafortune Software Solutions PVT LTDSoftware Engineer at Datafortune Software Solutions PVT LTD
Harsh Pralhad HungundHarsh Pralhad Hungund
Staff IOS Engineer at RapidAI Software Solutions India Private LimitedStaff IOS Engineer at RapidAI Software Solutions India Private Limited
Kenneth Thomas MendesKenneth Thomas Mendes
Subject Matter Expert at FOOD HUB SOFTWARE SOLUTIONS INDIA PRIVATE LIMITEDSubject Matter Expert at FOOD HUB SOFTWARE SOLUTIONS INDIA PRIVATE LIMITED