Technical Support Customer Service

PAPIYA MAJUMDER

**** ***** ****,

Southlake, TX 76092

*********@*****.***

Technical Skills

Ksh on Linux

C/Pro C on Unix (AIX, SunOS/Solaris, Sco Unix)

Oracle 10g, Sybase 11, SQL Server, DISAM

BIRT (Actuate 9)

C#, ASP .NET 2.0, PHP

SAP FI (technical), S.W.I.F.T

Experience in a nutshell

Ksh on Linux, 7 months

C on Unix (AIX 4.3.2, 5.0, Solaris 2.2, SCO), 12+ years

Oracle 10g (Toad and OEM), 3+ years

proC, 3+ years

SQL, 3+ years, DISAM, 5+ years

C and Korn Shell, 8+ years

dbx, 8+ years

BIRT, 6 months

C#, ASP, ADO, 1+ years

PHP, 6 months

Tssutil version 3 release 2007.0508

Syncsort, DMExpress 3.3

Legal status

U.S. Citizen

Experience

Direct marketing industry

Epsilon (Allied Data Systems), Irving, TX (April 2010 thru Dec 2010)

The MMP group, Data Engineering division, working on Verizon/Frontier accounts

Main responsibility is to do flat-file processing for name/address data hygiene using FirstLogic ACE and merge-purge software.

Using C, ksh, tssutil. Syncsort on Linux

ksh to create a Poller which would read a control file and look for files and then run some jobs

ksh and c to generate a frequency report getting data from the flat-file bases and upto four fields specified per section

ksh, tssutil, Syncsort to extract data for clients

tssutil to analyze and generate count reports for customer

Supply Chain Industry

Dollar General, Nashville, TN (Jan 2009 thru Apr 2010)

The Warehouse Management System running at the nine Distribution Centers is an application developed by Catalyst International.

Using C, ProC on Aix 5.3.0.0, Oracle 10g, C-Screen, BIRT

Customizing Red Prairies' Labour Management System to be used in the DCs for performance analysis:

Made database changes to accommodate RP’s requirements.

Updated the transaction history logging demon.

DG uses the Real Time Solutions' Pick-to-light system and Vocollects voice-picking applications – modified the interfaces to provide RP with the necessary parameters

Modified multiple applications to correctly log to the transaction history tables

Picking changes

Standalone screen/functionality changes

TTI, Fort Worth, TX (Feb 2001 thru May 2006)

The warehouse Control System running at the warehouses was originally from RGTI (bought by Marc Global then by Red Prairie) and handled customer order picking to shipping. I was involved in information gathering through implementation.

Using C on Aix 5.2.0.0 DB: DISAM 6.0 Screens: FMS

InfoShip is a third-party software to rate-shop for shipping. Modified the current shipping procedure to communicate with the Blackbox application through xml messages to rate/ship/delete packages. Parse the returned message to load the current database. This involved some socket programming.

RF hand-held terminals are used for picking in the static area. Changed the existing picking procedure so that the operator moves in a serpentine way between the aisles to pick the orders regardless of the priority of them.

Auto-replenishment of fast-moving items to the carousel locations from the static areas when the stock would fall below a threshold.

Medicare Medicaid Information System

EDS, Plano, TX (May 2006 thru Sep 2008)

Using C, ProC on SunOS 5.2(Solaris 2.2), Korn shell, Oracle 10g

OR and KY state implementation (on contract)

The MAR subsystem provides a timely and meaningful reporting capability for Medicaid program activity thus helping in effective planning necessary for the decision-making process. The input data comes from claims processing as well as member, provider, financial etc. to generate financial, statistical and summary reports as required by federal regulation and the state.

* Analysis and mapping of the respective state data to the current MMIS system.

* Mapping and producing quarterly MSIS (Medicaid Statistical Information System) records for the different claim types (CLAIMIP Inpatient, CLAIMLT Long Term, CLAIMRX pharmacy and CLAIMOT other) and eligibles (ELIGIBLE).

* Documenting all the processes, jobs, codes, tables etc. for customer use. Create mapping files, e.g., between MSIS TOS and State COS, MSIS TOS and Claim files, claim types etc.

* Reports are run as Unix batch job which extracts the data and then creates the report using C code with the help of mrpf library to actually write the report. Generated new reports (e.g., OR Chargeback report) and modified existing annual CMS 264 (by program code) and 372 (waiver) reports to satisfy the state requirement.

* Validation of CMS 264 and 372 reports are required for certification by DHS. The data on the reports need to be validated (using SQL) against the MAR, DSS and AIM db.

Mail-order Pharmacy

Advance Paradigm Data Services (May 2000 thru Jan 2001)

C on Aix 4.3.2.0 Shell: Korn shell DB: Sybase 11, Embedded SQL

Retail Industry

Tandy Information Services, Fort Worth, TX (Dec 1996 thru March 1998)

C, SCO Release V. AQL: ACR's query language (SQL) on SQL server.

'Scrnedit' to design screens. C and Korn shell. RPT Report Writer tool by Unify Corp

Technical Support

IBM Global Services, Westlake, TX (March 1998 thru May 2000)

Technical support for Tivoli Storage Management (Formerly ADSM)

‘ADSM V3 Solution Development and Implementation’ certified

.NET development

Using C#, ASP, .NET 2.0, SQL Server 2005, Ajax, JavaScript

Windows applications

Restaurant menu selection and billing

Beauty shop service charges

Salesman commission calculation

Concert ticket sales by auditorium sections

Web applications

User login or registration page

Book store cataloging, entry and retrieval

Monthly loan payment calculator

Conference registration

Airlines, request for maintenance service

Walmart IT(April 2004 to March 2023)

SAP ABAP application development

Maintain and administer S.W.I.F.T(SAA, AWP)

References

Available upon request

Contact this candidate