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