Resume

Data Ssis

Location:

Nashville, TN

Posted:

January 25, 2021

Contact this candidate

Resume:

Sandhya Jawagi

408-***-****

adjo3c@r.postjobfree.com

Profile Summary:

Over all close to 7 years of experience in Design and Developing and Implementation of Client-Server Applications & Database Administrator systems using MSSQL 2014/2012/2008/2005/2000.

Proficient in optimizing query, identifying missing indexes, index fragmentation

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 Data Ware 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.

Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

Trained business users to develop Ad hoc reports in SSRS, Good hands experiences in AWS Cloud

Good Knowledge in azure fundamentals and PaaS, IaaS, or SaaS.

Technical Skill Expertise:

Languages

T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, 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, Sun Solaris

Professional Work Experience:

Centene Corporation, Location - Remote Nov 2020 – Jan 2021

Project Lead and ETL Application 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, Bit Bucket, Jira, Teradata, TFS, Windows PowerShell ISE

HCA Healthcare, Nashville, TN April 2019–May2020

ETL Developer

Project: Human Resource and Kronos

Projects are developed using DMXpress and SSIS ETL tool to which enables HCA office to maintain information regarding all Employee Information, Theradoc, ATS

Responsibilities:

Worked closely with the Business Users to gather requirements.

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).

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.

Implemented data viewers, Logging, error configurations for error handling the packages.

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: SQL Server 2012/2014, DM Express 9.7.0Windows 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

Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

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/BI 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 data fetched from Facets database and sends out useful information to vendors.

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.

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.

Used BCP utility to Load Bulk data into stage table

Involved in Scheduling jobs to load SSIS packages on daily, weekly, monthly basis.

Involved in validating/Testing the data in Test and Production environment.

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.

Computer Science Corporation (CSC), Albany, NY Aug 2015 –Aug 2016

ETL/BI 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

Integrated SQL Server 2008 reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal

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

BI DEVELOPER