Arijit Bal

Email - abnzb1@r.postjobfree.com Phone - 818-***-****

Summary: Arijit, a Solution Architect has more than 17 years of IT

experience and about 7 years of Demantra(Demand Management/S&OP/Settlement

Management/PTP) and supply-chain planning experience of the whole software

lifecycle and Upgrade projects. Area of strength covers Production Support,

Build, QA/QC and Release Engineering. Has extensive experience in

Relational Database development using Oracle, SQL Server, Sybase and Access

also database administration in Oracle.

Work Environment

Hardware Pentium Server/VGA terminals, Sun SPARC Server/WIPRO

terminals, ICIM DRS/6000 Server/ICIM terminals, Solaris

Languages Java - 1 year, C - 1 years, PL/SQL - 11 years, Transact

SQL - 3 years, JHTML and HTML - 1 year

Operating SCO Open Server 5.0, UNIX (Sun, HP), Windows

Systems XP/2000/98/95/NT/7, Solaris, Linux

RDBMS &Tools ORACLE 11g/10g/9i/8i/8.0/7.3 - 17 years, SQL*PLUS - 17 years,

SQL Navigator - 7 years, Benthic - 2 year, SYBASE System 10.0

- 1 years, Access 2000/97 - 6 months, APT Workbench - 1

years, Data Workbench - 1 years, DB-Library with Host C - 1

years, SQL Server 2000 and 2005 - 2 years

CASE Tool Designer/2000 Release 2.1 - 3 years

GUI Developer /2000 (Forms 6i/5.0/4.5, Reports 6i/3.0/2.5) - 10

years, Crystal Reports 8.5/10 - 2.5 years, Crystal Enterprise

10 - 1 year, Dreamweaver/Front Page - 3 yrs, Flash - 1yr,

Photoshop - 2yrs

Application Dynamo 4.5.1 - 1 years

Server

Application Oracle Demantra 6.2.6/7.0.2/7.1.0/7.1.1/7.3.1 - about 7yrs,

Personality 2000 - 4 yrs

Technical Projects Experience

Client - Finisar - 12/2012 to till date

Functional and Technical Consultant: Working on enhancements, trouble

shooting issues in Oracle Demantra 7.3.0.2 implementation on Oracle 10g,

Linux and Weblogic.

Oracle Corporation - 04/2006 to 11/2012

Client - Sensata - 08/2012 to till date

Functional and Technical Consultant: Working on enhancements in an already

implemented Demantra application. The enhancements cover review some areas

and make changes as required. It's an Oracle Demantra 7.3.0 implementation

on Oracle 11g, Linux and Oracle Application Server.

Client - Google/Motorola Mobility - 06/2011 to 07/2012

Functional: Implemented Demand Management for a world-wide Communication

organization. Responsibilities include requirements gathering, business

process and functional design, configurations, developing integration

specifications, helping the technical team in designing the interfaces,

conducting Conference Room Pilot, Acceptance testing and troubleshooting.

It's an Oracle Demantra 7.3.1 implementation on Oracle 11g, Linux and

Oracle Application Server.

Client - US Postal Service - 10/2008 to 04/2009 and 07/2011 05/2011

Functional Lead and Solution Architect: Implemented Demand Management and

Sales & Operations modules. Responsibilities include requirements

gathering, business process and functional design, developing integration

specifications, leading the technical team in designing the interfaces,

data modeling, conducting Conference Room Pilot, Acceptance testing and

troubleshooting. Lead the team Functionally and Technically to achieve

successful Go live. This was an Oracle Demantra 7.2 Implementation on

Oracle 10g using Linux, Oracle Application Server and Demantra was upgraded

to 7.3 later.

Client - Jhonson and Jhonson Lifescan - 05/2009 to 06/2009

Functional/Technical Lead: Worked on upgrading the system to Demantra

7.2.0.2. Lead the upgrade project and addressed/resolved all issues during

upgrade.

Client - Ubisoft - 09/2008 to 10/2008

Technical Colsultant: Was responsible in performance tuning. This was

Oracle Demantra 7.2 Implementation on Oracle 10g and Unix.

