Page * of *

Amit Tamrakar

Cell: +1-506-***-****

Email: ada3to@r.postjobfree.com

https://www.linkedin.com/in/amittamrakar

Industry Experience

• Over 23 years of successive experience in development, customization, support and project management, includes 14 years in JD Edwards, 3 years in Oracle EBS, 6 years in Orion and 5 years in other technologies.

• Successfully developed and integrated technologies with ERPs like J.D. Edwards, Jeeves and Orion.

• Performed installations and developed custom applications, reports, NER business functions, end-user interfaces, and third-party integrations for data conversion and document production.

• Worked with customers for project planning, requirement gathering, develop business solutions, customization and modifications, implementations, transition and post-go-live support activities.

• Extensive international experience, including North America, Singapore, India, United Arab Emirates and many other Gulf countries, bringing technology experience from different continents. Training and Certifications

Project Management Professional (PMI-PMP)

ITIL Foundations

J.D. Edwards Development Tools & Enterprise Report Writing

IBM InfoSphere DataStage

Jeeves ERP Systems

Crystal Reports XI R2: Fundamentals of Report Design Experience

Application Architect, Irving Oil, New Brunswick, Canada August 2013 to November 2019 Application Architect (March 2015 – November 2019)

• Design and implement in-house information systems and networked software architectures from a tactical and operations point of view that support core organizational functions and assure their high availability.

• Gain organizational commitment for all enterprise systems and software plans, as well as evaluate and select all technologies required to complete those plans.

• Provide technical leadership across operational team, from the project planning level decision making down to the tactical and operations level.

• Worked on the customizations of Workday implementation and data migration from Oracle EBS. Training completed on Workday Report Writer, Integration System Fundamentals, Simple Integrations & Connectors.

• Performed annual archive and purchase of historical data from JDE.

• Talend tool used for data conversions and file transfers of invoices to various customers.

• COUPA integrations for Procurement, Contracting and Invoicing modules for 2 of our customers GlenCore and McCain for Propane, Natural Gas and Aviation Fuels using custom cXML format.

• Architecture detailed design documents for multiple product implementations like Allegro (ETRM)

• Integration of JDE with various systems like Oracle EBS, SalesForce.com, DTN, EDI, TMW. JDE Technical Lead (August 2013 – February 2015)

• Identify gaps in JDE and work towards optimizing and improving JDE performance

• Fix technical issues and small-scale development supporting expansion of business

• Gather and implement business requirements in JDE and/or sort out business pain points

• Manage or support JDE projects outsourced to vendors like IBM and Deloitte

• Reduced cost of storing old JDE source data by 75%

• Executed annual DR testing as part of maintenance and high availability of the application

• Completed successfully JDE application hosting to a new data center with a new architecture design

• Enabled creation and storage of all invoices generated in JDE in PDF format and made available on the web

• Created a new XML IATA format of invoices and migrated airlines customers to the new format Amit Tamrakar

Page 2 of 5

Senior ERP Consultant, Cartels Consulting Services, Ontario, Canada October 2009 to July 2013 Morneau Shepell, Toronto (February 2013 – July 2013)

• Developed customized applications, HR and financial reports in J.D. Edwards 9.1

• Created new process to merge PDFs in JDE with different formats from service management module.

• Created multiple BI publisher templates for service invoices.

• Taleo integration to JDE for new hires, automating their system user and access creation. Tenix Solutions, Australia (September 2012 – January 2013) New customized reports were development for Tenix Solutions, Australia in J.D. Edwards 9.0

Created new custom reports in inventory, finance, general ledger, sales.

Created new data conversion reports to move their business unit, cost codes and jobs. SBM Site Services, CA (January 2012 – August 2012) New customized reports development was done for SBM Site Services, CA in J.D. Edwards 9.0

Created new custom reports in payroll management, employee, salary, seniority, status change etc.

Extensively worked on BI Publisher for their purchase order printing and emailing formatted in word.

Created new financial reports like Income Statements, Trial Balance and Trend reports. Silgan Containers, CA (May 2011 – December 2011)

A number of reports were developed for Silgan Containers, CA in J.D. Edwards 9.0

New custom reports were created in Manufacturing, Purchasing and Inventory modules.

Other reports consist of finished goods, material issue, product performance and spare parts related. CB Richard Ellis, CA (May 2010 – April 2011)

Additional custom JDE reports and crystal reports development in J. D. Edwards 8.11

Crystal Reports development for various clients of CBRE

Custom application, NER business functions and JDE reports development for CBRE clients. Monrovia, CA (October 2009 – April 2010)

Created a custom application in Sales module of J.D. Edwards 8.11

Requirement study of the new custom application of Proration and Leveling.

Custom application development and NER business functions of Sales Proration and Leveling.

Created a new logic of Freight calculation which was incorporated in estimation, order entry, invoice printing, and sales update.

