EXPERIENCE SUMMARY:

SAS Development - 10+years Industries: Banking/Finance/Mortgage, Utilities (Power and Phone Transmission)Airline, Health Insurance, Pharma, Software

TECHNICAL SKILLS:

IBM Mainframe, Unix, NT and PC environments.: SAS, SAS /PC, Macros, Data Null, DDE, XML, SQL SAS Procs: SQL, Means, Summary, Freq, Print, Printto, Sort, Tabulate, Plot, Chart, Report, Copy, Datasets, Contents, Univariate, Format, Univariate, Corr, Reg, JCL and Utilities, TSO, Teradata, ISPF, DB2, COBOL, Assembler, FOCUS, Unix Scripts, SQL Assistant, Putty, Toad, Quality Center, Queryman, Oracle, Exceed,, DB2, Rumba, Perl, and C. Other software used: MS Word, MS Excel, MS Project, MS Access, Peregrine, FTP, CDR, Visio, Kermit, Lotus, and WordPerfect.

EXPERIENCE:

Confidential, West Des Moines, IA

Principal SAS Programmer

Responsibilities:

• Plans, develops, tests, and documents highly complex application programs and their results. Generates new code and corrects, converts, and/or modifies existing code to meet specifications.
• Unix and PC environments
• SAS, SAS /PC, SAS 9.3(Procs: SQL, Freq, Print, Printto, Sort, Datasets, Contents, Format, Univariate, Report, Summary, Means), SAS Macros, ODS, DDE, and Data Null. Also Sun Microsystems SunOS 5.10 and file transfer.

Confidential, Bloomington, IL

Sr. SAS Programmer

Responsibilities:

• Planned, developed, tested, and documented highly complex application programs. Generated new code and corrected, converted, and/or modified existing code to meet specifications. Mapped data to existing data structures.
• IBM MF, TSO ISPF, JCL, and PC environments
• MF SAS, SAS /PC, SAS 9.3 (Procs: SQL, Freq, Print, Printto, Sort, Datasets, Contents, Format, Univariate, Report, Summary, Means), also SAS Macros, ODS, DDE, and Data Null.

Confidential, Chicago, IL

Sr. SAS Programmer/Consultant

Responsibilities:

• Re-engineered, automated, tested, and implemented the test analysis for the Confidential 's DAT.
• Temporary assignment to fix existing code that wasn't working according to specifications.

Environment: Windows 7, Aptify, SQL, SAS 9.3(Procs: SQL, Freq, Print, Printto, Sort, Corr, RegDatasets, Contents, Format), also SAS Macros, ODS, and Data Null.

Confidential, Coppell, TX

Sr. SAS Programmer/Consultant

Responsibilities:

• Developed, tested, and implemented Testing and Tracking applications for Migration project from DB2 to Teradata.
• Automated the validation of the database data and the results of queries from DB2 and Teradata.

Environment: Windows XP, TO ISPF, JCL, Unix, DB2, Teradata, SQL, SAS 9.2(Procs: SQL, Freq, Summary, Print, Sort,Datasets, Contents, Format), also SAS Macros, Data Null, SQL Assistant, Putty, Toad, Quality Center.

Confidential, Chicago, IL

Sr. SAS Programmer/Consultant

Responsibilities:

• Developed, tested, and implemented data cleaning applications.
• Performed programming tasks including program design, coding, debugging, and documentation.
• Designated as a BLS agent.

Environment: Windows XP, MS ACCESS, SQL, SAS 9.13-9.2(Procs: SQL, Freq, Summary, Print, SortDatasets, Contents, Format), also SAS Macros, Data Null.

Confidential, Middleton, MA

Sr. SAS Developer/Consultant

Responsibilities:

• Developed, tested, and implemented MDI software product code on multiple platforms.
• Performed programming tasks on MDI including program design, coding, debugging, and documentation.
• Proposed and implemented design changes for MDI.
• Designed and authored documentation for ease-of-use and consistency for MDI.
• Coordinated MDI development-level testing of entire applications, verifying, tracking, and fixing "bugs".
• Worked on multiple programming and testing projects concurrently.

Environment: Unix, Windows XP, Oracle, DB2, SQL, SAS 9.13-9.2 (Procs: SQL, Freq, Summary, Print, Sort, Datasets, Contents, Format), - also SAS Macros, Data Null, Interix, Prism, Putty, MS Excel, Word, and Outlook, SqlDeveloper, Oracle SQL/Plus Editor,VI Editor.

Confidential, Charlotte, NC

SAS Consultant/Business Analyst

Responsibilities:

• Provided production support for various financial files, databases, and reporting systems.
• Analyzed, designed, developed, tested, and implemented new enhancements of existing financial systems.
• Developed utility SAS programs on UNIX.
• Lead Business Analysis and SAS Developer for the Auto Loan enhancement process for the Profitability Engine from analysis through implementation.
• Tracked profit and expenses on monthly basis for Profitability Model on products like credit cardauto loans, trusts funds..

Environment: Unix, Windows 2000, SQL, SAS 9.13 (Procs: SQL, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate), AF, ODS, OLAP - also SAS Macros, Data Null, Informix, Oracle, Teradata, Peregrine, MS Excel, Word, PowerPoint, Visio, FTP, and Lotus Notes.

Confidential, Renton, WA

Sr. SAS Developer/Consultant

Responsibilities:

• Defined, designed, developed, tested, and maintained SAS programs for Airplane Reliability and Maintainability System using Spec2000 guidelines.
• Lead design reviews, definition and testing sessions.

