Summary

• Senior Business Analyst with 7+ years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Experience as Business/Systems Analyst with expertise in Insurance, Healthcare processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.
• Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Experienced in working with EDI (ANSI X12, EDIFACT), XML, FF and CSV files.
• Experienced in MicroStrategy Report Services, Dynamic Dashboards, Freeform SQL, Query Optimization, Project Schema, and MicroStrategy Server Administration
• Extensive experience with all areas of MicroStrategy including Architecture, Dashboard development, Administration, Web and Intelligence Server monitoring/diagnostic and resource optimization
• Extensive experience in Healthcare domain.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Well versed with MicroStrategy 9 functionality of dynamic dashboard development, Intelligent Cube OLAP Services and in schema object creation via the Graphical Architect using Multi - data source functionality
• In-depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Extensive experience with Front end and Back end System Integration Testing
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Informatica based ETL testing for data warehouse and business intelligence solutions.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Business Analysis and Testing with hands on experience in Healthcare and Insurance Sectors.
• Extensive experience with Medicare/Medicaid processing as well as the Claims/Billing.
• Skills include defining Project Scope, Business Process Analysis, Business Process Reengineering, Requirements Gathering, Data and Process Modeling
• Strong knowledge of the Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD),Software Requirement Specification (SRS) across the deliverables of a project.
• Knowledge Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio
• Experience in working with QA team to develop the Test plans, Test scenarios, Test procedures, and Test cases to ensure adequate testing of software both before and after completion.
• Excellent verbal/written communication skills and analytical abilities and can perform well both independently and as a team player.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Proficient in business analysis, development lifecycle, ETL, QA and testing and performance tuning.
• Good expertise in using TOAD, SQL Developer and SQL Management Studio.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Experience in HEDIS to measure performance on important dimensions of care and service of Health Plans.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse.
• Ability to effectively speak to people about complex subject matter Expert.
• Experienced in ETL tool Informatica
• Experience in Performance Tuning of mappings, ETL Procedures and process.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
• Strong oral and exceptional written business communication skills
• Hard working, positive thinking, self starter with a strong goal orientation
• Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

TECHNICAL SKILLS

BI/Reporting Tools: MicroStrategy (8.x, 9.x), Business Object, Hyperion Essbase, MS Excel

Databases: Oracle, Teradata, SQL Server, MS Access. .Net, SQL,MS, Windows 95/98, Windows XP, MS Project, MS-Office, Access, Excel, Lync, OneNote, PowerPoint, Project, Visio, Word and Microsoft Outlook, Internet, and various accounting programs, Tally7.0, Internet Savvy, Oracle.

Methodologies: Agile, Waterfall, RUP, UML, SDLC.

IDE Tools: Rational Rose, Rational Clearcase, MS Visio 2007, UML

Requirements Management Tools: Rational Requisite Pro, DOORS, SharePoint, IBM Blueworks Live, JIRA, Confluence Project Management MS Project

Software Packages: MS-Office - Word, Excel, PowerPoint, Share Point, Outlook

Testing Tools: Quality Center, Load Runner, Rational ClearQuest, IBM Rational Test Manager

Databases: Oracle 10.6, MS-SQL Server 2000, MS Access

Reporting tools: Crystal Report, Excel

Work Experience:

Confidential, Edison, NJ

Business System Analyst

Responsibilities:

