Summary

Possess competencies addressing complex projects with focus on data analytics in Information Technology and Business Intelligence (BI). Strength in health care services, technology, telecom and pharmaceutical industries. Tactically deliver results with full accountability. Lead in fluid, risky, and rapidly-evolving environments. Streamline processes and clarify results. Expertise in converting business requirements to technical specifications. Promoter of precise, trusted, and smarter data.

Skills Overview

Perspecta Project History (May 2016 - December 2018)

Health Net Federal Services/Centene
May 2016 - December 2018

Assumed leadership over the implementation and sustainment of a multi-million-dollar contract with Health Net Federal Services/Centene. Led business and technical teams during implementation of system, including new hardware, software and infrastructure to meet strict government deadlines. Acted as resource manager responsible for managing the allocation of resource for all current and upcoming projects. Ensure project resourcing is managed in order to assume timely delivery. Specialized in communicating to appropriate project manager any resource issues that may impact deadlines. Served in following capacities:

• Manage resource forecasting spreadsheets for all contracts/projects based on input from weekly meetings and the production team.
• Met with stakeholders to make communication easy and transparent regarding project issues and decisions on services.
• Produced accurate and timely reporting of program status throughout all contracts and their life cycles.
• Authored and managed contacting artifacts which lead to the awarding of add on work.
• Collaboratively worked with client and team to resolve real world situations by providing technical solutions.
• Developed SharePoint workflows to improve business processes and productivity.
• Installed, administered and maintained enterprise-level SAS solution.
• Drove to develop and implement solutions that exceed contractual requirements.

Technologies: Teradata, SAS, SharePoint 2013, 2016, SAS

Claraview Project History (November 2010 - March 2016)

Led business and technical teams. Delivered both strategic and tactical solutions, and solved real world situations. Provided strategic direction incorporating new, appropriate product lines. Managed data migrations that required complex architecture changes. Served in following capacities:

• Accelerated assigned project task timelines after deliverable dates were threatened by other outside forces resulting in on-time delivery of project deliverables and exceeding customer expectations.
• Delivered over 130K data-profile metrics from 18 disparate information systems, allowing for decisions on how to proceed with source data (such as choosing systems that need least amount of attention.)
• Provided ETL tool selection project leadership for systems requiring near-live data feeds, ensuring best tool selection for current technical and business environment.
• Led requirement-gathering sessions with over 20 business organizations, documenting requirements, permitting comprehensive BI roadmaps, and exceeding customer expectations.
• Mentored ETL developers on reading Informatica repository data, capturing accurate process metadata, precipitating in more precise and timely reporting of ETL processes information.
• Created report specification adopted by Claraview as standard for future engagements, guaranteeing more comprehensive, standardized, and complete documentation for Claraview developers and clients.
• Documented installation accurately and used documentation for Teradata decision experts, exceeding strict military standards and fulfilling contractual agreements.
• Ran and managed 4 offshore Philippine resources while ensuring reporting specifications and client standards were properly utilized, having the effect of high quality, fully tested, and documented reports.
• Setup and administered SUSE Linux Teradata appliance, the sanctioning on-time migration and delivery of new ETL server with associated documentation.
• Designed Audit, Balance, and Control (ABC) data model, warranting success and integrity of ETL processes, culminating in expeditious reporting of possible data- load issues.

USDA - Food Safety and Inspection Service
October 2015 - January 2016

Project Overview: The USDA Food Safety and Inspection Service, or USDA FSIS, is a federal government agency that needed a Business Intelligence road map to utilize the Teradata appliance that they purchased several years ago. This engagement reviewed older USDA FSIS business requirements to ensure they were still valid, identifying any gaps or changes. It also included a comprehensive review of the Teradata appliance they purchased with current capabilities and options. Also requested was comprehensive review of all identified sources including data profiling. The result of this engagement produced a Business Intelligence road map with options. This road map would be used by USDA FSIS to implement a Business Intelligence solution that meet current business needs and address any areas that have been identified as issues or risks.

Note: This engagement required that all project personnel must complete and pass the Personal Identity Verification, or PIV, process. This process is akin to the DoD security process.

Role Description: Data Profiler/ETL Specialist

• Identified, organized and verified potential source systems.
• Documented business requirements that involve Data Integration, including the use incremental loads.
• Developed, analyzed and documented data profiling of identified in-scope source systems. This included the capture and documentation of over 136K data points from varied source database platforms.

Technologies: Sybase Adaptive Server Enterprise, Sybase Anywhere, Microsoft Access, SQL Server 2008/2012, XML

Time Warner Cable
September 2015 - October 2015

Project Overview: Time Warner Cable needed a price to migrate from its IBM/Netezza TwinFin to a Teradata appliance. This migration included the replication of databases and their respective objects and the scripts used to populate and maintain these databases. An assessment was required to examine the Netezza database system to determine the amount of effort required. This enabled the client to properly plan their tactical move from the aging Netezza system.

Role Description: Netezza System Architect

• Analyzed current Netezza database catalog to determine the number of database objects defined.
• Analyzed current space allocated and used to ensure proper sizing.

After the successful completion of the assessment, the Teradata team required additional assistance with the conversion of Netezza scripts to Teradata. All references to Netezza were replaced with appropriate Teradata scripts, commands and tools. This included the introduction of BTEQ and TPT into existing Time Warner Cable scripts.

Role Description: Developer

• Reviewed and converted Linux scripts to remove references to Netezza and add the user of Teradata tools and utilities like BTEQ and TPT.

BevMo!
August 2015 - October 2015

Project Overview: Teradata needed a Linux system administrator to migrate scripts, data and user accounts from an existing ETL server to a new ETL server.

Role Description: Linux SUSE System Administrator

• Copied user accounts and directories to new ETL server while maintaining existing file/directory attributes for historical purposes.
• Replicated all user and group settings on new ETL server. This included passwords and cron settings.

Hertz Car Rental
January 2015 - August 2015

Project Overview: Hertz Car Rental's Treasury team issues asset-backed securities based on the vehicle in its' fleet. To comply with regulations, the value of the vehicles had to be maintained on a daily basis to ensure accurate and verifiable data. By maintaining the accurate valuation of its fleet, Hertz is able to maintain the integrity of their bonds to its investors and regulators. Assistance was needed to provide additional help with day to day operations and to assist with reporting needs.

Role Description: Solution Architect/Data Analyst

• Performed daily reconciliation of vehicle fleet activities to ensure accurate vehicle inventory levels were maintained.
• Developed new Cognos package to provide dimensional data for adhoc reporting needs.
• Developed new reports and maintained existing reports to meet changing needs.
• Developed new dimensional model to providing analytical reporting treasury team requirements.
• Reconciled on a weekly basis the titleholder information as it was persisted in the numerous operational systems.

Technologies: IBM Cognos Report Studio 10.2.1/Framework Manager, Teradata SQL Assistant

Ventura Foods, LLC
July 2014 - December 2014

Project Overview: Ventura Foods required a new reporting environment to support their edible oil trading efforts. Current reporting environment did not satisfy business requirements which included single source of truth and update frequency. A new environment was needed to better respond to oil trading needs and to treat the resource as a commodity.

Role Description: Solution Architect

• Supervised the implementation of Embarcadero Design Studio in Ventura Foods' environment.
• Designed and implemented SharePoint templates to facilitate new documentation standards.
• Captured and documented Ventura Foods' legacy source system metadata from DB2 catalogs and created SharePoint pages using SharePoint 2010.
• Designed, developed and implemented audit capture system to gather Informatica repository information. This information would later be used to analyze Informatica runtime statistics and to highlight anomalies. This was done to meet Ventura Foods' requirement to persist this metadata outside of the Informatica repository. This audit capture system also required the need to add six standard fields to all new tables that capture ETL metadata. This was done through Embarcadero Designer's domain system.
• Designed and implemented new DB2 database objects to facilitate data warehouse requirements. By using Embarcadero Designer, these new tables were maintained in the tool, allowing the tool to generate necessary DDL. This DDL was then reviewed for completeness and submitted to DBAs for execution.
• After completing the first version of development, I was asked to remain with Ventura Foods as their IT solution architect after the sudden loss of their solution architect. I remained with Ventura Foods as their solution architect until a suitable permanent replacement was identified.

Technologies: DB2 (iSeries/AIX), Informatica 9.5.1, Embarcadero Studio Designer, SharePoint

Safeway
June 2014 - July 2014

Project Overview: Safeway required the development of some complex queries that were required by the data consumers. These queries would contain preset selection criteria, joins and all the necessary fields needed to return data elements that were required.

Role Description: Query Developer

• Developed complex queries utilizing Common Table Expressions (CTEs) and three views. Queries were tested in Safeway's development environment. Also provided support as SQL and views were promoted to production.

Technologies: Teradata SQL

Frontier Communications
March 2014

Project Overview: Teradata/Claraview and Frontier Communications' were about to enter into an agreement to allow Teradata and Claraview to provide resources and consulting expertise to Frontier Communications. In order to accurately define the scope of work needed to address Frontiers' request, an assessment was required. The goal of this assessment was to gain a better understanding of the scope of work needed and the solutions required to meet Frontier Communications' requirements.

