Software Engineer Project

SIDDALINGAPPA NESWI

Contact: +91-998******* E-Mail: *****@*****.***

Seeking senior level challenging assignments in Oracle / PL / SQL / Performance Tuning and D2k Technologies & Applications / Project Management with an organisation of high repute

Professional Précis

A dynamic IT professional with nearly 10 years of comprehensive experience inclusive of over 7 + years in Oracle / PL / SQL / Performance Tuning and D2k Technologies & Applications. Expertise in analysing existing systems and procedures, preparing business continuity plans, designing internal control systems and facilitate effective decision-making. Possess working knowledge on interfaces using SQL * Loader & Custom Application Development. Proven skills in managing teams to work in sync with the corporate set parameters & motivating them for achieving business and individual goals. Possess excellent interpersonal, communication & organisational skills with proven abilities in team management, customer relationship management & effective crisis management.

Core Competencies

Technical Skills

Operating Systems : Windows XP / 2003 / 2007, UNIX, MS-DOS, WINNT 4.0 & Linux

Data Base (RDBMS) : Design & development of RDBMS applications in ORACLE (7.X/8i/9i/10g) with developer

2000, Forms (4.5 / 6i / 9i / 10g) Reports (2.5 / 6i / 9i / 10g) & Graphics (2.5), SQL *

Plus, PL/SQL with Backend Development (Stored Procedures/Functions/Packages &

Triggers) / Performance Tuning, Exposure of DBA Functions.

Languages : Java / Applets / Swing / JDBC / HTML

Programming Skills : C / Pro * C

ERP : Oracle Applications (Oracle Financial )

Modules : (GL / AR / OE), AOL, Alert & System Administration

Functional

Oracle / PL / SQL and D2k Technologies & Applications

Implementing the customised ERP Application developed in Oracle/PL/SQL and D2k.

Documenting the requirements and developing the specifications for customisation.

Rendering technical guidance and training to the end user.

Handling the new enhancement & looking after the maintenance of the project developed Oracle /PL/SQL.

Project Management

Managing large sized projects.

Executing projects within time limit.

Mentoring team, deploying, monitoring and development.

Defining best practices for project support and documentation.

Employment Scan

Since Dec’09 with Accenture Software Services Pvt Ltd.

PROJECT EXECUTED

Title : Revenue Recognition (Sales & Finance) Team Size: 4

Client : Cisco (USA)

Environment : Oracle 10g / PL / SQL & Toad.

Description : The Revenue Recognition Application project is a Finance initiative to develop a custom application

that will automate and integrate information that is currently processed manually for

arriving at the deferred and recognized amounts for revenue, cost of goods sold(COGS),RMA

and Discounts.

Revenue Recognition Application contains SKU based exception. This is custom form to capture SKU based exceptions, for all theatres i.e US, EMEA, APAC.

Recognition Decision Logic (RDL) will derive and pass to the calling application whether Recognize or Defer rule needs to be applied for deriving the applicable GL account.

The Revenue Recognition Account Management, a custom form, is where the user will set up the Dr and Cr Account pairs to be used by the applications. The Source and Rule Type will determine the account pairs to be selected. A lookup will be set up in oracle, where all sources and rule types would be capture.

Accountabilities

Leading the team of 4 members, Interaction for team members, allocation of work to team members and Interaction with onsite coordinator.

Contributing in:-

o Development of Backend Procedures / Functions / Packages & Triggers.

o Preparation of Technical specification based on Functional specification.

o Test Case Preparation and Unit Testing.

Title : CMEH - (Customer Master Exchange Hub) Team Size: 2

Client : USA

Environment : Oracle 10g / PL / SQL & Toad.

Description : The Enterprise Customer Web services will be architected as an enterprise solution to access and

Maintain Customer Master Data stored in Customer Master Exchange Hub. A customer search is needed to retrieve customer and related customer information from the Customer Exchange Hub. Customer Exchange Hub contains 2 services.1.Maintenance data service and 2.Read Service.

