Data Analyst Reporting Analyst Business Analyst

Professional Profile

Career Objective

To continue my career path in a business systems environment, focusing on

project and information management.

Personal Profile

I am the type of person that looks for the next big problem. Trouble

shooting and solution management are skill sets I have fine-tuned over

the past projects I have managed directly or have been involved in.

Skills Summary

ERP System Expertise (M3/SAP) Microsoft Excel (14 yrs) OBIEE

ERP System Conversions (M3, VBA, Macros, Pivot Tables Data Mining

SAP, Pro4, Great Plains, Microsoft Access (8 yrs) SDLC

Lectra) Microsoft Word ( 14 yrs) Product Development

Conversion Areas: Materials Microsoft PowerPoint ( 8 yrs) Production Planning

Mgmt., Inventory Costing, Strong Written/Verbal

Production Planning, Microsoft Outlook (14 yrs) Communication

Purchasing, Sales Forecast ODBC Database Management

ETL Microsoft CRM Project Management

SQL Query Writing (iSeries / Microsoft SharePoint Data Extraction/Migration

AS/400) Visio

Engineering Cost Management

Informatica MDM

Professional Experience

Cox Communications (Atlanta, GA) Aug 2014 - Present (contract)

Reporting Analyst / Data Analyst

> Streamlined legacy Access database used to compile time tracking data

for building executive dashboards and post to SharePoint

> Developed new Access database to replace legacy time tracking database

o The new database reduced processing time from 16 hours to 5

minutes

> Developed macro in Excel to facilitate loading of HR data into

PeopleSoft

> Ran parallel processes with legacy database and new database and

analyzed the deltas between the two results

> Generated user manual in Word for end users to successfully use new

database

> Create adhoc reports for leadership as needed in OBIEE

> Conduct status update meetings and collaborate with team members on

improving current BAU processes

The Office Group (McDonough, GA) Aug 2013 - Jul 2014 (Entrepreneurship)

Independent ERP Consultant, Data Migration Specialist, Mobile App

Developer

> Worked with a customer's custom import/export process to integrate

compliance data within their SAP system.

> Extracted extisting item master data into Excel, cleansed the data,

then setup process form migration back to SAP.

> Generated reports and process flows for management to review via

Visio, Excel, and PowerPoint.

o Utilized VB to message the data and format in Excel

o Utilized Access to manage the different Excel generated tables

and create queries

o Utilized lookup tables and pivot tables and charts for

identifying data anomalies and generating summary reports

> Duty Drawback program implementation

> Android and Apple OS mobile app development for small businesses.

Autotrader.com (Atlanta, GA) Nov 2012 - Aug 2013 (contract)

Project Supervisor / Data Analyst

> Customer database migration from 5 separate legacy databases to one

revenue and billing system within Informatica MDM

> Track and manage progress throughout integration project via Excel VB

reports, SharePoint, and scheduled meetings.

> Utilize MS Access and Excel to manage various tables of large data

extracted from Informatica MDM and track history of changes made to

the live tables. Queries and custom reports were generated from

Access and Excel for the project manager to track.

> Ensured the products and services loaded to Informatica MDM mirrored

the business requirements as per contract signed by dealerships

associated with the different BUs.

> Manually entered dealership customers into Informatica MDM as needed

once the customer address information was vetted via internet

research, phone calls, and statistical analysis of the data.

> Put reports / slide decks together for management reviews summarizing

KPIs, risks, and milestones.

> Help out with production work within MS CRM system.

MarMac Manufacturing (McBee, SC) Mar 2012 - June 2012

Product Development Engineer

> Develop and test improvements to existing product lines for Level A/B

Hazmat suites

> Manage information across three different ERP systems and keep the

data in sync

> Work with the manufacturing plant for optimizing sewing processes

> Develop and implement a new sewing specification system

Encompass Group LLC (McDonough, GA) Nov 2002 - Mar 2012

Data Technician Supervisor (2003 - 2005)

> Management analysis of large and diverse data sets within engineering

related to BOM, costing components, and master data.

. 100,000 SKUs

. Commercial, Retail, Long Term Care, Drapery