Role Description: ETL Architect

• Performed in-depth analysis Frontier Communication's current ETL environment. Documented a complete inventory of required source systems with types of input needed. After learning of Frontier's need to include Chance Data Capture (CDC), a solution was designed and documented that included the use of Informatica. The solution incorporated Frontier's current concerns and issues (i.e. loss of source files, database journals becoming not available, et al.) along with their strategic direction.

Technologies: Informatica

Mercury Insurance Group
January 2014 - February 2014

Project Overview: Provide short term support to BI team to assist with backlog of issues.

Role Description: ETL Architect

• Design, develop and implement a Data Audit System. This system defined test cases that must be executed from an Informatica session. Test results are captured and made available for analysis. This system is used to verify successful ETL loads by providing data that may indicate a possible failure.
• Review MicroStrategy reports that execute greater than five minutes. Provided suggestions on how to improve report execution. This included changes to string handling in dimensions, creating aggregate fact tables and removing redundant steps.
• Performed in-depth analysis of EDW dimensional model. The purpose of the analysis was to identify design issues that involve both BI Best Practices and to better utilize Netezza-specific architecture.

Technologies: Netezza 6.0, MicroStrategy, Aginity, DB Visualizer, ER/Studio

T-Mobile
December 2012 - September 2013

Project Overview: Provide services as functional analyst.

• Document business requirements (BI RRDs). This included face-to-face interviews with business users to gather and document their requirements.
• Represent business users during interactions with technical teams. This was to ensure that all of the prioritized user requirements were addressed fully with clear understanding.
• Documented current processes used to report subscriber numbers. This included interviewing business and technical individuals and documenting SQL Server scripts used to perform ETL on subscriber records.

In addition to the functional analyst role, also assisted with a sales pursuit with T-Mobile when T-Mobile issued a Request for Proposal (RFP) for a metadata solution. My involvement with this effort ensured that Teradata understood T-Mobile request and provide T-Mobile with a solution that met T-Mobile's needs.

Suggested, coordinated and assisted with organizing of an off-site Teradata/Claraview planning meeting to develop and prioritize a strategic plan to address T-Mobile's tactical and strategic needs. The meeting's focus was to take the observations and suggestions of Teradata/Claraview resources at T-Mobile and to build a plan with tangible solutions and product offerings. This resulted in a clear and concise plan for Teradata and Claraview to target current and future T-Mobile needs.

Technologies: Business Objects, SQL Server

CareSource
August 2012 - November 2012

Project Overview: CareSource utilized the SAS statistical application to perform ETL-like processing and OLAP reporting. CareSource relied on local resources to develop and maintain the SAS system. The departure of those SAS resources has crippled CareSource's ability to maintain the system. CareSource developed a plan to remove their reliance on SAS. This included the procurement of Teradata hardware and the incorporation of BI best practices. CareSource wished to retire their SAS system by migrating their BI solution to Teradata. This included sourcing data from Facets and CareAdvance along with various other smaller source systems.

Role Description: Business Analyst

• Identify, review and capture information about the SAS environment and the source systems that populate the source system.
• Meet with CareSource personnel to document current architecture and to understand the current challenges.
• All findings were documented and used as input to determine the scope and priority of the project's subject areas.

Wind Mobile
February 2012 - August 2012

Project Overview: Wind Mobile uses five systems to support current operational reporting needs. These five systems would be integrated into a single data warehouse integration layer to provide analytical reporting.

Role Description: Reporting Lead

• Lead and manage the reporting (OLAP) team to meet requirements outlined in the SOW.

Technologies: MicroStrategy, Teradata

Groupon
January 2012 - February 2012

Project Overview: After purchasing a Teradata appliance, Groupon required a migration from their Vertica cloud solution to Teradata to increase performance and lower costs.

Role Description: Business Analyst

After reviewing the Groupon production environment, had to determine the scope of the effort to migrate all LINUX load scripts and other YML files. Scope documentation was integrated into work package to determine the actual cost to execute the project. Also began the establishment of the ADC (Manila) processes to use when the project began.

Technologies: Teradata

United States Air Force
September 2011 - December 2011

Project Overview: Implement Teradata Decision Experts (TDE) for USAF inventory control

Role Description: Installer/Documentation

Documentation allowed for military installers to perform TDE deployment with no assistance from Teradata.

Technologies: Teradata

Beam Global, Inc.
November 2010 - June 2011

