SUMMARY

Extensive experience as a IT Professional, with responsibility for all life-cycle phases of program development, from innovation to implementation including project management, data architecture, data governance, data modeler, database administration, testing, quality assurance, production support, of application development and data base management.Unique combination of being technical and people oriented, achieving improved productivity and quality through the development of people and more efficient use of resources.

TECHNICAL SKILLS

Operating Systems MVS/OS/VS/XA, IBM 360/370/380X/390, OS/390, z/OS, OS/2, Windows, MS-DOS, HP-UNIX, TCP/IP, LAN/WAN

Languages COBOL, ALC, C, PL1

Data bases IMS DB/DC, DB2, Oracle, SQL Server, VSAM, Access,

Support IBM Utilities, BMC products, Platinum products, Candle products, IMF, QMF, SQL, SPUFI, SAS, ADF, EXPEDITER, Syncsort, SMS, FDR, SMS, NDM, FTP, HSSR, CA1, CA11, JCL , TSO/ISPF, Clist, REXX, IOF, Bundle, MQ, CICS, InterTest, Roscoe, SQL Management Studio, Toad, Visual Studio, Remedy

Debugging Fileaid, Abend-aid, StopX37, Expediter

Scheduling CA7, Control M

Case tools//Modeling IEW, ADW/KEY, BACHMAN, ERWin, Arbutus, Oracle Designer, Toad Data Modeler, SQL Developer Data Modeler, Visio

Change Management Librarian, Endevor, ARMS, PVCS/Tracker/Version Manager/Dimension

Performance tuning Strobe, Omegamon, MICS/SAS, IMF

Security RACF, DBRC

Compression Shrink, Data Packer

PC Visio, Microfocus-Cobol, Inspect, Stingray-IMS, XDB-DB2, Lotus, WordPerfect, Timeline,

Estimator, Harvard Graphics, PVCS Tracker, CAD's, Power Builder, Designer Pro

Web HTML, JAVA, FrontPage

Microsoft Project, Access, Word, Excel, PowerPoint, Outlook, Visio

EXPERIENCE

Data Administrator/Data Modeler/Data Architect/Oracle DBA/Developer

• Supported multiple business analysts and developers to analyze user requirements, functional specifications and system specifications for the purpose of creating conceptual, logical, and physical data models OLAP and OLTP .
• Disseminated information to the users on naming standards, data governance, normalization rules within CBP.
• Created, designed and reviewed logical and physical models including Data warehousing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling for DB2, ORACLE, and SQL Server.
• Performed forward and reverse engineering processes to create DDL scripts or physical Data Models.
• Provided technical assistance and guidance to the program office as the physical data architect for analysis of data requirements to third form normalization.
• Maintained the contents of the CBP Data Dictionary and provided DBA support including backups, downloads, recoveries, upgrades to SQL server.
• Acted as the ERWin administrator, installed software on user's desktop, provided technical support, testing and training.
• Extracted data from data bases and system tables from the mainframe for DB2, Oracle, SQL and Datacom for the purpose of creating tables, reports and building repositories including tools such as SQL Server Integration Services, Toad, and Oracle Warehouse Builder.
• Executed and maintained scripts on the mainframe for updating Datacom, DB2, copybooks and Cobol data structures.
• Developed SQL scripts to produce reports within ERWin's Data Browser to enhance validation and identification of entities and tables components across Model Mart.
• Developed Procedures and Process , documentation as needed.
• Reviewed and mapped data components to NIEM domains as input to creating IEPD's.
• Extracted all the metadata within ERWIN for CBP to build new repositories for fact analysis, data mining and reporting.

Confidential

Oracle DBA/Developer

• Provided support and advisor to the SSA Medicare program director for the DB2 Data Base Special Project group. Provided data analysis, architecture, data modeling, physical and logical design, and production support.
• Developed short turn-around programs and SQL queries for Congressional and Management.
• Provided technical assistance to the LM team and SSA personnel for DB2/COBOL batch and online mainframe support.
• Maintained the Medicare Part D Data Base Data Dictionary.

Confidential

Construction Manager/Estimator

Developed material takeoffs and material lists from existing construction drawings, inspection of potential jobs, and customer request.

• Developed construction drawings for customer review and county approval using CAD packages.
• Prepared cost estimates for material and man-hours.

Confidential

Supervisor/Team Leader Programmer/Analyst

• Supervised/lead the activities of a team of analysts and programmers responsible for the continuing application development and ongoing production support for the GEICO Billing System a large Batch/On-line system CICS/DB2/IMS/COBOL .
• Monitored and advised the DBA IMS/DB2 on data base issues concerning the application and performance enhancement.
• Evaluated User request, problems, and new business needs for feasibility, prioritization, and best utilization of resources.
• Acted as Project Manager/Project Leader to create/ review and approve project plans, requirements, designs, test plans, scheduling, implementation, and documentation.
• Acted as the CM and Release manager for software control and movement of more than 30,000 components.
• Provided trouble shooting, resolutions and identification of testing and production problems.
• Led the continuous initiative to improve data base performance that included the partitioning of data bases, and the development of an archive process to off load/migrate and retrieval process of old data on the data bases.

