SUMMARY

• Around 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL and PL/SQL of different platforms like Windows NT/2000/XP, UNIX and Linux.
• Good knowledge of key Oracle performance - related features, such as Query Optimizer, Execution
• Client interaction for the business process.
• Hands on experience in Coordinating and maintaining the Operational Readiness Review Database.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Implementation and Post Implementation surveys.
• Experienced in RDBMS design, data modeling, data normalization and SQL tuning using Indexes.
• Good conceptual knowledge in Data warehouse and STAR Schema.
• Good knowledge in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
• Proficient in writing stored procedures, Functions, Packages and Database Triggers using PL/SQL.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Experience in UNIX Shell Scripting, scheduling cron jobs and dbms jobs.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL, DBA back end applications Development Toad, SQL Plus, PL/SQL Developer, UNIX and working knowledge of UNIX editors, Debuggers.
• Solid Experience and knowledge in ETL and Data warehousing concepts.
• Hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions and Process Documentation.
• Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams.
• Good Knowledge in Oracle Apps 11i Technical and Functional with the modules like GL, AP, AR, I-Expenses, PO, FA, I-Supplier, Bill of Material, Work in Process, and AME.
• Strong in using tools such as PL/SQL developer, SQL developer, SQL*Loader, oracle Discoverer, TOAD and SQL*Plus.
• Experience in performance Tuning and Explain plan, SQL loader, DBMS Scheduler, Utl File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, SQL*Loader, SQL*Plus, UNIX Shell scripting, Performance tuning and Query Optimization.
• Experienced in Dynamic SQL, PL.SQL Collections and Exception handling.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, and functions. Triggers, cursors, Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• 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.
• Proactively interacted with Business Analytical, technical analysts, Developers, Testers and External clients.
• Expertise in Oracle 10g and migration of Oracle Reports from 4.x/6i/9i to Oracle 10g.

TECHNICAL SKILLS

Operating Systems: DOS, Windows XP/NT, Linux, UNIX, OS X

Languages: SQL, PLSQL, C, C++, Java developer

Scripting Languages: JQuery, JavaScript, HTML and XML

GUI’s Technologies: Oracle Forms 11g, Developer Suite 10g/6i (Forms, Reports), Crystal Reports 9/10, Discoverer10g, Erwin, ODI, J2EE (Servlets, JSP, JDBC), Oracle APEX

Databases: Oracle8i/9i/10g/11g, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

SCM Tools: Subversion, CVS, ClearQuest, JIRA

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, Toad, ETL tools Informatica Power Center, OEM

PROFESSIONAL EXPERIENCE

Sr. PL/SQL Developer

Confidential, Beverly Hills, CA

Environment: Oracle 9i/10g/11g, Reports 10g, Forms 11g, SQL, PLSQL, SQL*Loader, SQR, KORN Shell script, TOAD, Unix

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Used RANK, DENSE RANK functions to involve in the development of custom stored procedures, functions, packages, triggers, SQL and PL/SQL.
• Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
• Good understanding and ability to create shell scripts/ Windows batch scripts for data management and data administration tasks on Unix/Linux and Windows platforms.
• Manage the FTP and SFTP processes for various data transfer processes.
• Prepare appropriate technical specification documents for building ETL and back end DB code.
• Developed and optimized SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Written SQL Cleanup scripts to clean the un-used data from database.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.

Sr. PL/SQL Developer

Confidential, Birmingham, AL

Environment: Oracle 9i/10g/11g, Reports 10g, Forms 11g, SQL, PLSQL, SQL*Loader, SQR, KORN Shell script, TOAD, Microsoft Visual SourceSafe, JQuery, Javascript, Java, OV (Open version) and UNIX.

Responsibilities:

