PROFESSIONAL SUMMARY:

• About 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications and Data warehouse environments using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance AnalysisandSQL query tuning using Query Optimizer, Indexes, Clusters, SQL Access Advisor, Hints, Explain Plan, and Tk - prof.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Good experience and hands with Agile Scrum Methodology and Experience in Export, Import and SQL*Loader Utilities.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Extensively used the AutoSys scheduler tool to schedule the UNIX shell scripts that will run the Oracle jobs.
• Used ClearCase version control tool for maintaining the different versions of files and implementing the code changes.
• Solid Experience and knowledge in ETL and Data warehousing concepts.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Good Knowledge about the ETL tool Informatica Powercenter for developing various mappings using different transformations.
• Robust knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Good knowledge of Database Administration.
• Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager, and Export/Import, Performance Monitoring, Backup & Recover.
• Extensively used PL/SQL to built Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS:

Operating Systems: Windows 7/ XP/ NT/95/98/2000, DOS, UNIX, and LINUX.

Database: Oracle 11g/10g/9i/8i, MySQL, MS SQL Server 2005, MS Access

.Programming languages: SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, XML, HTML.

Tools: & Utilities: Toad, Oracle SQL Developer, PLSQL Developer, AutoSys, RMAN, SQL Navigator, SQL* Plus, SQL* Loader, Informatica, ClearCaseReporting: Oracle reports 10g/9i/6i, MS Access, Crystal Reports.

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

WORK EXPERIENCE:

Confidential, MD

Sr. Oracle Developer

Responsibilities:=

• Developed PL/SQL Packages and Procedures accordance with Business Requirements and also to extract the data from different sources and load it into data warehouse
• Involved in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
• Involved in tuning SQL queries by using EXPLAIN PLAN.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Created various generic procedures using DBMS STATS and Rebuild Index to generate the statistics of tables and improve the performance.
• Developed many process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology and also by using hints for queries.
• AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to control the transactions.
• Involved in developing UNIX shell scripts for Loading Database Tables, running SQL files, Packages and Procedures.
• Loading data from flat files into database tables using SQL* Loader.
• Involved in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys 4.0 and AutoSys r11.3 versions.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases.
• Involved in unit and integration testing of the jobs and prepared documentation.
• Responsible for writing high quality and well documented code according to standards and documentation of various processes.
• Worked with a team which Upgraded Oracle DB 10g to Oracle 11g.
• Responsible for Analyzing and Implementing the Change Requests.
• Maintained daily batch cycle for different Data Loads and provide the support.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g/11g, Oracle SQL Developer, SQL Navigator, SQL * Loader, SQL*PLUS, Solaris, AIX, UNIX Shell Scripting, Informatica PowerCenter.

Confidential, FL

Oracle Pl/Sql Developer

Responsibilities:

• Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Supporting legacy systems with backups of all cases to/from parallel systems.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.
• Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
• Created Shell scripts to generate oracle reports and send to e-mail.
• ER diagrams are developed using TOAD Data Modeler.
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g, Toad, SQL * Loader, Toad, PL/SQL Developer, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, and XML, Informatica.

Confidential, NJ

Oracle Pl/Sql Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Tk-prof, Hints and indexes.
• Wrote shell scripts to automate loading files into database using crontab, error handling and notification.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.).
• Developed forms Using Tab-canvas, Stacked, Content and Horizontal toolbar canvas.
• Developed reports using complex queries as per client request as a part of production support.
• Generated the reports like list of the vendors, their supply schedule, actual deliveries and Inventory level of raw material.

Environment: Oracle 10g, PL/SQL Developer, SQL* Plus, SQL * Loader, TOAD, Oracle Reports, HTML, XML, UNIX Editors and Debuggers.

Confidential, TX

Oracle Pl/Sql Developer

Responsibilities:

• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Altering the database Objects to synchronize it with the new Schema created.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, Toad.
• Involved in creating triggers, views and Materialized views based on the client Requirements.
• Understanding the business logic to modify existing SQL Code and Performance Tuning.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Used AutoSys Scheduler for batch scheduling.
• Involved in writing procedures, functions, triggers, and packages for new requirements.
• Created Records, Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Participated in Performance Tuning using Explain Plan and Tk-Proof.
• Developed and customized number of reports using Oracle Reports and Forms.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed ad hoc reports using Discoverer 4i.
• Analyzing tables and indexes for performance tuning- Seasoned in optimizing Query performance using explain plan, SQL Trace and TKPROF utility.
• Involved in code reviews of other team members.
• Writing scripts for Data Staging, Loading and cleanup process.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Responsible for developing new reports in Oracle XML/BI publisher 5.6.2.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Involved in Production support for leg of thebusiness.

Environment: Oracle 10g, PL/SQL, SQL* Plus, SQL * Loader, TOAD, Oracle Reports, HTML, XML, Windows XP.

Confidential

Jr. Oracle Developer

Responsibilities:

• Responsible for system study & information gathering.
• Development was done using front end as Oracle Developer/2000.
• Involved in creation of Tables using storage parameters and clusters.
• Involved in writing Database procedures, Functions, Packages and Database Triggers.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens. Worked with DBA in making enhancements to physical DB schema.
• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Analyzed and designed tables based on small and large database transactions.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Developed complex Forms and Reports using Oracle tools.
• Conducted sessions to end-users.
• Involved in integration testing.
• Analyzed and designed tables based on small and large database transactions.
• Utilized PL/SQL developer tool in developing all back end database interfaces.
• Also responsible for writing test plan documents and unit testing for the application modules.