PROFESSIONAL SUMMARY:

• Around 5+ years of professional experience in the Analysis, Design, Development, Implementation, Testing of Client/Server and Web Applications.
• Extensive experience as a Business and Systems Analysis, and Process Improvement in insurance and finance industries.
• Expertise in Technical Writing, Business Analysis, Joint Application Development, Process Management, Requirements gathering, data analysis and management of documentation.
• Involved in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Excellent in Data Analysis, Software Analysis and Modelling of web/enterprise wide client/server based applications. Strong understanding of software development life cycle and object - oriented methodologies.
• Extensive experience in all the phases of Software Development Life Cycle (SDLC) including requirements, design, test, integration and implementation.
• Involved in Supporting Product Owner in pre-grooming, Backlog refinement and product backlog.
• Experience with Star schema modelling and knowledge of Snowflake dimensional modelling.
• Practical experience in Water-Fall Model and Agile (SCRUM).
• Practical experience implementing Agile methodologies to drive projects including creation of Agile artifacts. Well versed with other software methodologies like- Agile-SCRUM, Waterfall.
• Good experience with PEGA for customer relationship management (CRM), digital process automation, and business process management.
• Extensively worked on requirement engineering, gathering business functional requirements that matched technical systems setups and configuration.
• Good experience in remediation activities like Record Retention, and application governance.
• Extensively used JIRA, and HP ALM for requirements gathering, requirements management, use case development, use case management and setting traceability using traceability matrix.
• Prepared workflow diagrams by analysing “As Is” and “To Be” scenarios
• Sound Understanding of Joint Application Development (JAD) and an active participant in all the activities of a JAD session.
• Experience in drawing UML diagrams (Use Case Diagrams, State diagrams, Sequence diagrams, Activity diagrams, Collaboration diagrams) using MS Visio.
• Experience in conducting User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis, risk Analysis, and ROI analysis.
• Understanding of the legal / regulatory governance, risk management, controls and compliance requirements.
• Developed use case models, and use cases to capture the high-level objectives of an application during the initial phase of development.
• Experience in conducting GAP analysis.
• Used MS Visio for Business Process Modeling and Data flow diagrams.
• Extensive experience in Extract, Transfer and Load process using ETL tools like Informatica and SQL Server Integration Services for Data migration and Data Warehousing projects along with good project management skills.
• Expertise in using various tools like MS-Visio for Functional Flow charts, Organizational charts, Business Process diagrams along with MS-Project for project management.
• Strong knowledge of SQL.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.
• Experienced in the complete Quality Assurance (QA) life cycle from Requirements Gathering and Documentations to developing Test Plan, Test Cases, and conducting User Acceptance Testing (UAT) for QA Testing.
• Experience with working independently as well as part of a team. Highly motivated team player with excellent communication, presentation and inter-personal skills, looking forward to work in a challenging environment.

TECHNICAL PROFICIENCY:

Methodologies: Agile-SCRUM, Waterfall

Requirement Tracking: JIRA, ALM

Defect Management Tools: JIRA, QC/ALM

Operating Systems: MS Windows, UNIX

Databases: MS SQL Server, Oracle, MS Access

MS Office Tools: MS Word, Excel, Project, Outlook, Visio

Business Modeling Tools: Microsoft Visio

PROFESSIONAL WORK EXPERIENCE:

Confidential, Cedar Rapids, IA

Business System Analyst

Responsibilities:

• Coordinated with Business and Architecture to analyzed Big Data Sources to scale out the storage capacity needed for the data lake consists of petabytes.
• Provided support to Product Owner in developing, maintaining and grooming product backlog.
• Extensive experience with Agile Methodology.
• Participated in Backlog Refinement, Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective meetings using Scrumban Methodology (Scrum with Kanban).
• Documented metadata definitions, synonyms, data quality rules, translation rules, and usage of the Critical Data Elements (CDE's).
• Performed data profiling and data cleansing to identify duplicate data and null data. Worked on data validation, translation and use of data to create lookup tables needed for the downstream systems to generate accounting.
• Developing Custom Report and different types of Reports, Matrix Reports and distributed reports in multiple formats using Tableau Server.
• Involved in preparing functional workflow diagrams for requirements/module owned and prepare functional specifications in Pega tool for module specific requirements (user story wise).
• Analyzed “TO BE” scenarios based on the data that are currently required to generate reports.
• Develop advanced Tableau dashboards using multiple data sources, creating calculations, parameters, and interactive filters.
• Gathered functional and non-functional requirements of the system including requirements and processes for life and annuity.
• Organized and facilitated Agile-Scrum meetings, which included Sprint Planning, Daily Scrums or Stand ups, Sprint Check-In, Sprint Review & Retrospective.
• Assisted the data sourcing team to integrate data using ETL tools, and involved in implementing complex Tableau reporting solutions.
• Created source to target mapping specifications.
• Active participation in documenting and creating the report requirements for PEGA Initiative.
• Involved in validating XML Request and Response Files.
• Involved in data analysis, developed reports, dashboards and SQL queries using Tableau.
• Review technical specifications for each change request to ensure the business need is being met.
• Was responsible for reviewing and modifying process flows to increase productivity.
• Extensive experience in the requirement gathering process.
• Documented process questionnaire, current state mapping, gap analysis, and future state mapping to develop master data storage in domain key normal form.
• Extensive experience with the Aptitude Accounting Hub to create Journal Entries using transactional data and referential data from the Enterprise Charts Of Accounts which contains CLAC (Company Ledger Account and Center). Developed detailed journal entries which have contract level granular details (captured at the correct grain) and summarized journal entries which have multiple detailed journal entries going to the same account number and line of business assigned from the Charts of Accounts posting to the General Ledger.
• Prepared UAT test cases with test data, conducted UAT session with business users, collected feedback from the users and incorporated those feedbacks in the test plan according to the decision.
• Expertise in using various tools like MS-Visio, MS-Excel, MS-PowerPoint, Jira, Share Point, Confluence and Collibra.
• Experience with working independently as well as part of a team. Highly motivated team player with excellent analytical skills, presentation, coordination, project planning, estimation, development of schedule and quality matrices, organizational and interpersonal skills.

Environment: Scrum, Kanban, Oracle, Tableau, JIRA, ETL, SQL Server, Confluence, MS-Visio, MS-Excel (Macros & V-lookup), MS-Outlook.

Confidential, Concord, NH

Business Analyst

Responsibilities:

• Conducted User Interviews, Gathered Requirements, analysed, and documented business requirements based on the analysis of Insurance Processing Workflow Model.
• Analysed various Steps in the Insurance Lifecycle and designed the system to identify & monitor the riskier insurances.
• Analysed and prioritized key reports for day to day servicing needs for insurance monitoring processing and Inspection.
• Addressed all aspects of the Insurance Lifecycle, starting from identifying a deal right up to insurance closure.
• Worked closely to project managers and developers in Agile and Waterfall environment.
• Defined and documented the vision and scope of the project.
• Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts
• Extensively worked on Analysing data, applying business rules, designing the data warehouse, creating data mart/ schemas, partitioning the data, creating easy/quickest ETL process to load the data and automating the ETL process.
• Identifying and managing data requirements scope, risks and issues.
• Knowledge on Life Insurance terminology and Data Structures ( such as Acord model).
• Experience in working with the new business request in automated data transmission from third party vendor via Acord 103 XML .
• Experienced in electronic ticket submission to LifeWriter for underwriting process.
• Worked on Automated Underwriting and Lab free project to create a process to pass clean case automatically. The system will order Medical Information Bureau Report, Motor Vehicle Report, Pharmacy Report, Uranalysis, Blood or Vitals etc as needed, then approve, refer or declined the Life Insurance case.
• Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
• Prioritize the requirements and performed feasibility analysis and risk analysis on the application
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Used Jira for defect tracking. Participated in the Defect Review Meetings, Updated requirement document as per business user feedback.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Provided Functional Specification to development team to build Enterprise Reporting Systems.
• Used DOORS for overall Requirements Management and to build the Requirements Traceability Matrix.
• Performed data analysis and data mapping to complete existing documentation.
• Used SQL Server Database query for analysis.
• Performed Integration testing (end-to-end testing)
• Developed business process models in Agile Methodology (Scrum) to document existing and future business processes. Created graphical representations of complex business processes.
• Analysing the of data which is extract from source table and transform to the target table by using the sql query.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Involved in redesigning the organization resources as process re-engineering.
• Assisted client in developing content and materials; recommended enhancements and identified new business requirements.
• Developed test cases and test plans in HPALM/QC on the basis of requirements
• Coordinated with the development team and the business area to develop mock up screens.
• Assisted with product evaluation, product customization and system integration.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Insurance Monitoring and Asset Management.
• Managing and grooming product backlog along with the product owner.
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables).
• Proficient in Microsoft Word, Power Point, Access.
• Conducted User Acceptance Testing (UAT).

