Randall Thorne

62 Parkview Dr

Rochester, New York 14625

Randall@RandallThorne.com

585-329-7681

Website: www.randallthorne.com


Objective:


Determined, Professional with broad background in Database Systems. I desire a technical/functional analyst position supporting existing systems. I am familiar with database technology both relational and OLAP. My technical experience includes Oracle, SAP, Hyperion Essbase, UNIX, Windows and all the MS Office products. I am familiar with data models including the star and star snowflake designs as well as more normalized ER designs. I have experience in requirements gathering, unit and system testing, quality review, data analysis and small development projects. I am willing to travel up to 100%, but I am not open to relocation. My education includes an MBA in Information Technology and Finance, University of Rochester Simon School and a BS in Electrical Engineering from RIT. I am Focused, Committed, Dependable and Honest.


RF Harris Communications

Progress Supporting DBA

May 2006 to present

Analyze, monitor, support. Track database size add table extents as needed. Migrate changes in database between the development and production servers. Sun Sparc system, Unix 5.8


Barloworld Industrial Distribution

SAP BW Analyst

January 2006 to May 2006

Analyzed current data warehouse usage and existing implementation, Gathered user requirements from Finance and District Management. Performed a fit gap analysis against existing implementation and created a new cube design. Worked on eliminating existing data discrepancies and created data element mapping between SAP ERP implantation.


Citizens Communications:

Essbase DBA/Developer:

April 2004 to Nov 2005

  1. Participated in the design and build out of the Financial Planning and Budget project. Completed the automation of the overall process for enabling end users to control the Budget Consolidation. Lead the build out and enhancement of the Management, Consolidation, Revenue, Capital and Expense cubes with additional accounts, key figures, dimensions and load rules. Validated/tested the results in a Unit and System test. Worked with end users to validate preproduction results and obtained client signoff for migration to the production environment. Database sizes were 40 to 60 gigabytes. Mitigated and controlled end user timing expectations as appropriate to maintain a standard data warehousing environment worthy of an Enterprise Production System.


  1. Implemented improved security environment by region and cost center. Moved security controls from employee based name objects to more generic region/cost center name based. This enabled easier security modifications.


  1. Environment: Oracle 8i, Essbase 6.57, Windows NT.





KODAK - Enterprise Resource Planning (SAP-BW): Rochester, NY SAP Developer:

Multiple "Mini Projects"

2002-2003

1.) Built, prototyped, unit and system tested data warehouse tables, reports and transform logic. Completed test documentation provided to the local review team (Phases and Gates). Training materials were created and provided to internal customers.


2.) Modified Cost Management Information System that allowed the Finance organization to better track film manufacturing costs.


3.)Wrote a common set of ABAP code for CRM application, which was leveraged across three


4.) Modified the Sales and Operations Planning (S&OP) application to allow carry-forward estimates to be created automatically, enabling future forecasts to be populated from previous forecasts (Visual Basic), this saved the world wide operations team one months estimating time.


  1. Installed Sales Related Data application. These was a standard SAP BW business installation and roll out, included modifications to user exits. Enhanced standard sales reporting analysis to allow better tracking of key business indicators.


5.) Enhanced customer master data loading process that resulted in minimizing the need for performing reloads of transactional data. Saved approximately $800,000 per year in reloads.


6.) Responsible for overseeing SAP software patch upgrades, including researching SAP OSS notes for possible issues/problems. System functionality was enhanced with each upgrade.

Environment: Oracle 8i, SAP 3.1i and SAP BW 4.6c, HP UNIX.


SAP Business Warehouse Production Support Projects: 2000-2002

1. First to deliver Global “Follow the Sun Support” program in which resources from Europe and Asia were utilized for off hours pager support. This practice, which was expanded to the overall ERP program greatly, improved the “quality of life” for on call people by reducing off-hour paging by 80%.


  1. Installed and modified multiple custom financial reporting solutions that required complex MS Excel work using Visual Basic. Each solution was designed to drive down cost, decrease Outstanding Sales (return monies sooner), and monitor financial performance metrics, such as Economic Profit...


3.) Provided production support (keep it running) including on call 24X7. Identified reasons for on call pages and took actions to determine root cause analysis to reduce pages. Resulted in higher quality of life for on call people.


SAP Business Warehouse:

1998-2000

1.) Original member of the team that designed and built a Global Data Warehouse for Eastman

Kodak. Enabled global financial and sales reporting.


  1. Gathered requirements and built Profit Margin and Accounts Receivables reporting systems. Participated actively in the monthly Financial Close as required by Wall Street and Kodak upper management.


  1. Environment: Oracle 7, SAP BW 3.0, HP UNIX



KODAK - Motion Picture and Television Imaging

Business/Systems Analyst:

1991-1997

1.) Supported and modified a US based Business Unit data warehouse built in Oracle. Contained information related to key contacts, purchasing customers and product sales information. Was used for tracking top product line sales and customers.


2.) Performed support and training at multiple Field Sales Offices.


3.)Provided technical training to field sales personnel and updated laptop computers with upgraded software.


Monroe Community College -Information Management

Adjunct Professor: 1996 1

Developed/taught MS Excel curriculum, administered exams, achieved a 90% student passing average.


KODAK Subsidiary - Ultra Technology, Newark, NY

Individual and Supervising Engineer:

1985-1990

1.) Managed a test laboratory, eight individuals and an $800,000 budget, as well as, individual engineering deliverables. Performed performance appraisals rankings and layoffs.


2.) Designed and built a testing environment that would become known as Data Warehousing. Used software with HP Basic and built data collection computer systems and test fixtures. Performed computer-controlled tests, summarized results and reported back to the product development and research community.


  1. Received U.S. Patent #4816735, for a new battery charging design.


Education:

MBA, University of Rochester, Simon School, Rochester NY

Finance and Information Systems, GPA: 3.3/4.0


BS, Rochester Institute of Technology, Rochester NY

Electrical Engineering, GPA: 3.1/4.0


Professional References:

Steve Maillie

Company: RF Harris

Title: IT Manager

Email: smaillie@harris.com


Etienne M. Geldenhuys

Company:Barloworld

Title: IT Manager

Phone 704-587-1003

Email: EGeldenhuys@handling.barloworld.com


Scott Delap

Citizens Communications

Title: Data Warehouse Manager

Phone 585-777-5197

Email: scott_delap@yahoo.com


Eric Hunt

Company: Kodak

Title: Global IT Director

Phone 585-724-2614


Additional Info:

Data Warehousing:

Extract, transform, cleanse, and load data from different information systems. Dimensional (star and snowflake) vs. ER modeling (OLAP vs. OLTP) Data staging, data marts, Operational Data Store (ODS)

SAP (4.6C,D, 3.1H,I):

SAP General:

Customer Relationship Management (CRM), Business Warehouse (BW First Customer Ship to 3.1C), Order to Cash (OTC), Profit Center Accounting (PCA), Finance and Controlling (FICO),

Master Data., Marm, Mara, kunnr, etc.

SAP BW: SAPBEX Analyzer (SAP Excel query and Reporting Tool); navigational/display attributes; Info Cubes, transfer/communication structures, info sources and data sources.

SAP Technical Knowledge: ABAP programming; function modules; user exits; data elements; data objects; change transport system; security roles and profiles; jobs and logical file definitions.

Recently completed refresher classes on Oracle DBA through 9i.

Oracle (6.0i-9.1i): General Programming: PL/SQL, stored procedures (internal tables, Cursors), triggers, SQL loader. Index/Key/query/schema/: Bitmap, B-tree, primary, secondary, foreign, query joins (inner, outer) correlated, hints, table Sizing, extensions, views.

Other: UNIX, VI editor, basic knowledge of C shell, Crontab scheduler., HTML, web pages, Excel, Word, PowerPoint, Access and Visual Basic for Applications version 6.0. TCP/IP and networking. Cognos, Power Play, Transformer, Hyperion.