Roger L. Harris

Largo, FL *****

727-***-****

727-***-****

acpczw@r.postjobfree.com

SUMMARY

Twenty years experience in the IT industry including 18 years of SQR

development and 15 years working with Brio Portal/Hyperion Performance

Suite/Oracle Enterprise Performance Management System. Extensive experience

writing complex SQL queries in Oracle and other major relational database

systems.

SKILLS

Programming Languages

Hyperion SQR Production Reporting v2.5 - v9.x, SQL, PL/SQL, Watcom SQL,

TransactSQL

Scripting and Markup Languages

HTML, CSS, JavaScript, Unix shell scripting, Perl, Ruby

Database technologies

Oracle RDBMS, Teradata RDBMS, Sybase (Adaptive Server Enterprise, SQLServer

and SQLAnywhere), Informix, Ingres, Paradox

Database applications

Artemis Trackview, Maximo v3, Lawson v7 (HR/Payroll, and Financial suites),

multiple custom data warehouse applications

Software Applications/Development Tools

Hyperion Performance Suite v8.x, BrioOne*Administrator v7, BrioPortal v7,

SQL*Plus, Quest TOAD for Oracle v9, DbVisualizer v7.x

Operating Systems

Windows (9x, NT, 2000, XP, Server 2003), Linux (RHEL Server), UNIX (SunOS,

Solaris, AIX), VAX/VMS

EXPERIENCE

Contract SQR Developer Nov 14 to Dec 14

Rapid Web Global Inc., Iselin, NJ

Client info: Cigna Corp. Global health services company - medical, dental,

pharmacy, vision, life, accident and disability plans and insurance.

. Created multiple SQR report programs that output Spreadsheet XML files

per customer requirements.

Technologies used: Oracle 11g, SQR v9

Contract SQR Developer Jun 14 to Oct 14

ZTek Consulting Inc., Duluth, GA

Client info: Sodexo Inc. Food services and facilities management

multinational corporation.

. Modified query that extracted new Chart-Of-Accounts (COA) structure from

the database.

. Rewrote multiple SQR reports based on client's requirement

specifications and layout prototypes reflecting new COA.

Technologies used: Oracle 11g, SQR v8

Contract SQR Developer Nov 13 to Apr 14

NTT Data Corp., Plano, TX

Client info: Best Western International, Inc. Provides marketing,

reservations and operational support to over 4,000 independently owned

hotels in more than 100 countries and territories worldwide.

. Developed multiple SQR reports based on client's requirement

specifications and layout prototypes.

Technologies used: Oracle 11g, SQR v6

Contract SQR Developer May 13 to Aug 13

Strategic Staffing Solutions L.C., Detroit, MI

Client info: Cigna Corp., Global health services company - medical, dental,

pharmacy, vision, life, accident and disability plans and insurance.

. Developed multiple SQR reports based on client's requirement

specifications and layout prototypes.

Technologies used: Oracle 11g, SQR v9, Toad for Oracle v 11.6.1

Contract SQR Developer Jun 12 to May 13

TEKsystems Global Services Inc., Hanover, MD

Client info: Options Clearing Corp. Provides risk management, clearance and

settlement services to equities trading clients.

. Maintenance and Modification of existing SQR programs per customer

requirements.

Technologies used: IBM DB2, SQR v9, SQuirreL SQL Client

SQR Developer/System Architect Aug 10 to Aug 11

Sungard Data Systems Inc., New York, NY

Company profile: The Stream Wall Street Concepts division provides tax

information reporting solutions for various investment vehicles to

participants in the financial industry. These services facilitate the

production of Forms 1099, 1042S and K-1, as well as the preparation of

individual tax returns.

. Modified existing SQR and stored procedure code per business

requirements.

. Rewrote stored procedures that returned data sets to instead populate

temporary tables thus leveraging SQR's built-in break logic that

improved performance by over 10%.

