Project Oracle

Rajith

Mobile: +919*********

E-mail:***********@*****.***,********.*@*****.***

Summary of skills and Experience :

* Possess thorough and in-depth knowledge of Finance back-office functions

especially Quoting & Contracts, Order Administration, Project Accounting,

Procure to Pay functions and Customer Data Management.

* Possess the ability to quickly understand an existing business flow and

suggest technically sound, efficient and cost-effective alternate

solutions.

* Have 7 years of experience in analysis, design, development,

implementation, testing, and maintenance of application systems on the

Internet, Client Server environments; with 4+ years of experience as an

Oracle Developer.

* Excellent and in-depth experience in Installation, Configuration and

Maintenance of Oracle DB and other components.

* Experience in Data Modeling (Logical and Physical Design of Databases),

Normalization and building Referential Integrity Constraints.

* Excellent skills in creating SQL objects like Tables, Stored Procedures,

Views, Indexes, Triggers, Rules, Defaults, User defined data types and

Functions.

* Have in-depth PL/SQL Programming skills. Experience in query

optimization & performance tuning. Have used SQL Profiler, Execution Plan,

Performance Monitor and DBCC Commands.

* Have very strong background in a disciplined software development life

cycle (SDLC) process and have excellent analytical, programming and problem

solving skills.

* Strong skills in troubleshooting of application and database issues

pertaining to the Finance domain.

* Possess the ability to work in a fast-paced environment.

* Good team player and can also work independently. Have assisted other

developers on technical issues.

Professional Work Experience :

Oracle India Private 01-Apr-2011 to Till the Lead Automation Analyst

Limited date

Oracle India Private 24-July-2008 to Senior Automation Analyst

Limited 31-Mar-2011

Imaginit Software 12-02-07 to 30-01-08 Principle Consultant

Services

Adventsoft, Cochin 06-12-04 to 31-05-07 Team Leader

Adventsoft, Cochin 15-06-03 to 06-12-04 Programmer

Achievements :

- Founding member of Automation team at Oracle Finance department.

- Built up a team of 6 from scratch

- Manage and lead the team

- Rewarded with Best Supporting Employee award from Oracle Finance

VP for the applications designed and developed for the entire

Finance team

- Received various other awards like quarterly and monthly best

employee awards and appreciations at Oracle

- Conceptualized and developed many products and applications

which can be reusable by various Finance teams

- Worked with global technical professionals & associates

- Gained end-to-end application development knowledge, including

analysis, design, development, testing, debug deployment,

documentation and maintenance. Interested in doing R&D and

developing new packages and components

- Established Imaginit Services, a software firm in Kerala,

developed and marketed various products and services

Technical Skills :

Languages : C, C++, VB, VBA, VB.Net, Java

Database : Oracle 11g/10g/9i, SQL Server 7.0/2000,

Ms Access

Database Technologies : Oracle Application Express (APEX), PL/SQL, SQL

Web Technologies : JSP, ASP

Scripting Languages : JavaScript, VBScript, AJAX, JSON

Javascript Libraries : jQuery, Mootool

Web/Application Servers : WebLogic, JBoss, Microsoft IIS

Operating System : Windows98/2000/2003, Windows XP

Reporting Tools : Oracle Discoverer, OBIEE, Crystal Report, Brio

Intelligence

Educational Qualifications :

MBA

Diploma in Information Technology

Pre-Degree from Kerala University

Project Details

Organization : Oracle India Private Limited

Role & Responsibility of Projects : Design & Development

Packages :

1. Interactive Excel Data Upload to the database

Technologies: Oracle 11g/10g, MS SQL Server, JavaScript, MS COM,

AJAX, JSON and PL/SQL

I have developed a package for interacting data communication between

database and Microsoft Excel. Using this package we can insert excel row

data's into to database tables and also it has the ability to format the

excel rows like coloring, font size, style, type etc in excel cells to

indicate duplicate data, incorrect values, incorrect formats, various

error states etc. some of the main features are:

. Avoids human errors.

. High level accuracy.

. Maximum flexibility to the end-users

. Utilize the benefits of Microsoft excel in web applications

. Compare the data base values with excel row values

. Ability to format excel through web applications

2. Report Scheduler

Technologies: PL/SQL, JavaScript, AJAX, jQuery

Using this package end-user can subscribe the basic SQL report; they

will get an option to select the time period of the report need to

generate. System will frequently generate and send the report through

mail in the scheduled interval.

3. Outlook Express Data Integration with the application

