SUMMARY

• Business Analyst professional with over 9 years of experience in Banking (both Commercial and Investment), Finance and Property and casualty, Life Insurance and Annuities, Retirement plans.
• Solid understanding of Software Development Life Cycle (SDLC) processes including requirements gathering, analysis and design, development tools technologies and release.
• Experience working with various industry standards: Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Agile Methodology, Capability Maturity Models (CMM), ISO 9001 Quality Management Systems and Six Sigma (DMAIC) Methodology.
• In - depth understanding of Project Management Practices and Principles including Time Management, Budget Management, Resource Management, Risk Management and Change Mgmt.
• Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis and ROI.
• Excellent analytical skills to understand the business process functionality and to translate them to Business Requirement Specification and System Requirement Specifications
• Experience in implementing Rational Unified Process Methodology using Rational tools, working with Agile Development methodology by implementing and delivering Business Processes in iterations
• Familiar with investment banking, capital markets and technology, global reference data, securities lending, Collateral Management and prime brokerage.
• Extensive experience with Fixed Income, Capital Markets, Equities, Trade Lifecycle, Derivatives (Options and Futures), Financial Control.
• Experience working with client on-boarding and new account opening processes.
• Strong experience in database modeling and development of Entity Relationship Diagrams (ERD), SQL (ad hoc queries), Data migration, Data mapping, ETL,MDM and reporting process.(KPIs).
• Excellent leadership, communication and presentation skills.
• Experience working with business users, SME, offshore team and senior management

TECHNICAL SKILLS

Methodologies: RUP, UML, CMM, ISO, DMAIC, Scrum, Agile

Project Management Tools: Microsoft Project, MS-Office, Excel, Power Point

Content Management Tools: Microsoft Sharepoint, Documentum, ServiceNow

Document Design Tools: Rational SoDA, Rational Requisite Pro

Testing tools: Serena, QTP, HP ALM

Business modeling tools: Microsoft Visio 2007, Rational Rose

Version control tools: PVCS, Rational Clear Case

RDBMS/DBMS: Oracle 9i, Access 2003, Sybase, SQL

PROFESSIONAL EXPERIENCE

Confidential, New Haven, CT

Sr. Business Analyst

Responsibilities:

• Worked on implementation of AWD 10.1(Automated Work Distributor) an ITSM solution to automate existing workflow.
• Closely worked with vendors, higher management, and business users of to gather business requirements and implement document automation and customer communications management.
• Worked with Medical vendors in consolidating medical files for underwriting data base changes.
• Lead JAD sessions between business users, developers and AWD vendors to understand the current state and future state of the implementation.
• Worked with business users, business SMEs and IT to further refine system effectiveness and communicated with business users on system productivity.
• Wrote business requirements document (BRD) and business/system process flows to meet the needs of all stakeholders.
• Created Business Process modeling diagrams in AWD as well as Visio diagrams for better understanding of future state workflows.
• Laid out the User Interface look and feel and navigation including forms to be used for the future workflow and Conducted Business Requirement walkthrough to obtain stakeholder sign-off.
• Partner with QA on overall Test Strategy and delineation of tasks as well as creation of Test Plans and Test Cases.
• Helped developers in Performance testing and data validation of documents coming through rip parser in to AWD.
• Helped in Enterprise Support & Product develop event tracking, data models, key performance indicators (KPI), A/B testing strategies, and help architect the BI solution portal.
• Understood front to back Data flow from a system perspectives and created Visio diagrams depicting the flow.
• Participated in End-to-End testing, Integration Testing, User Acceptance Testing (UAT) and end user training.
• Familiarity with Life Insurance, Whole life, Term Insurance, Annuities, Universal Life, Claims.
• Wrote SQL scripts to troubleshoot several production issues and improve performance that helped reduce time involved based on date ranges, departments, Queues and other criteria’s.

Confidential, Norwalk, CT

Sr. Business Analyst

Responsibilities:

• Worked on gathering requirements for a Salesforce CRM Application for Loan origination.
• Worked in an Agile based SDLC as a scrum master and conduct daily standup, sprint review and sprint retrospective meetings.
• Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's.
• Conducted brainstorming sessions with the stakeholders and to understand the current state reporting and wrote requirements for it to be implemented in Salesforce.
• Worked with Informatica (ETL) to validate data mapping from Salesforce to old data system to enable reporting.
• Create user stories in Rally, an Agile management tool and used it for defect tracking too.
• Monitor new loan origination and provide data to Credit Risk Review teams to be used in origination analysis.
• Create and maintain workflows, approval processes, and validation rules based on internal stakeholder requirements.
• Facilitated JAD sessions with SMEs’, Product Owner, and Development managers to understand the business process, requirements and identify changes for the applications.
• Created test plan, test scenarios and coordinated automated testing in QTP.

Confidential, Hartford, CT

Sr. Business System Analyst

Responsibilities:

• Worked on major cross functional Rebranding project and on enhancement of wealth management, Asset Management process flow.
• Receive and review KYC and CIF requests for Amendments, event driven reviews, new and Periodic Reviews for Low, Moderate, and Increased risk rated customers.
• Also worked on accommodating regulatory changes in the in the database by helping the DBA with consolidated requirements.
• Determine if KYC requires escalation to and/or sign off by Compliance.
• Provide product and role information for Static Data Specialists based on KYC file information. Also coordinate client data required for Periodic Reviews.
• Liaise with Business, Compliance, Tax and Legal for client data-related issues.
• Was involved in the planning of the RUP iterations and documenting of the artifacts throughout the various phases of the development process.
• Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's.
• Worked on implementation of Service Now to raise tickets for different helpdesk issues and follow up on them.
• Wrote Application Functional Design Document (AFD/BRD) for various applications across different platforms to be used by developers for coding and did data mapping for the database.
• Worked on Master Data Management (MDM) by using Informatica for data mapping the fund names.
• Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data on different test runs in Quality Center.

