RESUME OF SIMMI SAHAY

ad07hh@r.postjobfree.com

Contact number: 082********/098********

EDUCATION : Masters Degree in Science (Chemistry) from Magadh University in 1991.

PGDCA from Uptron India, Bokaro. (1 year)

UNIX with 'C' from Apple Industries, Jamshedpur, India (6 months).

VISA (Value Added Information Technology Structured to Advance Application) training from Pentafour Software Development park, Chennai of 6 months duration residential course equivalent to post graduate diploma. I was in USA for 6 months.

CERTIFICATION:

ORACLE OCA (cleared SQL+PL/SQL paper).

IBM DB2 UDB V8.1 Family Fundamentals-700

EXPERIENCE : 12+ years.

O. S Dos, Unix, Windows 2000 Xp,

Languages SQL, PL/SQL,C,Pro C, knowledge of Python,Pandas

Databases Oracle 9i/10g/11g, DB2.,Teradata,SQL SERVER 2008 R2( (SQL, DDL,

DML)),Oracle DBA,Mysql

Applications Methodology Client / Server

GUI TPUMP,FLOAD,MLOAD,BTEQ,Informatica 8.6,BO,Actuate 5/7/8,

PowerBuilder, PL/SQL,,HTML,CSS

Forms, Toad,SQL* Loader.,SSRS

Using HTML and CSS,I have created multiple interface as per project requirements.

Knowledge of HTML,Javascript

Developed reports using Acuate,SSRS,POWER BI,Report Builder

Ensure that the project follows all Standards and Quality Guidelines during the full project life cycle.

Participate in Internal code review, User Acceptance Testing, document any failures.

Monitoring of installation of changes into the production environment.

Production Support with root cause analysis and permanent fix to the problem.

Design, Analysis, Coding and Testing of Platform Evolution application,

performance tuning of code & procedures, impact Analysis.

Task allocation and ensure the completion of task on time.

Metrics Preparation and Presentation, Status Reporting

Provided technical guide

Participated in weekly management meeting to communicate existing and/or future issues.

Provided weekly status report to senior management on status, progress and risk of development

Knowledge of data modeling

Used VSS for version Control

Used Bugzilla for resolving bugs given by testing team

I have provided training on oracle dba,Sql,pl/sql to team .

Significant Projects:.

Since NOV-2013,I am working as a freelancer consultant.

Location : Jamshedpur,India

1) Previous Company : ESSPL,BHUBNESHWER (May 2012 - Oct 2013)

Project Name: Archive Process

Client name: DAMCO,Global logistic service

Role: Development

Description:

Developed stored procedure using PL/SQL Damco logistics service.

Responsibility:

Design, Code development using Oracle 10g/11g,PL/SQL,toad,Oracle DBA activities like user creation

and management, Backup/Restore DB when required using RMAN, manual backup (cold and

hot backup),space management

Requirement Analysis

Client/Team Communication

Project Process adherence

Release Management

Performance tuning

2) Company : ESSPL,BHUBNESHWER

Project Name Mail Dispatch System Of UK

Client TNT,UK project

Duration/size 07-May-2012 to June 2013.

Role I involved in system study, development and maintenance of code of

existing code, team management..

Environment : Oracle 10g / 11g, PL/SQL. Toad DBA activities like user creation

and management, Backup/Restore DB when required using RMAN, manual

backup (cold and hot backup),space maagementt, Enterprise Manager

3) Company Name EXILANT TECHNOLOGY,BANGLORE

Project Name Working on Apple Care Repair project in MNC,Banglore.

Client Apple

Duration/size 19-Aug-2011 to May 2012.

Role . I involved in system study, Designing, development of mapping in informatica,

maintenance of code of existing code, team management.,

Environment Teradata,PL/SQL,TPUMP,FLOAD,MLOAD,INFORMATICA,BO,

AQUADATA,SQL DEVELOPER,EDW architecture.

Used Autosys for Scheduling the job.

Description Working on call and chart related.data.Moving data from oracle data base to

teradata using Informatica,Teradata utilities like TPUMP,FLOAD.

Developed mapping in informatica to transfer data from Oracle database and flat

file to flat file on informatica server and then doing ftp to transfer flat file from

informatica server to UNIX environment and then traansferring data using fload and

tpump to teradata Database .

4) Company Name: STI Software Solutions PVT.LTD.,Chennai

Project Name Material Management

Client NASA,DOD

