Resume - Trelco Limited Company

Document technical information

Format doc
Size 97.8 kB
First found May 22, 2018

Document content analysis

Language
English
Type
not defined
Concepts
no text concepts found

Persons

Charles Hofmann
Charles Hofmann

wikipedia, lookup

Philip Jessup
Philip Jessup

wikipedia, lookup

Organizations

Places

Transcript

Devendra Sakalley
101, Block 3A, CBR Estates
Madinaguda, Miyapur,
Hyderabad - 500050
Phone No. +91-9849004014
E-Mail: [email protected]
SUMMARY







Currently working as Project Leader in Oracle India Pvt. Ltd., India.
Worked as Project Leader for UCCnet/GDSN project.
3.5+ years of experience in Oracle Applications 11i/R12.
6+ Years of total experience in Software Development using Oracle
Technologies i.e. SQL, PL/SQL, Oracle Applications Framework 11.5.10,
Oracle Forms, Oracle Reports.
Strong analytical skills and problem solving approach.
Good communication and inter-personal skills.
Self-motivated, quick learner, willing to adapt to new challenges & new
technologies.
EXPERIENCE




6+Years
Currently working as Project Leader in Oracle India Pvt. Ltd., India, since
June 2002.
Worked as a Software Engineer in Infogen Technologies, New Delhi from
Nov 2000 to Mar 2002.
Worked as a Software Engineer in Netreal Solutions Pvt. Ltd, New Delhi
from June 2000 to Oct 2000.
Worked as a Software Engineer (Trainee) in Disa Information Systems Pvt.
Ltd., Indore (M.P.) from Dec 1999 to May 2000.
EDUCATION



MCA from U.I.C.S.A., Rani Durgawati University, Jabalpur (M.P.), with
71.24% marks.
B.Sc. with Computer Science, Physics, Mathematics as subjects from Nagpur
University, Nagpur, with 67.8% marks.
12th & 10th from CBSE curriculum with 79.4% and 72.2% marks.
TECHNICAL SKILLS
Tools
Languages
Operating Systems
RDBMS
Oracle Applications Framework 11.5.10, JDeveloper 11.5.10,
Oracle Forms, Oracle Reports
Java, C/C++, HTML, XML
Windows NT, Windows 2000/98/95, Unix (SCO-V, HP-UX),
Linux.
Oracle 10g/9i/8i, SQL, PL/SQL
DBMS
Others
FoxPro 2.6, Ms-Access 97.
Knowledge of Oracle 8i Database Administration.
PROJECTS UNDERAKEN


Projects at Current Job
 Product Data Hub - Oracle PLM (Product Lifecycle Management)
 UCCnet/GDSN Integration - Oracle PLM (Product Lifecycle
Management)
 Item Associations - Oracle PLM (Product Lifecycle Management)
 Item Dimension - Oracle DBI (Daily Business Intelligence)
 Item Master Maintenance - Oracle Inventory
 Item Dimension Maintenance - Oracle EDW (Embedded Data Warehouse)
Previous Projects
 Integral ERP
 Inventory Management System
 Dealer Financial Statement Generation System.
 Spare Parts Management System.
PROJECT DETAILS
1.
Title
Organization
Technologies
Role
Summary
Oracle PLM (Product Lifecycle Management) – Product
Data Hub
Oracle India Pvt. Ldt., Hyderabad, India.
Oracle Applications Framework 11.5.10, Oracle 10g on Linux,
SQL, PL/SQL.
Project Leadership, Technical Design and Development.
Oracle PLM is a part of Oracle Applications 11.5.10 EBusiness suite. Product Data Hub is the latest concept in Oracle
Advanced Product Catalog. Oracle APC is now converted into
Product Data Hub, which accepts data from disparate sources.
The different sources can be other Organizations, Systems
(such as SAP, Siebel etc.). The product information is then
imported into a single source of truth (i.e. the Product Data
Hub). This project is to enable and enhance the import into
Oracle APC from other source systems. The other sub-modules
are Import Workbench, Source system setup, Matching engine
etc.
As a project lead, I am responsible for the design and delivery
of following modules/parts
o Import Workbench
o UCCnet Bulkloader creation
I am responsible for the deliveries of developers involved.
Apart from the project lead role, my role in this project is to
design and develop the following parts
 UCCnet Bulkloader creation
 Import Summary and Search page
