SUMMARY

• Over 8+ years of experience as a techno - functional resource in Oracle E-Business Suite (11i/ R12) implementations, upgrades, and support mainly in the Procure to Pay modules. Well experienced in identifying gaps and developing custom components as per business requirements.
• Strong experience in SQL, PL/SQL and Unix Shell scripting. Proficient in back end programming using Packages, Functions, Stored Procedures, Exception handlers, Views, Tables, Materialized Views, Synonyms, Indexes, Triggers and Bulk Load.
• Worked on various phases of Software Development Life Cycle (SDLC) such as project requirement analysis, system analysis & design, coding, unit testing, quality assurance, project planning and documentation.
• Extensively worked on Oracle applications modules (PO, INV and AP) of E-Business Suite versions 11i (11.5.10, 11.5.10.2) and R12 (R12.2, R12.2.4, R12.2.5).
• Implemented Oracle Application Object Library (AOL) such as Functions, Menus, Responsibilities, Concurrent Programs etc.
• Experience in database design, data analysis, data modeling, development, Query Optimization, SQL Tuning, and Troubleshooting.
• Good experience in working with Autonomous Transactions in PL/SQL.
• Experience in working with SQL *Loader, external tables, import and export utilities, extracting and loading large volumes of data.
• Experience in using SQL TRACE tools for Explain Plan.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Understanding of Big Data Concepts
• Basic knowledge in Python, Spark and Machine Learning models.
• Certified in AWS, Tableau, Oracle Cloud Infrastructure, Oracle EBS Suite, Oracle PL/SQL developer and Oracle database SQL.

TECHNICAL SKILLS

ERP: Oracle EBS R12/Oracle EBS 11i - Purchasing, Inventory, Account Payables, iProcurement

Database: Oracle 10g, 9i

Tools: /Utilities: PL/SQL Developer, Toad, Forms 6i, Reports 6i, Oracle Workflow builder, Oracle Discoverer, Tableau

Language: SQL, PL/SQL, Unix Shell scripting, Hive

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Cleaned dataset using MS excel and Tableau.
• Visualized attendance and revenue data using Tableau.
• Developed forecast model on Databricks CE platform using SQL, Python and Spark.
• Used FBProphet model to forecast time series data.
• Calculated the Mean Accuracy Error of the predicted results.
• Reported the entire findings to the LA Zoo team.

Environment: Tableau, Databricks CE, MacOS

Confidential

Consultant

Responsibilities:

• Resolved Remedy Tickets on priority basis.
• Developed SQL queries as per the business requirement.
• Involved in providing techno-functional Procure-to-Pay (P2P) life cycle support.
• Design custom solutions to meet business requirements.
• Develop PL/SQL Procedures, Functions and Packages to implement business requirements.
• Coached the technical team about issue resolution.
• Created and performed functional testing of all system defects and enhancements
• Created detailed IT Functional Designs (MD070) and test scripts.
• Providing UNIX/PLSQL training sessions to new team members.

Environment: Oracle, SQL, PL/SQL, UNIX Shell script, Oracle e-Business Application R12 (PO, AP, GL, INV, OM), Windows.

Confidential

Subject Matter Expert

Responsibilities:

• Managed all the steps of Software Development Life Cycle (SDLC).
• Requirement gathering, analysis, and estimation after conducting the feasibility study and Impact Analysis.
• Briefed about the progress of our work to the clients in the weekly meeting.
• Design custom solutions to meet country specific requirements
• Worked on DML and DDL changes for Production data and implemented them.
• Created MD070 (Technical design document) for all enhancement requirements.
• Developed scripts for custom tables, indexes and sequences.
• Extensively utilized the Application Object Library to register PL/SQL procedures, reports as concurrent programs.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Worked on Dynamic SQL as per requirement.
• Responsible for creating the Change requests and prepare all the documentation required to move the code changes to production.
• Packaged the components for migration to higher instances using IT Governance tool(Kintana).
• Worked with the DBA team for releasing code into Production database.
• Tested the data in UAT and used to check with the business for signoff.
• Provided warranty support once the code migrated to production.

Environment: SQL, PL/SQL, UNIX Shell script, TOAD, UNIX, Windows

Confidential

Technical Lead

Responsibilities:

• Led the five-member team involved in fixing code with the upgrade of Oracle EBS from Oracle 11i to Oracle R12.
• Redesigned solutions to meet customer requirements and expectations.
• Fixed PL/SQL packages, procedures and views which broke due to the EBS upgrade.
• Tested the fix and preparing test cases.
• Reviewed all deliveries to ensure the quality.
• Managed deliveries for all remediation of all broken RICE objects done by resources working at onshore and offshore.
• Worked closely with functional team members and business to close understand requirements and ultimately pass it on to other RICE members.
• Reviewed all deliveries to ensure quality in terms of Confidential standards for RICE Objects
• Reported the progress of all remediation in the steering committee meetings.
• Prepared test cases, technical documents and functional documents.

Environment: SQL, PL/SQL, SQL*Loader, UNIX Shell script, TOAD, UNIX, Windows XP/2000

Confidential

Developer

Responsibilities:

• Fixed production issues on priority basis.
• Code PL/SQL procedures, functions, packages etc. as part of development and enhancement requirement.
• Root Cause Analysis of production issues and providing temporary and permanent fixes for data as well as program.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Used Toad for creating PL/SQL trigger and sequence.
• Created workbooks in Oracle Discoverer for trend analysis and reporting purposes.

Environment: Oracle, Windows,, Toad, Unix, PL/SQL developer, Workflow Builder, Report Builder, Putty, ITG tool