SUMMARY

• 8+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Diverse experience in Banking, Financial Services, Mortgage and Insurance.
• SCRUM Certified from International Scrum Institute with Scrum Master Accredited Certifications (SMAC)
• Excellent knowledge of Agile methodologies and implemented SCRUM methods in the team.
• 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.
• Experience with IBM WebSphere Business Modeler to understand and transform business through superior business modeling.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Agile, Object Oriented Analysis and Design (OOA/D)
• Experience working with PeopleSoft applications and CMS (Content management systems).
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Knowledge with investment banking regulatory reporting regulations like Basel II Accord
• Experience with MRMS tool to generate FFIEC 101 Reports for all Entities.
• Extensive experience in configuring data mapping between different Databases.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Cognos Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• 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

Methodologies: RUP, SDLC, RAD,JAD, Waterfall Model, Agile

Testing Tools: Rational Enterprise Suite, Test Director, Win Runner, Load Runner, QTP

Business Modeling Tools: Rational Rose, Microsoft Visio, Peoplesoft.

Project Management: Microsoft Project, Microsoft Office. MS Visio

Programming Languages: C,C++, SQL

Databases: Oracle 8/8i, MS SQL Server 7.x/2000, MS - Access, Bloomberg, Capital IQ, Factiva

Web Technologies: Microsoft FrontPage, DOORs

Reporting Tools: Excel, MRMS, Crystal Reports, OBIEE, ACBS (loan system)

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements.
• Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Experience in issue tracking and defect reporting services using Jira, Version One.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Excellent knowledge in Component-based Development (CBD) and Commercial Off-the-shelf (COTS).
• Worked in the implementation of COTS within Procurement business processes.
• Performed Impact analysis of COTS on the interface between systems engineering and software engineering.
• Followed Agile/Scrum methodology for the life cycle of the project.
• Developed user stories and attended stand up meetings on a daily basis.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel III Compliance.
• Interacted with Legal & Compliance team to include regulatory aspects
• Knowledge with investment banking regulatory reporting regulations like Basel II Accord
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Gathered and converted new regulatory rules and requirements into functional requirements for the system in ongoing update process.
• Participated in establishing inventory of all operational and regulatory reports required for cutover. Provided reporting specs for numerous billing and network related tracking reports.
• Was responsible for indexing of the tables in that data warehouse.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Manage Scope and change throughout the SDLC process of the product.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Managed backlogs within the agile projects.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagr ams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, COTS, IBM Websphere Business Process Modeller, VBScript, Adobe Photoshop, MIS-IP, ACORD, C#. NET, ASP.NET, XML, MicroStrategy, Agile, TestDirector, LoadRunner, Niku Project WorkBench, AVPN.

Confidential, Sterling, VA

Sr. Business Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Involved in S.W.O.T and Feasibility Analysis for the project integration and assisted Project Manager in cost determination and resource allocations by analyzing scope of the project.
• Involved in coding using Java created web pages using HTML, Java script.
• Organized meetings with Business area experts and captured High-level Business Requirements. Analyzed data/workflows. Performed GAP analysis.
• Experience in issue tracking and defect reporting services using Rally.
• Performed source to target mapping using MS Excel workbook to support developers in coding
• Worked independently with minimum supervision as part of a Dynamic CRM IT team. Worked with the Business, Operations, and Engineering stakeholders to define the functional integration and end-2-end test cases for the CRM project. Analysed requirements for loan request, loan process, member services, processing and portfolio management
• Developed and presented prototypes of new information processing application using MS Visio.
• Facilitated JAD sessions with SME to capture functional requirements and detailed business requirements documented DRD which was used by technology group to understand the data element level details of the project
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Used SQL to query the database and performed data analysis.
• Helped team in detailed design for the use cases and developed detail class diagrams and sequence diagrams using patterns in UML design.
• Followed the UML based methods using Rational Rose to create: Use Cases diagram, Activity Diagrams/State Chart Diagrams.
• Documented and established traceability matrix between the Business requirements and data requirements.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users
• Interacting with the development and testing teams to improve overall quality of the Application.

Environment: Java, J2EE, RUP Methodology, Rational Rose, CRM, Rational Requisite Pro, XML, Clear Quest, Documentum, Windows NT, SQL, .NET, MS Visio, MS Office, Oracle.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analysed AS IS and TO BE in 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.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Worked with the scrum master in getting the estimates for the projects and also user stories and defined the sprint periods using Agile/ Scrum methodology.
• Developed user stories by interacting with the team on a daily basis within the sprint periods.
• Worked in the analysis and implementation of COTS software which helped the enterprise teams take right decisions.
• Performed COTS evaluation between different lines of business.
• Consolidated the analysis of multiple business lines after the COTS evaluation
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Captured requirements based on Basel II internal ratings based approach (IRB). Allowing certain extent on estimation of credit risk.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains 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.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), COTS, Visual Basic, SQL, SQL Server, Oracle, C#.Net, XML, WebLogic, Websphere business process modeller, IPFR Services, HTML, ACORD, DreamWeaver, Adobe Photoshop, Windows Forms, Agile, Web Forms, LoadRunner, WinRunner, Niku Project WorkBench, Project Management.

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Complete study of the in-house requirements for the data warehouse.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Aimed at significantly improving the efficiency and effectiveness of the firm’s global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.credit
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), IBM WebSphere, XML, Java, J2EE, JSP, VoAVPN, Oracle, MS Visio, DB2,UAT, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro