Resume

VINCENT D. APA, JR.

Phone: 302-883-1238
Email: vincent.apa@gmail.com

PROJECT MANAGEMENT PROFESSIONAL

PROFESSIONAL PROFILE
â–ª Accomplished and versatile project-management professional with impressive record of performance and success leading project teams through continuous process-improvement operations and major new initiatives and implementations.
â–ª Skilled tactician known for providing expertise to financial and pharmaceutical industries in initiatives requiring analysis and application development, as well as proficiency that extends into database-marketing, risk-management, consumer-lending, and quality-assurance sectors.
â–ª Motivated achiever with proven track record of success and capability in spearheading and managing multiple projects and resources through full life cycle, employing strengths in research, planning, and quantification, as well as proficiency in migrating legacy data to updated systems.
â–ª Goal-driven self-starter whose multi-faceted career experience includes system analysis, design development, implementation, problem-solving, and technical support.
â–ª Polished interpersonal communicator with strong team-building and consultative skills, including assisting customers in defining and redefining business needs and managing internal/external customer expectations to meet or exceed customer goals, and build long-term relationships.

AREAS OF EXPERTISE
â–ª Project Management
â–ª Process Improvement
â–ª Cross-Functional Team-Leading
â–ª Supervising/Coaching
â–ª Assess Project Requirements
â–ª Project Planning/Schedules
â–ª Problem-Solving
â–ª Implementing Change
â–ª Investigate/Analyze/ResolveProduction Issues
â–ª Client/PMO Liaison
â–ª Client Advocacy
â–ª Customer Service
â–ª Research and Planning
â–ª Execute Strategic Initiatives
â–ª Adherence to Software Standards
â–ª Technical Specifications and Documentation
â–ª Technical Support
â–ª Network Requirements
â–ª Polished Presentation and Communication
â–ª Time Management
â–ª Database Design, Interface, and Interdependencies
â–ª Database Profiles/Definitions and Configuration
â–ª Decision-Making
â–ª Self-Motivation

TECHNICAL PROFICIENCIES
â–ª Database: Oracle 8i, 9i, Informix, Terradata, Dbase, Sybase, FoxBASE, MS Access, DB2, TOAD
â–ª Programming/Reporting: PL/SQL, Visual Basic, MS FrontPage, Cognos, Macromedia Dreamweaver, Javascript, HTML, ASP
â–ª Mainframe: JCL, COBOL, Global General Ledger and Accounts Payable Software, Focus, Easytrieve, SAS, Terradata BTEQ, FastExport, Fastload, REXX

PROFESSIONAL EXPERIENCE

Consultant – Application Programmer, State of Delaware, Delaware Justice Information System, Dover, DE, Nov. 2004 to present

â–ª Evaluated and completed COGNOS reporting requirement and project with comprehensive oversight of PL/SQL preprocessing of data, security enhancement to COGNOS front end, and COGNOS cube and report generation
â–ª Developed PL/SQL preprocessing routine to prepare data for COGNOS.
â–ª Redesigned Oracle 8i data-warehouse schema to include missing information.
â–ª Developed login screen that uses mainframe password for COGNOS application in VB.NET.
â–ª Generated reporting for productivity, crimes, wanted persons, and missing persons.

Consultant – Business Analyst/Application Programmer, McNeil Consumer and Specialty Pharmaceuticals, Fort Washington, PA, Oct. 2003 to Sept. 2004

â–ª Repaired and updated VB and VBA applications for manufacturing, finance, and sales activities.
â–ª Provided ad-hoc, monthly, and quarterly mainframe reporting for finance and sales operations.
â–ª Comprehensively oversaw:
â–ª VB and VBA program enhancement
â–ª Bug fixing on small to midsize applications
â–ª COBOL and DB2 program enhancement and report generation
â–ª Resolved service requests for more than a dozen MS Access enterprise databases.
▪ Redesigned schema for manufacturing metrics database and developed MS Access replacement “Proof of Concept� for enterprise applications using Web front end.
â–ª Delivered production and ad-hoc mainframe reports requiring COBOL and/or DB2 changes.

Consultant – Business Analyst/Application Programmer, American Business Financial Services,
Philadelphia, PA, Sept. 2002 to Aug. 2003

