We provide IT Staff Augmentation Services!

Lead Oracle Hcm Technical/functional Consultant Resume

Baltimore, MD

SUMMARY:

  • Over 20 years of IT experience as a Sr. Oracle Application Technical/Functional Consultant / Systems Analyst / Programmer/Developer.
  • Very strong in the design and development in various industrial verticals like Public Sector, University, Government, Financial, Manufacturing, Banking, Broad Casting and Business.
  • Involved in Full Lifecycle implementation of Requirement Analysis, Gap analysis, Gap Solution, Setups, Technical Design, Development, Coding, Testing, end - user training, post-implementation support, Customization, Conversion, Migration, upgrades, Patch testing, Trouble shooting Production issues and QA Testing.
  • Experience as Oracle HCM Cloud Consultant and specialized in Oracle EBS11i/R12/Fusion, ability to configure HR, Oracle Advanced Benefits, Compensation Workbench, Talent and have done Integration with Oracle HCM Cloud, using HDL and PBL for HCM components.
  • Expertise in Configurations, File-based loaders (FBL), Spreadsheet loader Payroll Batch Loader (PBL), OTBI Reports, and BI Publisher reports, HCM Extracts.
  • Experience in developing Interfaces for Oracle HCM Cloud and Oracle EBS HR.
  • Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology
  • Expertise in translating functional specifications into implemented technical solutions using Oracle applications supported toolsets.

TECHNICAL SKILLS:

Oracle Applications: Oracle Fusion HCM R11/R12 (HR, Payroll, Compensation, Benefits) Oracle EBS R12/11.i (11.5.10/11.5.9/11.5.8/11.5.7 )/ 11.0.3/11.0.2/10.7 NCA/10.7SC

Modules: HR/Payroll (HRMS), Advance Benefits (OAB), OTA, OLM, Oracle Self Service, Accounts Receivables, Accounts Payables, General Ledger, Inventory, Oracle Purchasing, Oracle Inventory, Order Entry, Order Management, Labor Distribution, Grants, Project Accounting, Application Object Library, System Administration, Oracle Alert, Oracle Workflow, Forms Configurator

Databases: Oracle7.X/8.X /8.i/9.i/10g/11g

Tools: Developer /2000 (FORMS 10g/9i/6i/4.5, REPORTS 10g/9i/6i/2.50), Oracle Discover 4i, Web ADI, OBIEE Tools

Languages: PL/SQL, SQL, C ++, C, PRO *C, JAVA, UNIX Shell Script

Oracle Utilities: SQL*LOADER 7.3

Operating Systems: UNIX (HP, Sun Solaris, AIX, SCO UNIX)

Methodologies: Applications Implementation Methodology (AIM), Agile/Scrum

Other Products: MS Access97, MS SQL Server, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle HCM Technical/Functional Consultant

Responsibilities:

  • Performed Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test script
  • Leading development team on high priority issues effectively.
  • Support existing processes, enhancements, and integrations, including issue resolution
  • Worked on Implementing Taleo Enterprise 15A Recruiting and Onboarding.
  • Worked on Integration between Taleo to ADP for Direct Deposit, W4 Federal and State Taxes
  • Designed and developed Taleo to HCM interface for new hires
  • Designed and developed HCM to Taleo interfaces.
  • Developed and tested Taleo Connect Client (TCC) scripts to developed inbound and outbound extracts.
  • Worked on Salary, Bonus compensation, was involved derived factor, Eligibility Profile, define elements, Compensation Plan.
  • Configure and Manage Benefit programs, plans, plan types and options.
  • Developed outbound Interface for benefit external carrier Kaiser, Delta Dental, Anthem, Discovery Cobra etc. . . .
  • Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits
  • Involved in the writing and modification of Fast formulas used in Oracle Payroll.
  • Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.

Environment: Oracle Cloud HCM Fusion r11/r12

Confidential

Lead Oracle HCM Technical/Functional Consultant