> Management of 2-3 employees responsible for data entry and

organization.

> Conducted yearly standard cost updates across entire system.

. Wrote statistical analysis reports from SAP/M3 using Excel for MU,

waste, fabric anomalies, and labor adjustments

Engineering Systems Manager / IT Liaison / Business Analyst (2005 -

2012)

> Corporate Business Analyst for computer system optimization and

implimentation via data extraction and migration efforts

> Ensure that internal customers are following the corporate business

model by working directly with the customers and influencing behaviors

through use of technology.

> Worked directly with upper management on data requests to define

structure and formats

> Analysis of data limitations and gaps within ERP system and

communicate to upper management and stakeholders of best practices

solutions

> Executed data mining projects to discover trends within the data and

put strategic plans in place to correct.

. Re-designed BOM setup process to capture needs lost at the

manufacturing plant level

. Fabric binding needs were not being captured in the cost structure

and would end up being charged back to the Engineering department

as MU loss. I was able to move the requirements back into cost and

also into the forecasting realm for visibility to the purchasing

department.

> I worked as data analyst and project manager dealing with engineering

systems conversions/migrations and integrations.

. Worked directly with internal customers for SDLC.

. Utilized Excel to extract data, cleanse, and manipulate before

migrating to corporate ERP system.

. Spearheaded data collection processes to recommend implementation

of new processes to stakeholders to give better visibility to raw

material needs and forecast demands

. Wrote "lock-down" report in Excel using VB to calculate where

there were going to be bottle necks at the manufacturing plants

and conducted meetings with the production planners and plant

managers weekly for course corrections. I achieved this via

macros, pivot tables/charts, and lookup tables.

. I extracted the drapery business and long term care facility design

business data from outdated computer quoting system and migrated to

legacy system via Excel and Access.

. Managed the SDLC throughout the project

. I worked independently to organize the needs of the project

using analytical methods key to the business requirements.

. Conducted weekly meetings with BU heads and stakeholders for

project progress and KPI updates

o I generated reports via Power Point, Access, and Excel for

management reviews

. Managed two data entry clerks and a plant engineer to facilitate

integration

. Programmed in Excel VB a quoting tool that enabled CSR's to

complete a quote over the phone with customers that took into

account all of the engineering formulas and legacy computer cost

components to formulate a quote that could be emailed or faxed

to the customer.

o Developed complex VB code to generate industry standard

engineering formulas to calculate material requirements based

on input from CSRs for dimensional and design requirements

required by the customer

o Utilized pivot tables and charts to give summarized cost and

generate price to customer based on pricing standards

o Utilized lookup formulas to integrate multiple tables of data

to one database of information required to generate accurate

pivot tables

o Exported each quote to access database for tracking and

historical reference purposes as well as tracking performance

levels for each CSR.

o Cost, Price, GP, and quantity of quotes completed were

tracked so a dashboard report could be generated via Access

and delivered to upper management for performance reviews.

> I was corporate manufacturing lead contact for consultant group on an

ERP system conversion to SAP including the extraction and data

migration of all master data, production planning data, and purchasing

info records.

. Worked independently to organize the analytic needs of the

consultant team to translate business processes to IT specs

. Worked directly with IT Manager to ensure the migration and

integration of existing legacy data was successful.

. I achieved this via Excel and Access by extracting data from the

legacy M3 system, cleansing, and migrating to SAP.

. I was able to verify the data integrity by extracting the fresh

data from SAP to do a comparison for accuracy utilizing Excel

and Access.

. Coordinated field indentification from Excel to SAP within LSMW

for data migration execution

. Worked within the configuration modules of SAP to fine tune

configuration settings

. Wrote extraction reports from AS/400 SQL query tool to use as raw

data and manipulated in Excel before migration could take place.

. Put together manual for end users on SAP data entry requirements

and troubleshooting options

Documented the genesis of all setup configurations in SAP and why

the path was chosen

Education

CLayton state university - Morrow, GA

*Equivalent to Associates in Business Management, 2007 (Still in

process of pursuing BBA at night; Planned Graduation Date 2015)

Contact this candidate