Project Oracle

Location:

Sunnyvale, CA, 94086

Posted:

November 01, 2010

Contact this candidate

Resume:

NAME Jalesh Addres **** Henderson Contact jaleshdixit@ai

Dikshit s Avenue, Apt #1 m.com

Work Permanent Sunnyvale, CA - 94086 Phone 408-***-****

Authoriza Resident

tion

Education: 4 year Diploma In Production Engineering from Agnel Technical

College (India), 2 year Post Diploma in Computer Applications from SBM

Polytechnic (India) - 18 years of Education.

Professional Summary: I am an IT Professional with extensive experience in

RDBMS OLTP, archive application development. I have worked on application

migration of Retail (Retek) from Tandem to ORACLE RDBMS. I have written

Batch Processing programs using RDBMS Oracle SQL PL/SQL interfacing Pro*C,

C++ OCI on Unix operating system platform. I am also well verse with

Multi-Tier reusable code and application architecture using Internet and

Intranet development. I am Good at verbal and written precise

communication, documentation. I have done business analysis and have

developed manufacturing application modules BOM, MRP, Inventory etc. I

have created bitmap graphics editor and text editor. I have ability to

learn quickly and adapt to new technology.

CERTIFICATION: http://www.brainbench.com/transcript.jsp?pid=2629979

SKILLS

ERP Manufactur Retail: CRM: Siebel, SilkNet (Kana), Microsoft

Applicatio ing: Retek 9 Dynamics

n MANMAN,

Oracle

Mfg.

RDBMS ORACLE SQLServer Informix, ESQL/C

5/6/7/8/9/ Ingres, ESQL/C,

10 MySQL

SQL*Plus,

PL/SQL,

Pro*C,

SQL*Forms

3.0,

SQL*Loader

, OCI

Design CRUD, OOAD, UML, SSADM (Structured System Analysis and

OLTP, STAR RUP, Design)

, ERWin, Rational

Visio Rose

Language C, C++,

Java

Compile make, lex,

Tools yacc

Internet XML, HTML, CGI Perl, Apache Webserver

CSS, PHP, jsp

JavaScript

Macro/Shel sh, sed,

l awk, perl

OS Unix Microsoft

Variants: DOS,

Idris, DDE Windows

SMOS, 98, NT, XP

DRS-NX,

SCO,

Solaris,

HP-UX,

Amdahl-UTS

, IBM-AIX,

Linux

(RedHat,

Ubuntu),

AT&T

PROJECTS

PERIOD

CLIENT

LOCATION

ROLE

EMPLOYER

May'10-Jul'10

Threshold Enterprises Ltd.

Santacruz, CA

Integtrator

As Contractor

TEK Systems

Project: Implementation support and enhancement of ERP (Microsoft Dynamics

NAV) at Client Site.

Threshold Enterprise is in the business of making natural health care

products and selling them to distributors. They also buy other health

products from market, label and pack them for wholesale distributors. They

implemented their new ERP system using Microsoft Dynamics NAV 5/6 with the

help of SCSdynamics Systems integrater.

I did Business Analysis and study of Table Fields Business Mapping from

report preparation Point of view.

I created foreign keys and ER Diagram using Microsoft Visio, Copied source

code into one file using export option for documentation purposes.

I created and debugged report, forms, codeunit object using C/SIDE, C/AL

event code mechanism. Exported Objects to text file for searching

occurrence of a table in different form, codeunit objects.

ERP/CRM

RDBMS

Language

Tools

Microsoft Dynamics NAV 2009

Microsoft Windows NT

DELL Intel

SQLServer

C/SIDE, C/AL

Visio

PERIOD

CLIENT

LOCATION

ROLE

EMPLOYER

Jun'09-Jul'09

Seatel COBHAM plc.

Concord, CA

Integtrater

As Contractor

TAC Worldwide

Project: Implementation support and enhancement of CRM (Microsoft

Dynamics) at Client Site.

