Executive Profile
Ankur Kelkar
Analytics Engineer · Pune, India
Professional Summary
Experienced Data Architect/Engineer with 10+ years in Travel Tech, Marketing Technology & Healthcare IT. Skilled in BI strategies, architectural transformation, and cost optimization. Expertise in Snowflake, dbt, Terraform, AWS services, Python, and BI tools.
Core Highlights
- 11+ years of experience in SQL.
- 7 years of experience in the US Healthcare domain and 2 years in Marketing Technology, with 1+ years in Travel Tech.
- Excel in harnessing Business Intelligence Tools, SQL Services, Data Warehouses, and Python.
- Proficient in cloud environments like AWS & GCP and multiple visualization software like Looker, Power BI, SSRS, Tableau.
- Certified SCRUM Master (PSM Level 1).
- Proficient in efficiently managing vast amounts of information, expertly employing data analysis tools and techniques to extract actionable insights and drive resultant business action.
- Adept at training, coaching, and providing leadership to team members, ensuring proficiency in products and workflows.
- Thrive in high-speed environments & excel under tight deadlines.
- Purposeful, Pragmatic and Relentlessly Driven.
Skills & Tech Stack
💻 Software and Services
SQL, T-SQL, Pythondbt, SSIS, AWS GlueSnowflake, AWS AthenaSQL Server, PostgreSQL, MySQLS3, Azure Blob StorageLooker, Power BI, SSRS, Crystal Reports, TableuAWS, Azure, GCPGit, SVNJIRA, Confluence, Shortcut, Miro, Team RetroCompetent in Terraform
📈 Data Skills
Data Architecture & OptimizationDimensional ModellingData Ingestion & CDCData EngineeringData ModellingData AnalysisData MigrationData Visualization
🛠️ Technical Skills
ETLAnalytics EngineeringBusiness IntelligenceArchitectural TransformationArchitecture & Query OptimizationData Mesh implementationDecentralization
🏢 Business Domains
HealthcareTravel TechMarketing Tech
🌟 Interests
Modern Data StackAnime: Shonen, Seinen, Action, Psychological, Slice of Life, Sci-FiGaming: RPGs, Narrative Driven, Simulation, Action-AdventureMusic: Old School Rock, Hard Rock, Alternative, Metal
🤝 Soft Skills
SCRUM MasterTeam Management & Project ManagementCommunicationAdaptability and Creative ThinkingCritical Thinking and PragmatismConflict Resolution & Emotional IntelligenceLeader and MentorTech Coach
Education
MCA (Master)
Sardar Vallabhbhai Patel Institute of Technology
2010 – 2013 CPI 8.01
BCA (Bachelor)
The Maharaja Sayajirao University of Baroda
2007 – 2010 58%
Certifications
Professional SCRUM Master (PSM I) Scrum.org
Employment History
Senior Lead Engineer
Kipi.bi · Remote
- Designed and implemented ETL/ELT pipelines using Python, SQL, and CI/CD
- Developed reusable data extraction pipelines with S3, Lambda, SQS, SNS, EventBridge
- Built Snowflake stored-procedure tasks for automated transformations
- Optimized data models for BI and ML workloads
- Working with Snowflake as the main Data Warehousing tool hosted on AWS.
- Worked on designing and implementing multiple ETL and ELT data pipelines using programming languages like Python and SQL and automated the code deployment through CI/CD pipelines.
- Created and optimized data models for the project keeping all BI and ML use cases in mind.
- Created multiple reusable data extraction pipelines using AWS services like S3, Lambda, SQS, SNS, Eventbridge & CodeCommit.
- Created multiple reusable data load and transformation pipelines using Snowflake Stored procedures & Tasks.
Analytics Engineer
Vio.com · Remote
- Modelled terabyte scale data across 15+ projects in dbt along with a team of three people.
- Collaborated with the team to implement a Data Mesh Architecture, involving the restructuring of multiple dbt projects, establishment of new processes and standards across various domains, and educating the organization on best practices.
- Pioneered an RFC (Request for Change) that improved financial data ingestion with a distributed architecture, eliminating single points of failure while delivering significant cost savings and heightened observability and robustness.
- Achieved substantial cost savings of approximately 3,000 € per month by optimizing dbt pipelines through meticulous utilization of Snowflake query plans and industry best practices.
- Slashed incremental data processing time by 30% through the strategic incorporation of hash-based retrieval for efficiently identifying modified data.
- Elevated Looker reports' performance and precision by implementing advanced features like Aggregate Awareness, PDTs, and Parameterized table sources.
- Automated invoice ingestion, improving financial data accuracy and timeliness by 40%.
- Improved Kustomer and Stripe data ingestion for valuable insights and data-driven decisions.
Sr. Data Analyst
Demandbase Data Cloud · Pune
- Lead a team of 3 Analysts to solve problems for Fortune 500 companies by leveraging technographic and firmographic data.
- Working on complex projects with AWS S3, AWS Athena, Presto and Python and dashboarding and visualizing data with Power BI
- Running the SCRUM and maintaining sprints on JIRA
Sr. SQL Developer
Radamatic Solutions Pvt. Ltd. · Pune
- Worked on SQL Procedures Optimization for the product
- Data migration from Azure SQL Datawarehouse to Snowflake
Associate Systems Analyst -> Sr. System Analyst
Allscripts Healthcare Solutions Inc. · Vadodara
- Lead a team of 8 analysts while managing several new and ongoing Business Intelligence and HL7 Integration projects for 5+ EHR clients while managing project timelines, resources and maintaining KPI’s.
- Seamlessly collaborated with onsite managers to plan future projects and resources for multiple ambulatory care clients.
- Mentored and coached team members in mastering the US Ambulatory Healthcare workflow, Allscripts EEHR, Allscripts PM
- Worked on multiple HL7 Interface engines like ConnectR, Rhapsody and eLink
- Collaborated with business unit teams and end users in planning and implementation of Data Migration of clinical data from Allscripts EEHR to EPIC
- Creation of a Data Warehouse, packages and HL7 interfaces to facilitate a continuous data transfer of patient data in multiple stages.
- Collaborated with EPIC and Oracle to plan and create a Data Warehouse for creation of patient centric and visit centric CCD’s.
- Lead a team of 3 Associate Analysts in creation and export of CCD (Continuity of Care) documents.
- Collaborated with a team on creating a Data Warehouse and stored procedures for migrating clinical patient data from Allscripts EEHR to EPIC
- Enhanced the performance of older SSRS reports by eliminating unnecessary joins and columns.
- Teamed up with Network Operations Team and created a custom SSRS report suite to pull data from SCCM & SolarWinds
- Developed packages for multiple data extraction projects.
Lead Developer
Kiren Solutions · Vadodara
- Lead developer on two Phonegap based mobile applications using variety of frameworks and toolkits and worked with jQuery, Dojo, Foundation, and databases like MYSQL and SQLite