Software Developer Sales

Kaushlendra Kumar Tewari

Mob : +91-890*******

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

Seeking to participate the skilled working team of a Leading & Innovative Organization. Learn continuously to enhance my knowledge by serving the Organization & also to produce best of results.

PROFESSIONAL SYNOPSIS

·Dynamic professional with 6 years and 0 months of rich experience in Oracle Forms & Reports, PLSQL, SQL, Oracle Database, Oracle Apps R12/Application Development /Enhancement/Support.

·Strong experience in developing and enhancing RICE components

·Development of Complex PL/SQL Packages, procedures, functions, triggers and Indexes.

·Strong experience in Oracle Projects module – Worked on Costing, Staffing, Billing, Revenue, Interfaces, Web-ADIs, UDA

·Experience of development, migration, enhancement projects.

·Proficient in developing and enhancing Oracle Apps Technical components – Concurrent programs, DFFs, Value Sets, Request Sets etc.

·Proficient in developing oracle XML Publisher reports

·Quick in bug-fixing and problem solving.

·Quick learner, can adapt and work on new technologies in short span of time.

·Experience in various utility tools like Toad, SQL*Loader, SQL Developer, Putty, WINSCP, PL/SQL Developer.

·Knowledge of Core Java concepts, Unix and python.

CAREER PROFILE

Presently working as Software Developer with AWC Software Pvt. Limited from 28 Apr,2018 to till date. I am working at Sapient Consulting Pvt. Ltd., Gurgaon client site of AWC Software.

I worked as Software Developer with J.K Technosoft Ltd. from 20 DEC,2016 to 28-APR-2018. I worked on client site at Maruti Suzuki India Ltd client site of J.K Technosoft.

I worked as Software Developer with M.M Infosystems Pvt. Ltd., from July,2016 to 19 Dec, 2016.M.M Infosystems providing ERP solutions to their various clients of the company.

I worked with Wave Industries Pvt Ltd. as an Assistant S/W Engineer from 10 Jan,2015 to 26 July 2016. Wave Industries Pvt Ltd (WIPL)is one of the leading providers of Sugar, Steel, Real-estate, Malls.

PROFESSIONAL QUALIFICATION

·B.Tech From ANAND ENGINEERING COLLEGE,AGRA affiliated by UPTU, Lucknow in 2013 with 72%

·2 months training in Java from Ducat Institute, sec 16,Noida

TECHNICAL SKILLS

·Languages : SQL, PL/SQL, Core Java (Basics), OOPS concept

·Databases : Oracle 10g/11g/12c

·Front End Tool : Oracle Forms and Reports 10g/11g/12c

·ERP Tools : Oracle Applications R12

·ERP Modules : Projects Accounting (PA), AP, AR, GL, XLA

·Operating System : UNIX, Windows XP/2003/2008/2010

·Development Tool : SQL Developer, Toad, PL/SQL Developer, SQL Loader

·Version Control : Lion Box

·Others : UNIX Shell Scripting, Cron Jobs, SQL Performance Tuning, XML Publisher Reports

PROJECT UNDERGONE

Title

E-GST IMPLEMENTATION (E-INVOICING)

Client

Sapient Consulting Pvt. Ltd., Gurgaon

Duration

Apr-20 – Oct-20

Description

Build integration using API to automatically upload invoice to portal and capture IRN and e-invoice details in ERP using response. JSON format is used for request and response.

Assignments

Technical Design, Tables Structures, Development, New Transaction Sources, New PA lookups, New XML reports, Changes in client Invoice report (QR code implementation)

Preparation of Unit Test Cases and Perform Unit Testing

Preparation of BR100 Document

Title

DUBAI OU CREATION(PUBLICIS SAPIENT FZ-LLC)

Client

Sapient Consulting Pvt. Ltd., Gurgaon

Duration

Dec,2019 – Apr,2020

Description

New OU enabled for Dubai

Assignments

PA related setups,Gathering requirement from business (Costing related) Overhead entry, Responsibility creation,Profile option attached at responsibility level and OU level,Project classification entry,Office creation, Metro creation,Project Type Creation, Project Template creation, Auto accounting lookups entry, office flowing to downstream applications, Organization authority entry,Value set entry through API, create Internal customer and its sites for same geo as well as other geo’s,Implementation Options, Define rate schedule forecast,Set forecasting option for external template, Scheduling of Jobs

Preparation of Unit Test Cases and Perform Unit Testing

Preparation of BR100 Document