Technologies: Oracle 11g/10g, MS SQL Server, JavaScript, MS COM,

AJAX, JSON and PL/SQL

Developed a package for integrating and interacting between Microsoft

Outlook and web application. Using this package end users can import their

contact, calendar and task to their application account and can do various

automations. We are using this package for storing and monitoring generic

mail inbox and outbox and can find the aging and TAT for each mail request.

4. eZorder Upload format (Tag) generation DLL

Technologies: VB 6, VBA

I have created a DLL for convert bulk Order's getting in excel

template into eZorder application (E-Business Suite) unloadable format

(Database Tagging like XML). This package is widely using in Oracle Order

administration department for booking Bulk orders and also it is using to

covert sales credit information's also.

5. Online version control

Technologies: VB 6, IIS

As finance team requires lots of excel macros and excel sheets to

do their task; the file version controls become an issue. So I have

created a package to ensure the file version and automatic file upgrade.

This package is using in Partner teams order submit Template which

ensures all product list, price, exchange rate and file version up-to-

date and it is using in all macros.

6 Excel to XML Tag Generator

I have developed a product that can convert all kind of excel data

into XML format and vice versa. This have the option to select different

file formats like ANSI, Unicode, UTF-8 etc so the system will support all

kind of foreign languages and special characters. This product is widely

using in finance and customer management orgs to store, display and

transfer their data in a structured way. Also most of the application

supports XML upload and download so this product can be used to convert

that into excel format.

7. Text File Converter

Created a web based application to convert bulk number of text files into

Microsoft Word, CSV and Excel formats. User can decide the converted

files page setups, font style; zoom size etc. system will convert all the

files into the selected formats. Also user has the option to select the

lines to be deleted and special characters to replace etc. System will

convert hundreds of files within few minutes.

Applications :

1. OA Workflow, Quality and Productivity Management System (OAST)

Application Technologies: Oracle 11g, Oracle APEX, PL/SQL, JavaScript,

jQuery

Developed and implemented a complete workflow application for

Oracle order administration team (OA). Using this application partner

team can submit their order package, monitor and track the booking

status, handles all kind of communication between the submitter and OA.

Also the applications have the capability to upload data sources from

various applications like Oracle Order management application (OM),

Siebel, Tele-service, POP Store etc. System will automatically categorize

the orders and redirect to the respective verticals and teams based on

the order type, country and other details.

Highlights:

1. A transparent mechanism between the order submitter and OA

2. Automated Queue managing system.

3. Effective workload management system.

4. Advanced query communication system.

5. Automated email alerts.

6. Automated work assigning.

7. Priority management system.

8. Built-in request managing and tracking system between different

departments.

9. Reduces the data entry time using data interface mechanism

10. Notifications and Announcement System.

11. Automatic guide lines from previous history.

12. Identify the standard time for various order types using time

and motion study mechanism

13. Turn around (TAT) reports

14. Aging reports

15. Advanced quality control system.

16. Analyze the Quality/accuracy of the employees.

17. Option for root cause analysis and preventive actions for

errors.

18. Productivity and Capacity reports.

19. Self management and goals settings option.

20. Advanced dashboard.

2. Fixed Prize Project Loss Accrual (PA-EFPLA)

Technologies: Oracle APEX, PL/SQL, JavaScript, Ajax, jQuery

This application is using to track, analyze and forecast the fixed prize

project and its revenue. The application will calculate the project expense

and remaining time to complete the project etc based on the different

parameter like project fund, total labor fund and remaining cost to

complete etc. Based on the project input system will calculate the

remaining fund to complete the project and highlights the loss projects.

Based on that project managers can take appropriate decision about the

projects. The system is having in built email system for communication

between the respective project managers and project accounting team so this

provides an end to end mechanism for tracking all transactions related to

the project. The system have the ability to identify the projects are

inactive from last couple of months and notifies the regional project

managers and they can update the project status with their comments so the

project accounting team can easily manage all the projects very

effectively.

3. GRAPO(Global Revenue and Procurement Operations) Project

tracking portal

Technologies: Oracle APEX, PL/SQL, JavaScript

Developed and implemented an application to track and monitor projects and

tasks in various Lob's and teams under Global Revenue and Procurement

Operation (GRAPO). Using this application they can create and assign

projects and each projects they can create task's and subtasks and each

task can have task owners and time frame. And also we can update the

progress and status of task so that they can have live project and task

status reports with various access levels.

4. SCA Report automation

Technologies: Oracle APEX, PL/SQL, JavaScript, Ajax

