Bill Biggs Excel Data Analyst

"Quality Should Be Intrinsic, Not Ancillary."

*** *****

Hutto, Texas 78634

Call / Text 512-***-****

-

WHAT I AM OFFERING:

Creative Excel\VBA Developer and Data Analyst with Out-Of-The-Box

thinking capability. Over ten years using Excel and Excel VBA from Excel

2000-2007.

9 Years of Primarily Non Supervisory Project Management over creation of

analysis tools for quality, manufacturing, inventory, scientific &

financial data.

Clear, concise oral and written communication with individuals, teams,

and groups (with technical and non technical backgrounds). Also strong,

gentle interpersonal skills laced with humor and solemnity as required.

An innate work ethic that recognizes the need for external and internal

customer satisfaction within company protocol and ethical boundaries (in

other words, no wink-wink-nudge-nudge offerings).

In a leadership position, I am a participative leader, taking queues and

encouraging input from those on my team, but taking overall

responsibility for decisions and results.

Professional references to vouch for my productivity, dedication,

expertise and character.

-

WORK EXPERIENCE:

Siemens Corporation, Contractor - Data Analyst, Telecommuting between

Texas and New York by VPN (December 2009 - April 2010)

Excel VBA Development and Analysis

Conversion of numerous files into Excel workbook

SAP entry

Heavy Sharepoint Usage

Daily Microsoft Live Meetings

Hours of SAP Training

-

AMD, Contractor - Data Analyst, Austin, Texas (October 2009 - December

2009)

Creation of Excel workbooks that query SQL tables and evaluate and

display that data in pivot tables and graphs

Complex VBA programming

-

Flextronics, Inc., Sr. Data Analyst, Austin, Texas (June 2008 - August

2009)

Creation of Excel dashboards for business analysis.

Creation of Excel analysis workbooks for work projection (some of these

will email completed reports to different groups)

Various workbooks import Access, csv. and SQL data packets using

customized macros

Have created some Access tables and simple queries

Created one workbook that creates and exports jpegs of various analyses

for use in a weekly PowerPoint presentation.

Created several Excel displays that show real time production rates

(WIP, Inventory, Shipments) for various section of the production

floor.

These are displayed on 50" flat panel screens to be viewed from great

distances. Have created a thoroughly modern "hi - tech" appearance for

easy eye appeal, and minor moral enhancement.

The macros are perpetual, running 24/7, needing no human interaction,

beyond the On and Off buttons.

Create detailed instruction and technical manuals for operation and

reproduction of workbooks

Left due to layoffs

AMD, Contractor - Data Analyst, Austin, Texas (February 2007 - May

2008)

Created a variety of Excel workbooks for scientific analysis of tests

run on CPU prototypes

Workbooks performed the following operations

Discerned errant data and expelled it

Organized data by several categories including source, test, frequency,

various controlled conditions, and other subsets.

Determine best and worst case results in organized, easy to understand

displayed

These workbooks processed raw data and would distribute clean data

packets for technicians in short order for close to real time analysis

(1 to 2 hour processing time)

Created detailed technical manuals for workbook operations

-

Dell, Contractor - Data Analyst, Round Rock, Texas (August 2005 -

January 2007)

Processed and analyzed raw data for mining purposes, and created

presentations (usually of those analysis in any format requested). This

was non-stop production of data and presentations in a high pressure

environment.

Did multiple Access data searches and processing. Aided in updating and

cleaning out data from tables that fed Access.

Created several automated Excel workbooks using macros and VBA

programming to automatically process imported data into the workbooks

using Excel VBA.

Created an Excel workbook that did comparative studies of parallel

databases to check for anomalies.

Created and edited a technical newsletter for the staff (100~)

providing instruction, updates, and handy tips for Microsoft software

apps (Excel and Access). Humorous, in color, with pop culture

references to keep info interesting. 5-6 pages, color .pdf on

completion.

Trained new personnel on SOP's, Excel and Dell software.

Experienced in D3, Dell PFR, Citrix, DellServe, Oracle

EDUCATION:

AAS, Electronic Engineering Technology, ITT Tech (January 1986 - March

1988)

-

-

SKILLS:

Excel Spreadsheet, Macros, VBA's, Pivot Tables (2003, 2007)

Access (2003, 2007)

Word ( 2003, 2007)

Outlook (2003, 2007)

Power Point (2003, 2007)

SQL (2000)

SAP Training

Oracle Experience

Windows 98 through XP Experience

Cumulative First Pass Yield Data Analysis

SPC Analysis

Highly Talented and Experienced Technical Writing Skill

Computer technology including Internet and intranet technology

-

OTHER EXPERIENCES:

ISO 9000, 5-S, employee auditing, process auditing, procedure

development, geo tolerance training, Six Sigma training, Kan Ban

experience, "Who Moved My Cheese", company traveling,

employee/management negotiations (personal conflicts), extensive

ministry and crisis intervention experience, former EMT for a 10 year

period, pastor, Sunday school teacher, plumbing, carpentry and

electrical experience, minor auto mechanics, a substitute teacher, a

volunteer fire fighter and homeless shelter volunteer. I can also spin

gold from hay and feed a family of six with two pork chops and a tightly

guarded secret family recipe.

-

WORK SAMPLES:

Samples of My Workbooks

Or cut and paste this link: "http://tinyurl.com/kmznwm"

Find me at LinkedIn

Or cut and paste this link":http://www.linkedin.com/in/williambiggs"

And find me on facebook

Or cut and paste link: http://tinyurl.com/y8qqy4l

And find my exhaustive resume at on Emurse

Or cut and paste link: http://bill_biggs.emurse.com/

-Find My E

Contact this candidate