Engineer Project

M. Sreenivasa Reddy

**************@*****.***

**************@**********.***

Mobile:+91-888*******

Objective

To be in challenging positions in programming in an encouraging

organization that has suitable environment to utilize my skills towards

organizational betterment.

Professional Summary

Over Eight years of IT experience including 9.0 years in Client Server

Application development using Oracle, Developer 2000 on NT, Unix and

Linux environments.

My Client Server Technology Skills includes Performance tuning, Stored

procedures, Packages, Database triggers and Developer 2000/6i,Developer

Suite 10g.

Professional Experience

.Working as a Systems Analyst in NTT DATA India Enterprise ..Bangalore,from December 2010 to till date.

.Worked as a Sr Software Engineer in Oracle India Pvt Ltd. Bangalore,from

5 th July 2010 to 10 th November 2010, Under the payrolls of CES(P)Ltd,

Hyderabad.

.Worked as a Sr Software Engineer in Photon Fargo solutions(p)Ltd

Hyderabad, from August 2009 to July 2010.

. Worked as a Software Design Engineer in Spheresoft Solutions Pvt. Ltd.,

Bangalore, from December 2006 to July 2009.

. Worked as a Software Engineer in Gate Wave Technologies, Hyderabad, from

April 2003 to October 2006.

Educational Qualifications

. B.A from Osmania University, Hyderabad.

. Diploma in information systems management from APTECH

. Oracle Certification course from SQL Star international Ltd., Hyderabad.

Technical Skills

. Languages: C, C++, JAVA, SQL, PL/SQL . Database: Oracle 8i/9i/ 10g . Web

Technologies: HTML DB, HTML, JAVA Script and VB Script. . GUI Tools :

Visual Basic 6.0 and Developer 2000 . OS : Dos, Windows 98/XP/NT, Unix and

Linux .

Current Project :

.Organization : Sony India Software Limited, Bangalore. Title : SONY DADC

. Duration :Dec 2010 - to till date.

This is a COM (Central Order Management) system will leads to the SONY

users to place the orders for disk manufacturing.

The order will be Placed for disk qty which has to deliver to said

address. The Order consists pricing of disk. If Manufacturing price of the

disk or not matching of price which given the customer while creation of

order the order went credit hold.

Role :Development Engineer and Lead .

Environment : Oracle10g/As, PL/SQL, FORMS,REPORTS,ORACLE APPS,Windows xp.

Project - 1

.Organization : Oracle India Pvt Ltd., Bangalore. Title : Bacardi STC.

Client : Bacardi Martini(Geneva).Duration :July 2010 - December 2010.

The Bacardi STC(Standard Cost Maintenance ) System is Developed to

Maintain the Production Cost of Bacardi products between the different

entities from the different country's.

This System also generates various reports to show production details

between the entities in different Period's and different Cycle's.

This System also calculate the data for the budget's for different period's

for different

Entities.

Role : Production Support and Development Engineer.

Environment : Oracle10g/As, Oracle Portal, Unix,Windows xp.

Project - 2

. Organization Photon Fargo solutions(p)Ltd,. . Title: Gallieo CBS(Banking

Domain).Client: Sistemas Gallieo (Costa-Rica). Duration : August 2009 -

July 2010. Team Size:22

The Callieo CBS is a Core Banking Solution System. This Provides maximum

requirements of a Core Banking Client With the following modules.

> CIF( Customer Information)

It gives every user the ability to access all the information

available on a particular customer from a single screen display. With

CORE BANKING's comprehensive CIF feature, you and your employees can

consolidate and view the entire relationship that any customer

maintains with your Institution. CIF information is easy to access by

customer name, account number, or tax ID.

> Deposits:

The more efficiently your personnel handle DDA items, the more time they

will have to better serve both customers and the financial institution.

Core Banking handles the high volume of items associated with DDA accounts

with unmatched efficiency. Core Banking reliably processes all items as

they flow from teller windows, drive ups, ACH, ATM Networks, Telephone and

Web Banking, and the Fed.

? Standard interfaces with proof, online sorter, cash letter, ACH,ATM

transactions, Web and Voice Banking, etc.

? Image-based POD and check imaging

? Full float capture and analysis by account

? Both combined and single-statement accounts at the customerlevel

? Exception item processing

? Overdraft loan protection

? Automatic transfers between accounts

? Sweeps and business account analysis, online NSF processing,and more.

