SUMMARY:

• 15 years of experience in IT and exclusively 10 years experience in techno - functional Oracle Applications (HCM) implementation, Upgrade,and support and around 5 years of oracle developer software engineer across multinational companies. combines strong core business knowledge in multiple business areas with expertise in a wide range of Oracle Application modules and a solid Technical Systems knowledge.
• Also I was involved in making forecasting models, demand planning and Sales and Operation Planning solutions, designing, developing and testing various conversions, interfaces and batch programs, Reports (Oracle Report/XML Publisher) in Oracle HCM modules .

TECHNICAL SKILLS:

Oracle EBusiness Suite: Oracle Applications R12, 11.5.X, 10.7

Oracle EBusiness Components: Oracle XML Publisher, Oracle Workflow, Oracle Alerts, SQL*Loader

Databases: Oracle 11g (11.2.0.1), Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools: Oracle SQL, PL/SQL, Oracle Reports 10g/6i/2.5, Oracle BI Publisher 5.6.3/10g, OBIEE, Oracle Forms & reports builder.

General Tools: Toad, SQL Developer, Microsoft Office, MS Visio

OS Platforms: Sun Solaris, Oracle Linux, Suse Linux, HP-UX, Windows NT/XP

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Techno-Functional Consultant

• Implement full Cycle for Core HR, Payroll Self-Service, OTL, iRec, OLM, and all of HCM Modules R12.2.5 & R12.2.4 .

• Requirement gathering with analysis on Business dimension, Performing Configuration setup, involving in implementation stages, Project documentation (AIM methodology), Supporting end user related tasks, Solutions to meet the reporting needs of users and Post Go-Live support.R12 exposure
• Involved in the DM and RT-SOP Solution Design process.
• Developed the Functional Design Documents (AIM methodology) .
• Worked with DBA on the performance of various standard collection programs.
• Functional Testing & Conducted various milestone like CRP, UAT.
• Writing Test Scripts (UAT) .
• Writing End User training Documents.
• Delivered Training / end user in Knowledge Transfer Sessions related UAT & PROD.
• Deliver end user training using UPK.
• Support and supervise the functional and technical teams that support Oracle HR Modules to make sure that they are being supported properly, and propose both functional and technical solutions to resolve issues raised by the system users.
• Data upload through Interface tables / SQL Loader and Using APIs.
• Writing and amendments in Fast Formulas for smooth monthly Payroll Processing.
• Resolving day to day functional and technical issues.
• Raise SR’s and handle till the end with the Oracle Customer Support.
• Defined the different payroll elements and wrote Fast Formulas to calculate the different element values.
• Maintained Oracle HRMS Self Service AME Work Flows and defined the approval path of notifications, in addition to defined notification rules.
• Registered the customized forms, reports and PL/SQL procedures in order to use them inside the HRMS.
• Reviewed functional design, created the technical specifications, developed code, unit and integration testing and user acceptance testing.
• Worked with users on daily basis providing functional support as well as technical troubleshooting assistance with the help of Oracle Metalink to ensure the successful running of business operations.
• Interfaced internal IT and business users for problem resolution and system enhancements.
• Trained technical applications users to ensure the correct and proper use the systems.
• Mass upload of different element values using Data-Loader, HR Elements Wizard, APIs, or Scripts and creating batch element entry (BEE)
• Monitored concurrent request manager and submit requests according to a defined schedule or upon request.
• Carried out Payroll processes and solved the payroll problems that have been raised during the monthly payroll run, Also Update Payroll Elements to be met with New Site Requirements.
• Designed and developed technical solutions for HRMS including interfaces, API's, scripts, forms customization and reports development to support the change in business processes.
• Trained technical applications users to ensure the correct and proper use the systems.
• Interfaced with vendors, oracle DBAs, internal IT and business users for problem resolution and system enhancements.
• Dealt with the different Key Flex fields, Descriptive Flex fields, and Values sets.
• Defined Alerts according to specific events such as insertion or updating tables or upon defined time intervals.
• Interfaced between the spreadsheets and the HRMS using ADE (Active Data Exchange).
• Uploaded annual balances of employees’ vacations and sick leaves.
• Develop and Enhance JSP Pages.
• Provided health check and system set up report to improve the system performance.
• Provided system support and involved with technical team in troubleshooting the issues
• Involved in pre-sale activities and managed different RFP documents.
• Provided excellent performance and walk through for SQL code.
• Engaged in the implementation and Go-Live activities.
• Working in XML Reports.
• Working in OBIEE reporting tool.
• Build & Design New Forms
• Build & Design New Reports
• Database Designer
• Write SQL & PL/SQL Database Objects (Packages, Procedures, Functions, Views, Materialized Views, etc.)
• Supporting Existing Customized System.
• Troubleshoot & Solving for Forms, Reports, Database Objects
• Creation of Integration interfaces.

Confidential

Oracle Developer

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling 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.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling.
• 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.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes..
• Created Shell Scripts for invoking SQL scripts .
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Design and develop Oracle forms & reports.
• Performed modifications on existing form as per change request and maintained it.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.