Sahil Patil

Experience

• 

  Capgemini

  Nov 2012 - Mar 2015

  Consultant

  - Collaborated with Technical lead/Manager to gather and understand data requirements and helped in documentation, data modelling and maintaining ETL workflows for data integration.- Developed and maintained ETL processes to extract, transform, and load data from various sources into the data warehouse using SSIS.- Implemented data cleansing, validation, and transformation processes to ensure data accuracy and reliability using various SSIS transformation.- Implemented various business rules by writing SQL stored procedure, functions.- Designed and developed Reports with SAP BO by creating universe.- Generated tabular and ad-hoc based reports in SSRS to support business decision-making processes. Show less

• 

  Deloitte

  Apr 2015 - Aug 2016

  Data Analyst

  -Loaded client data from various user interfaces, web applications files like CSV, Excel, JSON, PDF and XML into SQL and Oracle database using SSIS.- Developed data validation and quality assurance processes to ensure security, accuracy and reliability.- Collaborated with payroll and HR teams to understand business needs and deliver impactful Tableau solutions.- Created complex calculations, parameters, and filters within Tableau to enable dynamic and interactive data exploration.- Designed and optimized Tableau data extracts and data connections to ensure efficient data retrieval and visualization.- Developed interactive dashboards, reports, and visualizations using Tableau Desktop to provide actionable insights into business performance, trends, and key metrics. Show less

• 

  CitiusTech

  Aug 2016 - now

  -Design and create data models-Design, build, and maintain scalable data pipelines using Azure Data Factory (ADF) and other Azure services-Develop custom Data bricks notebooks with Spark to automate data cleansing and transformation tasks, reducing manual effort by 40%.-Create complex SQL Stored procedures, views and functions to conduct in-depth analysis of large datasets using statistical techniques to uncover trends, patterns, and correlations.-Utilize Python libraries such as Pandas, NumPy, and Matplotlib to perform advanced data manipulation, visualization-Build interactive and visually appealing report/Dashboards using Power BI, Tableau, SSRS & Microstrategy to support business decision-making and business performance monitoring. Show less - Designed and maintained the data pipeline for Member and Provider Data.- Improved the performance of existing ETL workflows using indexing and Partitioning the big tables.- Created complex SQL queries, stored procedures, and views to support reporting and analytics requirements.-Developed custom visualization in Microstrategy/Tableau/SSRS to provide a complete data solution and to support business decision making processes.-Created Attributes/Metrics/Hierarchies/Filters etc. to support semantic layer and ad-hoc reports in Microstrategy.-Successfully migrated existing SSRS reports to Microstrategy. Show less

  • Technical Specialist

    Feb 2020 - now

  • Technical Lead

    Aug 2016 - Jan 2020