EXPERIENCE SUMMARY:

Development: Banking/Finance/Mortgage, Utilities (Power and Phone Transmission), Airline, Health Insurance, Pharma, Software IBM MVS, UNIX, NT, and PC environments. Data Null, XML, SQL Confidential Procs: SQL, Means, Summary, Freq, Print, Printto, Sort, Tabulate, Plot, Chart, Report, Copy, Datasets, Contents, Univariate, Format, Tabulate, Corr, Reg, JCL and Utilities, TSO, ISPF, DB2, COBOL, Assembler, FOCUS, Unix Scripts, Teradata, BTEQ, 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 Programmer

Responsibilities:

• Planned, developed, tested, and documented highly complex Confidential application programs and their results.
• Generated new code and corrected, converted, and/or modified existing code to meet Medicare standards..
• Performed QA on existing Confidential programs and their resulting text and numeric data to Medicare standards.

Environment: s: Unix(Sun Microsystems SunOS 5.) and Wndows 7. 0 Confidential 9.3 on Unix and /or PC, Confidential 9.3(Procs: SQL, Freq, Print, Printto, Sort, Datasets, Contents, Format, Univariate, Report, Summary, Means), Confidential Macros, ODS, DDE, Data Null, and remote file transfer.

Confidential, Bloomington, IL

Sr. Programmer/Consultant

Responsibilities:

• Primary duties will include creating Confidential Code for new reports, maintaining Confidential Code on existing reports, running code and generating reports.
• Generated new code and corrected, converted, and/or modified existing code to meet specifications.
• Mapped data from existing COBOL data structures to Confidential data structures.
• IBM MF and PC environments MF Confidential, Confidential /PC, Confidential 9.3 (Procs: SQL, Freq, Print, Printto, Sort, Datasets, Contents, Format, Univariate, ReportSummary, Means), also Confidential Macros, ODS, DDE, and Data Null.

Confidential, Chicago, IL

Sr. Programmer/Consultant

Responsibilities:

• Re - engineered, automated, tested, and implemented the test analysis for the Confidential ’s DAT.

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

Confidential, Coppell, TX

Sr. Programmer/Consultant

Responsibilities:

• Developed, tested, and implemented Testing and Tracking Confidential applications for the 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, Unix, DB2, Teradata, SQL, Confidential 9.2(Procs: SQL, Freq, Summary, Print, SortDatasets, Contents, Format), also Confidential Macros, Data Null, SQL Assistant, Putty, Toad, Quality Center.

Confidential, Chicago, IL

Sr. Programmer/Consultant

Responsibilities:

• Developed, tested, and implemented data cleaning applications for Yemen, NCS, and SLAITS projects.
• Performed programming tasks including program design, coding, debugging, and documentation.
• Performed ETL services for survey data.
• Designated as a BLS agent.

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

Confidential, Middleton, MA

Sr. 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, Confidential 9.13-9.2 (Procs: SQL, Freq, Summary, Print, Sort, Datasets, Contents, Format), - also Confidential Macros, Data Null, Interix, Prism, Putty, MS Excel, Word, and Outlook, SqlDeveloper, Oracle SQL/Plus Editor,VI Editor.

Confidential, Charlotte, NC

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 Confidential programs on UNIX.
• Lead Business Analysis and Confidential 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 retail credit card, commercial credit card, auto loans, trusts funds, safety deposit box.

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

Confidential, Renton, WA

Sr. Developer/Consultant

Responsibilities:

• Defined, designed, developed, tested, and maintained Confidential programs.
• Performed ETL services for the data to Teradata.
• Lead design reviews, definition and testing sessions.

Environment: IBM z/OS, Windows 2000, SQL, Confidential 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. Developer / Consultant

Responsibilities:

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

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

Confidential, Elk Grove Village, IL

Sr. Developer/Analyst/Consultant

Responsibilities:

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

Environment: HP Unix, Confidential 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 Excel MS Word, PC 9.1.

Confidential, Downers Grove, IL

Consultant

Responsibilities:

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

Environment: IBM MVS, HP Unix, Confidential 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

Developer/Consultant

Responsibilities:

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

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

Confidential, McLean, VA

Developer/Consultant

Responsibilities:

• Developed, tested, maintained Confidential /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 of FAS140 databases and CDW.

Environment: NCR Unix, IBM MVS, Windows 2000, SQL, Confidential 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.