Professional Summary

Over 25 years of IT experience, including programming, systems analysis, DBA, Q/A, systems administration, design testing, re-engineering with full life-cycle methodology, database administrator, software engineer, software development, project management, consulting, strategic planning, senior-level project leader, training / mentor, and full software support on HealthCare utilizing IBM Mainframe, MS Windows and MS Office

Highlights of Qualifications

• I have over 25 years of professional experience assisting with the extraction and analysis of data elements from multiple sources in varied formats including mainframe flat files and RDBMSs. I have Read COBOL code and translated logic into pseudo-code and contributed to the developed of analysis documentation. I have developed code using COBOL, FOCUS, ACF2, RACF, JES2, Easytrieve plus, JCL, IBM Assembler, PL/1, JAVA, CRYSTAL REPORTS, TRACE OSCAR, CLAIMS, MASTER, ENDEVOR and many more programming languages for the financial, manufacturing, retail, insurance, healthcare, inventory control, material requirements and planning, telecommunications, banking, accounts payables, accounts receivables and much more.
• I have utilized Systems Development Life Cycle Methodology and other software applications development methods with Requirements Definition, Design, Development, Code Writing, Testing, User Acceptance Testing, Debugging, Deploying these software products to the production platforms and provided post-implementation supports for Verizon, MCI, Sanders Associates, Wang Laboratories, Montgomery Ward Insurance Group, Care first, APWU healthcare, and most of the US federal Government Agencies.
• I have utilized my experience with FLAT files, VSAM, MYSQL, ISAM and other data files with COBOL for all these employers, re-engineered from FROTRAN to COBOL and IMS COBOL, from PL1 format to DB2/COBOL, maintained COBOL programs with IDMS and ORACLE and DB2 database as well as CICS, and much more in designing, developing, maintaining, and testing these applications.
• Senior IT Project Leader with proven expertise in major programming languages and latest technical tools.
• Consistently completed projects before deadlines, saving employers significant money.
• Recognized by upper management for major accomplishments during large/complex projects.
• Possess a Master's Degree, certifications, extensive training and security clearances.
• I have taken charge of development, maintenance and support responsibilities.
• Excellent interpersonal and technical communication skills.
• Proven ability to streamline administrative tasks, manage multiple databases, alter and migrate database objects, optimize databases, improve database retrieval and monitor critical resources.
• I have kept data secure and reliable, performing online database reorganization and reduced database downtime.
• Performed the migration of CICS/DB2/IMS/VSAM/FILE-AID, ORACLE to the latest versions as a DBA role on IBM Mainframe.
• Problem determination and provide resolution.
• Installed and deployed IBM and other vendor software products.
• I have proven experience in configuring and implementing and enterprise wide configuration management discovery and dependency mapping tools such as Erwin, Rational RequisitePro, HP Quality Center, SharePoint and MS Office for systems and applications.
• I have proven experience in using CMS modeling tools utilizing configuration items stored in the configuration management database.
• I have proven experience in development and integration using object oriented languages such as Java, NET, and XML.
• I have utilized JYTHON, JSCRIPT, TQL, PL/SQL in writing scripts for several Federal Government and commercial employment places using Sun Servers and AIX/WebSphere.
• I have proven experience with Oracle, SQL Database, enterprise Application Architecture, PureXML, XML development, ETL.
• I have excellent knowledge of software languages and COTS applications.
• I am very proficient in MS Word, MS Power Point, MS Visio and MS Office.
• Maintained and implemented system software and various vendor products.
• Provided day to day technical support on HL7, HIPPA, Z/OS, REXX, CM, DPF, HADR, TMON, VMS, ENDEVOR, CICS, DB2, RACF, ACF2, JES2, ORACLE, ERWIN, HP, TOAD, IMS DBCTL, IDMS, VSAM, SAS, C , FILE-AID, CULPRIT, HIPPA, BMC, MCS, MRP, INVENTORY, SDLC, MicroFocus COBOL, MMIS, MEDICAID, DATAWAREHOUSE, OLAP, OLTP, CRYSTAL REPORTS on the IBM Mainframe.
• Created Test Plans, Test Scenarios, Test Scripts utilizing People Tools, People Code.

