SHEETAL PATIL
Parsippany,NJ
Summary
Results-driven SQL Server Developer with 9 years of experience in database development, ETL processes, and Business Intelligence solutions across industries such as health insurance, education, supply chain management, real estate, and retail. Expertise in Microsoft SQL Server, SSIS, SSRS, Power BI, and Tableau. Adept at optimizing SQL performance, designing ETL workflows, and developing scalable database solutions to support business analytics. Strong background in performance tuning, query optimization, data modeling, and implementing best practices for database security and integrity. Proven ability to automate ETL workflows, reduce execution times, and improve reporting efficiency using advanced BI tools. Extensive experience in Software Development Life Cycle (SDLC), production deployment, post-production support, troubleshooting database issues, and ensuring seamless transitions between development and live environments.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior SQL Developer
Humana
07.2023 - Current
- Optimized SQL Server database architecture, enhancing performance and scalability
- Designed database schemas, ER diagrams, and data flow models using Lucidchart
- Developed and automated complex ETL processes using SSIS, optimizing data extraction, transformation, and loading from multiple sources to a centralized data warehouse, ensuring data consistency and reducing manual interventions
- Worked closely with business stakeholders to understand reporting needs, transforming complex data into user-friendly, dynamic visualizations using Power BI.
- Developed optimized SQL queries and views to support Power BI dashboard development, ensuring efficient data retrieval and enhanced performance for large datasets.
- Used SQL Server Profiler, Execution Plans, and Dynamic Management Views (DMVs) for query optimization, reducing query execution time by 50%+
- Automated ETL workflows using Control-M, ensuring data consistency and security
- Created and authored a comprehensive best-practices document for standardized database development, which was successfully adopted and followed across board by various IT teams
- Collaborated in Agile environments using Azure DevOps for sprint planning and work tracking, while also providing production support to troubleshoot and resolve post-deployment issues
- Managed communication between onshore and offshore teams, facilitating smooth knowledge transfer, setting clear expectations, and ensuring alignment on project scope and deliverables.
Senior SQL Developer
Harvard University, Center for Education Policy Research
10.2022 - 07.2023
- Migrated and automated data loads from CSV files into a data warehouse using SSIS and JAMS Scheduler
- Redesigned database structures to enhance warehouse performance
- Implemented advanced join strategies to cross-check and validate data across tables, identifying discrepancies and ensuring correct data aggregation for reporting and analysis.
- Created ad hoc reports by writing dynamic SQL queries to address immediate business needs and deliver actionable insights across departments.
- Conducted performance tuning to optimize SSIS package execution times
- Resolved ETL failures and managed data integrity issues efficiently
- Provided guidance and mentorship to offshore developers, ensuring adherence to coding standards, best practices, and consistent documentation for cross-functional collaboration.
Senior SQL Developer
UPS Supply Chain Solutions
09.2021 - 10.2022
- Led the design, integration, and support of data management and reporting systems
- Provided SQL backend support for front-end applications, ensuring seamless data retrieval, storage, and integration with UI components.
- Collaborated with front-end developers to troubleshoot and resolve data-related issues, ensuring efficient communication between the database and UI.
- Optimized complex T-SQL queries and stored procedures for improved execution times, reducing execution times by 50%-300%
- Designed and implemented partitioning, indexing, and compression strategies
- Deployed and configured SSIS packages in Development (DEV) and User Acceptance Testing (UAT) environments, ensuring seamless integration and data accuracy before production release.
- Utilized Azure Data Factory to automate ETL workflows
- Collaborated with business users to refine reporting solutions using Power BI and Tableau
- Identified and resolved database-related production issues impacting UI performance, ensuring seamless user experience and minimal downtime.
SQL Developer / SSIS SSRS Developer
Realogy Franchise Group
11.2018 - 04.2021
- Designed and developed ETL packages using SSIS to transform and load data into the warehouse
- Created parameterized reports and dashboards using SSRS and Tableau
- Optimized SQL queries using indexing and query execution analysis tools
- Automated job scheduling and monitoring
- Provided technical expertise during the planning phase, helping to identify potential risks, mitigating strategies, and ensuring the feasibility of the proposed solutions.
SQL Server / SSIS / SSRS Developer
Blackboard Insurance
01.2018 - 10.2018
- Developed data warehouse solutions, migrating data from diverse sources using SSIS
- Designed SSRS reports and Tableau visualizations for business analysis
- Improved report performance by tuning queries and stored procedures
SQL Server / SSIS / SSRS Developer
Aetna, a CVS Health Company
09.2015 - 12.2017
- Built ETL pipelines to load data into a health analytics data warehouse
- Created and optimized complex SQL queries, stored procedures, and triggers
- Designed operational and analytical reports using SSRS and Tableau
- Worked in an Agile SDLC, participating in sprint planning and retrospectives
Education
Post Graduate Diploma - Business Administration & Management
The ICFAI University
Tripura, India01.2009
Bachelor's Degree - Banking & Insurance
University of Mumbai
Mumbai, India01.2007
Skills
- Databases: MS SQL Server (2018/2017/2016/2014/2012/2008), Azure SQL Database (Beginner)
- ETL & BI Tools: SSIS, SSRS, Power BI, Tableau
- Cloud & Big Data: Microsoft Azure, Azure Data Factory, Databricks (Beginner)
- Languages & Scripting: T-SQL, PL/SQL, VBScript, XML, HTML
- Tools & Version Control: Visual Studio, JIRA, GitHub, Redgate SQL Toolbelt, Team Foundation Server (TFS)
- Performance Tuning: SQL Profiler, Execution Plans, Index Tuning Wizard, Database Engine Tuning Advisor
- Others: Control-M, SharePoint, Lucidchart, Stata
Accomplishments
- Successfully reduced query execution time by 50%-300% through performance tuning.
- Automated ETL workflows using SSIS and Control-M, reducing manual intervention.
- Designed scalable database solutions, enhancing data integrity and reporting efficiency.
- Developed enterprise-level Power BI dashboards, improving business decision-making.
- Standardized database development with best-practices documentation adopted team-wide.
Certifications Professional Development
- Mastering SQL Server 2016 Integration Services, Udemy
- SQL Server Performance Tuning and Optimization, Udemy
- Microsoft Power BI Desktop for Business Intelligence, Udemy
- Tableau Data Analyst/Specialist Desktop Certification Prep, Udemy
- Python Certification, In Progress
- Databricks Certification, In Progress
Certification
- Mastering SQL Server 2016 Integration Services - Udemy
- SQL Server Performance Tuning and Optimization - Udemy
- Microsoft Power BI Desktop for Business Intelligence - Udemy
- Tableau Data Analyst/Specialist Desktop Certification Prep - Udemy
- In Progress: Python Certification, Databricks Certification
Timeline
Senior SQL Developer
Humana
07.2023 - Current
Senior SQL Developer
Harvard University, Center for Education Policy Research
10.2022 - 07.2023
Senior SQL Developer
UPS Supply Chain Solutions
09.2021 - 10.2022
SQL Developer / SSIS SSRS Developer
Realogy Franchise Group
11.2018 - 04.2021
SQL Server / SSIS / SSRS Developer
Blackboard Insurance
01.2018 - 10.2018
SQL Server / SSIS / SSRS Developer
Aetna, a CVS Health Company
09.2015 - 12.2017
Post Graduate Diploma - Business Administration & Management
The ICFAI University
Bachelor's Degree - Banking & Insurance
University of Mumbai
Similar Profiles
Monifah CocroftMonifah Cocroft
Healthcare Customer Service Representative at HumanaHealthcare Customer Service Representative at Humana
Adeshola K Adewunmi, M.DAdeshola K Adewunmi, M.D
Regional Medical Director at HumanaRegional Medical Director at Humana
Neva LouisNeva Louis
DMS Sales Agent at HumanaDMS Sales Agent at Humana
Cher Ann ChaputCher Ann Chaput
Care Management Support Supervisor at HumanaCare Management Support Supervisor at Humana
Antonio CasasAntonio Casas
Authorization Specialist Assistant Manager at Eye Centers of AmericaAuthorization Specialist Assistant Manager at Eye Centers of America