–gsWH7J0EYzAVdxRpVrJU9CowBNYWHhGY1ObJJpE
Hi -
I am looking for room on rental basis.
I am SG-PR. Currently residing in AMK.
Near to any MRT - anywhere in SG is fine.
Thanks & Regards
-Arvind
Cell : 9695 7690.
gamil Email : sawantarvind (AT) gmail (.) Com
–gsWH7J0EYzAVdxRpVrJU9CowBNYWHhGY1ObJJpE
–gsWH7J0EYzAVdxRpVrJU9CowBNYWHhGY1ObJJpE
Anbazhagan.P
Address:
#12-308, Bedok North road, Bedok, Singapore, Pin:460082
Mobile: 65-96234028 E-mail: rp.anbu@gmail.com or pr_anbu@yahoo.co.in
OBJECTIVE
Seeking a position to utilize my skills and abilities in the
Information Technology Industry that offers Professional growth
while being resourceful, innovative and flexible.
To grow professionally, doing processes and routines faster
and smarter.
To work in a team environment, learning and assisting my
coworkers.
SUMMARY
Team Leader with 5.7 years of experience as Database
Developer, including extensive expertise in Oracle PL/SQL
programming, Implementing Client-Server Application Using Oracle
Developer 2000
Having experience in all phases of Data warehousing project
development.
Having experience in developing and maintaining oracle
Database
Extensively used Erwin for data modeling and Dimensional
Data Modeling
EDUCATION / TRAINING / CERTIFICATION
Master degree in Computer Application, Bharathidasan
University, Thiruchirapalli,India (Completed 2001)
Bachelors Degree in Electronics, P.S.G College of Arts And
Science, Bharathiar University, Coimbatore, Tamilnadu, India.
(completed 1998)
Certification NIIT Network Admin
undergone Business Objects Training
TECHNICAL SKILLSET
Computer Languages: Oracle PL/SQL, Shell Scripting
Databases: Oracle 8i/9i/10g, SQL Server 2005.
Database Administration:
Oracle 9i/10g: Database Administration (performance tuning,
Import/Export, Data Loading Using SQL loader), User Management
SQL Server: Import/Export of data using DTS packages
Application Development Tools: Oracle Forms (6i, 5.0, 4.5),
Oracle Reports (2.5,6i), Visual Interdev, FrontPage 2000, Remedy,
SQL Navigator, TOAD, ERWIN
Operating Systems: Windows 95 onwards, AIX Version 5.3, MS-
DOS
Hardware: Troubleshooting computer hardware related issues.
IT INDUSTRY EXPERIENCE
Company: i-flex Solutions Ltd, Bangalore, India.
o Job Title: Associate Consultant
o Job Duration: 25-AUG-2006 Till date
Company: i-GATE Global Solutions, Bangalore, India.
o Job Title: Sr. Software Engineer
o Job Duration: 17-NOV-2004 25-AUG-2006
Company: Sundaram Infotech Solutions limited, Chennai, India
o Job Title: Software Engineer
o Job Duration: 21-JUN-2004 06-NOV-2004
Company: Rajshree Sugars & Chemicals Limited, Coimbatore,
India.
o Job Title: Senior Officer Information Systems
o Job Duration: 30-JUL-2001 16-JUN-2004
DATA WAREHOUSING PROJECTS
1. Reveleus Product
Reveleus is a suite of analytical applications for the financial
services industry focused in the areas of risk management, customer
Analytics product solves the most complex global challenges facing
the financial industry today, including multi-jurisdictional Basel
II compliance and operational risk management.
Involved in development of data extraction and loading
Manual process automation using procedure
Worked in Different databases and created the scripts for
the above related changes.
Handling customer issues and providing solutions.
Understood the functionality, designed the test cases
generation with the Program Specs of the solutions
Performed Load and Performance testing.
2. Business Intelligence Solution
Client lansforsakringar, Sweden
Period Jan 2006 April 2006
Environment Oracle 9i, PL/SQL, SQL Server 2005, Microsoft SSIS,
TOAD
Role Senior Developer
Responsibilities Data Model Design, Backend Object Creation,
Data Extraction and Loading
Brief description of the project:
I was involved the Data warehousing project for lansforsakringar. I
created a procedure to populate the calendar dates for the given
calendar years which is commonly used in data warehousing projects.
This calendar dates will be used in data model tables and I was
responsible for creating backend components like stored procedure,
backend object creation and Defining integrity constraints for the
Data Model.
Client-Server APPLICATION PROJECTS
1. Merchandise Management System (MMS)
Client Metro MGI Informatik GmbH, Germany
Period April 2006 Aug 2006
Environment Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Reports
6i, TOAD and Citrix
Role Senior Developer
Responsibilities Requirment Gathering, Design, Coding,
reviewing and testing
Brief description of the project:
The Merchandise Management System (MMS) at Metro MGI is the single
most important group of applications for the Metro Group as it spans
the entire business operations of the group from the supplier-facing
buying processes to the stores operations at Points of Sale (POS).
The SCM systems are designed to support the Metro C&C, Real and
Extra retail lines, and it is deployed at Metro locations in
multiple countries across the globe. There are multiple products
(like MMS, SCS, IPS etc.) that are available within the SCM
applications and these are deployed depending on the specific
requirements of the locations and their size of operations. When the
products are internationally deployed, they need to be customized
for local language interaction. Each system listed above is made up
of multiple modules interfacing with each other and across other
systems within MMS. The MMS system was developed in-house by MGI for
the Metro AG. Maintain the supplier details, promotions, article
details, sales lines, store details, vendors, manufacturers, order
management etc.
2. After Market Sales Order Management System
Client Cummins, USA
Period Nov 2004 Dec 2005
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, TOAD,
Citrix Program Neighborhood, UNIX
Role Senior Developer
Responsibilities Analysis of requirements based on
the technical specifications and guiding developers for development
of the same
Handling the development/technical issues.
Involved in development, unit testing and review according
to requirement specification
Onsite/offshore coordination
Brief description of the project:
After market Sales Order Management System is the order management
system used at Memphis Distribution System and is used worldwide to
enter and maintain customer orders. ASOMS interfaces, directly with
a warehouse management system to provide complete follow-up on
inventory, orders, shipments, backorders etc. It interfaces with the
requirements planning system for proper materials planning in the
warehouse. The architecture used is client server and the access to
the database and the development tools are through the Citrix server.
3. Asset Management
Client Sundaram Finance Ltd, India
Period Jun 2004 Nov 2004
Environment Oracle 8i Forms 5.0, Reports 3.0, PL/SQL, TOAD
Role Senior Developer
Responsibilities Document Preparation, Table Creation, Screen
Designing, Data Migration
Brief description of the project:
This module consists of 1. Purchase order entry 2. Purchase order
authorization 3.Invoice entry 4.Invoice authorization.
1. PO Entry
All computer accessories purchased in SFL/SIS has an Purchase order
associated with it which contains details about the particular
purchase such as vendor id, quantity, Value, Date of Purchase etc
The Purchase order given to the vendor is also stored in the oracle
system as a long raw column and invoked to the user as a word
document through OLE (Object Linking & embedding).
This project is to store the Purchase Order document separately as
word documents in common NT Folder and not in oracle database.
2. PO Authorization
The PO should be authorized by the super user in the company. He
should convince himself about the details in the PO. Once he feels
it is ok, he can authorize the purchase of the particular asset.
When the super user makes authorization, payment can be released to
the supplier.
3. Invoice Entry
When the payment is made to the supplier, he raises an invoice based
on the PO he has already raised. The user should check whether the
invoice is in sync with the PO that was already raised. If there are
any discrepancies he should immediately highlight it to the
supplier. Once the user satisfies himself, he can enter the invoice
details in the system.
4. Invoice Authorization
The Invoice should be authorized concern department head in the
company.
5. Sugar Cane Management System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2001 Aug 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities FoxPro to Oracle conversion, Payroll, Cane
management Customization
Brief description of the project:
Our client is one of the largest sugar manufacturing companies in
Tamil Nadu. We have been assigned to implement an ERP solution for
sugar factory management. This ERP consist of inventory management,
payroll accounting, cane weighing & crushing management system, cane
pricing management system, cane calendaring system and chemical
laboratory reporting modules.
6. Machinery Maintenance System
Client Rajshree Sugars & Chemicals Ltd, India
Period Aug 2003 Oct 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Creating User, Role and Privileges. Creating
Table space. Table level trigger was Created when data inserting and
updated. Stored procedures were created to Validate null values in
forms
Brief Project Description:
We have a 4500 Mtn crushing capacity factory. Maintenance of the
factory was computerized using oracle and D2K. The machinery
maintenance System is comprised of Masters (Equipment Instrument,
Motor, Gear Box, Valve, Stoppage, Pump, Reason, and Bearing, work
schedule), Reports, Transaction( Machinery log entry, Cleaning day
schedule, Authorization) screens. The online system is designed to
track every equipment and other assets that require emergency or
unscheduled maintenance as well as regular preventive maintenance.
The documentation of preventive and unscheduled maintenance data is
specifically designed to provide record retention and trace ability
to assist in achieving the requirements of sugar factory. The system
also provides valuable management information to analyze and
evaluate the effectiveness of the maintenance program, the cost of
equipment maintenance and repair, and the status of all assets of
any period.
7. Security System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2003 Jan 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
Management has decided to computerize the manual work done at
security gate premises and that project had been ntrusted to me.
The following screens comprise the security gate module.
1. Own Vehicle in/out 2. Other vehicle in/out 3. Officer in/out
And 4. Visitors in/out
A brief note on the above screen is given below,
We have around 15 vehicle of our own and they have been utilized for
various purpose viz., to drop/pickup the officials and visitors.
Here the vehicle distance run is tracked. In other vehicle screen
officer in/out entry mobility of the officers of our company is
noted. The visitors who are visiting our company are noted down in
visitors in/out screen.
8. Division Office Computerization
Client Rajshree Sugars & Chemicals Ltd, India
Period Jan 2004 Jun 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
We have 12 division offices for sugarcane procurement and Monitoring
of regular supplies to the factory. We have computerized all
divisions with Oracle Forms as Front end and backend is personal
Oracle. Script for Data transfer from Division Offices and factory
and vice-versa is formulated individually and see to it that no data
is lost on either side.
Database Trigger is written for automatic updating in stock of
fertilizers
Whenever there is inward and issue to other divisions.
Successfully developed Nine entry screens and ten reports.
PERSONAL DETAILS
Name : Anbazhagan Palanisamy
Present Address : #12-308, Bedok North road,
Bedok, Singapore, Pin:460082
Permanent Address : 90, Hudco Colony, 3rd Street
Tatabad, Coimbatore, Tamil Nadu.
Email Id : rp.anbu@gmail.com or
pr_anbu@yahoo.co.in
Marital status : Unmarried
Passport No & Date : E7948154 & 29/01/2014
Mobile Number : +65-96234028
Languages:
Tamil : Read, Write, and Speak
English : Read, Write, and Speak
Telugu : Speak
REFERENCES
1. Mr. Nagaraj Subramanian Singapore
Telephone: +81380680 (Mobile);
Email: subbu_kn2001@yahoo.com
–gsWH7J0EYzAVdxRpVrJU9CowBNYWHhGY1ObJJpE
–oHW4CVwrc5nNfGgj9yPsV1xz8rqiXJ50yFTbiyo
Anbazhagan.P
Address:
#12-308, Bedok North road, Bedok, Singapore, Pin:460082
Mobile: 65-96234028 E-mail: rp.anbu@gmail.com or pr_anbu@yahoo.co.in
OBJECTIVE
Seeking a position to utilize my skills and abilities in the
Information Technology Industry that offers Professional growth
while being resourceful, innovative and flexible.
To grow professionally, doing processes and routines faster
and smarter.
To work in a team environment, learning and assisting my
coworkers.
SUMMARY
Team Leader with 5.7 years of experience as Database
Developer, including extensive expertise in Oracle PL/SQL
programming, Implementing Client-Server Application Using Oracle
Developer 2000
Having experience in all phases of Data warehousing project
development.
Having experience in developing and maintaining oracle
Database
Extensively used Erwin for data modeling and Dimensional
Data Modeling
EDUCATION / TRAINING / CERTIFICATION
Master degree in Computer Application, Bharathidasan
University, Thiruchirapalli,India (Completed 2001)
Bachelors Degree in Electronics, P.S.G College of Arts And
Science, Bharathiar University, Coimbatore, Tamilnadu, India.
(completed 1998)
Certification NIIT Network Admin
undergone Business Objects Training
TECHNICAL SKILLSET
Computer Languages: Oracle PL/SQL, Shell Scripting
Databases: Oracle 8i/9i/10g, SQL Server 2005.
Database Administration:
Oracle 9i/10g: Database Administration (performance tuning,
Import/Export, Data Loading Using SQL loader), User Management
SQL Server: Import/Export of data using DTS packages
Application Development Tools: Oracle Forms (6i, 5.0, 4.5),
Oracle Reports (2.5,6i), Visual Interdev, FrontPage 2000, Remedy,
SQL Navigator, TOAD, ERWIN
Operating Systems: Windows 95 onwards, AIX Version 5.3, MS-
DOS
Hardware: Troubleshooting computer hardware related issues.
IT INDUSTRY EXPERIENCE
Company: i-flex Solutions Ltd, Bangalore, India.
o Job Title: Associate Consultant
o Job Duration: 25-AUG-2006 Till date
Company: i-GATE Global Solutions, Bangalore, India.
o Job Title: Sr. Software Engineer
o Job Duration: 17-NOV-2004 25-AUG-2006
Company: Sundaram Infotech Solutions limited, Chennai, India
o Job Title: Software Engineer
o Job Duration: 21-JUN-2004 06-NOV-2004
Company: Rajshree Sugars & Chemicals Limited, Coimbatore,
India.
o Job Title: Senior Officer Information Systems
o Job Duration: 30-JUL-2001 16-JUN-2004
DATA WAREHOUSING PROJECTS
1. Reveleus Product
Reveleus is a suite of analytical applications for the financial
services industry focused in the areas of risk management, customer
Analytics product solves the most complex global challenges facing
the financial industry today, including multi-jurisdictional Basel
II compliance and operational risk management.
Involved in development of data extraction and loading
Manual process automation using procedure
Worked in Different databases and created the scripts for
the above related changes.
Handling customer issues and providing solutions.
Understood the functionality, designed the test cases
generation with the Program Specs of the solutions
Performed Load and Performance testing.
2. Business Intelligence Solution
Client lansforsakringar, Sweden
Period Jan 2006 April 2006
Environment Oracle 9i, PL/SQL, SQL Server 2005, Microsoft SSIS,
TOAD
Role Senior Developer
Responsibilities Data Model Design, Backend Object Creation,
Data Extraction and Loading
Brief description of the project:
I was involved the Data warehousing project for lansforsakringar. I
created a procedure to populate the calendar dates for the given
calendar years which is commonly used in data warehousing projects.
This calendar dates will be used in data model tables and I was
responsible for creating backend components like stored procedure,
backend object creation and Defining integrity constraints for the
Data Model.
Client-Server APPLICATION PROJECTS
1. Merchandise Management System (MMS)
Client Metro MGI Informatik GmbH, Germany
Period April 2006 Aug 2006
Environment Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Reports
6i, TOAD and Citrix
Role Senior Developer
Responsibilities Requirment Gathering, Design, Coding,
reviewing and testing
Brief description of the project:
The Merchandise Management System (MMS) at Metro MGI is the single
most important group of applications for the Metro Group as it spans
the entire business operations of the group from the supplier-facing
buying processes to the stores operations at Points of Sale (POS).
The SCM systems are designed to support the Metro C&C, Real and
Extra retail lines, and it is deployed at Metro locations in
multiple countries across the globe. There are multiple products
(like MMS, SCS, IPS etc.) that are available within the SCM
applications and these are deployed depending on the specific
requirements of the locations and their size of operations. When the
products are internationally deployed, they need to be customized
for local language interaction. Each system listed above is made up
of multiple modules interfacing with each other and across other
systems within MMS. The MMS system was developed in-house by MGI for
the Metro AG. Maintain the supplier details, promotions, article
details, sales lines, store details, vendors, manufacturers, order
management etc.
2. After Market Sales Order Management System
Client Cummins, USA
Period Nov 2004 Dec 2005
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, TOAD,
Citrix Program Neighborhood, UNIX
Role Senior Developer
Responsibilities Analysis of requirements based on
the technical specifications and guiding developers for development
of the same
Handling the development/technical issues.
Involved in development, unit testing and review according
to requirement specification
Onsite/offshore coordination
Brief description of the project:
After market Sales Order Management System is the order management
system used at Memphis Distribution System and is used worldwide to
enter and maintain customer orders. ASOMS interfaces, directly with
a warehouse management system to provide complete follow-up on
inventory, orders, shipments, backorders etc. It interfaces with the
requirements planning system for proper materials planning in the
warehouse. The architecture used is client server and the access to
the database and the development tools are through the Citrix server.
3. Asset Management
Client Sundaram Finance Ltd, India
Period Jun 2004 Nov 2004
Environment Oracle 8i Forms 5.0, Reports 3.0, PL/SQL, TOAD
Role Senior Developer
Responsibilities Document Preparation, Table Creation, Screen
Designing, Data Migration
Brief description of the project:
This module consists of 1. Purchase order entry 2. Purchase order
authorization 3.Invoice entry 4.Invoice authorization.
1. PO Entry
All computer accessories purchased in SFL/SIS has an Purchase order
associated with it which contains details about the particular
purchase such as vendor id, quantity, Value, Date of Purchase etc
The Purchase order given to the vendor is also stored in the oracle
system as a long raw column and invoked to the user as a word
document through OLE (Object Linking & embedding).
This project is to store the Purchase Order document separately as
word documents in common NT Folder and not in oracle database.
2. PO Authorization
The PO should be authorized by the super user in the company. He
should convince himself about the details in the PO. Once he feels
it is ok, he can authorize the purchase of the particular asset.
When the super user makes authorization, payment can be released to
the supplier.
3. Invoice Entry
When the payment is made to the supplier, he raises an invoice based
on the PO he has already raised. The user should check whether the
invoice is in sync with the PO that was already raised. If there are
any discrepancies he should immediately highlight it to the
supplier. Once the user satisfies himself, he can enter the invoice
details in the system.
4. Invoice Authorization
The Invoice should be authorized concern department head in the
company.
5. Sugar Cane Management System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2001 Aug 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities FoxPro to Oracle conversion, Payroll, Cane
management Customization
Brief description of the project:
Our client is one of the largest sugar manufacturing companies in
Tamil Nadu. We have been assigned to implement an ERP solution for
sugar factory management. This ERP consist of inventory management,
payroll accounting, cane weighing & crushing management system, cane
pricing management system, cane calendaring system and chemical
laboratory reporting modules.
6. Machinery Maintenance System
Client Rajshree Sugars & Chemicals Ltd, India
Period Aug 2003 Oct 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Creating User, Role and Privileges. Creating
Table space. Table level trigger was Created when data inserting and
updated. Stored procedures were created to Validate null values in
forms
Brief Project Description:
We have a 4500 Mtn crushing capacity factory. Maintenance of the
factory was computerized using oracle and D2K. The machinery
maintenance System is comprised of Masters (Equipment Instrument,
Motor, Gear Box, Valve, Stoppage, Pump, Reason, and Bearing, work
schedule), Reports, Transaction( Machinery log entry, Cleaning day
schedule, Authorization) screens. The online system is designed to
track every equipment and other assets that require emergency or
unscheduled maintenance as well as regular preventive maintenance.
The documentation of preventive and unscheduled maintenance data is
specifically designed to provide record retention and trace ability
to assist in achieving the requirements of sugar factory. The system
also provides valuable management information to analyze and
evaluate the effectiveness of the maintenance program, the cost of
equipment maintenance and repair, and the status of all assets of
any period.
7. Security System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2003 Jan 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
Management has decided to computerize the manual work done at
security gate premises and that project had been ntrusted to me.
The following screens comprise the security gate module.
1. Own Vehicle in/out 2. Other vehicle in/out 3. Officer in/out
And 4. Visitors in/out
A brief note on the above screen is given below,
We have around 15 vehicle of our own and they have been utilized for
various purpose viz., to drop/pickup the officials and visitors.
Here the vehicle distance run is tracked. In other vehicle screen
officer in/out entry mobility of the officers of our company is
noted. The visitors who are visiting our company are noted down in
visitors in/out screen.
8. Division Office Computerization
Client Rajshree Sugars & Chemicals Ltd, India
Period Jan 2004 Jun 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
We have 12 division offices for sugarcane procurement and Monitoring
of regular supplies to the factory. We have computerized all
divisions with Oracle Forms as Front end and backend is personal
Oracle. Script for Data transfer from Division Offices and factory
and vice-versa is formulated individually and see to it that no data
is lost on either side.
Database Trigger is written for automatic updating in stock of
fertilizers
Whenever there is inward and issue to other divisions.
Successfully developed Nine entry screens and ten reports.
PERSONAL DETAILS
Name : Anbazhagan Palanisamy
Present Address : #12-308, Bedok North road,
Bedok, Singapore, Pin:460082
Permanent Address : 90, Hudco Colony, 3rd Street
Tatabad, Coimbatore, Tamil Nadu.
Email Id : rp.anbu@gmail.com or
pr_anbu@yahoo.co.in
Marital status : Unmarried
Passport No & Date : E7948154 & 29/01/2014
Mobile Number : +65-96234028
Languages:
Tamil : Read, Write, and Speak
English : Read, Write, and Speak
Telugu : Speak
REFERENCES
1. Mr. Nagaraj Subramanian Singapore
Telephone: +81380680 (Mobile);
Email: subbu_kn2001@yahoo.com
–oHW4CVwrc5nNfGgj9yPsV1xz8rqiXJ50yFTbiyo
–sRrMvZFjx6KghM7330RIbzd-7JIRGBiUIEkhrg-
Anbazhagan.P
Address:
#12-308, Bedok North road, Bedok, Singapore, Pin:460082
Mobile: 65-96234028 E-mail: rp.anbu@gmail.com or pr_anbu@yahoo.co.in
OBJECTIVE
Seeking a position to utilize my skills and abilities in the
Information Technology Industry that offers Professional growth
while being resourceful, innovative and flexible.
To grow professionally, doing processes and routines faster
and smarter.
To work in a team environment, learning and assisting my
coworkers.
SUMMARY
Team Leader with 5.7 years of experience as Database
Developer, including extensive expertise in Oracle PL/SQL
programming, Implementing Client-Server Application Using Oracle
Developer 2000
Having experience in all phases of Data warehousing project
development.
Having experience in developing and maintaining oracle
Database
Extensively used Erwin for data modeling and Dimensional
Data Modeling
EDUCATION / TRAINING / CERTIFICATION
Master degree in Computer Application, Bharathidasan
University, Thiruchirapalli,India (Completed 2001)
Bachelors Degree in Electronics, P.S.G College of Arts And
Science, Bharathiar University, Coimbatore, Tamilnadu, India.
(completed 1998)
Certification NIIT Network Admin
undergone Business Objects Training
TECHNICAL SKILLSET
Computer Languages: Oracle PL/SQL, Shell Scripting
Databases: Oracle 8i/9i/10g, SQL Server 2005.
Database Administration:
Oracle 9i/10g: Database Administration (performance tuning,
Import/Export, Data Loading Using SQL loader), User Management
SQL Server: Import/Export of data using DTS packages
Application Development Tools: Oracle Forms (6i, 5.0, 4.5),
Oracle Reports (2.5,6i), Visual Interdev, FrontPage 2000, Remedy,
SQL Navigator, TOAD, ERWIN
Operating Systems: Windows 95 onwards, AIX Version 5.3, MS-
DOS
Hardware: Troubleshooting computer hardware related issues.
IT INDUSTRY EXPERIENCE
Company: i-flex Solutions Ltd, Bangalore, India.
o Job Title: Associate Consultant
o Job Duration: 25-AUG-2006 Till date
Company: i-GATE Global Solutions, Bangalore, India.
o Job Title: Sr. Software Engineer
o Job Duration: 17-NOV-2004 25-AUG-2006
Company: Sundaram Infotech Solutions limited, Chennai, India
o Job Title: Software Engineer
o Job Duration: 21-JUN-2004 06-NOV-2004
Company: Rajshree Sugars & Chemicals Limited, Coimbatore,
India.
o Job Title: Senior Officer Information Systems
o Job Duration: 30-JUL-2001 16-JUN-2004
DATA WAREHOUSING PROJECTS
1. Reveleus Product
Reveleus is a suite of analytical applications for the financial
services industry focused in the areas of risk management, customer
Analytics product solves the most complex global challenges facing
the financial industry today, including multi-jurisdictional Basel
II compliance and operational risk management.
Involved in development of data extraction and loading
Manual process automation using procedure
Worked in Different databases and created the scripts for
the above related changes.
Handling customer issues and providing solutions.
Understood the functionality, designed the test cases
generation with the Program Specs of the solutions
Performed Load and Performance testing.
2. Business Intelligence Solution
Client lansforsakringar, Sweden
Period Jan 2006 April 2006
Environment Oracle 9i, PL/SQL, SQL Server 2005, Microsoft SSIS,
TOAD
Role Senior Developer
Responsibilities Data Model Design, Backend Object Creation,
Data Extraction and Loading
Brief description of the project:
I was involved the Data warehousing project for lansforsakringar. I
created a procedure to populate the calendar dates for the given
calendar years which is commonly used in data warehousing projects.
This calendar dates will be used in data model tables and I was
responsible for creating backend components like stored procedure,
backend object creation and Defining integrity constraints for the
Data Model.
Client-Server APPLICATION PROJECTS
1. Merchandise Management System (MMS)
Client Metro MGI Informatik GmbH, Germany
Period April 2006 Aug 2006
Environment Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Reports
6i, TOAD and Citrix
Role Senior Developer
Responsibilities Requirment Gathering, Design, Coding,
reviewing and testing
Brief description of the project:
The Merchandise Management System (MMS) at Metro MGI is the single
most important group of applications for the Metro Group as it spans
the entire business operations of the group from the supplier-facing
buying processes to the stores operations at Points of Sale (POS).
The SCM systems are designed to support the Metro C&C, Real and
Extra retail lines, and it is deployed at Metro locations in
multiple countries across the globe. There are multiple products
(like MMS, SCS, IPS etc.) that are available within the SCM
applications and these are deployed depending on the specific
requirements of the locations and their size of operations. When the
products are internationally deployed, they need to be customized
for local language interaction. Each system listed above is made up
of multiple modules interfacing with each other and across other
systems within MMS. The MMS system was developed in-house by MGI for
the Metro AG. Maintain the supplier details, promotions, article
details, sales lines, store details, vendors, manufacturers, order
management etc.
2. After Market Sales Order Management System
Client Cummins, USA
Period Nov 2004 Dec 2005
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, TOAD,
Citrix Program Neighborhood, UNIX
Role Senior Developer
Responsibilities Analysis of requirements based on
the technical specifications and guiding developers for development
of the same
Handling the development/technical issues.
Involved in development, unit testing and review according
to requirement specification
Onsite/offshore coordination
Brief description of the project:
After market Sales Order Management System is the order management
system used at Memphis Distribution System and is used worldwide to
enter and maintain customer orders. ASOMS interfaces, directly with
a warehouse management system to provide complete follow-up on
inventory, orders, shipments, backorders etc. It interfaces with the
requirements planning system for proper materials planning in the
warehouse. The architecture used is client server and the access to
the database and the development tools are through the Citrix server.
3. Asset Management
Client Sundaram Finance Ltd, India
Period Jun 2004 Nov 2004
Environment Oracle 8i Forms 5.0, Reports 3.0, PL/SQL, TOAD
Role Senior Developer
Responsibilities Document Preparation, Table Creation, Screen
Designing, Data Migration
Brief description of the project:
This module consists of 1. Purchase order entry 2. Purchase order
authorization 3.Invoice entry 4.Invoice authorization.
1. PO Entry
All computer accessories purchased in SFL/SIS has an Purchase order
associated with it which contains details about the particular
purchase such as vendor id, quantity, Value, Date of Purchase etc
The Purchase order given to the vendor is also stored in the oracle
system as a long raw column and invoked to the user as a word
document through OLE (Object Linking & embedding).
This project is to store the Purchase Order document separately as
word documents in common NT Folder and not in oracle database.
2. PO Authorization
The PO should be authorized by the super user in the company. He
should convince himself about the details in the PO. Once he feels
it is ok, he can authorize the purchase of the particular asset.
When the super user makes authorization, payment can be released to
the supplier.
3. Invoice Entry
When the payment is made to the supplier, he raises an invoice based
on the PO he has already raised. The user should check whether the
invoice is in sync with the PO that was already raised. If there are
any discrepancies he should immediately highlight it to the
supplier. Once the user satisfies himself, he can enter the invoice
details in the system.
4. Invoice Authorization
The Invoice should be authorized concern department head in the
company.
5. Sugar Cane Management System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2001 Aug 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities FoxPro to Oracle conversion, Payroll, Cane
management Customization
Brief description of the project:
Our client is one of the largest sugar manufacturing companies in
Tamil Nadu. We have been assigned to implement an ERP solution for
sugar factory management. This ERP consist of inventory management,
payroll accounting, cane weighing & crushing management system, cane
pricing management system, cane calendaring system and chemical
laboratory reporting modules.
6. Machinery Maintenance System
Client Rajshree Sugars & Chemicals Ltd, India
Period Aug 2003 Oct 2003
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Creating User, Role and Privileges. Creating
Table space. Table level trigger was Created when data inserting and
updated. Stored procedures were created to Validate null values in
forms
Brief Project Description:
We have a 4500 Mtn crushing capacity factory. Maintenance of the
factory was computerized using oracle and D2K. The machinery
maintenance System is comprised of Masters (Equipment Instrument,
Motor, Gear Box, Valve, Stoppage, Pump, Reason, and Bearing, work
schedule), Reports, Transaction( Machinery log entry, Cleaning day
schedule, Authorization) screens. The online system is designed to
track every equipment and other assets that require emergency or
unscheduled maintenance as well as regular preventive maintenance.
The documentation of preventive and unscheduled maintenance data is
specifically designed to provide record retention and trace ability
to assist in achieving the requirements of sugar factory. The system
also provides valuable management information to analyze and
evaluate the effectiveness of the maintenance program, the cost of
equipment maintenance and repair, and the status of all assets of
any period.
7. Security System
Client Rajshree Sugars & Chemicals Ltd, India
Period Oct 2003 Jan 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
Management has decided to computerize the manual work done at
security gate premises and that project had been ntrusted to me.
The following screens comprise the security gate module.
1. Own Vehicle in/out 2. Other vehicle in/out 3. Officer in/out
And 4. Visitors in/out
A brief note on the above screen is given below,
We have around 15 vehicle of our own and they have been utilized for
various purpose viz., to drop/pickup the officials and visitors.
Here the vehicle distance run is tracked. In other vehicle screen
officer in/out entry mobility of the officers of our company is
noted. The visitors who are visiting our company are noted down in
visitors in/out screen.
8. Division Office Computerization
Client Rajshree Sugars & Chemicals Ltd, India
Period Jan 2004 Jun 2004
Environment Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, SQL
Loader, RetHat Linux 9
Role Developer
Responsibilities Stored Procedure was created to
validate year
Designing and Testing Forms & Reports
Documentation (SRS, SDD) Preparation
Brief Project Description:
We have 12 division offices for sugarcane procurement and Monitoring
of regular supplies to the factory. We have computerized all
divisions with Oracle Forms as Front end and backend is personal
Oracle. Script for Data transfer from Division Offices and factory
and vice-versa is formulated individually and see to it that no data
is lost on either side.
Database Trigger is written for automatic updating in stock of
fertilizers
Whenever there is inward and issue to other divisions.
Successfully developed Nine entry screens and ten reports.
PERSONAL DETAILS
Name : Anbazhagan Palanisamy
Present Address : #12-308, Bedok North road,
Bedok, Singapore, Pin:460082
Permanent Address : 90, Hudco Colony, 3rd Street
Tatabad, Coimbatore, Tamil Nadu.
Email Id : rp.anbu@gmail.com or
pr_anbu@yahoo.co.in
Marital status : Unmarried
Passport No & Date : E7948154 & 29/01/2014
Mobile Number : +65-96234028
Languages:
Tamil : Read, Write, and Speak
English : Read, Write, and Speak
Telugu : Speak
REFERENCES
1. Mr. Nagaraj Subramanian Singapore
Telephone: +81380680 (Mobile);
Email: subbu_kn2001@yahoo.com
–sRrMvZFjx6KghM7330RIbzd-7JIRGBiUIEkhrg-
–EwyEj62NZfmyE3YnBuQFqN0sxr6Amqd1dPnns-D
Hi,
I am looking for 1+1/2+1 HDB from September 1st 2007. I am bringing my family from india.
Preferred areas*
NS Line: Between Marina Bay to Novena
EW Line: Any where in east west line.
NE Line: Between HarbourFront to Serangoon
Requirements*
Preferably near to MRT (Max 10 mins walk is Okay)
Rent between 900SGD to 1100SGD
Please Contact me*
Call me @ 63282468
SMS me @ 81848678
Mail me @ nnv_sivaprasad@ yahoo.co. in
*** It would be great help, if any one is refer me to House owners / Agents.
Thanks in advance.
Regards.
N.N.V Siva Prasad
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/
[Non-text portions of this message have been removed]
–EwyEj62NZfmyE3YnBuQFqN0sxr6Amqd1dPnns-D
–2Md9wrovCXcnAeuYfmIRMbBq0vMDnNB5MZePKAS
Hi,
I am looking for 1+1/2+1 HDB from September 1st 2007. I am bringing my family from india.
Preferred areas*
NS Line: Between Marina Bay to Novena
EW Line: Any where in east west line.
NE Line: Between HarbourFront to Serangoon
Requirements*
Preferably near to MRT (Max 10 mins walk is Okay)
Rent between 900SGD to 1100SGD
Please Contact me*
Call me @ 63282468
SMS me @ 81848678
Mail me @ nnv_sivaprasad@ yahoo.co. in
*** It would be great help, if any one is refer me to House owners / Agents.
Thanks in advance.
Regards.
N.N.V Siva Prasad
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/
[Non-text portions of this message have been removed]
–2Md9wrovCXcnAeuYfmIRMbBq0vMDnNB5MZePKAS
–APBY6gyZ7diaXwJigX1z0mlqJYABn18jrmkK0iI
Hi all,
Plz let me know anyone will do onsite monitor (CRT) Service. I have
two monitor for services. Interest person call, Charif Hp: 9634 5850
Regards,
Charif
[Non-text portions of this message have been removed]
–APBY6gyZ7diaXwJigX1z0mlqJYABn18jrmkK0iI
–pdynQXHYTMtL88o0Ed8Cnsgn5UBZ227glmCugbV
Dear All,
Electronic & Electrical Products Servicing , Network installation
and Maintains & New Software Installation .
Video cassettes , DV cassettes to VCD & DVD conversion, Digital
conversion, video editing
Audio cassettes convert to vcd/Mp3/audio cd/ any of one the format is
possible.
*****Reasonable Service Charge******
At your Convent Time, I will Come to your place solve the system
problem.
If u like give me your contact details so that I can call U.
Email: it_muthu@yahoo.com.sg
H.P - 81696236
Thanks.
Regards
Muthu
–pdynQXHYTMtL88o0Ed8Cnsgn5UBZ227glmCugbV
–XXp-2t-FdAfnPbxhA6g7WWZjUFXf2kDPkI03JUp
We are currently looking for Software Developers with following skills & experience for one of the project with our Banking client. Interested candidates are requested to submit their resume in wordformat with the details on their availability upon confirmation, current salary & expectation to discuss further.
Positions Available : Developer positions (2)
Location: Singapore.
Skills required:
At least 3 to 5 years of development experience in IT
Must have experience in VB & Actuate Reporting.
Should have experience in Sybase
Working knoweldge in tools like Clearcase & ClearQuest
Must have exposure working in Windows and unix enviorment
Thanks & Regards,
Sheryl
Technical Recruiter
———————————
Real people. Real questions. Real answers. Share what you know.
[Non-text portions of this message have been removed]
–XXp-2t-FdAfnPbxhA6g7WWZjUFXf2kDPkI03JUp
–3TwhwcgWHqjzzccOz8jQ6k3eGEdao0yP0MuRjxc
Hi All,
“Greetings”
We are currently looking for Embedded Developers with following skills & experience for one of the project with our MNC client in Singapore. Interested candidates are requested to submit their resume in wordformat with the details on their availability upon confirmation, current salary & expectation to discuss further. Appreciate your early response on this.
Positions Available : Senior Developer(2) & Developer positions (3)
Location: Singapore.
Skills required:
At least 3 to 4 years of firmware/software driver/application design experience, preferably in the implementation of wireless products
Degree/Master in Electrical/Electronics or Computer Engineer
Previous experience in developing embedded Operating System application software such as VxWorks, pSOS, ucLinux and good knowledge of C/C++/ assembly language
A good understanding of Bluetooth stack, Bluetooth profiles, and wireless protocols for WiFi, RFID and USB 2.0 is desirable
Ability to work independently or as a team and take responsibility of assignments
Responsibilities:
To provide software design/coding/testing of advanced Bluetooth /WiFi / RFID /GPS multimedia modules and products
To involve in implementation of embedded software and Windows software applications and drivers based on project requirements
To work closely with electronics designers to ensure that efficient system solutions are implemented for the products.
Thanks & Regards,
Sheryl
Technical Recruiter
———————————
Yahoo! Movies - Search movie info and celeb profiles and photos.
[Non-text portions of this message have been removed]
–3TwhwcgWHqjzzccOz8jQ6k3eGEdao0yP0MuRjxc