Sql Oracle
Resume:
Imelda Bernardo
**************@*********.***
San Ramon, CA 94582
SUMMARY
. Seasoned professional with over 19 years of Information Technology
industry experience providing technical leadership in Fortune 50
environments
. Efficiently supports daily backend processes using PL/SQL, Oracle 10g,
UNIX, UNIX Shell Script by automating handling of production abends that
leads to company's savings.
. Strong knowledge of Software Development Life Cycle (SDLC) and Relational
Database Management (RDM)
TECHNICAL SKILLS
HARDWARE
HP-UNIX, IBM 3090, IBM-PC, ORACLE RISC 6000
DATABASE
ORACLE 10g, DB2, Foxpro, SQL, SQL Server
PROGRAMMING LANGUAGE
PL/SQL, SAS, Crystal Reports (Business object), JAVA SCRIPT, Shell
Script, CSS, ColdFusion8, HTML, Pro-C,, Oracle FORMs, JAVA,, VSAM
COBOL, DB2/COBOL with UNICODE, JCL/PROCs, Foxpro, AIX MicroFocus COBOL
OPERATING SYSTEM
UNIX, DOS, MVS/ESA, OS/MVS
UTILITIES
Connect Direct, Oracle SQL Loader, SQL Navigation, Eclipse,, Developer
2000, CVS, Quantum DB, Job Scheduler, CSS, CVS, Autosys, Toad, SAS,
FILEAID, QMF FOR WINDOWS, Syncsort, Matrix Job, TSO/ISPF, ChangeMan,
NDM/FTP, IBM Utilities, IDCAMS, Cron jobs, Informatica (self train)
PROFESSIONAL EXPERIENCE
AT&T Services, Inc., San Ramon, CA December 2009 to Present
Extract/Transform/Load Programmer - CONTROL, AUDIT, REVENUE AND TAX
COLLECTION
. Efficiently monitor, analyze production data from different applications
to centralized data repository.
. Play a pivotal role in maintaining Infogix/MOSS application, correcting
defects and coordinate with interface.
Environment: HP UNIX, Client Server, ORACLE, PL/SQL,UNIX, Shell Script,
NDM, SQL Loader, SQL Server, Eclipse, JAVA, Toad, CVS, Job Scheduler,
COBOL/DB2, TSO/ISPF, MVS, JCL, FILEAID, CRON
AT&T Services, Inc., San Ramon, CA (Amdocs) August 1995 to May 2009
SENIOR ANALYST - BILLING AND CUSTOMER CARE (May 2006 to May 2009)
. Experience in extraction, analysis, transformation, data mapping,
integration and upload of data to create enterprise reports.
. Flexible in performing multiple responsibilities which include: gathering
of requirements from clients; manage projects, development of
methodologies and coding; logical analysis; testing; and support of AT&T
Global Calling Card (GICCS) and integration of miscellaneous systems that
makes the operation successful despite the company's reduction in
resources.
. Provide 24x7 production support for AT&T Global Calling Card and Galaxy
Integrated Systems and solve production issues within 8 hours to
satisfaction of clients, resulting in numerous commendations from
clients.
. Effectively configure, create reports for clients, execute and monitor
daily and monthly jobs resulting to lesser production system-malfunctions
and enhanced system-to-system interface.
. Act as subject matter expert on behalf of the team.
Environment: HP UNIX, Client Server, ORACLE, Crystal Reports, SAS,
PL/SQL, JAVA SCRIPT, UNIX, Shell Script, Korn Shell Script, ColdFusion,
HTML, XML, Pro-C,, Oracle FORMs, Connect Direct, SQL Loader, SQL
Navigation, Eclipse, JAVA, Toad, Developer 2000, CVS, Quantum DB, Job
Scheduler, Websphere, COBOL/DB2, TSO/ISPF, MVS, JCL, FILEAID
Major Accomplishments:
* Created application that activated calling cards which were
erroneously deactivated by the interface
generating million of dollars on yearly revenue.
* Lead player in batch applications migrations to new servers, including
environment setup, performance test analysis on all levels including
code updates and internal system interface resulting to application's
optimization on batch system process.
* Automated batch reports and created permanent solutions to solve
production problems resulting to savings due to reduce resources.
SENIOR ANALYST - CONFIRMATION LETTERS (September 2001 to April 2006)
. As Lead developer of Confirmation Letter team, developed, tested and
maintained the process which populates Confirmation Letters in seven
languages and email.
. Resolved production problems in timely manner by implementing ad-hoc
solutions in less than 24 hours while delivering high quality, low system-
malfunction rate.
. Provided 24x7 production support on all Confirmation Letters processes
and reduced the abend rate by 75% by making the application rapid
deployable through modifying the programs and re-structuring the tables.
. Back filled for Technical Architect.
Environment: IBM 3090, MVS/ESA, DB2, VSAM, SQL, DB2/COBOL with UNICODE,
SAS, FILEAID, QMF FOR WINDOWS, ORACLE, ColdFusion, HTML, UNIX, TSO/ISPF,
Syncsort, Matrix Job Scheduler, Changeman, PL/SQL, ShellScript, REXX,
Remedy, Crystal Reports
Major Accomplishments:
* Nominated for President's 2004 Star Performance Award for helping in
designing and as lead programmer to optimize the processing of sending
Confirmation Letters to the customers. Confirmation Letters job
process from four hours to 45 minutes execution time that saved the
company thousand of dollars due to faster processing time and reduced
support hours.
* Received 2nd quarter 2006 Winning Traits Recognition Program as one of
the designers and lead programmer for making Confirmation Letters
verbiage rapidly deployable in any languages. Process requires minimum
maintenance and verbiage can be deployed to production in less than
eight hours compare to 80 hours work before, leading to hundred
thousand dollars yearly savings due to reduced support hours and made
the application off-shored.
SENIOR ANALYST - BILL DAY INTERFACES (August 1995 to August 2001)
. Responsible for design, development, testing, implementation and
maintenance of Bill Day Interfaces processes.
. Contributed to team effort to solve more than 80% of Bill Day Interfaces
long list of defects.
. Environment: IBM 3090, MVS/ESA, VSAM, SQL, DB2/COBOL, SAS, FILEAID, QMF
for Windows
United Coconut Planters Bank, Makati, Philippines February 1993 to July
1995
SENIOR PROGRAMMER
Responsible for all batch programs that generate summaries of daily,
monthly and yearly transactions for the bank's Foreign Exchange Marketing
System and Money Market.
. Developed, implemented and maintained online data entry and inquiry
provisions, performed batch cleanup, and gathered data from the bank's
different systems.
. Environment: IBM 9121, MVS/ESA, DB2, VSAM, SQL, COBOL, AIX Microfocus
COBOL, CSP, ORACLE RISC 6000, Unix (AIX), DB2, SQL, SQL*Forms, ORACLE
Major Accomplishments:
* Played a pivotal role in the maintenance of system applications as the
sole analyst/programmer of the Integrated Customer Information
System team.
Mega Data Philippines, Makati, Philippines September 1991 to December
1992
PROGRAMMER
. Developed and maintained several payroll systems for different government
agencies.
. Environment: IBM PC, DOS, FoxBASE, Clipper
United Group of Companies - San Jose, Saipan October 1990 to July 1991
LEAD PROGRAMMER
. Organized and computerized all major systems for group of companies.
Served as pioneer architect/programmer of company application systems.
. Environment: IBM PC, DOS, FoxPRO
EDUCATION
University of City of Manila (Pamantasan ng Lungsod ng Maynila),
Manila Philippines B.S. COMPUTER SCIENCE, March, 1989
Contact this candidate