Sowjanya Merugu
Hyderabad,Telangana
Summary
Having 10+ years of IT experience in using Microsoft SQL Server 2012/2014/2016/2019/2022, for Database Design, Business Intelligence, and Database Back-end Development. Substantial experience in Microsoft and other BI Technologies; SQL Server, SSIS, SSRS, SSAS and Azure Data factory (ADF), ADLS (Azure Data lake Services). Having good knowledge on building reports from SSRS, Power BI. Worked with organizations in different fields mainly Product,Audit, Healthcare and Integration experience. Having experience on Technical design and estimations on requirements. Strong analytical and problem-solving skills combined with excellent verbal and inter-personnel, communication, documentation, skills including the ability to quickly adopt the nature of work. Interested to learn new technologies and implement them to have hands-on experience. Working as Database Migration Lead with team size 4 using Azure Data factory.
Overview
12
12
years of professional experience
Work History
Database Migration Lead
Tata Consultancy Services
01.2024
- Working as Database Migration Lead with team size 4 using Azure Data factory.
Team Lead
Tata Consultancy Services
04.2020 - 06.2023
- Working on European country Legacy system Migration to Target system
- Involved nearly 17 countries, where all of them want to migrate their Legacy data to new system.
Team Lead
Tata Consultancy Services
01.2020 - 04.2020
- Working on HAYS Recruitment System
- Responsible for Scrum Planning, leading Client Calls
- Used SSIS for building packages and created Jobs to schedule the packages, from the DB data working on new SSRS reports and optimization of Existing Reports and created Power BI reports for analyzing the business.
Developer
Tata Consultancy Services
10.2017 - 04.2019
- Working on TROJAN - Tax project
- Data dump using SSIS packages and used SSRS and Power BI along with SQL server for data analytics.
Developer
Tata Consultancy Services
10.2016 - 10.2017
- Working on Canvas Remediation project
- Building database warehouse using normalizations, developing cube structure using Star schema or Snowflake schema under SSAS.
Developer
Tata Consultancy Services
03.2015 - 10.2016
- Working on Global Independence System (GIS) project
- Analyzing the requirement document and estimating the completion dates on each requirement.
Software Engineer
Tech Mahindra
07.2014 - 02.2015
- Working on Nokia Integration project
- Developing integration packages (SSIS) and Reports (SSRS) using business intelligence tools for the requirements given in BRD document.
Developer
Tata Consultancy Services
01.2014 - 05.2014
- Working on Nokia Integration project
- Developing integration packages (SSIS) and Reports (SSRS) using business intelligence tools for the requirements given in BRD document.
Team Member
Tech Mahindra
01.2014 - 05.2014
- Working on Blue Cross and Blue Shield Organization project
- Creating SSIS Batch jobs for getting data into database from various data sources provided by insurance system.
Team Member
Tech Mahindra
06.2011 - 01.2014
- Working on OEMA 3.0 project
- Actively participated in understanding the client business for designing the SSIS job flow architecture.
Education
Bachelor of Technology - Computer Science Engineering
Andra University - 78.5%
06.2010
Skills
- SSIS, SSRS, SSAS(Basics), Power BI, ADF (Azure Data Factory)
- SQL, TSQL, MDX, VB Script for trouble shooting Packages
- Windows XP, Windows 7, Windows 8,Windows 11
- MS SQL Server 2012/2014/2016/2019/2022
- ETL development,Business Analysis,Data Validation and Performance Tuning
Databasedesigndevelopment
Working as Database Migration lead from Legacy systems to Destination Database. Strong hands on experience in SQL. Ability to write complex SQL queries without using any query generation tools. Strong in SQL basics. Strong in MDX basics. Strong understanding of SQL Server, plus experience developing in SSIS. Solid development experience with SSIS. Excellent T-SQL programming skills in constructing Tables, Triggers, User Function, Views, User Profiles and Relational Database Models. Excellent understanding of Relational Database Systems, Logical/Physical Data Modeling, Normalization, and Data Warehousing. Good understanding of Normalization and De-Normalization concept for faster query retrieval. SQL 2012/2016/2019 MSFT Team Foundation Server 2010/2012, MSFT Visual Studio 2016/2019/2019. Good understanding of Database Architecture concepts related to Pages, Database Design and Development in SQL server 2012/2016/2019 system in OLTP environment.
Timeline
Database Migration Lead
Tata Consultancy Services
01.2024
Team Lead
Tata Consultancy Services
04.2020 - 06.2023
Team Lead
Tata Consultancy Services
01.2020 - 04.2020
Developer
Tata Consultancy Services
10.2017 - 04.2019
Developer
Tata Consultancy Services
10.2016 - 10.2017
Developer
Tata Consultancy Services
03.2015 - 10.2016
Software Engineer
Tech Mahindra
07.2014 - 02.2015
Developer
Tata Consultancy Services
01.2014 - 05.2014
Team Member
Tech Mahindra
01.2014 - 05.2014
Team Member
Tech Mahindra
06.2011 - 01.2014
Bachelor of Technology - Computer Science Engineering
Andra University - 78.5%
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Katamneni SrinivasaraoKatamneni Srinivasarao
Head Operations Manager at SUBWAY®RestaurantsHead Operations Manager at SUBWAY®Restaurants