â–ª Implemented mortgage documents into third-party printing application.
â–ª Designed and implemented data-movement process for new document-control application.
â–ª Spearheaded implementation of:
â–ª VMP III mortgage and satisfaction documents into RAKIS document printing system
â–ª Integration of LOADS and MCC data into HARLAND DCS schemas
â–ª Ad hoc testing and research requests
â–ª Integrated all backlogged mortgage and satisfaction documents into RAKIS.
â–ª Designed, programmed, and tested ETL process using Oracle PL/SQL and SQL loader for two different data sources into Harland DCS schema and performed ad-hoc data mining using Oracle PL/SQL.

Consultant – Business Analyst/Project Manager, Merck-Medco, Blue Bell, PA, March 2001 to
Sept. 2002

â–ª Managed all aspects of data processing for direct mail and telemarketing for home-delivery division.
â–ª Drafted all business requirements for processing on all co-pay waiver-marketing programs.
â–ª Updated and verified all related marketing and suppression data, including all back-end analysis and reporting, as well as ad-hoc movement of data from mainframe to information warehouse for development and analysis.
â–ª Automated FTP process between Merck-Medco and Interdirect phone vendor.
â–ª Implemented automation of 100 percent QA process for all output files, target file maintenance process, and new database to consolidate and verify target audience.

Consultant – Business Card Acquisition Processing Manager, First USA Bank, Wilmington, DE
Mar. 2000 to Mar. 2001

â–ª Managed all aspects of data processing between FUSA and Acxiom Corp. for business card.
â–ª Drafted all business requirements for business-card acquisition processing.
â–ª Oversaw management/accounting/accuracy of all business-card marketing and suppression data.
â–ª Implemented new matching criteria, resulting in overall 10 percent increase in match rates.
â–ª Optimized new return-mail step, resulting in 1.5 percent returned mail rate.
â–ª Oversaw segmentation of all business-card marketing lists.
â–ª Implemented campaign history strategy for business card.
â–ª Initiated key strategy design for back-end analysis on new server.
List Processing Analyst, First USA Bank, Wilmington, DE, Jan. 2000 to Mar. 2000
â–ª Managed all business requirements for business-card and consumer lending.
â–ª Oversaw extraction and suppression of business-card and consumer-lending portfolio campaigns.
â–ª Audited all data extracted and suppressed for business card and consumer lending.

Business Card Program Coordinator, First USA Bank, Wilmington, DE, Nov. 1999 to Jan. 2000

â–ª Generated 25 percent cost savings by developing alternate processing routine after developing drop analysis report summarizing marketing record loss that resulted from processing.
â–ª Developed and supervised testing process to evaluate moving data processing to new vendor.
â–ª Performed lead analysis on prospect database.
Project Manager – Special Internet Projects, MBNA America, Wilmington, DE, Oct. 1998 to
Nov. 1999
â–ª Modeled email tracking system for new-account acquisition and workflow through company intranet.
â–ª Led team of developers and analysts performing database modeling and programming functions using Access and Informix SQL, Web design software evaluation and implementation, utilizing
MS FrontPage, and supervised transition of new initiatives to production environment.
â–ª Focused on developing email marketing through workflow and account-tracking database in Oracle using Designer 2000 and Developer 2000.

Project Manager, MBNA America, Wilmington, DE, Mar. 1997 to Oct. 1998

â–ª Managed team of six developers in developing and managing all new initiatives involving process improvement and ad hoc processing.
â–ª Implemented process improvements that generated $76 million in incremental marketing savings in 1997 and $89 million in 1998.
â–ª Wrote requirements, developed testing plan, and signed off on results for each project.
â–ª Tracked production impact of each project and maintained accountability for all marketing data shipped from data-processing vendor to mainframe site in Dallas and all summary data out of mainframe process to Wilmington.
â–ª Generated all reporting and statistical inquiries in Informix SQL, Informix ACE, MS Access, and Excel.

EDUCATION and DISTINCTION

â–ª Bachelor of Business Administration, Wilmington College, Wilmington, DE
â–ª Earned Air Medal, United States Air Force, four years of Active Duty, six years in Reserves