Summary

• Over 9 years of Professional IT experience in Banking Financial industry, Design, Development, Testing and Implementation of various software applications.
• Good Experience in developing application software on the IBM Mainframes using COBOL, DB2, EAZYTRIEVE, JCL.
• Experience in project planning activities such as Scope Definition, Project plans, Business Case, WBS and Project Change Control.
• Was instrumental in winning the SPX Statements and Pricing contract from the competitor. This earned a team of 11 at onshore and 55 at offshore.
• Experience in using different development Utilities/Tools like DataStage Designer/Director, QT-ODBC, File-aid for DB2, QMF, DB2I, Platinum, Clear Case, CHANGEMAN, SDSF, SAR, SORT, FILA, Quality Center and CA7 scheduler.
• Started the process of documenting the existing and proposed systems in lucid, business language which was appreciated by the non technical clients and was made a best practice from then on.
• Excellent experience as an Application Developer in Banking Financial industry for Bank of America in developing software application using DataStage and Mainframe.
• Experience with Data Extraction, Transformation, and Loading ETL from different Data sources like DB2, Flat files, COBOL files using DataStage.
• Experience in managing complex IT projects through full Software Development Life Cycle
• Created and maintained project schedules by identifying and monitoring the overall project timeline, project milestones, tasks, resources, ETAs and task dependencies.
• Preparing/reviewing Business requirement document BRD and other project related documents taking into account the Assumptions, Risks, Constraints and the in-scope and out-of-scope aspects.
• Problem identification and analysis, proactively identifying and avoiding Risks from materializing.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Position: Business Analyst/Project Manager

• Enterprise Service Development deals with the creation of re-usable services that can re-used across all the SOA platforms. It serves as middleware for almost all the systems in the Bank. This project involves development of loosely coupled SVB enterprise services for application integration using Oracle SOA Suite. The EIB platform provides support to standard protocols like HTTP and SOAP for messaging between service clients and business services.
• The project works on Agile methodology and runs four week sprints. EIB works across the verticals and all the teams are considered the customers for EIB.

Responsibilities:

As Business Analyst:

• Gather customer requirements by interacting with the clients and create the Service Specification Document SSD .
• Facilitating SSD reviews with the requestors, the Tech Lead, the Solution Architect, the Project Manager, the Development team and the testing team so that all are on the same page.
• Create data mapping documents after looking into the source target file layouts, data dictionary, and file specification documents provided by external processors.
• Define source and target record names, field names, field length, field description and list of rules.
• Work with the End users to gather Requirements and convert them to functional specifications and help the Developers to translate those into technical requirements.
• Create scope statements, use case documents, user stories, process flows and various other project artifacts.
• Conduct Joint Application Development JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Making sure all approvals are obtained and that the documentation is in place by the end of the sprint.
• Reviewing the Test Strategy and Test Summary Reports.
• Conducting workshops with the relevant stakeholders and articulate As-Is and To-Be Model.
• Perform Requirement Analysis of the different attributes in order to help designers and developers build an effective customer platform.
• Working under constantly changing environment with new and modified requirements as this is Agile and facilitating effective, defect free deliveries.
• Identifying the business logic involved in the Product Model and making changes to the related Service Specification Document based on the flows.
• Application design review for various projects that impact the application.
• Facilitating Architecture Reviews, Integration and User Acceptance Testing.
• Collection and Integration of Information from Multiple Lines of Businesses.
• Update the clients and the in house managers about the status through regular status reports.
• Conducting Governance meetings to receive and look through the new service requests.
• Creation of the monthly dashboard and newsletter for the senior management.
• Facilitating the daily scrum meeting Daily Standup meeting to review the team's progress and resolve roadblocks.
• Creation of the Sprint Backlog Sheet for each sprint.
• Deciding what services can be accommodated in that sprint based on the urgency and the team's capacity.
• Conducting the Kickoff meeting every month to plan for the services for that sprint.
• Conducting the Debrief meeting every month to close the sprint formally and to know three things: What went well What went wrong What can be improved
• Resource and Effort Estimation and Allocation.
• Balancing the Financials and making sure that the income is more than the expenses.
• Maintaining the Checkbook.
• Estimating the effort, negotiating with the requestors and sending the Chargeback to the requestors.
• Closely work with onshore to drive technical solutions and design as well as to provide development estimates for schedule and effort.
• Co-ordinate with cross functional teams to identify and resolve issues.
• Providing resources for Production release planning, coordination implementation support.

