oracle apps consultant

ZAHEER HUSAIN,

Mobile- +91-701*******,

948-***-****, Oracle Apps Techno Functional Consultant

*********@*****.***. Oracle Apps Techincal Consultant

Professional Summary:

Over 5 Years of IT experience as techno-functional and Technical consultant in Oracle Applications (E-Business Suite) Implementation and Support in 11i and R12 with emphasis in Hrms, Finance, Scm and Opm modules. Experienced in requirements gathering, system analysis, design, development, testing, documentation and design reviews.

Strong Technical Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e-business Suite R11i the main concentration being in the modules and full lifecycle software development, support, testing and maintenance of applications developed.

Good exposure in working with XML, BI, OBIEE, ADF, OAF and PLSQL. Hands-on work experience in Form Customization, Form Personalization, Reports and Data Conversions. Experience in Data Load Professional Tool.

Good Exposure to Oracle Application implementation methodology (AIM). Experienced in Developing Technical design documents (MD070), Conversion technical design documents (CV060) and Migration documents (MD0120).

Proficient in customizing Workflow in Oracle Apps. Well versed with Performance tuning concepts such as Optimizer Hints, Explain Plan, SQL Trace and TK Prof. Experience in set-up, configuration, and functionality checks.

Design, Development, Conversion, Customizations, Interfacing and Implementation of business applications using Oracle Applications 11i/R12. Adept in PL/SQL Procedures, Functions, Packages and UNIX shell scripts. Expertise in RICE (Reports, Interfaces, Conversions and Extensions).Experienced in Customizing Oracle Forms with Forms personalization, Custom.pll on Forms 10g/9i/6i/4.5.

Well versed with Performance tuning concepts such as Optimizer Hints, Explain Plan, SQL Trace and TK Prof.

Excellent team player with strong analytical, presentation and problem solving skills. Analytical, methodical and resourceful approach to problem solving, identifying root cause and corrective actions to meet short and long-term business, financial and system requirements, good understating of team management, communication and presentation skills.

Applications and Technology Capabilities:

ERP: Oracle E-Business suite R12/11i General Ledger GL, Accounts Receivables AR, Accounts Payables AP, Fixed Assets FA, Order Management OM, Inventory INV, Shipping WSH, Project Accounting PA, Cash Management CM, Advanced Pricing, Purchasing PO, expense, HRMS, OTL, AOL, System Administrator, BOM, WIP

Application Tools: Reports 6i/9i/10g, Discoverer 4i/9i/10g, XML Publisher 5.6.3/5.6.2, Oracle Forms 6i/9i/10g, Workflow Builder, Oracle Enterprise Manager (2.1.0) and OA Framework.

Databases & Tools: Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages: SQL, PL/SQL, C, C++, Java, HTML, XML

Scripting Languages: Unix Shell scripting

BI:OBIEE till 10.1.3.4.1, XML/BI Publisher

ETL: Informatica6x to 8.6.1, DAC7x to 10.1.3.4.1

Document Methodologies: MD.070, MD.050, CV.060, BR100, BR110

Professional Experience

Anjam Technology – Al Kobar Saudi Feb 12 to Dec 17

Oracle Apps Techno functional Consultant/Developer

SCOPE: Implementation on CORE HRMS, SSHR, OAB, PAYROLL, OTL

Responsibilities

Involved in technical design, development and Unit testing of the Outbound Interface (Oracle HRMS to system). Involved for defining of person types, employees, assigned employees to assignment and then for Payroll and the elements. Assist Functional team in Business Requirement Specification (BR100) for HR and Payroll.

Designed legacy data conversion strategy for HR, Payroll, OAB and OTL modules and performed lead rule for configuration in CRP1, QA and cut-over phases. Involved in business requirements finalization process, assisted fuctional team lead in design, gap assessment, and process redesign sessions. Performed OTL setup by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Preferences.

Configured mapping of timecards elements of OTL with Oracle Payroll earnings for Multi-Payroll environments. Developed functional specification and performing actual conversions from legacy system to Oracle applications. Performed and with a troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.

Analyzed and mapped legacy balances with Oracle payroll elements and prepared technical specification for Payroll Balance Upload. Created Crosswalk table between Legacy and Oracle elements, balances and geo-codes. Conducted meetings and presentations to make the client aware of the balances to be converted from legacy to Oracle for mid-year payroll process. Resolved issues with fast formulas, Elements, setup, year-end processing, tax with holdings, balances conversion and maintenance, employee W2, online pay slips, Employee and Tax balances, involuntary elements, Payroll-Benefit related issues.

Created new elements with compliance to FLSA, PTO plans and fast formulas were created. Assisted functional team and end user for Payroll Pre-processing, Payroll Processing, Process Payroll Using subsets (Assignment set, Consolidation set, Element set), Elements creation, Payroll Post processing, Costing, Year End Process, Federal/State W2, Employee W2, NACHA, Deposit Advices, Direct Deposit, Adjust Balances, Check writer, Quick pay, Rollbacks, Retries, Reversals, Run various reports, Retro pay Process and Absence Management (PTO).

