Data Developer

Jerry L. Dickens

SAS Analyst

Professional Summary:

Experienced SAS programmer, skilled at interfacing SAS with other technologies

Experienced with SAS DataFlux, DB2 and Sybase Databases

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

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

Experienced SQL, PL/SQL, procedures and functions

Exceptional at debugging and analyzing existing code

Very good with Excel and interfacing SAS to write to spreadsheets

Familiar with UNIX and UNIX Shell Scripts

Experienced SAS DATA Step programmer, versions 6.03 through 9.2

Experienced in the analysis, design, and trouble-shooting

Experienced in use of PVCS Tracker, Merant Version Manager, RUP (Rational Unified Process), MS Query, and Rapid SQL

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

Experienced with Mainframe SAS (IBM VM and MVS).

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

Familiar with SAS ODS, OLAP and Enterprise Application Development Systems,

Tortoise SVN Subversion

Matlab and ICAT Experience

TOAD Experience

SAS Enterprise Guide (4.0)

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

SAS Business Intelligence and Stored procedures

SQL Developer for Oracle

LINUX

UNIX

Education:

University of the District of Columbia Bachelor’s 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, and SQL.

Graduated with Honors

PROFESSIONAL EXPERIENCE:

US Bureau of Labor Statistics -BLS Modernization Project October 2015 to Present

Senior SAS Programmer/Developer

Writing Programs in Developing a new system for the CPI(Consumer Price Index) and PPI(Producers price Index) in support of the agency’s modernization plan.

Performing calculations and imputations to standardize the data in certain fields.

Uploading and downloading data from several platforms.

Writing SQL Code and doing testing.

USDA (Food Safety Inspection Service- (FSIS)) May 2015 to September 2015

Senior SAS Programmer/Analyst (BI Developer (SAS Tools Development Project))

Lead Programmer on the USDA’s Analytical Tools Project. The tool allows the user, with little SAS knowledge to do high level statistics and complex calculations and data reporting.

Analysis was done on instances of Ecoli, Salmonella, Lysteria and other food bacteria.

The output from the tool is Reports, Graphs, Maps and Charts. The Tool utilizes large amounts of data allowing the user to perform probabilistic forecasting based on past data, thus measures can be taken to prevent outbreaks, ensuring the safety of food marketed and consumed. Some of the SAS Products Used in Production of the Tool:

Extensive Use of Base SAS 9.4 for Coding and Testing according to Rules and Specifications, laid out by Employer, and for Reporting.

Use of SAS Logon Manager

Use of SAS Web Report Studio.

Extensive use of SAS Enterprise Guide (EG) 6.1 For Creating and Testing Stored Procedures and Creating/Testing Prompts.

Use of SAS Management Console 9.4 for registering Metadata, and for creating Shared Prompts, and other tasks.

Use of SAS Portal for Viewing Output and/Customer Testing of Stored Procedures.

Use of SAS ODS Graphics Editor 9.41 for Output in various Formats (HTML, etc.).

Some use of SAS Enterprise Miner Client, 13.2 for Machine Learning/ testing

Extensive use of SQL Management Studio for Querying, and Testing in SQL

Some use of Information Map Studio 4.4, mainly for testing/comparing...df

Heavy use of SAS Macros and Use of Microsoft Excel.

The position required extensive use of SAS language, SAS Macros, and SAS Procedures.

FreddieMac Inc. October 2014 to April 2015

SAS Data Flux Business Analyst

Implementation of SAS Data Flux and focusing on rules development and reporting, implementation, and support.

Experienced using Dataflux programming/configuration

Experience using SQL / PL SQL programming.

Experience with Data Warehousing.

Extensive experience in data analysis, data quality, data migration and integration, data

Enrichment, data warehousing, designing, coding, reporting, testing and support.

Experience with business analysis and with excels.

Fannie Mae Inc. September 2012 to June 2014

SAS programmer III, Specialized, Developer

Writing, developing, troubleshooting Programs in SAS.

Creating new programs as needed in SQL and SAS...

Modifying Programs in SAS, heavy use of proc tabulate, proc sql, and data step programming in SAS.

Use of SQL extensively including Proc Sql

Creating reports, Interfacing SAS with Excel, writing Shell scripts (Korn).

Analyzing data from different platforms, as needed to determine what is needed to produce the Client’s desired output.

Downloading and uploading data using SCP Scripts.

Use of MATLAB to produce the sample monthly report on Mortgage loans.

Extensive use of SAS Macros, SAS Code and Procedures like proc Tabulate, proc means, Proc Summary, Proc Reports, and most sas procedures needed for analysis.

Performing summation on aggregated mortgage data.

Producing Cash Flow and Analysis Reports (Ad Hoc) in addition to Adhoc reports... Producing production Reports that compare production to other platforms (UAT (user acceptance testing) and others).

Extensive use of Excel and ExcelOds Tag sets, using UNIX .commands, Using the ODS (output delivery system) on a regular basis.

