SUMMARY:

• Over 8 years of experience as Oracle PL/SQL developer in Analysis, Design and Implementation of Oracle E - Business Suite Applications.
• Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery.
• Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Experience in ETL and data integration experience in designing and developing ETL mappings and Power Center.
• Proficient knowledge in HTML and JavaScript.
• Specialized in writing NZSQL, NZLOAD, NZEVENT and stored procedures.
• Extensive experience in Netezza database design and workload management.
• Experience in managing users and user groups in Netezza.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Created materialized views like primary key, ROWID, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query.
• Extensive experience in utilizing Collections to boost performance in PL/SQL block.
• Exceptional skills in Agile Development and Test Driven Development.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Excellent technical and analytical skills with clear understanding of OLTP and OLAP models.
• Creating different kinds of partitions on tables and indexes .
• Creating roles and granting to users based on their group requirements.
• Experience in Waterfall and Agile development methodologies.
• Creating profiles and attaching them with users.

TECHNICAL SKILLS:

Operating Systems: Windows XP/7/8, UNIX, LINUX

Languages: SQL,PL/SQL, NZSQL and NZLOAD

Databases: Oracle 12c/11g/10g, Netezza TwinFin/striper

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Plus, SQL*Loader

Development Tools: Aginity, Putty, SQL Developer and TOAD

Scripting Languages: Java Script, UNIX Scripting, shell Scripting, SQL and PLSQL

Web Technologies: HTML, WebSphere and XML

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures, functions, packages to view appropriate data at GUI.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Created new mappings, modified existing mappings using InformaticaPowercentre9.1.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancements in the application using TOAD .
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created DataLoad process to load data from OLTP sources into Netezza.
• Designed table structure in Netezza.
• Created external tables in NZLOAD process in Netezza.
• Created Netezza stored procedures with complex business rules.
• Experience in table distribution methods in Netezza.
• Knowledge in Netezza internal storage mechanism.
• Knowledge in how zone maps works.
• Created test packages to validate all new and existing procedures and functions in Unit Testing Phase .
• Involved in all SIT, QA, UAT and Production deployment.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Written Shell scripts to automate loading the files into database using Crontab .
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Used Oracle supported DBMS STATS , DBMS JOB packages to gather the statistics and schedule job respectively. Also used DBMS METADATA.GET DDL package to describe table structure.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Worked with Bulk Collect to improve the performance of multiple - row queries.
• Made used Sub - query ( WITH clause ) to make complex SQL statements simple and make them more efficient .
• Experience with Agile Methodologies (Scrum) to manage full life-cycle development of the project.
• Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling .
• Created ad-hoc reports to users in Tableau by connecting various data sources.

Environment:: Oracle 11g/12c, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, AIX, Windows XP, Netezza, Informatica 9.1, IBM ClearCase, JIRA

Confidential, San Antonio, TX

Oracle PL/SQL Developer

Responsibilities:

• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad , PL/SQL Developer and SQL* plus .
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collections in PL/SQL objects for improving the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Designed Technical design document based on the business requirements .
• Created NZLOAD process to load data into data marts in Netezza.
• Created table structure for data marts in N etezza.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Written PL/SQL Cursors for transaction processing.
• Used Bulk collect feature to process the data from Cursor / Ref Cursor.
• Developed UNIX Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
• Worked extensively with the universe team and database team and users to analyze the gaps.
• Performed Database Administration of all database objects including tables , clusters , indexes , views , sequences packages and procedures.
• Upgraded the existing database from Oracle 10g to Oracle 11g .
• Involved in Logical & Physical Database Layout Design.
• Created queries to minimize transactions, table data size and copy into historical tables.
• Adapted Agile methodology for the project.
• Modified existing UNIX Shell Scripts to schedule daily jobs.
• Improved the performance of the application by rewriting the SQL queries .
• Involved application deployment process and co-ordinate with DBA Team.

Environment: Oracle 10g/11g, PL/SQL, TOAD, Sun Solaris, AIX, Netezza, Informatica, SVN, JIRA

Confidential, MD

Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications , development of database objects, developing code and validating programs and production support.
• Managing FDR applications and handling day to day support of the batches using job scheduler Tidal.
• Performed various activities like creating, debugging and modifying database objects and User defined functions and finely tuned them for performance.
• Create new Tables, Indexes, Views, Materialized Views and Table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, Record Types and UTL FILE.
• Wrote complex stored procedures and packages.
• Used FDR Scenario Manger to create new AML scenarios, writing complex queries in Oracle.
• Developed daily, weekly, monthly Reports for alerts generated and scheduled Jobs.
• Worked on UNIX scripting for scheduling the jobs.
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.
• Involved in fixing bugs within Packages and Stored Procedures .
• Involved in all production support tasks and have working knowledge of Reporting Tool like Tableau.
• Involved in Tuning Database & Application performance using Explain Plan .
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Performed Unit Testing and Integration Testing of the Application.
• Worked in an Agile/scrum environment.
• Involved in preparing documentation and user support documents.
• Wrote ad-hoc queries to generate reports for business users.
• Extensive analysis and reasoning of alerts generated by the system.

Environment: Oracle 10g, Windows 7, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty and Informatica.

Confidential, Austin, TX

Oracle PL/SQL Developer

• Created PL/SQL program units to modified and transformed data of Mater Planning, Demand Planning, Strategy, Transportation and Network Carrier module interface’s tables of JDA/Manugistics application 7.4.2.
• Created PL/SQL program units to modified data received from SAP to forecast demand and supply of products using historical data.
• Created PL/SQL packages using collections like Nested tables and VARRAYS.
• Improved SQL queries by tuning SQL queries using Explain Plan and TKProf .
• Created PL/SQL and SQL scripts using Oracle internal Standards.
• UNIX scripts are run through Scheduled Autosys jobs.
• Developed Unix Shell Scripts to call PL/SQL scripts and SQL scripts.
• Created UNIX scripts for automation of the PL/SQL procedure jobs.
• Created database modeling using Erwin tool.
• Created Database objects like Tables, Temp Tables, Sequences, Views and Materialized Views.
• Designed and Developed Star and Snowflake Schema.
• Created tables and partitioned tables using range, hash and list partitioning methods.
• Created materialized views and improved performance.
• Created slowly changing dimension (SCD) using OWB .
• Created Mapping for ETL process between sources and target using OWB .
• Generated code for PL/SQL and SQL*Loader for ETL process using OWB .
• Created database objects like tables, Indexes, Views, Synonyms using SQL Server 2008.
• Created stored procedures , functions and Triggers in SQL Server 2008.
• Created reports using Crystal report and Business Objects .

Environment: Oracle 10g, Windows 7, SQL Developer, XML, SQL, PL/SQL, UNIX Scripting, Putty.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.
• Used stored procedures , wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of SQL in order to design and tune SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures .
• Managed all indexing, debugging, optimization and performance tuning .
• Designed, developed and tested stored procedures , views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Created packages for transforming data from various data sources.
• Tuned SQL queries using execution plans for better performance.

Environment:: Oracle 10g, Windows 2000/NT/XP, TOAD, SVN.