TOOLS/METHODS:

• RUP, UML
• Agile, Waterfall
• MS Visio
• MS Office (Word, Excel, PowerPoint, Project, Outlook, Access)
• MS SQL Server
• Rational Rose
• Rational Requisite Pro
• Rational Clear Quest
• HP Quality Center
• Test Director
• CaliberRM
• Adobe Photoshop
• IBM Content Manager
• Web Sphere
• Oracle, SQL Server

RELEVANT CLIENTS:

• Cerner Corporation
• Michaels Inc
• Citibank
• Premera Blue Cross
• UBS

PROFESSIONAL EXPERIENCE:

Sr. Business/Data Analyst

Minneapolis, MN

• Elicited Functional & Non - Functional Requirements and conducted Requirement Sessions.
• Led sprint planning sessions to identify the features and functionalities that should be achieved by the new application.
• Applied strong understanding of role-based access to design workflows and system solutions.
• Ensured documented solutions followed client’s identity and access management best practices.
• Created Business Requirement Documents as a result of meetings with the business areas and obtained business sign offs on the documents after reviewing the final documents with them.
• Analyzed and evaluated User Interface Designs, Technical Design Documents and the performance of the application from various dimensions including Identity and Access Management.
• Maintained Traceability Matrix Table to uniquely trace the identified Business Requirements to general design to testing as proof that requirements requested have been developed into a solution and that it has been tested and tracked.
• Led the change control process for changes submitted for the BRD once the document was submitted.
• Documented the UAT Plan for the project. Worked with the UAT Team to ensure every acceptance criteria for the requirements had been included in the UAT Task Plan.
• Led client discussions relating to the Facets configuration of a standard Medicare Advantage Plan.
• Supported new Business Requirements by extending the functionality of the core facets system using the facets extensibility architecture feature.
• Involved in Facets Implementation including end to end testing of facets billing, claim processing and subscriber/member module.
• Used JIRA to track defects and issues.
• Interpreted metrics and participated in the development of appropriate actionable plans for the definition of a new and/or improvement of an existing ITIL process.
• Wrote Business Case Scenarios for HIPAA EDI transactions.
• Worked extensively on ITIL foundations like change requests, incident and problem management.
• Wrote Test Cases and Scripts and reported Quality Traceability Matrix influencing software design, product development, and release cycles.
• Validated all data quality checks during ETL and data warehousing load.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Reviewed Technical Specs together with the team of two developers.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transformed and finally loaded into the Data Marts.
• Performed Data Analysis and developed Data Mapping documents for ETL Informatica projects.
• Performed White Box, Black Box, and Usability Testing.
• Profiled the data using Informatica Data Quality (IDQ).
• Worked with IDQ on setting Business Rules and Designed Workflows for Data Validation.
• Assisted customers on their migration to new or revised system, applications and platforms.
• Validated HIPAA Transactions and code sets standards according to the test scenarios such as 270/271, 276/277, 837/835, 834, 999 acknowledgments for enrollment transactions and performed UAT.

Environment: Windows XP, RUP, UML, SQL, Rational Tools, MS Visio, Facets, JIRA, XML, MS Word, MS Excel, MS PowerPoint, MS Access.

Sr. Business Data Analyst

Irvin, Texas

