Data Developer

TECHNICAL SKILLS

Databases

ETL

Reporting

OLAP

SQL Server 2005,2008,2012 (Developer, DBA)

Oracle 9i, Mysql

SSIS\DataTools

****,****,****

Informatica DQ 9.5

SSRS 2005,2008,2012

Tableau 9.x

Qlikview

SSAS (2005,2008,2012)

Data Modeling

MDM

Healthcare Tools

BankCores

Erwin

Visio

SQL 2012 MDM

IBM Initiate MDM

Hedis, ICD9, HL7, Cerner Millenium, Meditech.

Fiserv, FIS

INDUSTRY EXPERTISE

Health Care

*St. Joseph Medical

*Kaiser Permanente

*Quintiles

*Huntington Hospital

Banking

*Bank of America

*SNL Financial

*Wells Fargo

Insurance

*Lockton Corp

Telecom/Cable

*Sprint

*Comcast

JOB EXPERIENCE

(January, 2016 – Present) Huntington Hospital Pasadena,CA

Senior ETL Developer and Data Architect

●Worked with Cerner Millenium to create 2 data marts (Revcycle, Encounter)

●Wrote data dictionaries and requirements documents for data marts and reports.

●Created in modified SSIS packages in SQL 2008/2012

●Created and modified store procedures in SQL 2012

●Created SSAS cubes based on data marts developed from Cerner Millenium data model.

●Incorporated other health care data sources into data marts (Meditech, Lawson).

(June, 2015 – December, 2015) Wells Fargo Los Angeles,CA

Contractor Senior Data Analyst\Data Warehouse Developer

●Created SSIS 2012 packages

●Modified SSAS cubes and wrote MDX calculations

●Created conceptual, logical and physical database design in Visio

●Created and modified store procedures in SQL 2012

●Created and modified SSRS 2012 reports, embedding custom MDX code to support reports.

(March, 2014 – June, 2015) St. Joseph Health Orange,CA

Contractor Senior ETL Developer\Data Analyst

●Developed reports and dashboards using Tableau reporting tools

●Developed and modified ETL and MDM using Informatica Developer 9.5

●Helped implement data governance and master data management methodology.

●Performed extensive data cleansing and data profiling using Informatica Developer

●Developed ODS and data warehouse using Kimbal methodology using SQL Server 2008

(October, 2013 – February, 2014) Bank of America Agoura Hills,CA

Contractor Senior ETL Developer

●Designed, created and implemented ETL process using SSIS 2008

●Implemented changes in existing schema using internal meta-data scripting procedures

●Created and modified stored procedures

●Wrote scripts to create and modify database schema objects

●Wrote stored procedure to validate data against database objects compared to data dictionary entries.

(August, 2013 –October, 2013) AAG Orange,CA

Contractor Senior BI Developer\Analyst

●Architected and created new Data Warehouse based on Kimball model

●Designed, created and implemented ETL process using SSIS 2008

●Used ERWIN Data Modeling Tool to design and implement Data Warehouse

●Created reports using SSRS 20012

●Created BI SSAS Cubes (SQL 2008/2012)

(March, 2013 –June 2013) Kaiser Permanente Aurora, CO

Contractor Senior SQL and BI Developer

●Architected and created new Data Warehouse based on Kimball model for entire healthcare databases

●Designed, created and implemented ETL process using SSIS 2008

●Designed created and implemented SSAS cubes using created Date Warehouse

●Wrote stored procedures for ETL process to be used by SSIS 2008.

(August, 2012 –February, 2013) SNL Financial Greenwood Village, CO

Senior BI and Database Developer

●Managed BI SSAS Cubes (SQL 2008/2012)

●Managed and modified SSIS ETL (SQL 2008/2012)

●Managed and modified existing data warehouses

●Performed data mapping against Fiserv and FIS banking core systems.

●Wrote and created processes to cleanse and cross validate data from Fiserv bank core.

●Became proficient on creating general ledger chart of accounts and implementing into a reporting system.

●Utilized TFS for the purpose of code check in and Agile tracking

(October, 2011 –August, 2012) Lockton Corp Kansas City, MO

Senior BI Developer and DBA

●Created and developed SSAS cubes in SQL 2008

●Created and modified ETL processes using sprocs and SSIS 2008

●Modified existing Data warehouses

●Performed data modeling using Power Designer tool

●Wrote and created processes to cleanse and cross validate data from source data.

●Created and modified reports using SSRS 2008 and Qlikview

●Utilized TFS for code check in

(January, 2008 –February, 2012) Encore Reports LLC Leawood, KS

(Self-owned LLC providing consulting and contract services)

(April, 2010 –February, 2012) SourceCorp Overland Park, KS

Contractor Database OLAP and ETL Developer

●Developed and modified SSAS 2005 and 2008 cubes

●Created and modified ETL SSIS process feeding into multiple data warehouses

●Modified and maintained multiple data warehouses in SQL 2005 and 2008

●Utilized TFS for code check in

●Performed data modeling using Erwin modeling tools.

●Wrote CLR procedures in order to create a secure data access for client

February, 2010 –April 2010) SMG Kansas City, MO

