Bill Wall Email & Phone Number

Brighton, Co, Us

Denver, Colorado, United States

Provided data engineering services for a local technology focused consulting firm• Maintained legacy SQL Server system for client during transition to cloud-based data system• Analyzed and constructed data sets for telecommunications companies considering program mergers• Developed Matillion jobs to transfer data from DB2 database to Snowflake platform• Created multiple stored procedures for SQL Server and Snowflake databases

Boulder, Co, Usa

Provided data engineering services for the energy sector (utilities) servicing portion of a multi-national consulting firm• Created multiple AMI databases in SQL Server, Hive, and Snowflake using client-provided utility data• Supported migration of Energy practice's databases from SQL Server to Snowflake• Designed and implemented numerous SSIS packages for ETL processes on existing and new databases• Developed an SSIS package to calculate variations within a group of files• Utilized SAS to reconstruct an application originally developed in SQL Server• Constructed a database for the Small Business Association in MS Access, encompassing validations, form interface, and reporting

Denver, Colorado

Provided data science and analytical solutions for the mortgage backed security industry• Created reporting dashboards in MicroStrategy, utilizing URL API for formatting and exporting reports and passing parameters through hyperlinks• Developed and managed SQL Server data structures for mortgage industry and loan servicer performance data• Automated Servicer Relations consulting packages using TSQL stored procedures, Excel VBA macros, and R scripts• Conducted comprehensive data validation using SQL and SAS scripts• Built and maintained Monarch Pro models and Monarch Data Pump processes to extract data from loan servicer PDF files and load it into corporate databases• Developed various SAS scripts for tasks such as building amortization tables, calculating borrower harm from ARM loan pay histories, and pivoting data from loan servicer file review databases• Provided training sessions on SQL query writing, MicroStrategy report building and analysis, TortoiseSVN for version control, and Excel VBA macro writing• Mentored junior team members in SQL and Excel VBA programming, MicroStrategy report formatting, dashboard design, URL API utilization, and gathering project requirements• Developed test plans for MicroStrategy upgrades and database clean-up operations

Provided data engineering and report development services for the dental insurance industry• Created ad-hoc reports using Oracle Discoverer Plus/Desktop 10g• Developed Balanced Scorecard Application with Oracle Application Express 2.0 and PL/SQL on Oracle 10g database• Designed customizable loss ratio report for tracking claim costs versus premium collected• Automated generation of 40+ marketing reports and billing reports for policyholders• Coordinated with external customers to gather requirements and deliver data requests• Designed user-friendly interface for Oracle Discoverer Plus to facilitate non-IT use• Tracked project progress using Microsoft Project and Numara Track-It• Developed PL/SQL programs and CTL scripts to extract, transform, and load data into Oracle 10g database for DDCO

Provided data analysis and data engineering services to the workers compensation industry• Designed and implemented two sections of Pinnacol Assurance data warehouse for claims medical management and employee telephone activity• Utilized Visio and Oracle Designer for table diagrams, Quest SQL Navigator, VBA for Microsoft Access, and UNIX vi editor for PL/SQL development• Supervised Decision Support tools testing during upgrade of Pinnacol Assurance data warehouse from release 8.1.7 to 9.2• Introduced Oracle 9i Analytic SQL and conducted proof of concepts for Oracle OLAP and Oracle Data Mining applications• Designed and maintained reports in BrioQuery Explorer 6.6, Oracle Discoverer, and Oracle Reports 6i with extensive PL/SQL programming• Developed Executive Information System applications in BrioQuery Explorer using JavaScript• Created, implemented, validated, and monitored statistical scorecards for first report of injury, claims development, and policy auditing using Statistica 6.0 and VBA for Statistica• Modeled business processes with flow-chart diagrams in Visio• Developed VBA for Excel applications to generate workbooks with key performance indicators• Maintained extract programs for computation of monthly business objective targets using Oracle Pro*C

Denver, Colorado

Assisted the Manager of Actuarial Services with data analysis tasks• Prepared policy ratemaking reports based on calculations provided by Manager of Actuarial Services• Researched claim, medical, and policyholder data from paper files and proprietary computer systems• Transferred data into Excel spreadsheets for Manager of Actuarial Services' reporting needs• Generated reports showcasing policyholder's risk exposure, type of medicine practiced, and claim amounts paid out on their behalf