Senior Consultant / Analyst Resume

SUMMARY:

I have worked with around the world to create database and Excel solutions. I consistently deliver results that mitigate financial and corporate risks, increase accuracy and reliability, while saving my clients time and money.
Microsoft Excel with VBA/macros/Custom Toolbars
Microsoft Access with VBA and SQL
SharePoint as an Access backend
Visio
Project Management
Project Life Cycle
Database Design
Software Development

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant / Analyst

Responsibilities:

Created complex Excel workbook to compare different drilling scenarios for sustainability. Workbook includes graphic interface to select different data entry tables, ability to copy scenarios, one - click ability to analyze percent change for sixteen different scenarios. GHG calculations can be made in either metric or imperial, and for EPA or EU standards.
Expanded complex Excel workbook that helps salespeople create bids for major projects. Data is loaded to workbook from Microsoft SQL or Oracle database. Salespeople can create and compare up to seven different scenarios to help them make the winning bid. Custom toolbar aids navigation.
Created custom Excel template to enable onshore and offshore engineers to report on product usage to client companies. Templates are populated from SQL Server / Oracle databases.

Confidential, Houston, Texas

Senior Consultant / Analyst / Developer

Responsibilities:

Managed all phases of over a dozen database projects for the ExxonMobil Development Company from concept to final product, including project scoping, timeline and budget management, database design and development, software design and development, implementation, testing, documentation, post-launch support and on-going maintenance. Projects include:
Designed and developed Access/Excel/VBA database which helps users effectively manage employees and contractors across ExxonMobil Development Company projects. It produces over 30 Excel reports including key metrics for upper management.
Designed and developed Access/Excel/VBA database that tracks Job Cards for ExxonMobil projects. This system allows bulk upload of drawing and material data from Excel.