SUMMARY:

• Business Analyst with over 10+ years of experience in State Government/IT/Healthcare IT/Financial with emphasis in Data Analysis, data modeling, process flow, quality assurance skills, MDM Data Analysis/Data Profiling and ETL process in Teradata development as well as development of Web applications.
• Proficient in authoring Business Requirement Documents (BRD), System Requirement Specifications (SRS) and identifying interfaces and business process specifications.
• Experience in various testing strategies like System/Integration/Regression/User Acceptance Testing (UAT) and Web Applications.
• Analyzing and identifying defects and creating graphs by using defect tracking tools like Quality Center and delivering presentation to the clients for their decision making.
• Excellent interpersonal and customer relational Skills. Enthusiastic and a self - starter with a need of minimal inputs.
• Experience in Healthcare and Pharmaceutical domains
• In-depth knowledge of Data Modeling & Mapping, Design using UML and Visio, Excel reporting and PowerPoint Presentations.
• Lead teams of IT and business resources during MDM testing initiatives to support successful MDM implementations
• Good exposure with technology like .net, Java, Java script & SQL
• Extensive experience in process improvement of day-to-day business operations.
• Successful project management (planning, resource allocation, scheduling and status reports)
• Excellent experience working with cross functional teams
• Experienced in statistical analysis, data management and analytics using statistical Minitab
• Knowledge of project management skills like time estimation, task identification and scope management.
• Excellent communication skills and ability to work effectively with technical teams in order to translate business requirements into an effective technical solution and serve as an effective communication channel between key IT personnel and business stakeholders.
• Skilled in preparing business requirements document (BRD), Functional Requirement Document (FRD), Functional Specification Documents (FSD), Use Case specifications, functional and technical specifications, systems design specifications (SDS)
• Strong presentation skills and ability to tailor presentations towards different functional areas of business.
• Experience in conducting walkthrough sessions with developers and testers.
• Experience in providing end-user training and mentoring team members.
• Understanding of SOA, Webservice, HTTP, XSD, XSLT and JSON.
• Extensive experience in data analysis, ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Good Experience in using tools HP Quality Center (QC), HP Quick Test Pro (QTP), Test Complete.
• Expert in conducting Gap Analysis, User Acceptance Testing (UAT) and documenting test output.
• Ability to prioritize and schedule multiple tasks on a day-to-day basis.
• Possess strong documentation skills including creating user and training manuals.

SUMMARY OF SKILLS:

• Teradata 16.10, SQL Assistant, IBM Infosphere Master Data Management (MDM)
• JAD Facilitator, Business Intelligence (BI Query, Power BI)
• Erwin 9.2, WIC, Nursing Home MDS (SME)
• HPQC, Quality Center, QTP, JIRA.
• System Testing, Use Cases, Test Cases, Test Scenarios, BRD, FRD
• BI Query, Power BI, SQL, PL/SQL
• XML, HL7, Linux
• Java, JavaScript, .net & HTML
• Clinical Quality Measures Reporting Repository and Clinical Data Repository
• Functional walkthroughs, Traceability matrix
• Experience in development methodologies like SDLC, AGILE, SCRUM and Waterfall
• Scrum and Kanban processes, JIRA
• JustInMind, FileNet (IBM), BPMN
• ADA 508 Compliance
• ASCII Doctor, Camunda

PROFESSIONAL EXPERIENCE:

Confidential, Lansing, MI

Sr. Business Analyst/Data Analyst

Responsibilities:

• Perform Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Ability to work effectively with technical teams in order to translate business requirements into an effective technical solution and serve as an effective communication channel between key IT personnel and business stakeholders
• Worked independently in a lead role on all aspects of diverse research, analysis, design, support and development of business solution.
• Workflow documentation and comprehensive training to the healthcare clients.
• Work with Data Warehouse Team to ensure data is loaded accurately
• Great knowledge of benefit plans in Nursing Home (NH) MDS, Women, Infants and Children (WIC) and Adult Home Help Assessments
• Gathered Business /Functional user requirements, created Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements Document (BRD)
• Experience in IBM Infosphere MDM Data quality issues and task resolution process
• Involved in the Onboarding process of Source systems data to State’s Master Person Index by performing initial data review and source data extract/query.
• Experience in the Data Analysis, Data Mapping, Data Quality, and Data Profiling.
• Design and review of various documents including the Software Requirement specifications SRS, Use Case Specifications, Functional Specifications FSD, Requirement Traceability Matrix RTM and testing documents.
• Coordinated with the QA Team for testing activities across multiple systems and managed Conversion test execution.
• Actively working in collaboration with DTMB and MDHHS to design and develop data load/maintenance projects and to build/maintain BI-Query models for customer.
• Create and update existing Views on DBMS as per client’s requirements and needs
• Develop straightforward DBMS queries, knowledge of HL7 and XML interface messaging
• Write SQL queries for Test cases and execute in Teradata SQL assistant to validate the data between Enterprise Data Warehousing and Staging Tables.
• Engaged Business Users to gather detailed software requirements / Business rules and ensured alignment with development teams.
• Business analyst for Clinical Quality Measures Reporting Repository and Clinical Data Repository for Meaningful Use attestation.
• Created class diagrams, use case diagrams and sequence diagrams to view the system from different perspectives.
• Complete system testing and facilitate user acceptance testing
• Medicaid/Medicare, Vital records and Healthcare industry knowledge
• Write Test Cases and perform User Acceptance Testing, documenting the detail defects.
• Work with diverse teams from multiple organizations through requirements identification, Functional and Technical requirements, testing, User acceptance testing and implementation
• Use various requirements gathering techniques including White boarding, Brainstorming, JAD, Focus Analysis, Reverse Engineering, Survey, Document Analysis, Interviewing and observations.
• Establish excellent client relations and maintain positive rapport with State government client and external sales team. Act as primary point of contact, facilitate customer meetings.
• Document existing programming processes and direct new releases on the Data Warehouse development
• Document and manage action items coordinate resolution planning and implementation with team members
• Provided BI/Query training for State government.

Confidential, Rochester, NY

Sr. Business Analyst/Data Analyst

Responsibilities:

• Assembled business requirement documents (BRO) and the functional specifications as per the user requirements.
• Managed relationships with healthcare partners and key stake holders to ensure our clients’ needs were met.
• Collaborating with the stakeholders, users and project leads in analyzing, designing, implementing and supporting Admin application for Enrollment & Sales.
• Created Business Workflow based on the requirements gathered from the client.
• Created functional specification documents based on the business requirement documents.
• Conducted weekly meetings with the clients and internal teams to formulate priorities and determine both automated and manual determine solutions.
• Management according to the HIPAA Compliance Standards for Claims Processing.
• Coordinated services for equipment distribution and home addition projects between clients and health equipment partner companies.
• Extensively worked with HIPAA 837,834, 297 files.
• Working knowledge for FACETS hatch file
• Tested different portals like Member portal, provider portal as part of HIX 10/1 releases.
• Extensively worked with HIPAA Privacy FACETS application groups.
• Extract and validate data from FACETS database using SQL
• Involved in creating documents and diagrams for Claims Processing.
• Extensive knowledge and experience in EDI transactions, ASC X12 transactions like 270,271,277.
• Worked on modules related to, Claims, Providers, & Contracts and worked with Claims attributes, Provider attributes, enabling EOB & Remit rules associated with Provider configuration process in FACETS.
• Working Knowledge of the data model, data fields, relationships (backend) of the FACETS System. FACETS tables such as Provider, Contract, Benefit, Claim, Claim details, and Member.
• Organized JAD Sessions to resolve issues and conflicts and to arrive at quick agreements regarding the system architecture design
• Performed Functionality and Regression Testing on IBM Curam web application
• Testing execution of CURAM/ACES customized components general test types of Unit.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center managers and stakeholders of the project.
• Analyzed and documented the limitations of the billing system.
• Interacted extensively with the client and the management teams to understand the requirements and to report the status of the testing efforts on their applications.
• Performed Gap Analysis. Followed the RUP methodology for the entire SDLC. Actively worked with developers as needed to isolate the Root Cause Analysis of defects.
• Worked with the clients on the final signing process in the User Acceptance stages. Managed scope and deadlines.
• Participated in various meetings and discussed enhancement and modification request issues.

Confidential, New York, NY

Marketing Representative/ IT Analyst

Responsibilities:

• Maintained quality enrollments and renewals of Medicaid Managed Care, Child Health Plus and Family Health Plus plans at assigned marketing sites
• Provided one on one knowledgeable presentation of the Confidential Health plan program and benefits, while following all State, City and company regulations and guidelines.
• Offer ongoing Member education and Member servicing.
• Responded promptly to all Client calls and Leads and distribute marketing literature and materials to all client calls and leads
• Maintained accurate records for reporting purposes.

Confidential, New York

Business Analyst (Consultant)

Responsibilities:

• Captured data elements of commonly used business forms in the Consumer Account opening process for a Concierge service website
• Gathered Business requirements and business rules for the Imaging Project
• Provided user interaction strategy to the system.
• Created Process flow diagrams for various stages of releases of new front-end systems.
• Collaborating with multidisciplinary teams to build good user experience and a great product.

Confidential, Jersey City, NJ

Business Data Analyst (Consultant)

Responsibilities:

• Acted as liaison between developer, management and other analysts.
• Acted as liaison between Data Management Group and third party data providers.
• Created and performed various query operations to eliminate duplicates and inactive or incorrect information.
• Incorporated Internet research to obtain accurate client account information
• Developed MS Access applications to aid in analysis and data cleanup activities.
• Documented procedures and created instructional guides for training purposes.
• Performed primary and secondary research on past and current corporate and institutional accounts using Internet based sources and company databases, focus on ‘high-risk’ clients to implement or enhance various policies and procedures to ensure full compliance with the USA Patriot Act and Anti money-laundering
• Responsible for creating Excel/Access spreadsheets to monitor client documentation and client file remediation
• Trained analysts and Interns on database clean-up procedures, counterparty/valid entity research and creation/modifications of accounts.

Confidential, Sunnyside, NY

Computer Associate

Responsibilities:

• Trained users to use the system and new software
• Provided Applications Support for staff
• Moves and changes of existing and new equipment
• Tested new hardware and software releases
• Assigned user rights, access to shared directories and created new users on the network
• Create manuals for users to use new Applications
• Assisted staff with routine requests
• Administered special projects and assisted the Business Manager
• Generated reports using MS Access regarding Home Health Aids, Client Visit Schedules and Available Employees