Contractor ETL Developer

●Wrote stored procedures in SQL 2008 for data cleansing

●Created and modified SSIS processes in SQL Server 2008

(September, 2009 –February 2010) Quintiles Kansas City, KS

Contractor ETL and Report Developer

●Developed reports in SSRS 2008

●Wrote stored procedures to support reports

●Maintained and modified ETL solutions using Informatica

(January, 2008-August, 2010) US Salt Kansas City, KS

Consulting Database and Report Developer

●Created SSRS 2005 reports focused on billing and manufacturing related issues.

●Created custom web pages for forecasting and tracking of raw goods.

●Performed DBA related tasks for maintenance and optimization of database.

(December, 2007 – May, 2009) Sprint Corporation. Overland Park, KS

Database Analyst

●Created a reporting data warehouse (SSIS) merging Oracle and SQL Server 2005 data sources.

●Created and modified reports in Microsoft Reporting Services 2005/2008

●Created adhoc reports in SQL Server and then automated via Excel scripts

●Wrote a variety of t-sql scripts for the purpose of updating data in various databases

●Wrote and modified stored procedures in Microsoft SQL Server 2005/2008

(May, 2007 – November, 2007) Adknowledge, Inc. Kansas City, KS

Senior Email Analyst

●Managed deliverability, ISP relations, and mail system configuration for email lists

●Provide data analysis of delivery, user response, and financial metrics

●Created and implemented several reports in Oracle using Toad

●Modified database objects in MySQl.

(Aug, 2006 – April 2007) Datacore Marketing Kansas City, KS

Data Warehouse Developer

●Designed and implemented several Data warehouses using Microsoft SQL Server 2005 based on Kimball design.

●Created and modified OLAP cubes using Microsoft SSAS OLAP

●Created ETL processes using Microsoft SSIS 2005.

●Wrote stored procedures, extended views, DTS packages.

●Created 50+ reports using Microsoft Reporting Services within a 5 month period.

(Apr, 2005 – August, 2006) Yellow Roadway Corporation Overland Park, KS

Senior Data Analyst

●Designed and implemented a Data warehouse using Microsoft SQL Server 2000

●Created multiple data warehouses for the purposes of reporting and archiving data.

●Wrote stored procedures, extended views, DTS packages

●Experience using SSIS and Microsoft Reporting Services 2005

●Create internal web pages using ASP.NET

●Successfully passed 1st exam for MCDBA certification (70-229 – SQL Server 2000 Database Design and Implementation) Microsoft Certified Professional ID: 3672606

(2002-March, 2005) Comcast Corporation Richmond, VA

Data Analyst and Billing Manager

●Created reporting process for entire division (Marketing, Inbound Sales)

●Provided performance metrics and statistical analysis to Marketing department for demand forecasting.

●Integrated multiple Oracle databases into Microsoft SQL 2000 Server.

●Output mailing lists for the purpose of marketing outbound mail campaigns.

●Automated data merging process via DTS procedures and stored procedures.

●Created multiple Access databases for several departments utilizing VBA language

Marketing/Database Analyst Portland, OR

●Created and implemented Microsoft SQL 2000 databases for usage in Sales department.

●Provided performance metrics and statistical analysis to Marketing department for demand forecasting.

●Managed daily\monthly sales reporting process using Microsoft SQL 2000 database and Access databases.

●Managed monthly commissions program for all of inbound bound sales.

●Created a new inbound sales commission program and implemented system in Microsoft SQL Server 2000.

(1998-1999) Disney Interactive Burbank, CA

Senior Manager, OEM Business Sales.

●Managed with Director responsibilities all aspects of OEM Business Development for Disney

●Licensed children's software titles and Disney content to major PC hardware and software manufacturers.

●Created a software distribution channel utilizing the DVD medium and an unlocking based on pay per use plan.

●Planned product features and product components into Disney Interactive titles, including 4 native DVD titles.

(1990-1998) Microsoft Corporation Redmond, Washington

OEM Sales Manager\Systems Engineer.

●Negotiated and licensed Microsoft software to strategic OEM U.S. subsidiaries (AST Computer, Toshiba America, Fujitsu Computer Systems, NEC Technologies,Acer America, Epson America). I generated $20+ million dollars per year in non-systems related revenue (Works, Money, Encarta, Golf, etc). I also negotiated, signed and managed a $50 million dollar Windows 95 license with NEC Technologies (an MDA OEM account)..

●Acted as the Microsoft DVD Evangelist working directly with Toshiba, Sony and other members of the DVD consortium and members of the Technical Working Group (Jan 1994 - March 1995)

●Created and implemented a variety of marketing and co-marketing programs between OEMs and Microsoft

EDUCATION

University of Oregon Eugene, Oregon

4 years Graduate Work as MS Student in Marketing, Statistics and Sport Psychology 1986-1990

University of Illinois Chicago, Illinois

1 Year graduate work as Ph.D Student in Industrial /Organizational Psychology 1985

Ohio Wesleyan University Delaware, Ohio

Bachelor of Science in Psychology, History, Physical Education, 1985

Contact this candidate