SUMMARY:

• Dedicated and enthusiastic expert SAS analyst with over 10 years of experience.
• Works with client/customer in solution driven approach with concentration on scope objectives.
• Enjoy being task focused using best practice techniques to achieve timely completion.
• Key elements include strong small project implementation, process redesign, data cleansing, and algorithm development.
• Experienced with efficient large dataset (10,000,000+ records) process techniques.
• Managed frequent production changes to large statistical performance reporting system (over 7,000+ code lines) for major airline.
• Ensured time critical report availability from large multi - dimensional database.
• Developed methodology to substantially increase prescreens execution in large financial services company.
• Used criteria based script process to validate marketing manager campaign requirements.
• Provides consistent and reliable results that meet customer requirements.
• Works with others input that assures tasks are within costs and timeline parameters.
• Takes ownership attitude toward all work.
• Completed several SAS Institute classes which include advance reporting, SQL with relational database, ODS, and advance macro/data step and efficiency techniques.
• REXX scripting. Perl regular expressions. UNIX. Expert MVS/TSO

TECHNICAL SKILLS:

Languages: Expert Base SASv9.4 Macros ODS HASH SAS AF FSP STAT SQL ACCESS SAS Graph Perl, Intermediate REXX, COBOL, Python and C knowledge

Application Software: Microsoft Word, Excel, PowerPoint, Access

Operating Systems: Expert MVS/TSO JCL, FileAid, Windows XP, UNIX knowledge

Relational Databases: DB2, SQL Server 2008, Oracle

Network Communications: FTP, NDM NORC seminar on HADOOP essentials parallelization with pig and hiveQL SAS Data Loader

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Programmer Analyst

Responsibilities:

• Automated high priority critical questionnaire cleaning. Replaced unwieldy error prone manual spreadsheets which often delayed client delivery. Inserted auto-generated code from access tables. Demographic back coding used same approach. My rework became standard method.
• Rescued nonperforming employee skills matrix tracking response system. Wide response master record containing over eight thousand variables. My techniques ensured timely availability, dramatic run time reduction, rapid table report changes.
• Implemented project specifications derived from large scale national data collection platforms. Extracts from SQL Server databases concerned national demographic tables to SAS datasets. Millions records were extracted by code frame reference. I employed macro automation to generate SQL code. My role consulted with survey analysts on new derived variables used their statistical analysis.
• Developed automated data type conversions from multiple SQL tables and file types to project standard aggregation. This greatly helped analysts deliver consistent consolidated reports.
• Core team member that collaborated with research analysts and statisticians.

Confidential, Mettawa, Illinois

Business Information Analyst

Responsibilities:

• Developed large scale campaign tracking program to validate/correct production feedback tracking system. Improved several name/address soft key matching algorithms used in DNS and CE lists. Redesigned prescreen criteria program to thoroughly find risk elements. Developed several waterfall reports compliant with updated mailing requirements.
• Developed prospect list programs that confirmed marketing segmentation strategies. QA Conduct code review with other analyst program specifications. Maintained interactive consultative relationship with marketing team on continuous process improvement.
• Implemented automated script method which enabled rapid multiple execution from source list segmentation validation to back-end load applications and tracking systems. This resulted in weekly measured gains by 400% over previous manual step submissions.
• Validated propensity models that selected best prospects for preapproved mailing. Ensured cost effective selection of likely responders. Designed reporting structure for CRM and marketing team sign-off confirmation of selection process.
• Converted legacy general ledger account COBOL copybook file and working storage business rules to SAS data marts. Enabled fast end-user turn around to customized solutions. Satisfied client requests to transform mart data to enterprise presentation tools and databases.

Confidential, Elk Grove Township, Illinois

Programmer Analyst

Responsibilities:

• Provided extensive tabulate reports across multiple levels with SAS Graphs presenting operating measures via parameter macro generation.
• Gathered customer requirements using SDLC methodology to test, review, and move to production.
• Used parallel processing grid computing techniques to improve resource utilization and faster turn times across mainframe and UNIX platforms.
• Developed ETL programs to compare against vendor supplied solutions bulk load to operations data warehouse.
• Redesigned as process improvement COBOL code for cost and resource utilization for flight performance to SAS application. This allowed rapid response update to summarization level changes versus time consuming UAT production previously used.