Kartik Patil

Processing the raw healthcare data and analyzing and monitoring KPI's by generating reports and dashboards.
Technologies used: PostgreSQL, Spark, Tableau

Analyze collected data to recognize patterns in data to draw logical conclusions and make recommendations for action.
Technologies used: R, Rstudio

This is an Amazon Web Services based web application that provides data to a wide range of people regarding particle pollution concentrations enabling them to determine the pollution percentages at various locations.

This project performs sentiment analysis on a twitter stream, indicating whether the given tweet is positive or negative.

Technologies used: AlchemyAPI, Python and R.

Developed an web application - loan calculator that accepts inputs from user and displays the final amount calculated based on certain parameters.

Technologies Used: HTML, CSS, Bootstrap, JavaScript, C# and MS Excel Macros

This is an IBM Bluemix based web application that allowed users to raise issues about various infrastructures in their community and crowd source ideas for fixing or upcycling old infrastructure.

Technologies Used : Node.js, Express, MongoDb, AngularJS, MySQL and Bootstrap

• Collaborated with clients and onshore business analysis team to gather requirements and understand business processes to define and implement analytical data mart.
• Devised strategies to implement change data capture to handle slowly changing dimensions in the data warehouse.
• Optimized voluminous data loads through performance testing and database tuning techniques.
• Analyzed the BI infrastructure to migrate, schedule and deploy ETL workflows.
• Delivered the project in… Show more

• Collaborated with clients and onshore business analysis team to gather requirements and understand business processes to define and implement analytical data mart.
• Devised strategies to implement change data capture to handle slowly changing dimensions in the data warehouse.
• Optimized voluminous data loads through performance testing and database tuning techniques.
• Analyzed the BI infrastructure to migrate, schedule and deploy ETL workflows.
• Delivered the project in sprints and adopted agile methodology to promote sustainable development of the project. Show less

• Independently developed PL/SQL procedures to perform predictive analysis, extract descriptive statistics from data marts and present the key areas of improvement to the business.
• Optimized PL/SQL procedure by implementing data partitioning and indexing, thus reducing the run time by 50%.
• Performed unit testing and UAT to validate the code against business requirements and ensure that project defined quality assurance metrics are met.

• Worked on Business Objects to incorporate new requirements into the universe and generate reports.
• Analyzed the technical requirements and data sources to create Data Mapping Documents for ETL loads.
• Profiled business data to analyze the content, quality and structure of source data.
• Developed a UNIX automation scripts to schedule and monitor ETL workflows.
• Performed Data Integration and Data Consolidation to merge data from disparate source systems.
• Analyzed and… Show more

• Worked on Business Objects to incorporate new requirements into the universe and generate reports.
• Analyzed the technical requirements and data sources to create Data Mapping Documents for ETL loads.
• Profiled business data to analyze the content, quality and structure of source data.
• Developed a UNIX automation scripts to schedule and monitor ETL workflows.
• Performed Data Integration and Data Consolidation to merge data from disparate source systems.
• Analyzed and queried metadata repository to perform ETL unit testing, isolate code defects and resolve them.
• Devised error handling and error logging strategies to handle bad data and reprocess them.
Show less