Developer Project

CONTACT DETAILS

Sanjay bejjaram(009***********)

**************@*****.***

Career objective

> Willing to work in an organization where I can apply and enhance my

knowledge and technical

skills,For the personal and professional development. Ready to take

leading responsibility and professionally looking forward to work

online with clients and winning over client's confidence.

> Good Team Player with excellent communications and Interpersonal

Skills.5.7 years of industry experience, which includes my present

Career Summary (5 Year work Exp. as Oracle DBA, Total Exp. 6.7 Years)

? 3 Year work experience with USA based organization Noida as Oracle

DBA.

? Around 1.7 year work experience in Parle Biscuits Pvt. Ltd. as an

Application Developer (Analyst).

? OCP Certified Application Developer from SQL Star International

Delhi.

? OCP Certification result awaited in DBA track -from SQL Star

International Delhi.

Professional Summary

? Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager,

SQL*Loader, and Export/Import, Performance Monitoring, Backup &

Recovery

? Making the Script, Functions, Package, Procedures, New users,

Granting privileges to Users, storage management, taking backup,

database recovery, query performance, database Tuning.

? Created and managed the Database Objects and Schemas.

? Creation of new scripts to automate the procedures to generate

statistics on Database Space Management, Performance and for Proactive

Monitoring.

? Various tools used such as fileZila for moving file from user to

server and server to user and worked on third party tools such as

TOAD/PL/SQL Developer.

? Connect to the both nodes in cluster and regularly check the alert

and log files in RAC environment

? Experience in cloning using cold backup, hot-backup and RMAN backup

? Experience in Upgrading and applying to security patches the

databases

? Experience in Performance Tuning and Monitoring using various tools

such as Statspack, TKPROF, SQL Trace and Explain Plan and also by

Rebuilding Indexes

? Experience as a production DBA, maintaining and troubleshooting

large databases, during the off hours and over the weekends and

maintaining multiple instances in a 24/7 Production supports.

? Proficient in migrating databases using various tools such as

Import/Export and Knowledge in Replication of the databases as well.

? Data Guard (Physical and Logical Standby Databases).

? Strong analytical and problem solving skills with ability to work

within team environment and independently when needed.

? An effective communicator with exceptional relationship management

skills with the ability to relate to people at any level of business &

management & experience working with steering committees & project

managers.

Organizational Experience-1

Company profile - IBM philippines

working as oracle DBA with IBM inc philippines 2013 -2014 jan

o Proactively monitor, diagnose and rectify database/OS related

problems.

o All trouble shooting related to DB & Application & handling the user

problem.

o Maintaining the DB performance & tuning, Handle all the Data

migration & data replication.

o DB Backup & recovery, solving Issues, disaster recovery

o Managing the communication with ORACLE with hotline, if there is any

critical problem.

o Managing the All DBA related daily basis activities.

o Handling the all user access related activities like assign to

grants, privileges, Roles etc.

Space management & Storage management.

Database Refresh, Cloning.

Implementation and maintaining Database Security (create and

maintain users and roles, assign privileges).

. Strong at Database backup and Recovery

. Upgradation and patching the database.

. Fresh installation of the oracle binaries and creating databases under

different releases under RFS activity. (Request For Service)

. Excellent knowledge of oracle9i and 10G architecture, good

understanding of new features.

Experience in configuration and trouble shooting Datagaurd.

(Standby )

Got appreciations for the work delivered with in the time scales.

Knowledge on RAC.

Working as Oracle DBA with USA based MNC at Noida from 2009 to 2013.

Company profile-This global headquarters is located in india with

local offices spread across the globe, EMEA and Asia--Pacific. Its

serves more than 300 clients worldwide, including relationships with

more than half of the top-20 global banks.

Its encompasses the people, technology, history, service, vision and

values that respect the integrity of every single relationship behind

the billions and billions of transactions

We bring passion to the world of payments.

PROJECT SUMMARY:-

PRODUCT Description: It's a Banking domain product. It deals with Card

Management System. Mainly it's used by 2 side which called Acquire

side & Merchant Side. With this help of this they deals all plastic

money (Credit, Debit Card) Transaction. We deal in both fields

licensing & processing of plastic card. We provide the client to this

product with the help of they create, manage, successfully run the

account of customer and give him the all other utilities like Lone on

phone, statement generation, currency conversion. All the transaction

involves the third party via Master, Visa card System.

Prime Involves front End Module which used by user and made by .Net

Technology.

And also its have online system which is made by Informix and it's

used the all merchant & acquire side transaction sent to the backend

database by End of Day.

Its also has Fraud-Guard Module which used for stopping the all fraud

activities by client or user side.

Designation: - Oracle DBA( oracle )(sql server)

Job Responsibilities: -

o Administration, tuning, monitoring, disk space management ensuring

data security and access control.

o Creating the required table spaces, users, and roles for the

application.

o Scripting for automating maintenance tasks and to ease

administration.

o To write user specific scripts as per application requirements.

o Installation, Maintenance, configuration of Operating System and

Databases as well.

o Proactively monitor, diagnose and rectify database/OS related

problems.

o All trouble shooting related to DB & Application & handling the user

problem.

o Maintaining the DB performance & tuning, Handle all the Data

migration & data replication.

o DB Backup & recovery, solving Issues, disaster recovery

o Managing the communication with ORACLE with hotline, if there is any

