Oscar Roth Mobile Phone: 914-***-****

E-Mail: acbytp@r.postjobfree.com

Summary

• Extensive IT experience applying database technologies to deliver data that business leaders

require to make informed decisions

• ETL expert with more than 8 years’ experience

• Expertise in database design, data warehousing, data marts, database applications, database

tuning, data integration, data modeling, and customer data integration

• Experience successfully implementing ETL products from Business Objects, Cognos, and

DataMirror through a combination of project management, hands-on project work, and training

• Project experience with customers in health care services, financial services, manufacturing,

pharmaceuticals, and marketing

• Track record of leveraging general management, strategic planning, problem solving, and

technical expertise to optimize performance for diverse organizations

• Experience driving positive change and delivering cost-effective business solutions

• Experience in leading technical teams and mentoring

Technical Skills Summary – Hours of Experience

Business Objects

Enterprise Web Intelligence

Desktop Intelligence Dashboard Builder

Universe Designer Voyager

Crystal Reports Crystal Xcelsius

Data Integrator 9000 Rapid Marts

Data Federator Data Quality

Data Insight Metadata Management

Data Warehousing & Business Intelligence

Project Management 10,000 Business Requirements 4000

Source System Analysis 6000 Dimensional Modeling 8000

Data Integration (ETL) 16,000 Enterprise Application

Integration (EAI)

Report Development 4000 Training 2000

Languages

SQL 30,000 Java

.NET Oracle PL/SQL 20,000

Microsoft T-SQL 8000 Python

Operating Systems

Windows 24,000 UNIX 16,000

Databases

Oracle 30,000 Microsoft SQL Server 14,000

Professional Experience

First Energy Senior Data Migration Consultant, April 2011 - Present

• Multiple Projects

•

•

o Information Architect in the Enterprise Architecture team. Developing the Enterprise Data

Model and assisting in various information initiatives.

o Upgrade SAP Data Services to version 4.0

o Installed SAP Data Services XI3.2 both Server and Clients.

o Attached repositories to multiple jobs in order to achieve redundancy.

o Created Server/Groups to achieve load balancing.

o Utilized multiple central repositories for version control and codes movement between

environments.

o Designed data migration from legacy systems to SAP.

o Data migration of SAP CRM to SAP CRM in order to cleanse names and addresses.

o Cleansed names and addresses using Data Services transformations.

o Removed duplicate data based upon business rules.

o Designed Data Services jobs that extracted legacy data.

o Tunes Data Services jobs to achieve maximum efficiency.

o Profiled data by using Data Services data profiling functionality.

o Mentored client staff using SAP best practices..

Major Financial Services Firm, New York, NY January 2011 – March 2011

• Project: Design Multiple Data Marts sourced from Enterprise Data

Warehouse.

•

o Designed logical and physical models for Data Marts.

o Gathered business requirements to support data marts.

o Designed ETL processes to load data into data marts form Enterprise Data Warehouse.

o Tuned ETL processes and SQL code to perform efficiently.

o Scheduled jobs that populated data marts.

o Provide documentation to support all processes.

o Analyzed data compatibility.

•

Alberta Treasury Branches, Edmonton Alberta, Canada August 2010- December 2010

• Project: Data warehouse project extracting SAP data to source Enterprise Data Warehouse.

•

o Convert Infomatica ETL jobs to Business Objects Data Services jobs.

o Tasks included performance analysis/tuning and documentation.

o Create development, QA, and production repositories.

o Establish central repository to store jobs and enforce version control.

o Mentor staff on best practices in use of Data Services.

Zions Bancorporation and Greenplum, Inc., Salt Lake City, Utah, March 2010 – July 2010

• Project: Data warehouse project involving Greenplum technology, Business Objects Data

Integrator 11.5, and Business Objects Data Services 3.0. Greenplum, Inc., has developed the

Greenplum database system, which is based on PostgreSQL server and Sun boxes to work with

large, multi-terabyte data warehouses.

o As the Project/Technical Lead, converted Oracle-based Business Objects Data Integrator

11.5 jobs into Greenplum-compatible jobs

o Tasks included design, development, implementation, performance analysis/tuning, and

documentation

o Converted database functions in Oracle to Greenplum/PostgreSQL

o Created YAML-formatted files for flat file bulk loading into Greenplum’s environment

o Worked with GPLOAD to bulk load the files into Greenplum’s environment

o Converted Business Objects Data Services 3.0 jobs from Oracle to Greenplum’s

technology

o Performed data quality activities, such as cleansing, matching, and consolidation, using

Business Objects Data Services

o Became familiar with Greenplum’s environment to understand the workings of the MMS

system and its built-in functionality

o Converted Oracle functionality to work best with Greenplum’s technology

o Conducted knowledge transfer, provided documentation, and provided support

•

• Environment: Business Objects Data Integrator 11.5, Business Objects Data Services 3.0,

Greenplum/PostgreSQL technology, Oracle, Rapid Marts.

Fresenius Medical Care, Nashville, Tennessee

