Business Analyst/QA

Kavita Majji

Cell # 704-***-****

*****.******@*****.***

Experience Summary

7+ years of experience in IT involving Business Analysis, Software Applications Development and migration on IBM Mainframes.

Working experience in both development and support projects at offshore and onshore.

Experience in Full Cycle of Software Development including Requirement Analysis, System study, Program Design, Development, Unit testing, System Testing, Integration Testing, System Maintenance, Support and Documentation

Proficiency in design of system inputs, outputs, edits and control including file structures, reports.

Have good 7 years working experience in developing, modifying and debugging complex SQLs.

Have good working experience in DB2 and TERADATA.

Expertise in Mainframe Technologies likes COBOL, JCL, DB2, VSAM, CICS and REXX.

Have good working experience as a Senior Business Analyst.

Having Good Knowledge in using DB2 and Teradata Utilities to Load the data to tables from Flat flies and Unload data from tables to Flat files.

Having Extensive experience in debugging the Batch and Online Programs (DB2) using Xpeditor.

Having good Experience in File-Aid, Change Man CA Librarian, Alchemist and Endeavor.

Sound knowledge in using IBM utilities like SYNCSORT, DFSORT, IEBGENER and IDCAMS etc.

Experienced in Analysis, Design, Coding, Testing, Implementation and knowledge transfer activities

Testing skills include performing regression, conceptual testing, integration, volume and stress testing as well as development, execution, maintenance of test plans, test specifications and test scenarios

Experience in applying Software Engineering Paradigms, designing SDLC and developing mini and major projects right from analysis phase through to implementation.

Extensive experience in working with users to review the results and examine any changes or additions to the project before installation and deployment.

Good understanding in the use of Network Data Mover (NDM) and Connect Direct.

Expertise in using file transfer methods such as FTP/Secure FTP

Knowledge in scheduling batch jobs thru CA7 and TWS/OPC Scheduler.

Technology

Operating Systems / Environment Software Products Databases Tools

TSO/ISPF,

MVS,

Z/OS,

OS/390,

COBOL,

CICS,

JCL,

REXX,

ISPF,

ASSYST,

Mercury Test Director,

VSS DB2, SQL,

VSAM,

TERADATA XPEDITOR,

CHANGEMAN,

ENDEAVOR,

CA7 Scheduler,

Teradata SQL Assistant,

FILE-AID,

ABEND-AID,

RACF,

ALCHEMIST,

TWS/OPC Scheduler,

QMF,

SDF,

SPUFI,

DB2I,

SYNCSORT,

IDCAMS & MVS Utilities

Line of Business

§ Banking Services

Customer knowledge and decision support activities

Deposits

§ Insurance Services.

Financial Application

Property and Casualty insurance product lines

Business functions including policy management, ratings, claims and billing

Qualifications

Degree and Date Institute Major and Specialization

Bachelor of Technology (2000-2004) Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh, India Electronics and Communication Engineering

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Project: Data Warehouse Resource Pool

Customer: Bank of America, USA

Period: June 2011 - till date

Description:

The project objective is to provide Development, Maintenance and enhancements to the Data Warehouse ‘The W’ of CK&DS division of Bank of America. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities. The main objective of the Warehouse is to help the bank in decision & strategy making process.

Data warehousing is a foundational practice that supports enterprise reporting, business intelligence and decision support. Data warehouses and data marts are created across levels of sophistication and different philosophical approaches, but typically involve extracting and transforming data from operational or transactional databases and loading it to a repository for shared use and analysis.

The project involves development and support of the legacy data loads to the Bank’s data warehouse aka ‘The W”. The W is built on Teradata database with 640 TB of disk space. It receives data feed from all the operational systems across the bank.

Role: Sr. Business Analyst

Operating System: Z/OS, TSO ISPF

Languages: SQL

Databases: TERADATA

Tools: Teradata SQL assistant, BOA internal tools

Responsibilities:

