System Analyst
Satyam Computer Services Ltd
مجموع سنوات الخبرة :15 years, 0 أشهر
Satyam Computer Services Ltd System Analyst Jun 2005 - till date
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2010 - till date
Environment Sun Solaris, HP-UNIX, Linux Oracle 9i, oracle 10g,
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Data refresh, Duplication, Upgrade, patching, Backup Monitoring, Data Guard and RAC support activities.
Providing database Support at different regions, Development, UAT and Production databases.
Role Support to Developers
Organization Satyam Computer Services Ltd.
Duration 02/2008 - 04/2008
Environment Sun Solaris, Oracle 9i
Project description
Sony has developed application that helps users to find the product and distributors information.
Contribution
• Performance tuning and troubleshooting general Database problems in all instances.
• Helps users to write PL/SQL and SQLs.
• Report generation using shell scripts
Organization Designation Duration
Satyam Computer Services Ltd System Analyst Jun 2005 - till date
Cognizant Technology Solution Pvt Ltd. Technical Consultant (Contract) Mar -2005 - May 2005
CodeReflex Technologies Pvt Ltd Database Administrator Mar 2004 - Mar 2005
Brukrs Technologies Programmer Jun 2002 - Feb 2004
MC Ranganathan & Co Audit Assistant Sep 1996 - May 1999
Project Profiles
10. Project Name: Data Assets
Client Chevron, USA
Organization Designation Duration
Satyam Computer Services Ltd System Analyst Jun 2005 - till date
Cognizant Technology Solution Pvt Ltd. Technical Consultant (Contract) Mar -2005 - May 2005
CodeReflex Technologies Pvt Ltd Database Administrator Mar 2004 - Mar 2005
Brukrs Technologies Programmer Jun 2002 - Feb 2004
MC Ranganathan & Co Audit Assistant Sep 1996 - May 1999
Project Profiles
10. Project Name: Data Assets
Client Chevron, USA
Organization Designation Duration
Satyam Computer Services Ltd System Analyst Jun 2005 - till date
Cognizant Technology Solution Pvt Ltd. Technical Consultant (Contract) Mar -2005 - May 2005
Role Team Member
Organization Cognizant Technology Solution Pvt Ltd, India
Duration (03/2005) - (05/2005)
Team Size Project: Module: Environment
(with skill versions)
Software
Database: ORACLE 10g
Tools: SQL Loader
O/s: HP-UNIX
Hardware
Project Description
This is migration project. The database is upgraded to ORACLE 9i to ORACLE 10g. Data are extracted into CSV format from Oracle9i database. This will be loaded Oracle 10g database using SQL Loader. All Procedures that are run in Oracle 9i should tested against Oracle 10g.
Contribution
This is testing against Oracle 10g. He identifies the obsolete function in ORACLE 10g. Bug fixing and find out the functions that are not supported by Oracle 10g but supported by Oracle 9i are major role. (For example, Rule based Optimizer supported by Oracle 9i but not by Oracle 10g)
As a team member, was responsible for
• Testing - unit testing
• Bug fixing
4. Project Name: SytemCode.NET
Client Afco International, France
CodeReflex Technologies Pvt Ltd Database Administrator Mar 2004 - Mar 2005
Role Database Administrator
Organization CodeReflex Technologies Pvt Ltd.
Duration (03/2004) - (05/2004)
Team Size Project: Module: Database
Environment
(with skill versions)
Software
Database: ORACLE 8i
Tools: Visual Basic.NET, Ultrawintree, Devcomponents,
Lex and Yacc
O/s: Windows 2000
Hardware Intel Pentium 4
Project Description
This project is to develop an Application Mining tool, SystemCode.NET, using Microsoft.NET Technologies. SystemCode.NET is an application mining tool which helps to create a repository of source code written in various legacy and modern languages. This repository can be then used to provide a reference point to maintain, migrate, understand, and transform both legacy and modern applications. This repository also serves to identify, create and extract business rules and ETL process. Application mining has been described as doing for developers what data mining does for business analysts.
Contribution
As a Database Architect, I was responsible for designing of database, Stored Procedures, creating views and database maintenance works like exp/imp, database tuning.
As a database Administrator, was responsible for
• creates database, tablespace, users, profiles, Roles, export and import data.
• Sizing indexes and tables
• Table Re-organization and Index rebuilding
• Management of physical storage of a database. This includes properly management of TABLESPACE, DATAFILES, REDO-LOG FILE.
• Export/Import
3. Project Name: StockTrack
Client Singapore Komalas, Chennai and Singapore
Role Database Designer
Organization Brukrs Technologies
Duration (11/2003) - (03/2004)
Team Size Project: Module: Database
Environment
(with skill versions)
Software
Database: ORACLE 8i
Tools: Mircosoft VB 6.0
O/s: Windows 2000
Hardware Intel Pentium 3
Project Description
This Software used for to maintain the stock of the stores. Stock information maintained at two places - Central Stores and Kitchen. There is option for manual and automated Purchase order. Alert will be given when the stock reaches Reorder level and at danger level. Options available for Purchase return. Issues made to kitchen will reduce the stock Level.
Contribution
As a Database Architect, I was responsible for designing of database, stored procedures, creating views.
As a database Designer, was responsible for
As a database Administrator, was responsible for
• creates database, tablespace, users, profiles, Roles, export and import data.
• Sizing indexes and tables
• Table Re-organization and Index rebuilding
• Management of physical storage of a database. This includes properly management of TABLESPACE, DATAFILES, REDO-LOG FILE.
• EXPORT/IMPORT
Projects Profile
2. Project Name: ElCare
Brukrs Technologies Programmer Jun 2002 - Feb 2004
Client Electrocare Systems and Services Pvt Ltd, Chennai, India
Role Database Designer
Organization Brukrs Technologies
Duration (07/2003) - (10/2003)
Team Size Project: Module: Database
Environment
(with skill versions)
Software
Database: ORACLE 8i
Tools: Mircosoft VB 6.0
O/s: Windows 2000
Hardware Intel Pentium 3
Project Description
This software cares on order processing and suspense issues to sales representatives. Order processing include from proforma to invoicing. A production module focuses executing order and installation. Stores module contains maintaining the stock-level. Suspense issues can be used to trace exact tracing of specific items. Payment follow-ups have collecting the amount from their customers.
Contribution
As a Database Architect, I was responsible for designing of database, stored procedures, creating views.
As a database Designer, was responsible for • Database Design
• Stored procedures
Projects Profile
1. Project Name: NaveenERP
Client Naveen Alarm System Pvt (India) Ltd, Chennai, India
Role Database Designer
Organization Brukrs Technologies
Duration (12/2002) - (06/2003)
Team Size Project: Module: Database
Environment
(with skill versions)
Software
Database: ORACLE 8i
Tools: Mircosoft VB 6.0
O/s: Windows 2000
Hardware Intel Pentium 3
Project Description
This is complete atomization of the company. This software consists of Marketing, Production, Stores, HR and Payment follow-ups. It also analyzes creditor (supplier), debtor (customer), cash-flow and stock-in-hand (ABC analysis)
Contribution
As a Database Architect, I was responsible for assisting for database design, stored procedures and creating views.
As a database Designer, was responsible for • Installed & Managed on Windows NT
• Database creation according the customer requirements.
• Creating the required TABLESAPCES, USERS and ROLES for the application.
• Implement and managed TNS Names.
• Installed and configured and managed clients using Net 8.
• Design and implementation of backup strategy for an ARCHIVELOG DATABASE. Regularly testing of a backup data, perform a scheduled backup using NT's integrated backup system.
• Monitoring Database tables and system catalogs with respect to overflows and appropriate storage structure based on the nature of queries on this table.
• SQL Tuning using Explain plans, SQL Trace utility, so maximum through put should be obtained at any movement of time.
MC Ranganathan & Co Audit Assistant Sep 1996 - May 1999
Project Profiles
10. Project Name: Data Assets
Client Chevron, USA
Organization Designation Duration
Satyam Computer Services Ltd System Analyst Jun 2005 - till date
Cognizant Technology Solution Pvt Ltd. Technical Consultant (Contract) Mar -2005 - May 2005
CodeReflex Technologies Pvt Ltd Database Administrator Mar 2004 - Mar 2005
Brukrs Technologies Programmer Jun 2002 - Feb 2004
MC Ranganathan & Co Audit Assistant Sep 1996 - May 1999
Project Profiles
10. Project Name: Data Assets
Client Chevron, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2010 - till date
Environment Sun Solaris, HP-UNIX, Linux Oracle 9i, oracle 10g,
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Data refresh, Duplication, Upgrade, patching, Backup Monitoring, Data Guard and RAC support activities.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: CitiGroup -EFG (Equipemt Finance group)
Client Citi Bank, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2008 - 04/2010
Environment Sun Solaris, Oracle 9i, oracle 10g, Oracle apps (finance, Portal)
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Involved in the DB Administration for various applications. This requires specialized knowledge of the CITIGROUP databases and its associated objects.
Interfacing with the different application managers of CITIGROUP, understanding the concerns and issues that have been raised and closing them at the earliest depending on the priorities
Monitoring Oracle databases and working on increasing the performance of the databases.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: SONY-Jeff Dean
Client SONY, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2010 - till date
Environment Sun Solaris, HP-UNIX, Linux Oracle 9i, oracle 10g,
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Data refresh, Duplication, Upgrade, patching, Backup Monitoring, Data Guard and RAC support activities.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: CitiGroup -EFG (Equipemt Finance group)
Client Citi Bank, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2008 - 04/2010
Environment Sun Solaris, Oracle 9i, oracle 10g, Oracle apps (finance, Portal)
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Involved in the DB Administration for various applications. This requires specialized knowledge of the CITIGROUP databases and its associated objects.
Interfacing with the different application managers of CITIGROUP, understanding the concerns and issues that have been raised and closing them at the earliest depending on the priorities
Monitoring Oracle databases and working on increasing the performance of the databases.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: SONY-Jeff Dean
Client SONY, USA
Role Support to Developers
Organization Satyam Computer Services Ltd.
Duration 02/2008 - 04/2008
Environment Sun Solaris, Oracle 9i
Project description
Sony has developed application that helps users to find the product and distributors information.
Contribution
• Performance tuning and troubleshooting general Database problems in all instances.
• Helps users to write PL/SQL and SQLs.
• Report generation using shell scripts
8. Project Name: PANDA
Client Ford Motor Company
Role Production support and administration of Oracle databases
Organization Satyam Computer Services Ltd.
Duration 09/2007 - 2/2008
Environment Sun Solaris, Linux Red hat, Windows 2000, Oracle 9iAS release 2, Oracle 9i and iplanet Web server
Project description
PANDA-Parts AND Accessories-an warehouse application for FORD was redeveloped from COBOL-UNISYS to Oracle and forms/reports on a LAN environment and is currently running in six markets (Malaysia-MY, Philippines-PH, South Africa-ZA, New Zealand-NZ, China-CN, Thailand-TH) . At present the PandaLite is running on a Client Server platform with Oracle forms as the GUI front end and Oracle as the database.
Contribution
• Administration of Oracle database and application server for all Asia pacific markets
• Work with Oracle Support to solve any critical issues in Oracle databases and 9i Application server on production and development environment.
• Table Re-organization and Index rebuilding.
• Performance tuning and troubleshooting general Database problems in all instances.
• Monitoring Database tables and system catalogs with respect to overflows and appropriate storage structure based on the nature of queries on this table.
• Creating and maintaining log for any issues in Production, QA and Development environments
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2010 - till date
Environment Sun Solaris, HP-UNIX, Linux Oracle 9i, oracle 10g,
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Data refresh, Duplication, Upgrade, patching, Backup Monitoring, Data Guard and RAC support activities.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: CitiGroup -EFG (Equipemt Finance group)
Client Citi Bank, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2008 - 04/2010
Environment Sun Solaris, Oracle 9i, oracle 10g, Oracle apps (finance, Portal)
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Involved in the DB Administration for various applications. This requires specialized knowledge of the CITIGROUP databases and its associated objects.
Interfacing with the different application managers of CITIGROUP, understanding the concerns and issues that have been raised and closing them at the earliest depending on the priorities
Monitoring Oracle databases and working on increasing the performance of the databases.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: SONY-Jeff Dean
Client SONY, USA
Role Support to Developers
Organization Satyam Computer Services Ltd.
Duration 02/2008 - 04/2008
Environment Sun Solaris, Oracle 9i
Project description
Sony has developed application that helps users to find the product and distributors information.
Contribution
• Performance tuning and troubleshooting general Database problems in all instances.
• Helps users to write PL/SQL and SQLs.
• Report generation using shell scripts
8. Project Name: PANDA
Client Ford Motor Company
Role Production support and administration of Oracle databases
Organization Satyam Computer Services Ltd.
Duration 09/2007 - 2/2008
Environment Sun Solaris, Linux Red hat, Windows 2000, Oracle 9iAS release 2, Oracle 9i and iplanet Web server
Project description
PANDA-Parts AND Accessories-an warehouse application for FORD was redeveloped from COBOL-UNISYS to Oracle and forms/reports on a LAN environment and is currently running in six markets (Malaysia-MY, Philippines-PH, South Africa-ZA, New Zealand-NZ, China-CN, Thailand-TH) . At present the PandaLite is running on a Client Server platform with Oracle forms as the GUI front end and Oracle as the database.
Contribution
• Administration of Oracle database and application server for all Asia pacific markets
• Work with Oracle Support to solve any critical issues in Oracle databases and 9i Application server on production and development environment.
• Table Re-organization and Index rebuilding.
• Performance tuning and troubleshooting general Database problems in all instances.
• Monitoring Database tables and system catalogs with respect to overflows and appropriate storage structure based on the nature of queries on this table.
• Creating and maintaining log for any issues in Production, QA and Development environments
7. Project Name: Lead Fulfillment Operations
Client General Motors
Role DBA
Organization Satyam Computer Services Ltd, Chennai
Duration (11/2005 - 08/2007)
Environment (with skill versions) Software Database: ORACLE 10g Tools: SQL*Loader, TOAD, ERWIN, Oracle Configurator O/s: SUN SOLARIS 5.9
Project Description
Lead fulfillment is CRM strategy. Lead fulfillment operations include the business processes and systems involved in sensing and responding to consumers which indicate an interest in GM products and services in order to maximize sales opportunities.
Contribution
• Installation of Oracle software on server and client machines and setting up client-server connectivity.
• Managing database instance, data files and log files.
• Provide database administration functions includes logical backup is taken using Export ( DataPump) utility
• Creation of associated database objects including tables, indexes, views etc.,
• Writing stored procedure and Functions.
6. Project Name: Customer Centricity
Cognizant Technology Solution Pvt Ltd. Technical Consultant (Contract) Mar -2005 - May 2005
CodeReflex Technologies Pvt Ltd Database Administrator Mar 2004 - Mar 2005
Brukrs Technologies Programmer Jun 2002 - Feb 2004
MC Ranganathan & Co Audit Assistant Sep 1996 - May 1999
Project Profiles
10. Project Name: Data Assets
Client Chevron, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2010 - till date
Environment Sun Solaris, HP-UNIX, Linux Oracle 9i, oracle 10g,
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Data refresh, Duplication, Upgrade, patching, Backup Monitoring, Data Guard and RAC support activities.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: CitiGroup -EFG (Equipemt Finance group)
Client Citi Bank, USA
Role DBA
Organization Satyam Computer Services Ltd.
Duration 05/2008 - 04/2010
Environment Sun Solaris, Oracle 9i, oracle 10g, Oracle apps (finance, Portal)
Contribution
Providing 24*7 DBA support and call support as and when required depending on the project requirement.
Involved in the DB Administration for various applications. This requires specialized knowledge of the CITIGROUP databases and its associated objects.
Interfacing with the different application managers of CITIGROUP, understanding the concerns and issues that have been raised and closing them at the earliest depending on the priorities
Monitoring Oracle databases and working on increasing the performance of the databases.
Providing database Support at different regions, Development, UAT and Production databases.
9. Project Name: SONY-Jeff Dean
Client SONY, USA
Role Support to Developers
Organization Satyam Computer Services Ltd.
Duration 02/2008 - 04/2008
Environment Sun Solaris, Oracle 9i
Project description
Sony has developed application that helps users to find the product and distributors information.
Contribution
• Performance tuning and troubleshooting general Database problems in all instances.
• Helps users to write PL/SQL and SQLs.
• Report generation using shell scripts
8. Project Name: PANDA
Client Ford Motor Company
Role Production support and administration of Oracle databases
Organization Satyam Computer Services Ltd.
Duration 09/2007 - 2/2008
Environment Sun Solaris, Linux Red hat, Windows 2000, Oracle 9iAS release 2, Oracle 9i and iplanet Web server
Project description
PANDA-Parts AND Accessories-an warehouse application for FORD was redeveloped from COBOL-UNISYS to Oracle and forms/reports on a LAN environment and is currently running in six markets (Malaysia-MY, Philippines-PH, South Africa-ZA, New Zealand-NZ, China-CN, Thailand-TH) . At present the PandaLite is running on a Client Server platform with Oracle forms as the GUI front end and Oracle as the database.
Contribution
• Administration of Oracle database and application server for all Asia pacific markets
• Work with Oracle Support to solve any critical issues in Oracle databases and 9i Application server on production and development environment.
• Table Re-organization and Index rebuilding.
• Performance tuning and troubleshooting general Database problems in all instances.
• Monitoring Database tables and system catalogs with respect to overflows and appropriate storage structure based on the nature of queries on this table.
• Creating and maintaining log for any issues in Production, QA and Development environments
7. Project Name: Lead Fulfillment Operations
Client General Motors
Role DBA
Organization Satyam Computer Services Ltd, Chennai
Duration (11/2005 - 08/2007)
Environment (with skill versions) Software Database: ORACLE 10g Tools: SQL*Loader, TOAD, ERWIN, Oracle Configurator O/s: SUN SOLARIS 5.9
Project Description
Lead fulfillment is CRM strategy. Lead fulfillment operations include the business processes and systems involved in sensing and responding to consumers which indicate an interest in GM products and services in order to maximize sales opportunities.
Contribution
• Installation of Oracle software on server and client machines and setting up client-server connectivity.
• Managing database instance, data files and log files.
• Provide database administration functions includes logical backup is taken using Export ( DataPump) utility
• Creation of associated database objects including tables, indexes, views etc.,
• Writing stored procedure and Functions.
6. Project Name: Customer Centricity
Client Royal Bank of Trinidad and Tobago.
Role Team Member
Organization SCSL
Duration (06/2005) - (09/2005)
Team Size Project: Module: Environment
(with skill versions)
Software
Database: ORACLE 9i
Tools: SQL*Loader, TOAD, ERWIN
O/s: WINWDOWS
Hardware
Project Description
The customer information from different system (internet, Telephone and mutual fund) will be combined into single system to have single point access.
Contribution
As a team member, was responsible for
• Creation of associated database objects including tables, indexes, views etc.,
• Performance tuning and troubleshooting general Database problems.
• Writing stored procedure and Functions.
5. Project Name: ORACLE 10g Upgrade
Client IMS, USA