Data Analysis Excel Access vlookup Reporting Metrics

Objective:

Meticulous, proven and efficient professional seeking key position

where I can continue to be an immediate resource and long-term valuable

asset.

Summary:

Extract, integrate data to create exceptional quality reports for

budget, metrics, scorecards, material control, purchasing, supply chain

/ demand, usage, trends, variances, forecasts, accruals, warehousing

including hospital, medical, engineering, construction, real estate,

pipeline, oil & gas, waste management, compression with minimal

supervision and easily integrated with new teams.

Superior Qualitative/Quantitative Analytical Skills

Designed queries to return accurate, quality data. Normalized

incongruous data, GAAP, audited Lean 5-S manufacturing flow line,

created relational databases.

Power User Advanced Skills - Computer/Software - Not Limited To:

MS Office / Excel / PowerPoint / Word / Access / Project / Primavera /

Visio / Report Writer / Strategy / RIBS / CMS / CRM / Enterprise

OneWorld JD Edwards PeopleSoft / Adobe / AS400 / Sage MAS90 / Seagate

Crystal Reports / CAPEX / Deltek / Hyperion Essbase / PROFS, PFS Write

Commercial Real Estate / Land Development / Construction / Manufacturing

Confirmed accuracy of permits, warranties, meetings, costs. Reported

progress, handled RFP's, RFI's, RFQ’s, change orders, assisted

investors, attorneys, accountants

Superior Soft Skills

Earn respect and trust quickly by being an immediate asset with

initiative to work outside the box to assure cost-effective solutions,

worked with Spanish-speaking teams in manufacturing, employed absolute

discretion and highest sense of urgency

History:

ANALYST, Dr. John Lang, CPA, MHA, PhD Houston, TX

10/03-Present

Enter data and write nested formulas to analyze data. Maintain data integrity, chain

of custody of sensitive information. Produce variance reports,

presentations in PowerPoint. Develop analysis plans, supported

recommendations. Designed Access database, DBA with over 40 end-users,

tracked $100MM in accruals, AFE’s, created reports, forms, queries,

managed tables, joins, conversion / integration of external data,

exceeded expectations.

Contributed to cost savings by eliminating need for outsourcing by

managing a critical mail merge, wrote macros. Designed reports: Access,

Excel not limited to vlookup, pivot tables, nested formulas.

Saved $13K extracting data from 1000 files into one data table. Awarded

and charged with improving, auditing Access parts database. Performed

financial, operational analyses. Conducted 5-S lean process audit given

2 weeks, finalized in 2 days well ahead of deadline. Created GANTT

charts, graphs, operational reporting, KPIs, verifying current, past

values. Developed variance, production, man-hour and trend reports,

Excel graphs, charts, PowerPoint.

ANALYST, Methodist Hospital System, Houston, TX 02/01-10/03

Saved $120K eliminating need to outsource analysis, bid process to

Ernst & Young CapGemini.

Saved $40K reducing report time turnaround from 3 weeks to 6 hours,

exponentially increasing accuracy writing SQL code.

Designed reports: Seagate Crystal Reports, Access, McKesson HBOC - PMM

(Pathways Materials Management), COGNOS-BI, SAP-BW. Supervised $40MM

audit for the V.P., Budget & Finance for FEMA losses with shared Excel

file, authorizing input, integration using SQL. Audited external

vendors' reports (medical products for tier pricing). Prepared reports

for Director, the President and Board.

Assistant, NEW AMERICA/Victory Mgt,

Houston, TX 01/99-02/01

Managed subcontracts for projects involving City of Houston.

Personally scheduled meetings with Councilmembers, Senators, members of

Congress, elected officials (Kay Bailey Hutchison, et.al.).

Preparations for Vice President as Commercial Seller for Bracewell &

Patterson and Northwestern Mutual Life's President. MasterSpec,

Prologue, Quantum Project Management (QPM), Deltek. Maximized reporting

with Bloomberg, ACT, Access, PowerPoint. Overlaid multiple charts,

graphs, plots. JD Edwards, demonstrating import processes for journal

entries and general ledger. CAPEX, PeopleSoft, macros, advanced

formulas, pivot tables, vlookup. Tracked accruals, voucher

distributions, depreciations, leases, reconciliations, ABC - 80/20

Reports, P&L, inventory, shipments, balance sheets, gross development

costs, construction draws, revenue recovery, audit. Enron / BP / BHP /

Ernst & Young (Cobb) / Shell / EPROD Enterprise LNG Pipeline.

Education:

Bradford School of Business - Graduate

International culture / Military SOP / Languages-Spanish, German, French,

Italian, Japanese, Africaans, Russian

Contact this candidate