Kartik Moharle
Pune
Summary
Experienced Data Engineer with a proven track record of over 3.8+ years in utilizing Snowflake, Microsoft SQL Server, Python and Azure Data Factory. Skilled in data modeling, ETL development, and performance tuning for seamless data flow and integrity. Committed to delivering high-quality solutions aligned with business objectives to drive organizational success.
Overview
4
4
years of professional experience
Work History
Senior Software Developer
Xcaliber Infotech Pvt. Ltd.
04.2024 - Current
- On-Premise SQL Server data migration to Azure SQL Database and Snowflake using Azure Data Factory, achieving a 40% increase in performance.
- Created and optimized fact and dimension tables in the data warehouse, enabling efficient data retrieval and analysis, leading to a 25% increase in reporting speed
- SQL Development for Data Availability: Developed Stored Procedures and SQL Views to support the analytics team, ensuring smooth data flow from backend to frontend.
- Automation and Scheduling: Automated ETL processes and scheduled jobs using SQL Server Agent, streamlining data workflows and ensuring timely execution of data-related tasks.
- Data Analysis and Troubleshooting: Conducting data analysis and troubleshooting to identify and address data quality issues, ensuring the accuracy and completeness of reports and dashboards.
- Stakeholder Collaboration: Engaging with stakeholders to understand their reporting and analytics needs and recommending data-driven solutions to meet those requirements effectively.
Software Developer
Xcaliber Infotech Pvt. Ltd.
04.2021 - 04.2024
- Spearheading hands-on development of stored procedures, functions, triggers, T-SQL, and views, driving a 50% reduction in query execution time.
- Attaining a 25% reduction in query response time by optimizing SQL queries.
- Executing advanced Data Warehousing concepts, including Dimension Data Modeling, Fact Tables, Dimension Tables, Star Schema, and Slowly Changing Dimensions, while enhancing ETL processes to achieve a 40% improvement in data retrieval time, thereby empowering informed decision-making.
- Administering query optimization and indexing, yielding a 15% enhancement in overall database performance.
- Architecting and optimizing fact and dimension tables in the data warehouse, facilitating efficient data retrieval and analysis that results in a 25% acceleration in reporting speed.
- Formulating complex SQL logic to calculate diverse KPIs aligned with business requirements.
- Assimilated expertise in Automation VBA Scripts on client servers, enhancing understanding and troubleshooting capabilities for streamlined operations.
- Managed the migration of legacy processes to the Snowflake cloud-based data computing platform, optimizing operations and enabling greater scalability and agility.
Education
Post Graduate Diploma - Big Data Analytics
Institute for Advanced Computing and Software Development
Pune, Maharashtra02.2021
Bachelor of Engineering - Electronics Engineering
AISSMS COE
Pune, Maharashtra05.2019
Skills
- Snowflake
- SQL
- ETL
- SSIS
- Python
- SQL integration
- Data Analysis Skills
- Microsoft excel
- Git proficiency
- Jira
Languages
English
Hindi
Marathi
Timeline
Senior Software Developer
Xcaliber Infotech Pvt. Ltd.
04.2024 - Current
Software Developer
Xcaliber Infotech Pvt. Ltd.
04.2021 - 04.2024
Bachelor of Engineering - Electronics Engineering
AISSMS COE
Post Graduate Diploma - Big Data Analytics
Institute for Advanced Computing and Software Development
Similar Profiles
Abhinav AndhareAbhinav Andhare
Jr. Application Support Engineer at Xcaliber Infotech Pvt. Ltd.Jr. Application Support Engineer at Xcaliber Infotech Pvt. Ltd.
Mayur PatilMayur Patil
Software Developer at Xcaliber Infotech Pvt. Ltd. - A Phoenix Group CompanySoftware Developer at Xcaliber Infotech Pvt. Ltd. - A Phoenix Group Company
SAFAR MANDALSAFAR MANDAL
Data Analyst | Tableau Developer at Xcaliber Infotech PvtData Analyst | Tableau Developer at Xcaliber Infotech Pvt