SUMMARY

• Strong 7.2 years of Experience in IT industry, currently working as MSBI Technologies and various reporting technologies.
• Solid understanding of the software development in an Agile environment.
• Ability to provide technical and strategic solution, collaborate with Project Manager, Business Analysts, Developers and QA/ Testers to size and estimate project efforts, define task dependencies and deliver solutions.
• Having sound knowledge in Data Warehouse development, implementation and support.
• Strong experience with SQL Server 2005/2008/2008 R 2/2012/2014/2016 and MSBI Stack (SSIS, SSAS and SSRS).
• Had solid experience in Database Design, development and database architecture (creating objects, indexing strategies, etc.)
• Had Sound knowledge in Data Modeling Techniques (relational, dimensional), Data Model Concepts (conceptual, logical, physical).
• Had experience creating and maintaining the enterprise data warehouse using ERWIN data Model Tool.
• Experienced in developing Functions, Stored Procedures, Views, and Triggers, Jobs.
• Strong experience on T - SQL and query optimization and excellent experience in Analyzing, Coding, Implementing SQL queries and procedures using SQL Server.
• Had solid experience in Migrating and UpgradingSQL server objects from older versions (2005,2008,2008 R2) to new versions (2012,2014/2016).
• Experience in creating SQL Server jobsand Scheduled SSIS Packagesin SQL server agent.
• Good knowledge and exposure in DBA activities likeDatabase Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Extensive experience ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like SSIS, Informatica.
• Expert in ETL (SSIS) and DTS packages to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Excel, XML, CSV, flat file, Text Format Data.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for Fact and Dimensions Tables using Analysis Services.
• Good experience and understanding of OLAP, OLTP, Cubes and normalizations.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Basic understanding of writing and debugging MDX queries.
• Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014/2016 ) and involved in creating drill down reports, parameterized reports, linked reports, sub reports, matrix and charts.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, Graphs, web reporting by customizing URL Access.
• Proficiency in creating differenttypes of reports such as Charts, Conditional, Graphs, Summary Form, Pivot tables, Lists, Sub reports, Matrix Reports and formatting them.
• Developed Dashboards using SSRS. Created action filters, parameters and calculated sets for preparing dashboards.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating Data Driven subscriptions to different users using Report Manager.
• Experience in report performance tuning, SQL tuning and following best practices.
• Sound knowledge in SSRS Portal Branding.
• Experience in creating the Subscriptions for SSRS reports.
• Experience in creating interactive dashboards and visualizations using Power BI.
• Experience in setting up the personal gateway to refresh the dashboards in Power BI website.
• Had experience in hosting data warehouse and databases in Cloud environment like SQL AZURE, AMAZON web services (AWS).
• Have good knowledge in promoting the codes between the different environments like DEV,QA, UAT, STAGE and PROD environments.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations.
• Have experience on writing PowerShell scripts for automating tasks and process for end to end automation.
• Have knowledge in automation deployment of SSIS ETL packages through scripts.
• Have experience in developing and maintaining the .NET technologies like C#.
• Have sound knowledge in VB6 and experience in debugging the .NET coding.
• Had sound knowledge in Microsoft Power BI and Informatica.
• Experience in maintain the ETL, report Source code in the Team Foundation Server (TFS) source control tool and SVN tool.
• Knowledge in Data Analyzer tools like Informatica Power Exchange to capture the changed data.
• Having good logical skill and Capable of learning new things easily.

TECHNICAL SKILLS

Languages: T-SQL, C#,.NET,PL /SQL,Oracle, MYSQL, PowerShell, VB6

ETL tools: (Microsoft BI) - SQL Server Integration Services (SSIS), Informatica, Talend

Reporting & Analysis Tools: SQL Server analysis services (SSAS),SAIKU, Power BI, SQL Server Reporting Services (SSRS), crystal reports, pentaho, Tableau, Looker

Databases: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Oracle, MS Access,snowflake

