DATA ANALYST/REPORTING ANALYST SUMMARY:

Business Analyst, Data Analyst, Reporting Analyst, MS Access Database Developer, Metrics Reporting Analyst, Database Analyst, Database Specialist, Report Developer, Database Administrator, Database Programmer. Retrieves, collects, cleanses, manipulates, summarizes, and interprets, data. Identifies, analyzes, and interpret trends in large data sets. Data scrubbing/cleaning, root cause analysis, graphs, charts, forecasting and data research. Expert in MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio. Spreadsheets, graphs, charts, pivot tables, pivot charts, V-LOOKUP, Macros, advanced Excel and Access functions and formulas.

MS Access Experience:

Created MS Access databases for some of the largest companies in the US. Siemens, UPS, Wells Fargo, Bank of America, Comcast, Synchronoss and others. I am available for remote/virtual project work or local work in Conway, Arkansas.

SKILLS:

Microsoft Office Suite 2003, 2007, 2010, 2013 Access, Excel, PowerPoint, Word, Outlook, Project, Visio, SharePoint.Microsoft SQL Server 2000, 2005, 2008, 2012 Administration and Programming. TSQL, SSRS, Data Modeling, Data Warehouse, Web based reporting tools, SAP Business Objects Business Intelligence BI , Lotus Notes, AS/400, Windows XP, Crystal Reports XI, Cognos Impromptu, Oracle 10g, PL/SQL, Pinnacle Studio Plus, Goldmine, ACT 2000, Support Central, Flash, Snag-it, Smart Draw, UserBase V2.2.

COMPUTER TRAINING:

New Horizons Computer Learning Center: Microsoft Office Suite 136 Hours , Crystal Reports 9.0 8 Hours . UPS Corporate Training: SQL, Advanced Access, Advanced Excel, Excel Business Analysis Data Warehouse 56 Hours . VTC Online University: Microsoft SQL Server 2005, 2008, 2012 Administration, Programming, TSQL, SSRS, Data Modeling, Crystal Reports XI, Oracle 10g ISQL Plus Workspace, PL/SQL, 80 Hours .

PROFESSIONAL EXPERIENCE:

BUSINESS ANALYST

Confidential

• Streamlined and automated monthly reporting metrics for team.
• Created easy to use Excel templates with complex formulas and functions.
• Created MS Access database with advanced query functions, VBA coding to import data with the click of a button,
• Integrated MS Access Database with Excel using MS Query, advanced functions and formulas, charts, graphs,
• pivot tables.
• Compiled data from multiple sources into easy-to-consume and understand online views of the data published to
• SharePoint.
• Wrote T-SQL queries using Microsoft SQL Server 2012 and created reports using SSRS.
• Significantly simplified existing reporting processes.

DATA ANALYTICS AND SUPPORT

• Used MS Access, Excel, V-LOOKUP, charts, graphs, Excel advanced formulas and functions, macros,
• PowerPoint, MS Word, data analysis, reporting, data warehouse, Fieldglass, EZ-Suite, Modias.
• Performed data analysis to validate data warehouse changes.
• Built MS Access databases and created ad hoc queries and reporting for management.
• Responsible for writing business requirements and user documents.
• Responsible for running weekly and monthly reporting and ad hoc reports as needed.

BUSINESS ANALYST/DATA ANALYST

Confidential

• Responsible for writing business requirements and user documents.
• Using Cognos, Excel, MS Access, PowerPoint, Word, Oxygen XML Editor, SVN file manager.
• Validated enhancements using Oracle SQL Developer, SQL, PL/SQL queries.
• Built MS Access database with ODBC connection to the data warehouse.
• Performed data analysis, ad hoc reports, queries, metrics, charts and graphs in Excel, created PowerPoint content.
• Worked closely with project managers and team to convey requirements to developers for large scale
• data analytics project.
• Validated UAT test cases and submitted change requests to team of developers.