Professional Experience

Database ANALYST/DEVELOPE/DESIGNER/TESTER, Confidential

• Working as senior developer/degigner/tester utilizing , DPF, RACF, ACF2, JES2, SOP, HADR, COBOL, IMS, OSCAR, CLAIMS, TRACE MASTER, ENDEVOR, FILE-AID, JCL, UTILITIES, Testing and debugging tools on IBM Mainframe and Servers, and taking lead role on these and disciplines for HealthCare Provider for the Nationwide, Financial Institution.
• Performing Requirements and Definitions, Analysis, Design, Data Mining and ERD.
• Supporting the Data Warehouse projects as a developer for the HealthCare databases related to Patient care and billing, Provider database, Medicare database and the Claims database.
• Developing, Maintaining,, and Supporting the existing Systems.
• Providing Support for HealthCare, Patient database, Providers and Claims.
• Advising and Collaborating with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
• Developing, coding, testing, debugging the application software for the major healthcare industry applying the HIPPA regulations using DB2, IMS, COBOL, ALC, CICS products with full code testing.
• Assisting all development work on DB2 , IMS, CICS with application development designing and creating database objects, migrating from test to production and implemented batch schedules appropriately.
• Utilizing appropriate IBM and other tools and utilities to accomplish this.
• Performing duties as developer, a quality assurance person in the software development projects utilizing COBOL, ALC, ENDEVOR, ISPF, TSO, JCL, VSAM, DB2, CICS, IMS, Task Manager, and many more tools and techniques.
• Delivering quality solutions, to Customer Acceptance and Satisfaction with end products
• Utilizing Innovative approaches in problem solving.
• Working with minimal directions from the management and achieved the goals with efficient results and quality.
• Working very closely with the technical as well as the non-technical staff and users with responsibility.

Sr. Database Analyst 07/12 to Current

Confidential

• Performed requirements analysis activities on National Vendor File project.
• Performed data analysis to identify significance and business usage of various elements in a vast database for the Social Security Administration Office of Disability Systems. Main drivers are the Electronic Disability Collect System and National Vendor File.
• Assisted with data conversion process from silo legacy database files to nationwide repository.
• Applied facilitation techniques, training, methodology development and evaluation.
• Participated on the weekly meetings for the NVF File Conversion, for the State of Illinois Data Conversion process with the rest of the project team members that was driven by the customer site.
• Facilitated meetings to elicit and discuss requirements for the project. Additionally, document and
• Publish meeting minutes when required.
• Utilized appropriate key tools, such as Rational RequisitePro, HP Quality Center, SharePoint, MS Office, and other Data Conversion and analysis tools to measure project progress against business-focused requirements.
• Performed Requirements elicitation and documentation Detailed Functional Requirements, User Need Analysis, Data Conversion Specifications, and Data Dictionary .
• Utilized several programming and analysis tools and languages, such as DB2 database, COBOL, CRYSTAL REPORTS, CICS, JCL, ACF2, RACF, JES2, IBM ASSEMBLER, PL/1, Utilities, SQL Query tools, CLAIMS, 835 and 837 Transactions, CMS Data Modeling tools, Java, XML, Oracle, MYSQL, COTS application, Data Mapping, MS Office, MS Word, MS Power Point, MS Visio, MS SQL, and other tools on the IBM mainframe, Servers and MS Windows..

Software Engineer/DEVELOPER

Confidential

