FERDINAND LUGAY

** ****** ******* • White Plains, NY 10607 • 914-***-**** • nl07tj@r.postjobfree.com

SUMMARY

Project Lead/Sr. System Analyst with 15 years of IT experience working on various application development involving MS SQL Server, DB2 and Oracle databases. Extensive experience in managing enterprise IT Project Life Cycle through all phases: analysis, design, development, coding, testing, implementation and post production support. Excellent communication and interpersonal skills having comprehensive problem solving abilities, multitasking ability, willingness to take up leadership, facilitate teamwork and implement activities.

TECHNICAL SKILLS

COBOL II DB2/SQL CICS TSO/ISPF JCL VSAM QMF EXPEDITER SQL 2005/2008

HTML XML UNIX SCRIPTING ORACLE SQLPLUS WEBFOCUS MS OFFICE

PROFESSIONAL EXPERIENCE

VERIZON BUSINESS, Rye Brook, NY 2003 – 2011

Lead Consultant - System Analyst/Programmer (as Project Lead) 2007 - 2011

Led a team of 1 ~ 7 (onsite and offsite) to successfully implement a multi-phase web-based International Revenue and Planning analysis system for the IPS (Finance and Planning) group while managing and supporting six key SQL Server based and mainframe batch and online production systems.

• Identified resources, facilitated and held team meetings, assigned individual responsibilities, reviewed deliverables, tracked and reported team hours and expenses thus ensuring that the deliverables were accurate, on time and within set budget 100% of the time.

• Designed security screens to assign permissions and data view restriction based on user role, sales hierarchy and country assignments thus increasing utility of the system by 50%.

• Fully documented system requirements, functional specs, general designs, project schedules, task lists for monitoring, tracking and risk management as well as UAT test plans.

• Translated requirements in functional specs into business cases for test case preparation and system integration testing in cooperation with Business Analyst, users and testers.

• Collaborated with impacted groups to assess the technical impact of business requirements and to reach consensus on alternative solution when necessary.

• Created QA and Production migration plans and oversaw the project implementation to completion

• Coded common stored procedures, views and one-time SQL scripts for transitioning historical data.

• Coordinated offshore consultants security and database access with our support groups, established guidelines, set sharable folders thus guaranteeing fluid flow of communication 100%

• Provided timely status reports keeping management well informed throughout each project life cycle

• Supported existing applications, solving production issues and providing clients with level of effort for their enhancement requests.

• Demonstrated the “whatever it takes” attitude to get the job done the right way

Senior System Analyst/Programmer 2003 – 2007

Volunteered to join the team in charge of setting an Oracle based system to handle Voice Over Internet Prepaid Card calls.

• Team was recognized and given Ovation points upon completion of the project within the set short timeframe.

• Interacted with clients in data analysis, issue resolution, report layout presentation and understanding of business requirements

• Coded, tested and implemented new SQL scripts for multiple interfacing billing feed extracts used by other in-house systems

• Assisted in testing during the upgrade from Oracle 8i to Oracle 9i

• Involved in the day to day resolution of billing issues and recycling of failed CDRs (Call Detail Records) thus assuring completeness of available billing data

• Set up a new mechanism translating XMLs to SQL Inserts commands for daily recycling using AWK commands

• Scheduled, monitored and supported daily, weekly and monthly VOIP billing processing

FORE Associate , NY 1997 – 2003

Consultant for MCI International as a Senior Mainframe Analyst/Programmer

• Involved in the analysis, design, development and maintenance of various mainframe financial systems

• Assigned to tackle day-to-day resolution of incoming trouble tickets (Tier1 ~ Tier 3) being the first listed contact person by Help Support Desk.

• Responsible for analyzing, coding and testing enhancement to both batch and online programs.

• Assisted in-house programmers with business and technical questions acting as their mentor

• Heavily involved in the conversion of the IFD Batch System to the IRA Online CICS/DB2/Cobol System

• Set up structured programming techniques, templates, built in common called routines, scripts and procedures used in the conversion process

• Spearheaded the Y2K conversion of IRA/NCBS/VISION/VNET/NAC systems as the lead consultant

FORMAL EDUCATION

BS, Accounting, De La Salle College, Manila, Philippines

LATEST TRAINING

Advanced SQL Server 2008 Programming, March 2011

Contact this candidate