SUMMARY:

• Over 8 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2008/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS) in SQL Server 2005.
• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert level skillsin Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity,Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating dash boards and dash board elements using SQL server analysis services.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Datamodeling experience using Dimensional DataModeling and Relational Data Modeling, SQL Tuning, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Oracle Designer & Visio.
• Experience with handling moderate to large tables/databases, Query performance tuning, Distributed Transaction, Distributed Queries/Linked Servers.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Hands on experience in creating the MDX cubes and dimensions.(SSAS)
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• Good knowledge on creating score cards and dashboards using MS Office Performance Point Server 2007(MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services
• Experience in designing and developing reports using different tools such as Visual Studio and Report Builder.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server 2005/2000/7.0
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS and Essbase Hyperion.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools,MDX, OLAP (MOLAP, HOLAP, and ROLAP),dimensionalmodeling, starschema and snowflakeschema.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience with Power shell language in writing complex T-SQL Scripts.
• Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Excellent backend skills in creating SQL Data Objects.
• Experiences in devising Disaster recovery strategies and effectively testing them.Experience in managing security, creating security policies and rules.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in deploying SQL Server Analysis Services Projects using MS SQL Server 2005.
• Experience in implementing different types of Replication models like Snapshot,Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Experience with software development life cycle (SDLC) and project management methodologies.

TECHNICAL SKILLS:

Languages

SQL, T-SQL , PL/SQL,.Net(C#,ASP,VB)

SQL Server Tools

Management Studio, Business Intelligence Development Studio,
Enterprise Manager, Query Analyzer, Profiler, Performance Monitor,
Database Tuning Wizard

Databases

SQL Server 2008R2/2008/2005/2000, MS Access, oracle 8i/9i/10g

Operating Systems

Windows Server 2008/2003/2000, UNIX, Linux

ETL

SSIS, BCP, Import/Export Wizard, BI Studio

Data Modeling

Erwin Data modeler, ER Studio, MS Visio

Web Technologies/ Tools

HTML, DHTML, XML, Visual Studio, MS Front page

OLAP Tools

SSAS, MS Excel

Reporting Tools

Visual Studio , Report Builder , SSRS, Crystal Reports

Web Servers

IIS, APACHE Tomcat

PROJECT EXPERIENCE:

Confidential, Richmond, Virginia August 2011 - Till Date
SQL BI Developer/DBA

Confidential, is the largest health benefits company in terms of commercial membership in the United States. Through its networks nationwide, the company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.
Responsibilities:

• Created and maintained Databases for development, testing and production environments.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, and Constraints.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed complex T-SQL code for the application.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Involved in designing datamarts and giving suggestions for the application needs.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Generated different types of SSRS reports using Visual Studio as per the requirements.
• Expertise in report modifications like sorting, grouping and adding rich content to the report as per the user needs.
• Involved in Database Migration from SQL Server 2008R2 to SQL Server 2008.
• Migration of Databases Using Generate Script Wizard.
• Involved in day to day activities like writing the scripts and loading into SVN.
• Experience in version controlling Using SVN.
• Created Logins and Permissions to the developers as per their requirement.
• Involved in migrating users and roles from one database to another database.

Environment: SQL Server 2008 R2/2008, SSIS,SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, MS Excel, MS Visio, Windows Server 2003 Enterprise Edition, HTML, SVN.

Confidential, Colorado December 2010 ­­ - July 2011
SQL Server SSRS/SSIS Developer

Education Sales Management's complete student lifecycle solutions include student enrollment, student retention, career services, continuing education and default prevention. As a premier Business Process Outsourcer, ESM operates the largest education-only contact center in the country. ESM\'s enrollment services deliver rapid, cost-effective lead processing, high contact rates and strong conversion rates. Additionally, ESM\'s student lifecycle solutions include retention services to improve graduation rates, career placement services to help students succeed professionally, counseling services to help students repay their loans, analytics services to help schools manage Cohort Default Rates (CDRs) and continuing education support to help students extend their learning.

Responsibilities:

• Installed and Configured SQL Server 2008R2 successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views,T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Involved in creating front end user interface to allow customers to interact with the application using C# objects and HTML.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures usingT-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports usingSSRSfor the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Proficiently created Reports based on the requirements using SSRS 2005, 2008.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Migrated data from different data sources.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Held responsibility for database maintenance plans.
• Actively involved in gathering and analyzing stakeholders requirements.
• Created alerts, notifications, and e-mails for system errors.
  

Environment: SQL Server 2008 R2/2008, SSIS,SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, ERWIN, Windows Server 2003 Enterprise Edition, HTML

Confidential, Charlotte, North Carolina May 2009 - November 2010
SQL Server SSRS/SSIS/SSAS Developer

Teachers Insurance and Annuity Association - College Retirement Equities Fund (TIAA-CREF) is one of the largest financial services in the United States. TIAA-CREF has been helping those in the academic, medical, cultural and research fields plan for and live in retirement. TIAA-CREF does this with a full array of financial products and services to help them live and through retirement and invest for life's other goals along the way. TIAA-CREF provides financial advice to help people plan for and live in retirement.

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors andappropriate User defined functions to implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Created PL/SQL code to validate and convert the invoice data from non oracle data format to Oracle databases.
• Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS (Microsoft Office SharePoint Server).
• Developed OLAPcubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Created MDX script for representing Cube Calculation using SSAS.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
• Well-versed in using multi dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi Dimensional OLAP Cubes.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Modifying existing Sybase stored procedures to make them ready for Sybase IQ data warehousing use.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server 2008R2/2008/2005, MS Access, SSAS,SSIS, SSRS, PL/Sql, HTML, Visual Studio 2005/2008, IIS, Sybase 12.0,Query Analyzer,, ERWIN, Windows server 2003, DTS, TSQL, Oracle 10g, .Net mvc, SQL Profiler, DTS, Team Foundation Server, CITRIX.

Confidential, Nov 2007 - April 2009
SQL Server Developer/SSIS
Pennsylvania government works hard to ensure that its citizens are able to lead healthy, happy and prosperous lives. From paving roads to helping hard working families make ends meet, the commonwealth provides a wide range of services that have a direct impact on the day-to-day lives of its citizens. The commonwealth has many ways that it helps people start, keep or grow businesses in Pennsylvania. It also helps hard-working Pennsylvanians connect to hot industries, upgrade their skills and—in times of trouble—find help while they work to get their careers back on track.

Responsibilities:

• Created Indexes on columns having high selectivity and low density to speed the execution of data retrieval queries and stored procedures.
• Wrote stored procedures, triggers, and constraints to ensure data integrity, data consistency and to meet the business rules.
• Converted various T-SQL statements into stored procedures thereby reducing the number of database accesses.
• Created T-SQL triggers, tables, views and SQL joins and queries for the application.
• Wrote various Stored Procedures for the purpose of application development.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Implemented constraints on tables. Database tuning and performance planning.
• Tuned SQL statements and Stored Procedures.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Responsible for writing the Unit Test Plan, Test cases based on the Functional Requirements and Technical requirements.
• Developed SQL Server Stored procedures and SSIS packages to extract data from database.
• Performed query optimization and checked performance tuning.
• Integration of PPS (Performance point server) and Excel Services to MOSS(Microsoft Office SharePoint Server) via PPS(Performance point server) and Excel Services web parts
• Created joins and sub-queries for complex queries involving multiple tables.
• Proper use of Indexes to enhance the performance of individual queries and enhance the StoredProcedures.
• Dropped and recreated the Indexes on tables for performance improvements.
• Used query analyzer to optimize queries.
• Created SSIS packages for transferring the data from different systems.
• Designed and implemented DTS package for data transformation and migration.
• Design and developing SSIS packages to import data from various large volume encrypted files into SQL database for data warehouse.
• Transformed data from various data sources using OLEDB connection by creating various DTS packages.
• Responsible for cleaning the data and maintaining the accuracy and quality of the data load from the files into the database objects.
• Created linked servers for data retrieval using OLEDB data source and providers.

Environment: Microsoft SQL Server 2005, Windows Server 2003, SQL Profiler, SSIS, BIDS, Performance Tuning, Oracle 9i, Advisor, Visual Studio, VB.Net, T SQL, PL/SQL.

Confidential, IL Oct 2006 - Oct 2007
SQL Server Developer/SSRS

Confidential, a subsidiary of Affirmative Insurance Holdings, Inc. (AIHI), handles the marketing, policy administration, claim and actuarial functions for certain insurance carriers. AISI is able to provide dependable service along with a broad range of products to meet the customers' unique personal insurance needs. Installation of Microsoft SQL Server 2005, Service packs and Hot fixes.
Responsibilities:

• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Implemented constraints on tables. Database tuning and performance planning.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Prepared Estimates for Database, table size growth
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Developed database monitoring and tuning strategies.
• Proficiently created Reports based on the requirements using SSRS 2005, 2008.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitored connections, locks and performance of SQL server.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Environment: Microsoft SQL Server 2005, Windows Server 2003, SQL Profiler, Tuning Advisor, SSMA, SSRS, DTS, ASP.Net, Query Analyzer, Enterprise Manager.

Confidential, Jacksonville, FL Aug 2005 - Sept 2006

SQL Server Developer/DBA
Confidential, based in Jacksonville, Florida, owns companies providing rail, inter modal and rail-to-truck trainload services that are among the nation\'s leading transportation companies, connecting more than 70 river, ocean and lake ports, as well as more than 200 short line railroads.
Accident Detail Preventer / Tracker: Tracks accident details like personal injury, cost, time, location etc and allows planning, distributing and updating of the companies safety policy to aid accident prevention.
Responsibilities:

• Develop and maintain stored procedures, functions and views to handle complex business logic and audit analysis.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment by executing DBCC commands for integrity check, fragmentation, statistics, re-indexing, shrinking files and databases, etc.
• Develop OLTP Database.
• Plan, implement and support database Backup\\Restore and Disaster Recovery.
• Extensively involved in designing and documenting, upgrading procedures and project plans for MS SQL Server 2000 to MS SQL Server 2008
• Developed several MDX calculations to get the weighted averages for metrics such as Weighted Average Gross Margin, Weighted Average Term.
• Maintain database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats using SQL Server Agent and Scripts.
• Reorganize data files on different disks for optimal performance of the databases.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management
• Implemented proper access to objects with help of Roles, Groups, Permissions and Policies.
• Build and maintain SQL scripts and complex queries for data analysis and extraction as well Develop, deploy and monitor SSIS Packages to import various Data Source Flat files (CSV, XML, Excel, MS Access etc.) and Other RDBMS ( Oracle, DB2 ) to MS SQL Server
• Work on Oracle and Commercial Off-the-shelf (COTS) applications.
• Generate reports using SQL Reporting Services (SSRS) and Crystal Reports for customized and ad-hoc Queries.
• Monitor Windows Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
• Performed Logical & Physical Database Designing and maintaining Data model Using Erwin and MS VISIO.
• Monitored database status including CPU, memory, I/O, space, blocks and dead locks using SQL Server Utilities and 3rd party tools.
• Worked with installing and managing 3rd party vendor application and dependent components, including packages for backup, performance monitoring and disaster recovery purposes.
• Setup Log Shipping or Mirroring or Replication for mission critical databases for High Availability and Disaster Recovery.
• Designed and Developed Data warehouse and OLAP systems.

Environment: Windows 2003, MS SQL Server 2000/2005, VB.Net, Analysis Services (SSAS),Microsoft Reporting services 2000/2005, MS Excel, Window XP, MS Word Microsoft Visio & MS Outlook.

Confidential, India Jan 2004 - Jul 2005
SQL Server Developer

Confidential, Managed Cloud Services (MCS) provides enterprise on-demand scalable provisioning of IT services including applications, messaging and collaboration, servers, storage, and networks. TheNaviCloud Platform offers unique enterprise IT advantages that tap into the core of NaviSite's application and enterprise infrastructure management expertise. Navisite is the premiere provider of complex hosting, application management and managed cloud services for the enterprise market.

Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Responsible and for logical and physical design of database.
• Use Crystal Reports to design and develop reports.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using DTS from flat files.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes, and triggers

Environment: MS SQL Server 2000, Windows 2000 server, Crystal Reports, VB.net, Query Analyzer, Enterprise Manager.

Confidential, India Jun 2003 - Dec 2003
SQL Server Developer

Confidential, deals with the consumer products. HLL has various Database applications running across its various Profit Center's & Cost Center's. IMAGE is the one of the Database project, which was the most challenging IT projects taken up by HLL at that time.

Responsibilities:

• 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.
• Trouble shooting Problems by using SQL server profiler. Very Pro actively identifying the problems before user complaints.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows 2000 Server, Query Analyzer, Enterprise Manager.

Confidential, India Sep 2002 - May 2003
SQL Server Developer

Confidential, is an Insurance Company whose products include personal, liability, commercial, industrial, social etc. "Insurance is the subject matter of Solicitation." This is the one which is followed by New India Assurance. New India Assurance is a leading global insurance group which has factors like Superior Capital Position, Strong Operating Performance and it has got major advantage of long record of successful trading outside India.
Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Responsible and for logical and physical design of database.
• Use Crystal Reports to design and develop reports.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using DTS from flat files.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes, and triggers

Environment: MS SQL Server 2000, Windows 2000 server, Crystal Reports, VB.net, Query Analyzer, Enterprise Manager.

Education: Bachelor's in Engineering