JOSE BLANCO
12 Calle Este, Walnut Creek, CA 94597
Email Address: [Send email using form at bottom]
Telephone No. : (909) 967-6729 (Mobile)
CAREER SUMMARY
IT professional with more than 15 years of experience in full life cycle
development primarily in Oracle Technologies. Experience includes Oracle GL v11
and v11i, AP, Cash Management, Oracle Developer 2000/6I, Forms 4.5/6/6i, Reports
2.5/6/6i , Oracle PL/SQL, DDE (Dynamic Data Exchange) programming using Oracle
Developer 2000 Forms. Other skills include Systems Analysis, System Design,
System Management and Testing.
HARDWARE
IBM PC Compatibles, IBM PC Family, Apple Macintosh, Micron Millenia Pro, HP K
Class 9000 Servers (HPK200, HPK460), Compaq Proliant, AS400, IBM Mainframe.
SOFTWARE
Oracle GEMMS(modules include MPS, MRP, Sales Forecasting, Inventory, Purchasing,
Formulation) , Oracle Financials v11i (11.5.5, 11.5.9) (A/P, Cash
Management,A/R), Oracle Purchasing, Oracle Inventory, Oracle Workflow 2.5/2.6,
Oracle Developer 2000, Oracle Forms 4.5/6/6i, Oracle Reports 2.5/6/6i, Oracle
PL/SQL, Oracle Discoverer 3.1, TOAD, Test Director, JavaScript, HTML, Java 1.2,
Oracle Designer 6.0/6i, CICS/Cobol, Dbase III+, Foxbase, Foxplus, Foxpro, DOS,
DOS/VSE, HP Unix, Red Hat 7.1 (Linux), Flow Chart, MS Project, Visio, MS Word, MS
Excel, Powerpoint, MS Exchange, Internet Explorer, Turbo Pascal, Clipper Summer
'87, Clipper v5.x, Novell v3.x/v4.x., Windows 95, Windows 98, Windows Xp, Windows
NT, Crystal Reports 8.5
PROFESSIONAL EXPERIENCE
BYER CALIFORNIA 03/2008 – Present
Oracle Analyst/Developer
Byer is one of the leading garment manufacturers in the USA. It first began as a
garments company in 1964. Today, the company has grown to include a huge
selection of clothing styles for all ages. You’ll probably recognize some of
their labels from some of the big Department Stores around.
I am currently working as an Oracle Analyst/Developer for Byer. My main task is
to provide support in the implementation of the Oracle E-Business Suite on the
whole organization. Supporting role includes analysis, design and programming of
new requirements and attending to issues of existing applications made using
Delphi (Delphi 6/Delphi 2005), customized Oracle Reports/Forms (developed using
Oracle Forms/Reports 6i), Foxpro, Crystal Reports 8.5, Rave Reports 4.0, Barcode
Anything. The company recently purchased the whole package of the Oracle
E-Business Suite version 10g with the intention of replacing their old system
with this new package. I am part of the team that is tasked to create a number of
customized oracle forms/reports/procedures/functions/triggers where the new
Oracle Apps are found to be lacking and are unable to support the process
structure of the company. The technology that are mainly used here are Oracle
Developer Suite 10g (which covers forms, reports, designer, discoverer) and
Delphi 2005. These customized applications are being fully integrated to the
various applications that are part of the Oracle E-Business Suite 10g like Oracle
Financials, Oracle Inventory, Oracle HR, Oracle Purchasing, etc.
COMPUTER BUSINESS PROGRAM 06/2004 – 02/2008
Analyst / Programmer
Computer Business Programs (CBP) was established in 1983 as a sole
proprietorship and incorporated in 1988 in the state of California. CBP provide
services and supports for Oracle Products especially Oracle Financials (FIS),
Oracle Development Tools, Oracle Database… to include System analysis,
Installation, Modifications, Training and On-going support. CBP has also
teamed-up, as subcontractors, with large-scale companies such as IBM, Oracle
Corp., Spear Technologies…for supporting their software packages at various
Government agencies.
Spears Technologies, San Francisco, California
• Prepare technical documentation of M3 Timekeeping Custom Object details.
• Provide technical support for MTA M3 Installation
• Technologies used: TOAD, PL/SQL Developer, Visio
Metropolitan Transportation Authority (MTA), Los Angeles, California
• Part of the original team that implemented Spear 3i Work Manager (an
application designed specifically for maintenance management by transportation
operators
• Developed several business rules and translated it into
procedures/functions/triggers for incorporation in the Spear 3i Work Manager
• Developed several related interface programs to allow exporting/importing data
to and from MTA's current maintenance management system and Spear 3i Work
Manager, thus, establishing a link between the old and the new system.
• Reviewed and modified existing customized reports using Crystal Reports 8.5
• Design and create new customized reports using Crystal Reports 8.5
• Design and create new customized reports using Oracle Reports 6i
• Prepared documentation on several of Spear 3i Work Manager’’s modules - mainly
technical specs which includes the various custom objects that were added on into
the application
• Conduct User Training on Spear 3i Work Manager’s various module.
• Prepared training documents on Spear 3i Work Manager’s various module
• Migrated critical data elements from the old to the new system (i.e. employee
records, shift schedules, equipments)
• Provide technical and user support.
• Technologies used: SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Windows
NT, Oracle Application System Administration 11i, TOAD, PL/SQL Developer, Crystal
Reports
JOHN CLEMENTS CONSULTING, INC. 09/2001 – 06/2004
Analyst / Programmer
John Clements is an organization that supplies clients with people
having various technical expertise on programming, systems design, and systems
development, and provide these clients information technical solutions.
Metropolitan Transportation Authority (MTA), Los Angeles, California
• One of the 4 technical people tasked to provide technical support during the
installation, testing, and implementation of the new M3 system (a transportation
maintenance & materials management 3rd party application developed by Spears
Technologies) company wide.
• Tasked to look after the timekeeping function of the M3 system and ensure that
it complies with the standard business practice of MTA.
• Developed several business rules and translated it into procedures/functions
which in turn were incorporated in the M3 system for more control.
• Developed several payroll related interface programs to allow
exporting/importing data to and from Oracle Payroll
• Technologies used: SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Windows
NT, Oracle Application System Administration 11i, TOAD, PL/SQL Developer, Crystal
Reports
Cooper, Kardaras & Kelleher, Los Angeles, California
• Task to design and build custom reports using Oracle 6i for existing
customized Timekeeping system.
• Assigned to do system administrator work such as security and customizations
of menus to match actual business responsibilities for Linux box and connected
workstations whenever deemed necessary
• Currently acting as a Help Desk person for the whole company whenever there
are any hardware or application related problems that a user or a group of users
might have in the day to day operation.
• Technologies used: Windows NT, Linux Red Hat 7.1, Oracle Forms 6i, Oracle
Reports 6i, Oracle 8i (database), MS Access, Paradox
Triple I, Denver, Colorado
• Perform an in depth analysis of the business requirements and produce a User
Requirements Specification in relation to the Oracle Financials 11i installation
of Qwest.
• Built customized forms and reports for Qwest using a combination of Oracle
Reports 6i and Oracle Forms 6i whereby these customized forms and reports were
made to access various Oracle Financials 11i tables.
• Perform the various steps involved in order for these customized forms and
reports to be registered as concurrent programs within the Concurrent Manager
option found in the Oracle System Admin 11i module.
• Modified existing forms found in Oracle Financials 11i by putting into effect
the changes using Custom PLL to implement these changes and in some cases used
Oracle Workflow to change the behavior of certain processes within the Oracle
Financials 11i itself.
• Prepare training documentation and assist in conducting training sessions
• Assist in conducting presentations to internal users for system changes.
• Technologies used: SQL, PL/SQL, Oracle Workflow 2.5, Oracle Forms 6i, Oracle
Reports 6i, Windows NT, Oracle Application System Administration 11i, TOAD
HEADSTRONG (formerly JAMESMARTIN + Co.) 10/1999 - 8/2001
Sr. Consultant
Headstrong is a global consultancy company based in Fairfax, Virginia that
creates real business value from digital technologies.
Rexel, Paris, France
• Analyzed the client’s system requirements on changes/enhancements to be done
on specific areas of functionality of Oracle 11i Applications (includes
Financials, Order Management, Inventory, Purchasing)
• Prepared Technical Specifications of the various customized SQL procedures,
Forms, and Reports to be integrated in these Oracle 11i Applications.
• Prepared Technical Specifications of the various changes/enhancements to be
done on existing Oracle Application Forms, Reports and internal processes.
• Built SQL procedures, Forms and/or Reports in compliance with the technical
specification.
• Defined the testing parameters to be used on the various SQL procedures, Forms
and Reports created.
- Formulated a project plan that includes the tasks, time table, and personnel
assignment.
• Monitored the progress of the project to ensure the timely completion of each
task.
• Technologies used: Oracle 11i Applications, Oracle Forms 6i, Oracle Reports
6i, Oracle Workflow, TOAD, UNIX, Windows NT, Test Director, Oracle Discoverer
3.1, MS Project
Merrill Lynch, Tokyo, Japan
• Performed system testing of all programs created using PL/SQL and Perl that
will handle the consolidation of Merrill Lynch's two subsidiaries' database,
Merrill Lynch Japan and Merril Lynch Japan Securities.
- Implemented immediate resolutions to all reported errors found during test
run.
• Verified the accurateness of all merged data in Oracle 11i GL by generating
Oracle 11i GL reports.
• Checked and reviewed Oracle 11i GL setup.
• Built PL/SQL routines using the SQL Loader to upload/transfer data from legacy
systems to Oracle 11i GL
• Technologies used: UNIX, Perl, Oracle Reports 6i, Oracle GL 11i, TOAD, Test
Director, MS Project, MS Access
Dairy Farms International, Hong Kong
- Designed and programmed the module/programs that uploads financial info from
various customized
systems such as Billing, Inventory and Receivables to Oracle GL.
- Exposed the programs to a very exhaustive unit testing to ensure that all
test scenarios and conditions are covered.
• Provided a quick resolution to errors or changes in the program.
• Technologies used: Oracle Forms 6i, Oracle Reports 6i, Oracle Designer 6i,
Oracle Workflow, Unix, Test Director, TOAD, MS Project
Sterling Tobacco ( a subsidiary of Philip Morris, Int’l), Sampoerna, Indonesia
• Actively performed as assistant project manager.
- Defined the system requirements on Oracle 11 Payables/Oracle 11 Cash
Management by forming discussion groups.
- Configured Oracle 11 Payables/Oracle 11 Cash Management based on the system
requirements that were gathered from the group discussions.
- Conducted user training to ensure the proper operation of the Oracle 11
Payables and Oracle 11 Cash Management Applications.
• Built customized reports and include it in Oracle 11 Payables and/or Oracle 11
Cash Management.
• Technologies used: Oracle Forms 6, Oracle Reports 6, Windows NT, TOAD, MS
Project
SELECTA WALLS, Philippines 11/1993 10/1999
SA-Programmer/Applications Supervisor
Selecta Walls is a subsidiary of Unilever, LLC which is into ice cream
manufacturing. Selecta is also the
official distributor of Hersheys chocolates and Sunkist in the Philippines.
Unilever is a well known
manufacturer of various commodity from bath soap to various food products and is
considered one of the biggest competitor of Procter & Gamble.
Projects
1. Customer Service System (CSS)
• CSS is composed of several systems assigned to do specific tasks. These
systems are the Billing System, Sales Monitoring and Forecasting System, Payment
System, Freezer Monitoring System, Returns Accounting System, and Credit/Debit
Memo System.
• Total Quality Management concept was adapted into these systems in order for
the company to maximize profits and minimize loss.
2. Manufacturing Management System (MMS)
• MMS is composed of several systems. These systems are the MPS/MRP System,
Inventory System, Purchasing System, and Formula System
3. Personnel and Timekeeping System (PTS)
• PTS keeps track of all the employee’s attendance as well as their respective
leave balances. It is also the repository of each of the individual employee’s
personal information.
4. Accounting System (AS)
• Composed of these systems: General Ledger, Accounts Payables, Accounts
Receivables and Cash Management
5. Oracle Global Enterprise Manufacturing Management System (Oracle GEMMS)
• GEMMS is composed of several systems involved in the manufacturing cycle.
These systems are the MPS/MRP System, Inventory System, Purchasing System, Sales
Forecasting and Formulation System
Notes:
• I was heavily involved in the actual planning, analysis and design,
programming and implementation of the various systems listed above.
• All systems were migrated twice: initially from an AS/400 platform based
system downsized to a Clipper based system running in DOS and Novell and finally
Oracle (using a combination of customized applications and Oracle GEMMS).
• Did a feasibility study on a third possible migration to SAP for all the
systems listed above.
Technologies Used
Cobol, Clipper 87, DOS, Novell, HP-UNIX, Oracle 7.1, Oracle Forms 4.5/6i, Oracle
Reports 2.5/6i, Oracle PL/SQL, Microsoft Project
Detailed Duties and Responsibilities
• Directed and supervised the activities and functions of the SA/Programmers in
the design and
development of applications.
• Studied user operations and identifies areas of potential improvements;
monitors applications
performance and develop recommendation for correction and improvement.
• Reviewed, evaluated and approved proposed system design solutions and
determine feasibility and
practicability in user environment.
- Guided users and management in the selection and implementation of automated
systems.
• Coordinated activities and interaction between users and information
technology to ensure efficient
applications design.
- Ensured that applications are designed to meet user requirements at the least
possible cost.
- Estimated resource requirements, cost and items needed for systems projects.
• Maintained the quality and professional competence of the department, staff
and consultants; evaluated their performance and reported on personnel activities
to the IT Manager through weekly and monthly IT Status Reports.
• Assisted in the implementation of programs to educate management and users in
information
processing and system capabilities, uses and requirements.
• Ensured timely completion of development projects within estimated costs and
standards. This is done through weekly status reporting on the progress of
applications development.
- Performed other related duties as may be assigned or required of the job.
DEVELOPMENT ACADEMY OF THE PHILIPPINES 1989 - 1993
Jr. Programmer/Programmer/Team Lead/Systems Analyst
EDUCATION
BS/Computer Engineering, Adamson University, Manila, PH, 1989
COMPUTER SCIENCE STUDIES/TRAINING/SEMINARS
Novell Systems Administration, Systems Analysis and Design, Pascal Programming,
Cobol Programming, MVS/CICS, Project Management, Novell Network Management, Unix
Operating System, Unix Systems,Administration, Oracle PL/SQL v7, Oracle
Developer/2000 Forms v4.5, Oracle Developer/2000 Reports v2.5, Oracle Developer
2000 Tuning and Techniques, Oracle Discover v2, Oracle Payables, Oracle
Receivables, Oracle Cash Management, Oracle Purchasing, Oracle Inventory,
Javascript Programming, Oracle Business Intelligence Enterprise Edition 11g
REFERENCE
Greg Sanders
Implementation Manager
Phone: (316) 706-8340
Email: g_s_sanders@hotmail.com
Ted Maasin
Oracle Retail Consultant
Logic Information Systems, Inc.
Phone: (925) 212-3621 (Office)
Email: tmaasin@yahoo.com
Joselito de Lusong – Senior Systems Engineer
Oracle Corporation
Phone: (732) 841-7022(Cell)
Email: jdelusong@yahoo.com
Regina Lim
Project Manager
Metropolitan Transport Authority (MTA)
Phone: (213) 922-4545 (Office)
Email: limr@metro.net
Flor Alcazar
Project Manager (Retired)
Farmers Insurance
Phone: (909) 444-1941
Email:
|
