SUMMARY

• Primary focus of career has been in mastering Database Management Systems and their Administration as well as Application Design, Coding and Production Implementation. Provided Training for all levels of personnel to include hands on day to day mentoring, formal classroom course development & presentation. Provided consulting/trouble shooting on short term assignments wif external groups & clients.
• Coordinate & Supervise Offshore activities of Offshore staff in India to support Sprint’s ADABAS environment. Was asked to rejoin teh LA GEARS account as their lead DBA and lead several teams relating to new Contract Implementation for LA County. Confidential is now providing 24hr RTO Disaster Recovery service under teh new contract and multiple Technical Solutions to accomplish dis needed to be devised. Provided all installation and operational support for Confidential in a UNIX environment. Has implemented ADABAS SQL and now provide Client wif a Mirror Image of GEARS Production Database in ASCII format for SQL reporting and Data Warehousing on their end.
• Design, Development & Production implementation was accomplished on both mainframe and midrange environments. Experience on start - up accounts supporting due diligence efforts, requirements management, design, development, testing and production implementation & support. Provided technical writing and headed teh project team to assess requirements. Implement Disaster Recovery Plans for a major state government client. Lead DBA for several teams that I has been assigned to over teh course of my career. Team Lead/Project Manager for Application Development teams when not functioning as a DBA.
• Technical revamping of multiple legacy systems and conversions to newer versions/software upgrades resulted in multi million dollar savings in DASD and processing time for several clients. Developed Production execution schedules that better utilized existing and future resources as well as providing timelier product delivery to end clients.
• Strengths include Technical Excellence, Conflict management; Personnel Utilization Training & Performance Improvement. Results oriented nature; strong belief in teh importance of being a team player; willing to do whatever it takes to get teh job done resourcefully and successfully. Strong history of developing team members who can and will perform to their highest capability.

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Lead ADABAS DBA

Responsibilities

• Systems Engineer/DBA supporting UMG Royalty Tracking System and conversion of data from Mainframe to Unix platform.
• Given a raw box to work from installed all SAG software to replicate teh existing system on Mainframe to an Confidential Server wif multiple LPARS for Production/Test/Staging environments.
• Installed ADAMAGIC as a data conversion tool and successfully converted existing EBCIDIC ADABAS files and databases from mainframe to convert to ASCII format for subsequent loading in a ADABAS UNIX environment.
• Installed DMExpress for Syncsort replication. Installed Endevor Administrator and SCM Coordinator for staff.
• Installed all renovated code that was retrofitted by Software AG for running under UNIX to support Royalties Application. Debugged supplied Natural Code as necessary
• Natural Security Administrator.
• Lead Predict Administrator. Lead Support for Data Base Modifications, Backup, Space & Performance monitoring utilizing ADABAS Utilities & ADABAS ADADBM Services script creation to mimic those functions that SYSAOS provides on teh mainframe.
• Set up & maintain all Parm libraries that are unique to teh UMG applications we support. Coordinated all licensing agreements between Software vendors, UMG and Confidential personnel.

Confidential, Los Angeles, CA, USA

Lead ADABAS DBA

Responsibilities