January 2007 – February 2010

• Project: During this three-year project, the client implemented a major Business Objects Data

Integrator upgrade of distributed clinical system hosted in 52 North American locations. Client

used Business Objects Data Integrator version 6.5 to update clinical data warehouse each night,

extracting from each location’s clinical systems in succession. Mr. Roth designed and

implemented architecture to allow the Business Objects Data Integrator process to support a

flexible conversion schedule whereby both versions of the clinical system are simultaneously

supported as sources.

o Key activities during three years on project included design, development, and

performance tuning, as well as dimensional and relational data modeling

o Created and maintained technical specifications and plan for modifications

o Designed and developed architecture to allow data warehouse load logic to support

multiple versions of the source system simultaneously

o Provided documentation and knowledge transfer of the solution

o Designed target database changes to accommodate the source systems requirements

o Developed ETL processes to handle the nightly load of data from 52 source databases

o Designed and coded Oracle procedures and functions required for use in the nightly ETL

process

o Designed modifications to the existing Oracle target database to improve performance

o Provided training and mentored client’s employees in Business Objects Data Integrator

best practices

o Designed and coded ETL processes to load converted source data to Oracle target

database

o Modified scripts that allowed multiple versions of source data to be handled on a nightly

basis

•

Acturner, Germantown, Maryland

2006

• Designed a data warehouse and data marts using Kimball methodology

• Gathered business requirements for designing the data warehouse that supported reporting

requirements

• Provided overall project management and resource allocation

• Source systems were JD Edwards and external feeds

• Target system was Oracle 10g

• ETL Tool Used: DataMirror Transformation Server

Andrews Consulting Group, Cheshire, Connecticut

2004 - 2005

• Employed as Senior Business Intelligence Technical Consultant for two years and worked on

various projects for different clients

• Provided ETL solutions and designed data warehouses using the Ralph Kimball dimensional

modeling methodology

• Used Business Objects Data Integrator as the ETL solution for loading data warehouses from JD

Edwards OneWorld

• Created a data model and E/R diagram using Computer Associates Erwin.

Boehringer-Ingelheim, Ridgefield, Connecticut

2001 - 2004

• Employed as Senior Business and IT Consultant for three years

• Interfaced with multiple departments within Boehringer-Ingelheim to define business requirements

• Performed database design of the data warehouse and the ETL process that used SAP as the

source system and Oracle 9 as the target; system was used to support the Sales and Marketing

divisions

• Defined business requirements

• Designed and deployed a solution supporting C-level decision making

• Delivered the project 50 percent ahead of schedule

Nestle Waters of North America (formerly The Perrier Group of America), Greenwich, Connecticut

2000 - 2001

• As Manager of Database Administration, recruited and managed seven direct reports and

directed $3 million budget

• Designed and introduced efficient systems

• Supported Oracle and Microsoft SQL Server applications

• Developed standards and performed tuning of databases and applications

• Applications included SAP, PeopleSoft, and Siebel

• Reduced costs by 50 percent by negotiating favorable vendor contracts

• Achieved 99.999 percent uptime, cut overtime expenses by 25 percent, and eliminated 4-day-per-

month downtime

• Documented systems using VISIO and DB*Artisian

Boehringer-Ingelheim, Ridgefield, Connecticut

1998 - 2000

• Employed as Business and IT Consultant to manage multiple projects and high-tech staff

• Streamlined processes and improved corporate decision-making ability

Oxford Health Plans, Norwalk, Connecticut

1995 - 1998

• As Claims Systems Manager, Mr. Roth managed ten staff members and the operational budget

• Advised senior management on business strategy, installed Business Objects for use in data

analysis, and designed an Oracle 8 claims process system

• Performed system tuning and code development in PL/SQL

• Performed project management functions

• Restructured unit to improve processing, expand capabilities, and facilitate growth

Johnson and Johnson, New Brunswick, New Jersey

1990 - 1994

• Slashed reporting time from 5 days to 1 day

• Designed and deployed an innovative management solution

• Established a high-performance unit and maximized efficiency

• Delivered project 33 percent ahead of schedule and consolidated four disparate systems into one

centralized solution

• Source systems were MVS files

• Target system was an Oracle 8 database

PepsiCo, Inc., Purchase, New York

1989

• Reduced risk and improved control by instituting company-wide Human Resource application

• Source system was third-party vendor data pertaining to employees

• Target system was an Oracle 7 database

Merck & Company, Rahway, New Jersey

1988

• As Data Architect, delivered one-year implementation project in eight months

• Project enhanced tracking and decision-making capabilities

• Target system was an Oracle 7 database

Prudential Bache Securities, New York, New York

1985 - 1988

• Designed and implemented an interest rate swap system using Oracle 7

• Database design provided analytic tools used by business clients for performance analysis of

data

Project enhanced company’s ability to analyze data in order to perform correct business

•

procedures

Training

• Oracle Database Design and Tuning Training

•

• Cognos Decision Stream (ETL) Training

Contact this candidate