Seatel / COBHAM plc. is in the business of making marine antennas and

selling them to distributors. They implemented their manufacturing system

using Pointman and CRM using Microsoft Dynamics

I did Business Analysis and study of Table Fields Business Mapping from

Data Copying Point of view from PointMan Oracle to Microsoft Dynamics

SQLServer Database.

Created schedulable shell scripts for extracting data into flat files from

Pointman Oracle database using SQL*Plus scripts and loading it to

intermediate database using bcp utility of SQLServer, later sqlcmd of

SQLServer is used to load data from intermediate database to CRM database.

I enhanced Form Screens using Microsoft Dynamics event code using SOAP and

WebServices with MetaData.

ERP/CRM

RDBMS

Language

Tools

Microsoft Dynamics CRM, Pointman

Microsoft Windows NT

IBM Intel

SQLServer

SOAP, XML,wsdl, asp, javascript

Web Services, sqlplus, bcp, sqlcmd

PERIOD

CLIENT

LOCATION

ROLE

EMPLOYER

Jan'08-Feb'08

Sakata Seed Corporation

Morgan Hill, CA

Programmer

As Contractor

RHI (Robert Half Inc.)

Project: Post implementation support and enhancement of Axapta CRM

(Microsoft Dynamics) at Client Site.

Sakata Seed Corporation is in the business of cultivating Fruits and

Vegetables Seeds and Selling them in wholesale market. They implemented

their seed quality management system by customizing Axapta.

I did Business Analysis and study of Seed Quality Management Table Fields

Business Mapping.

I enhanced Reports and Screens using Axapta Xmorph and X++.

ERP/CRM

RDBMS

Language

Tools

Axapta (Microsoft Dynamics)

Microsoft Windows NT

IBM Intel

SQLServer

X++

Xmorph

PERIOD

CLIENT

LOCATION

ROLE

Employer

Apr'07-Dec'07

IRISLOGIC

SantaClara, CA

Programmer

IrisLogic

Project: Analysis, Design and Coding and Documentation of Intranet,

Internet WebSite using WAMP5 php, MySQL

Worked on various projects for IrisLogic

OpenSTA QA Project for SUN Microsystems Marketing website created using

Java JSP

Documentation of backend Database and code for

http://www.personalgrowth.com using phpDocumenter

Creation of intranet vacation system website using WAMP5

ERP/CRM

RDBMS

Language

Tools

HR Vacation System

Windows NT

DELL PC

MySQL

php modules, html, css, JavaScript

Apache WebServer, WAMP5

PERIOD

CLIENT

LOCATION

ROLE

Employer

Jan'07-Mar'07

CocaCola CBS

Atlanta, GA

Programmer Analyst

IrisLogic

Project: Post implementation support and enhancement of TIBCO - MDM-CIM -

Master Data Management and Collaborative Information Management - for

cbs.com

cbs.com CocaCola Business Solution maintains its product information using

TIBCO CIM-MDM

I did business study of how CocaCola synchronizes vendor's product

information details for all products purchased by them

I did study of Tibco CIM-MDM from its scarce documentation

Created Unix shell scripts for data cleansing of flat files exported from

TeraData and importing into CIM-MDM

Modified Tibco rulebase, workflow XML

ERP/CRM

RDBMS

Language

Tools

TIBCO CIM-MDM

IBM AIX

IBM RS 6000

ORACLE 10

SQL, PL/SQL, XML, Java

sh, awk, sed

PERIOD

CLIENT

LOCATION

ROLE

Employer

Dec'03-Dec'06

Self

Sunnyvale, CA

Product Developer

Self

Project: Product development using Microsoft Visual Studio .Net VC++ 2003

interfacing with Database

Developing Database Interface product with different functionalities.

Developing ScreenSaver without DirectX using very poorly documented

Microsoft Visual C++ .Net 2003

Developing webpage for a standard that can be used for transliterated

search interface, close caption on TV, spellingless search interface

