Project Manager / Business Analyst Cognos
Resume:
Nicole Roach
Mobile Phone: 860-***-****
Secondary Phone: 860-***-****
E-mail: *********@*********.***
Nicole Roach
*** ***** ****** ******, ** 06231
Tel: 860-***-****
Experience
2003-2009 BI Consultant/Walllingford CT
Senior BI Consultant
o Architected and Implemented on the Microsoft Platform a Enterprise Data BI Solution
for one of the largest health care insurer affiliated with BlueCross BlueShield.
o Developed an Enterprise Data Warehouse using Microsoft SQL Server to be used for analytics
and reporting.
o Created Microsoft SSIS scripts for ETL into Enterprise Data Warehouse.
o Utilizing Analysis Services created the largest OLAP cube in the healthcare space with Proclarity
as the front end.
o Worked directly with the client to understand their business requirements and assist in identifying
their issues in the current Enterprise Data Warehouse to get them on a fast track for resolution.
Verisk Health/ Urix, Cheshire CT
Data Warehousing Manager
• Recruited as data warehouse architect and promoted to Vice President reporting to the CTO
• Supervised team of 6 data analysts, senior analysts and data architects
• Architected, Implemented and deployed the master warehouse template and conceptual data model
behind the industry leading “VHIP” platform for complex analytics and reporting in healthcare:
o Co-designed the custom “USTART” ETL application that boasts numerous features such as
high-performance multi-threading; dual-site transactions; automated OLAP cube production;
o Developed numerous healthcare specific algorithms as part of the 700+ module library:
IBNR and HEDIS calculations, membership engines, utilization engines, eligibility engines,
data cleansers and groupers
• Managed, implemented and deployed the data apparatus for Verisk’s major clients constituting over
14m members with a cumulative 40TB footprint across 2 hot-site data centers
o Worked directly with clients to understand and refine their data structures in
the construction of the data systems. Often solved client-side data issues
to ensure proper flow of data system.
o Worked with internal consultants to ensure data framework met the reporting and analytic deliverables (both relation and OLAP)
• Managed the design and construction of the OLAP cube systems for VHIP clients, deploying
some of the largest Analysis Services MOLAP cube structures in the country
o Delivered SUPER large cube systems with an average response time of 5-10 seconds
o Completed a proof of concept with Microsoft and HP for an enormous singular cube system containing 7m members and almost 750m data rows.
• Managed the data team for the monthly refresh of data systems turning data in 3-4 days
1998-2003 CIGNA, CT
Data Architect/Senior Business Analyst
• Designed both logical and physical data models for the Corporate Data Warehouse
• Researched and documented data modeling standards and best practices and managed metadata
• Provided expertise in the development of application areas around data.
• Participated in data definition and data management reviews.
1992-1998 Aetna, CT
Data Modeler/Senior Business Analyst
• Defined, designed and managed data requirements, including:
o Created data mapping documents and specifications for ETL
o Analyzed system requirements and data to create logical and physical data models
o Facilitated interaction and follow-through between the business and IT
• Fostered partnerships with project management, business analysts,
application designers and database administrators :
o Created business specifications and Standard Development Life Cycle (SDLC) documentation
o Developed process flows and document existing or new procedures.
o Created test cases developed form use cases/requirements.
o Assisted business SME’s with user acceptance testing.
Technical Skills
Languages Microsoft.NET (1.1-3.5) C#/VB; SQL, XML, MDX, SAS
Databases SQL Server 2000/2005/2008; Analysis Services 2000/2005/2008;
Reporting Services 2005/2008, Integration Services 2005/2008.
Software Erwin, Visual Studio 2003/2005/2008, Visual Source Safe 2005, SAS,
ProClarity, MS Office2002-2007;
OS Windows (9x, NT, 2000, XP, 2003, Vista, 2008)
Contact this candidate