SUMMARY:

• IT professional with over 20 years of experience on Mainframe and Client Server applications
• Excellent user interface skills along with solid team leadership background
• Well organized, detail - oriented with a strong work ethic
• Flexible, fast learning, dependable, hardworking, efficient and reliable
• Excellent oral and written communication skills
• Capable of doing data analysis across databases, platforms and vendors
• I have an interest in using data analytics with very large databases to visualize unseen patterns to create monetary and/or social opportunities

INDUSTRY BACKGROUND:

• Banking & Finance
• Medicare/Medicaid
• Manufacturing
• State & Fed Government
• Parts Supply
• Insurance/Health
• Trans and Logistics
• Telecommunications
• Farm Implement
• Aircraft Manufacturing
• Software Vendor
• Retail

SPECIALTIES:

• Full Life-Cycle Development (SDLC - Cyclical Methodology - 4 Phase).
• Mainframe-to-Web Back-end and Middleware Development
• Project Coordination
• Data Analysis/Mapping/Metrics/Analytics
• Agile Development
• Working with onshore/offshore teams

SKILLS SUMMARY:

• Mainframe
• Client/Server
• COBOL 2/390/LE/zOS
• MS Word
• Confidential MQ Series
• MS Excel
• CICS/BMS/Intertest/Smartest
• MS Access
• Production Support
• Data Mapping
• TSO/ISPF
• Custom ETLs
• Confidential JCL/Utilities/File-Aid
• Visio
• DB2/QMF/Spufi/Stored Procedures
• XML
• EAI/Data Analysis/Endevor/Platinum
• MongoDB
• Confidential Macros
• Postgres
• Easytrieve/Easytrieve Plus
• Hadoop
• Quikjob
• Hive
• Pig
• Panvalet/Roscoe
• HCatalog
• Confidential MVS 390/370/3090/ zOS
• Storm
• Assembler
• Pentaho

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Florida

Technical Project Leader/Developer

Responsibilities:

• Helped to create high-level design artifacts. Delivered high quality code modules. Lead validation for all types of testing and support activities related to implementation, transition and warranty.
• Supervised an offshore team in creating various code modules and artifacts, including XML, WSDL, Web Services and Java/Javascript.
• Worked on various mainframe side projects, using a mainframe stack, as assigned by the Program Manager.

Environment: Mainframe Stack (COBOL, CICS, DB2, Utilities, JCL Scripting, Platinum), zOS, MCP for Field Communications, Java/Javascript (IntelliJ IDEA 14, Eclipse, Maven), XML, WSDL, Win 7, Office 2010, Visio.

Confidential, Tampa, Florida

Data Analyst/Developer

Responsibilities:

• Analyzed Sysplexes to ascertain how to separate Development files, tables and Databases from a Combination Sysplex into Separate Production and Development Sysplexes.
• At the Application level, all JCL Scripts, Etc., were modified to address only the pertinent data.
• In addition, source code was migrated from Changeman to Endevor and retested to assure that the functionality worked the same as before the split.

Environment: zOS, COBOL, DB2 UDB, SPUFI, QMF, CICS, TSO/ISPF, JCL (Mainframe Scripting), REXX, Win 7/XP, Office 2010.

Confidential, Richmond, Virginia

Big Data Database Analyst/Developer

Responsibilities:

• Helped design and populate several MongoDB, Postgres and DB2 databases to facilitate the Redemption of Reward points from various categories.
• Helped facilitate ETLs of MongoDB databases to move collections from DEV to ST to IT for Rewards Redemptions and create XML versions of each collection.
• Completed several formal internal classes on MongoDB, Postgres, Hadoop, R, APIs and Business Analysis.
• Helped design, create and document both public and private Java API RESTful Integration Services to write to and consume data from MongoDB collections and Postgres databases.
• Helped design, create and document DB2 UDB Stored Procedures to write to and consume data from DB2 Data Warehouse databases.

Environment: MongoDB Enterprise (Mongo Shell scripting, JSON, RoboMongo, 3T MongoChef, MEAN Stack (MongoDB, Express, AngularJS, Node.js)), Postgres (pgAdmin3), Hadoop (Pig, Hive, HCatalog, Storm, Oozie), R (RStudio), Pentaho7 & 8 (IntelliJ IDEA 14, Eclipse, Maven), Python, XML, AWS, Win 7, OS X Yosemite, Office 2010, Visio, zOS, DB2 UDB, Confidential Data Studio.

Confidential, Jacksonville, Florida

Senior Developer

Responsibilities:

• Created high- and low-level technical designs using Visio and Use Cases.
• Wrote several dozen backend DB2 SQL native Stored Procedures, Confidential and Triggers to populate Web Services consumed by Java scripts.
• Used Confidential Data Studio to prototype and test native Stored Procedures, Confidential and Triggers.
• Wrote several COBOL routines and modules to affect changes for the Affordable Care Act (Obamacare) and ICD10.

