Technical Director | Senior Data Architect Resume - Hire IT People

TECHNICAL SKILLS

Languages: SQL, T - SQL, PL/SQL, VB/VBA, SQR, XML, Python

Data Engines: SQL Server 2000 - 2016, Oracle 9-12, Teradata, DB2, MySQL

BI Tools: SAP Webi/Deski, Crystal Reports, SSRS, Hyperion, OBIEE, Brio, QlikView, Tableau

ETL Tools: SSIS, DTS, Informatica, Health Catalyst (SMD & SAMD)

Other Tools: MS Project, Visio, Visual Studio, MS Access, MS Office, SSAS, Stata

PROFESSIONAL EXPERIENCE

Confidential

Technical Director | Senior Data Architect

Responsibilities:

Facilitated successful implementation of EDW for large ambulatory health system in less than one year
Complete on time and within budget
Transferred all functionality from Information Builder’s DW to EDW and QlikView dashboards
Created full ETL from Allscripts-TouchWorks and GE-Centricity to EDW
Created simple solution to pull all dictionary tables into one for easy use in data model.
Created complex QlikView dashboards to support continuous process improvement
Used innovation ( Design Thinking) to remove roadblocks
Designed self-service BI/ data access solutions
Prepared them to be self-sufficient via training and mentor coaching
Returned high ROI in both cost and customer satisfaction
Designed and led data warehouse migration project, from department based data warehouse to an EDW (enterprise data warehouse)
All managed care/ shared risk; data, logic & externally reported HEDIS quality measures
Combined logic for all shared risk into one code set
Created QlikView analytics application to show these different patient populations
Prepared code for successful external HEDIS audit.

Confidential

Senior Data Warehouse Engineer | Data Architect

Responsibilities:

Implement first EDW solution for finance and academics utilizing Informatica and Business Objects.
Kimball data modeling of complex 6000+ table/object PeopleSoft Finance, HR, & Student.
Created process to deal with PeopleSoft effective date time creating termination date time for each record.

Confidential

Analytics Engineer

Responsibilities:

Create and improve MS Access based analytics application system used by auditors to find and write claims.
Analyze, Design, Create and Implement process improvement solutions
Building Data Marts for use by Auditors
Designing Custom T-SQL Solutions (ETL, Stored Procedures, Functions)
Performance tuning 100+Terabyte Multi-Database Systems
ETL Run improvement from 7-8 days to 2-3 days

Confidential

Senior Business Analyst

Responsibilities:

Confidential

BI Consultant | Founder

Responsibilities:

Manage marketing, workload, AR/AP, and staff (2-4 Contractors)
Provide high ROI by consulting and training companies in the effective use of Business Intelligence
Develop data warehousing and reporting solutions with a focus on process improvement.

Confidential

EDI Systems Expert | BI Developer

Responsibilities:

Manage all pricing and automated creative content for integrated (EDI) distributors
Create innovations for new ETL and data warehouse needs
Engineer complex reporting using SQL, Business Objects Webi/Deski/Crystal Reports, Teradata/TOAD(Oracle)

Confidential

Senior Business Analyst | Programmer Analyst

Responsibilities:

Provide consulting and business solutions in the use of database applications and Business Intelligence
Create custom programming, SP, triggers, functions, views (SQL, MS SQL Server 2000 & 2005)
Create complex reports using SQL and (Crystal Reports 8.5, 9, 10, XI, 2008)
Manage client accounts, build positive relationships and resolve conflicts

Confidential

Research Analyst

Responsibilities:

Led grant funded project: neuropharmacology effects of methamphetamine and cocaine in dopamine neuron/cell excitation in nucleus accumbens.
Confidential is thought to be a key player in reinforcement learning, behavior, and addiction.