BISWAJIT PAUL
·
Over 12 years of experience in design and development
of information systems for various commercial / Data Warehousing applications (7 years of experience in US)
·
7 years extensive expertise in
designing, coding and testing of Data Warehousing applications using ETL tool
DataStage / Parallel Extender 7.5, Ascential 7.5/6.0,
·
Experience in ORACLE RDBMS 8.x, IBM
DB2, Teradata, UNIX (HP, AIX, SCO), Unix Shell scripts, Introduction to
Informatica (PowerCenter 5.0) and Cognos V 7.0, Autosys scheduling tool.
·
Excellent analytical, logical and
programming skills
·
Capacity for Work - Meeting Deadlines
·
Diagnostic Ability - Ability to go to
the core of the problem
·
Expertise in Trouble shooting the
problems
·
Willing to learn and adaptable to new
challenges, self-motivated, a quick learner and team player.
·
Excellent communication skills, with
ability to interact with end-users, managers, and technical personnel
successfully
·
MCA - Masters in Computer Applications,
from Jorhat Engineering College, India
(Awarded
National Merit Scholarship)
·
Data Warehousing, ETL Tool DataStage /
Ascential
·
Oracle Developer 2000 Training in STG,
Delhi
EXPERIENCE
State Street Bank, Boston, MA
DataStage Analyst
March 2005 to Present
EDW
/ Crystal Conversion:
State Street is the world's leading provider of services to
institutional investors. Their clients are some of the world's most
sophisticated and influential investors and have a broad array of complex and
specialized servicing requirements. They offer three core capabilities -
investment servicing, investment management and investment research and trading
- that can be used independently or together to boost clients' business
strategies
Responsibilities
·
Working in Data
Warehouse project EDW and Crystal to IBM Ascential Conversion.
·
Involved in
designing, implementing and developing processes
·
Applying
expertise in process skills from Meta Data design, Data Mapping,
·
Physical
design, Coding, deployment in a full SDLC environment.
·
Decoding
Crystal Info reports and converting them to IBM Ascential Parallel jobs.
·
Writing AutoSys
JILs to schedule jobs.
Environment: IBM
DataStage, Parallel Extender 7.5, DB2, Unix Shell
Script, Crystal Info (Report Designer, Query Designer), AutoSys (Job Scheduling
tool)
Anheuser Busch Companies, St. Louis, MO
ETL Consultant
December 2003 to Jan 2005
Enterprise Data Warehouse-BUDNET Remediation:
Anheuser-Busch's operations and resources are focused on beer, adventure park
entertainment and packaging. Anheuser-Busch also has interests in aluminum
beverage container recycling, malt production, rice milling, real estate
development, turf farming, metalized paper label printing and transportation
services.
Anheuser Busch has
Enterprise Data Warehouse on top of Teradata. To improve the performance, team
is responsible for remediating from Star schema to Normilised ER model. Worked for Wipro Technologies.
Responsibilities
·
Design and
Architecture, Standards and Guidelines for ETL, and Data Extract Strategy.
·
Used DataStage Manager to create
metadata repository.
·
Responsible for Design, Review and
Testing of ETL jobs using DataStage Ver 6.0.1 to extract data from the source
systems and load to the target.
·
Coordinate with offshore group.
·
Unit Testing and System Testing.
JPMorgan Chase, NY, NY
ETL Consultant
April 2002 to December 2003
JPMC DATA WAREHOUSING: JPMorgan
Chase is a major participant in the strongest, most vibrant capital markets in
the world, operating across various businesses and geographies. They are
leading global financial services firm with assets of $742 billion. The firm is
a component of the Dow Jones Industrial Average. Major functional areas of
JPMorgan are Investment Bank, Research, Private Equity, Investment Management,
Private Banking, Treasury and Securities Services and Middle Market.
Worked for Syntel India.
Responsibilities
·
Implementation
Architecture, Standards and Guidelines for ETL, and Data Exchange Strategy for
JPMorgan Chase Data warehousing.
·
Designed the data warehouse using Star
Schema approach.
·
Responsible for Coding, Review and
Testing of ETL jobs using DataStage Ver 5.2. to transfer the data from the
source systems to Data warehouse.
·
Involved in backend programming using
SQL, PL/SQL and Tuning
·
Used administrative version of Cognos
to create Catalogs, Impromptu reports.
Suntory Water Group, Atlanta, GA, through H2ORACLE
Datastage / Ascential Designer / Administrator
August 2001 to March 2002
Suntory Water Group
is a Spring Water Company. Their business is to deliver drinking water. The
operating unit, which delivers water at doorstep, is known as DIRECT DELIVERY.
The other unit, RETAIL, delivers water to the retail stores.
Responsibilities
·
Collection of user requirement,
understanding business rules strategies and standards.
·
Design and Development of customized
modules.
·
Used DataStage Manager to create
metadata repository.
·
Created the schema objects, dimensions
and fact tables for the data warehouse schema.
·
Used DataStage/Ascential Designer 4.1
for designing jobs for data warehouse.
·
Development using PL/SQL, (Database
triggers, Procedures, Functions, Views, Sequences, and Synonyms).
·
Used administrative version and user
version of Discoverer to create reports to be accessed by end user layer.
·
System Implementation testing.
Eli Lilly, Morristown, NJ, USA
Datastage / ETL Developer
June 1998 to July 2001
Lilly US Interface / Data Scrubbing for ETMS (Electronic
Territory Mgmt System): These are highly data intensive
Projects capturing pharmaceutical sales representative’s data (which are
maintained on Laptops and other hand held devices) to an operational database
and from there, the data is further pushed to the data warehouse and finally
from there to the respective Data Marts. Transferring of data was done through
flat files via ftp. There is a regular exchange of data between the Laptop and
the centralized database at base. Some of the third party data through flat
file was also been exchanged at a regular basis. This data is pushed to the
data warehouse using DataStage/ Ascential 4.1. These Projects are part of
Dendrite’s on going initiative to provide a wide range of sales force effectiveness
solutions to nearly 10,000 pharmaceutical sales representatives worldwide.
As a part of
Database management for the project of Data Scrubbing, responsible for database
modeling, tablespace designing, creation of users and roles, writing scripts for
database administration (backup, recovery) and application tuning.
Responsibilities
·
Writing PL/SQL code for Packages,
subprograms, database triggers.
·
Performance optimization of SQL
queries.
·
Writing shell script for automating the
ETL (extract-transformation-load) processes.
·
Design and Development of the
Application Architecture for the new system.
·
Install and administer Ascential
DataStage/ Universe database.
·
Creating DataStage jobs for Extract of
data from the database tables into flat files and loading data in flat files to
database tables.
·
Create and maintain Metadata and
Version Control.
·
Monitoring the ETL process through
Datastage’s director log.
·
Performing and fine-tuning of the
database and user related statements/programs.
·
Used analyze table, Explain plan
utility for performance and optimization.
·
Developing and managing consistent
database Environments that are flexible, reliable and facilitate application
development, data delivery and data management.
·
Database size estimation for future
needs and upgrades.
·
Optimization and performance tuning of
the database.
·
Actively monitoring the changes to the
DB Environment to increase efficiency, improve reliability and minimize
operating expenses.
·
Designing and reviewing the Backup and
Restore procedures.
New York State Senate, ALBANY, NY USA
Programmer / Analyst
July 1997 to June 1998
New York State Senate Financial Mgmt System:
The SASS caters to the administrative needs of the New York State Senate. It
supports departments viz. Accounts Payable, Purchasing, Payroll/Personnel, etc.
The project required conversion of the Financial Management System from Ingress
on VAX to Oracle 8 and Developer/2000 (Forms and Reports).
Responsibilities
·
As a Programmer / Analyst, migrated
Financial Management System for New York State Senate Administrative Support
Services (SASS) for New York Senate, Albany, NY.
·
Formulation of Migration Strategies and
Standards.
·
Design and Development of the
Application Architecture for the new system
·
Perform DBA activities
·
Development using Forms 5.0 and Reports
3.0
·
Provide Training to Client on Oracle 8
and Developer/2000
·
System Implementation
Ministry of Finance, CGA, India
Systems Analyst
November 1996 to June 1997
ACMS -Civil Accounts Cadre Management System: This
user-friendly package provides information about officers in a government
office. It keeps track of personnel details, training undertaken, place of
posting, security, leave, gratuity, and welfare of officers. Details of
confidential reports of officers are kept encrypted in tables to ensure secrecy
and confidentiality. Application-level security is also provided to ensure
access to data only to authorized persons.
·
As a Systems Analyst, developed a Civil
Accounts Cadre Management System (CACMS), for Controller General of Accounts.
·
Interviewing users, collecting user
requirements
·
Identifying basic functions, analyzing
the present system
·
Design and Development of the
Application Architecture for the new system
·
Designer/2000 (ERD, FHD, MSD, MD, DD)
for designing and documenting the system
·
Designer-generated forms and reports
were finalized using Developer/2000
·
Development using Forms 4.5 and Reports
2.5
·
Provide Training to Client on Oracle 7
and Developer/2000
·
Installed Oracle Designer/2000
repository on the server and Designer/2000 on the client.
·
Created users, granted privileges,
maintained roles, performed backups (Export/Import), and tuned Oracle
·
System Implementation
Ministry of Finance, CGA, India
Systems Analyst
October 1995 to October 1996
·
As a Systems Analyst, developed
Government Accounts Information Systems
·
Tuned UNIX, rebuild KERNEL
·
Installed Oracle and upgraded the
application (including SQL*Forms 3.0 to 4.5)
·
Introduced a new module for quick query
on specific heads of accounts, depending on search criteria. Used Developer/2000
(Forms 4.5 and Reports 2.5)
·
Reconstructed Oracle database to
minimize disk fragmentation and improve performance and response time. Took
cold as well as export backup of Database
·
Enhanced and generated complex reports
using Pro*C
·
Monitored the performance of Oracle and
tuned it. Also tuned application and Unix OS
·
Developed input and output forms with
Forms 4.5
·
Generated new reports using Reports 2.5
·
Developed a new menu using Forms 4.5
·
System Implementation
Bank of Baroda, Bank of Madura, Panjab
National Bank, India
DBA / Programmer Analyst
March 1995 to October 1995
·
Tuned and rebuild the KERNEL of HP-UX
·
Installed Oracle and ISBS
·
Migrated existing data to Oracle using
SQL*Loader
·
Modified/ enhanced programs, changed
the database schema
·
Trained DBAs for performing backups
·
Reconstructed the database to reduce
disk fragmentation, and improved performance and response time
·
Installed Oracle 6.0 and 7.1 and
installed ISBS
·
Eliminated errors modified and enhanced
codes, tuned application, performed troubleshooting