Environment: zOS, COBOL, DB2 UDB, SPUFI, QMF, CICS, TSO/ISPF, TSO Admin, Fault Analyzer, Test Debug, JCL (Mainframe Scripting), Win 7/XP, Office 2010, Visio, Confidential Data Studio, XML, Web Services.

Confidential, Atlanta, Georgia

DB2 Data Specialist

Responsibilities:

• Translated data store requirements into native and COBOL Stored Procedure designs.
• Created native and COBOL Stored Procedures from the team designs.
• Assisted in data store maintenance and guided the DBA in creating and tuning the Physical Data Store.
• Helped create the Data Access Layer Change Document.
• Used Confidential Data Studio to create and deploy Stored Procedures.
• Used QMF and batch jobs to test validity of the Stored Procedure SQL. Wrote formal test cases for all assigned Stored Procedures.

Environment: zOS, DB2 UDB, SPUFI, QMF, CICS, JCL (Mainframe Scripting), Win 7, Office 2010/2013, Visio, Confidential Data Studio.

Confidential, Alpharetta, Georgia

Data/Program Analyst

Responsibilities:

• Reviewed and researched 900 custom/standard Cobol-to- Confidential programs to determine how they will be handled in the new eBilling system.
• Developed new client/server report requirements documents based on legacy mainframe reports.
• Responsible for creating spreadsheets which contain group metrics, analytics and dashboard mashups for management and team consumption.
• Created ad-hoc reports and spreadsheets as requested by management and team members.

Environment: MS Office, zOS, COBOL, DB2 UDB, SPUFI, Oracle, TSO/ISPF, VSAM, Changeman, File Aid, JCL (Mainframe Scripting), Office 2003, Visio, Visual Studio, Crystal Reports, C#, VBA, MySQL, PHP, XML, MS Excel Mainframe API (Assembler based).

Confidential, Tampa, Florida

Senior remote and onsite Developer

Responsibilities:

• The Billing Team consolidates data of record from other system databases, using COBOL and DB2 tables, to create corporate and individual insurance bills for various insurance companies and associations.
• Wrote and tuned various DB2 stored procedures to be used by UI screens management dashboards.

Environment: MS Office, zOS, COBOL, DB2 UDB, SPUFI, TSO/ISPF, VSAM, Changeman, File Aid, Test Debug, JCL (Mainframe Scripting), Office 2003, Visio, PHP, XML.

Confidential, Delray Beach, Florida

Lead/Senior Developer

Responsibilities:

• Created SQL stored procedures for ad-hoc reports and graphs.
• Created processes for downloading various Medicaid spreadsheets for input into mainframe DB2 tables, i.e., procedure codes, HCPCS, CMS. And, maintained the team analytics/metrics spreadsheets.
• Started preliminary design to convert 4010 data/layouts to 5010 data/layouts. Created ETL job streams to help facilitate creating new tables structures for ICD-10.
• Also, as Lead/Senior Developer with the Prior Authorization group, re-engineered the automatically generated recipient/provider letters production workflow to facilitate faster turnaround time.

Environment: Office 2003, MS Outlook, Office VBA, Visio, zOS, COBOL, DB2 UDB, CICS, Assembler, Platinum, SPUFI, TSO/ISPF, VSAM, File Aid, Expediter, Endevor, JCL (Mainframe Scripting), Test Director.

Confidential, Delray Beach, Florida

Senior Developer

Responsibilities:

• Helped streamline and tune various DB2 modules for both CSC and WMS.
• Created metrics on slot info so that merchandise for delivery can be placed closer to conveyor belts.
• Assisted in the creation of AS400/iSeries interfaces to a mainframe backend using COBOL and Assembler.

Environment: Office 2003, MS Outlook, Office VBA, Visio, zOS, COBOL/390, Assembler, CICS, DB2 UDB, QMF, SPUFI, TSO/ISPF, VSAM, File Aid, Intertest, Expediter, Endevor, JCL (Mainframe Scripting), Bar Code Labeling, Custom Cartonization. CA Realia

Confidential, Tampa, Florida

Senior Developer

Responsibilities:

• Created several COBOL/DB2/embedded SQL programs to automate a manual system so that various flat files and DB2 tables can be modified through a screenless CICS process.

Environment: WinXP, Office 2003, MS Outlook, Office VBA, Visio, OS/390, COBOL/390, Assembler, CICS, DB2 UDB, QMF, SPUFI, TSO/ISPF, VSAM, File Aid, Intertest, Expediter, JCL (Mainframe Scripting), Endevor.