Responsibilities:

  • Performed Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test script
  • Leading development team on high priority issues effectively.
  • Managing Offshore and onsite team. Ability to supervise resources, Priority Setting, Design Approval
  • Work closely with project/team management to ensure timely deliver
  • Work with Senior HR and IT leadership on prioritization and architectural assessment.
  • Work closely with global HR business teams to identify and document requirements
  • Support existing processes, enhancements, and integrations, including issue resolution
  • Converted 10K Workers and related Work Structure using HDL
  • Worked on various Payroll, Compensation and Benefit Configurations.
  • Worked on Salary, Bonus compensation, was involved derived factor, Eligibility Profile, define elements, Compensation Plan.
  • Configure and Manage Benefit programs, plans, plan types and options.
  • Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits
  • Involved in the writing and modification of Fast formulas used in Oracle Payroll.
  • Was involved designed, developed and testing SOA composites and BIP reports for 36 HCM inbound and outbound interfaces
  • Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
  • Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
  • Used MFT to transfer/schedule PGP encryption files to vendor.
  • Open Oracle SR for various issues and for POD instance management.
  • Was involved in R12 Upgrade testing, code migration, instance pointing and redeployments.

Environment: Oracle Cloud HCM Fusion r11/r12

Confidential, Baltimore, MD

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Interacted with client during the Implementation process,
  • Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM
  • Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
  • Have developed the Interfaces back to Oracle EBS HR from Oracle HCM Cloud.
  • Have used the RTF templates and HCM Data model to define the HCM Extracts.
  • Involved in conducting CRP1, CRP2, test data preparation and test scenario preparation.
  • Provided production support during and after HR/Benefits/Payroll and Financial go live

Environment: Oracle Cloud HCM Fusion r11, Oracle Applications R12/11.i (AR, AP, PO, GL, HR and Payroll), Oracle 8.i/9.i/10g, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Confidential, Jamesburg, NJ

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
  • Developed, customized EMSD Web base tools to create AR Customers, Profiles, Invoice setup, Invoice Groups, Billing system with complex programing logic and AR invoices in Oracle
  • Involved in Design, Development, Testing, and Enhancement for HR, Payroll and Base Benefits modules.
  • Were involved tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
  • Worked as a Member of the Production support system to address day to day issues. Daily Development Interaction with Technical leads for status and any other outstanding issues.

Environment: Oracle Applications R12 (HR, OAB, Oracle Inventory PO, AP, GL, AR), Oracle 8.i/9.i/10gSQL, PLSQL, TOAD, Oracle OBIEE

Confidential, Pittsburgh, PA

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Designed and developed Receiving Interface which creates receipts, accept, deliver and adjustment using PLSQL Packages.
  • Used Oracle Standard API to Open PO lines for the day and closed at the end of the day once receipt quantity program completed.
  • Involved in the design and development of inbound and outbound interface HJ third party system to oracle for items, Purchasing, Receipt Interfaces
  • Involved in Designed and developed of custom reports using OBIEE tools like receiving aging, Invoice Invariance, Returns Quantity reports and various HR and OAB reports.
  • Involved HR, OAB setups, Fast formula and Open enrollments process.
  • Involved in OAB conversation from Legacy system and outbound interfaces for external carriers
  • Trouble shooting production issues

Environment: Oracle Applications R12 (HR, OAB, Oracle Inventory PO, AP, GL, AR), Oracle 8.i/9.i/10gSQL, PLSQL, TOAD, Oracle OBIEE

Confidential, Manhattan, NY

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Completed CV20 (data Strategy document), CV50 (data mapping document) and MD 70 (technical document) for client HRMS conversion.
  • Wrote script for employee, Address, Assignment, EIT, SIT, Salary conversion.
  • Configured OAB Program, Plan, enrollment requirements, eligibility profile, Standard rate, variable rates, and life events setup.
  • Was involved in OSB to OAB conversion.
  • Was involved in OSB De-enrollment process.
  • Successfully converted Participants and their dependents Medical, dental, vision benefits.
  • Wrote validation scripts to match pre conversion and post conversion data.
  • Was involved on Open enrollments process.
  • Developed and customized OAB Fast Formula.
  • Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
  • Monitor new hire data interface flow into ADP, ensuring accuracy of data.
  • Customized Oracle ADP views
  • Developed OBIEE reports
  • Ran CRP sessions and user training and test scripts.
  • Developed test scenarios and perform functional testing and document test results.
  • Experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively
  • Extensively used AOL and Sysadmin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields.

