Data Oracle

Jerry L. Dickens

**** ******** **

Laurel, MD ***08

Phone 301-***-****

E-Mail *************@*****.***

AREAS OF EXPERTISE:

o Experienced SAS programmer, skilled at interfacing SAS with other

technologies

o Experienced in ORACLE Forms and Reports, versions 3.0, through 9.2

o Experienced with Sybase (12, 12.5) and integrating SAS with Sybase

o Experienced SQL, PL/SQL, procedures and functions

o Exceptional at debugging and analyzing existing code

o Very good with Excel and interfacing SAS to write to spreadsheets

o Familiar with UNIX and UNIX Shell Scripts

o Experienced SAS DATA Step programmer, versions 6.03 through 9.2

o Experienced in the analysis, design, and trouble-shooting

o Experienced in use of PVCS Tracker, Merant Version Manager, RUP

(Rational Unified Process), MS Query, and Rapid SQL

o Experienced with TOAD (Quest) for accessing and Using Oracle 9.0

o Experienced with Mainframe SAS (IBM VM and MVS).

o Familiar with SAS ACCESS to ORACLE/UNIX/CMS/MVS (IBM Mainframe)

o Familiar with SAS ODS, OLAP and Enterprise Application Development

Systems,

o Tortoise SVN Subversion

o Matlab and ICAT Experience

o TOAD Experience

o SAS Enterprise Guide (4.0)

o Enterprise Architect (7.5) with UML (Universal Modeling language) for

design and business analysis, modeling, documenting, reverse

engineering, building and maintaining object-oriented software systems

o SAS Business Intelligence and Stored procedures

o SQL Developer for Oracle

o LINUX

o UNIX

WORK EXPERIENCE:

September 2012 to Present... FannieMae Inc

SAS programmer III, Specialized, Developer

Writing, Developing, troubleshooting Programs in SAS. Creating new

programs as needed in SQL, SAS.. Modifying Programs in the same. heavy use

of proc tabulate, proc sql, and data step programming in SAS. Use of SQL

extensively. Creating reports. Interfacing with Excel, Shell

scripting(Korn). Analysis of data from different platforms, as needed to

determine what is needed to produce the Client's desired output.

Downloading and uploading data using SCP. Use of MATLAB to produce the

sample monthly report on Mortage loans. Extensive use of SAS Macros, SAS

Code and Procedures like proc Tabulate, proc means, Summary, Proc Reports,

and almost any sas proc needed for analysis. Performing summation on

aggregated mortgage data. Producing Cash Flow and Analysis Reports (Ad Hoc)

in addition to regular work. Producing production Reports that compare

production to other platforms(UAT(user acceptance testing) and others).

Extensive use of Excel and ExcelOds Tagsets, as the platform is UNIX. Use

od Proc Download, Upload on a regular basis. Extensive troubleshooting and

performance enhancements. Much Analysis, impairment analysis, regression

analysis etc.. It's a really great job...

August 2011 thru May 2012

Data Analyst/ SAS Programmer/Developer

(Capital One Inc McClean, VA, through Collabera Inc)

Responsibilities included

Using SAS Enterprise Guide for Creation of EG Projects. Extensive use of

SAS, SQL and Excel. This role requires extensive skills in SAS, SQL and

other technologies. I'm also trying to Identify opportunities to use data

to develop new solutions.

o The maintaining of data infrastructure for development of scripts for

regular processes.

o Ensures that I/O capabilities with the principal Oracle database

function properly; Interacting with the Mainframe

o Writing SAS Code

o Writing SQL Code

o Communicating and presenting data in any format the Client desires to

see data.

o Formulating a system for seamlessly integrating all of the components

together

o Searching the BDW(Ban Data Warehouse) to Create reports from the

teradata repository for Ad-Hoc Reports, Daily, Weekly and monthly

Reports.

o Creating output for the Dash Board.

o Modifying the BOBJ Platform(Business Objects). Performing queries,

using Teradata SQL, Against the Platform. Creating reports.

October 2008 - To July 2011

SAS Programmer/Developer

(DOE-EIA, Department of Energy, Energy Information Admin)

Sr SAS programmer in support of the Petroleum Marketing Monthly task.

Responsibilities include:

o The migration of application code for the EIA-782A/B/C survey

processing systems from a mainframe to PC-based environment

o Ensures that I/O capabilities with the principal Oracle database

function properly; Interacting with the Mainframe

o Writing SAS Code

o Writing SQL Code

o Working with SQL Developer and the Oracle(11g) Database

o Formulating a system for seamlessly integrating all of the components

together

o Assisting with development and implementation of a test plan for the

migrated system; and providing additional technical maintenance and ad

hoc support as needed.

o Assisted in SAS Systems Upgrade to Eguide Enterprise Configuration.

o Developed requirements and enterprise architecture for EIA metadata,

Eguide and EBI under SAS version 9.1/9.2.

o Assisted staff in converting legacy SAS mainframe code to SAS Eguide.

o Trained staff in learning EBI analytical techniques and information

delivery approaches and methodologies.

o Designed and deployed software engineering practices, as requested, to

maintain SAS code configuration and data quality.

o Created Enterprise Guide projects and stored procedures in SAS,

seamlessly integrating the operations of the different modules.

o Used SAS Web Report Studio, Information map Studio and other SAS BI

(Business Intelligence) objects.

o Extensive use of the metadata repository, SAS macros, and Enterprise

Guide.

o Completed Courses at the SAS institute, Rockville MD, on SAS EG and

other BI modules.

February 2007 - August 2008

Sr SAS Programmer (epidemiological Analyst)

(US Army Civilian)

o Conducted data queries, analysis and validation.

o Retrieved, manipulated, and summarized healthcare System data from

various databases, warehouses and files using Base SAS software.

o Consolidated the data for reports.

o Calculated healthcare metrics and performed analyses on the data. The

various outputs included SAS (version 9.1) frequency reports, Excel

spreadsheets, ODS database tables.

o Created SAS code to assist Analytical Epidemiologist and the Central

Epidemiologic Center of AMSA ad hoc reports, reports, projects, or

task regarding the health and wellness, as well as the obstacles to

medical readiness of US Service Members.

o Wrote SAS programs to generate epidemiological/statistical analyses

