SUMMARY

• Over 8 Years of experience as a BA/BSA in various domains including Finance, Banking, e-Commerce, Mobility, Insurance Property Casualty/Worker's Compensation
• Expert communicator written, verbal and presentation involved in high level interaction and influence with variety of audiences Senior Executives, Clients PMs, developers, SME as well as PMO
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations
• Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
• In depth knowledge of the Software Development Life Cycle SDLC using Agile and other methodologies such as Rational Unified Process RUP and Waterfall
• Experienced working with BI Datawarehousing tools like Informatica and Hyperion Essbase
• Proficient in IBM Security Identity and Access Management IAM
• In-depth knowledge of Project Management Book of Knowledge PMBOK
• Proficient in creating and managing Requirement Traceability Matrix RTM for tracking and managing changes based on project's evolving needs.
• Facilitated Joint Application Design JAD and Rapid Application Development RAD teams with all IT group members for communicating managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
• Working knowledge in writing SQL query for identifying databases involved in the application development.
• Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivatives Back-Office operations.
• Understanding of various debt instruments including T-bills, T-bonds, Municipal bonds including revenue tax-exempt bonds and corporate bonds.
• Understanding of investment banking, asset management and other fund management functions.
• Understanding of AML reports including Suspicious Activity Reporting SAR , OFAC reports, Currency Transaction Report CTR , Foreign Bank Financial Accounts FBAR and CMIR reports.
• Understanding of different mortgage instruments like Mortgage backed securities, CMOs, CDOs including the tranche structuring and credit enhancement processes to manage prepayment and credit risk. Knowledge and understanding of the functions of mortgage agencies like Ginnie Mae, Fannie Mae and Freddie Mac.
• Understanding of Dodd-Frank Act and the implications of its various key provisions like Volcker rule, Collins Amendment on bank's trading activities and capital requirements including Basel II, Basel III.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
• Worked with star and snow flat schemas to create fact and dimension tables.
• Created tabular, matrix, pie, bar and column reports to meet client requirements.
• Performed ETL and analyze different sources of incoming data and performed various transformations.
• Performed GAP and cost-benefit analysis as required.
• Worked extensively with application programmers to develop proposed solution prototypes.
• Wrote use cases and Developed Test Plans and created Test Cases.
• Obtained expertise in performing System, Acceptance, Regression, Integration and Functionality Testing.
• Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance UAT , System Integration SIT and end-to-end testing
• Performed financial analysis such as cost analysis, NPV, IRR, and ROI as well as risk analysis
• Worked on Reports based on the requirements and Test driven development TDD
• Experience using DMAC and RASCI methodologies, root cause analysis etc.
• Proficient in Creating and Transforming Business Requirements into software requirement specification SRS using MS Word and Rational Requisite Pro.

SKILLS

Project Methodologies: RUP, Waterfall, Agile SCRUM

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM

Quality Management: DevTrack, Bugzilla, Jira, Quick Test Professional

Defect Tracking Tools: Rational Clear Quest, Quality center

Languages C , Java, HTML, .NET,XML

Operating Systems: Windows NT/XP/2000/7

Web dev tools: Dreamweaver, FrontPage

Databases: Oracle 8i/9i/10g , SQL Server, MS Access

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

EXPERIENCE

Confidential

Business Systems Analyst

Application was an on-line distributed financial trading system DTS . A web based continuous electronic market that traders can use to execute bundle orders. The application used Automated Matching Mechanism providing universal access to traders on the Internet, allowed interactive information exchange between traders and market makers. Worked with Stocks, Options, Futures, Derivatives and Fixed Income.

Responsibilities

• Followed RUP approach of development throughout the project
• Involved in defining scope of the project along with vision statement.
• With the help of the Financial Analyst, Designed and created Excel sheets to provide market analysis charts.
• Coordinated and tracked project communications and also maintained project schedules and milestones.
• Accumulated customer requirements from various end users through surveys, interviews and JAD sessions and analyzed the requirements.
• Created functional, technical and system requirement documents for trading system.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Applied Unified Modeling Language UML methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational RequisitePro.
• Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1,2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Design detailed FRD according to BRD and Basel regulatory requirements using Power Designer.
• Created test plans for Test driven development TDD
• Performed manual front-end testing to check all functionalities of different modules using Test Director for bug tracking.
• Administered Identity and Access Management IAM , including password management controls for staff and vendors assigned to department-level projects.
• Created tabular, matrix, pie, bar, drill down and drill through repots using SSRS.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.

