SUMMARY:

• Over seven years of experience as a Sr. Business Analyst/Data analyst with proven skills in requirement gathering, Gap Analysis, Change Management, User Acceptance Testing, Data Analysis, Business Analysis, ETL Testing, BI Testing in the Healthcare region
• Experience in developing Business Intelligence assets using tools like Informatica PowerCenter, Informatica Data Quality OBIEE, Tableau, Oracle and others
• Proficiency in Business Intelligence, Oracle, Database, Informatica, SQL Developer
• Very good understanding and experience in User Acceptance Testing, Smoke Testing, Regression Testing, Performance Testing and Functional Testing
• Involved in IT Business Analytics, Data Analytics and Data Profiling tasks with business to make data more accurate and result oriented
• Understanding the internal technical needs of an organization and recommend solutions as per timelines
• Expertise in various types of software development life cycles like water fall and agile
• Proficient in Medicare and Confidential billing
• Interact with clients for requirement gathering and prepare Functional Specifications
• Excellent knowledge of Health Insurance Portability and Accountability Act (HIPAA) Standards and Compliance issues
• Proficient in ICD - 9-CM and ICD -10-CM coding and claims processing
• Extensive experience in gathering Business/Functional user requirements, creating 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)
• Involved in facets system implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and Extensions, Load and Extraction programs involving HIPPA and proprietary format files and reports development.
• Worked with providers and Medicare and or Medicaid entities to validate the EDI transaction sets or internet portals.
• Act as a liaison between client and technical solutions/support groups, using advanced communication skills to elicit, document, analyze and validate client requirements
• Strong analytical and problem resolution skills with ability to plan, prioritize, and work efficiently in a multi-tasking environment
• Defining the AS-IS and TO-BE processes, and developing requirements through gap analysis.
• Provide support on production issues including troubleshooting, coordination with IT, and end user communication related to data issues
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively
• Strategic Planning for improving the organization’s efficiency
• Self-starter and able to handle multiple tasks based on priorities

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, Unix Shell Script

ETL Tools: Informatica 9.5/9.1x/8.6x/7.x(Power Center) (Designer, Workflow Manager, Workflow Monitor, Repository)

Databases: Oracle 9i/10g/11g, SQL Server 2008/2005, Teradata, Sybase 11.5, DB2, PL/SQL.

Operating Systems: Windows 2000/ XP/ Vista, LINUX, UNIX, DOS, Windows 2003 server.

Tools: SQL Loader, SQL*Plus, TOAD, SQL Developer, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Healthcare Data Analyst

Responsibilities:

• Conducting requirements gathering meetings to elicit requirements
• Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during JAD sessions
• Writing BRD (Business Requirement Document) from gathered requirements.
• Prepare policy briefs, reports, public hearing testimonies, presentations, and petitions.
• Prepare and publish periodic management reports.
• Created the Reporting requirements documents
• Deriving Use Cases from developed matrix where necessary.
• Creating relevant supporting documentation for requirements i.e., Excel spreadsheets, graphs etc.
• Hands on exposure on SharePoint for Tracking Requirement Documents, Status Reports,
• Implementation Guide and Support Documentation
• Involved in Policy management, Issue management, Change Management
• Analyzed the complex data for reporting and Performance Analysis
• Validated the External data to ensure the accurate reporting
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
• Provided technical expertise and support in data analysis and data reporting
• Created Test Strategy Planning (TSP) and assisted testing team to implement test plans during UAT kickoff.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Communicating with development and QA teams regularly to ensure accurate understanding and interpretation of requirements
• Performed extensive testing in Facets subscriber/member, tested groups, eligibility and enrollment and validated outbound 834 Extracts to the different vendors.
• Responsible for architecting integrated HIPAA, Medicare solutions and Facets
• Assisted project delivery lead in the creation and maintenance of project related documents (project status sheets, project plans, timelines, etc.)
• Created presentations and demos to help train internal teams: Sales, Marketing, and Services on new functionality

Environment: Share Point, MS Excel, Agile, MS Word, MS Access, HP Quality Center, UML, ETL, Informatica Power Center 9.X, Oracle 11g,Erwin,OBIEE 11g, MS Office suite, MS Visio, Oracle SQL Developer

