SUMMARY

• 8 years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL.
• Expertise in all the phases of System development life Cycle (SDLC)
• Writing code for enhancing existing programs or developing new programs.
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
• Experienced in working with many complex SQL queries with joins, date functions, inline views, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub - queries and analytical queries to generate reports.
• Knowledge on DBA activities like creating schema, users, managing tablespaces, granting and revoking objects privileges on database objects.
• Performance Improvement of PL SQL code and improving memory utilization.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers, Materialized Views.
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Work Experience in writing shell script in Unix & Perl environment.
• Worked on Oracle APEX for development of functional capability.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Working Knowledge in .Net & Java Script.
• Working knowledge of Datastage ETL tools.
• Torubleshoot batch failures to dertermine cause (AUTOSYS logs) correct/escalate.
• Proficient in debugging PL/SQL packages to troubleshoot issues.
• Experience in application development like Bulk Collect, For all, Dynamic SQL, Autonomous Transactions, Global Temporary Tables.
• Knowledge of Oracle application in General Ledger, Account Payable, Account Receivable.
• Experience in Back ends Testing of the applications by executing complex SQL commands.
• Can collaborate with the Product Management to understand and deliver the right solutions for business needs and comfortable working with Offshore team.
• Comfortable in working with a fast-paced, professional development team environment.
• Quality assurance of sql scripts,stored procedures,and triggers using database tables.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

TECHNICAL SKILLS:

Databases: Oracle 11g &10g, MS-SQL Server, MS Access, MySQL

Scripting: SQL, PL/SQL, Unix DB2, T-SQL, PERL

ETL Tool: Informatica, Datastage

Query Tools: TOAD, SQL Navigator, SQL* PLUS, OBIEE,PUTTY,FTP Application

Operating Systems: Windows 2000/XP,LINUX 9.2/9.3

Languages: C, C++, HTML, XML, PHP,Pro*C

Reporting Tool: Business Objects, Crystal Reports

GUI: Oracle Forms 9i and Reports 9i

Other Tools: SQL*Loader, ERWIN, Visio, Apex

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn VA

Sr. Oracle PL/SQL Developer with java

Responsibilities:

• Used PL/SQL collections like PL/SQL tables, Varrays and nested tables.
• Created stored program units like functions, triggers and procedures for implementing complex database intensive business rules.
• Performance tuning of existing sql and pl sql codes to improve the response time.
• Developed procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Developed utplsql environment for the testing purpose.
• Used performance tuning techniques like Partitioning, Partition pruning, Index by Tables, Bulk Collect, materialized views and Oracle hints.
• Migrated the data from excel sheets, text files into the respective Oracle Database tables using SQL *Loader * Benthic Import Export Utilities.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Worked in JAVA environment to support developer as per their requirement.
• Worked with Informatica for ETL purpose and transformation.
• Extensively worked in performance improvement using Indexes, Parallel hints, DBMS stats packages. Used massive parallel to run millions of data in production environment.
• Wrote packages for unit testing using PL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Used SQL*Loader to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.

Confidential, Chicago IL

Sr. Oracle PL SQL Developer

Responsibilities:

• Created stored program units like functions, triggers and procedures for implementing complex database intensive business rules.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Developed procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Used PL/SQL collections like PL/SQL tables, Varrays and nested tables.
• Developed Unix Shell Scripts to automate backend jobs and load data into the database using SQL* Loader.
• Involved in data modeling and design (physical and logical) as per the requirement given by business.
• Executed and maintained the data warehouse extract transform load (ETL) process.
• Conducted ETL development in the NETEZZA environment standard design methodologies.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Extensively used Bulk Binds (BULK COLLECT and FORALL) wherever applicable.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Used performance tuning techniques like Partitioning, Partition pruning, Index by Tables, Bulk Collect, materialized views and Oracle hints.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Used analytical functions like RANK, LAG, LEAD and PARTITION BY.
• Quality assurance to DB2 by coding SQL queries,transact SQL, PLSQL,stored Procedures,functions,triggers,and Cursors.
• Analyzed business requirements, preparation of source-target mapping documents, conducted unit testing and code walkthroughs to ensure there are no missing elements, and performed integration testing.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs. Create SQL scripts to perform unit and component testing.
• Migrated the data from excel sheets, text files into the respective Oracle Database tables using SQL *Loader * Benthic Import Export Utilities.
• Used Pragma Autonomous Transactions.
• Assisted with implementation/upgrade AUTOSYS and JWS,troubleshoot errors.
• Worked on Oracle APEX for development of functional capability.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Separated Tables and Indexes on different locations for reducing Disk I/O Contention.
• Wrote new code based on existing complex code to make it more understandable to person working in the same process.
• Worked with Informatica for ETL purpose and transformation.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordinated between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g, APEX, Oracle 11i, Oracle R 12,TOAD,XML,BLOB,PIPE Informatica, UNIX, PVCS, WinSCP, Data Stage,UNIX, Visio, XML, .NET

