Pawan Alreja

ERP Senior Analyst/Solution Architect

Email ID: adbz4g@r.postjobfree.com Contact: +91-983*******

Professional Summary and Key Accomplishments

Experience Summary:

Total experience: 10 years

Total JDE/IT experience: 7 years

Previous Companies – KPIT Technologies (now BirlaSoft Technologies) and Larsen & Toubro InfoTech

Current Organization – Cyret Technologies (I) Pvt Ltd

Primary Skills:

Over 10 years of total experience in the analysis, design, development of business applications, customization, support and upgrade.

About 7 years of rich functional experience in design and development in JD Edwards Enterprise One Finance, Procurement and Inventory modules. (ERP 8.12, ERP 9.0, ERP 9.1, ERP 9.2)

Expertise in JD Edwards Enterprise One application financial modules i.e. Accounts Payable, Accounts Receivable, General Ledger and Fixed Assets. Brief exposure to Real Estate and Expense Re-imbursement modules.

Exposure of working on Implementation, Enhancement and Support projects.

Good Knowledge about the Interoperability Standards of JD Edwards Enterprise One including EDI, Z-Files.

Skill Type - Team Lead, JDE Sr. Finance Functional Consultant and Business Analyst.

Traveled extensively and understands overseas business culture. Possess good communication, interpersonal and team leading skills.

Visa Status:

Holding Valid H1B and B1/B2

Holding Valid Australia Business Visa

Previously held Schengen Residence Permit Visa

Functional Expertise

Skill Type

Project Finance Lead, Solution Architect, JDE Functional Consultant

Application Expertise

JDE 8.12, JDE 9.0, JDE E 9.1 and JDE 9.2

Module Expertise

Finance, Sales, Procurement, Inventory & Real Estate

Industry Expertise

Consumer Business, Energy and Oil, Manufacturing, Real Estate

Education

Semi Qualified as CA Inter

November ’2008 Institute of Chartered Accountants of India

Bachelor’s Degree in Commerce

March’ 2006, Mumbai University, INDIA

Projects Summary

Company Name

Project Details

Role

From Date

To Date

Accolade Wines

Suuport, Enhancement

JDE Tower Lead

Jul 2019

Till Date

Baniyas Investment and Development LLC, UAE

Implementation, Post Go-Live Support

Finance Lead

Jul 2018

June 2019

Nerium International, USA

Implementation

Finance Lead

Aug 2017

Feb 2018

Weatherford, India

Support, Enhancement

Sr Finance Consultant

Apr 2016

Jul 2017

Otis Elevator, Spain

Enhancements, Customizations

Sr Finance Consultant

Oct 2015

Mar 2016

DET-Tronics, USA

Implementation

Finance Lead

Mar 2015

Sep 2015

Nynas AB, Sweden

Enhancements

Sr Finance Consultant

Nov 2014

Feb 2015

Nynas AB, India

Support, Enhancements

Finance Consultant

Oct 2012

Oct 2014

Project Details

Company Name

Accolade Wines, Australia & India

Jul 2019 till Present

Brief about the Project/Company

Accolade Wines is a major global wine business with headquarters in South Australia. It has been owned by The Carlyle Group, an American private equity company, since 2018.

Accolade has more than 1700 employees around the world, with operations in North America, the United Kingdom, Ireland, mainland Europe, South Africa, Australia, New Zealand and Asia.

Role

Finance Lead

Responsibilities

Since the business was going through an internal organization structural changes, the support and enhancement of the onging JD Eward application is outsourced to our company.

Was responsible to gather and capture the business intent and the onfiguration of JDE along with the integration with around 20 other applications like Hubble (reporting tool), Datacap (Voucher Scanning process), ShiftPOS (sales order integration), Transform, etc.

Understand and absorb and account for the configuration of system and prepare a Service Design Document that would then be used by the offshore team for refernce.

Plan and schedule for the topics to be covered for knowledge transition that would then be the base for taking over the support going forward.

Suggested process imporvements like adopting the EFT payment process and to use Expense Management module for tracking employee expenses.

Actively participated and working on the ongoing current enhancements.

Maintaining a Master Tracker system to log the challenges and track its progress.

Coordinating and handling a team of 7 for the ongoing offshore support.

Project Details

Company Name

Baniyas Investment and Development LLC, UAE

Jul 2018 till Jun 2019

Brief about the Project/Company

