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

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

Software Engineer - Mainframe / Big Data

Responsibilities:

• Data from several sources - DB2, flat files, VSAM, etc. - are extracted, transformed and loaded into various Hadoop HDFS systems via Confidential scripts.
• Used Dfsort/Icesort/Symnames to mask PII data and rearrange columns as needed.

Environment: Mainframe Stack (COBOL, CICS, DB2, VSAM, DFSort/Icesort, Utilities, JCL Scripting, Platinum), zOS, TSO/ISPF, Roscoe/CCF, Hadoop, Spark, Oozie, Datastage.

Confidential

Data Scientist/Analytics Student

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.
• 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, IBM Data Studio.

Confidential, Jacksonville, Florida

Senior Developer

Responsibilities:

• Responsible for new development on - and modifications to - the Confidential enrollment system.
• 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, Tampa, Florida

Senior remote and onsite Developers

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:

• 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, as400/iSeries, iSeries CL.

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.

Confidential, Dallas, Texas

Technical Project Leader

Responsibilities:

• Responsibilities included performing a technical lead role in developing design deliverables (Conceptual Design, Functional Design, Systems Technical Design, Programming Specifications and Unit, System and Integration Test Plans) as well as development and implementation of system initiatives.
• Structured general design requirements into application system information flows, program functions, and data requirements.
• Analyzed and solved problems in a complex environment.
• Created and installed several COBOL / Assembler DB2 stored procedures for the Emerging Credit / Student Credit system as well as loading/unloading the requisite tables.
• Modified several CICS modules to communicate with a VRU (Voice Recognition Unit) for the VRU system.
• Also, created several spreadsheets using VBA to keep track of various other duties that were assigned to me.
• Additionally, acted as Site Manager/Coordinator for the SOW consulting firm.
• Duties included being the on-site SOW contact, facilitated training and procured technical assistance for SOW consultants.
• Also, handled any queries or concerns of the client’s management or SOW consultants.

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

Confidential, Delray Beach, Florida

Data Analyst

Responsibilities:

• Responsible for data mapping columns from a mainframe DB2 database into Oracle and SQL Server databases.
• Created several Excel templates to capture various metrics before mapping data.

Environment: WinXP, Office 2003, MS Outlook, Office VBA, Oracle, SQL Server, OS/390, COBOL/390, Assembler, Easytrieve, DB2 UDB, QMF, SPUFI, TSO/ISPF, VSAM, File Aid, JCL (Mainframe Scripting), ESP Visual Scheduler.

Confidential, Atlanta, Georgia

Senior Analyst/Programmer

Responsibilities:

• Main duties included writing high-level specifications and detailed specifications.
• Also responsible for writing several interfaces into the present system.

Environment: Win2000, Office 2003, MS Outlook, OS/390, COBOL/390, Assembler, Easytrieve, DB2 UDB, QMF, SPUFI, TSO/ISPF, VSAM, JCL (Mainframe Scripting), File Aid.