SUMMARY

• Extensive experience in SQL Server database development in banking, health care and retail domains including database design and development.
• Extensive experience with SQL Server and T - SQL in constructing Tables, Triggers, User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experienced in developing database scripts (DML/DDL), Stored Procedures and other database objects necessary to accomplish project objectives
• Good knowledge throughout database development for both OLTP (batch processing and online processing) and OLAP Systems (SSRS, SSIS and SSAS) using SQL Server 2012/2008R2/2008/2005
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat File and Oracle to MS SQL Server by using BCP utility, DTS and SSIS services
• Extensive ETL experience using DTS/SSIS for data extractions, transformations and loads
• Good experience in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with the ability in generating Drill Down and Drill through reports with Drop down menu option
• Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running database consistency checks using DBCC.
• Good knowledge in scripting T-SQL Queries, complex Stored Procedures, User Defined Functions (UDF) and database Triggers.
• Experienced in Oracle supplied packages, dynamic SQL, records and PL/SQL tables
• Extensive experience in Tableau in enterprise environment
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence process for data integration and migration services.
• Experienced in high-level design of ETL packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat File and Text Format Data) by using different transformations
• Good experience in creating SSIS Packages to manage SQL Server databases and SQL Server objects between instances of SQL Server
• Extensive knowledge in designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data
• Strong experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Expertise in creating perspectives, partitions and design aggregations in cubes using SSAS
• Expertise in creating dashboard reports to support end users using SSAS.
• Experienced in developing OLAP cubes using SSAS for data mining and created reports from OLAP cubes using SSRS and Report Builder 3.0.
• Expertise in building Star Schema and Snow Flake Schema depending on business requirements and working with Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).

TECHNICAL SKILLS

Languages: C, T-SQL, PL/SQL, JavaScript, C#, VB.Net, .Net, VBA

RDBMS: SQL Server 2012/2008R2/2008/2005 MS Access and MySQL, SQL Plus.

Frontend: MS Visual Basics 6.0

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting and PowerShell 2.0.

Version Control: Visual SourceSafe and Clear Case

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS and Data Transformation Services.

Data Modeling: ERwin R7.3/7x/4.0 and MS Office Visio 2003/2007

Operating Systems: Windows 2000, Windows Server 2003, Windows NT, Windows XP/Vista/7/8 and Linux

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML Database Design and Normalization

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases and Data Mart databases.
• Developed SSIS templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into development, test and production environment, and extracted data using SSIS from OLTP to OLAP
• Upgraded FACETS System from version By using FACETS enables health plans to achieve operational efficiency
• Handled premium billing, commissions, capitation and reporting by using FACETS
• Ensured that claims are processed without any provider related issue, implemented a process for regular maintenance at provider
• Generated error reports on provider and claims data.
• Implemented Data Warehouse design principles and best practices for maintaining dimension and fact tables
• Generated parameterized reports and cascaded parameterized reports.
• Executed data validation Stored Procedures in SSIS Packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call Packages and Stored Procedures.
• Modified measures, dimensions, attributes, hierarchies and measure groups and deployed changes to cube in SSAS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Server (SSAS).
• Analyzed, designed, built and tested OLAP cubes with SSAS and in adding calculations using MDX.
• Created a cube using multiple dimensions and modified relationship between a measure group and a dimension, created calculated members and KPI is, using SSAS.
• Created Parameterized, Cascaded, Drill-Down, Cross-Tab and Drill-through Reports using SSRS 2008 and generated adhoc Tableau reports on demand for providers.
• Generated Tableau Dashboards with multidimensional database
• Remodeled existing DW as well as created logical and physical data model for new Data Mart.
• Developed Stored Procedures and Triggers for application
• Analyzed, designed, built and tested OLAP cubes with SSAS and in adding calculations using MDX and DAX.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.

Environment: Microsoft SQL Server 2012/2008/2005 , MS Access, SSAS, SSIS, SSRS, HTML, Visual Studio 2005/2008/2010 , IIS, Query Analyzer, ERwin, Windows Server 2008R2, DTS, TSQL, .NET, SQL Profiler, DTS, Team Foundation Server, Visual SourceSafe and Tableau 7.0.

Confidential, Ann Arbor, MI

SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2008R2/2012
• Strong experience in using BODS as an external system for ETL between ECC and BI
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Worked with users in and support and have experience in incremental data loading.
• Managed up gradation of DTS packages to SSIS packages
• Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
• Designed and created MDX and DAX Queries to retrieve data from cubes using SSIS.
• Good knowledge throughout database development for both OLTP (Batch Processing, Online Processing) and OLAP Systems (SSRS, SSIS and SSAS) using SQL Server 2012/2008R2/2008.
• OLAP design (SSAS 2008R2) for different cloud services and service items Implemented OLAP cube and connecting using Excel PowerPivot.
• Enabled logging, database mirroring and replication for SSIS (ETL) packages
• Configured server for sending automatic mails to respective people on SSIS (ETL) process failure or success
• Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.
• Created various weekly and monthly reports showing detailed information in SSRS
• Created cross-tab, drill-down, parameterized and sub-reports using Report Definition Language (RDL).
• Created Data Mart by taking into various business processes by identifying different dimensions and facts
• Utilized Merge Join in SSIS and merge statement to populate Data Warehouse from a source database, which provides efficient and granular level of control
• Performed data profiling tasks in SSIS (ETL) using Data Profile Viewer and then clean and standardize data as appropriate for databases.

