Search for Members. Filter by Industry, Location, Tags, etc...
Connect with Sagar Joshi at Chamber.com, an invitation-only community connecting leaders worldwide.
General
About
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
• 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, Transact
• 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
• 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, Transact
Haves
data conversion, database administration, debugging, design, features, financial accounting, human resources,payroll processing, inventory management, procurement, mis, optimization, oracle dba, oracle developer 2000, PL/SQL, SQL,Foxpro,Visual foxpro, Ms Access, SQL Navigetor, PL/SQL Developer, TOAD, third party utilities, JAVA/J2EE, JSP, Spring, HTML, CSS, Apex
Professional Experience
May 2001 - Present
Sr. Programmer
JMC Projects India Ltd
Human Resources
JMC Projects India Ltd
Human Resources
Reporting to: GM, IT. Major duties responsibilities: Fully involved in application software s 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
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
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
Special Features: Contains modules of major activity of maintaining the Assets. Special query screen for Heavy machinrary,
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
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
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
Special Features: Contains modules of major activity of maintaining the Assets. Special query screen for Heavy machinrary,
May 2001 - Present
Sr. Executive
JMC Projects India Ltd
Human Resources
JMC Projects India Ltd
Human Resources
Major duties responsibilities: Fully involved in application software system lifecycle. DBA Performance tuning of Database, maintenance of security scheme for various application software.
Apr 1998 - Apr 2001
(3 years)
(3 years)
Programmer
Associated InfoTech Ltd
Civil Engineering
Associated InfoTech Ltd
Civil Engineering
Reporting to: Director
Duties Assignments: Developing and On-site Implementation and Maintaining Systems for clients.
Duties Assignments: Developing and On-site Implementation and Maintaining Systems for clients.
May 2001 - Sep 2009
(8 years, 4 Months)
(8 years, 4 Months)
Sr. Executive
JMC Projects India Ltd
Human Resources
JMC Projects India Ltd
Human Resources
Education
1996
Bachelor of Commerce; Diploma, TULEC (DoE) (High School)
Advanced Accounting; Computer Programming
Linux from STG Pvt. Ltd. Ahmedabad.
Java from Netvision Pvt. Ltd. Ahmedabad.
Advance JAVA from US
Advanced Accounting; Computer Programming
Linux from STG Pvt. Ltd. Ahmedabad.
Java from Netvision Pvt. Ltd. Ahmedabad.
Advance JAVA from US
1996
BCom, Gujarat University (High School)
Commerce
Commerce
More about Sagar Joshi
First Name
Sagar
Last Name
Joshi
Specialities
data conversion, database administration, debugging, design, features, financial accounting, human resources,payroll processing, inventory management, procurement, mis, optimization, oracle dba, oracle developer 2000, PL/SQL, SQL,Foxpro,Visual foxpro, Ms Access, SQL Navigetor, PL/SQL Developer, TOAD, third party utilities, JAVA/J2EE, JSP, Spring, HTML, CSS, Apex
Recently in Chicago
Recently in Chamber.com
Featured Webinar
Awesomely Simple Webinar by John Spence
Best-selling author John Spence reveals how focusing on 6 core strategies will yield powerful results and dramatically improve the success of your company.
Find Contacts
Sagar Joshi's Business Networks
Sagar Joshi's Contacts
