Title:RAJESH NAMJOSHI

abp2n4@r.postjobfree.com

Document

Source below

NAME: RAJESH NAMJOSHI

ADDRESS: **** ****** ****

CITY: DUBLINE

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 94567

COUNTRY: USA

EMAIL: abp2n4@r.postjobfree.com

PHONE: 510-***-****

CANDIDATE ID: 96730

CITIZENSHIP: Permit

EDUCATION: Bachelor Degree

EXPERIENCE: 10

WILL RELOCATE: Yes

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: 75000

HOMEPAGE:

HOTSKILLS: Data Warehousing, Informatica Developement,Data Modeling

ESUME

RAJESH NAMJOSHIEmail: abp2n4@r.postjobfree.com

: 510-209-7504Home:

510-***-****

SUMMARY

Over 9 years of experience in Information Technology includes System Analysis,

Designing of various business applications, client/Server Technology and Data

Warehousing Applications. Experience in designing and implementing data mart

applications, mainly in designing data models using modeling tools like

Designer/2000 and Erwin. Extensive experience in Transformation process using

ETL tool like Informatica. Knowledge of reporting tools like Business Objects,

Cognos.Experience in Functional and application knowledge of Finance,

Manufacturing etc.

Highlights of Skills:

Strong Data and object modeling background and hands on experience in

developing large and complex logical and physical data models using Erwin and

Designer/2000. Experienced on Database like Oracle 7.x, 8.x, SQL

Server7.x Extensive experience writing SQL functions, procedures, triggers and

packages. Proficient working at Data Warehousing/Data modeling including

Decision Support system and Client/Server technologies. Proficient in ETL

tools- Informatica 4.7/5.0 Experience with informatica in creating maintaining

and testing mappings for staging using Powermart, Powercenter and PL/Sql to

build data mart

PROFESSIONAL EXPERIENCE:

Mecanzy & Company

Project Title:CORA

Aug01

to Current

Environment: Oracle Warehouse Builder 3i,Oracle 8.x,9i,Clearcase,Sun Solaris

Presently working as a Datwarehouse Developer/Quality Analyst for BI product for

a company called QUESTRIX. I am responsible for creating various mappings using

different transformations, writing functions, procedures using PL/SQL. Also

creating test environment and data for testing the mappings. The testing

includes unit testing, system testing etc. to test the business logic, data

transformation, assumptions etc.

My Contribution Used OWB Designer to design the multi-dimensional table schema

to scrub and filter the data that was being loaded and also to aggregate the

facts before loading them into the aggregate tables. Used OWB for extraction,

transformation and loading the operational data into a multi-dimensional

database Created various mappings using different transformations like filter,

lookup transformation, aggregator, expression transformations, joiner

transformations etc. Created reusable objects like global transformations to

standardize the business process and logic to avoid the redundant work. Also

work with database administration for tuning the mappings Created test scripts

for unit testing at individual mapping level for testing. Created test scripts

for System testing at Entity level. Created test data (flat files) for testing

the mappings and entities

Project Title:

Data Warehousing

Apr01

to Jul01PARSONS ENGG. LA

Position :

Data Modeler/Informatica Developer

Environment: Erwin 3.5,PowerPoint, MS Project, MS Word, Informatica 4.7,Oracle

8.x

Worked as a data modeler/ informatica developer a new application for Sales and

Marketing Management for the organization. This project purpose is to create

Data Warehouse for their Sales and Marketing. My Contribution Interacting

with the end users for collecting the requirements. Interacting with the

System Users who maintaining the current system and understand the business

processes and functions Documenting the requirements and do the Requirements

analysis Creating conceptual design and processes as per the

requirements Create high level ER digrams Build the data model on the basis

of Analysis Create user Environment Create initial Architectural Document

for the application Designed data model using Erwin and created schema. The

data from various operational tables were converted to master, aggregate and

historical tables. Used cross-reference tables and surrogate keys to track the

changes and maintain data integrity. Created Repository using the Repository

manager as a hub for interaction between various tools. Security and user

management, repository backup was also done using the same tool. Used

Informatica Designer to design the multi-dimensional table schema to scrub and

filter the data that was being loaded and also to aggregate the facts before

loading them into the aggregate tables. Used informatica Powermart for

extraction, transformation and loading the operational data into a

multi-dimensional database Created various mappings using different

transformations like filter, lookup transformation, aggregator, expression

transformations, joiner transformations etc. Created reusable objects like

mapplets to standardize the business process and logic to avoid the redundant

work. Created sessions and batches for created mappings to load data from

source to target with update strategies. Also work with database

administration for tuning the mappings.

PROVIDIAN FINANCIAL, Aug00Mar01

Project Title : Small Business Card

Position: Data modeler/INFORMATICA Developer

Environment: Erwin 3.5, Informatica 4.7,Oracle 8.x,Unix

Worked on a Data Warehousing project for Providian financial to store and

process data about the customers and credit cards and lines of credit. This

project involved designing the schema (SBC model) using Erwin, ETL using

Informatica Powermart and Oracle as a database on Unix platform. The

operational database stores the customers current and historical Business

credit card information in a Normalized Schema.This data was stored in an OLTP

database and contain details about the customer such as name address type of

account business type, income etc. This data is ported, refreshed, inserted and

updated weekly and fortnightly. There is another system called Total

system through which data is collected about customer monthly

transactions like total purchases against the cards, cash advances, Reward

schemes, points earned, last cash advance details and status of card etc. This

data is ported on monthly basis and updates customers transactions and

balances. This system is further integrated with SBC system

My Contribution Designed data model using Erwin and created schema. The data

from various operational tables were converted to master, aggregate and

historical tables. Used cross-reference tables and surrogate keys to track the

changes and maintain data integrity. Created Repository using the Repository

manager as a hub for interaction between various tools. Security and user

management, repository backup was also done using the same tool. Used

Informatica Designer to design the multi-dimensional table schema to scrub and

filter the data that was being loaded and also to aggregate the facts before

loading them into the aggregate tables. Used informatica Powermart for

extraction, transformation and loading the operational data into a

multi-dimensional database Created various mappings using different

transformations like filter, lookup transformation, aggregator, expression

transformations, joiner transformations etc. Created reusable objects like

mapplets to standardize the business process and logic to avoid the redundant

work. Created sessions and batches for created mappings to load data from

source to target with update strategies. Also work with database

administration for tuning the mappings.

Indo Rama Synthetics (I) Ltd Aug 99 Jul 00

Project Title : SAP Implementation

Position: Analyst Programmer

Environment: RS/6000,Oracle 7.3, AIX, ABAP/4, Win NT 4.0

Worked as a core team member of SAP functional team for Indo Rama Synthetics (I)

Ltd. For Materials Management Module. Involved in As-is-flows, Developing

reports and interfaces between the systems. Also undergone training of ABAP/4.

Working with the world known consulting team of KPMG for SAP project

My Contribution

Created classical and interacting reports. Created SAP Scripts Styles &

layouts sets. Created Queries and organizer. Data extraction and data upload

from Legacy System to SAP database. Documentation of the development

procedures, creating templates, coordinating with Functional Consultants,

Developing reports programs, Dialog programs, BDCs.

Indo Rama Synthetics (I) Ltd

Jan 98 - Jul 99

Project Title : Raw Material Inventory and Payable System

Position: Analyst

Led a team of four people in Designing and Development of the application. This

system has been developed monitoring the stores activities, which involved in

procurement of Raw materials required for finished products. Payable systems

provide to generate Payments to the suppliers with due integration with raw

material Procurement System and Raw Material Inventory System. Used SQL*loader

as a bridge for transforming data from legacy system to Oracle Database

My Contribution

Requirements analysis, data modeling, design and development Created E-R

diagrams, Flow charts Wrote procedures, functions, triggers and packages Used

SQL*Loader for data transfer Developed Forms using Oracle Forms 5.0 Created

reports on Export License Validity, License Balances, various MIS reports and

Transfer Note Write system test cases Database Administration, including

security, connectivity, optimization, backup strategy Migration from Oracle

7.3 to 8.0

Indo Rama Synthetics (I) Ltd

Projects from

Nov 95

to Dec 97

Position: Programmer

Environment: Oracle 7.3, Forms 5.0, Reports 3.0, PL/SQL, SQL*Loader, SCO UNIX,

Win NT 4.0

From Nov 95 To Dec 97, worked on various projects in Indo Rama Synthetics (I)

Ltd. In this period of 2 years, developed 4 commercial applications in Oracle,

UNIX and NT environment. The applications are listed below. My contribution to

these projects follows the project descriptions.Export License Monitoring

System

Jul 97 - Dec 97 The Government Of India offers a licensing scheme

for duty free import of raw material for export-oriented company, with the

obligation that the company has to export material worth 33% more than its

imports. The purpose of his application is to co-ordinate imports and exports

so as to keep license wise accounting of imports and export. Raw Material

Procurement System

Jan 97 - Jun 97 This system is Designed and Developed

to track the flow of raw material from supplier to Organization. This system

contains transactions like Purchase Order, Purchase Invoice, Letter of Credit,

etc. All documents are inter linked with each other to update pendancy at every

stage at port, at works etc. Which is important for procurement of

material.Purchase Control System

Jul 96 - Dec 96 Led a team of four

people in the project at IRSL, This system has been Designed and Developed for

monitoring the procurement activities of the organization. This system

generates MIS reports daily and weekly for the management. This system is

further linked with Inventory Control System. Inventory Control System Nov

95 Jun 96 This system is developed for maintaining all stores transactions

like Goods receipts, Goods issue, Goods returns etc., Through this system we

can track the inventory and consumption of material required to produce

finished goods in the factory. This system also generates automatic MRP. This

system also produces analysis reports like ABC analysis, ERTOP analysis. This

system has interface with payable system.My Contribution As a Developer & DBA

to above projects from Nov 95 to Dec 97: Requirements analysis, data

modelling, design and development Created E-R diagrams, Flow charts Wrote

procedures, functions, triggers and packages Used SQL*Loader for data

transfer Developed Forms using Oracle Forms 5.0 Created various MIS reports

using Reports 3.0 Database Administration, including security, connectivity,

optimisation, backup strategy

Sunflag Iron & Steel Co. Ltd

.

Apr 91

Feb92

Projects from

Nov 91

to Dec 94

Position: Programmer

Environment: Sco Unix Foxpro

Project Title : Payroll

This application contains all the details of their employee. This system has

interface with the punching machine to calculate the attendanceof the employees

for the month. This system generates various reports like salary sheet, PF

deduction statement,monthly deduction against loan etc. and the summary reports

required by the executives of the organization for yearly increments.

Sunflag Iron & Steel Co. Ltd

.

Feb92

- Apr94

Projects from

Nov 92

to Apr 94

Position: Programmer

Environment: Sco Unix Foxpro

Project Title : Branch Invoicing System

This system is developed for collecting the sales data on daily basis for the

marketing offices all over the country . This system has a feature of

maintaining stocks at branch level and monitor the sales activities at the

branch level. Also written some programs for updating and transfer of data from

branches to corporate system.

Contact this candidate