Resume

Oracle Developer

Location:

Walnut, CA

Salary:

135000

Posted:

April 19, 2020

Contact this candidate

Resume:

JOSE BLANCO

***** ******* **., ******* ***, CA **789

Email Address: adcvau@r.postjobfree.com

Telephone No : 626-***-**** (Mobile)

CAREER SUMMARY

IT professional with more than 27 years of experience in full life cycle development primarily in Oracle Technologies. Experience includes Oracle Financials (versions 11 and 11i), Oracle Developer 2000/6I/10G, Forms 4.5/6/6i/10G, Reports 2.5/6/6i/10G, Oracle PL/SQL, DDE (Dynamic Data Exchange) programming using Oracle Developer 2000 Forms, Microsoft Dynamics AX 2012 Trade and Logistics. Other skills include Systems Analysis, System Design, System Management and Testing.

SOFTWARE

Oracle Database (versions 7, 8,8i,9i,10G,11G,12c), Oracle GEMMS(modules include MPS, MRP, Sales Forecasting, Inventory, Purchasing, Formulation), Oracle Financials (A/P, Cash Management,A/R) (versions 11, 11i), Oracle Purchasing (version 11i), Oracle Inventory (versions 11i), Oracle Workflow 2.5/2.6, Oracle Developer Suite 10g (Forms, Reports, Designer, Discoverer, SQL Plus), Oracle Forms, Oracle Reports, Oracle PL/SQL, Oracle Discoverer, TOAD, Test Director, JavaScript, HTML, Oracle Designer, 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, Microsoft Visual Source Safe, Bridgetrak 5, Rave Reports, Barcode Anything, Qlikview v7/8.5, Oracle 11G BI Publisher, Microsoft Dynamics AX 2012 Trade and Logistics

PROFESSIONAL EXPERIENCE

SIMPLAIN 06/2012 – Present

Systems Integrations Specialist

Simplain Software Solutions LLC is a software solutions provider focusing mainly on implementation and support of Enterprise Software Systems.

Simplain is one of the very few companies in the U.S. with full life-cycle experience in implementing G.O.L.D. G.O.L.D. is a suite of Retail Management products from Aldata Solutions based in Atlanta, GA with its parent headquarters located in Paris, France.

Detailed Duties and Responsibilities

Studied user operations and identifies areas of potential improvements; monitors G.O.L.D. application performance and develop recommendation for correction and improvement.

Reviewed, evaluated and approved proposed system design solutions

Prepare and implement application solution that meets the user requirements.

oApplication solutions requires developing new Oracle PL/SQL objects as well as updating existing code.

oOracle Performance tuning – index creation, table partition, bulk collect, explain plan, etc.

oUnix shell scripting – used among other things for multithreading jobs

Ensure the timely completion of development projects within estimated costs and standards. This is done through weekly status reporting on the progress of applications development.

Tasks to load patch updates of the G.O.L.D. application.

Provides technical support to clients by performing these tasks: Issue Analysis, Development (New projects, enhancements, etc), and system maintenance.

Technologies used: Oracle SQL, Oracle PL/SQL, TOAD, PL/SQL Developer, XML, Unix, Oracle database version 12c

NORTHROP GRUMMAN 04/2011 – 05/2012

Oracle Developer

Northrop Grumman is an American global aerospace and defense technology company. The company was the fourth-largest defense contractor in the world as of 2010, and the largest builder of naval vessels. Northrop Grumman employs over 75,000 people worldwide. Its 2007 annual revenue is reported at US$32 billion. Northrop Grumman ranks #61 on the 2010 Fortune 500 list of U.S. industrial companies.

United States Postal Service (USPS), Eagan, Minnesota

Detailed Duties and Responsibilities

Acts as team lead for the RWHT (Rural Working Hours Tracking) Application on any issues, enhancements or revisions on this said application. This application is used for tracking the work hours of mail carriers all across the US.

Provides production support on the RWHT Application both on the backend and frontend part of the application.

Technologies used: SQL, PL/SQL, Oracle Forms 10G, Oracle Reports 10G, Unix, Linux, Windows NT, TOAD, SQL Developer, Dimensions, Remedy

