Experienced MS SQL Server Developer & ETL Lead
Resume:
Nilay Shah
************@*****.***
PROFESSIONAL SUMMARY
MS SQL Server Developer/ETL/ T-SQL/ PL-SQL Developer/Lead with Over 11+ years of strong experience in Retail, Banking, Finance, Government, Bioscience, Vehicle Dealerships and Market Research domains.
Highly proficient in operating MS SQL Server 2022/ 2017/2014/2012/2008R2/2008/2005 suite of products like SSIS, SSRS.
Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
Proficient in using PL/SQL development including triggers, types, procedures, functions.
Worked om developing and maintaining PL/SQL Packages, Stored Procedures, Functions, Triggers, and SQL statements in Oracle 19c for Merchant services KOL project.
Wrote and debugged PL/SQL stored procedures, functions and packages in Oracle 19c
Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
Developed Tableau data visualization using Cross tabs, Heat maps and Whisker charts, Scatter plots, Pie charts.
Perform data validation by writing/modifying complex SQL scripts in PL/SQL.
Worked on PL/SQL development including triggers, types, procedures, and functions for Merchant services KOL project.
Support business for all data related issues
Prepared documentation and analysis for end year audits for property tax
Perform ad-hoc and reoccurring statistical analyses.
Worked with data warehouse architects and software developers to generate seamless business intelligence solutions for business partners.
Worked on data modeling, workforce planning by using Visio tool.
Designed, Developed, tested, and maintained Tableau functional reports on user requirements.
Worked On building and managing Tableau dashboards.
Analyzes large amounts of data using pivot tables to create daily, weekly, and monthly reports.
Strong hands-on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
Perform ETL and data engineering processes such as configuring Data Pipelines, Data Modelling administering Snowflake.
Integrate on-premises infrastructure with cloud (Azure, Aws) infrastructure.
Implement data ingestion routines both real time and batch using best practices in data modeling, ETL/ELT processes ADF.
Work closely with Data Warehouse Architect to develop ETL pipelines in and out of the data warehouse solution such as Snowflake.
Worked on Python OpenStack APIS and used NumPy for numerical analysis.
Wrote Python routines to log into the websites and fetch data for selected options.
Scheduled execution and delivery of end of the day report using SSRS/QlikView, Power BI.
Created a data pipeline to get the data into redshift through panoply and transformed them into dbt tool.
Developed Power BI reports, dashboards, and DAX queries for Greenlight Platform SharePoint Activity.
Document implementation, testing, and deployment of Power BI solutions.
TECHNICAL EXPERIENCE
Programming Languages: T-SQL, PL-SQL, HTML, XML, C++, Python
Software/Databases: Microsoft Access 2012/2010/2007 Microsoft Excel, Outlook, PL -SQL,MS SQL Server 2022/2016/2014/2012/2008, MS SQL Server 2022/2012/2008/2008 R2/2005, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Power Point, MS Visio 2013/2007, Tableau Server, Oracle 11g/10g/9i, Snowflake, Power BI
Operating Systems: Windows 10/8/7 Advanced Server/Professional
Others: Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Erwin Data Modeler 9/8/7.2, Crystal Reports 8.5, Windows Server/Workstation 2012/2008 R2/2008, Tableau Desktop 9.1.1, ADF, AWS, DBT, Snowflake, Oracle 19c
PROFESSIONAL EXPERIENCE
WELLS FARGO BANK, Dallas, TX Apr 2023 – Present
Senior ETL/AB Initio/SQL/ PL -SQL Developer
Responsibilities:
Worked on Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations called "sprints.".
Developed Mapping Documents between Source to Destination Tables for AM Support, Hogan, and Complaint Metrics Applications.
Analyze and develop strategies and approaches to import and transfer data between source, staging, and Data Warehouse destinations for AM Support, Hogan, and Complaint Metrics Applications of Wells Fargo Merchant services Group.
Worked om developing and maintaining PL/SQL Packages, Stored Procedures, Functions, Triggers, and SQL statements in Oracle 19c for Merchant services KOL project.
Wrote and debugged PL/SQL stored procedures, functions and packages in Oracle 19c
Optimize and tune SQL and PL/SQL code to ensure high performance and efficiency for complaint metrics merchant services application .
Developed and tested database applications using PL/SQL, Oracle Forms and Reports and other database tools
Worked with Backend SQL Server Database (WDVWD99A0929) to change the T SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance of Guardian platform SQL Server Database (WDVWD99A0929).
Designed and Developed SSIS (ETL) packages to validate, extract, transform and load data from MS Access Database to AM Support, Hogan, and Complaint Metrics SQL Server Database (WDVWD99A0929).
Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to AM Support, Hogan, and Complaint Metrics Guardian Platform using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
Performed ETL mappings using MS SQL Server Integration Services.
Designed and implemented custom monitoring solutions for Autosys job schedules, providing real-time insights into job statuses and performance metrics.
Helped create standard operating procedures (SOPs) for job scheduling tasks in Autosys, providing clear guidelines for team members.
Participated in testing new software upgrades for Autosys, evaluating the impact on existing job schedules and functionalities.
Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive AM Support and Hogan reports according to business requirements in time restricted environment using SQL Server Reporting Services (SSRS).
Participated in reviews of issues related to Guardians SSRS reports and worked in troubleshooting those issues, fixing, testing, and deploying them in Embedded IT Prod Server.
Worked on All Merchant services SSRS Kol reports to Power BI.
Developed Power BI reports, dashboards, and DAX queries for Guardian Platform SharePoint Activity.
Document implementation, testing, and deployment of Power BI solutions.
RUMBLE ON INC, Dallas, TX Dec 2022 – Apr 2023
ETL/AWS Data Engineer
Responsibilities:
Develop and maintains schema designs, data models, API and troubleshooting documentation.
Build optimal ETL infrastructure for a variety of data sources.
Perform ETL and data engineering processes such as configuring Data Pipelines, Data Modelling administering Snowflake.
Build optimal ETL infrastructure for a variety of data sources.
Work closely with Data Warehouse team to develop ETL pipelines in and out of the data warehouse solution such as Snowflake and Aws
Install configure, test, monitor and tune existing PostgreSQL databases.
Worked on creating and managing the PostgreSQL instance from Amazon RDS.
Wrote Python routines to log into the websites and fetch data for selected options.
Integrate on-premises infrastructure with cloud (Aws) infrastructure.
Participates in the development, improvement, and maintenance of database applications.
Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Data sharing and stored procedures.
Performs independent technical analysis, debugging and troubleshooting as well as code and unit testing for complex scope modules, and projects.
Created a data pipeline to get the data into redshift through panoply and transformed them into dbt tool.
GREENLIGHT BIOSCIENCES INC, Minneapolis Jan 2022 – Dec 2022
ETL Developer/Azure Data Engineer
Responsibilities:
Perform ETL and data engineering processes such as configuring Data Pipelines, Data Modelling administering Snowflake.
Implement data ingestion routines both real time and batch using best practices in data modeling, ETL/ELT processes Azure Data Factory (ADF).
Work closely with Data Warehouse Architect to develop ETL pipelines in and out of the data warehouse solution such as Snowflake.
Design and build data collection and transformation pipelines in ADF.
Integrate on-premises infrastructure with cloud (ADF) infrastructure.
Participates in the development, improvement, and maintenance of database applications.
Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures.
Performs independent technical analysis, debugging and troubleshooting as well as code and unit testing for complex scope modules, and projects.
Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive MRNA reports according to business requirements in time restricted environment using SQL Server Reporting Services (SSRS).
Developed Power BI reports, dashboards, and DAX queries for Greenlight Platform SharePoint Activity.
Document implementation, testing, and deployment of Power BI solutions.
ST OF MN_ HENNEPIN COUNTY, Minneapolis, MN Jun 2018 – Dec 2021
ETL Developer / PL/SQL Developer
Responsibilities:
Create/modify ETL (SSIS) packages to ensure correct data extraction for vendor conversion activities.
Responsible for designing and implementing ETL architecture to meet property tax data management needs and business functional requirements.
Worked for creating Entity Relationship Diagram by using Erwin Tool.
Worked for creating Entity Relationship Diagram by using Visio.
Responsible for PTM data architect to implement source data into the designed target data model.
Responsible for Creating and maintaining documentation of the Data Warehouse/Business Intelligence architecture, objects, standards, and best practices.
Perform data validation by writing/modifying complex SQL scripts in PL/SQL.
Worked on PL/SQL development including triggers, types, procedures, and functions in Oracle 19C
Wrote and debugged stored procedures, functions and packages in PL/SQL
Developed and tested database applications using PL/SQL, Oracle Forms and Reports and other database tools
Record detailed results of validation including defects and documentation issues in tracking system (JIRA, TFS).
Support business for all data related issues. Perform ad-hoc and reoccurring statistical analyses.
Worked with data warehouse architects and software developers to generate seamless business intelligence solutions for business partners.
Review and validate vendor responses to reported bugs.
Analyze vendor provided documentation to ensure scripts accurately test data accordingly.
Interact with business subject matter experts and vendors relating to data migration activities.
Collaborate with project Business Analyst and other project team members as needed.
Gather and interpret data from disparate data sources to solve complex problems and evaluate scenarios to help support decision making.
Analyze multiple scripts and ETL packages to gain an understanding of data flow in the absence of comprehensive documentation.
Prepared documentation and analysis for end year audits for property tax.
Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
Gathered all the data from legacy systems and loaded them into a flat file using ETL.
Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
Developed property tax reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
Actively supported business users for changes in reports as and when required using SSRS.
Created many complex stored procedures/functions/triggers and used them in crystal reports directly to generate reports on the fly.
Designed, Developed, tested, and maintained Tableau Functional reports on Property tax User requirements.
BEST BUY, Richfield, MN Dec 2013 – May 2018
MS SQL / PL -SQL/BI Report Developer
Responsibilities:
Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations called "sprints.".
Created Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
Reversed engineer backend CCHClaimsHubDBO1, CCHClaimsHubDB02 database to change the T-SQL scripts, create Views, Stored Procedures, Triggers and Functions to improve performance drastically in PLSQL.
Worked om developing and maintaining PL/SQL Packages, Stored Procedures, Functions, Triggers, and SQL statements in Oracle 19c for Claims Hub Application.
Created various types of performance Claims Hub reports from the TFS server database using SSRS.
Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, Claims (Staging Database CCHCliamsHubDB01) to Claims Hub (PDW).
Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Claims Hub using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive Claims Hub reports according to business requirements in time restricted environment using Sql Server Reporting Services (SSRS).
Scheduled execution and delivery of end of the day report using SSRS/QlikView, PowerBI.
Participated in reviews of issues related to Claims Hub SSRS reports and worked in troubleshooting those issues, fixing, testing, and deploying them in PDW01CCHRS01 Server.
Designed, Developed, tested, and maintained Tableau functional reports on user requirements.
Converted existing Claims hub reports to tableau dashboard.
Performed Validation on machine learning output from R.
Analyzes large amounts of data using pivot tables to create daily, weekly, and monthly Claims Hub reports.
Worked with end-to-end understanding of the Epic platform, specifically Clarity and Caboodle.
MMC SYSTEMS, NJ Dec 2012 – Dec 2013
ETL/BI Developer
Responsibilities:
Involved in database design.
Create/modify ETL (SSIS) packages to ensure correct data extraction for vendor conversion activities.
Perform data validation by writing/modifying complex SQL scripts in SSMS.
Design and develop T-SQL procedure, query performance tunings and SSIS packages.
Develop underlying data models and databases.
Ensure compliance of standards and conventions in developing programs.
Designed and developed SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to DW.
Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
EDUCATION
Bachelor’s in Computer Science
Gujarat University
Master’s in Business Administration (MBA)
Goldey Beacom College
CERTIFICATIONS
Certified Java
Certified MS SQL Server
Certified Web Design and Implementation
Contact this candidate