> Certificates of Deposit

Core Banking's Certificate of Deposit module provides maximum flexibility

in handling a wide variety of Time Deposit instruments

? Fixed and variable rate CDs

? Various interest accrual methods

? Interest payments by check, transfer to DDA or savings account, or add-on

? Call report information breakdown

? User-defined class codes to identify products

? Automatic, user-defined early withdrawal penalty calculations, and more

> Credit Tracking

Core Banking Incorporates a tickler file for tracking credit documents that

expire or require review. This module enables the financial institution to

keep up with expired financial statements, UCC filings,and similar

documents and events. Customized letters or notices can be pre-defined and

stored to notify customers on actions required to renew documents set to

expire.

> Report Engine

A key element of Core Banking is it's full-featured Report Engine one of

the most powerful management, auditing, and marketing tools available. This

module makes it easy to produce specialized reports that present data you

need in the format you prefer.

? Access to information across multiple applications

? Multiple select and sort-by capabilities

? Stores predesigned report templates in multiple custom libraries

> Loans

Loan processing is among the most complex of financial institution's

operations. Core Banking's single loan module design enables the financial

institution to process multiple loan types in a single application. This

simplifies training, and makes the loan data entry and balancing much

easier.

? Processing for fixed, variable, and adjustable rate loans

? Standard interface to popular loan origination systems

? Advancing and re-advancing loans

? Floor and ceiling protection per loan

? Call report information breakdown

? Irregular payment schedules

? Various credit life and accident & health insurance options

? Escrow accounting

? Accounting for FASB91 and credit bureau reporting

? Full or partial non-accrual and charge-offs

? Detailed GL classifications, and more

> General Ledger

The Financial Institution's operation and profitability depends on current

and accurate financial information. Core Banking's General Ledger module is

designed to deliver the flexibility you

need to obtain information and totals in custom-designed formats based on

your needs.

? Branch/Cost Center accounting

? FI-defined statement of condition and income statement

? Back-dated transaction processing

? Online transaction inquiry

? Budget and comparative statements

? GAP analysis and rate sensitivity analysis

? G/L balancing report generator

? Automatic interfaces from ancillary systems, such as accounts payable and

investment accounting.

Environment : Oracle 10g, SQL,Pl/Sql, SQL Navigator, Oracle

Forms10g,Reports 10g Windows 2007 Server.

Role:

Working as senior member of the Project, Organizing meeting with clients

and providing the issue status etc., testing of the existing code for the

performance and was involved in migration 7i to 10g.

Used PL/SQL in writing Functions, Procedures and Packages to maintain

referential integrity and to do complex updates and validations

Project - 3

. Organization: Spheresoft Solutions Pvt. Ltd. . Title: MultiFonds

(Product) . Duration : November 2007 - June 2009. Team Size:15

The MultiFonds Fund Accounting system has been conceived and developed to

support the complex requirements of Fund Accounting in a global

marketplace.

MultiFonds Fund Accounting, which also includes full accounting

functionality, is now proven in the field, and its rich functionality is

already supporting the operations of many large and prestigious

International Banks or Fund Administrators in 20 countries.

MultiFonds Fund Accounting is completely multi-currency, multi-language,

multi-compliance and real-time. The system is very rapid and supports very

large volumes. Its mission-critical architecture and use of leading-edge

industry standard development tools ensure almost limitless scalability.

Extensive use of user-definable parameters guarantees continuity of

operations in a developing environment and adaptability to various country

legislations.

Involved in the following modules:

. Advanced Pooling Solution - Rebalancing of Stock exchange, Foreign

exchange, Futures, Options, Deposits and Loans.

In the Advanced pooling solutions, P&L accounts and rebalancing

transactions are based on the current day PAR calculation. The PAR being

calculated should only change if subscription and redemptions are processed

in the sub funds. In order for the PAR to change only with subscription or

redemption activity, rounding calculations is changed in Multifonds. This

change in rounding calculation will prevent rebalancing transactions when

there is no subscription or redemption activity on the sub-funds.

Allocation of the trades in the sub-funds based on the PAR as on the fund

accounting date. However on account of new sub. /red. the PAR could change.

This may therefore result in the trade positions in the Sub-funds not being

in accordance with the new PAR. The user would therefore need to do

rebalancing in order to readjust the futures positions in the sub-funds.

. Advanced Pooling solution - Subscription/Redemption Settlement in foreign

currency

