SUMMARY

• Over 7 years of experience as a Business Analyst, adept at managing all phases of software development life cycle, from needs assessment through testing and system implementation financial services and working experience in universal banking product FINACLE.
• Led teams for multiple product testing and development activities in banking domain and completed it with at most quality.
• Analyzed business requirements (BRD) and designed software requirement specifications (SRS) for UI development.
• Strong understanding of financial concepts and principles including Capital Markets, Equity, Derivatives, Fixed Income, Foreign Exchange, Financial Analysis and Reporting, Financial statement analysis, industry and company review, working capital assessment, collateral valuation, leverage and liquidity coverage
• Proficient in client interaction and requirement elicitation
• Expertise in review of Project Deliverables, documentation and coordination with business & technical stakeholders
• Experience in facilitating Joint Application Development (JAD) sessions with IT groups and conflict management with project team members
• Created, reviewed and updated documents capturing the viewpoints of organization resources, stakeholders as well as end users
• Expertise in Business Modeling using MS Visio, Rational Rose and proficient in creating Wireframes/ Mock - up Screens for designing prototypes
• Good Working knowledge in OBIEE 11.1.x/OBIEE 10.1.x which includes Oracle BI Dashboards, Oracle BI Analytics/Answers, Oracle BI Delivers, Catalog Manager, Oracle BI Publisher.
• Proficient in creating UML diagrams for Business Process Modeling: Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD), Data Flow Diagrams (DFD), Flow Charts (FC), Traceability Matrix, Data mapping and Wireframe designs and Prototypes
• Excellent knowledge and working experience in Requirement Analysis, Test Design, Test execution, Defect Management & Status report preparation.
• Excellent SSIS working knowledge and used extensively for ETL purposes and automation.
• Performed functional testing on CASA and Deposits modules to check the US regulations and functionalities.
• Maintained Requirement Traceability Matrix to determine all functional requirements were taken care of.

TECHNICAL SKILLS

Languages: T-SQL, Pl/SQL, HTML, Java, CSS Java CSS

Data Mining / Reporting Tools: MS Excel, SAS, R, Tableau, SAP, SSIS, SSAS, SSRS, OBIEE

Methodologies: Agile, UML, SDLC, Waterfall

Modeling Technique: Predictive Modeling and Linear Regression

Tools: Bugzilla, HP ALM, Quality Center 9.2, JIRA 4.1/4.0

Databases: MS SQL Server (2012/2008/2005/ 2000 ), Oracle 10g, 11g

Process/Model Tools: MSOffice, MS Project, MS Visio, MSWord, MS Excel, MS office, MS PowerPoint, Rational Rose, Requisite Pro, Clear case, Clear quest

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Business Analyst

Responsibilities:

• Performed Gap Analysis, Impact Analysis to check compatibility of the existing system infrastructure with new business requirements and suggested methods to overcome them
• Developed and gave presentations and product demos to the team for the flow of data in the seven modules.
• Extensively used OBIEE 11 for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Coordinated with the test team and helped in test case execution and tracking using HP ALM
• Documented system enhancements and coordinated with project team by facilitating JAD sessions
• Created the Training manual for the End Users for SnapTicket functionality
• Dealt with Business aspects of Hedging Techniques, Market Risk and Financial Risk Management
• Documented Financial Data Requirements with regards to Equity Trades and Fixed Income Securities to bring the data into Data Warehouse and Business Intelligence Applications
• Provide the presentations to fund managers on data mapping of Cash flow files, Interest Cash Flow, Ticker Symbols, settlement of the contracts and Margin Requirements
• Worked in the Oracle BI Apps Implementation, Support Projects and OBIEE Upgrade Project
• Created the OBIEE reports as per the functional documents.
• Developed Business models to represent business logic for Sales and created logical tables and defined the complex joins for a business model.
• Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio
• Analyzed Third Party Vendors Trade, Cash Flow and Interest Rate Agreement Files in format of XML/XSLT coming as Source to Confidential Platform via SFTP

Environment: SQL Server, UML, Quality Center, SSIS, HP ALM,MS office 2010, MS project 2010, MS excel 2010, OBIEE, MS PowerPoint 2010 and MS Visio 2010, Adobe Acrobat XI Pro.

Confidential

Business Analyst

Responsibilities:

