Ting Abbey

ad4dwr@r.postjobfree.com 281-***-**** Houston, TX

Summary

Experience leading data warehouse & data mart projects - architect, design & lead the ETL development

10+ years’ experience in report adhoc, development and automation using Microsoft BI Stacks SSRS, SSIS & SSAS Tabular & Power BI

Experience in MS SQL Server, AWS Redshift, Azure Synapse Analytics

Education M.S. in Telecommunications Management, Oklahoma State University, Tulsa, OK

B.S. in Computer Science, Oklahoma State University, Stillwater, OK

Director of Business Intelligence Analysis & Services 03/2021-Present

Architect & design business intelligence projects such as Physician Compensation & Enterprise KPIs.

Design the reporting model for incoming & outgoing files handshake for the coverage detection process

Oversee team’s budget on SQL server, application licensing and headcount

Leading data integration in multiple mergers

Leading migration project from MS SQL on premise to AWS Redshift & Azure Synapse Analytics

Help design & architect the new EDW data model as a SME

Work closely with business stakeholders on various projects coming up with solutions that meet their needs

Coaching 6 direct reports, 2 BA & 4 developers

Help trouble shoot data and process issues in production if they can’t be resolved by developers

Business System Analysis Manager/Sr. Business Intelligence Specialist 07/2015-03/2021

Lead ETL development on recent mergers and were heavily involved in business requirement gathering

Architect, design and lead the data mart project

Architect and design the process for Team Services and migrating old TFS source codes repository

Lead reports consolidation projects to standardize revenue recognition process and Clinical Utilization and staffing

Work closely with developers and train them on both the technical and business aspects

Create reports per user requirements using Power BI & SSRS

Help business users define process to ensure the data integrity and ease of maintenance

Work closely with contractors and business users to help them understand the data and data warehouse processes

Manage resources allocation to support tickets and projects

Report Analyst, U.S. Anesthesia Partners, Houston, TX 07/2008-07/2015

Creating and maintaining ETL/data extraction and transformation processes from various source into data warehouse

QA Data within data warehouse against the data source

Maintaining data in SSAS tabular

Developed and maintain reports on SSRS server

Developed and maintain internal financial revenue models for multiple practices

Customized report interface using C#, Web services, ASPX & HTML

Reduced the month end reporting process time by automating the process

Working with various departments to gather report requirements and create custom reports for doctors and management

System Analyst, Harris County, Houston, TX 08/2004-07/2008

Creating various ad-hoc reports using MS Reporting Services (SSRS) and Crystal Report supporting Budget Office, Grants Division and various management studies

Create applications to perform ETL process to extract data from Cerner’s MsMeds application with IBM UniVerse multi-values database using UniObject APIs

Develop ETL processes to download data from HTTP & FTP sites and import into MS SQL to support jail system study

Design and develop budget forecasting application for the budget office using VB 6.0

Programmer Analyst, NPC International, Pittsburg, KS 07/2003-04/2004

Designed, developed, & supported back-office and POS system using C++, VB, MS Access

Designed & developed reporting tools for senior management team

Software Engineer, WorldCom, Tulsa, OK 05/2000-12/2002

Designed and developed dynamic web-based interfaces for web-based call center product, internet wholesale product, and capacity planning and provisioning system using Java technologies

Integrated a web-based application with billing and email systems using Java and Vitria Businessware

Computer Support Specialist, Oklahoma State University, Stillwater, OK 02/2000-04/2000

Computer hardware and software support

MIS Manager, The Westin & Sheraton Park Central Hotels, Dallas, TX 08/1999-02/2000

Performed computer hardware and software installation, upgrade and repair

Lead IT Y2K compliance projects and created IT contingency plans

Contact this candidate