SUMMARY

• Around 9+ plus years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2012/2016 in Development, Test and Production Environments, C#, .NET framework and on various business domains like Health care, Retail and Insurance.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS) including MS solutions like MS EXCEL, Microsoft Office SharePoint server 2007/2010/2013 Performance Point Server and ProClarity analysis server.
• Experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers and strong RDBMS concepts using SQL Server, T - SQL.
• Used all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Worked in develop visualizations / dashboards in PowerBI
• Experience with data modeling, logical and physical database design using Erwin.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Extensive Knowledge on Power BI pro, Power Bi premium.
• Strong experience in writing SQL Queries, Stored Procedures, Indexes, Views, User Defined Functions.
• Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008R2/2012/2016, PowerPivot (Excel 2010)
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in creating complex ETL packages using SQL Server 2012/2016 Integration Services (SSIS).
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD (Type 1, Type2), MERGE, CDC, Parent/Child and Date based SSIS package patterns.
• Excellent Hands on Logging, Error handling using Event Handlers (pre and post) and other techniques for SSIS Packages.
• Experience in designed Data Conversions from wide variety of source system using SSIS.
• Experience working with different SSIS Configuration options and Deployment Methods for different environments.
• Experience in Performance Tuning in SSIS packages by using Non-blocking streaming, Non-blocking Row based partially blocking and Blocking Transformations using synchronous/asynchronous transformations.
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, Table Variables.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel (Power pivot), Performance Point Service (PPS), Power view.
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Having 3 years of experience on Tableau Business Intelligence/Business Analytics software.
• Designed and built complex cubes using Multidimensional Expressions (MDX) of SQL Server and manipulating the multidimensional data stored in OLAP cubes.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Dimensions,
• Measures, Cubes, Data Source, Data Source Views and following Star and Snow Flake schema, Used MDX Queries, DAX Data mining) using SQL Server 2008/2012 Analysis Services (SSAS).
• Generated Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.
• Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
• Experienced in using Power Shell / Power BI.
• Developed data interface layer using ASP.NET and C# for data access.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012 , Oracle 8i/9i/10g/11g, MYSQL

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.

Reporting Tools: SSRS, Report Builder, Focus, Power BI.

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

OLAP: SQL Server Reporting Services (SSRS), SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI

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

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

IT Processes: Software Development Life Cycle (SDLC), Agile, Waterfall, Iterative

Methodologies: Agile, Waterfall, Scrum, SDLC

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI SSIS SSAS Developer/Power BI

Responsibilities:

• Analyze, design, Develop, implement and tune SSIS packages to perform the ETL process.
• Strong understanding of data driven business decisions using mapping document and implement in SSIS ETL process.
• Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
• Created a batch file for SSIS ETL process and scheduled to job daily basis.
• Strong understanding of data driven business decisions using mapping document and implement in SSIS ETL process.
• Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
• Data modeling and designing data warehouse principles using mapping document.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Developed data visualizations and dashboards using Power BI and Tableau
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.
• Involved in scorecard and KPI Reporting.
• Designed Tableau and Power BI dashboard which give a visual representation for the users on MTD sales growth, Visual analytics on injuries, dealer location map etc.,
• Worked on various visualization techniques in Tableau like Scatter Plots, Histogram and Heat Maps.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Installed and configured on premises gateway in Power BI services.
• Scheduled Automatic refresh and scheduling refresh in Power BI services.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Environment: MS SQL Server 2012/2014/2016 , SSIS, SSRS, SSAS, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Microsoft Office, Power BI Desktop, Tableau, Visual Studio.Net, C#.NET, Power Pivot, DAX

Confidential

Sr. SQL BI Developer /Power BI

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Designed and developed an n-tier architecture that included Presentation, Business and Data Access Layers using C#.Net, ASP.NET and SQL Server.
• Implementation Migration and Upgrade on MS SQL servers, applied service packs
• Implement Asynchronous mode for Database mirroring in Staging Environment.
• Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
• Used Online Indexing and online Restoring in SQL Server 2008
• Developed data visualizations and dashboards using Power BI and Tableau.

Environment: MS SQL Server 2012/2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential, Pleasanton, CA

Sr. SQL BI Report Developer

Responsibilities:

• SQL Server 2012 Reports Writer and performed complex SQL report writing and design.
• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Created SSRS graph report with cascading parameters from Country to interface level.
• Created and used the network performance monitor fact and dimension table which stores data of network interface traffic Detailed/Hourly/Daily and performance tuned the ad-hoc query used for the SSRS report.
• Responsible for understanding the complex SSIS packages and make understandable to the team.
• Created the SSIS ETL process which loops through all the Orion servers using connection string values stored in the table and load the data from multiple Orion servers as a source to destination table.
• Created a batch file for SSIS ETL process and scheduled to job daily basis.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Developed Physical data models and created DML scripts to create database schema and database objects.
• Performed Debugging on the Stored procedures for the requirement to handle the errors
• Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Used ETL (SSIS) to develop jobs for Extracting, Cleaning, Transforming and loading data and extracting data from multiple data sources perform multiple complex transformations and land data into SQL Server Tables.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.
• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Defined best practices for Tableau report development.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create Master Package to run different other ETL in one Master package.
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2012, SSIS (2012), SSRS (2012), SSAS (2012), Azure Cloud, Visual Studio 2013, ASP.NET Web Application/Web Forms, IIS, HTML, CSS, TFS, Tableau, Power BI.

Confidential

Sr. SQL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 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).
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Guided projects to completion on time, within scope, and on budget.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS).
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in writing T-SQL code and .Net scripts for implement Stored Procedures and Functions for different tasks.
• Implemented Agile Development Methodology for quick solutions.
• Built SSAS OLAP cubes that used the built-in SSAS features for the time dimension.
• Developed dashboard in performance point server.
• Working on web application using Asp.Net, C#.Net and ado.net for enhancements and development.
• Created a batch file for SSIS ETL process and scheduled to job daily basis.
• Performed Debugging on the Stored procedures for the requirement to handle the errors.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS.

Environment: SQL Server 2008R2/2012, SSIS (2012), SSRS (2012), SSAS (2012), Visual Studio 2013, ASP.NET Web Application/Web Forms, IIS, HTML, CSS, TFS