Developer
Resume:
Roger L. Harris
Largo, FL *****
*****.******@***.***
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