SUMMARY

• Around 9 years of extensive experience in SQL server, T - SQL, SSAS, SSRS having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, Oracle, TSQL, Power BIfor building, deploying, and managing applications, Power APPs expert.
• Led the development of end-to-endPower BIreporting solution for large clients including data modeling, reports, dashboards, apps and content packs, SQL queries and ETL processing, workflow, and transformations.
• Implemented Row Level Security (RLS) in Power BI both in Static and Dynamic for hundreds of users.
• Outstanding experience working with different databases such as Oracle, SQL Server, Teradata, MySQL, IBM DBA/DB2, Azure SQL Databases, websites. Hands on Experience in installing, configuring, managing, monitoring, SQL Server 2019/2017/2016/2014/2012.
• Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
• Excellent understanding of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.
• Extensive knowledge in Tuning T-SQL queries to improve the database performance.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs).
• Expert in using DAX studio and Tabular Editor 1 & 3 to create measures and model.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Excellent with DAX Functions Such as SUM, SUMX, COUNT, SUMMARIZE, SELECTCOLUMNS, CALCULATE, ALLEXCEPT, FILTER, PATH and Time Intelligence functions.
• Formed various measures and calculated columns utilizing DAX in Power BI to answer business questions. Performed time series analysis using DAX expressions in Power BI.
• Build solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Power BI Pro.
• Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of it.
• UX Design (User Experience Design) - Over 9 years of experience with creating reports and other products that provide meaningful and relevant experiences to users involving the design of the entire process of projects and product integration.

TECHNICAL SKILLS

Database: Power BI Desktop/Service, SQL Server 2019, 2017, 2016, 2014, 2012, 2008/R2, Azure Data Lake, Oracle, DB2

SDLC: Agile, Scrum, Waterfall.

Database Programming: Power BI Desktop/Services, T-SQL, Dynamic SQL/Oracle, VB .Net

Development Tools: DAX Studio, Tabular Editor 1 and Tabular Editor 3, SSMS

Analysis Services: Power BI Desktop/Service

Reporting Tools: Power BI Desktop/Service/Tableau

Cloud Technologies: Power BI Service, Azure, Azure SQL, Azure Data Warehouses

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Power BI Developer

Responsibilities:

• PerformedPower BI Desktop Data modeling, to clean, transform and mash up Data from multiple sources, SQL Server, Azure Cloud Databases, XLS, CSV.
• Merged and Appended data from different sources such as SQL server, MS Access, Excel, CSV, and Text files by using ofPowerQuery data blend.
• Created Custom Columns using M-query language, to have all the data compressed before moving to Power BI Desktop for further analysis.
• Created complex measures using DAX functions and variables, such as SUMMARIZE, SUMMARIZECOLUMNS, ADDCOLUMN, COUNT, SUM, SUMX, COUNTROWS, DISTINCTCOUNTNONBLANK, created virtual tables using DAX variables, and so on.
• Strong experience with creating dashboards with visuals such as Azure Map visual, bar charts, donut charts, stacked bar charts, line charts, table visuals, matrix visuals and so on.
• Highly experienced with Row Level Security (both static and dynamic), page level security, sharing workspaces and reports with users, and administering datasets.
• Scheduled refresh for multiple datasets, created data flows for multiple Power BI users.

Confidential, New York NY

Power BI Developer

Responsibilities:

• Power BI Desktop Data modeling, clean, transform and merge data from multiple sources.
• Joined data from different sources such as SQL server, Azure SQL, Excel, CSV, and Text files by using ofPowerQuery Editor.
• Strong experience with query editor features as merge & append query, split column, conditional column, extract, pivot & un-pivot, add column, transpose, write M FORMULA using advance query editor, delete column, remove null, errors etc.
• Selected and managed data from Azure SQL Databases using DDL and DML SQL commands, including Stored Procedures, User Defined Functions and CTE’s.
• Created Power BI interactive reports daily for the business usingPower BIDesktop.
• Highly experienced in interpreting, analyzing and querying data retrieved from different sources.
• Embedded Power BI reports.
• Created Row Level Security in order to manage the security of data & reports.
• Successfullycreated database, views and manage, and manipulate data using DDL & DML command in MicrosoftSQLserver.
• Daily usage of DAX Studio, Tabular Editor 1 and Tabular Editor 3 to create fast running measures.
• Experience in Performance Analyzing and Query Optimization.
• Built analysis reports and visualizations using DAX functions like table function, aggregation function running totals, rolling totals and iteration functions.
• Executed dashboard setups and data manipulation using DAX.
• Created reports and dashboards using Bar Chats, Line Charts, Matrix Table Visuals, Pie Chart, Donut Chart, Gauge, MAP, Waterfall Charts, Filters, and Slicers.
• UsedPower BI enterprise GATEWAY to keep the dashboards and reports up to date.
• Implemented Row Level Security for hierarchy levels in dynamic way using the PATH function and USERPRINCIPALNAME.
• Implemented Page Level Security - gave people access to particular pages of the report.
• Published reports toPower BIservices (Premium) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Scheduled refresh for reports.
• Worked on tuning up and changing some of the existing SSRS reports into Power BI reports requested by the user.
• Responsible for deploying the reports, dashboard, and content packages on all environments.
• Formed database objects like tables, users, roles, stored procedures, triggers.

Environment: Power BI Desktop, DAX Studio, Tabular Editor 1 & Tabular Editor 3, Power BI Service, Data Gateway, DAX, T-SQL, SQL Profiler, XMLA, MS Excel, Recording Macros, Access, Windows 8, MS SQL Server 2019/2017/2016/2012.

Confidential, New York NY

Power BI Developer

Responsibilities:

• Have created new data mapping document for deploy a DataMart to get into the analysis server for reporting as well as Ad-hoc reporting purposes based on Power BI.
• Have been a team member in creating data ETL and transformation in PowerBI desktop based on the personal business line wide data, collaborated with users from team and other department.
• Built KPI's, Partitions, Perspectives, and Calculated Measures by using DAX queries.
• Used One Drive for storing different versions of Power BI report, defined Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Adhered to department, organization and industry guidelines, standards, policies, and procedures.
• Conduct SQL Server to create data mart include personal information and transaction data, updated ongoing Customer Risk Analysis in the risk management system, analyzed the creditworthiness of new/existing merchants, detected illegal financial transactions to prevent potential default loss of credit card and loan.
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2012.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Environment: SQL Server 2012, SSMS, T-SQL, Power BI Desktop, Power BI Pro, MS Excel, Windows XP/7, Python (NumPy, Pandas, Seaborn etc.)

Confidential, New York, NY

SQL Developer

Responsibilities:

• Experience as SQL Developerwith extensive knowledge of analytical techniques.
• Used Data Transformation Services to import the data inSQLserver from heterogeneous data sources like Excel, Access and Oracle.
• Involved in Software Development Life Cycle (SDLC)type like Agile and waterfall methodology.
• Worked with architect to tune T-SQLquery performance to improve upon business needs.
• FormedSQLqueries and optimizing Stored Procedures and improved Query Performance.
• Implemented error handing techniques (such as try catch and error functions) to create robust T-SQL code
• Proficient in scripting T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Performed data analysis and data profiling usingSQLon various sources systems includingSQLServer.
• Extensive knowledge and experience in producing tables, reports, graphs, and listings using various procedures and handling large databases to perform data manipulations.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.

Environment: Oracle, SQL Server 2008/2012, T-SQL, SSMS, MS Excel, Windows XP/7