Oracle Specialist Resume
0/5 (Submit Your Rating)
SUMMARY:
- Confidential is an Information Technology professional with over 18 years of experience in the implementation of business application software systems. He is especially seasoned with the Oracle EBusiness software in the domain of Human Capital Management and Financial applications. He has extensive experience in leading business application implementations with diverse skills in the areas of Business requirements gathering, Product configuration, Design & Development of Extensions, System Integration and Project management. With experience in consulting and in Information Systems Organizations, he combines project delivery skills with continuous enhancement, sustenance and support.
- Oracle Ebusiness Financials, Human Resources, Payroll applications (Release 11.5.10 and Release 12). Configuration of multiple HCM applications including Human Resources, Self Service, Payroll, Compensation Workbench, Talent Management, Benefits and Time Entry.
- Configuration and Support of Financial Applications of General Ledger, Payables and iExpenses.
- Integration of HCM and financial applications through the usage of cross - functional skills in disciplines as Accounting and Technology.Very proficient with SQL, PL/SQL and Data Modelling.Design and Development of Interfaces, Conversions, and Custom Extensions for several applications.Extensive experience with adjuncts such as Oracle Application Framework (OAF), Oracle Workflo
- Hands on skills with numerous tools including Fast Formulas, Eligibility Profiles, Personalization, Plan Setups, Approval Management Engine(AME), Extra Information Types, Flexfields, Alerts, webADI and Security Profiles.Specialized in the design and deployment of reporting architecture for operational and Analytical requirements.
- Collaboration with Database Administrators in the application of patches, performance tuning and instance strategy.Exceptionally skilled in the documentation of business case justifications, Project Charters, Functional and Technical Specifications.Strong Focus on Customer needs, Timely Delivery, Teamwork and Problem solving.
WORK EXPERIENCE:
Oracle Specialist
Confidential
Responsibilities:
- Provided functional and technical leadership in the conversion of UCMC’s General Ledger and financial reporting architecture from a legacy system to Oracle General Ledger R12. All round responsibility with focus in the following areas.
- Worked closely with the Finance Controller’s staff on configuration choices such as Account hierarchy, approval and posting controls, mass allocations and month end closing procedures.
- Design, development and validation of historical journal conversion, 3rd party interfaces and integration with Budgetary applications and Oracle source sub-ledgers such as Payables, Payroll and Inventory
- Delivery of Financial and Departmental reports using Financial Statement Generator, BI Publisher and Oracle Discoverer
- Leadership responsibility in the upgrade of Oracle EBS applications from release 11i to Release 12.1.3.
- Configuration of Payables, iexpenses, HR, Learning Management and Payroll applications for Release 12.
- Remediation of key CEMLIs in the areas using SLA Architecture and other structural changes.
- Facilitation of user adaptation to new business process with financial applications.
- Execution of User Acceptance testing and cutover.
- Led the implementation Oracle Human Resources applications for UCMC. The phased rollout included Core Human Resources, HR Self Service and Compensation Workbench and benefited over 6000 employees of the Medical Center and around 3000 employees of the University Of Chicago's Biological Services Division. Highlights of this effort include:
- Work Structure Redesign
- Conversion of Legacy historical HCM data and interfaces.
- Conference Room Piloting
- Extensions to support Grade ladder progression of Nursing and other unions that is based on multiple criteria.
- Evaluation and deployment of data security rules, EITs and taskflows.
- Configuration of Self service by leveraging tools such OA Framework Personalizations, Extensions, Workflow and Approval Management Engine.
- Compensation Workbench configuration for annual merit planning through eligibility profiles, fast formulas and plan Personalizations.
- Leadership Role implementation of an Oracle Payroll system for Confidential . Coordinated activities with Finance, Payroll, Human Resources, Benefits, Information Systems departments and external consultants in getting the project delivered on time and budget. Hands on role in the delivery of the following
- Fast Formulas for payroll and PTO accruals
- Design of inbound time entry and outbound extracts to banks, pension funds and Benefit carriers.
- Costing and labor Distributions
- Parallel Test runs, Legacy reconciliations and Cutover.
- Self Service for Payslip view and Absence Entry
- Provided Technical Project Management for the implementation of a Talent Management system as an offshoot of the Human Resources system. Instrumental in the deployment of features including organizational goal setting, employee appraisals, competencies, Compliance tracking and reporting
- Supported the HCM application for sustenance and continuous enhancement. Hands on involvement in job functions including user request intake, change assessments, configurations, technical design and development. Sample assignments include:
- Interface of the university's HR data into a separate business group to support requirements and track personnel movement
- Reconfiguration of Payroll application for FLSA compliance
- Establishment of a HR data mart to track competencies and licenses and feed compliance alerts and job scheduling subsystems.
- Deployment of a variety of HR initiated programs such as Vacation Buyback and Employee Wellness through a combination of Benefit Plan configurations, fast formulas, approval routings and OA Framework extensions.
- Configuration of specialized Compensation Workbench plans related to bonuses & allowances
- Configuration of multiple Individual Compensation Plans with specialized compensation and approval rules using a framework involving
- Payroll issue resolutions, Ledger reconciliation and Year end Support.
- Enhancement of performance appraisal templates for streamlined processing with pdf printing.
- Integration of HR data with third party web services such as Google Maps and a Unique ID generator.
- Coordination of Periodic patching, regression testing and promotion to production.
- Upgrade of Oracle EBusiness applications from Release 11.5.8 to 11.5.10. Related to this effort, determined the scope of the effort, hardware and other infrastructure constraints, created work breakdown for DBA activities, technical rework of extensions, instance planning, testing approaches, user communication and cutover strategy.
- Support of Oracle EBusiness Financial and Supply Chain applications that include the modules of Accounts Payables, Internet Expenses, Purchasing, iProcurement, Inventory
Oracle Consultant
Confidential
Responsibilities:
- Worked as a Lead Consultant in over 15 Oracle Financials and Human Resource implementations over a 12 Year period. Participated in all phases of Project Life Cycle including Requirements Gathering, Gap Analysis, Configuration, Design and Development of Extensions, Interfaces, Conversions and Reports. Worked with clients in diverse industries such as Government, Higher, Health Care, Financial Services, Office Supplies and Manufacturing.
- Single Instance Global Human Resources database for a pharmaceutical supplier with operations in more than 5 countries across the world. Responsibilities included Project Planning, Configurations and Conference Room Piloting.
- Implementation and support of an integrated Human Resources, Payroll, Advanced Benefits and Oracle Time & Labor application for a large county administration and Forest Preserve in Illinois.
- Implementation and support of an integrated Human Resources, Payroll, Advanced Benefits and Oracle Time & Labor application for a medium sized city government in Missouri. Addressed several unique requirements related to a diverse workforce including Police, Fire and Public Works department personnel.
- Design of a business intelligence application through the extraction of Human Resources and Payroll data for a steel industry conglomerate.
- Requirements Gathering and Conference Room Piloting for a Human Resources implementation at a prestigious east coast private university.
- Human Resource and Payroll implementation for a Chicago Suburban community college and a Park District.
- MultiYear Consulting experience in the modules of General Ledger, Accounts Payables, Fixed Assets and Purchasing. Secondary experience with Accounts Receivables, Inventory, Order Management and Learning Management applications.
- Implementation of Financial applications (General Ledger, Purchasing, Accounts Payables) for a Chicago Community College district
- Implementation of Fixed Assets application for a Mass Transit organization
- Led the Design of Data Warehouses and the development of business intelligence applications for a Higher al institution and for a Steel Manufacturing company.
- Worked extensively in the building of custom Oracle solutions for the manufacturing industry with respect to Inventory, Maintenance Management, Forecasting and related areas of Production Planning and Control.