PROFESSIONAL SUMMARY:

• Over 8 years of experience as a Business Analyst with extensive experience in requirement gathering, client interaction, process analysis, accounting and process auditing
• Strong knowledge of all phases and methodologies of System Development Life Cycle (SDLC) including Waterfall, Agile, Scrum and RUP framework
• Extensive experience in conducting Risk Analysis, Impact Analysis and GAP Analysis and preparing Problem Statement Matrix
• Well versed on Six Sigma and Lean Six Sigma Processes
• Managed project dashboards, change requests, issue escalations, resolutions and mitigations
• Profound knowledge in financial planning, forecasting and budgeting, and variance analysis
• Worked closely with the stakeholders for requirement elicitation, planning, projects tracking and for handling change management
• Facilitated JAD sessions to drive out detailed business requirements and resolve any conflicting issues
• Used MS Project to map the work breakdown structure (WBS) to manage schedules, status reporting and plan resources in line with triple constraint
• Experienced in monitoring project deliverables for given timelines, budget and resources and organized deliverables for stakeholders
• Acted as Project Manager on various OPEX projects
• Proficient in creating and analyzing Business Requirements Document (BRD), Functional Specifications Document (FSD), Systems Requirement Specification (SRS) and Use Case scenarios
• Experience in creating Key Performance Indicators (KPI), Enterprise Risk Management, Business Continuity Planning (BCP), and Change Management
• Adept in using MS Visio in creating various UML diagrams like Activity, Sequence, Use case, Data flow & ER diagrams and in using Mockup Screens to create prototype
• As a certified Scrum Master, carried out various scrum standup and other pre and post scrum meetings
• Worked with application Architects, Developers, Testing teams thereby coordinating efforts
• Extensively interacted with the QA Team in executing the Test Plans, providing test data, creating Test Cases, Test Reports and collecting the Test Metrics
• Reviewed, maintained and executed detailed Test scripts for unit testing, SIT and UAT, analyzing and fixing the bugs .
• Excellent knowledge in mutual funds, portfolio management, SOX and GAAP
• Experience in risk analytics (Credit Risk, Market Risk, Operational Risk, etc.)
• Knowledge of regulatory and compliance requirements such as K - Y-C, AML, Dodd Frank, BASEL I & BASEL II
• Market data and Market pricing through Bloomberg gateway
• Excellent Knowledge in REIT
• Extensive knowledge of Financial Analysis, Forecasting, Valuation, Planning and Budgeting
• Well versed in Star Schema & Snow Flake Schema, Dimensional Modeling, different relationships in Data Model such as Association, Generalization/Specialization and Aggregation & Composition
• Extensive Knowledge of Data Modeling, Data Warehouse, CRM and ERP Data Migration
• Experience in generating on-demand and scheduled reports for analysis and management decision using SQL server
• Simplified existing applications & integration architecture & built for scalability utilizing SOA as framework and applied the “As Is” and “To Be” process designs in order to identify any potential process gaps and as well as improvement opportunities
• Experienced in cross functional teams in the use, maintenance and protocols related to the Finance process from Receipt-to-Payment.
• Excellent analytical, problem solving, communication and documentation skills along with good process management skills
• Experience in implementing MDM foundational programs, define metadata that provide traceability between MDM and the heritage of each data element
• Proven track record of adding significant value and producing high quality work under time constraints
• Defects tracking prioritized outstanding defects in reporting system. Co-ordinated between development team and the management team to resolve any conflicts/defects in terms of requirements
• Dedicated & Self- motivated, proven leadership capabilities and time management skills

TECHNICAL SKILLS:

System: SAP, Oracle, Hyperion (BI), ETL Tools - Tableau, Essbase Hyperion

Technology: SQL, JAVA, Windows, HTML, Lotus Notes, Mockup Screen, Lucid Chart, UM, BPMN Dream Weaver, Flash

Microsoft tools: Excel, Word, Power Point, Access, Outlook, MS Project (Gantt Charts), MS Visio, SharePoint 2007/10/13

SDLC Methodology: Waterfall, Agile, Scrum, RUP,XP