• Designed, developed, tested, performed Q/A, implemented and maintained healthcare software.
• I monitored the Database on a daily basis, optimized SQL queries on the SharePoint technology.
• Responsible as a Database Administrator and took lead role on these and disciplines for HealthCare provider for the Nationwide, Financial Institution and Federal Government Agencies.
• Provided full support on HL7, HIPPA, MMIS and MEDICAID to the healthcare industry.
• Lead the Projects and Performed Requirements and Definitions, Analysis, Design, Data Mining and ERD Coding, Testing, Debugging and Implementation of various large Software Processes and the Stored Procedures for the new Developments and Maintenance, and Supported the existing Systems, and Provided Support for HealthCare, Patient database, Providers and Claims.
• Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment for OPM, some healthcare providers and several federal government agencies.
• I have applied Case Specifications, Detailed Functional Requirements, Data Conversion Specifications and Data Dictionary on various healthcare project Developments.
• Delivered quality solutions, to Customer Acceptance and Satisfaction with end products, utilized Innovative approaches in problem solving. Worked with minimal directions from the management and achieved the goals with efficient results and quality. Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.
• Utilized most of the latest Technological Tools and Software Systems, including Programming Languages and Tools such as MICROFOCUS COBOL, REXX, XML, C , ALC, CRYSTAL REPORTS, JAVA, JDBC, SQLJ, SAS, JCL and UTILITIES, TSO, ISPF, QMF, ACF2, RACF, JES2, ORACLE, ERWIN, TOAD, DB2/UDB/SQL V9.5, HADR, ENDEVOR, DBCTL File-Pro, Stored Procedures, UNIX/Linux Scripts, MQ, JCL, CICS, IBM Mainframe, TSO/ISPF/XPEDITER, SYNCSORT, SHAREPOINT, File-Aid, AIX, JAVA, SQLJ, JDBC, Java Scripts, PL/SQL, JYTHON, TQL, SUN, WS, MS Office Suit, and Utilities, Full SDLC Methodology and other development/testing software tools, MYSQL, Java Script, ETL, COTS, CMDB, .NET, MRP, MCS, SFC, INVENTORY.

Senior Systems Engineer/DBA, Confidential

• Provided software re-engineering and software support to FEP Division of CareFirst for HIPPA, MMIS, MEDICAID, Patient Care, Claims, Providers and Billing Databases.
• Installed and maintained systems software for CICS, DB2, IMS, FileAid, Culprit, MKS, TMON, PeopleSoft, DATAPROPAGATOR on Z/OS and other platforms by receiving it from different software vendors
• Maintained Healthcare software utilizing COBOL, ALC, PL/1, CICS, JCL, ACF2, RACF, JES2, TIVOLI, VSAM and other utilities.
• Utilized SMPE at the systems programming responsibilities with SHAREPOINT technology.
• Supported test plans development and regression testing process and disaster recovery.
• Provided performance tuning and disaster recovery on DB2/UDB, IMS and CICS.
• Performed capacity planning for software products
• Developed software utilizing Z/OS, JCL, ISPF, COOLGEN, ETL, Cobol, DB2, Stored Procedures, VSAM, SYNCSORT, BMC Utilities, MQ, C , SAS, Oracle, SQL, and many tools with Case Specification, Detailed Functional Requirements, Data Conversion Specifications and Data Dictionary.
• Created Test Plans for the software
• Performed functional analysis to support the clients on the daily basis to the FEP Division
• Provided full support for conversion and migration of software with large DB2 Database, IMS FileAid and TMON on IBM Mainframe and SUN Servers.
• Utilized WEBSPHERE and AIX/UNIX as an administrator.
• Collaborated with multitask teams, including management and customers in peer reviews
• Responsible for HL7, DB2/ UDB/EEE, SQL,JDBC, JAVA, CRYSTAL REPORTS, VMS, Server, Microsoft Suite, CM, WIN2000, CICS, XPEDITER, IMS DBCTL, HALDB and Fast Path, MVS, JCL, File-Aid, REXX, COBOL, ASSEMBLER, C , AIX, UNIX, Shell Scripts, FTP, ACF2, IFS2, TCP/IP, SAS, EMC, OMEGAMON, WS, MQ, PL/SQL, MYSQL, PeopleSoft, TERADATA, ORACLE, ERWIN, TOAD, ENDEVOR, XML, testing full Life Cycle, Q/A, CA-7, CM and system support

DBA/DEVELOPER, Confidential

• Provided software re-engineering and full software support to E-Services Division of IRS
• Mentored team members and provided full support to test plans development and regression testing process

I worked as an administrator, Confidential