C2C Contract (Support)

Client

Sapient Consulting Pvt. Ltd., Gurgaon

Duration

May, 2018 –Till date

Assignments

Providing support to Project Costing module single handedly

Development of XML Publisher report

ICER Reports Monitoring-Process to get stuck business transactions in error

Changes done in Sapient based costing package

Changes done in Auto accounting package for 5th segment(future2) for labor costing

Creation of Expenditure Types

Creation of Concurrent Programs, Value Sets, Executables, Menus etc. AOL Objects

Preparation of Unit Test Cases and Perform Unit Testing

Preparation of Business Design Documents as per business needs

Preparation of Technical Design Documents as per requirements

Creation of database objects like PL SQL packages, functions, procedures

Involved in performance tuning of several reports

Creation of SQL Scripts for automation handy solutions of several manual tasks

Worked on TCA Architecture

Worked on several Oracle’s seeded API’s and Open Interfaces in PA

Title

Dealer Management System(DMS)

Client

Maruti Suzuki India Ltd.(Gurgaon) (In-house Sales)

Environment

Oracle 10g, PL/SQL, D2K (Form & Report 10g)

Duration

20 Dec, 2016 to 28 APR,2018.

Description

This ERP have basically three modules such as Sales, Spares, Service.

Assignments

Working with new Project of Suzuki Philippines for four wheelers

Designing Forms, Reports, Coding & testing that consist of applying

functionalities with the help of various packages, procedures and functions in Pl/Sql. Making cron jobs to send mail data to various dealers

Preparation of Unit Test Cases and Perform Unit Testing

Preparation of BR100 Document

Title

Exa Infotech pvt. Ltd.(Gurgaon)

Client

M.M Infosystems Pvt. Ltd. (In-house)

Environment

Oracle 10g, PL/SQL, D2K (Form & Report 6i,11g)

Duration

26 July, 2016 to 19 Dec, 2016.

Description

This ERP have several modules such as Store, Purchase, Payroll, Sales, Accounts etc.

Assignments

Designing Forms, Reports, Coding & testing that consist of applying

functionalities with the help of various Triggers, packages, procedures and functions in Pl/Sql.

Preparation of Unit Test Cases and Perform Unit Testing

Title

ERP for Sugar

Client

Wave industries Pvt. Ltd.(Dhanaura)

Environment

Oracle 10g, PL/SQL, D2K (Form & Report 10g)

Duration

Jan 2015 to July 2016

Description

This ERP have several modules such as Store, Purchase, Cane, Payroll, Finance etc.

Assignments

Designing Forms, Reports, Coding & testing that consist of applying

functionalities with the help of various Triggers, packages, procedures and functions in Pl/Sql.

Preparation of Unit Test Cases and Perform Unit Testing

Preparation of BR100 Document

ACADEMIC PROJECTS

Project Title: UML BOX undergone a 45 days training program at BCS INFALLIBLE TECHNOLOGY in 2012

Summer Internship Project Description: UML BOX provides an IDE to create UML diagrams by simple drag and drop

ACADEMIC QUALIFICATION

·12th from CBSE Board in 2008 with 64.6%

·10th from CBSE Board in 2006 with 71.8%

EXTRA & CO-CURRICULAR ACHIEVEMENTS

First Prize in Bhartiya Sanskrit Gyan Pariksha at Tehsil level

Won third Prize in Speech Competition at District level in Year of Physics 2005

Participated in Olympic Day Run organized by National Olympic Committee of INDIA on JUNE 2008

Volunteer of Media committee in Cerebrum 2010 & Sukrut 2k11

Member of the event Microsoft Dream Spark Yatra

Played Street Play (NUKKAD NATAK) and Secured Second Position in Sharda Group of Institution (SGI).

Coordinator of QUIZ WIZ Event in Sukrut 2k12

REFERENCE

Available on Request

PERSONAL DETAILS

Father’s Name : Shri Devi Prasad Tewari

Date of Birth : 05-dec-90

Gender : Male

Hobbies : Playing KHO-KHO, Playing Cricket, Cooking, chess

Strength : Flexible and Quick Learner

Nationality : Indian

Marital Status : Married

Passport : Yes

Declaration:

I assure you that I will endeavor my best and I will prove to be a worthy choice to your esteemed organization. I hereby, declare that all the information given is authentic to the fullest of my knowledge.

Date : 18-Sep-2020 Signature

Place : (Kaushlendra Kumar Tewari)

Contact this candidate