Automated the manual report creation and distribution process in excel

into web application. Using this application end-user can upload

application report and other supporting data into the application and can

generate the report. All the excel formulas, manual calculations and Pivot

tables in excel reports have automated using PL/SQL functions. System will

automatically generate more than 35 different reports from the main data

source using various calculations.

5. E-Metrics (Employee appraisal and productivity tool for S2S,PA,OA

and CDM)

Technologies: Oracle APEX, PL/SQL, JavaScript

Developed an application which helps to do appraisal in an effective

way. This is a combination of many applications into one like productivity,

audit, assessment, feedback, initiatives etc. The system will capture

employee productivity, capacity and efficiency of each employee based on

the task settings and task volume and time. The system will work based on

employee entry as well as automated reports wich gives the task and volume

details for different applications. Using this tool team leaders and

managers can analyze their employee's productivity and their team's

capacity utilization.

5. Online Assessment & Survey Tool

Technologies: Oracle APEX, PL/SQL, JavaScript

Developed an application to conduct online exam, training, survey and

feedback. Using this product we can analyze employee's process and

functional knowledge. Based on the reports they can decide extended

training and appraisal etc. We have the option to combine various

assessment results and can analyze the progress of employees and their

functional area knowledge.

Highlights:

a) Global database that stores all the assessment results to a single

space which allows to do an effective comparative study using the

previous results

b) Subject functional area wise report which tells the employees

strong and weak areas

c) Employee, Team wise result comparison

d) Option of having question bank that can be reused in many

assessments

e) Questions and options to display randomly which ensures

reliability

f) Advanced reports like tenure wise report, most answered, most

wrongly answered and most displayed reports etc.

g) Options of having automatic result publishing, automatic result

sending through email to employees and respective managers

h) Very advanced user interface which helps to create customized

welcome screen, summary screen etc.

i) Advanced option to analyze various survey and feedback details.

7. Employee and Process Portal

Technologies: Oracle APEX, PL/SQL, JavaScript, Ajax, jQuery

Developing a common web portal is useful for whole employees in the

organization. The aim of this application is to have an all in on solution

for storing and managing personal and organization related data and reduce

the time and efficiency in every aspect. The facilities in this portal are

listed below.

1. Customizable home page for every employee

2. Notifications

3. Announcements

4. Instance messaging option

5. Options to set reminders and alerts

6. Link library

7. Document Library

8. Discussion forum

9. Asks to the expert

10. Advanced Checklists

11. Task/work planner and scheduler

12. Options to create survey and publish

13. Polling/Voting facility for new initiatives

14. Events organizer

15. Personal budget planner

16. Options to create different communities and forums

17. Employee search

18. Knowledge portal/ process Wikipedia

19. Option to share pictures and photos

20. Option to interact with other social networking sites like facebook

and twitter

Web Templates :

Technologies: JSP, Oracle APEX, PL/SQL, JavaScript, Ajax, jQuery

I have developed a platform for web templates using Ajax and jQuery. I

have replaced around 500+ different templates with 10 templates using our

dynamic loading and validation mechanism. Below mentioned is one among

from the group.

Customer Data Desk - Global Web Template

Created a global web template that replaces more than 150 templates

for various countries. Using the latest template customer creation,

address changes and relationship change request become very easy for the

end-user because they need to refer only one link and all the address

styles, Tax information's and list of values and validation will load

dynamically based on the country selection. The data quality also improved

because of country and business line wise validation for the key field like

Tax registration no, Address, postal code and profile class etc.

Excel Macros :

Technologies: VBA and VB 6

I have created lot of macros for Oracle finance organization to minimize

their task. One of the main macros which I created is POP Template. This

excel based template is used by all oracle partners to submit their bulk

order details. This has all product, pricing, discount and exchange rate

details with automatic update option with the main system all the

calculations will happen based on the entry and finally they can generate

an unloadable format and can upload to the application.

Organization: iMaginit Services

An IT company, mainly concentrated in software development and IT

enabled services, promoted by a three young professionals who had proved

their worth in their respective areas. Besides from software consulting and

developing company were involved in BPO Services, logo designing and

captioning etc. Fortunately I was one of the partner and chief of IT

Department.

Title: Dacon

Front End: Visual Basic 6.0, VBA

Backend: MS Access

Description: This is a package of software's mainly for data editing

and data conversion workers. This package contains six main applications

(exe) and other accessories and main exe is called "Dacon". This software

can help as a text editing tool and can covert scanned image formats like

Gif, Jpg and Bmp to various formats like Word, Html and Xml. This also

