SUMMARY

• Around 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• 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.
• Extensive experience in Testing, Manual and Automated using tools Win Runner, Load Runner, Quick Test Pro, TestDirector, Rational Robot or Web and Client/Server Applications & Mainframes
• Proficient in Testing methodologies, Test Matrices and Trace matrix.
• Extensive Knowledge of Systems Management, Data Warehousing, Design and Data Modeling.
• Proficient in Functional testing, Regression testing, Configuration testing, Integration testing, System testing and Sanity testing
• Experience with integration and cleansing of all financial data, budgeting, forecasting, scorecarding, simulation, risk management using SAS Financial.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• 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
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

Programming Languages: C,C++SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP.

Databases: MS - Access, MySQL, SQL Server, Oracle.

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Testing Tools: Mercury Interactive Win Runner 7.6/8.0, Load Runner 7.8/8.0QuickTestPro 6.5/8.0, Rational Robot, Test Director 7.6/8.2, Quality Centre 9.0

Methodologies: Agile, Waterfall, Scrum, RUP, SDLC

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, IA

Sr. Business/Technical Analyst

Responsibilities:

• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
• Gathered business requirements for Auto Finance stakeholders.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Developed Automation Test scripts using Perl to install the application on the Remote system.
• Created Test Cases and scenarios for Unit, Regression, Data Integration as well as Back end and System testing.
• Gathered requirements for a fully electronic auto loan contract process
• Used Quality Centre for requirement management, test planning, scheduling, executing test cases, managing and tracking defects
• Regular interaction with the core developers helped us in fixing the defects in less time.
• Played key role in defining test automation procedure and standards, creating Win Runner and QuickTestProfessional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Conducted JAD/RAD sessions and elicited customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs) to create subject specific questionnaires for clinical trials.
• Involved in creating test plans, UML diagrams, flowcharts, and screen mock-ups and systems requirements specifications.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Generated server side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Created automated Load test scripts using Load Runner.
• Highly contributed to the enterprise metadata efforts by completing the data mapping repository (DMR) information.
• Worked with Siebel users and co ordinate with the teams involved in testing the user interface and backend testing.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Performed Load and Stress Testing using Load Runner.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology
• Worked with UI team to create the User Interface screenshots to be presented to the Business.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Involve in preparing Trace Matrix to design test cases

Environment: Windows 98/2000, Window2003, Window NT, Linux, Solaris IBM Web sphere, Apache Tomcat, IIS 6.0, Web Logic, Java, Rational Robot, Quick Test Pro 8.2, Mercury Quality Centre 9.0, Load Runner, RUP, Agile, Oracle 8i/9i/10g, SQL Server 2000, DB2, Toad, MS Visio, MS-Project.

Confidential, Bronxville, NY

Business/Technical Analyst

Responsibilities:

• Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
• Analyzed clients systems and business processes.
• Worked on a web-based system that allows automotive dealers to submit credit applications
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Completed requirements analysis for Loan Origination System (LOS) project and Compliance Engine project.
• Established a Business Analysis methodology around the Rational Unified Process.
• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Worked for Version document with SME. Primary Liaison between Business User and Development Team.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Deep understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, Financial Derivatives, Cash flows, financing structure, Capital Management, Stock Valuation, Amortization, etc
• Communicated any gaps to WKFS and/or the appropriate LOS contact to investigate /discuss possible solutions as early as possible
• Performed Batch scripts in Rational Robot to run multiple scripts from a single script by using call statements.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Wrote Test Cases in Quality centre that would test various Test scenarios
• Used Rational Unified Process (RUP) for streamlining the team’s development activities.
• Managing personnel allocation and SDLC process for systems projects enhancements
• Worked extensively with MS Excel and MS access
• Created Process Flow Diagrams to explain the work flow of systems. Connecting LOS to servicing systems.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Deep understanding of Structured System Development Methodologies
• Wrote automated Test Scripts for Regression Testing using Win runner.
• Participated in UAT and worked with Mercury Quality Centre for bug and defect tracking.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Review, analyze, and modify Loan origination systems including encoding, testing, debugging and installing to support client/server software applications
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Involved actively in determining the quality and quantity of data to be provided for UAT.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Worked in mainframe environment and used SQL to query various reporting databases.

Environment: Mainframes, COBOL, JCL, Mercury, SAS, Unix, Quality Centre, test Director, Load Runner, Rational Robot, Db2, Oracle, RUP, Rose, AGILE, ETL, MS Project, SQL Server, Oracle, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential, Lakewood, CO

Business Analyst

Responsibilities:

• Worked as a business analyst to build Strategy Web application for financial statements and inspections
• Identified, researched, investigated, analyzed, defined and documented business processes
• Reviewed requirements together with QA Manager, Vice President of Human Resources & Business Analyst
• Involved in enhancing the credit application process for automobile dealers and their customers.
• Excellent experience managing the whole testing process using Quality Centre.
• Worked on IBM Rational Robot for testing the functionality of the web based application for automated regression testing.
• Assisted in developing and documenting Business Requirements, Functional Requirements, and Test Cases for the Loan Origination System (LOS) project.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Facilitated regression, integration and system testing on the corresponding enterprise level loan origination system (LOS) with separate components for loan officers, processors and brokers
• Facilitated four-hour long round table discussion with most HR directors, managers and analysts along with QA manager to get their input ad-hoc UAT in the project
• Reviewed Technical Specs together with the team of two developers
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements
• Analyzing Business requirements. Conducting Kick off meetings with the Lenders/Vendors/ LOS (Loan Originating System)Team
• Tuning of Informatica Mapping, With Respect to Lookup Transformation Aggregation, SQL Transformation
• Rational Unified Process (RUP) was used to implement iterative SDLC.
• Built a business process model using Rational Rose and Visio.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Documented the outcomes of all the testing in MS Word and MS PowerPoint
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints

Environment: - Mercury Tools (Win Runner 7.0, MS Office, MS Project, MS Visio, Test Director 7.0/7.5, Load Runner 6.5/7.0, Rational Robot, Quick Test Pro 6.5, Quality Centre 9.0), SQL Server, Oracle, RUP, Requisite pro, NT/00, XML

Confidential, NY, NY

Business Analyst

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Developed automated test scripts for Functional, GUI validation, Data Driven testing using Rational Robot.
• Manually tested and GTS modules using Quality Center
• Worked with various vendor groups to gauge the effectiveness of their solution
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Implemented mercury interactive automated tools like TestDirector, WinRunner and LoadRunner.
• Execution of various test procedures & test cases both manually and by using automation scripts.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML and OOD.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.

Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, Cognos, MS Visio, RUP, Rational Rose 2002, SQL Server 2000, TOAD, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot