Rudolfo A. Espinosa

**** **** **** **

Sarasota, FL 34243

941-***-****

acsjvv@r.postjobfree.com

acsjvv@r.postjobfree.com

Professional Summary

My career has spanned across several technological areas to include Data Warehouse / Business Intelligence (Data Modeling / Architecting) and Oracle Retail implementation / integration. In both of these major areas I have gathered business requirements and turned them into functional and technical specifications. I have also consulted on tool selection, planned projects from inception through test and integration, and conducted specialized user training.

As an Oracle Gold Level Partner, I have specialized in implementing and integrating Oracle Retail Sales Audit (ReSA), ReSA Financials, Oracle Retail Merchandising System (ORMS – MOM) Stock Ledger Financials, Oracle Retail Invoice Match (ReIM) Financials, Oracle Financials R12, MicroStrategy and Business Objects business intelligence (BI) software for the Retail and Healthcare industries.

Client List

KPMG (Tiffany & Co), Almacenes Siman (El Salvador), AXStores (Stockholm, Sweden), American Eagle Outfitters, Unicomer (El Salvador), Army and Air Force Exchange Service (AAFES), Forest2Market, Lockheed Martin, Well-Care – HMO, Arnotts Department Store (Ireland), Retek, Hugo Boss (Germany), Sainsbury’s (London), Accenture Asia Pacific, Williams-Sonoma, Toys ‘R’ Us, Winn-Dixie Stores, Inc., GAP Inc., Retek, Bed Bath and Beyond, Waldo’s $1 Mart (Tijuana, Mexico), Publix Grocery, JC Penney, HCA-HealthCare, The Cato Corporation, Syms Corp, J-Crew, El Palacio de Hierro (Mexico City), Brooks Brothers.

Author of D'ORDS: Dimensional Operational Reporting Data Store. Can be viewed at Information Management Direct or

http://www.information-management.com/infodirect/2009_125/business_intelligence_operational_data_store_dords_reporting_dimensional-10015534-1.html

Skills & Accomplishments

Data Warehouse Consulting / Business Intelligence Consulting –9.5 years

Designed a business intelligence models for reporting efforts

Conducted design sessions for both Logical and Physical Data Models (LDM / PDM)

Created the metadata document that corresponds with the logical model in preparation for the physical model design

Created the Data Dictionary Language (DDL) repository from the PDM

Used the Kimball and Inmon data modeling methodologies to create a hybrid solution based on business requirements

Created the physical model in a Star Schema design with Dimension and Fact tables

Created third normal form (3NF) model to satisfy client business requirements

Established LDM and PDM Data modeling version control

Designed and created the reports data model by hosting several business modeling sessions with the client business personnel

Created data mapping documents from the physical model to determine the structures of the MicroStrategy Project

Modified incumbent Business Objects Universe to accommodate the new fact tables and CRM dimension tables

Worked with disparate user communities to develop of their reporting cubes

Scoped the requirements of future data repositories

Validated audited sales data using reporting tools and custom SQL before loading into the Merchandising System and the DW

Conducted RDW Conference Room Pilot (CRP) to assist in the Scope and Planning of the reporting effort

Responsible for all data, ETL processes, and database issues in each of the RDW environments (Development, System Test, UAT and Production)

Developed an enterprise data warehouse (EDW) MicroStrategy Business Intelligence Reporting

Converted RDW 454 Calendar into Gregorian Calendar

Recreated RDW reports to use the Gregorian Calendar

Recommended improvements in the data warehouse database for MicroStrategy reporting

Business Intelligence Lead for multiple data modeling/business intelligence (BI) projects in a Health Care environment

Developed operational MicroStrategy reports from an RMS OLTP system to support an Operational Data Store (ODS)

Developed analytical MicroStrategy reports for Sales Audit, Store Operations, Inventory Analysis and Supplier Compliance from a Data Warehouse

Technical – 20 years

Designed the logical model in ErWin and reviewed with the stake holders

Defined and developed a physical data model structure to enhance the performance of data retrieval in a MicroStrategy reporting environment

Designed and created monthly aggregation tables for performance enhancements

Populated an operational data store (ODS) from Retek RMS transaction tables using standard ETL routines

Created the RDW database schema from 454 calendar to Gregorian calendar for MicroStrategy reports

