Database Analyst Resume
Sioux City, IA
Objective: To obtain a Mid-Level Position as an Analyst within an established or growing Corporation, utilizing my technical and analytical skills.
Education:
B.S., Science/Business Management
A.S., General Business
Skill Summary
The ability to gather, analyze, and research demographic, statistical, and account information. Then Use the aforementioned information to interpret the data in order to forecast future trends for preparation, and generation of various analytical reports, including Business Plans.
Computer Skills: Windows 2000/XP/VS, Microsoft Office 2000-2007, Adobe Photoshop, basic HTML, File Maker, Business Objects, SQL, and SPSS.
Employment History
Database Analyst, Confidential,Sioux City IA March 2008 – September 2009:
Create complex queries within MS Access and SQL Server Databases, then use said query data for analysis and report purposes.
Ad-hoc Reports; create and interpret Pivot Table reports and charts.
Automation: MS Excel-VBA macros and Excel connections with external programs to pull in data.
Research current and future competitor’s products for company benchmarking and competitive analysis reports
Relational database maintenance in preparation for monthly newsletter distribution
Occasional PowerPoint Presentation for company meetings.
Data Analyst, Confidential,Troy MI April 2006 – January 2008:
Created queries within MS Access and Oracle Databases, then query the database tables for data analysis and report purposes.
Manually update, insert or delete data based on various error reports that are generated at various stages of data transmission and process.
Design, develop, and deliver Business Object reports.
Extract large quantities of client data from MS Access and transfer data to MS Excel
Accurately create MS Excel Pivot Tables utilizing vendor and invoice information.
Troubleshoot potential issues which lead to monthly PowerPoint Presentations demonstrating errors found within database as well as all updates made each Analyst.
Assistant Manager, Confidential,Detroit MI, December 2005- May 2006: Customer Service, sales, inventory management, Accts Receivables and Accts Payables, etc.
Distribution Controller, Confidential,Troy MI, May 2004 - September 2004:
· Storage – organized inventory of tires for purchase and display, and market for the general public.
· Inventory – Assisted the Warehouse manager with shipping, receiving and the appropriate storage of merchandise as directed.
· Updated vendor information using an Access Database.
· Analyze and interpret financial data for preparation and generation of various financial reports.