SUMMARY:

• Over 10+ years of IT experience in Oracle PL/SQL SDLC using Oracle 12C/11g/10g/9i.
• Skilled in Oracle, UNIX, PERL Development.
• Extensive experience as Oracle Developer in utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing.
• Solid experience in writing SQL Queries such as Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, Dynamic SQL, Exceptions.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in Migrating Oracle versions from 10g to 11g, 9i to 10g.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and, Transportable table spaces.
• Partitioned large Tables using range partition technique.
• Tuned and improved the Package Performance by using DBMS Profile and SQL Query Performance using Explain Plan, HINTS, SQL Tuning Advisor and, TKPROF utilities.
• Worked in complex Oracle EXADATA Environment and streamed the data through Golden Gate.
• Proficient in creating logical and physical database design, data structures, and implemented large databases using ERWin and MS Visio.
• Strong Experience in Writing PERL, UNIX Bash and Korn Shell scripts to automate various Processes.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Extensively worked on Autosys, Control M, Tidal Batch scheduling tools to handle ETL jobs.
• Possess sound knowledge in various phases of Software Development Life Cycle (SDLC) including Design, Analysis, Development, Testing, and Implementation.
• Wrote Test Scripts and Procedures for Unit level and System level testing.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• Experience with various RDBMS databases like Oracle, DB2, Sybase, Teradata and SQL Server.
• Worked with Software Configuration and Version Control tools such as StarTeam, Tortoise SVN, PVCS, Rational ClearCase and, CA Software Change Manager (SCM).
• Worked with onshore/offshore delivery model.
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user training, Project demonstration and Implementation.
• 24/7 production support and involved in implementation of coding standards and Data Base change requests.

TECHNICAL SKILLS:

RDBMS: Oracle 12C/11g/10g/9i, UDB DB2 8.1/8.2, MS SQL Server 2000/2005/2008 , Teradata, Sybase

Scheduling Tools: Autosys, Tidal, Tivoli Alerts, iXp

Scripting Languages: UNIX Shell scripting, Korn Shell Scripting (Kshell), Perl.

Programming Languages: SQL, PL/SQL, SAS EG4, Java, JDBC, XML, HTML, C, C++, VB.NET, ASP.NET

Operating Systems: Windows 95/98/2000/XP/Win7, UNIX (AIX, HP-UX, LINUX and SUN)

Web Technologies: ASP, PHP, HTML, XML

IDE Tools: SQL Navigator, SQL*Loader, All Around Automations PL/SQL Developer, Rapid SQL, SQL Developer, Toad.

Version Control and Bug Tracking: Rational ClearCase, StarTeam, HP Quality Center, Tortoise SVN, PVCS, Ontime Bug Tracker, JIRA Bug Tracker, Rational Quality Manager (RQM), CA Software Change Manager (SCM).

PROFESSIONAL EXPERIENCE:

Confidential, Cranston, RI

Technical Lead and Lead developer

Environment: Oracle 10g, UNIX, Perl

Responsibilities:

• Prepared tech documentation for easy understanding by other developers.
• Created stored procedures, packages, generated triggers for security purposes using TOAD.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Migrated Oracle from 10g to 11g.
• Created a new cost based real time in sync database for reporting purpose.
• Created the Temp tables in the stored procedure for different applications.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS.
• Loaded data from flat files into Database using SQL*loader.
• Created Unix Shell Scripts for automating the execution process.
• Used DBMS SCHEDULER package for job scheduling.
• Created XML supported document.
• Fine-tuned the Java embedded SQL & PLSQL.
• Worked on Web application development with APEX.
• Involved in Unit testing, Integration test and writing the Test plan.
• Trained end users on the functionality and operability of the application. Prepared tech documentation for easy understanding by other developers.

Confidential, Phoenix, AZ

Developer

Environment: Oracle 10g, Thunderhead, Java

Responsibilities:

• Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.
• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Writing requirement documents based on the requirements provided by the line of business.
• Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes and other database objects.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Spool, Synonyms and Sequences.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Extensively used Ref Cursors and Bulk Collect to populate the data into the respective staging tables.
• Writing and debugging complex SQL and analyzed the best ways to in corporate database requests into application programs.
• Support and administration of databases for set of applications.
• Performing tuning and optimization on SQL queries using SQL trace, TKPROF and Explain Plan

Confidential

Onsite Support Co-Ordinator

Environment: ASP.NET, SQL 2000, Oracle 10g, Perl, UNIX and Java

Responsibilities:

• Responsibilities as Senior production support SME includes requirements review, design, development of change requirements.
• Onsite - Offshore coordination
• Ensuring adherence of protocol in case of severity incidents.
• Ensuring effective 24 * 7 productive production support.
• Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.
• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Writing requirement documents based on the requirements provided by the line of business.
• Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes and other database objects.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database bjects like Tables, Views Indexes, Spool, Synonyms and Sequences.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Extensively used Ref Cursors and Bulk Collect to populate the data into the respective staging tables.
• Writing and debugging complex SQL and analyzed the best ways to in corporate database requests into application programs.
• Support and administration of databases for set of applications.
• Performing tuning and optimization on SQL queries using SQL trace, TKPROF and Explain Plan.

Confidential

Technical Lead

Environment: .Net, Oracle 10g

Responsibilities:

• Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
• Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Used WinSCP for file transfer between different data base servers.
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Wrote complex Perl Scripts to handle pattern search for heavy data loads.
• Modify and made tables for the loading of data from different sources using SQL*loader.
• Used exception methods with pragma exception init to associate customized exception names.
• Used SP transformation for the Datastage Application.
• Handled XML Files for data loading purposes.
• Used UTL file package for automated ETL processes.
• Used APEX to develop end to end Web Application Development.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.

Confidential

Developer

Environment: Oracle 10g, UNIX, Perl

Responsibilities:

• Involved in defining system requirements, designing, developing, testing, training and Implementation of the applications.
• Worked on Kroger Customer Reporting and Loyal Customer Mailer report projects for sending the coupons to different households and find the scoring using the Oracle Analytical functions.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, Primary Keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Cursors, Ref Cursors, Triggers and Packages.
• Extensively worked on Dynamic SQL, PL/SQL Collections for performing DML activities.
• Written the code using the functionality of SAS EG4 to Oracle SQL/ PLSQL.
• Designed and created custom data sets and Proc Sql using SAS Enterprise Guide 4 tool.
• Created the dbms scheduler jobs to run the daily loads for each application.
• Used Oracle Enterprise Manager to monitor the performance of SQL queries step by step.
• Performed De-Normalization of aggregated data for the large set of rows in EXADATA Environment to improve the performance and handle billions of rows.
• Provided production support for the applications
• Interacted with end users and worked on creating the trouble tickets using Team Foundation Server (TFS) and JIRA and participated in daily stand up meetings.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Tuning SQL queries used in the applications to improve performance.
• Participated in application enhancements, fixes and upgrades of database applications.
• Worked with Software Configuration and Version Control tool such as Tortoise SVN