SUMMARY:

• 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Proficient in writing complex SQL Queries, creating Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Utilizing Cursors, Collections, Ref Cursors, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions and other advanced coding methodology.
• Demonstrated expertise in using PL/SQL to build Oracle Packages, Stored Procedures, Functions, Triggers, and Cursors for processing data, enforcing referential integrity and needed business rules.
• Proficient in Oracle tools and utilities such as TOAD, PLSQL Developer, SQL*Plus, SQL Developer, SQL*Loader, SQL Navigator, OEM (Oracle Enterprise Manager).
• Proficient in Oracle Database design with relational models and very good experience in entity and attribute identification and developing the Entity - Relationships.
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Loading data from flat files into database tables using SQL*Loader.
• Good knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc. for optimization process.
• Good Experience working on Performance Tuning and Query Optimization using Explain plan and TKPROF.
• Good Experience working with ODI (Oracle Data Integrator) ELT Tool for extraction, Loading and transforming of data from heterogeneous source systems to the target data warehouse.
• Experience in developing ODI objects like Project, Model, Mappings, Procedures, Models, Load plans and generating ODI scenarios.
• Have good knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting.
• Extensively used UTL FILE package to write the data from oracle tables to a flat file.
• Well experienced working with Waterfall & Agile Methodologies.
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Wrote Test cases and performed data validation and process testing for application moving into production. Involved in QA and UAT testing and fixing the issues.
• Good interpersonal and communication skills, and experienced in working with senior level managers, business people, and developers across multiple disciplines.
• Ability to work independently as well as in any challenging team environment with strong analytical and problem-solving skills.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, SQL Server 2000/2005

Database Tools: SQL Developer, TOAD, SQL*Plus, SQL*Loader, Oracle Forms, Oracle Enterprise Manager

Programming Languages: SQL, PL/SQL, C

ETL Tools: Oracle Data Integrator, Informatica Power Center

Scripting Languages: UNIX Shell Scripting, Perl

Operating Systems: Windows, UNIX, LINUX

PROFFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Assisted Business Analysts and Users in requirement analysis and authored various documents including BRDs, Technical Specifications, Migration Instructions and conversion mapping documents.
• Interacted with technical consultants and business analysts to understand the business requirements.
• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL for new DataMart.
• Involved in performance tuning for the new data mart which included creating indices, table partitioning, SQL hints using explain plan utility.
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Worked extensively with oracle External tables to load data from flat files into data mart for further processing.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Used several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Created PL/SQL packages to perform validations on data from legacy system before loading into Oracle.
• Performed unit and integration testing of the applications and PL/SQL modules and used CLEARCASE for version control in team development.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Experience working with ODI (ELT) tool, creating mappings for extracting loading and transforming data into the target tables.
• Worked on executing test cases with multiple data sets to attain exact test results and capture faulty construction.

Environment:: Oracle 12c, PL/SQL, TOAD, ODI (Oracle Data Integrator) 12c, UNIX Shell Scripting, Windows XP, HP Quality Center.

Confidential, Farmers Branch, TX

PL/SQL Developer

Responsibilities:

• Gathered business requirements from various business stakeholders like end users, process owners, functional managers and business analysts. Documented the requirements into technical specifications.
• Developed complex SQL/PLSQL scripts for the data analysis to check the quality of data using regular expressions at database level.
• Improve the performance of the slow SQL queries by implementing indexes, and improved performance of loading process using FORALL, BULK COLLECT.
• Developed various procedures, functions and packages to implement the new business.
• Utilized statement level, row level database triggers for auto updating the data.
• Performed SQL queries tuning using TKPROF utility, Oracle Hints and function-based indexes to improve the performance of legacy applications.
• Generating/Reading flat files using UTL FILE utility which gives us efficiency in reading and writing the large files in the order of gigabytes.
• Loaded data from flat files to the Oracle tables using SQL LOADER both conventional and direct path methods.
• Worked on Forms, Menus, Object Libraries, and PL/SQL Libraries using Oracle Forms Builder.
• Designed and developed Web-enabled Oracle Forms & Reports for Order Enquiry and Order tracking. Including Forms based on stored procedures.
• Created several SQL queries, procedures, functions, packages and several database objects.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Designing and building reports using Oracle Report Designer.
• Using views for designing and building reports.
• Modified existing reports to cater the new business requirements using PL SQL programming.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance.

Environment:: Oracle 11g, PL/SQL Developer, Oracle Forms and reports 11g, Windows, HP ALM.

Confidential, Jackson, MS

Oracle Developer

Responsibilities:

• Gather Business rules from the end users that are to be incorporated into the system.
• Extensively worked on the analysis of Tables in both Legacy Data store and new data store.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Worked on PL/SQL Tables, Records and Collections.
• Developed PL/SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Developed SQL queries to fetch complex data from different tables in remote databases using database links.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Source data residing in Excel formats are exported verbatim to flat files and then accessed via Oracle external tables to load into the staging schema, at which point all source data can be efficiently transformed and migrated to the target schema.
• Extracted data from Flat files using SQL*LOADER.
• Created partitions on the tables to improve the performance.
• Participated in application planning, design activities by interacting and collecting requirements from the end users.

Environment: Oracle 11g, PL/SQL Developer, SQL*Loader, SQL*Plus, Windows, Toad, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Participated in analyzing and creating the functional & technical requirement documents specific to the project. Discuss with business users, BA and Architects to finalize requirements and scope of the project.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Involved in loading the data from flat files into Databases and validated the data with PL/SQL procedures.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. Designed Database Triggers for audit and validation purpose.
• Involved in Preparation of the Test Cases and in Unit Testing and System Integration Testing.

Environment: Oracle Databases 9i/10g, SQL, PL/SQL Developer, TOAD, Windows, UNIX.

Confidential

SQL Developer

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Used SQL*Loader to load the database from flat files.
• Created new Tables, Indexes, and Sequences where needed.
• Created database triggers for data security & Consistency.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Extensively used the Oracle utilities such as Export/ Import, SQL*Loader, SQL Trace, TKPROF and day-to- day activities of different databases.
• Updated tables without breaking the existing functionality.
• Developed an effective Error Mechanism for the application using PL/SQL routine to send automated emails, created Error-Log Tables and used Autonomous transactions, Locks.
• Performed unit and integration testing of the applications and PL/SQL modules and used SVN for version control in team development.
• Involved in Unit testing and Integrated testing.
• Developed user interfaces using Oracle Forms.
• Customized Reports using Reports according to client requirements.

Environment: Oracle 9i, SQL*Plus, SQL*Loader, SQL Developer, MS Office, Windows, UNIX Shell Scripting.