UNNATI S PATEL
Robbinsville Township,NJ
Summary
Data engineering professional with over 12 years of experience in designing and implementing scalable ETL solutions across diverse industries. Proven track record in optimizing database performance by over 25%, enhancing data quality, and supporting cloud modernization initiatives using Azure technologies.
Overview
1
1
Certification
16
16
years of professional experience
Work History
Sr. Data Engineer/SSIS Developer/Tableau report
Wells Fargo
Summit, NJ
05.2020 - Current
- Led cloud data modernization initiatives by developing scalable ELT and data integration frameworks using Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), and Databricks, supporting enterprise analytics, reporting, and data governance requirements.
- Designed, developed, and deployed enterprise-scale ETL solutions using SQL Server Integration Services (SSIS) to process and integrate high-volume financial data from multiple sources, including flat files, CSV, Excel, SQL Server, and third-party systems into SQL Server 2017/2022 environments.
- Built complex SSIS packages using advanced transformations (Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Aggregate, Merge Join, Pivot, Unpivot) to improve data quality and ensure compliance with business rules.
- Developed and optimized complex T-SQL queries, stored procedures, functions, views, triggers, and indexing strategies, improving database performance by over 25% and significantly reducing report execution times.
- Implemented robust data warehouse solutions, including staging, operational, and reporting layers, enabling accurate financial reporting, historical trend analysis, and regulatory compliance.
- Developed and deployed enterprise-scale Tableau dashboards, scorecards, and analytical reports leveraging complex SQL queries, dimensional data models, and data warehouse architectures to deliver actionable business insights for executive and operational stakeholders.
- Administered enterprise Tableau Server environments, managing user provisioning, security, content migration, extract scheduling, and performance monitoring to enhance organization-wide business intelligence capabilities.
- Collaborated with business users, data architects, and cross-functional teams to gather requirements and design scalable reporting solutions, implementing Tableau best practices to address data management challenges in fast-paced environments.
- Established backup, recovery, and disaster recovery strategies for mission-critical SQL Server databases, maintaining high availability, business continuity, and data integrity standards.
Sr.Data Engineer/ ETL Developer
MMIT
Yardley, PA
03.2019 - 01.2020
- Developed and implemented end-to-end ETL solutions using SQL Server Integration Services (SSIS) to extract, transform, and load data from diverse source systems including Flat Files, Excel, CSV, and relational databases into SQL Server 2017/2019 data warehouse environments.
- Designed and optimized complex SSIS packages utilizing advanced transformations such as Lookup, Fuzzy Lookup, Conditional Split, Derived Column, Data Conversion, Merge Join, Aggregate, and Row Count to enhance data quality, validation, and auditing processes.
- Automated enterprise data workflows by scheduling and monitoring SSIS packages through SQL Server Agent Jobs, enhancing reliability of data refresh cycles with minimal operational intervention.
- Monitored ETL performance, implementing optimization strategies that enhanced data processing times and increased overall system throughput.
- Performed data profiling, cleansing, reconciliation, and validation activities to improve data accuracy, consistency, and compliance across multiple business domains.
- Created and maintained T-SQL objects, including stored procedures, functions, views, triggers, and complex queries, to enhance data integration and support business intelligence initiatives.
- Contributed to data warehouse development, focusing on staging layer design, dimensional modeling, and ETL optimization to ensure effective reporting and analytical capabilities.
- Collaborated with business analysts, QA teams, and database administrators to gather requirements and troubleshoot ETL failures, delivering scalable data integration solutions.
- Supported business intelligence and reporting initiatives by delivering high-quality datasets for Tableau, SSRS, and ad-hoc reporting solutions used by business stakeholders.
Sr ETL Developer/SQL DBA
Wells Fargo North Brunswick
, NJ
02.2017 - 03.2019
- Led a large-scale database migration initiative, successfully converting mission-critical business data from Sybase to SQL Server 2014 with zero data loss, ensuring data integrity, business continuity, and seamless application functionality throughout the transition.
- Designed, developed, and optimized enterprise ETL solutions using SSIS to extract, transform, validate, and load data across heterogeneous source systems, supporting data warehouse modernization and reporting initiatives.
- Administered and maintained SQL Server production environments, ensuring optimal performance through effective database installation, configuration, patch management, security administration, and capacity planning.
- Implemented proactive monitoring frameworks using SQL Server Agent Jobs, DMVs, SQL Profiler, and Performance Monitor to track performance of CPU, memory, disk I/O, blocking, and queries across multiple servers.
- Developed automated alerting and notification systems for identifying performance bottlenecks, failed jobs, storage issues, and threshold breaches, enhancing response time to system alerts.
- Collaborated with application development teams, business analysts, and infrastructure engineers to design scalable database architectures, aligning with enterprise data integration requirements.
- Leveraged Microsoft Azure services and Power BI to develop cloud-enabled reporting and analytics solutions, delivering interactive dashboards and real-time business insights for executive stakeholders.
Sr ETL Developer/SQL DBA
State of Ohio
Columbus, OH
02.2015 - 10.2016
- Designed, developed, and deployed enterprise ETL solutions using SQL Server Integration Services (SSIS) to extract, transform, and load large volumes of structured and semi-structured data from XML, Flat Files, Excel, and relational databases into SQL Server 2012 data warehouse environments.
- Developed scalable ETL frameworks for loading and processing large datasets, ensuring data quality, consistency, and compliance with enterprise data governance standards.
- Engineered complex SSIS packages utilizing XML Source, Data Conversion, Conditional Split, Lookup, Derived Column, Aggregate, Merge Join, and Script Components to enhance data integration, validation, and transformation efficiency.
- Developed advanced T-SQL queries, stored procedures, functions, views, and triggers using complex joins, Common Table Expressions (CTEs), correlated and non-correlated subqueries, ranking functions, and window functions to support critical business operations and reporting requirements.
- Performed database performance analysis and optimization using SQL Server Database Engine Tuning Advisor (DTA), Best Practices Analyzer (BPA), SQL Profiler, and Dynamic Management Views (DMVs) to enhance query performance and system stability.
- Administered SQL Server databases, including installation, configuration, security management, user provisioning, performance tuning, backup and recovery, and maintenance planning.
- Established automated database monitoring, maintenance plans, index optimization, statistics updates, and health checks to maintain high availability and optimal system performance.
- Supported data warehouse development initiatives, including staging layer design, dimensional modeling, fact and dimension table implementation, and ETL optimization.
ETL/SSIS/SSRS Developer
Cardinal Health
Columbus, OH
04.2014 - 02.2015
- Designed, developed, and implemented end-to-end ETL solutions using SQL Server Integration Services (SSIS) to extract data from relational databases, Flat Files, CSV files, and external source systems, transforming and loading data into enterprise data warehouse environments.
- Developed scalable ETL workflows utilizing multiple staging layers, business rule validations, data cleansing, and transformation logic to ensure data accuracy, consistency, and integrity across healthcare reporting systems.
- Built and optimized SSIS packages using advanced transformations including Data Conversion, Lookup, Aggregate, Sort, Merge Join, Conditional Split, Derived Column, Union All, and Multicast to support complex data integration requirements.
- Optimized ETL and reporting performance through query tuning, indexing strategies, and package optimization to enhance system efficiency.
- Maintained T-SQL stored procedures, views, functions, and complex queries to enhance ETL processing, reporting solutions, and ad hoc business analysis.
- Designed, developed, and deployed SSRS reports, dashboards, and parameterized reports delivering operational, financial, and healthcare analytics to business users and executive stakeholders.
- Collaborated with business analysts, reporting teams, and database administrators to gather requirements and develop technical specifications for scalable business intelligence solutions, ensuring alignment with business needs.
- Supported data warehouse initiatives involving staging, operational data stores (ODS), and reporting data marts to facilitate enterprise reporting and analytics.
- Utilized ClearCase and SVN for source code management, version control, release tracking, and deployment coordination across development, testing, and production environments.
BI Developer/SSIS/SSRS Developer
Missionary Oblates of Mary Immaculate
Belleville, IL
06.2013 - 02.2014
- Designed, developed, and implemented end-to-end ETL solutions using SQL Server Integration Services (SSIS) to extract, transform, and load data from transactional systems, Flat Files, Excel spreadsheets, and relational databases into enterprise data warehouse environments.
- Developed scalable SSIS packages with advanced transformations (Lookup, Merge Join, Derived Column, Aggregate, Conditional Split, Data Conversion, Union All) to improve data integration accuracy and streamline processes.
- Optimized ETL workflows, report performance, and SQL queries through indexing strategies, execution plan analysis, and performance tuning techniques.
- Built and optimized data warehouse solutions including staging layers, operational data stores (ODS), and reporting data marts to improve data accessibility and analytical capabilities.
- Designed, developed, and deployed interactive SSRS reports, dashboards, scorecards, and KPI-driven reporting solutions, providing stakeholders with real-time visibility into organizational performance metrics.
- Collaborated with business users and management to gather reporting requirements and translate them into technical solutions, providing actionable insights for decision-making.
- Performed data quality assessments, validation, and reconciliation to ensure consistency and accuracy of enterprise reporting data.
- Participated in the complete Software Development Life Cycle (SDLC), including requirements gathering, design, development, testing, deployment, and post-production support.
- Prepared technical design documents, ETL mapping specifications, data dictionaries, and report documentation to support maintainability and facilitate knowledge transfer.
SQL Server Developer/SSIS Developer
JP Morgan Chase &Co
Jersey City, NJ
03.2012 - 06.2013
- Developed, enhanced, and maintained SQL Server database solutions to support enterprise financial applications, ensuring data integrity, scalability, and optimal system performance.
- Designed and implemented complex T-SQL stored procedures, functions, triggers, views, and scripts to support transactional processing, data validation, reporting, and business-critical operations.
- Modified and optimized database schemas for improved performance and compliance with business requirements through creation and alteration of tables, views, indexes, constraints, and relationships while maintaining referential integrity.
- Developed SSIS packages for ETL processes to extract, transform, and load data from SQL Server, flat files, Excel, and external databases into centralized reporting and operational environments, streamlining data accessibility.
- Migrated legacy DTS packages to SQL Server Integration Services (SSIS) to enhance ETL performance and maintainability, improving monitoring capabilities and operational reliability.
- Utilized SSIS transformations like Lookup, Derived Column, and Conditional Split to implement complex business rules and validate data quality effectively.
ETL Developer/SSIS Developer
Assurant Insurance INC
Miami, FL
04.2010 - 02.2012
- Designed, developed, and maintained enterprise ETL solutions using SQL Server Integration Services (SSIS) to extract, transform, and load large volumes of insurance and policy-related data from multiple source systems into SQL Server databases and reporting environments.
- Developed and deployed SSIS packages using transformations like Lookup, Derived Column, Conditional Split, Data Conversion, Aggregate, Merge Join, and Union All to improve data quality and integration across disparate systems.
- Implemented incremental and change data loading strategies to improve ETL performance and minimize processing windows, enhancing data load efficiency.
- Optimized ETL workflows and database performance through query tuning, indexing strategies, execution plan analysis, and package optimization techniques, achieving reduced batch processing times.
- Developed complex T-SQL queries, stored procedures, views, functions, and scripts to implement intricate business rules, automate data processing, and support operational and analytical reporting requirements.
Education
Master - Software Engineering
Stratford University
VA01-2009
Bachelors - Information Technology
S P University
Gujarat, India01-2007
Skills
- Data integration and ETL
- Databases: SQL Server, Oracle, PostgreSQL, Azure SQL Database, Amazon RDS
- Cloud Platforms: Microsoft Azure, AWS
- Cloud storage solutions
- Big data processing
- Business intelligence tools
- Data modeling techniques
- Monitoring & Logging: Splunk, Grafana, Azure Monitor, CloudWatch
- Data governance and security
- Programming Languages: Python, SQL, PySpark, Spark SQL, Scala (Basic)
- DevOps & Version Control: Git, Azure DevOps, Jenkins, CI/CD Pipelines
- AI & Productivity: GitHub Copilot, Microsoft Copilot, Azure OpenAI Service
- Project management tools
- Software development methodologies
Certification
Microsoft Certified Azure Fundamentals (AZ-900), Microsoft Certified Technology Specialist (MCTS) SQL server 2008
Timeline
Sr. Data Engineer/SSIS Developer/Tableau report
Wells Fargo
05.2020 - Current
Sr.Data Engineer/ ETL Developer
MMIT
03.2019 - 01.2020
Sr ETL Developer/SQL DBA
Wells Fargo North Brunswick
02.2017 - 03.2019
Sr ETL Developer/SQL DBA
State of Ohio
02.2015 - 10.2016
ETL/SSIS/SSRS Developer
Cardinal Health
04.2014 - 02.2015
BI Developer/SSIS/SSRS Developer
Missionary Oblates of Mary Immaculate
06.2013 - 02.2014
SQL Server Developer/SSIS Developer
JP Morgan Chase &Co
03.2012 - 06.2013
ETL Developer/SSIS Developer
Assurant Insurance INC
04.2010 - 02.2012
Master - Software Engineering
Stratford University
Bachelors - Information Technology
S P University