Title:Software Engineer

abpmui@r.postjobfree.com

Document

Source below

NAME: konduri, srinivas

ADDRESS: ****,***** **** ******,#***

ADDRESS2:

CITY: Scottsdale

STATE: AZ

ZIP: 85258

CANDIDATE ID: 2257644

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: Yes -

JOB WANTED: Any

RATE NEEDED

: Open

TELEPHONE: 480-***-****

EMAIL: abpmui@r.postjobfree.com

HOMEPAGE:

YOE: 5

Objective:

To be involved in complete software development life cycle including design, development,

and testing of relational database systems using the leading edge fourth generation tools

such as Oracle Developer 2000 and customization of Oracle Financials.

Professional Experience:

Six years of experience in design and development of relational database systems using

Oracle, Developer 2000, Oracle 8i, Developer 6i, Seagate Crystal Reports8/8.5.

Computer Proficiency:

Languages : SQL,DB2, FORTRAN, BASIC, PL/SQL 2.0,JAVA, and C.

Software : Developer 2000, Seagate Crystal Reports 7/8/8.5,Seagate

Info7, Developer 6i,Designer 2000

RDBMS : Oracle 7x/8/8i, DB2

ERP : Oracle Finanacials Modules : Oracle General Ledger

Payables, Recievables, Application Object Library and

Order Entry.

Oper Systems : DOS, UNIX, Windows NT, Novell Netware 3.12,

Windows 3.11/95.

Professional Experience:

Client:

City of Chandler, Chandler, AZ Feb 2001 - PresentConsultant/ Software Developer

Designed and Developed Forms and Reports using Developer 6i for the Sales Tax Application

and the Back End being Oracle 8i.Converted some Reports of older versions to Oracle

Reports6i. Performance tuned them to get maximum optimal performance. Some of the examples

of reports are sales tax, Accounts Receivables Summary Reports, License Report etc.

Environment and Tools Used: Oracle 8i, Reports 6i, Forms 6i (Developer 6i) Windows NT

Client:

JDA Software Group, Inc

., Scottsdale, AZ June 2000Feb 2001Consultant / Software Developer

Creation of robust back-end queries, stored procedures, and packages to generate

appropriate data for financial and reporting applications in conjunction with the

implementation of Computrons TEAM and DI modules. Did bulk of development and in creating

code to be consistent in style and standards. Designed and developed Reports using Seagate

Crystal Reports 8.5 and were deployed on web using ASP. The front end screens were

developed using VB6 for inputting user parameters. Performance tuned all the applications

to ensure minimal processing times. Examples of reports are client/engagement, sales tax,

employee time reports etc.

Environment and Tools Used: Oracle 8.0.5, SQL*Plus, SQL Navigator, Crystal

Reports 8.5,ActiveServerPages,Visual Basic6, Rapid

SQL, UNIX

Programmer/Developer

Client: PCS Heath Systems, Scottsdale, AZ Sep99 to May00CEMA Application

Designed and developed Reports using Seagate Crystal Reports7 for CEMA(Client

Event Management Application).The application tracks and records all requests relating

To the member at Pharmacy,Client and Physician Levels.Later on all the Reports were

converted using Seagate Crystal Reports 8.5.All the Reports were Scheduled to run

automatically at desired intervals on Daily, Weekly and Monthly Basis.

Responsibilities:

Write code programs, system design, detailed technical reports.

Prepare technical documentation.

Involved in detailed functional and technical specs.

Develop test data to test the module.

Changes made to the code in accordance to the users requirement.

Environment: DB2, Windows NT, Seagate Crystal Reports7/8.5,Seagate Info7

Programmer/Developer

Client: NDC Health Information Services, Phoenix Apr 99 - Aug99

Schering BIC Data Warehouse

The vision of the BIC Data Warehouse is to provide state-of-the-art

decision capabilities which will be used by the Business Information

Center(BIC) to identify opportunities for business growth within

Scherings Sales and Marketing Organization and to provide an

Integrated data base for standard, cyclical reports based on the wholesale

And retail sales of ethical products possibly in combination with sales

Representative call reporting.

Responsibilities:

Write code programs, system design, detailed technical reports.

Prepare technical documentation.

Involved in detailed functional and technical specs.

Develop test data to test the module.

Changes made to the code in accordance to the users requirement.

Environment: Oracle 8.0.5, SQL*Plus, UNIX, Developer 2000(Forms4.5 and

Reports2.5

)

Programmer/Analyst

Client: Dial Corporation, Scottsdale, U.S.A Sep98March 99

Data Warehousing

This is mainly the interface between ODS(Operational Data Store) Data layer and ODS

presentation layer .Data from the ODS data layer will be used to create a view in the ODS

presentation layer which will be accessible for mapping it in the schemas like Sales

Analyser, Commertial Markets, TPMS and CSMS. Most of the data will reflect all Inserts,

Updates and Deletes made throughout the processing day.

