MRINAL HAZARIKA

** ****** ***. *******, ** *****

Cell: 203-***-****

ab8zx5@r.postjobfree.com

OBJECTIVE Position as a senior database developer/Architect/application DBA or team lead

in an IT department of any Industry in which my knowledge of system analysis,

database design, coding, testing, implementation and offshore team

management skills can be utilized in achieving organization’s goal.

•

SUMMARY Overall 10+ years of experience in the Software Industry as an application

Developer/DBA/Analyst/Architect with extensive experience in Oracle,

PL/SQL, Shell Scripts, SQL Server, T-SQL, MySQL, Sybase, DB2, Perl and

Unix shell scripting

• Extensive experience in System Analysis, Logical and Physical data modeling,

Database Design, Data warehouse design, Coding, Testing, Implementation and

Configuration Management

• Experience developing interfaces to Oracle or other SQL-based databases in

OLTP and OLAP processing

• Experience PL/SQL, ETL processing

• Extensive experience in heterogeneous data extraction and load

• Excellent SQL & database-level performance tuning skills

• Experience with platform migration and/or data conversion.

• Experience and knowledge of Portfolio management, Asset Management

• Basic Knowledge of finance, fixed income securities and derivatives

• Experienced in Eagle Pace portfolio management

• Knowledge of Agile software development methods

• Thorough understanding of backup, recovery and cloning using

R MAN, data pump and export/import. Experience with Oracle

E nterprise Manager Grid Control.

• Ability to write and maintain SQL and shell scripts as necessary to

support database operations

• Extensive software development experience in Banking, Portfolio

management, Regulatory control, Hospital, Pharmacy, HR,

I nventory and Telecom area

• Experienced working in a team environment including

offshore/onsite model

SOFTWARE Oracle 8i/9i/10g/11g, SQL-Server 2005, D B2 UDB, PL/SQL, C,

C++, COBOL,Basic, Pascal, UN IX Shell Scripting, Perl, Eagle

Pace, Eagle Star, JDK 1.2, JDBC, Developer/2000,

Designer/2000,

Linux, Sun Solaris, HP-UX 9.0, HI-UX, SCO UNIX, AIX, Windows

O/S

95/2000/NT

Mrinal…1/4

TOOLS Toad, PL/SQL Developer, DbArtisan, Informatica, Datastage, Autosys,

JIRA, Sharepoint, Erwin,Visio 2003, Toad Data Modeler, TortoiseSVN,

Clearcase, OEM, AWR, ADDM.

EXPERIENCE UBS, Stamford, CT, US

SCP (Supervisory Control Portal)

Aug 2008 to till date

My role includes

• Design solutions using oracle analytical functions, pipelined functions,

autonomous transactions, forall, PL/SQL table, bulk collection,

materialized views, packages, procedure, overriding procedures,

function, nocopy compiler, utl_smtp, xml functions etc.

• Design and develop analytical solution for Supervisory control project using

PL/SQL

• Debugging package/procedures and providing solutions to production issues

• Build Shell scripts using gerp, sed,awk etc to call from Autosys jobs

• Handling a database migration project including study the dependencies,

complexity, risk and advantage of that project

• Develop a data migration plan, create tasks and work with offshore team

• Prepare specification, test cases and release documents

• Perform unit, Integration and post implementation testing and collect

test evidence

• Perform database application tuning

UBS, Stamford, CT, US

TGRS (Tracking Global registration System)

Nov 2004 to July 2008

• Designed and developed oracle solutions for Registration System using

PL/SQL

• Tuned SQL and application, rebuilt tables, constraints, views,

materialized views, indexes etc.

• Configured DEV and UAT databases, provided size and naming

conventions for data tablespaces, Index table space, temporary

tablespaces

• Built Unix scripts using gerp, sed,awk etc.

• Reviewed functional specification document

• Performed root cause analysis and fixed production bugs

• Performed unit and integration testing

• Prepared release documents

• Coordinated with team members on issue resolution

Eagle Investment System. Newton, MA, USA

Eagle Pace and PT Plus

Dec 2000 to Nov 2004

Eagle Pace is a portfolio management system and PT Plus stands for

Partnership transactions.

• Designd and developd customized solution for clients using

ORACLE, SQLSEVER, SYSBASE to adopt Eagle pace

2

• Created database and database objects like tables, Indexes, views,

sequences, Synonyms, pl/sql tables, package, procedures, functions

etc.

• Built package procedure functions for PT plus using ORACLE/SQL-

SERVER

• Performed database backups and restore

• Tuned Oracle, Sql Server or Sybase application

• Performed quality testing

• Performed production releases

• Built PERL script to extract and load data from pipe/comma delimited

feed file using DBI and DBD interface

• Managed User accounts and access privileges

• Scheduled jobs for data loading and processing

Hitachi Ltd., Japan

DCE (Distributed Computing Environment)

PATNI Computer Systems Ltd.

SEEPZ, Mumbai, India.

October 1999 – December 2000

DCE was an integrated suite of components like threads, Remote

Procedure Call, Security, Directory services, time synchronization services

and Distributed File System. Scope of the project was to port OSF/DCE

1.2.2 core components to HI-UX/MPP (Hitachi Unix / Massively Parallel

Processors) for SR8000 system (Hitachi's super technical server).

• Created Program Checklist and Functional Specification for

Administration, Security and Remote Procedure Call APIs

• Performed analysis of source code dependencies

• Built process in C

• Reviewed FS, PCS and Test code

• Prepared porting Architecture documents (PAD)

• Ported the source code onto HI-UX

• Performed configuration management

Department of Telecommunications

Telecom Revenue Accounting System (TRA)

Fault Reporting and Monitoring System

June 1997 – June 1999

TRA package was built to automate billing and accounting system of all

telecom districts in North East India.

• Installed Unix and, Oracle database

• Created database and database objects

• Tuned and administered databases

• Performed backup and recovery

• Built PL/SQL programs for new Forms and Reports using Developer

2000

• Built PL/SQL package procedures functions for billing and accounting

system

• Built Unix Shell Scripts for batch processing

Mrinal…3/4

• Performed production support and user training

Directorate General Assam Rifle

Programmer Analyst / Jr. DBA

April 1996 – May 1997

The Assam Rifle is a Para-military force Head Quartered at Shillong,

Meghalaya. India. Assam Rifle Personnel Information (ARPIS) was

developed to automat payroll as well as maintenance of individual’s

information like transfer, promotion, demotion, punishment, education etc.

• Involved in the entire development cycle ( SDLC) of ARPIS system

• Developed logical and physical data model

• Installed SCO Unix and Oracle 7.1.6

• Created database, schema, tablespaces etc

• Built packages using PL/SQL, SQL*Forms 3.1, Pro*C

• Performed database administration and tuning activities

• Prepared training manual and trained users

Education : M.C.A. (Master of Computer Application)

Jorhat Engineering College

Jorhat, Assam, India.

June 1989 to June 1993

B.Sc. (Bachelor in Science),

D.H.S.K. College

Dibrugarh, Assam, India

June 1986 to June 1989

Certification : Oracle Certified Associate

Massachusetts, US.

4

Contact this candidate