Frank Vigna Email & Phone Number

Work with Subject Matter Experts (SME) to analyze existing security administration processes and identify opportunities for improving operational efficiencies. Design, code, test and implement automated batch processes to enhance or replace existing manual security operations. Work with offshore security consultants to itemize and document all manual security tasks as formal Security Operations Standard Operating Procedures (SOP). • Worked with Security Operations SMEs analyzing and researching existing manual processes to update Mainframe ACF2 Access Rules database. Designed, developed, and tested an automated Mainframe SAS batch process to update ACF2 Access Rule data stores. Process produces ACF2 Access Rule transaction files and generates email notification of Logon ID errors. Valid Logon IDs are recorded to normalized history files for subsequent loading to DB2 data stores, producing history, audit and tracking reports. • Worked with offshore security consulting team to identify and document all manual tasks performed to SOPs. Developed strategy to move project forward, creating SOP project templates and establishing staging area to deposit completed documents. Inventoried and cataloged all completed SOPs to workbooks providing the operations team with search and quick access capability to all completed SOPs from a single point of contact. Organized ongoing weekly team meetings to track progress and resolve issues. Provide management with weekly team status reports.

Senior Developer and Technical Lead gathering, defining and translating business requirements into technical specifications and detailed designs increasing productivity and reducing learning curves. Responsible for coding, testing and delivering project and small enhancement activities on-time with a high degree of customer satisfaction. • Integrated, productionized and automated HMO Lab Leakage application. Completed extensive research and analysis of existing system in test environment. Established project requirements and specifications, completed design activities, coding, testing and implementation on multiple platforms with integrated modules on AIX-UNIX/SAS-SQL, Mainframe, SQL Server and distributed Web Reporting front end environments - Estimated first year savings, $2mm.• Gathered and defined user requirements, completed detailed specifications, systems design and windows web screen designs for new Non-HMO Lab Usage application. Performed system analysis to formulate and model multi-platform solution reusing existing code of related HMO Lab Leakage application. Acted as technical lead assisting DBAs in creating parallel SQL server database to store new application data and assisting web developers in creating new web reporting screens. Completed coding, testing and implementation of modules on Mainframe and AIX-UNIX/SAS-SQL environments. Application was delivered on-time and under budget with high degree of customer satisfaction. • Designed, developed and implemented DB2 SQL PL programs satisfying a variety of HEDIS Measure requirements and extracting and transferring result-set data to DARTH windows based applications. Assisted HEDIS team producing database design models and high level/low level designs simplifying complex HEDIS Crystal Report system, showing vital processes and end-to-end file/table/report interactions.

System Delivery Specialist and Team Leader responsible for Government Programs regulatory efforts aimed at maintaining operational compliance for 150,000 Medicare members. Provided technical leadership and guidance on all aspects of Aetna Government Programs Medicare projects including requirements gathering, detailed design, development, testing and installation of online systems and related batch processes. Documented and resolved issues, provided time and resource estimates, project plans and team status reporting. • Supervised Project Team members and offshore consultants to develop a suite of mainframe batch update modules and online DB2 Inquiry systems, including Medicare Letter Inquiry, Monthly Medicare Reply Tape and Monthly Membership Report. Systems allowed Medicare business unit quick online access to Aetna/CMS transaction feeds that helped avoid non-compliance issues and penalties during audits.• Team Leader for the Medicare Reconciliation System with the business, third party vendor and developers. Extensive requirements, specifications, analysis, design, and guidance performed for project. System identified Medicare membership with special statuses that allowed for higher reimbursement rates and crucial for recouping a yearly average of $60 - $90mm in missing revenue.• Supported all phases of Provider Termination system including design, development and implementation. System is critical to HMO platform notifying all HMO membership (Medicare and Non-Medicare) of providers (PCP and Non-PCP) terminating the network. Successful on-time delivery helped insure the company’s compliance with the BBA of 1997 and gain NCQA accreditation.• Designed and implemented Working Aged Survey system generating surveys to Medicare membership after their first year anniversary. System recovers $10mm yearly of unapplied or misapplied CMS reimbursements.

• Designed, developed and supervised Global Exposure System enhancement activities for the Advanced Commercial Banking System for preparation for Y2K and the replacement of the existing commercial loan system. • Team member of the Information Technology area during the Anderson transition resulting in a Management Retention Bonus for outstanding performance.

• Supported enhancement and maintenance activity of the Producer Administration System, an IMS DB/DC system. Assured integrity of production environment, investigated and corrected problems, and performed production assurance reviews.• Completed maintenance and enhancement requests to Outside Adjuster Tape and Cigna Header/Loss Edit System. Subject matter expert of the Outside Adjuster Tape Team and provided project knowledge transfer and technical training.