SUMMARY:

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

TECHNICAL SKILLS

• IBM MVS
• Unix
• NT
• PC environments
• PC
• Macros
• 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
• Teradata
• ISPF
• DB2
• COBOL
• Assembler
• FOCUS
• Unix Scripts
• SQL Assistant
• Putty
• Toad
• Quality Center
• Queryman
• Oracle
• Exceed
• DB2
• Rumba
• Perl
• MS Excel
• MS Project
• MS Access
• Peregrine
• FTP
• CDR
• Visio
• Kermit
• Lotus
• and WordPerfect.

PROJECT EXPERIENCE:

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.
• Re - engineered, automated, tested, and implemented the test analysis for the ADA’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 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, Unix, DB2, Teradata, SQL, Confidential 9.2(Procs: SQL, Freq, Summary, Print, Sort, Datasets, Contents, Format), also Confidential Macros, Data Null, SQL Assistant, Putty, Toad, Quality Center.

Confidential, 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, Sort, Datasets, Contents, Format), also Confidential Macros, Data Null.

Confidential, Middleton, MA (Modis)

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

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 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 credit card, auto loans, trusts funds..

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 for Airplane Reliability and
• Maintainability System using Spec2000 guidelines.
• Performed ETL services for the data to Teradata.
• Lead design reviews, definition and testing sessions.
• 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, JCL, Unix 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, Confidential PC 9.1.

Confidential, IL

Developer/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 and risk reporting.
• 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, DatasetsContents, Format, Tabulate) ODS, - also Macros, Data Null, Teradata, FTP, MS Excel, MS Word, Visio.

Confidential, McLean, VA

Confidential 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.
• Developed marketing lists for various campaign initiatives using Confidential 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.
• Performed systems analysis, design, and development and testing (using Confidential ) 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, Unix, Confidential 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

Data Warehousing Specialist

Responsibilities:

• Lead the programming initiative using Confidential in analyzing Telephone Usage data from Teradata datamarts for various marketing strategies.
• Developed Confidential programs for the Telephone Usage marketing initiatives.
• Developed adhoc Confidential 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, Windows NT, Confidential 6.12(Procs: SQL, Summary, Freq, Print, Printto, Sort, Report, Datasets, Contents, Format, Copy, Tabulate)—also Macros and Data Null, Teradata, Oracle,