Andrew Radtke
EBI Developer II at Baylor Scott & White Health- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Baylor Scott & White Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
EBI Developer II
-
Jan 2019 - Present
Austin, Texas Area
-
-
-
FirstCare Health Plans
-
United States
-
Insurance
-
100 - 200 Employee
-
BI Developer III
-
Apr 2017 - Jan 2019
Austin, Texas Area - Responsible for pulling complex data sets from disparate data sources to provide information to business stakeholders in a cohesive format - Developed robust end to end workflow solutions using ETL packages with error handling and logging to pull data from OLTP sources for consolidation into datamart destinations - Designed, developed, tested and implemented complex business reports and dashboards to support business stakeholders and regulatory reporting requirements - Drove… Show more - Responsible for pulling complex data sets from disparate data sources to provide information to business stakeholders in a cohesive format - Developed robust end to end workflow solutions using ETL packages with error handling and logging to pull data from OLTP sources for consolidation into datamart destinations - Designed, developed, tested and implemented complex business reports and dashboards to support business stakeholders and regulatory reporting requirements - Drove, gathered, and evaluated reporting requirements to support health data analyst reporting needs - Effectively communicated with team members and management to share knowledge and training in data structures, business processes, and data development practices - Collaboratively engaged and worked with users to ensure data quality, integrity and to identify gaps in data rules
-
-
Health Data Analyst
-
Apr 2016 - Mar 2017
Austin, Texas Area - Deployed solutions for the dissemination of intelligence, trend and root cause analysis by leveraging data from the collection of data warehouses - Built and maintained the presentation of complex data sets for the business that highlights key insights and met periodically with business owners for metrics and analysis - Mentored reporting team coworkers to refine requirements, develop, code, unit test, and document for the successful delivery of reporting needs - Analyzed complex… Show more - Deployed solutions for the dissemination of intelligence, trend and root cause analysis by leveraging data from the collection of data warehouses - Built and maintained the presentation of complex data sets for the business that highlights key insights and met periodically with business owners for metrics and analysis - Mentored reporting team coworkers to refine requirements, develop, code, unit test, and document for the successful delivery of reporting needs - Analyzed complex datasets to observe trends, draw conclusions, and make recommendations to the business in order to enable data-driven decision making - Gathered and evaluated reporting requirements to support reporting development
-
-
-
-
Senior Business Analyst
-
Aug 2014 - Apr 2016
Austin, Texas Area - Translated customer proposals into working reporting deliverables for development - Worked with stakeholders throughout the development process to ensure customer needs are met throughout the development and delivery process - Administration of multiple Tableau server environments in addition to providing guidance and training for new users - Updating and maintaining Tableau reports in addition to SSIS packages for time reporting and management needs - Creation of production and… Show more - Translated customer proposals into working reporting deliverables for development - Worked with stakeholders throughout the development process to ensure customer needs are met throughout the development and delivery process - Administration of multiple Tableau server environments in addition to providing guidance and training for new users - Updating and maintaining Tableau reports in addition to SSIS packages for time reporting and management needs - Creation of production and ad-hoc reports for client review or management needs - Analyzed business processes and requirements by conducting design sessions with business users and business subject matter experts
-
-
Data Conversion Analyst
-
Feb 2008 - Aug 2014
Tucson, Arizona Area - Development of SSIS packages using C# scripting to facilitate the loading and transformation of large data volumes - Responsible for the estimation of the conversion implementation plans and time tables, including the monitoring and optimizing of total conversion time - Analyzed business processes and requirements by conducting design sessions with business users and business subject matter experts - Discussed and assisted peers with the conversion methodology in particular the data… Show more - Development of SSIS packages using C# scripting to facilitate the loading and transformation of large data volumes - Responsible for the estimation of the conversion implementation plans and time tables, including the monitoring and optimizing of total conversion time - Analyzed business processes and requirements by conducting design sessions with business users and business subject matter experts - Discussed and assisted peers with the conversion methodology in particular the data model, data flow, and conversion mapping - Performed and guided the data cleansing processes, and monitoring to ensure data validation and quality - Maintained on site and distance client relations for multiple state projects involving up to 50% travel and expense reporting - Triage of reported data conversion bugs and investigation into customer inquiries concerning data - Created conversion plans, rules and mapping documents for client signoff and implementation by database developers
-
-
-
3M
-
United States
-
Industrial Machinery Manufacturing
-
700 & Above Employee
-
Quality Assurance Technologist
-
Jun 2005 - Mar 2008
Tucson, Arizona Area - Responsible for testing 3M products to ensure client specifications were met - Gathered defect details and escalated defects to the development, business analysis and quality assurance teams - Created test-related plans, cases and data for the 3M products - Setup test data for the batch jobs and analyzed the resulting output files - Created and updated the documentation of test scripts and test cases for the use of the test department and user acceptance testing -… Show more - Responsible for testing 3M products to ensure client specifications were met - Gathered defect details and escalated defects to the development, business analysis and quality assurance teams - Created test-related plans, cases and data for the 3M products - Setup test data for the batch jobs and analyzed the resulting output files - Created and updated the documentation of test scripts and test cases for the use of the test department and user acceptance testing - Independently set schedule and prioritized tasks for completion of goals on projects Show less
-
-
-
Blueprint Consulting
-
Business Consulting and Services
-
1 - 100 Employee
-
Software Quality Engineer
-
Mar 2003 - Jun 2005
Phoenix, Arizona Area Evaluated software and documentation to ensure the product quality of software developed by the Administrative Office of the U.S. Courts for the Bankruptcy, District and Appellate court systems. Software Quality Analyst - Executed black and white box testing on the implementation of system modifications to the District and Bankruptcy Court software - Analyzed and evaluated Java, JavaScript, Pearl scripts to troubleshoot software - Coordinated and trained remote testers in the… Show more Evaluated software and documentation to ensure the product quality of software developed by the Administrative Office of the U.S. Courts for the Bankruptcy, District and Appellate court systems. Software Quality Analyst - Executed black and white box testing on the implementation of system modifications to the District and Bankruptcy Court software - Analyzed and evaluated Java, JavaScript, Pearl scripts to troubleshoot software - Coordinated and trained remote testers in the testing and user acceptance of new enhancements to the software - Created and updated the documentation of test scripts and test cases for the use of the test department and user acceptance testing - Independently set schedule and prioritized tasks for completion of goals on projects Show less
-
-
-
-
Software Quality Engineer
-
Apr 1997 - Aug 2001
Bellevue, Washington
-
-
Education
-
Bellevue Community College
AAS, Computer Science