SUMMARY

• With 8+ of years of professional experience in business analysis, Systems Analsis, business process analysis, business requirements, database design, business process modeling and strategic planning in the field of Insurance and Financial Services Industry including Group and Individual Life Insurance, Annuity.
• Proficiency in Business Requirement gathering,Business Process flow,Business Process Modelling (BPM), Process Redesign,Business Process Re - engineering and testing, etc. with a keen awareness of developers and end-users needs and able to deal with user groups at all levels efficiently.
• Adhered to BPMN standards for Visio process models.
• Strong Knowledge and hands on experience with SDLC methodologies like Agile/scrum and Waterfall.
• Excellent understanding of Business Requirements Gathering, Evaluating Database Sources, Translating Requirements into Specification/ Functional and Technical Documents.
• Experience attending and collaborating on the conduction of SCRUM ceremonies: Sprint Planning, Sprint Review, Daily Stand-Up Meeting and Retrospective Meetings.
• Vast experience conducting and documenting the "AS-IS" and "TO-BE" processes and Business Process Re-engineering (BPR) exercises along with understanding of Rapid Application Development (RAD), Systems Implementation and Continuous Improvement techniques
• Provided detailed process flow and process maps.
• Conducted Joint application development (JAD) sessions with relevant Subject Matter Experts and documented reports, implementation requirements, project status reports, oral presentations, e-mails, etc.
• Adept in gathering business requirements pertaining to functional, non-functional, and data aspects of thebusiness. Held meeting with stakeholders and end-users to determine needs and necessities.
• Authored business and system requirements analyses and functional specifications with supportingbusinessprocess flows (data modelling), Traceability matrices, risk analysis.
• Worked on Requirements Traceability Matrix to trace thebusinessrequirements back to logical model.
• Assisted UI/UX team in translating client graphical requirements to reality by creating Mock up Screens.
• Strong experience in Application Design (Prototyping, Screen Mock-ups), wireframes, UI design.
• Experience with Data analysis and SQL querying with database integrations.
• Strong knowledge of SQL and SQL scripts.
• Experience in using defect tracking tools JIRA & HP QC to address bugs/issues and interacting with development team to fix them.
• Experienced in MS Office (Word, PowerPoint, Excel, and Visio)
• Experience in the documentation of system andbusinessrequirements and specifications, design, and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.

TECHNICAL SKILLS

• MS Word
• MS Excel
• MS PowerPoint
• MS Access
• MS Outlook
• ALM
• Rational Enterprise Suite
• Load Runner
• JIRA
• Rational Clear Quest
• QTP
• Rational Rose
• Balsamic
• Microsoft Visio
• Waterfall
• Agile (Scrum
• Kanban)
• Tableau
• Excel
• SQL
• HP Quality Center
• SoapUI
• AxureRP
• Envision
• MS Visio
• DBMS
• MS SQL Server
• Oracle 11g
• Oracle10g/9i
• DB2
• Windows 7, 10
• MS DOS.Bankware.net
• SAP R/3
• UML
• MS-Visio
• ER
• Requisite Pro
• FTP
• RTC

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Business Systems Analyst

Responsibilities:

