SUMMARY

• A proactive and results - oriented Sr. Business Analyst and Quality Assurance Analyst with 9+ years of experience in Government Contracting, Financial Services, Investment Services, and Mortgage with a proven track record of delivering global solutions on-time and within budget.
• 5+ years of working experience for Department of Veterans Affairs on their flagship Loan Guaranty Program as Principal Senior Business Analyst.
• Currently hold Low Level Public Trust Clearance from US Govt. attained during working with U.S. Department of Veteran Affairs.
• Strong experience in AGILE methodology, SCRUM, product backlog session, grooming and retrospectives, managing team as scrum master.
• Successfully led dynamic, energized, and highly creative multidiscipline high-performance Onshore/Offshore work teams.
• Experience in designing process workflows and workload management systems.
• Proficient in Mortgage, Financial, Banking and Trading concepts such as HUD/Closing Disclosures, Foreign Exchange, Bonds, Futures, Swaps and Derivatives, Mortgage Industry, Payment Processing and Payroll activities.
• UML: 8+ years of Business Requirement Documents (BRD), Use Case Specifications, Functional Specifications, System Design Specifications, System Requirement Specifications, Requirements Traceability Matrix across the project Deliverables using Rational Unified Process (RUP) and Unified Modeling Language (UML) methodology.
• Experience with process analysis of the as-is system and suggest changes for to - be system.
• Facilitated JAD (Joint Application Design) sessions and e-JAD sessions.
• Recognized for leadership, creativity and people growth by team members and senior leadership team
• Very strong SQL skills, including the use of nested table expressions, unions, and multi-table joins, scalar functions, outer joins and derived columns.
• Experience in customer/client interaction, creating RFP and RFIs, deep understanding of financial business systems functionality and technicality.
• Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project.
• Strong skills in GUI (Graphic User Interface) Automation, Functionality testing, System testing, Stress testing, Integration Testing, Load testing, Backend testing, Data driven testing, Regression testing and Integration testing.
• Experience in Data Analysis and Data Modeling involving Data Cleansing, Data Conversions, Data Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Experience with Data warehousing and Business Intelligence tools.
• Developed and executed testing tasks and deliverables in relation to the testing phases of the SDLC.
• Experience with Content Management.
• Utilized BPM lifecycle concepts - Design, Modeling, Execution, Monitoring and Optimization to improve the efficiency of the system.
• Lead a prototyping team to design the Graphics User Interface for the system under scope.
• Project management experience in developing testing strategies based on functional and technical goals of the end user.
• Used SharePoint as a main repository for document and workflow management.
• Created and maintained Requirement Traceability Matrix, Test matrix and performed Gap Analysis.
• Strong analytical skills coupled with good communication and interpersonal skills, critical thinking, decision-making and leadership aptitude, Good organizational and problem solving abilities.

TECHNICAL SKILLS

Software: SharePoint, Excel, Word, Project, Access, Visio; Power Point, and Outlook

Programming Languages: HTML, SQL

Business Analysis: Requirements engineering, business process modeling (BPM) and improvement; gap analysis; cause and effect analysis; decision trees; data flow diagrams; data modeling; UAT, Agile Scrum, Rational Suite

Data Analysis: Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis, Star/Snowflake schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling, Entity-relationship diagrams, MS Visio, Rational Requirements Composer, Rational Team Concert.

Tools: Rational Rose; Requisite; Clear Quest; Clear Case; DOORS; iRise, Rational Tools (RTC, RRM, CCM), Axure

PROFESSIONAL EXPERIENCE

Confidential

Project Manager/ Project Coordinator

Responsibilities:

• As a member of Management Personnel of Confidential, provide support to the Business Development Support Group (BDSG), Project Management Operations (PMO) and Strategy Team by:
• Performing proposal coordinator role and answering to technical sections of the proposal.
• Collating information and steering towards proposal effort
• Participate in Business Development Meetings, Project Evaluation and Bid-No bid decision
• Support proposal efforts so as to enable Confidential respond quickly to new business opportunities
• Provide assistance identifying resumes and level off effort of project proposals