provides a scanner facility to acquire the image from scanner. This can

also provides the facility to word by word comparison of image and text

with proper character indication marks both in image and word with the

calculation of accuracy of comparison and spelling. It is developed using

VB, VBA, OCR Technology and Artificial intelligence Methodologies and MS

Access.

This software can use as a text editing software like MS Word. This

software has a very good GUI. It has many controls such as:

. Image to Text Converter (OCR)

. Formatting and QC Software

. Text Converter

. Dock Combiner

. DigNotpad

. Accessories

Title: Voice Based Sales and Inventory Control

Front End: Visual Basic 6.0

Backend: MS Access

Report: Crystal Report

Description: This application is developed using MS TAPI, SAPI and VB

Technology. This software provides an advanced facility to place the order

using voice recognizing system, using this facility an authorized user

login to the system from remote location using their communication device

and record the instructions in the system. The main objectives of the

project is to maintain the stock details of the goods, daily and

periodically both product wise and general sales report. It is also keep

the Supplier details and their products and their last time purchased or

offering prize also so at the time of order generation they can select view

and select appropriate supplier.

Title: Imaginit PcExpert

Front End: Visual Basic 6.0

Description: This is a very good tool for administrating various system

facilities that are not providing the Windows OS GUI's. This tool is very

help full for repairing virus affected registry

Such as disabled task manager, fodder options etc. This software is mainly

developed by editing Windows Registry values. It have three parts first

part facilitates good UI for the user to enable, disable and add new

features to Drivers, Internet Explorer, control panel, start menu, media

player and login window. It will also provide computer information's,

Program Restriction options, battery level indicator, CPU and Network usage

and Various parts models and serial no of computer hardware pieces like

hard disk, motherboard etc. The second part is a folder or file protection

software. It provides the facility to protect various files and folders

from unauthorized access. The third part is a File splitting and encrypting

software for giving high security for the files. This software encrypts the

file and splits single files into small pieces and saves.

Title: Burglar

Front End: Visual Basic 6.0, VBA

Backend: MS Access

Description: This application is developed for Excel data entry work.

This software will speed up the data entry works by avoiding the

difficulties of accessing Excel spread sheet cells. It will act as an

interface between Excel and Internet Explorer by accessing excels cells

values and search and find the corresponding data with Google search

engine. It allows reading and entering excel cell values through a

graphical user interface. In this system user don't have direct interaction

with excel and internet explorer.

Organization: Adventsoft Info Technologies, Cochin

Title: Production and Maintenance

Front End: Visual Basic 6.0

Backend: SQL Server 2000

Report: Crystal Report

Role & Responsibility: Programmer

Description: This application is developed for boosting, cost

effective, waist less and time based product manufacturing. Using this

system the production team can check the order delivery possibilities and

raw material availability; according to that they can plan and schedule the

machine, employees shift and raw material purchase order etc. It also has a

maintenance module helps to keep the maintenance details of various

categories of machines.

Title: HR and Payroll System

Front End: Visual Basic 6.0

Backend: SQL Server 2000

Report: Crystal Report

Role & Responsibility: Programmer

Description: We developed a fully automated package for payroll and HR

solution it can be used in any organization with the flexibility to have

their own settings like number of branches, Designations, Tax

information's, OT etc. It gives automated attendance systems like Biometric

and access card and Manual systems like system login and Excel template

upload. This will automatically send the pay slip to the corresponding

employee's Email Id's. And also we have an option to include remote camera

viewing facility (Can see different office locations and its live

movements).

Title: Stores and Purchase (Inventory)

Front End: Visual Basic 6.0

Backend: SQL Server 2000

Report: Crystal Report

Role & Responsibility: Senior Programmer

Description: This application keeps whole materials and its allocation

in the company. It is also keeping the store wise raw materials stock and

their supplier details. The main process of this software is to receive the

material requisition from the production department and according to that

check the availability of the material and generate purchase order with the

approval of the finance department and finally makes the material issue.

And also helping to keep the out Pass and in Pass details of materials.

Personal Details:

Father's Name : Rajendra Prasad

Date of Birth : 31.05.1982

Marital Status : Single

Sex : Male

Hobbies : Cricket, reading books, music and

browsing

Languages Known : English, Hindi, Kannada, Tamil,

Malayalam

Declaration: I consider myself familiar with System Application Aspects. I

am also confident of my ability to take any responsibility. I hereby

declare that the information furnished above is true to the best of my

knowledge and belief.

Contact this candidate