SREEVANI PONUGUPATI E-Mail: acri0h@r.postjobfree.com

Mobile: 704-***-****

Summary

8.5+ years of progressively responsible experience in development, testing, documentation & production support applications using Technologies in Data Stage Architecture and Mainframes.

Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Parallel jobs using Data Stage to populate tables in Data Warehouse

Excellent Experience in Designing, Developing, Documenting, Testing of COBOL programs, Jobs using Mainframe Technologies COBOL, JCL, DB2.

Excellent Experience in Handling SEV1/SEV2 issues and providing the impact analysis.

Extensive experience with data warehouse and OLTP based applications.

Solid experience in using IBM clear case for version management and leveraged same technology for managing versions for UNIX components

Experience in Database Design, Creation and management of Schemas, writing stored procedures, functions, triggers, SQL queries.

Efficient in incorporation of various data sources such as Oracle, DB2, XML and Flat files into the staging area.

Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator

Efficient in developing UNIX shell scripts using for the automation of processes and scheduling the Data Stage jobs using wrappers

Solid experience in building application from scratch and proved my technical capabilities through this opportunities

Solid experience in leading the technical / functional teams and also led the team in building flaw less new applications

Efficient in cross-functional and global environments to manage multiple initiatives and tasks concurrently with effective communication skills.

Efficient in all phases of the development lifecycle, coherent with data cleansing, data conversion, performance tuning and system testing.

Extensive knowledge on enterprise architecture and participated in building strategic applications for Bank of America which are meeting world class business requirements.

Have experience in automating manual processes at project level. This was set as process improvement example at enterprise level.

Excellent knowledge of studying the data dependencies using Metadata stored in the Data Stage Repository.

Have received many delivery excellence awards at project level/ account level and enterprise level.

CERTIFICATIONS

IBM certified Database Associate-DB2 Universal Database Family (DB2 UDB) V8.1

IBM certified Data Stage8.5 developer

Certificate Programme in US Banking Competency

Certificate Programme in Banking Competency

Certificate Programme in Payment Cards Competency

Technical Skills

ETL Tools

:

Data Stage v8.x, Designer, Director and Administrator.

Schedulers

:

AUTOSYS, CA7

Operating Systems

:

Windows 2000/XP/07, Linux/Unix, OS 390

Database

:

Oracle 10g/9i. DB2, MySQL

Tools

:

IBM Data Studio, TOAD, SQL PLUS, IBM Clear case, WINSCP, PUTTY, FileAid, Change man, Maximo, Quality Center, SharePoint, MQ series, TSO SAR, REXX.

Methodologies

:

Star Schema, Snow Flake Schema.

Application Suite

:

MS Office, MS Share Point, Visio

EDUCATION

B.TECH (Bachelor of Technology) from JNTU, Hyderabad, India.

PROFESSIONAL EXPERIENCE

Client : Bank of America

Duration: March 2013 – Present

Role : Sr Technical Analyst / Team lead.

Location: Charlotte, NC.

Project Summary: Websphere Customer Center is based on IBM’s Master Data Management (MDM) product, which is a real time, transactional Customer Data Integration (CDI) software product. It maintains consistency of data and provides a 360-degree view of customer information through the WCC Hub. It is based on open standards and designed to implement with in a Service-Oriented Architecture (SOA). MDM as a product includes over 500+ business services to manage and maintain customer data. MDM provides Integrated Data Quality Management, privacy, security management and flexibility to build composite transactions from existing services.

The main intent of the project is to create the files to vendors and consuming the files from vendors. Currently these files are being processed on mainframes and eventually converted to data stage jobs.

Responsibilities

Involved as primary onshore Team lead and senior technical analyst during the analysis, planning, design, development, and implementation stages of project.

Analyzing the business requirements and system specifications to understand the application.

Created functional and technical specifications for projects. Also, responsible for logical and physical design of database for new projects using Microsoft Visio

Documented ETL test plans, test cases, test scripts, and test results based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Extensively used Parallel Job Stages like Dataset/ Sequential file, Aggregator, Join, Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel, Change Capture, Pivot stage for developing jobs.

Extensively used Data stage, Designer, Administrator, and Director for creating and implementing jobs

Extensively worked on native data base stages like ORACLE/DB2 for extracting and loading the data.

Responsible for scheduling Data Stage ETL batch jobs on a daily, weekly and monthly basis through AUTOSYS

Responsible for developing the batch jobs and migrating the code to upper regions using IBM clear case in all phases of SDLC