http://www.Sp lllessTr nslitareshanKodingD kyum nt.net

Developing gnu C, C++ code along with redhat linux shell script for

altering Oxford pronunciation dictionary for the new standard.

Developing CGI scripts in Perl, php with MySQL database interface hosted

on yahoo.com later by godaddy.com

RDBMS

Language

Tools

Database Interface

Microsoft Windows XP

Intel PC

MySQL, Oracle

C, C++

Visual C++ .Net 2003

PERIOD

CLIENT

LOCATION

ROLE

Employer

Oct'02-Nov'03

ROSS STORES

Newark, CA

Project Lead

Deloitte Consulting

Majesco Software Inc.

Project: Migrating Custom Designed Retail Management System from

NonStopSQL on Tandem to Oracle on Unix with Retek

(ETL-ExtractTransformLoad)

Creating sed, awk shell script to read table definition from Tandem COBOL

and generating SQLCI scripts for data Extraction from NonStopSQL and

SQL*Loader scripts.

Genrating PL/SQL BULK feature scripts for loading data from temporary

tables to Retek tables with mapping data as input.

Studying Business Field mapping, Retek ER Diagram, Database procedures,

Pro*C batch programs and creating batch programs, altering make files.

Studying category, Sub-category, style, size, color code of clothing and

storing it in database in hierarchical fashion.

Modified and ported SunOS pro*c oracle 9 program to HP-UX oracle 8 with

SQL*Net connectivity between them.

Assisting SeeBeyond Retek Interface Bus RIB developer for queue table,

Oracle XDK, Oracle Advance Queue.

ERP/CRM

RDBMS

Language

Tools

Retek 9

Solaris

SUN Sparc

Oracle 9, 8

SQL, PL/SQL, Pro*C

sed, awk, lex, yacc, sh

PERIOD

CLIENT

LOCATION

ROLE

Employer

Feb'02-Aug'02

Sun Microsystems

Denver, CO

Data Architect

Deloitte Consulting

Majesco Software Inc.

Project: Using Localization L10N Internationalization I18N database for

storing Database Access Information to enable simultaneous multi-user

modification access

Sun Microsystem had decided to migrate its custom built CRM support system

from Java - Vantive - to SIEBEL

The security access module had to store database access information, L10N

tree leaf nodes were utilized to store this information with one XML block

per DB in order to facilitate simultaneous access and update of individual

database information.

The java interface for CRUD (create update Delete) was defined with

multi-tier architecture

The Rational Unified Process (RUP) was adapted to document OOAD class

diagram using UML

ERP/CRM

RDBMS

Language

Tools

SIEBEL, L10N

Solaris

Sun SPARC II

ORACLE

Java

Rational Rose, (ERD, UML)

PERIOD

CLIENT

LOCATION

ROLE

Employer

Oct'01-Dec'01

SanMateo County

SanMateo, CA

Warehouse DBA

Deloitte Consulting

Majesco Software Inc.

Projects: Performance improvement of SanMateo County Welfare DataWarehouse

SanMateo country welfare system stores data for child welfare system, and

various other welfare system on legacy system

The Oracle Business objects FrontEnd was used for extracting 'Business

Intelligence' queries from DataWarehouse archived using Informatica Tools

in Oracle 8

As DBA, I studied the Extraction, Transformation (PL/SQL), Loading of

Archive DataWarehouse

I modified the init.ora parameters, increased redolog filesize, enhanced

parallel query, studied striping RAID 0+5 for better performance

I also updated ER diagram using ERWin for the STAR schema FACT and

Dimension tables of the warehouse

ERP/CRM

RDBMS

Language

Tools

Welfare DataWarehouse

Windows NT

DELL Intel

ORACLE 8

SQL, PL/SQL

ERWin, SVRMGR

PERIOD

CLIENT

LOCATION

ROLE

Employer

Aug'01-Sep'01

Cadence Design Systems

SanJose, CA

Pro*C Programmer

