Project Data

JOHN D. RAINEY

*** ******** ****; Marietta, SC **661

Mobile: 864-***-****; *********@*****.***

PROFESSIONAL SUMMARY

Data Warehouse/BI Professional with more than 23 years of experience and 15

years of experience successfully defining, designing, and implementing high

performance solutions for Fortune 500 companies in various business

verticals, with a primary focus in Financial Services. Deal with all

aspects of the Data Warehouse and BI platform postproduction, including the

day-to-day operations as a working manager. A consistent record of

providing accurate project deliverables to a published timeline, while also

managing client expectations and project scope. Successfully lead both

onshore and offshore development teams, applying software development best

practices during the development life cycle.

SELECTIVE CLIENTS (PARTIAL LIST)

AIG, Citigroup, Xerox, Michelin, Walmart, Key Bank, Chartis, Blue Cross

Blue Shield (BCBS) and America OnLine (AOL).

COMPUTER SKILLS

Software/Programming: Ab Initio GDE & Co-Operating System (2.0x - 2.5x),

Microstrategy 7.X-9.X, UNIX k-shell scripting, UNIX Bourne shell scripting,

Ab Initio EME version control, CVS version control, PVCS version control,

Tivoli Job Scheduler, Autosys Job Scheduler; Information Builders Focus

development, SQL development, Oracle (7.x -12.x), DB2 (7.x - 8.x), SQL

Server, MS-Access, RedBrick, Oracle Designer, Erwin, MS-Word, MS-Excel, MS-

Visio, MS-PowerPoint; MS-Project, Visual Basic, Visual Basic for

Applications, Subversion, GIT, JIRA.

Database Platforms: Oracle 7.x - 11.x, UDB 7.x - 8.x, DB2 7.x - 8.x,

Netezza, SQL Server.

Operating Systems Platforms: HP UNIX (10.x - 11.x), AIX UNIX (5.x and

above), Sun UNIX, Linux, MS-Windows NT 2000 Server, MS-Windows (3.xx, 95,

XP, Vista, 7, 8) MS/DOS, IBM PC/DOS, TSO, VM/CMS, VMS and OS X (UNIX).

Hardware: IBM server, HP server, SUN server, IBM 3973 mainframe, IBM 390

mainframe, Amdahl mainframe, IBM PC Compatible and Apple MAC.

PROFESSIONAL EXPERIENCE

SARsoft LLC, Greenville/Windstream, Greenville, SC (Contract) 2014 -

ETL Architect/Designer/ETL Developer/Oracle Technologist

Served as a Consultant, ETL Architect and Oracle Technologist for

communications vertical.

. Use UNIX K-Shell and Bourne Shell for Oracle SQL ETL and SQL Loader

solutions. Evaluate various ETL tools to determine the best fit for the

business environment, based on data volumes and financial constraints.

Work with various ETL tool vendors in arranging demonstrations and Proof

of Concepts. Work with the business to choose ETL software that will

serve current needs while scaling to handle needs of the business over

the next decade. Work with the business to select hardware that will

meet the needs for the ETL tool, Oracle database upgrades and sufficient

file system space.

. Work with Oracle versions 9.i through 11.g to improve performance of

queries, views, materialized views and SQL Loader scripts, based on the

functionality available in the existing versions of the Oracle software

being utilized. Use various techniques such as rewriting SQL, adding

hints, temp tables, materialized views and indices to improve overall

performance.

JOHN D. RAINEY; Mobile: 864-***-****; Page 2

.

. Analysis and planning to upgrade the 9i and 10g database versions to 11.g

and 12.c, evaluating the use of the new ETL tool to replace existing DB

links.

. Analysis of methodologies for managing large data volumes using Oracle

and ETL functionality and techniques.

. Bourne shell scripting to creating jobs that extract, manipulate and load

data between Oracle databases, Netezza databases and flat files.

SARsoft LLC, Greenville, SC/Key Bank (Contract) 2013 - 2014

ETL Architect/Designer/Developer/Business Intelligence Analyst/Data

Architect

