Lavanya Yannam
Summary
Dynamic and detail-oriented DataStage Developer with five years of IT experience in ETL development, production support, and data integration. Strong hands-on expertise in IBM DataStage, SQL, UNIX, Oracle, and scheduling tools like Control-M, and TWS. Proven ability to handle end-to-end ETL workflows, defect analysis, enhancements, deployments, and SLA-driven production support.
Overview
5
5
years of professional experience
Work History
AmeriHealth caritas
Cognizant Technology Solutions
10.2024 - Current
- Enhancement of existing parallel jobs and sequence jobs.
- Perform the deployment activities.
- Extract the reports and share them with the business users.
- Need to create the new objects and fields in DataStage.
- Having a good knowledge of UNIX commands.
- Defect fixing and analyzing the root cause.
- Completed day-to-day duties accurately and efficiently.
- Prioritized and organized tasks to efficiently accomplish service goals.
- Identified needs of customers promptly and efficiently.
USAA(United service automobile association
TATA CONSULTANCY SERVICES
10.2023 - 10.2024
- Creating and executing jobs and transformations for various business scenarios.
- Enhancement of existing parallel jobs and sequence jobs.
- Perform the deployment activities.
- Understanding of DataStage workflows and running the ETLs based on the requirements.
- Created and scheduled the jobs by using the Control-M application.
- Handled tools like Hive and Nifi for monitoring live data streaming.
- Having a good knowledge of UNIX commands.
- Involved in gathering the requirements, designing, and testing.
- Maintenance and support of various schedules and jobs in production, code walkthrough, and review of the same.
- Defect fixing and analyzing the root cause.
Qantas Airlines
TATA CONSULTANCY SERVICES
03.2021 - 10.2023
- Solving tickets based on priority and making sure their SLA is not breached.
- Analyzing and providing quick break fixes in case of any job abort, and handling CRs.
- Developed and maintained ETL processes.
- Datastage Job Scheduling, monitoring tool, and work through the open cases during business hours.
- Executing SQL scripts for making any data corrections and for generating critical/auditing reports based on the requirement.
- Ensured high-quality and efficient data processing.
- Designed and implemented data integration solutions.
- Collaborated with cross-functional teams.
- User requirements. (DML commands, subqueries, all kinds of joins, views, and stored procedures were used.)
- Exceeded customer satisfaction by finding creative solutions to problems.
- Contributed innovative ideas and solutions to enhance team performance and outcomes.
Education
B.Tech - Electronics and communication engineering
A.M. Reddy Memorial College of Engineering And Technology
09-2020
Skills
- DataStage
- UNIX
- SQL
- Snowflake basics
- ServiceNow (ticketing)
- SQL Developer
- TWS
- Control -M
- Windows
- GitLab
Timeline
AmeriHealth caritas
Cognizant Technology Solutions
10.2024 - Current
USAA(United service automobile association
TATA CONSULTANCY SERVICES
10.2023 - 10.2024
Qantas Airlines
TATA CONSULTANCY SERVICES
03.2021 - 10.2023
B.Tech - Electronics and communication engineering
A.M. Reddy Memorial College of Engineering And Technology