Environment: IBM z/OS, TSO ISPF, JCL, Windows 2000, SQL, SAS 9.13(Procs: SQL, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate) ODS, - also Macros, Data Null, XML data/XML Mapper, Teradata, Rumba, JCL, MS Excel, Word, PowerPoint, and Visio.

Confidential, McLean, VA

Sr. SAS Developer / Consultant

Responsibilities:

• Developed, tested, maintained SAS programs for financial reporting for the RCA and Single Class initiatives.

Environment: SUN Unix 5.8, IBM MVS, TSI ISPF, JCL, Windows 2000, SQL,SAS 8.2(Procs: SQL, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate) ODS, - also Macros, Data Null, DB2, MCM, FTP, JCL,Unix Scripts, VI-editor, MS Excel, Access, Word, Exceed.

Confidential, Elk Grove Village, IL

Sr. SAS Developer/Analyst/Consultant

Responsibilities:

• Mapped SAS fields in SAS programs to DB2 fields.
• Documented existing SAS programs processes and their inputs/output for conversion to other interfaces to an UDB/DB2 datamart.
• Supported existing SAS programs in Sales Dashboard application.

Environment: HP Unix, SAS 9.1(Data step, Procs: (SQL, Sort, Print, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate, Means, Rank), ODS, Macros, Data Null, FTP, MS ExcelMS Word, SAS PC 9.1.

Confidential, Downers Grove, IL

SAS Developer/Consultant

Responsibilities:

• Converted IBM MF SAS Programs to Unix environment.
• Mapped the IBM MF files/fields to Oracle DW tables/fields.
• Developed ad hoc SAS programs for financial and risk reporting.

Environment: IBM MVS, TO ISPF, JCL, HP Unix, SAS 8.2(Procs: SQL, Sort, Print, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate) ODS, - also Macros, Data Null, Oracle, FTP, MS Excel, MS Word, UltraEdit, Rumba 5.2b, KeaTerm 420 v5.1, TOAD.

Confidential, Charlotte, NC

SAS Developer/Consultant

Responsibilities:

• Built the programming infrastructure using SAS and SQL for a marketing campaign decision support system.

Environment: PC/SAS, Unix, SAS 8.2(Procs: SQL, Sort, Print, Freq, Summary, Print, Sort, Report, DatasetsContents, Format, Tabulate) ODS, - also Macros, Data Null, Teradata, FTP, MS Excel, MS Word, Visio.

Confidential, McLean, VA

SAS Developer/Consultant

Responsibilities:

• Developed, tested, maintained SAS/DB2 programs for financial reporting for the Reaudit and Disclosure initiatives.
• Provided training to new consultants on the business systems, system resources, and access and utilization f FAS140 databases and CDW.

Environment: NCR Unix, IBM MVS, TSO ISPF, JCL, Windows 2000, SQL,SAS 8.2(Procs: SQL, Freq, Summary, Print, Sort, Report, Datasets, Contents, Format, Tabulate) ODS, - also Macros, Data Null, DB2, Command CenterFTP, JCL, Unix Scripts, VI-editor, MS Excel, Access, Word, Exceed.

Confidential, Irving, TX

SAS Developer/Consultant

Responsibilities:

• Developed marketing lists for various campaign initiatives using SAS from Oracle, Teradata, and outside sources such as D&B.
• Provided quality control and/or assurance for the computer program development including code review and adherence to marketing and legal requirements.

Environment: NCR Unix, IBM MVS, TSO ISPF, JCL, Windows NT, SAS 8.2(Procs: SQL, FreqSummary, Print, Sort, Report, Datasets, Contents, Format) ODS, - also Macros, Data Null, Oracle 8i, Teradata, FTP, Unix Scripts, VI-editor, SuperEdit, MS Excel and Word.

Confidential, Long Grove, IL

Data Mining Technical Analyst

Responsibilities:

• Performed systems analysis, design, and development and testing (using SAS) for current and new business systems with data FTPed from mainframe and D&B.
• Identified and mapped data and business processes using Visio.

Environment: Windows NT, IBM MVS, TSO ISPF, JCL, Unix, SAS 8.2(Procs: SQL, Summary, Means, Freq, Print, Printto, Sort, Report, Datasets, Contents, Format) - also Macros and Data Null, MS Excel, MS Word, and MS Project, Visio, FTP.

Confidential, Hoffman Estates, IL

SAS/Data Warehousing Specialist

Responsibilities:

• Lead the programming initiative using SAS in analyzing Telephone
• Usage data from Teradata datamarts for various marketing strategies.
• Developed SAS programs for the Telephone Usage marketing initiatives.
• Developed adhoc SAS programs for marketing, financial, and legal requests.
• Performed systems analysis, data modeling, design, development, and testing for DSS data warehouse.
• Completed the detailed Usage Source System Design Specifications and Transformation Specifications for all releases.
• Worked with Source System teams to ensure accuracy and timeliness of feeds.
• Participated in the development of the dimensional and physical data models for telephone usage.
• Assisted in the planning, review, creation, and modification of Perl and PL/SQL Stored Procedures modules.
• Ensured quality by executing detailed documented unit test plans.
• Supported the establishment of the FT DSS Production environment and the migration of Revenue prototype.
• Designed, developed, and implemented Autosys scheduling for initial version.
• Created/updated system documentation for system modifications and enhancements.

Environment: NCR Unix, IBM MVS, TSO ISPF, JCL, Windows NT, SAS 6.12(Procs: SQL, Summary, Freq, Print, Printto, Sort, Report, Datasets, Contents, Format, Copy, Tabulate)-also Macros and Data Null, Teradata, OraclePerl, Kermit, CDR, MS Excel, MS Word, MS Project, and MS Access.