SUMMARY:

• Extensive experience in Implementation, Migration, Customization, Upgrade and support of various modules in Oracle HRMS with major focus in Core HR, Payroll, Absence management, Oracle Fusion HCM - Talent Management .
• Implemented Oracle Fusion HCM(R10) Core HR, Payroll, Benefits, Absent Management, Talent Management
• Oracle Certified Specialist in Human Capital Management and General Ledger
• Experience in HCM Extracts, mass data updates/uploads
• Experience using Fast Formulas in Payroll Calculations, Accrual Plans, Benefits Administration, Validation of Element Inputs or User Tables, Assignment Sets, Absence Duration
• Experience in Oracle Fusion Compensation Management, project exposure on managing compensation, base pay, Individual compensation, personal contribution, Workforce compensation, Compensation budgets.
• Project exposure in Oracle Advance Benefits, Oracle Time and Labour and Oracle Learning Management
• Experience in Administering Workforce compensation and Analysing Total compensation
• Experience in Projects, Budgets, Expenditures, Costing, Billing, Capital Projects, Project status Inquiry, Reports and Listing, Process of Oracle Projects
• Experience in Billing Data Flow for Contract Projects, Overview of Contract Projects, funding a Contract Project, Controlling Billing by Top Task, Quick Agreement / Funding Projects, Accruing Revenue for a Project, Reviewing Revenue, Invoicing a Project, Revenue - Based Cost Accrual
• Experience in Calculating Costs, Distributing Labor Costs, Precedence for Calculating Burden Cost, Burdening (Cost Plus Processing), Storing and Viewing Burden Costs
• Experience in Integrating Oracle Projects with Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Asset, Oracle Human Resources, Oracle Inventory and Oracle Workflow
• Strong programming experience in SQL, PLSQL, Advanced PLSQL. Experience in Oracle 9i,10g,11g databases
• Hands on experience in writing Views, DB link, Materialized views, Partitions, Collections, Triggers, Procedures, Functions, Cursor, XML and PL/SQL Packages, Bulk Collect, For ALL clause, REF cursor, DBMS packages, SQL Loader, Analytical functions, Hierarchical function, Dynamic SQL, Execute immediate in Oracle. Expertise on Query Optimization and Tuning, AWR report, SQL Trace, TKPROF utility.
• Experience in managing major enhancements deliveries. Handled a team of 25+ members covering all phases of the SDLC cycle.
• Experience in other Oracle E-Business Suite modules like AR, AP, System Admin and Application Developer, Cash Management, Advanced Collections, Core HRMS, Payroll, Absence management as well.
• Proficient in business process study (As Is & To Be), gap analysis, cost benefit analysis, business process modelling, process flow & interface design to suit business requirements
• Adept in pre-project studies, project effort estimations, and customer demos/ customer trainings.
• Skilled in managing and negotiating with stakeholders having diverse cultural environments with the accountability of informing them on current and future scenarios, by acquiring feedback on critical issues and taking suitable actions to ensure positive experience and increase in user adoption.
• Expertise in building teams and developing skillsets across technologies, domains and functions in accordance to the business development strategy and sales pipeline / forecast.
• Extensive experience in executing end-to-end projects in domains like Insurance, Airline, ERP HRMS, Self Service Portals (Employee, Customer, Supplier), Bespoke Application Development etc. as per quality & time norms.
• Strong experience of leading & implementing all phases of Software Development Life Cycle using waterfall / agile/devops methodologies.
• Proficient at HRMS User Hooks, fast formula, Conversions, AME, Interfaces, Data migration API and Alerts.
• Pro skills and handled projects with a combination of technologies - Oracle PLSQL, XML publisher, AME, Oracle Forms and Reports, Oracle workflow . Proficient experience in Unix, Shell Scripting .
• Adept in configuring exceptional approvals through Oracle Approval Management Engine (AME).
• Worked for prestigious clients like Aviva Insurance (General and Life), Confidential .
• Focused & committed team player having an Entrepreneurial bend of mind, with an interest in innovative ideas which can turn into excellent projects.
• Appreciated for cordial relationship maintained with customers and ensuring customer satisfaction without comprising on the any quality parameters.

TECHNICAL SKILLS:

Development Technologies: Oracle PLSQL, UNIX Shell scripting, Oracle Forms and Reports, Forms personalization, XML Publisher, AME, Oracle Workflow, Alerts Management.Tools: Toad, PLSQL developer, PVCS Version Manager, Microsoft Visual Source Safe, Data loader, Assyst, JIRA, HP - Quality Centre