Designed Spec. for month-end Benefit Balance validate and update to Oracle payroll, developed programs to upload time from contingent worker time system to OTL which includes time and project attributes for OTL module. Designed employee date tracked report with payroll balance, new hire report, employee work history report, organization wise payroll summary report which match expanse accounts and prorate regular earnings, over time earnings report for payroll, sick leave report to show payroll deduction history, regular hours worked and earning using PL/SQL, Oracle Concurrent Manager and UNIX Shell scripts.

Designed various inbound interfaces (person import, Email import, Absence import Encryption SSN and IRC auto hire import) and outbound interfaces (TROWE extract 401k, EMEA payroll extract and Ultra link Census Extract).Was responsible in defining Advanced Benefits, Eligibility Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements, Flex credits, Benefit Pools, and Standard Rate Calculation. Was involved in Setting up US Regulatory plans like Imputed Income and COBRA. Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and mapping of Costing fields with Oracle financial.

Was involved in setting Salary Administration setup and absence management. Worked on Catalogue security and managing enrollments in oracle Learning Management. Modified the seeded HR workflow processes as per the needs for Oracle Self Service and Payroll. Created Alerts to send emails to employees on new hired, enrolment or termination of benefits, open enrolment, timesheet entry issues and year-end processing notices. Was involved in Unit testing, System Testing and in phase of UAT across multiple environments.

Anjam Technology – Al Kobar Saudi Feb 12 to Dec 17

Oracle Apps Techno functional Consultant/Developer

SCOPE: Implementation on MRP/MPS, APS (Advanced Planning and Schedule), INV, BOM, WIP, OM, PO, Opm

Responsibilities:

Developed Interfaces to create internal Purchase Order Requisitions and Purchase Orders. Lead offshore team in developing Item Conversion program to import Items from custom applications at terminated manufacturing plants. Developed Conversion program to import customer information corresponding to Obsolete Operating Units to the AR of using TCA APIs.

Developed inbound interfaces for major services to update the pack lists with shipment information and to generate freight invoices for the customers. Enhanced the Shipping Application to provide compatibility with eastern system used at shipping department. Responsible for support activities on an on-demand basis for both custom applications and Oracle Applications.

Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for EDI Vendors', 'Outbound interface for EFL Customers' etc. Designed and customized custom Forms using Oracle Forms 6i.Developed a custom BOM interface using APIs to load BOM from custom application

Developed a WIP Late Job Reason program to determine the late reasons of delayed Shop floor jobs. Customized standard PO Approval workflow to send user notifications for PO approvals based on preset the approval limits Resolved Production Support tickets with a quick turnover time. As part of tuning, created Indexes, Histograms on tables when necessary and made sure the cost of the query executions meets the standards set by the Sony DBAs. Documented the development process as per AIM standards and Sony norms for each object along with the test cases. Impact analysis, design, development, implementation, testing, user training, management reporting, process improvement, Green Belt coaching, techno-functional mentoring. Solve application issues, fix application bugs, production support, and job monitoring, enhancements.

Process improvement using Six Sigma methodology to reduce cycle time and quality of the IT processes for supporting day to day and month-end processes. User requirements gathering, design solution, development and testing. Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers.

Supported production environments and users on a daily basis by responding to emergency requests (24x7)•Developed Forms, Reports, Triggers, Stored Procedures, Packages, Scripts, Menus, Responsibilities, Profiles, Concurrent Programs, etc. to customize the application based on the requirements. Monitor Oracle APS Net change overnight to load back and forth data from Oracle Manufacturing Applications to Oracle APS (where consolidated Planning is performed for multiple sites/orgs)Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online -Oracle Metal ink.

Implementation of MRP/MPS functionality to perform customized planning for specialized turbines and modules

Responsible for gathering user requirements, design solution, development, assigning work schedules and deliverables to developers and testing. Modules setup (MRP/MPS, INV), configuration and implementation involved all the mandatory and optional steps. Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers; also trained users understand different application modules

Supported production environments and users on a daily basis by responding to emergency requests. Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing Migration of OPM setups and Inventory modules. Migration and amendment or integration interfaces within legacy systems.

Support and handling of data for other systems for operations control and productivity measurement. Migration of interfaces from GPRS systems (master items and formulas define tool) to CDOA, OPM (Routings, Formulas and version control) and Inventory. Documentation of enhancements required for migration purposes. Training and handover to team members during and after migration.

Analysis, design and development of new functionality on legacy systems required to work according to new Oracle definitions on the new version. Oracle adjustments made to have OPM running according to business needs (routing deactivation and version control)

