TECHNICAL SKILLS

• PL/1, JCL, IMS, IMS DB, COBOL, CICS, MFS, DB2, DB2 Stored Procedures, TSO, ISPF, MVS, z/OS, QMF, SQL, SPUFI, SYNCSORT, VSAM, Flat files, FileAid, Dumpmaster, AbendAid, Endevor, FTP, NDM (Network Data Mover / Connect:Direct), MFT (Managed File Transfer), MQ (Message Queue), Visual Basic 5.0, MS Access, XML, Taskmate screen scraping, SDLC, Waterfall, automation, Textpad
• Working knowledge of Java, JSP, Servlets, JDBC, Confidential, PL/SQL, Agile and Scrum, JIRA, ServiceNOW, ITIL and ITSM, Eclipse IDE

PROFESSIONAL EXPERIENCE

Confidential

Mainframe Developer

Responsibilities:

• Application developer for the Policy Register, Senior NYLIC, and CASTL legacy mainframe batch job applications.
• Responsible for the Confidential policy systems and databases that generate correct commission and pension payments for all Confidential agents around the world.
• Created automated process to detect data anomalies on an Confidential agents' records, and correct the records to ensure proper commission and pension payments for Confidential agents. Provided L3, L4 support to Confidential agents. Application developer involved in the migration, modernization, and retirement of the Policy Register, Senior NYLIC and CASTL legacy mainframe batch job applications.
• Data analyst and technical lead, reviewing and correcting legacy mainframe database records, and performed data mapping in preparation for the migration to SQL based DB2 database .
• Participated in UAT and QA end - to-end flow through testing of new modernized application systems.
• Tested and validated new systems through parallel processing during transitioning period. Kept executive level management and all stakeholders abreast of the progress of migration and retirement efforts.

Confidential

Software Engineer III

Responsibilities:

• Application architect, technical lead, and developer for the SOP ordering system and its various subsystems.
• Responsible for the mainframe applications of ordering, provisioning, and billing for internet, TV, and voice services.
• Ensured customers received correctly ordered products and services, timely provisioning and installation of products and services, and correct billing. SPOC for after hour outages.
• Provided 24x7 on call coverage. Application system architect team member responsible for designing the NSOP ordering system on a distributed web platform and retiring NSOP's predecessors SOP and SOI legacy mainframe applications. Performed business analyst role extracting and documenting business rules and work flow rules from mainframe legacy code base, gathered users' requirements and feedback, created high level and detail design documents for software development teams. Performed data analyst role, reviewing legacy mainframe tables and databases, and preformed data mapping to new system.
• Performed UAT and QA end-to-end flow through testing of new modernized application systems.
• Developed and maintained middleware programs and processes that integrated NSOP and SOP during parallel processing, testing, validation, transitioning period. Created driver programs for NSOP application to simulate data traffic from external interfacing systems, to speed up and ease testing, reducing overall testing and development time. Made on-site visits to users and trained users in the use of NSOP system. Documented the users' experiences and bugs, and reviewed findings with application team to resolve issues.
• Kept executive level management and all stakeholders abreast of the progress of migration and retirement efforts. Increased system reliability, speed, performance, and decreased operating costs.
• Application architect and developer for NSOP Workflow Robots system. Implemented automation for real time correction of customer service order records held in error status and re-flow to downstream systems, expediting fulfillment of customers' orders.
• Eliminated thousands of weekly man hours spent by customer service center reps manually correcting customer order records in error, saving millions of dollars annually.
• Technical lead for SOP North Support and NSOP Triage service desk. Provided L1, L2, L3, L4 support for the SOP / NSOP applications (including their various subsystems).
• Investigated incidents reported by users from all lines of business, and responded and resolved incidents meeting SLAs and OLAs.
• Troubleshoot and identify customer order records flow through issues, performing RCA (root cause analysis).
• Reviewed KEDB (known error database) and implemented workaround if available. Updated KEDB with new known errors and workarounds. Performed the necessary corrective actions on customer order records, application, environment, databases, and reflowed customer order records to downstream systems, to expedite fulfillment of customers' orders.
• Developed TASKMATE screen scraping scripts, to perform ad-hoc automated correction of customer service order records held in error status and re-flow to downstream systems, to expedite fulfillment of customers' orders.
• Eliminated thousands of weekly man hours spent by customer service center reps manually correcting customer order records in error, saving millions of dollars annually.
• Technical lead and data analyst for SOP/NSOP Tables team.
• Responsible for maintaining and updating the various tables and databases in the SOP / NSOP applications, ensuring data integrity.
• Provided reports for various audits, fraud investigations, legal litigation disputes, metric reporting for executive level management and all stakeholders.
• Developed the Tables 2K application, a Windows based application to maintain and update the data source for several legacy mainframe databases, reducing data entry errors, increased productivity, and reducing operating costs. Provided L1, L2, L3, L4 support for Tables2K users.
• Provided L3 and L4 support for SOP/NSOP system environment.
• Collaborated with capacity management and mainframe operations to investigate, troubleshoot and correct performance issues in SOP/NSOP system environment. Performed system health checks by generating ad-hoc reports of service order activity and service order metrics.
• Assist in performance tuning of mainframe system environment.
• Troubleshoot major system outages and assist in system recovery and fallout mitigation.
• Involved in disaster recovery exercises.
• Application architect and developer of the SMARTS work force management mainframe system.
• Responsible for the system that provided available appointment dates & times for customers, and scheduled the deployment of field technicians for internet, TV, voice service repairs and installations. Provided L1, L2, L3, L4 support to field users, troubleshooting appointment date availability problems and ensured efficient use of total man hours available at each field tech garage. Application architect and developer for WFA work force administration mainframe system.
• Responsible for the system that allow field technicians to update and close out customer service orders, out in the field through their tablet, after completion of work at the customer site.
• Ensure that customer orders are expedited to billing, so payments can be collected in timely manner. Track and report on time performance of installation/repair completions, and missed commitments. Application developer for the SOI batch reporting mainframe system.
• Responsible for the system that produce reporting feeds for executive level management and all stakeholders, which include but not limited to, metrics of accurate reporting of timely provisioning of services to customers and timely billing of services after provisioning to avoid monetary fines levied by competing companies and government regulatory agencies, recognizing and rewarding high performing sales representatives, tracking and forecasting sales trends of internet, TV, voice services. SPOC for after hour outages.
• Application developer for the E911 data feed batch mainframe system.
• Ensure accuracy of E911 address data extracts and timely transmission of E911 address data feed to the various E911 call centers. Mentored, guided, and collaborated with junior application developers of onshore and offshore development teams. Provided KT (knowledge transfer) sessions.