TECHNICAL SKILLS:

Languages: SAS v9.3, SAS Macro, SQL & Proc SQL, Unix Shell ScriptingSAS Enterprise: Guide 5.1, SAS/Warehouse Admin., PC SAS, SAS/SHAREAS/Access, OLAP Tools, SAS/ETL Warehouse, SAS/DatafluxSAS EBI Suite (Enterprise Guide, Information Map Studio, Data Intergration Studio, Information Delivery Portal, Add - In for MS office, Management Console)

Databases: Oracle 9I, DB2, Teradata, IBM Netezza, MS Access, FDR Financial databases, SAS/WarehouseStar Schema data warehousing, BI Query, Erwin tool.

Reporting tools: such as, MS Excel, Brio Reporting Query Tool, Business Objects/Desktop IntelExperience in Business Intelligence in Telecom, Finance Banking, Marketing, Healthcare and Manufacturing

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Developed in SAS 9.3 a MAC Source Data ETL process to read-in third party raw data
• Converted a existing MS Access Recovery Audit Contractors suppressions list process to a SAS Enterprise Guide ETL process.
• Creation of Business Objects Desktop Intelligence query extracts.
• Utilized Netezza and Teradata SQL-Pass Thru queries to directly hit our CMS related databases
• Working knowledge of National Claims History (NCH) database.
• Creating SAS macros to perform monthly and or daily related reporting needs.
• Daily routines of quality control testing and performing internal data request when needed.
• Proficient knowledge on a Citrix virtual desktop environment.
• Utilizing SAS Output Delivery System to generate proper output to internal customers.
• Writing SAS Perl expressions to accommodate inbound messy files.
• Primary Data Lead (PDL) to our One - PI SAS Large Data Extract Process

Confidential

Senior SAS Statistical Programmer/Analyst

Responsibilities:

• Developed and maintain daily SAS reports for various internal resources.
• Performed financial and behavioral analysis phases of business operations related to sub-prime lending industry.
• Developed automated and/or scheduled monitoring systems that collect data, analyze the data.
• Designed, developed, and automated analytical and reporting systems to “commoditize” both internal business studies and external client portfolio management functions

Confidential

SAS Business Intelligence Architect

Responsibilities:

• The developing & managing of the SAS EBI Daily Flow ETL Processes thru SAS Management Console.
• Utlilize data cleansing techniques to import 3rd party incoming data feeds in various formats.
• Developing processes thru SAS EBI Data Integration Studio such as Fact Tables / Dimension Tables / Lookup Tables.
• Maintain the performance of the SAS Web Portal by modifying existing Stored Process jobs.
• Optimize and maintain the performance of the Stored Process Server & Workspace Server.
• Create new EBI Data Integration Studio flows which are used in the daily production loads.
• Maintain our SAS Dataflux data cleansing jobs in also perform updates when needed.
• On call support with our global clients when needed.

Confidential

SAS Programmer Analyst

Responsibilities:

• Worked with Business Managers & Analyst on developing Medicare & Medicaid Data Quality Claim Reportsn an quarterly, monthly, daily basis.
• Write ETL Load Process to create Oracle 9I tables from a 3rd party Vendor
• Developed Quarterly Provider Network Adequacy report which was based on being able to tell the state of how many in providers specialist are in are network within a county and or zipcode. Also the report was detailed to tell the state if a provider was accepting new Confidential ts and if the provider was a true term. . Also the report associated with a monthly report that listed specialist counts on providers leaving are network in new additions coming to our network.
• Developed Pharmacy Lock-In Process that told the business managers if a member was taking multiple controlled substance prescriptions to multiple pharmacies in which the prescription was from multiple providers within a 30 day calendar period. If so the company would lock-in that member to 1 pharmacy location to prevent fraud and abuse.
• All reports request made the use of SAS output delivery system in formats from comma separated to adobe pdf . using multiple proc steps such as tabulate, report, summary .

Consultant

Confidential

Responsibilities:

• SAS Programmer, SAS Data warehouse Developer, Business Intelligence Developer
• Working in conjunction with the marketing business analysts and senior level management to develop / enhance programs
• Writing BASE SAS data step programs which update / merge data from existing master tables
• Developed Project Plans on upcoming campaigns
• Worked in a SAS/Warehouse relationship database in also Oracle 8I,9I .
• Created/Utilize Proc SAS Steps & SQL for certain types of delivery or output
• Creation of SAS/Macros on daily ETL Processes
• Writing SQL/SAS programs to do data extracts from Oracle Databases
• Using the latest tools in SAS version 8.2, such as the Enterprise Guide
• Utilizing other resources such SAS Exceed for windows and SAS Warehouse ETL tool to build the Customer Data warehouse
• Programming environment is standard Unix VI environment
• Using Online Analytical processing (OLAP) for multiple Business Intelligence projects
• Develop ETL processes to do initial, daily, gap load, data loading, Write Unix shell scripts, Using SAS/Warehouse Administrator, SAS/Share Server, SAS/FSP server.
• Maintains SAS Warehouse Administrator, update paths, support SAS Dashboard and EIS reports.
• Develop customer campaign projects for email reminding.
• Churn analysis, revenue analysis using SAS/Stat, SAS/GRAPH
• Build OLAP cubes using SAS MDDB and Microsoft SQL Server OLAP builder
• Data warehouse Dashboard Design, coding, using SAS Application Developer, SAS WEB/AF to display report on Intranet with drill down graphs.
• Enterprise Guide Setup, build and run Windows SAS/EIS reports
• Closely communicate with Marketing, Financing, Revenue Analysis Team to discuss business requirements, analysis requirements

Confidential

SAS Programmer

Responsibilities:

• Develop monthly / weekly programs in either SAS ver. 8.0 or Visual Basic ver. 6 from DB2
• Performed programming conversions using JCL to extract data
• Created weekly / monthly production internal reports
• Conducted ad-hoc reports on a weekly basis.
• Utilized a vast majority of SAS proc steps such as Proc Report, Proc Means, Proc Tabulate
• Conducted Brio-Query Reports until conversion is finished then I will be utilizing SAS Enterprise Reporter.

Confidential

Senior Software Programmer / Developer

Responsibilities:

• Developing electronic catalogs for window companies and also industrial retail stores
• Used Visual Basic 4.0 & 6.0 as the software language
• Other responsibilities include maintaining the Design System Interface, which is used as the main utility throughout Confidential stores.
• Also being part of a design group I’m able to make suggestions to how a customize a particular catalog such as should a catalog be best written using 16-Bit or 32-Bit environment.
• Worked directly with a Project Manger which enables me to develop a clear communication between the business services which benefits my development IT duties.

Confidential

Consultant Computer Programmer

Responsibilities:

• Created Ad-hoc reports when needed. This was a Unix environment, which enables to utilize Unix scripting to achieve a higher performance for a particular program
• I also wrote Visual Basic code (background of Excel Applications) to allow data transfers from a Unix environment to a MS Windows environment
• I utilized SQL scripts to give me the opportunity to create tables in Oracle 8.0. I also used Base/SAS utilities and SAS/Macros, wrote my own SAS data sets and wrote SAS/SQL programs to test the consistency of data
• The SAS tools that I utilize are Proc Steps, Proc Print, Proc Freq, Proc Tabulate, Proc Summary & Means

Confidential

SAS Programmer

Responsibilities:

• Producing daily operations reports using a Lotus 1-2-3 and Excel/Visual Basic
• Programming SAS DataSets and writing SAS Macros and a Unix environment
• Installing VB/MS office programs throughout the bank
• On call support via a help desk routine for my programs