MOHAMMED AFSHAD

OBJECTIVE

I am an experienced senior software developer relocating to

Bengaluru in August and seeking employment with a fast- growing startup. I bring more than saven years experience writing PLSQL coding, developing forms and reports 12c and migration, debugging, upgradation and patching more than eight years experience in the technology industry.

EXPERIENCE

RMS INDIA PVT LTD

10-2012 - 04-2015

Software Engineer

Previous working RMS india Pvt Ltd as software Engineer behalf of KSRTC transportation department in information technology Caritor Solutions India Pvt Ltd

05-2015 - 01-2019

Senior software Engineer

Previous working as caritor Solutions India Pvt Ltd as senior software Engineer behalf of KSRTC transportation department Mfx infotech

01-2019 - 08-2019

Senior software Engineer

Previous working in Mfx infotech Pvt Ltd Quess company as senior software Engineer behalf of Health and Glow Pvt Ltd. Retail stores company.

TEKsystems

11-2019 - 04-2020

Senior software Engineer

Currently working in TEKsystems as senior software Engineer behalf of Arrow electronics India Pvt Ltd.

EDUCATION

Kuvempu University

2012

BCA

64

PROJECTS

CONTACT

add1vb@r.postjobfree.com

996-***-****

567,17th Cross Rd, Stage 2, Hoysala

Nagar, Indiranagar, Bengaluru,

Karnataka 560038

www.linkedin.com/in/muhammed-

afshad-0b3b5060

www.facebook.com/MuhammedAfsh

SKILLS

Oracle SQL,PLSQL

Oracle forms and reports 6i,11g,12c

Pro C

Batch script

Python

LANGUAGE

•English •Kannada •Urdu •Hindi

PERSONAL DETAILS

Date of Birth : 01/02/1990

Nationality : Indian

Pan Card : AZGPA0823J

Passport : K3232710

Adhar card : 8240

Warehouse Management System

Organization : Arrow Electronics India Pvt ltd

Role : SR Software Developer.

Period : 29th Nov 19 to till date.

Team size : 6

Client : Arrow Electronics, Bangalore.

Environment : Oracle 9i/10G/11G, PL/SQL Developer, Developer 6i/10g, Toad 9.3.2.

Description:

WMS is to automate the receiving and shipping functions of the primary distribution centres. The WMS system was designed by EATON-KENWAY Corporation and implemented in 1985.The system is also known as AS/RS (Automated Storage and Retrieval System). WMS has been re-engineered considerably over the last 20 years.

Responsibilities:

Development of master screens.

Development of Transaction Screens.

Development of SQL, PL/SQL Coding, FORMS, REPORTS. Developed coding for Forms Triggers and Report Triggers. Worked with calling of Reports from Forms Environment. Worked with Lovs and Record Groups, Property Classes and Visual Attributes.

Worked with object libraries and PL/SQL libraries. Provided support of applications to team members.

Technical Skills:

Databases : Oracle 9i,10g, 11g and 12c.

Operating systems : Windows NT/ 2000 /2003/ XP, Windows 7, UNIX, Linux

Languages : SQL, PL/SQL, UNIX Shell Programming

Tools : Developer 2000 Forms 6i and Reports 6i,

SQLPLUS, Oracle PL/SQL Developer, informatica

power centre designer 9.1

Toad

Job functions : Analysis, Design, coding, debugging, migration, upgradation and patching

Merchandise Management System

Organization : Health & Glow

Role : SR Software Developer.

Period : 31stJan 2019 to 30 Aug 2019.

Team size : 6

Client : Health & Glow, Bangalore.

Environment : Oracle 9i/10G/11G, PL/SQL Developer, Developer 6i/10g, Toad 9.3.2.

Description:

Merchandise Management System (mms) provides immediate snapshots of key performance measures across merchandise sales, suppliers and stores. MMS is a complete POS (Point of Sale) and retail management solution for individual stores that often runs as a standalone application. It enables cashiers to process transactions and serves customers quickly and effectively and also enables store managers to maintain tight control over inventory, pricing, suppliers, promotions, customer information and reporting.