Environment: DB2, SQL, IBM Infosphere DataStage V8.5, MS-VISIO, JCL, SORT, Easytrieve, CA7

Confidential

Position: Senior Business Analyst

Responsibilities:

• Effective communication of the requirements between all the relevant stakeholders to avoid ambiguity and to ensure smooth progress in all the stages of the project.
• Understanding the project requirements and specifications by going through the BRD.
• Project Planning, Resource and Effort Estimation and Allocation for new enhancements.
• Facilitating the definition of project scope, goals and deliverables during every phase.
• Coordinating with the clients regarding the business requirements and impacts.
• Identifying risks proactively and performing risk analysis and management.
• Monitor and review project status periodically and present status reports to the key stake holders on daily, weekly and monthly basis.
• Coordinating meetings between required stakeholders, as and when needed.
• Support the team's Co-ordination with the end-point applications teams during the testing phase.
• Reviewing Gap Analysis.
• Working under constantly changing environment with new and modified requirements and facilitating effective, defect free deliveries.
• Conducting sessions and resolving queries on the Business Processes for the teams involved.
• Application design review for various projects that impact the application.
• Facilitating Integration and User Acceptance Testing.
• Production release planning, coordination implementation support for integrated release.

Environment: IBM Infosphere Datastage V8.1, MS-VISIO, Autosys, QT-ODBC, MS Office Tools

Confidential

Position: Business Analyst

• Statements Pricing application is a source system for multiple services like Combined Statement, Relationship pricing/Packages offered by the bank. Combined Statement is a service that combines more than one account into a single statement. Relationship Pricing/Packages is a service that links one or more accounts together to waive Monthly Maintenance Fee MMF on the primary account. SPX records these linkage structures via DB2 stored procedure/Web service request from different banking channels and feeds other batch systems like statement notification engine. SPX also services the retrieval/maintenance of the stored information for different banking channels. The application is built with good flexibility by defining the business eligibility rules in code tables and identifies what products can be linked in a service. The application is designed with two identical data centers DB2 Q replication enabled as part of business strategy for business continuity, fail over/fall back, disaster recovery.
• Confidential Conversion:The goals of this initiative was to convert the Statements and Pricing Data from the California state. This project was critical since California had the wealthiest clients and we had penalty clauses on this project. All the data from these systems had to be analyzed to see if they are in accordance with the SPX rules. If yes, the linkages had to be formed and if not the linkages had to be dropped. The volume of this conversions was about 68 million. A major part of my design for the NW conversion was used for this project.

Responsibilities:

As Business Analyst:

• Gather customer requirements by interacting with the clients and prepare the Business Requirements Document BRD .
• Understand project objectives and analyze the requirements to translate into functional specifications.
• Conducting workshops with the relevant stakeholders and articulate As-Is and To-Be Model.
• Effective communication of the requirements between all the relevant stakeholders to avoid ambiguity and to ensure smooth progress in all the stages of the project.
• Perform Gap Analysis of the requirements to achieve consistency across multiple stakeholders' requirements.
• Perform Requirement Analysis of the different attributes in order to help designers and developers build an effective customer platform.
• Working under constantly changing environment with new and modified requirements and facilitating effective, defect free deliveries.
• Designing process flow diagrams and use cases to be used by the development team.
• Prepare Traceability Matrix from Business Requirements.
• Conducting sessions and resolving queries on the Business Processes for the teams involved.
• Interacting with the Technical team to understand the existing system functionality.
• Identifying the business logic involved in the Product Model and making changes to the related Business Requirements Document based on the flows.
• Application design review for various projects that impact the application.
• Providing resolution for functionality related defects raised by testing team and verifying the results.
• Facilitating Integration and User Acceptance Testing.
• Doing casual analysis for all the defects and providing/verifying the resolution for the same.
• Doing Project Management Activities like Resource and Effort Estimation and Allocation.
• Collection and Integration of Information from Multiple Lines of Businesses.
• Update the clients and the in house managers about the status through regular status reports.

• Closely work with onshore to drive technical solutions and design as well as to provide development estimates for schedule and effort.
• Co-ordinate with cross functional teams to execute the project deliverables.
• Co-ordinate with onshore for build, Unit testing Component integration testing.
• Design and develop test scripts for System Integration Testing.
• Execution of System Integration Testing scripts.
• Triaging/tracking of any Integration defects defining resolution.
• Production release planning, coordination implementation support.

