SUMMARY:

• Result Oriented IT professional with over Thirteen years of progressive expertise in Implementation and Support of Large Enterprise Systems as key resource and working in Oracle E - Business Suite R11i, R12 and Oracle Fusion (SaaS & Private cloud).
• Overall IT industry Experience includes Oracle HCM implementation, Interface Designing and Customization for Oracle Financials, Implementation of Oracle Hyperion planning & Budgeting, Analysis, Development, Integration for Decision Support System and Designing of Plug-in Modules.
• Implementation Experience in Oracle Fusion HCM modules includes Global HR, Global Payroll, Talent management, Compensation and Taleo Recruiting.
• Hands-on experience analyzing the requirements, application design, development, testing and a comprehensive background in Database development and Business Intelligence.
• Worked at Leading Organizations (Private & Public) and got exposure to working with customers in various backgrounds ranging from Financial, Commercial, Technology and Professional Services.
• Hands on expertise in Oracle Fusion technologies includes Enterprise Structure Configurator (ESC), HCM Extract, FBL, HDL, ADF Integration, Data Exchange, Process Scheduler and Manage Configuration Packages.
• Expertise in Setup Migration between Test to Production Instance.
• Experience in TCA Architecture, User Productivity Kit (UPK), Oracle Discoverer, Oracle BI Publisher, BI Answers, Alerts, Oracle Web ADI, Oracle FND libraries, Oracle Application Object Library, Oracle Message Dictionary and SQL*Loader.
• Expertise in data conversion process development using Open Interfaces, PL/SQL, SQL Loader and Oracle APIs.
• Sound expertise in Application Personalization, Approval configuration, Workflow customization, Notification development.
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence OBI EE 12c/11g/10g.
• Expert in development of Test scripts, execution of CRP, UAT and Cut Over plan for Go-Live activities.
• Excellent Self Driven project management skills, Team Player, Good communications, Presentation, time management and prioritization skills.

PROFESSIONAL EXPERIENCE:

Confidential, MA

Oracle HCM Techno-Functional

• Gathered requirements, mapped business processes, gap analysis, conducted test sessions and developed Business Requirement Specification, functional specifications.
• Perform Fusion HCM configuration which includes Functional Setup Manager, legal structure, Employment model, Grade Ladders, work schedule and Payroll Employment Model (active/suspended).
• Liaise with Oracle Support team for Oracle Fusion Patching, Data Masking, Creation of POC instance, Production to test Migration.
• Hands on experience includes Creation & Publishing of Sandbox and Personalization of the Human Resource Dashboards.
• Perform Incremental Loads & Error handling for Fusion Instances using FBL.
• BI/Reporting Migration through Oracle Transactional Business Intelligence (OTBI)/ Business Intelligence Publisher (BIP)
• Liaise with Oracle Support team to Removes bad/incomplete data from tables during initial implementation
• Participated in creating Fusion Security Profile and Data Roles assignment.
• Created Representatives for approval delegation.
• Created Employment Terms to limit or prevent changes made directly to the assignments.
• Hide Portrait Cards & actions via creating custom duties and Roles.
• Created Administrative messages & Calendar Events (Holiday/General Kick-off Meetings)
• Created Model Profile Required Skills & Qualifications for Internal Job Posting.
• Coordinated with OCE for Oracle Fusion related tasks for smooth Implementation & Operations.
• Participated in creating Supervisor Hierarchy, Defined Jobs and Positions.
• Create work schedules for employment contract.
• Created Checklists & actions for respective events (Transition, Hire, Termination, Transfer with in Legal Employers)
• Created Union Representative for approval.
• Restrict the My Portrait Self service functions as per requirement with respect to public.
• Developed tests scripts to validate payroll elements, payroll balances and modified payroll fast formulas.
• Created Model profile for comparison and job eligibility.
• Conducted meetings with client and business user to discuss the balances conversion from legacy to Oracle payroll.
• Created BI publisher reports and conducted train the trainer sessions for ad-hoc reporting.
• Used HCM extract & OBIT for HR data archiving & extraction.
• Configured Global Payroll Legislative rules which includes mapping payroll relationship.
• Performed Global Payroll configuration and set up earnings and deductions, payment methods, payroll flow, Component groups and Element classification required for payroll processing
• Perform balance configuration, initialization and balance adjustment.
• Manage Fast-formula creation & editing for Global Payroll - HCM Extract Formula type.
• Created & Publish Organization Level goals
• Created & Configured Performance Management Eligibility Profile, Lookups.
• Created Succession plans and association of Talent pools with succession plans.

