jaya santosh behera

▪ ABF methodology being used for the Implementation.
▪ Involved in development of AS-IS (RD020) Business process document for Oracle HRMS, SSHR, Payroll and PMS.
▪ Involved in development of TO-BE Business (BR030) process document and Setup document (BF.100) for Oracle HMRS and SSHR.
▪ Developed Payroll and Accrual Fast formulas.
▪ Setup Business Groups, KFF’s, DFF’s, SIT and EITs.
▪ Setup Absences and Payroll Elements.
▪ Incorporated the Business Logic using Oracle Fast Formulas for Performance management system
▪ Developed and customized the Oracle workflow
▪ Configured Oracle AME for Approval process.
▪ Configured Oracle Alerts.

Radar Optimization
Duration: Jun 2009- Mar 010
Team size: 5
Role: Oracle Pl Sql Developer
Environment: Oracle 10g, Unix, Mac OS
Summary: Apple is a leading Consumer Electronics manufacturer in the US. Apple sells its products through various channels including its retail chain. Radar is Apple’s problem (bug) tracking tool. Apple IS&T R&D group has plans to incorporate the tasks. The scope of this project has been derived based on the followings
o CVS clean up activities
o Segregate each of the file in DDL folder to hold the ddl of each table along with the Grant, Index, synonym statements.
o Validate the updates done against production sources to ensure that they are in synch
o Move all the data correction scripts to migration folder.
o Database Code Clean up activities for 742 Database Objects
o Remove redundant codes from Radar application database objects
o Remove obsolete codes that are no longer been used
o Improve code readability by proper code indentation
o Improve code readability through appropriate comments wherever its necessary

Responsibilities:
o Developed Shell Script to remove unused Variables.
o Developed Shell Script to append Mod Log .
o Code Indentation by using PL SQL Developer.
o Modularizing Database Objects (Combining Functionally similar Objects Into Packages.)
o Removing Redundant Codes

Enterprise Resource Planning and Optimization
Duration: Jan 2008- May 2009
Team size: 15
Role: Oracle Pl Sql Developer in Sales & marketing module, Financial Accounting Module of the ERP system
Environment: Oracle 10g, VB. Net, Crystal Report 9, Toad 7.0, Windows XP, Oracle Enterprise Manager, Collections, SQL*Plus, TKProf, Explain Plan
Summary: The ERPO is an ERP system that is under development aimed to integrate and automate many of the business practices associated with the operations or production aspects of HML. Our ERP basically caters to the need for planning, manufacturing, invoicing, distribution, inventory and accounting. This software can aid in the control of many business activities like Sales, Delivery, Billing, and Inventory management, Human Resource, Material Mgmt, Raw Materials, Material Loan, Fixed Deposits and Financial Accounts etc. It’s a customized tool which can help any industry specially Cement manufacturers and has been developed according to the needs of the Company unlike other built in ERP’s which doesn’t support all the features..
Responsibilities:
o Designed and developed complex Procedures, Functions & Packages using PL/SQL.
o Used Collections like variable arrays, nested tables extensively.
o Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
o Handled DBA activities like user creation, backup.
o Used Import Export tools to create dump files for exporting and importing data to the database
o Used Export/Import utility for backup purpose and transferring data from one database to another.
o Rectification of errors reported during System Test and User Acceptance Test.
o Identification and implementing business rules (constraints, triggers etc.) and views.
o Developed materialized views for reporting purpose in Sql Reports & Crystal Reports
o Tuning of SQL Statements using EXPLAIN PLAN, SQL-TRACE and TKPROF

Legacy System
Duration: Apr 2007 - Dec 2007
Team size: 10
Role: Database Developer
Environment: Oracle Developer 6i, Forms 6i, Reports 6i, Korn Shell Scripts
Summary: This project is developed in Centralized Architecture with Browser based access, to the centralized Database and Oracle Application Server. Day to day financial transactions is entered in the system from multiple locations. Major transactions are CPV (Cash Payment Vouchers), CRV (Cash Receipt Vouchers), JEs (Journal Entries), Revenue Budget transactions etc. Major modules are Transaction Entries, Daily Cashbook Generation, Financial Ledger & trial balance, Party Ledger & Trial Balance, Revenue Budget Details, Cheque Printing, Pay-in-Slip, and Bank Reconciliation.
Responsibilities:
o Application development using Forms 6i.
o Build ad-hoc reports.
o Created Stored Procedures, Functions to call various oracle developer modules.
o Sub-queries and joins were extensively used in stored procedures.
o Created database triggers to automate the transactions that take place online.
o Assess and fix bugs.
o Creation of users, roles and procedures for data clean up to protect the database security.
o Used SQL Loader to automate the load of data from Text files to Oracle Tables.
o Created UNIX Shell script for sending email to alert users for erroneous records.

EMS (Estate Management System)
Duration: Dec 2006 - Mar 2007
Team size: 15
Role: Database Developer
Environment: Oracle 8i, PL/SQL, HP-UX 10.x, complex Stored Procedures, triggers and packages, SQL Loader, Oracle Forms & Reports 6i, SQL*Plus, Toad.
.
Responsibilities:
o Developed forms and reports using Oracle Forms and Reports 6i
o Used Stored Procedures, Packages and Database Triggers extensively.
o Sub-queries and joins were extensively used in stored procedures.
o Rectification of errors reported during System Test and User Acceptance Test