Contractor

Majesco Software Inc.

Project: Pro*C Programs to extract data from SIEBEL Oracle Database as

done by FulCrum utility to create html pages with command line interface.

Cadence was in the process of migrating its support system from Scopus to

Siebel

The reports that existed in scopus had to be created from SIEBEL database,

I with the help of business analyst, found the mapping of business

functions.

Extracted data from Oracle database by writing Pro*C programs.

ERP/CRM

RDBMS

Language

Tools

Scopus, SIEBEL

SunOS

Sun SPARC

Oracle 8

Pro*C

make

PERIOD

CLIENT

LOCATION

ROLE

Employer

May'01-Jul'01

Innovis-Haverstick Consulting

Indianapolis, IN

Oracle Programmer

Contractor

Majesco Software Inc.

Project: Migration of http://www.carpetone.com backend Database from

Oracle to SQLServer developed using ColdFusion

Created 'C' program using Visual Studio, along with Unix Tools for Windows

NT to detect differences in SQL of Oracle and SQLServer 2000 in ColdFusion

files

Exported Oracle Data and imported it in SQLSercer2000

Made automated and Manual changes to Oracle SQL to make it SQLServer2000

compatible.

ERP/CRM

RDBMS

Language

Tools

WebSite

Windows NT

IBM PC

Oracle 7, SQLServer2000

T-SQL, C, Shell script

Unix tools for Windows

PERIOD

CLIENT

LOCATION

ROLE

Employer

Dec'98-Aug'00

WellsFargo Bank

SanFrancisco, CA

C++, Oracle Developer

Contractor

Majesco Software Inc.

Projects

Change the encryption algorithm of passwords stored in database

ARS Audit Reporting System, collect database object access audit

information from all databases and create web-CGI interface to access the

DataMart

CEOCR - Reconciliation system

Created Pro*C program for converting the encryption algorithm

Created PERL program with fork to simultaneously access multiple

database information and Load DataMart Datatable on daily basis

Created C++ CGI with OCI to generate HTML pages displaying queried

database access information by dynamic queries.

Developed html/Javascript pages and SQL scripts for Reconciliation System.

Coded Java Socket server with JDBC connectivity to verify password.

Coded Java Applet for displaying graph in browser over CGI application.

ERP/CRM

RDBMS

Language

Tools

Warehouse Banking

Unix SunOS, HP-UX

SunSparc, HP

Oracle 7,8

C, C++, Pro*C, PL/SQL, Java, HTML, JavaScript

make

PERIOD

CLIENT

LOCATION

ROLE

Employer

Aug'97-Aug'98

Informix Corporation

MenloPark, CA

C Programmer

Contractor

Majesco Software Inc.

Project: Testing Oracle function implementation in Informix, Developing

Server Validation Suite for QA of Informix Universal Server with DataBlade

API

Informix Universal Server started supporting UDT User_Defined_Type and had

MI DataBlade API for ORDB Object Relational Database features

I documented specifications for Server Validation Suite and coded ESQL/C

code with blade API for testing the features during simulated transaction

load

ERP/CRM

RDBMS

Language

Tools

Informix

Solaris

SUN UltraSPARC

Informix

C, ESQL/C

make

PERIOD

CLIENT

LOCATION

ROLE

Employer

Aug'94-Nov'94

3DO

Redwood City, CA

MFG ERP Programmer

Contractor

Mastek Software Inc.

Project: Post implementation Enhancement of Oracle Applications

Engineering/Manufacturing BOM, Costing modules batch programs and reports.

Coded customization of Oracle Application BOM pro*C code,source code

provided by oracle support.

Coded customized RPT/RPF reports for manufacturing.

Coded scripts for implementing running average costing in standard costing

environment.

ERP/CRM

RDBMS

Language

Tools

Oracle Applications

Solaris

SUN SPARC

Oracle

C, Pro*C, OCI, SQL

make

Brief Summary of Other Projects