BUSINESS ANALYST/DATA ANALYST

Confidential

• Gathered requirements from end users, designed and built reporting solutions to capture and manage
• production data for 103 file reviewers.
• Improved efficiency of data collection and reporting. Before joining this project, a team member was receiving
• 53 emails every day to consolidate, summarize and report to management.
• Integrated MS Outlook with MS Access to collect data through email, data captured was automatically imported into
• MS Access database from Outlook inbox.
• Developed, built and maintained 2 MS Access databases to collect and manage data and reporting.
• Developed ad hoc reports and queries in MS Access. Created MS Access queries to report on weekly production,
• production numbers available with a click of a button.
• Wrote a business case in PowerPoint to explain the need for SharePoint to centralize reporting, SharePoint Team
• site was approved.
• Built and maintained SharePoint 2007 Team site. Integrated MS Access with SharePoint, linked MS Access tables
• to SharePoint lists for more efficient data collection.
• Created VBA Macros in Excel.
• Used T-SQL to write and edit queries in Microsoft SQL Server 2012 and SSRS.
• Used SQL to write and edit queries in MS Access.
• Used MS Project to create Gantt Charts for mortgage look back project.
• Trained end users how to enter their production data on SharePoint lists and created a user guide.
• Created PowerPoint presentations, graphs and charts for management reporting.

DATABASE ANALYST

Confidential

• Retrieved large data sets from User Base, developed MS Access databases, ad hoc reports and queries. .
• Used MS Access, MS Excel, V-Look Ups, Pivot tables and charts, MS PowerPoint, MS Outlook, MS Communicator and User Base to perform responsibilities.
• Coordinated with billing system Managers and support staff to clean up duplicate billing system user IDs in billing systems and User Base.
• Provided status updates on projects to Sr. Director of Information Technology and Sr. Director of Customer Service Operations.
• Participated in frequent conference calls with regions regarding User Base clean up phases.
• Cleaned and imported data into UserBase to correct duplicate data from regions.

REVENUE ASSURANCE ANALYST

Supported the business with data analysis and report development in SAP Business Objects Business Intelligence BI , Crystal Reports, Oracle Toad, PL/SQL, MS Access, MS Excel, MS PowerPoint, MS Outlook, Pivot Tables, V-Look Ups, charts, graphs.

• Developed and automated reporting. Self-taught SAP Business Objects Business Intelligence BI , improved efficiency and accuracy of daily reporting of Breakage metrics and monthly Revenue Reporting for over 40 partners.
• Worked with IT Dept. to implement requirements for BI Universes to support the business.
• Created charts, graphs and PowerPoint presentations for financial reviews and meetings.
• Participated in cross functional projects and problems as needed.
• Reviewed contracts to ensure compliance with billing rates and partners obligations.

• Supported billing team with payment reconciliation and invoice auditing.

CORP. REPORTING ANALYST

• Supported Global, Enterprise and Strategic Management with web based decision tools and data reporting.
• Used MS Access, MS Excel, MS PowerPoint, MS Outlook, Pivot Tables, V-Look Ups, SharePoint, Web Based proprietary databases, data warehouse to perform data analysis and advanced reporting functions.
• Generated sales reports and created various ad hoc reports as needed.
• Prepared PowerPoint presentations and managed sales databases.
• Solved business problems related to decision tools and reporting.

• Developed MS Access Database for Sales Operations Department.

INSURANCE AGENT

Top Producer South East Region.

• Won NAS award, wrote 51.5 applications in 1st 90 days.
• Won 1st and 2nd place in Winners Edge Sales Contest.
• Became part of Management team, trained and managed a team of 8 agents.
• Earned CLTC designation certification.
• Won 2 sales awards for beating my own best record in 2 quarterly sales cycles.
• Became expert telephone prospector and trained new agents how to use the telephone to conduct business and cold call, used web based lead system to generate reports, mailings and advertising.
• Licensed Insurance Agent in 4 states SC, GA, NY, CA.