Statistical: Process Modeling, Data Modelling, Risk and GAP Analysis, Elicitation Techniques, Framing KPI s, Change Management, Data Warehousing, Reporting Dashboard, Minitab

Domain Tools: GAAP Reporting, P&L Accounting, Variance Analysis, Budgeting and Forecasting, Supply Chain Management - Negotiation Skills, BISAM B, Value Stream Mapping, Tableau, Domo, IBM Rational tools, IBM BPM, HPQC, SunGard XAMIN

ETL Tools: Informatica 9.5/8/7 (All suites), DataStage 9.1/8 (Enterprise Edition), IBM Data Manager 10.2/9, Teradata utilities: BTEQ, Fast Load, Fast Export, Multi-Load

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/Reporting, Multidimensional Analysis, Data Mining, Drill Down/Roll Up, MDM

Financial and Financial Modelling: Equities, Fixed Income, securities, foreign exchange, bonds and derivatives, insurance, mutual funds, REITs and check processing, trading & risk environment, credit, interest rates, equity, foreign exchange, treasuries and mortgage concepts

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Analyst

Responsibilities:

• Reviewed the existing artifacts and Interacted closely with the SMEs (Subject Matter Experts) through user interviews to elicit requirements and document the business, functional and system specification requirements
• Created a Problem statement matrix and GAP Analysis for better understanding of the business problems, opportunities and challenges
• Worked on MS Project to prepare a work break down structure (WBS) for managing resources and estimating project cost and schedule
• Extensively worked on JAVA and used it in different web services and Business Rule Engines
• Defined the business process using ER Diagram
• Created and reviewed various artifacts such as business requirement document (BRD), Software Design Specification (SDS), Use Cases, Test Cases and Test Scenarios
• Prepared Mockup Screens and Use Case diagrams using Visio to analyze As Is and To Be scenarios
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, and Project) for project tracking, documentation, and presentation
• Followed Software Development Life Cycle (SDLC) using Agile Methodology (Scrum framework)
• Moderated Scrum meetings to improve the efficiency and productivity of each sprint
• Acted as Scrum Master in various post and pre scrum meetings such as Review, Planning and Retrospective
• Participated in the weekly status meetings to discuss and review the status
• Performed Unit Testing, System Testing (SIT) and UAT on business requirements, technical specifications and product knowledge.
• Shadowed the Project Manager; directed the project and met the deadlines
• Worked with SQL queries to extract data to perform application validations
• Worked on data repository to extract the relevant data and create data marts
• Used ETL tool to extract the data from the source data and OLAP to perform data analysis
• Ensured requirements compliance and testing using traceability matrix
• Involved in preparing a simple and detailed User manual for the application for intended users

Confidential, Denver, CO

Sr. Business Analyst

Responsibilities:

• Obtained a detailed knowledge of business process involved in the project environment
• 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
• Contributed with Project manager in handled scheduling, resource planning and allocation matters conducted status meetings and compiled reports.
• Analyzed user problems, including automated and manual business processes, and identified, researched, investigated, defined and documented business processes
• Participated in configuring the web services using JAVA
• Reviewed and analyzed the business requirements document (BRD) to derive the functional specifications document (FSD) and System Requirement Specification (SRS)
• Created Dataflow and Activity diagram to set a flow to the data & activity involved in the project respectively
• Analyzed business requirement and created business and process flow diagram to understand the AS IS and TO BE model
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)
• Created artifacts and defined milestones and iterations plan for inception and elaboration phases
• Designed Mockup Screens and Use case diagrams using MS Visio to present a better view of the system and enable the technical team to identify the key processes
• Created user stories and as a SCRUM Master conducted various stand up meetings
• Contributed in customizations, enhancements, updates, and changing functionalities of web page.
• Created and executed Test Cases. Assisted in functional testing for both manual testing and automated testing using HPQC
• Prepared UAT test scripts and worked closely with QA lead to conduct UAT testing
• Conducted many informal Sessions to resolve open issues, and change requests
• Developed user manuals and manuals as per project specification and timelines

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Involved in performance attribution analysis of various portfolios
• Gathered and analyzed business requirements from various department through interviews, JAD sessions and interacting with users, management and SME’s
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to agreement terms
• Documented Business Requirement Documents (BRD) and Systems Design Specification Document (SDS)
• Worked on HP projects and Portfolio Management for continues update with project schedules, quality, Issues and managing resources
• Used JSP as client side validation and configured middle tier using JAVA
• Interacted with technical architects to identify and analyze the given information, procedures, decision flows, and also evaluated existing procedures
• Created and reviewed various business documentation like BRD, FRD, Use Case, Test Scripts
• Used MS project for project management activities and create project plans and project schedules
• Designed and developed Use Cases, Process flow diagrams, Dataflow diagrams using MS Visio
• Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing
• Worked closely with the QA team and reviewed the test scenarios as well as test case
• Analyzed, designed and developed ETL strategies and processes, writing ETL specifications
• Supported cross functional teams to address business requirements
• Involved in documentation during various phases of development life cycle
• Responsible for debugging, defect tracking and data verification

