Here is mine Summary: •6 Years of Experience as a Database Administration DBA, Architecture, Data Modeling using SQL Server 7.0 and 2000. .5 years of Experience of web development using ASP •Setting up and Monitoring SQL Server Replication in SQL Server 7.0/ SQL Server 2000 •Administrator in OLTP and OLAP Data warehouse Databases in SQL Server 7.0/2000 •Handling Large Mission-Critical Environments •Backup and Recovery •Data Migration /Transfer Using Database Transformation Services (DTS) •Database Performance tuning and monitoring, Scalability .Creation of objects like Stored Procedures, triggers, views, UDF .Experence in query optimization, SQL Server Profiler •Optimizing Database, Transaction Log Performance •Design, implement and support SQL Server Databases •Maintaining multiple databases in development and QA environments •Worked Extensively in Financial Sectors such as Banks, Mortgage •Optimizing Backup and Restore Performance •Developed data loading plans to seamlessly automate the data loading procedures from multiple data sources (Sybase, SQL Server, MS Access, Oracle) into OLTP and OLAP systems. •Data Modeling in Physical and Logical using Rational Rose •Resolves database performance issues, database capacity issues, replication, and other distributed data issues •Experience in Indexing, disk partitions and optimizing •Experience in Production & Development Environment CERTIFICATIONS •Microsoft Certified Professional (MCP), Designing & Implementing Database with SQL Server 7.0. •Brainbench Certification on SQL Server 2000 Administration Education •M.S. in Computer Science, Maharishi University of Management. IOWA USA •B.Sc. in Electrical & Electronic Engineering, Bangladesh Institute of Technology Technical Skills: Operating Systems Windows 2000 Server, Windows 2000 Advanced server, Windows NT 4.0, UNIX, Windows XP. Languages SQL, Visual Basic, XML, ASP, VB.Net PL/SQL, T-SQL, Visual SourceSafe RDBMS SQL Server 2000 /7.0, Oracle 9i/8i, MS Access Database Query Tools MS SQL Server Query Analyzer ,SQL*Plus Database Modeling Data modeling / Database design (logical / physical) using Erwin Data Warehouse Modeling SQL Server Environment: Designing and implementing OLAP solutions using Microsoft Analysis Manager, Data Transformation Services, Implementing OLAP with SQL Server 2000 RDBMS Other Tools MS Project, Microsoft Word, Excel, Outlook, PowerPoint, etc Professional Experience: Progressive Insurance Mayfield Village, OH March 13, 2006 – till today. SQL Server Developer .Completed project to migrate Aspect database in SQL server to Oracle. . Working on data warehouse project for Aspect database. Environment: SQL Server 2000, DTS,Oracle 9i,Win 2000,SQL Analysis services. Kawasaki Motors Corp., U.S.A. CA September 12, 2005 – December 30, 2005 SQL Server DBA Team member .Optimizing the existing stored procedures, database triggers and SQL scripts on the Server level .Creating stored procedures for custom data access and crystal reports .Fine tuning the performance of queries, stored procedures, triggers. .Used ETL Tool Sagent to make various plans to extract the data. .Extract data from main frame to SQL Server using Sagent plan. .Task scheduling to automate processes /tasks like database backups. .Data Migration with MS Access, Excel and Text files and scheduling tasks using DTS. .Writing T- sql queries for different purposes in daily activities. .Performance monitors using tools provided by SQL Server 2000 on SQL Profiler. .Taking daily online Backups, weekly off-line Backups and frequent exports. Environment: SQL Server 2000, DTS, T SQL,Sagent ETL Tool,Opalas, WINDOWS-NT and Windows 2000 Server,Main Frame. Option One Mortgage Corporation, Irvine, California, USA CA September 12, 2004- September 09, 2005 SQL Server 2000 (Database Administrator) - DBA/Developer Responsibilities: •Database Performance tuning and monitoring, Scalability Testing •Designed and implemented Transactional and Snapshot Replication •Provide non-stop Database Access support 24x7 •Preparation of Schedules for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases •Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database •INDEX Optimization •Remove physical and logical fragmentation from indexes using CREATE INDEX WITH DROP_EXISTING, or logical fragmentation using DBCC INDEXDEFRAG, or rebuild all indexes using DBCC REINDEX •Setup and Maintain Replication between Production and the Standby servers •Optimizing Backup and Restore Performance •Optimizing Transaction Log Performance •Experience in Indexing, disk partitions and optimizing •Writing Stored Procedure Using Transact-SQL •Designing a Data Warehouse, data mining, Relation Database design •Memory management, data storage, user connections and Load Balance •Database authentication modes, creation of users, configuring permissions and assigning roles to users •Prepare and set up environment for Disaster recovery •Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) •Data conversions from legacy systems to SQL server Using DTS •Maintaining remote and central databases for Synchronization of data and preparing plans for Replication •Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events •Creation of objects like Stored Procedures, triggers, views as per requirement and implementation of the security model on Application for Access of Objects •Design of Maintenance plan for backup/restore and Indexes •Working with development teams on all aspects of database design including tables, views, stored procedures, permissions, etc •Designing a Data Warehouse, data mining, Relation Database design administering Data Warehouse Databases •Work with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency Environment: SQL Server 2000, Enterprise Manager, SQL Profiler, Data Model, SQL Trace, Transact SQL (T-SQL), Query Analyzer, Performance Monitor, SQL Query, Transactional Replication ,Backup/ Recovery, Analysis Service, Database Transformation Services DTS, Windows 2000,T-SQL, Windows 2000 Advanced server, PL/SQL Oracle PL/SQL,Windows NT, ETL Information System Department,Maharishi University of Management,Iowa,USA June 2004- September 2004 SQL Server DBA/Developer (Part time) Responsibilities: •Preparation of Schedules for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases •Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database •Designed and implemented Transactional and Snapshot Replication •Database Performance Tuning and monitoring, Scalability Testing •Remove physical and logical fragmentation from indexes using CREATE INDEX WITH DROP_EXISTING, or logical fragmentation using DBCC INDEXDEFRAG, or rebuild all indexes using DBCC REINDEX •Writing Stored Procedure Using Transact-SQL •Designing a Data Warehouse, data mining, Relation Database design .Converted MS access code to Store Procedure .Used different XML parsers to load the data from XML files. •INDEX Optimization,Transaction Log Performance •Experience in Indexing, disk partitions and optimizing •Optimizing Backup and Restore Performance •Memory management, data storage, user connections and Load Balance •Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events •Creation of objects like Stored Procedures, triggers, views as per requirement and implementation of the security model on Application for Access of Objects •Design of Maintenance plan for backup/restore and Indexes Mercantile Communication Pvt. Ltd, Kathmandu,Nepal March 2000- August 2003 .Software programmer Developed web-based Inventory management system for Furniture Land, Kathmandu, Nepal. Responsibilities: •Created and modified procedures, triggers and functions. •Created all administration tasks of SQL Server and designed database. •Used system store procedures and DBCC commands. •Used ASP.Net with C# to develop front-end system. Environment: SQL Server 2000, ASP. Net, C#, Windows 2000, NT, IIS Planned Replication set up for banking software PumoriPlus between SQL Server 2000 and local access database for Nepal Investment Bank. Responsibilities: •Used Snapshot replication. •Setting up of Snapshot agent, Distribution agent, Publishers, Subscribers and Distributor. Environment: SQL Server 2000, Windows NT, Access Developed administrative tasks of SQL Server for banking software PumoriPlus running in various large banks in Nepal. Responsibilities: •Performed daily backups and developed recovery procedures. •Created DTS package to export and import data from SQL Server to Access, text files and Excel files. •Checked Performance Tuning, Indexing, Query Optimization. •Created and modified procedures, triggers and functions. •Used database consistency checks using DBCC utilities. •Wrote complex T-SQL for retrieval of data. •Wrote distributed queries for two SQL Server databases. Environment: SQL Server 2000, Windows NT, Delphi Team member of web-based complete Hotel Management software used by large hotels in Nepal. Responsibilities: •Created and modified procedures, triggers and functions. •Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases. •Created ASP pages using MS Visual InterDev 6.0 with JavaScript and VBScript. •Designed database for hotel management software. •Created automatically running stored procedures for day-end operation using SQL Server agent. •Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility. •Automation of COM object using sp_OA procedures. Environment: SQL Server 7.0, ASP, JavaScript, HTML, Windows 95/98/NT, IIS, Rational Rose, Erwin Design Tool Developed Inventory management system for UNICEF, Kathmandu, Nepal. •Designed database for Inventory management software in MS Access. •Designed different forms and wrote code in Visual Basic 6.0. •Used stored queries in MS Access. •Used VB reporting tools for generating reports. Environment: MS Access, Visual Basic 6.0, Windows 98/NT CAS Trading House Pvt. Ltd., kathmandu Nepal August 1999-Feb 2000 Software Support Engineer Responsibilities: •Supported various problems related to banking software Banks 2000 (by INFOSYS, India) using Oracle, Unix, and C/C++. •Created various banking reports for Bank of Kathmandu and SBI Bank. Technical Environment: •Oracle, Unix, C/C++ GRADUATE PROJECT .Developed banking application module using C# and SQL Server 2000, Rational Rose applying black board architecture. PROFESSIONAL TRAINING • Visual Basic 6.0 from Mercantile Communication,Date:March 3,2000-April 20,2000 • Networking with windows NT and TCP/IP from Mercantile Communication ,Date March 5,2000-March 15 2000 • Hotel software MICROS FIDELIO from Mercantile Communication ,Date: March 3,2000-May 20,2000 • Banking software BANKS 2000 and UNIX from CAS Trading House,Date : August 1999 – October 1999