Environment: Oracle Fusion HCM (HR, Payroll, Compensation, Talent Management) - SaaS, ESC, HCM Extract, HDL, ADF Integration, Data Exchange & BI Answers / Publisher.

Confidential

Oracle HCM Techno-Functional Lead.

• Served as an Oracle consultant role for Oracle Fusion HCM cloud implementation.
• Participated in team meetings and was responsible for recommending HCM Technical solutions against functional requirements and fit-gap.
• Providing IT solutions for assigned project scope items and drive them to closure.
• Created Implementation project via offerings in Fusion SAAS.
• Created & assigned tasks to respective team members for smooth completion of project activities.
• Defined Geographies structure & Hierarchy for Address Validation.
• Developed proof-of-concept prototypes models using Enterprise Structure Configurator (ESC) in Oracle Fusion HCM.
• Define Position & Grade Ladders.
• Define Position based Hierarchy.
• Created Eligibility profile for Compensation plan.
• Created Compensation outside of the regular compensation (spot Bonus)
• Created plans for workers (Saving plans for worker)
• Created BI publisher reports as per Statutory Requirements.
• Data archiving via HCM extract.
• Provided Technical expertise for Custom applications data conversion.
• Data loading via File Base Loader (FBL).
• Created & Publish Organization Level goals
• Created & Configured Performance Management Eligibility Profile, Lookups.
• Created Succession plans and association of Talent pools with succession plans.
• Installation & configuration of Oracle Business Intelligence APPS Instance for Oracle ERP 12.2.4.
• Creation of Source (Oracle ERP 12.2.x) in BI offerings.
• Created BI APPS implementation project via BI configurator.
• Defining Data Load Plan & execution via BI configurator.
• Implementation of patches & load plan restart.
• Customizing RPD as per the OBIApps module licensing.
• Online RPD customization.

Environment: Oracle Fusion HCM (HR, Payroll, Compensation, Talent Management) - SAAS, OBI Apps (11.1.1.8), SQL*Plus, TOAD, Linux

Confidential

Techno-Functional

• Interacting with business users for requirement gathering.
• Analyzing business requirements and their fitment into the product and IT architecture
• Create functional documents & designing Application Architecture.
• Designing & Implementation of Business Rules, Task Lists, Forms & Reports.
• Designing & Implementation of Process Management & security model.
• Application Migration between environments (development, test, Production).
• Integration with live systems (GP - Great plans Financial System & DW).
• Conducting “Train the trainer” & End-user trainings.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Repository building (Physical, Business Modeling & Presentation Layers)
• Design & development of Dashboards, reporting, Alerts, RPD.
• Performed patching and upgrading of BI systems across development, test and production domains.
• Performed root-cause analysis and tuning for poorly performing ETL.
• Identified and created aggregate tables to improve query performance
• Implementation of OBIEE 11g advanced features (Master-Detail events, graphs, Range Selector & Slider view, Hierarchical Columns reports, Dashboard Prompts etc)
• Created Session & Repository Variables to achieve desired functionality
• Implemented data Level security.
• Requirement gathering and interacting with IT personals.
• Created connection pools, physical tables, defined joins and implemented authorizations in the OBIEE 11g physical layer of the repository
• OBIEE 11g Data Modeling & Repository building (Physical, Business Modeling & Presentation Layers)
• OBIEE 11g Map viewer integration.
• Presentation of custom spatial data along KPI data in OBIEE 11g.
• Implemented data Level security in OBIEE 11g.
• Demonstrate usage of OBIEE 11g Summary advisor (Exalytics Machine) and comparison with Micro-strategy.
• Demonstrate usage of OBIEE 11g Aggregate persistence and comparison with Micro-strategy.
• Migration between OBIEE 11g Development & Production Instance.
• Created different types of Customized Reports (Drill down, Aggregation) in OBIEE 11g to meet client requirements.

