Oracle Developer

SWETHA J

SUMMARY

Over * years of experience as Techno functional consultant in Oracle E-Business Suite applications.

Over 2 years of experience in Kronos applications as developer and administrator.

Thorough experience in Kronos Workforce Central (version 6.7) suite application.

Experience in working with Workforce central components like Scheduling, Time and attendance and Absence management.

Experience in configuring and modifying Pay Rules based on business requirements.

Experience in monitoring the clocks and debugging, fixing issues in device Manager.

Expertise with Time Card Management, Employee Accrual Maintenance, Access and Process profiles for Managers and Integration of Kronos with Oracle HR system.

Experience working on Workforce Integration Manager and Process designer tools to develop interfaces and process profiles for kronos system.

Experience working on production support activities for kronos system which also includes error fixing for data/process related issues, working with Kronos Support and with end users directly.

Experience working on kronos migration to cloud.

Technical expertise in Oracle Applications R12/11x, across Financials Modules such as Payables (AP), Receivables (AR), Purchasing (PO), Inventory (INV), System administration (AOL) and HRMS.

Proficient in using the tools that support Oracle Applications development including PL/SQL, AOL, Reports, API’s, UNIX and BI Publisher.

Expertise in handling inbound/outbound interfaces for GL, AR, AP, Payroll, daily rates and HRMS information.

Experience in the preparation of Functional Design (MD120), Technical design documents(MD050), business requirement document(BRD) and System test scripts for Extensions, Data migrations, Interfaces, Reports and Customizations.

Experience in retrofitting the 11.5.10 reports, procedures and SQL objects to work in R12 environment.

Have enough knowledge in Oracle SQL, PL/SQL, Oracle Reports, Alerts and workflows.

Have thorough experience with working on SLA model for the production support activities (including communication with end user) in oracle financial modules for 11i and R12.

Thorough experience on software development methodology and Quality Process.

Worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.

Excellent problem solving skills with an ability to identify problems and implement connective solutions.

Have experience in leading smaller teams and preparation of weekly status reports as per business requirement.

Have experience in training junior team members of the business flow, applications used and the process adherence.

Experience in providing Level 2 support to resolve high priority production and support tickets.

EDUCATIONAL DETAILS

Bachelors from SV University, Tirupati, India

TECHNICAL SKILLS

ERP Suite

Oracle E-Business Suite R12/11.x: AP, PO, AR, AOL, I expense, I procurement, HRMS, Payroll.

Database & Tools

SQL, SQL developer, SQL * Loader, Toad.

Oracle Tools

Reports 10g/6i, Oracle Workflow Builder, Oracle Reports Builder, BI Publisher.

Operating System

Windows-95/98/2000/XP/7, NT, SCO Unix-5.0.

Programming Languages

PL/SQL, Oracle Reports.

Other Tools

Remedy, PPM (Project Portfolio Management).

Workforce management Tools

Kronos (Work force Central 6.7 and 8.0).

PROFESSIONAL EXPERIENCE

Emdeon Inc/Change HealthCare, Nashville TN. February 2015 – March 2016

Role: Oracle apps technical developer and Kronos developer.

Description: The project involves support and maintenance activities for Oracle 11i, migration of Oracle 11i components to Oracle R12 and support and maintenance for R12 financial modules. It involves reporting through OBIEE. It also involves HR Employee’s time tracking and attendance, pay roll management through Kronos Application.

Responsibilities:

Involved in the retrofitting and migration of Oracle 11i objects to execute in R12 environment that were used in the BI Publisher reports, AP and HRMS.

Have worked on building and implementing custom program for AP Invoices Interface and Remittance advice email address update for employee suppliers in R12.

Have worked on HR Employee information maintenance from Ultipro system to Oracle and from Oracle to Kronos.

Have worked on developing and modifying, registering of few reports in oracle as Alerts from AP and HRMS modules.

Have worked on creating and managing Pay rules, pay code distributions, work rules, breaks and all related building block components for Pay policies.

Have worked on the new accrual setup, related changes (process profiles, access profiles, interface changes), Employee Migration to new accrual plans and Oracle to kronos interface changes from end to end for 2015.

Have involved in the configuration of Holidays for 2015, access profiles, display profiles and have understanding of core user essential functions including Time card maintenance, Hyper find queries, reports, exceptions, schedules.