BIDC, a majority owned subsidiary of the Baniyas Sports and Cultural Club, has been an active contributor to the dynamic transformation of the area of Baniyas and Abu Dhabi in UAE, moving forward with modernity without ever forgetting the emirate’s rich culture and heritage. As the investment and development arm of the Baniyas Sports and Cultural Club, the company’s core competencies are in the areas of investment, development and management of real estate projects.

Role

Finance Lead

Responsibilities

Business Analysis w.r.t understanding and acquiring in-depth business charter along with generic real estate industry processes and activities in detail.

Conducting AS-IS work-shops with the concerned stakeholders.

Identifying the business pain areas.

Charting the TO-BE process flow.

Performing and documenting the GAP analysis.

Legacy system data validation and leading the data migration strategy.

Configuration and set up activities.

Creation of Test Scripts and User Manuals for training purpose.

Maintaining a Master Tracker system to log the challenges and track its progress.

Conducting various Pilot conferences with business head honchos discussing various strategies, challenges and project status.

Assisted JDE real estate peer in capturing the business requirements and presenting the solutions. Gathered generic and fundamental overview of JDE real estate module.

Coordinating and handling a team of 5 for the post go live offshore support.

Project Details

Company Name

Nerium International, USA

Aug 2017 – Feb 2018

Brief about the Project/Company

Headquartered in Addison, Texas, Nerium International is a global relationship marketing company offering breakthrough, proprietary age-fighting skincare and wellness products using Multilevel Marketing Model. Validated by years of scientific research, their product line incorporates exclusive ingredients designed and proven to deliver visible results. The demand for their products, coupled with their tools, support and unrivaled expertise enables Nerium to offer an incomparable opportunity to build a successful business.

Role

Finance Lead

Responsibilities

Understanding the industry based multi-level marketing model to get clarification w.r.t management accounting and reporting.

Conducting and documenting the AS-IS processes and chartering the TO-BE processes.

Assisting users to convert legacy COA to JDE COA.

Actively participated in designing and developing the integration of POS (Exigo and Magento) into JDE. [Using EDI 850/860 Order Creation/Order Change, F47011/F47012, and then customizing the R47011 UBE for handling the integration.]

Also assisted in cross module integration of 3PL Inventory Interfaces into JDE using EDI processes (852) using (F47121/F47122) and Z Process R47121.

Assisted in mapping UDC’s that were used in the integration of Exigo and Magento Customer data into JDE using EDI processes using

oCustomer Master Upload in JDE (F0101Z2, F03012Z2) and Z Process (R01010Z, R03010Z)

oSupplier Master Upload in JDE (F0101Z2, F0401Z1) and Z processes (R01010Z, R04010Z)

Wrote the Functional Solution Design document to customize and develop Batch Applications and Financial Reports as per user requirement e.g.

oCheck Print using BI Publisher

oBank File Generation (XML Format) using BI Publisher

oPositive Pay File

Worked with Avalara team for integration with JDE with regards to tax rate update in customer/vendor master tables.

Coordinate Testing and Delivery of Solutions with the client functional teams.

Project Details

Company Name

Weatherford, India

Apr 2016 – Jul 2017

Brief about the Project/Company

Weatherford is one of the world's largest multinational oil and natural gas service companies. The company provides products and services for drilling, evaluation, completion, production and intervention of oil and natural gas wells, along with pipeline construction and commissioning. Headquartered in Switzerland, Weatherford operates in more than 100 countries across the globe and employs more than 35,000 people (2016). Weatherford International plc (NYSE: WFT) has been selected for inclusion in the Euronext Vigeo World 120 index, which is composed of the 120 most advanced companies in the European, North American and Asia Pacific Regions.

Role

Sr Finance Consultant

Responsibilities

Was engaged with off shore support for finance modules for EU, APAC and MENA region.

Resolving integrities with regards to AR-GL and AP-GL to ensure smooth month end.

Assisting users with account reconciliation, RNV integrity and issues relating to alternate payments.

Participated in Kazakhstan reporting enhancement project.

Worked closely with Kazakhstan business stakeholders to understand the reporting requirements.

Documented the business reporting requirements and provided knowledge transfer of these requirements to ETL Informatica team and worked closely with them to design and generate reports for effective business analysis.

Project Details

Company Name

Otis Elevator, Spain

Oct 2015 – Mar 2016

Brief about the Project/Company

The Otis Elevator Company is the world's largest manufacturer of vertical transportation systems, principally focusing on elevators, moving walkaways and escalators. The company pioneered the development of the "safety elevator", invented by Otis in 1852, which used a special mechanism to lock the elevator car in place should the hoisting ropes fail.