Confidential

Senior Business Analyst

Responsibilities:

• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes, and communicated enhancements/new features to stakeholders.
• Analyzed business requirements.
• Created Requirement documents including - Epics, User Stories and Tasks, System Design Documents, Use Case Specifications.
• Worked with other BAs and business line to establish an effective Requirements Management Process.
• Wrote user manuals as a part of process enhancement process.
• Understanding and Clarifications of the requirements with extensive Client interaction.
• Developed the complete prototype for the Graphic User Interface (GUI) requirements understanding of the system.
• Used Excel to analyze large amount of data and to present using graphs etc.
• Experience and understanding of software development process including Software development life cycle (SDLC), RUP’s Iterative System Development Life Cycle process, implementing the Rational Unified Process (RUP) in all four phases of a project Inception, Elaboration, Construction and Transition.
• Used SharePoint as a Business User and also managed SharePoint portal.
• Helped architect and develop enterprise level business solutions for MOSS 2007.
• Created reports and presented to the clients using Excel and PowerPoint.
• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.
• Conducted successful UAT for Loan review and conveyed the feedback to update backlog.
• Managed and maintained project planning documents like Roadmap and Responsibility matrix.
• Manage Agile scrum teams, conduct release planning and sprint planning, manage burn downs and product backlog.
• Data Analysis experience while working with Reporting/ data warehousing teams.
• Worked with Data warehousing team to define data dictionary, schema and standardization of data elements for Loan Review application.
• Defining various KPIs and establishing inference from the yearly data reports.

Environment: UML, MS Visio, MS Project, Rational Clear Quest, Rational Requirements Composer, Rational Team Concert, Dimensions, and Agile.

Confidential, Washington DC

Senior Business Analyst

Responsibilities:

• Interacted highly with clients and vendors on day to day basis.
• Conducted and coordinated meetings for the smooth functioning of the projects.
• Executed recruitments functions from sourcing to interviewing the client and companies.
• Gathering requirements and Analysis of the existing tools.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes, and communicated enhancements/new features to stakeholders.
• Analyzed the GUI and other interfaces to capture information.
• Designed UI by creating throwaway prototypes as well as using Wireframes.
• Understanding and Clarifications of the requirements with extensive Client interaction.
• Developed the complete prototype for the Graphic User Interface (GUI) requirements understanding of the system.
• Developed and designed the basic framework components of the system.
• Creating High level functional diagrams of existing applications that will provide the foundation for new requirements requests.
• Used Cognos platform to turn business historic data into important information that can be used for business.
• Used Excel to analyze large amount of data and to present using graphs etc.
• Incorporated various tools like Mortgage rate calculator, credit payments etc. within the website.
• Experience analyzing the capabilities of MS SharePoint and move intranet to SharePoint Servers.
• Used SharePoint as a Business User and also managed SharePoint portal.
• Helped architect and develop enterprise level business solutions for MOSS 2007.
• Created reports and presented to the clients using Excel and PowerPoint.
• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.

Environment: Oracle, Windows NT, UML, Cognos, DOORS, Requisite Pro, MS-Visio, Rational Clear Quest.

Confidential

Sr. Business Analyst

Responsibilities:

