Engineer Developer

***********@*******.***

USA: 620-***-****

IVAN VALDEZ

JOB RELATED SUMMARY

30+ years of experience as a Database Developer

25+ years of experience in Oracle databases

15+ years of supply chain software implementation and integration

6+ years of experience managing software development teams including analysts, developers and DBAs

6+ years of student’s management software implementation

Proficient with both Unix and Windows shell scripting

3+ years of experience working in an Agile Environment.

Excellent communication, interpersonal and business skills such as allow me to relate to all levels of management, to a variety of business positions, and to work successfully with a diversity of personalities, customers and end-users. These skills include US, Canada and Latin America business cultures.

Quick learner and always eager to learn something new. Always receptive to any company training and adaptable to any company business policies.

Results-oriented, client-driven, dependable; not easily affected by job related stress.

SUMMARY

Over 30 years of professional experience in Analysis, Design, Modeling, Development, Support, Implementation and integration of applications in the client/server and web environments using Oracle and proprietary desktop databases

Over 20 years of experience creating PL/SQL code including SQL scripts and database objects (packages, procedure, functions, triggers). Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.

Data Architecture, data modeling, data integration, DB Performance tuning using Oracle

Extensive experience in PL/SQL and SQL performance Tuning and Batch Processing.

Extensive knowledge of Oracle Administration concepts such as architecture, memory structures, logical and physical structures and data dictionary

Proficient in installation, setup and configuration of Oracle 10,11,12 under Unix, AIX, Linux and Windows NT environments.

Extensive experience in SQL development tools such as TOAD and SQL Developer

Over 5 years of experience using Oracle Web Application Server

Over 2 years of experience using Developer2000, Designer2000, Forms and Reports 6i

Over 10 years implementing JDA products such as Demand, Fulfillment, Collaborate and Monitor Also experience implementing JDA PMM, Sequencing, Strategy and Flowcasting

Basic knowledge and understanding of Data Warehousing.

Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.

Familiar with Perl Scripting, PHP, Java, JavaScript

Familiar with version control software such as CVS and ClearCase

PROFESSIONAL EXPERIENCE

HALLMARK (KANSAS CITY, USA) / INFOSYS

OCT 2020 – MAR 2021

TECHNICAL ARCHITECT (INDEPENDENT CONSULTANT)

Responsibilities:

Co-Lead technical activities for the implementation and integration of JDA Demand and Fulfillment 2019 version. Created technical specifications and scripts for customizations.

SAVE ON FOODS (VANCOUVER, BC, CANADA) / INFOSYS

JAN 2019 – JUL 2020

TECHNICAL ARCHITECT (INDEPENDENT CONSULTANT)

Responsibilities:

Lead technical activities for the implementation and integration of JDA Demand, Fulfillment, Promo and Inventory Optimization 2019 version for over 200K products in 200 locations. Created technical specifications and scripts for customizations. Troubleshoot performance issues.

Provided solution design for various integrations points between JDA products and internal applications.

PHILPS VAN HUSEN PVH (BRIDGEWATER, NJ) / SPINNAKER

AUG 2018 – NOV 2018

TECHNICAL ARCHITECT (INDEPENDENT CONSULTANT)

Responsibilities:

Support System Integration Test for Wave 3 implementation of JDA Fulfillment for retail SKUs

MARS (MOUNT OLIVE, NJ) / ACCENTURE

JUN 2017 TO AUG 2018

TECHNICAL ARCHITECT (INDEPENDENT CONSULTANT)

Responsibilities:

Lead the technical upgrade from 7.6 to 8 version of JDA Demand and Market Manager to a newer version for US Chocolate Division including architecture of new integrations points

Member of the team responsible to develop an unified version of JDA Demand 9 across all the organization. Created technical design documents and develop all the corresponding scripts/setup including PL/SQL, JDA configuration and Perl scripting

REVLON (EDISON, NJ)

JAN 2017 – MAY 2017

TECHNICAL ARCHITECT (INDEPENDENT CONSULTANT)

Responsibilities:

Lead the technical implementation of several countries into JDA Demand/Collaborate

Redesign of the batch scripts to allow a more flexible, simple and efficient way to implement new countries to the application

JDA SOFTWARE

AUG 2008 – NOV 2016

TECHINCAL ARCHITECT

Responsibilities:

Participated and lead several implementation projects of JDA products such as Demand, Fulfillment, Collaborate, Flowcasting, Monitor and Sequencing for US, Canada, Mexico and Chile based clients.

Provided full lifecycle support to clients from initial client interaction, product installation and requirements analysis through integration, design, coding, testing, debugging, implementation and provide ongoing application support and troubleshooting.

Performed several upgrades from different versions for different products

Collected user requirements, proposing technical design, architecture integration and technical specifications documents, developing code per the specifications, doing code reviews and unit testing, facilitate source code control.