DATA REPORTING ANALYST

• Responsible for data analysis and reporting to Management. Used MS Access, MS Excel, MS PowerPoint, MS Outlook, MS Visio, SharePoint, Pivot Tables, V-Look Ups, data warehouse, Support Central and advanced reporting functions to develop and manage data reporting.
• Created correlation and regression statistical analyses in MS Excel on the relationship that crude oil prices have on other oil commodities.
• Created Excel spreadsheet analyses to track spend by business units.
• Created and maintained SharePoint website for centralized team information sharing.
• Developed MS Access databases for team reporting enabling users to retrieve data metrics at the click of a button.
• Arranged technical on-site training for 150 GE Engineers.
• Responsible for all aspects of planning, managing and coordinating the Mechanical Design Fundamentals Technical Training Program for GE Engineers.
• Managed and maintained student databases, website content, lecture materials, schedules and workflow forms.

DATA ANALYST

• Responsible for data analysis and reporting of product line performance to engineering teams and Management.
• Extracted large data sets from Microsoft SQL Server, AS/400 and used MS Access, MS Excel, MS PowerPoint, Louts Notes, MS Word, MS Visio, to extract, analyze, manipulate and present data findings.
• Created root cause analyses, histograms to determine cause of quality and performance issues.
• Presented data findings in graphs, charts, pivot tables, pivot charts and PowerPoint presentations.
• Created data analysis presentations for weekly meetings, created org charts and diagrams in MS Visio.
• Created a faster more efficient method for tracking trial runs using MS Access Select Queries.
• Successfully coordinated QES Training for 20 employees.
• Became Quality Evaluation System QES database expert, self-taught proprietary database system and reporting capabilities.
• Won 2nd place in global PowerPoint competition created a PowerPoint presentation for the manufacturing/Quality Team to Present to annual summit in Italy.

ADMINISTRATIVE ASSISTANT

Senior Administrative Assistant to Plant Manager Senior Management Team.

• Responsible for all aspects of managing day-to-day operations of executive office.
• Performed data analysis and created reporting using MS Access, MS Excel, MS PowerPoint, Data Warehouse, JD Edwards to create and manage data reporting projects.
• Created correspondence, technical manuals, Excel spreadsheets, graphs and charts, PowerPoint presentations, MS Visio org charts and diagrams.
• Improved speed and efficiency of financial reporting, reducing 2 days of data manipulation to 2 minutes.
• Coordinated executive travel, managed executive calendar, handled logistics of meetings, high profile customer visits and other special in-plant events.
• Simplified the budgeting process, reduced several weeks worth of manual data extraction and manipulation to minutes.
• Worked with IT Dept. to create more efficient processes for accurate data collection and reporting.
• Conducted internet research for government contract opportunities and won the NASA Deep Space Cable contract for the Jupiter Icy Moon Orbiter JIMO Program.

ADMINISTRATIVE ASSISTANT

• Responsible for all aspects of managing day-to-day operations of executive offices.
• Provided high-level executive assistance and administrative support to 3 General Partners.
• Used MS Excel, MS Word, MS PowerPoint, MS Outlook and web based programs.
• Managed executive calendars and handled logistics of meetings and conference calls, coordinated travel and conducted internet research for special projects.

ADMINISTRATIVE ASSISTANT

• Responsible for managing office operations, provided administrative support to the President and Vice President.
• Assisted with the mortgage loan process, used MS Excel, MS Word, MS PowerPoint, MS Outlook and web based programs to create mass mailings to solicit business, prepared correspondence, spreadsheets, established workflow for daily operations and created central filing system.

EXECUTIVE ASSISTANT

• Provided client services, used proprietary software to manage client accounts, generated various reports, correspondence, MS Excel spreadsheets, MS Word, MS PowerPoint, MS Outlook, client mailings and day-to-day administrative tasks.