Performed other related duties as may be assigned or required of the job.

EASTRIDGE INFOTECH 08/2010 – 03/2011

Oracle Analyst/Developer

Eastridge Infotech is an IT Staffing Solution Company that serves some of the biggest companies in San Diego, San Francisco Bay Area and Las Vegas areas.

LPL Financial, San Diego, California

LPL Financial is one of the nation's leading diversified financial services companies and the largest independent broker/dealer supporting over 12,000 financial advisors nationwide. It is also an enabling partner to a broad range of banks and credit unions, as well as broker/dealers at leading financial services companies. LPL Financial helps financial professionals manage the complexities of running successful organizations by providing their customers with access to:

Leading-edge tools and technology

Independent investment research

Dedicated service and training

Open product architecture offering investment solutions

Detailed Duties and Responsibilities

Designed the Commission System’s tier based computation of commissions for individual or groups of individual financial reps by breaking each commissions into rule groups, rules and elements.

Built/Programmed the tier based computation of commissions using Oracle Forms 10G and PL/SQL.

Designed and built/programmed the Mass Rep Setup process. This allows the users the ability to assign individual or groups of individuals to a lone rule or groups of rule at one time. These rules governs how each individual rep will get paid their commissions.

Technologies used: SQL, PL/SQL, Oracle Forms 10G, Oracle Reports 10G, Unix, SQL Navigator, TOAD

BYER CALIFORNIA 03/2008 – 03/2010

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.

Detailed Duties and Responsibilities

Investigate and resolve various functional and technical issues arising from Oracle EBS which includes Oracle Financials (GL, AR, AP, Cash Management), Oracle Inventory, Oracle Order Management, Oracle Purchasing.

Design and developed several procedures/functions/triggers using PL/SQL allowing Oracle Apps to send and receive data from non-oracle applications.

Ensured that Oracle applications and its database structure are designed to meet user requirements at the least possible cost.

Set up concurrent requests through Oracle’s System Administration module for customized Oracle PL/SQL objects such as procedures/functions/triggers and reports.

Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.

Build various customized Oracle Forms/Reports.

Debug and resolve issues of existing Delphi customized applications.

In charge of maintaining/creating several VB scripts that allows orders to be sent to overseas contractors. .

Assist in directing and supervising the activities and functions of various users in accordance with the new work processes introduced by the new Oracle E-Business Suite 10g.

Studied user operations and identifies areas of potential improvements; monitors application

performance and develop recommendation for correction and improvement.

Assist in guiding 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.

Maintained the quality and professional competence of the MIS department 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.

Created various management reports using Qlikview as its main tool for creating it. Reports made includes (Graphs, Tables, Dashboards, Pie Charts to name a few). Reports were made to extract data from various standard Oracle Apps tables and customized Oracle tables as well.

Performed other related duties as may be assigned or required of the job.

Technologies Used: Delphi, Oracle Developer Suite 10g (Forms, Reports, Designer), Oracle Workflow, Oracle E-Business Suite Package 11i(Oracle Inventory, Oracle Purchasing, Oracle Financials,etc.), Foxbase, Unix, Rave Reports, Barcode Anything, PL/SQL Developer, Rave Reports, Barcode Anything, Qlikview v7/8.5

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 Oracle PL/SQL 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 Oracle PL/SQL objects such as 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 using Oracle PL/SQL.

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 Oracle PL/SQL objects such as procedures/functions which in turn were incorporated in the M3 system for more control.

Developed several payroll related interface Oracle PL/SQL 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 Oracle 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

Acted 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 oracle 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 Oracle PL/SQL procedures, Forms and/or Reports in compliance with the technical specification.

Defined the testing parameters to be used on the various Oracle PL/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

Note:

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

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. Qlikview Professional, Oracle 11G BI Publisher Fundamentals

CERTIFICATION

Microsoft Dynamics AX 2012 Trade and Logistics

REFERENCE

Fernando Gonzalez

Chief Information Officer

Byer California

Phone: 415-***-**** Ext. 6319