Environment Business Objects, Informatica,, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer, SharePoint

Confidential

Business Analyst

responsibilities:

• Served as a liaison between the business and technical developers to define problems, enhancements, and solutions.
• Facilitate Work sessions and Solution discussions across business units to understand reported problems and to drive acceptable solutions / workarounds.
• Working with clients to better understand their needs and present solutions using Agile approach.
• Interacted with the Agile team to gather requirements from the customer and documented for use by the developers through Story Card.
• Created best-practice requirements deliverables, such as use cases, system process flows and context diagrams
• Gathered requirements, developed Process Model and detailed Business Policies.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Review Use Case History to identify existing requirements that support claimed functionality performance.
• Documented the FRDs and BRDs for Ecommerce projects.
• These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface
• Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
• Conducted Gap Analysis for the system considering AS IS and TO BE features.
• Develop user manuals, presentations and training manuals as per project specifications and timelines.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Drive Problem Resolution by holding resources accountable for delivery dates and pursuing continual follow through as necessary, this can include additional technical team meetings to brainstorm ideas.
• Conducted UAT sessions to approval.
• Facilitated the design and development of Business Rule Engines to support SOA architecture and web services.
• Worked closely with System Architect to implement Service Oriented Architecture SOA , Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Partner with Release Management areas to insure any potential issues or road blocks are avoided and approved Release Candidates are deployed on time.
• Proficient in writing good SQL queries.
• Develop and foster relationships with business and development teams to ensure transparency of processes to resolve more Critical / High priority problems that meet our business and ultimately our Guests expectations.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Build and managed a cohesive team to meet deliverables per project / track assigned.
• Provided customer support as required to meet service level agreements.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.

Environments SharePoint, MS Office, MS Project, Oracle Agile PLM, SharePoint 2010, Informatica, Java, XML, MS Visio, Agile, Quality Center, SOA, SQL.

Confidential

Business Data Analyst

Confidential is a diversified financial services organization providing financial market intelligence. The project was a mainframe based application involved enhancement of the automated Mortgage loan origination process beginning from origination/opening a Mortgage application through funding/closing. The system performs all the Business functions of the loan process such as set-up Account information, New Loan set-up, Escrow Analysis, the Appraisal, credit, and income. Also worked on the mobile application that was developed specifically for their Private Wealth Management line of business

Responsibilities

• Gathered requirements from business users and analyzed them using Rational RequisitePro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to automate the loan approval process for home Mortgage online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review
• Acquired in-depth knowledge of the banking industry Mortgage, Assets, and Accounts Receivables/Accounts Payables etc
• Gathered business requirements through interviews, surveys, and observing from account managers and UI User Interface of the existing Brokerage Portal system
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design OOD using Rational Rose according to the UML methodology
• Developed use cases/diagrams, conceptual model, behavior diagrams sequence, collaboration, state chart, Activity , using MS Visio
• Involved in testing all the data elements in RSIs Mortgage Account Inquiry Service, which is called by CCW to obtain Mortgage loan data from MSP
• Worked on mapping of MSP Webservices to Enterprise Interface Partners and coordinated with FIS on MSP
• Sketched diagrams of proposed and existing systems using Visio
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro
• Supported IT Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow
• Created a RACI matrix based on the organization standards for ongoing operations and issue resolution procedures
• Gained thorough understanding of Cash Management, Liquidity Positions and Liquidity Ratios
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing
• Tracked changes using Rational ClearQuest
• Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place
• Conducted User Acceptance Testing UAT
• Participated in developing of Training Materials for the new technology and User Training
• Worked effectively with Project Manager in handling the whole project

Environment SDLC, Agile Methodology, UML, Oracle, MS Project, MS Office.

Confidential

Business Analyst

Confidential is an MGA who works on behalf of Insurance Company who will design the rates, Collect the premium, Issue the Policy and Settle the claims. Client is operating in 2 States California San Diego and Florida Jacksonville . PREMIA is the core insurance product which handles Policy Issuance, Policy Servicing, Claims and Billing.

Responsibilities

• Analyzed client systems and Business processes.
• Organized Joint Application developments JAD , Joint Application Requirements sessions JAR , Interviews and Requirement Elicitation sessions.
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and requirement gathering
• Gathered Business Requirements, created Functional Requirements FRD and analyzed data/workflows to define the scope, project financials and progressed from problem statements to well documented designs.
• Documentation of the AS-IS and TO-BE process for current and future phases of the Claims Management System
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Gathered requirements for Policy Admin, Claims and Billing module for Non-Standard Auto, Home Owners, and Worker's Compensation policies.
• Worked as a Personal Lines Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Documented and delivered Functional Specification Document, DD Documents and various other documents needed for the project team
• Conducted JAD sessions for communicating with Stakeholders and Project delivery heads.
• Developed business requirement specification documents as well as high-level project plan
• Developed timelines for Project delivery and Managed projects/resources
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Provided Training, UAT and Product support
• Involved in the creation for Manual Raters for Auto products
• Monitoring the Configuration and Customizations activities
• Change Management
• Worked as a Single point of Contact for Offshore and Onsite Model.

Environment Windows NT/2000, MS SQL Server, Rational Unified Process RUP , Facets 4.21, UML, Rational Rose, Mercury Test Director, MS Office Tools.

Confidential

Business Analyst

Confidential is a web portal application used by bankers to manage relationship with their client contacts. eBanker also allows relationship ranking of contacts and has feature to setup notification for lonely contacts. Through various subsidiaries, the company provides brokerage, Credit Derivatives, Mortgages, Retail Banking, Assessment Management and capital markets services.

Responsibilities

• Identified Use cases from the Functional Requirements and wrote Use Case Specifications and created TO-BE Business Process Workflow diagrams Activity diagrams in MS VISIO.
• Developed BRD Business Requirement document , ORD Operational Requirement Document and FRD Functional Requirement Document , HLD High level Design Document , LLD Low Level Degin Document .
• Participated in JAD Sessions for gathering requirements from SME'S. Played the role of a Facilitator in the JAD session.
• Documented the AS-IS Business Workflow adhering to UML standards. Comprehensively performed requirement gathering for enterprise reporting system-using Requisite Pro.
• Worked with different business users to develop Vision Document and Business Requirement Specifications by gathering Business and Functional Requirements. Experience supporting the full Software Development Life Cycle SDLC in Agile Scrum methodology.
• Investment Banking financiers work with businesses to help them with budgetary issues. Involved in raising money for new ventures or streamlining business costs by identifying areas of excessive spending.
• Understanding of Trade Life Cycle Middle office functions. Responsible in the back office operations such as accounting and human resources are in place to hold the business together from a financial and legal standpoint.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Created Use Case Diagrams using MS VISIO and Rational Rose in order to show the interaction between the Actors and Use Cases as well as showing the relationship between the Use Cases.
• Performed extensive business process analysis including Data Mapping, Data analysis and GAP analysis. Involved in version control management for storage and distribution of documentation using Rational ClearCase.
• Performed data integrity and balance sheet verification procedures, as well as contributing to process improvements in the product control function.
• Maintained a Traceability Matrix to ensure that all Functional Requirements are addressed at the Use Case Level as well as the Test Case Level.
• Performed Functional and GUI Testing to ensure that the user acceptance criteria are met. Created User training materials. Co-coordinated the User acceptance testing UAT with the SME'S to make sure that all the Business Requirements are addressed in the application.
• Wrote SQL Queries, such as Joints, Sub Query, correlated sub query and nested queries to retrive data from various tables in the database.
• Conducted User Acceptance Testing UAT and System Integration Testing SIT to certify that the functionality designed and developed meets the business requirements and expectations
• Worked on the ETL process used by the Data Stage System designers used for extracting data from heterogeneous source systems, transforming and loading the data into the data warehouse/ data marts

Environment Hyperion Essbase, Oracle, .Net, Windows 7, Acrobat Pro, iRise, Lotus Notes, MS Suits 2010, SharePoint server 2010, MS Showcase, Rational RequisitePro 7.1, Rational Rose 7.0, SQL Server 2008R2, Quality center 10 and LoadRunner 9.5.