Professional Summary:

• Overall 7 years of extensive experience in Database Design, Development, Testing and Implementation of Client-Server Applications & Database systems using MSSQL SERVER 2000/2005/2008 in various domains.
• Extensively involved in writing Stored Procedures, Triggers, User Defined Functions, Constraints and In-Depth Knowledge on Normalization and De-Normalization techniques for both OLTP\\OLAP systems.
• Experience in Tuning SQL queries and optimizing the query performance by creating various Clustered, Non-Clustered Indexes and Indexed Views.
• Extensively used SQL Server tools like Query Analyzer, Enterprise Manager, Profiler and Management Studio.
• Experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS and Bulk Copy Program (BCP) utility.
• Expert in creating SSIS Packages to transform data from different OLEDB Providers like DB2, MS Access, Flat File, Excel, Oracle and finally load it into Datawarehouse.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in designing Ad hoc reports and different types of Drill Down, Drill Through, Tabular, Matrix, Custom reports, Sub reports and Parameterized reports in multiple formats using SQL Server Reporting Services (SSRS).
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Knowledge in generating Cubes and Dimensions, defining referenced relationships in SSAS, defining granularity within a measure group, generated KPIs and Calculations.
• Experience in Database Backup, Recovery procedures.
• Experience with .NET framework using ASP.Net, C#, XML and ADO.Net database connectivity.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

Technical Skills:

Databases

SQL Server 2000/2005/2008, Oracle 8i, MS - Access

SQL Server Tools

Data Transformation Services (DTS), SQL Server Enterprise Manager, SQL Server Profiler, SQL Server Query Analyzer, BIDS (SSIS, SSRS, SSAS), Crystal Reports, MSVisio, Erwin

Programming Languages

T-SQL, C#, ASP.Net, Visual Basic 6.0, C, C++, PHP

Operating Systems

Windows 95/98/2000/2003/XP-Pro, Windows NT, Windows XP, UNIX.

Web Technologies and Software

CSS, HTML, DHTML, XML

Certification:

• Microsoft® Certified SQL Server™ 2005 Business Intelligence Development(BI)

Professional Experience:

Client: Confidential, Herndon, VA June 10 - Till Date
Title: SQL Server/SSIS/SSRS/SSAS Developer
Description: Comcast is one of the leading communication companies in the nation and is well-known for its cable television services. They are known as a leader in business communication technology. Comcast is a cutting-edge company that offers quality products, great customer service all at an affordable price.

Responsibilities:

• Involved in Gathering requirements, Performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Datawarehouse.
• Designed and normalized the databases and created different objects like Tables, Views, Stored Procedures, User defined functions, Indexes.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Designed packages using Transformations such as Execute SQL Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Resolved and closed the Production tickets generated due to failure of daily Incremental production jobs.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created various reports like Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports using SSRS.
• Created reports using stored procedures and also involved in Scheduling, Creating Snapshots and Subscriptions for the reports in SSRS for business users.
• Used expressions to Calculate, Group, Filter, Parametarize and Format the contents of the report according to the requirement.
• Designed and developed Data Warehouses, Data marts using Multi-dimensional models such as Star Schema and Snow Flake Schema for developing cubes.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure.
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.

Environment: SQL Server 2005/2008, Query Analyzer, SSIS, Microsoft SQL Server Reporting Services, SSAS, XML, MS Excel, MS Access, .Net, Visual Studio, C#.

Client: Confidential, Denver, Colorado May 09 - May 10
Title: SQL/SSIS/SSRS Developer
Description: Charles Schwab Corporation was incorporated in Delaware in 1986. The Company, through its subsidiaries, is engaged in securities brokerage, banking and related financial services. It provides financial services to individuals and institutional clients.

Responsibilities:

• Extensively used Joins, sub-queries, Stored Procedures and Indexes for complex queries involving multiple tables from different databases.
• Extensively involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project using SQL Server Integration services.
• Used various SSIS tasks such as Conditional Split, Derived Column and Slowly Changing Transformation which were used for Data Scrubbing, Data validation checks during Staging.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Bulk Insert task, Data flow task, File system task, Send mail task, Active script task, Xml task and also used Import/Export Tool.
• Designed and developed Various Tabular and Matrixreports using SSRS.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Scheduled reports daily, weekly, monthly for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created standard and data drivenSubscriptions, used report manager for securities.
• Extracted data from cubes to create complex reports according to end user requirements.
• Involved in creating Cubes and Dimensions for the new Data Warehouse using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), SQL Profiler.