Environment: Hyperion Planning & Budgeting, OBIEE 11g, Weblogic, Oracle Database 11g, TOAD, ODI 11g, Linux.

Confidential

IT Project Manager & Oracle HCM Techno-Functional

• My responsibilities as an IT Project Manager to implement Oracle ERP for 6 African Opcos were as follows.
• Managing Project from Group IT Perspective to be aligned with Group Guidelines for Standardized ERP Processes and Structures.
• Interacting with the Local Implementation Teams & Vendor to ensure that the group policies and procedures are implemented at all levels.
• Worked as HRMS Functional Consultant in Oracle E-Business Suite R12 implementation and applied functional knowledge for business process mapping, HRMS configuration, prototyping, gap analysis, solution design and test scripts, Oracle Human Resource (HR) Oracle Payroll and Self-Service HR (SSHR) modules.
• Assisted functional team in Core HR configurations which includes but not limited to descriptive flex fields, key flex fields, special information types, users, responsibilities, request sets, menus and system profile
• Performed setup for Employment Lifecycle process, Absence Management, Employee Timecards process, Benefits Enrolment, HR Requisitions process for Oracle Human Resource (HR) module.
• Performed configuration for HR organizations, locations, payroll elements, employee costing, job titles, payrolls, application utility lookups, security profiles, system profile, flex fields, key flex fields, validation sets, special information types, users and responsibilities within the Oracle HRMS module
• Lead Integration Designing & Implementation which includes 401k, interfaces using PL/SQL, Oracle API and UNIX Shell Scripts.
• Developed data conversion programs to load employees, addresses, assignment, SIT, EIT, salary proposals, elements entries, costing, beneficiary, emergency contact, open invoices, PO and vendors into Oracle HCM modules.
• ERP & Integration Servers (Oracle Forms & Reports) capacity planning.
• Planning &Designing of integration layer between Oracle ERP & Revenue Applications (Billing & POS).
• Implementing GSI Model for 5 African & Group to reduce License and support cost.
• Implemented Oracle ERP custom module in Oracle Forms & Reports to track the usage history.
• Create usage tracking Reports in Oracle reports and register in Oracle ERP for Management review.
• Deployed Oracle Forms & Reports on Oracle Weblogic Server.
• Designing & Deployment of support model & SLAs with ITL team for Central support of ERP application across Zain Opcos.

Environment: Oracle ERP 12.0.4 (Financials & HRMS)

IT Project Manager

Confidential

• My responsibilities as an IT Project Manager were as follows.
• Interacting with Business Users & Vendor to implement Business Requirements
• Integration with Live Systems (Interconnect, IN, POS, Billing & Astellia)
• Designing of Support Model & SLAs’
• Standardization of Reports & KPIs’ across ZAIN
• Manage work allocation, offshore-onsite co-ordination and Issue resolution
• Assigned & worked as Account Manager of ZAIN Iraq for the Implementation of Data Warehouse (CVD)

Environment: OCDM, Billing, IN, POS, CRM, Interconnect, Astellia (Telecom Network Management)

Confidential

Technical Lead

• Debugging & Up Gradation of RA applications in Oracle Forms & Reports 11g.
• Created Interconnect Reconciliation CDR Application in Oracle Forms & Reports 11g.
• Recovered & saved US$ 125,000revenue from Interconnect Reconciliation
• Created Roaming Reconciliations Application in Oracle Forms & Reports 11g.
• Created IN & CRM Reconciliation Application in Oracle Forms & Reports 11g.
• Created MSC Data Loading, Validations& Network Trend Analysis application in Oracle Forms & Reports 11g.
• Bill daywise Billed Revenue Preparation in Oracle Database.
• Postpaid Package Rating & Billing in Oracle Database & Reports 11g.
• Postpaid Subscriber Reconciliation& Automation.

Environment: Oracle Forms & Reports 10g, Oracle Database 10g, SQL*Plus, TOAD, Linux.