• Acted as a Subject Matter Experts to development teams producing the technical specifications in the BRD for Insurance Brokerage System, implementing the agile methodology
• Led requirements elicitation sessions to understand business problems and how proposed system enhancements address them while assessing impact to existing functionality and business processes
• Produced business requirement artifacts - including UML, Use Cases, Business Rules, Supplemental (Non-Functional) Specifications, and User Interface Design Specifications and requirement traceability matrix
• Involved in developing a solution to issues/project work within the tool set of NextGen
• Conducting Knowledge gathering and Knowledge Transfer to the existing team and new team members.
• Created Test Cases, test data, executedmanual unit tests, documented results and updateddefect-tracking systems using agile methodology.
• Participated in the user experience sessions and provided input to the system’s team on the usability of the banking systems.
• Interpreted business requirements from subject matter experts (SME) and wrote user stories resulting in a clearer and more detailed understanding of project deliverables.
• Extensively used SSIS Import/Export Wizard for performing ETL operations.
• Performed Smoke testing & Regression testing of integrated modules and completed Logging & Tracking Defects in JIRA.
• Scripted complex SQL Queries, Procedures & Views for data analysis and data extraction.
• Acted as a liaison between technical and business teams to ensure client needs are met in UI enhancements.
• Analyzed transactional data by Performing Data Filtering, Data Cleansing and Data Profiling using automated Python.
• Performed Query Optimization and T-SQL Tuning to improve the application performance during run time by 20%.
• Supported PMO with testing reporting requirements every week using VLOOKUP and Pivot tables in multiple projects.
• Generated monthly reports using Tableau for monitoring the application performance metrics.

Environment: Windows XP/2000, MS Outlook, MS Excel, SQL, Business Objects, Word, Share Point, Sales Force, PowerPoint, QC, Rational Clear Case, Clear Quest, DOORS, JIRA, Oracle 11g

Confidential

Responsibilities:

• Gathered, Elicited and published technical System Requirements for the RTM platform.
• Lead Meetings with offshore team to finalize the requirement.
• Conducted review of System Requirements documentation and participate in reviews of other artifacts
• Owned requirement management and refinement through phases of the project life cycle, including ownership of requirements traceability and carry out updates to documents arising from defects found in the design and construction phases
• Facilitated in scope-shaping exercises with integrated BSAs, Architects & Tech Leads to ensure System Requirements satisfied project business requirements and were aligned with the eAPI standards and long term objectives.
• Worked on converting functional requirements into technical/solution specification document
• Communicated with the development team and proactively raise, clarify and follow up on issues.
• Performed Credit Risk Analysis
• Reviewed test cases and test results
• Responsible fordocumenting the As-Is process and to-be process.
• Contributed to team Requirement Management activities and processes
• Responsible for interacting with developers and help them understand the requirements and working on technical requirements.
• Interfaced with business users and technical staff to translate business process requirements into technical documentation such as functional requirement document, use cases, and process flows using MS Visio
• Generated Unified Modeling Language (UML) diagrams to demonstrate critical processes

Environment: MS Project 2013, MS Visio 2013, MS Word 2013, MS Excel 2013, Quality Center 9.2, Oracle 9i,, MS Outlook

Confidential

Business Analyst

Responsibilities:

• Conducted high-level interview sessions to understanding the needs of multiple stakeholders across the organization
• Performing Gap Analysis by modeling and mapping as-is and to-be business process using MS Visio.
• Gathered and documented business requirements, functional, and technical requirements using UML diagrams and use cases.
• Prepared requirements specification documents include Vision and Scope Document, Business Requirements Document (BRD), Functional Requirements Document (FRD), and Technical Requirements Document (TRD) using Rational Requisite Pro.
• Documented the Requirements Traceability Matrix (RTM) for tracing the Test Cases and requirements
• Assisted testers to develop test plans, test design specs and test cases to match business requirements and thoroughly test software to ensure proper operation.
• Leads user acceptance testing efforts to ensure that the software implementation meets the needs of business end users
• Managed stakeholder communications and the project scope change control process
• Served as the primary point of contact for all matters related to the project’s performance

Environment: MS Word, MS PowerPoint, MS Visio, MS Access, MS Excel, MS Outlook, UML, Rational Requisite Pro, SQL Server, Waterfall