SUMMARY

• Over 9 years of professional experience as a Sr. Business Systems Analyst/Quality in Public/Government sector, Healthcare/Insurance/Retail domain.
• Experience in performing data validation after Database migration using Excel functions e.g. Lookup, Macro & Reference functions.
• Expertise in analyzing and gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of testing.
• Experience in developing Scope/Vision Documentation and Project Plan, as well as tracking Project Process, and manage resources to ensure successful delivery
• Knowledge of Benefits Administration, Time and Labor and aspects of Payroll processing to support the complete business process.
• Acted as the liaison between the users and the technical resources of the team.
• Hands on experience with UML modeling, Use Case Documents, Use Case Diagrams, class diagrams, interaction diagrams, activity diagrams, state chart diagrams and documentation of each and every method and attribute.
• Familiarity with interviewing Subject Matter Experts (SME), asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical personnel.
• Experience in conducting Joint Application Development(JAD) sessions and White Board Sessions with end - users, Subject Matter Expert (SMEs) team, Architects and design group development and QA team for project meetings, walkthroughs and customer interviews commensurate with excellent communication skills.
• Knowledge of Rational RequisitePro and its use in documenting test plans and test requirements based on Functionality and Business rules.

TECHNICAL SKILLS

Languages: HTML, SQL, T-SQL.

DBMS: SQL Server (2005/2000/7.0 ), Access 2003, DB2, MySQL, Teradata, TOAD

Analysis/ Design Tools: Erwin, Sybase Power Designer, ER Studio, MS Visio, Rational Rose, TOAD, Oracle Designer 6/8, Rational ClearQuest, Rational ClearCase, HPQC

Operating System: Windows NT 4.0/3.5, XP, Vista, 10, Solaris, Linux.

Business Modeling Tools: Rational Rose, MS Visio, MS Office including Word, PowerPoint and Access.

Reporting/Visualization Tools: Business Objects, Tableau Desktop, Tableau Server

Defect Tracking Tools: Rational Clear Quest, Test Director, Quality Center, TFS, JIRA, Selenium.

Project Methodologies: Rational Unified Process (RUP), UML, Agile, Waterfall, CMMI, SDLC, Project Management

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Sr. Business Analyst

Responsibilities:

• Lead and implemented a million-dollar enhancement through business designs, development and testing.
• Working as a Functional Designer (business analyst), on Curam 7.0.3.
• Implementing Managed Care in Confidential and documenting business rules for Managed Care and PHP auto assignment (P14.0)
• Authoring user stories, updating the tasks and Epic documents in Jira
• Host Report status meetings, designs and requirements sessions and represent the team
• Creating mockups and writing rules for the specific features, along with conducting walkthroughs.
• Involved in developing test cases, test scripts based on the FDDD, DD or Epic documents.
• Created the templates for the Detailed Design documents, Functional Detailed Design Document, Epic Documents.
• Created process flows for certain features to provide an understanding about the Managed Care Services.
• Created reference guides for Acronyms and terms as per the states policy and procedures.
• Creating rules for the Managed Care project and documenting them in the FDDD or the Epic document along with evidence/logic mapping
• Updating processes in Jira and creating/updating dashboards on a weekly basis and providing the status updates for the same.
• Followed Agile/Scrum methodology throughout the project life cycle
• Worked on gathering the high-level requirements and documenting it in the business requirements document (BRD).
• Prepared Traceability Matrix to understand the functional requirements and track them easily once the testing is scheduled.
• Written the Test Plan and Test Cases in the HP ALM (Application Lifecycle Management) with respect to the Functional Requirement Document (FRD).
• Facilitating and leading JAD sessions
• Created business requirement document for IBE (P14.2)
• Created test scripts for IBE (P14.2) and reviewed them with business and created E2E scripts in HPQC and JIRA

Confidential, Columbia, SC

Sr. BA & QA

Responsibilities:

• Working as a Senior Business Analyst on Curam 6.2 upgrade/implementation.
• Gathered requirements and performed Gap analysis between the existing system and new system
• Testing the current product and documenting the test results in Jira, along with manual testing.
• Developed test cases for the 6.2 Curam application for several tracks like EDD, Workflow and Tasks, Notice Redesign, Person search and Match, Person Merge, VLP, App Ing etc.
• Handled Change management requests along with sending out updates using SharePoint.
• Involved in Jira upgrade requirement gathering process and documenting using the tool Bizagi.
• Performed UAT testing and defects logging in Jira and getting the defects fixed and retesting the scenarios.
• Interacting with the vendor on day to day basis on getting the proper requirements and testing the application, if any defects found trying to get them resolved as their earliest.
• Understand Curam Case Management functionality and associated business processes of DHHS organization.
• Experience with problem identification and integration of technical skills to resolve issues.

