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

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, Python, Postgress, Linux shell scripting, Oracle SQL Developer, TOAD, JIRA, CRON Scheduler.

Confidential

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.