(e.g. tables, listings, figures, and other Statistical output.

o Performed quality review on SAS programs generated by other staff

analysts.

o Documented programs.

o Servgggbed on assigned projects and task.

o Programmed using SAS, SQL, and MS Office Suite.

o Worked under Limited Supervision.

o Performed Additional duties as required.

August 2003 - December 2006

Senior Developer/Analyst/Programmer (SAS - Sybase - SQL - Oracle --

Mainframe)

Under Windows NT (LAN), IBM Mainframe, UNIX (Client Server), and PC

Lead Programmer/Developer

o Ran SAS in multiple UNIX environments as well as stand-alone PCs,

Consolidated Computing Environment in Solaris, distributed

environment, Mainframe SAS, and PC SAS editions which are mixed LAN

and locally based.

o Responsibilities included maintaining software levels and planning for

future product implementations.

o Day to day duties included writing, coding, updating, modifying and

trouble-shooting SAS programs and macros in support of the CPI

(consumer price index) and PPI (producer's price index).

o Use of Versions 6.09 SAS (mainframe), 8.2 SAS (LAN and UNIX),

integrating them seamlessly from one platform to another as part of a

downsizing effort.

o Worked on C&S/TPOPS Production and development.

o Used Sybase 12.0 and 12.5 with SAS to replace code on the mainframe

for high priority work to produce the CPI every month.

o Designed, Coded and documented applications to meet customer

requirements where SAS was an integral component of the system.

o Prepared associated documentation, block diagrams, and logic flow

charts.

o Translated design specifications into program instructions.

o Prepared, tested data and conducted test.

o Formulated recommendations on technical problems with little guidance.

o Loaded to SAS version 9.2 on the UNIX servers.

o Migrated data from the mainframe using SAS 8.2 and SAS version 9.

o Versions 8.2 used on the LAN, 8.2 on the PC, 8.2 and 9.2 on UNIX,

versions 8.2 and 6.12 on the Mainframe (SUNGARD).

o Instructed, directed and monitored lower level developers and served

as a SAS reference person on a development / redesign team.

Independent Contractor Temporary Position (W2)

August 2000 - June 2003 UUNET Technologies;

Senior Systems Analyst (SAS - SQL SERVER -SYBASE)

o Developed applications and programs/reports in SAS (programs were

previously written in version 6.12, upgraded to version 8.0). Version

8.0 was used extensively (as version 7.0 was not acceptable).

o Used DB2, SAS, Sybase and SQL Server (Open Client versions 4.6 and 10)

in a Data-Warehousing (a terabyte of data) environment to gather data

that was often located on different servers in a large-scale

production system (Producing over 200 Reports Daily);

o Mined Data, constantly manipulated the data in a high volume,

production based system.

o Wrote SAS Programs, macros and code and produced Ad-hoc Reports.

o Integrated SAS Code with SQL+ and other languages.

o Used SAS to gather data from Microsoft SQL Server for a system

requiring hundreds of reports daily.

o Found and broke down hidden structures in data for data mining. This

effort required a heavy use of SAS macros. Used of SAS/STAT and SAS

GRAPH as well as SAS Share Software. Also used SAS ACCESS to create

data views for transferring data to the web.

o Used SAS ODS (Output Delivery System) to produce reports on the web.

o Used Java web development Tools (J2EE, J2SE), cross platform

technology and Eclipse, team studio analyzer.

o Wrote HTML code and edited HTML pages using advanced Html Editors.

o Used the OLAP (Online Analytical Processing) to produce Sales and

Marketing reports, financial reports and quality control analysis.

o Produced tables, charts, summary and multi-dimensional reports for

different clients.

o Wrote specifications and designed and developed SAS based production

applications that interfaced with the Sybase RDBMS in order to

manipulate data into required formats.

o Utilized SAS ETL tools (power-loader) to provide source code,

migrating data and supporting process documentation for production

applications.

o Prepared documentation and constructed test files.

o Gathered data from the data warehouse, the LAN and sometimes from

Legacy (main frame) systems.

o Became familiar with Informatica.

o Also became familiar with and used SAS (EAS) Enterprise Application

Development System for information delivery (version 2.0) which

allowed me to use SAS Intranet components such as htmSQL, MDDB Report

Viewer.

Independent Contractor Temporary Position (1099)

November 1999 - To July 2000 G4TI Inc; Senior Systems Analyst (HUD)

o Y2K Desktop Readiness project.

o Insured that HUD's IT infrastructure was absolutely functional for the

Year 2000.

o Used Oracle and Sql (UNIX) to create table structures and relational

databases to hold data that was to be collected.

o Used Bindview (Btrieve) to collect and analyze huge sums of raw data

from HUD's 18,000 PCs and over 100 network servers spread out among 81

field offices.

o Used Oracle Reports to produce the information in the proper format

for the various interested parties.

o Provided coordination and assistance with all of the receivers of the

information and reports.

o Assisted the 81 IT Field Office personnel/Users with support for

individual tool usage or questions when it came to their applications

(spreadsheets and databases).

o Use of Access and Excel to produce a variety of databases/spreadsheets

for individual reports, charts, graphs for users.

o Produced Summary Reports and various Application Reports (Compliance,

Non Compliance, Accounting, and User).

o Also Analyzed, Prepared and distributed reports to all interested

parties. Coordinated and trained local field personnel.

Worked for CACI Inc, on different Projects 1991 - 1999 (CACI is a

Consulting Company)

June 1997 - November 1999 CACI, Inc; Senior Systems Analyst (SAS - SQL-

ORACLE)

(At CACI Headquarters 1100 N Glebe Rd Arlington, VA)

o Oracle Applications/Database Analyst (UNIX).

o Produced Oracle Forms (Oracle 8) using forms 5.0.

o Upgraded existing applications to 5.0. This included trouble-shooting

and re-writing triggers when necessary.

o Wrote procedures and functions using PL/SQL.

o Developed reports in SAS. Used SAS application (Proc SQL) to access

Oracle to get required data for SAS reports, sometimes returning data

to Oracle by loading a table from SAS (Proc dbload).

o Wrote technical specifications for testing and implementation of

procedures.

o Provided Oracle system application and database support including

requirements analysis, design development, testing, integration,

implementation, and documentation for developmental and maintenance

efforts on a wide variety of projects, primarily in a windows

operating environment and on a Unix Platform.

o Provided support for Year 2000 (Y2K) renovation, and test

plan/procedure development/execution.

o Systems ranged from small applications to large-scale/complex

structures.

o Extensive use of SAS (versions 6.09 and 6.12) and SQL+ was required.

o Used Unix Shell Scripting to perform global changes and sometimes to

re-direct output to new location (printer).

o Also use of scripting to effect program control transfer (start-up

other applications.).

o This job required heavy Product Documentation and Support.

o This was a large volume production project. Worked with HTML Pages and

java.

March 1996 - June 1997 CACI, Inc - Commercial; Systems Analyst (ORACLE -

SAS)

(At US Justice Dept. (USDOJ) Office of Litigation Support Washington, DC)

o Creating forms in Oracle forms 4.5. (UNIX)

o Upgraded forms from 3.0 to 4.5 and Used Oracle 7 for a wide variety of

form applications from Oracle forms 2.5 through 4.5.

o Wrote triggers and customizing and upgraded form applications. Using

SAS (versions 6.09) to create reports for a wide range of comparisons

of data in different databases.

o Use of SAS/AF Software to create interactive applications.

o Used of SAS Screen Control Language (SCL) and SAS Access and Proc SQL.

o Created menu systems.

o Wrote programs and de-bugged code in SQL+ and PL/SQL.

o Used Data Preparation Software and applications to upgrade and

transfer data.

May 1995 - March 1996 CACI, Inc - Commercial; Computer Programmer Analyst

(Senior Programmer) Lead Programmer (UNIX-ORACLE-SAS) (at USDOJ Civil

Rights Division Washington, DC)

o Headed a team of 6 (3 Senior Programmers, 2 Programmers, 1 Junior

Programmer) Sr. Programmer for the Justice Department Civil Rights and

Criminal Divisions.

o Our Job was to migrate data including a complete forms system

(consisting of forms 2.5 and 3.0) from a data general System to an

Oracle Platform/Unix Environment.

o Wrote UNIX shell scripts.

o Created forms in 3.0.

o And created menu systems.

o Created Databases in Oracle using SQL+ and SQL-loader, and SAS

products, Proc SQL and Proc-Dbload.

o Created reports in varying formats for different clients within the

scope of the Civil Rights Division.

o Performed searches; Wrote Programs in SAS (version 6.07 and 6.09) to

down load and edit data from tape format to make it compatible with

the LAN.

o Received a Generous bonus for my work.

April 1994 - May 1995: CACI, Inc. - Commercial; Computer Programmer II (SAS-

SQL-REXX) (At CACI Field Office for DOJ 1120 G ST. NW, Washington DC.)

UNIX on Solaris SparcServer 10 Platform, Mainframe on IBM 3090/400J (VM).

o Programmer on the T4D automated litigation support project with the

Department of Justice's Office of Litigation Support.

o A large focus of this job was the migration of data from the Mainframe

to a complete Oracle/Unix Environment.

o At this time we were still using both.

o Wrote and debugged programs in SAS (versions 6.03 and 6.07), SQL,

PL/SQL, and REXX. Produced reports, conducted client and internal

searches, performed loads to the LAN And Mainframe databases, and

updated the Oracle(Unix) and Inquire(Mainframe) databases; Drew flow

charts and Diagrams.

o Created and maintained tables in Oracle. Wrote SAS programs for

producing the Witness

o Binder reports required by Justice Department for Litigation Support.

January 1993 - April 1994: CACI, Inc. - Commercial; Computer Programmer

(MAINFRAME/UNIX) (At DOJ Headquarters 6th St and Pennsylvania Ave NW,

Washington

DC)

o UNIX on Solaris SparcServer 10 Platform, Mainframe on IBM 3090/400J

(VM).

o Prepared logic and diagrams flow programs from program specifications.

o Modified, Coded and Tested programs based on user and management

requirements; De-bugged programs.

o Use of IBM DB2 (version 5) under OS/2.

o Documented Program Modules and subroutines.

o Used SAS (v6.03), REXX, INQUIRE, JURIS, Oracle 7, SQL*Plus, Forms 4.0

and Reports 2.0.

o Loaded Tapes; Performed Maintenance work on the T4D database (A

database of 1.5 million records), Implemented changes and updates.

o Assisted with Special Projects as necessary.

October 1991 - January 1993: CACI, Inc. - Commercial; Data Base Search

Assistant (Lead DBSA) Headed a team of 3 DBSAs in Searching the Data Base

for Documents (Mainframe)

o Performed database tasks in support of a major government litigation

effort; performed updates on various databases.

o Maintained automated and paper history of past searches and record

files.

o Used Inquire on IBM Mainframe (3090/400J) VM for searching and

querying the databases.

o Designed and maintained report formats.

o Wrote reports in SAS using Data step programming on the Mainframe.

o Used SAS Access and SAS Companion for CMS.

o Created Queries to respond to customer request.

EDUCATION:

University of the District of Columbia Bachelors Degree/Computer Science ;

University of the District of Columbia Associate Degree/ Electronics

Technology;

Computer Learning Center; Springfield,

Nine-month (900 clock hours) Programmer course on SAS, SQL UNI

(Including Shell Scripting), VI Editor, Client-Server Architecture, PL/SQL

Oracle Forms and reports. Wrote Programs in SAS, PL/SQL, SQL.

Graduated with Honors

Contact this candidate