Extensive troubleshooting and performance enhancements. Much Analysis, including impairment analysis, regression analysis, risk analysis.

Capital One Inc. McClean, VA August 2011 to May 2012

Data Analyst/ SAS Programmer/Developer

Responsibilities included:

Used SAS Enterprise Guide for Creation of EG Projects. Extensively used SAS, SQL and Excel. This role required extensive skills in SAS, SQL and other technologies. Also Identified ways to enhance performance and streamline operations.

Maintained data infrastructure for development of scripts for regular processes.

Ensured that I/O capabilities with the principal Oracle database functioned properly; Interacted with the Mainframe

Wrote SAS Code

Wrote SQL Code

Communicated and presented data in any format the Client desired to see data.

Formulated a system for seamlessly integrating all of the components together

Searched the BDW(Bank Data Warehouse) to Create reports from the Teradata repository for Ad-Hoc Reports, including Daily, Weekly and monthly Reports.

Created output for the Dash Board.

Modified the BOBJ Platform (Business Objects). Performed queries, using Teradata SQL, Against the Platform. Creating reports.

Department of Energy October 2008 to July 2011

SAS Programmer/Developer

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

Responsibilities included:

The migration of application code for the EIA-782A/B/C survey processing systems from a mainframe to PC-based environment.

Ensured that I/O capabilities with the principal Oracle database function properly; and Interacting with the Mainframe

Wrote SAS Code

Wrote SQL Code

Worked with SQL Developer and the Oracle(11g) Database

Formulated a system for seamlessly integrating all of the components together

Assisted with development and implementation of a test plan for the migrated system; and provided additional technical maintenance and ad hoc support as needed.

Assisted in SAS Systems Upgrade to Eguide Enterprise Configuration.

Developed requirements and enterprise architecture for EIA metadata, Eguide and EBI under SAS version 9.1/9.2.

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

Trained staff in EBI analytical techniques and information delivery approaches and methodologies.

Designed and deployed software engineering practices, as requested, to maintain SAS code configuration and data quality.

Created Enterprise Guide projects and stored procedures in SAS, seamlessly integrating the operations of the different modules.

Used SAS Web Report Studio, Information map Studio and other SAS BI (Business Intelligence) objects.

Extensive use of the metadata repository, SAS macros, and Enterprise Guide.

Completed Courses at the SAS institute, Rockville MD, on SAS EG and other BI modules.

Sr. SAS Programmer (epidemiological Analyst) February 2007 to August 2008

(US Army Civilian)

Conducted data queries, analysis and validation.

Retrieved, manipulated, and summarized healthcare System data from various databases, warehouses and files using Base SAS software.

Consolidated the data for reports.

Calculated healthcare metrics and performed analyses on the data. The various outputs included SAS (version 9.1) frequency reports, Excel spreadsheets, ODS database tables.

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.

Wrote SAS programs to generate epidemiological/statistical analyses (e.g. tables, listings, figures, and other Statistical output.

Performed quality review on SAS programs generated by other staff analysts.

Documented programs.

Served on assigned projects and task.

Programmed using SAS, SQL, and MS Office Suite.

Worked under Limited Supervision.

Performed Additional duties as required.

US Dept. of Labor August 2003 to 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

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.

Responsibilities included maintaining software levels and planning for future product implementations.

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).

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.

Worked on C&S/TPOPS Production and development.

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.

Designed, Coded and documented applications to meet customer requirements where SAS was an integral component of the system.

Prepared associated documentation, block diagrams, and logic flow charts.

Translated design specifications into program instructions.

Prepared, tested data and conducted test.

Formulated recommendations on technical problems with little guidance.

Loaded to SAS version 9.2 on the UNIX servers.

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

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).

Instructed, directed and monitored lower level developers and served as a SAS reference person on a development / redesign team.

UUNET Technologies August 2000 to June 2003

Senior Systems Analyst (SAS - SQL SERVER -SYBASE)

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).

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);

Mined Data, constantly manipulated the data in a high volume, production based system.

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

Integrated SAS Code with SQL+ and other languages.

Used SAS to gather data from Microsoft SQL Server for a system requiring hundreds of reports daily.

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.

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

Used Java web development Tools (J2EE, J2SE), cross platform technology and Eclipse, team studio analyzer.

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

Used the OLAP (Online Analytical Processing) to produce Sales and Marketing reports, financial reports and quality control analysis.

Produced tables, charts, summary and multi-dimensional reports for different clients.

Wrote specifications and designed and developed SAS based production applications that interfaced with the Sybase RDBMS in order to manipulate data into required formats.

Utilized SAS ETL tools (power-loader) to provide source code, migrating data and supporting process documentation for production applications.

Prepared documentation and constructed test files.

Gathered data from the data warehouse, the LAN and sometimes from Legacy (main frame) systems.

Became familiar with Informatica.

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.

Contact this candidate