Oversaw the entire ETL (Extract, Transform, Load) environment including production processing and update migrations. Coordinated work load to create/update Informatica objects and Oracle database objects. Developed OBIEE reports and preformed testing/troubleshooting excercises.- Built the company’s first OBIEE application in conjunction with fellow ERP team members. Created customized processes to extract source data quickly and accurately, giving decision makers information needed to act on cost-cutting and profitability opportunities.- Developed a Rig Rating Report to grade the rigs on twelve aspects of the business, giving Sr. Management and Rig Operators timely information needed to improve accountability for the company’s operations. Significantly improved visibility into incident prevention and daily rig operations which drove an increase in revenue efficiency.- Produced a Vendor Scorecard using various criteria designated as relevant by the supply chain organization. Enabled the buyers to quickly evaluate companies and make confident money-saving decisions regarding purchases, as well as, educating the vendors on possible areas of improvement.- Facilitated a 24 hour support rotation for separate daily, weekly and monthly data loads. Created a standardized error response method which ensured prompt and precise action was taken to make reports available to a global audience across all time zones.

Created and updated Informatica objects and SQL Server objects. Developed data models to support reporting requirements. Monitored and supported all processes. Built and validated Siebel Analytics reports.- Installed latest Informatica version and upgraded existing repository data to new version. Verified that all existing workflows worked properly and provided expected results, resulting in faster processing times and increased reporting efficiency for clients.- Planned and updated the architecture of the SQL Server database to include facts, dimensions and bridge tables to handle many-to-many relationships. Streamlined data warehouse provided an efficient platform for various reporting requirements across variety of clientele.- Designed and built complex workflows using Autosys (a UNIX-based scheduler) which included the timings and interdependencies of all jobs as well as interaction between the application and the various development tools (Informatica, Siebel Analytics, DAC). - Assumed a 24-hour support role to ensure processing ran without issue, making reports always available and updated as expected.