Environment: Oracle Applications R12 (HR, Payroll, OAB and AP, GL, AR), Oracle 8.i/9.i/10g, SQLPLSQL, TOAD, Web ADI, OBIEE Tools

Confidential, Manhattan, NY

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Prepared Technical Specs using OUM Methodology, Code review and Code development
  • Prepared Strategy documents for the conversion
  • Gather technical requirements and detailed conversion specifications, including data mapping
  • Converted data from production 11i instance to R12 instance using oracle APIs employee, Address, Assignment History, Secondary Assignment, Payment Method, EIT, SIT, Salary, Qualification, absence conversion.
  • Design, developed and tested PLSQL package for correction/update/insert employees start date, employee’s information and assignment details. Wrote scripts for reversal rehire and reverse termination process.
  • Was involved in 64 business Group implementation and knowledge about localization.
  • Successfully converted Participants and their dependents Medical, dental, vision benefits
  • Was involved on Open enrollments process.
  • Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
  • SQL tuning for reports running slow and PLSQL packages using TKPROF, EXPLAIN plan, applying indexing and HINTS.
  • Conducted successfully Conference Room Pilots - CRP1, CRP2, SIT, UAT
  • Worked with Various Functional issues and Raising TARs whenever it requires for Oracle Standard Functionality support from Oracle.
  • Extensively used AOL and Sysadmin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields
  • Production Support for Financial modules AR,AP, GLPA

Environment: Oracle Applications R12 (HR and Payroll and PA, AP, GL, AR), Oracle 8.i/9.i/10g, SQL *

Forms 6.i, SQL *Reports 6.i, SQL, PLSQL, TOAD, Web ADI, Oracle Human Resource (HR

And Financial Modules)

Confidential, Baltimore, MD

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Analyzed documentation for functional design, technical design and Unit Test Plan
  • Analyzed over 100 pieces of code (RICE) recommended Changes from R11i to R12
  • Designed, Developed and tested XML reports

Environment: Oracle Applications R12/11.i (AR, AP, PO, GL, HR and Payroll), Oracle 8.i/9.i/10g, Forms 10g, Reports 10g, SQL, PLSQL, TOAD, Web ADI

Confidential, Detroit, Michigan

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Prepared Technical Specs using AIM Methodology with all standard documents like CV20, MD 50, MD 70 and MD 120, Code review and Code development.
  • Gather technical requirements and detailed interface and conversion specifications, including data mapping.
  • Thorough Knowledge of Oracle HR/Payroll API’s, Database Items, Balance Packages (Regular and Tax Balance), Payroll Balance concepts (Element Feeds and Dimensions).
  • Converted data from production 10.7 instance to 11i instance using oracle APIs and custom code to add employees, address, assignment history, create contacts and dependents, create phone entries, create positions and jobs, create SITs, load salary proposal including history, add personal payment methods load element entries and programmatically linking elements.
  • Was involved in upgrading oracle 11i to R12.Retrofited custom RICE objects to R12.Upgraded forms and reports from 11i to R12.
  • Developed, designed and tested EEO4 process to merged PPS and oracle data.
  • Developed, designed and tested Project Account to WB interface
  • Prepared Test Scenario’s and Test Scripts for Oracle Projects (Costing, Grants Mgmt. System, Integration - Purchasing, Fixed Assets, Accounts Payables)
  • Modified the UIA interface, Longevity interface and BEE Interface.
  • Involved in Balance Initialization upload .Developed, design and tested to load balances into oracle HRMS
  • Developed, designed and tested Performance details review report, Job code class report, and various audit reports.
  • Developed Batch Element Entry interface Program for the employee assignments element entries.
  • Developed, designed and tested interface to cost Oracle Payroll to General ledger.
  • Wrote scripts to correct Element costing information.
  • Customized seed oracle reports such as Payroll register, check Writer, Deposit Advice and New Hire State Report as per the DTW requirements
  • Designed employee date tracked report, New Hire report, employee jobs history, employee assignment report, organization wise summary report to show regular earnings, over timing earnings, regular hours worked.
  • Wrote Fast formulas for Payroll Elements, Accrual Plans, Absence Duration and Validate Elements for an Assignment.
  • Defined Eligibility profiles, Enrollment Requirements, Plans, Programs and standard rates.
  • Successfully converted employee contacts information and employees OAB conversion Medical, dental, vision benefits.
  • Was involved on Open enrollments process.
  • Developed outbound Interface for benefit external carrier BCBS, Delta Dental.
  • Developed several reports in HR, Payroll and OAB using XML Publisher.
  • Developed, designed and Tested User Responsibility report and this report is view by restricted person only for security purpose.
  • Wrote scripts to reset Oracle user Password and changed password after 120 days.
  • Designed, developed and tested changed user password using form personalization.
  • Performance Tuning of Long running queries.
  • Involved in end-end testing of objects including installation scripts, Download and upload Ltd. files using FNDLOAD.
  • Was involved to open oracle SR/Tar and fixed issue related HR/Payroll/OAB and Financial modules.
  • Was involved in reverse engineering to get data from water department reports and provided audit reports.
  • Wrote scripts to purged Workflow Notifications.
  • Used UNIX shell programming for converting FTP scripts and writing new scripts for oracle job scheduling and file transfer automation.
  • Worked on Noetix View and developed Noetix reports.
  • Involved in post-production support for HR/OTA/OLM/Benefits/Payroll and financial modules.

