Back Office Sales

Anshu Baranwal

*+ years of experience in EPICOR (Epicor Connected Retailer 6.2, Epicor Sales Audit 5.0, Epicor CRM 6.1, Enterprise Back office 5.0, Epicor settlement 4.7.11 and Epicor POS). Knowledgeable with hands on experience on problem management. Instrumental in new store setup, POS upgrade, rollout /encryption keys, MPOS rollout and implementing change requests and enhancements for inventory movements, system compatible scripts etc.

Achievements:

Got POB for Inventory Management

University topper in BE from Nagpur University

Type of projects:

Point of Sale and Epicor Back

Office modules

Application Support Project

Development and enhancement projects

Business Domains worked on:

• Retail Support

Skill Set:

Epicor Connected Retailer, Epicor Sales Audit, Epicor CRM, Epicor Enterprise Back office, Epicor settlement and Epicor POS

PL SQL and Oracle SQL database

Dos Batch, VB Script

Operating System: Linux, Windows

Experience

Experienced and knowledgeable on the flow for business-critical data (POS transactions and inventory movement to reorder cycles, pricing, promotional campaigns etc.) in EPICOR Connected retailer Suite.

Knowledgeable on the sales audit processing which includes polling, translation of encrypted data, editing, auditing, day-end and period-end processing. Developed Sales audit monitoring and validation scripts, which prevents delay in posting FDMS data to bank for Credit settlement after auditing.

Good knowledgeable on the process flow for online and offline customer data conciliation and processing to Central CRM database.

Good analytical knowledge on Problem management to reduce interface connection breakdowns, developed Data validation scripts on various interfaces to resolve the data leakage issues (inventory movement to reorder cycles, pricing, promotional, Employee details data etc.).

Applied code fixes for various SQL scripts (Flat file generation from database) to fetch compatible data with the change made in the system.

Experienced in Technician coordination and have instrumental knowledge on new store setup.

Worked on the POS upgrade (Digi POS to Sure POS) activity and developed various tools (Scripts for data backup and restoration) to boost up the upgrade process with Minimum down time for the stores.

Development & support experience using .NET technology. Expert in designing and creating PL/SQL code (Packages, Procedures, Functions and Triggers) that efficiently implement business functionalities.

Worked on MPOS rollout, Colehaan Logo change rollout, POSXML & DCNS rollout and PCI encryption keys rollout.

Assignments Completed

ColeHaan, USA (IGATE): The overall level 2 support was handled in supporting Epicor POS, Batch Jobs, application interfaces monitoring and processing. We also handle all 119 retail stores and their applications. Designed dashboard on retail issues and monitoring status

Current Assignments:

Arkemedise (Demorgia Consulting Services Pvt Ltd): This project is meant to design websites for conducting exams. The baseline of the project is database. These websites will be used in schools, colleges and competitive entrance exams.

Role:

In this project I worked on MySQL platform in which I created databases for candidate and their respective organization.

I developed various SQL scripts to fetch required data with merging of candidate and organization databases.

I was also involved maintaining records of candidates who would be eligible for next level based on pervious exam results.

Contact this candidate