Developer Management

Ashish Pachpor

Mobile: (Oman) +968-******** Mobile: (India): +91-950*******

E-Mail: *******.******@*****.***

A bright, ambitious and self-motivated Oracle SQL PL/SQL Developer with a good technical background who possesses self-discipline and the ability to work with the minimum of supervision. Possessing a good team spirit, deadline orientated and having the ability to produce detailed technical specifications from client requirements. A quick learner who can absorb new ideas and can communicate clearly and effectively. Currently looking for an opportunity where position with a stable company with room for growth and opportunity for advancement.

PROFESSIONAL SNAPSHOT

A competent professional offering over 4+ years of experience in designing, coding and testing of applications and report creation using Oracle Forms & Reports 6i/10g/11g and Oracle Database(SQL/PLSQL) .

Presently associated with OMAN FOODSTUFF FACTORY L.L.C, Muscat, Oman as Oracle Application Developer.

Expertise in Oracle SQL, PL/SQL. Developed application in Oracle Forms &Reports. Strong experience in data manipulation using SQL and PL/SQL scripts for the retrieval of data from the relational database.

Responsible for trouble shooting back end UAT and production issues.

Working on well-known integrated business suit like ERP Product.

Worked on E-governance Project for Bihar and Maharashtra Government of INDIA.

Working experience of various phases of cycle (Finance, Purchase, Sale, Stores, Production, QC and Export, Logistics etc.)

Experience in client interactions from the requirement gathering phase to the implementation phase as well as regular support.

Understanding knowledge on customer support for ERP application implementations.

Dynamic career with good leadership qualities, problem solving, planning, team building and project management skills.

High level of Self-Motivation, Productive, Dedicated and capable of working independently as well as a team member.

Good in providing subsequent Training & Technical Support to end users.

ORGANISATIONAL EXPERIENCE

Tenure Company Name Designation

Since Aug’16 OMAN FOODSTUFF FACTORY, Oman Oracle Application Developer

Mat’15 – Jul’16 ABM Knowledge ware Ltd, Mumbai (IND) Developer

Apr’14 – Feb’15 Virtual Galaxy InfoTech Nagpur (IND) Implementation Executive

Aug’13 – Mar’14 Jass Services Nagpur (IND) Software Engineer

EDUCATION DETAILS

M.C.A (Master in Computer Application) from Nagpur University (India) with (65%)

B.C.A (Bachelor Computer Application) from Amravati University (India) with (58.91%)

IT SKILLS

Reporting Tools : Oracle Reports 6i/10g/11g

Tools : Oracle Developer suite Forms & Reports, PL SQL Developer

Database : Oracle 8i/10g/11g.

Operating Systems : Windows Family, Server 2003, Server 2008.

PROJECT DETAILS

ORGANISATION: OMAN FOODSTUFF FACTORY LLC (IT DIVISION)

Project Description

ERP Model

This is a customized ERP Software in house development which facilities for whole industry to enhance efficiency and cost cutting. It is an intelligent package, which integrates all departments of an organization and caters to its individual needs.

Company overview:

Oman Foodstuff Factory Involved the production of Chips, Tomato paste, Milk as brand name Al Mudhish. The company requirement all module is tightly integrated so that the whole operation can be put under one umbrella.

Client : Oman Foodstuff Factory, Muscat, Oman

Environment : Oracle Forms & Reports Oracle 8i/11g

Duration : Aug 2016 – Till date.

Role : Oracle Application Developer.

Team size : 3

Role & Responsibilities

Involved in full project life cycle like Designed, Developed, implemented, maintained and tested the application.

Ensure conformance to code standards and documentation requirements.

Developing Forms, Reports as per user requirements.

Actively participated in the development of Modules in Oracle Customize ERP.

Developed Dash Board and Reports for Management to review Company Activities.

Designing and defining Database Tables, Sequences, indexes, constraints.

Experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages,

Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL,

Exceptions.

Extensively writing of database queries.

Experience in developing External Tables.

Extensively used Dynamic SQL, Ref Cursors and Bulk Collect to populate the data into the respective staging tables.

Perform DBA Role like creating users, grant users, and create table spaces.

Loaded the data into database tables using SQL*loader from flat files.

Fix bugs in existing applications reported by clients or internal testers.

Tuned SQL statements and Procedures using Explain Plan.

ORGANISATION: ABM KNOWLEDGEWARE LTD, MUMBAI (India)

Company overview:

IT solution Provider Company engaged in rendering specialized in providing E-governance solution to

various locations in India.

