Project Data
Resume:
Title:Programmer/Analyst/DP Manager
***********@*****.***
Document
Source below
NAME: nadkarni, shirish
ADDRESS:
ADDRESS2:
CITY: worcester
STATE: MA
ZIP: 01606
CANDIDATE ID: 2303918
US CITIZENSHIP:
EDUCATION:
EXPERIENCE:
WILL RELOCATE: -
JOB WANTED:
RATE NEEDED:
TELEPHONE:
EMAIL: ***********@*****.***
HOMEPAGE:
HOTTEST SKILLS: 2167, 3270, 80.86, a+ certification, abap, activex, animation, apache, as
400, as/400, as400, assembly language, athlon, autocad, automatic test equipment,
aviation, baan, banyan, beos, booch
REVISION: 22-MAY-02
YOE:
RESUME:
Objective
Seeking a long-term, challenging opportunity which enables my advancement with the
organization by suitably utilizing my diverse IT experience and business knowledge in an
Information Management position. My knowledge and expertise exists specifically with
INFORMATICA PowerMart / PowerCenter, Oracle, and Trillium.
Summary
Presently working with Allmerica Financial Corporation, Worcester, Massachusetts for
Keane Inc. in the capacity of INFORMATICA Database Administrator.
Developed business and data conversion strategies and coordinated all aspects of Data
Management. Led the Data Warehousing and Knowledge Management efforts to effectively
capture and disseminate knowledge within an organization. Planned the data integration and
conversion processes for Data Warehouse projects ensuring the smooth transition between
diverse database systems.
Job Duties (Informatica Admin):
i Managing and maintaining the infrastructure of platform integration projects.
i Controlling central issues such as security, distributed objects, database
connectivity, software installation, and organizing session and batch runs.
i Managing tasks with the vital role of developing, troubleshooting and maintaining
transformations, mappings, and mapplets the logical structure of the data integration
process.
i Working
with Informaticas core enablement technologies to integrate data from a
greater variety of platforms and enterprise solutions.
i Maintaining and migrating mappings/sessions from the development/testing environment
to the integration/production environment. Implemented considerable amount of
comprehensive integration process during migration.
Informatica Project: CBS Datamart
Corporate Brokerage Services (CBS): CBS is a data management and analytical facility to
support the brokerage account business for the Allmerica Financial advisor group. This
facility is utilized to: support financial advisors with electronic record keeping,
support compliance in the monitoring and supervision of sales practices, the first phase
covered target customer, account, transactional, positions, account balances, and
suitability data for feeds from National Financial (Fidelity), DST FanMail, NSCC, IPS, and
NLS, as well as Vantage and Beacon proprietary annuity products.
Currently the Brokerage Services data exists in an Oracle database on a shared server and
is accessed via the eFirm website. The access is provided through Java servlets, in turn
creating DHTML for viewing on the website.
The process of extraction, transformation, and loading into the CBS datamart takes place
nightly and then integrated with the data that exists from the other external feeds. The
National Financial (Phase I of the CBS project) source data is stored in its own set of
tables separate from the other sources (DST, NLS, NSCC, Vantage, and Beacon).
The data for accounts, balances, bookkeeping customers, and positions are extracted from
the database and loaded into the CBS datamart. Full conversions are run initially and are
followed by the daily deltas (the new daily files received).
Current Technical Architecture:
Production:
ETL Tool: Informatica Power Mart 4.7.3
Database: Oracle 8i
O/S: Sun O/S
Server: WW3
Development:
ETL Tool: Informatica Power Mart 4.7.3
Database: Oracle 8I
O/S: Sun O/S
Server: WWWAFRSD
Job Duties (Trillium):
i Profiling the condition of the data
i Identifying elements in free-form data such as first and last names, business names,
address lines, cities, serial numbers, dates, part numbers and other data "shapes"
i Recoding data patterns for consistency
i Enhancing and fixing missing data in customer addresses
i Identifying and matching households, business contacts and other relationships
i Eliminating duplicates in large databases
i Periodic maintenance of postal directory tables.
Software and Operating Systems
Windows NT, Windows for Workgroups, Windows 98, Windows 95, Unix.
Software/DB Tools:
INFORMATICA PowerMart release 4.5.1, 5.1. Trillium version 4.0,5.0. Strong in Oracle
Backend development, 8.0/7.x, PL/SQL, SQL*Plus. Involved in DBA activities like: Creating
databases and other schema objects. Creating users, granting privileges to users.
Developer 2000 (Forms 5.0/4.5 & 3.0), ASP, HTML, SQL Server, SQL Loader, FORTRAN 77,
BASIC, MS Office 2000.
Education
Bachelors Engineering,
May '98
University of Mumbai,
India
Software Education Program focusing on Oracle at Gebbs Institute, Sept '98
A division of Gebbs Software India Pvt. Ltd.
Informatica PowerCenter 5.0 certification program - June 2001
BMC Patrol for Oracle certification training program
June 2001
Trillium Software training program Aug 2001
Experience
Database Administrator
(INFORMATICA) @ ALLMERICA FINANCIAL CORPORATION
Add: 440 Lincoln Street, Worcester, Massachusetts 01653
From 05/01
- till date
Responsibilities: Managing the global repositories running on Oracle using Power Mart
4.5.1, 4.7, 5.1, an ETL Tool (Extraction Transformation and Loading).
Duties involve
i Consolidation, cleansing, transformation, and customization of data as per the
outlined business rules.
i Integration of operational and analytical resources
i Centralized management of distributed resources
Trillium Software:
Duties involve
i Run the Trillium Batch Process for name and address matching and/or householding.
i Process the data in a batch environment.
i Write/modify the scripts which call the Trillium modules.
i Conduct unit testing, system testing, data auditing, checklist adherence and
validation and customer specific business rule auditing and validation.
i Use the Trillium-PowerMart Plug in Tool to cleanse the data.
System Analyst
(Oracle Database Architect) @ Netline Web Services.
Add: # 5, Roy Mansion, Aaram Society Road, Vakola, Santacruz (E), Mumbai 400055
From 10/98
04/01
Analysis, design and development of Oracle based applications. Major strengths include
database architecture, data quality assessment, and web-based database development.
Assisting programmers and developers with PL/SQL, and SQL queries. Testing and
installation of Oracle tools.
Projects for NETLINE Web Services
Project: Stock Management Control System
Part of a three-member team. This is an on-line Inventory Data Management Control System
to keep track and maintain the stock in works. System will register all Goods/ Raw
materials that are coming to the stores. Goods Received Note (GRN) will be generated
through the system and Stock Ledger is updated for every transaction. When issues to Sub-
Contractor/Issues to Customer are made, Issue Slip will be generated by the system.
Delivery Challan (DC) is also generated through the system. It also generates various
reports like stock statement, materials lying with sub-contractor; materials ready for
dispatching, Item wise stock statement, Customer wise etc.
Responsibilities involved designing of the database using normalization, coding &
implementation. Item master Maintenance screens with all proper validations. Data entry
screens for add/modify & delete for GRN, Material Issues & Delivery Challan (DC). Interact
with user departments to gather their requirements and design as per the specifications.
Tools: Oracle 8, SQL Plus, PL/SQL, Stored Procedures, DB Triggers.
Project: www.indiaofficeshop.com
Total development team strength was 5. This is an online vertical portal for office
products. The scope included designing of HTML pages, static as well as interactive,
developing animated banners. Database implementation. Designing of shopping cart,
personalized shopping lists, user administration and automated product search engines.
Duties included, implementing the relational capabilities of Oracle RDBMS to manage their
information to be stored in the database. Developing highly parameterized forms and
representing the logical description of the database in the same manner as ordinary data.
Representing complex, relationships involved in office automation products, customer
database, developing full web-based applications which are used to maintain product
information.
Tools: Oracle 8, ASP (Active Server Pages), HTML.
Project: www.navimumbaidoctors.com
Total development strength was 3. Navimumbaidoctors.com is a site for a Non government
organization Navi Mumbai medical services (NMMS) founded by a team of doctors dedicated
to the welfare of the society. The site mainly aims to increase the interaction among the
doctors and the patients. The various functionality links are E-mail, Doctors search,
diagnostic center, hospitals, Blood banks, chemists, register and placements. E-mail
services are also provided on this particular site. The site also provides search for
various doctors, diagnostic centers, hospitals, Blood banks, chemists, various
registration for doctors, Organ/blood donors, Diagnostics centers, Chemists/ Medical
stores, Hospitals, Blood banks. The site also deals with placements of the candidates.
Chat is also incorporated on the site.
Scope included designing the various Web pages. Creating and coding databases. Planning
and implementing the navigational flow of the website and linking different web pages in
an orderly fashion.
Tools: Oracle 8, ASP (Active Server Pages), HTML.
Project: www.pagli.com
Total development team strength was 5. The primary aim of this project was to construct
an online shopping mall to cater to the client's international customers and thus broaden
the customer base, and to provide a complete, customized solution for an online boutique
catering to the Indian ethnic wear and thus reducing the advertising cost. The project
included a customized shopping cart, which was routed through CCNow, the online retailer.
Duties included, designing the database, mapping navigational flow of the site to
encourage easy and efficient transaction in business.
Tools: Oracle 8i, ASP (Active Server Pages), HTML
Project: www.granth.com
Total development team strength was 4. This is an electronic commerce site for a
bookstore incorporating the shopping cart application. The objective was to put up virtual
bookstore on the net similar to amazon.com but on a smaller scale. The site included
exhausted searches, complete automated categorization, and user administration. Developed
centralized planning and reporting application using Oracle 8 for generation of detailed
and statistical reports for management of daily and future planning. Maintained and
analyzed usage statistics. This project was highly profitable and effective for the
company.
Tools: Oracle 8I, ASP (Active Server Pages), HTML
EDP in Charge (Data Management) @ HYUNDAI CONTINENTAL MOTORS
Add: Manorama Chambers, Plot# 34, S.V. Road, Opp. Indian Bank,
Bandra (West), Mumbai - 400050
INDIA
From
01/97
- 10/98
Basic responsibility involved overlooking the functioning of the PCs (including hardware
and software) and reporting the hardware/software anomalies. Also managed Oracle
application Autodeal developed exclusively for Hyundai, India. Primary application
features included registering, invoicing, and billing advice number from the billing
department where it is registered with the relevant data gathered from billing advice file
and passed for registration. The objective of the application was to automate and reduce
data entry time. Various reports such as balance billing, party wise, schedule wise, bill
wise can be generated for any given period. Included a certain amount of SQL querying.
References: Available upon request.
Contact this candidate