SUMMARY

• Over 12 years of experience in IT industry mainly in design, development, implementation, testing and documentation of business applications using Oracle/UNIX/Oracle Data Integrator (ODI), Hadoop, Hive and Pig technologies.
• Proven experience in PL/SQL that includes Cursors, Ref - cursors, Bulking techniques, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, Exceptional Handling etc.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Good understanding of RDBMS, Oracle Database architecture, design and performed some DBA duties, such as Table partitioning, import/export and data pump.
• Solid experience in performance tuning and Query Tuning (Using Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF etc.).
• Experience in using SQL tools like Oracle SQL Developer, TOAD and PL/SQL Developer and SQL*Plus.
• Excellent Knowledge of Extraction, Loading and Transformation process (ELT).
• Expertise in Production Support activities and documenting the Abend resolutions for root cause analysis.
• Ability to work on complex technical assignments and ensuring the timely deliveries.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
• A Team evolved person with excellent organizational, verbal, written communication, presentation and understanding skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, ODI 11x, C, Pro*C/C++, Hive, Pig.

Database: Oracle 11g/10g/9i/8.x.

Operating Systems: Windows 98/2000/XP/NT, MS DOS, UNIX, Linux

Web Technologies: XML, HTML, Java Scripting.

Scripting: Unix/Linux Shell Scripting, Python/DSD/TCL Scripting.

Tools: SQL*LOADER, SQL Navigator, Oracle SQL Developer, PL/SQL Developer, SQL*Plus, TOAD, SVN, Text pad, MS-Office Suite, JIRA, Gitlab, ClearCase and ClearQuest etc.

PROFESSIONAL EXPERIENCE

Confidential, GA

Sr. Oracle Database PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Involved in Designing schema and schema objects.
• Review of Test Cases and System Testing.
• Developed various Complex Queries, Views for Generating Reports.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Implemented migration from Oracle to Postgress.

Environment: Windows 7 Pro, Oracle 12c, Pl/SQL, SQL*Loader, Ajile, Postgress, Linux shell scripting, Oracle SQL Developer, TOAD, JIRA, CI/CD using Jenkins, CRON Scheduler.

Confidential, GA

Sr. Oracle Database PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Involved in Designing schema and schema objects.
• Review of Test Cases and System Testing.
• Developed various Complex Queries, Views for Generating Reports.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Re-org the large volume of tables to achieve better performance.
• Implemented Hadoop jobs using hive to convert existing high data intensive jobs.

Environment: Windows 7 Pro, Oracle 11g/12c, Pl/SQL, SQL*Loader, Hadoop, Hive, Pig, UNIX shell scripting, Linux, Oracle SQL Developer, TOAD, JIRA, CRON Scheduler.

Confidential, OH

Oracle PL/SQL Computer Programmer

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Developed interfaces, packages, scenarios and Load Plans in ODI.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Involved in creating schema design and objects.
• Review of Test Cases and System Testing.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Developed various Complex Queries, Views for Generating Reports
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Job Scheduling using ODI and CRONTAB.

Environment: Windows 7 Pro, Oracle 11g/10g, Pl/SQL, ODI, Oracle Apex 4.1, SQL*Loader, Linux shell scripting, Oracle SQL Developer, PL/SQL Developer, AccuRev, CRON Scheduler.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Did thorough analysis of the requirements and prepared the detailed analysis reports and estimations for work requests.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Developed various Complex Queries, Views for Generating Reports.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Tivoli.
• Creating new jobs in Tivoli and scheduling them as per Business requirements.
• Loading data from flat files into database tables using SQL* Loader.
• Did the database export/import activities for core data.
• Effective Interaction with Support and other Application groups through on call for high priority issues
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue or an RDBMS issue.

Environment: Windows XP Pro, Oracle 10g/9i, Pl/SQL, SQL*Loader, UNIX shell scripting, Explain Plan, TKProf, Oracle SQL Developer, Toad, Tivoli, Javascript, Clear Case, Clear Quest.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Translating business rules into procedures, packages, database triggers and functions using PL/SQL.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Data from Flat Files been uploaded into Staging Tables using SQL* Loader.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Autosys.
• Did the Check-out/Check-in process (version control) using IBM Clear Case and used Clear Quest for Bug tracking.

Environment: Windows XP Pro, Oracle 10g/9i, SQL, Pl/SQL, Pro*C/C++, SQL*Loader, UNIX, Explain Plan, TKProf, Toad, Tidal, Clear Case, Clear Quest, Edit plus.