Derek Bell

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

Phoenixville, PA *9460

484-***-****

acyoor@r.postjobfree.com

ADVANCED SAS/SQL PROGRAMMER/ANALYST

OBJECTIVE: Challenging position within an organization where computer skills and science knowledge will be translated into improved growth and profitability.

EDUCATION:

2005-2008 Biblical Theological Seminary

M.Div./Masters of Divinity

2003-2003 SAS Institute Wayne, Pa

SAS Programming I, Programming II,

Programming III, Report Writing, SAS Output

Delivery System and Macro Language.

1995-1997 Barry University Miami Shores, Fl

College of Podiatric Medicine.

6/1987 Shaw University Raleigh, North Carolina.

B.S./Biology

*Shaw University's Deans' List: 1985, 1986, 1987.

*Who's Who in American Colleges & Universities, 1986.

*Received Honors in Biostatistics, SAAP program at UNC Chapel Hill.

*1st Place-Special Medical Project, Fisk University Pre-Medical Institute, 1985.

EXPERIENCE:

09/30/2014 – Present Strategic Consulting Partners; NAVSUPP WSS; Systems Analyst & Trainer

* Provide over the shoulder SAS support training and leadership for WSS personnel in SAS Enterprise Guide.

*Teach WSS personnel how to read and understand SQL as well as to write queries in SQL.

* Created SAS programs that help to facilitate WSS reporting.

* Created training material for SAS Workshops: SAS EG1, SAS EG2, SAS EG3.

* Taught NAVSUP WSS personnel how to make SAS datasets, querying, filtering, modifying data, assignment variables,

summing data, counting data, grouping data, summarizing data, ordering data, making analysis variables, first., last.,

computed columns, importing and exporting data, joining data, bar charts, box charts, line plots, case expressions,

recorded columns, splitting and stacking data, production planning and SAS programming.

* Created PowerPoint training material for 8 hour SAS sessions.

* Provided training for SAS Web, Information Maps, SAS Add Ins, SAS Web reporting and SAS Viewer.

* Support SAS Issues and Web Teams to resolve problems that may occur with SAS configurations.

* Produce and run production Code that creates ERP History Generation Datasets in SAS on the server.

5/1/14- 7/31/14 Blue Cross Blue Shield via Becker Staffing, Senior Research Analyst

* Pull data from teradata using volatile tables for more than 800 million records using SQL.

* Pull data from teradata to create permanent tables in the sandbox using SQL.

* Analyze data to perform gap analysis on DX codes per provider for patients with chronic conditions.

* Analysis on patients with CKD, HCC looking at their prevalence in the enrollment population and cost to the

company.

* Worked with SAS to manipulate data and perform analysis by using macros, metadata, loops, counts and macro

variables.

* Used Pros Sql in all programming including counts, dictionary.tables, dictionary.columns, row over partition

Case Statements and more.

* Created macro variables using Call Symput and Proc Sql into statement.

* Give presentations in analytic forum.

5/14/10- 4/30/14 Aetna Inc., Senior Lead Analyst/Data Programmer

* Pull data from various data warehouses such as ATV, SRDB, and IWH with more than 100 million records.

* Modified existing code to meet he specifications of new or current clients for Plan Sponsor Reporting.

* Analyze data to ensure accuracy for client reporting, correct problems from pre-existing code, compare results to Crystal

Reports to tie out with Plan Sponsor Analyst.

* Create excel spreadsheets from the SAS code to read into Excel Macro’s to populate reports. Modify VBA code in excel

to add new plan sponsors, modify code, create counts, create YTD counts, and quarterly counts.

* Worked with rx, dx and hx data to create counts for Case Management Reporting.

* Give presentation in analytic forum.

12/02/08-5/7/10 Medecision Inc., Senior SAS Programmer/Data Analyst/Interim Team Lead

* Manage a team of 3 people to create files, RAV’s, PCS and reports for all clients monthly production runs.

* Attend company meetings interfacing with the client to improve or address production concerns.

* Automated the data analytics dept using SAS, SAS Macro, Proc SQL and ODS to create rules, validation checks and

analysis.

* Created more then 40 programs to help reduce manual labor in the department.

* Created Do Loops to check any specified number of members in the program.

* Give presentations on reports and rule creation with the client.

* Pull data from oracle via SAS with over 100 million records.

* Created SAS datasets from Oracle using SQL Pass-Thru.

01/02/06-11/31/08 Surveillance Data Inc., SAS Developer and Data Analyst/Project Team Lead

*Read in files and format data using SAS Macros using the Name? statement.

*Create macro variables using Call Symput.

*Create Do Loops that use macro variables.

*Create macro variables using Proc Sql that make counts and resolve variables.

*Use macro keyword parameters.

*Create datasets from Oracle to SAS using Pass-Thru.

*Use the INTNX function to create standard start and stop dates for Macros.

*Analyze data for business clients using Base SAS and SAS Macros.

*Create reports in SAS then use the ODS facility to put them in Excel.

*Created export macros that put all spreadsheets into one workbook.

*Created e-mail notifications in SAS to let me know when a job was done.

*Generated data using SAS macros while the job was running.

*Created counts for patients and drug utilization.

*Analyze patient that were new to market, new to brand, continuing, switched or restarted for various drug

markets.

*Analyze various drug markets for to see what the top ten drugs are in the market.

*Provide statistical analysis on the various drug market and patient data.

*Provide counts and percentages on dx data, rx data, hospital data pertaining to dx codes, cpt codes, days

supply and more.

*Performed various analysis for Novartis, Johnson&Johnson, Pfizer, Sanofi, Astra Zeneca, Boehinger & Ingleim, Glsxo-Smith-Kline, Allergan, Merck and Chimerix.

08/03/06-12/31/06 Bank of America, Data Analyst in Analysis and Information Modeling.

*Read in large amounts of records from Oracle and DB2 using SAS.

*Join tables using Proc Sql, group data, order, sum, min, max and where statements.

*Create tables using left outer joins, right joins, and inner joins.

*Create Macros to run code.

*Upload and down load data in SAS and Oracle and DB2.

*Create frequency distributions to analyze data using proc freq, proc means and proc chart.

*Lead generation for clients within and out of the Bank including Visa and Master Card, NFL, MLB, PGA and others.

*Create text files to ship out to clients.

*Perform audit process to verify accuracy of data.

*Cleanse and massage data for analysis.

*Manage projects for multiple accounts.

*Merge SAS datasets, using the IN statement, rename, drop, keep, datepart and others.

*Read in raw data using infile statement, dsd, dlm, truncover and missover statements.

*Create formats using proc format, format data using format statement,.

*Create reports using proc tabulate and proc summary.

*Used conditional logic such as if then else and if then do.

01/23/2006-8/01/06 Keystone Mercy Health Plan, Pharmacy Analyst/SAS Programmer

*Create queries in RX Focus II and import them into SAS for data analysis.

*Create SAS code that merges different data types into one dataset.

*Use Proc Sql to create left joins, check data for duplicates, order data and summarize data.

*Create SAS macros to run monthly and quarterly reports.

*Create reports in MS Excel and MS Access on a daily basis.

*Create summary reports in SAS using Proc Tabulate and reading the data directly into MS Excel using SAS ODS.

10/04/2004-01/22/2006 JP Morgan Chase Bank NA., Business Analyst/SAS Programmer

*Analyze data using proc freq, proc chart, proc gchart, proc tabulate, proc univariate and proc format.

*Extrapolate data from oracle databases using SAS Access while on UNIX platforms.

*Performed underwriter analysis on ACAPS and RCO data from MS Access by connecting to Sybase.

*Update the LAR using SAS code and checking for the integrity of the data.

*Manipulate data from excel, text files, .dbf format and MS Access into SAS using proc import.

*Created MSA analysis and DEC for the quarterly presentations.

*Updated the Zippy data on a monthly basis in MS Access and then created a dataset in SAS for analysis.

*Trained new statistical analyst in SAS techniques and methods.

*Created Bad Address report and Report Type 3's for HMDA analysis.

*Create HMDA pooling reports on a Ad hoc basis.

*Created SAS code for Denials Analysis by merging different types of data into one dataset then adding the analysis

code.

*Created macros for analysis of data.

*Join datasets using proc sql.

*Get data from Oracle database using Proc Sql

*Create reports in Excel and MS Access.

*Combined 3 different LARS for OCC Analysis by ssccctract.

*Created HMDA data for OCC Analysis in submission Lar format from the SuperLar.

*Created SAS code for LMI_INFO dataset and analysis using proc sql.

*Created various ad hoc reports for other departments using SAS and analysis skills.

*Created LMI eligible file by creating SAS code and analyzing data for the LMI subsidy.

*Trained in using RATA COMPLY for HMDA and creating Q&V Reports and Edit checks.

*Read raw data into SAS by creating SAS code.

*Export data into excel using .xls or .csv file formats.

09/23/2003-11/30/03 Manpower Professional/Fleet Credit Card Services, SAS Programmer

*Created queries in SAS searching databases in Oracle, Unix and SAS between 2 and 12 million records

searching for credit card fraud. These queries included using the following statements; Set, Index,

Compress, Length, Day and Date, InTick, Like, In, Rename, If then, Else Do, Greater then, Less then and

