Data Administrative Assistant

ANGELENA JACKSON

**** ******** ****, **********, ** 30052 phone: 404-***-**** email: *****@********.***

SUMMARY OF SKILLS

Nineteen years of experience in database development, query and report writing, data mining, data management and data analysis. Organized, detail oriented, innovative self-starter with excellent verbal, written and presentation skills.

SQL – write and execute SQL queries to extract data.

MS Access – design and develop databases (using VBA and macros); design user interface forms; write advanced queries; develop database reporting; export and upload data.

Excel – write and troubleshoot VBA macros; create programmed spreadsheets and dashboards; design charts & graphs; create advanced pivot tables to summarize data.

Reporting – Design, develop and implement new reporting; model reporting to track trends; troubleshoot reporting problems; analyze existing reports to promote automation and streamline reporting processes.

Data Analysis – Collect and organize data from multiple sources and present it to a wide audience of internal and external stakeholders; analyze data to track trends, identify problems and recommend solutions.

Documentation – document procedures and user guides; interpret and document workflow processes.

PROFESSIONAL EXPERIENCE

Zadi-Mart, Loganville, Georgia (part time) 2009 - 2014

Co-Owner – Home Based Online Retail Store (full time) 2014 - 2016

Tripled the monthly gross revenue of a small home-based online retail business in less than a year by identifying buying trends and changing the store’s inventory to meet consumer demands.

Developed and maintained an Access database to enter product descriptions and track store inventory. Created a database program that exported a CSV file that was uploaded to the store’s internet site.

Managed the store’s monthly budget, maintained all financial records and developed P&L reporting.

Aon Integramark, Alpharetta, Georgia 2011 – 2014

Reporting Analyst – Client Reporting

Developed an Access database that saved the company from losing a $3M client. The database was placed on a Citrix server and addressed the client’s need for immediate access to their reporting.

Wrote SQL queries to extract data from call management system for client reporting and ad-hoc requests.

Automated and streamlined existing client reports using VBA macros in Excel and Access.

Documented reporting procedures and made recommendations to management for improvement.

Developed an Access database for insurance division to provide metrics and reporting for insurance operations and underwriting team.

CARE, Atlanta, Georgia 2010 - 2011

Independent Consultant – Human Resources

Prepared a three-year technology roadmap for the HR department. The goal of the roadmap was to identify system inefficiencies and outline the steps necessary to streamline technical processes.

Surveyed and interviewed HR team members to identify areas of improvement.

Documented current and future state processes and flow of data diagrams using Visio.

Angelena Jackson Resume / page 2 of 2

CARE, Atlanta, Georgia 2006 - 2010

Business Analyst – Human Resources

Developed and maintained an Access database that helped to automate the process of producing candidate offer letters. This database also produced a file that was uploaded into the Lawson HRIS as pending personnel actions, reducing the amount of manual data entry by 50%.

Produced the organization’s gender, equity and diversity reporting which was used by the CEO to identify areas of potential risk.

Managed a technology assessment project which outlined all of the systems used by HR, the cost to maintain those systems and the areas where improvements were needed.

Developed and maintained an Access database that was used for two years to store talent management data from CARE staff around the world and provided talent management reports. The database was used by all levels of management throughout the organization and by the recruiting department.

Maintained the website which hosted CARE’s internal LMS known as CARE Academy.

UPS MAIL INNOVATIONS (through Spherion Professional Services), Alpharetta, Georgia 2005 - 2006

Data Analyst – Billing Department

Developed a database in Access that was used by three different departments to track collection efforts, customer complaints and resolutions.

Provided analysis of shipment data and financial data from Oracle and published periodic reports to finance department and sales team.

Developed and maintained a database that was used to generate billing summaries.

Designs By Dot, Inc., Co-Owner, Lake City, South Carolina & Decatur, Georgia 2002 - 2004

ADP Tax Credit Services, Data Analyst, Florence, South Carolina & Atlanta, Georgia 2002 - 2003

The Coca-Cola Company, Senior Research Specialist, Atlanta, Georgia 1998 - 2001

Lee Hecht Harrison – Administrative Assistant, Atlanta, Georgia 1996 - 1997

First Data Resources – Proof Operator, Atlanta, Georgia 1994 - 1996

EDUCATION & TRAINING

Training & Development:

HTML – Web Design, Emory Center for Lifelong Learning, Atlanta, Georgia (2009)

VBA & Access, Emory Center for Lifelong Learning, Atlanta, Georgia (2007)

Undergraduate Course Study:

Computer Information Systems, Georgia Perimeter College, Clarkston, Georgia

Computer Science, Clemson University, Clemson, South Carolina

Contact this candidate