Support and development of other JDE reports continued later after the go-live. Senior Technical Consultant, Profit Concepts International, California, USA October 2004 to September 2009 CB Richard Ellis, CA (April 2009 – September 2009) Crystal Reports XI R2 installation, configuration, user training and reports development for J. D. Edwards 8.11

Crystal Reports and Crystal Enterprise Installation and Configuration on 2 clustered servers

User training on Crystal Reports for JD Edwards

Crystal Reports development for various clients of CBRE

Custom application, NER and JDE reports development for CBRE clients. Sizzler, CA (September 2008 – March 2009)

The conversion from their proprietary system to J.D. Edwards 8.11 was done for Sizzler, CA.

Did conversion of financial accounts, fixed assets and address book master

Customized the generation of bank payment file and auto bank statement Amit Tamrakar

Page 3 of 5

Integrated their online invoicing system with JD Edwards

User training on JD Edwards reports

Custom JD Edwards report development

ACM Technologies, CA (May 2008 – August 2008)

Created a custom application in CRM module of J. D. Edwards 8.11 A CRM Sales Summary tool is being created for the Sales People who will have a dashboard kind of application to monitor, manage, and forecast sales by account executives, customer and products.

Requirement study for the new custom application

Create a prototype and estimate the effort required for the development

Custom application development and NER business functions within a not-to-exceed time and budget. BakBone Software, CA (September 2006 – September 2009) The upgrade of J. D. Edwards from XE to 8.11 was done for BakBone, CA. After going live with their US office, they wanted to move their UK & Japan office from their proprietary software to JD Edwards. It required modifying existing applications & creating new reports required for both the offices.

Customized Sales order application on power forms for their new requirement

Developed reports for US, UK, France & Japan including reports in Japanese & French & continued support.

Designed a lot of financial reports from accounts receivable, accounts payable, fixed assets and job cost.

Integrated JD Edwards with salesforce.com and Softrax Software Works Inc, SC (January 2006 – December 2007) A new application Alcohol Loss and Prevention System (ALPS) was developed for Software Works, SC. It compares units of product dispensed against units of product recorded as sold along with any accounted for losses or gains to accurately report both quantities are profit loss & can be analyzed with loss graphical analysis.

Single handedly studied, designed, developed and modified the complete software package

Inventory Audit and Audit Validation can also be done using ALPS PDA on a handheld with a scanner

Both ALPS and ALPS PDA are developed using Visual Basic .NET 2003 and SQL Server 2005 Other Projects (January 2006 – August 2006)

The upgrade of J. D. Edwards from XE to 8.11 was done for National Cement, CA. The upgrade required a lot of new report development or customizing the existing reports.

Customized following areas of reports: Accounts Payable, Sales Tax, Shipments, Haul Build & Print

Redesigned the order to cash process

The upgrade of J. D. Edwards from XE to 8.11 was done for Suzuki Motors, CA. The upgrade required making sure all the applications and reports that were customized in XE were running with all new SAR applied. A lot of reports had version over-rides and that required creating new versions from 8.11 and then updating with the customization that was done on the same. The changes included a wide range of reports and applications. The upgrade of J. D. Edwards from OneWorld to 8.10 was done for Memorex, CA. The upgrade required a lot of new application development and report development. Customized the application for processing Temporary Price Reduction (TPR) and Mail-in Rebate (MIR). The entire process was broken down into the following steps:

Capture TPR / Rebate Request, Create Credit / Purchase Order

Email Notifications & Approvals, Update Profit Planner

Claim / Invoice Receipt & Approval / Denial Payment, Reporting Farmer Brothers Coffee, CA (January 2005 – December 2005) The enhancement of J. D. Edwards XE was done for Farmer Brothers, CA. The CRS Mobile application is a fully customized mobile application developed to meet the requirements set forth by Farmer Brothers to mobilize Customer Route Sales. Mobile users conduct daily business while disconnected from the Enterprise One application and when connected, propagate those changes to Enterprise One.

Customized the end of day process for each Route Sales Person

Engineered the messaging system among branches, divisions, districts, persons or general messages Amit Tamrakar

Page 4 of 5

Designed batch processes for sales update, activity scheduling and message distribution

Programmed equipment transfer, inventory count, route master, and vehicle maintenance

Defined application, users and rules for tablet PC data synchronization using Synchrologic Enterprise Applications Manager, 3i Infotech, Dubai, UAE October 1998 to September 2004 Pliva Inc, NJ (August 2004 – December 2004)

The enhancement of Orion was done for Pliva Inc, NJ. Integrated with various modules like Sales Order, Inventory, Warehouse management. Orion was integrated with shipping labels and palletization.

Project Planning & Budgeting, managing project scope and timelines

Communication and Executive Reporting

Customized the picking, packing and palletizing transaction forms

Created reports for barcode label printing, picking sheet, pallet number barcodes

Customized forms developed to interface with the PLC conveyor belt Bookazine Inc, NJ (March 2004 – July 2004)

