Data Engineer Ms Sql
Resume:
Swetha Vudugu
*********@*****.***
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