Sudha Thudi
Hyderabad
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
9
9
years of professional experience
Work History
Data Analyst/Engineer
Forey Soft
07.2024 - 10.2024
- Initiated Data analysis and started involving in Migration activities to migrate Data from on premise to Azure
- Worked on improving the performance of Informatica Jobs by using Various ETL performance technique’s like using lookups instead of Join’s , Using Flat files instead of Relational Objects, Utilizing Explain plan, DB load utilities and Orchestration techniques.
- Prepared the test cases and test criteria for the developed ETL flows.
- Preparation of various documents like design and testing documents to ensure that the technical logic implemented in various Taskflows is clearly understood by everyone
- Implementation checklists while promoting to testing and production.
- Involved in the preparation of detail design document.
- Developing generic IICS Taskflows.
- Perform Transformation and Validation Process.
- Involved in Unit Testing, Documented Test Cases for each Taskflow.
- Involving Peers code review.
- AIG Insurance (American International Group) is one of the largest and most well-known insurance companies in the world. AIG providing a wide range of insurance products and services for individuals, businesses, and organizations and specializes on property casualty insurance along with other financial services.
- Environment: IICS, Informatica Power Center 10.1, Snowflake, Oracle, Fat Files, ADF pipelines, Linux, Windows, Control-M, Azure synapse, Azure storage explorer.
Senior Consultant
Joules to Watts
10.2023 - 01.2024
- Involved Development and Application support.
- Identify/implement enhancements to existing Taskflows/projects to meet the Business requirements.
- Minor enhancements to the Mappings as per requirements.
- Identify root cause for issues and identify workarounds for production issues.
- Performing Code analysis to Migrate into IICS.
- Development of IICS Tasks and mappings by using various components.
- Involved in migrating the Mappings, Workflows across environments.
- Blue Shield of California is a mutual benefit corporation and health plan founded in 1939 by the California Medical Association. It is based in Oakland, California, and serves 4.5 million health plan members and more than 65,000 physicians across the state.
- Environment: IICS, Informatica Power Center 10.1, Oracle, Fat Files, Linux, Windows, Control-M, Azure synapse, Azure storage explorer.
Consultant
Tetrasoft India Pvt.Ltd
09.2022 - 10.2023
- Being an ETL consultant extensively worked on On-Premise Data migration activities and migrated 18 applications from Netezza to Azure Synapse (SQL Datawarehouse).
- Limited experience in Migration of Data onto Snowflake
- Built ADF pipelines and IICS tasks as part of Data migration.
- Expertise configuring and creating ADF/SSIS solutions for ETL and business intelligence process for data integration and migration services.
- Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using ADF/SSIS.
- Developed, deployed, and monitored IICS/Azure ADF Packages for new ETL Processes and upgraded the existing IICS tasks to Azure ADF for the on-going ETL Processes.
- Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
- Responsible for Dimensional modeling. Defined relationships between Dimensions and Measure groups.
- Created the data source views and defined granularity within a measure group and drill through actions.
- Responsible for identifying and defining Data Source and Data Source views mappings for ETL
- Working for one of the largest publicly traded property and casualty insurance company Called Chubb, serving consumers and companies of all sizes with traditional and specialty insurance products and industry-leading claims and risk engineering services.
- Environment: IICS, Informatica Power Center 10.1/9.6, SQL Server, Fat Files, UNIX, MS VISIO, Robot scheduler, ADF, Azure synapse, Azure storage explorer
Production Support Analyst
Liberty Mutual Insurance
01.2019 - 07.2019
- Responsible for maintaining proper quality standards in deliverables, version control, defect tracker, error log, and Major Business and Operations Support.
- Involved in Solving Priority 2 Business Incidents and Maintaining and supporting the production on a Full Cycle basis.
- Experience in trouble shooting IICS Task flows, Synchronisation and Replication Tasks
- Handled Code enhancements for the IICS
- Involved in migration and testing of applications during software/hardware environment upgrades.
- Monitoring daily runs of jobs on ESP (scheduling tool) and UNIX environment.
- Batch job support (24x7) including Month End, Quarter End, and Year-End Support.
- Performed various transformation logics by utilizing the Source Qualifier, expression, filter, joiner, lookup, router, and Update Strategy.
- Having experience in Dimensional Data Modeling using Data modeling, Star /Snowflake Schema modeling, FACT & Dimensions tables, and Physical & logical data modeling.
- Deploy Informatica Objects into TEST, UAT Environments.
- Involved in the development of Informatica Mappings, Mapplets, and Workflows for Complex Business Rules
- Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
- PI DATAMART is responsible for delivering standardized reports and data with business rules applied and provides business intelligence that helps to make the business decisions to retain customer Advocacy on its desired growth path. CPI is responsible for critical business decisions based on the data provided by the OLAP tools like Business Objects and This DATAMART is built based on Informatica8.6 and Teradata.
- Environment: IICS, Informatica Power Center 10.1/9.6, SQL Server, Fat Files, UNIX, MS VISIO, Robot scheduler, ADF, Azure synapse, Azure storage explorer
Informatica Developer
Statefarm
11.2015 - 12.2018
- Developed ETL programs using Informatica to implement the business requirements, Using the Agile Scrum Model.
- Communicated with business customers to discuss issues and requirements.
- Created shell scripts to fine-tune the ETL flow of the Informatica workflows.
- Redesigned Existing ETL flow with Linux Scripting.
- Used Informatica file watch events to pole the FTP sites for the external mainframe files.
- Production Support has been done as part of the ELS period to resolve the ongoing issues and troubleshoot the deployment problems.
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections, and relational connections.
- Involved in enhancements and maintenance activities of the data warehouse including tuning, and modifying stored procedures for code enhancements.
- Worked in Informatica version-based environment and used deployment groups to migrate the objects.
- Used debugger in identifying bugs in existing mappings by analyzing data flow, and evaluating transformations.
- Effectively worked on Onsite and Offshore work models.
- Pre and post-session assignment variables were used to pass the variable values from one session to another.
- Designed workflows with many sessions with the decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
- Reviewed and analyzed functional requirements, mapping documents, problem-solving, and troubleshooting.
- Performed unit testing at various levels of the ETL and was actively involved in team code reviews.
- Fixed the invalid mappings and troubleshoot the technical problems of the database.
- Environment: Informatica Power Center 10.1/9.6, Web Services, DB2, SQL Server, XML, Fat Files, WinSCP, UNIX , Windows MS VISIO, Control-M, Quality Center
Education
Btech - Engineering
Osmania University
Hyderabad, India 04.2001 -
Skills
Around 6 years of IT experience with a strong background in SDLC, Data Integration tools including Informatica Power Center
Having 39 Years of Onsite experience with Accenture with Payroll company as Global Infotech Inc
Currently working with Joules to Watts as a consultant
Expertise in IICS, Informatica Power Center 10x/9x & Azure Synapse, Netezza, SQL Server and DB2 databases
Extensive experience in Extraction, Transformation and loading of data using Informatica and DB2 Utilities from heterogeneous sources
Involved in Data and ETL code Migration from on premise to Azure and Snowflake
Hand on building ADF pipelines as part of building ETL programs
Extensive Experience in resolving Cloud Data Migration Data and Code Issues
Performed ETL activities with the help of DB2 Utilities and shell scripting by redesigning existing Informatica Mappings and Workflows
Involved in Application Migration from SQL Server to DB2 including Data Archival and Database Migration
Extensive experience with Insurance and Banking Domains
Experience working in an Agile/Scrum environment
Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support, and, prepare dimensional data models
Good understanding of Dimensional data modeling like Star and Snowflake schemas
Organized Group sessions to discuss complex business requirements, design sessions, code reviews, and troubleshooting issues
Extensively worked in the development of Informatica Mappings and Informatica Workflows
Involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management, and parallel threading
Timeline
Data Analyst/Engineer
Forey Soft
07.2024 - 10.2024
Senior Consultant
Joules to Watts
10.2023 - 01.2024
Consultant
Tetrasoft India Pvt.Ltd
09.2022 - 10.2023
Production Support Analyst
Liberty Mutual Insurance
01.2019 - 07.2019
Informatica Developer
Statefarm
11.2015 - 12.2018
Btech - Engineering
Osmania University
04.2001 -