Resume

It has been suggested that I post my resume on this page for those who might be interested, or were directed to it. So, here it is:

DAVID W. MEIGEL
Email: dmeigel@comcast.net
cell: (916) 662-5275

NO SAN FRANCISCO / S.F. BAY AREA CALLS PLEASE!!

SUMMARY

Experienced mid-career professional with proven skills in office management, supervision, assistant project management, business / data requirements gathering and analysis, metrics, reporting, dashboard and scorecard development, along with change management/policy and procedure analysis, seeks long term/permanent position where my organizational skills and management/supervisory talents can best be utilized.

PROFESSIONAL EXPERIENCE

Security Clearance: CLEARABLE!!

Technisource (Spherion)
Rancho Cordova, CA. 2009 - 2010
Consultant (Business Intelligence Analyst)
Provided data analysis, metrics, and KPI indicators required to drive healthcare services support to internal clients for McKesson, Inc. Successfully developed and maintained semi-automated macro-driven monthly reports using MS Excel in support of Corporate IT asset management efforts. Coordinated business intelligence analysis and updating corporate asset records with functional managers, data warehouse administrators, and internal clients using Remedy CMS. Served as sole backup and second level support to manager of corporate asset management database using the MRO ValueWeb application. Authored and edited technical asset management process documents and “Best Known Method” procedures.

Janus Research Group, Inc.
Little Rock, AR. 2008 – 2009
Cognos Report Writer
Successfully developed and instructed classes in BI Report writing for Army National Guard students attending Professional Education Center in-residence. Assisted other team members in courseware development and acted as adjunct instructor for other Cognos BI classes not otherwise matched to technical skill sets. Partnered with course developers in Resource Management Training Center to create and present Cognos BI reporting skills targeted to Finance Management personnel.

Kelly Technical Services
Rancho Cordova, CA. 2008
GeoAccess Report Specialist
Assisted VSP Client Services team with generation of MS Access/GeoAccess reports tracking membership demographics and projecting new business coverage areas in support of sales and marketing efforts to drive increased business opportunities. Worked directly with metrics requestors on data/report requirements. As part of a 3-person team, succeeded in getting department caught up on a 3-month backlog of reports, to be a month ahead of scheduled requests.

IT Strategies International Corp
Las Vegas, NV. 2008
Senior Business Intelligence Analyst
Provided corporate level business intelligence analysis using Cognos v 8.2 to develop reports for gaming industry revenue generation. Worked with senior executives along with business analysts to define report content, and then design end user reports.

Advanced Technology Group, LLC
Kansas City, MO 2006-2007
Senior Business Analyst
Successfully partnered with internal account clients in generating daily, weekly, and periodical MIS reports. Efforts included full identification and location of business intelligence data and divining requirements for development and production of Cognos Impromptu Web Reports and other formats (Excel/GeoAccess, etc.)

Rose International
Jefferson City, MO 2006
Business Analyst
Identified, documented, and published “Best Known Methodologies” for Documentation Management, Configuration Management, and Change Management functions throughout the department. Initiated documentation of High Level Design report requirements which pertained to internal metrics and reports development.

Rose International
Sacramento, CA 2005
Business Analyst
Succeeded in full development of 10 initial balanced scorecard metrics for senior management team. Information was used to drive further development of business intelligence metrics across applications development group. Technical specifications were documented initially using RUP (Rational Rose). Metric data collection was accomplished by SQL generation using MS Access and Excel.

VOLT Technology Services Group
Rocklin, CA 2005
Business Data Analyst
Performed data analysis in support of material shipping audits. Partnered with logistics team leader in analyzing data to identify and summarize domestic and international duplicate paid, overpaid, or erroneous invoices over a two year period. Succeeded in identification of $50,000 in charges due back to the company.

MSX International
Rancho Cordova, CA 2004
Business Analyst
Supplied business analysis of HMO and national pharmaceutical chain data using proprietary SQL-based database tools, Inform, InformPro, and Improve. Provided health care business intelligence needs including ETL tools, OLAP, ad hoc tools, built-in security, key performance indicators, charting, and interactive user-defined Web-based reports to major clients such as Hartford Insurance Co., Blue Cross/Blue Shield of Philadelphia.

Adecco Technical
Folsom, CA. 2004
Database Developer
Designed an MS Access database for collection of Region Sales Management data and reporting of periodic performance data allowing input from corporate mainframe sources and regional store flat file import. Developed executive summary metrics and indicators from data provided. Completed project was demonstrated and presented to senior management using MS PowerPoint, while user training and full documentation were also provided

Freelance IT Consultant/PC Support/Webmaster
Self / Orangevale, CA. 2003-2004
Created and managed MS FrontPage 2000 website for local church. Began development of Church library database using MS Access. Assisted various “walk-in” clients with personal PC software installation/configuration/troubleshooting issues.

