Ankur Kelkar Email & Phone Number

Pune, Maharashtra, India

• Worked with the team in implementing a Data Mesh Architecture
• Focused on our Snowflake database and optimized the dbt pipelines that were responsible for aggregating and enriching our largest datasets. By fine-tuning these pipelines, was able to save approximately 3,000 € per.
• Wrote and implemented a Request for Change (RFC) that proposed a new architecture for ingesting financial data. Instead of using a monolithic pipeline, we transitioned to a distributed one. This change not only.
• Made optimizations to Looker by incorporating features such as Aggregate Awareness, PDTs, and Parameterized table sources, and was able to improve the performance and accuracy of our reports.
• Implemented the use of hash for efficiently retrieving modified data. This allowed us to quickly identify and fetch the relevant data, reducing processing time and improving overall efficiency.
• Extensively restructured dbt to implement the Data Mesh vision. This involved redefining schemas, tables, and relationships to ensure a more coherent and intuitive data model.

Pune Area, India

• Solving problems for Fortune 500 companies by analyzing problems and solving them by leveraging technographic and firmographic data.
• Working on complex projects with AWS S3, AWS Athena, Presto and a bit of Python
• Dashboarding and visualizing data with Power BI
• Running the SCRUM and maintaining sprints on JIRA

Pune

• Working on SQL Procedures Optimization for the product
• Data migration from Azure SQL Datawarehouse to Snowflake

Vadodara, Gujarat, India

• Coordinated with onsite managers planning future projects and timelines for clients
• Managing several Business Intelligence and HL7 Integration projects for multiple clients
• Coaching team-members on US Ambulatory Healthcare workflow, Allscripts EEHR, Allscripts PM
• Managing project timelines and maintaining KPI’s
• Worked on multiple HL7 Interface engines (ConnectR, Rhapsody, eLink)

Vadodara, Gujarat, India

• Collaborated with business unit teams and end users in planning and implementation of Data Migration of patient 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 CCD’s and visit centric CCD’s
• Worked with a development team in creation and export of CCD (Continuity of Care) documents
• Was a lead on multiple data extraction projects for multiple clients.

Vadodara, Gujarat, India

• Worked 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, columns etc.
• Collaborated with Network Operations Team and created a custom SSRS report suite to pull data from SCCM & SolarWinds
• Developed packages for several data extraction projects

Vadodara Area, India

• Was a lead developer on two Phonegap based mobile applications using variety of frameworks and toolkits
• Worked with jQuery, Dojo, Foundation and databases like MYSQL and SQLite

• Develop Android Applications,
• Web Development

• As a Core Team member of a national level tech fest, have gained experience in some management skills while being under a deadline. Visit prakarsh.org

Vadodara Area, India

• Have worked as freelancer providing virtual assistance, back office work and management consultancy to clients in USA,UK and Australia.

Master Of Computer Applications (Mca), Computer Programming, Computer Software Engineering, Programming Languages, Web Development, 8.1 Cpi, 7.99 Cgpa

Activities and Societies: Member Computer Society of India, Started Open Source Society, Started Innovation Cell, Core Organizing.

Bachelor Of Computer Applications (B.C.A), Computer Programming, Computer Software Engineering, Programming Languages, Web Development

Activities and Societies: Organized Multiple Events

Schooling, Hsc, Ssc, Maths, Physics, Chemistry