SUMMARY

• Over 9+ years of experience as OracleDeveloper in development and production environments.
• Extensive working experience in Oracle Database (12c/11g/10g/9i). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader.
• Used range and list partition technique for larger table partitioning.
• Unittestingand debugging the code using error log package.
• Experience inrequirementsgatheringfrom Client and implement the same in applications.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Worked in debugging and Tuning the PL/SQLcode, Explain plan, tuning queries and optimization for the Oracle database.
• Exposure in using CASE tools like TOAD, PLSQL Developer and SQL Developer for writing PL/SQL programs.
• Createdbatchfilesfor Windows environment for running the scriptfilesand scheduled them using Windows scheduler.
• Involved in various phases of SDLC fromrequirementgathering, analysis, design, development and testing to production
• Extensive experience in Database query and Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 11g/10g/9i/6i, Reports 10g/9i/6i.
• Experience of Data modeling (both transactional OLTP and dimensional OLAP).
• Normalization Techniques for designing database with Relational technology on N - Tier Architecture.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience in using several built in database packages as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS SQL are few to be named.
• Loaded Data into Oracle Tables usingSQL Loader.
• Experience in creating master detail forms and adding Alerts.
• Experience in Deploying Forms and Reports on the web.
• Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Solid Understanding of Adobe LiveCycle.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, Export/import and UTL FILE to read and write the files.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• As a professional developer involved in code review of all the team members.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i, Oracle forms 11g/10g/9i, Oracle reports 10g/9i, SQL Server 2005, Microsoft Access.

Programming languages: SQL, PL/SQL, Unix Shell Scripts, CSS, HTML, XML.

Operating systems: Win XP, Vista, Win 7, UNIX, Linux and Mac OS.

Development Tools: TOAD, SQL Developer, SQL*loader, SQL*plus, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Worked with Business Analysts duringrequirementgathering
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD
• Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
• Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges.
• Createdbatchfilesfor automation ofSQLscriptfilesand scheduled those using windows scheduler.
• Expertise in Data Migration by performing data analysis, data cleansing and preparing data to migrate from legacy to current systems.
• Developing test cases and do UnittestingandIntegrationtesting
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• Providing support in end to end integrations.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed SQL*loader scripts to load data in the custom tables.
• Developed PL /SQL code for updating payment terms.
• Involved in documentation of User requirements and Testing of developed modules.
• Worked in the Production Support team and fixed high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
• Performed unit testing and integration testing for various development applications in ORACLE 11g.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Experience in UNIX shell scripts in writing deployment code for migrations.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Creation of interface screens and reports using oracle forms and oracle reports.
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions and packages; ensured that the quality, programming and project management standards were met.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections.
• Used Bulk Collect feature to improve performance.
• Created indexes on tables for fast retrieval of data.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the project.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS JOB, and UTL FILE.
• Designing and rebuilding indexes for faster overall data processing.
• Gathering the requirements through meetings with the Business Users
• Tuned Report performance by exploiting the Oracle’s built-in functions and rewriting SQL statements.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Test case/data preparation, execution and verification of the test results.
• Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment: Oracle 12c/11g, SQL, Oracle Data Integrator (ODI),PL/SQL, UNIX, Oracle forms 11g, Reports10g, C#,.Net, Toad, TFS, shell Scripts, SQL*Loader

Confidential, St. Louis, MO

Oracle developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Resolved different kinds of tickets issued to us which involved in UNIX shell scripting, modifying database tables.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersonmaster tablesfor automatic creation of primary key values.
• Created scripts for new tables, views, queriesfor new enhancements in the application using TOAD/SQL developer.
• Based on BusinessrequirementsmodifiedPL/SQLPackages and delivered the Projects before the deadline
• Createdindexes on the tables for faster retrieval of the data to enhance at a baseperformance.
• UpgradedOracle 10g to 11gsoftware in different environments for latest features and also tested databases.
• Involved in performance tuning of various integrations and database by creating indexes on the tables for faster retrieval of the data.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Developed PL/SQL triggers for automatic updating the tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Created database objects like tables, views, materialized views using SQL Developer and SQL* plus.
• Used principles of Normalization to improve the performance.
• Used advanced PL/SQL concepts like bulk binding, bulk collect, ref Cursor, PLSQL tables and dynamic SQL for DML operations for better performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Created Materialized Views and partitioning tables for performance reasons.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.
• Created tickets to other development teams for supporting applications.
• Involved with users to understand the problem they have and train them with work around for similar issues.
• Created Informatica mappings and sessions to accomplish data migrations.

Environment: Oracle 11g/10g, K-Shell, PL/SQL, SQL* Plus, SQL developer, SQL*Loader, TOAD, UNIX.

Confidential, ST. LOUIS, MO

Oracle Developer

Responsibilities:

• Requirements gathering from end users.
• Responsible for developing database objects - Functions, Procedures, Packages, Cursors and Triggers etc.
• Worked on tickets to fix the issues reported by the end users.
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Normalized to 3NF to acquire least data repetition required by business.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Wrote SQL queries to developed test data for use during test execution.
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, and detailed design, coding and testing.
• Optimizing the performance using PL/SQL table types and record types.
• Worked on table partitioning and index creation for the performance improvement.
• Extensively worked on complex SQL queries using joins, sub queries, correlated sub queries and analytical functions.
• Extensively used advanced PLSQL features like BULK COLLECT, FORALL, REF CURSORS, COLLECTIONS data types in the procedures, functions.
• Designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements.
• Generating software upgrade scripts for cross functional teams.
• Highly involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every logical branch of the stored Procedure.
• Involved in the preparation of Technical Specification Documentation.
• Analyzing the performance of the SQL queries and created the scripts for indexes

Environment: Oracle 11g, SQL, TOAD, UNIX Shell Scripting, PL/SQL, MS Visio, SQL Developer.

Confidential - Memphis, TN

Oracle Developer

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements.
• Document the business process flows.
• Schedule meetings and present technical issues to business users and developers.
• Migrated data from Sybase to Oracle using SQL developer.
• Performed discussions with data modeler to update the data model for new requirements.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Used PL/SQL tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility.
• Create & maintained batch jobs using Shell Scripts.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Communicate issues and progress to project manager.
• Solving day-to-day problems, giving support to the users.
• Worked with Dynamic SQL, Global Temporary Tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Import/Export utility is used for transforming data from one place to another from testing to Production.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views.
• Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 10g/11g, SQL, PL/SQL, TOAD for Oracle, SQL *Plus, UNIX Shell Scripts.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Scheduled job for DTS packages.
• Used BCP / Bulk Insert to publish table output to text files.
• Created advanced T-SQL/PL-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions (UDF) and Stored Procedures.
• Used all Declarative Constraints for maintaining Data Integrity.
• Created Views to restrict access to data in a table for security.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Auditing using triggers.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to the software change requirement.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Involved in Data warehouse design with star schema.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Developed test plan documents for all back end database modules.
• Responsible for unit testing, and documentation of the interfaces.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored the Database Performance using execution plans and Index tuning.
• Optimized the query performance with modifications in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.

Environment: Oracle database 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX.