SUMMARY

• Experienced SAS programmer through versions 9.4
• Skilled at interfacing SAS with other Languages/Technologies
• Experienced with SAS DataFlux, DB2 and Sybase Databases
• Experienced in ORACLE Forms and Reports, all versions
• Experienced with Sybase (12, 12.5 etc) and intergrating SAS with Sybase
• Excellent SQL Programmer including PL/SQL, procedures and functions
• Exceptional at debugging and analyzing existing code and upgrading
• Very good with Excel and entire Microsoft Suite
• Great with UNIX/LINUX and writing/using Shell Scripts
• Experienced SAS DATA Step/Macro programmer
• Experienced in SAS 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
• Experienced with Mainframe SAS (IBM VM and MVS).
• Familiar with SAS ACCESS to ORACLE/UNIX/CMS/MVS (IBM Mainframe)

WORK EXPERIENCE:

Sr SAS Developer/Statistical Data Analyst

Confidential

Responsibilities:

• Developed and tested software programs in a production environment that required a good working knowledge of the syntax, capabilities and limitations of the programming language and operating system under which it operated.
• Performed Statistical Analysis on Data Collected including Regression Analysis, Time Series Analysis, Multivariate Analysis(using multiple outcome variables), and Survey Development and Reliability/Validity Testing(For the CPI(Consumer price Index) and PPI(Producers Price Index) Surveys.
• Designed, Analyzed and Developed Web-based Report Systems in support of The Consumer Expenditure Survey Program(CE). Much of the Analysis data for Geographical Analysis and Market Analysis(Including some Economic Data) was from the FPDA(Federal Procurement Data System) as well as data from the Census Bureau.
• Worked with US Census Bureau for Data and Specifications on the Collected Data.
• Created new programs as needed in SQL, and SAS Using SAS 9.3 and 9.4.
• Modified and Implemented, Tested and Upgraded SAS and SQL programs. .
• Verified that software meets/exceeds Customer requirements.
• Use of Linux/Unix extensively, including shell scripting.
• Engineered Application Architecture associated with client network and computer environments.
• Wrote and Maintained program documentation.
• Improving the performance of delivery systems which include oracle, SAS, and Sybase. t.
• Downloaded and Uploaded data From/To different Platforms.
• Provided requirements Analysis work products for client’s systems such as Use Cases and Use case Surveys for IT systems That we are developed.
• Extensive use of SAS Macros, and SAS/SQL Code and Procedures.
• Developed test cases and test scripts to perform acceptance and integration testing.
• Prepared Customized Reports and Presentation Material for the Client.

Confidential

Senior SAS BI Developer/Data Analyst

Responsibilities:

• Extensive Use of Base SAS 9.4 For Coding and Testing according to Rules and Specifications, laid out by Employer, and for Reporting.
• Extensive Data Collection and Statistical Analysis of Data including Mean, Median, Standard Deviation, etc.
• Quantitative Analysis of Sample data Collected and Report Production.
• Created Graphics Report using SAS Graph, and The ODS Output Delivery Systems suite.
• Use of SAS Logon Manager
• Use of SAS Web Report Studio.
• Extensive use of SAS Business Intelligence Platform including 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
• Extensive use of SAS Intranet
• Heavy use of SAS Macros and and SQL. Use of Microsoft Excel.

Confidential

SAS programmer III, Specialized Developer and Statistical Analyst.

Responsibilities:

• Wrote, developed, troubleshot different Programs in SAS.
• Created new programs as needed in SQL, and SAS.
• Analyzed Mortgage performance Data and produced Charts/ Tables on results.
• Interpreted Analytical Reporting Results for determination of best Data Model fit.
• Modifying Programs in SAS, heavy use of proc tabulate, proc sql, and data step programming in SAS.
• Use of SQL extensively including Teradata SQL and Proc Sql for SAS.
• Extensive use of Unix/Linux Commands(they are same for unix/Linux).
• Created reports, Interfacing SAS with Excel, writing Shell scripts (Korn).
• Analyzed data from different platforms, as needed to determine what is needed to produce the Client’s desired output.
• Downloaded and Uploaded 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.

Data Analyst/ SAS Programmer/Developer

Confidential

Responsibilities:

• 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
• Use of SAS Intranet for outputs in html.
• 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.

Confidential

SAS Stistical Analyst/Programmer/Developer

Responsibilities:

• 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
• Used Unix and shell scripting.
• 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, SAS Intranet 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.

Confidential

Sr SAS Programmer

Responsibilities:

• 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 HCPCS codes.
• 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 using ICD9-ICD10 CODES.
• 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.

Senior Developer/Analyst/Programmer

Confidential

Lead Programmer/Developer

Responsibilities:

• Ran SAS in multiple UNIX environments as well asstand-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.