Oracle Software Engineer
Resume:
Balachandran Venkatasubramanian (Bala)
Phone : 201-***-****; E-mail: *****.*@*****.***
Oracle Apps Techno-functional Consultant with 11+ years extensive experience in design,
analysis, user requirement study. Development of Reports and Interfaces, implementation,
setup, testing, customization, support and migration in Oracle Apps Financials, Distribution
and Application Object Library modules (11i, 11.0.x). Expert in technologies like SQL,
PL/SQL, SQL Loader, Forms 6i, Reports 6i, Oracle Discoverer, BI Publisher, packages,
triggers, Oracle 8i/9i/10g. Good Functional knowledge of setting, configuring and use of Oracle
Financials, Distribution with Apps System Administration skills.
ERP Expertise:
Implementation and technical expertise in AR, FA, GL, AP, Inventory, Purchasing, Order
Management, Enterprise Asset Management, HRMS, Oracle Projects, BOM, Installed
Base, Service Contracts and Oracle Time & Labor modules.
Specialized in Oracle Applications (Financials/Distribution/Manufacturing) skills with sound
knowledge of their integration.
Expertise in Customization and Conversion of various modules (RICE components).
Well conversant with aspects of Application Object Library (AOL) of Oracle Applications.
Good knowledge of Order to Cash and Procure to Pay cycles.
Strong with reporting tools like Oracle Discoverer, Reports 6i/10g, XML Publisher.
Designed, Developed and Customized Open Interfaces, Forms and Reports in Oracle Apps
Strong technical skills with good programming experience in SQL, PL/SQL, Developer
6i/2000 (Forms 6i, Reports 6i), SQL*Loader, UNIX Shell Scripting.
Post production support, Bug fixing and Enhancements.
Good experience in Unit Testing and System Integration Testing.
Performance Tuning and Optimization of SQL Queries.
Have Strong Conceptual, Business, Analytical skills & highly motivated team player.
Proficient in Gathering Specs, Application design, development, and customizations, coding
Excellent verbal, written, communication and presentation skills.
Oracle Applications: Oracle Applications R12/11i/11.0.x, General Ledger, Accounts
Receivables, Account Payables, Fixed Assets, Inventory, Purchasing, Human Resources, Order
Management, Project Accounting, Time & Labor, Bill of Materials, Installed Base, Service
Contracts and System Administration.
Programming Languages: PL/SQL, SQL Plus, C, Java and Unix Shell scripting
Software Used: Oracle 11g/10g/9i/8i/8.x, Oracle Forms 10g/6i/Reports 10g/6i, Oracle BI,
Discoverer, SQL *Plus, TOAD, SQL Developer, XML Publisher, SSRS, JDeveloper, VSS.
System Development: Business Process Analysis, Testing, Documentation and Implementation.
Operating Systems: Windows 95/98/NT/2000, Sun Solaris, MS-DOS and UNIX
Education : Bachelor Degree in Engineering (Computer Science)
Professional Experience:
Client Project Role / Duration
HealthMarkets, Inc. Oracle EBS R12: Enhancements / Senior Oracle Apps
Dallas TX Customization and Support Consultant
Sep 2012 till date
Page 1 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Client Project Role / Duration
F. Gavina & Sons Gavina Coffee: Oracle EBSR12 Senior Oracle Apps
Vernon CA Implementation, integration between EBS Consultant
and AR7, and Maintenance Support Dec 2010 – Oct 2012
Optinuity Alliance Oracle EBS 11.5.10.2: Enhancements, Senior Oracle ERP
Resources Corporation Customization and Support Consultant
Apr 2008 – Nov 2010
Ulticom, NJ Oracle Apps: AR Invoice Interfaces, Senior ERP Developer
Enhancements (GL, AR, AP), Prod Support Oct 2007 – Mar 2008
MARTA, Atlanta GA Oracle Apps Implementation – RICE Oracle Apps Technical
Development (Report, Interface, Conv. and Consultant
Enhancements) and Production Support Apr 2006 – Sep 2007
Singapore Police Oracle Apps: Implement Asset and Oracle Apps Technical
Force, Singapore Inventory System using Inventory, EAM, Consultant
GL, BOM and Financials modules Sep 2005 – Mar 2006
Hutchinson, Singapore Oracle Apps Implementation: Customize AP, Oracle Apps Technical
PO, FA and GL, data migration Consultant
May – Aug 2005
Gulf Extrusions- Oracle Apps 11i Customization of AP, GL, Software Engineer
Dubai, India Invoice import for AP, Report Development Mar 2004 – 2005
Citadel / Visaka / Oracle Applications: Customization, Software Engineer
Aarohi / Unisoft, India Enhancement Development and Support Mar 2002 – Feb 2004
Work Experience:
Sep 2012 – Till Date HealthMarkets Inc. Senior Oracle Apps
Dallax, TX Consultant
HealthMarkets® is the brand name for products underwritten and issued by the subsidiaries of
HealthMarkets, Inc. – The Chesapeake Life Insurance Company ®, Mid-West National Life
Insurance Company of Tennesseesm and The MEGA Life and Health Insurance Companysm.
Products under the HealthMarkets brand are designed to provide personalized protection to
individuals, families, the self-employed and small businesses.
Responsibilities:
Gathered requirements and designed the functional specification documents for the
implementation of interface between ADP and Oracle HRMS
Created mapping table for job-position relationship between ADP and Oracle HRMS
Implemented position hierarchy and setup approval limits for purchasing approval
Implemented AP Approval hierarchies using the Special Information Types (SIT) flexfield.
Created custom PL/SQL package to get first level approver for AP hierarchy
Setup business rules in AME module for AP hierarchy
Created custom package for Cash Management process
Created/modified packages to combine payments from two different bank accounts
Defined Bank Transaction codes for auto reconciliation of external transactions in cash
management
Involved in employee supervisor and position cleanup
Customized the PO Approval workflow to meet the client’s requirement
Created and maintained users using SSO
Page 2 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Implemented setups for General Ledger approval
Created mapping tables for promotion planning to be used with synectics and created custom
forms for maintenance.
Created Business Areas for the reports and granted security privileges to the users.
Developed discoverer reports for Active Users and Employees, Invoice Details and Position
Hierarchies as per the client’s requirement
Created workbooks based on the Business Areas.
Created discoverer reports for audit purposes
Created XML publisher reports (Single & Multiple) for Printed Purchase Order to meet
client’s requirement
Created Organizations, Jobs and positions in HRMS
Written custom programs to terminate, hire and re-hire employees
Defined concurrent programs and attached to request set.
Creating and maintaining Users, Responsibilities, etc.
Re-assigned workflow transactions using workflow administrator
Involved in critical patch updates and rollup patches
Involved in Performance tuning and post production support
Preparing MD 070 technical design documents based on the MD 050 documents.
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications 11.5.10 (Oracle HRMS, Oracle Purchasing, General Ledger,
Oracle Payables, Oracle Learning Management, Sysadmin, Application Developer, AME),
Oracle 11g, Oracle Forms 6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000
Dec 2010 – Aug 2012 F. Gaviña & Sons, Inc. Senior Oracle Apps
Los Angeles (Vernon), CA Consultant
The Gavina family has been in coffee business for over 130 years as growers, importers and
roasters of gourmet coffee. The company is one of the successful and largest in coffee business in
the western United States. Role involved as Senior ERP Developer includes development and
customization of reports, customization of Forms and data conversions. Involved in R12 upgrade.
Also involved in support and enhancement of applications.
Responsibilities:
Gathered requirements and designed the functional specification documents for the
implementation of trade promotion analysis and planning system.
Developed an Interface between the Apps system and Synectics Account Review (3 rd party
system for trade promotion analysis, planning and settlements).
Implemented DFF’s to store the promotional plan data whenever a Sales order is created to be
used for re-conciliation with the receivables system by Forms personalization
Developed Interface files for feeding into the synectics system and receiving the promotion
files for feed into the Oracle system.
Involved in 11i – R12 upgrade. Created FNDLOAD scripts to backup and restore the
customizations done to the system
Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to
Oracle Receivables tables using the Auto Invoice Import program.
Customized AP Invoices approval workflow to meet the requirements of the client
Page 3 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory
using the Import Items program.
Developed a daily report to show the orders created for the day with the promotion plan
details in Oracle Discoverer.
Created mapping tables for promotion planning to be used with synectics and created custom
forms for maintenance.
Created Business Areas for the reports and granted security privileges to the users.
Developed PL/SQL packages to import booked Sales Orders from the legacy system into
Oracle in the Order Management module.
Created workbooks based on the Business Areas.
Defined concurrent programs and attached to request set.
Creating and maintaining Users, Responsibilities, etc.
Synchronize Active Directory with Person data using the Oracle dbms_ldap package by
modifying the attributes of Active Directory for use by downstream applications
Involved in Performance tuning and post production support
Preparing MD 070 technical design documents based on the MD 050 documents.
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications R12/11.5.10 (Oracle Inventory, Oracle Receivables, General
Ledger, Order Management, Oracle Payables, Oracle Financials), Oracle 11g, Oracle Forms
6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000
Apr 2008 – Nov 2010 Optinuity Alliance Resources Senior Oracle ERP
Corporation, Armonk, NY Consultant
Optinuity Alliance Resources provides portfolio and operational support services to MBIA Inc.
and its subsidiaries and affiliates. These services include portfolio management and remediation,
claims management, financial reporting, tax preparation and auditing services, information
technology, corporate administration and analytical and consultative services in remediation,
financial reporting, legal, marketing, and strategy.
Responsibilities:
Gathered requirements and designed the functional specification documents for the
implementation of trade promotion analysis and planning system.
Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to
Oracle Receivables tables using the Auto Invoice Import program.
Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory
using the Import Items program.
Create PL/SQL packages for General Ledger Historical import
Imported AP invoices from Legacy system to Oracle Apps
Written cash management interface for bank transactions
Created Business Areas for the reports and granted security privileges to the users.
Developed PL/SQL packages to import booked Sales Orders from the legacy system into
Oracle in the Order Management module.
Created workbooks based on the Business Areas.
Defined concurrent programs and attached to request set.
Creating and maintaining Users, Responsibilities, etc.
Synchronize Active Directory with Person data using the Oracle dbms_ldappackage by
modifying the attributes of Active Directory for use by downstream applications
Page 4 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Involved in Performance tuning and post production support
Preparing MD 070 technical design documents based on the MD 050 documents.
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications R12/11.5.10 (Oracle Inventory, Oracle Receivables, General
Ledger, Order Management, Oracle Payables, Oracle Financials), Oracle 11g, Oracle Forms
6i/Reports 6i, Oracle Discoverer 10g, Shell Script, Windows2000
Oct 2007 – Mar 2008 Ulticom Inc., NJ Senior ERP Developer
Ulticom is a global leader in service-enabling software providing solutions to Tier-1 network
equipment providers and service providers. Found as a provider of contract programming and
services, Ulticom amassed talent and experience in telecommunications signaling, networking
and applications. Role involved as Senior ERP Developer includes development and
customization of reports, customization of Forms and data conversions. Also involved in support
and enhancement of applications.
Responsibilities:
Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to
Oracle Receivables tables using the Auto Invoice Import program.
Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory
using the Import Items program.
Created database tables, sequences and synonyms to capture the SR details when the
customer takes on the satisfaction survey when the SR is closed.
Developed the Customer Satisfaction Survey Report which gives the SR Details along with
the Questions and Answers using Discoverer 10g.
Developed Custom Reports in the OTL module to get the timecard summary and details of all
employees in the organization using Discoverer 10g. This report is developed based on the
supervisor hierarchy which enables the managers to get the timecard details for the list of
employees under them.
Created a custom form to keep track of the RMA(Return Material Authorization) transactions
and two custom tables on which the form is based.
Created the RMA Performance Response Rating, RMA Summary & Details Report and the
Traveller Details Report .
Generated a commercial Invoice Report using XML Publisher. The RTF templates used to
generate PDF and HTML outputs is developed using Template Builder for Word.
Developed a custom report in the HR module to get the education details of all the active
employees in the organization at a given point of time.
Developed custom reports in the HR module to get the salary details, performance review
details of all employees in the organization during a given point of time.
Developed the VSOE Licensing Report which gives the maintenance and the contract details
for all the licenses. This report fetches the data from the Inventory, Service Contracts,
Installed Base and Receivables modules.
Developed Paid Time-Off Reports which includes the Vacation, Sick Leave and Floating
Holiday Details of employees in the organization based on the supervisor hierarchy which is
attached to the responsibilities of all the employees. For managers, it will give their leave
details along with the details of their subordinates.
Created Business Areas for the reports and granted security privileges to the users.
Page 5 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Created workbooks based on the Business Areas.
Defined concurrent programs and attached to request set.
Creating and maintaining Users, Responsibilities, etc.
Preparing MD 070 technical design documents based on the MD 050 documents.
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications 11.5.10 (Oracle Inventory, Oracle Receivables, General
Ledger, Oracle Install Base, Service Contracts, Oracle Payables, Projects, Oracle
Financials), Oracle 10g, Oracle Reports 6i, Oracle Discoverer 10g, Shell Script,
Windows2000
Apr 2006 – Sep 2007 Business Transformation Oracle Apps Tech Consultant
Program (BTP) –
IBM, Metro Atlanta
Rapid Transit
Authority (MARTA),
Atlanta GA
Metropolitian Atlanta Rapid Transit Authority(MARTA) is Atlanta’s modern transit system. It is
the primary bus and train facility operating in Metro Atlanta. It operates across 5 counties in
Atlanta for more than a quarter century and 3.5 billion rides. Role as an Oracle Apps Tech
Consultant – Data Conversion from Legacy System to Oracle Applications, Interfaces, extensions
to current application, reports development across modules and post-production support.
Responsibilities:
Developed a package to load the Assets from the Legacy System into Oracle Applications
using the Mass Additions program.
Developed a package on AR Auto Invoice Interface, imported invoices from legacy system to
Oracle Receivables tables using the Auto Invoice Import program.
Developed PL/SQL packages to bring in General Ledger Balances into Oracle from the
legacy system with 5 years of history as summary and the current fiscal year transactions in
detail using Import Journals program.
Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory
using the Import Items program. Also updated the Average Cost of Items.
Developed PL/SQL package to import Customers from legacy using Customer Import
program and used API’s to update the e-mail address and the salesperson.
Created PL/SQL packages to import open purchase orders into Oracle Applications
Purchasing module using the Purchase Order Import program.
Developed PL/SQL packages to import booked Sales Orders from the legacy system into
Oracle in the Order Management module.
Written packages to import Project Balances based on awards and split percentage using the
PRC Transaction Import program into Oracle Grants Accounting module.
Written an Interface program in Inventory module to automate the Item process including
Master Items, Organization Assignment, Item Catalogs, Manufacturer Part Numbers, Item
Cross-references and Sub-inventory Assignment.
Created SQL Loader scripts and temporary tables for the Data Conversion process.
Developed Missing Assets Report in Fixed Assets (FM) module to identify missing assets
based on physical inventory including a PL/SQL program that identifies and prints the report.
Page 6 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Developed a report which updates the physical inventory name and generates a report of the
updated assets using Reports 6i as per the client’s requirement.
Developed Auto Write-off Uninventoried Assets to identify Assets missing for more than two
years and retire them automatically.
Created the GL Translation Form to help the users identify the mapping of legacy values to
Oracle values for Chart of Accounts in the General Ledger module.
Developed Inventory Adjustments Report, Inventory Turn-over Report, Months of Inventory
On-hand Report in the Inventory module using Reports 6i and Discoverer.
Created SQL Loader control files and temporary tables in Oracle to bring in data from flat
files to oracle for validations during Data Conversion.
Created unit test cases and performed unit testing; provided post-production support to client.
Defined Concurrent Programs and attached to request set.
Prepared Technical Design Documents (MD070) based on Functional Design Documents
(MD050)
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications 11.5.10 (Inventory, Receivables, General Ledger, Oracle
Grants Accounting, Purchasing, Payables, Fixed Assets), Oracle 9i, Oracle Reports 6i,
Oracle Discoverer 4i, Shell Script, Windows2000
Sep 2005 – Mar 2006 AIS – Asset and Inventory Oracle Apps Tech Consultant
System
Singapore Police Force (SPF),
Singapore
This project involves developing an AIS (Asset and Inventory System) for Singapore Police
Force. This is a customized application, the Inventory System consists of modules like eKit, TOE,
Loan, Condemnation, Inter Unit Transactions and Sub Inventory Transfer. Each officer is given
an eKit Card based on their vocation and service status to monitor the transactions for clothing,
info-communication and operation equipments issued from the different stores. My involvement
was with the Data Loading (interface) of the Inventory, BOM and the Enterprise Asset
Management modules.
Responsibilities:
Create PL/SQL packages for importing Items and On-Hand quantities into Oracle Inventory
using the Import Items program. Written a package to update Average Cost of Items.
Written validation programs in PL/SQL to import Asset Groups, Rebuildable Items, Asset
Activities and Rebuildable Serial Numbers into the Enterprise Asset Management (EAM)
module using the Import Items program.
Used Oracle API’s to upload Meters, Associate Meters, Associate Activity and upload
preventive Maintenance with runtime rules into the Enterprise Asset Management module.
Created PL/SQL packages to import open purchase orders into Oracle Applications
Purchasing module using the Purchase Order Import program.
Developed PL/SQL programs to import Bills and Routings into the Bill of Materials (BOM)
module using the Import Bills and Routings standard Interface program.
Developed the e-kit transaction report using Reports 6i as per the client’s requirement.
Customized the Aging Trial Balance Report in the Payables modules as per the client’s
requirement.
Created custom form for the e-kit transactions to keep track of equipments given to the
officers on duty.
Created SQL Loader programs and temporary tables for Data Conversions.
Page 7 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Created test cases and performed unit testing of the modules.
Provided post-production support to the client.
Created Responsibilities and attached it to users.
Effective knowledge transfer to the entire team.
Prepared Technical Design Documents (MD070) based on Functional Design Documents
(MD050).
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object
Library, Oracle Applications 11.5.10 (Oracle Inventory, Enterprise Asset Management,
General Ledger, BOM, Financials), Oracle 9i, Oracle Reports 6i, Shell Script,
Windows2000.
May 2005 – Aug 2005 Hutchinson Instance Merger Oracle Apps Tech Consultant
Hutchinson,
Singapore/Thailand
Hutchinson is a leading cell phone service provider in Thailand. The Hutchinson Instance Merger
project involves merging of two Instances for Hutchinson (Thailand). This includes migration of
data for the AP, PO, FA and GL modules and developing and customizing reports in the
Inventory, OM and AR modules. My involvement was with AP, PO, FA and GL modules.
Responsibilities:
Written extraction scripts for extracting data from the Payables, General Ledger, Purchasing
and Fixed Assets modules from the Hong Kong (HK) instance which is used for loading into
the Thailand (TH) instance.
Created PL/SQL packages to load the open Invoices from the HK instance into the TH
instance into the Payables module.
Created PL/SQL packages to import open purchase orders into Oracle Applications
Purchasing module using the Purchase Order Import program.
Developed PL/SQL packages to bring in General Ledger Balances into Oracle from the
legacy system with 5 years of history as summary and the current fiscal year transactions in
detail using Import Journals program.
Developed PL/SQL packages and scripts to bring in suppliers from the legacy system into
Oracle Applications Payables module.
Created PL/SQL packages to import open purchase orders into Oracle Applications
Purchasing module using the Purchase Order Import program.
Written a Custom program in Order Management module to create and close a sales order in
a different company, which includes various stages in the Sales order like Pick Release and
Ship Confirm.
Customized the GL 180 char report to suit the client’s requirement using Reports 6i.
Created SQL Loader programs and temporary tables for Data Conversions.
Created test cases and performed unit testing of the modules.
Provided post-production support to the client.
Created Responsibilities and attached it to users.
Effective knowledge transfer to the entire team.
Prepared Technical Design Documents (MD070) based on Functional Design Documents
(MD050).
Environment: Sun Solaris, Oracle System Administrator, Oracle Applications Object Library,
Oracle Applications 11.5.7 (Oracle Purchasing, Payables, Fixed Assets, General Ledger), Oracle
8i, Oracle Reports 6i, Shell Script and Windows2000
Page 8 of 10
Profile of Balachandran Venkatasubramanian (Bala)
Mar 2004 – Apr 2005 Oracle 11i Customization and Software Engineer
Support
Gulf Extrusions-Dubai, India
The Project involves writing Interface Programs using SQL* Loader for importing Invoice
information into Oracle Payables Module and customization of Oracle Payables and General
Ledger modules using Reports 6i. The application has been customized to meet the need of the
customer.
Responsibilities:
Imported Journal Information into GL module using SQL*loader.
Involved in developing Future Payment Status Report as per the client’s requirements using
Oracle Reports 6i.
Developed the GL Dual Currency Report as per the client’s requirement.
Imported Invoice Information into Payables module using SQL*loader.
Imported Purchase Orders and Suppliers into the Purchasing module.
Customized the Purchase Order form to enable charge account in the purchasing module as
per client’s requirements.
Developed Supplier and Site-wise report in AP using Oracle Reports 6i.
Defined concurrent programs and attached to request set.
Creating and maintaining Users, Responsibilities, etc.
Creating and assigning document sequences.
Preparing MD 070 documents based on the MD 050 documents.
Environment: Sun Solaris, Oracle Applications11.5.9, Oracle Payables, Purchasing, General
Ledger, Oracle 9i, Forms 6i, Reports 6i, Shell Script and Windows2000
Jan 2003 – Feb 2004 Oracle Applications Software Engineer
Customization and
Interfacing - Visaka
Industries, India
This project involves the implementation and support of Oracle Financials. The
application has been customized to meet the needs of the customer.
Responsibilities:
Creation of interface tables, SQL*Loader control file to transfer data from flat files to Vendor
interface tables.
Developed PL/SQL programs to validate and transfer data from vendor interface tables to
application tables.
Imported invoices from legacy system into Oracle payables through Payables Open Interface.
Developed PL/SQL script for loading Purchase Order Information into Oracle Purchasing
using Purchasing Documents Open Interface.
Developed the Invoice Aging Report without the Aging Buckets in the Payables module.
Developed the Check Payment Voucher report as per the client’s requirement.
Environment: Oracle Applications11i Purchasing, Payables, General Ledger, Fixed Assets,
Forms6i, Reports6i, and UNIX.
Jan 2003– May 2003 Oracle 11i Implementation Software Engineer
Citadel, India
Page 9 of 10
Profile of Balachandran Venkatasubramanian (Bala)
The project involves Customization of Oracle Application by developing Oracle Forms, Reports,
and PL/SQL for a telecommunication company. The application has been customized to meet the
needs of the customer.
Responsibilities Included:
Created the temporary tables for transferring data from flat files.
Created SQL*Loader scripts to import customers from legacy system to Accounts
Receivables.
Created reports as per client’s requirement.
Created SQL*Loader scripts to import journals into Oracle General Ledger.
Customized reports as per client’s requirement.
Imported external invoices into Oracle Receivables through Auto Invoice Program
using SQL*Loader.
Environment: Sun Solaris, Oracle Applications11i, Account Receivables, Payables, Oracle 8i,
Forms 6i, Reports 6i, Shell Script, Windows2000.
Mar 2000 – Dec 2002 HR Information System – Performance Programmer
Management – Aarohi Communications
Pvt. Ltd., India
The Human Resource Information System is an intranet based Management Information
System that is a framework of various applications of the client’s organization. This
system provides an online system to obtain complete insight into the employee
information by the HR and Senior Management executives. The Performance
Management consists of sub-modules: Goal Setting, Appraisals, Development Plan,
Rating, Assessment and Backup Identification. My involvement was with Appraisals and
Development Plan.
Responsibilities:
Implemented database packages and procedures for Appraisals reviews using
PL/SQL.
Developed user interface screens using Forms 6i to capture appraisal reviews.
Validate the review rating in consensus with Goal Setting.
Validate the appraisal proposal and development plan using Forms screens.
Involved with maintenance and new enhancement to this module.
Involved in developing unit test cases and perform unit testing of my modules.
Environment: H/w: Pentium O/s: SOLARIS 8, Windows NT S/w: Oracle 8i,Forms6i/Reports 6i,
SQL*Plus, PL/SQL, Shell Script and Pro *C.
***
Page 10 of 10
Contact this candidate