Country: India

State: Andhra Pradesh

City: Hyderabad

Posted date:05/08/2013

JOB ROLL: Oracle Developer

Name: Mamatharani. Bandaru

Mail: acewmx@r.postjobfree.com

Mobile:995-***-****

Experience:

Relevant Experience: 2 Years,

Total Experience: 6 Years.

Presently working as a Oracle Developer, Pune from July2011 to 23 august 2013.

Previous worked as lecture in Electronics, Science in Junior College 2008 to 2011 July

Summary:

Having 2+ years of experience in Application Software development using Oracle 9i/10g/11g.

Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors,

Packages, Exceptions, Joins.

Involved Explain plan and investigate the performance issues.

Strong understanding of business processes with good experience in development.

Good exposure on advanced topics Like Analytical Functions, Partition Tables.

SQL Loader and UTL_FILE package.

Knowledge in SDLC and all phases of Application development.

Good experience of coordinating with various teams like Deployment, Testing Team to speed up

Development process.

Experience of good client interaction and to deal with their requirements.

Quick learner & Self-directed, consistently updating self with emerging trends in the industry.

Education Profile :

Bsc(MPCs) from Vivekananda degree College Karimnagar with an aggregate of 67%

Intermediate from Vivekananda College karimnagar with an aggregate of 57%.

SSC from High School, Ramagundam with an aggregate of 82%.

Certification: SQL/PL-SQL(Associate(OCA)

Skills & Expertise :

Languages: SQL, PL/SQL, FORMS,REPORTS

IDE: SQL Developer, SQL*PLUS.

Operating System: Windows XP, Window 7,

Databases: Oracle 9i, 10g,11g.

Professional Experience :

Project # 2:

Title: Inventory Management System.

Client: Precision Engineering Company, Pune.

Duration: Aug 2012 to Till Date

Team size: 4

Environment: Oracle 9i/10G, Windows, Reports

Role: PL/SQL Developer

Project Description:

Design and develop a User Interface(UI) to Create the Inventory Item Master.

Design and Develop a UI to Create the Inventory On Hand Quality.

The Inventory Planner should be able to see the Planned Purchased orders created in the

purchasing System and Receive the goods into the Inventory.

Design and Develop a UI to Receive the data into the Inventory.

Goods can be receive into the Inventory through the approved Purchase Order or through an

unplanned receipt.

All the Inventory Transactions should be maintained in a Inventory Transaction Table.

Upon receipt of the Goods the On Hand Quality in the Inventory On Hand Quality Table should

increase by the quality received.

The Inventory Planner should also be a position to create Unplanned receipts.

The Unplanned receipts will increase the Inventory On Hand Quality for that Item the Unplanned

receipts do not have any Link with the Purchase Order.

The Inventory Planner can do Unplanned Issues.

The Unplanned issues will reduce the Inventory On Hand Quality from the tables.

Create a Reports to Display the Current On Hand Quality in the System

Responsibilities:

Requirement gathering from the Business Team.

Convert the functional requirements into technical document as per the business standards.

Worked as per the CR Raised from the end user.

Analyze the Existing code and do the impact analysis.

Created Database Objects like tables, Views, sequences, Stored Procedures, functions,

Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

Involved in modifying various existing packages, Procedures, functions, triggers according to the

new business needs.

Wrote SQL Queries using Joins to retrieve data from the database.

Used SQL Loader to upload the information into the database and using UTL_FILE packages

write data to files.

Involved in explain plan for query optimization.

Data validation/Reconciliation report generation.

Involved in peer to peer code reviews.

Code validation as per client requirement.

Project # 1:

Information System (PMIS)

Client: Pune

Time Duration: Oct 2011 to Jul 2012

Team size: 3

Environment: Oracle 9i, Windows, Reports, Java

Title: Project Management

Role: PL/SQL Developer

Project Description:

Project Management Information system is a Database System which is used for maintaining the

entire Database regarding Naval Projects developed by DMDE. This Project Processing Lifecycle

of Products from gathering of Technical Requirements to Final Production which includes Master

data, financial data, Purchase Orders, Quality Assurance report etc. The centralized data is

maintained in the oracle database. The end users will be able to take the Business Decisions

based on our different Forecast reports. Finally the data is maintained in different staging servers.

The data warehouse systems will be maintained internally for Business analysis and ongoing

customization.

Responsibilities:

Requirement gathering and worked according to the CR.

Worked under the senior level guidance.

Data validation/Reconciliation report generation.

Code Development as per the client requirements.

Involved in the development backend code, altered tables to add new columns, Constraints,

Sequences and Indexes as per business requirements.

Perform DML, DDL Operations as per the Business requirement.

Creating views and prepares the Business Reports.

Resolved production issues by modifying backend code as and when required.

Used different joins, sub queries and nested query in SQL query.

Involved in creation of sequences for automatic generation of Product ID.

Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures,

functions, Packages, Cursors, Ref Cursor and Triggers.

Testing of code functionality using testing environ

Date of Birth: 5-8-1983

Alternative contact no: 995-***-****(hyderabad)

Official Email/Phone Number: acewmx@r.postjobfree.com

Reason for change: Husband transferred

Passport Number/PAN Number: BFHPB3489M(Pune)

Current Location: Secunderabad(sainikpure)

Full Name: Mamatarani

Email: acewmx@r.postjobfree.com

Contact: 995-***-****

Current Location: Hyderabad sainikpure

Location Preferred: Hyderabad

Relevant IT Skills" : 2.5months

Current CTC:1.8per ann

Expected CTC: 2. Per ann

Notice Period(14Dadys): Yes

Company Address:

Email : acewmx@r.postjobfree.com

Address : 145, Wing 'B', First Floor,

Shoppers Orbit, Alandi road,

Vishrantwadi, Pune - 411015

India Ph No: 020-********,

Company website: www.careerintech.com

Contact this candidate