Role

Sr Finance Consultant

Responsibilities

The project was in a phase wherein for certain business process customizations were suggested and these solutions were required to be presented to get the sign offs for proceeding with the same.

Since I held Schengen visa and the responsible consultant had backed out from traveling citing personal reasons, my role was to chip in, understand the business requirement and the customization mapped.

It was all related to work-order processing for job costing and certain financial processes with regards to draft processing.

One other challenge was communication, as the business users only communicated in Spanish. Had to communicate through translator during the whole process of presenting the customizations and answering to the business queries.

Successfully presented the solutions and received the sign offs.

From offshore, also provided extended support in preparing UPK’s and manuals for the custom processes.

Project Details

Company Name

DET-Tronics, USA

Mar 2015 – Sep 2015

Brief about the Project/Company

It is the global leader in fire-and gas-safety systems, providing premium flame- and gas-detection and hazard-mitigation systems for high-risk processes and industrial operations. The company designs, builds, tests and commissions SIL 2 Capable flame- and gas-safety products that range from conventional panels to fault-tolerant, addressable systems that are globally certified. It is a part of UTC Climate, Controls & Security, a unit of United Technologies Corp., a leading provider to the aerospace and building systems industries worldwide.

Role

Finance Lead

Responsibilities

Since this was US based project, made sure that I updated my skill sets with regards to US GAAP and SOX Compliance procedures.

Read all the specific US based standard processes (Positive Pay file, 1099 reporting, etc.) from Oracle white papers which was helpful during the AS-IS and TO-BE phase.

Handled core stake-holders team of 12 super users across AP, GL, AR and FA modules.

Worked on the JDE – Vertex integration with regards to tax rate area mapping for customer/vendor master.

Assisted in designing temp reports for uploading mass data for master and transaction tables for AR, AP and Inventory modules.

Being a manufacturing client, worked closely with my JDE manufacturing peer for DMAAI mapping and accounting impacts for the manufacturing process within JDE.

Led the offshore team and assisted them in configuring the ‘pay when paid’ accounts payable JDE process.

Project Details

Client Name

Nynas AB, Sweden

Nov 2014 – Feb 2015

Brief about the Project

Nynas AB is a Swedish manufacturer of specialty naphthenic oils and bitumen products. Founded in 1928 as a national oil company with a traditional range of products, the company today also supplies specialist products and niche markets. The company has sales offices in more than thirty countries and a global distribution network with sixty storage depots.

Role

Sr Finance Consultant

Responsibilities

Nynas AB had decided to merge and centralize its operation for Nordic region. Initially it had offices and operated in Norway, Denmark, Finland, Sweden and Estonia.

To cover up the indirect overheads and effective cost management, Nynas AB decided to centralize its operation for Nordic region from the head office in Sweden.

It was a kind of roll out wherein all the locations were already live in JDE but had to be consolidated in Sweden operations.

Actively participated and strategized the consolidation approach.

Planned the cut off activities and stream lined the VAT processes based on the necessary changes suggested by tax consultant.

Migrated the existing customers and vendors and their respective balances into the consolidated company based on the cut off strategy.

Provided training to the users with regards to the new data input process to be followed after the consolidation of operations.

Provided post go-live onsite month end support.

Project Details

Client Name

Nynas AB, India

Oct 2012 – Oct 2014

Brief about the Project

Nynas AB with operations in more than thirty countries was live on JDE 8.12. It had started the process of upgrading to JDE 9.0 release one by one for all its locations. Having operations in Latin American countries, African continent, Japan, Korea, EU, Australia and Singapore, they were also using JDE localization features.

Role

Finance Consultant

Responsibilities

Was responsible for supporting incidents for financial modules AR, AP, GL, FA and expense reimbursement.

Handled incidents with regards to various configuration like the missing AAI/DMAAI set up, payment terms, tax rate area set ups, setting up employee profile or approver profile in expense reimbursement modules, etc.

Performed RCA for repetitive incidents and provided permanent fix for the same.

Got an exposure of writing and executing SQL queries (update as well as delete).

Worked on enhancement like the EU SEPA process wherein assisted the finance lead in writing the FSD for the xml file generation and testing the SEPA process.

Capable of handling the month end support and worked in different time zones in rotation.

Had exposure to grasp knowledge of the localization process while handling the support incidents.

Contact this candidate