Duration/size 01-DEC-2008 to 29-JAN-2010.

Role I involved in system study, Designing, development and maintenance of code of

existing code, team management,DBA activities like user creation

and management, Backup/Restore DB when required using RMAN, manual backup

(cold and hot backup),space management

Environment Oracle 10g / 11g,SQL,PL/SQL,Toad,Oracle DBA,Enterprise Manager

Description System was managed the materials purchased by the Lab. .

5) Company Name: North shore Tech, Noida

Project Name Active Contact Project

Client Motorolla,USA

Duration/size 16 Apr 2007 To 16-OCT-2007/ Team of 4 members.

Role Team Lead. I was involved in system study, Designing, development, maintenance of

code of existing system, DBA activities like user creation

and management, Backup/Restore DB manual backup (cold and hot backup),

space management etc.

Environment Oracle 9i/10g,PL/SQL,Oracle DBA,

Description System was maintaining data related to vendor, customer,contract getting from

various retailer .

6) Company Name IBM,Pune -7 Aug 2006 –10 APR 2007

Project Name Contractor Invoice Processing, Tracking and reporting System (IGA).(With)

Clint IBM

Role I was involved in system study, development, maintenance of code of

existing system.

Environment DB2, Window Xp. Rational Application Development Environment

Description This project is tracking the claim done by contractors and invoice submitted by the

vendor. It is verifying the amount in invoice claimed by vendor against hours claimed

by contractor. Based on result invoice is getting accepted or rejected.

7). Company Name : Scandent Solution,Chennai

Project Name Integrated Resource Information System (IRIS)

Duration/size 27 Sep 2004 – 5 Aug 2006 / Team of 6 members.

Role Involved in system study, Designing, report development, review, UTC

preparation and testing of reports

Environment Windows 2000, Using Actuate 7/8.0, Active Portal, Management

Console, iServer, toad, Oracle, SQL, DBA activities like user creation

and management, Backup/Restore DB manual backup (cold and hot backup),

space management etc.

Description IRIS has been developed as a flexible business solution that integrates multiple

requirements and businesses of Department of Family Services (DFS,US Govt.

Project)

8) Company Name : TCS,Kolkatta-On Contract Sellcraft India

Project Name Service Management Report

Client British Telecom

Duration/Size 14 Jan 2004 – 20 Sep 2004/ Team of 6 members..

Role Involved in system study, Designing, development and maintenance of code of

existing system

Environment Windows 2000, Using Actuate 7, Active Portal, Management Console, iServer, toad,

Oracle, SQL, PL/SQL

Description This project was developed for the leading Telecom Service Provider UK,British

Telecom

9) Project Name Base Quata System (Silverline Tchnology,Mumbai)

Client Colgate Pamolive India Ltd. (Producion Support)

Duration/Size Nov 00 - Apr 2001 /team size -2.

Role Involved in system study, development, maintenance, testing of existing application.

Environment Windows 98, Power Builder, SQL Loader toad, Oracle, SQL, PL/SQL

Description This system is used to generate their revenue billing, retailing billing, sales forecast,

prize money, Targets etc for their branches, regions, zones.

10) Project Name Hotel Reservation System (Silverline Tchnology,USA)

Duration/Size Jun 00 - Sep2000 .

Role Involved in system study,Designing, report development, review, testing of reports.

Environment Actuate 3.0,Oracle

Description This project aims at developing a portal through which online

reservations can be made

11) Company Name Silverline Tchnology,Mumbai (Production Support)

Client : Essar Steel,Surat (Production Support)

Duration/Size May 96 – Dec 99 .

Project Name Material Management System (MM). / Financial Accounting System

Duration/Size May 96 – Dec 98 . (Silverline Tchnology,Mumbai)

Role Involved in System study, Support, development, maintenance, modification of

existing Application software.

Environment Unix, Oracle,SQL,PL/SQL,FORMS 3.0,Report Writer 1.1

Description MM is an on-line software which consists of various modules that are completely

integrated with one another. It supports all the phases of mm material planning and

control, purchasing, good receiving, inventory management, invoice verification

vendor evaluation, and material ledger.

Financial Accounting System: The financial accounting system is on line software

that consists of various modules that is completely integrated with one another. It

enables the user to evaluate information in general ledger, in account receivable,

account payable. This application is central data post, which contains all the

account data arising within an organization.

(SIMMI SAHAY)

ESSPL PVT.LTD., BHUBNESHWER Page of 4

Contact this candidate