SUMMARY

• Total Years IT Experience 29 Years
• Manufacturing/Utility/Insurance/Banking/State Government 29 Years
• MS Word/Excel/ACCESS 18 Years
• DB2 UDB/SQL/QMF 18 Years
• Sr. Business Analyst 5 Years
• Candle Confidential - Omegamon II For DB2 3 Years
• BMC Administrative Products For DB2 3 Years
• BMC Catalog & Change Manager 3 Years
• Computer Associates - Platinum Products For DB2 3 Years
• Visual Explain 3 Years
• Microsoft SQL Server 2000 Enterprise Edition 3+ Years
• Project/Team Lead 3 Years
• DB2 Administrator Utility (DB2 Admin) 1 Year
• DB2 Performance Monitor (DB2 PM) 1 Year
• DB2 Connect 1 Year
• ErWin Modeling Software 3+ Years
• MS Visio Pro 2007 1 Year
• Confidential Rational Rose Object Oriented Development Suite 1 Year
• Confidential - V2R14.10,V2R1 + Years
• Confidential SQL Assistant - V1 + Years
• Confidential Administrator - V14.00 4+ Years
• Confidential Manager 13.00 4+ Years
• Confidential ViewPoint 14.00 6+ Years
• UNIX/ksh/Perl (Sun Solaris) 4 Years
• UltraEdit 2 Year
• NEXUS 1 Year
• MS SQL Server 2005/2008 1 Year
• SAS 9.3 10 Months
• MAXIMO 6 Months

SUMMARY

• Five years working as a Senior Business Analyst interacting with Business End-Users to acquire information for functional and technical business requirements.
• Developed execution plans for system, regression, performance, and end user acceptance testing. Designed and implemented data conversion strategies.
• Assisted with programs for new, and enhanced applications. Identified, documented and assisted with the implementation of process improvements.
• Used full System Development Life-Cycle methodologies in the development of new and/or enhancement of systems. Provide weekly status reports on project milestones, alerting business users, and management to any potential delays.
• Ten years experience as DB2 UDB Database Administrator, three years of the ten with dual role of Microsoft SQL Server 2000 Enterprise Edition Developer/DBA.
• Eleven years as a Confidential Developer/DBA.
• Responsibilities as database administrator included working with Business Analyst to create the logical and physical structures of a database (data modeling), optimizing the logical database design (normalization), set up and identify user accounts and roles (security), ensuring SQL statements were coded for maximum efficiency (using features such as Visual Explain for performance tuning), monitoring of databases for accuracy (referential integrity), replication of databases and tables across different platforms, and preparing steps for recoverability (restoring of database).
• To sharpen skills, I am aggressively pursuing s in Confidential .

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Asked to convert to Full Time Employee by Confidential because of my extensive experience with Confidential .
• As a Full Time Employee, I was reassigned to their Performance Metric Tuning team to directly work with senior management, and Confidential DBA’s to produce various Capacity Planning graphs showing the performance of the different Confidential platforms.
• I am also in the process of cross in SAS, Hadoop, and Informatica.

Skills Utilized: UNIX, Confidential V2R15.10, Confidential SQL Assistant, Confidential Data Mover, Confidential View Point, CA AutoSys, CA7, Remedy, Shared Platform Management

Contractor

Confidential

Responsibilities:

• Contacted by Confidential for a Confidential Data Mover Production Support position at Confidential .
• Position required strong knowledge of Confidential platform and its utilities, UNIX, Change Management operations, and skills in problem resolution. Assigned role of Confidential - Data Mover Developer / Production Support.
• Responsible for transferring business critical data across five different Confidential platforms.
• To maintain data integrity across all platforms, as primary production platform was updated with new data, my responsibility was to see data mover jobs were executed for various databases/tables to transfer the data to other Confidential platforms for analytical analysis so as to not impact day to day operations.

Skills Utilized: UNIX, Confidential V2R15.10, Confidential SQL Assistant, Confidential Data Mover, Confidential View Point, CA AutoSys, CA7, Remedy

Contractor

Confidential

Responsibilities:

