Data Developer

Ryan P. Casey, MBA, BA **********@*******.***

**** ****** ***** ***.****************.com

mailto:**********@*******.******** Richland Hills, TX 76180 www.linkedin.com/in/ryancaseymba/

Mobile 817-***-**** www.linkedin.com/company/aim-report-writing

Business Intelligence Professional, Strong Business Acumen, Clear Communication

13+ Fortune 500 Corporations Implementing Data Centers and Data Warehouses

oProject Managing Consultant for 3 Microsoft Gold Partner Companies 1 Silver Partner Company

Top 25 Ranked Program, Innovation and Entrepreneurship MBA (3.698 GPA), University of Texas at Dallas

o15+ years SQL Server and Oracle (T-SQL PL-SQL), (Excel Flat Files XML)

o12+ years Visual Studio (SQL Server Date Tools Data Tools Business Intelligence) / (ASP.Net C# VB.Net)

o10+ years (Excel), (SSRS SSIS SSAS), (Performance Point Power Pivot Power Query)

Shared Development Services: SharePoint Server, Team Foundation Server and Project Server

Friend of Redgate (SQL Toolbelt), Idera (SQL Diagnostics), Credera (Impala Hive Pig Spark)

Business intelligence professional seeking permanent employment that utilizes over fifteen years of experience in information technology. An acceptable role would target 4-5 hours of daily development (data warehouses and business intelligence products) and 3-4 hours of daily secondary, self-directed roles such as technical skills development, project maintenance, expectation management, and daily collaboration including: email, verbal, scrums and tactical meetings. An ideal role includes flexible scheduling with 3-5 days of remote development. This role would utilize Microsoft SQL Server’s Business Intelligence catalog of products as well as other professional and technical tools such as the Microsoft Developer Network. A desired company will have an excellent reputation, clearly defined projects and productivity goals / reporting, strategically implement technology, and provide an innovative environment staffed with top quality professionals.

Medical

Envision Healthcare, Examination Management Services, T-System, Extendicare, Blue Cross / Blue Shield

Oil and Gas / Environmental Banking Insurance Construction

Safety-Kleen, FracTech Beal Bank, CitiGroup Torchmark, Blue Cross / Blue Shield DR Horton Homes

Technology

Hitachi Consulting, Catapult Systems, Robert Half International (Salaried Professional Services), Micron Technology, MCMS

Retail

GameStop, Standard Motor Products, Safety-Kleen, PepsiCo, Neiman Marcus Group, Mary Kay, Inc.

Business Processing Business Services Conglomerates Education

Source Corp FedEx Kinkos Cooper Industries Cambium Learning Group, Uplift Education

Professional Experience

Mary Kay, Inc. (RightStaff, Inc.), Addison, TX 10/2015 – 1/2016

Microsoft T-SQL / SSIS Developer

Development

oSQL Server Data Tools (SSDT) Solutions (Builds, Publishing, and Maintenance)

T-SQL Scripts for Tables, Stored Procedures, Indexes, Functions

oSQL Server SSIS Packages using Package Deployment Model

oPowerShell Environment Management

Data Warehouse / ETL Maintenance

oFact and Dimension Data Investigation using T-SQL Scriting

oSource Data (transactional) and Target Data (data warehouse) Comparison and Validation

oEvaluation of Row / Column Based Auditing and Query Based Sanity Checks

TFS Source Control and Work Items

oObject Versioning and Work Item History

oRequirement and Bug Status Updates, Progress, Links, and Attachments

oBug Root Cause and Solution (fix) Analysis

oPowerShell Task Management

GameStop (NYSE: GME), Grapevine, TX 10/2014 – 5/2015

Data Modeler, Senior ETL/ ELT Developer

Modeled Data Warehouse, Data Marts, Data Repositories, and ETL / ELT processes using CA ERwin Data Modeler

Developed / Maintained SQL Server 2012 SSIS Projects (Packages, Parameters, Server Environments, SQL Jobs)

oTablet Usage Reporting, and Multi-Channel Product Page, Downloadable Content (DLR) Return Codes

oDatabase and Table Size Statistics, SSIS Package Inventory 2008R2 and 2012

oShip from Store (XML), Commission Based PC Downloads

oHyperion Flash Sales and Hyperion Consolidated for Domestic and International

SnapLogic (Training by SnapLogic), Hadoop (Training by Daugherty Business Solutions), Metadata Manager (Training)

LevelUp Leadership Workshops

Envision Healthcare (NYSE: EVHC), Dallas, TX 07/2013 – 4/2014

Senior Microsoft Business Intelligence Developer

Developed and Architected Major projects

oED (Emergency Department) ETL (SSIS) and ED Analytics (SSAS and PerformancePoint).

Patient Volume, 72 Hour Readmits, Relative Value Units per Hour (RVU), Left without Treatment

oIPS (Inpatient Services) ETL (SSIS) and IPS Analytics (SSAS and PerformancePoint).

Admissions, Encounters, 30 Day Readmits, Length of Stay, Net Revenue, RVU Rates, Downcodes

oPIT (Practice Improvement) ETL (SSIS) and PIT Analytics (SSAS and PerformancePoint).

Patients per Hour, Acuity Level, Productivity, Critical Care Denied, PQRS Non-Compliance

oRTI (Medical Billing) ETL (SSIS) and RTI Analytics (SSAS and PerformancePoint).

Designed and Created Special Projects

oDWH Framework

Master Packages, Checkpoints, Transactions, and OnError Email Notification

Logging (Batch, Package, Table, Cube Processing) and Stored Procedure Last Run (used for delta loads)

Configuration (Data Connections / SMTP Connection / Email Configurations) and Environment Variables

oTeam Foundation Server 2012 / Source Control (Integration, DevTeam1, DevTeam2, Test, UAT, Hot Fix, and Prod)

oSharePoint Issues and Enhancement Lists with Alerts

Modeled Data Warehouse, Data Marts, Data Repositories, and ETL processes using Embarcadero ER Studio Data Architect

Standard Motor Products (NYSE: SMP), Lewisville, TX 02/2013 – 05/2013

Lead Microsoft Business Intelligence Architect

Enterprise Data Warehouse Infrastructure, Architecture, Maintenance, and Disaster Recovery

Safety-Kleen (NYSE: CLH), Richardson, TX 05/2012 – 02/2013

Lead Microsoft Business Intelligence Architect

Developed an Oil Cube (SSAS) used to monitor the sales of 3 recycled oil refineries with revenues of over 1.2 billion dollars a year and sales of 160 billion gallons of recycled oil a year made from 200 billion gallons of collected used oil a year.

Developed a Pay-For-Oil ETL (SSIS) process that combined both flat file data loads with SAP data feeds by moving the data through stage, consolidation, and transformation layers to a final star schema.

Built a Customer Segment and Zone / Node pricing extract, transform, and load (SSIS ETL) processes that delivered customer segment and pricing data to the star schema.

Created dozens of SSRS reports and Performance Point dashboards such as Closed Order Information and 12 weeks Overdue Parts Washer Maintenance.

Designed extract, transform, and load (SSIS ETL), SSRS, SSAS and Performance Point documentation including a business overview, technical models, object lists, and tasks / blockers.

Cambium Learning Group (IntgrITalent), Dallas, TX 03/2012 – 05/2012

Senior Microsoft SQL Server Reporting Services (SSRS) Developer

Class Schedules and Rosters, Department, Location, and Staff Reporting and Dashboards

Chart of Financial Reporting (Company, Accounts, General Ledger, Products, Categories)

Hitachi Consulting, Dallas, TX 10/2011 – 03/2012

Senior Microsoft Business Intelligence Gold Partner Consultant

Client: PepsiCo (NYSE: PEP)

Senior Consultant on 3-person team that closed the statement of work (18k) for a DTS solution migration.

Supervisory role for the implementation of the “Hybrid Delivery Solution.” The Hybrid Delivery Solution is used to place orders for cross-dock customers. These cross-dock customers were composed of the companies most valued customers who requested a customized delivery of Pepsi and Frito Lay products. This solution (application) was used on average 3 to 4 times per week by two subject matter experts (SME) that processed thee cross-dock orders.

SQL Server 2005 DTS upgraded to SQL Server 2008, Access 2003 application front-end upgraded to Access 2010

Client: Uplift Education

Senior consultant tasked to develop an ad hoc reporting analysis. This analysis looked at three main products. Microsoft Performance Point, Report Builder, and Power Pivot.

Created MDX based calculations, calculated members, and named sets based on educational metrics such as cost per student and current admission levels compared to the last time periods and parallel time periods.

Designed Performance Point analytic grid reports and charts using advanced MDX queries for calculations not stored in the cube, or formatting such as alerting based on defined measures.

Defined cube KPIs using MDX for the value, goal, status, and trend expressions for metric groups such as development of faculty and staff and academic instruction.

Customized BI Center (Business Intelligence SharePoint site template) in a communication and collaboration effort. Libraries included dashboards, Power Pivot gallery, and RS Reports. Additional Libraries include PPS Content (KPIs, Score Cards, Dashboards, Analytic Grid / Chart Reports, Filters, Time Intelligence), PPS Data Connections, and Site Pages.

Blue Cross Blue Shield of Texas, Richardson, TX 6/2011 – `10/2011

Senior SQL Server Developer, Dashboard Developer

SQL Server Reporting Services (SSRS) Dashboards

T-SQL Database Objects for Data Marts and Data Repositories

Examination Management Services (Leprechaun), Fort Worth, TX 3/2011 – `6/2011

Senior Extract Transform and Load (ETL) Developer / SQL Server Business Processing

Nightly Process, Processor, and Assessment Projects (SSIS 2008, SQL Server 2008, T-SQL)

Load Process Re-Design (SSIS 2008, SQL Server 2008, T-SQL)

Home Health Care Report Repository (SSRS 2008)

Catapult Systems, Dallas, TX 12/2010 – 03/2011

Senior Lead Microsoft Business Intelligence Gold Partner Architect / Developer / Administrator

Client: FracTech

Architect on 5 person sales team that helped sign 2 statements of work (250k and 235k) for business intelligence solutions lasting in the Dallas metroplex for 7 weeks and 5weeks.

Designed SSIS historical and delta data loads using segregate keys for referential integrity and conformed dimensions. The cube included role playing, degenerate, and junk dimensions.

Identified MDX based calculations, calculated members, and named sets based on oil and gas metrics such as system availability and production yield for period to date that were used in Performance Point analytic grids and charts.

Delivered a Business Intelligence Roadmap to a company in the oil and gas industry including fifteen (15) SSRS Reports.

T-System (BravoTech), Dallas, TX 08/2009 – 08/2010

Data Services Architect / Developer / Administrator

Implemented a reporting architecture (T-Reporting) using T-SQL, SSRS and SSIS for T-SystemEV (EDIS).

Cube foundation designed following the Kimball Group methodology and using a data-mart-bus architecture.

Created MDX objects on medical industry metrics (patients discharged against medical advice and patient errors.

Designed Performance Point analytic grid reports and charts using advanced MDX (number of starts and stops of fluids).

Defined cube KPIs using MDX for the value, goal, status, and trend expressions for length of stay and bed utilization.

Custom deployment for T-Reporting using Powershell, Reporting Services Script (RSS), XML Configuration Files, SQL Management Objects (SMO), and Windows Management Instrumentation (WMI).

Developed a C# custom SSIS data flow transformation called Report Exporter. This custom data flow transformation synchronously took a data flow input and exported reports based on fields in the data flow such as webServiceURL, reportName, reportPath, destinationReportName, destinationReportPath, and parameters.

Robert Half International (NYSE: RHI) Microsoft Business Intelligence Gold Partner 01/2008 – 02/2009

Client: Torchmark (NYSE: TMKPRA) Client: Source Corp

Neiman Marcus Group Senior Business Objects XI Architect / Developer / Administrator 05/2007 – 01/2008

M1 Support Services Microsoft Business Intelligence / SharePoint Services Developer 02/2007 – 04/2007

Resulte’ Universal (FedEx Kinkos, NYSE: FDX) Business Objects XI Architect 11/2006 – 03/2007

Primus Global Services, Inc. (CitiGroup, NYSE: C) Business Objects XI Architect 01/2006 – 07/2006

Sense Corp (Cooper Industries, NYSE: CBE) SAP BW Data Warehouse Developer 06/2005 – 10/2005

DR Horton Homes (NYSE: DHI) Business Objects XI Developer 05/2004 – 05/2005

Assisted Living Concepts (Extendicare, NYSE: EXE) SQL Server / Crystal Reports Developer 05/2003 – 04/2004

Micron Technology, Inc. (NYSE: MU) and MCMS (Plexus) Intern C++ Programmer 01/2001 – 05/2002

Education

8/2011 University of Texas at Dallas Professional MBA Program – Innovation and Entrepreneurship Focus (3.698 GPA)

8/2002 Boise State University Bachelor's Degree – BA in English, Technical Communication & Computer Information Systems (CIS) Minor. Dean's List with High Honors: Spring of 2000 and Spring of 2002. (3.127 GPA)

Contact this candidate