Service and Quality Management: JIRA, Pivotal Tracker, Source Gear Vault, Rally, SVN, TFS

Other related tools: Business Intelligence Development Studio 2008/2012, Visual Studio, MSOffice, SQL Server Management Studio, Endeca Development Management Studio, Active Batch, MicrosoftVisio, Beyond compare, SQL tool belt, BI - Xpress

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

BI Consultant

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures in SQL server and Replicating the database objects to snowflake database.
• Responsible for logical and physical design of SQL Server databases.
• Analyzing and improving the performance of databases and its objects.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Analyzing and Creating Ad-hoc reports using Looker.
• Migrating the SSRS reports to Looker reporting tool.
• Had involved in creating the dashboards and visualizations using Power BI and created security groups to secure the reports from unauthorized users.

Environment: SQL Server 2016, SQL Server Integration Services 2016, SQL Server Reporting Services 2016, Business Intelligence Development Studio, Power BI, Looker5.0, snowflake.

Confidential, Plano, TX

SQL BI architect

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
• Designed complex cube's MDX spaces: static and dynamic sets, calculated members with custom calculations at the different hierarchy levels, scopes
• Extract Transform Load(ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS)
• Had involved in creating the dashboards and visualizations using Power BI and created security groups to secure the reports from unauthorized users.
• Published reports and dashboards in power BI website and setup the personal gateway to refresh the dashboards in scheduled time.
• Implemented row level security to secure the data in the power BI reports.
• Created content packs for the reports in PowerBL.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.
• Created subscriptions to provide a daily basis reports.
• Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 8.1/8.2 and Tableau 9.
• Managed and troubleshoot report server related issues.
• Experience in report performance tuning, SQL tuning and following best practices.

Environment: SQL Server 2016, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio-SQL, Power BI, DTS,MDX, DAX, SQL Profiler, OLAP, OLTP, MS-Excel, Tableau.

Confidential, New York, NY

Senior MSBI developer

Responsibilities:

• Designed and developed ETL process to extract Test to load the murex backtest results file into murex back test system and to Enterprise Services warehouse using SSIS.
• Huge experience as a data analyst in identifying the slowly processing data areas and can improve performance of databases rapidly.
• Enable the reference architecture and design solutions for several specific data warehouse issues: enterprise key assignment process, data migration and integration, complete ETL audit and catalog process, multi-source (including legacy systems) data acquisition, data archival strategy, and data analysis for business specific applications.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), ETL package design, and RDBM systems like SQL Server and oracle.
• Team player with excellent communication and problem-solving skills.
• Worked with production support team for a while to handle high priority issues.
• Responsible for designing and developing the database objects like Tables, Views, and Complex T-SQL Store Procedures involving Joins and using Temporary Tables, UDF (User Defined Functions).
• Development ofcustom scripts and stored proceduresfor data import and manipulation
• UsedSQL Profiler and Index Tuning Wizardfor tracing slow running queries and stored procedures.
• Evaluated database performance and performed maintenance duties such as tuning,backup, restoration and disaster recovery.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Environment: MSBI SSAS, SSIS, SSRS, Multi-Dimensional, SSRS reports, SQL Server 2012/2008 R2, Windows server 2008 R2, T-SQL, SharePoint 2010/2013, MS-Visio, XML, XSLT, XSD.

Confidential - Eden prairie, MN

Senior MSBI developer

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.
• 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.
• 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’s, using SSAS.
• Created Parameterized, Cascaded, Drill-Down, Cross-Tab and Drill-through Reports using SSRS 2008 and generated adhoc reports on demand for providers.
• 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 2008 R2.
• Responsible for designing and developing the database objects like Tables, Views, and Complex T-SQL Store Procedures involving Joins and using Temporary Tables, UDF (User Defined Functions).
• Integrated the SSRS reports into web applications using Report viewer control, URL methods and creating Data Driven subscriptions to different users using Report Manager.
• Involved in loading the data to data warehouse, processed OLAP cubes and reports are being loaded in SSRS by MDX queries from OLAP cubes.
• Had involved in creating the dashboards and visualizations by using KPI, Gauges and charts in Power BI and created security groups to secure the reports from unauthorized users.
• Published reports in Power BI service.
• Implemented row level security to secure the data in the power BI reports.

