Technical Solutions Architect
Posted by on May 31, 19103 at 15:10:07:
R. Balasubramanian
E-mail: rbs100@indiatimes.com
Ph: 91-044-22418632
STRENGTHS
§ Strong in Oracle 7.3/8I DBA
§ Strong in Oracle 8I PL/SQL programming
§ Strong in Oracle 8I DBA
§ SAP Basis Administration and SAPDBA
§ Good team player
§ Good communication and interpersonal skills
EXPERIENCE
Ø Around 9 years of experience in Oracle 7.3,8I DBA, PL/SQL programming and D2k Programming
Ø Worked in ERP environment
Ø Having onsite and offshore experience
Ø Worked with different industries like Non Banking, Banking, Manufacturing, Printing and Insurance
Ø Have capability to lead a team.
Ø Have experience in Managing and implementing a project in different locations
Technical Lead
Polaris Software Lab Chennai- INDIA (Sep 1999–till date)
§ Working in Oracle 8I DBA, PL/SQL programming.
§ Providing end-to-end client solutions from Offshore to onsite.
§ Has international experience
Systems Executive (Software Development and Administration)
Macmillan India Ltd, Chennai- INDIA (Feb 1999–Aug 1999)
§ Responsible for Systems and Database Administration and Development activities for the Press
§ Lead a team
Systems Officer (ERP Implementation)
Carborundum Universal Chennai - TN, INDIA (Jul 1998–Feb 1999)
§ Implemented ERP called Ramco Marshals in different locations
§ Lead a team during implementation
§ Administered SQL Server 6.5 Database and Windows NT
§ Migrated ERP from SQL Server 6.0 to 6.5
Systems In charge (Southern Region)
Ceat Financial Services Ltd., Chennai - TN, INDIA (Mar 1995–Jun 1998)
§ Taken Care of Southern Region consisting of Chennai, Hyderabad, Bangalore, Coimbatore and Madurai
§ Lead a team of 5
§ Responsible for Development and Administration of Oracle 7.3, Windows NT 4.0, Novell Netware, AT&T Unix and Developer 2000
§ Responsible for implementation of the software developed at the branches
Programmer (Software Development)
Madras Motor Financial Guarantee Co. Ltd. Chennai - TN, INDIA (May 1994–Mar 1995)
§ Involved in development of software in Form3.0
§ Good team player
TECHNICAL SKILLS
Operating Platforms
Unix (on Sun-Solaris 5.0, AT&T Unix), MS-DOS, Windows 2000/NT
Novell Netware
RDBMS and Database Management
Oracle 7.3, Oracle 8I, PL\SQL, SQL Server 6.5, T-SQL, SAP DBA
Networks and Networking Protocols
NT Networking, Novell NetWare 3.11 and 4.0
Development Tools & Languages
Developer 2000, Seagate Crystal Reports, Actuate Report Writer, Pro-c
ERP
Ramco Marshals, SAP Basis Administration
Certifications
§ Pursuing 2 more papers of Oracle Certification for Oracle 8I database (OCP 8I) to get OCP 8I Certified.
Projects Undertaken
Polaris Software Lab-Chennai-TN- India
Senior Database Administrator (Mar ’02 –Till Date)
Client: AIG-Sun America
Role in the Project
My responsibilities in the project include database administration for development, Testing and Production database of our client AIG-Sun America and PL/SQL programming. Leading a team of two people
Operating Environment and Development Tools
Oracle 8I, SAP DBA
Description
§ First line database support administrator responsible for continued availability of production, testing and development databases.
§ Worked in Onsite at Los-Angeles – CA -USA
§ Database creation and maintenance
§ Database Refresh
§ Performance Tuning.
§ Network Administration
§ Monitor and tune performance using the various tools of oracle like Oracle Enterprise Manager, Explain Plan, etc.
§ User security and administration.
§ SQL tuning with Explain Plan
§ Optimization of SQL statements using explain plan
§ Extensive use of SQL and PL/SQL in writing stored procedures, database packages, views, Database Triggers and Materialized Views.
§ Writing optimized queries, creating indexes b-tree, bitmap, function based indexes
§ Used Materialized Views, database links, triggers
§ Managing multiple databases of 12 at the same time
§ Handling large volumes of data with database size ranging from 10 GB to 40 GB
§ Suggesting improvements for easy management and Performance tuning of database
§ Guiding developers to write good SQL
Database Administrator- Feb 01 – Jan 02
Client: Nippon Electric Company
Role in the Project
My responsibilities in the project include Database Administration
Operating Environment and Development Tools
Oracle 8I, PL/SQL, Sun Solaris
Description
§ Writing optimized queries, creating indexes
§ Creating Stored Packages and procedures for easy monitoring of Database
§ First line database support administrator responsible for continued availability of testing and development databases.
§ Backup and recovery
§ Monitoring storage and shrinking and reallocating the data files
§ Performance Tuning.
§ Network Administration
§ Monitor and tune performance using the various tools of oracle like Explain Plan, virtual v$ tables, etc.
§ User security and administration.
§ SQL tuning with Explain Plan
§ Optimization of SQL statements using explain plan
§ Extensive use of SQL and PL/SQL in writing stored procedures, database packages, views
§ Writing optimized queries, creating indexes
Lead Developer (May ’00 – Dec ’00)
Client: Nationwide Global Holdings-Dublin-Ohio-USA
Module: Refunds
Role in the Project
My responsibilities in the project include Solution Modeling, Impact Analysis, requirement gathering and development of upcoming enhancements and leading a team of 1.
Operating Environment and Development Tools
Oracle 8, PL/SQL
Amarta Toolset, Sun Solaris 5.0, Windows NT
Description
§ Leading a small team for refunds module
§ Writing stored packages and stored procedures.
§ Created business rules, Lear, functions, Logical, modules, etc.
§ Writing stored packages and stored procedures.
§ Built complete lifecycle
§ Tested the lifecycle using LCSIM tool
§ Partially involved in Solution modeling.
§ Writing stored packages and stored procedures.
§ Appreciated by the client for outstanding performance.
Database Administrator (Dec’99 – APR ‘00)
Client: Citi Bank Chennai-TN, INDIA
Role in the Project
Responsible for Backup & Recovery, refreshing of Database and reorganizing the data files.
Operating Environment and Development Tools
Oracle 7.3, Oracle 8.0, Sun Solaris 5.0
Description
§ Backup the database
§ Refreshing of Testing Database from Production
§ Monitoring the storage and resizing, relocating of data files, adding a data file if necessary.
§ Monitoring the users
§ Monitoring the process and the load
§ Creating and restring the users
Lead Developer: (Oct 99-Dec 99)
Product: Nterprise
Role in the Project
Involved in high level design and development of Sales Order Module
Operating Environment & Development Tools
Developer 2000(Forms 5.0, Reports 3.0), Windows NT 4.0
Description
Sales Order System is a sub product for a product called Nterprise for Supply chain stores. This module will address the need for a Sales Order System It will take care of gamut of Order activities
§ Analyze the requirements
§ Create design documents
§ Lead the team
* Developed the system
Company: Macmillan India Ltd.
Systems Executive (Feb 99 – Sep 99)
Role in the Project
My responsibilities included Installing of Windows NT, Installing of Oracle and Administration of NT and Oracle Database, leading a team of four people, developing and delivering system for the management of press.
Operating Environment & Development Tools
Oracle 8, Developer 2000(Forms 5.0 and Reports 3.0), Windows NT 4.0
Description
Print order system is to cater the day to day needs of the press to track the orders, printing and movement of books, keeping tracks of accounts and cater the need for the management to know the inventory of the books printed and to be printed based on the ISBN.
§ Gathering user requirements
§ Analyze the requirements
§ Creating design documents
§ Lead the team
§ Prepare and Install the Operating Systems
§ Create the Database
§ Create the Schemas
§ Maintenance of database
Company- Carborundum Universal Ltd
Systems officer (Jul 98 – Feb 99)
Role in the Project
As Implementation specialist, I was responsible for implementing the ERP System at various branches like Chennai, Cochin and Palakkad. Which required to tailor the ERP to need of the Company and develop code and reports and design extra screens for the user requirements and administer and tune the SQL Server system for the future space management and speed.
Operating Environment & Development Tools
Ramco Marshall (ERP), SQL Server 6.5, Seagate Crystal Reports 7.0, Windows NT
Description
Ramco Marshall is a ERP developed by Ramco Systems - Chennai, consists of several modules like General Ledger, Sales Ledger, Accounts Receivable, Accounts Payable, Human Resources, Payroll etc. integrated together to cater all the needs of the company at various places.
§ Gathering user requirements
§ Analyze the requirements
§ Guide the team
§ Configure the OS
§ Configure the database
§ Map the system to the User requirements
§ Prepare Test Cases
§ Get User approval
§ Implement the system
Company: Ceat Financial Services Ltd.-Chennai-TN- India
Systems In Charge-Southern Region (Oct 1997-May 1998)
Project: Hire Purchase and Leasing System
Role in the Project
As a person in charge for the southern region, I was responsible for Analysis, Design. Development, Administration (OS&DB) and implementation of the system and Database based on the user requirements and the feedback. Responsible for managing the systems department of Southern region of the Company in India, which had branches in Madurai, Coimbatore, Bangalore and Hyderabad , having Regional office at Chennai. Providing end-to-end technical solutions between the regions.
Operating Environment & Development Tools
Oracle 7.3, D2k,Pro C, AT&T Unix, Windows NT, Win 95
Description
Hire Purchase & Leasing System takes care of Hire purchase and leasing business for the Company starting from customer master to IRR calculations and EMI Calculations and gives analytical details like aging and gives all kinds of MIS Reports at finger tips. It provided the tracking of marketing information and collection done by each executive and pending collection to be done and giving report for each customer, marketing executive.
§ Gathering user requirements
§ Analyze the requirements
§ Guide the team
§ Configure the OS
§ Create the database
§ Configure the database
§ Maintain the database
§ Maintain the OS
§ Get User approval
§ Implement the system
§ Maintain the system
Systems In Charge-Southern Region (Jun ‘96-Sep 97)
Project: Limit monitoring System
Role in the Project
I was responsible for Analysis, Design, Development, Administration (OS&DB) and implementation of the system and Database based on the user requirements and the feedback. Responsible for managing the systems department of Southern region of the Company in India, which had branches in Madurai, Coimbatore, Bangalore and Hyderabad, having Regional office at Chennai.
Operating Environment & Development Tools
Oracle 7.3, D2k, AT&T Unix, Windows NT, Win 95
Description
Limit Monitoring System takes care of Limits for each employee regarding his medical bill, HRA, vehicle allowance, etc.
§ Gathering user requirements
§ Analyze the requirements
§ Guide the team
§ Configure the OS
§ Create the database
§ Configure the database
§ Maintain the database
§ Maintain the OS
§ Get User approval
§ Implement the system
Analyst Programmer (Jun ‘95-Apr ‘96)
Project: Fixed Deposit System
Role in the Project
Initially I was responsible for Analysis, Design, Development, Administration (OS&DB) and implementation of the system and Database based on the user requirements and the feedback. Near to the end of the project, based on my performance and leadership capabilities, I was promoted to be in charge of the systems department of the entire southern region, which consisted of Hyderabad, Bangalore and Regional Office at Chennai. Later stage Madurai and Coimbatore was added to the Southern Region.
Operating Environment & Development Tools
Oracle 7.x, D2k, Pro C, AT&T Unix, Windows NT, Win 95
Description
This system takes care of fixed Deposit requirements, which includes Application Processing, Modification of Fixed Deposits, Fixed Deposit printing, Warrant Generation, Warrant Printing, Various Tax calculations, Statements for Customer, Broker, Banks, Tax, Periodical reports, etc. This was developed using D2k, Pro C under Oracle 7.3 environment Initial development started in Forms 3.0 in Unix environment and later migrated to D2k and entire development was done in Developer 2000.
§ Gathering user requirements
§ Analyze the requirements
§ Guide the team
§ Configure the OS
§ Create the database
§ Configure the database
§ Maintain the database
§ Maintain the OS
§ Get User approval
§ Implement the system
Company: Madras Motor Finance Guarantee Co. Ltd
Programmer (May 94 - Mar 95)
Project: Financial Accounts
Role in the Project
I was part of Development team and also done testing for the system.
Operating Environment & Development Tools
Oracle 7.x, AT&T Unix and Forms 3
Description
Financial Accounts takes care of the company’s Ledger details, petty cash details, Trail Balance Details.
§ Gathering user requirements
§ Analyze the requirements with the team
§ Develop the system
EDUCATION
Master of Business Administration
Sikkim Manipal University (2003 – till date)
· Currently Doing
M.A – Public Administration
Annamalai University – TN- INDIA (2000 – 2002)
· Received aggregate 50% marks
B.Com
University of Madras – TN- INDIA (1991 – 1994)
· Received aggregate 60% marks
Date Of Birth
08-Apr-1971