Client - 20th Century Fox - 08/2007 to 04/2008

Technical Lead: Designed and implemented a unique solution for Category

Management for a leading Film Studio. Responsibilities include requirements

gathering, business process and technical design, developing integration

specifications, data modeling, development, end user training and user

acceptance testing. Performance Tuning was the most critical area in this

project and was handled successfully to meet the Client's expectation. This

was Oracle Demantra 7.1.1 Implementation on Oracle 10g.

Client - Pharmavite - 11/2006 to 07/2007 and 04/2008 to 09/2008

Functional and Technical Lead: Responsible for production support,

troubleshooting, enhancement of Demantra DM/and PTP solution, analysis,

design and development based on the requirements gathered from business

users. Oracle Demantra 6.2.6 Implementation on Unix.

Client - Korbel - 04/2006 to 10/2006

Technical lead: Responsible for application installation, database creation

and maintenance, integration design, model configuration, performance

tuning (application level and DB level) and workflow setup. Developed SQL

procedures to implement custom client calculations. Configured forecast

accuracy measurements within the application. Provided post production

support. This was Demantra 7.1 Implementation on SQL Server 2005.

Client - City of Pasadena - 04/2002 to 03/2006

Support and development:

Payroll/HR system- was responsible in database (Oracle8i/9i), report

(Report6i) development and support in City of Pasadena. Personality2000 is

the application, which covers different areas like Payroll, HR, Benefits,

Budget and Transportation. Working as the only consultant to support all

these applications to provide with high level of customer satisfaction. Is

involved with new report development as well as enhancement using Report6i.

Performance tuning is performed in different areas using Explain plan. Used

SQL Navigator4.0, SQL*PLUS as a tool to write procedures, functions,

triggers using PL/SQL. Also, is involved in giving training to the other

developers as well as solving their problems.

Automated Timecard system- Was responsible in database (SQL Server),

report (Crystal Reports 10 and Crystal Enterprise 10) development and

support.

Client - SBC Directory Operations - Interactive Media. - 01/2000 to

03/2002

Production Support - Was responsible to solve the site issues, which

are reported by SBC customers and users. The site issues are mostly related

with Oracle 8i, Java, JHTML. Besides solving site issues, takes care of

problems associated with code-release, is responsible in bug fixing with

SBC's Order Entry Tool and Build Tool( Developer 2000 Forms5.0, Reports3.0)

- used by Customer Service and Order Entry department.

Was also responsible in development of new Web-based applications.

SBCDO has one of the best YellowPages in the world. It has some unique

features. The system is based on Dynamo Application Server. The scope of

work covers maintenance and development by back-end programming in Oracle8i

database and Java 1.2.2, PL/SQL languages. Was also responsible for

database maintenance and administration. Was responsible for handling the

site issues, which are reported by different customers.

Release Engineering - Was responsible to develop a Build Release

application using Java and JHTML with version control using Star Team 4.0.

Headings - Was responsible in analysis, design and development of

Universal Heading Code mapping. Headings, received from different sources,

consolidate into SBCI virtual headings. The Advertisers can buy a listing

in any region in any Heading. So, when a type search is performed in a

particular directory or city or zip code, the Advertisers (along with the

free listings) will show up. The purpose of this mapping is to increase the

number of Advertisers, which will result in more revenue. Used Oracle8i and

PL/SQL.

WhitePages - Was involved in WhitePages development. One of the main

responsibilities was to manage more than 90 million transactional data. The

work-area covered database development and maintenance. Was responsible for

performance tuning, which was directly related to SBC's site performance. A

powerful feature of Dynamo - Relational View Manager was used to interact

between the Java Classes and the Oracle database.

YellowPages - Was responsible to include the Geocoding of addresses to

get the exact location in the map for Driving Directions. Worked in the

integration of Telco Data with different data sources like Ameritech and

South Western Bell. Implemented business rules for "hour text" for

different customers and Merchant Id generation. Also used shell scripts to

run the batch jobs.

Personalization - Was responsible to implement Personalization Server

with the current functionalities to increase site traffic. The module

