Leon Tidwell Email:ad355j@r.postjobfree.com

Mesa, Arizona Phone: 602-***-****

Highly effective and results-driven Data Architect with Teradata warehouse and Cloud environment experience. Expert in optimizing query performance in SQL Server Integrated Services and SAP Data Services. Successfully managed teams of ETL developers and analysts tasked with delivering critical business processes and reporting. Large Dataset ingestion, Optimization.

TECHNOLOGIES & PLATFORM EXPERIENCE

Cerner EMR(DB2), Teradata Studio, SAP Business objects, Informatica, Power BI, Crystal Reports, Azure, Tableau, ERWIN, M.S. SQL Server, SQL Server Integrated Services, SQL Server Report Services, Quick Test Pro/Quality Center, Oracle Developer, SAS Enterprise Guide.

Collaboration Tools: Jira, MS Teams, Confluence, Slack.

Programming: C#,VB Script, VBA, T-SQL, SQL. Other Software: AS400, EDW, Minitab.

Operating Systems: Windows, AIX.

PROFESSIONAL EXPERIENCE

BI Sr. Data Architect, Banner Health, Phoenix

May 2014 to Present

•Develope/Maintain Healthcare Data model

•58 Hospitals/Clinics and 28 Pharmacies

•Develop/Maintain Teradata data lake-Migrated to Azure Cloud

•Maintain and promote SSIS packages to new environment

•Erwin Modeling

•Insurance and Finance Modeling

•Power BI Dashboard and SSRS reporting

•Manage team of five Business Intelligence ETL analysts

•Document system requirements and processes

•Lead IT committee Service Level Agreements (SLA) for URAC certification for pharmacies

•Lead IT collaboration between Technical and Business

•Approve ETL work to be moved to production

Quality Advisor Med D RMT, CVS Caremark, Scottsdale

June 2007 to 2014.

•Developed RMT SQL 2008 db./Develop SSIS packages for MED D

•Created Automated Processes for Payer to Payer, Gov’t Claims

•Automatically processed > $10 Mil in claims annually

•Sourced Claims from EDW

•Mentored a team of 4 analysts

•Developed Quick Test Pro(QTP) Scripts for Quality Testing

•Created Winrunner/QTP Scripts to Test Green Screens

•Tested Web/Intranet production Changes per requirements

•Data Stuart/Developer

•Used Enterprise guide (SAS) to facilitate reporting

Metrics Supervisor, Caremark, Scottsdale

January 2005 to 2007

•Managed team of 5 analysts

•Developed Med D reporting for CMS

•Project Manager for Careview to completion

•Organized movement to SQL environment

Sr. Metrics Analyst, Caremark, Scottsdale

January 1999 to 2005

•Maintained Call Center and Agent Productivity Metrics

•Led a team of 5 analysts in prioritizing projects. Worked with Clients to determine reporting guarantees

•Developed/Scheduled Crystal Reports using Business Objects Enterprise 11

•Worked with Supervisors and Managers to implement productivity measures for their agents

•Facilitated Stars reporting, reporting to clients and reporting guarantees

•Developed M.S. Databases to facilitate Metrics Reporting, a cost savings of 3 FTE over the course of 3 years

•Migrated all access databases to SQL Server 2000

•Communicated with scheduling to validate assumptions and scheduling issues

•Design a Scorecard/Dashboard Application used for agent productivity and schedule compliance for all processes

•Troubleshot Microsoft Access/Visual Basic application issues

•Trained Supervisors and Managers in the use of Metrics to help them coach their agents

Certifications and Specialized Skills:

•Citizenship: US Citizen

•Clearance: Secret, 1/1988-11/2006

•Air Crew Egress Technician, Air Force Reserves, Luke A.F.B., AZ, 8 years

•Private SEL Pilot, 6 years

•Calculus and Statistics Tutor, Mesa Community College, Mesa Arizona, 2 years

US Citizen

Air Crew Egress Technician, Air Force Reserves, Luke A.F.B., AZ 8 yrs

Secret Security Clearance 1/1988-11/2006

EDUCATION

B.A. Mathematics, Arizona State University-Related study in Statistics and Economics

A.A. Aircraft Systems Maintenance Technology, Community College of the Air Force

Contact this candidate