SUMMARY

• Over 8 years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 in various domains like Financial, HealthCare, Telecommunications sector.
• Experience in Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Excellent SQL, T-SQL Development Skills to write Complex Queries involving Multiple Tables & to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views.
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables, and Derived Columns.
• Proven ability in Performance Tuning (SQL Query/Stored Procedure Tuning), Query Optimization, troubleshooting.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents (BRD) and plans for creating interactive dashboards.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Utilized Power BI (Power View) to create various analytical/interactive dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Handled more than 1000 VM's in Public Cloud Azure Infrastructure in Deployments and Configuration Upgrades across Azure platforms and sub components with new builds and releases.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Implemented several DAX functions, MDX queries for various fact calculations for efficient data visualization in Power BI.
• Created Azure Data Factory to move data from once source to other source.
• Utilized Power BI (Power Pivot/View) and DAX functions to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Configured Azure Traffic Manager to build routing for user traffic.
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing.
• Extensive experience in creating Drill-down and Drill-through Reports (SSIS/SSRS), writing Expressions in SSRS and Fine-tuning Reports.
• Adept at creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools.
• Configured Azure Active Directory and managed users and groups. Implemented operational efficiencies using scripting tools such as Python and PowerShell.
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS.
• Migrating datacenters to workloads towards Azure and understanding & troubleshooting issue Azure laaS and PaaS .
• Deployed the packages on staging and production. Monitored jobs and supported Azure Data Lake production environment.
• Experience in Dimensional Data Modeling and Cube Development, designing of STAR, SNOW FLAKE Schemas, Partition, Aggregation and Optimization using SSAS
• Adept in designing Crystal reports, Enterprise reports using SSRS ( 2005/2008/2012/2014 ) and Excel Pivot.
• Extensive experience in SSASOLAP Cubes, and Data Mining.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SSAS using multi-dimensional expression(MDX), mathematical formulae, and user-defined functions.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2016/2014/2008 R2/2005, T-SQL, SQL Loader

ETL: SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL using Stored Procedures

Tools: Visual Studio 2008/2005/2003 , Toad Reporting Services, Crystal Reports, Tableau, Power Pivot

BI Tools: SSRS / SSIS / SSAS

Version Control Tools: TFS, VSS, SVN

Languages: C, C++, PL/SQL

Web Knowledge: XHTML, XML, JavaScript

Operating System: Windows 7, XP, Vista, UNIX, Windows 2000, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA, GA

SQL/Power BI Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering phase to technical design, development and testing phase.
• Extensively involved in building the Data Warehouse environment with Azure cloud implementation of the ODS having multiple layers of data.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions.
• Designed the Data warehouse, performed mappings from Source to the Target tables.
• Extensively used the DAX queries to build the Data Model in the backend.
• Worked extensively on SSIS packages to implement the data load strategy.
• Involved in designing, developing and testing ETL strategy to populate the data from various source systems feeds using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Proven Power BI development experience with desktop and pro versions, familiarity with Direct Query functionality within Power BI.
• Development of Microsoft Power BI dashboards and dashboard templates also used DAX functions and MDX queries.
• Worked on Azure Active Directory . Microsoft Azure date storage and Azure Data Factory , Data Lake , Big Data on Azure.
• Migrated SQL server to MS Azure cloud. And extending domain services to Azure.
• Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot, Power BI, Power View, and SSRS)& implementing enterprise software solutions.
• Provide analytical, complex and specialized client service analysis using Power BI dashboards.
• Developed custom Azure Runbooks and connections to the REST API which will send email/text messages whenever there is a failure in scheduled pipelines at every stage.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Used DAX studio to extract data form different Azure analysis services cubes.
• Calculated Tables, Custom transformations (M-language) and Dynamic KPI ( DAX ) are used.
• Used basic statistics functions that are available in DAX to provide insights on descriptive analytics.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, DAX, Partitions, KPI’s & MDX Queries and DAX using SSAS 2012.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Experience in Provisioning, Configuring and Publishing Web and Worker Roles in Azure PAAS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.
• Used various functions in DAX to build running totals, YTD and MTD Values
• Created and maintained various databases in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS (move two points up).
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
• Provided daily support to the client/technical teams for system wide tasks such as monitoring, alerting, testing, bug fixing/problem resolution & documentation

Environment: MS SQL Server 2012/2008/R2, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Plano, TX

SQL/Power BI Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• 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
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Proven Power BI development experience with desktop and Pro versions. Familiarity with DirectQuery functionality within Power BI
• Development of Microsoft Power BI dashboards and dashboard templates
• Provide analytical, complex and specialized client service analysis using PowerBI dashboards
• Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, PowerView, SQL Server Reporting Services) Experience implementing enterprise software solutions
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
• Identified the dimension, fact tables and designed the Data-Mart using Star schema
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s &MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access
• Worked with SQL queries using MS Access for data manipulations
• Wrote T-SQL queries,Stored Procedures and used them to build packages
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Created and Maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.