Integrate JDA with several applications including SAP and internal applications

Developed PL/SQL scripts, procedures and functions, created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers. to support the needs of the implementation according with functional requirements.

Co-Lead the first approach to integrate JDA PMM with SCPO Suite by using Datastage

Used tools such Toad and SQL Developer to create PL/SQL code, SQL queries, extract and test data in the database, monitor sessions, test execution plans and perform basic Oracle administration tasks

Use SQL*Load and SQL*PLUS extensively to create inbound/outbound scripts for interfaces and data conversion scripts

Created Shell scripts in Unix and Windows to support batch execution

Created XML files to customize JDA’s processes execution

Enforced database integrity using primary keys and foreign keys.

Created PL/SQL functions to facilitate business functions and calculations.

Performed installation assessments and performance improvements including application and Oracle tuning

Fine-tuned procedures/SQL queries for maximum efficiency. Create indexes and using Oracle Hints where required. Used various performance tuning techniques using tools provided by Oracle like Explain Plan, SQL*Trace, TKPROF, Autotrace.

Opened trouble tickets and view status, reviewed details of past service issues and signed up to receive trouble ticket updates.

Environment:

Oracle 10g, 11g. PL/SQL, SQL, Toad, Unix, Linux, AIX, Windows shell scripting, XML, ClearCase, Eclipse, SQL*Load

JDA SOFTWARE

2007 – 2008

SR. SOFTWARE ENGINEER

Responsibilities:

Participated in the team to integrate Order Optimization with JDA Fulfillment using Java

Created scripts including Java code and database test data for unit testing

Used CVS for source control

Used Agile methodology

Environment:

Oracle 10g, 11g. PL/SQL, SQL, Toad, Java, JDBC, CVS

JDA SOFTWARE

2003 – 2007

SOFTWARE ENGINEER

Responsibilities:

Lead batch module development for PRO’s forecasting application.

Created technical specifications from functional design requirements

Developed SQL, PL/SQL, SQL*Plus programs required to calculate forecast using cursors, bulk collect and exception handling.

Identified test cases. Created PL/SQL code and SQL scripts for unit testing including data test creation.

Used CVS for source control

Used Agile methodology

Environment:

Oracle 10g, 11g. PL/SQL, SQL, Toad, CVS

JDA SOFTWARE

2002 – 2003

SR. PROGRAMMER/ANALYST

Responsibilities:

Implemented performance improvements (65% overall) into PMM to allow huge volume data processing

Modified existing PL/SQL packages, procedures and functions to include bulk collect and hints. Optimized cursor queries.

Created PL/SQL code and SQL scripts for unit testing including data test creation.

Environment:

Oracle 10g, 11g. PL/SQL, SQL, Toad

JDA SOFTWARE

2001 – 2002

TECHNICAL CONSULTANT

Responsibilities:

Participated in several implementation projects of JDA PMM

Provided full lifecycle support to clients from initial client interaction, product installation and requirements analysis through design, coding, testing, debugging, implementation and provide ongoing application support and troubleshooting.

Created technical specifications documents, developing code per the specifications, doing code reviews and unit testing, facilitate source code control.

Developed PL/SQL scripts, procedures and functions, created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers. to support the needs of the implementation according with functional requirements.

Used tools such Toad and SQL Developer to create PL/SQL code, SQL queries, extract and test data in the database, monitor sessions, test execution plans and perform basic Oracle administration tasks

Customized UNIFACE interfaces as per client requirements

Environment:

Oracle 10g, 11g. PL/SQL, SQL, Toad, UNIFACE

UNIVERSIDAD DE GUADALAJARA

1993 – 2001

CHIEF SOFTWARE ARCHITECT

Responsibilities:

Positioned the University as a leader in the region on software development and student’s administration systems.

Managed a team of 16 people that participated in the implementation and integration of the Banner Student System including developers, analysts and database administrators

Successfully implemented Banner Students System for over 100K students across 10 campuses

Support the University transition to use credits instead of fixed subjects plan

Created custom web based applications to enable access to faculty (input qualifications, class schedule query) and students (registration, class schedule and qualifications query)

Successfully established Oracle as the database foundation for administrative porpoises.

Environment:

Oracle. PL/SQL, SQL, SQL Developer, Designer2000, Developer2000, Oracle Forms, Oracle Reports, Oracle Web Application Server, Banner Software, Clarion, FoxPro, Erwin, HTML

EDUCATION

ITESO – GUADALAJARA, MEXICO, 1987-1991

Bachelor’s Degree, Computer Systems Engineering

OTHER HIGHLIGHTS

US Permanent Resident

Over 6 years teaching IT at several universities and institutes

Speaker in Oracle Open World Mexico – “Creating Web based applications using OWA and PL/SQL”

Experienced Clarion Programmer

Experienced WinDev Programmer

Experienced Mac OS user

Contact this candidate