Served as a Consultant, ETL Architect, Managing Technical Lead, Design Lead

and Developer on projects for Fortune 500 companies in the Banking and

Financial Services business vertical.

. Interview client business and technical personnel to determine high level

and detail project requirements.

. Superior problem solving skills, including the creation of the ETL high

level and detail level designs from which the development staff worked.

. Architect, design and create the project ETL best practices and

architecture documents used by the development staff.

. Defined project development resource staffing requirements and

deliverable timelines based on the estimation of the project effort and

staffing experience.

. Lead development teams and manage their activities, mentoring junior

staff, assigning tasks based on experience level and deliverable

timelines.

. Architect and design and implement high performance applications that

extend an existing data warehouse.

. Architect and design applications that ensure that the client meets their

regulatory reporting requirements.

. Manage all technical aspects of the project, based on best practices and

data warehousing SDLC.

. Managed client expectations, project scope and conflict resolution

through direct interaction with client stakeholders and the client

project management team, ensuring the understanding and agreement on

project tasks, timeline, development resource head count and anticipated

team effort.

. Significant hands-on development and testing of complex Ab Initio graphs,

ensuring the rapid completion of the ETL code deliverables. This

includes the creation of reusable table load/unload graphs and reusable

components.

. Extraction of data from various sources including mainframe serial files,

mainframe DB2 and UNIX based UDB databases that are used to populate the

data warehouse and data marts, along with the creation of flat files that

are distributed to external clients via SFTP.

. Use of the Ab Initio EME for version control ensuring that code modules

are created, updated and maintained in a properly managed environment for

the entirety of the software development life cycle.

Michelin North America, Greenville, SC 2010 - 2013

BI Architect, Business Intelligence Analyst and Manager of North America

Finance BI Platform

Manage all aspects of the North America zone Finance data mart and

mainframe Business Intelligence (BI) platforms.

. Regularly interact with North America zone Senior Management, managing

their expectations with regards to project deliverables for the Finance

data mart and mainframe Finance BI platform.

. Architect, Design and manage Credit, Sales and Accounts Receivable data

models for the Finance data mart and Decision Support System.

. Architect and Design reporting applications that ensure that the client

meets their regulatory reporting requirements.

. Strong SQL skills used in validating data, reports and database

structures

JOHN D. RAINEY; Mobile: 864-***-****; Page 3

.

. Advanced MS-Excel skills used in data validation and analysis using

formulas like VLookup, SumIf, CountIf, and combining predefined formulas

to build complex formulas and surrogate keys to uniquely identify

records.

. Strong background using MS-Excel to manipulate and validate datasets, as

well as display these datasets through the use of Pivot Tables, Graphs

and Charts.

. Superior skills in the use of Visual Basic for Applications (VBA) that

permits the rapid application development of automated functionality and

tools in MS-Excel that can be used for data acquisition, cleansing,

manipulation and various forms of data analysis.

. Design, create and manage Attributes, Consolidations, Filters and Metrics

using the MicroStrategy BI tool to support reporting of data from the

Finance data mart.

. Design, create and manage reports for the Finance data mart and mainframe

BI platforms using the MicroStrategy BI reporting tool and Information

Builders Focus mainframe reporting tool.

. Design and manage, to a published schedule, all enhancements and upgrades

to the Finance data mart and mainframe Finance BI system.

. Create documentation and conduct training sessions that provide detailed

step-by-step instructions for business users to execute pre-existing

reports, based on user selected runtime parameters, as well as providing

documentation and training to the advanced user in the creation of ad-hoc

reporting.

. Regularly interact with the IT Data warehouse team to define, validate

and test upgrades to the data mart.

SARsoft LLC, Greenville, SC 2009 - 2010

ETL Architect/Designer/Developer/Business Intelligence Analyst/Data

Architect

Served as a Consultant ETL Architect, Managing Technical Lead, Design Lead

and Developer on projects

for Fortune 500 companies that are in the Insurance and Financial Services

business vertical.

. Interviewed client business and technical personnel to determine high

level and detail project requirements.

. Superior problem solving skills, including the creation of the ETL high