Involved in the kronos Interfaces modification/deployment for employee process profile update and accrual plan changes.

Involved in the process profile modification and deployment in kronos WFC.

Have developed and implemented a view in kronos to calculate the Total number of hours worked in a year for all the employees and registering it in Oracle.

Have fixed major issues with Employee missing accruals, accrual mismatch and Carryover balances by providing the data fixes.

Have independently handled the production support issues/tasks raised by the business users and from the ticketing system.

Environment: Oracle11x/R12 Ebiz Financial modules (AP, PO, AR, GL, OM), BI Publisher, APEX, OBIEE, Kronos (WFC 6.7), Oracle SQL, PL/SQL, J Developer.

Magellan Health Inc, St. Louis, MO October 2013 – January 2015

Role: Oracle HRMS, APPS Techno functional / Kronos developer support

Description: The project involves Integration of Oracle Payroll and HRMS with People soft, development of outbound interfaces for oracle HRMS and Payroll data to Cognizant PeopleSoft system. It also involves support and maintenance activities for Oracle 11i, R12 financial modules and development of Hyperion reports and Bi Publisher reports.

Responsibilities:

Involved in the design/development and Testing of Address Interface and Termination Interface which sends the active address information data, terminated employee’s data from Oracle HRMS to PeopleSoft system.

Involved in the development of BI Publisher report for GL Balances data via data template method.

Involved in the development of oracle Queries in Oracle HRMS module for Hyperion Reporting.

Have worked on oracle competences for year 2016 which involved disabling current competences, competence elements and update, load new competences all using oracle API’s.

Have worked on defining elements for Payroll and fast formulas based on business requirements.

Have worked on forms personalization for few forms in HRMS employee screen.

Involved in the production support activities for HRMS and Payroll modules.

Have led team of 4 and involved in preparing weekly status reports for business review.

Have worked on Mass additions for a requirement to capture additional information for employee manager by adding extra field in Assignments screen.

Environment: Oracle11i (11.5.10), R12 Financial modules (AP, PO, AR, GL, HRMS, PAYROLL), BI Publisher, Hyperion, Oracle SQL, PL/SQL, J Developer.

Trizetto R12 migration, Chennai, INDIA January 2013 – August 2013

Role: Oracle apps technical developer

Description: The project involves migration of Oracle 11i components to Oracle R12. It includes Oracle objects migration of database objects like Forms, Reports, and Procedures etc. It also involves the production support for the Oracle R12 environment.

Responsibilities:

Involved in the retro fitment, testing and implementation of Oracle 11i Reports, Procedures to execute in R12 environment.

Involved in the analysis and defect fixing for the issues related to R12 migrated components.

Involved in the Production support activities – Working on the tickets raised in P2p modules, HRMS in R12 environment.

Environment: Oracle11x/R12Ebiz Financial modules (AP, PO, AR, GL, HR), Forms 10g, Reports 10g, Oracle SQL, PL/SQL.

MATTEL Inc., Chennai, INDIA December 2007 – December 2012

Role: Oracle apps developer (development and Support)

Description: The project involves the development and customization of the RICE Components. This involves complete end to end handling of the oracle apps modules data flow, issue fixing, reports, generation, and enhancements in oracle 11i. Production support based on the Incidents rose. Analysis of the system and patches required for migration to R12. Migration of all the modules to R12 and post migration support activities.

Responsibilities:

Involved in the production support activities for 11i financial modules (AP, PO, I expense, I procurement)

Involved in the interface data load handling for AP invoices, AR invoices, GL daily rates, HR and Payroll information on daily basis and fixed issues for error transactions.

Fixed more than 2000 issues in expense and I procurement in the AP module and HRMS.

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', and ‘AR Invoice Import', Customer Import and EDI imports.

Involved in the testing of 11i objects (Procedures, reports, views, custom programs) up gradation to R12.

Have retrofitted few reports and custom programs to work in R12.

Involved in the Production Support activities of the R12 upgrade Project.

Design and Build AP Invoice Interface for loading AP Invoices from legacy system into Oracle EBS.

Environment: Oracle11x/R12Ebiz Financial modules (AP, PO, AR, GL, HRMS, FA, PA), Forms 10g, Reports 10g, ADI, Mark view 170 systems, More 4 Apps, Demantra, Oracle SQL, PL/SQL.

Contact this candidate