2.
Title
Organization
Technologies
Role
Summary
3.
Title
Organization
Technologies
Role
Summary
Oracle PLM (Product Lifecycle Management) – UCCnet
Integration
Oracle India Pvt. Ldt., Hyderabad, India.
Oracle Applications Framework 11.5.10, Oracle 9.2.0.5.0 on
Linux, SQL, PL/SQL.
Project Leadership, Technical Design and Development.
Oracle PLM is a part of Oracle Applications 11.5.10 EBusiness suite. Oracle Advanced Product Catalog is a part of
Oracle PLM. Oracle Advanced Product Catalog provides the
functionality of Item Master, Item Catalog Category, Lifecycle
maintenance, Catalogs etc. UCCnet is an E-commerce solution
provider, which is now a day in much demand in USA, because
of Walmart mandating all its suppliers to register their products
to UCCnet. Oracle Advanced Product Catalog now provides
the functionality of Registering/Publishing the GTINs to
UCCnet Global Repository. GTIN (Global Trading Item
Number) is the unique item number in the UCCnet repository.
Each GTIN has several attributes attached to it, such as length,
width, height, color etc.
As a project lead, I was responsible for the delivery of
following modules/parts
o GTIN maintenance
o GTIN Attributes maintenance
o Packaging Hierarchy maintenance
o Registration and Publication workbench
I was involved in the estimation of effort and schedule of each
of these modules and was also responsible for the deliveries of
developers involved.
Apart from the project lead role, my role in this project is to
design and develop the following parts
 Define GTIN for each item
 Define/maintain its attributes
 Validation of GTINs and its attributes before
registering/publishing.
 Maintainence of status of GTIN at UCCnet repository.
 Maintainence of Customer specific attributes
 Registration and Publication of GTIN to UCCnet.
Oracle PLM (Product Lifecycle Management) – Item
Associations
Oracle India Pvt. Ldt., Hyderabad, India.
Oracle Applications Framework 11.5.10, Oracle 9.2.0.5.0 on
Linux, SQL, PL/SQL.
Technical Design and Development.
Oracle PLM is a part of Oracle Applications 11.5.10 EBusiness suite. Oracle Advanced Product Catalog is a part of
Oracle PLM. Oracle Advanced Product Catalog provides the
functionality of Item Master, Item Catalog Category, Lifecycle
maintenance, Catalogs etc. Item associations is a sub-module
of Oracle Advanced Product Catalog, which contains the
following parts
 Item Cross References – these are used to define a
reference to the item. The reference is linked with the
reference type.
 Related Items – these are used to define a relationship
between two items.
 Customer Item Cross References – these are used to
define a reference to the ERP item with the customer
item.
 Manufacturer Part Numbers – these are used to define
the reference to ERP item with the manufacturer’s item.
My role in this project is to design and develop each of the
above parts with the search, edit, insert, delete capabilities.
4.
Title
Organization
Technologies
Role
Summary
Oracle DBI (Daily Business Intelligence) – Item Dimension
Oracle India Pvt. Ldt., Hyderabad, India.
SQL, PL/SQL, Oracle 9.2.0.5.0 on Linux.
Technical Design and Development.
Oracle DBI is a part of Oracle Applications 11.5.9+ E-Business
suite. DBI is the intelligence portal for Oracle Applications.
Each module has its own intelligence portal for ex. Financial
Intelligence, HR Intelligence, Manufacturing Business
Intelligence, Supply Chain Intelligence etc. Each of these
intelligence portals uses the item/product as one of the
dimension. (Dimension is the term taken from Oracle EDW)
My role in this project is to design and develop the item
dimension, which can be used by each of these intelligence
teams in their reports. It consists of following parts
 Product Hierarchy maintenance – Product catalog can
be defined as a hierarchical structure in Oracle
Applications. This needs to be converted to a flat
structure in order to be used within the MVs.
 Item Dimension maintenance – the item is attached to
product catalog, purchasing catalog, inventory catalog
etc. in Oracle Applications. All this information needs
to be moved to a single de-normalized table in order to
be used within MVs.
One of the major task in this project was to increase the
performance of total process.
5.
Title
Organization
Technologies
Role
Summary
Oracle Inventory – Item Master Maintenance
Oracle India Pvt. Ldt., Hyderabad, India.
Oracle Forms, SQL, PL/SQL, Oracle 9.2.0.5.0 on Linux.
Maintenance.
Oracle Inventory is a part of Oracle Applications E-Business
suite. Item master is one of the key area in Oracle Inventory,
which is used to create and maintain items, categories, category
sets, associations etc.
My role in this project is to do the maintenance of Item master
by fixing the existing bugs and doing some minor
enhancements. This is an ongoing project and we solve the
bugs as and when they come.
6.
Title
Organization
Technologies
Role
Summary
7.
Title
Organisation
Client
Team Size
Technologies
Role
Summary
Oracle EDW (Embedded Data Warehouse) – Item
Dimension
Oracle India Pvt. Ldt., Hyderabad, India.
SQL, PL/SQL, Oracle 8i/9.2.0.5.0 on Linux.
Development and Maintenance.
Oracle EDW is a part of Oracle Applications E-Business suite.
EDW is the data warehousing solution for Oracle Applications.
It consists of dimensions and facts, which in turn are used by
Oracle Discoverer to generate the reports. Item dimension is
one of the dimensions of EDW.
My role in this project is to do some enhancements to the item
dimension collection program and fixing of bugs. Maintenance
of metadata for item dimension is also one of the tasks
involved.
Integral ERP
Infogen Technologies, New Delhi
Escorts Ltd. (Auto Suspension Parts Division), Faridabad
10
Oracle 8.0 on HP-UX, Oracle Developer 2000(Forms 6.0,
Reports 6.0), PL/SQL
Design, Development and Implementation
Integral ERP is a Copyright product of Infogen Technologies,
Naraina, New Delhi. This is an ERP package, which automates
& integrates all the functional parts of an enterprise in an
efficient manner. As a Module Leader, I am dealing with the
design, development and implementation of the FINANCE
module at Escorts Ltd.(ASP). I am also involved in the design,
development and implementation of some parts of
MATERIALS & SALES modules. Summary of these modules
with which I am dealing is as follows
FINANCE
 General Accounting – All type of voucher entries(Cash,
Bank, Journal, Imprest, Purchase and Sales), Bank
reconciliation, General Ledger, Trial Balance, Profit &
Loss account, Balance sheet, Cash flow analysis,
Account balance statements etc.
 Bills Payable – Manual bill entry for all type of
