SUMMARY

• Experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment and Production Support.
• Experienced in end - to-end database development using MS SQL Server Experience in writing FUNCTIONS, TRIGGERS, CURSORS and programming in T-SQL to implement Stored Procedures and Functions for different tasks.
• Experience in Writing and Debugging Stored Procedures and Triggers, Troubleshooting database issues.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good noledge on SQL Server Analysis Services (SSAS).
• Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Worked extensively wif complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS)
• Experience in working wif SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Good Understanding ofStarSchema and SnowflakeSchemain Relational Data Warehouse (OLAP).
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Worked wif different methods of logging in SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces wif BIDS.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

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

Database: MS SQL Server 2014/2012/2008R2/2005/2000, MS Access, MySQL, Sybase, Teradata V2R5

ETL Tools: DTS, SSIS, Informatica power center

Languages: SQL, PL/SQL, T- SQL

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr MSBI Developer

Responsibilities:

• Working wif Finance and business users for gathering the requirements.
• Experience wif SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints in SSIS
• Worked on optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Implemented multidimensional cubes wif MDX calculations to support analysis needs and fast data retrieval
• Played a major role in production support of SSAS cube and SSIS jobs.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Checking Database Health by using DBCC Commands and DMVSand created dashboard reports.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction wif business stake holders, gathering requirements and managing the delivery.

Environment: Sql Server 2014/2012/2008R2/2005, T-Sql, TFS, Excel, MS Visio, Informatica Power center,Sybase, Oracle, Teradata

Confidential. Charlotte, NC

Sr MSBI Developer

Responsibilities:

• Working on gathering the requirements from business users
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Worked on creating stored procedures to retrieve data for different forms.
• Worked on generating XML files for the new fields added to link to the application
• Worked on debugging the stored procedures to get the values correct.
• Worked on creating repeatable sub groups so the columns under dat will return multiple rows on the forms.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Worked on stored procedure to improve the performance related issues.
• Working on Paragon Form generator to fulfill the change requests.
• Worked on creating the design document and data mapping for the source and target.
• Worked on creating the stored procedure and SSIS packages to load the data into the warehouse.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Unit Testing the SSIS packages wif respect to its flow and performance issues.
• Worked on creating many ad hoc and scheduled reports using SSRS.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS.
• Working on TFS version tool.

Environment: Sql Server 2012/2008R2/2005, T-Sql, TFS, Excel, MS Visio,Oracel,Teradata

Confidential, Lakeland,FL

Sr MSBI Developer

Responsibilities:

• Worked closely wif Architect and business on gathering the requirements for building a new application.
• Worked on creating ETL SSIS packages to load the data into relational database from a non-relation data source.
• Worked on creating mapping documents and requirement documents.
• Designed Star Schema in the process of data modelling
• Involved in creating stored procedures and performance improve process.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Created and Managed OLAP Cubes using SSAS.
• Create new tables, views, indexes and user defined functions.
• Unit Testing the SSIS packages wif respect to its flow and performance issues.
• Worked on creating many ad hoc and scheduled reports using SSRS.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS

Environment: Sql Server 2012/2008R2/2005, T-Sql, TFS, Excel, MS Visio

Confidentia, Charlotte, NC

MSBI Developer

Responsibilities:

• Worked on creating stored procedures to load data into Data Warehouse.
• Worked on creating stored procedures for Reconciliation process to calculate the variance
• Worked on Sql Server Reporting Services to generate different types of reports for various subsystems.
• Created many ad-hoc reports using SSRS for business users as per requirement.
• Developed various drill down and drill through reports which involved complex chart based reports.
• Scheduled Jobs to call SSIS packages and Stored Procedures using Sql Agent
• CreatedSSISpackages to automate the ETL processes included Meta data on record count, file size and run time
• Worked on developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and Processing SSAS objects.
• Worked on SSRS reports, SSAS OLAP cubes, dashboards or scorecards based on business requirements.
• Experienced in Building Cubes and Dimensions wif different Architectures and Data Sources for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
• Worked on Sybase database creating stored procedures to support legacy system.
• Experience in using Sql Advantage tool for Sybase
• Extensive worked on Tuning SQL queries to improve the query performance.
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.

Environment: Sql Server 2008R2/2005, T-Sql, Sql server Integration Services, Sql server reporting services, Sybase, Informartica, Excel, Sql Advantage, MS Office

Confidential, Charlotte, NC

MSBI Developer

Responsibilities:

• Worked on upgrading the process from sql server 2000 to sql server 2008R2
• Worked closely wif architect on building the architecture pan for upgrading the project.
• Leading the development team on migrating and developing new SSIS packages as required.
• Worked closely wif business analysts to resolve defects from start to end.
• Created the dynamic jobs and written stored procedures to call the jobs dynamically.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Monitored SQL Profiler and Database Engine Tuning Advisor.
• Scheduled Jobs to call SSIS packages and Stored Procedures using Sql Agent.
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• CreatedSSISpackages to automate the ETL processes included Meta data on record count, file size and run time
• Worked on creating and managing Star schema cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Created and Managed OLAP Cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Actively ensuring the production implementation of the new enhancements wif smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment:Sql Server 2008R2/2005/2000, T-Sql, MDX,MS-Office, MS Access,Visio,ErWin

Snap-On Business Solutions

Confidential, OH

Responsibilities:

• Interacting wif Business users, gathering and analyzing requirements.
• Worked on Developing SSIS Templates for Data Migration in sql server 2008R2.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Leading offshore team and coordinating things to onsite.
• Worked on creating Analysis and mapping documents.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and stored procedures to overcome the transformation constraints.
• Worked on migrating data from non-relational database to relation database.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages wif the use of environment variables.
• Developed and changed Procedures, Functions, Packages, Triggers, and Views using PL/SQL Provided support to development applications for various databases.
• Actively ensuring the production implementation of the new enhancements wif smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: Sql Server 2008R2/2005, Oracle, PL/SQL, T-SQL, MDX, MySQL,ERWIN,Visio

Confidential, IA

MSBI Developer

Responsibilities:

• Installing and Configuring SQL Server 2005, Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate Functions, and TEMPeffective Triggers to facilitate efficient data manipulation and data consistency.
• Written SQL Scripts to do the Data Profiling like clarify the structure, content, relationships and derivation rules of the data
• Designed partitioning strategies and storage modes for optimal performance in SSIS and SSAS
• Written integrated Stored Procedures to generate the Reports.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Various clustered/non-clustered indexes, triggers, check constraints and functions.
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.

Environment: Sql Server 2000/2005/2008,MySql,Visual Studio, MS Access, MS Excel, MS office 2007,T-sql,Pl/sql, MDX