. Identified and modified slow running SQR code that improved performance

by over 30%.

. Modified Perl and Ruby programs used to launch SQR batch jobs.

. Operations support for tax statement production.

Technologies used: Sybase ASE v15, SQR v9, DbVisualizer v7

Contract Hyperion SQR Developer Aug 09 to Dec 09

IT Mantra LLC., Wellesley Hills, MA

Client info: Wright Express Corp. Provides payment processing and

information management services to the U.S. commercial and government

vehicle fleet industry.

. Developed data warehouse SQR reports based on HLD/DLD requirements.

. Modified existing SQR reports and UNIX shell scripts per requirements.

. Assisted staff completing DIT/SIT testing for design/functional

requirements.

. Completed assignment 3 weeks early.

Technologies used: Oracle 10i, SQR v9, Toad 9, UltraEdit

Sr. Programmer/Analyst - Hyperion Systems Administrator Jan 05 to Mar 09

Fidelity National Information Services Inc. - Check Services, St

Petersburg, FL

Company profile: Provides core financial institution processing services,

card issuer and transaction processing services, mortgage loan processing

and related information products and outsourcing services to financial

institutions, retailers, mortgage lenders and real estate professionals.

. Developed SQR reports for companies check warranty data warehouse.

. Developed SQR reports for Project Management Group, data queried from

Artemis Trackview project management/time keeping application.

. As Senior SQR developer mentored junior SQR programmers.

. Authored company's SQR coding standards as part of initiative to obtain

Capability Maturity Model (CMM) Level 3 certification.

. Assumed administrative duties for the Hyperion Performance Suite

reporting portal.

. Developed custom parameter forms using HTML, JavaScript and CSS to

collect runtime parameters for SQR reports running in the reporting

portal.

Technologies used: Oracle 10i, Hyperion Foundation v8x, SQR v8.x, Toad 9

Contract Hyperion SQR Developer Sep 04 to Dec 04

Connect: The Knowledge Network, Denver, CO

Client info: The TriZetto Group Inc. Information technology and services

company focused on the healthcare industry.

. Analyzed existing SQR programs, made required design changes and

implemented SQR coding changes.

. Updated SQR code to comply with company coding standards.

. Modified existing Korn shell scripts to comply with company coding

standards.

Technologies used: Sybase ASE v12.5, SQR v6.2, RapidSQL v7.2

Contract Hyperion SQR Developer Apr 04 to Jun 04

TEKsystems Inc., Hanover, MD

Client info: YUM Brands, Inc. Corporate parent of KFC, Pizza Hut, Taco

Bell, A&W All-American Food Restaurants and Long John Silvers.

. Performed impact analysis of corporate alignment identifier changes on

SQR programs.

. Modified and tested SQR programs to reflect alignment changes.

Technologies used: Teradata Warehouse 7.0: Teradata RDBMS v2r5, SQR v6.1.2

Contract Brio SQR Developer Aug 03 to Dec 03

TEKsystems Inc., Hanover, MD

Client info: Corporate Express Inc. Business-to-business supplier (delivery

and direct shipment) of office and computer products and services.

. Modified Warehouse Management System (WMS) document generating SQRs per

client requests.

. Provided test cases for Unit/System Testing.

. Conducted impact analysis on SQRs for proposed database changes.

Technologies used: Oracle8i v8.1.7, SQR v6.1.4

Contract Brio SQR Developer Nov 02 to Mar 03

Comforce Info Technologies Inc., Woodbury, NY

Client info: Mayo Foundation . Provides IT services for clinical trials of

drug studies and medical procedure for clients worldwide.

. Modified custom clinical trials report suite of 20+ SQR reports per

client requests.

Technologies used: SQR v3 and Ingres

Contract Brio SQR Developer Nov 98 to Aug 02

TEKsystems Inc., Hanover, MD

Client info: Colorado Springs Utilities - Four service utility company

