Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

VAMSHI KRISHNA REDDY VANGAPALLY

Hyderabad

Summary

Having 8 years of experience in Information Technology including ETL development using IBM Infosphere DataStage 8.7, 9.1, 11.3, 11.5 & 11.7. Has good exposure to working in SDLC phases. Experience in waterfall methodology and agile methodology. Extensive experience in designing and developing ETL Environments involving various source and target databases like Flat Files, MS Excel files, Teradata, Oracle, and SQL Server. Good experience in understanding the requirements and designing the code. Good Knowledge of Shell Scripting and development on various automation scripts useful in the project. Good understanding of Banking domain standards and terminology. Expertise in implementing complex Business rules in Dataset jobs. Experience in creating BTEQ scripts with complex SQL queries. Ability to handle multiple tasks, projects, and work independently as well as in a team, and communicate with cross-functional teams. Experienced professional with a strong background in technology-related roles. Proficient in software development, system administration, and technical support. Skilled in problem-solving and optimizing performance. Capable of managing projects and collaborating effectively with teams. Committed to continuous learning and staying current with industry trends to contribute to organizational success.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Wipro Limited
Hyderabad
06.2021 - Current
  • Company Overview: Client: Citi Bank
  • Involvement in various requirement gatherings with the Business analyst team
  • Analysing the requirements and coming up with an initial design approach
  • Handling both Development and supporting testing activities
  • Managing the team and pushing them to progress in case of blockers
  • Worked mostly on DataStage, Linux, Teradata SQL, and Oracle Database tools
  • Also worked on Autosys, Jira, Microsoft Excel other various tools
  • Involved in knowledge transfer meetings and close interactions with the team to meet timelines
  • Client: Citi Bank

HSBC Software Development (INDIA) PVT. LTD.
Hyderabad
08.2019 - 05.2021
  • Understanding the requirements & mapping sheet
  • Having discussions with Businesses to understand the requirements
  • Involved in the design of DataStage jobs and, Control M Jobs
  • Writing SQL queries to extract the data from the database
  • Have dealt with multiple stages like Transformer, Sequential file, Lookup, Sort, Join, Copy, Teradata connector, Dataset, Change Data Capture, and surrogate key generator stages
  • Have created the DataStage sequence jobs to control the branch flow of parallel jobs and Unix scripts
  • Have created the Control M Jobs to schedule the DS Jobs as per the run frequency
  • Have prepared the unit test cases, performed testing, and captured the test results
  • Have attended the daily scrum calls & weekly scrum of scrum calls to update the progress of stories
  • JIRA has been updated periodically on the progress of each story
  • Stories, Tasks, Test results, and Defects have been logged in JIRA
  • Code has been deployed using deployment tools Jenkins, GitHub, Control M quality gate & RTC G3

Tata Consultancy Services Limited
Hyderabad
03.2016 - 07.2019
  • Company Overview: Client: Lloyds Banking Group
  • Involved in all phases of SDLC from requirement, design, development, and testing
  • Involved in designing jobs for ETL process using Business rules document
  • Designed multi-instance jobs
  • Sequential file, dataset, transformer, funnel, Aggregator and Join stages have been used in parallel jobs
  • Prepared Unit Test plan and I have done the unit testing for all the designed jobs
  • Have dealt with schema files to import metadata
  • Involving in all the testing phases including Unit testing, System Integration Testing, and User acceptance testing
  • Client: Lloyds Banking Group

Education

Bachelor of Technology - Electronics and Communication Engineering

Keshav Memorial Institute of Technology (JNTU University Hyderabad)
01.2015

HSC -

Narayana Junior College
Hyderabad, Telangana
01.2011

SSC -

Krishnaveni Talent High School
Mancherial, Telangana
01.2009

Skills

  • IBM Infosphere DataStage 87 to 117
  • Teradata
  • Oracle
  • SQL Server
  • PL/SQL
  • IBM Cognos
  • C
  • Python
  • UNIX
  • Putty
  • SSH Tectia
  • Windows
  • Jenkins
  • GitHub
  • Control M
  • Autosys
  • Tivoli Work Scheduler

Certification

  • Certified in company internal certification- Infosphere Datastage 9.1.
  • Certified in company internal certification- SQL Server Basics.

Timeline

Wipro Limited
06.2021 - Current

HSBC Software Development (INDIA) PVT. LTD.
08.2019 - 05.2021

Tata Consultancy Services Limited
03.2016 - 07.2019

Bachelor of Technology - Electronics and Communication Engineering

Keshav Memorial Institute of Technology (JNTU University Hyderabad)

HSC -

Narayana Junior College

SSC -

Krishnaveni Talent High School
VAMSHI KRISHNA REDDY VANGAPALLY