critical problem.

o Managing the All DBA related daily basis activities.

o Handling the all user access related activities like assign to

grants, privileges, Roles etc.

Space management & Storage management.

Database Refresh, Cloning.

Implementation and maintaining Database Security (create and

maintain users and roles, assign privileges).

. Strong at Database backup and Recovery

. Reorg of database, Rebuilt of index.

. Strong in RMAN backup and recovery.

. Strong in understanding the Process and implementing the new process.

. Upgradation and patching the database.

. Fresh installation of the oracle binaries and creating databases under

different releases under RFS activity. (Request For Service)

. Excellent knowledge of oracle9i and 10G architecture, good

understanding of new features.

Experience in configuration and trouble shooting Datagaurd.

(Standby )

Got appreciations for the work delivered with in the time scales.

Knowledge on RAC.

Onsite Project Experience (9 Months):-

I had been to london (united kingdom) for around 11 months for project

training and worked as well. I used to handle all the work for Barclays

Bank UK. I was onsite on behalf of my current company.

It had given me a great opportunity to prove myself in a great arena of

professional life.

I worked for 3 main different institution Barclay INDIA, UAE & Kenya.

Organizational Experience-2

Worked as an Application Developer (Analyst) in Parle Biscuits Pvt.Ltd

Mumbai Nov 2007 to June 2009.

Parle Biscuits Pvt.Ltd-It's a product based company with head-quarter in

Mumbai.

It has around 40 products made in different units based at different

location of India. It has 7 main units & around 53 Sub-Units, which are

called CMU (Contract Manufacturing Unit) .The three main Modules which help

in different aspect of running its business are Material Management System,

Financial Accounting, Payroll System, and Dispatch management system.

PROJECT SUMMARY:-

(A)

Environment Windows NT 4

Project Title Material Management System(MMS)

Company Parle Biscuits Pvt. Ltd.

Tools Oracle 9i\10g, SQL, Pl/SQL, Form 6i, Reports6i, Foxpro

Role Application Developer

Nature Of Project -This Module is designed and used for the purpose of

daily Material transaction in the manufacturing unit.

(B)

Environment Window NT 4.0

Project Title Financial Accounting(FA)

Company Parle Biscuits Pvt. Ltd.

Tools Oracle 9i, Pl/SQL, Form 6i, Reports 6i,Foxpro

Role Application Developer

Nature Of Project -This Module is used to generate and maintain all the

financial and accounting matters, payment details, freight payment, scrap

sales and excise activities.

(C)

Environment Window NT 4.0

Project Title Payroll System

Company Parle Biscuits Pvt. Ltd.

Tools Oracle 9i, Pl/SQL, Form 6i, Reports 6i.

Role Application Developer

Nature Of Project -This Module is used to maintain the payroll structures,

training structures and records of all the workers and Employees.

(D)

Environmet Window NT 4.0

Project Title Dispatch Management System(DMS)

Company Parle Biscuits Pvt. Ltd.

Tools FoxPro

Role Application Developer

Nature Of Project - This Module helps in maintaining the records of

biscuit's dispatch to the different depots and whole sellers, preparation

of sales invoices and dispatch plans.

Designation: - Application Developer

Job Responsibilities: -

o Worked as an Application Developer, Enhancement in module and debugging

different existing kind of modules

o Developing New Packages, procedures & functions, Views, Indices, synonyms

and all DB objects.

o Gathering statistics through Report6i.

o Making New users, grant privileges, Role

o Making scripts, all Database Developer activities.

o Worked on Front End tool of Oracle(Forms6i,Report6i)

IT Skills

Client Server Software: Oracle 9i/10g/11g/12c,teradata,

Programming Language: SQL, PL/SQL, Form6i, and Report 6i, Crystal report.

RDBMS: Oracle 9.0.1/9.0.2/10g /11g RAC

Operating Systems: Windows 2000, Windows NT, Window XP,

Tools used: OEM, Pl/SQL Developer, Toad, VI editor, Sqlloader, TKprof,

Rman, Putty,ASM,

Web-Technologies: HTML

Oracle Applications: 9.2.0.7.0

Protocol: TCP/IP, SFTP, TELNET, HTTP,

Scheduling Tools: Oracle Enterprise Manager (Intelligent Tools),

Oracle Application Manager (OAM).VERITAS (Backup Tool)

Academic Credentials

? bachelor of engineering (Computer Science engineering from osmania

university college of engineering,ou campus Hyderabad.india(2003-

2007).

? got 72% aggregate 1st class marks

? 12th(intermediate college) from ssr junior college,nirmal,andhrapradesh (2001-2002)

?got 61% aggregare 1st class

? 1st-10th standard (elementary, secondary,high school from govt

high school,khanapur,andhrapradesh (1990-2000)

Professional Training

? Oracle PL/SQL,Forms6i,Report6i

? Oracle 9i Database Administration: Fundamental -1.

? Oracle 9i Database Performance & tuning, Installation, Patching, Cloning

and Up-gradation of Database.

Companies I have worked before;

? IBM solutions inc philippines 2013-2014

? Working as Oracle DBA with USA based MNC at Noida( tech mahindra company

) from 2009 feb to 2013.

? 1.7 year work experience in Parle Biscuits Pvt. Ltd. as an Application

Developer (Analyst).2007aug -2008 decemeber

Contact this candidate