Objectives:

To work with a competitive enterprise which provides challenge, growth and opportunity to explore and take business to next level.

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

Experience:

Confidential

01-Apr-2011 to Till the date

Senior Automation Specialist - 2

Confidential

24-July-2008 to 31-Mar-2011

Senior Automation Specialist

Confidential

12-02-07 to 30-01-08

Principle Consultant

Confidential

06-12-04 to 31-05-07

Team Leader

Confidential

15-06-03 to 06-12-04

Programmer

Educational Qualification:
Diploma in Information Technology 
Pre-Degree 
Achievements:

• I was founding member of the automation team at Oracle Finance department.
• Built a team from scratch
• Ability to lead and manage a technical team
• I got the best supporting employee award from Oracle Finance VP by considering the applications which I 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 to various finance teams
• Worked with professionals & associates from all around the world
• End-to-end application development knowledge, including analysis, design, development, testing, debugs deployment, documentation and maintenance.
• Interested in doing R&D and developing new packages and components.
• Started a software company in Kerala called Imaginit Services and developed and marketed various products and services.

Curriculum Projects
Organization : Confidential
Role & Responsibility of Projects : Design & Development

Packages

• Interactive Excel Data Upload to the database

Technologies: Oracle 11g/10g/9i, MS SQL Server,JavaScript, MS COM, AJAX, JSON and PL/SQL
I have developed a package for interacting 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
• Report Scheduler

Technologies: PL/SQL,JavaScript, AJAX, jQuery 
Using this package end-user can subscribe the report which they are viewing; they will get an option to select the time period of the report need to send through mail. System will frequently generate and send the report through mail in the scheduled interval.

• Outlook Express Data Integration with the application

Technologies: Oracle 11g/10g/9i, 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.

• 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. 

• 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.

• 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.

• 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

• 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 partner team and OA. Also the application have the capability to upload data sources from various Order management applications like Oracle Order management application (E-Business Suite), Siebel, Tele-service, POP Store etc. System will automatically categorize the orders and redirect to the respective verticals and teams like EMEA Direct Team, AMER Partner Team etc based on the order type, country and other details. System will automatically interface the required data from the order package based on the request and send a notification to the respective team so they can also access the same application and can update the status so we can effectively and accurately manage and track the details and can improve the turnaround time (TAT). 
Based on the number of request processed, other tasks, time taken for each task and work hour’s system will show the productivity and capacity of each employee. We have the option to compare the individual wise, team wise and management wise productivity.
Highlights:

• A transparent mechanism between the order submitter and OA
• Automated Queue managing system.
• Effective workload management system.

• Advanced query communication system.
• Automated email alerts.
• Automated work assigning.
• Priority management system.
• Built-in request managing and tracking system between different departments.
• Reduces the data entry time using data interface mechanism
• Notifications and Announcement System.
• Automatic guide lines from previous history.
• Identify the standard time for various order types using time and motion study mechanism
  

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.

• 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. We have hosted this application in Oracle GIT server with all GIT security policies and Oracle secure coding guide lines.

• 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. 

• 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.

• Online Assessment Tool

Technologies: Oracle APEX, PL/SQL, JavaScript
This product can be used for online exams, certifications and trainings. Using this product we can analyze employee’s process knowledge and their functional area knowledge. Based on the reports they can decide extended training and appraisal etc. We can combine various assessment results and can analyze the progress of employees and their functional area knowledge. 
Highlights:

• Global database that stores all the assessment results to a single space which allows to do an effective comparative study using the previous results
• Subject functional area wise report which tells the employees strong and weak areas
• Employee, Team wise result comparison
• Option of having question bank that can be reused in many assessments
• Questions and options to display randomly which ensures reliability
• Advanced reports like tenure wise report, most answered, most wrongly answered and most displayed reports etc.
• Options of having automatic result publishing, automatic result sending through email to employees and respective managers
• Very advanced user interface which helps to create customized welcome screen, summary screen etc.
• Online Survey Tool

Technologies: Oracle APEX, PL/SQL, JavaScript
Developed a web application for conducting online surveys using this tools we can do various employee surveys, feedbacks, requests and registrations. The main advantage’s of this application is correct submitter information’s due to SSO integration and powerful reports.

• Employee and Process Portal

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

Developing a web portal for personal, team and department management. 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 of each and every aspect. Every employee is having access to this application and everyone is having option to design their own home page. The facilities in this portal are listed below.

• Customizable home page for every employee
• Notifications
• Announcements
• Instance messaging option
• Options to set reminders and alerts
• Link library
• Document Library
• Discussion forum
• Asks to the expert
• Advanced Checklists
• Task/work planner and scheduler
• Options to create survey and publish
• Polling/Voting facility for new initiatives
• Events organizer
• Personal budget planner
• Options to create different communities and forums
• Employee search
• Knowledge portal/ process Wikipedia
• Option to share pictures and photos
• 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 various dynamic user-friendly web templates using latest technologies like Ajax and jQuery . I have replaced around 300 different web templates with 3 templates using our dynamic loading and validation mechanism.

• 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.

• RMAM Template
• Account Receivable – Global Credit MEMO Template
• Escalation Template Etc..

Excel Macros

Technologies: VBA and VB 6
I have created lots 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.

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: Remote Sound based Order Placing System 
Front End: Visual Basic 6.0
Backend: MS Access
Description: This software provides the facility of saving various speech or conversation happening in various geographical locations or in the same location for keeping record. This is mainly developed using MS TAPI Technology. Using this facility an authorized user can remote login to this system using their communication device and record the instructions in the system. In advance it also provides the facility to place their order using this system. This system is still under revolutionary changing at can provide lots of facilities in feature. 

Title: Sales and Inventory Control
Front End: Visual Basic 6.0
Backend: MS Access
Report: Crystal Report
Description: It is developed for maintaining the sales and inventory control of a private shop. The shop mainly deals with electrical and electronics components. All the details of goods can be maintained correctly and the stock details also can be maintained. 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: Network Management System
Front End: Visual Basic 6.0
Backend: MS Access
Report: Crystal Report
Description: This software is developed for small and large scale cable TV Network operators. Using this system they can keep their location wise customer details and their payment scheme’s and payment details. So they can easily find out the paid, non paid and special scheme ended customer details with their location in monthly and periodically wise.

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: Confidential

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.

Title: Marketing 
Front End: Visual Basic 6.0 
Backend: SQL Server 2000
Report: Crystal Report
Role & Responsibility: Module Leader
Description: This system is developed for the marketing department of an exporting company. Using this software the marketing departments can keeps their clients details, place their order, produces the pre shipment and shipment invoice with the consent of their production department.

Title: Online Registration 
Front End: ASP, VB Script
Backend: MS Access
Role & Responsibility: Project Lead
Description: This is a web based application that gives the guidelines and instructions for various registration processes for their clients and provides online registration and application status details.