Confidential, San Francisco CA

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked with SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Created PL/SQL packages, procedures, functions applying the business logic to calculate Communication Volumes (by touchpoint & communication channel), Response Rates (Customer Pay & Warranty Pay breakouts), Dealer ROI Metrics, Key Program Headquarters Statistics, Revenue Generated Statistics (cumulative and per CP RO), Services Purchased (e.g. Brakes, Batteries, Tires, etc.), etc.
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Provided APEX guidance and support to technical staff on application maintenance
• Created data for Crystal Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Worked with Data Stage for ETL purpose and transformation.
• Assessed the NETEZZA environment for implementation of the ETL solutions.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Documented design specifications and architecture using Microsoft Visio.

Environment: Oracle 10g, APEX, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 9.0.3, TOAD,XML, Informatica, AIX 7.1, Data Stage, MS-Office

Confidential, Dallas, TX

Sr.PL SQL Developer

Responsibility:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Extensively worked in data warehouse environment architecture and methodology.
• Involved in writing backend Packages extensively in PL/SQL.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Used Visio to create and change in the process diagram.
• Defining and reviewing the coding standards besides reviewing the code.
• Performance tuning of existing sql and pl sql codes to improve the response time.
• Successfully worked on implementing Oracle EBS project in Team environment.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose.
• Worked in .NET environment to support developer as per their requirement.
• Extensively worked in performance improvement using Indexes, Parallel hints, DBMS stats packages. Used massive parallel to run millions of data in production environment
• Used DB Visualizer in development environment to develop and analyze the code.
• Worked with Informatica for ETL purpose and transformation.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Used Linux and Unix system during the projects.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, SQL TRACE, ANALYZE and HINTS.

Environment: Oracle Database 11g, Oracle 11i, TOAD,XML, Informatica, Microsoft Windows Server 2008 R2, UNIX, PUTTY, C/C++,PVCS, WinSCP, SSRS,UNIX, IViso, .NET

Confidential, Jacksonville, FL

Oracle PL\SQL Developer

Responsibilities:

• Wrote packages for unit testing using PL/SQL and debugged using DBMS debug packages and other PL/SQL developer tools.
• Monitoring existing SQL code and performance tuning if necessary.
• Created Temporary Tables in procedure to achieve performance issues.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Developed Unix Shell scripts.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Worked with workflow team to support existing PL/SQL code and provided solutions to assigned tasks for various enhancements and defects.
• Design batch processing system for application using AUTOSYS.
• Involved in Data Loading and Data Migration (ETL) using Informatica.
• Used SQL*Loader to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Worked in Crystal reports for report generation to come out with valuable information from existing data. It helped to take better business decision while performing routine operation.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Dealt with heavy weight tables which are appended with millions of records daily.
• Moved / manipulated data from one environment to another for development, testing and debugging of application.

Environment: Oracle 10g, PL/SQL Developer, Reports 6i, SQL*Plus, XML,SQL Loader, Toad, C/C++, Crystal Reports, Forms 6i, DB2, reports 6i, ERWIN, Perl.

Confidential, Woonsocket, RI

PL\SQL Oracle Developer

Responsibilities:

• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Wrote PL SQL query for investment management section to retrieve data from the database create report for the executives.
• Used packages, functions and procedure for investment management, capital market and fixed income system database to improve system performance.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Created Stored Procedures, functions and Packages in Oracle 10g using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
• Increased efficiency of code, by usingbulkcollection techniques to handle large amounts of data.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Wrote PL/SQL procedure that extracts data into excel worksheet and created macros manually in the system
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.
• Worked on Data warehouse design, created star schema, dimension and fact tables.

Environment: Oracle 10g, Forms 10g & Reports10g, ASP, SQL PLUS, PL/ SQL, DB2,PerlSQL*Loader, UNIX Shell Scripts, Data Stage, Business Objects, SQL Navigator, TOAD.

Confidential

Oracle Developer

Responsibilities:

• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Created PL/SQL Packages for easier application design and improved Performance.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created reports using Interactive Reporting for the users so that they can interact among each other without any IT support.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms.

Environment: PL/SQL, C, Pro*C, SQL, SQL*Plus, SQL*Loader, Oracle 9i, IBM Rational Application Developer (RAD) 6/7,UNIX, Windows.