Deepika Pentala

Ph.: 732-***-****

Email: acyygz@r.postjobfree.com

Location: Jersey City, New Jersey

Summary

Over 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and Informatica power center.

Involved in all phases of Software Development Life Cycle (SDLC) including analysis, specification, development, maintenance, testing and documentation.

Experience in drawing ER diagrams, Data Flow Diagrams/Process Diagrams using ERWIN and Oracle data modeler.

Strong experience in writing SQL queries and PL/SQL Development, Stored Procedures/Functions/Packages/Database Triggers, Exception Handlers, Cursors.

Created and maintained Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.

Modified and developed database triggers, cursors, procedures, functions and packages to meet business requirements.

Extensively worked with tools like TOAD, PL/SQL Developer, and SQL Developer.

Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.

Technical Skills:

Programming Languages

Plsql, Sql, Informatica

Data Base

Oracle

Tools

TOAD, MySQL, Sql*Plus, Sql Developer, Informatica Power Centre

UML Tools

Rational Rose

Operating Systems

Windows, Linux, UNIX and DOS

Education:

Masters in Information Assurance

Wilmington University, Delaware, USA

Bachelors in Information Technology

Osmania University, Telangana, India

Professional Experience:

BRIGHT AID PHARMACY - Bronx, NY

Duration: October 2014 to Current Date

Role: Oracle Developer/Analyst

Bright Aid Pharmacy is a growing chain of pharmacy stores in New York area. They sell prescription drugs and a wide assortment of general merchandise, including over the counter drugs, beauty products, cosmetics, film and photo finishing services, seasonal merchandise, greeting cards and convenience foods.

Responsibilities:

Identified Tables, Indexes, Stored Procedures, Triggers, Constraints and Data types of the existing SQL Server database.

Came up with the low level detailed design to re-create the objects to Oracle database.

Developed Functions & Procedures to manipulate the data and to load to the tables.

Implemented and fine-tuned the detailed design to fit into the migration process.

Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms according to corresponding Data types

Developed PL/SQL code to implement business rules through Cursors, Ref Cursors, Procedures, Functions, and Packages

Designed and developed Informatica Mappings to load data from Source systems.

Migrated data from flat files to Oracle database using SQL*Loader.

Designed and developed Informatica Mappings to load data from Source systems.

Created PL/SQL stored procedures for database and application validations.

Modified and developed database Triggers, Cursors, Procedures, Functions and Packages to meet business requirements.

Environment:Oracle 11g, Toad 10.6, SQL Developer, SQL* Loader, UNIX (AIX 6.1), Putty 0.62, Windows 2010, Informatica Power Center.

BARCLAYS BANK - Whippany, NJ

Duration: November 2012 to August 2014

Role: Oracle Developer

Involved in development of an online banking application, which enables the bank customers to access their various accounts through the Internet. The application also allowed the users to submit account related queries to the bank that include ordering checks, requesting copies of checks and statements, etc.

Responsibilities:

Responsible for study, Analysis, Design, Development/Customization and Testing/Debugging of the application.

Designed and developed tables, views, sequences and synonyms.

Developed Functions & Procedures to manipulate the data and to load to the tables.

Developed various Complex Queries, Views.

Written control files to load data into staging tables and DW tables.

Involved in Unit testing PL/ SQL Stored Procedures and Functions.

Prepared final design documents and general instruction to follow during development.

Analysis of customer reported issues, which could be a code issues, Data fix issues, performance issues, setup issues, functional issues or an RDBMS issue.

Effective Interaction with Support and other Application groups through on call for high priority issues.

Environment: Oracle 11g, Toad 10.6, SQL Developer, SQL* Loader, Windows 2010

Oakton

Duration: December 2011 to October 2012

Role: Oracle PL/SQL Developer

Cygnus Software’s, Inc. provides consulting services to design, Implement and manage software applications that provide enterprise scale business solutions. The formula that makes Cygnus Software’s, Inc. consulting services extremely attractive in the demonstrated expertise on cutting edge technology and the cost effectiveness of the consulting staff.

The application involved maintaining personnel details of employees that include vacancies, new recruitments, employee details, qualification, history, transfer history, promotion, increment history, experience details and dependency details. In addition, we designed and developed payroll interface system that takes the input from different tables and makes the timesheet for each employee.

Responsibilities:

Created Data Flow Diagram, Entity Relationship Diagram from Designer.

Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.

Various stored procedures were written to achieve the back-end functionality.

Involved in Development, Implementation and Testing.

Developed Functions & Procedures to manipulate the data and to load to the tables.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming to extract data from large database.

Created Database Triggers in PL/SQL to accommodate for data Integrity and additional Referential Integrity.

Involved in Package modifications to reflect the changes. .

Using of Built-In-Packages of Oracle in PL/SQL procedures and functions.

Environment: Oracle Database 10g, oracle 11g SQL*PLUS, PL/SQL, SQL*LOADER, TOAD,, Unix shell scripting, Windows NT/Windows XP.

Adani Enterprise Limited

Duration: October 2009 to September 2011

Role: Oracle Developer

The system totally automates all the functions of Human Resource Department. The application involved maintaining personnel details of employees which includes vacancies, new recruitments, qualification, history, transfer history, promotion, increment history, experience details, dependency details etc. In addition, we have designed and developed payroll interface system that takes the input from different tables and makes the timesheet for each employee.

Responsibilities:

Created Data Flow Diagram, Entity Relationship Diagram from Designer.

Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.

Various stored procedures were written to achieve the back end functionality.

Development, Testing, Implementation and Training.

Developed Functions & Procedures to manipulate the data and to load to the tables.

Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Involved in Unit Testing Stored Procedures and Functions.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Developed complex SQL queries for data retrieval from various database objects including tables and views.

Created SQL*Loader scripts to load data into the temporary staging tables.

Environment: Oracle Database 10g, SQL*PLUS, PL/SQL, SQL*LOADER, Windows NT/Windows XP.

Contact this candidate