Candidates About

Hector Hebron

CAREER profile

·         Over 20 years experience in the development of application systems including project management, business requirements gathering, programming, end-to-end testing, project implementation, user training and documentation.  Extensive experience in development and implementation of financial, manufacturing, retail and supply chain applications.

·         Consistently received high rating in annual performance review – for consistently meeting and frequently surpassing established objectives and customer expectations.  Goals achieved are well above standard in terms of business impact.

·         Proven ability to solve complex technical problems, detailed and very organized, excellent communication skills, strong commitment to quality and innovation, positive attitude and strong work commitment.

technical skills

·         IBM AS/400 (ISeries), Linux, Microsoft Windows

·         IBM Report Program Generator (ILE RPG with embedded SQL and Apache POI), IBM Control Language (CLLE), Visual Basic, JAVA

·         SALESFORCE, JDA VMR (E3), Teradata SQL Assistant, DB2 SQL, SDA, RLU, DBU, PDM, SEU, DFU, SAP Query/400, COGNOS, Powerplay, Aldon, Crystal Reports, Gentran Integration Suite (GIS)

·         Software Development Life Cycle (SDLC)

·         Microsoft Office – Excel, Word, Powerpoint, Project, Visio

career highlights

Senior Programmer/Analyst, NBC Universal (2001 to 2010)

Solution Architect, NBC Universal (2010-2016)

Technical Lead, NBC Universal (2016-2018)

Major Accomplishments:

·         Managed the conversion of the JDA VMR application into web-based GUI client. Single handedly analyzed, designed, coded, and implemented more than 200 RPGLE and CLLE programs to ensure compatibility with the VMR.

·         Re-designed the Point-of-Sales process to accommodate the new EDI file format (852) and to include configurable posting of post quantity sold, On-hands, Returns (both store and warehouse returns), Out of stock, On-Order, etc.

·         Improved the order replenishment process to eliminate hardcoding, to streamline necessary controls required by each partner and to consolidate PO assignment at the retailer or store level. Worked closely with the EDI, Sterling Integrator (SI) and SAP teams to ensure that technical and business requirements are all met.

·         Led the implementation of the JDA VMR application to Canada retailers. Collaborated with the Canada counterparts in deciding the best possible approach to handle the processing of the POS 852, SAP Open Orders, Shipments, and Cancellation files.

·         Initiated the multi-thread processing of critical batch processes to enhance system performance. This reduced the processing time of approximately 80% which eliminated the problematic delays of the order transmission to SAP and Technicolor.

·         Designed and developed forecasting system to support the demand of the fast moving new release and catalog materials.

·         Increased efficiency by introducing a tool written in Excel to give users the flexibility of changing key field values in JDA application. It also allows users to create orders and update the stock level which is very crucial to the calculation of suggested order quantities. The tool saved the users 75% of their time creating replenishment orders.

·         Improved productivity of the business users by 40% - architected the design of the added functionalities of the Planogram application written in VB.NET in windows.

·         Eliminated redundant process of program change and testing every time a new studio or partner is introduced into the system by creating Distribution Partner table driven reports

·         Completed the team’s initiative to migrate all ISeries applications to the newer IBM Power 7 servers.  Coordinated with Infrastructure Shared Services. Sterling Integrator, EDI, Hedway, SAP and business engagement teams to ensure data integrity was maintained, connectivity was functional and application was operational.

·         Maintained the Data Chain Management (DCM) application in Linux environment. Handled the yearly upgrade to the latest release of both batch and web based applications. Customized the batch processing front end written in SQL to interface daily product demand tables from Hedway to DCM.

·         Collaborated with business to provide solutions to the problem areas and improved processes critical to the business.  Provided 24/7 global support to JDA VMR business users.  Participated in defining test case scenarios to strengthen quality and functionality of key applications.

·         Worked closely with the SALESFORCE team in setting up the case management process and supporting the salesforce based in-house application.  Participated in brainstorming sessions related to design and development of case management applications.

Prior to 2001

·         Senior RPG Programmer/Analyst, Best @ IT International, 1999-2001

·         System Analyst/RPG Programmer, Hong Kong Bank of Canada, 1997-1999        

·         System Analyst /RPG Programmer, Pro-form Feeds Inc., 1995-1997                    

·         Assistant Lead, ROHM Electronics Philippines, 1991-1994                         

·         System Analyst / Programmer, Global Science and System Corp, 1990-1991

Accomplishments:

·         Supported the clients, Universal Studios and Universal Music in maintaining and enhancing the JDA VMR Application system. Developed systems and wrote RPG programs to introduce new tools and functionalities. Partnered with the business users in achieving their goals and increasing daily productivity.  Constantly monitored the JDA VMR application to ensure the integrity of interactive and batch programs.

·         Managed the implementation of the Global Cash Management System and Auto-Payment System. 

·         Responsible for the maintenance of the AS/400 system. Applied PTFs and upgraded the AS/400 Operating system to the latest release. Implemented the Novell Network using the AS/400 as the file server. Re-designed the Order Entry System using RPG for three different store locations to be able to accommodate the new business strategies. Converted the accounting system to be able to handle the Y2K.

·         Led the IT department of 4 programmers in the development of in-house application systems using RPG and DBASE III+. Supported the in-house manufacturing system developed in Japan on the AS/400 environment.

EDUCATION and TRAINING

Bachelor of Science in Computer Science

Salesforce Admin Course

Salesforce Trailhead Playground Courses

Gentran Integration Suite Fundamentals

Gentran Integration Suite Data Mapping and EDI Processing

JAVA Basic Programming

AS/400 Interactive Program Design

AS/400 Control Programming Workshop

AS/400 Literacy Program

AS/400 Relational Database Design and Coding

RPG/400 Interactive Programming Workshop

RPG/400 Programming

HOBBIES AND INTEREST

·         Playing guitar/drums and jamming with friends

·         Playing tennis/basketball

·         DIY projects at home