A metadata model would be required to maintain information about the consumer. For example Consumer source systems, consumer nodes, consumer node types (INDV,ORG),consumer behaviors profile, element catalog, usage association.

The maintenance service maintains the customer master data in customer exchange hub. The metadata layer for maintenance data contains the information about the consumer system, maintainable nodes and their hierarchical structures, program interface, actual fields, node types.

Accountabilities

Leading the team of 2 members, Interaction for team members, allocation of work to team members and Interaction with onsite coordinator.

Contributing in:-

o Development of Backend Procedures / Functions / Packages.

o Preparation of Technical specification based on Functional specification.

o Unit Testing.

Since Nov’ 08 with Zensar Technologies Ltd.

PROJECT EXECUTED

Title : CSCC - (Cisco Service & Contact Centre – Quoting and Ordering). Team Size: 4

Client : Cisco (USA).

Environment : Oracle 9i / PL / SQL & Toad.

Description : CSCC combines many tools into one, for a clean, Unified Service and Sales Experience.

This will simplify to identify Opportunities, Create Quotes and Manage Contracts all

in one Application. CSCC will expedite the Quote Creation Process by allowing users to complete Validation and Error handling upfront, without requiring Manual Support.

CSCC for Indirect Resellers and Distributors will consolidate multiple applications into one single Quoting Application. Simplifying Quote and Contract creation/ renewal Process for 1-tier and direct customers, Order submission and management. Ability to perform variety of functions within one like Opportunity Management, Contract Management and 'Quote to Order' conversion.

CSCC Application can be used for Creating New Quote and Renewing existing Quote. In case of

Successful validation, Partner will be notified with price details in Order to Create Contract/

Order, Otherwise Error description with recommended action will be displayed over user interface

so that Quote Creation/ Modification Process can be revalidated. In successful validation scenario

the Quote Entity lifecycle can have various status like NEW, VALID, ORDER_IN_PROGRESS,

ORDER_BOOKED, ORDER_SUBMITTED, ORDER_COMPLETE, Otherwise INVALID status message

will be displayed.

Accountabilities

Leading the team of 4 members, Interaction for team members, allocation of work to team members and Interaction with onsite coordinator.

Contributing in:-

o Performance Tuning, helping the solving of defects.

o Development of Backend Procedures / Functions / Packages & Triggers.

o Preparation of Technical specification based on Functional specification.

o Defect fixing / Test Case Preparation.

Aug’06-Oct’08 with iGATE Global Solutions Ltd., Bangalore

PROJECT EXECUTED

Title : CFM - (Customer File Management System). Team Size: 4

Client : Metro MGI (Germany).

Environment : Oracle 9i/PL/SQL, Windows 2000 Professional.

Front End Tool : Forms 9i & Reports 9i.

Description : The Customer File Management System (CFM) at Metro MGI (Metro Group of Informations) is

the international applications in CRM umbrella of applications for, Administrations of customer

file data including, Customer Master data and Transactional data. Support customer lifecycle

dependent activities Ensure standardized customer classifications Maintains Customer Blocking

Strategies The CFM Applications resides on the Customer Server (CS) which is the International

data platform for all CRM applications. CFM can be used as a de central system, called Single

Store where the Applications and the database reside in each of the stores in a Client/Server

Environment or as a central system called the Multi store which represents a Web Architecture

where in different stores accesses the applications through web. There are Multiple application

systems like POS System, Goods Management System and also Metro Data Warehouse which

interacts with the Customer Server(CS).CFM Applications has Interfaces to/from these various

systems for the exchange of data both customer master data as well as transactional data. The

CFM Applications when Internationally deployed needs to be customized for local language

interaction.

Accountabilities

Leading the team of 4 members, Interaction with members, allocation of work to team members and Interaction with onsite coordinator.

Contributing in:-

o Design and development of Application for New enhancements.

o Preparation of Technical specification based on Functional specification.

o Coding/Designing of Forms and Reports.

