Summary
Overview
Work History
Education
Skills
Relevant Industry Systems Experience
Additional Representative Consulting Assignments
Professional Development Education Languages
Remote Only
Accomplishments
Technical Skills And Capabilities
Professional Executive Profile
Timeline
Generic

Carol W. Fletez

Elkridge

Summary

Accomplished Technical Consultant with extensive experience at HPE, specializing in database management and systems analysis. Proven track record in legacy migration and data integration, utilizing advanced SQL and effective communication skills to enhance operational efficiency. Successfully led multi-million dollar projects, ensuring compliance and optimizing data processes for diverse clients.

Overview

22
22
years of professional experience

Work History

Technical consultant

Dba/Digital Integration Technology
Elkridge
07.2022 - Current
  • Contractual assignment to DPP Systems related to payrolls and other tasks. Backup resource to contractual personnel for this assignment. Problem Troubleshooting (Agile methodologies, WINDOWS Based, Cleared under USA-ACCESS guidelines.- Current assignment -promised COBOL but not in active duties at this time.

Technical consultant

TEK systems/Peraton
01.2022 - 08.2024
  • Contractual assignment to CICS efforts to update a critical CICS application related to military pay systems. Backup for a period to permanent personnel for this assignment. Problem Troubleshooting (Agile methodologies, z/OS/CICS/COBOL/VSAM/Isam), Cleared under DOD guidelines.

Enterprise Solutions Specialist

HPE
Remote
08.2021 - 03.2022
  • Offshore Migration client support for HP/E Spain for a telecommunications company in a private cloud. Database analysis for ORACLE/DB2 support for systems migrations to private cloud installation.

Principal Mainframe Systems Consultant

Majesco Insurance
01.2021 - 07.2021
  • Software Integrator and technical mainframe COBOL Architect – Micro Focus Enterprise Developer/Enterprise Server emphasis – Assisted in transition to Microsoft Azure and Micro Focus Enterprise Developer. Shaw systems loan servicing additions.

Principal Mainframe Systems Consultant

Digital Integration Technology
Elkridge
01.2021 - 07.2021
  • Software Integrator and technical Architect advisor. Offshore migration client based in India for VOYA – DB2 analysis and emphasis for an onshore insurance client- installation of DB2 within Enterprise Server, Azure. Shaw loan systems.

Software Integrator and Technical Architect/Support

U V Software Inc.
Vancouver
10.2015 - 12.2020
  • Representative legacy migration client engagement content example: two short support for CLOUD BASED migrations to Azure ETL for a finance/investment company; migration to Micro Focus LINUX installation on PRIVATE server at an international client. Creating support transactions from mainframe applications via WebSphere/SOA to update existing IMS/DB2 mainframe data via complex Stored Procedures ‘housed’ on Linux RHEL. Extensive troubleshooting was required at the mainframe and network levels to define and resolve CICS/WebSphere MQ and Solaris WebSphere MQ issues.

IBM Solutions Technical Architect

GANTECH, Inc.
Glen Burnie
07.2014 - 09.2015
  • Company Overview: (CATS+ SUPPORT contract at Maryland Motor Vehicle Admin)
  • Evaluated legacy mainframe COBOL system to define/design the architectural/systems specifics and concepts for three major multi-million projects for legacy migration of support functions from mainframe applications via NET EXPRESS to Microsoft Visual Studio/Micro Focus COBOL. Resulted in elevating current transactions into currently supported software environments with expectations of extensive ROI for the durable life of the systems, which support all customers of the Maryland Motor Vehicle Administration.
  • Supported extensive legacy migration and conversion of existing CICS/COBOL dialog-based programs into Visual COBOL including defining how they would continue to manage data sources such as DB2, SQL Server and ORACLE relying heavily on hybrid formats compatible with server dispatched transactions while timely hosting database entities on the mainframe.
  • Developed standards in production of viable DB2 CICS Stored Procedures, remediation of two additional back-end systems to modernize overall. Defined and monitored provisioning of hardware and software for the task’s completion for both costs and timely availability.
  • Designed and managed project plans to accomplish data and database conversions including all phases of conversion: evaluation, definition, integration and testing, manage functional interrelationships, and the creation of methods to evaluate post-conversion processing. Project management and team lead hands on for data and conversion phases.
  • (CATS+ SUPPORT contract at Maryland Motor Vehicle Admin)

Software Integrator and Technical Architect Support

U V Software Inc.
Vancouver
09.2010 - 06.2014
  • Creating support transactions from mainframe applications via WebSphere/SOA to update existing IMS/DB2 mainframe data via complex Stored Procedures ‘housed’ on Linux RHEL. Extensive troubleshooting was required at the mainframe and network levels to define and resolve CICS WebSphere MQ and Solaris WebSphere MQ issues. Use of ALTOVA products to assist.
  • Extensive legacy migration and conversion of existing COBOL programs which manage these data sources such as DB2, IMS and ORACLE relying heavily on advanced SQL skills to create formats compatible with UNIX, Linux and .NET from internet dispatched transactions.
  • Analyzed data at more than five permanent clients where sensitive PII HIPAA mainframe data formed the basis for creation of custom reports and programs in COBOL and UNIX scripting languages. Two of these were extensive legacy migration data projects with requirements to perform analytical manipulation and interpretation of large databases. Report formats included Crystal Reports, OFFICE documents and shared representations in SharePoint.
  • Designed and managed legacy migration project plans to accomplish data and database conversions including all phases of conversion: evaluation, definition, integration and testing, manage functional interrelationships, and the creation of methods to evaluate post-conversion processing. Project management and team lead for data and conversion phases. Managed conversion and migration of JCL and other systems structures which support data availability to UNIX/Linux platforms with custom and system tools.
  • Using onsite tools such as those cited in skills above, conducted evaluations of varieties of client data including health care, pharmaceutical and banking, to assure the migrated data met client criteria for reorganization of data in viable relationship algorithms. For example, a healthcare organization must provide proof of compliance with privacy standards under HIPAA guidelines.
  • Provided ongoing status reports of legacy migration work in process at several client sites demanding reprioritizing of effort and focus while balancing priorities. Created data migration job sets incorporating mainframe tools such as SPUFI, BMC DB2 tools as well as interpreting and writing stored procedures in COBOL, transferring same to the receiving platform. Clients’ data volumes varied in size from a few million to multi million records requiring compliance restraints on accessibility and archiving.

Senior Technical Consultant

Micro Focus Inc
Rockville
11.2009 - 08.2010
  • Defined requirements for legacy migration and created custom programs in COBOL and scripting languages to migrate and convert data sources such as DB2, IMS and ORACLE to formats compatible with UNIX/LINUX at seven United States based clients.
  • A notable legacy migration client combined system from more than 5 different ‘arms’ of business where multiple disparate databases and mainframe tools required great volumes of data relationship evaluation before any migrations occur.
  • Utilized Micro Focus proprietary legacy migration tools to house multiple CICS environments within a server system that included 17 CICS regions. Evaluated sensitive client data including HIPPA-related health care, pharmaceutical, manufacturing, billing and compliance processes based on client data to determine organization of data into valid relationship algorithms.
  • Defined requirements for and created migration job control language tools (JCL) to migrate data, incorporating mainframe tools such as SPUFI, BMC DB2 tools as well as interpreting and writing stored procedures in COBOL and transferring same to the receiving platform.
  • Mentored clients on product utilization and tailored specific transitioning tools including scripts; gathered specifications for and assisted in the process of automated transition of databases, VSAM files and migrated mainframe databases such as DB2 and IMS to Micro Focus formats.
  • Installed and supported Micro Focus products such as Server Express and Micro Focus Enterprise Studio on UNIX and Linux platforms for RHEL.
  • Applied solution design methodologies, performed testing and resolution of open issues with specific design solutions as goals.

Software Integrator and Technical Marketing Support

U V Software Inc.
Vancouver
01.2008 - 10.2009
  • See September 2014 description

Technical Lead

Johnson & Johnson
Morris Plains
06.2007 - 09.2007
  • Database analysis consolidation from text to ORACLE for Systems Compliance.

Technical Lead

Excel Resources
07.2006 - 05.2007
  • Company Overview: (Moore/Wallace, a division of R. R. Donnelley)
  • Migration to UNIX based server of financial/mortgage loan mainframe applications using Microfocus tools and extensive DB2 knowledge.
  • (Moore/Wallace, a division of R. R. Donnelley)

Sr. Systems Analyst IV

Northrop Grumman
12.2004 - 06.2006
  • Company Overview: (Commodity Futures Trading Commission)
  • Support of Windows based DB2 and Sharepoint environments for KC Board of Trade and other CFTC financial clients.
  • (Commodity Futures Trading Commission)

Technical Team Lead DB2

Database Integrators, Inc
12.2003 - 11.2004
  • Company Overview: (Deutsche Bank/ Alex Brown)
  • Financial Systems Modernization and Conversion – DB2 conversion to DB2 LUW database on AIX using DB2 tools. Interpreted and wrote corresponding stored procedures to transfer data to AIX based stored procedures.
  • (Deutsche Bank/ Alex Brown)

Education

B.A. - Economics and Latin American Area Studies

The American University
Washington, DC

Associate of Arts - Spanish, Literature

The National University of San Augustin
Arequipa, Peru

MariaDB, DBForge Studio, and other non-mainframe database tools

Self-Taught coursework

Skills

  • Systems analysis and documentation
  • Productivity and communication tools
  • Version control systems
  • Database management systems
  • Job scheduling and automation
  • Programming languages and scripts
  • Data integration and ETL tools
  • Virtualization and networking technologies

Relevant Industry Systems Experience

  • Dba/Digital Integration Technology, Elkridge, MD, 07/01/22, present, Technical consultant, Contractual assignment to DPP Systems related to payrolls and other tasks. Backup resource to contractual personnel for this assignment. Problem Troubleshooting (Agile methodologies, WINDOWS Based, Cleared under USA-ACCESS guidelines.- Current assignment -promised COBOL but not in active duties at this time.
  • TEK systems/Peraton/DFAS, Remote, MD, 08/01/21, 08/31/24, Technical consultant, Contractual assignment to CICS efforts to update a critical CICS application related to military pay systems. Backup for a period to permanent personnel for this assignment. Problem Troubleshooting (Agile methodologies, z/OS/CICS/COBOL/VSAM/Isam), Cleared under DOD guidelines.
  • Majesco Insurance, Remote, MD, 08/01/21, 03/31/22, Principal Mainframe Systems Consultant, Software Integrator and technical mainframe COBOL Architect – Micro Focus Enterprise Developer/Enterprise Server emphasis. Assisted in transition to Microsoft Azure and Micro Focus Enterprise Developer. Shaw systems loan servicing additions.
  • HPE, Remote, MD, 08/01/21, 03/31/22, Enterprise Solutions Specialist, Offshore Migration client support for HP/E Spain for a telecommunications company in a private cloud. Database analysis for ORACLE/DB2 support for systems migrations to private cloud installation.
  • Digital Integration Technology, Elkridge, MD, 01/01/21, 07/31/21, Principal Mainframe Systems Consultant, Software Integrator and technical Architect advisor. Offshore migration client based in India for VOYA – DB2 analysis and emphasis for an onshore insurance client- installation of DB2 within Enterprise Server, Azure. Shaw loan systems.
  • U V Software Inc., Vancouver, BC, Canada, 10/01/15, 12/31/20, Software Integrator and Technical Architect/Support (U.S only)., Representative legacy migration client engagement content example: two short support for CLOUD BASED migrations to Azure ETL for a finance/investment company; migration to Micro Focus LINUX installation on PRIVATE server at an international client.
  • GANTECH, Inc., Glen Burnie, MD, 07/01/14, 09/30/15, IBM Solutions Technical Architect, Evaluated legacy mainframe COBOL system to define/design the architectural/systems specifics and concepts for three major multi-million projects for legacy migration of support functions from mainframe applications via NET EXPRESS to Microsoft Visual Studio/Micro Focus COBOL.
  • U V Software Inc., Vancouver, BC, Canada, 09/01/10, 06/30/14, Software Integrator and Technical Architect Support (U.S only), Creating support transactions from mainframe applications via WebSphere/SOA to update existing IMS/DB2 mainframe data via complex Stored Procedures ‘housed’ on Linux RHEL.
  • Micro Focus Inc, Rockville, MD, 11/01/09, 08/31/10, Senior Technical Consultant, Defined requirements for legacy migration and created custom programs in COBOL and scripting languages to migrate and convert data sources such as DB2, IMS and ORACLE to formats compatible with UNIX/LINUX at seven United States based clients.
  • U V Software Inc., Vancouver, BC, Canada, 01/01/08, 10/31/09, Software Integrator and Technical Marketing Support, See prior tasks and responsibilities already described above.

Additional Representative Consulting Assignments

  • Johnson & Johnson, Morris Plains, NJ, 06/01/07, 09/30/07, Technical Lead, Database analysis consolidation from text to ORACLE for Systems Compliance.
  • Excel Resources, Moore/Wallace, a division of R. R. Donnelley, 07/01/06, 05/31/07, Technical Lead, Migration to UNIX based server of financial/mortgage loan mainframe applications using Microfocus tools and extensive DB2 knowledge.
  • Northrop Grumman, Commodity Futures Trading Commission, 12/01/04, 06/30/06, Sr. Systems Analyst IV, Support of Windows based DB2 and Sharepoint environments for KC Board of Trade and other CFTC financial clients.
  • Database Integrators, Inc, Deutsche Bank/ Alex Brown, 12/01/03, 11/30/04, Technical Team Lead DB2, Financial Systems Modernization and Conversion – DB2 conversion to DB2 LUW database on AIX using DB2 tools.

Professional Development Education Languages

Active Member: IASA, NOREX; certified in Inventory Management APICS, IBM–Various mainframe (IMS, CICS, COBOL, DB2) training and certificates, POAC (PETAG) – Facilitator of Maryland State Employment group which encourages re-employment of IT and Engineering Professionals (Conducting extensive training and mentoring), B.A., Economics and Latin American Area Studies, The American University, Washington, DC, Spanish, Literature, The National University of San Augustin, Arequipa, Peru, MariaDB, DBForge Studio, and other non-mainframe database tools., Interest in modern security tools., English, native, primary, Spanish, fluent and technical, French, conversational

Remote Only

True

Accomplishments

  • Organized versatile specialist with multi-enterprise solution design experience, project management knowledge and skills, and expertise with numerous system life cycle methodologies (SDLC), planning tools and methods.
  • Extensive consulting and hands-on development experience in data driven and legacy modernization to multi-platform EDI/EDL/ETL environments.
  • Expert knowledge of data analysis tools. Significant experience converting volumes of data, government/corporate data specifications and content to reliable and efficiently functioning databases.
  • Excellent communication/presentation skills. Agile troubleshooter, team builder and implementer of dynamic solutions. Versatile in managing multiple goals to achieve client objectives.
  • Software application expertise in ‘from scratch’ basic solution designs, technical knowledge of code generation, testing, and implementation.

Technical Skills And Capabilities

Document Management/Development/Productivity and Communication Media Tools: Clear Case and Rational tools, Crystal Reports, Changeman, MS Office, MS Project, Visio, TEAMS, SmartDraw., Multiple Browsers. Powershell/Notepad++/UltraEDit., Enterprise-wide configuration management software products (such as GitLab tools, ENDEVOR, MS Source Safe, Subversion, Librarian, PANVALET, TCT, CVS, PVCS)., ETL tools, COBOL, Micro Focus COBOL and Visual COBOL, Visual Studio .NET, UNIX KORN shell, Perl (basic knowledge), C++., Learning R., Job Scheduling (CA7); Building and using all formats of VSAM files and IDCAMS, Syncsort; File-Aid; Abend-Aid; File Transmission (FTP/NDM); all levels of COBOL, COBOL II, JCL–z/OS, JES, TSO/E–z/OS, ISPF, CICS/TS, MQ Series, QMF, DB2 and SQL, DDL, UDS, ISPF, IMS/VSAM related databases (Other IBM Data and file Utilities), VTAM, Control-M, INTERTEST, EYEWITNESS, OMEGAMON, TMON, EXPEDITER, CEDF, VERIFY, and other CICS utilities; other IBM mainframe operating systems (z/OS, 3090/93xx/43xx, MVS/OS/390, MVS/ESA, MRO, XA, VM/ VSE). Z/OS-WebSphere MQ, PC-Based Data Manipulation and Security Tools: Altova analytical products, Data Stage, MS SharePoint, SmartTerm, NetTerm, PowerTerm and NeoTrace; CISCO VPNs, Virtualization suites, TCP/IP, SCS, Internet Browsers, Internet Security Suites, TextPad., IMS based apps, SQL, MS Access, MySQL, MariaDB, DBeaver, DB2 Relational Database (mainframe and distributed platforms), IBM: SQL/PL for DB2, SPUFI, QMF, SQL/DS, DB2 Universal Database on UNIX/LINUX platforms (Solaris, AIX and HP/UX) and .NET under Enterprise Server (Micro Focus), Data Stage, CA-Gen, BMC Tools, Erwin and most relevant database design utilities., IMS/DLI, ETL, SQL Server, older ORACLE, PL/SQL for ORACLE; ORACLE Discoverer, TOAD for Oracle and DB2., Micro Focus Enterprise Server for Windows Server, Micro Focus Server 3.0 for LINUX for Azure, (or AWS), Micro Focus Net Express for Windows, Micro Focus Server Express for UNIX, Micro Focus AppServer for UNIX, Micro Focus Server Express for RHEL and .NET, Micro Focus Master Enterprise Express Edition for mainframes, Micro Focus Soft Factory 2000 – REVOLVE, Main Frame Access, Main Frame Express., Red Hat Linux (RHEL), UNIX (Solaris, AIX and HP/UX) on n-tier IBM, Stratus and HP servers, Windows Servers (2019-2012 R2), Windows OS (Win7 Pro, Win 8.1, Win 10), OnDemand architecture, FTP, NAS, NTFS, UNIX file structures and shells. Z/OS-WebSphere MQ, and Solaris WebSphere MQ, Production Queue Management.

Professional Executive Profile

  • Bilingual CLEARED Senior Solutions Architect/Developer/Programmer Analyst and Project/Team leader with more than 15+ years of experience in Information Technology on IBM mainframes/multiple distributed platforms.
  • Experienced in building and supporting modern and legacy applications from definition of technical requirements to creating and supporting critical business applications.
  • Successful at migrating mainframe Enterprise Systems to other platform environments via Micro Focus Tools and methods.
  • Over 15+ years hands-on experience, customer facing, in implementing applications supporting business and technical solutions.
  • Established enterprise business requirements for legacy applications and modernization, developing mainframe code end to end, performing meticulous database analyses within applications, supporting data warehouses/data migrations, and creating systems integration and business intelligence components to achieve these goals.
  • Extensive industry experience assisting remote/onsite clients performing additions to new and legacy tasks; implementation and migrations of successful software solutions: at state/federal government, financial, automotive, general and healthcare insurance, investment institutions, software consulting firms, HIPAA compliance and PII personnel data management, and numerous others.

Timeline

Technical consultant

Dba/Digital Integration Technology
07.2022 - Current

Technical consultant

TEK systems/Peraton
01.2022 - 08.2024

Enterprise Solutions Specialist

HPE
08.2021 - 03.2022

Principal Mainframe Systems Consultant

Majesco Insurance
01.2021 - 07.2021

Principal Mainframe Systems Consultant

Digital Integration Technology
01.2021 - 07.2021

Software Integrator and Technical Architect/Support

U V Software Inc.
10.2015 - 12.2020

IBM Solutions Technical Architect

GANTECH, Inc.
07.2014 - 09.2015

Software Integrator and Technical Architect Support

U V Software Inc.
09.2010 - 06.2014

Senior Technical Consultant

Micro Focus Inc
11.2009 - 08.2010

Software Integrator and Technical Marketing Support

U V Software Inc.
01.2008 - 10.2009

Technical Lead

Johnson & Johnson
06.2007 - 09.2007

Technical Lead

Excel Resources
07.2006 - 05.2007

Sr. Systems Analyst IV

Northrop Grumman
12.2004 - 06.2006

Technical Team Lead DB2

Database Integrators, Inc
12.2003 - 11.2004

B.A. - Economics and Latin American Area Studies

The American University

Associate of Arts - Spanish, Literature

The National University of San Augustin

MariaDB, DBForge Studio, and other non-mainframe database tools

Self-Taught coursework
Carol W. Fletez