Objective:
To work in a dynamic environment where there is opportunity to use and enhance
my personal as well as academic qualification and my assimilated knowledge and
ideas to give best to the organization.
Academic Information:
Diploma in Computer Engineering
NTTF Electronics Training Center, Bangalore, Karnataka
(Indias First ISO 9001-2000 training institution)
Aggregate Percentage : 68.09% (1-6th Semester)
Year of Passing : July 2006
SSLC
New English School, Gokak
Year of Passing : Mar 2003
Aggregate Percentage : 73 %
Job Responsibilities:
Programming/Software Development
Specialized In:
Software Development
ERP Customization
Technical skills:
Languages : C, C++, Java, ASP.Net, PHP
RDBMS : SQL Server 2000, MySql 6.0 and Oracle 9i.
Environment : Windows 95/98/NT/XP
Tools : Syteline(MAPICS), Microsoft Visual Basic
6.0,
SQL Server 2000, Crystal Report 9.2.
Professional Summary:
1.11 year of software development experience in IT industry which includes 10
months onsite experience in a Client Industry.
Expertise in developing ERP (MAPICS SyteLine) solutions using VBA Programming
And SQL Server 2000
Expertise in report generation using Crystal Reports.
Expertise in data base programming.
Broad technical & Functional knowledge on various modules like: Purchasing,
sales, workflow, production, finance, and inventory.
Strong team player with demonstrated ability to find creative solutions to
software problems.
Good analytical skills, commitment to co-operative teamwork and developing
high quality software meeting requirements of the customer.
Experience Summary:
Organization Designation Period Platform
Blue Chip Computers
Bangalore Software Engineer
May 06 to till date ERP (Syteline)
# Summary Of Important Projects:
PROJECT 1
Client : CPPC (Thailand)
Module Developed : Costing Module
Platform : Windows 2000/XP/2k3
Technologies : Syteline Customization, Crystal Reports 9.2 & SQL Server
Description:
Developing all the Master forms for the Costing Module along with the table
designs and binding those to the back-end through the IDOs. Developing reports
like Stock Card, Production Cost and various other customized reports. Scope of
the project is to customize a new costing module to allocate Overhead Expenses
occurred during the month into each Jobs, Lot, Item W/H that were processed in
that month to reflect the actual cost.
Roles/Responsibilities:
Analyzing the Requirement And Getting Proper Clarification From The Client
Involved in Interface Designing, Code generation
Creation of stored procedures.
Creation Of Crystal Reports
Modeling database architecture and ensuring it supports the business needs
PROJECT 2
Client : Snechma (HAL)
Module Developed : EOU Enhancement
Platform : Windows 2000/XP/2k3
Technologies : Syteline Customization, Crystal Reports 9.2 & SQL Server
Description:
Developing the entire Master forms and tables for the Enhancement in the EOU
Module. Creating stored procedures for the various transactions done during the
EOU cycle. Developing reports as per the requirements.
The Enhancement included the development of Block Transfer, CT-3 and PC-1 forms
from scratch and impact to the Bond Registers and MRN. Adding functionality for
the In-Bond Sales Vendor.
In Block Transfer Masters user can enter valid period, valid till and amount
(25% of total Import Duty). Generally, the User will create new Block Transfer
for every three months. Block Transfer amount will be debited to Running Bond.
The user can cancel the Block Transfer by crediting the Running Bond.
Bond Registers:
Block Transfer amount will be debited the Bond-17 while creating the Block
Transfer. The same will be credited while cancelling the Block Transfer on
production of rewarehousing certificate.
25% of Duty amount will be debited from Bond registers for CG whenever there is
a receipt of capital goods through Import or CT-3. Duty amount will be credited
only when there is a returned to supplier.
25% of Duty amount will be debited from Bond registers for RM/CM whenever there
is a receipt of Raw Materials or Consumables through Import or CT-3. For Raw
Materials and Consumables, Duty amount will be credited at the time of Invoicing
of Finished goods on the basis of consumption, otherwise if there is a returned
to supplier.
Roles/Responsibilities:
Involved in Interface Designing, Code generation
Creation of stored procedures.
Creation Of Crystal Reports
Modeling database architecture and ensuring it supports the business needs
PROJECT 3
Client : TA, Vietnam
Project Title : TAHL Customizations
Platform : Windows 2000/XP/2k3
Technologies : Syteline Customization, Crystal Reports 9.2 & SQL Server
Description:
FIFO allocation:
TAHL needs further manipulative control over Purchase Order Receiving i.e.
Quantity received from the supplier will be allocated to Purchase Order on FIFO
basis. Standard SyteLine does not provide functionality to auto allocate quantity
received from supplier. Auto allocation of quantity received from supplier on
FIFO basis it was customized.
Consolidated Job Pick List
Theodore Alexander (hereafter referred as TAHL) needs further manipulative
control over Issuance of Material to Shop Floor. Standard SyteLine has the
Standard Job Pick List and Material Pick list under the Job Paper Work report but
both will give output per Job Order where as TAHL requirement is consolidation of
quantity as per material.
Consolidated Resource Group Dispatch List
TAHL needs further manipulative control over Resource Dispatch List. Standard
SyteLine has the Resource Dispatch List Report and Resource Group Dispatch List
Report, which will display dispatches for each and every resource; meaning that
both reports display which resource is allocated to which job. TAHLs requirement
is to consolidate dispatch list on Resource Group.
Item Exclusivity
Theodore Alexander (hereafter referred as TAHL) needs further manipulative
control over Customer Order Entry. TAHL will provide Item Exclusivity to their
Customers, meaning Items can be restricted to certain specific Customers. There
are two types of Item Exclusivity, although they are handled in the same way: -
1. Collection Exclusivity. Some of our collections are not sold in certain
countries e.g. the Althorp Collection is not sold in the UK, while the Hampshire
Antiwues collection is not sold in the US. Another example is the Chair Man
collection, which is only available to customers who buy into the Chair Man
program. For other customers, the whole collection is prohibited for sale.
2. Individual item exclusivity by country. This often happens when one customer
in a specific country decides to purchase an individual item from our catalog on
condition they have exclusive rights to sell that item in their country. Other
customers in that Country are prohibited from purchasing that item from TAHL (but
customers from other countries are eligible to purchase from TAHL).
We can handle this using Customer Item Cross Reference but there are thousands
of Items. If we enter those thousands of Items in Customer Item Cross Reference
for each and every customer then there will be huge data entry work as well as a
lot of data entered in the database. To reduce data in database and data entry in
Customer Item Cross Reference was customized.
Roles/Responsibilities:
Involved in Interface Designing, Code generation
Creation of stored procedures.
Creation Of Crystal Reports
Modeling database architecture and ensuring it supports the business needs.
PROJECT 4
Client : Dematic, Australia
Project Title : Localization Module Reports
Platform : Windows 2000/XP/2k3
Technologies : Crystal Reports 9.2 & SQL Server
Description:
The main objective of the above work item was to create reports that give the
details of the transactions. The reports handled by me were Purchase order
reports, work order reports, packing slip reports, Export Invoice reports,
Invoice summarizing reports etc.
Reports were designed in Crystal Report 9.2 and the procedures to fetch the
details were written in Microsoft SQL Server 2000.
Roles/Responsibilities:
Analyzing the Requirement And Getting Proper Clarification From The Client
Involved in Interface Designing And Code generation
Preparation of Unit Test Cases.
PROJECT 5
Client : TVS Cherry (India)
Module Developed : Entry Tax and Cform
Platform : Windows 2000/XP/2k3
Technologies : Crystal Reports 9.2 & SQL Server
Description:
We have developed this module to meet the domestic client requirements, so
we call it as localized modules. Developed 2 reports in Entry Tax and Cform.
Scope of this project is to list the total entry tax amount that was paid against
a vendor. Cform report lists all the invoices related to the particular local
customers.
Roles/Responsibilities:
Creation Of Crystal Reports
PROJECT 6
Client : Tata Holset / Cummins Turbo Technologies (Dewas, India)
Module Developed : Various Modules
Platform : Windows 2000/XP/2k3
Technologies : Syteline Customization, Crystal Reports 9.2 & SQL Server
Description:
Giving Onsite Support for Syteline ERP for 10 months in Tata Holset, now known
as Cummins Turbo Technologies Limited.
Roles/Responsibilities:
Interacting with users, supporting them and resolving the issues if any.
Handling the new requirements.
Generating reports as per the business requirements.
Personal Information:
Name : Mahantesh B
Age : 21 Years
Date of birth : 01 June 1987
Sex : Male
E-mail : [Send email using form at bottom]
Permanent Address : S\O Mr. Suresh B
Markandey Nagar
Falls Road Gokak
Belgaum dist
Karnataka 591307
Taste : Cricket, Music, Movies, Browsing
Languages known : English, Kannada, Hindi
Declaration
I hereby declare that all the above said information is true to the best of my
knowledge.
Place: Bangalore
Date: 31-10-2007 Signature
|