o Development of Backend procedures / Functions / Packages and Triggers & Performance Tuning.

o Unit testing / Defecting fixing and Documentation.

Apr’06-Aug’06 with iNetFrame Technologies Pvt. Ltd., Bangalore as Sr. Software Engineer

PROJECT EXECUTED

Title : SGCIB - (Societe General Corporate & Investment Banking). Team Size: 5

Client : Oracle Software Solutions India (Oracle SSI).

Environment : Oracle 10g, Windows 2000 Professional, Linux

Front End Tool : Forms 10g, Reports 10g Migration

from Forms6i / Reports 6i to Forms10g / Reports10g

Description : SGCIB is a migration project, migration from Forms 6i, Reports 6i to Forms 10g and Reports

10g. The two-tiered architecture is replaced by three-tier in 10g, in Linux environment. It

contains 3 modules. Alise/Eole /Gate. During migration, some of the client oriented functions are

replaced and some of the obsolete functions are replaced. Replacing the features is not

supported by Forms 6i to the Forms 10g. Handled, unit and integration testing and taken care of

run-time bug fixing.

Accountabilities

Contributing in:-

o Interaction of Team members, allocation of work to team members.

o Migration of forms from Forms 6i to Forms 10g and Reports 6i to Reports 10g.

o Unit testing of Forms/Reports and Co- ordination with team members.

Dec’04-Apr’06 with Hinduja TMT Ltd., Bangalore as Sr. Software Engineer

PROJECT EXECUTED

Title : Saipa Enterprise Solutions. Team Size: 6

Client Name : Iran (SAIPA).

Environment : Oracle 9i/PL/SQL & Windows 2000 Professional.

Front End Tool : Forms 9i, Reports 9i.

Description : Material Receipts. Material Receipts one of the Important Module of Project SAIPA. Material

Receipts Comprehensively addresses the functionalities related to Receipts and dispatches of

Materials to the Organizations from external resources.

It includes components like:-

Receipts from Overseas Suppliers / Local Suppliers / Sub Contractors.

Dispatches to Supplier against the rejections.

Quality Rejections.

Supplier Blacklist Tracking.

While accounting the material receipts from various sources this system has got the following functionalities to ensure the proper receipt accounting.

Gate entry.

Quantity & quality Verifications.

Goods receipt document generation.

Quality Rejections.

Dispatch of material.

Pallet Accounting.

The Material received at the gate comes along with a Supplier Delivery document which contains supplier details, Purchase order details and Material details. Gate Entry is a preparatory stepped to generate the GRN (Goods Receipt Note). If Material is self Certified, the stock goes directly to Quantity verification done by the warehouse and the GRN generated. If the incoming material is non-self certified it is forwarded to the Inspection department for Quality check. During the Quality verification if the materials fail to meet the quality norms as per SAIPA standards, it is rejected and returned to the supplier. At SAIPA Quality first and then Quantity checked. If Quality is approved then the Materials proceeds to the Warehouse for Quantity check and GRN is created. Import material arriving consignments which are two types, Complete knocked-down and knocked-down. Complete knocked-down refer to a kit of parts it can be assembled into a fully built vehicle. CKD materials are self certified and proceed to warehouse. Depending on the quality of the material and its state rework is ordered. The Material Receipts system also hands the receipt processing for Non Production Items.

Accountabilities

Contributing in:-

o Design and development of Material Receipts Module.

o Preparation of Program Specific documents (PSD), Design of Proto types.

o Designing and Coding of Forms and Reports.

o Development of Backend procedures / Functions/Packages and Triggers & Performance Tuning.

o Unit testing and preparation of User manual and System Manuals documentations.

Oct’00-Nov’04 with Hinduja TMT Ltd., Bangalore as designation Sr. Software Engineer

PROJECTS EXECUTED

Title : ALMAP (Ashokleyland Manufacturing Applications). Team Size: 8

Client : Ashok Leyland Limited, Hosur plant I & II.