• Conducted JAD sessions to allow different Stakeholders to communicate their perspectives with each other, resolved any issues and came to an agreement quickly.
• Performed Requirements Gathering and Analysis, interviewed SMEs (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Involved in meeting with Business Process Owners, SME’s (Subject Matter Experts) and Marketing Team for Requirements Gathering in Definition Stage.
• Gathered and maintained requirements, software documentation, and meeting notes in JIRA.
• Created and troubleshoot defect tickets in JIRA before assigning them to developers.
• Changed the format of extracted JIRA issues and made it presentable to the clients so that they can prioritize the issue.
• Prepared Software Requirement Specifications (SRS) and was involved in the preparation of the Functional Requirements Document (FRD).
• Followed the UML based methods using MS Visio to create Business Flow Diagrams and Use Case Diagrams.
• Performed Configuration Management and Version Control.
• Worked with the development team to made sure that they understood the user requirements and that the system developed met those requirements.
• Worked with the Project Manager on various Project Management activities like Resource Planning; Resource Request; keeping track of Project Status, Deadlines and Issues; Environment Request; and Compliance Issues.
• Designed and developed UNIX Shell Scripts as part of the ETL process to automate the process of loading and pulling the data for testing ETL loads.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provided technical support and hands-on mentoring in the use of Informatica for testing.
• Participated in setting up Test Environment and creating Test Data.
• Documented changes and implemented procedures for these changes as discussed in Change Request Meetings.
• Wrote SQL queries to check for data validation.
• Created and executed SQL statements manually to perform Backend Testing that ensured data consistency on the Frontend.

Environment: Windows XP, RUP, UML, SQL, Rational Tools, MS Visio, JIRA, XML, MS Word, MS Excel, MS PowerPoint, MS Access, Informatica.

Business Data Analyst

Warren, NJ

• Facilitated Work Sessions with Business Users and assisted them in defining business processes, requirements and possible risks, and analyzed possible solutions with team members.
• Created reports based on workflow data pulled from the JIRA database such as workflow statuses, review statuses, and completion statuses.
• Worked with JIRA entering User Stories into respective epics, tasks and assisted with prioritizing stories for sprints.
• Served as a liaison between business users and IT team and implemented business process analysis, business process modeling and business process re-engineering techniques.
• Performed JRP/JAD sessions and developed detailed requirements and preliminary design such as conceptual design for the application and created UML Diagrams to clarify the requirements.
• Created data mapping document for ETL process to merge tables and worked with data modelers in the creation of logical and physical data models.
• Performed Gap Analysis (AS-IS & TO-BE) to derive requirements for existing system enhancements.
• Leveraged SOA design principles and best practices in developing the requirements and UAT testing.
• Defined Project Vision, Scope, Roles, Tasks, Milestones, Budgets, Action Plans and Measures of Success.
• Assisted the business in identifying, assessing, and documenting business requirements.
• Identified, assessed, and recorded near-term business needs; recommended business priorities; and advised businesses on options, risks, and costs versus benefits.
• Assisted the business in evaluating priorities, risks, and costs versus benefits of various solutions.
• Analyzed business processes, products and operations to monitor detailed business requirements.
• Communicated requirements to the development team for the design and implementation of business solutions.
• Reviewed new system functionality and patched to determine what was applicable and what should be presented to the business for prioritization.
• Communicated business priorities to the technology organization accordingly in order to drive effective business solutions.
• Developed scripts to modify and add on to the functionality of the DOORS application.
• Provided in-depth and detailed reporting and analyses for different departments for functional and project side of the business.
• Developed Use Cases to explain/demonstrate Business Requirements/Specifications to IT team.
• Closely monitored the project deadlines to manage the production flow.
• Worked with Quality Assurance Testing team to facilitate comprehensive Quality Assurance Verification to ensure minimal post-implementation defects.
• Coordinated UAT for customer approvals on final deliverables.
• Worked on Data Modeling and produced Data Mapping and Data Definition Documentation.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that supported the business requirement and process.
• Wrote UAT Test Plan, organized and conducted User Acceptance Testing with clients and worked as a part of support team.
• Logged defects in HP ALM and verifying all the cycles of the defect that I was responsible for.
• Reviewed and created Test Cases to perform Functional Testing, Security Access Testing, End-to-End Testing and Regression Testing.
• Executed SQL queries, PL/SQL stored procedures, triggers on backend as a part of data analysis and data validation.

Environment: Windows XP, RUP, UML, SQL, Rational Tools, MS Visio, JIRA, XML, MS Word, MS Excel, MS PowerPoint, MS Access, Informatica.

Business/Process Analyst

Seattle, WA

• Conducted Gap Analysis between the current system and new requirements to be implemented thereby mapping the Business Requirements to the application.
• Involved in training and test sessions on HIPAA Privacy Policy.
• Prepared high-level and detailed System Requirements Documents for the application.
• Identified the requirements for accommodating HIPAA 5010 standards for 837P transactions and captured these requirements to develop new GUI for the internet based application.
• Set claim processing data for different Facets Module.
• Involved HIPAA regulations in Facets HIPAA Privacy Module.
• Involved EDI Claim Process according to HIPAA Compliance.
• Coordinated with the Release Management Team in order to complete the overall release plan.
• Used Requisite Pro for writing/analyzing project vision, goals, specifications and requirements.
• Compiled Vision and Scope documents to better define the rationale for the project.
• Gathered requirements from business to determine the functionality that should be provided to the users.
• Created Business Requirement Documents as well as System Requirement Specification after the JAD session.
• Extensively worked with ANSI X12 HIPAA EDI Transactions 270, 271, 276, 277, 837 , 835 and 99 7.
• Involved in testing the Medical and Hospital Claims in Facets based on Service, Agreement and Pricing Id's.
• Tested the Web interfaces and Web Service Applications.
• Translated the scenario based requirements in to User Stories, Use Cases and implemented Agile methodology as a standard for the ongoing project.
• Tracked all the requirements and issues mentioned in the issue tracking system called JIRA.
• Worked with ANSI X12 (835, 837, 834) EDI Transactions.
• Responsible for providing regular test reports to the management.
• Reported the defects to the developers using Quality Center.

Environment: Windows XP, RUP, UML, SQL, Rational Tools, MS Visio, JIRA, XML, MS Word, MS Excel, MS PowerPoint, MS Access.

Business Analyst

Stanford, CT

Responsibilities:

• Identified the Project Scope and Project Plan for GDMP Application Archive.
• Performed analysis to identified Record Series with coordination of Legal and Compliance Department.
• Identified Business and Legal Requirements for all Business Streams.
• Created a Repository for all identified risks involved in the project.
• Proposed solutions for efficient process flow once the application was archived and Go Live.
• Designed the Process Flow for certain requests for existing application.
• Planned and scheduled application for GDMP Application Archive.
• Gathered requirements from Legal and Compliance Departments to design the Business Requirements.
• Created Technical Specification Document which would be used all across business streams to implement the solution.
• Designed the business object based on the guidelines provided by Legal & Compliance and individual Business Streams.
• Provided Program training to Business Users all across the regions.
• Conducted Informational and Technical Sessions with Development team to bring the issues on board.
• Planned with business streams to bring their application On Board.
• Mitigated certain risks once the impact had been identified.
• Conducted meeting with Business Stakeholders to gather requirements.
• Validated requirements with Business Stakeholders by providing acceptable level of details.
• Created Use Cases and Use Case Diagrams using MS Visio and MS PowerPoint.
• Created Business Process Flow and ERD Diagrams.
• Coordinated with Development Team to carry out application.
• Performed JAD sessions with Development and Business teams to stream line the Development process.
• Worked on different environment of GDMP Program, Development, Testing and Production.
• Conducted weekly and monthly meetings with Board of Directors all across the region to understand the new features and releases of GDMP Program.
• Helped during the UAT to create Test Cases and RTM.
• Extensively used Requisite Pro to manage different Project Requirements and Project Plans.
• Created Test Cases in Mercury Quality center for UAT effort.

Environment: IBM Content Manager, Web Sphere, Oracle, SQL Server, MS Access, MS Excel, MS Visio, MS PowerPoint, Rational Requisite Pro, Mercury Quality Center.