level and detail level designs from which the development staff works.

. Architect, design and create the project ETL best practices and

architecture documents used by the development staff.

. Defined project development resource staffing requirements and

deliverable timelines based on the estimation of the project effort and

staffing experience.

. Responsible for interviewing ETL development staff new hires.

. Lead development teams and manage their activities, mentoring junior

staff, assigning tasks based on experience level and deliverable

timelines.

. Architect, design and implement high performance applications that extend

the existing data warehouse.

. Architect and design applications that ensure that the client meets their

regulatory reporting requirements.

. Manage the technical aspects of the project, based on best practices and

data warehousing SDLC.

. Managed client expectations, project scope and conflict resolution

through direct interaction with client stakeholders and the client

project management team, ensuring the understanding and agreement on

project tasks, timeline, development resource head count and anticipated

team effort.

. Significant hands-on development and testing of complex Ab Initio graphs,

ensuring the rapid completion of the ETL code deliverables. This

includes the creation of reusable table load/unload graphs and reusable

components.

. Extraction of data from various sources including mainframe serial files,

mainframe DB2 and UNIX based UDB databases that are used to populate the

data warehouse and data marts, along with the creation of flat files that

are distributed to external clients via SFTP.

. Use of the Ab Initio EME for version control ensuring that code modules

are created, updated and maintained in a properly managed environment for

the entirety of the software development life cycle.

JOHN D. RAINEY; Mobile: 864-***-****; Page 4

.

Knightsbridge Solutions/Hewlett Packard, Chicago, IL 2003 - 2009

ETL Architect/Designer/Developer/Business Intelligence Analyst/Data

Architect

Served as a Consultant and Technical Lead, ETL Architect, Data Architect,

Lead ETL Designer and Lead Developer on multiple projects for various

Fortune 500 companies in various business verticals, including: Retail,

High Technology, Insurance and Financial Services.

. Interviewed client technical and business personnel to determine high

level and detail project requirements.

. Data analysis and logical/physical modeling, designing Star and Snow

Flake schema based database tables, using Erwin and Oracle Designer.

. Created/updated ETL standards for architecture, technical design,

development of best practices and production processing.

. Defined project development resource staffing requirements and

deliverable timelines through estimation of the project effort and

staffing/experience requirements.

. Managed client expectations, project scope and conflict resolution

through direct interaction with client stakeholders and the client

project management team, ensuring the understanding and agreement on

project tasks, timeline, development resource head count and anticipated

team effort.

. Create development project timelines and prioritized task lists, where

tasks are assigned to various teams members, based on staff experience,

number of tasks currently assigned to a resource and projected task

complexity and completion dates.

. Institute a change management process to address changes identified by

the client and that customarily fall outside of project scope. These are

typically resolved following the current development phase.

. Meet with the client to review deliverable progress against the project

plan and timeline.

. Lead small development teams, assigning tasks based on skill level,

mentoring junior staff, directing the activities of onshore and offshore

development teams, ensuring that the client receives the best return on

investment for the development team mix.

. Significant hands-on development of complex Ab Initio graphs, ensuring

the rapid completion of the ETL code deliverables.

. Thorough knowledge of Data Integration Architecture and considerable

experience in the development of Ab Initio graphs that successfully apply

data integration techniques.

. Utilize Ab Initio and Oracle SQL Loader to load data into database tables

in either API or Utility mode, permitting data to be loaded in

conventional mode or direct unrecoverable mode.

. Performance tuning of ETL code using a variety of techniques, including:

data reduction as early as possible within graphs, utilization of multi-

files and parallel processing where supported by appropriate data

volumes, management of data skew within multi-files, the application of

partitioning keys and the utilization of pipeline parallelism.

. Definition of database tables to permit the preservation of historical

data utilizing slowly changing dimensions, where required.

. Extraction of data from various sources including: mainframe serial

files, mainframe DB2, UDB, Oracle, SQL Server, Redbrick, UNIX serial

files, UNIX multi-files and various MS-Windows files.

. Use of scheduling software to create batch schedules, which executes ETL

