Experience

NITS Solutions

• United States
• IT Services and IT Consulting
• 100 - 200 Employee

• Sr Oracle Developer

  • Dec 2011 - Present

  December 2011- Till Date Oracle Apex Reports Design and Development Created stored procedures to enable data extraction from existing database into the Data warehousing database. Modified (Data transformation) the extracted data into acceptable form to be inserted into the data warehouse database. Joined/Aggregated several tables to bring data from all those tables into one destination table. Documentation done for the destination database in terms of the tables, table structure and data types. Created explain plan and tuned SQL and PL/SQL scripts to improve performance. Implemented business rules into stored procedures to bring about smooth extraction and loading of data. To implement dedicated Oracle database servers. Provided daily Technical guidance in maintaining, troubleshooting and supporting of existing system. Delegate feature requests and bug fixing to developers for maintenance purpose. Continually provided support for new model development. Currently I am working on three different analytical projects which require ETL, Stored Procedures, Transaction Forms and Reports Developments. Environments/Expertise: SQL, PLSQL, Oracle 11g, Reports, Apex Windows, Unix



Nirma Limited

• India
• Chemical Manufacturing
• 700 & Above Employee

• Consultant

  • Nov 2010 - May 2011

  Provided daily Technical guidance in maintaining, troubleshooting and supporting of existing system. Delegate feature requests and bug fixing to developers for maintenance purpose.Continually provided support for new model development.

• Module Leader / Developer

  • Jun 2006 - Nov 2010

  Maintained a Sales module of ERP system which includes adding new features to module and performance tuning of the module.Developed Sales module related master entry, sales inquiry, sales order, sales invoice forms and packages.Prepared module test cases and performed testing. Developed forms & reports as per systems new requirement.Provided training to the end user of the module. Wrote training document for sales module which resulted in reduction of average support call.Wrote Data migration scripts for data migration legacy system to ERP systems using PL/SQL code, External Table ,SQL Loder, UTl_FILE etc.

• Oracle Developer

  • Jan 2004 - Jun 2006

  As Employee)Developed general master form and Packages which is required for transaction and development in ERP system. Wrote PL/SQL, procedures, function, triggers .Wrote reusable object library and packages. Developed Transaction forms, Reports, and other associated elements.

• Programmer

  • Oct 1994 - Jan 2004

  As Employee) Developed various system using Frontend FoxPro , Clipper , PowerBuilder and backend FoxPro, FoxBASE, Oracle 8. Involved in the development of Supermarket sales, inventory, accounting system and Implementation. Conducted code and specification reviews. Involved in user Training.