Erp Solutions And Services

4C plus

ERP SOLUTIONS AND SERVICES

Ashish Kumar Yadav Professional Experience/ Skills I have 2 years of IT experience in designing and development of various clientserver applications using Oracle RDBMS, PL/SQL, SQL, and Developer 2K, 6i, 9i, 10g and have the experience to give the Technical and Customer support.

Technical Experience Summary • • • • • •

Technical and Customer Support Extensive experience in handling backend database activities on SQL, which includes writing stored procedures, Packages, triggers, view creation. Optimization of SQL queries. Oracle Utilities : Backup, Export and SQL*Loader Forms & Reports designing, coding and testing. Interpersonal Skills, especially working in large groups.

Development Tools and Languages Windows NT, 98, Xp, 2000, DOS-6.22 Oracle - 8i, 9i, 10g Developer Ver.6I, 9i, 10g PL/SQL, SQL, C, C++, java MS-Office

Operating System RDBMS GUI Languages Package

Education & Qualifications 1. MCA (Master of Computer Application) V.B.S.Purvanchal University Jaunpur(UP).(2007) 2. Graduation In Science (Physics,Math,Chemisty) V.B.S.Purvanchal University Jaunpur(UP).(2004) 3. Intermediate (10+2) from U.P Board(1998). 4. High school (10th) from U P Board(1995)

Employment History Technical & Customer Support

Projects • ERP Solutions Job Profile for the above project • • • • • •

Ashish Kumar Yadav

Interaction with the customer and on-site team. Technical support to the on-site team. Sharing the knowledge with offshore and on-site team members. Preparation of the Design document, Technical specification, Program specification and Impact Analysis of the new requirements. Discussion with the off-shore team regarding the new requirements Preparation of the Unit Test Cases and system test cases of the new

Page 1 of 5

4C plus

ERP SOLUTIONS AND SERVICES • •

requirements. Validating the technical specification and managing the development of the new requirements. Involvement in the user Acceptance

Technical Competency • • • • •

System Analysis And Designing

RDBMS : Oracle 9I GUI : Developer 6I Languages : PL/SQL, SQL Oracle Utilities : Backup, Export and SQL* Loader MS-Office

Projects • MRP System (Manufacturing Resource Planning) System Analysis • • • • • • • • • • •

Gathering of Requirement from managers and end users of concern departments. Preparation of the Final Requirements and putting these in front of the manager's team to take the final approval of the requirements of all the departments. Discussion on the availability of the data to enter-related departments from each other. Defining the business architecture. Translating the collected business requirements into the functional specification and data /information flow diagram to show the integrity between departments. Presentation of the Business architecture and Data/Information Flow Diagram. Validation of the Business Architecture and Function Specifications. Final approval of the Business architecture and Functional specification to go ahead for Technical specification. Discussions with each department’s head for the Output Reports format. Maintaining the required documents. Providing the final Business Architecture, Function Specification, Data/Information Flow Diagram and Output Report Format to the technical team.

System Design • • • • • • • • • •

Ashish Kumar Yadav

Discussion with the technical team to translate the business requirements into the technical specification. Preparation of the Technical Specification. Designing of the Database. Designing of the Backend things like Tables, Views, Indexes, Procedures, Functions, Packages, Triggers. Designing of the processes for the integration. Designing of the front-end things like Input Forms and Output Reports. Preparation of the Program specification for each Back-End and front-end things. Preparation of the Impact Analysis document of each entity. Preparation of the Unit Test Cases and System Integration Test Cases. Maintaining other required documents.

Page 2 of 5

4C plus

ERP SOLUTIONS AND SERVICES

Development • • • • •

Division and allocation of work in the development team and my self. Help to other team members to trouble shoot their problems. Sharing the knowledge between the team members. Taking care of the Unit tests of each forms and reports. System Integration testing of the modules.

Training User Acceptance and Implementation (Project Delivery) •

• • • •

Checking of the developed modules by the End Users. If they requested any change in the module, it was changed and again tested by them. Consequently, other documents are updated and change request was maintained. Software Training was provided to the end users and also managers. And taking the satisfaction of them. Acceptance of the modules by the end users. Acceptance of the modules by the department head. Successful implementation of the system.

Extensive exposure • • • • •

Developer & Tester

To develop the Leadership quality. In system analysis and designing. To make the customer interaction, relationship and meeting with managers and take decisions. Confidence development To develop Communication and presentation skill

Projects • ERP Solution for Sugar Industries And Production Planning System For following modules Job Profile • • •

Coding on the basis of program specification. Testing of the modules on the basis of the Unit Test cases Implementation of the module on the site and taking the acceptance of the end users.

CURRENT MODULE: GATE CONTROL MANAGEMENT. Duration: May-2009 to till date 22-Jul. Client :M.P.Sugar Industries Majhaulia West Champaran(Bihar) Team Size :2 Software: Oracle 10g, Developer-2000 (Form 6i, Reports 6i). Project Abstract: Gate Control Management is to monitoring all the inwards and outwards through gate from vehicles to human to ease the security process. Also to avoid all types of illegal operations performed for any miss happenings in the factory and restrict all of them outside from the gate. My Responsibility: Database Design & Creation, Coding, testing & implementation, Monitoring Data Flow, Integration of different Modules.

2. STORES MATERIAL MANAGEMENT MODULE.

Ashish Kumar Yadav

Page 3 of 5

4C plus

ERP SOLUTIONS AND SERVICES

Duration: Feb-2008 to July2008. Client :Bajaj Hindustan Ltd. (Sugar division) Team Size :4 Software: Oracle 10g, Developer-2000 (Form 10g, Reports 10g). Project Abstract: Material Management involves the purchasing of materials through raising the inquiries to related Vendors on the basis of requisition by different cost centers, vendor analysis, purchase order dispatch, material Receipts & issues, stock maintenance, Stock valuation. My Responsibility: Database Design & Creation, Coding, testing & implementation, Monitoring Data Flow, Integration of different Modules.

3. CANE MODULE Implementation for mare than 5 sugar factories. Duration :Sep,2007-Feb,2008 Client: J.K. group, Bajaj Group, Uttam-engineering, Chadha group Etc. Team Size : 4 Software: Oracle 10g, Developer-2000 (Form 6i, Reports 6i). Project Abstract: In different locations sugar industry has their own working culture. So to cover-up all the activities, I have to customize my package in all respect as Per their requirement for better outcome. My Responsibility: I was responsible for implementation and testing of this Package in all sugar factories.

4. PLANT AND MACHINERY MAINTENANCE MODULE Duration :Jan’2007’ to Mar,’ 2007’ Client: R.B.N.S.Sugar Mills Laxer Haridwar(Uttra Khanda). Team Size : 3 Software: Oracle 9i,Developer-2000 (Form 6i,Reports 6i). Project Abstract: The Plant Maintenance is integral part of a manufacturing plant. To reduce their losses, breakdowns, also apart from keeping a regular Day to day Recording of every parameter, of Equipment, Machinaries, and other items in the plant, breakdowns, stoppages, reasons, consumption of raw materials, the management logs of the manpower and supervision, to the alarming values of the equipment, their requirements during manufacturing, we plan-out all this and scheduling of machinery equipments. So that Every activity on that for calculating their expenses. Special features: User Interface. My Responsibility: Design, Development, integration with the current existing Materials, Lab System.

5. CANE MODULE Development & Implementation. Duration :Mar'2007’ to Sep,’ 2007’ Client: R.B.N.S.Sugar Mills Laxer Haridwar(Uttra Khanda). Team Size : 4 Software: Oracle 9i,Developer-2000 (Form 6i,Reports 6i). Project Abstract: Sugar Industry Is Very Big and Process Dependent Industry. In Sugar Industry We have to optimize, their resources for maximize output. So The keyword 'Timing' Is very important for sugar industry and we trying to take care of all this through this Cane module. So

Ashish Kumar Yadav

Page 4 of 5

4C plus

ERP SOLUTIONS AND SERVICES

that cane supply and their extraction will be smooth and within maturity period. So we maintain all the activities right from cane sowing To grower's payment. For this we maintain data of grower's field survey, supplying quota, their supplying schedule, cane weighment and their payment indivisual. Special features: Data String capturing from one device through serial port, Manipulate in our required format and fetched onto third device. My Responsibility: Design, Development reports, Better User Interface, Customize As per Their requirement. [email protected]

Email:

: aashish.sky @hotmaill.com Contact Address:

A1/95, New Ashok Nagar, New Delhi. Phno. 9973930327

Present Job Profile: Organization: 4C PLUS Internet company,Muyur Bihar New Delhi Designation: Programmer, Software Engineer PERSONAL INFORMATION: Father's Name: Mr. Surendra Pratap Singh Yadav Date of Birth: 5th oct 1979. Marital Status: Married I hereby declare that particulars furnished above are true and correct to the best of my knowledge

Place: New Delhi.

Ashish Kumar Yadav

(Ashish Kumar Yadav)

Page 5 of 5