graphs and scripts to produce data sets which are either used by other

processes or represent results used by business.

. Use of version control software to assist in the management of code

modules, ensuring that the modules are created, updated and maintained in

a properly managed environment for the entirety of the software

development life cycle.

. Design and develop Ab Initio based solutions, unrelated to data

warehousing, where large volumes of data exist and high data throughput

is of the upmost importance.

JOHN D. RAINEY; Mobile: 864-***-****; Page 5

.

Michelin North America, Greenville, SC 1997 - 2003

ETL Architect/Designer/Developer/Business Intelligence Analyst/Data

Architect

Develop and maintain software for UNIX and Windows operating systems,

utilizing Oracle database for both data warehouse and data marts, sourcing

data from legacy mainframe and other systems.

. Create and maintain systems consisting of a seven-terabyte data warehouse

and multiple data marts.

. Support the operations of a nightly batch schedule.

. Create and maintain user interfaces using Visual Basic and the

MicroStrategy ROLAP reporting BI tool.

. Manage the full software development lifecycle in the development of code

to populate the data warehouse and data marts, using the Ab Initio ETL

tool to process data in parallel or serially.

. Utilize Ab Initio and Oracle SQL Loader to load data into database tables

in either API or Utility mode, permitting data to be loaded in

conventional mode or direct unrecoverable mode.

. Design database tables, using Star and Snowflake schema, in both the data

warehouse and data marts using Oracle Designer. Created tables,

particularly in the data warehouse that use Type I, II and III (Type VI

Hybrid) slowly changing dimensions.

. Use Tivoli to write a batch schedule that manages job dependencies and

order of execution, for

k-shell scripts and graphs, to successfully populate the data warehouse,

data marts, and external data files.

. Partner with customers to determine their needs, determine data sources

and define requirements at both a high and detail level, then translate

into an ETL design and code, ultimately resulting in data populating the

data warehouse/marts and accessible by the business for decision support.

. Work with third party software vendors to resolve identified tool

defects, obtain and install software upgrades, and manage development

software licensing.

. Direct the day-to-day activities of junior personnel, ensuring that

assigned tasks are matched to individual skill levels and successfully

completed in a timely fashion.

ADDITIONAL RELEVANT EXPERIENCE

Software Data Services Inc., Charlotte, NC

Applications Programmer/Gupta Database Administrator

DBA administration and maintenance of a Gupta Sqlbase relational database.

Create and maintain an assortment of automated reports used by the business

to measure the progress and cost effectiveness of internal processes.

WCA Inc., Simpsonville, SC; Software Applications Programmer / Database

Administrator

Develop and maintain Windows and MS/DOS software targeting the real estate

market, which included a relational database job tracking system, as well

as an application that both processes and manages digital photographs

related to real estate properties. Perform applications and systems

research in conjunction with product development. Work with customers to

define their needs and gather requirements. Direct the day-to-day

activities of programmers, working with a variety of 3 G/L and 4 G/L

languages.

QS/1 Data Systems, Spartanburg, SC; Systems Programmer /Database

Administrator

Develop and maintain the systems computer software used by the applications

development team, including the integrated development environment (IDE)

and code compilers. Responsible for the evaluation and application of all

third party software and hardware products.

EDUCATION AND AWARDS

. Education: Bachelor of Science in Computer Science; University of South

Carolina, Spartanburg, SC; Graduating GPA 3.656. Additional coursework in

Mathematics: Calculus (I, II, III), Abstract Algebra, Linear Algebra,

Differential Equations, Statistics and Discrete Mathematics (I, II).

JOHN D. RAINEY; Mobile: 864-***-****; Page 6

.

. Training: UNIX, MicroStrategy Report Development, Advanced Ab Initio ETL

Topics, Advanced Oracle Topics, Zinger-Miller Management, Data

Integration Architecture

Awards:

. Recognized with several distinguished service awards for exceeding

client and business expectations.

. Awarded Coach of the Year Mentoring Award for three consecutive years

(2005, 2006 and 2007), in recognition of work in mentoring junior

staff.

Contact this candidate