SUMMARY:

• Senior Technical Consultant working with the government for the last 26 years, with experience in database management, project planning, research and meeting customer requirements and deadlines.
• Senior Programmer Analyst for 11 years in the private sector planning, supervising, developing, testing, and training for multiple systems in Cobol and Assembler.
• Training of displaced workers, basic training of Confidential troops, swim instructor for Confidential troops, Data Processing Technician
• Lead Data Integrity Project
• Lead Officer’s Reference Tool Project created in SharePoint
• Lead project for documentation of all application systems into Managed Objects Monitoring Tool.
• Lead programmer and staff supervisor
• Created and taught programming class
• Structured Development Methodologies
• Data Normalization
• Modular programming
• Data Research analysis
• Problem solving
• Training
• Testing

TECHNICAL SKILLS:

• Cobol
• CA - SQL, CA-DQRY, CA/Platinum tools. CA-DataReporter
• MS Office tools: VISIO, EXCEL, WORD, POWERPOINT, SharePoint
• EASYDBA
• SQL SECURE
• Secure Network Services
• Oracle SQL*Net/MVS
• CA-Datacom
• DB2
• Oracle
• IBM 3090/720
• IBM 3090/820
• HDS EX/100
• HDS EX/65
• HDS EX/310
• IBM/RS 6000
• IBM SP2/AIX

PROFESSIONAL EXPERIENCE:

Confidential

Production System Monitor

Responsibilities:

• Tracking Primary Transaction activities that are slated to be converted to Confidential to determine the overall usage.
• Working on extensive research of table relationships, programs, and data content; documented all the current table sizes (in rows and record length) along with the date of the oldest data; tracked the activity for all tables not moved to Oracle, compared to tables already moved to Oracle.
• Working with the retirement committee to develop processes to retirement obsolete objects and set a standard for retiring the systems in Datacom as they become modernized.
• Working with the deployment committee to review Implementation plans and plan for future deployments.
• Acting as a representative on the System Engineering committee to review and approve changes to be presented to the Board of Directors Steering committee.
• Acting as a representative on the Security committee to review Internal Audit and security requirements for the modernization of application systems.
• Provides support to the modernization teams, and assists with new projects that affect multiple systems.
• Additional duties are to evaluating Impact reports for potential problems, monitor volume counts, working with the application teams to archive and partition data files that were exceeding growth limits and provides government leads with collated representations of the systems currently supported. This system receives over 6 billion requests per day, 151 million adds, and 67 million deletes per day, supports 1700 tables on Datacom and 500 tables on Oracle. Approximately 167 TB on Oracle, and 500 TB on Datacom.

Confidential

Production System Monitor

Responsibilities:

• Duties with Confidential & Confidential are the same duties performed for Confidential . The contractor changed the job did not.

Confidential, CA

Database Administration Technician

Responsibilities:

• Supported 3 high profile systems on DB2 which includes image copies, reorgs, performance monitoring, adding new tables; supporting table changes, and stored procedures. She has basic experience in using CA/Platinum tools. These systems use LOBS, partitions and store procedures.
• Was the primary DB2 DBA working with the Application Team to put in place a very high profile project on DB2 to support an agreement between President Bush and the Prime Minister of Canada. The project involved the creation of over 200 table spaces, tables, and indexes, the migration of this from the development to testing and production environments. This project had a very short turn around time and required extensive coordination with other teams.
• Was part of the Database Administration team working with CA/Datacom for the nine development MUFs, eight SAT MUFs (used for quality assurance), and 13 production MUFs. These environments have share datasets and star links across multi-platforms. The DBA team is responsible for the physical and logical design of new databases, the approval of any database changes, the changes to the development environment, and the transfer of the changes to the Sat and Prod environments. They are also responsible for reorganizing tables, reallocating space using SMS, maintaining a 24-hour on call service and working weekend maintenance outages. There is additional support given to the Data-Query users and the developers in the field.
• Worked as part of the team to establish and test the conversion of AES from Datacom to DB2. This involved establishing the DB2 environment, defining STORGROUPS, defining tablespace, converting the tables, converting the data, and loading the data into the new environment. Worked on the DB2 team in addition to maintaining the work load on the Datacom systems. As a member of the DB2 team assisted in establishing operations rules, monitoring rules, and guidelines to support problems with the system.
• Was part of a six-member team actively involved in the development of a distributed environment using IBM/RS 6000, and IBM SP2/AIX with the Oracle database. This process includes installing and testing third party products such as EASYDBA, SQL SECURE, Secure Network Services, Oracle SQL*Net/MVS and several online training products. Worked at setting up table definitions, creating users, creating roles, granting privileges, defining table space, and monitoring table space usage.
• Previously, working as a Senior Database Consultant assigned to the Customs and Border Protection Situation Room; as part of a three-person team responsible for monitoring five mainframes: IBM 3090/720, IBM 3090/820, HDS EX/100, HDS EX/65, and a HDS EX/310, running eight MVS/ESA Operating System environments. This environment included 26 CA Datacom/DBMS and 60 Confidential regions; was responsible for identifying and resolving problems in a quick and efficient manner. During the third shift, the team acted as the management control center for all activities that occurred in the data center and the field.

Confidential

Database Specialist/ Senior Programmer & Analyst

Responsibilities:

• As a Database Specialist, worked to maintain the corporate physical database using CA Datacom; with responsibilities for physical database design, performance analysis and tuning, backup, and recovery. Assisted in the installation, upgrade, maintenance, and security of the system.
• As a Senior Programmer and Analyst designed, analyzed, coded, modified, tested, and documented programs and systems using COBOL batch and Confidential Command. Project lead for an in house system with a staff of contract programmers.

Confidential

Programming Instructor, Parkersburg, WV

Responsibilities:

• Trained displaced workers in computer programming in BASIC and COBOL, which included testing and selection of the students.
• Established a training class and course description
• Procured equipment, located and rented space for a class room