Responsibilities:

Development of master screens.

Development of Transaction Screens.

Development of SQL, PL/SQL Coding, FORMS, REPORTS. Developed coding for Forms Triggers and Report Triggers. Worked with calling of Reports from Forms Environment. Worked with Lovs and Record Groups, Property Classes and Visual Attributes.

Worked with object libraries and PL/SQL libraries. Provided support of applications to team members.

Analysis and design of data flow between the various components.

Involved in generating transaction reports daily, weekly, monthly and yearly.

Writing SQL Queries, Procedures, Functions, Triggers, Packages Using PL/SQL

Developed coding and testing.

Debugged the stored procedures, functions using oracle PL/SQL. Technical Skills:

Databases : Oracle 9i,10g, 11g and 12c.

Operating systems : Windows NT/ 2000 /2003/ XP, Windows 7, UNIX, Linux

Languages : SQL, PL/SQL, UNIX Shell Programming

Tools : Developer 2000 Forms 6i and Reports 6i,

SQLPLUS, Oracle PL/SQL Developer, informatica

power centre designer 9.1

Toad

Job functions : Analysis, Design, coding, debugging, migration, upgradation and patching

Depot Computerization System (DCS)

Period : May 2012 to April 2019

Database : ORACLE 11g

Tools : Developer 2000 Forms 6i, 10g and Report

6i,10g

Team Size : 03

Role : Programmer, Database Analysis and Design

Platform : windows xp, unix,

Description:

Depot Computerization System offers a platform for total computerization of all the transactions of the depot. It comprises of the modules including Ticket Accounting and Revenue Collection, Traffic and Administration, Stores, Workshop and MIS. This software is deployed over 78 depots and works on 24X7 basis.

Responsibilities:

Design and Developing of workflow procedures.

Interacted with various user departments to gather the requirements and implement the same in the project. Handled various duties and activities like designing, developing, coding, debugging and programming

Creating Database tables, views, sequences & indexes. Developed PL/SQL Packages, procedures, functions & triggers. Extensively worked on backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Cursors, Database triggers for Oracle 11G and also SQL queries.

Good Exposure in SQL Loader and Database links

Responsible for creating and modifying tables for Traffic, Store, Fuel etc

Used SQL Trace, TKPROF utility and explain plan while performing Tuning of SQL

Queries and PL/SQL Programs

Use Oracle SQL* Loader utility for data loading in tables from the flat files.

Writing bulk operations by using collections, ref-cursors, bulk loading and bulk fetching .

Created Technical Design documents for enhancements and attended Technical Design Reviews.

Troubleshooting Database Problems as and when exists. Execute the test cases based on work request.

Documented the process and the problem resolution.

INTERESTS

•Mixed martial arts

Chess

Drawing

Music

Playstation games

ADDITIONAL INFORMATION

Professional Summary

•Proficient in writing Complex SQL queries, Stored Procedures, Cursor, Functions, Packages and Triggers.

•Good knowledge in complete phase of Software Development Life Cycle [SDLC].

•Good exposure in written programs using advanced PL/SQL concepts like Ref cursors, collections, dynamic SQL, Bulk Binding, etc.

•Working knowledge of UNIX shell-programming

Good working knowledge on SQL* Loader & other Oracle Utilities

•Good Exposure in development, coding and troubleshooting the applications using Developer Forms 6i & Reports as front end and ORACLE 10g,11g as database.

•Exposure to Oracle Architecture.

•Exposure to Oracle features in 10g/11g/12c

•Performance Tuning of SQL queries PL/SQL code using Explain Plan, Tracing and TKPROF utilities.

•Career oriented, hard working and ability to handle multiple tasks.

•Exceptionally good and experienced in handling the problem and troubleshooting.

•Excellent communication, organizational and presentation skills.

•Quick learner and excellent team player having ability to meet tight deadlines and work under pressure.

MOHAMMED AFSHAD

Contact this candidate