SUMMARY:

• IT Professional with 7+ years of experience as Oracle PL/SQL Developer with Oracle … in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Strong coding & designing experience in Oracle PL/SQL & SQL and used Database utility tools like SQL Navigator, SQL Plus, TOAD, and SQL Developer.
• Expert in using PL/SQL Packages, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B - tree Index, Bitmap Index), Views, Materialized Views and Database Links.
• Experience in writing dynamic SQL Statements using EXECUTE IMMEDIATE and DBMS SQL.
• Experience in developing Joins, Indexes and sequences.
• Experience in FTP to SFTP migrations.
• Extensive knowledge of Oracle Cursor management, REF Cursors.
• Expertise in working with oracle supplied packages such as DBMS SQL, DBMS JOB, UTL FILE, UTL MAIL and DBMS SCHEDULER.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, STATSPACK, TKPROF, Indexing, Hints, Bulk Bind, Bulk Collect, Creation of global temporary tables and table partitioning.
• Skilled in UNIX Shell Scripting. Created load scripts in Korn shell called by scheduler (Crontab and AutoSys), to format and transfer data from various platforms and databases.
• Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit.
• Knowledge in data migration activities like Export and Import utilities, Bulk copy processing (BCP), data scrubbing using Oracle DataPump and SQL *Loader.
• Excellent Java development skills using HTML, CSS, Java Script, Core Java,J2EE, Groovy, Grails framework.
• Experience in designing and consuming Java web services for Soap and Restful Webservices.
• Experience in test automation and frameworks.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the Big Data as per the requirement.
• Experience on User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS, and PRAGMA EXCEPTION INIT etc.
• Experience with all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Excellent analytical, communication and interpersonal skills with strong ability to perform as part of a team.

TECHNICAL SKILLS:

Operating Systems: MS Windows and UNIX

Languages: SQL, PL/SQL, MS SQL, C/C++, HTML

Scripting Languages: Windows Batch/Ftp Scripts, UNIX Shell Script

Databases: Oracle SQL Server 2008 and MS-Access

Tools: SQL*Plus, TOAD 12.2.1, SQL Developer, SQL*Loader, MySQL, TKPROF, PUTTY, Database Configuration Assistant, SQL Trace, Erwin, MS Excel, MS Visio

WORK EXPERIENCE:

Sr. Oracle PLSQL Developer

Confidential, Mesa, AZ

Responsibilities:

• Performed unit test on the developed code to ensure that its bug free.
• Handled Production and UAT issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries
• Using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• 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.
• 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.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.
• Used Oracle packages like DBMS STATS to collect statistics of many various kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.
• Optimized SQL to improve query performance using SQL Navigator and PL/SQL Developer.
• Understanding the requirements and preparing the business requirement and functional specification document.
• Analyzing the reports requirement and designing the Dimensional model.

Environment: Oracle application Express, Oracle 11g/10g, SQL, PL/SQL, SQL *Plus, Shell Scripts, SQL Plus, SQL Developer, UNIX, Windows 7, Windows XP.

Sr. Oracle Pl/SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development of the CEMR Application.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively worked in providing updated records of the patients on weekly basis by comparing the with the Previously-Exported patient's records.
• Involved in keeping track of Previously-Exported patients and archived them for future purpose.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the patients' database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Created the custom tables to import the Patient's data and insert into the database tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS-Office, Perl Scripts, MS Office, MS Visio

Sr. Oracle PLSQL Developer

Confidential, San Francisco, CA

Responsibilities:

• Analyze the functional & technical requirements and of the project.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production and UAT issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Involved in Logical and physical modeling.
• Manage team of 3 people, create project plans, conduct meetings, perform code reviews.
• Designed and developed ETL process from scratch for this new system using Oracle, PL/SQL and Unix.
• Designed Fact and dimension tables and handled slowly changing dimensions.
• Create new Tables, Indexes, Views, Materialized Views, 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, And Record Types, UTL FILE
• Wrote complex stored procedures and packages.
• Create new Structures, Input/Output Events, and Sources in RDJ for new rules.
• Create & Modify Transformation, Change, Balancing, Aggregate & Audit rules in RDJ8.3.2 as per the requirement.
• Validate, extract and send the rules to File Manager, compile and move them to production.
• Move data between databases using Import/Export.
• Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.
• Extensively used hints to tune & optimize queries using DB links.
• Used DRIVING SITE, HASH, INDEX, NO USE NL, etc hints to optimize queries.
• Wrote complex shell scripts for processing of rules.
• Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.

Environment: Oracle database 9i, PL/SQL, SQL Plus, Erwin 7.3, SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, AIX, SQL developer, Data stage, CSS, UNIX.

Sr. Oracle PL/SQL Developer

Confidential, New York, NY

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * Loader.
• Ran Adhoc queries to get client detailed information about their stay and family
• Design, Develop and Test the jobs in Informatica Power Center for the data flow from Flat Files, CARES legacy system to data marts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Extracting the data from simple flat text files into operational database.
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools like SQL Loader.
• Used Golden Gate data selection and filtering for replication and making use of SQLEXEC to interact with database.
• Created database links to retrieve data from multiple servers.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Create and run batch files on regular basis.
• Created records, tables, collections for improving performance by reducing context switching.
• Created number of database triggers according to business rules using PL/SQL.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• 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.
• Used version control tool VSS, which helps multiple users to access, and make changes to the collection of source code files.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, PL/SQL Developer, Informatica Power Center, Golden Gate, UNIX, VSS

Oracle PLSQL Developer

Confidential, Bloomington, IL

Responsibilities:

• Interacted with the clients to understand the requirements and Designing module wise Oracle 11g database structure and its implementation on the client server.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in developing and scheduling using Cronjobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Involved in writing the database triggers to furnish the audit details.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Troubleshoot performance issues and bugs within packages using dbms output, explain plan.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX Shell Scripting, Windows XP

Oracle PLSQL Developer

Confidential, Colorado Springs, CO

Responsibilities:

• Wrote stored PL/SQL Procedures for reports.
• Developed PL/SQL scripts for data processing.
• Created Indexes, Views and Tables
• Optimized the existing UNIX scripts to achieve better performance.
• Wrote triggers and procedures to handle the data processing.
• Created scripts to trigger nightly batch processes.
• Involved in Developing and Generating Reports.
• Experience with Enterprise Guide in generating analytical reports.
• Preparing Unit test scripts, setting up a test environment and unit testing the code.
• Tuning of the SQL statements for application developers.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL Navigator, SQL* Loader