Environment: Oracle Applications R12/11.i (HR, Payroll, OAB, Self-service, CWB), Oracle 8.i/9.i/10gSQL * Forms 6.i, SQL *Reports 6.i, SQL, PLSQL, TOAD, Web ADI

Confidential, Cleveland, OH

Oracle Application Technical/Functional Consultant

Responsibilities:

  • Understand client requirements, studied existing customizations and Prepared Technical documents MD70 (AIM Methodology), Code review and Code development
  • Developed and executed testing strategy like unit, integration, system integration Testing.
  • Successfully Converted employees information from legacy system using Oracle Standard API
  • Wrote scripts to load Oracle SIT and EIT information.
  • Designed, developed and tested internal and external interfaces.
  • Wrote Fast formulas for Payroll Elements, Accrual Plans, Absence Duration and Validate Elements for an Assignment.
  • Developed and tested reports like Worker Compensation, Stock option using Reports 6i tools
  • Designed, Developed and tested Oracle workflow for salary performance review and sends notification to Supervisor. Wrote script to schedule the workflow.
  • Wrote script to developed Training data which has been use to give training to users.
  • Experience maintaining Oracle Discoverer Administrator Edition including Business area, Table based and custom folder, with appropriate joins, and registering user define PLSQL functions which use in reports and setting access rights and privileges.
  • Extensively used AOL and Sysadmin modules for set up of various concurrent programs, Request sets, Value sets and Descriptive flex fields
  • Provided production support during and after HR/Benefits/Payroll and Financial go live.
  • Developed Interface for BCBS, AETENA, COBRA.
  • Developed Benefit Details and Summary report to get all employees benefits information.
  • OAB fast formula creation/modification

Environment: Oracle Applications 11.i (HR, Payroll, OAB), Oracle 8.i/9.i, SQL * Forms 6.i, SQL *Reports 6. i, SQL, PLSQL, SQL *Loader, TOAD, Oracle Discoverer 4i

Confidential, Mentor, OH

Oracle Application Technical Consultant

Responsibilities:

  • Provided post - production support to client; resolved issues for benefits, assisted users with additional training, and supported Benefits, HR, Payroll and ADP
  • Worked on fast formula.
  • Developed Interface for BCBS Alabama, AETENA, NPA Express Script, Vision Plan and Cobra.
  • Developed and tested FSA Amount report using Oracle report 6i

Confidential, San Jose, CA

Position: Oracle Application Technical Consultant