Environment: DB2, SQL, IBM Infosphere DataStage V8.5, MS-VISIO, JCL, SORT, Easytrieve, CA7

Confidential

Position: Business Analyst

Confidential Conversions:

The goals of these initiatives were to convert the Statements and Pricing Data from the Merrill Lynch Bank as well as from the Washington and Idaho states. All the data from these systems had to be analyzed to see if they are in accordance with the SPX rules. If yes, the linkages had to be formed and if not the linkages had to be dropped. The volume of these conversions was about 33 million.

Responsibilities:

• Gather business requirements by interacting with Business Analyst team and analyze the requirements to translate into technical specifications.
• Closely work with clients to drive technical solutions and design as well as to provide development estimates for schedule and effort.
• Co-ordinate with cross functional teams to execute the project deliverables.
• Co-ordinate with offshore for build, Unit testing Component integration testing.
• Design and develop test scripts for System Integration Testing.
• Execution of System Integration Testing scripts.
• Triaging/tracking of any Integration defects defining resolution.
• Production release planning, coordination implementation support.

Environment: DB2, SQL, IBM Infosphere DataStage V8.5, IBM Websphere, JCL, SORT, Easytrieve, CA7

Confidential

Position: Business Analyst

Responsibilities:

• Preparation of HLD, LLD and their reviews.
• Reviewing and co-ordination of build activities.
• Reviewing unit test and system test specifications.
• Component Integration Testing, System Integration testing and supporting stress testing.
• Dress Rehearsal planning and execution.
• Production release coordination Implementation support.
• Coordination of delivery activities from onshore.
• Analyzing for any scope of improvement in Batch or real-time programs, extracts/unloads and stored procedures and optimizing the process.
• Documentation of production support related procedures, tips and best practices.

Environment: DB2, SQL, zOS, COBOL, MQ series, JCL, SORT, Easytrieve, CA7, NDM.

Confidential

Position: Business Analyst

• Banking Online Support Systems is considered to be the backbone of Bank of America. It contains Customer, Account and Address data in three separate IMS databases. It provides data to the front end systems through online. It receives data directly from the tellers and also updates the IMPACS which is the complete financial system of BOA. Have involved in the following initiative for BOSS.
• Mortgage Integration: The Confidential/ Countrywide Financial CFC merger involved many projects to merge the Countrywide Customer information systems into the Bank of America Customer information systems. Mortgage Integration is one of key projects under the consumer platform. The goal of this project is to build out part of the integration of CFC servicing platform to BAC enterprise applications and infrastructure.

Responsibilities:

• Preparation of HLD, LLD and their reviews.
• Coding, reviewing and co-ordination of build activities.
• Preparing unit test and system test specifications.
• Unit testing, Component Integration Testing, System Integration testing and supporting stress testing.
• Dress Rehearsal planning and execution.
• Production release coordination Implementation support.
• Coordination of delivery activities from offshore.
• Analyzing for any scope of improvement in Batch or real-time programs, extracts/unloads and stored procedures and optimizing the process.
• Documentation of production support related procedures, tips and best practices.

Environment: DB2, IMS, HOGAN, zOS, COBOL, JCL, SORT, Easytrieve, CA7, NDM

Confidential

Position: Business Analyst

Confidential

The Retail and Travel Solution Center has projects for which internal quality assurance and assessments have to be done. British Airways and Quantas from Travel domain and Woolworths from Retail domain were allocated to me.

Responsibilities:

• Setting up Project Start up and Wind up meetings.
• Conducting Quarterly Project Management Reviews.
• Conducting Final Inspections before deliveries are made.
• Conducting Project Audits.
• Tracking down NCRs to closure.
• Identifying potential issues and informing higher management accordingly.

Environment: Internal Tools, MS Office

Confidential

Position: Business Analyst

Responsibilities:

• Requirement analysis and preparation of Technical specification and Program specifications.
• Coding, Code review.
• Preparing Unit System Test Scripts.
• Unit and System Testing.
• Packaging the delivery components implementation support from offshore.
• Creation of the lessons learnt best practice documents.

Environment: COBOL, DB2, SQL, JCL, EAZYTRIEVE, NDM and FILEAID