TECHNICAL CAREER PROFILE

• Over Thirty years of progressive Information Technology experience in multiple IT disciplines and platforms.
• My experience includes computer operations, production control, system analysis, system design, system development, system testing, system implementation, system administration, systems programming, database design, business intelligence administration, project leadership, project management, change control management and product owner.
• I have a wide technical area of expertise in the mainframe, client server and web technologies.

SKILLS SUMMARY

EXPERIENCE PROFILE

Confidential

Title: Systems Development Senior Specialist

• Perform multiple roles for the Motor Vehicle Systems of the States and Local Solutions division with a primary role of an Oracle PL/SQL Developer responsible for development and support of new and existing Oracle applications.
• Oracle PL/SQL Developer Perform development, maintenance and support to various Oracle applications for the Motor Vehicle Systems such as the Common Accounts, Registration, Taxation, Fuel Tracking, Tobacco Tracking and Permitting systems.
• Trouble shoots Oracle web and backend application related problems and errors pertaining to security, user ids, accounts, reports, forms, database, triggers, gateways, web services, stored procedures, db packages, FTPs, ETL processes and network.
• Perform development and maintenance tasks related to Oracle Forms, Oracle Reports, PL/SQL, SQL, Oracle Database, Stored Procedures/Functions, DB Packages, Database Triggers, WCF Web Services, ODBC, Data Warehouse, UNIX shell scripts, FTP and ETL.
• Solid experience in front end development using Oracle Forms/Reports 6i/9i and Oracle Discoverer 9i.
• Solid experience in developing Stored Procedures, Functions, Packages, Triggers and SQL Scripts using PL/SQL for automating existing business procedures.
• Solid experience in writing complex SQL queries and PL/SQL procedures for data extraction, business intelligence custom view creation, application and reporting requirements.
• Expertise in data analysis, data warehousing, ETL processes and Data conversion using UNIX shell scripting, SQL, PL/SQL, SQL Loader.
• Involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Knowledge on DBA activities like creating users, granting and revoking objects privileges on database objects and more.
• Expertise in all the phases of System development life Cycle SDLC using Waterfall and Agile Scrum, XP methodologies.
• .NET Developer Participated in a new development project for the Kentucky Fuel Tracking E-Filers application using .NET MVC framework. Performed development and maintenance to the Common Accounts application which was converted using ATX Forms2NET from Oracle to ASP.NET.
• Business Intelligence Manager/Oracle Discoverer Administrator - Responsible for the configuration, business area
• creation, user setup, user security, user privileges, documentation and user training for the Oracle Discoverer products. Perform adhoc reporting for clients using Discoverer Workbench and Discoverer Plus. Responsible for maintainance and enhancements to the Discoverer data warehouse where data are loaded and updated with FTPs, Oracle database and mainframe DB2 tables from various sources.
• Change Control Manager - Responsible for the review, approval and tracking of production implementation packages for the Motor Vehicle Systems. Coordinates implementation tasks and user testing efforts to ensure successful production implementation. Represents the department at the data center's weekly Change Control Board meeting to discuss implementation packages, priorities, schedules, risks, back out procedures, resources and tasks contentions or conflicts.
• Other roles include Technical Project Management and Agile Product Owner.

Environment: UNIX, Windows, Apache, Oracle9iAS, Oracle Forms, Oracle Reports, Oracle Discoverer Admin/Plus/Viewer, Oracle Transparent Gateway, SQL Plus, PL/SQL, PL/SQL Developer, Toad, UNIX Shell Script, SQL Loader, ETL, FTP, SFTP, AS400, IBM S390, OS/JCL, TSO/ISPF, COBOL-370, DB2, CICS, DB2 Stored Procedures, ChangeMan. Version Manager, SVN Subversion, Biztalk, WSDL, WCF, SOAP, XML, HTTP, ATX Forms2NET, MS .NET, ADO.NET, ASP.NET, SSRS, MVC, TFS, MS Visual Studio, SharePoint, JavaScript, JQuery, JSP, AJAX, LINQ, JSON, HTML5, CSS3, Bootstrap, Angular JS, Razor, C , ORM Entity Framework , Agile.

Confidential

Title: Sr. Systems Engineer

Perform application development, enhancements and maintenance to the Motor Vehicle Systems which consist of batch, online, client server and internet applications. Utilized AppMaster Builder to create and modify COBOL/CICS/DB2 programs, reports and online screens. Designed and developed CLIST programs and DMS panels to facilitate mainframe development tools and utilities.

