SUMMARY:

• Over around 8 Plus years of extensive experience as a Business Analyst in Software Development Life Cycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process), business and functional requirement gathering, analyzing requirements, business process design and software validation.
• Experience in the implementation of a risk management framework to ensure corporate functions are in compliance with the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
• Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite, MS Visio, Data Warehousing concepts.
• Strong experience in client interaction, understanding business applications and business data flow.
• Knowledge of Basel II/III, CCAR, DFAST, PPNR, ALLL, AML, KYC, Credit Risk/Market Risk/Liquidity Risk Modeling and Management, PD/LGD/EAD modeling, Quantitative Approaches including General Linear Regression (GLM), Time Series Analysis (ARIMA/ARCH/GARCH), Decision Tress, Classification and Cluster Analysis, Principal Component Analysis(PCA), Monte Carol Simulation, and Vector Auto Regression (VAR).
• Hand on Experience in regular auditing, process checks, conflict resolution and database review
• Extensive experience in documenting Business Requirements (BRS), Use Case, Functional and Nonfunctional requirements, Systems Design Specifications, Systems Requirements Specifications (SRS).
• Excellent in performing Gap Analysis to check the compatibility of the existing system infrastructure with new Business Requirements, SWOT analysis, forecasting and traceability matrix.
• Extensive in personal and commercial Property and Casualty insurance and long - term retirement savings products.
• Experienced with Policy & Claims Administration Systems (Insurity Suite a plus), Experienced in Implementing Premium and Claims Interfaces
• Facilitates all aspects of UX Research and Usability Testing: recruiting, scheduling, test materials, scripts, findings, reports and presentations
• Proficient in developing Use Cases, Behavior & Structural diagrams, Business Process Flow based on UML using MS Visio.
• Adept in translating business requirements, reporting requirements and user expectations into detailed system specifications employing Unified Modeling Language (UML).
• Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn down charts and reviewed defects.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Experienced in conducting User Acceptance Testing and coordinating with the UAT participants to get the change requirements.
• Adept in deploying the projects by involving in go-live processes and getting client feedback timely.
• Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making and organization skills.

TECHNICAL SKILLS:

• Requirement Elicitation
• UML (Unified Modeling Language)
• RUP
• Microsoft Office 2010/2007/2003 (Excel
• Word
• PowerPoint
• Access
• Outlook
• Project
• Visio)
• MS SharePoint Business Definition Requirements
• Business Process Analysis & Research
• Use Case Modeling
• JAD/ RAD Sessions
• Requirements Gathering
• Gap Analysis and Impact analysis
• Finance
• Banking
• Mortgage
• Healthcare. Methodologies like Agile
• Waterfall
• RUP and UML. Cognos - BI tool- transform raw data to meaningful things
• SAP BI - to enhance and improve business
• CCAR
• Basel III

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Sr. Business Systems Analyst

Responsibilities:

• Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
• Analyzed market tendency and customer purchasing preference of insurance products and derivatives
• Assisted in modeling to set up sales target, premium rates, payment method and insurance product package to fit in different customer base
• Analyzed different insurance policies to determine risks and identify fraud involved that impact on premium and payments
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Documented High Level Design (HLD) and Low Level Design (LLD) Documents to define the system rules by creating Use cases, interface designs etc. Created Use Case diagram, activity diagrams, sequence diagram in MS Visio.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Prepared and processed documents to disbursed funds, made deposits and prepared reports
• Contribute to the development of improved strategic sourcing strategies.
• Responsible for business requirement analysis, data accuracy and quality check, process/approach/model verification and validation, defect management, and System Integration Test (SIT).
• Involved in Data Governance framework for corporate Data Governance Program used to identify and remedy poor data quality and data quality practices.
• Created gap analysis and specified all required business data for XML messages to place facultative reinsurance submissions, quotations and binder information
• Partnered with business clients to define and capture new key performance indicators and measures to accurately measure business performance to enable business to make better business decisions.
• Entered one-year Property and Casualty program for Confidential . Was responsible for multi line claim adjusting. These areas included Workers Compensation, Property, and General Eligibility.
• Prepared system and quality assurance test plans and user instructions and reference documentation. Noted corrective action, composes instructions for user community and prepares required documentation to support job assignments.
• Interfaced in all aspects of user consulting, business analysis, general systems design, vendor contracts and detail business specification development; learns user functions, organization and role in the enterprise to the extent required.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Focused on the validation process, reviewing the claims submitted by the servicers to the client.
• Involved in creating the Project templates, Use case specifications, Change request form.
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
• Worked with the database design team to assist them in designing the database and also created data dictionary.
• Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
• Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
• Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
• Interpreted business requirements, translating them into business specifications.

Environment: Microsoft Office Suite 2007, MS Visio, MS Excel (Macro), HP Quality Center, SQL Server Management Studio 2005/2008, Reporting Services (SSRS) MS SharePoint. Basel III

Confidential, OH

Sr. Business System Analyst

Responsibilities:

• Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Conducted current state study, which included data collection methodologies, data quality and data integration problems, and data storage issues.
• Experienced in data mapping, metadata management, gap analysis ETL.
• Elicit, document and Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Teradata, Data Warehousing, and Cognos.
• Wrote detailed specifications for various reports generated using Cognos.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues. Documented the requirements such as BRD and FRD.
• Defined product lines allowing for average yields, default rates, prepayments and repayments.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisitepro - RUP
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• 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.
• Created the test cases for all the Use Cases using EA tool also created test scripts with QA team for all the test cases.
• Documented and evaluated test cases/test results/feasibility study of various ETL tools like Informatica.
• Build and maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework. Liaise with FR Y-14 template owners to ensure compliance with instructions and report timing.
• Project management duties coordinating external consulting team of 15+ members; provide critical input and key decision maker of technical solution design.
• U.S. Basel III Liquidity Coverage Ratio - Requirements Analysis
• Performed requirements analysis of the U.S. Basel III Liquidity Coverage ratio (LCR) rules
• Provided oversight over the development of an operational risk model and framework based on the BASEL III pillars (Enhanced Minimum Capital & Liquidity Requirements, Enhanced Supervisory Process, and Enhanced Disclosure-Discipline of Market).
• Provide finance/risk management consulting services on Basel III implementation
• Establish cross-functional reconciliation framework for tie points between FR-Y9C and FR-Y14 reporting templates.
• Worked with Data Governance Program Management to develop a target data governance model along with a roadmap
• Supported and maintained alignment of the Enterprise technology architecture to Agency business strategy, goals and objectives, and the defined architectures of other key Enterprise architecture domains (e.g.
• Application, Data, Security, etc.).
• Involved in the FRY9C and CCAR Q/M/A data analysis and reporting.
• Analyzed and documented the current and the future state of reports related to Credit Risk and different types of securities. Documentation of the processes for all Manual Data feeds and in future to create a Strategic process around the manually sourced data.

Environment: RUP, UML, UAT, SDLC, Rational Rose, SAP, Rational Test Manager, Informatica, Rational Requisite Pro, Rational Clear Case, Rational Rose, UNIX, Oracle 8i, PL/SQL, Mercury Test Director Agile, Waterfall, MS Access, CSV Files, XML File, Basel III

Confidential, Long Island City, NY

Business Systems Analyst

Responsibilities:

• Worked extensively with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
• Conducted and controlled brainstorming sessions with project focus groups which included folks from leadership and management.
• Responsible for researching companies for targeted marketing campaigns, which included in-depth research about the companies, as well as top level management.
• Interacted with the QA team and involved in End to End testing of the interfaces with various scenarios to make sure that the Interface Integration is complete and accurate for different kind of data and protocols (xml data and DB tables via HTTP protocols).
• Created Use Case diagram, activity diagrams, sequence diagram in MS Visio for scenarios including Parole and sentence term scenarios.
• Participate in Daily Agile Scrum "Stand-up", Bi Weekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Established and managed the maintenance of the internal portal database of flight management system
• Highlighted technical requirements to assist managers for RFP documentation for outsourcing potential projects and assist hiring
• Presented and trained recruiting personnel on how to best make use of an online tracking database, and the information/metrics that can be synthesized from it.
• Tracked daily issues and analyzed a solution documentation where required.
• Involved in creating the Project templates, Use case specifications, Change request form.
• Actively participated in CAB meetings and overnight deployments
• Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Tableau.
• Worked with the database design team to assist them in designing the database and also created data dictionary.
• Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
• Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
• Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.

Environment: MS Visio, MS Office Suite, Agile/Scrum, Rational Requisite Pro, UML, Windows XP, SOAP, XML, MS Project, Quality center, .NET, Tableau, SQL Server.

Confidential, New York

Sr. Business System Analyst

Confidential 

Responsibilities:

• Gathered user requirements and directed developers for practical deliverables.
• Analyzed complex financial products and system architectures, including accounting business processes including financial and management reporting (e.g. IFRS and US GAAP), month-end closing process, regulatory reporting, entity consolidations and multi-currency accounting.
• Created and revised reporting templates based on industry standards and project requirements.
• Worked through the complete SDLC, Elicit, Analyze and Define requirements.
• Conducted JAD sessions between the end users and the development team. Worked with the software architects / developers to ensure that the applications conform to customer requirements.
• Used Rational Unified Process (RUP) for streamlining the team’s development activities.
• Created project documentation such as BRD and FRD.
• Analyzed current formats for reporting Accounts Payable,Accounts Receivable and Reconciliation towards using some of the necessary fields in the new format too.
• Utilized Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices.
• Reverse-engineer several databases, such as research, business, and clinical to extract metadata to leverage it for ETL design and reporting.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Experienced in developing Object Oriented Analysis and Design Models; Use Case Model and UML.
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Prepared documents to conduct user acceptance testing.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
• Documented the dimensional models of ETL system.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Tracked UAT issues/bugs and prepared reports.
• Performed job of contact point for all stakeholders (business, legal, compliance, development)
• Took approvals from business owners for business requirements
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project

Environment: UNIX, DB2 UDB, MS PowerPoint, MS Excel, Cognos, RUP, UML, Rational Rose, System Analysis, Testing Strategies.

Confidential, Richmond, VA

Business Analyst

Responsibilities:

• Involved in working with a team of developers and partially responsible for allocation of work.
• Involved in project management activities including project planning, development and execution.
• Analyzed Client requirements and generated workflow process and necessary documents for the project.
• Managed Requirements and communication with user groups and team members using UML diagrams in Rational Rose and Rational Requisitepro.
• Involved in Development of Sale and Profit Reporting and various other interfaces utilizing and importing XML based SOAP messages between various interfaces and services.
• Created Business Required Document (BRD) detailing the solution of the project and the needs of client.
• Assisted Project Teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
• Defined project milestones, schedules by monitoring progress using and updating plans as required using MS project.
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships, and allowed maximum software reuse.
• Documented User Requirements with MS Word as the editing tool.
• Conducted highly interactive JAD sessions with project's stakeholders including users, QA analysts, and project management team to identify and resolve issues.

Environment: Windows, MS Project, MS Visio, UML, SOAP, XML.