CLIENT DESCRIPTION PERIOD CITY STATE

PE-Nelso SQL*Forms 3.0 to Oracle Forms 4.0 Nov'94 San Jose CA

n Migration for SQL*LIMS (Laboratory -

Information Management System) Dec'94

FRITZ Coding SQL*Forms 3.0 (Freight Information Jan'95 San CA

System) - Francisc

Feb'95 o

SQLSyste Bridge between Rapier R5 Plant Maintenance Apr'95 Eden CA

ms System and Oracle Engineering Module - Prairie

(HSBRT) Aug'95

Amdahl COMPASS Communication of Problem and Aug'95 Sunnyval CA

Solution System (Inhouse CRM/Support - e

system using SQL*Forms 3.0 on block mode Dec'95

terminal with backend Oracle 6 database on

Amdahl UTS Unix)

Amdahl RPM (Release Product Management) C, Jan'96 Sunnyval CA

QuickScreen, X Window - investigating - e

problem integrating with COMPASS on Amdahl Aug'96

UTS Unix

Sanmina Oracle Application DBA on Sun Solaris, Aug'96 Milpitas CA

Oracle 7 -

Sep'96

Tradespa http://www.tradespace.com StratUp Website Sep'96 San Jose CA

ce for buying and selling Computer -

Components, Organizing Computer Bill Of Jan'97

Material with different manufacturers

using Oracle RDBMS for Web Front-End.

Gilead Resource study for IT Department working Feb'97 FosterCi CA

Sciences on Drug Trials for Drug Approval by FDA - ty

using ClinTrial and ClinTrace Software. Aug'97

Microsoft 3.0 to Windows 95 Migration.

Unix Performance and security.

Cadence Pro*C program to migrate LONG datatype Aug'98 San Jose CA

Design from SCOPUS to SIEBEL -

Systems Sep'98

SilkNet Support at SilkNet after 2 weeks training Oct'99 SanFranc CA

Kana for Web Based CRM and Support system - isco

Nov'99

VARStree SilkNet Install and Implementation for Dec'99 SantaCla CA

t Application Service Provider with Oracle - ra

on Unix Feb'99

Lucent Performance DBA- investigating performance Mar'00 Alameda CA

bottleneck in SIEBEL implementation -

Suggested Striping JBOD with RAID 0 (2

weeks)

Mastek Java Servlet, JSP pages with SQLServer Apr'00 Mumbai India

JDBC/ODBC

Projects in India and Singapore

PERIOD

CLIENT

LOCATION

ROLE

Employer

Dec'93-Feb'94

Mastek India

SDF V, Mumbai

C, lex,yacc Programmer

Internal Team

Mastek India

Project: Automated Translation of Oracle Scripts for various Tools to

Ingres tool scripts, I was working SQL*Plus script translation to Ingres

ESQL/C code

Created lex and yacc script with C functions to read SQL*Plus script

grammar and generate elementary ESQL/C code.

Partial mapping of Oracle SQL functions to Ingres SQL functions

Partial grammar of Oracle SQL

ERP/CRM

RDBMS

Language

Tools

Ingres

SCO

IBM PC Compatible

Ingres

C, ESQL/C

make

PERIOD

CLIENT

LOCATION

ROLE

Employer

Aug'93-Oct'93

IVP International Video Products

Yishun, Singapore

Project Leader

Mastek Asia Pacific Pte.

Mastek Asia Pacific.

Project: System study for migration of MANMAN on VAX/VMS to Oracle

Application on Unix for VCR/VCP manufacturing management system.

Study of various option for OMAR (Order Mangement and Account Receivable),

AP for MANMAN

Comparative study of Ingres and Oracle as an alternative to MANMAN.

ERP/CRM

RDBMS

Language

Tools

MANMAN

VAX/VMS

VAX

Oracle, Ingres

PERIOD

CLIENT

LOCATION

ROLE

Employer

Aug'92-Aug'93

hmt India

Ernakulam, India

