Data Analyst

Victor Callahan

**** ******* **** ***** ******, Georgia 30080 770-***-**** home *************@*****.***

OBJECTIVE

To obtain a challenging opportunity with an organization that will effectively utilize my experience, training, and achievements.

QUALIFICATION HIGHLIGHTS

Offering a background of formal education and experience in business & financial systems, data systems analysis,

financial reporting, database management, pivot tables, macros, advance filters & formulas, records, reports, queries, and

implementing policies & procedures.

Proficient in planning and completing projects to high standards in time-critical situations.

Strengths include excellent analytical, organizational, time management, interpersonal, and problem solving skills. Proven

ability to quickly grasp client needs and implement successful strategic plans

Advanced computer skills (Access, SQL, SAP, Excel, Word, PowerPoint, Outlook, and Lotus Notes.).

PROFESSIONAL EXPERIENCE

ATLANTA TECHNICAL SUPPORT Jan 2013 – Present

Database Analyst/Developer (Consultant Position)

Created Access databases for reporting and process improvement.

Consulted with clients and gave recommendations to meet there specific reporting needs.

Wrote queries and code using T-SQL to produce and automate reporting.

Communicated with all departments to gather data and reporting specifications.

Created Access databases for end users with full documentation for reporting.

Created coding and queries in Access to import data from multiple sources.

Presented reporting results using different functions in Excel.

Meet all reporting and time requirements.

COCA COLA REFRESHMENTS, ALPHRETTA, GA Sept 2012 – Jan 2013

Data Analyst (Contract Position)

Designed a daily report in Access to help reconcile the Coca Cola Parts System.

Worked with management to determine and gather reporting requirements.

Used T-SQL coding to extract and manipulate data for reporting.

Created an ad-hoc report in Access to identify and research the variances between the Coca Cola Parts System and SAP.

Used advanced features in Excel for report presentation.

Worked with IT to transfer business logic to the IT Department.

Analyzed complex database dictionaries for work flow and reporting.

MATRIX CAPITAL RESOURCES, DULUTH, GA Jan 2009 – Mar 2012

Data Analyst

Wrote advance coding in SQL and Access for financial reporting.

Performed data mining and data manipulation tasks in Access .

Analyzed and reconciled data variances and conducted research to solve the root cause.

Access Database Development and Automation

Used Trans Codes in SAP to extract and analyze data.

Performed complex statistical analysis in Access.

Created interfaces in Access for end-users

Used SQL for data extraction and database automation.

Created and analyzed financial reports utilizing advanced pivot tables and macros in Excel.

THE COCA COLA COMPANY- SIEMENS, Atlanta, GA June 2007 – Oct 2008

Database Analyst/Developer (Contract Position)

Produced a daily measurement report for upper-level Coca Cola Management.

Developed complex queries in Access to produce and automate important historical databases.

Created coding in Access to verify and analyze critical data and reports.

Served as a liaison between IT and other business functions.

Worked with team members to complete various projects.

Used Excel to create advanced spreadsheets and reports.

Created new procedures for process improvement.

Assisted other team members with databases and reporting.

Used coding in Access to create ad hoc reports.

Provided reporting and analysis to various clients.

COCA COLA ENTERPRISES, Atlanta, GA Mar 2006 – May 2007

Volume Analyst, (Contract Position)

Developed advanced coding in Access and SQL to create complex Sales reports.

Created macros in Access to run large sets of queries.

Developed coding in Access for report automation and process improvement.

Created complex pivot tables to format Sales reports.

Designed coding in Excel query to import data into Excel from other sources.

Experienced in advanced formulas, macros, and linking worksheets in Excel.

Developed ad-hoc reports in Access for variance departments.

HURRICANE KATRINA RELIEF VOLUNTEER Sept 2005 – Jan 2006

AMERICOLD LOGISTICS, Atlanta, GA May 2003 – July 2005

Database Reporting Analyst

Utilized technical knowledge of Access and SQL to automate financial reporting processes on project for replacing manual data

entry & reporting.

Ad hoc financial analysis of financial and operating metrics to support the Director of Accounting.

Designed, created, and maintained all databases used by the automated system.

Developed queries with Access for verifying data integrity and accuracy.

Created a data dictionary for the tables in Access Databases.

Provided technical support to end users on Access.

Prepared & reviewed financial reports, and conducted analysis on data and variances for management reports.

Created the reporting format for financial reporting.

MCI, Atlanta, GA Oct 2000 – April 2003

Financial Reporting Analyst

Applied expertise with Access and SQL to perform data extraction, manipulation, and analysis, and automated monthly market

reports by writing queries.

Created an optimization project in Access to create company savings.

Data mining to identify customer segmentation opportunities based on profitability.

Key liaison for all key data to support ongoing projects around cost increases as well as saving opportunities.

Provided Revenue and Expense Analysis Reporting to upper management.

Oversaw project involving data transfer from Excel to Access and SQL.

Initiated and completed audits on revenue and billing databases to locate and reconcile discrepancies.

Interfaced professionally with other Database Analyst to develop and test Access and SQL databases.

EDUCATION

SOUTHERN UNIVERSITY, Baton Rouge, LA

BA in Accounting

REFERENCES AVAILABILITY UPON REQUEST

Contact this candidate