Environment: Windows XP, MS Word, Excel, PowerPoint, Jira, Visio, LifeWriter, ALIP (Accenture Life Insurance Platform), XML, MS SQL Server, UML, SQL Server Database.

Confidential, NY

Business/System Analyst

Responsibilities:

• Followed agile methodology for the entire Software Development process (SDLC).
• Participated in the research and gathering business requirements through conducting surveys, interviews and JAD sessions.
• Actively contribute in client engagements and requirement workshops.
• Create project status reports highlighting critical issues for management and overall status of the project.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks.
• Gathered requirements for the Worker's Compensation, Personal Auto and Commercial property in Claims Center.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Conducted Requirement Gathering Sessions with the stakeholders.
• Incorporated stakeholder feedback throughout the project lifecycle to ensure project quality and customer satisfaction.
• Involved in handling various customers and change management.
• Acting as a liaison between Business Analyst and Developers to analyze current system functionality and elicit business/system requirements.
• Created user stories, improvements as per business requirements.
• Responsible for creating test cases/ scenarios from user stories and executing test script for various demands.
• Involved in requirement gathering and data analysis
• Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Initiating the fortnightly sprint-planning meetings and including the items from the product backlog to the spring backlog after prioritization.
• Generated PEGA specific artefacts such as application profiles, application documents, discovery maps, sizing documents etc.
• Used Agile practices like documenting User Stories, facilitating Story Point discussions to analyze the level of effort on project specifications.
• Worked on the project plan and documentation of Business Requirement Documents by ensuring requirement gathering from end users.
• Collected, analyzed, maintained, and iterated user requirements from customers using customer surveys, online digital traffic, and in-person interviews.
• Used statistical analysis to draw valuable insights, evaluating customer needs and areas of growth.
• Worked in Testing and Maintenance of project, Producing the project/Program plan, Monitoring and executing it
• Specified the system architecture and design utilizing the Design Models.
• Designed and analyzed the model at different level using Business Process Model and Notation (BPMN).
• Worked on Data-Integration, Data Mapping, Data Profiling and Data Warehouse access using SQL, ETL process.
• Documented business requirements and communicated the requirements with the development team for design and implementation of business solutions.
• Created use-case models, business process flows and activity diagrams using UML.
• Managed the ETL and Business Intelligence vendor selection life-cycle from business requirements to contract negotiations.
• Involved with functional and regression testing
• Conducted Requirement Gathering Sessions with the stakeholders.
• Incorporated stakeholder feedback throughout the project lifecycle to ensure project quality and customer satisfaction.
• Interacted with the project team to help define the Business and System Objectives, confirmation of scope, identify constraints and the measures of success for the system to be developed.
• Create SQL queries using SQL Server tools to produce Ad-Hoc reports for data quality validation.
• Facilitated testing and validation of report fields and data by generating SQL queries to verify test results in various environments.
• Offered data support and checking using SQL/Query and developed complex spreadsheets using SQL.
• Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show one end-to-end business model. Responsible for creating business flow diagrams (using MS-Visio).
• Gathered and documented PEGA requirements, specifications, and business objectives
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Involved in monitoring and reporting defects by using ALM
• Incorporated User Stories in different release plans for the sprints.
• Assisted Project Managers in the development of weekly and monthly status reports.
• Conducted Gap Analysis during the review of the compliance items for improved future audits.
• Effectively translated business analysis requirements into appropriate data hierarchies, organizational form and technical specifications.
• Used ALM for project tracking, bug tracking, and reporting.
• Responsible for identifying and documenting business rules, conducted User Acceptance Testing (UAT) in terms of the end users.

Environment: Agile, User Stories, MS Visio, SQL Server, MS Office, HPALM/QC, PEGA, Homeowners, UAT, ETL, Oracle, Windows.