SUMMARY

• IT professional as Oracle Developer in Oracle 18c, 12c, 11g, 10g versions and IT experience in Software Development/Maintenance & Production Support Projects.
• Technical areas of experience related to PL/SQL, Informatica, and UNIX & Shell Scripting.
• Experienced in complete life cycle Implementation of PL/SQL Development.
• Experienced in working in OLAP and OLTP Database environments.
• Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization.
• Performance tuning and optimization using Explain Plan, SQL*Trace, and Oracle Optimizer hints.
• Experienced in PL/SQL Performance Tuning using Bulk Collections and other optimization techniques,
• Expertise in Dynamic SQL and Exception Handling.
• Expertise in Data Integration of data from various data sources like SQL Server, Oracle, Flat Files, and XML files and Data Migration.
• Experienced in working with high availability and scalability databases.
• Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, HINTS, DBMS STATS etc.
• Experienced in importing data from Flat files from Legacy Applications to Oracle DB using SQL Loader.
• Creating Users, Roles and Profiles, Privilege management with role - based security.
• Expertise in Data Warehousing and ETL concepts.
• Good Exposure to Informatica Transformation concepts.
• Expertise in handling 24/7 Production Support projects.
• Good exposure to Development, Testing, Production Support, Debugging, Implementation and Documentation.
• Experienced in Requirements Gathering and Preparing Use Cases.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and Hints.
• Comprehensive and in-depth experience using the System Development Life Cycle (SDLC).
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• A self-motivated, responsible, and reliable team player with a set of strong technical skills.
• Strong conceptual, business, analytical skills, and innovative problem-solving abilities.
• Good communication, interpersonal and problem-solving skills.
• Expertise in Client-Server application development using Oracle 11g/10g PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 11g/12c, 18c using SQL, PL/SQL.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modelling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, and Indexes.
• Integration of Oracle APEX with Oracle EBS.
• Experience in APEX reports queries& report Layout.
• Good knowledge in front-end development using APEX.
• Strong experience working in EBS, in the modules: AP, AR, GL
• Good knowledge working in EBS, in the modules: INV, BOM, HCM

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c/18c

Other Technologies: Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN

Languages: SQL, PL/SQL, Apex.

ETL Tools: ODI

Data Warehousing: ODI

Dev. Tools: Windows/Linux Environment, Eclipse.

Tools: TOAD, SQL*PLUS, SQL Developer, Forms 10g, Reports10g, Workflow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Analise, design and solve tickets assigned in order to fix issues, bugs present in the business system
• Monitor the tickets in the Jira platform.
• Create documentation in the company wiki page.

Confidential

Oracle EBS Developer

Responsibilities:

• Analyze business processes in order to make to necessary adjustments so the current functionality prevailed when the EBS incorporates a new organization unit. Create official technical design documentation explaining how to create and implement the adjustments and goals.
• Deliver the installation package so it could be deployed in the Production environment and monitor it.

Confidential

Oracle EBS Application Consultant

Responsibilities:

• Analyze business processes in order to make to necessary adjustments so the current functionality prevailed when the EBS connected to a newer version of the Retail System. Create official technical design documentation explaining how to create and implement the adjustments and goals.
• Audit the product and tests created by Development department according to company and Oracle coding standards.
• Being a link between the EBS instance owner and the Development department for reviews about the product created according to the technical document.

Confidential

Oracle Analyst Pl/Sql Developer

Responsibilities:

• Analyze requests, design the best, practical and efficient solution, build the development, test the development and analyze the results, release in Production environment.
• Creation, modification and enhancement of DB objects as: procedures, functions, packages, triggers, cursors, indexes, tables.
• Creation, modification and enhancement of Oracle Forms objects as: forms, queries, program units, parameters.

Confidential

Oracle EBS and Pl/Sql Developer

Responsibilities:

• Analyze requests, design the best, practical and efficient solution, build the development, test the development and analyze the results, release in Production environment.
• Creation, modification and enhancement of EBS objects as: concurrent programs, lookups, flexfields, bank check printing format, and xml based reports.
• Creation, modification and enhancement of DB objects as: procedures, functions, packages, triggers, cursors, indexes, tables.
• Creation, modification and enhancement of Oracle Forms objects as: forms, queries, program units, parameters.
• Creation, modification and enhancement of Oracle Reports objects as: forms, queries, program units, parameters, formulas.

Confidential

Oracle EBS and Pl/Sql Developer

Responsibilities:

• Analyze requests, design the best, practical and efficient solution, build the development, test the development and analyze the results, release in Production environment.
• Creation, modification and enhancement of EBS objects as: concurrent programs, lookups, flexfields, bank check printing format, xml based reports.
• Creation, modification and enhancement of DB objects as: procedures, functions, packages, triggers, cursors, indexes, tables.
• Creation, modification and enhancement of Oracle Forms objects as: forms, queries, program units, parameters.
• Creation, modification and enhancement of Oracle Reports objects as: forms, queries, program units, parameters, formulas.