SUMMARY

• SEVEN years of rich IT experience mainly in Database design, data access and development using Microsoft SQL Server 2000/2005 and Web Applications development using ASP.NET and C#.
• Experience of developing stored procedures, user defined functions, triggers, tables, views, user defined data types, and indexes.
• Proficiency in T - SQL, Table partitioning, Creation and optimization of all database objects Stored Procedures, Indexes, functions, views, triggers, management of DTS packages/SSIS packages and BCP utility, creation and management of Data files and partitioned file groups, and implementation of database mirroring.
• Extensive experience in production support including database backup, performance monitoring, application troubleshooting, system upgrade.
• Excellent knowledge of normalization concepts, database architecture and design and strong data analysis skill. Experience in Code review and impact analysis. Understanding of Software Development Life Cycle.
• Experience of Databases like SQL Server 2000/2005, MySQL, MS Access.
• Experience of SQL Server 2000/2005 Data Transformation Services (DTS), Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS).
• Experience of upgrades from previous version, table normalization.
• Knowledge of SQL Server 2000/2005 database backup & restore, Activity Monitoring.
• Experience of dealing with different data sources like flat files, SQL server, XML, excel.
• Experience in Query Optimization, SQL Profiler.
• Experience with VSS (Visual SourceSafe) to manage code (SQL, VB6, ASP, ASP.NET) version. Experience with OLTP development for web transaction and client-Server transaction.
• Experience working with Production 24/7 and Development Environments. Extensive experience in installation, configuration & Maintenance of MS SQL Server 2005, 2000 and 7.0.
• Experience with creating/modifying Java Script, HMTL and XML.
• Experience of ASP.NET, C#.NET.
• Microsoft Certified IT Professional: Database Developer (SQL Server 2005)
• Microsoft Certified Professional in Developing and Implementing Web Applications with C#.NET and Microsoft Visual Studio.NET (MCTS)

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2000/2005, MySQL 4, MS Access, Oracle 8ETL Tool SQL Server Integration Services, Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting ServicesData Warehousing SQL Server Analysis Services

Web Technologies: ASP.NET 1.1/2.0, C#.NET, VB.NET, PHP, ASP, HTML, JavaScript

Languages & Tools: Visual Basic 6.0, C, C++, T-SQL, SQL, PL/SQL

Operating System: Windows 9X, Windows 2000, Windows XP

Others: PayPal payment gateway integration, Authorize.net payment gateway integration, Microsoft Virtual Earth Map Control, Facebook Application

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

MS SQL Developer

Responsibilities:

• Database Management. Analyzing and designing database of applications using ER Diagram and DFD. Developing and maintaining scalable, robust Intranet/Internet base applications.
• Creation/deletion of schema objects like tables, defaults, triggers, Stored Procedures, Indexes, functions, views. Managing System and database roles. Creation and management of SSIS packages for Importing and exporting data. Scheduling and monitoring SQL Server Jobs.
• Planning Backup/Restoration strategies. Tuning of SQL Server and SQL statements using SQL Profiler, Performance monitor, and Event Logs. Installation of Operating Server and SQL Server 2005.

Environment:MS SQL Server 2005, SQL Server Profiler, SSIS, Widows 2000, MS IIS-6.0, ASP.NETMaster Card

Confidential, MO

SQL BI Developer

Responsibilities:

• Implementation of reports using SQL Server 2005 Reporting Services (SSRS).
• Developed queries and stored procedures using T-Sql for the front-end application.
• Used SQL Server Integration Services (SSIS) as ETL tool for data transformation and loading in SQL Server 2005 Database.
• Developed different types of reports as Prebill & Invoices, Account Payable & Receivable,
• Project Cost & Budget, Project and Labor Reports in Reporting Services.
• Developed Cube on the dimensions, levels and measures required for the analysis.
• Developed drill through reports to customize the presentation of the data.
• Run and published reports in HTML, PDF, CSV and Excel for analysis.
• Pivoting, Drill down, Slice and Dice and filtering operations are done for all the OLAP applications.

Environment: SQL Server 2005, SSAS, SSIS, SSRS, MS Excel

Confidential, Columbus, OH

Data Warehouse / SQL Developer

Responsibilities:

• To Work closely with the Business analysts for requirements gathering, designing the database and creating workflow.
• To design the staging database in order to extract and load the data from various sources.
• To be active member of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• To work on ETL process.
• To design workflow and take the ownership of some very complex packages.
• Implemented the Master/Child Package Model so that only the Master Package has to be scheduled which will in turn fire the other packages.
• Scheduling and monitoring the ETL packages.
• To develop Exception handling process for each ETL package.

Environment: SQL Server Integration Services (SSIS), SSRS, MS SQL Server 2005, VB.Net, Business Intelligence Development Studio (BIDS)

Confidential, Atlanta, GA

ETL / SQL Developer

Responsibilities:

• Architected design of workflow.
• Prepared Standards & Guideline Documents for preparing various packages.
• Developed & Deployed of various parameterized packages with SQL Integration Services 2005.
• Implemented error handling strategies.
• Trouble-shooting wherever and whenever required.
• To develop complex transformation.

Environment: SQL Server Integration Services (SSIS), MS-SQL Server 2005, Business Intelligence Development Studio, C#.Net

Confidential

Database Developer

Responsibilities:

• Implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Maintain SQL Scripts for changes in database objects.
• Provide database coding support to application development team.
• Design and develop data transformation processes.
• Design and develop SSIS packages for data transformations and importing into new database.
• Design T-SQL code blocks.
• Development of modules using asp.net c#.net .