Project Overview: Beam Inc owns and produces Jim Beam Bourbon whiskey along with a wide variety of other liqueurs and spirits. Beam Inc utilized Essbase version 7.11 (no longer supported by Oracle) to maintain operational data. Beam Inc also received and analyzed Aperity data to determine store shelf inventory levels over time. Beam Inc could not overcome the challenges of integrating disparate source systems to perform accurate reporting and analysis.

The purchase of additional brands (i.e. Skinnygirl Cocktails) presented Beam Inc with additional challenges. The Beam Inc. leadership requirement to receive immediate accurate feedback on the status of a new brand or product could not be met by the current reporting environment. Incorrect information was routinely delivered to Beam Inc leadership, highlighting Beam Inc.'s inability to integrate and focus on new brands.

Role Description: ETL lead, Architect, Report Specification Writer

• The Claraview team was able to successfully integrate the disparate source systems into a new EDW system. The new OLAP reports were proven to provide correct, verifiable data elements that garnered the faith and respect of Beam Inc management. A standardized hierarchy system was developed to accurately merge the source systems to provide a single source of truth.
• Processes were developed and documented to facilitate and identify new brands and products. Beam Inc's EDW was enabled to report and analyze new brands and projects quickly and effectively. This allowed Beam Inc to tweak and adjust marketing plans and projections accordingly.

Technologies: SQL Server 2008

EDS Project History (June 1988 - February 2010)

Developed scalable, quality-driven ETL solutions. Delivered technical and process metadata for data consumers. Led high-energy, interactive business requirement sessions. Provided leadership in OLAP tool selection. Protected EDS' position as leader in Decision Support Services.

• Introduced ground-breaking ideas and designs, capturing, maintaining, and delivering new, innovative applications in metadata management.
• Led technical teams during implementations of metadata management framework, leading in sale of additional EDS' services.
• Developed high quality, fault-tolerant, ETL SQL scripts used in production cycles, resulting in fully-documented code that met client requirements.
• Facilitated requirement-gathering sessions with business users, bringing about precise, fully-realized requirements and attaining accurate roadmaps and quotes.
• Utilized data-modeling tools, defining enterprise-grade 3rd normal form and star schema designs, meeting client needs and requirements.
• Introduced leadership ideas and solutions as innovator of technology, resulting in EDS becoming recognized for BI advancements in metadata management.

Blue Shield of California
December 2009 - February 2010

Data modeling assignment for an existing claims processing data warehouse. Blue Shield of California purchased a new source system. This required the reengineering of an existing Operation Data Store (ODS) to integrate the new source.

Owens-Illinois
September 2009 - November 2009

With the purchase of three new virtual Solaris ETL servers, Owens-Illinois required the installation of IBM's InfoSphere 8.1 software package.

TennCare
August 2009 - September 2009

Acted as Business Lead during an Business Intelligence assessment. Participated and lead interviews with over 42 TennCare and EDS employees to determine the current state of TennCare's Business Intelligence environment. Also collected BI requirements and determined if the current TennCare Business Intelligence environment is meeting those requirements. Documented all findings with a road map and high-level project plan to bring TennCare's Business Intelligence environment in line with their requirements.

Service Alberta
April 2007 - March 2009

Worked as an ETL lead on the Service Alberta account. The vehicle registration and licensing source system was stored in a Adabas system. The ETL development team uses Informatica PowerCenter and PowerExchange to perform ETL activities. The account is located in Edmonton, Alberta and required extensive international travel.

Service Alberta
February 2007 - April 2007

While assigned to work in Edmonton, Alberta, Canada, the government agency, known as Service Alberta, requested an assessment to determine if a data Warehouse solution would address their reporting needs. After performing an analysis of their requirements, it was determined that a data warehouse would indeed address their requirements for reporting on the motor vehicle (MOVES) system. The resulting report lead to the sale of a data warehousing implementation sale.

Sara Lee
June 2006 - January 2007

Worked as a project lead on a data warehouse solution at Sara Lee in Downer's Grove, IL. The resulting data warehouse allowed Sara Lee to monitor the effectiveness of third-party carriers and truckers in the United States. Responsible for an ETL team and a reporting team. Also in charge of managing the Sara Lee management team. The source system was Oracle and the ETL tool used was IBM DataStage.

Kable News Company
April 2005 - June 2006

Worked as an ETL lead on the Kable News Company data warehouse. Was responsible for interfacing with the client and the collection of business rules concerning the subscribers. These rules were then translated into ETL specifications for a team of three ETL developers. This engagement was located in Mount Morris, IL and required extensive travel. The source system was Adabas and the data warehouse used SQL Server 2005.

