AJITH VIJAYAN

703-***-****

Professional Summary

Plus 12 years of experience in the field of Information Technology with a Masters Degree in Electronics.

Eight years of progressively responsible experience in Oracle Applications consulting with involvement on both functional and technical aspects of the product. Possess extensive experience in the following modules:

* Knowldge of R12 HRMS

* Oracle HRMS Applications (11i/11/03/10.7(SC)

* Oracle i-Recruitment

* Oracle Time and Labour (OTL)

* Oracle Alerts

* Oracle Self Service using Application Object Library (AOL)

* Oracle Projects, Grants, Fixed Assets

Extremely adept at designing simple solutions to complex problems and technically proficient in the following:

* Oracle PL-SQL,Shell Scripting,XML Publisher,WEB ADI

* Forms 9i/6i/5.0, Reports 9i/6i/3.0, Discoverer

* Fast Formulas, Custom Libraries and Workflow

* Noetix Administrator

Highlights of Professional Experience

CANTOR FITZGERALD Application Techno - Functional Consultant NY Nov 09-Present

Environment

Oracle HRMS Applications11i (11.5.10), Oracle 10.2.0.4 RDBMS HR, Reports6i, Forms6i, Discoverer 4.5

ADP Payforce payroll,XML Publisher,WEB ADI,Shell Scripting,OAB,Oracle Alerts,OTL

§ Modified the ADP payroll address view to pull the employees if they have any tax address other than there primary address, if no tax address then pull there primary address

§ Modified the ADP payroll Employee ref view, so that the user can run the connection of few set of employees

§ Create a Computer Share report using report 6i and XML Publisher as per the client requirement.

§ Troubleshooting end user problems, management of a comprehensive repository with CWB's problems and solutions, development and delivery of training for key users and the creation of policies for maintenance on all environments.

§ Create a Retro pay Report using XML Publisher.

§ Designed and Supported OTL.

§ Developed a Custom Desktop Interface to Load the Person EIT using WEB ADI

§ Created a Shell Scripts to send the reports via email to the users.

§ Create an oracle alert which will send the email to the user there is a new department or location added in the oracle.

§ used shell scripting to run the concurrent programs.

E*TRADE FINANCIAL Application Techno - Functional Consultant Nov-05 - Nov-09

Environment

Oracle HRMS Applications11i (11.5.10), Oracle 10.2.0.4 RDBMS HR, Reports6i, Forms6i, Discoverer 4.5, Business Intelligence Discoverer, NOETIX, AOL, Work Flow Builder,Self Service

§ Involved in the full life cycle implementation of ADP Payforce; Responsibilities included product review, member of a 5 person team involved in performing fit-gap analysis; Responsible for creating High Level Design (MD-70) and Low Level Design(MD-50) documents for Customizations. Extensive interaction with the end users to ensure that customizations fit the needs of the Business User. Created multiple prototypes and chaired Joint Application Development (JAD) sessions.

§ Involved in the full life cycle implementation of i-Recruitment; Responsibilities included configuring the required profile options, setting up additional DFF’s, Lookups; Also was involved in setting up Qualification Types, Competencies, Compensation Plan, Security Setup and testing since the module to the company’s extranet. Worked closely with the Business to define the Approval Hierarchy for both Vacancy creation and Candidate Approvals. The Approval process was setup using Oracle Approvals Management Engine (AME). Solely responsible for setting the EAM plug-in for the Resume mirror concept in iRec. Setting up of offers and creating multiple custom offer letter templates using XML Publisher, Integration of the job with the Job Vendors like (Monster, Career Builder and Hot jobs).

§ Wrote one-time PL-SQL programs to convert Recruitment data from various Legacy systems, which in some cases included spreadsheets. Also created audit scripts to assist with data reconciliation.

§ Performed Production support on an as needed basis; was responsible for maintaining various Benefits outbound feeds to Third Party administrators.

§ Wrote outbound interfaces for Equity Edge, Celergo (payroll interface for Philippines employees), Reged(FINRA Account details for registered employees).

§ Extensively worked with offshore teams comprising of a mix of Full Time and contracting professionals. Assigned chunks of work to offshore personnel and was responsible for weekly updates to the Project Management Office (PMO) in the U.S.

§ Full Cycle implementation of Noetix Reporting tool and Supporting as Noetix Administrator, Noetix Database administrator.

§ For a period of time was responsible for creating the Discoverer Reports as per the Client requirement using the WEB Version and sharing the reports with the user. Also responsible for supporting the day-to-day issues.

§ Used Shell –Scripting for FTP process to send the file to vendors.

§ Used Shell –Scripting for PGP encryption.

§ Making the Documents as per SOX

§ Was responsible for resolving issues with Discoverer reporting tool and served as the Administrator.

Rockefeller University Application Techno-functional Consultant May–05 to Oct-05

Environment

Oracle HRMS Applications11i (11.5.9), Oracle 8i RDBMS, ADP, Grants Accounting, Fixed Assets, Reports6i, Forms6i, Discoverer 4.5

§ Worked extensively on Oracle Payroll with specific focus on configuration. Worked closely with the functional lead to assist in the setup of Payroll Elements, Taxation rules, GREs and Tax Balances. Also worked on Paid Time Off (PTO) setup for Vacation, Sick and PTO plans.

§ Create a Benefits Report using Reports 6i by aggregating data from various Oracle Advanced Benefits (OAB) Tables.

§ Created an interface for hospital System call as STIX, where you pull all the current as well as Ex-employees information and put into a file which in turn is passed into the Hospital system called STIX.

§ Create a View only Custom Form using Forms Configurator. Created SQL*Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables

§ Prepared functional document to Create Assignment Set programmatically to include all the employees both existing, rehire as well as terminated employees eligible for special pay so that the payroll processes only employees with pay.

§ Prepare specification to process the payment of long due special bonus to the eligible employees. Coordinate with the users, identify the employees based on the various criteria, and include programmatically the eligible employees into various Assignment sets, to be processed by various payrolls.

§ Defined and designed various KFFs, DFFs, value sets, and carried out validations. Created missing information Report of Phone, email, location comparing with the Directory system and Hr system that list using Reports 6i.

Merrill Lynch Application Technical Consultant Dec –04 to May-05

Environment

Oracle HRMS Applications11i (11.5.9), Unix, Oracle 8i RDBMS, HR, BENEFITS, Reports6i, Forms6i, PVCS, Test Director, AUTOSYS

§ Worked on the Organization and Hierarchy interface. Updating the Organization and Hierarchy tables taking the data from the temporary table using the Organization and Hierarchy API’s.

§ Worked on the Inbound Interface, which updates the email address of the employees using the HR_PERSON_API.Update_person.

§ Worked on the inbound Interface for currency feed into Oracle GL_DAILY_RATE_INTERFACE table.

§ Used Custom.PLL for modifying the existing Forms. Also, worked on the Autosys, which is a third party tool through which we submit the Jobs to the request Queue, which are then run by the OFSA server Engine.

TROON Golf Application Technical Consultant Oct –03 to Dec - 04

Environment

OracleApplications11i (11.5.7), Windows2000, Oracle 8i RDBMS, Payroll, OAB, HR, SELF SERVICE, Open Enrollment, Reports6i, Forms6i, Discoverer 4i, Work Flow

§ Developed 401K Report using Reports6i.

§ Involved in finalizing the Target Flow Process, extensively worked on Employee Self Service(Personal Information, Online Pay Slips, Tax Forms, Pay Methods, Leave of Absence) and Manager self service(Hire, Assignment Change, Pay Change, Manager Change, Terminations) using Oracle Approval management.

§ Use of Workflow builder for Employee Self Service; Involved in day to day production support.

§ Customized the Seeded Check Writer and Deposit Advice Report as per Client’s Requirement.

§ Developed an outbound Interface for Ceridian on Cobra file. Developed an outbound interface for Eyemed on Employee’s Vision Plan.

§ Used API’s for mass Salary Upload of Employees, Termination and NEW-Hire. Developed custom Time sheet Program.

§ Used the BEE API for dumping the payroll data into Element entry tables. Solved lot of setup issue with Elements in payroll process.

§ Added couple of interface to different Responsibilities. Created SQL*Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables.

§ Opening of TAR’s for different issues.

§ Extracted the Balances using pay_balance_pkg.get_value.

§ Helped in setting up of EIT's ans SIT's of People and Assignment. Defined and designed various KFFs, DFFs, value sets, and carried out validations.

§ Involved in creation of TAR(Technical Assistance Request) Report in Metalink. Added Third Party sick pay Element for calculating STD Leave.

§ Created EULs according to user requirements using Discoverer Administration and was involved in giving privileges and security roles as Discoverer Administrator.

§ Created Custom Folders built on SQL, PL/SQL Functions. Created Functions, Calculations, and Item classes, Summaries, Hierarchies and Joins. Worked in SQL Importing and Exporting. Converted standard application reports to Discoverer reports as per user requirements.

7-ELEVEN Application Technical Consultant Jun 03- Oct -03

Environment

Oracle Applications11i (11.5.8), Solaris5.8, Windows NT, SQL8i, PL/SQL, TOAD, Payroll, OAB, HR

§ Involved in creating MD 70’s

§ Designing the interfaces for the offshore development teams.

§ Acting as the main communicator between the user and the offshore teams.

§ Interacting with the User and Helping the Development Team with Offshore.

§ Mapping the columns to oracle hrms from mainframes legacy data.

§ Identifying the API’s used for different Inbound interfaces.

Dallas Independent District School Applications Technical Consultant Mar 03 –Jun -03

Environment

Oracle Applications11i (11.5.8), Solaris5.8, WindowsNT, SQL8i, PL/SQL, Forms 6.i, Reports6i, Payroll, OAB

§ Involved in writing INBOUND and OUTBOUND Interface in OAB and Payroll using Oracle 8i

§ Developed Inbound interface for Baylor file, LITW file, IACM file and created and reports using Reports 6i

§ Developed outbound Interface for 401a deduction plan.

§ Used several API for the inbound interfaces.

§ Created SQL*Loader script to populate the staging tables from the feed data, created PL/SQL packages to validate the feed data against the primary tables.

§ Defined and designed various KFFs, DFFs, value sets, and carried out validations.

§ Involved in developing Reports in Payroll and OAB using Reports 6i.

§ Created a report of 403B and 457 plan using Reports 6i

§ Created an arrears and earnings reports using Reports 6i

§ Customized payroll forms using Form 6i.

University Of Alabama Applications Technical Consultant Sep –02- Mar-03

Environment

Oracle Applications11i (11.5.7), Solaris5.8, PL/SQL, Forms 6.i, Reports6i, Payroll, OAB, HR

§ Customized Oracle Application Forms Element Entry System, Address and Phones, School and Colleges and Person as per the Client Needs using Forms 6i

§ Developed several Payroll, HR Interfaces.

§ Converted the Labor Schedule’s for the UAB Employees.

§ Customized effort report form of the Oracle Application as per the Client Requirement using Reports 6i

§ Developed inbound interface For Mass Upload of Salaries from legacy system to Oracle HRMS Base Tables.

§ Developed a HIMS (Inventory Management System) file for the Hospital. This process creates a file of all active hospital employees

§ Developed outbound interface to builds a file of employee data for Hospital Employee Health and developed the report for the same.

§ Developed outbound interface for all the employees for stern Library. This file is created monthly of all employees for Sterne Library and developed the report for the same.

§ Developed outbound interface that looks for changes in certain data elements to create a file to feed the TAMS system for the hospital.

§ Developed outbound interface that will take a file of employee hours from design build and create T2 File Maintenance Transactions.

§ Developed outbound interface that produces a file of persons with NRA Earnings and puts them in a file for pick up by stars.

§ Developed Arrearage summary report for the Employees.

§ Developed the script to load the data into the temporary tables using SQL*LOADER.

§ Created concurrent programs to integrate them with Oracle Application instance.

Bahwan Engineer Company LLC-Muscat Applications Technical Consultant Apr -02 - Sep-02

Environment

Oracle Applications 10.7 Financials, SQL, PL/SQL, Forms4.5 Reports3.5. Financial Accounting System (FAS)

§ Customized Five Reports Aging 4-Bucket Report Disabled the parameter ‘Show On Account’ and Changed Default value to ‘Summarize’ by changing the where clause condition in the query.

§ Rearranged Report Header, Defined the Concurrent program in Production under Leapfrog Custom Application with the name Leapfrog Aging – 4 Bucket Report, Attached to Collection Group under Oracle Receivables.

GL Account Analysis Report

§ Modified the Report to generate based on Five Accounts. First Account is Mandatory others are optional. Added eight new parameters for another four accounts.

§ Created a New Group for Account Flex field. Added New Frames and New repeating Frame, Added Two Summary Columns for Debits and Credits, Rearranged the report layout.

§ Define the Concurrent Program as Leapfrog – Account Analysis Report. Production under General Ledger Module

Accounts Payable (AP)

§ Involved in vendor import from legacy system. The data was loaded into temporary tables from datafile and then loaded into Oracle tables along with some default values and with other values as per the Oracle setup.

§ The process involved many SQL*Loader scripts, stored procedures and packages. AP Check Format, AP Expense Distribution Detail Report, AP Payment Register. AP Receiving Hold Requestor Notice.

Canbank Computer Services Ltd. Jul-97 To April-02

This Application Software computerizes the activities of R&F sections at Regional Offices, Circle Offices and Head Offices. Recovery of advances is an integral aspect of Banks functioning .Any slackening on this front would seriously jeopardize the health, soundness and long term viability of the Bank . Waiting for the borrower to call on the bank and repay the sums borrowed, as per schedule longer constitutes banking wisdom. Contacting, reminding, exhorting and perseverance with the borrower till the money is recovered in full is the need of the day. Over dues /NPAs are a drain on our profits. Hence there is an important role to be played by R&F Section/Recovery Section t RO/CO/HO to eliminate these non-performing assets and finally close them.

The various methods are: -

Calling the parties by Branch manager for a compromise.

Transferring the a/c's to LPD.

Filing a suit against the borrower, either in civil court or in DRT.

Without filing the suit also Bank can go and seize the security.

The securities, which are movable, can be seized without the intervention of court. The securities, which are immovable property under, mortgaged and of huge security should be seized with intervention of court. Bank can seize the security with the help of clearing agents, which are of the Bank's panel.

Contact this candidate