• Collaborated with multitask teams, including management and customers in peer reviews
• Provided performance tuning and disaster recovery on IMS and DB2/UDB database
• Performed functional analysis and developed software for IRS online electronic registration Utilities, MQ, C , SAS, Oracle, SQL, and many tools with Data Dictionary and Data Conversion Specification.
• Administrated MQ messages and analyzed it
• Provided full support for conversion and migration of software with large DB2 Database from the Gaithersburg system to IRS headquarters
• Responsible as a DBA for DB2/ UDB/EEE, SQL, PeopleSoft and People Tools, MS Office Suite, CICS, IMS DBCTL, MVS, JCL, Utilities, XPEDITER, MICROFOCUS COBOL, ALC, PL/1, FILE-AID, SAS, C , JAVA, Java beans, SQLJ, JDBC, UNIX, CRYSTAL REPORTS, Oracle, ERWIN, TERADATA, Shell Scripts, FTP, ACF2, RACF, JES2, TCP/IP, MQ, PL/SQL, Rational Rose, Rational RequisitePro software, JAVA, ETL, ENDEVOR, COTS, XML, Web development, testing full Life Cycle, Q/A, CM and system support on IBM Mainframe and Sun Servers.

DBA/DEVELOPER, Confidential

• Provided database administration during strategic planning of massive telecomm-billing database.
• Mentored team members through formal training
• Developed software utilizing Z/OS, JCL, ISPF, COBOL, DB2, Stored Procedures, VSAM, SYNCSORT, BMC Utilities, MQ, C , SAS, Oracle, SQL, and many tools.
• Collaborated with multi-functional teams, including management, operations and customers.
• Developed disaster recovery and performance tuning plans for the IMS and DB2 databases.
• Participated in tuning and conversion of very large databases for UDB/DB2 and Oracle for the financial management system.
• I have worked as an administrator in the IT area, installing the AIX and WEBSPHERE, UNIX, for the HP and SUN and IBM Mainframe platforms utilizing Data Dictionary and Data Conversion Specification, Detailed Functional Requirements.
• Provided full software support for Unix, AIX, Shell Scripts, FTP, ACF2, RACF, JES2, TCP/IP, MQ, Oracle, CRYSTAL REPORTS, TERADATA, WEBSPHERE, DB2, UDB/EEE, SAS, SHAREPOINT, SQL Server, WIN2000, SMALLTALK, C , AWK, SED, CICS, MVS, JCL, Utilities, FLIE-AID, ERWIN, TOAD, COBOL, ALC, PL/1, ENDEVOR, SAS, VSAM, IMS DB/DC, SAP, Informix database PeopleSoft Tools, Rational Rose, XML, WEB, SCM, and JAVA

Senior Engineer/DEVELOPER, Confidential

• Interfaced with Department of State bureau chiefs in developing strategy for Y2K compliance.
• Analyzed and tested daily cycles with Detained Functional Requirements, Data Conversion, Data Dictionary and Case Specification.
• I utilized the HP Quality Center and other tools and technology working on the Y2K projects at Department of State.
• Performed Y2K inventory, analysis, scanning and assessment after the full conversion of the Database
• Provided regression testing on multiple Y2K certification projects utilizing DB2, UDB, SQL Server CICS, MVS, JCL, MICROFOCUS COBOL, ALC, PL/1, VMS, DEC, ERWIN, VSAM, SCM, SAS, UNIX, C , IMS, CICS, MQ, TCP/IP, Shell Scripts, AIX, EMC, ACF2, RACF, JES2, FTP, SAP, JAVA, and WEB on IBM Mainframe and Servers.

Systems Administrator, Confidential

Involved in Department of Education student loans contract with offices located nationwide

• Provided daily support of large data center
• Supported the Financial Management system converting DB2 database from version 5 to 6 on a daily basis
• Monitored daily user activities and resolving problems, provided performance tuning and disaster recovery plans for the IMS and DB2 databases.
• Provided systems programming lead support on SMPE and SHAREPOINT tools
• Installed system software for upgrades for DB2/EEE, SQL Server, UDB PT and B/U Recovery , CICS, IMS, IDMS, DBCTL, VSAM, MVS, SAS, ALC, JCL, SCM, SMPE, FTP, ACF2, RACF, JES2, DEC, VMS, TCP/IP, ACF2, Platinum, C , WEB, ORACLE, ERWIN, SAP, and UNIX

