Jancarlo Tavarez available

Jancarlo Tavarez

SAP ABAP Consultant

available
Profileimage by Jancarlo Tavarez SAP ABAP Consultant from
  • Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: not provided
  • Languages: English (first language) | Spanish (first language)
  • Last update: 01.02.2019
KEYWORDS
SKILLS
PROFESSIONAL EXPERIENCE

Ogilvy & Mather (October 2014 – January 2018)?
Role: SAP SD Analyst?
Environment: SAP ECC 6.0

Ogilvy & Mather is a New York City-based advertising, marketing and public relations agency. It is part of the WPP Group, which is by revenue one of the largest marketing and communications companies in the world.?
?
Responsibilities:
  • Enhancement of reports for SD and PS: Queries and ALV Reports for Projects and Jobs.
  • Used of Queries for conversion projects purposes such as: Inquiries, Quotations, Debit Memo
    Request, Sales Conditions, Rate Cards.
  • Used of LSMW and BDC to update DMRs, Sales Conditions and Rate Cards.
  • Involved in 3 global conversion projects due to the acquisition of 3 new companies and the roll out of the SAP Implementation for them.
  • The creation of business processes for the business units within Ogilvy and subsidiaries.
  • Used of SAP Debugger and troubleshooting issues in the system like iDoc failures reprocessing,
    Job scheduling and maintenance and report performances.
  • Extraction of data from HR tables like PA0008, PA0001, PA0002 to analyze employee data and create access to the interfaces created and Used of transaction PA20.?
Arias Motors (October 2013 – January 2014)?
Project: SAP ECC 6.0 System implementation
Role: SAP ABAP Consultant.?
Environment: SAP ECC 6.0

Arias Motors is one of the leading distributors of vehicle parts in Dominican Republic.? ?
Responsibilities:
  • Developed reports for FI module such as: ALV Reports for accounts receivable and accounts payable.
  • Added more functions to the sales orders Web Service. Improving sales orders creation BAPI to accept sales orders from a new document type.
  • Adding functionalities to customs ABAP programs.?
Anheuser-Busch InBev (AB InBev) (June 2013 – October 2013)?
Project: SIEBEL to SAP Interface redesign
SAP ECC 6.0 and Oracle Siebel CRM.

InBev is the world's largest brewer company had operations in over 30 countries including DR and sales in over 130 countries. ?
?
Responsibilities:
  • Created a transaction to upload Siebel CRM sales flat files to a custom SAP table.
  • Created a transaction (Dynpro) to process manually files uploaded from Siebel. The process involved using SD, MM and FI BAPIs within SAP system. Reprocessing for erroneous files and assigning to responsible user by email for further treatment.
  • Developed an ALV report for the Interface status so the user would be able to see the status of the data processing.
  • Involved in unit tests, integral tests, production environment, documentation and support of the interface.
Anheuser-Busch InBev (AB InBev) (November 2012 – March 2013)?

Responsibilities:

• Involved in creating a workflow recursive approval for purchase requisition, orders and contracts. Transactions: ME21N, ME51N and ME31K.?
Anheuser-Busch InBev (AB InBev) (May 2012 – November 2012)?
Project: Role: Environment:
Responsibilities:
SAP BW 3.5 Implementation.?SAP ABAP / BW Consultant.?SAP BW 3.5
  • Involved in creating customs extractors to load the data from SAP R3 server to SAP BW Server. Creating and managing ODS, Infosets, MultiProviders, Conversion rules, InfoCubes and modeling data for BEx Querys requirements.
  • Configured a Process Chain to load data dynamically to InfoCubes. Creating Querys (SAP BEx Analyzer and Query Designer) and Web Dashboard using SAP BEx, HTML and CSS3.


Marti LPG Group (September 2011 – May 2012)?

Marti LPG Group is one of the leading Gas and Oil Groups in Dominican Republic. ? ?
Responsibilities:
  • Involved in developing a custom Interface (Dynpro) for processing daily sales orders, deliveries, invoices and accounting entries from external system to SAP. The interface uploads data to custom table in SAP to process it through transactions: VA01, VL01N, VF01 and FB04 using RFC, BAPIs, Function Modules and Web Services. (Modules SD, MM and FI)
  • Developed an Interface to transfer the legacy system pre-paid tickets sales files to SAP and process it. Creating sales orders, invoices and accounting entries. Using: BAPIs, User-Exits and Dynpro.
  • Developed daily sales report showing processed sales orders in the interface, commission of each daily sale for every salesman and Bank reconciliation report. (ALV, SD, MM and FI).
  • Developed a SAP User Exit which changes the vendor position in accounting document for each sales order number processed in the interface for automatic compensation of open items. SDVFX008.
  • Developed a SAP User Exit for batch number creation in Transaction MIGO. Using the same purchase order number to create the batch if not batch number was found. SAPLV01Z.
  • SD Routine to transfer sales order number to accounting document. Using transaction VOFM. ?

Arkia Distributor (January 2011 – September 2011)?
Arkia Distributor is exclusive distributor of PARMALAT Milk among others beverages in Dominican Republic.?
?
Responsibilities:
  • Developed a Bank reconciliation report to capture the Ending Bank Balance, Unadjusted G/L Balance, General Open items and Returned open items from G/L, Open items from Bank, Open items from Checks IS-CD and difference between Bank and G/L.
  • Developed a Balance letter report to send to customer the actual balance. (SAPScript)
  • Developed an Interface Monitor for sales order process status. (Dynpro)? ?
REFERENCES
Guillermo B. De Jesus Castillo
Quality Data Analyst at Santander
June 20, 2014, Jancarlos worked with Guillermo B. in the same group
I had the opportunity to work for a long time with Jean CarlosTavarez and undoubtedly is a great professional with a broaddomain in your area and huge sense of commitment, serious,hardworking and intelligent, a huge asset to any company.

Luis Dauri Polanco
SAP-ABAP/MM Consultant
July 14, 2014, Jancarlos worked with Luis Dauri in the same group
An excellent professional, well trained!

Victor Valdez
Senior SAP ABAP Consultant at DTS, Higher Results
July 19, 2012, Jancarlos worked with Victor in the same group
An excellent professional
GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge