SUMMARY

• Having 5 years of experience as Oracle PL/SQL Developer in teh field of Information Technology.
• Involved in teh Development, testing, implementation and maintenance cycles of teh project.
• Experience in installation of Oracle 10g, 11g and 12c in Unix, Linux, Aix and windows environment.
• Experience in developing complex database objects like Packages, Procedures, Cursors, Triggers and Functions using SQL and PL/SQL.
• Experience in working with databases of size greater than 25TB.
• Experience in creating Tables, Table portioning, Views, Materialized Views, Indexes and Constraints.
• Experience in using Oracle Supplied packages like UTL FILE and DBMS JOB.
• Experience in Advance PL/SQL like Rank, Dense Rank Functions, Bulk Collect and Insert.
• Experience in code migration using Quest Stat code migration tool.
• Experience in Oracle Apps Technical tables and joins.
• Experience in Loading data into tables using SQL Loader.
• Experience in writing complex queries, sub queries and join queries.
• Rebuildingindexes when needed to avoid fragmentation and improve performance.
• Experience in tuning SQL queries using SQL advisory, Explain PlanandTKProf.
• Experience in Data Pump export/import and traditional export/import.
• Experience in writing Oracle SQL, PL/SQL scripts and T - SQL.
• Good working knowledge on ETL and BI Tools.
• Good knowledge on Big data, Hadoop, Pig and Hive.
• Self-motivated and resourceful team contributor, able to quickly grasp new technologies.
• Strong analytical and problem solving skills

TECHNICAL SKILLS

ERP: Oracle E-business Suite R12 (12.1.1, 12.1.3)

Database: Oracle 10g,11g and 12c, MongoDB

Scripting Languages: Unix/Linux shell scripting

Programming Languages: C, C++, Java, C#, Oracle SQL, PL/SQL,T-SQL

IDE: SQL Developer, Toad, Microsoft SQL server 2008, MySQL

ETL Tools: Informatica 8.7.1

BI Tools: SAP BO, Cognos BI

Other Tools: Putty, WinSCP, JIRA, SVN

Operating Systems: Windows, Unix/Linux Families, IBM AIX 5.3, 7.1, Solaris

Office Tools: Microsoft Office 2000. '03, '07, '10, Adobe Acrobat

PROFESSIONAL EXPERIENCE

Confidential

Software Developer

Responsibilities:

• Installation of oracle database, creating logins and managing internal users.
• Installation of Hadoop on different systems for students to use for lab work.
• Querying and analyzing data using Hive.
• Writing programs and executing them on LONI HPC(high performance computing) clusters.

Confidential

Oracle SQL and PL/SQL Developer

Responsibilities:

• Created database objects like Packages, Procedures, Cursors, Triggers and Functions using SQL *plus and Toad.
• Used Advance PL/SQL like Rank, Dense Rank to improve performance based on teh requirement.
• Tuning of long running queries and monitoring teh health of databases using OEM 12c.
• Automate daily activities and certain tasks using Unix shell scripting.
• Good knowledge on Data warehousing concepts like normalization, de-normalization, star, snowflake schemas and dimensional modelling.
• Wroteefficient SQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• CreatedPL/SQL scriptsto extract data from teh operational database into simple flat text files usingUTL FILEpackage.
• Creatingindexeson required tables to improve teh performance to eliminate full table scans and views for hiding teh actual tables from Unauthorized access.
• Worked closely with QA & End users and fixed issues raised during different levels of testing.
• Experience in database export and import utilities EXPDP and IMPDP utilities.
• Creating unit test cases, debugging and maintaining revision history.

Confidential

Oracle SQL and PL/SQL Developer

Responsibilities:

• Created Tables, Views, Synonyms and grants based on teh application enhancement using Oracle SQL Developer.
• Used Bulk collect and Bulk Insert to improve performance of teh queries.
• Tuned SQL and PL/SQL queries based on Explain plan, SQL Trace and TKProf.
• Modified queries extracted from Oracle Discoverer tool and performed data validation.
• Handled errors using Exception handling for debugging and displaying error messages in teh program.
• Created Unit Test case document for teh module developed.
• Validated teh data generated from teh Queries against Oracle Apps Front end forms.
• Developed Query Studio and Adhoc Reports for teh Queries using Cognos BI.

Confidential

Software Engineer

Responsibilities:

• Developed PL/SQL scripts to one time migrate data.
• Gathering requirements from teh Business Users, extracting data from database and creating reports using SAP BO.
• Created Mappings, Transformations, Reusable Mapplets using Informatica Power Center.
• Developed database objects like packages, procedures and functions to implement business logic for migrating data.
• Responsible for handling Customer module in teh oracle system.
• Prepared Low Level Design (LLD), unit test plan(UTC) and Deployment documents for Customer Module.
• Creation of tables in Oracle 11g for Web Data marts.
• Loading data into Oracle 11g using ETL tool Informatica Power Center & Developing Adhoc reports in SAP BO.