Data Warehouse Project

Richard B. Jackson

E-mail:*********@*******.***

* ******* *****, *******, ** 203-***-****

Professional Profile

A Project Leader with extensive data processing experience including

designing, programming and implementing strategic systems and tools for

direct marketing and reporting. Highly motivated, flexible, goal

orientated team player. Strengths include organizational ability, the

aptitude to quickly learn new skills, the ability to do detail orientated

work and to work independently, and communicate technical issues

effectively to individuals with a variety of skill levels.

Technical Skills

Software:

COBOL, TSO/ISPF, VSAM, Base SAS, SAS/DB2, OS/MVS JCL and Utilities,

SyncSort, File-Aid, Embarcadero Rapid SQL, CONNECT:Direct (NDM)for MVS and

UNIX, File Transfer Protocol (FTP), PGP, WS_FTP Pro, SSH, TCP/IP, Endevor,

ChangeMan, CVS, Librarian, Vi Editor, Kornshell, UNIX, MS Office Products

(e.g. Excel, Word)

Environments:

UNIX, MVS/XA, TSO/ISPF, Windows, OS/390, VM/CMS.

Professional Experience

Accenture, White Plains, NY

Technical Architect, AT&T IT AO Services Unit, Internet Data Warehouse &

Reporting

February 2009 - April 2010

Functioned as an on-shore Team Lead and subject matter expert for offshore

development and test teams when the ATT Internet Data Warehouse application

was outsourced to Accenture. Worked collaboratively with other team

members from different disciplines, backgrounds, and skill levels to

organize and direct complex work efforts.

. Analyze business requirements and work requests, and determine

possible impact to internal reporting applications.

. Document the data processing solution and the high level application

and program design, and develop and test the program code.

. Lead the offshore team and set direction for coding, testing, and

implementation, which lead to a problem free product ready for

implementation ahead of schedule.

. Act as functional and technical subject matter expert for the Internet

Data Warehouse applications and point of contact for the offshore

development teams.

SBC/AT&T, White Plains, NY

Technical Architect, Internet Service & Long Distance Solutions, Internet

Data Warehouse & Reporting

January 2004 - January 2009

As a Project Leader, or as a team member, analyzed business requirements,

and documented the data processing solution. Designed, developed and

implemented reports and data feeds for both internal and external

applications based on demographic, billing, products and usage information.

. Convert and reconcile analyses, feeds and reports from MVS mainframe

and UNIX Oracle SQL queries to DB2 SQL queries for the first phase of

CRM implementation when Prodigy was bought by SBC/ATT.

. Create list of clients targeted for special customer care billing

notification, direct marketing campaigns and promotions.

. Rapidly addressed urgent client requests for adhoc one and two day

turnaround file generation for external fulfillment, and USP and email

mass mailings.

. Contributed to and/or authored Solution Approach, Technical

Requirements, High Level Design, Interface Agreements, Detail Design,

testing, and implementation project lifecycle documents.

. Served as project lifecycle process Subject Matter Expert for Internet

Data Warehouse application teams.

. Create Unix Kornshell scripts to automate adhoc, daily, weekly and

monthly production processes.

Prodigy Communications Corp., White Plains, NY

Senior Programmer/Analyst, Internet Data Warehouse & Reporting

June 1989 - December 2003

Project Leader that analyzed business requirements, documented the data

processing solution, authored the application and program designs,

developed, and implemented the code on the IBM mainframe (MVS).

. Designed, coded and implemented the collection and reporting of

millions of url records per day for webhost client sites, and revenue

reporting for Web advertising on the Prodigy Internet Service.

. Responsible for day to day support of client reporting and billing,

proxy collecting and reporting, advertising reports, revenue and

royalty reporting, and shopping orders resulting in a 99.9% on time

delivery.

. Developed, coded and implemented the collection and reporting data

feeds of member internet download products such as WINSOCK, NETSCAPE,

CYBERPATROL, and GAMES on MVS, which accelerated the delivery of data

to the client contract billing systems for royalty payments.

. Was a team member that developed, coded and installed an order

fulfillment system on RS/6000 using COBOL II, DB2/6000 for AIX.

. Achieved 50% and 75% reduction in computer CPU time by recoding the

Newspaper and Provider reporting application programs allowing

delivery of the reports by 8AM.

. Lead projects, designed, coded, tested and implement data feeds from

Internet Data Warehouse to Enterprise Data Warehouse, Finance System,

and outside vendors.

Military Service

U.S. MARINE CORPS - Honorably Discharged

Education

Iona College - New Rochelle, NY - BA, History

Contact this candidate