Responsibilities:

  • Successfully Converted employees, Job, Position, Address, Assignment, Salary using Oracle Standard API.
  • Designed, Developed and tested Oracle HR/Payroll Reports.
  • Created Oracle Alert for Job, Location and Salary Basis changed
  • Involved in Production Support for HR/Payroll problems.
  • Was involved in OAB setup and wrote script to load Open Enrollment benefits legacy data using OAB sequence of API.
  • Wrote PLSQL script to Update Rate value for 401(k) Savings Plan, ESPP - 01/2004.
  • Developed Interface for Great West, AETENA, Vision Plan and Cobra.

Confidential, Baltimore, MD

Oracle Application Technical and Functional Consultant

Responsibilities:

  • Successfully Upgraded HR/Payroll modules from 11.0.3 to 11i.
  • Designed, Developed and tested Oracle HR/Payroll Reports.
  • Provided post - production support to client; resolved issues for benefits, assisted users with additional training, and supported HR and Payroll
  • Customized Optio reports Printed Purchase Order, Printed Change orders, printed RFQ and Printed requisition reports.
  • Developed customized database trigger that populates a custom table whenever expediting-related information is changed on a purchase order shipment.
  • Production support for financial modules.

Environment: Oracle Applications 11.i (HR, Payroll, OAB, PO, AP, AR), Oracle 8.i/9.i, SQL * Forms 6. I / 4.5, SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Confidential, Milwaukee, WI

Oracle Application Technical and Functional Consultant

Responsibilities:

  • Successfully Upgraded HR/Payroll modules from 11.0.3 to 11i.
  • Played active role in the data conversion of all HR and payroll data from over 2 legacy systems, including: preparation of data requirements for the end - user, data cleansing, troubleshooting API loading errors, full testing of converted data and all related processes.
  • PO to IBS Interface, AR to IBS Interface, IBS to AP Interface
  • IBS to AR (AR Lockbox) Interface

Environment: Oracle Applications 11.i (HR, Payroll, OAB, PO, AP, AR), Oracle 8.i/9.i, SQL * Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader, TOAD

Confidential, Morgan Town, WV

Oracle Application Technical and Functional Consultant

Responsibilities:

  • Successfully Upgraded HR/Payroll modules from 10.7SC to 11i.
  • Involved in standard benefit setup, wrote PLSQL program to change benefit (FBMC), terminate the benefit using API.
  • Involved in the setup of Vacation and Sick Accruals. Wrote a PTO accrual report to capture YTD, PTD Vacation/Sick Taken by employees along with Accrued time and net entitlement
  • Wrote PLSQL script, which calls API and Unix Shell Script for student FICA process
  • Forms Configurator to developed WVU Enter Employees info using Oracle template.
  • Designed, Developed, Customized HR and Payroll Reports, Forms, Custom Library according to clients need.
  • Wrote Data Cleanup scripts for HR and PAYROLL Modules.
  • Customized Optio Reports in PO and AR modules to include the university Logo.
  • Customized Oracle forms 6i for the Raise Process and PTN Interface.

Environment: Oracle Applications 11.i/ 11.0.3/10.7 sc (HR, Payroll, LD and Financial), Oracle 8.i/9.i, SQL Forms 6.i/4.5,SQL *Reports 6.i/2.5,SQL, PLSQL

Confidential, Bradenton, FL

Senior Programmer Analyst

Responsibilities:

  • Mapping the Business Needs of the client to identify the areas that need customization and the set - ups required for implementation.
  • Upgraded Oracle Application from 11.0.3 to 11.i and performance Tuning.
  • Wrote PLSQL scripts, which calls API for Employee Atomized Process includes Create Employee, Create Address, Update Assignment, Update Assignment Criteria, Update Federal Tax Rules, Update State Tax Rules Update City Tax Rules, Update County Tax Rules, Create Salary Proposal, Create Payment Methods.
  • Developed and tested interfaces like Balance Initialization process and Element Entry.
  • Involved in the design and implementation of WEB Time Card application to feed Timecard entries into Oracle Payroll using Batch Element Entry (BEE), designed the interface to upload the Pay Batch Headers and Lines Tables.
  • Customized the Oracle Payroll Register report.
  • Designed, Developed the Reports, Forms, Custom Library according to clients need.
  • Worked on Oracle Advance Benefits, Oracle Self Service modules.

