Engineer Sql
Resume:
JEFFREY M. FELICIANO
Milpitas, CA 95035
Home: 408-***-****
Cell: 408-***-****
Email: *******@*****.***
Professional Summary
BSCS degree with over 19 years experience in software development in the
shipping, utility and banking industry.
10 years experience in Oracle 8i/9i/10g using SQL/PLSQL, SQL tuning, SQL
Loader, triggers, ETL, Integration, Java Stored Procedures, FTP and UNIX
scripting. 4 years using J2EE and 2 years in C#. Also worked on BEA
Weblogic and JMS.
Languages/Software
Oracle PL/SQL, PLSQL Developer, SQL Loader, Unix Scripting, OC4J, BEA
Weblogic, C#, J2EE, AXIS, SOA, Tomcat, Servlet, JSP, JDBC, XML, Ftp, Ant,
Eclipse, Jdeveloper, TopLink, JMS, TIBCO EMS, Electronic Data Interchange
(EDI) using IBM DI MVS, GE Application Integrator/IES, COBOL, CICS, JCL,
SPUFI, TSO/ISPF, Easytrieve
PG&E
IT Database Operations Analyst
December 14, 2009 to present
. Provide production support to the SmartMeter project and ensure that
it completes its daily operational activities to properly bill
customers.
. Support Release H which involves adding SSN gas and Kvarh meters.
. Load data using external tables and Weblogic queue
. Coordinate resources for application updates
. Perform DB updates and patches.
. Created Unix scripts to automate repetitive process.
Environment :
Oracle 10g, BEA Weblogic, PL/SQL, AIX scripting, J2EE, SOA,
webservices, JMS, Teradata
Orient Overseas Container Line (OOCL) USA, Inc
Software Engineer
September 1, 2005 to August 3, 2009
. Performed data aggregation and initial data loading for AIO Sales and
SSEC module
. Did the data migration of Booking, Shipment and ITS using SQL Loader
. Retired the shipment webservice for AIO and Dashboard by exposing
shipment domain partition thru DB views and API
. Designed/developed the Standard Service Offering from
conceptual/physical modeling, data migration and bulk/batch testing
. Performed code review and tuning of SQL/PLSQL using Explain Plan,
Profiler, Autotrace
. Created/Maintained the Customer lookup, Sales Visibility Hierarchy and
AIO Booking modules end to end implementation using C#, J2EE, PL/SQL
. Exposed the shared tables like Vessel Schedule and Customer
Information via Web Service
. Modifed the Cutomer lookup to make use of paging and caching using
Tangosol coherence
. Involved in the POC for creating the Workflow Instantiation Manager
which uses TIBCO's EMS
. Migrated the shipment webservice from bottom up to top down
. Part of the committee that reviews the XSD DTO
. Part of the support team for CDRIVE applications from Jan 19 - Apr 5,
2009
Environment :
Oracle 10g, Oracle Application Server, PL/SQL, Unix scripting, J2EE,
SOA, webservices, C#, Visual Studio, Eclipse, TIBCO EMS
CargoSmart
E-Commerce Engineer
Feb 2, 2000 to August 31, 2005
. Designed/developed the integration module that extracts and ftp cargo
tracking and manifest for EDI processing using PL/SQL, DBMS_JOB,
DBMS_UTIL, ftp, unix scripts
. Designed and developed the integration module that uploads data coming
from external parties using SQL Loader and DBMS_UTIL..
. Have utilized Oracle's JVM to create a real time sql ftp instead of
using the usual approach of batch ftp. Pushed for the usage of
DBMS_JOB over daemon and cron scheduled scripts.
. Have created a DB centric program for housekeeping DB and UNIX
folders. This served as a standard that can be reused by developers
instead of creating their own.
. Performed a dual role as I was loaned to another team to function as
an Integration Analyst based from my past experience in EDI and
communication skill with dealing with customers/carriers. Due to
urgency, was requested to handle CargoSmart key accounts like Inttra,
Maersk, P&O, Hapag Lloyd and customer Diageo. This includes discussing
requirements with partners and creating necessary documentation for
EDI developers and Systems Analysts.
. Performed sql code review
. Went to Hong Kong and Manila from June to July, 2005 to turnover the
integration module.
Environment :
Oracle 8i/9i, PL/SQL, Unix Scripting, GEIS EDI and Application
Integrator
Orient Overseas Container Line (OOCL) Philippines, Inc
Systems Analyst
May 9, 1995 to Feb 2, 2000
. Project lead for the EDI team which has 7 programmers and is involved
in the preparation of specifications, development and maintenance of
messages for the Electronic Data Interchange (EDI) using DI MVS,
COBOL,CICS, JCL and DB2. Also provided primary support in the EDI,
Rate Request and Approval System (RRAS), served as backup in System
Security/Administrative functions and provide technical support in the
Payroll/Timesheet system.
. Went to Singapore and Malaysia from Nov 3 to Nov 12, 1997 to provide
technical assistance to colleagues/clients on EDI requirement
gathering notably IFTMIN/IFTMCS and went to Hong Kong from June 21 to
July 3, 1998 for AI/IES training.
. Worked in San Jose, California from March 23 to May 29, 1998 to
develop/maintain COBOL batch programs/JCLs to support EDI X12
messages.
EDI messages supported :
UN EDIFACT - CUSCAR, CUSRES, CUSREP, IFTMIN, IFTMCS, CODECO, COARRI
X 12 - TDCC210, 304, 310, 311, 315, 322, 410, 622
Environment :
IBM MVS/ESA, IBM DI MVS, Exceed, GE Application Integrator/IES,
Windows 95, EDI, COBOL, CICS, TSO/ISPF, JCL, Easytrieve, Foxbase, DB2,
VSAM
Coney Lopez-Manuel Dynamics
Programmer
October 20, 1994 to January 20, 1995
. Main task is to provide enhancement, testing and maintenance of the
Inventory system. Also knowledgeable in RPG 400 programming.
Javlon Information Systems, Inc.
Programmer
April 4, 1994 to September 30, 1994
. Main task is to provide enhancement, testing and maintenance of the
Common Trust Fund system.
Philippine Commercial International Bank
Contractual Programmer
January 23, 1992 to January 3, 1994
. Main task is to provide enhancement, testing and maintenance of the
Common Trust Fund system. Also acted as LAN administrator and provided
hardware/software support in the PC environment.
Exbyte Technologies Corporation
Junior Programmer/Instructor
September 23,1991 to January 20, 1992
. Main task is to provide user training/demos for Wang software
packages.
Logic Management Incorporated
Contractual Programmer
July 5, 1991 to September 15, 1991
. Main task is to develop the Personnel Information system.
Other Systems Developed
1. Cargo Billing System - used Foxpro for Windows (multi-user)
2. Payroll - used Clipper
Seminars / Training's Attended
1. Advance Java Programming Aug, 2009
2. Oracle PL/SQL Programming and Performance Tuning Nov 10-14, 2008
3. Intro to Visual C# for .NET + Developing .NET Apps for Visual C# .NET
Dec 10-14, 2007
4. TIBCO General Interface Aug 3-4, 2006
5. TIBCO EMS Jun 19-20, 2006
6. Java Programming Feb 14-17, 2005
7. Advance PL/SQL Mar 01-03, 2004
8. Introduction to Oracle for Experienced SQL Users April 16-18, 2001
9. Develop PL/SQL Program Units April, 2001
Contact this candidate