Project Manager

Confidential

• Business Requirement gathering
• Process Model & Data Flow charts Designing
• Created Application in Oracle Database & Forms 11g.
• Created Nation-wide reports in Oracle Reports 11g.
• Train the trainer trainings
• Operational Support Model Designing & Implementation.

Environment: Oracle Forms & Reports 10g, Oracle Database 10g, SQL*Plus, TOAD, Linux.

IT Analyst

• Process Modeling & Making Comparison Reports
• Created Number Inventory & Management application in Oracle APEX.
• Created Number Reconciliation application in Oracle Forms & Reports 11g.
• Created VOMS (Voucher Management System) Reporting in Oracle Reports 11g
• EDMS (Electronic Document Management System) Implementation.

Environment: Oracle Forms & Reports 10g, Oracle APEX, Oracle Database 10g, SQL*Plus, TOAD, Linux.

Confidential

Oracle EBS Techno - Functional Consultant

• Worked with business owners for business requirements finalization and designed training materials and deliverables to bring users up to the extended system functionality for Oracle Payroll.
• Participated in detailed payroll requirement gathering process with client as functional consultant for custom reports to meet the organization requirements.
• Created 6 payrolls to fulfill Employees type Category.
• Prepared specification (MD.050) for customized employee Statement of Earnings, which calculate annualized employee salary by manipulation of furlough time, regular hours worked, over time earnings, sick leave earnings and pay basis elements of prior year payroll.
• Developed custom PL/SQL conversion programs for Payroll Tax element conversion and consolidation using PL/SQL.
• Designed and configured elements, costing options, salary, furlough, absence, wages and taxes for customized employee statement of earnings.
• Part of design team for creating employee date tracked report, new hire report, employee assignment report, earning summary report to show regular earnings, over time earnings, sick leave earnings, regular hours worked.
• Designed extension to enhance Employee Competency functionality to include employee’s affiliations, certifications and degrees in search results of Suitability Matching.
• Performed setup for educations, qualifications, professional qualifications, competency profile, work preferences, resumes and suitability matching modules within Oracle Employee Self Service and Manager Self Service.
• Personalized the Self Service employee competency module to include custom define competencies, like employee work history and employee licenses options.
• Defined payroll earning, deduction, tax and information elements and processed payroll during production support.
• Configured Oracle Approval Management (AME) for Oracle Talent Management and created custom transaction types for employee educations information, certifications information, training, affiliations, skills and competency approval.
• Configured and customized Oracle HCM Workflow and added custom approval notifications to appropriate approver.
• Wrote complex Fast Formulas for employee salary, services and payment calculation in Oracle Payroll module.
• Configured Oracle Web ADI for Oracle Human Resource module to upload employee assignments and created Web ADI integrator using a custom designed API wrapper.

Environment: Oracle HR & Payroll (11.5.10)

Confidential

Sr. Software Engineer

• Business requirement Gathering.
• Created application in Oracle Forms & Reports 10g.
• Register Oracle Forms 11g Application in Oracle ERP.
• Created DB level packages.
• Register Oracle Reports 11g in Oracle ERP.
• Root cause analysis and solution for assigned Production Incidents

Environment: Oracle ERP 11, Oracle Forms & Reports 6i, Oracle Database 9i, SQL*Plus, PL/SQL Developer, Linux.

Confidential

Oracle EBS Technical lead

• Business requirement Gathering.
• Created application in Oracle Forms & Reports 10g.
• Register Oracle Forms 11g Application in Oracle ERP.
• Register Oracle Reports 11g in Oracle ERP.
• Provide test support and post go-live normalization support

Environment: Oracle ERP 11, Oracle Forms & Reports 6i, Oracle Database 9i, SQL*Plus, PL/SQL Developer, Linux.

Confidential

• Collected & Analyzed User Requirements
• Carried out major Modifications to the System Design
• Removed Inconsistencies in Application developed in Oracle Forms & Reports 6i.
• Carried out Testing and Implementation

Environment: Oracle Forms & Reports 6i, Oracle Database 9i, SQL*Plus, PL/SQL Developer, Linux.