SUMMARY

• Around 7 years of IT experience as a MS SQL Server Developer specializing in database design, development & administration work wif SQL Server 2008, 2005 and 2000 for OLTP, OLAP and large - scale data warehouse applications.
• Over 5+ Years of experience in data warehouse development wif Integration Services, Analysis services and OLAP report development.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries wif T-SQL, Database Design including ER diagrams, normalization
• Experience in Data Modeling & Database Design wif ERwin, MS Visio Performance Tuning and Optimization of SQL Server 2005 and 2000.
• Experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Hands on experience in migrating DTS packages to Integration Services Packages.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Extensive experience in developing and deploying SSIS 2005 packages.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS)
• Experience in migration of MS SQL Server 2000 to MS SQL Server 2005 (Side by Side).
• Knowledge of Analysis Services and Reporting Services, Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Strong Knowledge in database modeling concepts, MDX
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), BULK Insert and Log shipping
• Used Performance Monitor or SQL Profiler to solve dead locks/long running queries
• Management of schemas, Data modeling, objects & partitioning teh tables & indexes.
• Monitoring and tuning SQL Server performance wif multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard
• Experience in troubleshooting DEADLOCKS by adding TRACE FLAGS
• Sound knowledge of SQL Server 2005 novel concepts like Data partitioning, Sliding window implementation, Snapshot Isolation, Online Indexing, Try-Cache Blocks, Dedicated Admin Connection (DAC), Data Base Snapshot, Common Table Expression (CTE), DDL Triggers, Dynamic Management Views (DMV) & Dynamic Management Functions (DMF)
• Closely worked wif development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, triggers.
• Good knowledge in Normalizing and De-normalizing teh tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Worked wif business customers in Gathering and documentation
• Experience in installing, configuring and monitoring MS SQL Server 2008/2005/2000 installations.
• Good knowledge and exposure to Database Mirroring, Replication, Logshipping, backup and restore procedures, disaster recovery
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA(DATA BASE ENGINE TUNING ADVISOR), Upgrade Advisor

Monitoring & compliance Tools: Spotlight, SQL secure, SCOM

Business Intelligence Tools: SQL Server Integration Services(SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Crystal Reports

RDBMS: MS SQL Server 2008/2005/2000 , Oracle 10g/9i,MS Access

Languages: SQL,T-SQL,PL/SQL,C,C++,JAVA,C#,VB

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web Technologies: HTML,XML,VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Data warehousing tools: Informatica, Business Objects, Cognos, Erwin

Other Tools: Visual Studio 2008/2005,Visio,Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

SSIS/SSRS/SSAS /SQL SEVER Developer

Responsibilities:

• Involved in installing and configuring of SQL Server 2005 in remote installations. Performed system administration tasks related to installation and security of SQL Servers in very large database (VLDB) environment.
• Involved in Data modeling for OLAP system and designed logical and physical models using Erwin 7.0 & Visio 7.0
• Creating and managing schema objects such as Tables, Views, Triggers, Stored Procedures, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and user profiles wif privileges in SQL server 2005 as per teh Service Legal Agreement (SLA).
• Worked on Performance Tuning, Query optimization and execution plan of query for better performance
• Performing database consistency checks using DBCC Utilities and handling data corruption in user databases.
• Creating Linked Servers between different SQL Servers in SQL Server 2005/2000 environments to access database objects in remote locations.
• Worked wif SQL Server Litespeed tool for backup and recovery and Implemented Database Mirroring to provide high availability and fault tolerance. Used Data modeling concepts
• Configured Transactional replication between Primary Server and three Read - Only servers, wif separate Distributor server to offer load balancing and offline processing.
• Coordinating wif teh development team regarding tuning teh SQL queries and stored procedures to improve performance using SQL Profiler.
• Monitoring teh performances of indexes and tuning them to optimize performance using Index Tuning Wizard.
• Identifying teh bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Created and scheduled jobs to setup log shipping between production servers to increase availability of production server by maintaining a backup server.
• Dealt wif Service Broker SSB and Multi dimensional Expressions(MDX)
• Configured teh Log shipping and created Standby server to increase availability of teh server.
• Used Extract, Transform and Load (ETL) processes to transform data from heterogeneous data sources to SQL Server 2005 to facilitate reporting services.
• Involved in transfer of user profiles from SQL server 2000 to SQL Server 2005 using DTS and transferred DTS packages using SQL Server Integration Services (SSIS).
• Worked wif DTEXEC and DTUTIL utilities for SQL Server Integration Services (SSIS) and generated various reports using SQL Server Reporting Services (SSRS).
• Design and develop OLAP cubes for Multi dimensional data reporting using SSAS 2005.
• Create Dimensions/Filters for teh cubes
• Involved in Analyzing, designing, building and testing of OLAP cubes wif SSAS 2005 and in adding calculations using MDX.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries wif MDX.
• Developed OLAP Star Schema and created Cubes using SSAS and Writing MDX expressions for cube calculations and KPIs.
• Grant privileges to user(s), role(s), and object(s). Support column level privileges.
• Administrate security for server’s logins (Windows and SQL Accounts). Used temporary tables, table variable and common table expression (CTE) depending on work

Environment: MS SQL Server 2008/2005, Windows 2003/2008 servers, IIS, DTS, MS Access, SSIS, SSRS, SSAS, Litespeed, SQL server Management Studio

Confidential, Burbank, CA

SSIS/OLAP Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on teh given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain teh required results
• Creating dashboards for different departments, Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from teh present columns for teh given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP)
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Created Linked reports, Ad-hoc reports and etc based on teh requirement. Linked reports are created in teh Report Server to reduce teh repetition teh reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views..
• Refreshing teh cube to get teh latest information updated and deployment of Cubes to teh production server.
• Worked on large data warehouse Analysis services servers and developed teh different reports for teh analysis from that servers.
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).
• MS SQL Integration Services and Server 2005 as teh back end wif Cognos tool as front end

Environment: MS SQL Server 2005, MS Access, MS Excel, DTS, T-SQL, SQL Profiler, Index Tuning Wizard, Microsoft Visio, Cognos tool

Confidential, Dallas, TX

SQL Server Developer, SSIS /SSRS developer

Responsibilities:

• Developed and Optimized database structures, stored procedures, Triggers and Functions for teh application.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning teh database.
• Involved in Performance tuning teh Stored Procedures to by removing unnecessary cursors
• Created SSIS package using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, Execute SQL Task etc to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text File, MS Access and CSV Files to data warehouse
• Responsible for DTS to SSIS Migrations, designing and maintaining SSIS packages.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2005
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked wif users in training and support and also have experience in incremental data loading.
• Responsible for developing, monitoring and deploying SSIS packages.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Query for generating drill down and drill through reports in SSRS 2005.
• Formatted SSRS reports using Global Variables, Expressions and Functions for teh reports.
• Configured Report Model for developing ad-hoc reports by teh end-users.
• Involved in Data modeling.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor
• Created SSAS Cubes using snow-flake schema wif Facts, Measure Groups and dimensions.
• Created SSRS reports from Analysis Services using MDX and DMX Queries.
• Developed stored procedures to transform teh data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Creating and Maintaining Users roles groups and granting teh privileges to users and Groups and maintaining security up to date. .
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Used Database Maintenance Wizad, DBCC Statements to perform maintenance tasks on teh database.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability.
• Involved in implementation of replications like Snapshot and Transactional.
• Designed logical and physical data models using Erwin.

Environment: - MS SQL Server 2008/2005, Windows Server 2008/2003, DTS, SSIS, SSRS, SSAS, T-SQL, ERwin 4.0,MS Access, XML, MS Excel, Visual Studio 2005.

Confidential, Columbus OH

SQL Server-BI Developer/SQL DBA

Responsibilities:

