PAVULURI LAKSHMI KOMALI

Project Description:

MassMutual offers life insurance and investment products in the U.S., and protection products, as well as retirement services, to help you meet your financial goals.

The primary objective of this project is to capture customer data from the sources and maintain customer data for different types of plans, and populate the required customer data for the users in the required format. Extract, transform, and load the data into the Vertica database using Airflow, Jenkins, and TWS jobs, and generate various reports on a daily, monthly, quarterly, and yearly basis. The reports are used for identifying customers, agents, and agencies for various requirements and performance, as well as commission analysis reports for agents and agencies, such as business development managers.

Roles and Responsibilities as an ETL Developer:

• Collaborated closely with product owners and business analysts to gain a thorough understanding of project requirements.
• I have extracted the data from AWS S3 bucket files and database tables, transformed the data using Vertica SQL scripts, and loaded the data into Vertica database tables using airflow scheduling tool.
• Written multiple SQL scripts to load the data into fact/dimension tables as per the business requirements.
• Developed reusable SQL scripts to streamline the data loading process.
• Worked on SQL query optimization to process a massive volume of data in the minimum time frame.
• Created Jenkins jobs and Airflow DAGs using python code for scheduling the ETL-Vertica SQL processes to load the data into relational database tables.
• Working with QA teams to resolve the issues in production and development.
• As a part of Incident Management, I analyzed and provided a Root Cause Analysis document for every ticket given, closing them before they breach.
• For emergency deployments, I worked with the Risk Management team to submit the Change Request with respect to ETL DB tasks.
• I have created ETL SQL script files in GitHub and migrated them by raising a pull request.
• Documenting the issues and solutions identified in the business and data warehouse.
• Documentation, development, and programming.
• Analyzing data and producing reports to assist in analysis and decision-making, to prioritize workload, and to ensure that development and business requirements are met.
• Research and identify data quality issues reported by the end users.
• Taking care of junior resources on the team and assigning tasks to them as per the requests.

• Strong experience in developing and configuring IICS Data Integration components, such as Cloud Mapping Designer, Cloud Mapping Configuration, and Cloud Mapping Validation.
• Understanding the business rules and sourcing the data from multiple source systems using IICS.
• Worked on data integration using IICS.
• Implemented SCD Type 1, Type 2, and incremental mappings to load the data into the DB.
• Worked on replication, synchronization tasks creation.

Description:

• I contribute to the project as an ETL developer.
• I primarily work on business requirements for the data extraction, transformation, and implementation of business logic to load data to staging areas using Informatica PowerCenter.

Roles and Responsibilities:

• Involved in all phases of the SDLC, from requirement gathering, design, development, testing, production, user training, and support for the production environment.
• Developed the mappings, sessions, and workflows using required transformations in the Informatica tool according to technical specifications.
• Performed data manipulations using various Informatica transformations, such as Filter, Expression, Aggregate, Normalizer, Joiner, Router, Sorter, and Union.
• I have developed UNIX shell scripts and created Autosys scheduling jobs.
• Deployed the code in production by creating Change Management requests, with the help of Admin teams.
• Participated in weekly status meetings, updated the JIRA board on time, and completed the assigned stories/tasks on time.