• Business requirements gathering and documentation, data cleansing and extraction, report design and implementation, and testing.
• Developed numerous PL/SQL stored procedures, SQL scripts and Bourne/Perl shell scripts to extract and convert legacy data into Oracle readable format.
• Created a secure interface (Pl/sql, Korn shell and cron) to transfer data from the legacy system (Wachovia database) to the Thomson Oracle database.
• Developed complex Oracle Forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).
• Generated DDL/DML scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involved in analyzing requirements and designing database using normalization techniques.
• Designed and Created E-R diagrams for the entire process along with flowcharts using MS-Visio.
• Created reusable mapplets/transformations embedding business logic.
• Analyzed the existing Access system and re-designed it in Oracle 10g by developing data validation and load processes using PL/SQL, stored procedures, functions and triggers to enhance and improve functionality requested by business for reducing their manual processing time.
• Meet with business stakeholders and other technical team members to gather and analyze application requirements
• Design database solutions to satisfy application (business and technical) requirements
• Implement database solutions using available database development tools
• Provide first level operational support for development and production database systems.
• Provide written status reports to management regarding project status, task, and issues/risks.
• Handling the Ingestion and Publishing process using CRON jobs and AUTOSYS.
• Designed/Coded/implemented automatic error handling and recovery processes for table data loads.
• Coded and implemented data migration processes using Oracle procedures/packages (using PL/SQL) and Unix/C/Pro*C programs
• Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
• Involved in writing UNIX Shell scripts for automation.
• Prepared ER Diagrams, Data flow diagrams based on the requirement.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Created and maintained development environment and resolved Production and Validation Environment problems.
• Constant interaction with Java Developers for tuning of SQL statements, embedding them in Java code using SQL and for unit testing and other test sequence comparisons.
• Optimized and tuned PL/SQL programs to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used Jquery, Javascript to develop the front end UI for the application.
• Involved in requirement gathering and User Testing.

Sr. Oracle PL/SQL Developer

Confidential, Rochester, NY

Environment: Oracle 9i, 10g r2, 11g r1, Oracle e-Business Suite, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, Beyond Compare, Microsoft C#, Crystal Reports, XML packages, Solaris. Red Hat Enterprise Linux, JDA allocation.

Responsibilities:

• Post migration testing of database by comparing table data in the pre and post-migration environments.
• Performed data validation - used comparison tool Beyond Compare to check for consistency in table data before and after migration.
• Unit testing of the modules of the project.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Responsible for SQL tuning using explain plan, TKPROF utility, optimizer hints to improve the performance.
• Involved in RDBMS design and developed ER-diagrams using Erwin.
• Good working knowledge on Oracle Pseudo columns like ROWID, ROWNUM.
• Tuning and optimization of the existing as well as new code as needed using Oracle hints
• Used nested table and Bulk collect for faster retrieval of data and improving performance.
• Interfaced with system analysts to analyze the schema using excel with macros and provided input for updating the entity relationship diagrams.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedure, functions, packages using SQL*Plus.
• Providing technical and functional support for E-Business Suite programs for databases supporting supply chain management, order management, warehouse management system, purchasing.
• Wrote technical design and functionality documents.
• Worked on Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger(GL), fixed assets(FA), and cash management(CM), supporting data extraction, filtering, and validation.
• Prepared unit test cases and executed the same.
• Creating and reporting Crystals Reports for higher management as business tool.
• Developing ETL process for the data-warehouse in Oracle 11g.
• Participating in requirement meetings and design walkthroughs.
• Worked on extracting data from the XML file sand loaded it into the database.
• Comfortable working with Composite Data Types.

Oracle PL/SQL Developer

Confidential, Bellevue, WA

Environment: Oracle 10g, UNIX, SQL, PL/SQL, SQL*PLUS, SQL*Loader, WinMerge, TOAD, Erwin, Informatica.

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL, functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Experience in using various oracle PL/SQL collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Involved in migrating database from Oracle 9i to 10g database.
• Involved in developing screens and generating reports.

ORACLE PL/SQL DEVELOPER

Confidential, Oklahoma City, OK

Environment: Oracle 9i/10g, SQL, PL/SQL, Redhat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORT.

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases.

ORACLE PL/SQL DEVELOPER

Confidential

Environment: Oracle 10g, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML, Ultra Edit

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC.
• Developed capacity plan for the database, estimated the table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for protecting data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among the various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.