Client : Bihar and Maharashtra Government India

Environment : Java, Oracle 11g.

Duration : Mar 2015 – Jul 2016.

Role : Developer

Team size : 10.

Project Description

Electronic governance or e-governance is the application of information and communication technology

(ICT) for delivering government services, exchange of information, communication transactions, integration

of various stand-alone systems and services between government-to-customer (G2C), Government-to-

Business (G2B), government-to-government (G2G) as well as back office processes and interactions within

the entire government framework. Through e-governance, government services will be

Made available to citizens in a convenient, efficient and transparent manner.

Role & Responsibilities

As SQL/PLSQL Developer responsibilities like Controlling PL/SQL flow of execution, Case expression, LOOPS, Composite data type, PL/SQL records, Indexing, Writing Implicit/Explicit Cursor, Handling Exception, Creating Procedure, Creating Function, Creating Package, PL/SQL Tables and record in packages, Debugging PL/SQL program unit, Manipulating large objects. Creating Database Triggers, Managing Triggers and advance development in PLSQL etc.

Involved in writing database packages/procedures/functions & implementing conversion of the water billing system.

Conversion From one database structure to a new one with different functionality and database layout like MS SQL.

Performed changes and enhancement in design of application

Attending the review meeting to understand the business requirement gathering & designing.

Code development, Debugging, Unit testing & Bug fixing.

Data Modeling.

Report creations as per user requirements.

Prepared the necessary documentation.

Prepared documents for CMMI Audit.

ORGANISATION: Virtual Galaxy InfoTech Nagpur (MH) India

Company overview:-

IT solution provider company engaged in rendering specialized ERP software solution for sugar, solvex, textile, fertilizer and steel industry, core banking software solution, ATM switch, Net Banking, NFS connectivity services, head office automation, application development & integration and web development services.

Client : Goyal Proteins Ltd. Kota(Rajasthan) India

Environment : Oracle Forms & Reports 10g, Oracle Database 11g.

Duration : Apr 2014 – Mar 2015.

Role : Implementation Executive

Team size : 4

Project Description

Goyal Proteins Ltd is a solvent plant involved the production of Soya nuggets, Soya Granules, Soya flour,

Soya Doc, Soya Crude Oil etc. The Company’s requirement was to integrate the activities into various

departments functioning in their company.

Roles & Responsibilities

I worked on ERP -Software and contributed in the following areas:

Finance

Production Management

Sales Management

Seed Purchase

Purchase Management (Other)

Weighbridge Management

Human Resource

Export

Quality Control

Created Master, Master Detail and Query Forms for above modules.

Creating Reports for above modules.

Creating Query form for MIS Management.

User creation, Granting Roles, Export, Import. Writing Procedures functions, Triggers, Cursors.

Attending the review meeting to understand the business requirement gathering & designing.

Code development, Debugging, Unit testing & Bug fixing.

Report creations as per user requirements.

Prepared the necessary documentation.

ORGANISATION: Jass Services Nagpur (MH) India

Company overview:-

It was startup IT solution Provider Company engaged in rendering specialized ERP software solution for sugar, solvex, textile, fertilizer and steel industry.

Client : Ambika Solvex Akola (M.H) India

Environment : Oracle Forms & Reports 10g, Oracle Database 11g.

Duration : Oct 2013 – Mar 2014.

Role : Software Engineer

Team size : 2

Project Description

Ambika Solvex Ltd is a solvex company. It involved production of Mustard Oil, Soybean Oil, and byproduct

like Lecithin; DOC (Soya and Hi Pro Both).The Company’s requirement was to integrate the activities of the

various departments functioning in their company.

Production Management.

Sales Management.

Purchase Management.

Human Resource.

Roles & Responsibilities

I worked in the Purchase, Sale, Weighbridge and MIS Module for the above-mentioned ERP -Software and contributed in the following areas:

Creating Reports for above modules.

Creating Master detail Forms.

Creating Views, Function, Procedures.

User creation, Granting Roles, Export, Import.

PERSONAL DOSSIER

Date of Birth : 28th October 1987.

Address: (Permanent) : 28,Kolhe Lay out, Landmark Gajanan Mandir,

Yavatmal (MH), India. Pin code: 445001.

Address: (Temporary) : Al hail, Muscat Sultanate of Oman.

Languages Known : English, Marathi, and Hindi.

Passport No : L2577365.

Passport Valid Up to : 2023.

Marital Status : Single

Currently Residing Country : Oman.

Skype ID : ashish.pachpor

Contact this candidate