Data Analyst Resume

SUMMARY
Solutions-oriented developer/consultant with a proven record of success in working with MS ACCESS and MS Excel applications, building and revamping relational databases, Excel spreadsheet analysis, report presentation design, and end user training

Demonstrated expert knowledge of the stages of database construction using MS Access including: data modeling with table relationships, import/export functions, ODBC interfacing, advanced form & report design, high-level query writing, SQL code modification for customized queries, macro automation and user training within the application

Possess an excellent record of end-user training on developed applications

Displayed leadership skills, initiative, and a self-motivated work ethic that has often resulted in increasing responsibilities, and the overall satisfaction of management

Have functioned as an extremely effective liaison between IT professionals and employees working with developed applications. This has led to training responsibilities often in the past

Have distinguished myself as an advanced report designer through the expert use of MS Access using SQL code for query modifications

Core Competencies

MS applications development

Report Design & Presentation

A/P-A/R invoicing expertise

Extensive Training Acumen

Marketing Data Analysis

Technical Proficiencies
Platforms: Windows 95/98/NT/2000/XP/2003/2007
Languages: SQL
Tools: Microsoft Office Pro (Word, PowerPoint, Excel, Access), Quick Books, Crystal Reports, SQL Server

PROFESSIONAL HISTORY

Confidential, July 2011-Present
Data Analyst

Long-term contract assignment working in the Discoverant database inputting data and ultimately designing queries and reports in compliance with Federal regulatory audits.

Contributions

Utilized Excel spreadsheets to track the progress of ongoing data population into the Discoverant application

Developed proficiency in the use of the Discoverant application

Provided “in house” Excel and Discoverant training to coworkers populating the Discoverant database with manufacturing sciences data.

Confidential, February 2011-April 2011
Data Analyst

Contract assignment that involves the updating of insurance provider information in multiple systems. Involves drawing from numerous SQL-based proprietary applications to pool data to make necessary demographic updates.

Key Contributions

Customized Excel spreadsheets with macros and cell formulas to automate data calculations

Processed medical claims using SQL based proprietary in-house technologies

Provided “in house” Excel training to analysts who were previously proficient only on Mainframe applications.

Confidential,July 2010-September 2010
Data Analyst

Contract assignment involving revenue compliance audits featuring heavy use of Excel spreadsheets implementing pivot tables, charts, formulas, and V-Lookups

Key Contributions

Performed audits to track company contract revenue through the use of 2007 Excel spreadsheet templates.

Designed pivot tables and charts to show summary reports of potential revenue savings

Trained others on how to implement advanced Excel 2007 functions

Confidential, November 2005-February 2007
Data Analyst

Utilized extensive reporting techniques using MS Access and MS Excel in an effort to target various “market segments” of customers to determine marketing strategies that will maximize sales dollars, sales volume and acceptable general margins for adequate pricing.

Key Contributions

Automation of monthly reporting functions for the company using Scheduled Tasks and advanced Access macros

Customized Excel spreadsheets with macros and cell formulas to automate data calculations

Worked with advanced Excel graphing techniques, using pivot tables/cross tabs to pinpoint deficiencies in current marketing strategies (bids, contracts, catalogs, mailings, email)

Changed the database modeling to provide referential integrity to the record sets, and cascading table information which resulted in an improved integration of MS Access data

Confidential,September 2000-Dec 2001
Associate Operations Coordinator/Data Analyst

Developed and maintained MS Access Databases that tracked the allocation of funding for DOD Confidential Nuclear Aircraft Carrier Overhauls. These databases where required to have sound, accurate data, while discretion & attention to detail in this environment was a must. This position also entailed the heavy use of the SQL Server (7.0) application, which involved high-level sublanguage code writing using the Query Analyzer, Enterprise Manager, Stored Procedures, Mailing Views, and complex DTS functions

Key Contributions

Reporting functions were automated to perform without fail in an exacting, as well as highly bureaucratic IT client/server environment

Confidential demographic material was pulled to the consistent satisfaction of management as a result of expert use of the MS Access application

Many successful presentations (using PowerPoint, Crystal) as well as employee training seminars were conceived & executed while serving the Navy as a civilian developer

The judicious use of VBA coding allowed for relatively painless platform conversions and necessary data migration through the use of ODBC functions

*This position required the obtainment of DOD CONFIDENTIAL government security clearance

Education & Credentials
Bachelor of Arts in History

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship