Tijo M.

[A] Summary

Overall ** years of experience in IT out of which over 8 and half years in

JDE as Technical Consultant, Lead.

JD Edwards technical expertise includes development / modification using

Enterprise Report

Writer, Interactive Application, Table Design Aid, Table Conversions,

Writing & debugging

NER and C BSFN, Other Enterprise One Development tool sets.

Training in Finance Module in JDE

Knowledge of BSSV

Experience in Databases, and Customer relationship management domains

Well-developed interpersonal and communication skills, having dealt with

diverse

Professionals, clients & team members at global locations

Excellent analytical, negotiation & Organizational skills

Self-motivated, able to set effective priorities to achieve immediate, long-

term goals and meet deadlines.

[B] Skillsets

Operating Systems: Windows 3.x, Win 95, Win 98, NT, Windows 2000 &

XP, UNIX, M.S Dos

ERP: JD Enterprise One XE Edwards World, JD Edwards

Packages: MS Office 2000 (Word, Excel, Power Point & Outlook)

Adobe Acrobat, Adobe Reader

RDBMS: Oracle 9.2.0.1.0, SQL Server 2000 & MS Access 2003,

Language: C, C++ & Visual Basic 6.0, Java 2.1

[C] Project Experience

Weatherford Houston, Texas (Onsite)

> Project Details

Duration : Feb, 2013 - May, 2015.

Project : Enterprise One E9.1 Upgrade

Role : Project Lead/Developer

. Technical lead for Finance module.

. In charge of deliverables of 450 objects in Finance.

. Was involved in Client interaction, Setting up the quality processes,

review methods

. Helped in making project execution plan using pivot tables.

. Reviews of Technical Specifications Document, Design Document

(Technical as well as non-technical), Program Specifications and Test

Cases

. Interaction with offshore team for execution and deliverables.

. Worked on Critical object of Service Rental "Service Delivery

Ticket"(P594210H), which is cloned from P4210 (Sales Order) and P0411,

P4314 and P04571

. Worked on MBF'S of Finance (B040047, XT4314ZN, XT4314Z2) and cloned

MBF's of Sales order (B4200310, B4200311)

. Onsite technical developer for any finance related issues during CRP's

Archer Daniel Midlands Illinois (Onsite)

> Project Details

Duration : Nov, 2012 - Jan 2013

Project : Enterprise One E9.1

Role : Senior Consultant

. Responsible for analyzing the functional requirement and estimate the

time required for developing technical specifications, technical

development & unit testing.

. Point of contact for client interactions, project execution and

deliverables

. Developed Customized application, reports based on client requirement

. Modified C BSFN

Stoneridge Electronics Ohio (Onsite)

> Project Details

Duration : July, 2011 - Oct, 2012

Project : One World XE

Role : Lead/ Senior Consultant

. Responsible for analyzing the functional requirement and estimate the

time required for developing technical specifications, technical

development & unit testing.

. Point of contact for client interactions, project execution and

deliverables

. Developed Customized application, reports based on client requirement

. Created and worked on SQL queries based on business requirement

. Developed new applications, reports as per client requirement

. Modified applications reports as per client requirement.

Windsor Foods California (Onsite)

> Project Details

Duration : March, 2011 - July, 2011

Project : Enterprise One E9.0

Role : UPK Lead.

. Lead a team of 3 consultants

. Developed UPK Topic for 200+ CRP scripts

. Development of UPK topics as per business requirement and testing the

same.

. Modules covered includes Finance, OTC, PFI

RSB, India

> Project Details

Duration : Feb, 2011 - March, 2011

Project : Enterprise One E9.0

Role : Senior Technical Consultant.

. Retrofitted objects (R55POIN01, P574312, P5743121, P58SL30A, P571351,

and P571352).

PT AGRO, Indonesia

> Project Details

Duration : Aug, 2010 - Jan, 2011

Project : Enterprise One E9.0

Role : Senior Technical Consultant.

. Responsible for analyzing the functional requirement and estimate the

time required for technical specifications, technical development &

unit testing

. Developed Customized application using power forms for creating an

online calculator to make formulas

. Customized application P3711 to decode the formulae and calculate the

Test Result value for Test ID for the above formula.

. Developed Customized application to insert Custom rows in grid based

on client format and calculate values based on formulae

. Developed Customized report for calculating tank wise usage details.

. Developed an EDI interface for fetching records from customized table

and inserting them into F0911Z1 file for running the preprocessor

program

. Developed application using power form to upload data into customized