Databases: Oracle 9i, Oracle 10g, Oracle 11gApplication/Web Servers: Oracle Applications 11i, Oracle Application Rel12.1.1, Rel12.1.3.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Implementation of Self Service HR by decommission the legacy employee facing portal.
• Implementation of Oracle Absence Management
• Implementation of Oracle Advanced Benefits
• Implementation of Oracle Payroll
• Developing Low Level Design
• Developing interfaces between Success factor and Oracle EBS
• Implementing critical code and data fixes.
• Data Loading through Oracle SQL * Loader
• Developed interfaces through Oracle Advance queues
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data
• Extensively worked on Performance tuning
• Created Materialized views and DB Links
• Invoked Webservices using UTL HTTP API in PLSQL
• Core HR
• Payroll
• Oracle Absence Management
• Oracle Advanced Benefits
• Self Service HR

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Implementation of Oracle Fusion Talent Management under coexistence model with Oracle EBS.
• Configured Complex OBI reports for reporting needs
• Developed interfaces between Oracle EBS and Oracle Fusion instance
• Prepare/Review solution design and implement modular, extendable and accurate solutions.
• Collaborate with customers in outlining business processes and recommend/implement process improvement case studies.
• Gather user requirement on system enhancements
• Accountable for Quality deliverables.
• Document Standard operational procedures and user manuals.
• Conduct training sessions for business units on the all application across HR landscape.
• Head and manage various teams across the SDLC phase of the enhancements/projects.
• Manage the second level user support for the end user community on functional clarifications. SLO tracking for all applications.
• Held presentations to Business users on prototypes, conduct meetings, convert requirements and solution into IT documents, engage users for testing (User Acceptance testing), deliver quality applications to users and train the users.
• Involved in both functional and technical analysis which enables effective gap analysis and propose effective solution.
• Customized reports in OBIEE
• Exposure to Informatica for interfaces.
• Developed Materialized Views, stored procedures, functions, triggers, packages in PLSQL for various business requirements.
• Experience with masking, unmasking of data
• Project Experience in single sign-on, encryption, decryption processes
• Generated and Parsed XML in PLSQL using XMLElement, XMLForest, XMLAttributes, XMLSerialize, XMLConcat, XMLSequenceType, XMLType, XMLAgg, XMLPI, XMLComment, XMLPARSE, XMLRoot, XMLCOLATTVAL, XMLCDATA, DBMS XMLGEN, SYS XMLGEN, SYS XMLAGG, XMLTABLE, XMLParser, XMLDom, XSLProcessor
• Triger Email Notification in PLSQL through SMTP
• Experience in HCM Extracts, mass data updates/uploads
• Experience in Oracle Fusion Compensation Management, project exposure on managing compensation, base pay, Individual compensation, personal contribution, Workforce compensation, Compensation budgets.
• Experience in Administering Workforce compensation and Analysing Total compensation
• Experience in Projects, Budgets, Expenditures, Costing, Billing, Capital Projects, Project status Inquiry, Reports and Listing, Process of Oracle Projects
• Oracle Fusion Talent Management
• Implementation of Oracle Fusion Talent Management under coexistence model with Oracle EBS.
• Implemented Goal Management
• Implemented Performance Management
• Implemented Talent Review
• Oracle Fusion HCM
• Implementation of Oracle Fusion HCM R10
• Implement CORE HR
• Implemented Payroll
• Implemented Benefits
• Implemented Absence Management
• Experience in HCM Extracts, mass data updates/uploads
• Oracle Fusion Compensation Management
• Implementation of Oracle Fusion Compensation Management.
• Manage Compensation
• Manage Base Pay
• Manage Individual Compensation
• Manage Personal Contributions
• Manage Workforce Compensation
• Manage Compensation Budgets
• Administer Workforce Compensation
• Analyze Total Compensation
• Oracle Medical Benefits System
• Implemented Oracle Medical Benefits systems (MedNet International Cloud product) for employee’s group health insurance.
• Interfaces from Oracle Core HR to Medical Benefits systems for HR Data
• Interfaces from Medical Benefits systems to Oracle Payroll for reimbursements
• Interfaces from Medical Benefits systems to Oracle General Ledger for accounting
• Interfaces from Medical Benefits systems to Oracle Account payables for supplier payments

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Liaise with business users to identify cost effective and productive areas of improvement to current operational procedures.
• Prepare/Review solution design and implement modular, extendable and accurate solutions.
• Collaborate with customers in outlining business processes and recommend/implement process improvement case studies.
• Gather user requirement on system enhancements
• Track and manage deliverables from development team. Ensure no slippage of deliverables.
• Accountable for Quality deliverables.
• Document Standard operational procedures and user manuals.
• Conduct training sessions for business units on the all application across HR landscape.
• Head and manage various teams across the SDLC phase of the enhancements/projects.
• Manage the second level user support for the end user community on functional clarifications. SLO tracking for all applications.
• Held presentations to Business users on prototypes, conduct meetings, convert requirements and solution into IT documents, engage users for testing (User Acceptance testing), deliver quality applications to users and train the users.
• Involved in both functional and technical analysis which enables effective gap analysis and propose effective solution.
• Develop effective relationships with clients and partners to exchange information and meet business & operational objectives.
• Delivered solutions for major Emirates departments like Dnata Airport Operations, Emirates SkyCargo, Emirates Engineering and Emirates Airport Services and worldwide employee portal of the company.
• Delivered ERP solutions ( Oracle HRMS ) for several in-house applications.
• Have implemented new process rules within my team with the aim of achieving zero defect and have been successful in delivering the same. My delivery model has been widely acknowledged and practised by other IT business streams in my organization.
• Developed D2k Forms and Reports
• Developed Materialized Views, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data
• Project Experience in single sign-on, encryption, decryption processes
• Extensively worked on Performance tuning
• Invoked Webservices using UTL HTTP API in PLSQL
• Experience using Fast Formulas in Payroll Calculations, Accrual Plans, Benefits Administration, Validation of Element Inputs or User Tables, Assignment Sets, Absence Duration
• Experience in Client Extensions, Project Security Extension, Budget Calculation Extensions, Transaction Control Extensions, Labor Costing Extensions, Labor Transaction Extensions, Labor Billing Extensions, Overtime Calculation Extension, Billing Extensions, Automatic Invoice Approve/Release Extension, Project Workflow Extension, Budget Workflow Extension of Oracle Projects
• Experience in Integrating Oracle Projects with Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Asset, Oracle Human Resources, Oracle Inventory and Oracle Workflow
• Implementation of Oracle Absence Management across 60+ station across the globe
• Attendance management for around 10000+ employees across 60 stations across the globe has been centralized with this implementation. Oracle absence management integrated with HR Self Service was rolled out to emirate employees. Also, handled user training for HR admins on the new application rolled out.
• This project not only brought in centralized management for employee leaves but also help management have better visibility and control.
• Provident Fund & Pension Scheme Revamp (PFPS)
• Design and development of the Pension & Provident Module which involves the complex payroll calculations.
• Developed new Exceptions & Variance reports to be used in Monthly Payroll Processing related to PFPS.
• Created multiple common Web Services to be used for Internal projects and across the Emirates Group for obtaining the HRMS related data from Oracle ERP such as Element Details, SIT Details, EIT Details, Element Entry, Batch Element Entry, Lookups, etc.
• Created various XML Publisher Reports and Oracle Alerts.
• Implemented complex Payroll calculations using Oracle Fast Formulas.
• Developed various interfaces to be used for interfacing PFPS data to integrating systems like Candidate Portal, Employee total rewards (ETR), Oracle ERP etc.
• Oracle HRMs/Payroll Enhancements
• Around 30 + enhancement per quarter were handled by me. These enhancements included automations, integration, regulatory changes and internal HR policies change implementation, and rollout new employee services.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Provide leadership to teammates through coaching and mentoring.
• Participate in peer-reviews, identify and encourage areas for growth and improvement within the team.
• Reviewing the requirements, design, and code for the changes and the new capability enhancements in accordance with established standards.
• Conduct POC and submit proposal to further translate them into projects.
• Coordinating with the Business users to understand the enhancements required and issues faced.
• Carrying out Operational Acceptance for all projects going live.
• Guiding the team towards requirement understanding and resolution of issues
• Ensuring smooth run of period closure activities.
• Implementing critical code and data fixes.
• Data Loading through Oracle SQL * Loader
• Developed interfaces through Oracle Advance queues
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• Experience with masking, unmasking of data
• Project Experience in single sign-on, encryption, decryption processes
• Extensively worked on Performance tuning
• Created Materialized views and DB Links
• Invoked Webservices using UTL HTTP API in PLSQL
• Developed D2k Forms and Reports
• Experience in Project and Labor Cost Security, Multi - Organization Support, Implementation Steps for Each Additional Operating Unit of Oracle Projects
• Interface like OIL (Oracle Integration Layer) for integrating different Underwriters to Oracle collections.
• Interface with Williams Lee for printing Broker’s Statement detailing commissions and premiums generated for Oracle AR.
• Aviva -Oracle Upgrade and Support
• This project was done to upgrade Oracle 11i applications to R12. Modules I was involved are Oracle HRMS, Payroll, Account Receivable and Account payables.
• Post the upgrade, was leading the support team from onsite Norwich (UK) to ensure smooth processing of operations and daily activities.
• Conducting team hurdles to understand and resolves priority issues with the team.
• Weekly customer meets to report on SLA compliance and understand user issues/complaints.
• Automation of Daily Checks/Dashboards. Ensuring smooth run of period closure activities.

Confidential

Technical Consultant

Responsibilities:

• Developed custom reports using D2k
• Used Oracle SQL * Loader to load bank transactions to oracle
• Used XMLElement, XMLForest, XMLAttributes, XMLSerialize, XMLConcat, XMLSequenceType, XMLType, XMLAgg, XMLPI, XMLComment, XMLPARSE, XMLRoot, XMLCOLATTVAL, XMLCDATA, DBMS XMLGEN, SYS XMLGEN, SYS XMLAGG, XMLTABLE, XMLParser, XMLDom, XSLProcessor for xml generation and parsing
• Developed complex queries, joins, stored procedures, functions, triggers, packages in PLSQL for various business requirements
• SQL Query Development and Optimization.
• Extensively worked on Performance tuning of Oracle queries.
• Developed interfaces between Oracle EBS and legacy systems
• Prepare/Review Technical Design Documents.
• Manage the second level user support and SLA tracking for all applications.
• Held presentations to Business users on prototypes, conduct meetings, convert requirements and solution into IT documents, engage users for testing (User Acceptance testing), deliver quality applications to users and train the users.