• Worked as a Business Analyst the primary liaison between the business line operations, and the technical team throughout the project life cycle.
• Interpret changes within the business to determine the operational impacts and mitigate risk, including Affordable Care Act mandates
• Conducted Requirement Validation (RV) and Joint Application Design (JAD) sessions to define requirements.
• Followed RMLC process of documenting, analyzing, tracing, prioritizing and agreeing on requirements and then controlling and communicating to relevant stakeholders.
• Interviewed users, stakeholders to manage and map business requirements of new system with existing legacy system by performing gap analysis, risk assessment, modifications and design specification mapping.
• Prepared Training materials and conducted Training sessions to train end users for exercising full use of application.
• Published Crystal Report on Crystal Enterprise.
• Managed and led development of documentation and measurement source code for HEDIS compliance submission and successful on-site audit.
• Analyzed all EDI implementations, recommended improvements to processes and coordinated with trading partners to resolve all issues effectively.
• Designed and maintained all EDI maps to ensure compliance to all business requirements.
• Participated in all system tests and analyzed all data and processes and recommended improvements.
• Documented all EDI solutions for system development life cycle and maintained all documents specifications and developed various transaction specifications as per requirement.
• Provided support and business solutions to front office clients on functionalities such as pricing analytic and trade capture on fixed income and foreign exchange.
• Analyzed mandates/compliance requirements under Affordable Care Act (ACA) for successful product development and configuration of State Exchange products (HIX) into contracting, claims, customer service, EOB, as well as Vendor data feed systems.
• Write Oracle queries to test ETL jobs and MicroStrategy reports and dashboards.
• Provided weekly status report to project managers with over all progress Incidents development and testing progress or any other system blocker major issues preventing users to complete work.
• Documented Functional Specifications to include incremental business requirements, functional design and scope.
• Implement Data warehouse processes like Data Extraction/Transformation and Load (ETL).
• Updated Topic Papers to Include enhanced functionality and got end users sign off.
• Performed GAP and Risk analysis of existing system and evaluated benefit of new system.
• Conducted project related presentations and provided reports to the higher management.
• Worked closely with PMO in all the phases, Project Initiation, Project Planning & Design, Execution & Build, Implementation, Project Closeout
• Designed and managed MicroStrategy tool that allows anyone to create reports that directly access database without SQL knowledge
• Extensively involved in using of formula fields, parameter fields, Group selection and record selection in Crystal reports 7.0.
• Conducted workgroup sessions with client and security team to analyze system role-based access and panel security.
• Analyze and gather medical record information for HEDIS Quality reviews.
• Attend and provide data for HEDIS workgroup meetings.
• Created stored procedures and used ETL tools to automate activities for extraction, transformation and loading into the corporate data warehouse.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Participated in several weekly cross-departmental team meetings. Coordinated with DST on outstanding AMISYS program fault/failure issues in the department.
• Expertise in System Integration (X12 EDI-HIPAA-835) with Health plans eligibility and claim (CPT, ICD 9 codes).
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.Applied guidelines, standards and regulations such as HL7 CDA, CDISC, MedDRA, Code of Federal Regulations (CRFs) to clinical data modeling.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Generated Requirement Specification Document and Design Specification Document.
• Created Test Plans, Wrote Test Cases, Executed Test Cases, Maintain Issue Logs, Logged Triage Issued in Clear Quest, attend Triage Meetings addressing daily issues and actively participated in User Acceptance Testing
• Performed data quality analysis on data by writing queries to ensure data integrity across tables in DB2 database environment
• Created logical views in Microstrategy for complex report creations situations.
• Documented System Design Documentation (SDD) describing the systems requirement, operating environment, files and database design, input format, output layout, detailed design
• Analyzed customer needs and existing functions in the area of HIPPA transactions to determine feasibility, consistency with the established scope of work
• Responsible for mapping of ICD9 to ICD10 and also did testing for 837I/P, 835 transactions to migrate to HIPAA 5010

Confidential, FL

Business Analyst

Responsibilities:

• Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
• Worked as a business analyst for various other areas of Medicare Part D, such as EOB letter generation, Transition letter, CMS reporting and various other processes with CMS mandates.
• Created and revised Business Requirement document (BRD) and Functional requirement Document (FRD) using the Scope and Interview with stakeholders
• Validated TP configuration, EDI (ANSI X12, EDIFACT), IDOC, ACH, XML, FF and CSV files.
• Involved in with data migration (ETL development), document data manipulation processes and scripts.
• Responsible for preparing Software Requirement Specification (SRS) and documenting them.
• Created Process Work flows, Functional Specifications documents and documented system requirements.
• Develop detailed unit test plans and scripts and conducted rigorous testing per requirements and assisted in data mapping.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Interacted with various cross-functional teams on building business use cases, and understanding expenses and revenue stream.
• Facilitated the process for arriving at a common understanding and agreement on the organizational work models for information exchange to strengthen decision support, and developing a new approach to integrated eligibility as a foundation for defining key business requirements.
• Participated in multi-organizational, multi-disciplinary teams to determine, articulate, and document workflows, use cases, logical data models, and functional (business) and non-functional (technical, implementation, performance) requirements.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Involved in database and ETL Testing Test ETL data warehouse components. Executing backend data-driven test. Create, design and execute test plans, test harnesses and test cases. Identify, troubleshoot and provide solution for potential issues. Test flat file data transfers.
• Good understanding in processing of Medicare and Medicaid eligible claims.
• Working on different area of expertise in Medicaid domain related to various subsystems involving Professional, Dental and Encounter claims.
• Good understanding of CMS 416 Form submission for each fiscal year.
• Key role in conducting JAD session with the State and writing detailed requirements. Performed the requirement analysis, impact analysis and documented the requirements.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Performed the requirement analysis, impact analysis and documented the requirements.
• Prepared Functional Design Specifications (FDS) employing Use case scenarios, sequence diagrams and class diagrams.
• Prepared Report using SQL Server Reporting Services (SSRS)
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Analyzed and translated business requirements into system specifications utilizing UML.
• Collaborated with other team members to work on different Change Orders.
• Communicating the business requirements to the Development and Testing teams for a successful deliverable.
• Writing Test Scenarios and helping in Test execution in Quality Center.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Prepared Demo on SharePoint for various businesses to get new approvals.
• Extensively worked on Installing and setting up of Microstrategy Intelligence server and Web servers.
• Designed workflows and allocated permissions within SharePoint.
• Participated in User Acceptance testing and documented detailed results.
• Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Interaction with the developers to report and correct bugs.
• Developed Test Plans and Test Cases according to Business Requirements.
• Use HL7 implementation methodology to create specifications, assist with unit testing, and perform integrated testing for messaging between the state Departments of Health and the location office
• Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units
• Analysis of new Business Requirements and preparation of the Functional Design Specifications

