Thomas Miller

• Provide standby of DWH batch (ensure delivery of reporting dependencies).
• Find resolutions to any data discrepancy between the Data warehouse and Source Systems.
• Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
• Evaluate performance of stored procedures and make recommendations for optimization.
• Extract large volume of data for business analysis.
• Log incidents and ensure successful resolution of issues.
• Write queries to independently validate results of existing analytics and make recommendations.
• Provide business with regular feedback on data related queries and timelines for solutions.
• Investigate incident that relate to Stores Reporting.

Oracle Apex development :

• Front -End design
• Back-End SQL scripting
• Views
• Procedures
• Functions
• Triggers
• Packages

Oracle Apex support and admin :

• Access control
• Deployments of solution between DEV, QA and Prod
• Capture and maintain meta data
• Engage with business to build Oracle Apex solutions
• Engage with other IT teams including Oracle DBA's for technical support
• Represent change controls at CAB
• Architecture input in BI Architecture Forum
• BI Architecture forum hosting

AWS Quicksight :

• Dashboard development

AWS Data brew:

• Technical rule scripting

Projects and Initiatives:

• Upgraded Apex from version 5.1.4 to version 18.1.0
• Developed Data quality dashboard in APEX to report on data quality dimensions in ODWH
• Developed hospitalization process to identify and investigate the cause for failed records into DWH
• Developed data quality dashboard using AWS Quicksight and AWS Data Brew part of the Foods Demand Forecasting project