Krishnakumar Chinnasamy

 

The resume has not yet been entered.


Krishna Kumar
7318 Parkridge Blvd, #86
Irving, TX 75063
E-mail: kumar@vayyam.com
Phone: 972-501-9931


SUMMARY
* Has 6 years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments; with 5+ years of experience as a SQL Server DBA/ETL developer.
* Very good experience in Installation, configuration and maintenance of SQL Server.
* Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
* Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. 
* Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
* Experience in Database backup and disaster recovery procedures.
* Experience in Replication – Snapshot, Merge and Transactional.
* Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
* Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
* Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
* Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
* Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
* Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
* Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills. 
* Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.

EDUCATION AND TRAINING
Masters in Computer Applications

TECHNICAL SKILLS
Hardware:
DELL 6850 Servers, DELL 6300 Servers, SAN arrays, Pentium PC’s and Windows 2000 Servers
Operating Systems:
Windows Server 2003, WINDOWS XP/2000/NT, WINDOWS 9x
Software:
MS SQL Server 2005/2000/7.0, T-SQL, DTS, MS Access 2000/97, ODBC, Visual Basic 6.0, Visual Source Safe 6.0 and Crystal Reports 7.0/8.0

EXPERIENCE DETAILS

Covey Software Systems, Inc		TX		Aug’2006 to Present
MS SQL Server DBA/ETL developer
Customer Loyalty Program
The Customer Loyalty program is developed for Retail Industry. This system automates Customer enrollment, Partner Management, Customer transactions, their Points management, Awards management, Shipping, Points Bonus and Campaign Management. This system involves an OLTP system and Data Warehouse system for Campaigns.

* Responsible for installation and configuration of SQL server 2005 database on Dell Servers.
* Involved in data modeling for the application and created ER diagram using ERWin.
* Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
* Implemented database standards and naming convention for the database objects.
* Developed DTS packages to extract, transform and load into the Campaign database from OLTP database. 
* Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
* Created and configured an OLTP replication database for disaster recovery purpose.
* Worked with developers to tune the SQL queries using SQL Profiler.
* Worked with Star Schema, Cubes and Analytical services.
* Provided 7 x 24 Production support for the database and application issues.

Environment: 
DEL 6850 Servers, MS SQL Server 2005/2000, T-SQL, DTS, VB.Net, ASP.Net, Visual Source Safe 6.0,Windows 2003 Server and Compuware QA Load test

RAMCO Systems	USA					Jan’2006 to Aug’2006
MS SQL Server DBA/Analyst Programmer
United Nations Relief and Works Agencies (UNRWA), USA
UNRWA is relief and human development agency. UNRWA provides education, health care, social services and emergency aid to over 4.3 million refugees living throughout the world. The project involved government functions such as Finance, Administration, Social services, Health Care, Public Safety, Criminal Justice, Transportation and Public Works. 

* Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
* Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. 
* Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
* Implemented database standards and naming convention for the database objects.
* Conversion the legacy systems data into MS SQL server using DTS packages.
* Developing SQL scripts for maintaining administration tasks.
* Tuned the SQL queries using SQL profiler. Involved in tuning the database.
* Upgrade the MS SQL server from 7.0 to 2000. 
* Updating with latest service packs and security patches.
* Based on the business need created all three replication models on different applications.
* Implementing stand by servers and Log shipping.
* Involved in developing stored procedures, triggers  for the application.
* Estimating of Table sizes and Record sizes. Maintaining proper licenses.
* Maintain all the SQL documents includes installation and data conversion Procedures documents. 
* Trouble shooting Problems by using SQL server profiler. 
* Solved critical production problems and performed point in time recovery plans.
Environment: 
DEL 6300 Servers, MS SQL Server 2000/7.0, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0,Windows 2003 Server and Compuware QA Load test

RAMCO Systems						     Mar’2005 to Dec’2005
MS SQL Server DBA/Analyst Programmer
Group 4 Securicor systems, Belgium
Group 4 Securicor is a global leader in security solutions, offering Security Services, Security Systems, Cash Services and Justice Services in over 100 countries around the world. The project deals with various details related to Security Guards such as employment, Guarding, Cash services, Payroll, Training, Firearm details, Investigation techniques, Bomb countermeasures, and Hostage Negotiations.

* Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
* Responsible for configuration of Microsoft Server/Client Products and implementation.
* Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. 
* Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes. 
* Responsible for General Database Administration and Performance tuning.
* Experienced in resolving deadlock and blocking issues for concurrent users
* Worked with DTS packages to load the massaged data into Data warehousing system.
* Data Migration from legacy to master tables using DTS-Import and Export wizard.
* Performance tuning of Ramco e apps ERP on SQL Server 7.0 and 2000.
* Developed Database Backup Scripts and automated this process
* Used MS Visual Source Safe 6.0 as a Version Control System. 
* Partly Participated in system study and analysis of software applications. 
* Experienced in support, applications and software development.
Environment: 
DELL 6300 Servers, MS SQL Server 2000/7.0, T-SQL, DTS, Visual Basic 6.0, Visual Source Safe 6.0, Windows 2003 Server, Compuware QA Load test and Ramco report Writer.

RAMCO Systems						Jan’2004 to Mar’2005
MS SQL Server DBA/Analyst Programmer
Elegance Technology Accuracy (ETA), Switzerland

ETA Manufacture Horologer Suisse is one of the world’s largest manufactures of watches and movements. The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, destuffing, Billing, vendor-managed inventory and warehouse management.