Confidential, Detroit, MI

Healthcare Data Analyst

Responsibilities:

• Played a key role in the System Development Life Cycle process consisting of design and gap analysis, business requirements, systems requirements, test criteria and implementation to have the outputs of projects that dealt with the automation of correspondence directed to the insurance policy owners.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Responsible for interacting with the business analysts and the business partners to identify information needs for the business requirements for DAR.
• Involved in Facets System implementation, electronic claims and benefits configuration set-up testing, inbound/outbound interfaces and extensions, Load and Extraction programs involving HIPPA 835 and proprietary format files and reports development.
• Worked with the ETL specialists to migrate data into DWH & involved in data modeling.
• Responsible for checking member eligibility, provider enrollment and member enrollment for the Medicaid and Medicare claims.
• Defined functional test cases documented and executed test scripts in the Facets system.
• Performed data mapping for the application, confirmed and vacillated the requirements at time of testing.
• Worked on HIPAA transactions and code sets standards according to the test scenarios such as 837 health care claim transactions.
• Performed complex ad hoc SQL queries from BAs in both SSMS and Teradata SQL Assistant.
• Worked with providers and Medicare or Medicaid entities to validate the EDI transaction sets or internet portals. This includes HIPAA 837, 835, 270/271, and others.
• Researched the existing client processes and guided the teams in aligning with the HIPAA rules and regulations for the systems for all the EDI transaction sets.
• Gathered requirements and modeled the data warehouse and the underlying transactional database & performed Gap analysis of the processes to identify and validate the requirements.
• Identified/documented data sources and transformation rules required populating and maintaining the data warehouse content.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Use cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: SQL 2012, RUP, UAT, GAD (Gap Analysis Document), Microsoft Office 2007 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003 and HTML

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Authored the Business Requirement (BRD), User Requirements, Functional Requirements (FRD)
• Gathered requirements by working with the relationship managers, wealth managers and field agents.
• Worked on Use Case diagrams in gathering requirements
• Worked with development team to implement technical solutions the client
• Used SQL to analyze data on data bases
• Performed Backend Testing by executing SQL queries.
• Involved in developing test plan for the entire application. Developed test cases after analysis of the Business requirements and Business Use cases.
• Participated in various meetings and discussed Enhancement and Modification Requests.
• Interacted with all the developers to report defects and also to get the build status of the application.
• Analyzed system Specifications and design document and developed test plan in Test Director.
• Prepared the test environment including setup of facilities, hardware and software.
• Executed and wrote Test Cases on increments based on functionality added on each increments of web application.
• Participated in Use case Reviews, Test case Reviews, Test scenario Reviews and created synchronization points for validation and verification.
• Preparation of Test Plan which specifies testing overview, testing approach, testing strategy, roles and responsibilities and scope of testing.
• Executed different scenarios like compatibility, scalability, and load test to identify bottlenecks on every component of the system.

Environment: Manual Testing, Test Director, Oracle, UNIX, JAVA, J2EE, HTML, JavaScript, MS Word, Windows NT

Confidential, Portland, OR

Sr. Business Data Analyst

Responsibilities:

• Created the Detailed Requirements, User Stories and Acceptance Criteria
• Act as liaison between information technology and business units; interpret business requirements and, with developers' input, design new database functionality
• Designed excel Pivot tables and V-Lookup tables to analyze large data.
• Tested the applications along with the Quality Assurance testing teams.
• Created the Test plan, Test Strategy and Test Scenarios based on scope of project
• Provided estimates to the project managers
• Provided regular status reports to the management.
• Managed the issues on HP Quality center (ALM)
• Implemented the change management procedures
• Extensive SQL querying on Staging, Data warehouse and Data marts
• Performed UAT and Regression Testing
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Integration
• Validated the BI Reports and dashboards developed using the OBIEE

Environment: SQL, .Net, SQL Server, PL/SQL, Informatica Power Center, Informatica Data Quality, Microsoft Access, Visio, Share Point, HP Quality Center, JIRA, Oracle, SQL Server, MS SQL Server Studio, Oracle SQL Developer