Sales Data

TANYA JACKSON

Hendersonville, Tennessee ***** ۰-615-***-****

***********@***.***

OBJECTIVE

A corporate segment position employing my strong Financial Acumen and Management, Information Services, Project Scope Management, and Program Cost Benefit Analysis expertise to attain strategic goals of your organization.

QUALIFICATION SUMMARY

My diverse expertise has been with world-class financial services, computer, plastics, automotive, and aerospace organizations in Finance, Systems, Business Intelligence, Data Analytics, Logistics, and Inventory Control. Experience developed over wide segment of manufacturing, distribution and corporate roles that address all levels of project management and process improvements. My demonstrated abilities are in leadership, finance system implementations, customer interaction, new product development / launch, and operational systems. I am a results-oriented individual with strong interpersonal skills.

Specialized training in the following areas:

Oracle EBS R12 & BI Analytics

Oracle Hyperion Finance Management (HFM)

Business Process Improvements

Trillium Data Quality Software

MS Office –Excel/Access/PowerPoint

OBIEE / Tableau / SAP Financial Reporting

Manufacturing floor methodologies

Inventory/Manufacturing/Distribution systems

Salesforce & Logistic systems / EDI

Lawson / Platinum Financials / QuickBooks

AS400/Lotus/DBASE/SPC/SAP

Black Belt Certified

Erwin – Database Modeling Tool

JD Edwards ERP/Great Plains/Crystal Reports

EXPERIENCE

2016-Present Caterpillar Financial Planning, Nashville, Tennessee

Information Services – Sr. Data Quality Analyst (Consulting)

Develop a deep understanding of the business systems used within the organization, the nature and structure of the data collected, the flow of data between systems and methods and technologies used to expose the data for analysis

Data cleansing and data analysis for conversion from Info Lease to Oracle Lease Management EBS using Trillium Data Quality Software

Gathering and reviewing large amounts of data from all over the globe, looking for data anomalies

Analyze current data flow between the existing systems

Conduct Data Quality meetings with the Business Team to address the data cleansing and reporting needs for the Conversion into Oracle EBS using Tableau and Excel

Acts as a liaison between the Information Services Conversion Team representatives and the Business Team to ensure appropriate services

Assist with analysis of new technologies and services to understand the impact on the data analysis systems

Tanya Jackson Page 2

2009-2016 Griffin Technology, Nashville, Tennessee

Sr. Finance / Business Intelligence Analyst

Managing financial planning and sales analytics, using Oracle BI and Salesforce

Develop category and merchandising presentations for line reviews

Analyzing historical sales, cost, and profit for cost reduction and ROI improvements

Identify key sales and category trends, while also using NPD Data to integrate an understanding of the marketplace results

Track vendor sell through data, discounts, and promotions

Develop sales/demand Forecast and Variance reports

Build and update Business Intelligence (BI) sales data reports, processes, and systems for cross-functional departments using Oracle, Salesforce, and JDE Enterprise One

6+ years as Oracle 10g/11g BI Administrator, trainer, write basic SQL code for functions

JD Edwards, Agile, and Salesforce software champion in integrating systems with Oracle

2008-2009 Healthways, CoolSprings, Tennessee

Financial Systems Analyst (Consulting)

Project Lead on SAP Financial system implementation and integration with Hyperion Financial Management

Generated financial analysis, forecast & budgets, healthcare pricing, and network contracts

Performed financial impact analysis, risk management, and data manipulation

Train Financial Analyst on using Hyperion Financial Management system

2006-2008 United Technologies Corporation - Carrier Sales & Distribution, Nashville, Tennessee

Financial Planning & Analysis Manager

Managed financial planning & sales analysis for the Mid-South Region of Carrier Heating and Air Conditioning, a Business Unit of United Technologies Corporation

Developed Sales, P&L, BS forecast & budgets, and Variance reports using Oracle HFM

Interfaced with Directors, Marketing Managers, and Sales Managers to provide sales data and analysis, as well as prepare Quarterly Sales Incentive Bonuses

Analyzed historical sales, cost, and profit for cost reduction opportunities, and to determine forecast and calendarization strategies

Prepared FY Financial Review, and assist with Month End Close process

2002-2006 Dell Computer Corporation, Nashville, Tennessee

Sr. Finance - Site Controller

Disseminated financial reporting of the East Coast Merge Operations and Dell Americas Manufacturing Operations for Dimension products

Developed Operating expense forecast & budgets, Capital expense planning, Business Case development, target setting, and key metrics tracking from Oracle Application systems (now known as Oracle E Business Suite 11i)

Generated Full Product Costing on all OEM products in support of Sales, and PG teams

Implemented Month End Close process and reporting

Project Lead on transition / implementation of Hyperion Enterprise to Hyperion Financial Management system

Championed Logistics Finance Automated Web Based Cost Allocation system – Black Belt project

Tanya Jackson Page 3

2001-2002 Clopay Plastic Products Company, Nashville, Tennessee

Sr. Cost Accountant

Implemented Shop floor/Job Order automation system for production data

Developed Annual Operating budgets, and Variance Analysis reports

Interfaced with Engineering and Operations regarding process flow and cost allocations

Financial Steward for product costing in support of Sales team, set up standard cost, valuation of inventory, classification of Labor, Material and Overhead cost

Performed General Ledger Audits during close cycle

