| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name Email:EMAIL AVAILABLEMesa, Arizona Phone: PHONE NUMBER AVAILABLEHighly 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 EXPERIENCECerner 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 EXPERIENCEBI Consultant/Data Architect, Lancesoft for Lockheed Martin Corporation(Sikorski Business Unit)Sept 2021 to PresentDesign Data Models for new environmentMigrated Data Services ETL processesMaintained and promoted SSIS packages to new environmentOptimized existing DataflowsDevelop Power BI Dashboards/Power BI AdminTroubleshoot Datawarehouse production issuesPower-BI developmentBI Sr. Data Architect, Banner Health, PhoenixMay 2014 to Sept 2021Developed/Maintained Healthcare Data model58 Hospitals/Clinics and 28 PharmaciesDevelop/Maintain Teradata data lake-Migrated to Azure CloudErwin ModelingInsurance and Finance ModelingPower BI Dashboard and SSRS reportingManaged team of five Business Intelligence ETL analystsDocumented system requirements and processesLed IT committee Service Level Agreements (SLA) for URAC certification for pharmaciesLed IT collaboration between Technical and BusinessApproved ETL work to be moved to productionQuality Advisor Med D RMT, CVS Caremark, ScottsdaleJune 2007 to 2014.Developed RMT SQL 2008 db./Develop SSIS packages for MED DCreated Automated Processes for Payer to Payer, Govt ClaimsAutomatically processed > $10 Mil in claims annuallySourced Claims from EDWMentored a team of 4 analystsDeveloped Quick Test Pro(QTP) Scripts for Quality TestingCreated Winrunner/QTP Scripts to Test Green ScreensTested Web/Intranet production Changes per requirementsData Stuart/DeveloperUsed Enterprise guide (SAS) to facilitate reportingMetrics Supervisor, Caremark, ScottsdaleJanuary 2005 to 2007Managed team of 5 analystsDeveloped Med D reporting for CMSProject Manager for Careview to completionOrganized movement to SQL environmentSpecialized SkillsPrivate SEL Pilot, 6 yearsCalculus and Statistics Tutor, Mesa Community College, Mesa Arizona, 2 yearsUS CitizenEDUCATIONB.A. Mathematics, Arizona State University-Related study in Statistics and Economics |
