SIDDHARTHA cHATTERJEE
#2208, Ground Floor, 17th A Main Road, 5E Cross,
HAL 2nd Stage, Indiranagar, Bangalore - 560008
Mobile: 9341715373, E-Mail:
,
Date of Birth: 6th June, 1979
Field of Expertise:
[A] ‘C’ Programming.
[B] COBOL Programming.
[C] Teradata data warehousing package
[D] Knowledge of DB2 RDBMS package
[C] Structured Query Language (SQL)
[E] Knowledge of connect-direct utility (A FTP tool)
[F] Pro-Cobol programming (Embedded SQL) with
ORACLE
[G] PL/SQL Programming.
[H] Unix Shell Programming (Korn shell in HP-UX +
AIX + NCR-UX + SOLARIS mainly)
[I] Familiarity with Rational Rose tools (Mainly Testing
Tools)
[J] Familiarity with UNIX power tools like
SED/ED/AWK
[K] Working knowledge of PERL
[L] Familiarity with Client Server Programming
Concepts
[M] Working knowledge of ORACLE server 9i
[N] Working knowledge of Query Tuning (ORACLE)
[O] Knowledge of HTML and Javascript.
[P] XML Concepts
[Q] Exposure To Version Control Software Like
PVCS (Primary Version Control Software) and
SVN (SubVersion).
[R] Exposure to financial softwares like
(i) B@NCS-24 (A distributed OLTP software for
Core banking).
(ii) Finance One (A corporate general ledger
package)
Professional Certificates: [1] Basic AIX Certification.
[2] Teradata Basic Certification.
[3] Teradata SQL specialist certification.
I am a teradata certified professional and SQL specialist.
Professional experience: 3 Years 4 months
Educational Qualification: B. Tech in Computer Science and Engineering
Professional Profile
§ ------.
Education
§ B.Tech. : (Computer Science and Engineering) from University Of Kalyani, (IEM Kolkata) in 2002. Secured 75% marks
§ 12th level : From W.B.B.S.E in 1995 scored 82% marks.
§ 10th LEVEL : From W.B.C.H.S.E in1997 scored 76.6% marks
My Current Employer: IBM Global Services India
Employment History : I joined Tata Consultancy Services on 6th October,
2002. I was an Assistant Systems Engineer.
I joined IBM global Services on March 2005.
Project Experience
(During My Employment):
[1] Developing a distributed multi-threaded
UNIX – based banking application for STATE BANK OF INDIA
Functional Domain: Banking
Technology: UNIX, C, COBOL, ORACLE, Shell Scripting, PL/SQL, XML
Duration: 2 years
Client: State Bank Of India
Employer: Tata Consultancy Services
DESCRIPTION: The main purpose of the project was to provide a solution
for state bank of India group (famously known as SBI group). The goal was to
develop one or more than one application which will facilitate the client (State
Bank of India and its seven associate banks) to manage their operations from a
central location and guide the branches. The volume the application was supposed
to support is a staggering figure: 13000 (for 8 banks) of which 3,000 are State
Bank of India branches. The entire solution is divided into three parts: a corporate
General Ledger package, a centralized core banking solutions, a trade finance
application. I have worked in first two packages (mainly core banking solution).
The core banking application is distributed and multi threaded in nature and
runs on HP-UX operating system. The database is ORACLE 9i and the front end
system for the end user is a server mainly based on IIS and windows 2000 server.
The language for the back end is COBOL and C where the language for front end
development involves from HTML, XML, JavaScript and .NET based
technologies. The production system is a HP – SUPERDOME.
Corporate General Ledger package employs same technology at the back end and
at the front end it involves JAVA.
My responsibilities included every phase of project management at various
stages of the development. I have done requirement collection, design, coding,
testing and deployment for various functionalities. The technical assignments
required the technical skills that I have described in COMPUTER SKILLS
section. The responsibilities that I completed are:
(i) Inventory system of the bank (Total Development)
(ii) Entire cheque clearing system. (Total Development)
(iii) Entire remittance processing system (Total Development)
(iv) Entire standing instruction processing system (Total Development)
(v) Dividend warrant processing system (Total Development)
(vi) Service branch package (Partial Development)
(vii) Batch transaction processing system (Design)
(viii) Business Process Reengineering of cheque collection system. (Design)
(ix) A part of the Business Process Reengineering team.
(x) A member of the performance measurement and optimization team. I am also part of the team which
monitors change in core system architecture for the project.
[2] Enhancement and maintenance of AT&T Business Services
Data Ware Housing
Functional Domain: Data Warehousing (Sales Data)
Technology: UNIX, Teradata, Shell Scripting, WebSphere, Crystal report and
Cold Fusion
Duration: 10 months
Client: AT&T Corporation
Employer: IBM Global Services (India)
DESCRIPTION: In this assignment, I was a part of the team that is
responsible for maintaining and enhancing a datawarehousing application of
AT&T corporation (currently owned by SBC corporation). This application is built
to assist the sales and marketing division in making decisions. The application
takes data feeds from various operational data stores, gather the data together and
represent the summarized and detail data with the web based interface. The ETL
server used in the procedure is made of shell scripts and C programs (NCR Unix).
The web interface is custom built with cold fusion, MPI and websphere. The same
system has an interface with NCR TCRM software with which I have some
familiarity.