• Conducted various interviews, meetings and JAD sessions for requirement gathering with keybusinessusers and SMEs at in-house location.
• Wrote complex SQL queries using joins to verify data on TOAD.
• Performed walkthrough with the development team and systemanalystand incorporated modifications in the original test plan before proceeding with the automated testing.
• Conducted benchmarking activities to identify best practices. Conducted Use Acceptance Testing.
• Worked with the project manager through each iterations of the Agile methodology.
• Introduced Agile to the product team and organized releases into SCRUM sprints.
• Conduct daily stand ups as part of the Agile process.
• Facilitated the Sprint planning, Pre-planning and retrospective sessions as part of a Scrum master responsibility.
• Created burn down charts to estimate the efforts taken to deliver work in each iteration.
• Calculate sprint velocity to estimate the conclusion of the project.
• Constantly groom the product backlog to to have high priority stories completed first to add more value to the work delivered.
• Used JIRA to write user stories as part of the AGILE methodology.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Also conducted gap analysis to derive requirements for the automation process.
• Worked extensively with SMEs in understanding and documenting their requirements pertaining to the issue.
• Assisted the project manager in preparing the project schedules, milestone tracking, and resource allocation using Microsoft project 2000. Created functional specification document.
• Involved in manual testing and UAT with the development team and QA team.
• Worked as a team with Developers and Process Analysts in preparing the requirements, writing workflows, process flows, and Interacted with system developers to resolve questions and discrepancies in BRD.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifact (SRS's and SDS's).
• Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on AGILE methodology.
• Responsible for identifying and documentingbusinessrules, created detailed Use Cases and conducted Credit Derivatives and Fixed Income Derivatives User Acceptance testing.
• Extensively work on Access, MS Visio, Excel, Word, PowerPoint, SQL, and MS Project
• Responsible for identifying and documentingbusinessrules and creating detailed Use Case.
• Performed multiple SQL queries using Oracle 10g and Query Analyzer / SQL Server for Data Analysis; created database driven reports with output to MS Excel and custom reports such as SQL file count, Ad-Hoc reports, and monthly migration reports
• Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT).
• Worked on Application Lifecycle Management for creating test cases and QA purposes.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Collaborated with stakeholders from multiple disciplines to elicitbusiness, data and functional requirements. Stakeholders included: Annuity Product Design, Forms Management, NewBusinessService, Legal and Compliance teams.
• Use of Waterfall SDLC to createBusinessRequirements Document (BRD) by holding JAR meetings with Regulatory stakeholders, reviewing available documentation and interviewingbusinessSME.
• Created Functional Design documents (SRD) by holding JAD sessions withbusinessand IT personnel; extracting information from BRD (s) and meeting with IT SME (s)
• Validated thebusinessrequirements, suggested workarounds and process improvements
• Conduct JAD (Joint Application Design) sessions.
• Worked on as-is process documentation, UML,businessrules, work flows, flow charts, use cases, data flow diagrams, user manuals,businessand technical documentation
• Handledbusinessand technical challenges and worked on all phases of SDLC.
• Worked onbusinessrules, work flows, flow charts, data flow diagrams,businessand technical documentation
• Analyzedbusinessand technical processes, requirements, and data necessary to provide detailed logic for ETL development teams
• Reviewed User Interface design, Navigational Flows, Security access setup and data mapping documents that utilizes inhouse ACCORD XML
• Prepared Unit Test Plans to check functional validity of the customizations.
• Act as bridge between System Integration team and external vendor (developers)
• Developed action plans and project plans for small to medium sized initiatives, related to the data mart.
• Created and Reviewed Functional Requirement Document (FRD) through inputs from project team members to create wireframes, User Interfaces & Use cases includingbusinessand system requirements
• Collaborated efforts with technical staff and subject matter experts to establish the vision of product.
• Participated with QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Created and reviewed UML diagrams, State Diagrams, Use Case Diagrams, and Activity Diagrams in MS Visio.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Used the MS Excel, MS Access for report analysis.
• Experience in Project tracking, management, and reporting using MS Project and in doing presentations and recommendations to plant heads and corporate management.
• Analysed customer data, data elements and applicable data integrity.
• Implemented the optimizedbusinessprocess and solutions which had improved 30% of processing time of data reporting services.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Retrieved Data using SQL queries and did Data Mapping and Data analysis.
• Implement basic SQL queries for QA testing and report / data validation.
• Performed manual testing and created test case and organized test plans & test cases.
• Wrote extensively SQL scripts for validating the data generated by the UATs.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Reviewing & gathering ofbusinessrequirements with thebusinessand creatingbusinessanalysis process.
• Created BRDs, FRDs, FDDs, and TDDs, along with Use Case for application development for retirement plans, such as 401 k, 403 b/k and other non-traditional plans andannuities.
• Analyzed requirements on retirement plans, andannuitiessuch as 401 k, 403 b/k and other non-traditional plans.
• Analyzing and identifying gaps in existing system comparing and contrasting with documentedbusinessrequirements, As-is system and the To-be system.
• Interviewed Stake-Holders, keyBusiness/Super users and Subject Matter Experts (SME's) to understand thebusinessneeds, project objectives and approach to solution.
• Constructed Screen Mockups/Definitions and Dependencies forannuitiesportfolios.
• Created detailed Functional Requirement Specification (FRS) and Non-Functional Requirements for Individual Market Portal Project based on the approved scope document.
• Facilitated JAD sessions and workshops required to understand workflows,businessneeds and storyboards.
• Conducted Scrum meetings on regular basis.
• Kept the Product Owner & Project Manager informed about project status and issues that may impact client relations.
• Attended client meetings and assist with determination of project requirements.
• Organized meetings, team celebrations, between team members and clients.
• Recorded minutes at meetings & kept detailed project notes and records.
• Worked with cross functional team like UX, design, development, QA, marketing and different Line of Businesses.
• Generated Use Case diagrams, Activity diagrams,BusinessObject to depict process flows and PowerPoint presentations.
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Worked on defining the sprint scope and oversee the BA schedule and deliverables.
• Worked with IT to design and develop data collection and management tools to manage the information.
• Created a roadmap for the Internal Communications department to enhance the overall employee engagement and increase productivity.
• Responsible for syncing requirements from ReqPro to Quality Center using sync tool.
• Articulated UML through Use cases, use case document by specifying actors, normal flow, sub flow, alternative flows.
• Collected and documented policies, calculation methods,businessprocesses as well asbusinessrules.
• Worked closely with test team for user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Developed the test scenarios and test plans based onbusinessrequirements, technical specifications and/or product knowledge in Quality Center.

Confidential, NJ

Business Analyst

Responsibilities:

• Work in the capacity of aBusinessSystemanalystand assist in gatheringbusinessrequirements from the stakeholders and convert them into technical requirements for the developers to work off.
• Participated in using the Agile Methodologies on projects utilizing full Systems DevelopmentLifeCycle (SDLC), while using MS SharePoint for storing project documents.
• Worked with Project manager to identify best approach for gathering requirements.
• Work closely with developers to review user requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, process flows, and other UML diagrams using Microsoft Visio.
• Conducted requirement gathering sessions with the purpose of creating User Stories, Epics, and Features created for the various releases throughout the year.
• Assist in test plans and test cases and perform user acceptance testing (UAT).
• Prepare internal management reports such as weekly project status report; time reporting against projects, meeting minutes, agendas, and project plans which is required by the CIO and other management staff.
• Developed Use Stories, Activity Diagrams, Sequence Diagrams using UML and MS Visio.
• Assisted with user testing of systems to validate configuration processes for HR, payroll, and benefits transactions, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Assisted in development of training materials for new technology and process improvements.
• Interacted with team to review and develop XML data standards as well as develop and review data exchange or data sharing models.
• Build CRUD and Traceability matrices to help in development of the system and to keep a check on the requirements.
• Develop project document templates based on SPICE methodology which is a mix of Agile and waterfall methodology.
• Implement basic SQL queries for QA testing and report / data validation.
• Worked and successfully implemented WORKFLOW to automate the underwriting process
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Performed manual Back-End testing by writing SQL queries for validating user information available in the tables.
• Coordinated with the UAT and Project management teams and performed User Acceptance Testing with the Users.
• Initiate and facilitate JAD sessions and Requirement walkthroughs before entering into the development phase.
• Create and maintain a list of inventory used for applications and interfaces used by the system network.
• Use SQL server for refactoring the code written by developers.
• Prepared and Presented Weekly Project reports to senior Management
• Created sample Wire frames using iRise to make system better understood byBusinessand technology teams.
• Build project related Technical specification documents and training materials for the developers and uses respectively.

Confidential, Montpelier, VT

Business Analyst

Responsibilities:

• Closely worked with development team to make sure whether the software application fits within the architecture and has the required behaviors.
• Manages the product backlog (grooming, prioritization and refinement), working day-to-day with the product Agile/Scrum teams to clarify requirements balance thebusinessneeds with technical requirements.
• Document user stories, creating process flows, wireframes and mock ups.
• Utilizing Agile Process for streamlining the team development activities.
• Participated in all major SCRUM ceremonies: Stand up, Sprint Planning, Sprint Review and Sprint Retrospective.
• Created user stories, broke down epics, worked with team to determine points in JIRA.
• Responsible for gathering requirements from users and SMEs.
• Conducted GAP Analysis after analysing AS-ISbusinessprocess and the TO-BEbusinessprocess.
• Performedbusinessprocess re-engineering by analysing thebusinessrequirements and changes in work flow.
• Initiated and validated changes and facilitated new user training sessions and provide user support for the application after project release.
• Used MS Visio for Process modelling andBusinessProcess flow diagrams.
• Created the project organization chart; involved in resource planning, selection, training, management and appraisals of staff.
• Worked with UX engineers to provide mock ups and prototypes.
• Gather requirements and translate intobusinessprocesses as well as UI wireframes.
• Performed requirement analysis including data analysis and GAP analysis.
• Worked with the developers assisting them in writing SQL queries for validating data.
• Created Data Mapping Documents and worked withbusinessto write transformation rules and UAT testing plans.
• Managed requirements through Requirements Traceability Matrix (RTM)
• Used Jira for bug tracking and reporting.