included User Registration, Address Book, and Notepad Maintenance. For this

project Dynamo Personalization Server 4.5.1 along with Oracle 8i were used.

QA/QC - Was responsible to test and finalize different projects.

Axiom Technologies International - 09/1999 to 12/1999

Working as a Database administrator and system developer on a Catalyst

Testing application. The client is in need to uniform and standardize the

data input procedures, which can keep track of the same readings in a

uniform way. Is responsible to study, design the database and user

interface along with graphs using Access 97.

Simultaneously involved in developing a Timesheet Management system, using

Java Servlet programs with Oracle database. Used Crystal reports for

reporting.

Techna International Corporation, November 98 to August 99

06/1999 to 08/1999 Worked as a Database Administrator on a project

named Recruiters Exchange (REX). Contract Programmers' Exchange deals with

the requirements raised by the buyers. REX maintains a Dynamic Database

created by generic process. Using Designer/2000 release 2.1 the Database

was transformed in Oracle 8.0 from ERD and DFD. Had a leading role in

creating and maintaining the full database, managing the users. Was

responsible to maintain regular back-up also.

Client - Nomura Research Institute Europe LTD. (London) - 01/1999 to

02/1999

Worked as a System Developer on Raffles Business System. Was engaged in

developing current functionality, related with security trading. Was

responsible to provide some changes in already developed system in Oracle

8.0 with Developer 2000 Release 2 as front-end.

Client - California State University, Northridge Campus - 10/1998 to

12/1998

Worked as a system developer on Student Information Management System. Used

Developer/2000 Forms 4.5, PL/SQL for developing the reports and Library

extract files. The Creation of Grade Roaster had a challenging feature of

"Bubble Allocation", implemented with the help of PL/SQL.

Sigma Consultants, August 96 to October 98

Client - GEC Alsthom - 01/1998 to 10/1998

Supply Chain Management System:

Worked as a Business/System Analyst, DBA and developer. This system was

responsible to take care of the key areas like sales, order, promotions and

market research information across different branches and regions to

corporate office. I was responsible to analyze users' specification and

design/integrate the system to serve the purposes efficiently. Was

responsible for developing DFD with Designer/2000, loading data using SQL*

Loader, creating Stored Procedures, Triggers, Functions using PL/SQL. And

was also responsible to create user interfaces for maintenance of data

using Developer/2000. High level of performance tuning needed to be done

because of high Volume of data.

Production Planning System:

The System was part of the Database Oriented Real Time Enterprise Wise

Automatic Management System for the Engineering Industry. This part

included I) Plan Process and II) Production Schedule. This System was

involved with the complete flow from Research and Development to Dispatch

of complete items.

Sales Monitoring and Inventory Control System:

This generalized integrated system encompassed all facets of the production

process, from the order booking stage through work order generation. The

status could be available until the final stage i.e. dispatch and invoices.

The system was developed with the help of Developer/2000 using Oracle 7.3

as back-end.

Shares Accounting System (SAS):

Involved in implementing this SAS package so that the company would be able

to generate all the various types of transactions affecting the share

holders' balance, location, tax status, protection, share movements,

distribution etc. and update the share holders' information. The system

generated decision support reports needed during executive meetings.

Client - Eveready Industries LTD - 08/1996 to 12/1997

Worked as System Developer on Sales and Finished Goods Consolidation System

using APT Workbench and Data Workbench, SYBASE System 10.0, bcp utility,

DB-library with C host C was used.

Artintel Systems Laboratories Ltd. January 95 to July 96

Client - Worthington Pump LTD - 01/1995 to 07/1996

Worked as a system developer on project named Production Planning and

Control System. The company was in real need of Standard Planning and

Control of their Production Procedures, so that they could get the optimum

control on their product quality and dispatch values as per ISO 9001. In

the system the modules from R&D to Dispatch were incorporated. On the

server side, various stored procedures and database triggers were written

in Sybase System 10.0.

Education

MS in Computer Applications (ongoing)

Certification in Computer and Office Management

Advanced Certification in System Management

References available upon request.

Contact this candidate