SUMMARY

• Over 8 years of extensive IT professional experience with expertise in Business Intelligence, TSQL, Database Development and Technical Management.
• Hands on Experience with Integration Services (SSIS), Reporting Services (SSRS). And Analysis Services (SSAS).
• Expertise in Installing, Configuring, Managing and troubleshooting SQL Server 2012/2008R 2/2008/2005/2000 and excellent communication and analytical skills, can understand business requirements in various domains.
• Experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, SQL Joins, User defined Functions, Relational Database Models and Data Integrity.
• Optimized the databases by creating various clustered, non-clustered indexes and indexed views.
• Expertise in Creating SSIS Packages and migrating DTS Packages from SQL 2000 to SQL 2005, 2008R2 and 2012.
• Experience in developing complex SSIS Packages for integrating data from heterogeneous sources (Excel, Flat file, Oracle, IBM DB2) by using multiple transformations provided by SSIS such as Look-ups, Fuzzy Look-ups, slowly changing dimension with help of Event Handlers and Error Handlers etc..
• Experience in creating database backup and restore processes using SSIS.
• Experience in creating jobs through SQL Server Agent and scheduling DTS/SSIS Packages.
• Expert in designing reports using Cascading parameters, Parameterized Reports, ad-hoc reports and Crystal Reports using SSRS.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2012.
• Extensive experience in deliveringOLAPsolutions by developing Corporate Dashboard Reports usingSQL Server Reporting Services (SSRS).
• Experience in Developing and Extending SSAS Cubes, Dimensions, creating calculated measures, partitions, aggregations and Processing and Deploying SSAS objects.
• Thorough understanding of Kimball’s’ theory, KPIs, Perspectives and Translations.
• Experience in C# and VB.net scripting.
• Experience in Excel pivot services.
• Worked with report builder tool 3.0/2.0/1.0.
• Exposure to CMMI, ISO and QA processes, Team foundation server, visual source safe and version controlling etc…
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2012, 2008 R2/2008, SQL Server 2005, SQL Server 2000, Access, Oracle 8i/9i/10g, MYSQL, Data warehouse.

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP.

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows 7/vista/XP/98/95, MS DOS, Agile, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Champaign, IL

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Upgraded the databases and servers of SQL Server 2008R2 to SQL Server 2012.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous sources such as Oracle, IBM DB2, MS Access, MS Excel, Flat files into SQL Server 2008R2 and 2012 then transform and load into the data warehouse.
• Used Script task component to write C# .Net scripts as a part of data extraction and Data Manipulations.
• Implemented Event Handlers and Error Handling inSSISpackages and notified process results to various user communities. Experience in creating complex SSIS packages using proper control and data flow elements.
• Used For each loop for iterative loading and Send mail task for E-mail notifications.
• Experienced in taking Database full Backup and differential backup in daily Routine.
• Migrated DTS objects to SSIS environment.
• Great Expertise in DeployingSSISPackage to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Developed complex stored procedures, CTE’s, Merge queries, triggers and cursors.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated users and to administrative Clients.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Created Cubes with multiple dimensions, measures, hierarchy, Key Performance Indicators as well as slowly changing dimensions.
• Scheduled SSAS cubes through Analysis services processing task from SSIS.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL code.
• Optimized complex queries by looking at Execution Plan for better tuning of the database.
• Used various data compare tools to compare data from different servers.
• Installing windows roles, features and deploying applications using PowerShell scripting.

Environment: SQL Server 2008 R2/2012 Enterprise Edition, IBM DB2, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio 2008/2010, Visual SourceSafe 2005/2008 and Team Foundation Server.

Confidential, Mequon, WI

SQL BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2008 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes.
• Worked on scripting languages like batch scripting and PowerShell.
• Working experience with PowerShell 3.0 on windows server 2008 r2.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized complex queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Albany, NY

SQL BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables
• Created partitions of the Analysis Services cube to improve performance.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder 2.0.
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Hands on experienced in developing and deploying SSAS cube.

Environment: SQL Server 2008 Enterprise, WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, InfoPath, Access, Agile, Share Point Portal Server 2003, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio, C#, ASP.Net 3.5, VB.Net.

Confidential, Sunnyvale, CA

SQL BI Developer (SSAS\SSRS)

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created calculated measures, dimension members using MDX and user defined functions, named calculations using SSAS for generation of cubes.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages(SSIS), SQL Server Analysis Services(SSAS), MDX, .Net, VB.Net, HTML, IIS, Visual Studio, Visual Source Safe, DTS, T-SQL, Oracle 10g.

Confidential

SQL Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS, Visual Source Safe 2003, Crystal Report, Crystal Enterprise, Microsoft Visio 2000

Confidential

Junior Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Actively participated in developing T-SQL queries involving joins, stored procedures and views to implement security.
• Involved in the Normalization process to improve performance.
• Designed and developed forms using C#

Environment: C#.Net, SQL Server 2000, Windows 2000.