Environment: Oracle Applications 11.i/11.0.3 (Hr., Payroll and Financial), Oracle 8.i/9.i, SQL * Forms 6. i/4.5, SQL *Reports 6.i/2.5,SQL, PLSQL, SQL *Loader

Confidential, Melville, NY

Programmer/Analyst

  • Has worked on Data Conversions from legacy to Oracle Applications. Developed, designed, Customizations HR and Payroll Interfaces.
  • Developed and tested custom reports e.g. EEO Reports, Fiscal Budget, and Accrual Report using Reports 2.5.
  • Customized Fast Formula for the Oracle standard benefit element.
  • Was involved in item upload

Environment: Oracle Applications 11.0.3(Hr., Payroll and Financial), Oracle 8.i, SQL * Forms 4.5, SQL Reports 2.5, SQL, PLSQL, SQL *Loader

Confidential, Morgan Town, WV

Programmer/Analyst

Responsibilities:

  • Interacting and Understanding the Client requirements
  • Working as Oracle Application System administrator and giving postproduction support. This
  • Involves Setting up new users, Personal Profile Options, Responsibilities, Menus, Request
  • Groups, Registration of new Reports and Forms etc.
  • Wrote a PLSQL scripts, which loads Batch Element Entry for Fringe Benefits Management Company (FBMC)
  • Wrote a PLSQL Script which End dates the Supplemental and PEIA Elements and Nullifies the AT amount Freezing the Benefits salary and Changes into PEIA Coverage

Environment: Oracle Applications 10.7 NCA (Hr., Payroll and Financial), Oracle 8.i, SQL * Forms 4.5, SQL *Reports 2.5, SQL, PLSQL, SQL *Loader, SQL Navigator

Confidential, Troy, MI

Programmer/Analyst

Responsibilities:

  • Upgraded Oracle Application from 10.7 to 11.0.3
  • Involved in Balance Initialization Upload
  • Interfaces for Merill Lynch Report, 401k related information.
  • Customized Standard Oracle Reports like Payroll Register report, Checkwriter and Deposit Advise Report.
  • Design, developed and tested the following Reports
  • W2 Balances reports, Employees Quarterly Federal Wages/State WagesEmployees Check Registrar Report, costing Report and Garnishment Register Report,
  • Used NOETIX view to developed many reports.
  • Production support for AR/AP/PO and GL modules.

Environment: ORACLE APPLICATIONS 11.0.2/11.0.3 (HR/PAYROLL AR/AP/GL), UNIX SCRIPTS

Confidential, Detroit, MI

Programmer/Analyst

Responsibilities:

  • Employee Upload (Nearly 30,000 Employees Loaded in Oracle Applications from Legacy system), Job Upload, Position Upload, Terminate Employees, Personal Payment Method
  • Mass updates of Jobs and position
  • Balance Initialization Upload
  • Element Entry Upload (used Batch element Entry method to load elements)
  • Reports: Third Party Payments FOC, Employees 401k Eligibility Report

Environment: ORACLE APPLICATIONS 10.7(HR, Payroll and Financial), ORACLE 7.3, DEVELOPER/2000

Confidential

Sr. System Analyst

Responsibilities:

  • Wrote PLSQL packages using API to convert legacy data to Oracle Application HR and Payroll modules.
  • Developed and tested Oracle Payables Open interface import to load Different Methods of Submitting Concurrent Programs ( CONCSUB, FND REQUEST)

Environment: ORACLE APPLICATIONS 10.7, ORACLE 7.3, DEVELOPER/2000(FORMS 4.5, REPORTS 2.5)

Confidential

Sr. Analyst/Programmer

Responsibilities:

  • Developed, designed, tested complex forms and reports using tools developer 2000 (Forms 4.5, Reports 2.5).
  • Wrote PLSQL packages, database triggers, performance tuning for various process.

Environment: PRO*C, ORACLE 7.1, DEVELOPER 2000 (FORMS 4.5, REPORTS 2.5), PLSQL, SQL

Confidential

Analyst/Programmer

Responsibilities:

  • Involved in the analysis, designed, and development of an E-Mail System.

Environment: C, SQL, and PLSQL

Hire Now