Client: Confidential, Chesapeake, VA Sep 08 - Apr 09
Title: SQL/SSIS/SSRS Developer
Description: AHM offers a fully integrated suite of hosted technology solutions and sales support services designed to address the diverse operational and compliance management needs of its clients, including corporate speaker bureau and event management solutions.

Responsibilities:

• Involved in complete SDLC which includes requirement gathering, analysis, design, development, and implementation.
• Developed stored procedures, triggers, views, adding/changing tables for data load, transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SSIS Packages using transformations like Derived Column, Data Conversion, OLEDB command, Union All, Script Task, Conditional Split.
• Used Checkpoints in packages to enable the package to run from the point of failure and also used Event Handlers.
• Used Configurations like XML, SQL Server and Environment Variables to make dynamic changes to packages.
• Involved in Default logging and Custom Log to keep track of the package.
• Migrating SQL Server DTS packages to SSIS 2008 packages.
• Developed and maintained Enterprise Reporting (SSRS Reporting Services) based on specification and business needs and modified existing reports as needed.
• Design, deployment, and maintenance of various SSRS Reports in Drill mode using tables, cross tabs and charts.
• Designed and created OLAP cubes by defining the relationship between dimensions and measure groups in Star Schema Data marts.
• Facilitated communication between developers and business users to ensure that customer requirements are correctly translated to appropriate data design specifications

Environment: MS SQL Server2005, SSIS, SSRS, SSAS, SQL Profiler, MS Office, Windows Server 2003.

Client: Confidential, Bloomington, IL Mar 07 - Aug 08
Title: SQL Server/SSIS Developer
Description: State Farm Insurance Company provides various insurance products and services in the United States and parts of Canada. In addition, the company provides various banking products and services, home mortgage loans, car loans and online banking. State Farm was found in 1922 and is headquartered in Bloomington, Illinois.

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in rebuilding views to reduce apparent database complexity for end user and preventing exposure of underlying tables and filtering the bad data accordingly.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Designed complex SSIS packages using appropriate control and data flow elements with SSIS standards like event handling, error handling, logging and working with package configuration files.
• Worked on Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS), BCP (Bulk Copy Program) and FTP task in SSIS.
• Performed the tasks of data conversions, lookups, adding derived columns, sending E-mails is done using various tasks in SSIS for the data cleansing and auditing.
• Created reports for users in different departments in the organization using web-enabled services in SSRS.
• Used Report Designer to extract information from one or more files and successfully deployed on various sources like XML, Web browser and PDF.
• Scheduled jobs, Alerts using SQL Server Agent.
• Responsible for the creation and maintenance of Analysis Services objects such as cubes, dimensions and analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.

Environment: SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, SSRS 2005, SSIS Tools ,Windows 2000/XP, SSAS, Microsoft Visual Studio, VB Scripts

Client: Confidential, India Jan 06 - Dec 06
Title: SQL Server Developer/DBA
Description: HDFC was amongst the first to receive an \'in principle\' approval from the Reserve Bank of India (RBI) to set up a bank in the private sector, as part of RBI\'s liberalization of the Indian Banking Industry in 1994. HDFC Bank commenced operations as Scheduled Commercial Bank in January 1995.
Responsibilities:

• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Extensively involved in designing the DTS packages to make the automated synchronization of data from one system to another system.
• Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using BCP and DTS utility.
• Analyzed and implemented backup and database maintenance plans.
• Configured Mail Profile for sending automatic mails to the respective people when a job failed or succeeded.
• Administering MS SQL Server by Creating Logins and assigning appropriate roles.

Environment: SQL Server 2000/7.0, Windows 2000 Server, SQL Profiler, DTS, T-SQL, BCP, System monitor/Performance Monitor, Query Analyzer

Client: Confidential, INDIA July 04 - Dec 05

Title: SQL Developer/DBA
Description: This is a major Indian telecommunication company headquartered in Mumbai, India. It is the 16th largest operator in the world with more than 128 million subscribers.

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2000.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Maintained the client relationship by communicating the daily and weekly status of the project.
• Planned, defined and designed data flow processes for data migration to the Datawarehouse using DTS.
• Planned Backup strategy based on project requirements.

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Education:
Bachelors in Electrical Engineering