Confidential, Washington DC

Sr. Business Systems Analyst

Responsibilities:

• Analyze, determine, and document functional requirements. Provide definition on how the applications will support business requirements.
• Gather requirements for Summer Youth (SYEP), Office of Worker’s Compensation (OWC), Office of Wage & Hour (OWH), including the current business process As-Is and conducting JAD sessions.
• Administered user and user groups for Tableau reports and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
• Working with project managers to ensure we have completed all the documentation as required before the sign off
• Ensured effective implementation of agile process.
• Representing the team in scrum meetings on weekly basis and updating the team on the current status of the project.
• Used advanced Microsoft Excel to create pivot tables, used VLOOKUP and other excel functions.

Confidential, Dover, DE

Sr. Business Systems Analyst

Responsibilities:

• Analyze, determine and document functional requirements
• Generated PeopleSoft HCM Test Strategy in conjunction with HR, Benefit and Payroll teams (both client and consultant teams)
• Analyzed requirements, performed configurations and implemented custom code in the PeopleSoft HCM module (specifically Benefits Admin) for the new system to service 18,000 university employees
• Recommend and develop reports for validation of data using the PeopleSoft query tool and SQL query.
• Application support based on the Business requirements.
• Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports/metrics.
• Extracted, compiled and tracked data, and analyzed to generate reports.
• Designed, Developed and Implemented User Acceptance Test (UAT) cases.
• Upgrade experience from 9.1 to 9.2 strongly desired
• Communicate accurate and up-to-date status updates with cross-functional teams.

Confidential, Bloomington, IL

Sr. Business Analyst

Responsibilities:

• Gathered business requirements from Business and SMEs from the Underwriting Property & Casualty & life, Product in insurance.
• Helped in defining Change Management Process for Release Management Team.
• Created user stories and updated the acceptance criteria in Jazz.
• Performed GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio.
• Developed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
• Develop detailed specifications of X12 and XML data format standards.
• Created 837 Institutional and Professional outbound, 834,835, 270 and 271 Transactions
• Created electronic data interchange maps including 850, 855, 856, 810, 844, 849, 852, 836 and 846
• Identified and implemented process improvement efforts within the EDI structure including system interface, policy and procedure changes.
• Developed and prepared EDI documentation, as well as provided content and format testing for internal and external use.
• Coordinated with the QA team in using HP Quality Center for defect tracking for issue and rating module.

Confidential, Herndon, VA

Business Data Analyst

Responsibilities:

• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Effectively interacted with Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Supported various projects through the Agile/ Scrum methodology and knowledge management including analysis, requirements gathering, development, testing, implementation and training.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Used problem and change management software to document work requests for release activities.
• Coordinated with teams within the organization to collect release requirements.
• Prepared use case models based on Business Requirement Document (BRD) gathered through interaction with users and the stakeholders.
• Documented project plans, process flow, timelines and other requirements.
• Facilitated meetings and Joint Application Development (JAD) sessions with business stakeholders and technical units.
• Created and maintained the Requirements Traceability Matrix (RTM).

Confidential, Bentonville, AR

Business Data Analyst

Responsibilities:

• Interact with the existing Retail and POS user groups, Business Analysts, Legacy and Distributed end programmers to understand detailed technical/business process flows.
• Created Business Rules and Business Processes for Promotions and Exchanges of Point of Sale System (POS)
• Created ad-hoc reports for users in Tableau by connecting various data sources.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Perform extensive research and analysis on Web based Point of Sale (POS) systems and presented to Executive sponsor.
• Created Requirements Design Documents (RDD) and Functional Requirement Documents (FRD)
• As a Business Analyst involved in business requirements, analysis, design, project planning & scheduling, creating UAT Test Plans / Test Cases.
• Wrote SQL Queries and did the Documentation for the Databases
• Produced and managed documentation on release activities to support problem resolution.
• Performed basic UAT with the different customers and different business modules.
• Analyzed the user/business requirements (BRD), functional specs (FSD) and Use Case System documents.
• Prepared and maintained the Requirement Traceability Matrix (RTM) to record the business and functional requirements.

Confidential

Intern (Junior Analyst)

Responsibilities:

• Performed requirement gathering & analysis, analyzing and negotiating customer requirements and prepare the requirements specification document for the application using MS Suite.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Implemented ISO 9001 documentation standards in the company.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Assisted with UAT, developing and maintaining quality procedures.