Professional overview:

• Over 3+ years of IT Experience in design, development, coding and testing of business/commercial applications MS SQL Server 2008/2005/2000, MS Access, .NET Script, Windows XP, Windows 2000/2003/2008.
• Experience in creating database, tables, indexes, stored procedures, views, triggers, T-SQL, DTS/SSIS using MS SQL Server 2000/2005/2008.
• Working knowledge of Software Development life Cycle (SDLC) and N-tier Application Architecture.
• Extensively used SSIS for integration services.
• Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008 by creating ETL package from Scratch. Experience in Database Backup and Recovery.
• Installed and Configured SQL Server 2008/2005/2000.Good understanding of Normalization/De-normalization, Normal Form and database design methodology.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Created Cube on top on enterprise data warehouse.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and DimensionsTables using MS Analysis Services.
• Created different kind of reports and deployed it on different Servers.
• Excellent knowledge in RDBMS concepts.
• Extensively worked in Data Modeling.
• Experience in Data legacy mart.
• Extensively involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP.
• Experience in creating Jobs, Alerts on SQL Mail Agent, and scheduled DTS/SSIS Packages. Experience in query optimization & performance tuning.
• Created Database and Database Objects like Tables, Stored Procedures, Views, user defined data types, different kind of jointo fetch the data from different server table And functions using T-SQL queries.
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirements activities including database consistency check, and data backup & restore strategy, index fragmentation.
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Create an index on terabytes databasesto retrieve data faster from database.
• Found a cluster index is faster than the non cluster because of leaf level.
• Work on data modeling, store procedure, view, trigger, different kind of join to fetch the data from different table.
• Strong troubleshooting and organizational skill, independent, self-managing and teamwork.
• Ability to work in-groups as well as independently with minimal supervision.

TECHNICAL SKILLS:

Databases

MS SQL SERVER 2000/2005/2008, ORACLE 9i, MS Access

Database Tools

T-SQL, Enterprise manager, Query Analyzer, bcp, SQL
Agent, Performance Monitor, Client Configuration Utility, Server Configuration Utility, Profiler, Export & Import (DTS), Erwin.

Web Servers

IIS 4.0,5.0 and 6.0

Languages

T-SQL, PL SQL, VB.NET, C#.NET, Visual Basic 6.0, C, C++

Tools

MS Office 2010/2007/2003/2000/XP, MS Outlook 97/2000

Operating System

Windows 2008/2000 Advanced Server/Server 2003/Professional/ NT 4.0, Win XP Prof/Standard, Win 98.

Data Modeling

Microsoft Visio, DB Designer, Front Page, Erwin

Education:

• Bachelor’s in Information Technology.
• Master’s in Computer Science.

Client: Confidential,Norcross, GAJan ’11 - Present Role: SQL Developer/ BI Developer (SSIS, SSRS, SSAS)
Project Description: CareerBuilder provides Business Solutions with data analysis, comprehensive partner network and superior customer service to match the right people with the right jobs. Provide customer solution by following Lean principles.
Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file (CSV), XML, and Oracle to MS SQL Server by using BCP utility, SSIS services.
• Created SSIS Packages to migrate data from SQL 2005 to 2008 and worked on slowly changing dimensions.
• Worked on SCD Type-1, 2 in order to keep historical data in enterprise data ware house.
• Worked on staging database, data clean up, data cleansing and concatenate of data in staging environment through ETL process and T-SQL queries.
• Created configuration files for SSIS packages and migrated on \\Dev, \\QA, \\UAT and \\Prod environment.
• Responsible for Deploy ETL packages on Development environment, QA, UAT and production.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Responsible to create job on SQL server agent and have them to run by using batch command.
• Created Cube on top of enterprise data warehouse.
• Worked on partition of cube in order to pull data very efficient way and for better performances.
• Worked on Excel pivot functionality to pull Cube data and Responsible for to show how to pull data in Excel in Demo.
• Worked on process full for measure group and process update for Dimensions in cube.
• Worked on production support 24/7 in warranty duration.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
• Creation of schema objects, rules and granting of roles to the users.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Involved in developing E-R diagrams, logical & Dimensional Modeling, development and implementation of Enterprise data warehouse project.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Optimized query performance by creating indexes.
• Created summarized and details reports as per business requirements.
• Created different kind of reports for internal and external users as per the Business Analysts requirement.
• Created drill through reports for getting more information about the product at detail level.
• Deployed reports on Report Server as well as Share point Environment.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Control source code of database, reports and packages using Visual Safe Source control.
• Have worked with different people from different team to finish the business requirement.
• Created design and technical document at the end of Project for users with Data model.

Environment: SQL Server 2008 R2,SSIS,SSAS,SSRS, SharePoint Services 3.0, .NET, C#, Business object.

Client: Confidential,MT Laurel, NJ Feb’10 – Dec’10
Role: SQL Database Developer/ (SSIS, SSRS)

Project Description: AAA mid Atlantic basically provides all kind of services. AAA Mid Atlantic is a leading provider of customer services including in many aspects like membership, shopping, travel, insurance, banking and loan for members.My responsibility was implementation and maintenance of databases, Application Development, Generating reports and Analyzing data.

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Created partition table for very large database for good performance.
• Participated Databases Architecture and data Modoling design for enterpise data warehouse.
• Worked on installing, configuring and supporting database systems.
• Involved in Import/Exporting of Data to/from SQL database.
• Involved in Database Analysis and Normalization.
• Wrote store procedures for some job automations.
• Created Indexes and involved in Performance tuning.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.

Environment: MS SQL Server 2005 and 2000, SQL Server Reporting Services, SQL Server Integration Services, OLAP.

Client:Confidential, INDIA Jan’07 – July’08
ROLE: SQL Server Developer

Project Description: RDMS is the Reference Data Management for the wealth Alternate Investment division to centralize the creation of all the Investment (Funds, Deal, Assets and Position) and Investor (Funds, Vehicle) Related Entities for Credit Derivate risk and Trade level Platform.

Responsibilities:

SQL Server 2000 RDBMS database development including T-SQL programming.

• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Developed stored procedures, functions, views and triggers.
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
• Generated dynamic stored procedures, xml stored procedures, triggers for the database development.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created Users and Roles, and managed security and permission of database.
• Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.

Environment:SQL Server 2000, MS Access, Erwin 4.1, SQL Query Analyzer, Crystal Report.