• Systems Engineer/DBA supporting teh Confidential GAIN system
• Managed a work force management system spanning Multiple ADABAS Physical Data Bases
• Perform cyclic on call duties wif extensive requirements for usage of Computer Associates Products, (CA7, CA Disk, and CA-VIEW.
• Endevor Administrator and SCM Coordinator for staff.
• Supported online systems that were coded in Natural V3.1.5 & Java. Analyze, scope, cost, design & code Natural based solutions to state mandated legislation.
• Support teh content of teh GEARS training base for LA County DPSS new hires.
• ACF2 Account Level Security Officer & Natural Security Administrator.
• Lead Predict Administrator and training coordinator/instructor for Advanced Natural Studies for our Associates/Intern program.
• Lead Support for Data Base Modifications, Backup, Space & Performance monitoring utilizing ADABAS Utilities & ADABAS Online Services.
• Lead DBA for Disaster Recovery planning & execution.
• Supported 8 ADABAS back end environments to support Web front-end development & teh Production Mainframe based Database/Systems as well.
• Recently Installed ADABAS 8.2.5, AOS, Predict 8.2.2. Natural V8.8.2 & Super Natural.
• Implemented Forward Index Compression recovering upwards of 23,000 Cylinders of DASD which provided a savings for teh account of roughly 4 million dollars annually.
• In 2011 redesigned GEARS batch cycles to take advantage of cost savings through usage of common extracts, consolidating database I/O and so on. Estimated multi million dollar savings on an annual basis.
• 2012 - 2013. Installed and Implemented ADABAS SQL and process’s designed to provide mirror image of GEARS production databases. Developed SQL queries for Client reducing Mainframe processing charges and storage costs.
• 2014 Implemented High Capacity tape system to further support Disaster Recovery procedures.

Confidential, Overland Park, KS

Lead ADABAS DBA

Responsibilities

• Completed Transition and assumed responsibility for all maintenance of upwards of 80 physical ADABAS Systems.
• Provide LOE (s) for Project Planning for teh EDS Data Management staff for all DBMS platforms supported at Sprint (Oracle, DB2/IMS, Progress, ADABAS, Teradata, Sybase)
• Conduct training, mentoring and monitoring of offshore development staff of 3 DBA (s).
• Developed procedural web based documentation for transition of duties from Sprint personnel to EDS DBA staff.
• Continue to refine automated tools to accomplish required DBA maintenance & housekeeping functions wif a greatly reduced staff size. dis toolkit increase DBA productivity to provide service excellence by putting more tools in teh hands of our end clients as well.
• Provide (+-30%) LOE (s) for estimation and Contract LOE (s) that EDS provides to Sprint as an accurate & actual basis for determining Level of Effort, Total Cost of Ownership, Return on Investment and so on.
• Participated in Install and Configuration of ADABAS 7.4 (Most Current Version of DBMS) for my former account (LA GEARS) and performed duties of System DBA for LA County in mid 2007.

Confidential, Downey, CA

LEAD Technical Engineer Confidential

Responsibilities

• Responsible for ongoing enhancements & maintenance for teh County’s Adult Probation System.
• Duties include ADABAS file maintenance utilizing ADABAS Utilities & performance tuning of existing inventory of NATURAL V2.X being converted to NATURAL V2.3.
• Heavy emphasis on production support and resolving problems encountered during cyclic batch processing.
• Continued to upgrade teh online systems employed for defendant tracking & reporting efforts.

Confidential, Universal City, CA

Lead Technical Support

Responsibilities

• Supported teh integration of teh POLYGRAM/MCA Home Video Systems after teh acquisition of POLYGRAM by Universal.
• Systems were based in COBOLII/DB2 and NATURAL/DB2 running under MVS on multiple IBM Mainframe platforms.
• Provided production support for online data entry systems & online submission of batch reporting subsystem. Resolved production abend situations and provide system enhancements as time permitted.
• Utilized SAG products such as PREDICT & SYSPAC for production migration & implementation.
• Troubleshoot Y2K conversion Modules created by Software AG.

Confidential, Brea, CA

Team Lead/Lead Technician Y2K Conversion

Responsibilities

• Provided retrofit for Y2K conversion of a Stock Portfolio & Record Keeping legacy system for an international financial management corporation.
• Systems were coded in COBOL & NATURAL V2 and interacted wif DB2 & VSAM and ADABAS data structures respectively.
• Natural Connection & Natural PC subsystems were converted as well.
• Systems ran under MVS/TSO for batch applications & CICS

Confidential, Phoenix, AZ

Team Lead/Lead Technician Welfare Reform Act

Responsibilities

• Re-coded existing legacy systems based in NATURAL V2 to comply wif welfare reform policy(s) occurring at both teh state & federal level.
• Systems retrofit also included performance enhancements when possible wifin scope of project.
• Provided on-call production support for existing systems while project was progressing.

Confidential, Arlington, VA, USA

Team Lead/Lead Technician

Responsibilities

• Converted existing legacy system from ADABAS/NATURAL to DB2/COBOL II.
• Systems supported teh Calling Area Data Base (NPA/Area Code Splits).
• Systems were developed on multiple IBM mainframe platforms, running under MVS, TSO/ISPF & CICS for online portions of teh systems.
• Also provided production support for teh existing system during conversion

Confidential, Topeka, KS./Ft. Worth, TX, USA

Team Lead/Lead Technician

Responsibilities

• Completed teh design & coding to adapt Santa Fe Railroads enterprise systems based in DB2/ NATURAL DB2 for teh needs of Burlington Northern due to a merger between teh two corporations.
• Systems were developed in NATURAL/CONSTRUCT & NATURAL/DB2, under MVS, TSO/ISPF & CICS as a TP monitor.

Confidential, AL, USA

Team Lead/Lead Technician

Responsibilities

• Designed & codes systems to support teh NASA Financial Accounting System. dis system was primarily designed to support space station FREEDOM I, however it is envisioned to be adopted Agency wide.
• Systems were designed on DEC/VAX hardware platforms using CADRE case tools & teh Interleaf documentation package.
• Prototypes of teh actual working systems were designed & coded in NATURAL & NATURAL/CONSTRUCT wif supporting ADABAS data structures. .

Confidential, McLean, VA./ Richardson, TX

Lead Technician/DBA/Project Leader

Responsibilities

• Supported rewrite of existing system used by telecom engineers to install new switching packages ordered by MCI long distance customers.
• Systems were written in COBOL II, NATURAL, ALC & PL/I. System originally was designed for on-line support and re-coded to operate in an online submission for batch execution in background.
• Authored teh Logical Data Base Design for system retrofit.
• Project leader for subsequent conversion of ADABAS Direct Call & ADAMINTS embedded wifin ALC & COBOL Programs. Converted inventory of 2000 + modules written in Natural 1.2.7 to Natural 2.1. Executed on multiple IBM hardware platforms under MVS & TSO/ISPF.

Confidential, Dallas, TX, USA

Lead Technician/DBA

Responsibilities

• Performed teh Duties of ADABAS/IDMS Data Base Administrator in support of upwards of 500 applications programmers.
• Utilized all ADABAS/IDMS Utilities & maintained documentation to support teh physical environment via PREDICT.
• Used NATURAL to write application programmers utilities including rewriting PREDICT wif a design that was eventually adopted by Software AG for teh next generation of teh product.
• Wrote COBOL application software wif embedded ADABAS direct calls. Designed & coded parallel systems that mirrored production ADABAS systems in DB2/COBOL II.