Improvement on Oracle resource demand regarding integration data between OPM and Purchasing Support the issues and enhancements related to OPM, Costing, Purchasing-OPM, Inventory and Legacy related interfaces. Team work to improve Oracle functionality and information accuracy within Oracle internal interfaces. Team training for handover and knowledge transfers to allow team involvement into support and new enhancement or implementations. Delivery of metrics for SLA with the different Kellogg business worldwide.

Delivery of control reports and documentation of the improvements and corrections in a monthly basis. Development of new reports and/or improvements of existing ones using Oracle Discoverer and Oracle Reports. Continuous data recompilation to accomplish customer satisfaction. Developed PL/SQL scripts for validating the data and Storing the data into MTL_SYSTEM_ITEMS_INTERFACE and then populating the base tables by running the ITEM IMPORT Interface. Used Bulk Collect feature to improve performance.

Anjam Technology – Al Kobar Saudi Feb 12 to Dec 17

Oracle Apps Techno functional Consultant/Developer

SCOPE: Implementation on AR, PO, AP, GL, SLA, CM, AM

Responsibilities:

Requirements gathering. Setups create COA (Chart of Accounts), create and enable SOB (Set of Books), Calendar and Currencies (multiple), enable Dynamic Entry of new accounts, enable multi-companies. Perform and coordinate Data Loads. Modify and create reports using FSG (Financial Statement Generator).

Use ADI (Application Desktop Integrator) to enter data and export corporate reports to the web. Train users and provide day-to-day support. Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP, GL. Implemented AP Invoice import through Payables Open Interface Import Program.

Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL_Budget_Interface table using SQL*Loader. Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs. Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR_PAYMENTS_INTERFACE_ALL), from interface table to the Base Interim tables and finally to the base table.

enveloped an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables. Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos etc. Customizations of Requisition Approval, PO Approval & Auto Create Workflows.

Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System. Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).Implemented several custom logics for Form Personalization using ZOOM Functionality.

Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU_TOP on forms server of client. Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables. Developed Cash flow summary report, Cash flow detail report, PA_rev_monthly report, PA_rev_monthly_budget report, and Inventory aging report and Asset register report. Customized AR-CE Bank Reconciliation Batch Info Report. Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances. Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer plus and Discoverer Desktop. Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).

Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. Its displays the discount amount calculated for that order basing on the payment terms of the order.

Experience with Oracle Supplied Packages such as DMS_SQL and UTL_FILE.Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets. Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving.

Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.

Designed and developed custom USER APPROVAL WORKFLOW to meet the client application’s user creation and `maintenance according to the business requirement. Worked on Version Control software to check-in codes and integrated with Kintana for file migration. Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files. Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Anjam Technology – Al Kobar Saudi Feb 12 to Dec 17

Oracle Developer

Description: They uses the entire suite of for policy of general and health care in that to give complete solution towards requirement of between policy in motor insurance and general insurances. Designing of entity process based upon functional requirements. It helps in monitoring the transactions of an organization by maintaining the records of the transactions status between customer and banks.

Responsibilities:

Writing and supporting Stored procedures and triggers to generate the details about the sales and production

Involved in Designing forms for auditing the Gross and net sales of customer. Involved in writing unit test cases and testing the application functionality. Design and development of Contractor Price List Form. Design and development of Price List Amendment Form. Involved in the development of SQL*loader scripts and UTL_FILE packages. Involved in performance tuning and also used Hint process. Involved in development of reports based on business requirements and registered them in Oracle applications.

Conversions: Developed Customer Conversion to load historical data into Oracle base tables. Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.

Interfaces: Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report. Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.

Reports: Purchase Report Detailed Item wise allows you to have a detail study of purchases Made during a given period using XML publisher. Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details. Developed Supplier Payments Report using XML Publisher.

Forms: Designed and created custom form using Forms 6i tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated .fix executable file to $AU_TOP on forms server of client. Customized Sales Order Form.

Developed the following custom reports as per user requirements:

1. GNPOC Customer Requisitions Tracking Report

2. GNPOC Customer Order Statistics Report

3. GNPOC Customer Order Monthly Report

4. GNPOC Customer Requisitions Outstanding Report

5. GNPOC Policy Workload Summary Report

6. GNPOC Policy Workload Detailed Report

Educational Profile:

Annamalai university – Master of information technology(perusing)

Anna University - Master of Business Administration in Information Technology (2008)

Bharathidasan University- Bachelor of Arts (2004)

Certification:

OCP (Oracle Certified Professional) from Oracle University.

OCA (Oracle Certified Professional) from Oracle University

OCM(Oracle Certified Professional) from Oracle University

ORACLE HRMS (Oracle Certified Professional) from Oracle University

ORACLE SCM (Oracle Certified Professional) from Oracle University

SAP ABAB HR (Sap Certified Professional) from Sap University

DECLARATION

I hereby declare that the above mentioned information is true to the best of my knowledge and belief.

Contact this candidate