table and validate data

. PO print report customized as per client specification

. New GRN print developed as per client specification

Cargill

> Project Details

Duration : June, 2010 - July 2010

Project : Enterprise One E8.12

Role : Senior Technical Consultant.

. Customized report for Canceling ST lines from F4211 and related OT

lines from F4311

. Customized report to Canceling F4600 lines using standard BSFN

. EDI interface for Calculating Credit Card commission from customized

table and uploading to "Z" files F0911Z1 and F03B11ZI

. EDI interface for calculating Sales Tax for different items business

unit wise and uploading it to "Z" file F0911Z1

JBPCO, USA

> Project Details

Duration : October, 2009 - May 2010

Project : Enterprise One E8.12

Role : Senior Technical Consultant.

. Responsible for Client interactions.

. Responsible for writing technical specifications for new reports as

well as doing unit testing for the reports developed

. Retrofitted objects (R42565,R43500,P43011,P4310) in DV, tested the

same in QA

. Created dummy records in application to test the data.

. Debugged and modified C BSFN

. Developed Sales reports for UnCosted Inventory, Received Not Vouchered

Inventory, In transit Inventory, Freight Calculation, Taxation Reports

based on the Category Codes, Accounting Information etc.

. Customized Application P55003B to check for the existence of Multiple

record in F00165 and update the same in P3003 Media Object

. Customized Automatic Check Print Report (R04571) as per client

Requirement

. Customized report R31435 as per client requirement.

. Made Custom report for Positive pay details and customized application

P007101

. Created new report to update Planning resource Set duration and

capacity required (F34A190, F34A120) based on customer formula for

resource set in F34A180 having the same RESCD as the work Centre Code

in F34A180

. Cosmetic modification in Print Invoice (R42565), PO Print (R42520)

and Work Order Print (R31415)

Undergone training is World Soft AS400 Platform from Aug 2009 to Oct 2009

YUM Restaurants India Head office (Onsite)

> Project Details

Duration : October, 2008 - July 2009

Project : Enterprise One E8.12

Role : Senior Technical Consultant.

> Project Scope & Responsibilities

Yum Restaurant International has Brands namely, American Food, KFC,

Long John Silver, Pizza Hut and Taco Bell. Supply Chain management is

the source of revenue for YUM

. Responsible for on site development, deliverables.

. Responsible for writing technical specifications for new reports as

well as doing unit testing for the reports developed

. Made Outbound interface for directly uploading data into the

Citibank website for Cheque, DD and Draft Printing. Tables used

F04571, F04572, F04573, F0030, and F0911. Made inbound interface

for Bank reconciliation, for data received from Citibank.

. Customized C BSFN to check to include PDDJ as part of the primary

key.

. Report for voiding stale Cheque entries in F0911 using JE entries,

update the same in table F0911R as "R" based on date criteria

passed by the user.

. Created New Customized Report (Fixed Asset Register)

. Made custom reports to track expenses by defining category codes in

F0901 based on the JE's created for the expenses,

- Repair and Maintenance, Preoperative expenses for displaying the

expenses incurred during a period. Based on table

F0911,F0901,F0414 F0413 and F0902

- Marketing expenses incurred by the company for a period .Based

on table F0901, F4311, F0411 and F4301.Includes Marketing

summary.

. Supplier information Fetch. Tables F0101, F0111, F0116, F0115,

F751010, F01151, F0030, F0401.

. As of Open AP report for displaying Open Tax, Vendor amount

including their totals. Tables used F0411, F0411A and F75I100.

. Balance Confirmation report based on supplier balance as on Date

. Modified Customized version of Report Print Invoice (R42565), PO

Print (R42520)

. Modified Customized version of Cheque Cum Voucher for including DMS

No.

. Modified Customized version of PO Print Report

. Customized Custom Report Profit & Loss Business Unit-wise.

Mainetti, Hongkong

> Project Details

Duration : August, 2007 - August, 2008

Project : Enterprise One E5.0

Role : Technical Consultant.

> Project Scope & Responsibilities

Mainetti uses the state of the art robotics and automated equipment

for the production of garment hangers of the highest quality at the

lowest possible cost.

. Done analysis for their manufacturing module .Understanding of Cost

component details like cost roll up programs frozen cost and simulated

cost. Understanding of BOM details and routing details. Made High

level functional specs for manufacturing module.

. Modified Standard report R30445A (Multiple Level Costed Bill of

Material) for updating F0911 standard table with Bifurcated COGS

entry(A1 Cost bifurcation) for already sales updated entries as well

