St Data Architect

Leon Tidwell Email:************@*****.***

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

•Developed/Maintained Healthcare Data model

•58 Hospitals/Clinics and 28 Pharmacies

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

•Tableau Report Development

•Insurance and Finance Modeling

•Power BI Dashboard and SSRS reporting-using T-SQL

•Managed team of five Business Intelligence ETL analysts

•Documented system requirements and processes

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

•Convert SSRS reporting to Business Objects reporting

•Approved ETL work to be moved to production

BI Consultant/Data Architect, Lancesoft for Lockheed Martin Corporation(Sikorski Business Unit)

Sept 2021 to Mar 2023

•Develop New Oracle objects with T-SQL

•Develop Oracle PLSQL and DDL, DML scripts

•Migrated Data Services ETL processes-Convert SSRS reports to BO report

•Maintained and promoted SSIS packages to new environment

•Optimized existing Dataflows

•Develop Tableau Reporting and Power BI Dashboards

•Troubleshoot Datawarehouse production issues

•Backup/Disaster Recovery

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

•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-Grad. 1996 Related study in Statistics and Economics

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

Contact this candidate