• Coordination with various teams like GL Integrity team, Reference Data Team, Business, Legal Entity controllers- Informing them about the change, agreeing on the assistance required from each team, receiving a sign off from LECs, Post implementation support - to ensure there is no impact elsewhere.
• Worked on the merger of Bear Sterns and Confidential Bank and in bridging the gap between the 2 ledgers. Handled the project single handed “CIB VDP Conversion”
• In change of currency set up from Fixed Decimal Positioning to Variable Decimal Positioning.
• Followed the complete SDLC for the implementation of the project.
• Responsible for entire CIB VDP currency conversion activity.
• Lead and managed entire project including requirement gathering, estimating time lines and cost and testing of the deliverables.
• Used Excel to sort and analyze the data fetched from backend using Month End Reporting tool called(MERIT) based in business intelligence tool Cognos.
• Created Requirement Documentation, budgeting time and cost, UAT testing, implementation, coordination with various involved teams (GL integrity team, GL ref data team, Business and Legal Entity Controllers)
• Developed data analysis formats using Cognos applications that helped to make business process more efficient.
• Support for post implementation activity and finally receiving Sign offs from LECs after the changes are implemented in production.
• Verified defect fixes.
• Preparation of Process Flow documents.
• Experience with Content Management to manage account and currency information.
• Documenting the timelines and mail coordination with Business and concerned teams.
• Created functional requirement documentation for various components of the application.
• Coordinated the team to Log requirements of all components of the application in Quality Center.
• Developed Test Script in Quality Center and mapped them to the requirements.
• Used Quality Center to run manual and automated tests, report execution results.
• Interacted with the developers to report and track bugs using Test Director.
• Used SOAP as simple XML-based protocol to exchange information.
• Follow up with developers on defects status on a daily basis.
• Worked with the BA / QA team to develop test plan and test cases for (UAT)

Environment: Oracle, Windows NT, UML, Business Intelligence tools,Cognos, Requisite Pro, MS-Visio, Rational Clear Quest, DOORS, Mercury Quality Center.

Confidential, Chicago IL

Business Analyst

Responsibilities:

• Responsible for writing functional & technical specification documents for various application components
• Helped development team with interpreting business requirements.
• Analyzed and created reports after each batch of testing is run in mainframe environments and highlighted the issues with the concerned Stakeholder.
• Design and development of ETL process to populate acquisition, enrichment and reporting modules of DC data warehouse.
• Used Mainframe reports to analyze the reconciled data.
• Kept a track of the trend of the defects in various cycles.
• Raised tickets and resolved issues associated with the tickets.
• Developed Test Plan based on business requirements, functional and technical specifications.
• Familiarized the team members with the customer needs, specifications, design targets, the testing process, design standards, techniques and tools to support testing effort.
• Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts
• Created Use-Cases and Requirements documents to document business needs
• Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application
• Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same.
• Assigned roles and responsibilities and deliverables to all team members.
• Used Enterprise Content Management to take the digitized backup copy of critical banking documents.
• Used Content Management tools to reduce the time required to access documents by lowering effort required to fill information.
• Maintained timelines and deliverables using Microsoft Project.
• Experience with Unit Testing, System testing and Integration Testing.
• Used Business Intelligence tools to analyse the reports and take decisions.
• Performed database reconciliation that focuses on the integrity and quality of the entire database or data set. Frequently used data reconciliation to address the integrity or accuracy of individual records of data quantities.
• Utilized database reconciliation for completion of a data migration effort to understand if the validity of the entire data set is still intact.
• Created functional requirement documentation for various components of the application.
• Coordinated the team to Log requirements of all components of the application in Quality Center.
• Developed Test Script in Quality Center and mapped them to the requirements.
• Performed System Testing, Extended System testing for 3 cycles of testing.
• Performed Regression, Functionality, GUI testing.
• Performed Back end testing using SQL and UNIX.
• Utilized BPM methodology to gain higher customer satisfaction, product quality and delivery speed.
• Coordinated and Performed Integration testing. Wrote IST Scenarios.
• Used Business Intelligence tools for creation of reports.
• Validated the data across the system during IST and UAT.
• Performed End to End testing across the applications using SQL and UNIX.
• Analyzed the data from reporting tools and presented in Excel Spreadsheets.
• Developed Timeline for different cycles of testing.
• Logged, assigned and tracked defects in Quality Center.
• Conducted Daily defect calls with Project PM, and Developers.
• Prepared and Maintained documents like Test Strategy, Risk Assessment, Test Report and Trace Matrix.
• Serve as a focal point to communicate and resolve interface and integration issues with other teams