Intel Corporation
Folsom, CA. 1999-2003
Client Support – Programmer/Analyst
Successfully generated, maintained and managed over 3,700 individual BI reports and metrics developed using Cognos Impromptu, MS Excel, and MS Access, which were provided to clients using a monitored semi-automatic local scheduled delivery software package. Report delivery was successfully maintained at a 97%+ availability rate, consistently exceeding a stated 95% goal for four consecutive years. Data collected was initially housed in a Sybase data warehouse environment, and later changed to a SQL Server 2000 environment. Worked directly with functional managers and senior group leadership in defining and documenting metric requirements; Created Visual Basic / MS Excel applet which automated generation of weekly warranty parts cost analysis report from various SQL sources (MS Excel, Cognos Impromptu). Application saved a minimum of 210 man-hours per year in report preparation and processing time; Developed metrics for Electronic Data Interchange (EDI) team tracking inbound/outbound transactions from Oracle data extracts; Served as Chairman of Global REX (Remedy) Users Group. Provided complete documentation on all report sets, and procedures

Kelly Services
Rancho Cordova, CA. 1998-1999
Database Analyst/Developer
Completed development of a rebuilt customer account information database; Managed and supervised the daily/periodic coordination of remote data uploads from company mainframe and Oracle database sources via FTP feed; Supervised the complete redesign of the project’s regional customer account information database, to include addition of new OOD features to include a revised coverage calculator and semi-automated data import capability:. Design improvements resulted in individual data entry ability being increased by at least 50%. Supervised a team of six members tasked with customer data entry/updates and generating mailing lists; Daily population of manual/FTP data input was achieved while consistently meeting daily customer information package printing target. Conducted weekly team and project staff meetings keeping project managers informed of progress and developments towards their respective goals.

Adia / Adecco
Folsom, CA. 1996-1998
Help Desk Technician; Information Systems Analyst
Performed duties as Help Desk technician providing assigned state support within Technical Assistance Center. Later transferred to working as primary data analyst/metrics provider to project manager of “Win/Win” site PC conversion project. Successfully completed all metrics assignments given, including major presentation of final project metrics to senior leadership; On project completion, was transferred to newly formed Quality Metrics and Feedback team responsible for all corporate metrics and indicators. Developed many Cognos Impromptu, Business Objects (2.x) metrics, MS Access and Excel reports, along with providing graphics and PowerPoint presentations of completed indices.

United States Air Force
(Various unit assignments) 1975-1996
Instrumentalist / Section Supervisor - Additional Duties
Supervised and rated section personnel in performance of daily duties. Managed assigned personnel dormitory and was responsible for over$250,000 in inventory/capital resources; Served as Chief of Administration (Office Manager) to unit Commander. Additional duties assigned at the direction of the unit Commander included Unit Safety NCO, Unit Historian, Duty Sergeant, PC Network Technician and Documentations Manager; USAF/Civil Air Patrol; Served as Deputy Commander, Northern California Group 25 Headquarters; Managed and directed daily operations of 14 member squadrons located throughout northern California in support of emergency services disaster recovery, search and rescue operations, drug interdiction efforts in coordination with state/federal law enforcement agencies, and support of cadet aerospace education programs. Additional information is available on request.

SKILLS:

Cognos Impromptu, PowerPlay, Framework Manager, Report Studio, Analysis Studio, Query Studio; WS-FTP; Adobe Acrobat, Adobe Exchange; MS Office 2007: Word, Excel, Access, Outlook, PowerPoint, Publisher; MS FrontPage 2000; MS Visio; ABC FlowCharter; Intuit GeoAccess; Business Objects (2.x); Data Analysis, Business Intelligence, Metrics / Reports, Presentations / public speaking; Office and team manager / supervisor; Organizational / operations management; Data analysis, configuration / change management, policy and procedure development; Trainer – instructor; Courseware development.

EDUCATION:

Inquestra, Ontario, Canada; June 2006
Business Systems Analyst Certification Course (IIBA approved)

National University, Sacramento, CA.1999-2001
B.S. Information Technology – magna cum laude

Cognos Corp, San Ramon, CA.2000
Certification; Application Administrator, Cognos “Impromptu”; “PowerPlay”

US Air Force Non Commissioned Officer’s Academy, Norton AFB,CA.1991
Completion Diploma – graduated in top 20 of class by point standings.

US Air Force/Civil Air Patrol – Squadron Officer’s School, Maxwell AFB, AL 1987
Completion Diploma

ANCILLARY TRAINING:

SQL/Transact SQL Query Language (16 hr online coursework); Business Case Development; MS Visual Basic Application Development (beginning); Requirements Engineering; MS Access Advanced Programming Techniques; Situational Leadership; MS Excel 2000; macro development; MS Excel Charting and Data Manipulation; Managing Interpersonal Relationships; Time Management; Working with Difficult People.

ASSOCIATIONS / MEMBERSHIPS:

National Association of Parliamentarians; California State Association of Parliamentarians; Air Force Musician’s Association

HONORS:

"Who's Who in America" 2009, 1998-99 Edition, Marquis Publishing Co.; Intel Quality Award - June 2001; Intel Direct Recognition Award (DRA) - June 1998; Intel Special Recognition Award, April/May/July 1997; "Who's Who in the West" 1994-95 Edition, Marquis Publishing Co.; US Air Force Commendation Medal; US Air Force Achievement Medal (2); US Air Force Humanitarian Service Medal; Civil Air Patrol Meritorious Service Medal; Civil Air Patrol Commander's Commendation Medal (2); "Outstanding Young Men of America" 1988/1990, OYMA, Montgomery, AL.