Systems Engineer/DEVELOPER, Confidential

• Acted in several capacities from Systems Engineer/Administrator to Field Consultant on many projects varying in size and scope
• Worked on and led projects for federal and state governments, Y2K projects, Fannie Mae, telecom and more
• I utilized HP quality Center in testing and Re-Engineering projects for various vendors.
• Took charge as Systems Administrator on Y2K project for State of Maryland
• Led Y2K project for Montgomery County
• Provided full assessment of equipment used at facility to meet Y2K requirements
• DB2 Administrator at FRB Agency of US Government
• Performed systems analysis at Fannie Mae to support the financial systems, including G/L, order processing and accounting
• Assisted in maintenance and enhancement of Financial Management Information System FMIS on contract for Bureau of Alcohol and Tobacco
• Maintained system documentation at Department of State
• Analyzed and updated COBOL programs
• Developed computer programs on C , COBOL, SAS, Assembler, FORTRAN, DB2, UDB, IDMS, IMS DBCTL, IMS DB/DC, CICS, MVS, DEC, VMS, HP3000, JCL, WEB, UNIX, Solaris, Shell Scripts, FTP, TCP/IP, ACF2, RACF, JES2, AWK, SED, ENDEVOR, MICROFOCUS, SCM, SMALLTALK, Rational Rose, Java on IBM Mainframe, Servers, Windows and other platforms.

Technical Skills Summary

• Operating Systems: OS, VMS, DOS, UNIX, OS/MVS/VSE/SPE/ESA/TSO/ISPF, Z/OS, AIX
• Software: UNIX/LINUX, ENDEVOR, SQL Server, MYSQL, MVS/VSE/ESA/TSO/ISPF, HALDB, Fast Path, Expediter, PANVALET, SMARTTEST, VSAM, Lotus Notes, PeopleSoft, MQ, SCM, SAP, OLQ, WEBSPHERE, TERADATA, CICS, VMS, SMALLTALK, RACF, VB, SQL, PL/SQL, SDLC, DMLO, IDD, JCL, Dialog Management, MS OFFICE, Windows, Shell Scripts, FTP, ACF2, Wang Procedure, ADS/O, ADS/A, SQLJ, JDBC, JAVABEANS ,BOM, INVENTORY, MCS, SFC, SDLC, MRP, CRYSTAL REPORTS
• Developing: Case Tools, YOURDEN Demarco, COBGEN, CRYSTAL REPORTS, ERWIN, TOAD, TELON, Client Server, Platinum, Boole Babbage, CA-7, CA-11, CW
• Hardware: IBM MAINFRAME, EMC, AIX, PC, Wang VS, HP, Sun Solaris, DEC, VAX, Unisys, Sperry, BURROUGH, DEC, Window NT/2000
• Languages: C , Java, VB, COBOL, SAS, SQL, Assembler, PL/I, Basic, JCL, Pascal, FORTRAN
• Databases: Oracle, HADR, DB2/UDB, SQL, IMS DB/DC, IMS DBCTL, IDMS, IRDB, ODBC, Informix
• Tools: ACF2, OSCAR, CLAIMS, RACF, JES2, DATAWAREHOUSE, VISUAL EXPLAIN, OMEGAMON, TMON, DB2PM, OPTIM QUERY TUNER, PRECISE FOR DB2, QUEST, DBI SOFTWARE, EMBARCADERO, PERFORMANCE ANALYST, BMC, TIVOLI, SMP/E, EDI, HL7, HIPPA, MMIS, OLTP, Rational Rose, JCAPS, UML, SAP, PeopleSoft, MQ, XML, Exceed, Firewall, AMAPS, CAS, SFD, Code1, WYLBER, CA-7, CA-11, CLISTS, DL/1, FILE-AID, Focus, OLAP, EASYTRIEVE, VSAM, DATA DICTIONARY, CASE SPECIFICATION, NERO