* Involved in installation and configuration of SQL server 2000. 
* Applied patches and service packs to keep the database at current patch level.
* Responsible for configuration of Microsoft Server/Client Products and implementation.
* Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. 
* Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
* Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
* Supported production and development databases.
* Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues.
* Maintained 6000 tables, 60,000 stored procedures, 3000 views and 1700 triggers
* Managed 17 databases at the headquarters running on 10 servers
* Database version control using VSS.
* Developed SQL scripts for maintaining administration tasks.
* Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
* Backup and Recovery plans for Field office and Headquarters database servers
* Maintained the field office database backups through SQL mail Scripts.
* Converted the legacy data from mainframes and dbase by using DTS packages
* Interacting with the users and troubleshooting the problems involved with the development of stored procedures. 
* Created and maintained users and user groups
Environment: 
MS SQL Server 2000/7.0, Microsoft VC++, T-SQL, DTS, Windows 2003 Server, Compuware QA Load test, Ramco virtual Works and Ramco report Writer.

ICICI BANK, India						Dec’2002 to Dec’2003
MS SQL Server DBA/Analyst Programmer
Customer Loan processing System
ICICI Bank is India's second-largest bank in India. ICICI Bank has a network of about 614 branches and extension counters and over 2,200 ATMs. The Project involved end-to-end application deployment to support Loan Organization like online loan application, loan interest rates, Adjustable And Fixed Rate Loan, Part fixed, Part Floating Rate Loan, Balance Transfer of your existing loan from other banks, Compliance, Reporting and treasury operations.

* Installed SQL Server on Windows 2000 Server.
* Involved in the Analysis and Design
* Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. 
* Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes. 
* Responsible for General Database Administration, Query Performance tuning.
* Backup recovery schedules, Backup scripts.
* Worked with DTS packages to load the massaged data into Data warehousing system.
* Tuned the SQL queries using SQL profiler. Involved in tuning the database.
* Data Migration from legacy to master screen using VT Script.
* Used MS Visual Source Safe 6.0 as a Version Control System. 
* Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.	
Environment: 
MS SQL Server 2000/7.0, T-SQL, DTS, Microsoft VC++, Windows 2003 Server, Compuware QA Load test Ramco virtual Works and Crystal reports 8.0.

PT Rainbow Indah Carpet, Jakarta-Indonesia	Feb ‘2002 to Dec’2002
MS SQL Server Developer/DBA
ERP system
This company is a leading manufacturer and exporter of carpets around the world. We have developed the projects for RIB, which focuses on SCM, Financial Operations, Discrete production, Planning, Inventory, costing, human resource management and Payroll. 
* Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs
* Installed SQL Server on Windows 2003 Server.
* Responsible for configuration of Microsoft Server/Client Products and implementation.
* Developed various T-SQL stored procedures/functions for the Application.
* Responsible for database tuning using normalization and application tuning
* Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler
* Data migration between different environments and Third Party Databases.
* Monitored user accounts, user permissions, table partitions and backup.
* Developed and designed the GUI with ActiveX Controls like MS Flex Grid, List View, Tree View, etc. 
* Used ADO Technology for application related operations.
* Interacted with the users and troubleshooting the problems involved with the development of stored.
* Generated MIS reports using Crystal Reports.
* Estimating of Table sizes and Record sizes.
* Performed database consistency checks.
* Backup recovery schedules, Backup scripts.
* Developed Database Backup Scripts and automated this process
Environment: 
MS SQL Server 2000/7.0, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0,Crystal Reports 8.0 and Windows 2003 Server
 
ECC Motors, India			 			Mar ‘2001 to Jan’2002
MS SQL Server Developer/Junior DBA
Materials Management System
This system handles the basic material management functions like Materials planning and programming of procurement and supplies, Purchasing, Inventory control, Storekeeping and warehousing, Materials handling and transportation, Codification and standardization, Value Analysis, identification, Disposal of supplies, obsolete and scrap materials, Printing of various Books & Forms, Periodicals, and Journals.

* Involved in configuring and converting MS SQL server 6.5 database to MS SQL Server 7.0. 
* Partially involved in Database design and Database objects.
* Created backups for databases.
* Partly Involved in Performance tuning 
* Created ActiveX DLL COM Components using Visual Basic 6.0. 
* Responsible for Developing GUI Screens
* Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.  
* Responsible for creating COM Components using ActiveX DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
* Developed various management reports using Crystal reports 8.0.
* Maintain the application as per the user requirement.
Environment: 
MS SQL Server 7.0/6.5, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0,Crystal Reports 8.0 and windows 2000.


CST Traders, India			              	Feb ‘2000 to Feb’2001
MS SQL Server Junior Developer
Inventory Management Systems
Handles all functions related to the tracking and management of material. This would include the monitoring of material moved into and out of stockroom locations and the reconciling of the inventory balances. Also may include ABC analysis, lot tracking, cycle counting support, Bin Management, Landed Cost, Customer and Volume Pricing, Multi-currency Pricing, Multi-location, Multiple Units of Measure, Lot Numbers, Bulk Ordering, Special Orders, Serialized Inventory, Lot Tracking, Item Upgrades/Downgrades Audit Trail for Inventory Adjustments and Stock Transfer. 

* Partly Involved in System study and database designing.
* Install, configure and upgrade MS SQL Server.
* Porting the old data in to the new database using of BCP
* Assisted for Development and design the GUI with ActiveX Controls like MS Flex Grid, List View, Tree View, etc. 
* Used MS Visual Source Safe 6.0 as a Version Control System. 
* Generated MIS reports using Crystal Reports. 
* Coding, Testing, designing the Active X controls.
* Client side implementation and testing.
* Maintain the application as per the users requirement.

Environment: 
MS SQL Server 6.5, Microsoft Visual Source Safe 6.0, Visual Basic 6.0, Crystal Reports 8.0 and Windows 98.



Member number:9786
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 Krishnakumar Chinnasamy and Software Contractors' Guild, 3 Country Club Dr., #303, Manchester, NH USA 03102