Group Leader

ICIM/Zensar

ICIM

Project: Migration of Manufacturing and Production Management System from

Network Database on ICL to Oracle RDBMS on Unix DRS-NX.

hmt ( hindustan machine tools) is a CNC machine tool manufacturing company

I did Analysis, Design and coding of presentation, logic layer of BOM,

MRP(implosion, explosion), Purchase, Inventory modules.

Coding of 'C' program for migrating 6 bit byte data on legacy system to 8

bit byte data on Unix.

ERP/CRM

RDBMS

Language

Tools

Manufacturing System

Solaris DRS/NX

DRS/NX 6000 SPARC

Oracle

Pro*C, SQL*Forms 3.0

make

PERIOD

CLIENT

LOCATION

ROLE

Employer

Jan'89-Jan'90

INS Indian Naval Service

Lonavala, India

C Programmer

ORG Systems

Project: CBT Computer Based Training system for Indian Naval Service in

English/Russian in a classroom environment with Instructor on console.

Coded Russian and English text editor on MS-DOS using MSC 3.0, the extra

128 characters above ascii 128 were changed in EPROM for Russian in PC

Coded bitmap Graphics Editor with primitives flood-fill on MS-DOS using

MSC 3.0

Enhanced Student client program used for browsing text and graphics

Designed and coded double link list for storing student and their test

score database.

Debugged and patched lesson tree editor, nry tree for lesson levels.

Implementation at customer site.

ERP/CRM

RDBMS

Language

Tools

Training System

SMOS Unix, MS-DOS 6

Supermax MC 68000, IBM PC

PERIOD

CLIENT

LOCATION

ROLE

Employer

Jan'89-Jan'90

Internal IT

Andheri, India

AutoCAD, DBase Programmer

Programmer

Polychrome Plastics Pvt. Ltd.

Project: Drafting mold on AutoCAD for plastic molding, applying pline

transformation to incorporate shrinkage and adding allowance.

Coded Russian and English text editor on MS-DOS using MSC 3.0, the extra

128 characters above ascii 128 were changed in EPROM for Russian in PC

Coded bitmap Graphics Editor with primitives flood-fill on MS-DOS using

MSC 3.0

Enhanced Student client program used for browsing text and graphics

Designed and coded double link list for storing student and their test

score database.

Debugged and patched lesson tree editor, nry tree for lesson levels.

Implementation at customer site.

ERP/CRM

RDBMS

Language

Tools

Sales, Inventory

MS-DOS 6

IBM PC

Dbase, FoxBase

PERIOD

CLIENT

LOCATION

ROLE

Employer

Sep'85-Sep'86

Godrej

Vikroli, India

Trainee Engineer

Godrej & Boyce Mfg.

Godrej & Boyce Mfg. Company Pvt. Ltd.

Project: Trainee Engineer One year orientation in various manufacturing

units.

Studying furniture, lock and safe, refrigerator, typewriter, m/c tool

mfg., service and support divisions of Godrej and Boyce manufacturing.

Studying designs and manufacturing units, manufacturing processes, study

assembly line, industrial engg..

PERIOD

CLIENT

LOCATION

ROLE

Employer

Jan'84-Jun'84

Mahindra & Mahindra Jeep

Kandivali, India

Trainee Technician

Part of Diploma in Production Engineering

Mahindra & Mahindra

Project: Orientation in Jeep Manufacturing Plant for studying various

manufacturing processes

Studying different assemblies in Engine, Gear Box, Differential in Jeep

Studying spur and helical gear, thread manufacturing processes Gear

hobbing, shaping, shaving

Studying 47x11 Hypoidal Bevel Gear cutting by Gleason method, gear lapping

Studying sheet metal cutting, forming processes

Studying jigs, fixtures for various turning, milling, grinding and

drilling processes.

Studying involute and other metrological measurement instruments

Studying foundry casting, forging and other manufacturing, metallurgical

processes.

Contact this candidate