Confidential

Consultant Production/Development/DBA

• Provided overall Tier ll technical responsibility for the production support and technical support of the Local Billing application that included seven production environments plus test environments across multiple platforms MVS/DB2/COBOL/HP-Unix/Oracle for batch and online.
• Served as the one-point of contact concerning technical issues for anyone interfacing with the Billing System team, this included system programmers, testers, data center personnel, developers, DBA's and third party vendors.
• Monitored DASD space, data bases, tables, and job performances using PL/SQL, STROBE and Omegamon for the purpose of improving performance. Improved the abend rate by more than 85 .
• Created test environments and tested new and modified system software.
• Reviewed the contents for any software going into production, such as, documentation, coding, JCL, SQL, database changes, and UCC7 changes, for omissions, accuracy, and performance considerations.
• Handled problem identification and determination, and recovery for the application 24/7.
• Taught JCL and performance considerations to the development staff.
• Acted as the application DBA for DB2 and Oracle.
• Performed all activities for the maintenance of data bases such as unloads, reloads, runstats, queries and updates using SQL.
• Acted as the Security Administrator using RACF and PVCS.
• Acted as the Configuration Manager using Endevor and PVCS.

Confidential

Senior Technical Staff Member

• Coordinated, controlled all activities for the daily operation of a 6 billion billing system COBOL/IMS/DB2 batch and online that included analyst, programming, problem determination and resolution, development of personnel provided technical support performance tuning and system enhancements.
• Designed, documented and implemented a disaster recovery plan for the application.
• Provided support for maintaining and continue development for the production and test environments, that included maintaining, design, construction, and modifications for the IMS and DB2 databases.
• Monitored the system tables and data bases using Candle, Omegamon, BMC software and QMF.
• Worked with project control tools such as Timeline, Visio, Estimator, Microsoft Project for the purpose of producing schedules, estimates and charts such as GANNT, PERT, Entity Relationship Diagrams, Data Flow Diagrams, Structure Chart Diagrams, and work breakdown structures WBS in my efforts to monitor, control, and make risk assessments.
• Acted as the Release manager that approved all movement of software after verification of its disposition.

Specialist Technical Support

• Provided technical support for more than two hundred programmers within the division for DB2/IMS data base and programming support.
• Coordinated and created the Technical Development Platform . This effort included the reverse re-engineering of the software on the mainframe, utilization of KEY CASE tool , creating an environment on the PC that simulated the mainframe using COBOL, DB2 and IMS.
• Acted as administer for Version Management and Tracker.
• Certified by Sterling for teaching Vision: Assessment, Redocument, Recode , and Inspect a system-wide analysis tools . Implemented, installed, and trained individuals for usage of mainframe and PC development products in Va., Fl. and NJ.
• Evaluated PC software products for requisition.
• Monitored acquisitions, purchases and costs and prepared Management Proposal for Cost Reduction, Resource Usage, and Areas for Improvement. Developed training package, training schedule, course material, and classes for PC's products interfacing with the mainframe.
• Created and maintained the monthly metrics for Cost and Performance for the district.
• Lead the Performance Improvement Team composed of AT T and IBM personnel, to evaluated database and application performances including redesign and denormalization of tables for performance . Operating cost was reduced by more than 36 with minimum coding changes, to reduced CPU, wait time, elapsed time, and I/O.
• Produced a 75 page document containing an evaluation on database and application performances and coding techniques.

Specialist/Project Leader Testing/Release Mgr/QA/DBA

• Coordinated all testing activities from two outside contracting companies EDS and CBIS that provided functionality testing, performance testing, regression testing, for the application.
• Provided input and direction for QA, usability assessment, test plans and strategies.
• Reviewed requirements, test plans, test cases, and test data to assure quality of the testing.
• Assured that all problems were tracked, documented and assigned to the appropriate group for resolution before additional testing.
• Acted as the AT T Release Management/Configuration Manager Software ARMS Coordinator, responsible for all software movement.
• Acted as the DBA for maintaining the test system, including 80 clone DB2 environments.

Senior Programmer/Project Leader DBA

• Provided DBA and Tier II support for the LDS billing system 65 million customers . Provided data analysis, architecture, data modeling, physical and logical design, and construction for IMS and DB2 databases.
• Managed all activities associated with the maintenance and use of software control and provided support, problem identification and resolution.
• Identified savings that resulted in more than 1.6 million in annual spending via DASD reduction, performance enhancement, and elimination of processes

Project Leader/Manager Development/DBA

• Directed the activities on behalf of 32 individuals within Application Support Group programmers and DBA's .
• Established methods and procedures for setting-up, and running the application at two new data centers.
• Provided training to group personnel in learning IMS and application knowledge to improve productivity.
• Provided support for a large integrated IMS system across five complexes over 30,000 users 2300 databases, 11,000 production jobs for 95 million customers.
• Installed DBRC for the site and provided training.