Duration : Aug’03-Oct’04.

Environment : Oracle 8i/PL/SQL, Windows 2000 Professional.

Front End Tool : Forms 6i, Reports 6i.

Description : Excise system. ALMAP (Ashok Leyland Manufacturing Applications) is an ERP application. It

contains 16 models. One of the modules of ALMAP is Excise module. The excise module deals

with organizing, directing controlling of the activities related to the excise functionality of

Ashokleyland and maintenance the data at all times as required by the personal. This module

enable the user to provide all the information related to the excise efficiently and reduce the

redundant time bounded activities ensuring higher efficiency and proper handling of the

activities. The main objective of the Excise module is to generate Invoice, Excise Challans, and

Central Excise, Value Added Tax (CENVAT) details and generate statutory reports.

Accountabilities

Contributing in:-

o Design and Development of Excise/Export and Post Channal Modules.

o Preparation of PSD, Coding, Proto type Development & Unit Testing.

o Implementing of above modules in Ashok Leyland Plants Hosur – I & II.

o User Interaction and Maintenance of Modules.

o Documentation of User Manuals and System manuals.

Title : ALFIN (Ashok Leyland Finance). Team Size: 6

Client : Ashok Leyland Limited, Hosur plant I & II .

Duration : Apr’02-Jun’03.

Environment : Oracle 8i/ PL/SQL; Front End Tool: Forms 6i, Reports 6i.

Description : Bill Passing System (Account Payable). Bill Passing System is one of the important modules of

ALFIN (Ashok Leyland Finance). This module handles the payment activities of the suppliers.

Once GRN (Goods Receipt Note) is raised, bills entered at finance Dept. AP booked. Once AP is

booked due date is calculated, depends on the due date payment voucher is generated, cheque

printed then payment made to the supplier.

Accountabilities

Contributing in:-

o Design and Development of Bill Passing System Modules.

o Preparation of PSD, Coding, Proto type Development and Unit Testing.

o Implementation of Bill Passing System in Ashok Leyland Plants Hosur – I & II.

o User and System Manuals documentations.

Previous Experience (Non-IT)

TENURE ORGANISATION DESIGNATION

Jul’98-Mar’00 Infotech Computers, Bangalore Faculty

Jul’97-Jul’98 HMT Ltd., Computer Division, Bangalore Programmer Trainee

Jun’96-Dec’96 Global Information System, Bangalore Faculty

Jun’95-Mar’96 Educomp Datamatics (P) Ltd., Bangalore Faculty

CASE STUDIES IN ORACLE FINANCIALS

Module: Oracle General Ledger.

Design Accounting Flexfield structure and set of Books.

Imported accounting data form legacy system to oracle general ledger and Integrated with oracle general ledger using journal Import for Importing accounting data from legacy system using SQL*Loader and Importing Inter company Data, Statistical Data into Interface Tables.

Module: Oracle Receivables.

Auto Invoice Implementation: Integrated with Oracle receivables with the Legacy system to import invoice information with accounting and invoicing Rules using SQL*Loader.

Module: Oracle Order Entry.

Define Order Entry Cycle, Integrated with oracle Inventory, define items in Inventory, select unique items while setting up descriptive flexfield for Pricing attributes.

AOL: Create journal Entry Application, transferred data from Application tables to GL interface tables by creating procedure.

System Administration: Creating Application users, Report security Group, data Group, Create concurrent Manager.

ACADEMIA: B.E. (Computer Science) from S.J.M.I.T., Kuvempu University, Chitradurga, Karnataka in 1995.

Professional Training Undergone

Pursuing Training in Oracle Applications (Oracle financials 10.6)

Kernex Micro System (I) Pvt. Ltd., Bangalore.

Modules: (GL, AR, OE) Aol, Alert & System Administration.

Personal Minutiae

Address: Akshya Nagara 2nd Stage, Shanthi Layout, Ram Murthy Nagara,

Bangalore-560 016

Contact this candidate