Responsibilities:

Write code programs, system design, detailed technical reports.

Involved in detailed functional and technical specs.

Develop test data to test the module.

Changes made to the code in accordance to the users requirement.

Environment: Oracle CPG, SQL*Plus, UNIX, Developer 2000

Programmer/Analyst

Client: Computer Resolutions, C.A,U.S.A

March 98- August 98

Write code programs, system design, detailed technical reports.

Prepare technical documentation.

Involved in detailed functional and technical specs.

Develop test data to test the module.

Changes made to the code in accordance to the users requirement.

Responsibilities and customization:

Involved in design,development of AP,AR and GL modules. Developed various feeder

programs to feed data from legacy systems into interface tables for General Ledger and

Recievable modules. Various kinds of reports were designed and integrated with AOL to suit

user needs.

Enhancements:

Interface table was developed to import the price list from the Legacy systems into

Oracle Order Entry System and a concurrent program was developed to extract data from

interface table into so_price_list and so_price_list_details. Forms were developed for the

agent at customer site to confirm & issue, after the material was shipped from the

suppliers place.

Pro*c programs:

Send mail to customer in Auto Receipts:

This program logs on to oracle, selects the customer name, bank account, receipt number

date, amount applied, balance remaining from database tables for the receipts applied and

send a mail to each customer.

Program to calculate Tax:

This program receives ship_to_address, item_code,quantity and price from the invoice

screen,calculates the tax & displays the tax on the screen.

Program for customer credit check:

This program conducts a credit check for the customer based on the distribution channel,credit limits fixed for each channel and the profile class attached to the customer.

Programmer/Analyst

Monsun Technological Services, India.

Order Entry System April 96

- Jan 98

Responsibilities:

Write code programs, system design, detailed technical reports.

Prepare technical documentation.

Involved in detailed functional and technical specs.

Develop test data to test the module.

Changes made to the code in accordance to the users requirement.

Project:

A case study on implementation of Oracle Financials for a established Pharamaceautical

company. The case study includes the design and development of Set of Books for the

accounting transaction for the company .The complete process

of registration of the application,tables, forms with AOL, attach the forms to menus,

reports to report groups, creating the data group for the application, assigning them

to a responsibility and attaching the responsibility to a user.

Customization:

Developing the budget interface programs to upload the budget information from non-

oracle financials modules to the budget interface tables using SQL*Loader and Pro*C.

Fields in different forms of various modules were modified to suit the user needs.

Various kinds of reports were generated to match the business needs.

Additional information was provided to the user by customizing the descriptive

flexfields.

Also involved in generating Procedures and work instructions for ISO-9002 and produced

a unit manuals for the implementation of standard operating practices and imparted unit

training.

Spares Budgeting System

Jan 96 - Mar 96

Responsibilities:

Involved in detailed functional and technical specs.

Write code programs, system design and complex reports.

Prepare technical documentation.

Develop test data to test the module.

Project:

Developed a spare parts and sales monitoring system for an automobile company. The

front-end GUI interface was developed using Oracle*Forms 4.5 and the backend was Oracle

7.1.6. The application keeps track of weekly, monthly and yearly sales of the parts and

also maintain information about the spare parts available in the workshop. Also created a

complex reports using Oracle *Reports 2.5

Environment: Oracle 7.1.6, SQL*Plus, Developer 2000

Material Master Maintenance System

Jul 95

- Dec 95

Responsibilities:

Write code programs, system design, detailed technical reports for internal customers

and external customers.

Develop test data to test the module.

Project:

Designed and implemented a Material Master Maintenance System for an automobile

industry for a wide range of user level interface. The system keeps track of parts

required for assembly and maintenance. Developed interface screens using Oracle*Forms

4.5/4.0. This application keeps track of the Inventory, purchases and sales information.

The system generates the reports of company sales and maintenance for a schedule time

periods.

Environment : Oracle 7.1.6, Oracle*Forms 4.5/4.0, Oracle*Reports 2.5, UNIX

Executive Information System

Sep 94 - Jun 95

Responsibilities:

Involved in detailed functional and technical specs.

Write code programs, system design, detailed technical reports..

Prepare technical documentation.

Develop test data to test the module.

Project:

Designed, developed, tested and implemented the Executive Information Systems for the

Top Management group of a major Automobile Industry. The system extracts and manipulates

from several tables such as production, material, finance, personnel, spare parts and

service information. In addition the system maintains the profiles of executives and

managers divisional targets and work performance data using Oracle 7.0.

Environment : Oracle 7.0, SQL*Forms 3.0, SQL*Report Writter 1.1, UNIX

Education:

B.S

in Engineering, Osmania University, India.

Training:

Oracle Order Entry,Payables,Recievables, General Ledger, Application Object Library

modules from Authorized Oracle Center.

Awards

National Merit Award for Pre-University performance.

References

Will be furnished upon request

Contact this candidate