Data Project
Resume:
Title:RAJESH NAMJOSHI
***************@*******.***
Document
Source below
NAME: RAJESH NAMJOSHI
ADDRESS: **** ****** ****
CITY: DUBLINE
STATE/PROVINCE: CA
ZIP/POSTAL CODE: 94567
COUNTRY: USA
EMAIL: ***************@*******.***
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: ***************@*******.*******
: 510-209-7504Home:
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