Environment: Mercury Quality Center, Oracle, Mainframe, TOAD, SQL, VB.NET 2005,MS VISIO, Wirefames,QTP, IIS 6.0, IE 6.0, Windows 2003.

Confidential

Business Analyst

Responsibilities:

• Gathering requirements and Analysis of the system - various debt market instruments.
• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes, and communicated enhancements/new features to stakeholders.
• Understanding and Clarifications of the requirements with extensive Client interaction.
• Developed the complete prototype for the Graphic User Interface (GUI) requirements understanding of the system.
• Developed and designed the basic framework components of the system.
• Developed High Level Design documents on 10 instruments in debt market that includes Bond, Collateral Bond, ETF, FRA, Repo, Collateral Repo, Asset Backed Securities, and Mortgage backed Securities.
• Developed UI Prototypes using Wireframes.
• Created Data flow diagrams, and Entity Relationship diagrams
• Facilitated business users in identifying data and tools required to regulate financial markets.
• Responsible for quality assurance for the same.
• Preparation of High Level design documents, low level design documents other UI(User Interface)specification Analysis document.
• Created prototypes using prototyping tools like iRise and Wireframe.
• Created USE CASE, ERD using BPM techniques.
• Experience in creating and writing XML Documents.
• Understanding of related XML technologies - XSD, XSLT, DOM and XPATH
• Developed XML Resource files for multi-lingual application where all the text was stored and read from XML documents
• Wrote SQL Queries to gather data from these MS Access Tables.
• Supported the creation of user testing strategies, plans, scripts, etc. and participating in test execution.
• Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, financing structure, Portfolio Analysis, etc.
• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives, and develop and document the functional requirement documents.
• Assisted with the development of project timelines and scope.
• Performed data creation, data mining and data cleaning activities.
• Used Business Objects tools for creating data dictionary.
• Manage and maintain projects documents on standard project document repository, Change control.
• Responsible for managing the Business Rules using the firm’s Business Rules Engine.
• Acting as a liaison with the Business Analysis Team (BAT) to ensure that business needs are not overlooked.
• Consulted Quality Assurance (Testing) Group on various documents as test plan, test cases, requirements traceability matrix (RTM) and test scenarios.
• Worked with trade capture and processing, as well as settlement and clearing functions for domestic and foreign fixed-income instruments,
• Supported the creation of User Acceptance Testing (UAT) strategies, plans, scripts, etc. and participating in test execution.
• Conducted various testing cycles including System Integration Testing with various builds.
• Maintained documents and the effect of proposed changes on the project schedule and costs.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.
• Reengineered claim Management process.
• Designed and developed scenarios based on business requirements.
• Developed requirements integrating E-R diagrams and designed the testing process flows.
• Followed the RUP methodology for the entire SDLC.
• Strong Knowledge of Quality center.
• Used DOORS for requirement management.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process effort in different iterations and phases (Inception, Elaboration, Construction and Transition) of the Software Development Life Cycle.

Environment: VB.net, SQL, IIS 6.0, IE 6.0, Quality Center.

Confidential

Business Analyst/QA

Responsibilities:

• Involved in developing business use cases, activity and class diagrams using UML tools using MS Visio 2003
• Presentation tier and Middle tier (Business logic) built using ASP.NET 1.0. Data tier built using MS SQL Server 2005, language used for development was C#
• Worked extensively with Windows Forms, form validation and developed reusable custom UI controls
• Wrote Stored procedures and SQL statements to access data from SQL Server database using ADO.Net
• Developed reports using Crystal Reports 8.5
• Conducted training session for end users to acclimatize them with the new Software
• Formulated test plan and test cases based on the system requirements specification
• Wrote the user guide for the system
• Was involved in the successful implementation of the project in 4 branches of the company and coordinated UAT.