Senior ETL Developer
Resume:
Sandhya Jawagi
Phone – 408-***-****
***********@*****.***
Profile Summary:
Over all close to 9+ years of experience in Design and Developing and Implementation of Client-Server Applications using MSSQL 2014/2012/2008/2005/2000.
Experienced in installation and setup of new SQL Server environment.
Experienced in troubleshooting performance issue, resolving deadlocks.
Experience in database administration, system analysis, backup recovery, testing, disaster recovery and development & support in production using SQL Server.
Experience in planning and implementing MS SQL server security and database permissions.
Strong experience in creating complex stored procedures, replication, index, functions, DTS packages, triggers, cursors, tables, views and Stored Procedure other SQL joins and SQL statements.
Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DM Express 9.7.0.
Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Dataware House using SSIS.
Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
Experience in Microsoft Team foundation services (TFS) and good knowledge and understanding in Agile, Scrum methodologies.
Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
Trained business users to develop Ad hoc reports in SSRS, Good hands experiences in AWS Cloud.
Technical Skill Expertise:
Languages
T-SQL, PL/SQL, XML, HTML,SQL
Tools/Utilities
Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, Visual Studio 2005/2008, SQL * Plus, Toad, Tableau, MS Excel, MS Office, OBIEE11G, Oracle
Databases
MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access, Teradata
Data Modeling Tools
Microsoft Visio, UML
Operating Systems
Windows 9x/2000/XP, Linux, UNIX
Professional Work Experience:
HCA Healthcare, Brentwood, TN Aug 2023 – Till Date
Senior ETL Developer
Project: Expanse Project
Responsibilities:
Involved in Expanse Project meetings to understand the Business Requirement and Developed ETL Jobs to load the data from different source files to Target Destination Tables data based on the Business requirements.
Using DMexpress analyzed the source data to Extract and Transform from the various Source systems (Oracle, SQL Server and Flat Files).
Involved in Creating Testing Document to verify the Source and Target counts.
Developed and used the SQL queries to validate the data in both source and target databases.
Involved in creating Sql scripts to load the data in Teradata using DM Express ETL tool.
Created Zeke Jobs to load the data in Teradata and monitor the Jobs in Rumba/IBM mainframes
Created Paramfiles and bat files to run the ETL Jobs
Hands on experience in Google Big Query and Google Could Platform (GCP)
Involved in developing and updating DAGs in GCP
Developed ETL jobs to test Teradata vantage migration platform on GCP
Environment: DM Express 9.9.0 Windows 8, Github, TFS, Jira, Teradata, UNIX, GCP
HCA Healthcare, Brentwood, TN Jan 2023 – July 2023
Senior ETL/SQL Developer
Project: Project Vail
Responsibilities:
Involved in analyzing the Claims data based on the Business requirements and build the transformation rules to create stored procedure and TPT scripts to load the data in target systems.
Claims Projects are developed using Stored Procs and TPT scripts to generate CSV files to third party vendor
Created Merge logic to update existing records and insert the new records based on mapping document.
Involved in creating SQL code review document for performance tuning.
Created Migration documents and SQL scripts, ETL jobs and Components to release the code in QA and Prod Environments.
Involved in Creating Testing Document to verify the Source and Target counts.
Developed and used the SQL queries to validate the data in both source and target databases.
Involved in creating Sql scripts, Stored Procedure, TPT scripts to load the data in Teradata.
Used Github to migrate the scripts from lower to higher environment.
Environment: TPT, Windows 8, Github, TFS, Jira, Teradata, UNIX
Zywave Inc, Nashville, TN (WFH) April 2022 – Jan 2023
Senior ETL/SQL Developer
Responsibilities:
Involved in analyzing the Multiple Source Systems based on the business requirements build the Transformation rules to extract Transform and Load the data in the Target systems.
Created ETL packages using SSIS ETL tool to load data into target destination table.
Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Created different SSIS packages to load Data from different sources such as CSV, Excel, Zip Files.
Created SSIS package to load Incremental file, daily Refresh File and used file system task to move file to archive once the loading is completed
Developed SSIS package to load only weekdays file and move weekend files to archive before loading.
Used Github to migrate the packages from lower to higher environment.
Environment: SQL Server 2019, Visual studio 2017/2019, TFS, Windows PowerShell ISE
HCA Healthcare, Nashville, TN March 2021 – March 2022
ETL Developer/SQL Developer
Responsibilities:
Involved in analyzing the Multiple Source Systems based on the business requirements build the Transformation rules to extract Transform and Load the data in the Target systems.
Using DMexpress analyzed the source data to Extract and Transform from the various Source systems (Oracle, SQL Server and Flat Files).
Created Merge logic to update existing records and insert the new records based on mapping document.
Involved in creating SQL code review document for performance tuning.
Created Migration documents and SQL scripts, ETL jobs and Components to release the code in QA and Prod Environments.
Involved in Creating Testing Document to verify the Source and Target counts.
Developed and used the SQL queries to validate the data in both source and target databases.
Involved in creating Sql scripts to load the data in Teradata using DM Express ETL tool.
Created Zeke Jobs to load the data in Teradata and monitor the Jobs in Rumba/IBM mainframes
Created Paramfiles and bat files to run the ETL Jobs
Environment: SQL Server 2012/2016, DM Express 9.9.0 Windows 8, oracle, Github, TFS, Jira, Teradata, UNIX, visual Studio 2015
Centene Corporation, Location - Remote Nov 2020 – Jan 2021
Project Lead Application Software Engineer (ETL) /SQL Developer
Project: Supplemental Data Source (SUDS)
Projects are developed using SSIS ETL tool to which enables Centene office to maintain information regarding all the SUDS related data.
Responsibilities:
Worked closely with the Business Users to gather requirements.
Used SSIS to populate Supplemental data Source from various data sources, creating packages for different data loading operations for applications.
Created different SSIS packages to load Data from different sources such as CSV, Excel, Dat Files, Zip Files.
Involved in testing SSIS packages to validate the Import Rows, Stage Rows, Duplicate Rows, and Error Rows.
Used Windows PowerShell script to generate the UAT reports
Used Bit bucket a code repository for solution development to maintain source control to deploy the code to production environment.
Environment: SQL Server 2016/2019, Bit Bucket, Jira, Teradata, TFS, Windows PowerShell ISE
HCA Healthcare, Nashville, TN April 2019–May2020
ETL Developer
Responsibilities:
Using DMexpress analyzed the source data to Extract and Transform from the various Source systems (Oracle, SQL Server and Flat Files).
According to business requirement involved in creating SCD type2 logic.
Created Merge logic to update existing records and insert the new records based on mapping document.
Involved in creating SQL code review document for performance tuning.
Created Migration documents and SQL scripts, ETL jobs and Components to release the code in QA and Prod Environments.
Involved in complete life cycle in creating ETL packages using DMXpress, building, deploying and executing the packages in both the environments (Development and Production)
Involved in Creating Testing Document to verify the Source and Target counts.
Developed and used the SQL queries to validate the data in both source and target databases.
Involved in creating Sql scripts to load the data in Teradata using DM Express ETL tool.
Created Zeke Jobs to load the data in Teradata and monitor the Jobs in Rumba/IBM mainframes
Created Paramfiles and bat files to run the ETL Jobs
Environment: DM Express 9.7.0, Windows 8, oracle, Github, TFS, Jira, Teradata, UNIX
ShareCare, Franklin, TN July 2018 –March 2019
ETL/SQL Developer
Project: Health and Wellness project
Health and wellness engagement platform that provides consumers with personalized information, programs and resources to improve their health.
Responsibilities:
Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Wrote efficient stored procedures for the optimal performance of the system.
Monitored performance and optimized SQL queries for maximum efficiency.
Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
Converted stored procedure from Oracle to SQL server based on business need.
Involved in error handling of SSIS packages by evaluating error logs
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
Used Lookup Transformation to get the data from reference data sets
Involved in testing SSIS packages in test Environment before deploying in Production environment
Involved in analyzing data marts and File validation Process
Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
Maintained and Supported Microsoft Team Foundation Server TFS to allow for a secure code, SSIS Packages and Reports and use as a repository in order to compare modified and unmodified code.
Environment: SQL Server 2012/2014, SQL Server Business Intelligence Development Studio (SSIS, SSRS), C#, .Net framework, XML, Windows 8, oracle, TFS
Optum Technologies, Franklin, TN Nov 2016 – June 2017
ETL/SQL Developer
Project: Patient Assessment form
I have worked on a project for a health insurance provider company where we have interfaces build in SSIS that transforms and process the Claims and Patient Assessment forms.
Responsibilities:
Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions.
Used Import/Export Wizard to quickly move data into or out of SQL Server from or to a variety of sources, including text files and other SQL Server instances.
Created, updated and maintained ETL technical documentation, Created database objects like tables, views, indexes.
Developed ETL packages for parsing, mapping and importing raw 820, 834,835 and 837 files into the data warehouse using EDI Parsing software/SSIS.
Deploying new Database objects in testing and production environment.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task
Used SSIS to populate Claims and Enrollment data from various data sources, creating packages for different data loading operations for applications.
Created different SSIS packages to load Data from different sources such as CSV, Excel, Dat Files, Zip Files.
Created SSIS package to load Incremental file, daily Refresh File and used file system task to move file to archive once the loading is completed
Developed SSIS package to load only weekdays file and move weekend files to archive before loading.Worked on SSIS package to load to skip trailer records and load data in table.
Used 7 Zip task to unzip the zip files and to load only unzip file.
Created Stored Procedure to load data from stage table to destination table in database.
Experience in using Team Foundation Server (TFS) as a tool for source control, data collection, reporting and project tracking.
Downgraded SSIS packages from higher to lower version
Involved in developing, documenting ETL implementation for new data sources
Actively Involved in presentation to explain Health care project work flow to the team
Good Knowledge and understanding in Health care Project.
Involved in testing SSIS packages and SSRS Reports.
Environment: SQL Server 2012/2016, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), C#, .Net framework, XML, Windows 8.
Employer: Propelsys Technologies LLC
Research Foundation for SUNY, Albany, NY Aug 2015 –July 2016
ETL/SQL Developer
Responsibilities:
Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Modified the existing SSIS packages to meet changes as specified by the users.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
Involved in OBIEE installation on Red hat Linux on AWS(Amazon web services)
Involved in creating Redshift database connections to OBIEE Server
Developed OBIEE reports using Redshift Database
Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS) and Created SQL Jobs to schedule SSIS Packages
Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc. and Configured and deployed SSRS reports to Share point
Scheduled the SSIS packages to run at different intervals to load the data
Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server
Business Intelligence Development Studio (SSIS, SSRS),C#, .Net framework, XML,OBIEE 11g,Redshift
Railroad Commission of Texas, Austin, Texas Jan2015-Aug2015
ETL/SQL Developer
Responsibilities:
Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
Modified the existing SSIS packages to meet changes as specified by the users.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
Involved in OBIEE installation on Red hat Linux on AWS(Amazon web services)
Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS) and Created SQL Jobs to schedule SSIS Packages
Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc. and Configured and deployed SSRS reports to Share point
Scheduled the SSIS packages to run at different intervals to load the data
Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio ( SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS
Wellington Management LLP, Marlborough, MA Jan2014 – Dec2014
ETL/SQL Developer
Responsibilities:
Wrote efficient stored procedures for the optimal performance of the system.
Monitored performance and optimized SQL queries for maximum efficiency.
Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
Recovering the databases from backup in disasters
Created indexed views and appropriate indexes to reduce the running time for complex queries.
Generated custom and parameterized reports using SSRS.
Created reports that call sub reports in SSRS.
Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Created Reports and dashboards in Oracle business Intelligence enterprise edition (OBIEE)
Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access, OBIEE 11G,Oracle
Endurance International Group, Burlington, MA June2013 – Dec 2013
SQL/ ETL Developer
Responsibilities:
Created Reports and dashboards in Oracle business Intelligence enterprise edition (OBIEE)
Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables for resource Management.
Tested to optimize the procedures and triggers to be used in production.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Involved in project planning, scheduling for database module with project managers.
Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008, C#,T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access, OBIEE 11G,Oracle
State University of New York (SUNY), Albany, NY Feb-2013-June-2013
ETL/SQL Developer
Responsibilities:
Involved in project planning, scheduling for database module with project managers.
Created indexed views and appropriate indexes to reduce the running time for complex queries.
Developed, deployed, and monitored SSIS Packages. Generated custom and parameterized reports using SSRS. Created reports that call sub reports in SSRS.
Assisted in the design of star schema and snow flake schema.
Created reports and dashboards according to business need in OBIEE11g
Environment: SQL Server 2005 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C#, T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access, Visual Studio 2005.OBIEE 11g, Oracle
Goldman Sachs Group, Inc., Jersey City, NJ Aug 2012- Feb2013
SSIS Developer
Responsibilities:
Design/Build Extract Transform Load procedures in SQL Server Integration Services.
Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
Developed user defined financial reports to provide on demand financial data analysis using SSRS
Developed numerous ad-hoc reports using SSRS for day to day financial reporting..
Environment: SQL Server 2005/2008 Enterprise, Windows Enterprise Server 2003, SSIS, SSRS, Server 2004, Share Point Portal Server 2007 (MOSS 2007),XML, ETL, Microsoft Visio 2010, MS Visual Studio 2008/2010
EDUCATION:
Bachelor’s Technology in Engineering, SICET, JNTU, INDIA, 2009
Master of Science, California State University, Northridge, CA, 2012
Worked as Student Assistant at CSUN, Feb 2010 to May 2012
Contact this candidate