Data Migration, Integration, Cleansing And Conversion / Consultant / Dba Resume
Qualifications:
Thomas has 20+ years of experience in Information Technology with supervisory or management roles in each of thefollowing areas:
7 years DBA Contract Data and Database Migration including Mainframe to PC database conversions and Data Mapping, retrieval, cleansing, consolidation, mapping, and reporting for client review.
He has been responsible for Total Project Management with multiple clients utilizing MS Project scheduling reports as main source of status and timeline management during his years as a Contract Data and Database Migration provider. He has been a central functional consultant during multiple Cutover processes with city and county Police, Fire and EMS dispatching and records systems in the US. Provided weekly and milestone summary reports to clients and final consumers and co-ordinated with other groups, such as program developers, when field type or size changes occurred in the receiving systems, or client customers when needed data, for new system, was found on client customers individual computers in: excel, Outlook, dbase, paradox, Oracle, MS SQL, MySQL or word processing systems. In addition he worked five years as a systems and production control analyst for AFLC at McClellan and Wright Paterson AFB. He has taught elementary and advance classes in Microsoft Project, as well as, all of the products in Microsoft Office. He has experience operating and successfully completing simultaneous customer Data migration contracts. He has had ERP processing experience which included data access security settings, control, and definitions for multiple customer types across multiple city and county agencies. He has also been:
DBA Corporate Intranet Data consolidation and performance Consultant
Database Systems Consultant / Corporate Data Analyst / DTS Consultant Instructor
Data Analyst / Database Developer / DBA / Database Instructor / DBA Manager
Project Manager / Project Director / Program Manager
PC Applications Programmer / Windows Operating System Instructor
Applications Developer / Lead / Supervisor / Manager
Configuration / Change Control Supervisor/ Manager
Assembler Programmer / Systems Programmer / Systems Supervisor
Production Control Analyst / Supervisor / Operations Manager
Help Desk Analyst / Supervisor
Eight years in Retail and Service industries.
WORK EXPERIENCE
December 2004 – present
Self employed:
Data Migration, Integration, Cleansing and Conversion / Consultant / DBA – Confidential,
Confidential,Project Management, Project /Program Cost Assessment and
Data: Migration, Integration, Cleansing, and Conversion (Identification, Analysis, Mapping, Conversion including DTS to SSIS, and Reporting) services for Multiple Software Vendors, in multiple locations throughout the United States.
The Software Vendor Systems include but are not limited to:
CRM (Customer Relations Management Systems), CIS (Customer Information Systems) IMS (Inventory Management Systems), SMS (Supply Management Systems), Public Safety (Police, Fire & EMS) ((State, County, local))
Rent Management Systems, and POS (Point of Sale Systems)
Data sources for these conversions included but are not limited to:
IBM (AS400 and mainframe) DB2, Oracle (7.0 – 11i), MS SQL (7.0, 2000, 2008),
MySQL, MS Access (1.0 – 2007), Excel (1.0 – 2007),
Paradox (((1.0, 3.5, 4.5) for DOS), (4.5 – 11.0) for Windows), FoxPro, Dbase (I, IV),
MS Word (1.0 – 2007), Adobe PDF, and various record files (text, comma delimited…)
Programming languages used include: MS SQL, PSQL, VB, VBA, VB.NET, ASP.NET, ObjectPal, Pal, Basic, Delphi, COBOL and JCL.
December 1996 – November 2004
Systems Support DBA Consultant – Confidential,
Confidential,provider of Program: Support, Modification and Migration of legacy Paradox and Paradox for Dos systems to Delphi using Erwin 3.5.2 with Microsoft SQL 7.0, Microsoft SQL 2000 and Oracle. Used HTML, XML, JavaScript, Cold Fusion, and ASP to create corporate intranet applications from existing systems. Consolidation and data validation of department data systems to corporate Intra net data systems. Used T-SQL to update Oracle Systems from Microsoft SQL 7.0 database. Paradox to Microsoft SQL 2000 migration using Delphi. InstallShield, Wise, Paradox, Access, Excel, Crystal Reports 7.0 Quattro Pro and Word Document Conversions using DTS to create Corporate Data Stores including use of Business Objects Designer to create small scale product requirement history reports. Created and published Universes from Oracle 8 database system. SQL modifications and promotion of applications to N-tier systems. Program support, modification and migration of legacy systems to Delphi with MSSQL. Paradox to Access conversions, InstallShield installations. Developed, used, and taught Crystal reports class to client management and staff. Program Modification of an existing credit card system for Y2K validation. Re-wrote 5 applications to be Y2K compliant. Improved performance by over 400% on all systems. Provided custom Utility paradox programs for various Y2K tasks. Database Cleanup, restructuring and documentation, and program modification of an existing credit card processing system as system was upgraded to Oracle.
Project Manager Consultant – Confidential,
Directed 22 programmers, develop schedule, provided for their hardware, and software needs. Formulated and implemented a plan to upgrade all existing client systems to Year 2000 compliance. Coordinated and controlled implementation and training of new and existing systems. Worked with Microsoft Project 95 and Microsoft Project 2000. Converted all schedules. Updated and inserted tasks and developed new projects. Instructed 150 people in use of Microsoft Project though self created structured learning plan, classroom instruction, and hands on support for their projects and definitions. Developed Cost Project budget reports for company wide usage.
Created and implemented small in-house applications using Paradox, InstallShield, Microsoft Access, Microsoft FoxPro and Delphi. Upgraded programmers work computers systems from i386 to Pentiums.
September 1995 to November 1996
Software Product Development Manager, Confidential,Beaver Creek, OH. Designed, developed and tested and controlled the development Public Safety Software, a Client Server Database Application, using Borland Paradox, Microsoft SQL and Delphi IDE’s. Duties included System Analysis, Development Controls (PVCS) Network Management, InstallShield, and DemoShield. Also included were minor sales duties. Product sold to another developer in November.
Self-Employed Software Developer, Confidential,Centerville, OH
Creator of Database/Windows database application systems for use on i386 and i486 DOS machines using MSSQL, Oracle, Paradox, FoxPro, Access, Sybase, Interbase, and dBase IV. Duties included System Analysis, Data Acquisition, Work Flow Analysis, Cost Benefit Analysis, Market Research and Development, Marketing, System Integration, Customization training for clients in procured software such as Microsoft Windows, Windows NT, Office, Word, Excel, Power Point, Microsoft Project, Paradox, Crystal Reports and DOS 5.0, 6.0 & 6.2, Development work included but was not limited to Table and Form creation formatting and testing for Customer Update and Searches, Data entry for new customers and work orders, automated inventory control and modification of minimum and maximum hold quantities using historical queries. Standardized report generation of daily, weekly, monthly, quarterly, year-to-date and yearly reports: Income, Accounts Payable, Accounts Receivable and Sales Tax. File creation for use with Quicken 2.0 for Windows and Quick books. Shipping system for UPS shipments including labeling, automated price increase notification on all stock received. Labor cost tracking and charge back.
System Engineer – System Programmer, Confidential,Reston, VA. Production, Operations and System Analyst utilizing Word Perfect, PCPlus, Assembler, Roscoe
RPF Language, Quick job, COBOL, TSO, CICS, VSAM, VTAM, CA-7, CA-11, CA-APCDOC, CA-Manager, CA-Dispatch, CA-TLMS, CA-Ideal, CA-Librarian, CA-Earl, CA-CULPRIT, CA-IDSMS/R and
JCL on Amdahl 58xx and 59xx series IBM 390-200e and 3084 machines. Duties included but were
not limited to: PC Support/recovery training with Paradox, Procedure writing and analysis, Migration procedure writing, MVS system support, MVS Exit writing, User problem definition, problem trend analysis, workload and scheduling analysis, Work center operational review and Software training and procedures.
WORK EXPERIENCE (continued)
April 1985 to June 1991
Programmer/Analyst, Confidential,Falls Church, VA
Production, Operations, and Systems Analyst. Originally hired as Help Desk Technical Support Staff and quickly moved to Junior Programmer/Production Analyst at the Naval Military Personnel Command Headquarters in Washington, D.C. as a result to programming changes made to PC based Problem Tracking System. Promoted and transferred to Sacramento, California as sole corporate representative to the Air Force’s ALC. Implemented, trained and supported the U.S. Air Force Logistic Center’s Base Operating Environment. The migration of a Multi-vendor, Multi-CPU, Data Center to an automated and integrated lights out operating Environment. Instrumental in reducing System CPU percentages by 36.7% in two-year period. Migrated many Job Streams from a manually submitted system automated scheduling. Provided PC technical support in movement of one production system from mainframe to PC Client Server Environment using Paradox for DOS. Another migrating system with my JCL modification reduced wall clock time from 11 minutes to 72 seconds, reduced CPU time by 43.4%. These two migration efforts alone resulted in a yearly savings of $160,282 in processing costs. Provided technical briefing support using Harvard Graphics and Word Perfect.
Operating Systems:
Windows XP,2000, NT, 98 & 95, Windows 1.0 - 3.1. Windows for Workgroups, DOS 5.0 &
6.0, System 7, OS/VS1, MVS, MVS/XA and MVS/ESA, MVS/ESA.
Software:
Programming Languages:
Visual Basic (VB6, VBA, VB.NET), ASP.NET, Delphi, SQL, ObjectPascal, C++, ObjectPal, HTML, XML, JavaScript , Paradox Application Language, dBase III+, dBase IV, PICK BASIC,Cobol, Ideal, Assembler (MVS-H), RPF, MVS Basic, Quickjob, Culprit, Job Control Language (OS, MVS, MVS/XA & MVS/ESA)
Supported and Installed Products:
MSSQL 7 - 2008, Oracle 8.0 -11i, Delphi 1.0 - 7.0, Paradox for Windows, 1.0 – 11.0, Visual Foxpro, Crystal Reports, Erwin, BusinessObjects, Installsheild, DemoSheild, dBase IV, dBase III Plus, Access, Windows 95, Windows, Windows 2000, Microsoft Project 4.0 - 2000, DOS 5.0 & 6.0, Word Perfect, Microsoft Word, Excel, CA–0, Novell, CA-TLMS, CA-7, CA-11, CA Dispatch, CA-Look, TSO/ISPF, RMFMON, Roscoe
Hardware:
PC Pentium (I-VI), i486, i386, i286, and AT IBM DOS machines. Apple II & IIIs, Macintosh, Mac Plus, and Performa Series Apple Machines, IBM 390-200e, 3084, 3081,4341, 4381, as well as Amdahl 58xx series.