• A month before my contract was to end with Confidential, I received a phone call from an account representative working for Confidential wanting to know if I would be interested in a contract Confidential DBA position.
• I inquired as to how he knew my contract was ending in a month, and he replied, Confidential management did not want to lose my extensive knowledge and skill set working with Confidential .
• I had made such a big difference with performance in their SAS applications using Confidential they asked Confidential to contact me about making a lateral move to their Confidential DBA group.
• I accepted their offer. At Confidential, my responsibilities as a Confidential DBA are to: 1) Work with both U.S. and Overseas developers to ensure their SQL Scripts used appropriate Confidential standards to maximize performance, 2) Implement DDL and DML SQL scripts from data architects to create databases, tables, roles, grant access rights between tables and roles, allocate additional space to databases, modify tables (add / drop columns, modify indexes), and 3) Troubleshoot incident tickets coming from End-Users.

Skills Utilized: UNIX/ksh/Perl, Confidential V2R14.10, Confidential SQL Assistant, Confidential Manager, Confidential Administrator, Confidential Viewpoint, UltraEdit, HP Quality Control

Contractor - SAS/ Confidential Developer

Confidential

Responsibilities:

• Having extensive experience working in Confidential environments, Confidential through the consulting firm Confidential Systems contracted me to work for them as a SAS/ Confidential Developer.
• I was given the tasked of writing SAS applications that extracted strategic card risk information from Confidential ’s Confidential EDW.
• I simultaneously worked for three different managers overseeing groups that produced trend, and monthly analytical reports using SAS applications.
• When SAS applications showed signs of performance issues extracting information from the Confidential EDW, I developed a SAS application that showed which tables were skewed so Business management could request information on those tables be redistributed across Confidential AMP’s. For SAS Developers who had no previous experience working with Confidential, I put together a program to teach Confidential Basics as well as utilization of utilities such as FastExport, FastLoad, MultiLoad, and TPump.

Skills Utilized: UNIX/ksh/Perl, SAS 9.3, Confidential V2R13, Confidential SQL Assistant 7.2, Confidential - FXPORT, FLOAD, MLOAD, TPUMP, Microsoft Visio, Microsoft Office Suite.

Contractor

Confidential

Responsibilities:

• Because of previous experience working at Confidential (BOA) as a Confidential Developer, Confidential Systems was able to provide me with a contract to work in BOA’s Card Technology Credit/Information Management group.
• My assignment was to act as BOA’s Senior Technical Developer for a project to take telephone numbers from various sources, and place their information into a series of metric tables for determining when would be the best time to call a customer.
• Worked with banks Sourcing Partner (vendors) to gather support information such as Service Level Agreement, location where files should be sent (Landing Zone), and a point of contact list if information failed to arrive on time.
• Created Low Level Design document offshore developers would use to producenecessary scripts for Telephone Metrics project. Had a staff of six offshore developers to write UNIX/ Confidential scripts for Telephone Metrics project.
• Provided management with project status reports, and maintained all documentation that would be needed to present to banks Change Advisory Board (CAB).

Skills Utilized: UNIX/ksh/Perl, Confidential V2R12, Confidential SQL Assistant 12.0, Confidential - MLOAD, FLOAD, TPUMP, Nexus, Maximo, Microsoft Visio

Contractor

Confidential

Responsibilities:

• Having previous experience in migrating databases from different platforms, I was contracted by Strategic Staffing Solutions to work at Confidential in their MIS CAP1 - Financial Group to migrate a SQL Server 2005 database to their Confidential platform.
• Working with my SQL Server counter part, created the necessary Confidential equivalent tables, views, and macros to those in SQL Server.
• Created scripts on a UNIX Server, using BCP, BTEQ/Multi Load/ Fast Export utilities, to automate the extraction of data from each table once a month.
• Once everything was created, Bank Groups that provided the monthly feed to the tables parallel tested the integrity of the data by loading data to both SQL Server as well as Confidential tables.
• Since Bank Confidential Standards prohibit the creation of Stored Procedures on Confidential, once a month, I manually executed the scripts for each table to load the data on Confidential back to SQL Server for comparison validation.

Skills Utilized: UNIX/Ksh/Perl, Confidential V2R12, Confidential SQL Assistant 12.0, SQL Server 2005 Management Studio

Contractor

Confidential

Responsibilities:

• Contracted by Confidential Systems to work as a Confidential Developer at Confidential (BOA) in their Confidential Systems (ECRIS) group.
• Because of my strong skills in database administration and development as well as knowledge in migration of systems from different platforms, bank management asked me to oversee the migration of DB2 data from Confidential to BOA Confidential databases and tables.
• Once initial migration was completed, I would do performance tuning on all SQL scripts used in batch Confidential BTEQ (Multi Load, Fast Load, Fast Export, etc.) jobs to maximize efficiency.
• Monitored jobs on a daily basis to ensure the arrival of accounting information sent by Confidential for loading into BOA Databases and tables.

Skills Utilized: OS/390, Z/OS, JCL, UNIX, DB2, Confidential, SQL Assistant 7.1, File-Aid, CA7, Microsoft Visio, Peregrine

Contractor

Confidential

Responsibilities:

• Having strong Database Administration knowledge and skills was hired by Proceed Technical Resources to work as a Confidential Developer/DBA for Confidential (BCBS) of Texas in their Enterprise Information Management Data Delivery department.
• As a Confidential Developer/DBA for BCBS, my role requires me to work with Subject Matter Experts and Business Analyst examining DB2, and Confidential Data Marts for specific data necessary for an outside third party vendor to create tailored reports for BCBS customers.
• Once all data elements have been identified, I create Confidential tables into which the data is to be loaded, Stored Procedures (ETL) to extract the data from various Data Marts/Warehouses to project tables, and use the Explain feature to evaluate the efficiency of my SQL script. Part of this process requires me to export BCBS Customer Access Authority information from SQL Server tables, the SQL Server data is then imported to Confidential tables to control what data can be examined by end users. Working in conjunction with Quality Assurance, verify the referential integrity of the data which has been extracted.

Skills Utilized: OS/390, Z/OS, Endevor, File-Aid, JCL, COBOL2, Confidential, SQL Assistant 7.2, DB2 UDB, SQL Server 2000, VSAM, LOTUS Notes, Erwin Data Modeling Software

Contractor

Project Team Leader CG Technology

Responsibilities:

• Worked as contractor for Confidential, assigned role of Team Leader over Confidential /MBNA project which required me to work with Subject Matter Experts and Business Analyst to identify, and design a process to retrieve specific data from DB2 Data Marts to comply with the BASEL I Confidential Banking Agreement. As Team Leader, I was required to create a Project Plan using Work Breakdown Structure (WBS) principles to identify development task, and Gantt Charts for scheduling work assignments.
• Working with Subject Matter Experts, produced High Level (Functional), and Low Level (Technical) design documents.
• Had a staff of six developers producing COBOL/Batch applications to extract data from DB2 tables.
• Because of time constraints assisted in coding COBOL/DB2/VSAM applications in the retrieval of data.

Skills Utilized: OS/390, Z/OS, JCL, File-Aid, SyncSort, COBOL2, DB2 UDB, BMC Catalog Manager, VSAM

Confidential

Responsibilities:

• Worked as a permanent employee for Confidential, was directed to continue my role in the development of the Confidential System ( Confidential Project).
• Representing the State of Louisiana Department of Social Services was assigned to a team to coordinate efforts with the Confidential ( Confidential ), the retrieval of information from their databases for use in identifying individuals requiring additional aid who had been affected by hurricanes Katrina and Rita.

Skills Utilized: DB2 UDB, OS/390, Z/OS, Microsoft Visio Pro, Rational Rose Suite, DB2 Admin, DB2 PM, Microsoft SQL Server 2000 Enterprise Manager, SQL Server 2000 Components (Agent Services, Query Analyzer, Transact-SQL, etc.), Erwin Data Modeling Software

Contractor

Confidential

Responsibilities:

• Working as a contractor for Confidential, assigned to work as a DB2 DBA for the State of Louisiana Department of Social Services in the development of a new Social Service System ( Confidential Project). Assignment involved: 1) Working with Confidential contractors overseeing the development of new OLTP system, providing them with expert knowledge in design and data modeling of databases for new system, 2) Long term maintenance and recover of databases once in production.
• First Phase of project entailed taking requirement information and building Logical Data Models using MS-Visio Pro
• Using Rational Rose Enterprise Edition created object oriented designs of databases identifying hierarchical relationships between database objects. Assist application developers in writing SQL statements ensuring they perform optimally in their applications.
• Second phase of project, appointed Senior DBA by Confidential management to oversee the data modeling and designing of databases.
• Created and maintain data dictionary, identifying database objects for second phase of project.
• Used mainframe DB2 Administrator and Performance Monitoring tools to maintain performance, and recovery of databases.
• From workstation used DB2 Connect to monitor performance of databases.
• Because of my knowledge in both DB2 and SQL Server 2000, DSS requested I take the lead SQL Server DBA role in two of its conversion projects from SQL Server to DB2. Using SQL Server Data Transformation Services (DTS) exported data from SQL Server tables to mainframe for loading to DB2 tables. Completed both conversion projects on schedule.