Environment: IBM S390, OS/JCL, TSO/ISPF, COBOL-370, CLIST, DMS, DB2, SQL, SPUFI, CICS, Xpediter, Changeman, Jobtrack, CA-7, APS, DB2 Stored Procedures.

Independent IT Consultant Contracts confidential

Lead Programmer/Analyst - Participated in the design, development, testing and implementation of the World Wide Central Submission system WWCS for the American Express Global Financial Capture. Develop major online CICS/DB2 programs and background tasks for transaction Tracking/Problem Determination, Cross Reference Analysis and Maintenance functions. Also wrote batch DB2 programs for reporting, DB2 table updates and extract. Serve as a technical lead consultant.

Environment: IBM S390, OS/JCL, TSO/ISPF, COBOL-370, DB2, SQL, QMF, CICS, Xpediter, Intertest, Changeman, Jobtrack, CA-7.

confidential

Sr. Programmer/Analyst - Performed batch and online program enhancements for YEAR 2000 compliance and code conversion from COBOL-68 to COBOL-370 to the Adult Inmates Management System AIMS . Perform system and application testing for IMS upgrade from IMS 3.1 to IMS 6.1, CICS upgrade from CICS 3.2 to CICS 4.1, and MVS system upgrade from S370 to S390.

Environment: IBM S390, OS/JCL, TSO/ISPF, COBOL-370, IMS/DL-1, CICS, Xpediter, Smarttest, Viasoft/Insight, Viasoft/Validate, Cobol Conversion Aide.

confidential

Technical Project Manager / Lead Programmer/Analyst - Participated in the design, development and testing of the Multiple Line Billing Systems MLBS Project for Farmers Insurance Company, consolidating 4 different insurance lines of business into 1 major integrated system. Responsible for leading and managing the MLBS Financial Reporting System Project with a development team of 12 consultants. Perform project planning and tracking, user interface, systems analysis, systems design, systems development, test plans and implementation plan.

Environment: IBM 90XX, MVS/XA, OS/JCL, TSO/ISPF, PANVALET, COBOL-370, ADW-key, Assembler, CICS, DB2, VSAM, SPUFI, QMF, SMARTTEST, FILE-AID, Hiperstation, BETA Products, Jobtrack, CA-7.

confidntial

Sr. Programmer/Analyst - Responsible for the design, development, testing and implementation of various new online and batch applications for the Revenue System such as the Station Sales sub-system, Other Airlines Ticket sub-system, Manual Document Entry sub-system and the On Board Products sub-system.

Environment: IBM 90XX, MVS/XA, OS/JCL, TSO/ISPF, XPEDITER, ENDEAVOR, MAPR, EXPORTER, COBOL-370, CICS, DB2, SPUFI.

confidential

Technical Project Manager / Lead Programmer/Analyst - Participated in the design, development and implementation of the Kentucky MMIS Medicaid Management Information System . Responsible for project management and tracking of the design and development of the MMIS Financial System. Also served as team lead guiding the efforts of 10 to 15 consultants. Responsible for the design and development of the Online Integrated Accounts Receivable System, the Financial Interim Payment process, the Interim Refund Recovery process and the 1099 reporting. Performed enhancements to the financial payments, administrative billing, month-to-date provider summary, remittance advice and A/R report programs.

Environment: IBM 90XX, MVS/XA, OS/JCL, TSO/SPF, PANVALET, XPEDITER, BMS, FILE-AID, COBOL2, Easytrieve Plus, CICS, VSAM.

confidential

Title: Sr. Programmer/Analyst -

Responsible for the development, implementation and maintenance of the MEDEX Managed Indemnity Program systems which processes prescription claims for BCBS of MA and BCBS of MI. Participated in the design, development and implementation of the Federal Employee Program claims processing system. Designed and developed the MEDEX Online Claims Adjustment system.

Environment: IBM 90XX, MVS/XA, OS/JCL, TSO/SPF, LIBRARIAN, SMARTTEST, BMS, FILE-AID, DB2I, SPUFI, SQLEASE, MicroFocus Workbench, XDB, COBOL2, MicroFocus COBOL, DYL280, CICS, DL1, SQL, VSAM, IMS, DB2, Jobtrack, CA-7.

confidential

Title: Lead Programmer/Analyst -

1. Responsible for user liaison, system specification, design, development, implementation, product support, project control, technical interviews, hiring, training and employee performance evaluations. Supervise a staff of 5 to 8 programmer/analysts and consultants. Perform maintenance and enhancements to Airline Tickets, Travel Insurance, Checks processing, TBA Bank Statements, Bank Deposits, Data Maintenance, MSA Accounts Receivable, MSA General Ledger, and Debit/Credit Advice systems. Designed and developed the Online Commercial Client Automatic Assignment and Networking system Major Insurance enhancements Online Insurance Rate Tables Online TBA Bank Statement Processing, Correction and Automatic Reconciliation system. Also participated in the design, development and implementation of the following projects: Travel System Migration and Conversion New York to Phoenix , Automated Accounts Reconciliation System, Simplified Expense Reporting System and Corporate Express Cash Plus.
2. Also serve as the Function Point Coordinator responsible for the department project metrics.

Environment: IBM 3090, MVS/XA, RACF, OS/JCL, LIBRARIAN, INTERTEST, SDF2, TSO/ISPF, XPEDITER, BTS-II, IMS/EXPERT, IMS/TAMS, FILE-AID, COBOL, Easytrieve-Plus, CLIST, CICS, IMS/DC, IMS/DL1, IMS/DB, VSAM.

confidential

Title: EDP Systems Project Leader -

• Project Team Lead - Managed a staff of 5 programmers and 2 consultants. Responsible for technical interviews, hiring, training, employee performance evaluations, project tracking and project control. Perform maintenance and development to the Membership, Claims, Reinsurance and Capitation systems. Responsible for the design and development of the Primary Care Physician Update subsystem the Automatic Health Plan Assignment, Enrollment and Notification subsystem the Membership Roster the Online Reinsurance Security and Maintenance system the Online Reinsurance Claims Adjustment process Online Voucher processing and the Automated Reinsurance Checks processing.
• Project Management Participated in the design and development of Arizona Long Term Care System ALTECS project.
• Designed and managed the development of the contingency system for Long-Term-Care Eligibility, Membership and Claims.
• Responsible for reviewing and monitoring the requirements, design and development of the LTC Online Eligibility Determination and Tracking system project developed in ADR/IDEAL by Peat, Marwick and Maine consulting group.

Environment: IBM 3090, MVS/XA, RACF, OS/JCL, TSO/ISPF, LIBRARIAN, SDF, INTERTEST, ESTIMAC, PLANMAC, Project Management Workbench, COBOL, Easytrieve Plus, CICS, ADR/IDEAL, VSAM, Datacom/DB.

confidential

Title: Sr, Programmer/Analyst -

Performed analysis, design, development, testing, debugging, documentation, user interface and implementation to major banking applications such as Time Deposit Accounting, Demand Deposit Accounting, Certificate of Deposits, Premium Savings Plan and IRS Reporting. Participated in the installation and enhancement of the PACER IRS Tax Withholding and Reporting System TEFRA 1984 . Designed and developed the Deposit Interface programs and the Year-End IRS Correction system.

Environment: IBM 43xx, 3033, 3081, MVS/XA, VM/XA, OS/JCL, TSO/ISPF, PANVALET, COBOL, MARK IV, DYL260, DYL280, Easytrieve Plus, CLIST, EXEC2, REXX, IMS/DL1, VSAM, RDAM, IMS/DB.

Technical Training and Certifications

• Pluralsight Various classes including but not limited to Bootstrap, HTML5, CSS3, Angular JS, JavaScript, C , MVC, .NET
• Oracle Corporation Oracle Discoverer Training, various local Oracle and Oracle World seminars
• Themis, Inc., Certificate of Completion DB2 Stored Procedures
• Platinum Technology Inc., Certificate of Completion Data Modeling using Extended Relational Analysis, Intro to DB2, Advanced SQL Programming, DB2 Database Design, DB2/DBA
• ADR/Applied Data Research, Certificate of Completion ADR/DATACOM/DB Programming
• Computer Systems Development Inc., Certificate of Completion TSO ISPF/PDF for Programmers, CICS Overview, CICS Command Level COBOL, CICS Application Dump Reading, Introduction to DL/I Application Coding
• American Express Company/Systems Training, Certificate of Completion Xpediter, IMS/VS DC Programming Workshop, IMS/VS Dumps Debugging, IMS/VS TAMS
• Valley National Bank of Arizona Programmer Trainee Program
• Peralta Data Processing Tutorial Center Inc., Certificate of Completion COBOL Programming, Assembler Programming
• Data Masters Training Center, Certificate of Completion Fortran IV Programming
• And more .