The enhancement of Orion was done for Bookazine Inc, NJ. Integrated with various modules like Purchase, Inventory, Warehouse management.

Customized forms for put away request, reservations and suggestions

Customized forms for replenishment requests and suggestions

Customized forms for Work Order creation and processing

Customized form developed to interface with the PLC conveyor belt to divert the cartons for put away. D. A. Fehr, PA (November 2003 – February 2004)

The customization of Orion was done for D. A. Fehr, PA. It's a web-based solution that would enable the automation of getting the rate quotations from various trucking carriers in United States and Canada.

Gathering information relating to current sales process, shipments, HR & Payroll process

Customizing the sales order form, sales order update form and sales invoice form

Created reports for sales order printing and sales invoice printing

New form was required to interface with the websites of various carriers to fetch the rate quotes AccuMed Inc, NJ (August 2003 – February 2004)

The customization of Orion was done for AccuMed, NJ. It’s a handheld-based solution that enables the automation of receiving, picking and shipping material in the warehouse and manufacturing location.

Performed various management tasks (like project plan, cost calculations, project budgets & client meetings)

Developed handheld transactions for receiving, put-away, batch orders, pack orders and shipping orders

Customized report printing for order lists and sales invoice in crystal reports

Created all the stored procedures, functions and views required for the handheld application Achievements: Generated confidence in the customer who later replaced their Oracle Apps 11i with ERP Orion. Safe Store, Singapore (January 2003 – July 2003)

The customization of Orion Retail was done for Safe Store, Singapore. Integrated with various modules like Sales, Purchase, Inventory, CIS, GL, AR/AP and Loyalty

Project Planning, Budgeting, Scope & timelines

Systems study their existing system, propose them new system to overcome their existing problems

Made prototypes for the customizations and mapping for the new system

Managed the development of customization based in India Orion Tools (August 2002 – December 2002)

Product management of Orion Tools that were earlier known as Zeus, was now broken down into 2 different tools, because of its distinct usage. Administrator allows you to customize and map your business processes, create user groups and users, and assign privileges. Configurator allows you to set up transaction flow for any Orion modules. Customizer was added to customize Orion forms without the need to know Oracle Forms. Apart from this there was ICICI Tools that was created to help implementers on-site. Amit Tamrakar

Page 5 of 5

GlaxoSmithKline (GSK), Dubai (January 2002 – July 2002) The customization of Crossroads was done for GlaxoSmithKline, Dubai. It has been completely integrated and implemented with Orion.

Managing Project scope, timelines, developers & their timesheets billable to client

System design, mapping of the system, and functional testing

Co-ordination of the project with the client during implementation Point of Sales (March 2000 – December 2001)

Orion Point of Sales module was customized for Jackys Group of Companies, Healthline Middle East (HME) and Ajmal Perfumes all based in Dubai, UAE. POS interface has the ability to handle different pricing & bundling requirements depending upon the customer type (loyalty coupon’s), or locations. It has the ability to provide an online status of inventory, because of its online interface with the back-office inventory module, & prevents stock out situations in the event of unexpected peaks in sale volume.

Had single handedly studied, designed and customized the whole module and later managed the product. Implementation of ERP Orion (October 1998 – February 2000) The implementation of Orion was carried out in various client sites in Dubai, Bahrain, Kuwait & Saudi Arabia. The ERP Orion is a product of 3i Infotech developed on Developer 2000 (Forms 4.5 and Reports 2.5) and Oracle as database. These reports were part of up gradation from their old system to the new system.

Developed and customized reports in Crystal Reports for various modules such as Sales & Distribution, Purchasing, Manufacturing, and Human Resource & Payroll.

Later all these custom reports were consolidated and implemented as part of the ERP to all its customers. Information Technology Consultant, Cartels Consulting Services, India January 1996 to September 1998 Projects (October 1996 – September 1998)

Delhi Tent and Decorators had 4 warehouses, 3 banquet halls and several sites across Delhi, which made them very difficult to locate the number of items kept at various places. Mr. Indispensable automates the process of stock movement, inventory & ledger preparation.

Analyzed, created database, designed screens and developed reports. Doctors Diary was developed keeping in mind that any Doctor who runs their individual clinics to maintain the medical profiles of their patients and get the desired reports can use it. This project was developed for two different doctors, one was an ENT specialist and the other one was an Eye specialist.

Had Single handedly studied, designed and developed the whole application. Inventory record and billing was developed for Crossroads Fast Food Joint, India. Since it was a commercial project, changes were a part of the system.

Had single handedly studied, developed, implemented, enhanced and maintained this project. Education

Master of Business Administration (Operations Management) Indira Gandhi National Open University, India

Bachelor of Engineering (Computer Technology) Nagpur University, India

Diploma in Advanced Computing (DAC) Center for Development of Advanced Computing, India Reference available upon request.

Contact this candidate