Confidential, Columbus, OH

Sr. Business Analyst

Responsibilities:

• Used both Agile/Scrum methodology for the web application used by Agents and Underwriters for providing new Insurance plans and Renewals of a group/company.
• Was able to understand business goals and business context and translated them into technical specifications
• Worked on implementation of Service Now as incident management system (ITIL,ITSM solution) as a member of production support team.
• Managed a team of offshore developers in Europe and a team of offshore testers in South Asia.
• Experienced in web services concepts and support utilities, related database utilities. Demonstrated understanding and experience with ETL, Stored Procedures, and Queries.
• Synchronized and prioritized relevant defects and enhancement/system requests on based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Worked with DBA to perform normalization of the database.
• Defined & managed business specifications end-to-end and acted as facilitator between the Operations run-the-bank teams, IT and other areas such as front office, finance, legal & compliance etc.
• Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process.
• Participated in User Acceptance Testing and Business-to-Business Transaction testing for the project.

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Experience with Wealth Management client on-boarding and new account opening processes.
• Knowledge of Capital Markets, Fixed Income, Trade lifecycle and derivatives.
• Provide product and role information for Static Data Specialists based on KYC file information. Also coordinate client data required for Periodic Reviews.
• Liaise with Business, Compliance, Tax and Legal for client data-related issues
• Delivered business requirement documents, functional specification documents, Use Cases, test plans, and requirement traceability matrices.
• Worked on business applications related to security master, market data, settlements, and reconciliation and performance measurement.
• Conducted Business feasibility and impact analysis of the current functionality with respect to proposed enhancements.
• Maintaining and monitored project progress and status using MS Project, providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
• Interacted with various cross-functional teams to build business use cases and understand banking regulations and Cash-Management functionality.
• Interfaced between business users and offshore development / QA team to ensure the business specifications are met and solicit business sign-offs.
• Drafted User Training Manuals outlining the features of the application and step-by-step process for using the functionality provided by the application.

Confidential, Columbus, OH

Business System Analyst

Responsibilities:

• Used Agile/Scrum methodology as well as Waterfall methodology for the web application used by Agents and Underwriters for providing new sale Insurance plans and Renewals of a group/company.
• Worked in property casualty insurance that included home and auto insurance.
• Also worked on mapping a current flow and future flow for Annuities.
• Gathered requirements, identifying and preparing Use Case specification documents, created Trace-ability matrix and tagging it in the Rational Requisite Pro.
• Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
• Synchronized and prioritized relevant defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Performed extensive data analysis and data integrity testing for loading and validation of the data set output.
• Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process.
• Participated in User Acceptance Testing and Business-to-Business Transaction testing for the project.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Worked with Operations on a major Legal Entity name change project which involved cross functional database change.
• Knowledge of Capital Markets, Fixed Income, Trade lifecycle and derivatives.
• Also worked with Asset Management team in collecting requirement for strategic process improvement.
• Reconcile daily transactions against generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.).
• Prepared Use Cases based on Business Requirements and High Level Design using MS Visio.
• Understood the real end user needs and analyzed their requirements on different platforms performing a cost benefit analysis and Risk analysis.
• Conducted various JAD sessions with different stakeholders in order to get a better understanding of ongoing activities and updating every party of their tasks and assigned duties.
• Documented business rules and business integration processes using BRD (Business Required Documentation) based on the gathered requirements.
• Created Workflow and Activity diagrams using Rational Rose.
• Conducted periodic meetings with technical team in order to make sure that developments are adhered to the business requirements and customer’s expectations.
• Used SQL queries for data validation retrieving the date from the back end.
• Preformed System Testing, Regression Testing, Functional Testing and also Conducted UAT (User Acceptance Testing).

Confidential, Herndon, VA

Business Consultant

Responsibilities:

• Served as a liaison between Mortgage specialists and the project team and gathered user requirements and specifications for designing a Mortgage based loan system.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system.
• Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
• Worked with Project manager, created Work flow diagrams, Activity Diagrams on MS Visio/MS Project using Program Evaluation and Review Technique (PERT) technique.
• Conducted Joint Application Development sessions for requirements gathering with Business Stakeholders, SME’s.
• Created Wireframes, Context Diagrams, Use Case Diagrams and made conceptual illustrations.
• Coordinated with business users to prepare, update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Created data models for the data warehouse and specified data mapping documents from specific data sources.
• Conducted process improvements, status meetings, presided over the Change Control Board meetings to discuss Defect and Enhancement.
• Conducted UAT and Coordinated with the QA Team for the sign-off process before deployment and assisted the Project Manager on creating the Lessons learned document.

Confidential, Richmond, Virginia

Business Analyst

Responsibilities:

• Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
• Developed process flow diagrams Context Diagrams, Wireframes, Swim Lane Diagrams, which helped in Rapid prototyping and pinpointing potential problems early in the process.
• Coordinated with Project Managers, Developers, SME’s to design, create Work Flow Diagrams using MS VISIO.
• Reconcile daily transactions against generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.).
• Process and apply loan payments (checks/wires) in the application and also provide information to the government-assigned and internal auditors.
• Calculate pay-offs and collect on delinquent accounts from financial institutions. And Provide vault custodians with instructions for securities that are being canceled and shipped.
• Generate ad hoc queries and monthly financial reports. And Distribute billing statements to borrowing institutions.