Business Analyst

Business Analyst  (CG36313)

Pleasanton, CA, 94588

5+ Month Contract

Contract Terms: W2

The NCAL Reporting & Analytics workstream of the ICD-10 project has four baselined project plans (3 Legacy applications to be remediated and one business reporting plan) that indicates a required effort of over 17,000 IT hours by from 2012 to 2014. 

This position will work in a team with a dedicated project manager and solution consultant, and will engage with other IT resources to complete some required efforts (data modelers, DBAs, etc.). 
The NCAL ICD-10 Reporting & Analytics workstream has recently taken over the responsibility for the ICD-10 readiness of the HC Clarity data repository, which had previously been managed by the NCAL HC program. 

The HC Data Model Conversion demonstrated the intense business need for consulting, documentation, and communication services to prepare Clarity for ICD-10. 
Significant solution consulting resource gap exists to complete the necessary requirements gathering, solution design, test plans, test execution, UAT coordination, other documentation, and extensive communication to business users. 

Currently, there is a need for a dedicated business consultant to manage, plan, organize, and drive the remediation of IT reporting applications and to create communications for business users that need to remediate their reports, data marts, and reporting tools. 

A business consultant with experience in Business Intelligence and data strategy, ICD-10 codes, ICD-9 to ICD-10 mapping, SQL, relational database, application testing, test data management, and report development is required to support the complex tasks and activities. 

Deliverables expected from this resource will include: 
ICD-10 Remediation Specifications for Clarity and other data sources. 
Test Plan/Strategy, Test Cases, and Test Data Plans for reporting systems. 
Facilitation of redesign of Clarity custom views, extracts, and reports. 
Coordination of business user UAT and Validation of reporting systems. 
Analysis, planning, and coordination of regional End-to-End report testing. 
CMT to ICD-9 to ICD-10 mapping documentation, tools, and user support. 
SQL code review and support for end users that rewrite reports. 
Comprehensive Test Data Strategy for reporting to provide adequately robust test data for use by reporting & analytics. 

As a Business Analyst you will perform requirement gathering and analysis, data analysis, data mapping, functional design, quality assurance/Testing and documentation for ETL related projects. The individual will be working closely with ETL Leads, Solution Consultants and testing team.

Responsibilities:

Primary responsibilities include:
Perform requirement gathering and analysis of applications and their business processes. Performs analysis that is diverse and very complex and works independently under general direction (ie writing queries). Perform Data Analysis, develop Data Mapping and Functional Solution Design documents for ETL projects. Works with Development Team to ensure feasibility of design and clarify user requirements.  Capture business rules and build physical design document to meet user requirements.  Work with Data Modelers and DBA to create/update table structures.  Understand and Interpret Logical design document and Data Model diagrams to understand requirements to build physical design document. Effectively communicate the functional design to developers and confirm the same with solution design team. Develops test scenarios and scripts that match the business users objectives to confirm system functions are met.  Work with Development and Testing team to support testing activities.

Qualifications:  
Typically requires a minimum of 3-5 years of related experience or equivalent combination of education and experience. Strong knowledge and experience in Foundation Systems (Membership System for CA regions)/Candidate must have hands on experience in Mainframe and Oracle technologies. Candidate must have strong knowledge and experience in interpreting user requirements and building Physical Solution Design Document. Candidate must have good knowledge and experience in understanding logical mapping and data model to build Physical Design document. Strong knowledge and experience in Data Warehousing (ETL, Data Analysis, etc) concepts. Strong intuitive and analytical problem solving skills. Good understanding on testing principles, concepts and tools. Advanced working knowledge of Testing, Business Analysis techniques and tools. Should have ability to write and execute complex SQL Statements especially in Oracle Environments. Expertise with Defect Management Tools preferably Mercury Tools preferred. Good understanding and experience in writing test cases/plans, executing test cases & identifying defects.

Technical Qualifications:
Sound knowledge and experience in Teradata, Oracle, and Mainframe systems. Clarity experience a big PLUS.