Responsible for post implementation warranty for 30 days and responsible for fixing production issues incase of any.

Client : Bank of America

Duration: Jan 20 11 – March 2013

Role : Sr Technical Analyst / Team lead.

Location: Charlotte, NC

Project Summary: This project was developed to integrate all customers to a single data store. Before this was executed customer information for California region was residing in legacy systems and customer information was not centric. As part of this project the applications that were maintaining CA customer were retired and customer information was migrated to new applications

Responsibilities

Involved as primary onshore Team lead and senior technical analyst during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software (Quality Stage v8.5)

Documented ETL test plans, test cases, test scripts, and test results based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Created functional and technical specifications for projects. Also, responsible for logical and physical design of database for new projects using Microsoft Visio

Responsible for converting data from legacy applications (IMS based) to new systems(DB2 based)

Extensively used Parallel Job Stages like Dataset/ Sequential file, Aggregator, Join, Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel, Change Capture, Pivot stage for developing jobs.

Extensively used Data stage, Designer, Administrator, and Director for creating and implementing jobs

Extensively worked on native data base stages like ORACLE/DB2 for extracting and loading the data.

Responsible for scheduling Data Stage ETL batch jobs on a daily, weekly and monthly basis through AUTOSYS

Responsible for developing the batch jobs and migrating the code to upper regions using IBM clear case in all phases of SDLC

Client : Bank of America

Duration: JUL 2009 – JAN 2011

Role : Technical Analyst

Location: Charlotte, NC.

Project Summary: WCC is the Bank of America’s core customer hub for consumers leveraging the IBM WCC product for Customer Data Integration. WCC is a source system of record for Customer Profiles and Customer to Account linkages. The scope of this project is Design and Development of various WCC Application Programming Interfaces for Merrill Lynch Transition to Bank of America.

Responsibilities

Involved as primary Onshore Team member and technical analyst during the analysis, planning, design, development, and implementation stages of project

Documented test plans, test cases, test scripts, and test results based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Analyzing the business requirements and system specifications to understand the application.

Creating High Level Design, Low Level Design, Code development and Deliverables

Review & Recheck the code of team members

Make use of the database utilities for DB2 requirements in the project’s software development life cycle.

Preparing Unit Test Plan, Unit Test Specifications

Simulating the test conditions with the help of tools like FILE-AID.

Verifying the job output using SDSF (Spool Display and Search Facility) or SAR.

Unit testing and Component Integration testing using JCLs.

Extensive interaction with business partners of varying levels within Business Process Management.

Recommending technology solutions that meet business needs and producing functional specifications for business approval.

Performing Incident Management and Business Support by Interacting actively with Infrastructure team, Relationship Managers, IT teams and Business users.

Responsible for Monitoring of Alerts and Performance of the applications.

Providing performance/enhancements Feedbacks on Applications running in Production

Responsible for Process Improvement sessions with the Business Analysts and Application Development teams.

Continuous monitoring of entire production environment and ensure stability at all times

Handling Sev1/Sev2/Sev3 and providing impact analysis.

Meeting project deadlines for Customer satisfaction

Review and Quality Assurance, Production implementation and data load

Client : Citi Cards

Duration: FEB 2006 – JULY 2009

Role : Technical Analyst

Location: Chennai, India.

Project Summary: Citigroup is the first financial services company in the U.S. to bring together banking, insurance, and investments under one umbrella. Its 300,000 employees manage 200 million customer accounts across six continents in more than 100 countries. Citi Cards is the largest provider of credit cards in North America, with more than 100 million customer accounts. In addition to MasterCard- and Visa-branded bankcards, the business includes Affinity and Private Label credit cards as well.

Responsibilities

Involved as primary Offshore Team member and technical analyst during the analysis, planning, design, development, and implementation stages of project

Documented test plans, test cases, test scripts, and test results based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Studying the existing system.

Understanding and Capturing of requirements.

Involved in the preparation of high level/low level design documents.

Involved in the construction of new COBOL programs as per specifications and standards.

Constructing the solution/component.

Reviewing the Code and Unit Test Result at the completion of the requirements.

Involved in the Resolution of technical issues while testing.

Co-ordinating with onsite for the implementation for the Change/Enhancement requests.

Co-ordinating with the clients for getting requirements, reviews, System Test and User Acceptance Test.

Shipping the deliverables to the on-site team.

Conduct technical and process related training sessions for the team.

Handling Pre and Post Implementation support activities for all Major and Minor releases.

Involved in Production support activities.

Contact this candidate