Swetha Vudugu

ad0flt@r.postjobfree.com

732-***-****

Summary:

Professional with 7+ years of total IT experience in Data warehouse design, Database Design, Business Analysis, Data analytics, Development, and support for various ETL and Data engineer projects.

Experience in writing and executing Functional Specifications from Requirement specifications.

Worked on all phases of the development lifecycle from gathering requirements, implementation, testing and support.

Effectively able to translate and interpret business needs into technical requirements along with analyzing impact of changes as new solutions are introduced.

Experience working with Microsoft Technologies including MS SQL Server and SSIS, SSRS, PowerBI.

Expert with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, relational database models.

Involved in Performance tuning and query optimization for various Maintenance Projects.

Experience in all aspects of Data Warehousing (used Kimball’s approach) including project planning, requirement gathering, data modeling, development, deployment, maintenance, and enhancement.

Advance knowledge in RDBMS concepts including conceptual/logical/physical data models&

Dimensional/Star/Snowflake schemas.

Worked on Snap logic ETL to load data into Snowflake tables from AWS S3 buckets.

Migrated data from various data sources like data lake into Cloud DW and EDW using various ETL tools.

Worked on Alteryx to Integrate data between salesforce and SAP Application systems.

Experience with Wherescape ETL tool to create and maintain data warehouse jobs.

Expert in analyzing data warehouse systems and using a data warehouse.

Worked on Data Quality projects using Informatica Data Quality Tool (IDQ) and developed analytical Scorecards.

Generated various Analytical Reports and Dashboards using SSRS and Tableau,

Experienced in scheduling jobs and monitoring them for Full and Incremental loads in day-to-day process.

Technical Skills:

Relational Databases

MS SQL 2008/2008 R2/2012,2014, Oracle

Languages

C#, Java, R

ETL Tools

SSIS, Informatica, Alteryx, WhereScape

Tools

SSMS, Visual Studio, TFS, MS Excel

Reporting Tools

SSRS, Tableau, Power BI, SAS

Project Tools

TFS, JIRA, and Share point 2013

Scripting

JavaScript, VBScript, Python.

Education:

Master’s in computer and Information Systems from Rivier University - Nashua, NH

Master of Business Administration from Osmania University - Hyderabad

Bachelor of Information Systems from Osmania University - Hyderabad

Professional Experience:

Worked as Senior Data Engineer for Siemens DISW

Role : Sr Data Engineer

Duration : April 2022 – March2023

Description: Siemens Digital Industries software is an American software company specialized in 3D&2D Product Lifecycle

Management Software.

Responsibilities: As a Data Engineer created workflows using Alteryx ETL tool to Integrate data between different application

Systems (Salesforce and SAP).

Scheduled Alteryx flows to perform day to day salesforce data updates.

Worked as Senior Data Engineer for Liberty Mutual Insurance - Dover, NH

Role : Sr Data Engineer

Duration : June 2020– March 2022

Description: Liberty Mutual is a leading insurance provider. As a data engineer created snap Logic ETL pipelines to move

data from Teradata source to Snowflake data warehouse.

Scheduled snap logic jobs to refresh data for day to day needs.

Worked as Data Quality Analytics Developer for Partners Healthcare - Somerville, MA

Role : Developer/ Analyst

Duration : August 2019 – June 2020

Description: Partners HealthCare is a not-for-profit health care system that is committed to patient care, research, teaching, and service to the community locally and globally. Collaboration among our institutions and health care professionals is central to our efforts to advance our mission. My responsibilities include Analyze data to identify and evaluate critical capabilities and recommend solutions by using SAS, SQL, IDQ and Excel.

Environment: SQL Server 2014, Agile, SSIS, TFS, Visual Studio2017, POWER BI, Informatica IDQ, SAS, Excel

Worked as ETL Database Developer for Beacon Health Options, Boston-MA

Role : ETL Developer

Duration : April 2019 – July 2019

Description: Beacon Health Options is a subsidiary of FHC Health Systems, Inc. The company provides behavioral healthcare management to 41 Fortune 500 companies, national and regional health plans, and federal, state, and local governments.

My responsibilities include 834 membership enrolment and maintenance imports and 837 claims exports, claims and encounters as well as proprietary formats such as delimited files.

Environment: SQL Server 2012, SSIS, JIRA, TFS, Visual Studio2017

Worked as MSBI Developer for Logix Health, Bedford-MA

Role : Developer

Duration : April 2017– February 2019

Description:

Logix Health is an ED Coding and Billing Company, which does end to end coding and billing providing full service for millions of ED visits annually in 40 states. In addition to offering a complete ED Revenue cycle management solution, Logix health also provides stand-alone expert coding-only services for both the facility and Professional Components of ED Services. My responsibilities building SSRS reports, make data availability for Power BI using various sources such as, SQL server, SQL Azure, EXCEL and internal Applications.

Environment: SQL Server 2012, Windows Server 2003, SSIS, SSRS, Power BI, Tableau 10.2, TFS, Share point 2013.

Worked as SQL Developer for Harrison Global LLC, Boston-MA

Role : Developer

Duration : February 2016 – February 2017

Description:

Harrison Global (Boston Coach) is a transportation service provider. Worked as a SQL Developer/ Reporting Analyst to provide informed business solutions based on various metrics. My responsibilities include creating dashboards and detailed reporting using Power BI, managing daily SQL DB backups and Restores and ensure the Production availability, Reporting and QA databases.

Environment: SQL Server 2008, Windows Server 2003, SSIS, SSRS, Power BI, TFS, Share point 2013.

Contact this candidate