Safety-Kleen Systems, Inc.
January 2002 - December 2002

In charge of collecting, analyzing, and publishing of metadata for the Service Delivery portion of the project. During this time, a conduit was built to extract metadata from ERwin V4.0 XML to the Metatory Microsoft Access database. This was accomplished by using Microsoft Visual Basic V6.0.

Eagle Global Logistics
January 2001 - December 2001

Lead a project to implement new EDI rules into an existing system.

National Health Insurance Company
January 1999 - December 2000

ETL developer for a new operational system.

Wellmark Blue Cross Blue Shield
May 1998 - December 1998

Designed, developed, delivered and supported a metadata management application called Metatory. Metatory was a full-featured desktop application capable of importing metadata from various sources including Excel, CA Erwin, and CoolGen. It was also capable of exporting metadata to Business Object universes and static HTML websites.

Johnson & Johnson Health Care Systems
March 1997 - April 1998

JJHCS needed a data warehouse for Johnson & Johnson sales and marketing teams that would calculate the number of J&J products that are consumed by health providers. This data warehouse would compare that value with the actual number of products used. This would provide a ratio of Johnson & Johnson's market share at a provider level.

As a part of this new JJHCS service to its clients, JJHCS needed to determine the best OLAP tool to deploy that would meet the project's requirements. I reviewed project requirements and criteria, interviewed end users and JJHCS resources, performed evaluations of OLAP tools and researched current 3rd-party reviews. I met this task's requirement by providing our OLAP recommendation.

Pharmaceutical Industry Group (EDS Internal)
1994 - 1996

Acted as technical lead on project. Designed, constructed and implemented a Lipid/Diabetes Registry Application using Microsoft Access V2.0. This client-server application is used by Bristol Meyers-Squibb in the Great Lakes Region. It is used to track cardio-vascular patients through their treatment during a Phase IV trial. The database stores patient data, such as dietary, smoking and treatment data. Several other support applications were also developed to support the Lipid/Diabetes Registry. This included an Export and Import Process as well as a Compact and Repair Utility.

Program Products (EDS Internal)
June 1992 - June 1993

Upon completion of the CHAMP V5.0 rewrite, Rodney joined the Team EPIC project. Rodney designed, constructed, tested , and implemented modifications to the Legent's ENDEVOR product that allowed the Team EPIC pilot program to continue. Without this activity, the project would have suffered a major delay.

Program Products (EDS Internal)
June 1991 - June 1992

While remaining with the Program Products, Rodney assumed the role of Team Leader over the CHAMP product. During this time, he supervised a major restructuring of the product which included a complete rewrite of the VSAM I/O subsystem utilizing MVS control blocks using Assembler.

Program Products (EDS Internal)
August 1989 - June 1991

After graduating from the EDS SED Phase II training, Rodney joined the EPIC project as an SED Phase III. During his stay with the EPIC group, he served as the team's expert on the Application Development Workstation (IEW and ADW). He had the responsibility for the integrity of the data model and for the design of an interface between ADW and BookMaster (documentation software). He also served as the liaison between the Plano and Denver SE Center teams. During his tenure here, Rodney became an SE by graduating from the SED program.

Advanced Technology Planning Division (EDS Internal)
June 1988 - June 1989

While with this group, Rodney played a strong role in the gathering and analysis of responses to an IPSD (Information Processing Services Division) Customer Satisfaction Survey in addition to supporting numerous other projects. Rodney also developed his own MS-DOS menuing system and prototyped various Mandelbrot set equations to generate graphical representation of fractals.

Education

M.B.A. General Business
Amberton University - Garland, TX (2004)

B.S. Statistics
California State University - Hayward, CA (1988)

Military

From 1981 to 1985, Rodney trained and worked as a missile analyst technician on the AGM-69A (SRAM) on B-52Gs. During this time, he received the Good Conduct Medal and Commendation Medal for outstanding work. Rodney was assigned to the 42nd Bomb Wing at Loring AFB, Maine. Rodney was honorably discharged from active duty in August 1985 with a rank of E-4. This career field required that Rodney hold a Top Secret clearance from the military.

Security Clearance

Top Secret Clearance from DoD on October 1981
Secret Clearance from DoD on October 2011
Personal Identity Verification (PIV) on October 2015

Training and Certifications

EDS' System Engineer Development Program - 1989
MicroStrategy Certified Project Designer - 2010
Teradata 12 Certification - 2012
Microsoft SQL Server 2012 MTA - 2014
Installation of Hadoop - 3/22/2016
Apache Hadoop - 3/23/2016