Discussing with Users to get the knowledge on the business requirement.

Analysis on the impact of the change requirement on the deposits application.

Coordinating with the DBA, Onshore lead, TDM to document the requirements to HLD.

Providing all the detailed requirements to the onshore lead and conducting timely meetings.

Coordinating with the other applications and interface contacts when required.

Coordinating the test environment setups along with the DBA and the onshore coordinators.

Creating the SIT test plan and approving the test results.

Project: Data Warehouse Resource Pool

Customer: Bank of America, USA

Period: Mar 2010 - Feb 2011

Description:

The project objective is to provide Development, Maintenance and enhancements to the Data Warehouse ‘The W’ of CK&DS division of Bank of America. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities. The main objective of the Warehouse is to help the bank in decision & strategy making process.

Data warehousing is a foundational practice that supports enterprise reporting, business intelligence and decision support. Data warehouses and data marts are created across levels of sophistication and different philosophical approaches, but typically involve extracting and transforming data from operational or transactional databases and loading it to a repository for shared use and analysis.

The project involves development and support of the legacy data loads to the Bank’s data warehouse aka ‘The W”. The W is built on Teradata database with 640 TB of disk space. It receives data feed from all the operational systems across the bank.

Project involves converting and migrating the monthly privilege applications to weekly and daily processes to improve the decision support activities.

Role: Sr. Developer

Operating System: Z/OS, TSO ISPF

Languages: COBOL, JCL, SQL

Databases: TERADATA

Tools: CA7 Scheduler, NDM (Connect : Direct), Xpeditor, Changeman, File-Aid, SDF, Abend-aid, Teradata SQL assistant

Responsibilities:

Coordinating with Onshore team to get the complete understanding on the initiatives.

Discussing with Users and Business Analysts to get the knowledge on the business requirement.

Analysis on the impact of the change requirement.

Development, testing and implementation of application enhancements

Preparing new SQLs with high performance and get it approved from the CAB team.

Analyzing the impact on the downstream Applications.

Coordinating on the changes and testing with the other applications whenever required.

Coordinating with the DBA on the table and space requirements in production and test regions.

Preparing Technical Design Documents and Test Plans.

Unit Testing & System Integration Testing

Coordinating on getting the required space for the new database or tables in production.

Getting the new tables created in production on time with proper required access rights.

Creating CA7 forms to change the Schedule for the New JCL’s.

Reviewing Changeman Package and their components

Providing Batch Production Support and fixing the production Abends during the warranty

Project: Financial Application Services

Customer: AVIVA Insurance, UK

Period: May 2008 - Feb 2010

Description:

AVIVA is one of the largest insurance companies in the United Kingdom. Financial Application System is a HUB which maintains applications such as Automated Banking and Cashbook Update system (ABACUS), Bankers Automated Clearing system (BACS), Check Production, Debit/Credit card systems, Payment Preparation, Aviva Payroll etc.

The project involves providing BAU support and Application Development and Maintenance activities related to the above applications.

The system is highly critical in terms of business as it deals with the flow of cash in and out of business units. Finance data currently is scattered onto many systems causing synchronization issues. Single insurance platform is being establish to migrate all the finance data onto a common single database. It is a ongoing project for 3 years duration started from Mar2008.

Role: Analyst / Tech Lead

Operating System: OS/390, TSO ISPF

Languages: COBOL, JCL, CICS, REXX, SQL

Databases: VSAM, DB2, IMS

Tools: OPC/TWS Scheduler, FTP, Xpeditor, Alchemist, File-Aid, SPUFI, SDF, Abend-aid, Assyst, Mercury Test Director

Responsibilities:

Coordinating with Clients for requirement gathering and to take any change request related decisions.

Co-ordinate with onshore development project coordinator

Perform Initial high level analysis to provide the high level design for the further phases of the change request.

Creating estimations & delivery plan and assignment of work. Monitoring the progress of the work.

