Summary:

• Over 6+ years of business and technology background. Has significantly contributed to business process improvements through integrated system solutions.
• Demonstrated competency in business analysis, systems design, application architecture and programming.
• Diverse experience inManufacturing, Financial Services, and Banking.
• Proficient in Technical and Business writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Proficient in DB2 and strong Knowledge of experience in complex SQL and emphasis on performance Tuning.
• Experience in implementation of mainframe and mainframe-J2EE applications following the industry best practices.
• Proficient in designing and developing Mainframe applications using COBOL, DB2, IMS, CICS and JCL.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Well versed with technical, functional and training documentation.
• Well versed with System Development Life Cycle (SDLC) and Project Management methodology.
• Strong leadership, managerial and planning skills. Self motivated versatile team player.
• Easily adaptable, highly Organized and flexible and customer oriented.
• Excellent interpersonal, verbal, non-verbal, written communication skills.
• Creative to understand complex problems and finding right solutions in time.
• Exceptional analytical, presentation and problem solving skills.

Technical skills: 
Certifications: DB2 Certified.

Project Management / Methodologies: Microsoft Project, Microsoft Office

Databases: DB2, UDB,Oracle, SQL, MS-ACCESS, DB2 Stored Procedures

Mainframe: COBOL II, JCL, CICS, TSO/ISPF, XPED/CICS, XPED/TSO
QMF, VSAM, DCCS, FILE-AID, CA7 scheduler, IMS, IBM File Manager,
IBM Debugger Tool.

Operating Systems: UNIX, MVS/XA, Windows 95/98/NT/200/XP
Others: Crystal Reports.

Professional Experience:

Confidential 2009 – Till Date 
Project:Supplier Capacity and Volume Variance (SCVV)
Description: SCVVis an integrated system by having manufacturing capacity for all suppliers and calculating the variance from requirements versus capacity. Makes alternate plans for variance control and support follow-up process.
Major Tasks:

• Worked with the sponsor to ensure requirements are well understood and documented
• Used Joint Application Development (JAD) techniques for faster development time and quicker acceptance by the end users
• System & Application planning
• Design and development of back-end mainframe components.
• Coordinate with all cross functional teams
• Code review and deployment of web application on server.
• Cross functional coordination.
• Training manual /documentation preparation and end user training
• Review the test cases / plans , deliverables and implement changes including staging and production environment moves

Software : COBOL, DB2, JCL, IMS, Stored Procedures

Confidential Apr 2008 - Dec 2009
Project: Part Volume System
Description: A Mainframe application which provides the part volume forecast for the long term and short term capacity planning. It aids in tooling decisions for the suppliers while awarding Purchase Order to them.

Major Tasks:

• Gathering of user requirements.
• Ensured that a formal user requirements document is prepared and formally signed off
• Coordinated with all other cross functional teams.
• Design and development of mainframe components.
• Review the test cases / plans , deliverables and implement changes including staging and production environment moves
• Load Testing of the application.
• Maintain / update processes and Quality documentation

Software : COBOL, DB2, JCL, CICS, Stored Procedures

Confidential, Covington, KY Apr 2007 - Apr 2008

Project: Credit Card Processing.

Description: Bank of America is the largest financial services company in the world. It is the largest bank by assets, second largest bank by deposits in the United States. Bank of America wanted to start a new Competitive Intelligence (CI) unit to analyze and strategize the competitors by creating a knowledge base. The project also involved working on Credit Card Processing application. My project also involved working with the Payment Processing to measure the overall payments of the bank.

Major Tasks:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Employed SDLC for the purpose of monitoring the project and also followed the step-by-step procedure.
• Worked with SDLC for the purpose of evaluating the costs and also for setting up targets for the completion of project.
• Used MS Visio for the purpose of creating diagrams and copying it to MS PowerPoint.
• Worked with MS Visio for designing flow charts and process flow diagrams.
• Implemented agile methodology for rapid delivery of the high quality application and also for development with customer needs and company goals.
• Used agile development methods to promote development iterations, team work, collaboration and process adaptability.
• Worked with Gap Analysis for measuring investment of time, money and human resources required for successful completion of the project.
• Also used Gap Analysis for classifying how well a solution meets set of requirements.
• Experience working with SQL querying for the purpose of data retrieval and management.
• Worked with SQL Queries for retrieving data from different tables using joins.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Developed logical and physical data models using Erwin.
• Followed the UML based methods using Microsoft Visio to create Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Built Use cases from the requirements gathered to create use case diagrams and Use case documents.
• Experience using MS Access for creating own database solutions.
• Used MS Access for creating solutions using VBA, meeting end user database needs and quick application development.
• Used MS PowerPoint for preparing dependencies for different Business Requirement Documents and also for diagramming flow charts.
• Used Requisite Pro for the purpose of writing use cases and also for increasing the quality.
• Extensively used Requisite Pro for customizing and filtering requirements to maximize the informative value of each requirement.
• Worked extensively on Data Modeling for the purpose of designing and analyzing data requirements to support the application.
• Worked on Activity oriented and Product oriented Process models to meet the requirements.
• Used Quick Test Pro along with VB Script for specifying the test procedures.
• Also used Quick Test Pro for manipulating the objects and controls of the application under test.
• Prepared Logical Data Models that contained set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Was responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Software : COBOL, DB2, JCL, Stored Procedures

Confidential, New York Aug 2006 - Apr 2007

Project: Commercial Banking Application.

Description: The Bank of New York is the oldest bank in the United States which is well known for its global financial services. This project was based on the commercial banking application where the customers can access Account details like their Savings and Checking account details, can view and update their personal information and can even make the payments directly from the Checking accounts.

Major Tasks:

• Conducted one-to-one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.Assisted the Project Manager in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, Operations and the Technical areas throughout the Project Cycle.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Participated in the Logical and the Physical Design sessions and developed Design documents.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
•  Worked with Quality Control Teams to develop Test Plan and Test Cases.
•  Developed User Manuals and training Manuals as per Project Specifications and Timelines.

Software : COBOL, DB2, JCL, CICS, Stored Procedures

Confidential Feb 2006–Aug 2006

Project: Galaxy – Phase 1, Lloyds TSB, India

Description: This phase of the Galaxy programme is aimed at developing new generation Internet Banking application of leading bank of UK, Lloyds TSB. The new application will replace the existing Legacy Mainframe application Java based application with rich and enhanced features.

Major Tasks:

• Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business.
• Prepared the Analysis document for AS-IS system functionality.
• Involved in the design of new system and coordinated with Cross platform team.
• Documentation.
• Coordinate the testing and moving to production environment.

Software : COBOL, DB2, JCL, Stored Procedures 
Education:

Bachelors in Electronics