2000-2001 Hoeganaes Manufacturing GKN Corporation, Gallatin, Tennessee

Sr. Financial Analyst - (Consulting)

Prepared Business Unit financial forecast and results for Corporate

Reviewed compliance of Internal Controls

Prepared Annual Audit packages for Independent Auditors

Conducted risk assessments of organizational processes

Developed cost estimates, transactional and monthly closing reports

Supported transition of Financial system from HP3000 to BPCS

1997-1999 American President Lines (Business Logistics Services), Scottsville, Kentucky

Business Logistics Analyst

Championed Dollar General Corporate Account

Managed Dollar General’s Anera Contract for all Steamship Lines - Onsite

Implemented APL’s new EDI Access Database (Equipment Tracking Logistics System)

Led Dollar General’s Container Management System

Served as liaison for Dollar General’s buyers, distribution centers, and third party clients, such as brokers, trucking and rail companies

Responsible for financial data and reports for all Import Shipments

1992-1996 Ingersoll-Rand Company, White House, Tennessee

Supervisor of Government Contract Administration

Managed the Government Dept. of Defense (DOD) and GSA Contracts

Interpreted manufacturing DFAR contract terms and conditions

Developed financial pricing data and complete Proposal Packages to Government

Implemented EDI system for use in RFP development and bidding

1987-1992 McDonnell Douglas Aerospace Company (Boeing Corp), Mesa, Arizona

Sr. Pricing Analyst

Prepared financial Government Contract Proposals for DOD

Managed Commercial and International Proposals

Performed proposal audits, interpreted Engineering drawings, and Statement of Works

Negotiated contracts with DOD at Rock Island, IL (U.S. Army Corps of Engineers)

EDUCATION

Bachelor of Science Degree, Business Administration, Arizona State University, Tempe, Arizona

MEMBERSHIPS AND CIVIC ACTIVITIES

American Society of Financial Accountants Junior Achievement: Tutorials in Math/Science

OBIEE Professionals Group Toastmaster

Page 4 - TANYA JACKSON 615-***-****

TECHNICAL SKILLS:

OBIEE 10G & 11G Applications

Oracle BI Admin Tools

Oracle Analytics

Oracle Dashboards and Answers Reports

Oracle Applications 11i/R12 (E-Business Suites 11i/R12)

Oracle BI Publisher reports

Oracle Hyperion Financial Management HFM (includes Financial Lease Management)

Oracle DBA

Tableau 10.1

Trillium Software - Data Quality

Hyperion Enterprise & Essbase

JD Edwards

SAP

Great Plains

Lawson

AS400

DBASE

Visio

Crystal Reports

Erwin- Database Modeling System

Data Mining

Salesforce CRM

Agile

ORACLE PROFESSIONAL EXPERIENCE:

Responsible for the day-to-day operation and maintenance, and training of the company's Oracle Business Intelligence information technology systems. Worked with Developer and Sys Admin for installation and upgrades.

Manage security and access of the OBIEE Dashboard Report environment by using and assigning users/groups.

Collaborate with Software Developer to create and maintain production repository: objects (including but not limited to: fact tables, dimensions and hierarchical structures with appropriate logical and physical joins) using Oracle BI Administration Tool

Collaborate with Developer to create ETL maps and process flows using Oracle Warehouse Builder 10g/11g for data movement and manipulation of data into data warehouse from JD Edwards ERP-(Accounting, Sales, & Product Management), Salesforce, and Agile

Create User Interface (UI) Financial Reports for decision making such as dashboards, Pivot Tables, graphs, gauges, Scorecards, and iBOT’s - (automated delivery of various Reports to end user) using Oracle BI Answers.

Monitored trouble ticketing system, JIRA, for Griffin’s IT Support Team troubleshooting for problem resolution for any Oracle BI (OBIEE) Reports, Dashboards, and iBOT related issues

Perform Data validity and integrity checking, and correct issues by reviewing Oracle BI (OBIEE) code errors

Develop data requirements/specifications through technical meeting with IT staff and end-users

Project Lead on Oracle BI (OBIEE) upgrade from 10g to 11g

Ensured quality and performance of developed application by working with software developers to implement acceptance testing and modification required for production releases

Manage requirements for importing and exporting hundreds of third party EDI files and Manual data into Oracle to create Reports

Write SQL code for various functions in Oracle, such as Expressions - Case Statements, Conversions - Value Of, Aggregations – Rank & Top etc., Calendar/Date using repository variables – Current Month, Last Month, etc., Math – Round & ABS, etc. to create various Reports, Dashboards, etc. for all functional depts.

Develop Sales, P&L, BS and Operating Expense forecast & budgets, and Capital Expense planning using Oracle Hyperion Financial Management

Project Lead on Hyperion Enterprise upgrade to Hyperion Financial Management

Oracle R12 Experience - Set up and convert Accounting & Financial System with New Users, Employees, Items, and Categories, Create Purchase Requisitions - (iProcurement), Purchase Orders, Sales Orders – (Order Management), Invoices – Enter, Pay, Match to P.O., and generate in Receivables, Define Ledgers, Chart of Accounts – Set up Key Flexfields – Companies, Depts., Accounts, and Products. Set up and use Calendar Types, Currencies, Inventory, and Depreciation. Create and set up Journal Entries (JE’s), Product Costing, Expenditures, forecast and budgets, Contacts, and Reporting

Contact this candidate