Confidential

Business and Financial 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
• Gathered business requirements through interviews, surveys, prototyping and observations of account managers and UI (User Interface) of the existing system
• Conducted controlled brainstorming sessions with project focus groups
• Prepared Logical Data Models and BRDs (Business Requirement Documents)
• Prepared the process flow, Mockups and Conducted Gap Analysis to show the current and proposed functionalities of the system
• Created and maintained various asset logical model: Depreciation, Tax and Accounting Rules
• Ensured proper accounting of general ledger transactions and preparation of financial statements and monthly reconciliations
• Instituted a reporting system that met GAAP standards
• Planned and defined system requirements to Use Cases and Test Plans
• Worked with SQL queries to extract application data from the source file to perform application validations and create data marts
• Assisted in testing the application whether all the user requirements were catered to by the application
• Performed different testing like unit testing, system testing, functional regression testing
• Involved in preparing a simple and detailed User manual for the application for intended users.
• Wrote Test Cases and developed strategies with Quality Assurance group to implement them.
• Supported the business in identifying and resolving the post production issues

Confidential

Business Analyst

Responsibilities:

• Facilitated collection of requirements from system users and preparation of Business/Functional requirement documents utilizing UML & RUP methodology to provide appropriate scope of work for technical team to develop prototype and overall system.
• Analyze and prioritize requirements and use them to outline timeline for completion of goals.
• Conducted controlled brainstorming sessions with project focus groups.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders to develop specifications.
• Used Entity-Relationship Diagram and established entities, relationships and attributes
• Created Work Plan clearly identifying task level details, resource assignment, project timeline, including “Target” and “Actual” Start and End dates, showing task completion and overall percent completion of effort.
• Performed GAP Analysis with system functionality and existing Business Processes.
• UML and RUP process for productivity in communicating specifications to design & development team. Analyzed and designed Use Case & ER diagrams using UML/Visio.
• Managed scope and requirements throughout the project life cycle.
• Discuss and propose conversion / interface solutions with the clients and users.
• Performed Functional Testing, Integration Testing, System testing and Regression testing.
• Wrote Test cases, test scripts and test plans for UAT.
• Provided live support and for the end users.

Environment: Visual Studio.NET, VB.NET, ASP.NE, SQL, PL/SQL, Windows, MS Visio, MS Project, MS Office Suite (MS Word, MS Excel, PowerPoint).

Confidential

Associate Business Analyst

Responsibilities:

• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system methodology.
• Involved in analyzing Business Requirements and developing System Specifications.
• Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.
• Did rigorous load testing using Load Runner.
• Assessed business priorities, and advised business units on risks and Cost-Benefit analysis.
• Used Rational Rose to generate various UML Diagrams.
• Organized cross of team members and users to become more responsive.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Involved in incident reporting and change and configuration management procedures using Clear Case.
• Ensured that the modifications suggested by the users were incorporated into the application.
• Formed a bridge between the Project Manager and different teams with effective presentations.

Environment: UML, RUP, SDLC, Rational Requisite Pro, Rational Rose, Windows 2000, MS Office, MS Project