bills(Normal, supplementary, against rejection, against
reoffered goods and expense), Automatic bill
generation of exciseable goods, Automatic generation



of purchase voucher for each bill, Supplier outstanding
with aging, Payments to vendor(through cheque, cash
or LC/Hundi), TDS deduction and certificate
generation, Sale Tax returns, other tax returns specific
to Haryana state such as HST, Haryana Entry tax etc.
Accounts Receivables – Customer’s outstanding with
aging, Customer’s credit period analysis, Bill
discounting(LC), Sale Tax returns, C-Form tracking
etc.
Budgetting – Defining budget, Allocation of budget to
different cost centers, distribution of this budget to
group of accounts, controlling expenses according to
budget, budget Vs actual expenses report, etc.
Fixed Assets – Defining assets, maintaining these assets
at their physical locations, defining depreciation
methods, asset valuation etc.
MATERIALS
 Purchase – Purchase requisitions, Capital expenditure
requisitions, Purchase orders, Work orders.
 Goods Inwards & Store Accounting – Gate entry,
Challan entry, Valuation of goods, Inspection of goods,
Store acknowledgement of goods.
SALES
 Pre Sales – Enquiry handling, Quotation generation,
Sales order generation etc.
8.
Title
Organization
Client
Duration
Team Size
Technologies
Role
Summary
9.
Title
Organization
Inventory Management System
NetReal Solutions, New Delhi
Juhee Marketing Company, New Delhi
5 Months
5
Oracle 8.0 on Win NT(Server 4.0), Oracle Developer
2000(Forms 5.0, Reports 3.0), PL/SQL
Analysis, Design, Development and Implementation
Juhee Marketing Company is an authorized dealer of Tata
Pipes and other branded pipes. The inventory and related
accounts are managed by the above system. The above system
is used to record the entries for purchase, sales and stock
transfer of the pipes. It also keeps record of the customer's
account. It generates the various reports such as stock ledger,
stock statement, area-wise sales report, area-wise-part-wise
sales report, customer-wise sales report, customer ledger, agewise outstanding report etc.
Dealer Financial Statement Generation System
Disa Information Systems Pvt. Ltd., Indore(M.P.)
Client
Duration
Team Size
Technologies
Role
Summary
10.
Title
Organization
Client
Duration
Team Size
Technologies
Role
Summary
Distinct Ford, Indore(M.P.)
4 Months
3
Oracle 8.0 for Win NT, Developer 2000(Forms 5.0, Reports
3.0), PL/SQL, SQL
System Analysis / Design, Development and Implementation.
Dealer Financial Statement Generation System is used for
automated generation of a monthly report that is a standard
format for Ford Motors Company used worldwide. Different
databases maintained by the client are parsed in accordance to
the predefined structure given by Ford Motors Company, USA,
to generate this report. The report contains all the financial
statements of the organization. The main parts are operating
trend analysis, operating summary, departmental summary for
sales, expense & operation, profit & loss account, personnel
(HRD) summary and balance sheet. The report is printed in a
standard preprinted format supplied by the Ford Motors
Company, USA.
Spare Parts Management System
Disa Information Systems Pvt. Ltd., Indore(M.P.)
Distinct Ford, Indore(M.P.)
2 Months
1
Oracle 8.0 for Win NT, Developer 2000(Forms 5.0, Reports
3.0), PL/SQL, SQL
System Analysis / Design, Coding.
Distinct Ford is an authorized dealer of the Ford cars. They
have to manage the inventory of the Spare Parts and accesories
of the cars. The above system is used to record the entries for
purchase, sales, stock transfer of the parts and accesories. It
also keeps record of the customer's account. It generates the
various reports such as stock ledger, stock statement, area-wise
sales report, area-wise-part-wise sales report, customer-wise
sales report, customer ledger etc.
PERSONAL PROFILE
FATHER'S NAME
DATE OF BIRTH
SEX
MARITAL STATUS
PASSPORT No.
EXPIRY DATE
Shri R.K.Sakalley
14th June, 1975
Male
Married
E2238241
5-June-2012
×

Report this document