Environment: Microsoft SQL Server 2008/2012, Visual Studio 2008/2010, T-SQL, PowerPivot 2012 Team Foundation Server, SQL Server Analysis/Integration/Reporting Services and Share Point 2010/2013.

Confidential, Austin, TX

SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Used SSIS to migrate data from databases such as Oracle and SQL Server database, flat files to centralized IT destination and built SSIS Packages to pull data from Teradata.
• Developed monitored and deployed SSIS packages and created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy data.
• Used Event Handlers for exception handling in SSIS Packages
• Developed incremental data logic to load data into SQL Server using SSIS from Teradata
• Developed Report Models using Report Builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel PowerPivot table based on OLAP cubes.
• Identified and worked with multivalve parameters for parameterized reports in SSRS.
• Developed monitored and deployed SSIS packages and created dynamic configuration packages in SSIS.
• Conducted error handling in SSIS (ETL) using Event Handlers
• Designed and built dimensions and cubes with Star Schema using SQL Server Analysis Services (SSAS).
• Trained the end-users to access OLAP cube using Excel Powepivot
• Developed and supported client facing ASP.NET web applications that use SQL Server as a backend that meet functional and information requirements of the user community.
• Used Teradata SQL Assistant to extract data from Data Warehouse
• Wrote VB.NET (Framework) code, according to the requests
• Developed and maintained old and new VB.NET environments.
• Experienced in programming in VB.NET Framework, VBA and SQL
• Developed Excel templates (VBA, Macros) that retrieved information
• Developed VBA programs to export and import data
• Developed Access/VBA programs to convert Excel data into XML format
• Used JSON objects to communicate between request and response, pass as the parameters.
• Created documentation on each step in database and execute quality assurance test plans.

Environment: MS SQL Server 2008R2/2008, SQL SSIS, SQL SSRS, PowerPivot, T-SQL, Oracle, PL/SQL, SQL Plus, Visual Studio 2012, .NET (C# and VB), VBA, Windows Server 2012, MS Office 2010. SQL Server Management Studio, MS Excel, Teradata and Erwin

Confidential

SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Worked as a Developer in creating complex Stored Procedures, Triggers and Functions
• Managed Index Statistics, Tables, Views and Cursors, optimized Queries using execution plan for tuning database, and implemented different types of constraints on tables.
• Used try catch and @@error for exceptional handling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and Index Tuning Wizard
• Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio
• Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS).
• Created Drill-Through, Drill-Down, Cross Tab Reports and Sub-Report using RDL
• Created queries for generating drill down reports in SSRS 2008/2005
• Formatted SSRS reports using global variables, expressions and functions
• Used SSIS Import/Export, migrated heterogeneous database such as Oracle and Access database, flat files to SQL Server 2005
• Configured replication servers and transactional replication between production and standby server for disaster recovery

Environment: MS SQL Server Management Studio 2005, MS SQL Server Integration Services (SSIS), Oracle 9i, SQL Server Reporting Services (SSRS), C#, TFS, Microsoft Visual SourceSafe and JavaScript.

Confidential

SQL Server BI Developer

Responsibilities:

• Ensured project requirement and delivery with active interactions with end users
• Redesigned and tuned Stored Procedures, Triggers, Tables, UDF, Views, Recursive CTE and Indexes and able to increase performance of queries
• Created complex Store Procedures for data profiling process needed to define structure of pre staging and staging area
• Developed DTS packages to extract, transform and load into campaign database from OLTP database.
• Used SSIS control flow task, analysis service processing task to individually process partitions and dimensions and updating cube as changes occurs in underlying Data Warehouse.
• Designed ETL data flows using SSIS and created mappings/workflows to extract data from SQL Server and data migration and transformation from Oracle/Access/Excel Sheets using SSIS.
• Involved in all phases of report life cycle (authoring, managing and delivering)
• Created adhoc reports and complex enterprise reports (drill down, drill through reports, parameterized reports and cascading report) using SQL Server Reporting Services and Report Manager
• Created linked reports using Report Builder.
• Used notification services to generate error messages and send them to user through e-mails.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, MS Visio 2000 and MS Projects 2000

Confidential

Junior SQL Developer

Responsibilities:

• Conducted performance tuning/MS SQL Server development - SQL Profiler, SQL scripts, Stored Procedures, Triggers, Functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Created and developed Stored Procedures and Triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager
• Created and administered multiple development, and production databases.
• Developed and created data dictionary, advanced queries, views, indices and functions for databases.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server

Environment: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Team Foundation Server (TFS), XML, HTML and ERwin.