SUMMARY

• Over 7 years of experience in IT Sector wif strong analytical skills in Development wif BI Tools Power BI, and technical implementation wif MS SQL server database
• Project Lead cross - functional teams wif business, technological, and financial components.
• Extensive in a Retail, Manufacture wif a strong understanding of data & analytics.
• Expertise in performance improvement and data modeling on Power BI and SQL Server SQL Quires
• Expert in developing, maintaining, and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, SQL, Excel pivot tables, Power Pivots, Power BI, DAX).
• Working extensively on Data Model, Architecture design and SQL server.
• Strong skills in Data Modelling, Report Design and Visualizations and Power BI Visuals including Tree Map, Funnel, Line Chart wif Map Reports and Stacked Reports in Power BI Desktop.
• Developed various kinds of reports using line chart, Bar chart, Bullet Charts, KPI's, Multi row cards, Stacked column Charts in the Power BI Desktop.
• Extensive knowledge in reporting objects like Hierarchies, filters, DAX fields, Groups, Parameters etc., inPower BI Desktop.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS).
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI andSSRS reports.
• Used incremental approach in the Workflows and Data Flows to integrate source data into warehouse tables using required transformations.
• Conversant wif all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages

TECHNICAL SKILLS

OLAP/Reporting Tools: (SSRS), MDX, Power BI

Relational Databases: SQL Server 2016/2014/2012/2008 R2, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Other Tools: Microsoft Office 2003/2007/2010 and 2013, Power pivot.

SQL Server Tools: SQL server Management Studio, Microsoft Visual Studio 2010/2013/2015

Programming languages: SQL, PL/SQL, T-SQL

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Power BI Developer

Responsibilities:

• Created different visualizations using slicers, lines, pies, histograms, maps, scatters, bullets, heats maps, tree maps, etc.
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Developed complex calculated measures using Data analysis Expression language (DAX).
• Creating different types of user-defined functions using T-SQL.
• Developed parameterized reports, drill down, Drill through reports, sub reports as per report specifications and functionality.
• Development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s using Power BI
• Worked wif Metadata-Driven Packages to pull the data from different sources and loaded them to the Data Mart.
• Developing Power BI Reports, ad-hoc reports usingReport Designer.
• Generating several types of drill down and drill through reports using Power BI Desktop.
• Developing complexreports using multiple data providers, global variables, expressions, user-defined objects, aggregate-aware objects, charts, and synchronized queries.
• Designing and implementing parameterized and cascading-parameterized reports using Power BI.
• Developing, publishing customized interactive reports and dashboards, report scheduling usingPower BI
• Generated interactive web sharing dashboards wif simple drag and drop options.
• Worked extensively on trend lines, statistics, dual axis, groups and sets to develop detailed level of summary reports.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Excel, Windows XP, SQL Server Reporting Services(SSRS).

Confidential, Bentonville AR

Power BI Developer

Responsibilities:

• Analyzing and understanding the business requirements.
• Development of SSIS packages that loads data from a different source system into a staging environment and then performed transformations on data for cleansing and modification.
• Extracted data from sources and transformed the data using different transformations like Data Conversion, Derived Columns, Lookup, Conditional Split, Aggregate, Union all, Merge Join and Multi Cast Transformations.
• Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.
• Created Cubes using SSAS and process cubes to store data in OLAP databases.
• Design and developed Tabular cube model for Power BI dashboards.
• Created DAX calculations in SSAS Tabular cube.
• Implemented Row level security in Tabular model.
• Created Time series calculation using Calculation groups in Tabular model.
• Deployed Tabular model to Azure Analysis services and created Jobs to automate SSAS Tabular models.
• Developed the SSRS reports in the form of Table, Matrix and Chart using SQL Server 2012 Reporting Services.
• Implementing Power BI dashboards using DAX queries.
• Designed Different Types of reports like Drill Down, Sub Reports and Parameterized Reports.
• Develop stored procedures, tables, indexes, views and any other needed database objects to support ETL.
• Worked on SQL Server performance tuning.
• Developing automated and near real-time Power BI dashboards and reports.
• Developing Data Models wifin Power BI and developing variety of visualizations based on use case.
• Developing enterprise level KPIs and trends for executives which included a paginated report sourcing KPIs from multiple Power BI Datasets which worked as a Daily Report.
• Developing Power BI data flows and datasets by applying transformations in Power Query to implement the ETL steps wifin Power BI Stack were ETL resources are unavailable.
• Developing several datasets wif incremental load in Power BI and used XMLA end points to refresh the partitions for heavy data loads exceeding 10 GB in size.

Environment: SSIS, SSRS, SSAS, Mobile Dashboards, SQL Server and Power BI Dashboard

Confidential, Charlotte NC

Power BI Developer

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio,Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2,Power BI Desktop, Power BI Service.

Confidential, Atlanta GA

SQL Developer

Responsibilities:

• Requirements gathering from Business users to perform technical design, development andtesting.
• Worked extensively in writing and debugging complex stored procedures, views, triggers anduser-defined functions
• Worked on designing databases according to industry standards and make tuningrecommendations.
• Designed the Data warehouse and done the mappings from Source to the Targettables.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based ontheirquirements usingSSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports usingSSRS.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profilerand Index Tuning Wizard inSSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split,Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Tasketc.
• Created SQL Server jobs and scheduled them to load data periodically using SQL serverAgent.
• 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 2008R2 AnalysisServices.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV filesintoSQL Server2008R2.
• Generated multi parameterized reports in MS SSRS 2008R2 allowingusers the ability to make selections beforeexecuting reports; thus, making them userfriendly.
• Report Design and Coding for Standard Tabular type reports, including Drill down and Drill throughfunctionalityand Graphical presentations such as Charts and Dashboard type metrics usingSSRS
• Created Ad Hoc and parameterized various Reports using SSAS andSSRS.
• Assisted in handling escalating billing issues and propagating bug fixes in productionenvironment.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst andcustomerrepresentatives for various categories based on businessneeds.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer.