Post Job Free

Resume

Sign in

Data Sql Server

Location:
Dublin, CA
Posted:
January 28, 2016

Contact this candidate

Resume:

Natalia Sahba

**** * *** **** *******

Dublin, CA 94568

C 925-***-****

acta2p@r.postjobfree.com

Qualifications

• Expertise in Oracle 7-11g, SQL server 2000-2014, MySQL, Cache, DB2, PL/SQL, .NET, XML, Perl, and Java.

• Strategic and technical consulting for large healthcare, utilities, and financial clients.

• Project and team management: Business process mapping, Organizational change management, Budgeting, Data integration. Product management, Use Case and Requirements Gathering, Business Case development, Datawarehouse Architecture, Executive Dashboard development, Performance Metrics and Trend Analysis, Technical Training.

• Broad BI tool set: Business Objects (BOXI) administrator, Certified Epic ETL Administrator, OWB 10.2, Informatica Power Center 7-9, MS SSIS, Pentaho Data Integration (kettle), SQL*Loader, Automate 6 and 8, Electronic Commerce Server (ECS), Liason Delta, Actuate, BIRT, Oracle Discoverer, Tableau, relational and dimensional databases; star and snowflake schema; dimensions and cubes; statistical data analysis, structured and semi-structured datasets.

Professional Experience

08/2015 – 01/2016

Under Contract To Kaiser Permanente, Pleasanton, CA BI Team Lead

• Integrated API data from Rally and Jenkins into relational data warehouse with pentaho ETL

• Published agile PMO metrics with Tableau 9.1

01/2015 – 05/2015

Anthelio Healthcare Solutions Inc., Pleasanton, CA Data Solutions Architect

• Created technical documentation and conceptual model for healthcare analytical data system

• Designed and developed multi tenant data warehouse with CA ERwin in SQL Server 2014

• Delivered 6-tile Meaningful Use dashboard complete with drilldowns and multiple user access levels 08/2014 – 01/2015

Kaiser Permanente Information Technology, Pleasanton, CA National ETL Lead, Solutions Architect

• Managed international team of 26 ETL analysts through production upgrades, environment migration, and archiving for 48 production Epic ETL insances.

• Coordinated cross-functional teams of system engineers, network administrators, DBAs, and business analysts to address provisioning of new system environments and tuning existing infrastructure for optimum performance. 05/2013 – 02/2014

Alameda Alliance for Health, Alameda, CA Manager, IT Integration

• Hired and managed a team of 11 BA, DBA, QA, and ETL developers through upgrades of major Benefit Processing & Adjudication systems (from Diamond to HealthSuite; from MedImpact to Argus) that entailed overhaul of the main operational data source (ODS) and analytical Datawarehouse.

• Acted as the lead negotiator on data integration projects of various scales. Managed projects from requirements gathering through rapid development, documentation, and user training; always delivered projects on time and within budget.

• Directed all technical aspects of rolling out Argus Pharmacy Benefits Management (PBM) system including eligibility and encounter interfaces. Integrated the new PBM with financial and operational reporting.

• Managed and developed X12 HIPAA EDI 5010 interfaces: 834 Enrollment, 835 Remittance Advice, 837 Claims, NCPDP D.0 Pharmacy, 999 Acknowledgement.

• Participated in implementation of interfaces with Covered California Health Care Exchange (CalHEERS). 06/2009 – 05/2013

Washington Hospital Healthcare System, Fremont, CA Business Intelligence Lead

• Created and implemented original framework of health informatics and data warehousing for community hospital using ERwin, MS SQL Server and pentane ETL.

• Identified and scoped major components of persistent informatics integration to achieve Meaningful Use (MU) of healthcare information. In close collaboration with clinicians and business delivered MU certification metrics. Page 1 of 2

Natalia Sahba

5715 W Cog Hill Terrace

Dublin, CA 94568

C 925-***-****

acta2p@r.postjobfree.com

• Completed full cycle of information extraction, archiving, and sharing for ER Utilization, Patient Accounting, and Operating Dashboard. Data crossed multiple department boundaries and time periods; updates have been fully automated.

• Automated quality and compliance reporting to Center for Disease Control (CDC), Centers for Medicare & Medicaid Services (CMS), American Heart Association (AHA), and other registries and agencies.

• Archived legacy data from Cache to MS SQL Server 2012

• Supported daily Epic ETL operations including SU and environment synchronization.

• Set up and extracted data for Asthma, Pneumonia, and Stroke registries.

• Was instrumental in creating Epic reporting workbench (RWB) metrics for physicians and staff. 11/2005 – 12/2008

DaVita Rx, Pleasanton, CA Health Informatics Engineer / Project Manager

• Facilitated collection of system requirements through interviewing stakeholders and prototyping solutions.

• Selected core model representing best fit for business and existing infrastructure.

• Ensured model transparency to compliance principles and organization standards.

• Created, analyzed and maintained SQL stored procedures, triggers, functions, and materialized views.

• Developed complex SQL queries and stored procedures involving complex multi-table relationships.

• Created XML schema for processing prescriptions visual information.

• Integrated Oracle infrastructure with web services.

• Performed query analysis and formulated tuning recommendations.

• Worked extensively with system owners and data analysts on designing and documenting Data Flow Diagram

(DFD).

• Created staging area for enterprise Datawarehouse; mapped OLTP data on stage for replication with Materialized views in Oracle 10g. Enabled intraday reporting from the stage with Oracle Discoverer 10.1.2.

• Created and managed Master data, Data Quality, Metadata, and Data Life Cycle documentation.

• Provided data analysis and data modeling expertise to the organization. 09/2004 – 11/2005

Contract with Kaiser Permanente Walnut Creek, CA Senior Technical Consultant

• Created BI solution featuring:

o XML interface for scheduled data exchange between Oracle, Business Objects, and SQL-server databases of business partners across the organization;

o Live executive dashboard with rollups, collaboration, and e-mail notifications to community members.

• Evaluated business needs, gathered functional and technical requirements, participated in vendor evaluation, designed interface’ engine, trained technical team on application support. Designed prototypes and technical solutions based on organizational requirements and provided technical expertise in development. Facilitated quality management, documentation and user adoption. Working closely with data analysts and business program management, communicated milestones of ongoing technical progress. Education and Certification

04/2012 Epic Certified Extract, Transform, and Load Administrator Verona, WI 06/2012 SAP Certified Business Objects Administrator San Francisco, CA 07/1998 - 04/2000 MBA in International Marketing and Finance DePaul, Chicago, IL 09/1984 - 04/1992 MS in Nuclear Physics and Engineering Moscow, Russia Page 2 of 2



Contact this candidate