Environment: MSBI, SSAS, SSIS, SSRS, Multi-Dimensional, SSRS reports, SQL Server 2008 R2, Windows server 2008 R2, T-SQL, SharePoint 2010/2013, MS-Visio, XML, XSLT, XSD, Power BI.

Confidential, Boston MA

SQL /MSBI developer

Responsibilities:

• Actively involved in all the phases of Software Development Life Cycle (SDLC).
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data warehouse (EDW).
• Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.
• Implemented incremental loading into the destination.
• Having experience in creating the Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers.
• Designed ETL for implementing Slowly Changing Dimensions to maintain historical data.
• Created configuration files to deploy SSIS packages across all environments
• Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.
• Created the complex stored procedures, user defined functions to encapsulate the business logic.
• Created views, indexes, and user defined data types and implemented the cursors, triggers as
• Followed best practices in writing T-SQL queries as a regular daily routine.
• Involved in monitoring the SQL jobs using Active batch tool and Bi-Xpress Monitoring Tool.
• Involved in performance tuning of queries using query execution plans, SQL Profiler and DMVs.
• Responsible for creating the reports using the SQL server reporting services.

Environment: MSBI, SSAS, SSIS, SSRS, Multi-Dimensional, SSRS reports, SQL Server 2008 R2, Oracle, Windows server 2008 R2, Active batch, Bi-Xpress, T-SQL, MS-Visio, XML, XSLT, XSD.

Confidential - Health spring, Tennessee

MSBI Developer

Responsibilities:

• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes.
• Created detail design, work on development and perform code reviews.
• Created tables and Adhoc reports from DW.
• Involved in Production support for existing DW. (L1, L2 Support)
• Design and develop data model and creation of complex stored procedures.
• Designed the layout of the SSRS reports.
• Performance tuning of the stored procedures.
• Worked on normalizing the tables and worked on reducing the size of the database by analyzing and removing the unused columns and invalid data from the data staging tables.
• Implementing the request in production.
• Production Support during the Warranty Period

Environment: SQL Server 2008 R2, My SQL, MSBI, SSAS, SSIS, SSRS, Multi-Dimensional, SSRS reports, SQL Azure, Windows server 2008 R2, T-SQL,MS-Visio.

Confidential, New York, NY

SQL /MSBI developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Have experience in setting up the data warehouse in SQL AZURE environment.
• Have knowledge in creating SQL Azure databases and deploying reports in it.
• Alter the schema for the required objects. Designed and optimized all the SSIS packages.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS and pentaho.
• Developed ETL process using Pentaho PDI to extract the data from sources and loaded into datamart.
• Analyzed, designed, built and tested OLAP cubes with SSAS and in adding calculations using MDX.
• Created cubes using multiple dimensions and modified relationship between a measure group and a dimension, created calculated members and KPI, using SSAS.
• Created Parameterized, Cascaded, Drill-Down, Cross-Tab and Drill-through Reports using SSRS 2008 and generated adhoc reports on demand for providers.
• Involved in creating SSRS dashboards.
• Experience in writing C# codes for the ETL packages.

Environment: SQL Server 2008 R2, My SQL, MSBI,SSAS, SSIS, SSRS, Multi-Dimensional, SSRS reports, SQL Azure, Windows server 2008 R2, T-SQL,MS-Visio,pentaho.

Confidential, New York, NY

Senior Data Analyst

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.
• 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.
• Involved in tuning the existing T-SQL code for performance improvement.
• Followed the best practices in writing T-SQL for universal readability and reusability of code.

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