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

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/Waterfall Development
• Working with and/or leading onshore/offshore teams

SKILLS SUMMARY:

Mainframe

Client/Server

COBOL 2/390/LE/zOS

MS Word

IBM MQ Series

MS Excel

CICS/BMS/Intertest/Smartest

MS Access

Production Support

Data Mapping

TSO/ISPF

Custom ETLs

IBM JCL/Utilities/File-Aid

IMS

DB2/QMF/Spufi/Stored Procedures

XML

EAI/Data Analysis/Endevor/Platinum

MongoDB

IBM Macros

Postgres

Easytrieve/Easytrieve Plus

Hadoop

Quikjob

Hive

Endevor/Changeman

Pig

Panvalet/Roscoe

HCatalog

IBM MVS 390/370/3090/ zOS

Storm

Assembler

Pentaho

Microsoft

Online Curriculum

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Florida

Technical Project Leader/Developer

Responsibilities:

• Interfaced with key stakeholders and applied technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Application Architecture definition and Design.
• 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. 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, IBM 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, UDFs and Triggers to populate Web Services consumed by Javascripts.
• Used IBM Data Studio to prototype and test native Stored Procedures, UDFs 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, IBM 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 IBM 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, IBM Data Studio.

Confidential, Alpharetta, Georgia

Data/Program Analyst

Responsibilities:

• Assigned to perform analysis on how to convert eBills from a legacy mainframe system to MySQL/Crystal Report eBills.
• Reviewed and researched 900 custom/standard Cobol-to-CSV 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, Delray Beach, Florida

Lead/Senior Developer

Responsibilities:

• Responsible for all development, testing, SYST and UAT preparations, defect resolution and turnover of the Confidential Healthcare IT Reference System.
• This system consists of approximately 60 COBOL/DB2/PHP modules which control the main reference tables and update/interface processes for various groups, i.e., Managed Care, Claims, Provider, et al.
• 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:

• Main responsibilities were warehouse fulfillments, just-in-time allocations, item inventories and vendors, mailing labels, RFID and cartonizations.
• All of these sub-systems were either online/real-time or handheld scanner/real-time.
• 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:

• Primary responsibility is the design and engineering of custom interfaces to facilitate the smooth operation between the merged bank’s computer systems.
• 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.