SUMMARY:

• Over 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modelling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
• Expert level experience on PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Object, Partitioned Tables, and Table Indexing.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
• Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment.
• Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11. x and Worked on KORN Shell Scripts to write maintenance script for Oracle.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Experience in using tools like SQL * Plus, SQL Assistant, PL/SQL developer and TOAD.
• Experienced in writing UNIX shell scripts for automating the process of data loading& Batch Processing.
• Worked in analysing and Implementing the ETL architecture using ETL Informatica, SQL * Loader, PL/SQL.
• Good experience in data modelling using Erwin Data Modeler: Creating entities, relationships, sub-types, schemas and ERD to database schemas.
• Expertise in Oracle SQL, PL/SQL, Oracle Forms and Oracle Reports.Experience in creating composite data types and collections.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast-paced environment.
• Good experience in Software Engineering Processes (Agile and Waterfall Methodologies).
• Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.

PROFESSIONAL EXPERIENCE:

Confidential, Billerica, MA

Oracle PL/SQL Developer

Responsibilities:

• Involved in creation of database objects like Tables, Views, Materialized views, Procedures, Packages using SQL server, Oracle tools like PL/SQL, T-SQL Developer, SQL* Plus, TOAD.
• Wrote PL/SQL and T-SQL code for Oracle and SQL server Job Scheduling and Maintain Batch jobs.
• Load data into Oracle table using SQL*LOADER and External Table. Wrote database triggers, created database links, synonyms and snapshots
• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related sub queries, in-line views and PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursor.
• Involved in developing and modifying PL/SQL packages, functions and procedures.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Tested, debugged and took measures for maximum performance utilizing query optimization.
• Created Interfaces using Unix Shell Scripts and pl-sql for daily file transfers using FTP, SFTP, and Connect Direct.
• Automated tasks like Analyze Tables, Collapse Partition Monthly, pulling data using PL/SQL packages and Autosys.
• Created PL/SQL & SQL scripts for the ETL Converting/Migrating data from Mainframe, DB2, Oracle, XML, Flat files into Oracle database tables for Data warehousing and BI purpose.
• Used external tables, Utl file and SQL LOADER for the purpose of loading flat file And XML data.
• Modified shell scripts to call different procedures and functions in different environments to run in different time periods.
• Created database objects and developed and modified PL/SQL packages, functions, procedures, triggers using index, hints, global temporary table, Cursors, Ref-cursors.
• Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.

Confidential, Tempe, AZ

Oracle PL/SQL Developer

Responsibilities:

• Created PL/SQL stored procedures, triggers and packages and created scripts for purging of data.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
• Created cursor, collections and database triggers for maintaining complex integrity constraints and implement the complex business rules.
• Developed sql scripts for creating database objects such as tables, views and sequences.
• Created SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Worked with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Designed and developed custom packages, procedures, Triggers using PL/SQL. Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL* Loader and extensive use of External Tables.
• Designed the packages and procedures for getting the data from Source systems to ESA (Enterprise Staging Area) and from ESA to EDW (Enterprise Data Warehouse)
• Performed unit testing on the developed code to ensure that its bug free and handled Production issues and manage the same in issue log.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.

Confidential, Irving, TX

PL/SQL Developer

Responsibilities:

• Developed and Unit testing of all the required PL/SQL packages, stored procedures and triggers.
• Involved in analysing the existing business process, application and Database design.
• Worked on Stored Packages, Procedures, Functions and Triggers using SQL and PL/SQL.
• Coordinated with DBAs to make the daily loads run much faster by tuning different aspects of the load jobs.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.
• Wrote Queries to retrieve data in XML format from the tables.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Worked in Agile environment and participated in day to day processes like scrums and sprints using Rally.
• Participated and interacted with different teams from off shore and on shore from different countries for requirement gathering and solve complex problems.

Confidential

Software Developer

Responsibilities:

• Followed the Agile software development methodology to manage the application deliverables
• Used Maven 3.0 to build directory structure.
• Used Eclipse IDE 4.2 for developing the application
• Developed the application using Spring Framework that uses MVC architecture with JSP and HTML as the view.
• Worked with SQL Server to maintain the details in the database repository
• Wrote SQL queries of differing complexities for the application. Designed and developed database objects like Tables, Views, Stored procedures, User Functions using PL/SQL, SQL Developer
• Used IBM WAS and JBoss server to deploy and run the applications
• Developed, designed and executed test scenarios/scripts and test cases for functional tests and regression tests. Tested program for validity of results, accuracy, reliability, and conformance to establishment standards.
• Developed End-to-End test scenarios based on Functional Requirement Specification (FRS), processes and user stories/acceptance criteria.
• Documented software defects using bug tracking system tool like JIRA and report defects to software developers using tools.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.