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)