OBJECTIVE:

• Seeking aSAS ProgrammerAnalyst position.My strengths include being able to not just pull the required data using languages such as SAS and SQL, but to make sense of it and turn it into useful information so that I can present it in a form that is easily understandable to its intended audience. This includes a variety of audience types, such as Senior Management, Business Analysts and other stakeholders throughout the organiation.
• Certified Base Programmer for SAS 9 -Currently preparing for Advanced SAS Programmer exam.

WORK HISTORY:

• Confidential Programmer/Analyst contractor for Teksystems
• Charles Schwab, Analytics, Insight Loyalty / Business Solutions
• Ran Monthly and Weekly SAS Reports included using Excel Pivot Tables and Think-Cell software for inserting pivot tables into PowerPoint slides that included customer Cash Inflows and Outflows on their brokerage accounts. Calculations were also made that captured Inflows and Outflows as a percentage of customer statement equity to classify the customer as either a Spender or Saver for example. In all, there were a total of I0 classifications that I created and analyzed
• Worked on Persistency Project to measure how often customers were in each of the 10 classifications I mentioned above. Much of this involved converting data using Proc Transpose, then ProcUnivariate to measure variable Percentiles and other metrics
• Wrote detailed documentation/procedures for these reports.

Confidential

Risk Analyst contractor for Signature Consulting

• Wells Fargo Bank, Risk Management Department / On-Line Fraud Unit
• Using Proc SQL Pass-Thru, queried Teradata tables for potential on-line fraud transactions and determined current Fraud trends and identified fraud cases
• Created ad-hoc and production Fraud Reports. Risk Indicators include logons from multiple IP Addresses when the customer resides in the United States. Most of these reports are output using ODS Excel Tagsets. Unix Crontab is used for scheduling the production reports.

Confidential

SAS Programmer contractor for Computer Aid Incorporated

• Highmark Blue Cross / Blue Shield of Pennsylvania Informatics Department
• Wrote SAS programs against clinical data for the purpose of generating Patient Centered Medical Home PCMH Dashboard reports for use by senior management and outside clients
• Created Scorecard reports from PCMH data using SAS code that included macros and the creation of SAS format libraries
• After creation of scorecard data sets, I then performed QA and analyzed the data against established PCMH Scorecard and Dashboard business rules before releasing the data to internal Senior Management and external Medical Groups stakeholders
• Interfaced with both internal and external stakeholders to standardize clinical data business rules that were then transformed into SAS code.

Confidential

Intermediate Analyst/Developer

Worked on SAS/SQL code related projects and Ad-Hoc reports that supported departments throughout the enterprise. Data were obtained from a variety of sources, including Data Warehouse including claims, membership and revenue, and pharmacy data marts located in Oracle tables . I performed different types of analysis on it, including time series testing and regression analysis. I then wrote up a summary on it and passed it on to Senior Management and/or the stakeholder department that requested the data Provided technical support to SAS and Business Objects users throughout the company as well, mainly assisting with optimizing SAS code and SQL queries PROC SQL pass-through, connect to Oracle and the use of the Oracle Explain PlanUtility Oracle Query Optimizer Utility . Wrote code for the UAT testing portion of SDLC and also performed QA on the test data, comparing it to production. Most of my work in this area was performed due to a new claims source system being implemented at Blue Shield, and verification had to be made that the new data was ending up correctly compared to the legacy system that was being replaced in the company Data Warehouse back-end , after ETL from the claims front-end source operational system FACETS . Performed code testing and UAT with Business Objects when Blue Shield converted to the BOXI Webi platform from an older version of Business Objects and SQL code had to be modified in order for the legacy programs from the prior Business Objects version to be able to run correctly. This also included assisting UAT testers to help run their legacy programs/reports against the new Universes in BOXI MaintainedBusiness Intelligence's BI portion of the HP Service Manager internal ticket tracking request project system.Wrote SAS reports that captureddata from the HP Service Manager system, then I used this data for Time Series Forecasting and wrote reports on my analysis of the data that included current trends and forecasting. Performed training of company staff in SAS and SQL programming.

Confidential

Senior Consulting Data Analyst

Worked as lead on major Pharmacy data project. Extracted and analyzed data and reported on cost outliers on Pharmacy prescriptions that numbered in the millions of records. Responsible for maintaining and updating the Zip code Residence Area Master ZRAM system. ZRAM consists of north and south mainframe format libraries, VSAM files, and the CAZM file. CAZM is an Excel file that uses the same source file as ZRAM, and maps every California Zip code to a facility member residence area. I also wrote detailed documentation on this system as well. Write SAS including PROC SQL code to generate membership, utilization and financial monthly production reports and data sets. Create utilization and membership ad-hoc reports by writing SAS programs that extract selected data from DB2 table views, flat files, and SAS data sets. SQL code is also written using the QMF Mainframe Utility for extracting selected data from DB2 table views as well.