implementing Maximo for their Resource Management System and Lawson for

HR/Payroll and Financial suites.

. Designed and developed 40+ custom Brio SQR reports for new Maximo

installation.

. Mentored staff programmers in SQR, assisting with debugging.

. Assisted implementation and setup of BrioPortal.

. Designed and developed 50+ custom SQR reports for new Lawson

installation.

. Published reports to BrioPortal.

. Designed and coded 30+ custom web based ONE*SmartForm parameter

collection forms for reports published in BrioPortal.

. Participated in client's Brio Performance Tool Suite evaluation demo.

Technologies used: Oracle v7.1.3 - v8.1.6, BrioPortal v6 - v7, SQR v6, HTML

and JavaScript

Contract SQR Developer Mar 98 to Nov 98

Paradigm Integrated Services, Phoenix, AZ

Client info: Ugly Duckling Corp. Used car sales and financing.

. Developed ad hoc SQR reports for a loan servicing application, per user

requests.

. Modified existing stored procedures using TransactSQL.

Technologies used: Sybase SQLServer v4.9.2 and SQR

Contract SQR Developer Dec 97 to Feb 98

Southwest Supermarkets, Phoenix, AZ

. Developed SQR enhancements to an application for processing incoming

flat files.

. Developed and modified SQR Reports per customer requests.

. Modified UNIX Shell Scripts used to submit SQR jobs.

Technologies used: Informix v7.2 and SQR

Contract SQR Developer Apr 97 to Jul 97

Qualcomm Inc., San Diego, CA

Client info: Wireless communications developer and commercial trucking

satellite communications, position location and logistics management.

. Converted 30+ existing SQL*ReportWriter reports to SQR.

. Installed converted SQR reports in custom menuing system.

Technologies used: Oracle v7.2 and SQR v3

Programmer Dec 96 to Mar 97

Science Application International Inc., San Diego, CA

Company profile: Employee-owned research and engineering company, providing

information technology, systems integration and eSolutions to commercial

and government customers.

. Designed Archive Function for an engine maintenance database.

. Wrote Watcom SQL scripts to implement Archive Function.

Technologies used: Sybase SQLAnywhere v5.0

Oracle/Programmer Consultant Sep 96 to Nov 96

National Bankcard Association, Inc., San Diego, CA

Client info: Markets and services electronic credit card processing and

payments systems to small retail, wholesale and professional businesses.

. Installed and configured Oracle RDBMS.

. Performed ETL using PL/SQL scripts to populate database from flatfiles.

Technologies used: Oracle v7.1

Engineer/Programmer Aug 93 to Jun 95

Prospective Computer Analysts, Inc., Coronado, CA

Company profile: Management and engineering company specializing in

acquisition and integrated logistics support as well as expert systems and

information technology.

. Developed SQR Reports for a Configuration Management application.

. Enhanced and modified existing SQR Reports per customer specifications.

. Designed inventory control system for Test Program Set Library by

converting existing Paradox application to Oracle.

. Developed data entry forms using SQL*Forms and PL/SQL.

Technologies used: Oracle v6 and SQR v2.5

Senior Engineer Jul 84 to Dec 89

Access Research Corp., San Diego, CA

Company profile: Department of Defense contractor for United States Air

Force (USAF).

. Developed test programs for testing digital circuit boards on a GenRad

2225 portable tester.

. Modeled Unit Under Test (UUT) circuitry using Hierarchical Integrated

Test Simulator (HITS).

. Conducted non-destructive fault insertion testing.

. Performed Independent Validation and Verification of Test Program Sets

for replacement USAF F-111 Avionics Automatic Test Stations.

EDUCATION

A.S. Computer Information Systems, Honors Graduate, cum laude GPA 3.878

Coleman College - La Mesa, CA

B.S. Electronic Engineering Technology

DeVry Institute of Technology - Phoenix, AZ

Contact this candidate