Normally, the pool and sub-funds currency should be same. If the user

booked in different currencies we need to perform the following steps:

Sub./Red. are processed at the sub-fund level validated with outstanding

status.

i. SB process - determining the FX trades to convert Sub./Red. into pool

base currency.

ii. SC process - fund accounting receives confirmed FX trade or rate and

injects in MF related Sub./Red. trade is authorized.

iii. FI process - generating the input file using the provided FO file.

iv. CT process - exporting the transactions to the text file.

. Advanced pooling - NAV reporting

Printing the reports at several different levels will be a key control in

ensuring that the pooling structure is working correctly and that there are

no breakdowns in the replication/allocations. NAV reporting is done in

three different levels.

i. Manager level reports are required to print NAV reports at manager

level.

ii. Fund level as per the current official NAV process reports will be

printed at fund level.

iii. NAV group summary level reports will be developed as per NAV group for

checking whether the NAV and daily movements are within tolerance.

. Sylvan Feed Extract is an interface for Sylvan extract, for extracting

the positions and transaction data from the Multifonds. It is used to feed

the performance system sylvan and can be used for one or several funds. The

user can extract data from Sylvan interface according to the parameterizes.

. Compliance module is made up of the management of several Italian rules.

This phase of development covers the main limits on derivative instruments.

i. Controls must be realized in order to check the limits on derivative

investments.

ii. All listed derivatives must have an allowed underlying asset related to

fund's portfolio.

iii. All unlisted derivative must have an allowed underlying related to

fund's portfolio and this unlisted derivative must be traded with a high

standing counterparty.

iv. Uncovered derivatives short selling is not allowed.

v. A fund can not hold derivatives commitments for more than 10% of it's

assets against a single bank counterparty.

vi. A fund cannot hold derivatives commitments for more that 5% of it's

assets against a single not-bank counterparty.

. Short functionality separates the short position transactions like short

domestic equity, short foreign equity, short fixed income, and short

foreign fixed income interest being accrued(Interest income, realized

gain/loss, realized forex gain/loss and dividend coupon) on a short

position from the same as the interest accrued on a long position.

. XML Interface for Aktiengwinn groups is made up of set of rules called

templates defined in the XSL and provided extensible facilities for

defining data types of elements and attributes using XSD. The data is

inserted into the tables with the information provided in the given XML

file.

And also involved in many enhancements and bug fixings.

. Role: Involved in Performance tuning, Development, Bug fixing and

Enhancement of reports, forms and backend programming.

. Environment: Oracle 9i/10g and Developer 2000, Unix, Windows XP.

Project - 3

. Organization : Spheresoft Solutions Pvt. Ltd. Title: Agilent

HRIT.Duration:Dec-2006 to Oct-2007.

Agilent HRIT is responsible to maintain all the HR and IT related

applications for the World wide client Agilent. Amongst those applications

two of the reporting applications are maintained by Reporting Stream. The

two applications are WEDB (Workforce Employee Database) and Bluebook

(Reporting application for Agilent).

WEDB: This is a workforce database which maintains all the HR and Finance

related data of all the Agilent and Non Agilent Employees'. Loading of

employee data is done through a blend of JCL and UNIX Shell scripts and SQL

/ PL SQL and through Informatica Jobs. It is a huge database which takes

data from different Vendors / Applications and provides data to different

Vendors / Applications.

Bluebook: This is a reporting application which is implemented using Data

Warehousing concepts. This is a proprietary product of Agilent Technologies

Ltd. The data is pulled in to this application through the DB which is

maintained for this application into which the data is loaded through a set

of UNIX Shell scripts and PL / SQL procedures. Role based security is

provided to this application which is used by all the top level employees

of Agilent.

Team Size : 11

Environment : Oracle 9i, SQL, SQL Navigator, Windows XP, UNIX

Role:

Worked as senior member of the Project, Organizing meeting with clients

and providing the issue status etc

Worked as team member on customizations of the projects

Developed new modules based on the client requirement from the scratch

Used PL/SQL in writing Functions, Procedures and Packages to maintain

referential integrity and to do complex updates and validations

Project - 4

. Organization : Gate Wave Technologies . Title: SMKHPTS (Sistem Mkulmat

Kutipan Hasil Prejabat Tanah Selongore) . Duration : September 2005 -

October 2006 . Size: 10

The SMKHPTS is an comprehensive product to automate the revenue system of