Ensure relevant reviews are performed with respect to all the deliverables like System Design, System Test plans, UAT Plans, Release Plans etc.

Coordinating the implementation activities with client, onshore and offshore.

Status Reporting

Co-ordinate with onsite or client in resolving issues or solving critical tasks.

Involved in quality processes like documentation review, code review, and creation and updating the project system Documentation.

Involving in the development and testing of the change requests.

Suggesting the process improvements and executing the same.

Co-ordinating with the upstream and downstream applications when ever required.

Providing Batch Production Support and fixing the production Abends.

Co-ordinating with offshore by distributing the work requests to them.

Allocating work to the offshore team based on priorities and severities

Providing technical leadership and guidance to the offshore team

Training and Mentoring the new comers as well as the existing Team members

Involved in quality processes like documentation review, code review, and creation of CPI (Composite Productivity Index) matrix

Project: Norwich Union Insurance - HUON

Customer: AVIVA Insurance, UK

Period: Aug 2006 - May 2008

Description:

HUON 4.11a is a Package supplied by TIG (The Innovation Group) Company. This package is used mainly in property and causality insurance and financial services industries. The transactions Quote creation, New business, Endorsement, Renewals, Cancellation, Re-Instatement and Schedule print are the part of the Policy underwriting system. Claims activities are from creation to Commit payment (close of claim) can be performed through claim Management system.

The project involves Support, Maintenance and Enhancement of HUON system. The support activity involves data migration, analysis of corrupted data, and correction of the corrupted data and fixing of production related issues. Enhancement activities include requirement analysis, coding, testing and implementation of requirements to the satisfaction of the client.

Role: Tech Lead / Onsite Co-ordinator

Operating System: OS/390, TSO ISPF

Languages: COBOL, JCL, CICS, REXX, SQL

Databases: VSAM, DB2, IMS

Tools: OPC/TWS Scheduler, FTP, Xpeditor, Alchemist, File-Aid, SPUFI, SDF, Abend-aid, Assyst, Mercury Test Director

Responsibilities:

Getting the detailed requirements from the client for the change requests.

Providing estimations for requests received

Development, testing and implementation of application enhancements

Analysis of the error requests and change requests.

Preparing the technical specifications and getting it reviewed by the business people.

Coding and preparing the unit test plans.

Performing the unit testing.

Fixing bugs during all phases of testing and in production.

Providing the HUON data to the Business as per the urgency and the priorities

Allocating work to the offshore team based on priorities and severities

Monitoring the incidents reported in the assist queue and allocating the work to the team based on the severity

Involved in quality processes like documentation review, code review, and creation and updating the project system Documentation

Providing Overnight and weekend support for the batch abends as well as online related problems for the Huon system

Giving permanent fixes wherever possible to avoid future similar abends

Arranging the daily/weekly calls with client and offshore based on the change complexity.

Attending the business health check calls.

Project: United Health Group (UHG) CPR2

Customer: United Health Group, USA

Period: Jan 2005 - Jul 2006

Description:

Claim Processing Remediation and Re-architecture (CPR2) is an initiative where we redesign the whole claims processing system of the client. We are migrating there system from the old VSAM mode to DB2. Till date four files have been successfully migrated to DB2 and running in Dual mode (VSAM, DB2).

Role: Developer

Operating System: OS/390, TSO ISPF

Languages: COBOL, JCL, CICS, REXX, SQL

Databases: DB2, VSAM

Tools: Xpeditor, File-Aid, Endevor, TWS/OPC, Abend-aid

Responsibilities:

Understanding the Business Requirement for the proposed enhancement

Participating in the requirement meetings with clients to understand the design well

Prepare the understanding document, Develop a high-level flow for the design

Coordinating with the System Analyst in preparing the Detailed System Specification

Review the Technical Specification, Coding, Unit Test plan

Support during the testing Phases of the project

Working on fixing Regression Defects, System Testing Defects, UAT(User Acceptance Testing) Defects

Contact this candidate