as for special inventory items.

. Modified Standard report R4210IC to update ADDJ date on the day of

actual ship confirmation

. Modified Customized report intercompany order generation.

. Made interface for exporting F4072 and F41061 details to .csv file.

Interface to import modified csv to custom table for updating standard

tables.

- Price Adjustment Detail (F4072)

- Supplier Catalog (F41061)

Mass Update of F4072, F41061 based on custom table.

. China Jing Sui Invoices numbers are given by Govt. and generated on

Jing Sui software.

Made interface for Exporting JDE to Jing Sui details using in

"txt"format, made interface for importing the same for updating custom

table.

. Report for updating Jing Sui Invoice No. and Batch No in F03B11.

. Worked on customization of Standard Sales Order Application (P4210) to

generate the calculated Promise Delivery Date based on the functional

requirement.

. Worked on customization of Standard Sales Blanket Order Release

(P554011) to generate the calculated Promise Delivery Date based on

the functional requirement

. Made Interactive application/ report for changing currency rate for

A/P module.

. Done Modification on custom application Supply demand Inquiry.

. Developed technical specs as per the functional requirement.

. Updated functional specs for any revisions.

Globus Head Office, Santa Cruz

> Project Details

Duration : March 2007 - May, 2007

Project : Enterprise One 8.11

Role : Associate Technical Consultant.

> Project Scope & Responsibilities

Daily cash flow Inflow/ outflow report - G/L, A/P, A/R module

Created report for the cash Inflow/ Outflow for transfer to Head

office, Real estate and Stores module.

Invitrogen, USA

> Project Details

Duration : September 2006, February 2007.

Project : Enterprise One 8.11

Role : Associate Technical Consultant.

> Project Scope & Responsibilities

Responsible for providing development & customization of reports for

Sales, Manufacturing as well as changes to existing report

. Designed Reports as follows:

1. GOE Orders Meet MFG cut off Time, Component History Report; Quotes

with Discontinued SKU, Vendor Address book Maintenance Report, Bank

Batch by Day Report etc...

Encomium, Dubai, UAE

> Project Details

Duration: January 2005 - July 2006

Role: CRM/Data Analyst

Environment: MS Access, SQL Server, MS Excel

> Project Scope & Responsibilities

. Make CSI/SSI reports for the surveys conducted, which is a part of

DC's (Daimler Chrysler) international CSI/SSI reporting Middle East.

Survey Include (10 Dealers DC) and (7 Dealers Mercedes)

. Upload receive data for CSI/SSI survey as well as for their on line

website and had been in-charge for automization of CSI/SSI reports

. Mapped and analyzed Sales and Marketing operations, business models,

and goals according to specific data gathering techniques in order to

provide proactive solutions for dealing with customers using tools,

processes, and reports

. Coordinated for delivering quality analysis of Field Sales & Marketing

support services solutions and operations

. Report of results/workload on regular basis

Jacobsons, Dubai, UAE

> Project Details

Duration: January 2004 -December 2004

Role: Database Executive

Environment: Ms Access, SQL Server2000

> Project Scope & Responsibilities

. Responsible for Designing, creating and testing database. Making

reports and queries for the projects

. Modified existing databases and database management systems or direct

programmers and analysts to make changes. Train users and answer

questions

. Responsible for feature enhancement and performance tuning in both SQL

Server and MS Access 2000 environments

. Test programs or databases, correct errors and make necessary

modifications

. Develop data model describing data elements and how they are used,

following procedures

. In-charge of the data for their CSI/SSI surveys conducted in Call

Centre

. Receive data from the dealers of DC online. Coordinate with the India

office for data cleaning and enhancement

. Analyze and check the quality of database and the various other

criteria for improving the performance & taking In-charge as DBA

during his absence

. Worked for their sister concern Encomium, specializing in CRM

projects

Soware Software Solution

> Project Details

Duration: May 2002 -August 2003

Role: Programmer

Environment: Visual Basic, Ms Access

> Project Scope & Responsibilities

. Responsible for working on retail managements system

. Prepared and tested code for purchase processing and taxation module

. Carefully analysis client requirements with the developed standards

. Creating program for Storing, analyzing and displaying of Sales

[D] Training & Education

. Masters in Computer Management -Pune University with First Class

OCA Certified, (OCP) 9.2.0.1.0 certification Program

. GNIIT Diploma in Programming

. Training in Finance Module JD Edwards (AS400 Platform June, 2007 to

July 2007)

Contact this candidate