many others.

*Created data sets in SAS via concatenation, merge statement, var statements, proc transpose, file

statements and Proc SQL.

*Formatted data in SAS using Proc Format to create a list of directories for the various Fleet Business units.

*Used Analysis statements; Proc Freq, Proq Means, Proc Univariate and Proc Tabulate to find percentages,

averages, maximum, minimum.

*Created Reports in SAS using Proc Report including define statements, width, right,left and compute. Also

created tables in MS Access, joins, forms and reports.

*Calculated numerical data including totals, addition, subtraction, division.

11/6/2000-03/31/03 Questdiagnostics, Client Server

*Created formatted list and column input to read raw data files in SAS.

*Used infile statement options to control processing when reading raw data files in SAS.

*Used various components of an input statement in SAS to process raw data files including column and line

pointer controls.

*Combined SAS data sets using the data step such as concatenation and merging.

*Created data Step statements to export data to standard and comma delimited raw data files and

Controlled which observations and variables in a SAS data set are processed for output.

*Managed SAS data such as modifying variable attributes using options and statements in the data step (var

statement, length etc

*Used SAS functions to manipulate character data, numeric data, and SAS date values (put and input

statements).

*Generated list reports using the print and report procedures. Also created summary reports and frequency

tables using base SAS procedures(proc freq, proc means, proc tabulate).

*Identified and resolved programming logic errors, recognized and corrected syntax errors and Examined

and resolved data errors.

*Provide Tier 2 Support by troubleshooting and resolving technical software problems on Windows 2000,

Windows NT Service Pack 6, Microsoft Office 97, Internet Explorer 5.0, 4.0, PeopleSoft Financials,

National Billing System, Rumba, SMS, PowerTerm, Applix, Clarify, Peregrine, Crystal Reports, VMS,

Toplab,Interfaces (Cerner, Sun, MediTech), Lotus Notes, MS Exchange ATTRAS and Microsoft Access.

*Created Database in Oracle 8i, developed coding skills in SQL Plus and worked in DBA Studio.

*Developed ON Call Tracking Database and Call Tracker in MS Access for the NSC.

*Created Tables, Relationships, Queries and Forms in MS Access.

*Created Forms and Writing Code in Visual Basic and SQL. Connected them to the ODBC which linked

them to MS Access Database.

*Reset passwords in NBS and NT, unlocked accounts in NT.

*Assisted users in troubleshooting Dial-Up Networking.

*Mapped drives and performed software upgrades.

*Troubleshooted problems for printers, laptops, monitors, cd-roms, floppy drives and reinstalling printers

*Provided On Call Support after hours.

10/1999 - 10/2000 Genesis Health Ventures, Customer Service Analyst

*Provided Tier 1 support by troubleshooting and resolving technical software problems on Windows 95 and

98, Microsoft Office 95 and 97, Internet Explorer 3.0, 4.0, 5.0, Netscape Navigator, AS\400, Peoplesoft and

Oracle, MDS, Vitalsystems and Unix.

*Learned Computer Based training for PL\SQL, Software Lifecycle and Mentality of a DBA.

*Mapped drives and performing software upgrades.

*Served as a Project Manager for Background America and Genesis Policies and Procedures, Outlook Web

Access and escalated calls within the helpdesk.

*Troubleshooted hardware problems for printers, laptops, modems, PC's, Monitors, CD-Roms, back-up

drives, dial up networking, hardware configurations and installing printer drivers.

*Managed E-Mail and Voice Mail systems and provided on call support after hours.

*Supported Windows NT, User Manager, LAN\WAN with Windows 95 and 3.1.

*Created Tips and Tricks for Background America and Genesis Policies and Procedures, Outlook Web

Access and others.

*Trained new Customer Support Analyst to work at the Helpdesk.

5/1998 - 8/1999 Pyxis Corporation, Application Specialist

*Project Manager responsible for a 4 million dollar territory that I helped increase in growth.

*Presented detailed status reports to Hospital Boards, Pharmacy Directors and Nursing Directors.

*Installed the Pyxis Database in pharmacies and Pyxis stations throughout the hospital.

*Trained pharmacy staff and nursing staff how to use the Pyxis stations and database.

*Project Management with emphasis on troubleshooting, technical support, customer service and software (Microsoft Windows 98,95,3.1, Excel, Word, 0S2, Novell, DOS).

*Responsible for managing new and existing accounts, maintained account summaries and the coordination

of client resources.

*Setup various communication methods (Networks/TCPIP, Modem and RS).

*Installed/troubleshoot motherboards, networkcards, RS cards, floppy drives and Hds.

*Performed upgrades to various software and hardware systems.

Contact this candidate