SUMMARY:

• About 8 years of experience with SQL Server Suite of products (SSIS, SSRS,SSAS, Power BI)
• Experience with Full life Cycle of Data Warehouse development and ongoing support.
• Experience with BI application design and development principles.
• Experience in upgrading MS SQL Server 2005 to MS SQL Server 2008/2010/2012/2014 , and MS SQL Server 2008 R2 to MS SQL server 2012/2014.
• Experience in Developing and Tuning T - SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks.
• Experience with analyzing and debugging existing Complex stored procedures, Query optimization.
• Experience in ad-hoc SQL queries Sub-queries, CTE’s (common table expressions), Table Variables and Physical Temp Tables.
• Experience in using all the Data Virtualization tools and integrating with the applications and services.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experience in Cube designing in BI Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in creating different types of Complex Reports using SSRS.
• Experience in analyzing design, development and application using SQL Server Integration Services (Control Flow, Data Flow, Error Handling, Data transformation Tools, Data Conversion).
• Experience at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Worked with Confidential Power BI, DAX expressions, Power View and Power Query integrated with share point.
• Experience in developing 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.
• Experience in a fast paced Agile Development Environment, Test - Driven Development (TDD) and Scrum.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience with SQL Server Reporting Services (SSRS) and generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012 .
• Having Knowledge on SQL Azure, Azure Data warehouse, Azure Data Lake.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2014/2012 , Access, Oracle 13g, MySQL, Tera Data 16.10

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

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

Web services: IIS 7.5/7.0/6.0

Reporting Tools: Power BI, SSRS, Tableau, SAP Crystal Reports, SSAS

Version Control Tools: Visual Source Safe (VSS), Team Foundation Server (TFS),GIT Hub, MS SharePoint, K2 Work Flow, Becqom Excentive tool

Operating Systems: Windows Server, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Power BI / MSBI Developer

Responsibilities:

• SME for Power BI and work extensively on Confidential Business Intelligence stack and Oracle SQL Developer with web-based application tools.
• Implement reports using REST APIs and Real - time streaming data set in Power BI report, which helps the business needs to see the live data.
• Develop web-based application tools which helps the business to run their operation process smoother.
• Developing PowerApps to help the business and customer to manage the organization data to run their process much smoother than ever using mobile phones or even on browsers.
• Migrating from existing Tableau, SAP Crystal reports into Power BI.
• Created Confidential Flow for Approvals, complicated processes and automated the process for the business using triggers and actions.
• Developing customized reports by using SAP Crystal reports 2013 tool and publishing to Bobj and maintaining the reports.
• Developed integration of Power BI reports into PowerApps and interacting the data by visuals through PowerApps and modifying the existing records in real time accordingly.
• Created Workspace and Apps in Power BI and giving access to end users to Apps.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Wrote complex Measures in Power BI depending on the requirement using DAX queries.
• Experience in Custom Visuals and Groups Creation in Power BI.
• Wrote complex T-SQL queries to achieve the Business requirement.
• Training the LPSD Group Business users to use Power BI tool from End to End and make them to build their own reports.
• Created a Training Documentation for the End Users.

Environment: Power BI, Tableau, PowerApps, Confidential Flow, SQL Server Management Studio 2016, Oracle 13g, Tera Data 16.10, SQL Server Data Tools 2017, SAP BO.

Confidential, Parsippany, NJ

Sr. Power BI / MSBI Developer

Responsibilities:

• Subject Matter Expert (SME) for Power BI and work extensively on Confidential Business Intelligence stack.
• Responsible for building complex reports in Power BI from the Scratch and migrating from SAP BO.
• Experience to connect different data sources like SQL DB (SQL Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Design and development of SQL Data Model to satisfy the end user reports by creating different types of Reports and Dashboards in Power BI.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users.
• Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and Scheduling.
• Experience in creating Datasets using different data sources like Confidential SQL Server, Confidential Azure, Excel and SAP BO.
• Experience in "Analyze in Excel" feature after publishing them to the Server and using the published reports as "ODC Source" from published reports to help the business for the wide reports for Excel.
• Training the Regional Business users to use Power BI tool from End to End and make them to build their own reports.
• Experience in Configuring Gateways in the Power BI service.
• Experience on Implementing Data security (row level security) on Dataset and Reports in Power BI.
• Experience in Scheduling of Power BI reports in online version and knowledge of viewing dashboards in Power BI mobile version.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.

Environment: Power BI, SQL Server Management Studio 2015, SQL Server Data Tools 2015, Azure Blob storage service, SAP BO, Team Foundation server.

Confidential, Denver, CO

Sr. MSBI / Power BI Developer

Responsibilities:

• Design the Data Model for the current solution to make it centralized for the other line of businesses.
• Responsible for building reports in Power BI from the Scratch.
• Used to connect different data sources like SQL DB (SQL Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Load the multisource data from on-prem databases to Azure Blob using Azure blob storage service in JSON format.
• Design and development of SQL Data Model to satisfy the end user reports by creating different types of Reports and Dashboards in Power BI.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users.
• Fetch the data from Azure blob data service using SSIS Azure tasks Azure feature pack for SQL server 2016 and implement the incremental load of the data into intermediate database.
• Develop Power BI Reports & effective Dashboards after gathering and translating end user requirements.
• Experience in Custom Visuals and Groups Creation in Power BI.
• Experience in Scheduling of Power BI reports in online version and knowledge of viewing dashboards in Power BI mobile version.
• Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards.
• Load the processed data into final view point centralized data ware house for further Power BI reporting.
• Understanding the existing data and create the required data models for the development.
• Experience on Implementing Data security (row level security) on Dataset and Reports in Power BI.
• Creating Linked Services, Data Sets for Azure Blob storage and maintaining them.
• Utilize Team foundation server for code maintenance and code check in’s.
• Explore Azure services for Analytics and Power BI.

Environment: Power BI, Oracle SQL Data Modeler, SQL Server Management Studio 2015, SQL Server Data Tools 2015, SQL Server 2016 on Azure, Azure Blob storage service, Team Foundation server.

Confidential, Redmond, WA

MSBI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in different stage of System Development Life Cycle from defining, designing and developing the new system to testing evaluating and maintaining the system.
• Working with different business users to adopt the data visualization - Power BI in the Organization and get insights from the data.
• Work with the technical Team to gain a good understanding of the database models used for Power BI reporting.
• Design and development of ETL packages to load the data into Marts implemented to perform cleansing, mapping, profiling and whole governance on a real time process.
• Experience in creating SQL data models/Queries for Power BI and Ad-hoc Reports.
• Develop Power BI reports & effective dashboards after gathering and translating end user requirements.
• Experience in writing stored procedures and functions on numerous SQL server.
• Extensively used different transformations i.e., looping, data formatting, check points, error handling, email notification in SSIS packages
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2014.
• Written stored procedures and used them in SSIS packages.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups and Implemented Event Handlers and Error Handling in SSIS packages.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Responsible for building reports in Power BI from the Scratch.
• Experience in Custom Visuals and Groups Creation in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Writing MDX queries to get the data from a tabular model.
• Has extensively done Data profiling and data quality analysis.
• Design and development of SSAS Tabular cubes to satisfy the end user reports by creating different types of Reports and Dashboards in Power BI.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users.
• Experience in Implementing Performance testing and Load Testing.
• Involved in Bug/Root Cause Analysis and providing the resolution.
• Worked on Identifying the slow running ad-hoc reports and came up with the performance improvements.
• Implemented the test automation suite in C# which helped the test team to enforce high quality testing and effort saving.

Environment: MS Visual Studio 2015, Power BI, SSAS (Tabular), SQL Server Management Studio 2016, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS SharePoint, GIT Hub.

Confidential, Atlanta, GA

BI Developer

Responsibilities:

• Responsible for architecture, design and implementation of a customizable Drag and Drop portal application extensively using HTML, CSS, Ajax, Oracle PL/SQL
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Created SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Monitoring and resolving Data warehouse ETL Production issues.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Developed data interface layer using ASP.NET and C# for data access.

Environment: SQL Server 2005/2008/2010 , SSIS, SSRS, Business Intelligence Development Studio 2012, Teradata, Confidential Visual Studio, ASP.NET, MS Excel.