Performed DBA activities in Microsoft SQL-Server environment for a back-office POS system

Created generic Sales Audit routines for POS data to determine deficiencies before loading into the Retek Merchandising System (RMS)

Redesigned the RMS replenishment module for a pull type store replenishment system

Designed a store order book replenishment application in a Rapid Application Development (RAD) environment

Created a new RMS schema for replenishment activities by integrating RMS On-Hand and RDM table structures to determine accurate stock levels after the ‘Pick List’ in the warehouse

Created warehouse stock depletion routines to enable suitable stock substitution for the stores

Developed DWH Change Data Capture routines to support the integration of an OLTP system

Created customized SQL scripts to convert GMT to local time with respect to daylight savings time by time zone

Managed a team of ETL developers who converted existing PL/SQL code into SAS code

Conducted and evaluated database and ETL code review sessions

Created an incremental release schedule to update the ODS/DWH with new data

Modified the existing warehouse to accommodate new data repositories

Created SQL code to populate the sales tables for legacy data by item, department, store, day with appropriate rules

Resolved missing season data not loaded into the RDW

Established procedures to reload reject records from the previous batch runs

Developed a metadata repository from MicroStrategy and Teradata databases

Developed the ETL process to populate the database of table and column information from Teradata and MicroStrategy

Performed Teradata database realignment during a MicroStrategy upgrade with a size just less than 3 TB

Technical Lead in Business Intelligence, Data Model/Data Architect in a MicroStrategy, SQL Server, and Teradata environment

Design, develop and test SQL code to load legacy history data into and base RDW tables

Business Process Modeling – 14 years

Conducted ‘Current State’ business process workshops to deliver process models for the ORMS / ReSA application

Conducted business process ‘Leading Practice’ design workshops to incorporate ORMS / ReSA application

Delivered ‘Future State’ business process designs through the culmination of Leading Practice and Current State definitions

Conducted data discovery and business process modeling sessions for the Oracle Retail ReSA application

Defined and presented process flows and mappings from Point of Sale (POS) through Sales Audit, Stock Ledger and ReIM into Oracle Financials R11 and/or client financial systems

Defined ReSA report process flows to assist in data validation between POS Sales data, complex ReSA Totals and to align with the Oracle Financials accounts receivables (AR)

Defined test scripts to ensure accuracy in the Sales Audit process from inception through downstream systems such as Oracle Financials R11 and the Data Warehouse

Defined controlled scenarios to test and validate sales into Oracle Financials R11

Modeled the AR/GL/AP processes from base Oracle Retail Merchandise Operations Management (MOM) to the client General Ledger Financials System

Modeled the process flows from ReSA to the Operational Reporting environment

Modeled the operational reports process and document the requirements

Evaluated client As-Is / To-Be processes to determine whether ReSA Sales Audit could function as a stand alone module

Created a Functional Requirements document for the integration effort between RMS/ReSA and the Legacy GL

Gathered reporting requirements to determine the gap between ‘out-of-the-box’ RDW / MicroStrategy reports and client needs

Created a CRP gap analysis of the integration effort avoid duplication of effort

Create functional and technical design documents to process differently formatted POS files into one RTLOG file for processing

Created a design solution to integrate the RMS general ledger with client mainframe general ledger

Modeled business rules of Non-Merchandise accounts mappings in the RMS/ReSA extracts

Created AS-Is and To-Be documents for a reporting solution

Lead the team in refining the Month End data loading activities

Conducted meetings to develop and integrate additional data into the current warehouse

Business Process mapping to convert an ‘As-Is’ – ‘As-Was’ data warehouse to a total ‘As-Is’ environment

Performed a gap analysis between the EDW data model and the business reporting model

Sourced legacy data to meet business reporting requirements

Conducted business data mapping exercises

Implementation and Integration – 15 years

Integrate base Oracle Retail Sales Audit (ReSA) application, client custom modifications and mapped ReSA Financials Sales Accounts into Oracle Financials R11 (Spanish Language)

Integrated Oracle Retail Financials modules – ReSA, Stock Ledger, Invoice Match into client General Ledger (GL)

Mapped ReSA Sales Totals to the ORMS General Ledger and the Data Warehouse for reporting

Mapped Oracle POS data to Sales Audit repository for ReSA processing