• Develop SQL Server Stored procedures and SSIS Packages Scripts to extract data from teh database
• Worked as a developer to tune teh queries, run scripts and move teh database from production to development servers
• Worked in tandem wif BI Architects to ensure data compliance.
• Consulted wif other ETL designers and developers to make sure that teh business rules are implemented correctly.
• Participated in design of data integration components including ETL and web services as requirements analysis demands.
• Captured data requirements wif visual data models using MS Visio and DSV’s
• Developed stored procedures, advanced queries, triggers, views, and indexes by using T-SQL.
• Create and manage schema objects such as tables, views, indexes, procedures and triggers through SSMS.
• Create complex stored procedures and views for teh above modules which were used extensively for Reports.
• Created indexes on teh tables to get teh results of teh T-SQL queries faster thereby increasing performance.
• Monitored and scheduled teh batch jobs.
• Tune SQL queries using show plans and execution plans.
• Consulted on Report development using teh MS BI infrastructure.
• Developed, maintained and monitored Jobs created via ETL packages for data import/export routines, monitor database disk space utilization, design maintenance plans including database backup structures and migration of database.
• Developed Database Diagrams using Microsoft Visio
• Involved in unit testing of teh application.
• Ensured all scheduled administrative jobs are running/completed for production Servers.
• Participated in various meetings and conferences wif application teams to meet corporate milestones for database consolidation and data migration.

Environment: SQL Server 2005, SSIS, SSIS Packages, SQL Server Jobs, Microsoft Visio.

Confidential, CA

SQL Server Developer

Responsibilities:

• Developed logical and physical data models and created DDL scripts to create database schema and database objects.
• Designed Logical and Physical data models using ERwin data modeler.
• Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining SSIS packages
• Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server 2005 databases to flat files/CSV files and vice versa.
• Migrated SQL Server 2000 DTS objects to SQL Server 2005 integrated services (SSIS).
• Wrote SSIS Packages to migrate users, logins, stored procedures, and tables, deployed SSIS packages
• Designed SSIS Packages in visual studio environment for performing teh data migrations from Oracle, Sybase, Access and Flat Files to SQL Server 2005
• Created SSIS packages which include data staging like Importing, Cleansing, Parsing, Scrubbing by using SSIS tools.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Responsible for gathering requirements from teh customer for developing reports using SSRS 2005
• Designed various operational, drill-through and drill-down reports using SSRS.
• Developed queries, parameterized stored procedures for generating reports, identified and added teh report parameters.
• Formatted teh reports using teh Global variables, Functions and expressions.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Implemented Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Involved in General Database Administration, Query Performance tuning, and validated some of teh existing schema.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Used Database Maintenance Wizard to make necessary changes and to keep teh performance of teh server at acceptable levels. Involved in SQL Server Clustering and Database Mirroring implementation.
• Managed SQL user logins, database user accounts, server roles, database roles and its Permissions.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Implemented Snapshot, Transactional and Merge Replication models.

Environment: - SQL Server 2005, Windows Server 2003, T-SQL, DTS, SSIS, SSRS, SSAS, ActiveX, XML, Excel, Visual Studio .NET, ERwin

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written teh technical specifications.
• Involved in Data Administration and Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in performance tuning of T-SQL Queries and Stored Procedures, analyzing teh indexes to add, edit or delete indexes using SQL Query Analyzer.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages
• High Level Design of DTS Package for integrating data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data into MS SQL Server 2000.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers
• Created DTS Packages and T-SQL Stored Procedures for teh ETL Process.
• Responsible for fine tuning of teh database, trouble shooting, user administration, memory management, and running DBCC commands.
• Perform daily database backup & restoration and monitor teh performance of Database Server.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Addressed teh Replication Issues. Created new replications, DTS packages to maintain high availability of teh data between teh servers.
• Worked on DTS Package for transferring data from Database (Oracle and Text format data) to SQL Server.
• Analyzed and designed disaster recovery / replication strategies wif business managers to meet teh business requirements

Environment: MS SQL Server 2000, T-SQL, DTS, Microsoft Visual Source Safe, Visual Basic 6.0,Crystal Reports and windows NT, Enterprise Manager