the Malaysian government for the collection of various taxes on the

property. Tax for a particular property depends on location, property type,

area etc. There will be annual bill generation per a property with the

amount of tax to be paid. This bill will be issued to the billing owner of

the property. There is Remainder generation for the customers who don't pay

the tax with in time with some penalty. Mostly these will be generated on

demand.

Project also deals with registering loans for the selected people and

collecting it in installments. The selection of people is according to the

reservation laws of Malaysian government. Collection of bills and Deposit

generation for registering loans also automated. This is an intranet

product, which is deployed for testing in Selongore state of Malaysia.

This project mainly has Land, Low Cast Housing, Deposit and Collection

modules. Land module involves registering the property and generating

annual bills. Low Cast Housing involves registering the loans for the

selected people and generating bills for the installments to be paid.

Deposit module involves deposit registrations and generating bills for the

deposit amount. Collection module involves collecting amount for the bills

generated by the above three modules.

. Role: Involved in Development of reports, Designing of forms and built

necessary backend packages for Land Module.

. Environment: Oracle 9i, Developer 2000 and Unix

Project - 5

. Organization : Gate Wave Technologies. . Title: Payroll Accountancy and

Processing System . Client : VSV Systems, New Delhi . Duration :

January 2005 - August 2005 . Size: 6

The PAPS is divided into two modules Payroll Module and Payroll Accountancy

Module.

Payroll Module can be functionally classified into various processes namely

employee monthly payroll processing, supplementary bills and advances &

loans. The Payroll processing includes in time proceedings for increments,

DA arrears, Leave encashment etc. Where as Supplementary bills include

delayed proceedings for increments, arrears, and leave encashment. Advances

& loans include various loans & advances given to employees except GPF

loan. All the Pay bills and Supplementary related vouchers are generated by

the system at the time of bill generations.

Payroll Accountancy Module includes booking of receivables/payables and

maintaining the corresponding receipts, Payment Voucher Preparation,

Challan Generation, Bank Scroll Process, Compilation of all vouchers and

challans, Ledger posting, Trail Balance, Balance Sheets Generation.

. Role: Involved in Development of Stored procedures, Functions, Packages

and Designing and development of the reports for the Payroll Module and

interacted with the customer for getting the details for the form, report

layout designing and module testing.

. Environment: Oracle 8i, Developer 2000 and Windows.

Project - 6

. Organization : Gate Wave Technologies.. Title: Recruitment System .

Client : VinuInfoway Consultancy Services . Duration : June 2004 - December

2004 . Size: 6.

Recruitment System is developed for the placement consultants who deal with

recruitment. The main activities involved are Consultant Workflow, Client

Workflow, job workflow, cash flow, budget workflow and company workflow.

The candidate can opt either for domestic or overseas placement. The

personnel details of the candidate including his marital status, passport

number along with his skill set, training, qualifications and experience

etc. are stored. The client will receive the consultant's information

through Email with qualifications, skills and experience details. The

Client will match the details like qualifications, experience according to

his requirement. Then the Client will call the Candidates for Interviews.

The Consultants will work with the clients after their selection process is

over. The financial details of the Company, Consultant, and Client are also

maintained.

.Role: Development of Cash Flow, Budget Flow, Reference, Customization

modules and Reports Generation.

. Environment: Oracle 8.0, Developer 2000 and Windows

Project - 7

. Organization: Gate Wave Technologies. . Title: B2B Ordering System .

Client : Alexon Foam . Duration : April 2003 - May 2004 . Size: 7

The Alexon Foam has Manufacturing, Distribution and Retail organizations.

My involvement has covered maintenance of large orders from corporations.

The customers request gift cards specifying the number and denomination and

"The Alexon Foam" Vendor ships the cards to the customer. The application

handles customer orders, activating the gift cards and shipping the gift

cards to customers. The application will support any denomination of gift

cards. It will allow multiple payment methods including check, credit

cards, Debit memo and wire.

. Role: Involved in Development of reports and Designing and Coding of

Order Search & Order Forms and utility programs

. Environment: Oracle 8.0, Developer 2000 and Windows

Personal Details

Father's Name : M.Rangappa

Marital Status : Married

Nationality : Indian.

Passport No : H2456455.

Address : H.no:292

G.P.R Layout, Opp. Bangalore Fruit Market.

Hoskur Road,

Near Hoskur Gate,

Bangalore. India.

Contact this candidate