Manager Developer
Resume:
SAIKAT DAS
PROFILE
* ***** ** ******* ** experience
* ***** ** *** ********** (Oracle, Datastage, Informatica, Ab-Initio)
* ***** ** ***** (Oracle 9i/10g, SQL Server, DB2) experience
* ***** ** Oracle Developer (2000/6i) experience
4 years of Data Warehouse System Designing and Data Modeling experience
SUMMARY
Seven years of IT experience in various phases of Software Projects (Business Requirement Gathering, System
o
Analysis, System Design, Coding, Testing & QA, and Implementation), and with different Software Development
Lifecycle Models (Waterfall, Agile) on Windows and Unix Platforms, for Investment Banking, Financial, Retail, and
Telecom Industries.
Seven Plus Years of IT experience as a Data Warehouse/Data Mart/ETL Developer using various ETL tools like using
o
Informatica 8.1/7.1 Repository Manager, Designer (Source Analyzer, Transformations, Mapplets, Worklets), Workflow
Manager, and Workflow Monitor, DataStage 7.5 (Parallel and Server Jobs) using the components Administrator,
Designer, Manager, and Director.
Extensive experience in tuning Informatica Mappings/Sessions/Workflows (using various components like parameter
o
files, variables and caches like Static, Dynamic, Shared, Persistent) and Datastage Jobs for optimum performance.
Working experience in Extraction, Transformation and Load (ETL) of data from Legacy/Mainframe Systems.
o
Over Seven Years of RDBMS experience using Oracle 10g/9i/8i, IBM DB2 UDB, DB2 8.0/7.0, MS SQL Server
o
2005/2000, MS Access 2000, SQL (DQL, DML, DDL, TCL), PL/SQL (Stored Procedure, Function, Package, Trigger,
Bulk Load, Autonomous Transaction, Exception Handling), XML, XSL, SQL*Loader, Oracle 10g Data Pump, and SQL
Editor (SQL*Plus, TOAD).
Seven plus years of experience as a Developer, Designer, Data Modeler using Oracle RDBMS 9i/10g, MS SQL Server
o
2000/2005, UDB DB2.
5 years of experience in performing Data Modeling tasks primarily dealing with Relational Data Models, Dimensional
o
Data Models (Star Join Schema, Snowflake Schema, Facts & Dimensions tables, Slowly Changing Dimension),
Physical & Logical Data Modeling, OLTP, and OLAP.
Experienced in writing UNIX shell scripts for executing and maintaining database activities, and managing Informatica
o
pre & post session operations.
Experienced in automation of jobs using scheduling tool Argent, and Autosys.
o
Extensive experience as a BI Developer using Reporting Tools Oracle Reports, Crystal reports.
o
Implemented the slowly changing dimensions in data warehouse.
o
Provided Production support, performed Document reviews, Test Case execution at Unit level and Integration level,
o
prepared Technical design document, Implementation plan, Promotion document and design document.
Performed drill analysis which will allow the user to view data at a more detail level, and generated Master/Detail,
o
Master/Cross, Chart, Subtype reports as and when required.
A team player with a responsibility oriented strategy at work place and an ability to learn, adapt and implement new
o
skills.
Effective in cross-functional and able in managing multiple tasks & assignments concurrently.
o
Highly organized and detail-oriented professional with strong business and technical skills.
o
Excellent inter-personal and communication skills and ability to work independently as well as in a team.
o
TECHNICAL SKILLS
RDMS/DBMS : Oracle 10g, Oracle 9i, MS SQL Server 2000, MS Access 2000, MySQL
BI Tools : Oracle Reports 6i, Crystal Reports
ETL Tools : Informatica PowerCenter Version 7 & 8 (Repository Manager, Mapping Designer, Workflow
Designer, and Workflow Manager), IBM WebSphere Datastage 7.1 (Designer, Director,
Manager and Administrator), AbInitio GDE v1.13, Pentaho Data Integration, DTS, SISS.
Programming Languages : PL/SQL, SQL, Transact-SQL, C, C++, Java, XML.
DB Tools : SQL*Loader, Data Pump
GUI : Oracle Forms 6i
Operating Systems : Windows NT/2000, UNIX, MS-DOS, Linux 8
Web Technologies : HTML, Java Script, VB Script, ASP, PHP
Version Control Tools : Visual Source Safe 5.0
General Tools : TOAD, Ultra Edit, Putty, Psftp.
Mail Client : IBM Lotus Notes Ver. 7/8, MS Outlook
TRAINING
IBM WebSphere Data Stage 7.1.1 (Designer, Director, Manager, Administrator)
o
Informatica PowerCenter Version 7(Repository Manager, Mapping Designer, Workflow Designer, and Workflow
o
Manager)
Page 1 of 6
SAIKAT DAS
(C) 856-***-****
******.***@*******.***
PROFESSIONAL EXPERIENCE
State Street Corporation, Boston, MA Feb ’08 – Mar ’09
Position: ETL/ DataStage Developer
Project : Derivatives Look through Processing
Involved primarily as a ETL Developer in the Design and Development of processes to handle Derivatives data
received daily by the Mutual Fund Administration.
Project : Process Integration of IBT and State Street Corporation
Involved primarily as a ETL Developer in Process Integration efforts between State Street Back Bay (formerly
Investors Bank & Trust) Legacy FACTS System and State Street Corporation System.
Project : Mutual Fund Administration
Process Mutual Fund data received daily (Fixed Length Data Files for General Ledger, Fund NAV, and Holdings)
from vendors, to perform Fund and Account Level Balance Processing and load into the appropriate table,
meeting client fixed SLA’s.
Achievements:
Interacted with the Business Users to analyze the business requirements and transform the business
o
requirements into the technical requirements.
Developer data models, created source to target mappings and technical specifications for the development
o
of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
Design and Developed Informatica Workflows.
o
Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of
o
project from development to testing environment and then to production environment.
Designed and Developed Oracle PL/SQL Package for initial loading and processing of Derivative Data.
o
Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer,
o
Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
Developed mapplets and worklets for reusability.
o
Implemented weekly error tracking and correction process using Informatica.
o
Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting
o
perspectives.
Designing and creation of complex mappings using SCD type II involving transformations such as expression,
o
joiner, aggregator, lookup, update strategy, and filter.
Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented
o
effective transformation Logic.
Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and
o
Unconnected Stored Procedure Transformations.
Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are
o
accurate, which was extracted from different source systems according to the user requirements.
Preparing and using test data/cases to verify accuracy and completeness of ETL process.
o
Actively involved in the Production support and also transferred knowledge to the other team members.
o
Performed Unit Testing, and QA of all developed objects.
o
Assist in User Acceptance Testing.
o
Environment: Informatica PowerCenter Version 7.1.4 (Repository Manager, Mapping Designer, IBM WebSphere
DataStage v7 Workflow Designer, and Workflow Manager), Oracle 8i/10g, SQL, PL/SQL, MS SQL
server 2005, UNIX, DDL/DML/DCL Scripts, MS Windows, TOAD, Citrix.
Page 2 of 6
SAIKAT DAS
(C) 856-***-****
******.***@*******.***
Innovatech Solutions, Inc., Crystal City, VA Jun ’07 – Feb ’08
Position: ETL/ Data Warehouse Developer
Project: USPTO Enterprise Data Warehouse (EDW)
The EDW serves as the cross-functional reporting system for USPTO, and approximately 90% of the reports
used to support financial management are generated using it. This infrastructure allows creation of Digital
Dashboards, executive information snapshots, template portal pages, Cascading Style Sheets, and hierarchical
categories that leverage role-based security.
Achievements:
Analyzed Source Data coming from various sources (Flat File, XML, Database Tables) and working in tandem
o
with Business Users and other team members in developing the Developmental Model.
Involved in Dimensional modeling to Design and develop STAR Schema, Fact and Dimension Tables.
o
Created source to target mappings
o
Extracted, Transformed and Loaded OLTP and OLAP data into the Staging area and Data Warehouse Tables
o
using Informatica Mappings and Complex Transformations (Aggregator, Joiner, Lookup (Connected &
Unconnected), Source Qualifier, Filter, Update Strategy, Stored Procedure, Router, and Expression).
Designed and Developed complex Informatica Mappings, Reusable Components (Mapplets, Transformations)
o
for different types Information Sources and Monthly/Yearly Loading of Data.
Used Workflow Manager for Workflow and Session Management, database connection management and
o
Scheduling of jobs to be run in the batch process.
Modified Existing Workflows and Mappings, tested Stored Procedures and Functions, performed Unit and
o
Integration Testing of Informatica Sessions, Batches and Target Data.
Extracted data from various sources like IMS Data Flat Files and Oracle.
o
Created reusable transformations and reusable Mapplets for use in Mappings.
o
Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
o
Created Sessions and Batches in Workflow Manager and Scheduled the batches and sessions at specified
o
frequency.
Coded UNIX Shell Scripts for Informatica Pre-Session, Post-Session Management.
o
Monitored Informatica Workflow using Workflow Monitor.
o
Used Oracle 10g Data Pump and SQL * Loader for Bulk loading of Source Data.
o
Created Stored Procedures for Data Transformation purpose, and used MERGE statement for initial data
o
loading.
Used Stored Procedures to create a standard Time dimension, drop and create indexes before and after
o
loading data into the targets.
Identified and removed bottlenecks at source level, transformation level, and target level for the optimum
o
usage of sources, transformations and target loads.
Created mechanism to capture and log data load errors, and initiated correctional measures to load into
o
target system.
Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
o
Implemented efficient and effective performance tuning procedures, Performed benchmarking, and these
o
sessions were used to set a baseline to measure improvements against.
Tuned Source System and Target System based on performance details, when source and target were
o
optimized, sessions were run again to determine the impact of changes.
Environment: Informatica PowerCenter v7 (Repository Manager, Mapping Designer, Workflow Designer, and
Workflow Manager), Oracle 10g, SQL, PL/SQL, DDL/DML/DCL Scripts, HP Unix, Shell Scripts, vi
editor, Ultra Edit, Putty, Psftp, TOAD, Citrix.
Page 3 of 6
SAIKAT DAS
(C) 856-***-****
******.***@*******.***
IBM Global Services Aug ’05 – May ’07
Position: Software Developer
Project : AOL
Enterprise Data Warehouse (EDW) was developed to improve customer analytics, product performance
management, and click stream analysis. The scope of the project includes the high level of design, detail
technical design, development of AbInitio graphs, development of AutoSys scripts for job scheduling and testing
(test strategy & test case preparation, code review, string testing, integration testing and regression testing).
Achievements:
Member of Enterprise Application Business Intelligence Service.
o
Developed and support the extraction, transformation and load process (ETL) using AbInitio GDE, fed with
o
flat files generated from legacy systems.
Attended several business sessions with the clients, and modified AbInitio Graph Designs as per business
o
requirements.
Created Database Configuration files (.dbc)
o
Generated Table Configuration files (.cfg)
o
Experienced in using Unix vi editor.
o
Involved in performance tuning and monitoring queries, procedures for the maximum efficiency in various
o
schemas across databases using Oracle Hints, explain plans and Trace sessions for Cost based and Rule
based Optimization.
Sourced the data from Oracle Tables and flat files and populated the high volume of complex data into
o
Redbrick.
Production Support for various modules developed.
o
Perform Secondary Administration of Enterprise Meta Environment (EME) for configuration management.
o
Environment: AbInitio (GDE) v1.13, AbInitio Co-Operating system v2.13, Netezza Performance Server, Oracle
9i, SQL, PL/SQL, TOAD, Citrix, Windows 2000 Professional, Lotus notes mail client.
Project : Lenovo – Global Sales Data Migration Mar ’06 – Sep ’06
Lenovo data migration project involved the migration of proprietary and historical sales data with IBM Personal
Computing Division to specified formats in Lenovo sales system, required for the analysis of their sales and for
sales forecasting.
Achievements:
Prepare Technical Specification.
o
Developer data models and created source to target mappings.
o
Design and Develop DataStage maps, developed using Datastage Designer, to extract, transform, integrate,
o
and load data into Data Warehouse.
Use Datastage Manager to import Metadata from legacy repository, and create new job categories and data
o
elements.
Mapped extremely complicated proprietary sales data formats.
o
Design and implementation of Server and Parallel jobs including Batches and Job Sequencers.
o
Used Hashed File look-ups for improved performance.
o
Perform complex Inner, Outer and Full Joins using Datastage maps.
o
Used Sequencer extensively to sequence jobs.
o
Extensively used Job Parameters and Job Control to sequence jobs.
o
Used Link Partitioner and Link Collector to enhance the performance of some Jobs.
o
Environment: IBM WebSphere Datastage 7.1, Oracle 10g, Oracle SQL, PL/SQL, PERL, TOAD, Ultra Edit, MS
Visual Source Safe 6.0, Windows 2000 Professional.
Project : TESCO UK - Stock Record System (SRS) Aug ’05 – Feb ’06
The Stock Record System (SRS) solution deals with the retailing services of Tesco, and provides accurate and
timely tracking of profitability at Department and SKU level, and integration of operational and financial
management data. The technical solution comprised of ETL Interfaces using AbInitio, Business Components
(Bespoke Components) using PL/SQL, and Reports using Oracle Reports 6i.
Achievements:
Page 4 of 6
SAIKAT DAS
(C) 856-***-****
******.***@*******.***
Prepare Technical Specification.
o
Develop ETL Application using Oracle Packages, Stored Procedure, Function, Triggers, using PL/SQL in Oracle
o
9i database.
Develop Oracle database triggers and event triggers to perform many initial setups for the users and
o
automatic data propagation.
Experienced in handling large size (terabyte range) databases.
o
Conduct Performance Testing on all SQL used in the applications, perform tuning as per DBA suggestion.
o
Involved in tuning of Oracle Stored Procedures.
o
Preparing Unit Test Plans and performing Unit Tests.
o
Defect / Change Request analysis and implementation.
o
Perform debug and fixed PL/SQL code modules for applications.
o
Design and Develop AbInitio Graphs to load data in Staging Tables from Legacy System.
o
Design and Develop Reports using Oracle Reports 9i.
o
Adopting SOA to deliver the business agility and IT flexibility of their web based system.
o
Used many advance features of PL/SQL in server-side code modules (e.g., Autonomous Transaction, Nested
o
Tables and Native Dynamic SQL).
Document the processes and Update Deliveries in SDMS and VSS, Release and Baseline.
o
Extract and document all server side PL/SQL objects into PVCS VSS for better development effort.
o
Environment: Oracle 9i RDBMS, SQL, PL/SQL, AbInitio 1.13.1, Oracle Developer 9i, DDL/DML/DCL Scripts,
PL/SQL, SQL, Pro*C, Java, PERL, TOAD, Ultra Edit, MS Visual Source Safe 6.0, Citrix, Windows
2000 Professional.
Delphinus Engineering, Inc., Philadelphia, PA Sep ’04 – Aug ’05
(Overseas Clients Delivery Centre, Kolkata, India)
Position: Application Developer
Project : Time Card Program
Required to track & maintain records of day-to-day activities of employees, including daily attendance, leave,
short breaks. It is also equipped to handle salary and incentives calculations, and various time bound report
preparation. The interfaces was developed using Oracle Forms 6i, the business components using PL/SQL, and
reports using Oracle Report 6i, generating HTML output.
Achievements:
Perform System analysis, and develop Functional and Technical Specifications.
o
Developed Oracle Packages (Procedures and Functions), Triggers in Oracle 9i.
o
Developed Oracle database triggers and event triggers to perform many initial setups for the users and
o
automatic data propagation.
Debug and fix PL/SQL code modules for applications specifically in the OA Interface system (Financial
o
Interface System).
Developed GUI using Oracle Forms6i.
o
Developed organizational reports using Oracle Reports 6i.
o
Conducted Performance Tests and tuning on all SQL used in the applications.
o
Involved in tuning of Oracle Stored Procedures and Functions.
o
Prepared Unit Test Plans and performed Unit Testing.
o
Involved in analyzing Defects and Change Requests, and do necessary modifications.
o
Environment: Oracle Developer 6i Suite (Forms 6i and Reports 6i), ORACLE 9i RDBMS, Oracle Application
Server, MS Windows 2000 Server.
Project : Business Control System
Business Control System was developed to provide with tools for maintaining business parity and work
synchronization among different work sites and offices. It is also capable of generating a host of reports
including progress of work, cost estimation, resource location, resource allocation, and resource management.
Achievements:
Performed System analysis and prepared Functional and Technical Specifications.
o
Developed Complex Forms and Reports using Developer 6i.
o
Page 5 of 6
SAIKAT DAS
(C) 856-***-****
******.***@*******.***
Developed Procedures, Functions, Triggers and Packages in PL/SQL with Oracle 9i as the database.
o
Performed Unit Testing.
o
Developed the business components and Interfaces.
o
Environment: Oracle Developer 6i Suite (Forms 6i and Reports 6i), ORACLE 9i RDBMS, Oracle Application
Server, PL/SQL, SQL, Pro*C, Java, MS Windows 2000 Server.
Project : Content Management System
It incorporates the open source Content Management System CMS (http://cms.sourceforge.net/). This Perl-
based groupware application allows a group of persons to share documents via a web interface. Components
taken from Horde (www.horde.org) and integrated with it are IMP (a web based email system), and password,
which allow the user to manage his/her own password. It have an icon in IMP that when clicked brings one to
the CMS site and is integrated so that the same username and password is effective in both systems allowing a
single sign on through the Horde framework.
Achievements:
Performed System Analysis and Requirement gathering.
o
Developed Functional and Technical Specifications.
o
Designed and Developed the system, and developed the business components and Interfaces.
o
Integrated the Horde Framework.
o
Integrated the IMP Webmail Client, to provide webmail access to IMAP and POP3 accounts.
o
Designing and developing web based user interfaces, and server side components with PHP 4.
o
Created client side validations using JavaScript.
o
Created Oracle tables, indexes, views, and cursors.
o
Performed Unit Testing.
o
Environment: MySQL 4.0.3-beta, PHP4 & JavaScript, PERL, Linux 8.
SYSCOM, Kolkata, India Aug ’03 – Aug ’04
Position: Application Developer
Project : IMPACT
IMPACT enabled the Directorate of Commercial Taxes, west Bengal, India to automate its earlier auto-manual
system of functioning, and to migrate to the Value Added Tax (VAT) system. The three-tier Software Architecture
model comprising an Oracle 9i database and an Application Server running on Oracle9iAS. The clients run through
HTML browser. The architecture provides authenticated and authorized access to this central database from any
node in it’s dedicated WAN which connects all its regional locations across West Bengal, as also through a web
portal. The Interfaces are developed using Oracle Forms 6i, the business components using PL/SQL, and reports
using Oracle Report 6i.
Achievements:
Involved in designing Oracle Stored Procedures to retrieve data from several sources to the Data
o
Warehouse.
Created Oracle tables, indexes, views for initial setup.
o
Designed and Developed system components using Oracle 6i Developer Suite (Forms 6i & Reports 6i) in
o
Oracle 9i RDBMS.
Created triggers for automated data propagation and status updates.
o
Developed Oracle Stored Procedures to perform ETL operation on database.
o
Developed process to load data from offline sources using SQL*Loader.
o
Developed Unix Shell scripts to automate file manipulation and data loading procedures.
o
Documented the Forms and Reports development.
o
Developed GUI to generate Reports as per business need.
o
Environment: Oracle 9i RDBMS, Oracle Application Server, Oracle Developer Suite (Forms6i/Report6i), PL/SQL,
SQL, Pro*C, Java, SQL*Loader.
EDUCATION
B.S. in Mathematics Calcutta University, Kolkata, West Bengal, India.
o
M.S. in Computer Applications Vidyasagar University, West Bengal, India.
o
Page 6 of 6
Contact this candidate