Skills Utilized: DB2 UDB, OS/390, Z/OS, Microsoft Visio Pro, Rational Rose Suite, DB2 Admin, DB2 PM, Microsoft SQL Server 2000 Enterprise Manager, SQL Server 2000 Components (Agent Services, Query Analyzer, Transact-SQL, etc.), Erwin Data Modeling Software

Database Administrator / Sr. Business Analyst

Responsibilities:

• Short term contracts with Small Businesses needing enhancements and/or modifications to various software packages. Analyzed their current business operations and provided them with Functional and Technical Specifications.
• Modified customer applications to meet their business requirements.

DB2 Database Administrator

Confidential

Responsibilities:

• Aided Business Analyst in the design of DB2 databases for mainframe, and intranet business applications.
• Evaluated the performance and tuned DB2 databases across 6 SYSPLEXES. Assisted in the upgrade of DB2 software from DB2 version 6 to DB2 UDB version 7.2 utilizing OS/390 and z/OS.
• Contributed to the design of databases for an intranet application used to track the amount of time applications ran on 18 different mainframes.
• The information gathered was used for performance tuning, and in turn saved the company over 1 million dollars in operating cost annually.
• Set up new databases and modified existing databases using BMC Catalog and Change Manager.
• Using Candle Corporations Omegamon II and BMC Administrative Products for DB2 evaluated the performance of databases.
• Using Platinum Products for DB2, set up database tables and indexes for backup and reorganization.
• Participated in upgrading DB2 software from DB2 version 6 to DB2 UDB version 7.2. Worked with Confidential administrators coordinating the connection of applications between Confidential and DB2 databases.
• Worked on Confidential 's Vision Team to encourage employees to come up with innovative ideas to cut cost.

Skills Utilized: Confidential OS/390 & z/OS, DB2 UDB, BMC Catalog & Change Manager, BMC Admin. Products, Omegamon II, Confidential 8i

Confidential

Responsibilities:

• Hands-on lab experience with Oracle8 database administration software.
• It included: Hands-on lab experience preparing Hardware and OS for Oracle8 Installation.
• Hands-on experience installing and setting up Oracle8 Sever, Client's, Net8. Creating and configuring new databases, table spaces, data file storage management.
• Hands on experience creating and maintaining user accounts and roles. Hands on experience with Import/Export, Hot/Cold Backups, Rman Configuration and Rman Backups, Server ManagerMichael L. Wells Page 5 of 5
• Confidential Enterprise Manager (OEM), SQL*Loader, PL/SQL and SQL*Plus scripting.
• Recovering Oracle8 database using Hot/Cold backup, and Rman backups.

Skills Utilized: Confidential, Confidential Server, SQL Loader, PL/SQL, SQL*Plus

Confidential

Sr. Business Analyst

Responsibilities:

• Maintained a daily log that documented tasks completed on or ahead of schedule, later used to bring about resolution to $3 Million in disputed charges.
• Member of a redesign team of Analyst and Database Administrators, taking the client's current CIS Utility System (COBOL/VSAM), and gave it greater functionality (COBOL/DB2) to meet their requirements for deregulation.
• Researched, developed and produced Functional and Technical Specifications, later used by Programmer Analyst to modify and give greater functionality to the client's current CIS Utility System.
• Oversaw and assisted Programmer Analyst during the coding of applications (COBOL/DB2). Loaded DB2 tables with initial customer and validation parameters.

Business Analyst

Responsibilities:

• Appointed team leader over Confidential (CSS) Functional Documentation project.
• Supervised ten other Business Analysts assigned to the project.
• Coordinated the designing and development of a LOTUS Notes database repository for functional documentation.
• Completed project six months ahead of schedule, and distributed to CSS Sales Representatives in the field.
• Reassigned to Utility Development project, analyzing Accounts Receivable and Billing requirements. Mentor to college hires.

Skills Utilized: DB2, COBOL, VSAM, CIS Utility, LOTUS