Developer System

Sagar Joshi

****, *. ******** ****, ***#****, Chicago, IL 60640

Cell No.: 773-***-****

Email id: ***********@**********.***

Visa Status : Green Card

Objective:

A Challenging and innovative job in Software Engineering and E-commerce

that provides an

opportunity to work on the state of the art technology with lots of room

for professional

environment.

Summary

. More than 8 years of experience in Information Technology with

extensive knowledge and work experience in design and development of

applications using Oracle Forms - Developer 2000 (D2K)

. Extensive background working in finance, payroll, Asset tracking and

IT industries

. Experienced in identifying Business requirements, Technical

requirements, Database Design, Troubleshooting and writing interfaces

between various applications

. Experienced in code migration, database change management and data

management through the various stages of the development life cycle

. More than five years of extensive experience in Oracle technologies

. Good team player, highly committed, hard working, enthusiastic and a

self learner

Oracle Expertise:

. Worked on different versions Oracle 7.x, 8.0, 8i, 9i and 10g

. SQL - SQL*Plus

. Schema Objects - Data Integrity, Creating and Maintaining Tables,

Indexes, Sequences, Views, Synonyms

. PL/SQL -Triggers, Stored Procedures and Functions, Cursors,

Transactions, Packages

. Experienced in Performance Tuning & Optimization of SQL statements

Oracle Developer Expertise:

. Worked on different versions Developer 4.5, 5.0 and 6i

. Designed and developed various form like Master Form and Master Detail

Form

. Developed and modified Menu, Query, Graphics and Procedure

. Extensive experience in Break Report, Master Detail Report and Matrix

Report

Expertise in Oracle Utilities & Other Tools:

. Experienced in using Oracle SQL*LOADER and IMP/EXP DATADUMP utilities

. Experienced and good knowledge in third party tools like PL/SQL

Developer and TOAD

PROFESSIONAL EXPERIENCE:

JMC Projects India Ltd.

May-2001 to Sep-2009

Engineers Constructors Firm.

Designation: Sr. Programmer.

Reporting to: GM, IT.

Major duties responsibilities: Fully involved in application software

system lifecycle. DBA

Performance tuning of Database, maintenance of security scheme for various

application software.

1> Financial Accounting System. (FAS)

Involvement: As member of team.

Role: Defining logic for various triggers, functions modules, coding of

database functions,

development of various reports, online query modules balance-sheet queries,

developing

implementation of security system and open gateway system, Data conversion,

parallel

implementation, enhancement maintenance, vital master creation user role

creation.

Software Tools : Oracle 10g D2K forms 6 report 6, PL/SQL Developer.

Special Features : Multi-Division, Multi-Location, Auto-Contra Facility,

Auto-Reversal of entry,

Bank Reconciliation auto manual, Open gateway for Voucher Generation,

three-tire user security as well as GL account locking, grouping for MIS

2> HR Payroll System.

Involvement : As member of team

Role : Table designing, mapping, linking auto loading with FAS, development

of flexible payment

scheme, Implementation of user level employee level security, Data mapping

conversion,

implementation, training.

Software Tools : Oracle 10g Developer 2000 forms 6 report 6, PL/SQL

Developer.

Special Features : Flexible Payment Scheme, tight linking of salary

components with FAS, Loading of Monthly salary into FAS, Special query

screen for direct use of employee, multi-level multi-tire security system,

Open query module for online MIS query generation with standard output

format.

3> Asset Tracking System.

Involvement: As member of team

Role: Table designing, development of Asset tracking, Implementation of

user level employee level security, Data mapping conversion,

implementation, and training.

Software Tools: Oracle 10g D2K forms 6 report 6, PL/SQL Developer.

Special Features: Contains modules of major activity of maintaining the

Assets. Special query

screen for Heavy machinrary,

4> Purchase System.

Role: Enhancement debugging in various modules and report as and when

required.

Software Tools: Oracle 10g D2k forms 6 report 6, PL/SQL Developer.

Special Features: Contains modules of major activity of Purchase, Vendor

evaluation, Open PO, MR passing for auxiliary suppliers, linking with FAS

Associated InfoTech Ltd., Ahmedabad.

Apr. 1998 to Apr. 2001

Designation: Programmer.

Reporting to: Director

Duties Assignments:

Developing and On-site Implementation and Maintaining Systems for clients.

From Jan. 1997 to Mar. 1998

Designation: Faculty. As a Faculty member, Conducting Lecture Guiding

academic projects.

Client Project-Work:

1. Gujarat Composite Ltd. Digvijay Cement

System: Sales A c. System.

Software Tools: ORACLE 7.3, Developer 2000 Forms 4.5, Reports 2.5.

Role: Developing Enhancement - Maintaining.

Special Features: Export Invoice, Security Deposit, Branch System, Export

invoice printing, letter for security deposit, letter for outstanding,

branch stock sheet, damage recovered stock sheet.

2. Symphony Comfort System Ltd.

System: Sales System Sp. for schemes.

Software Tools: FoxPro 2.6.

Role: Developing Enhancement - Maintaining.

Special Features: As the Company has various scheme, so generalized sales

system for various

schemes were made, getting the detail of customer, dealer, salesman orders

etc. Inventory, Excise reports, and data transferring module were included.

3. GCPTCL, Bharuch.

System: Oracle Finance 9i.

Involvement: Team member 1

Software Tools: Developer 2000 Reports 2.5.

Special Features: Reports like Purchase Order, Taxation, Vendor

Information, etc. were made

according to the Client Specifications.

4. Divine Fuels Services, Ahmedabad.

System: Transport System

Software Tools: FoxPro 2.6.

Role: Maintaining.

Special Features: Maintenance of the Existing Transport System. According

to the Client

Specifications.

5. GMIDC, Ahmedabad.

System: PF System

Software Tools: FoxPro 2.6.

Role: Maintenance of the Existing PF System. Changes were made as Client

Specifications.

Qualification:

. Bachelor of Commerce majored in: Advanced Accounting and Auditing,

India

. Diploma in Computer Programming & Application, India

Contact this candidate