Home » Other » Marketplace » Oracle HRMS Functional Consultants
| Oracle HRMS Functional Consultants [message #106420] |
Tue, 08 July 2003 13:43  |
Amy Bergin, DARC Corporat
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
DARC Corporation is a leading provider of Oracle Applications technology solutions, including implementation and upgrade consulting, education services, and Oracle integration software. With over 10 years of experience dedicated to Oracle Applications, DARC ensures success for its clients using Oracle’s e-Business Suite. Headquartered in Chicago, with offices in Dallas, Washington, DC, and San Francisco, the firm serves both middle-market and Fortune 1000 organizations throughout North America and across the globe.
DARC Corporation was founded by a group of the first Oracle consultants that delivered the Oracle Applications to marketplace. It has been our goal from day one to set industry standards for expertise and client service in the Oracle Applications market. We believe in a team-oriented commitment to customer service, a consistent focus on core competencies, and the pursuit of innovation.
DARC Corporation offers a very unique organizational culture in which innovative thinking, strategic planning, and cutting edge technologies are utilized to develop the value-added solutions our clients and employees depend on to get ahead.
We have career opportunities available for Oracle Consultants with 2-3 years experience implementing Oracle HRMS 10.7 - 11i. You must possess a demonstrated ability to perform requirement determination, mapping and gapping, solution design, application set-up and usage, and possess an understanding of the underlying application table structure.
Ideally, you will have completed at least 2 full life cycle implementations with Oracle Payroll, possess outstanding communication skills (verbal and written) including the ability and willingness to direct/mentor a team of on-site staff consultants when needed.
Prior experience with Oracle r11.03 or higher, Discoverer, ADI, Workflow, SQL, PL/SQL, Developer 2000, SQL*Loader, SmartDB, etc. would be a plus.
If you are interested in learning more about DARC Corporation or would like to submit your resume for consideration, please contact Amy Abbott, Director of Resource Planning at aabbott@darc.com
Please visit our web site at http://www.darc.com
|
|
|
|
| Re: Oracle HRMS Functional Consultants [message #106682 is a reply to message #106420] |
Sun, 21 March 2004 16:53  |
Ramakrishnan Gopalan
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
RAMAKRISHNAN GOPALAN
Cell: 408-230-8951
Home: 408-749-1495
Email: ramgopalan@hotmail.com
Profile Summary
Highly motivated, energetic, and focused analyst with progressively responsible and highly diversified experience in the field of Information Technology. Possesses excellent organizational, planning and leadership skills with the ability to communicate throughout an entire client organization. Excellent expertise in designing and developing IT systems and excellent experience in Systems Integration Projects.
Specific Expertise
Extensive Knowledge of Oracle Applications 11i - Oracle HRMS, Oracle Payroll, Oracle Benefits, Oracle Time and Labor.
Strong knowledge and experience with Oracle System Administration and Application Developer functionality such as registering Concurrent Programs, Executables, Form Functions, Defining users, administer responsibilities, adding custom reports/processes to request groups and several other related tasks.
Database design: entity relationship, logical/physical, process modeling;CASE tools.
Relational database analysis/programming using Oracle, Sybase etc.
Designed and Developed Inbound and Outbound interfaces.
Designed and Developed Assignment, Element Entries and other conversion scripts for converting from Legacy System to Oracle Applications 11i.
Expertise in customization of Forms and Reports.
Software requirements analysis and design specifications.
Professional, Graphical user interface and navigation design.
SQL* Plus Reports Design and Development
Internet/intranet architecture, web transaction processing.
Advanced HTML, Perl 5.0/CGI scripting using Javascript for validation.
Familiarity with DOS, Win3.x, Win9x, WinNT and Unix platforms.
Technical and user documentation.
End-user and developer training.
Computer Systems Experience
Oracle Products Oracle HRMS 11i (11.5.3 - 11.5.9), Oracle v7.x, Oracle v8.x, Oracle v9.x (including 8i and 9i), SQL*Loader, PL/SQL, SQL*PLUS, Oracle Developer 6i, Designer 2000, Toad, SQL Navigator
Operating System Unix, Windows NT 4.0, Sun Solaris, MS-DOS
Other Software Javascript, Perl 5.0/CGI, DHTML, HTML, Sybase 11.5, Fortran 77
Courses
Introduction to Oracle 8i: SQL and PL/SQL; Advanced PL/SQL Programming; Oracle8 Performance Tuning Workshop
Professional Experience
Xoriant Corporation, Sunnyvale, CA Senior Consultant
Feb 04 - Present Client McGraw Hill (Through AppShop)
Verified setups for Oracle Order Management in McGraw Hill. Checked if the setups are correct from one instance to other and then migrated the correct setups to production. Verified if the production setups are correct or not. Checked if the Dynamic Flex Field, Lookups and value sets are correct by writing sql scripts to fetch the setup data from the database and comparing it from one instance to other.
Dec 03 - Jan 04 Client Dresser Inc. (Through Bearing Point)
Designed Benefits Outbound interfaces (Eligibility Interfaces) for Dresser as a part of implementing Oracle Applications 11i. Designed the system extracts for the interfaces by specifying the data file layout (Record layout) and also specifying other information like Extract Criteria and Advanced Conditions. Both types of extracts Full feed and Changes only extracts were designed for the interfaces. Developed a means of loading the system extracts to be created in the application into the system. Used FNDLOAD as well as API’s for doing this. Specified the layout of the api’s for loading the attributes of the system extract. The api’s used were to load the Data Elements, Records and File layouts. The api’s were also called to load the extract criteria and extract definitions. Wrote PL/SQL packages that utilized these api’s to load the extract definitions into the database. These packages called the api’s with the appropriate parameters for loading the extracts into the database.
Designed the Conversion process for converting the Element Deductions and W4 tax information from the legacy system to the Oracle Applications 11i. Specified the api’s to use and the mapping of the parameters to the api to the staging table for doing the conversion. Designed the staging table and the error table for doing the conversion. Specified the data file layout (the input from the legacy system) for the conversion process.
Jan 01 - Nov 03 Oracle Corporation, Redwood Shores, CA Senior IT Analyst
(Internal IT - HR & Payroll)
Developed the Benefit extracts for sending information to Vendors about benefit deductions by employees to different Vendors. Vendors in question are Watson Wyatt, Fidelity, Liberty Mutual and CNA. The benefit extracts provided the employee deductions to the vendors for the employees in Oracle Corporation who opted for the deduction. Both positive and negative deductions of the employees were sent to the Vendors for them to administer the benefits. Written packages that will capture change events through triggers on database tables. These change events were custom and needed to capture changes in the columns of the tables.
Developed the BEE Zone application that can be used for uploading the element entries that is available as a flat file. Developed the form for setting up the interface. The setup can be done for the header, trailer and detail record for the interface flat file. Also developed the concurrent program that uses the set up of the interface flat file and loads the data into the Batch Element Entry module. Various element entries for various employees could be loaded into the BEE for ultimately entering into the element entries table. These information could be loaded into the BEE from a flat file with a pre-designed format. Designed the interface database staging tables in which the flat file information is loaded. Developed the concurrent program which calls a PL/SQL package. This package has the code that will load the flat file data into the batch headers and batch lines of the BEE. The package has the code that will verify the header and trailer information and then load the data into the tables.
Developed the Projects to Payroll interface that is used for transferring the time entered in the projects application and transfers that to the BEE. This interface transfers the captured time to the BEE through a registered concurrent process. Different types of tasks like Vacation Pay, Jury Duty, Pager Pay etc can be handled by the interface. Different kinds of time of the employees of the business group could be loaded through projects and these entries were extracted into BEE for loading the absence and the time entries into the absence form and the element entries forms and tables respectively. Designed the database staging tables in which the projects information is loaded. Developed the concurrent request that calls a PL/SQL package. The package then extracts the time captured in the Projects tables and then inserts into the BEE tables. These batches when loaded will create the element entries and the absence entries.
Developed the United Healthcare Interface that provides the Deduction information to United Healthcare (Vendor) for all the Oracle Employees with Healthcare and Dependent care Deductions in each payroll period. This information will be used by United Healthcare for reimbursing the employees of their Healthcare expenses. Designed the database staging tables in which the deduction information is loaded and from which the data of the interface is queried. Developed the PL/SQL package that gets the UHC deductions for all employees who have the deduction by using balance calls. These deduction information is sent to the output file through utl file utility and this file is sent to the vendor who pays the employees the claims.
Developed the Oracle Time and Labor web report. This is an application that is launched from Oracle self service that displays information about the employee’s time information that they entered through the Oracle Time and Labor. It displays the time information for all employees for a particular manager. The user selects an employee under him and provides the time range for which the report has to be run and the report displays the time information entered. The vacation time for all the employees themselves or the employees under a manager could be got from the web report. The vacation accrual and the carry over from the previous year can also be got from the report. Developed the PL/SQL package that will display the web template from which the user runs the report. Once the report is run the package will get the data from the database and send it to the web page which will display the data.
Developed the Contractors Data Mart is a web application that is launched from Oracle self service which is used to maintain information about people who are Contracting at Oracle. This application provides facilities to search the contractors database for obtaining information about them or to enter information about new contractors. This information is used by security to view the contractors information. This application is used by Oracle Security for maintaining information about contractors. Designed the database tables in which the contractors information is stored. Developed the PL/SQL package which will display the screens that are used in the Contractors Data Mart. The package when called will display the search screen through which the contractors information can be searched. The package also allows the user to insert a new record or update the existing record for the contractors concerned.
The Global reports are a set of reports that provide different kinds of information including compensation information to users about employees of Oracle. Other reports developed provide the above information for new hires in a given period and terminations in a given period. This information is used by Corporate Compensation within Oracle for analytical purposes. Written the SQL Plus scripts that will fetch the data from the database in the reports.
Made enhancements to the Salary Increase module for providing a salary increase to Oracle Employees. This is a custom module that is part of the Oracle Self Service through which managers can provide increases in salary. Made changes to the process that populates the data in the module. Made modifications to the web pages in the module for business. Written the PL/SQL packages that fetches the data from the database and populates the salary module tables with eligibility information and rollup information. Also written packages that will allow the modification of the data and approval of the modifications by managers through the module screens.
Fine tuned the payroll process with development to make sure the payroll process that calculates the earnings, supplemental earnings, deductions and the taxes in less time. Worked with Oracle Development by providing tkprof and trace files to them on the process so that they can identify the queries that slowed the process. The fine tuned process now runs in 5 hours for all the employees in Oracle US. Fine tuned the costing also to make sure that all the costing performs in very less time by working with Oracle Development to fine tune the queries that delay the process thereby improving performance.
Aug 99 - Jan 01 Xoriant Corporation, Santa Clara, CA Consultant
Client PricingDynamics
Part of the team that developed the E-commerce site (www.dinnerbroker.com) for Pricing dynamics through which customers can book restaurant tables at a partner restaurant for a premium. Developed several screens for the site for day to day operation of the site using Perl CGI.
Client Beyond.com
Developed reports for E-Stores which sell software on the internet. E-Stores are electronic software stores started and maintained by Beyond.com software for different companies manufacturing software products. The project involved developing detailed web based reports and email reports about the performance of the E-Stores deployed on the intranet/extranet. Developed SQL scripts that will fetch the performance data from the database and provide it in the web reports.
Developed Symantec Reports for Beyond.com. Symantec Reports involved developing E-Mail reports on the performance of Symantec Stores. The reports were run by from a web based GUI. Typical reports included revenue reports, sales reports, customer service reports, summary reports etc. Developed SQL scripts that will fetch the performance of the Symantec stores from the database and display the data in the web pages.
Feb 98 - Jul 99 Emirates Airlines, Dubai, UAE Software Engineer
Performance of World-wide Emirates Routes (POWER) - Part of the team that developed POWER. POWER is a decision support tool, which will report Revenue earned and Costs accrued by Emirates Airlines on different routes and will report performance through standard airline performance indices. The application provides performance data by way of performance indicators at an individual route level and network level to the top management of Emirates Airlines. Designed the database tables from on which the application runs. Developed PL/SQL packages that will calculate the revenue earned and cost accrued on different routes. The packages then will gather statistics from the data and produce the performance indicators at an individual route level and network level. Developed forms that will run the processes that calculate the revenue and costs and the performance indices. Developed reports that will provide the performance information on the different routes and on different networks.
Transaction Reconciliation and Activity Control Kit (TRACK) - Part of the team that developed TRACK. TRACK is a tool for reconciliation of transactions. TRACK interfaces with different feeder systems, which feed transactions into the system. TRACK reconciles the transactions from one feeder on one hand with the transactions from another feeder. The transactions can be automatically reconciled or manually reconciled. TRACK provides for reversal of reconciliation, forced reconciliation and leaves an audit trail. Designed the database tables on which the application runs. Developed the packages that will do the reconciliation of transactions from different feeder systems. Developed the forms through which reconciliation can be done on the different feeder systems.
Bank Reconciliation Accounting System (BRASS) - Maintained BRASS application. BRASS is an accounting application for reconciliation of Bank Accounts. The Deposits, Credits and Inter-bank Transfers from the Banks and the transactions from Emirates Financial System (OLAS - General Ledger) are loaded at weekly intervals into BRASS. Auto reconciliation is performed initially and transactions from the banks are matched to the transactions from the General Ledger and reconciled. The transactions that are left can be manually reconciled.
May 96 - Apr 97 NYX Inc, Michigan, USA Quality Engineer
Created / Edited Manual, procedures, work instructions, Forms that satisfy ISO 9000 requirements. Assisted in complete documentation of Quality Manual, procedures. Addressed customer concerns, performed root cause analysis and communicated corrective actions to the customer/client. Tracked quality operating system measurables like Zero Defects, machine efficiency, deliveries. Conducted acceptance sampling for incoming materials and final inspection of the products.
Education MS - Chemical Engineering, University of Cincinnati (1994)
BS - Chemical Engineering , IIT Bombay (1993)
References Provided Upon Request
|
|
|
|
Goto Forum:
Current Time: Tue Nov 26 13:45:12 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