Confidential - Chicago, IL

Business Analyst

Responsibilities:

• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Provider inquiry about the status of Remittance Vouchers (RVs). This involved checking the MMIS provider subsystem and checked the setup of their Remit Media
• Resolved issues related to EDI configuration and translation.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Accumulated system requirements from various departments through surveys and interviews.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Extensively worked on Installing and setting up of Microstrategy Intelligence server and Web servers.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Involved in writing the detailed Test Plan using Mercury Quality Center, after analyzing business requirements and software/functional requirement artifacts.
• Worked extensively with MS Excel and MS access
• Performed data analysis by using SQL queries using the DB Artisan tool
• Suggested measures and recommendations to improve the current application performance.

Confidential

Business Analyst/ Business System Analyst

Responsibilities:

• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
• Gathered Business Requirements, analyzed data/workflows, defined the scope, and performed GAP analysis.
• Conducted workshop sessions with the client to gather HR business requirements for blueprinting.
• Conducted SWOT Analysis for better market understanding and fool proof project implementation
• Reviewed ANSI X12 documents for potential impacts
• Verified clients' EDI configuration and translation before promoting changes to production.
• Migrated clients' EDI configuration, mappings and EDI flow to a new version of GIS.
• Demonstrated reports to global users with user activity sessions on the MicroStrategy tool.
• Provide user with the structural overview of the ANSI ASCX12 837 standard
• Met with client groups to determine User Requirements and Goals, thus converting User Requirements into Business Requirements and User and Functional Requirement Specification.
• Involved in designing and developing Data-Flow diagrams, E-R diagrams, and logical and physical database design.
• Responsible for EDI communications and GIS mapping of ANSI X12 and EDIFACT messages (850, 860, 856, 855, 810, 997, CONTRL, ORDRSP, IDOC and FF).
• Facilitated collection of Functional Requirements from system users, and prepared Business and Technical Requirement Specification documents.
• Responsible for writing Business Use Cases, Business Rules, logical analysis and change management of requirements.
• Utilized RUP to configure and develop processes, standards, and procedures and to perform System analysis and organizational review of existing QA processes.
• Involved in development of Business and Technical Requirements in preparation of System Architecture, Information Strategy, and Detailed Design documents for Business Needs and Processes.
• Appointment scheduling and recalls, accounts receivable management and collections, reporting and filing claims trough EDI X12 format transaction sets in compliance with HIPAA standards
• Work closely with the business partners during initial engagements and understand the business requirements for MicroStrategy projects.
• Report the Defects using Rational Clear Quest and HP QC.
• System, integration and acceptance testing of the client-server component.

Confidential - Columbia, SC

Business Analyst

Responsibilities:

• Successfully defined the scope and business rules of the project, gathered business requirements and documented them textually or using models.
• Facilitated JAD sessions and worked with business users through interviews, workshops, and brainstorming sessions.
• Researched and understood the claims adjudication and reimbursement systems based on HIPAA X12 4010 standards.
• Work on creating various POC's using different features of MicroStrategy for requirements gathering.
• Exposed to using ICD 9/ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for both Inpatients and outpatients.
• Ensured that ICD-9-CM procedure codes used for inpatient services and CPT codes for outpatient and physician services were not outdated.
• Performed root-cause analysis and troubleshoot issues encountered in EDI processing and Mainframe.
• Interacted with developers to report software bugs and retested the fixed issues.
• Facilitated User Acceptance Testing and test strategies with developers and testers and participated in manual front-end testing to check all functionalities of different modules.
• Used Rational Rose/MS Office Suite for creating use cases, workflows and sequence diagrams according to the UML methodology thus defining the Data Process Models.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Maintained Requirement Traceability Matrix (RTM).
• Developed queries using SQL to automate the weekly and monthly reports.
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.
• Coordinated Regression Testing and created test scenarios for User Acceptance Testing (UAT).
• Maintained documents for change request and implemented procedures for testing changes.