SUMMARY

• 7+ years of experience in design, development & analysis of SQL Server 2005/2008 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise in writing T-SQL Queries, sub-queries and complex joins for generating Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• T-SQL Programming using DDL, DML, DCL commands for various business applications
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• ETL implementation using SQL Server Integration Services (SSIS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008/2005/2000 , Oracle 10g/9i/8.0, MS Access, MS Excel, DB2.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, DTS, Crystal Reports9.0, Lite speed, MDX.

Languages: T-SQL, PL/SQL, MDX.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, JavaScript.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

TECHNICAL SKILLS

Confidential, Murray, Utah

SQL Server Data Reporting Analyst

Responsibilities:

• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS).

Confidential, Des Moines, Iowa

SQL / BI Developer

Responsibilities:

• Identified data source and define data source views.
• Design ETL packages from different sources and loaded data to target destination by performing transformation using SSIS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created Databases, Tables, Views, Indexes.
• Wrote complex stored procedures, queries, triggers.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for transferring the data using SSIS packages.
• Gathered user requirements.
• Developed Analysis Services Project.
• Responsible for Dimensional modeling.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for Understanding the world scope data feed, help design the target schema and develop an ingestion feed process using SSIS.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
• Involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Designed dimensional modeling with star and schema flakes Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Experience in creating Ad-hoc reports.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Documented all database objects and packages for future references.
• Educated team on load process and data movement changes.
• Analyzed and designed of software and database solutions.

Environment: MS SQL Server 2005, MS SQL Server 2000,, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, Windows XP, Oracle, T-SQL, Query Analyzer.

Confidential, Somerset, NJ

SQL BI Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Deployed the generated reports on to the server.
• Assisted in migrating denormalized report DB into a Star Schema design.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C# Oracle, T-SQL, Query Analyzer.

Confidential

SQL Server Developer

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.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented the Logical and Physical model of the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Maintained the consistency of the client’s Database using DBCC.

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