Implemented Business Intelligence solution (Reporting)

Integrated client reporting cubes

Implemented and integrated Sales Audit, Store Operations, Inventory Analysis and Supplier Compliance reports in MicroStrategy

Implement an enterprise data warehouse (EDW) for MicroStrategy Business Reporting for major retail and grocery chains

Implemented a Customer Relationship Management (CRM) reporting database using batch ETL processes

Implemented an Intra-Day ETL process for marketing and to maintain customer profiles

Evaluated and implemented the Change Data Capture routines to preserve data integrity

Implemented an incremental release schedule to update the Operational Data Store (ODS)

Identify the requirements of future data repositories

Develop and integrate new data into the current data warehouse

Integrated modified view of the data warehouse to accommodate new data repositories

Managed the implementation and integration of an RDF module with the RDW environment

Ensure the RDF modifications are in line with other ORMS mods

Implemented a phased integration approach to include a Direct-Ship business

Implemented and Integrated history data loads into existing DW schema

Project Management – 8 years

Created project plans and task list to support the retail reporting and financials data integration efforts

Identified the deliverables and milestones for each major section of the project with timelines to include

oTechnical architecture installation, and configuration

oBusiness reporting architecture

oResource allocation of technical, functional and management personnel

Conducted technical interviews to fill various positions on the data warehouse implementation / integration team

Created the design document for approval of the project and its resources

Assisted the Project Management Office (PMO) in the design, development, and implementation of an enterprise data warehouse (EDW)

Incorporated an incremental release schedule of updates to the ODS/DW into the existing project plan

Managed the on-shore and off-shore production support personnel for the RDW Batch

Produced work schedules and assigned tasks

Financials Consulting – 5 years

Provided upper management Directors with design solutions for end of month Inter-Company, In-Transit and WAC adjustments

During System Integration Testing (SIT) validated specific general ledger accounts such as Assets, Liabilities, Expenses and Revenue

Worked with the Financial department to identify and map the Chart of Accounts (COA) from Oracle Retail GL sales to Oracle Financials R11

Integrated Sales Audit (ReSA), Stock Ledger, Invoice Match (ReIM) and mapped each to the client general ledger financial system

Mapped and configured financial sales, inventory valuations, and Invoice Match accounts payable accounts from base Oracle Retail and the modified components to the client general ledger financial system

Created the source to target mapping document consisting of retail sales accounts for the Oracle Retail General Ledger

Provided business rules of service type accounts for use in the RMS/ReSA extracts

Established balancing criteria using T-Accounts for GL, AR and AP data from Oracle Retail MOM

Provided upper management with custom sales reports for the end of month soft and hard close and Weighted Average Cost (WAC) adjustments

Computer Experience

Oracle Retail MOM (ReSA, ReIM, Stock Ledger) RMS, RDW, Oracle Financials R11, R12, MicroStrategy, Crystal Reports, MS Project, AutoSys, Control-M, AppWorx, UNIX K-Shell scripting, Business Objects Crystal Decisions, Business Objects XI, Erwin, Microsoft SQL Server, Teradata database, Oracle database

Education and Certifications

Oracle University E-Business Suite – Oracle Financials R12.x GL, AR, AP,,,

November 2014

Oracle University Oracle 10g SQL and Database tuning ED 2

May 2008

Villanova University Certificate Program in the Essentials of Project Management

July 2003

MicroStrategy 7 Platinum Certified Developer Software Engineer (CDSE)

April 2001

Retek Retail Systems RMS 8.0 Technical and Functional Perspectives

November 1999

Oracle University Oracle Financials and Functional Foundation (R11)

October 1999 Oracle Applications Implementation Methodology (AIM) 3.0

MicroStrategy 5/6 Platinum Certified Developer Software Engineer (CDSE)

March 1998

B.S. Resource Management Troy State University-Europe

June 1984

A.A.S. Imagery Analysis Community College of the Air Force

February 1984

USAF - Veteran

Intelligence Security Analyst HQ Air Force Intelligence Agency (AFIA), Intelligence

June 1985 to October 1991 Reserve Detachment-4, Ft. Belvoir, VA

World Wide Military United States Air Force

Commitments TS-SCI EBI Performed in Jun 1984

July 1974 to June 1985

Contact this candidate