SUMMARY:

• 8per+ years of Industry experience as a Business System Analyst with solid understanding of Business
• Requirements Gathering, Data warehousing, Data Modelling,
• Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Diverse exience in Banking, Retail, Financial Services, Mortgage and Insurance.
• Deep understandin
• Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application
• Development (JAD) sessions with IT Groups and Conflict Management with Project team members. g of enterprise data warehouses.
• 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 Worked on IT compliance Projects for Risk Management with requirements sufficing Sarbanes - Oxley Act and Basel I, II, III norms.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• 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 I, II, III Accord
• Experience with SOX, Regulatory Compliance and Controls.
• 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 Business Objects 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:

Programming Languages: C, VB,VB.NET, ASP.NET, Java, SQL, PLSQL

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

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 RequisiteProBug Tracking Tools: Mercury TestDirector, Rational ClearQuest

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

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Business System 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.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Collaborated with Basel II & III team on credit risk and market risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II & III
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II & III Compliance.
• Worked closely with Pillars 1,2 and 3
• Gathered requirements for credit risk, operational risk and market risk management
• Worked closely with. Standardised Approach and Foundation IRB (Internal Ratings Based) Approach for Credit Risk
• Involved in putting together QRM (Quantitative Risk Management) models for risk-weighted calculations
• Worked with Disclosure requirements as per Pillar 3
• Gathered architecture specifications for second pillar dealing with the regulatory response
• Worked with Oracle Reveleus Basel III to help generate various statistical models
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel III Accord.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Was responsible for indexing of the tables in that data warehouse.
• Reverse Engineered the existing ODS in to Erwin.
• Performed stress testing and advanced capital adequacy practices required by Basel III.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2008.
• 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.
• 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, IBM Websphere Business Process Modeller, VBScript, Adobe Photoshop, MIS-IP, ACORD, C#. NET, ASP.NET, XML, Business Objects, TestDirector, LoadRunner, Niku Project WorkBench, AVPN.

Confidential, Herndon, VA

Business System 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.
• 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.
• Worked closely with Pillars 1,2 and 3 for capital allocation
• Gathered functional requirements for systemic risk, pension risk, concentration risk, strategic risk, reputation risk
• Helped streamline QRM (Quantitative Risk Management) for credit, market, and operating risk
• Involved in data mapping around Pillar 1 and Pillar 2
• Involved in preparing business requirements for handling Pillar 3 disclosure requirements
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Worked with Basel I & II for implementing Basel II in the regulatory environment.
• 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.
• Captured requirements based on Basel I & 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, and Stored Procedures in Sybase Database Servers.
• Worked on creating framework for dealing with systemic risk, strategic risk, reputational risk, liquidity risk and legal risk for Basel II.
• 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), Visual Basic, SQL, SQL Server, Oracle, C#. Net, XML, WebLogic, Websphere business process modeller, HTML, Windows Forms, Web Forms, LoadRunner, WinRunner, Project Management.

Confidential, Princeton, NJ

Business System 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.
• Understood audit trails requirements using Oracle Reveleus
• Gained understanding of pillars 1 and 2
• Involved in quantitative risk management workshops
• Involved in Pillar II stress testing across all regulatory risk models
• 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, Oracle, MS Visio, DB2, UAT, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Miami, Florida

Business Analyst

Responsibilities:

• 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.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Performed data analysis and ran various SQL queries to critically evaluated test results
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Designed and developed Project document templates based on SDLC methodology.
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• 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 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.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, TestDirector, UAT

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• 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.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Was responsible for indexing of the tables in that data warehouse.
• Assisted in on going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Developed Test Plans and Test Cases according to Business Requirements.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, UAT, DreamWeaver, Windows, JavaScript, XML, HTML, Oracle, SQL, Test Director, Load Runner