Soniya Verma

***** *** ******* ****, *** ****, Nashville, TN 37211

u Mobile: +1-404-***-**** u adbfqw@r.postjobfree.com Career Summary

• Accomplished IT professional with 7+ years of experience with ETL, Data Integration & Reporting tools (SSIS & SSRS)

• 7+ years of experience with flat file, format file, XML, CSV and pipe delimited files for Extract, Transform & Load

• Proven 7 years of experience in ETL applications to import and export data utilizing available tasks in SSIS and also maintain, support and improve the performance of existing applications in production

• 7 years of experience in relational databases, Microsoft SQL Server and Oracle for defining and implementing designs and schema changes

• 6+ years of experience in writing database queries and complex joins for creating various database artifacts stored procedures, triggers, user-defined functions, views and cursors

• 4 years of experience in developing enterprise grade ASP.NET and Windows based applications using C#.NET, JavaScript, jQuery, Bootstrap, MVC framework, AWS SDK for .Net

• 2 years of experience in data modeling (dimensional & relational) concepts like Star-Schema, Snowflake Schema, Fact and Dimension tables.

• 2 years of experience working with various AWS services IAM, EC2, S3, ELB, RDS, R53

• Excellence in data analysis, data cleaning and restructuring the raw data in meaningful format

• Comprehensive experience working with health care, US medical codes and banking domain

• Form quality corporate liaisons and relationships easily, instilling high level of confidence at all levels.

• Received appreciation from clients and colleagues for significant contribution done for the growth of organization Career Path

ETL Developer

PopHealthCare, Franklin, TN

Mar 2017-Current

Graduate Assistant and Master’s Student

Tennessee State University, Nashville, TN

Aug 2015 – Dec 2016

Technology Analyst

Infosys, Pune, India

June 2012 – Nov 2013

Analyst Programmer

Syntel Inc, Pune, India

Sep 2010 – June 2012

Associate System Engineer

IBM, Pune, India

Dec 2009 – Aug 2010

Software Developer

Mahindra Satyam, Pune, India

Dec 2007 – Aug 2009

Technical Skills

• ETL Technologies: SQL Server Integration Services (SSIS)

• Reporting: SQL Server Reporting Services (SSRS), Knowledge of Power BI

• Cloud Computing: Amazon Web Services (IAM, EC2, S3, ELB, RDS, R53)

• Relational Database: Microsoft SQL Server, Oracle

• Programming Language: C#.Net, VB.Net, Java, OOPs concepts.

• Scripting Languages: JavaScript

• API Implementation: RESTful API, SOAP over HTTP

• Programming Technologies: Net Framework 4.0/3.5/2.0, ASP.Net

• Source Code Repo: TFS, SVN

• Software Architecture: Unified Modelling Language (UML), Entity Relationship Diagram (ERD)

• Project Management: JIRA and Sifter

• Other Technologies: HTML/CSS, Web API call

Education

Master’s In computer science (Honors)

Tennessee State University, Nashville, TN

Fall 2016

Bachelor of Engineering (Electrical Engineering) (Honors) A D Patel Institute of Technology, Gujarat, India

2007

Projects Completed

Project Title & Duration DataXchange / Jan 2018 – Present Role & Technology ETL Developer / SSIS, SSRS & SSAS, C, ASP.Net, Microsoft SQL Server Client BCBS, US Healthcare Companies

Project Description

DataXchange project handles wide array of services for clients, handling files for membership, claims data and to send outbound files to clients and vendors. It also includes services for onboarding new clients. Responsibilities

§ Designing solutions for the requirements ratified with business team and analysts and creating POC if applicable

§ Responsible for continuous improvement/efficiencies of the defined process to increase performance and reducing design complexity to reduce time to market

§ Created config based generic process to create zip file to be sent to clients using SSIS tasks like foreach loop, event handlers, expressions, process task and send mail tasks reducing manual efforts by 35%.

§ Key contributor in designing scalable, reusable and maintainable ETL templates for increased productivity

§ Developed, documented and validated complex business rules vital for data transformation.

§ To develop and support outbound process using SSIS to export data from SQL server into flat files

§ Import text files into staging tables utilizing BULK INSERT and generate format file as per the specifications.

§ Implementing multi-tiered process including SSIS package, stored procedures, transformations & ETL mappings.

§ Designed and developed multiple business crucial process like loading medical codes and call history files

§ Experience working with querying data from remote server using OPENQUERY and dynamic queries to maintain the local copy of data for reporting purposes.

§ Implemented custom data validation process for metadata summarization of the data warehouse tables to export appointment data to send reminder messages to members.

§ Creating ISPAC scripts for deploying, validating SSIS packages and supporting production environment Project Title & Duration RST application / March 2017 – Present Role & Technology Web Developer / C#, ASP .Net, SQL Server, SSMS, SSIS, SSRS, TFS, RESTful API Client ACA Insurers

Project Description

RST web application is instrumental to load membership and claim data for health plans, It transforms and validate medical and pharmacy claim data, creates and posts XML files on AWS S3 buckets on CMS server using Bootstrap, JavaScript, C# and ASP.Net. Response files received from CMS refreshes data in SSRS reports assisting ACA clients to analyze accepted claims. The project reduced manual work done by the team by over 80%. Responsibilities

§ Designed & developed .net application that imports files to database using SSIS packages & stored procedures

§ Developed SQL rule engine utility to automate cleansing & validating the membership and claim data reducing manual efforts by 40%

§ Designed and developed C# console microservice to automate XML file creation and integrated with claim processing application to further reduce manual work by 20%

§ Developed SSIS packages to extract & load CMS XML response files in database reducing manual work by 20%

§ Design and develop SSRS reports as per Center for Medicare Services release changes directives

§ Responsible for working closely with business for defining requirements and developing requested changes

§ Integrated .Net application with AWS SDK for .net to authenticate, create s3 bucket, upload and download files from s3 buckets, starting and stopping EC2 instance programmatically. Project Title & Duration

Five9 / Jan 2018– Dec 2018

Role & Technology ETL Developer / SQL Server, SSMS, SSIS, SSRS, Visual Studio, TFS, C#, Web API Client US Healthcare Clients

Project Description

Five9 is a cloud-based call center system which is used for outreaching patients. It stores call history, status of calls and appointment scheduling which is used for reporting purpose. Responsibilities

§ Designed and developed an automated system which loads call center data (CSV files) from different sources into SQL server database using SSIS packages, stored procedures and complex database queries.

§ Developed the process to push data to cloud based call center using Web API through SSIS package and script task to make them available for agents to call.

§ Responsible to analyze the call data for creating SSRS reports. Support existing packages and troubleshoot issues Project Title & Duration Australian Future Directives Share (AFDS) / June 2012 – Nov 2013 Role & Technology Database, ETL Developer / Oracle PL/SQL, Control M, TOAD, PVCS Client Australian Mutual Provident

Project Description

The purpose of AMP COIN/XPLAN project was to extract files for Future Directions Australian Share (AFDS) for AMP sent by COIN and XPLAN users.

Responsibilities

§ Managed performance & tuned slow running SQL queries in production utilizing tools like Explain, Trace.

§ Developing PL/SQL packages and scripts for ETL (Data Integration) purposes.

§ Developed SQL scripts using CURSORS, STORED PROCEDURES, INDEXES to efficiently convert data to information for analysis purposes.

§ Responsible for writing unit test cases for the project developed and provide support during UAT.

§ Involvement in UAT and production validation and providing warranty support to the customer.

§ Responsible for scheduling ETL packages using Control M. Project Title & Duration HIDCMS and Control Point / September 2010-June 2012 Role & Technology ETL, Database Developer / SSIS, SSRS & SSAS, C#.Net, ASP.Net, SQL Server 2012 Client Humana Healthcare

Project Description

HIDCMS is the application which manages the Humana ID card requests. It also includes reports for management use for ID cards applied, approved or rejected with reason and final status of cards. Responsibilities

§ Creating ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

§ Performed data reconciliation, validation and error handling after Extracting data into SQL Server.

§ Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

§ Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

§ Created reports with Analysis Services Cube as the data source using SSRS. Project Title & Duration Deutsche Bank, IBM India / December 2009-August 2010 Role & Technology System Engineer / C#.Net, ASP.Net, SQL Server Client Deutsche Bank, IBM India

Project Description

The project was an execution engine for Cash Trading, Program trading and Non-Agency Responsibilities

§ Responsible for developing and deploying code as outlined in the design documents

§ Responsible to create and running unit test cases and work with QA team for any issues faced in QA Project Title & Duration Mahindra Satyam / December 2007 – August 2009 Role & Technology Software Developer / SSIS, SSRS & SSAS, C#.Net, ASP.Net, SQL Server Client Internal Clients

Project Description

XMART sales is a web application used add, update and delete items for sale. Responsibilities

§ Created module using C# to manipulate item attributes and quantities and user interfaces

§ Create ADO.Net for connecting to Microsoft SQL server database to insert, update and delete data. Professional and Academic Triumphs

§ Subject matter expert for CMS Risk submission application to bridge the gap between client and technical team

§ Graduated Master’s in Computer Science from Tennessee State University, Nashville with 4.0 GPA.

§ Training in C# and MS SQL server from Mahindra Satyam, India

Contact this candidate