SUMMARY

• Around 7+ years of experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2008/2005/2000 , SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008/2005/2000 .
• Excellent knowledge in creating Databases, Tables, Stored Procedure, Views, User defined data types, Cursors and Indexes using T - SQL.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Deployed database objects from development/testing environment to production environment with ETL/Data Warehousing
• Experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility and SSIS services.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Created many complex SSIS packages with transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Conditional Split etc.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports using SSRS.
• Ability to work with team with SQL Profiler and Query Analyzer to identify performance issues.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Knowledge in query optimization & performance tuning using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Expert in planning and scheduling backups and restoring databases.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Expert in planning and scheduling backups and restoring databases.
• Good understanding of ACID properties, RDBMS and Normalization /De-normalization.
• Knowledge in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008/2005/2000 , MS Access, MS Excel. Teradata

Programming Languages: T-SQL, PL/SQL, C, C++, HTML, XML, Java

ETL Tools: SQL Server Integration Services (SSIS), Data TransformationServices (DTS), Data Warehousing, Informatica, Data Stage.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Cognos

SQL Server Tools: SQL Server Management Studio (SSMS), Business IntelligenceDevelopment Studio (BIDS), Query Analyzer.

Operating Systems: Windows 98/2000/2003/ XP/NT/VistaData modeling Tools Erwin 7.2

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Server/BI Developer

Responsibilities:

• Developed and Optimized database structures, stored procedures, views and user - defined functions for the application.
• Managing of database objects like Tables, views, indexes etc.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• High Level Design of ETL SSIS Package for integrating data from heterogeneous sources (XML, Excel, CSV, flat file, Text Format Data)
• Responsible for database backups, restoration and scheduling backup strategies.
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Suggested creating Clustered and Non Clustered indexes on tables
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Formatted the reports using the Global variables, expressions and Functions.
• Optimized SQL statements for customer summary reports.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Migrated DTS packages to SQL Server 2005 Integration Services and modified the existing packages accordingly by using the advanced features and tools such as Script Component, Script Task, Lookup, Derived Columns, Condition Split, Union All, Copy Column, Aggregate, Audit Transformations etc.
• Responsible for developing drilldown reports using MDX and SQL.
• Built MDX queries for Analysis Services & Reporting Services.
• Designed the flow template and structure with staging area for data extraction and processing using SSIS for creating packages and populating the warehouse database.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore, Rebuild Indexes on Various tables.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created OLAP Cubes and deployed those using SQL Server Analysis Services (SSAS).
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Expertise in report generation using SQL Server Reporting Services 2005/2008 (SSRS).
• Created simple SSRS Daily Sales Summary Reports which show the daily sales, MTD Sales, YTD Sales.

Environment: MS SQL Server 2008 R2/2005, SSIS 2008, SSRS 2008, SSAS, DTS, T-SQL, SQL Server Profiler, Windows XP, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS),MS Access 2007.

Confidential, Plano, TX

SQL Server/BI Developer

Responsibilities:

• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created complex stored Procedures, triggers, cursors, and other SQL joins and statements for applications.
• Created clustered/ non clustered Indexes and maintained FILL FACTOR for fast and efficient reporting process.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Designed SSIS packages with Error Handling and email notifications.
• Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Implemented Incremental loads and Data split using different kind of transformations like Row count, Sort, Merge, Fuzzy lookup, Multicast using SSIS.
• Transformed data from one server to other servers using tools likeBulk Copy Program (BCP)andSSIS.
• Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Responsible for identifying and defining data source and data source views.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: MS SQL Server 2005/2008, SSIS/SSAS/SSRS, MS Access, Windows NT, Windows XP, MS SQL, ERWIN 7.0X, SQL Profiler, SQL Query Analyzer, T-SQL, MS SQL Server Integration Services 2008/2005, DTS, ASP.NET, MS Office.

Confidential, Columbus, OH

SQL Server/BI Developer

Responsibilities:

• Wrote complex T-SQL queries for reporting and data extraction from SQL Server.
• Wrote Complex Stored Procedures, Functions.
• Created new tables structures according to Business rules.
• Created DTS packages to export and import data from DB2 database excel to text using SQL server 2008/2005.
• Managed the products and development databases including performance tuning, SQL Server clustering, Log shipping, database security configuration.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Developed, modified, and optimized complex queries to data retrieval and modification
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server 2008.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package
• Used Lookups Transformation to get the data from data sets.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Generated complex custom reports using SSRS 2005 as per customer requirement.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created complex SSRS reports using data mart as well as from the SSAS Cube.

Environment: SQL Server 2005/2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS, SQL Profiler, MS Access, Visual Studio 2008, SQL Profiler, Query Analyzer.

Confidential, CA

SQL Server/BI Developer

Responsibilities:

• Wrote complex T-SQL queries for reporting and data extraction from SQL Server.
• Wrote Complex Stored Procedures, Functions.
• Created new tables structures according to Business rules.
• Created DTS packages to export and import data from DB2 database excel to text using SQL server 2005.
• Managed the products and development databases including performance tuning, SQL Server clustering, Log shipping, database security configuration.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Developed, modified, and optimized complex queries to data retrieval and modification
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server 2008.
• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package
• Used Lookups Transformation to get the data from data sets.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Generated complex custom reports using SSRS 2005 as per customer requirement.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created complex SSRS reports using data mart as well as from the SSAS Cube.

Environment: SQL Server 2005, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS, SQL Profiler, MS Access, Visual Studio 2005, SQL Profiler, Query Analyzer.

Confidential

SQL Server Developer

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Designed reports using SSRS according to the customer requirements.

Environment: SQL Server 2000/05, SSRS, SSIS, Query Analyzer, Enterprise Manager, DTS Designer, Index Tuning Wizard, Windows XP, MS Excel, MS Access.