Home

Salman - Microsoft Certified Data Analyst/ Power BI/Azure/ Tableau Developer

[email protected]

Location: Memphis, Tennessee, USA

Relocation: open to relocate

Visa: H1B

Summary: Having around 9+ years of IT experience in the Analysis, Design, Development, implementation and Testing Client/server applications using Microsoft SQL Server and BI suite. Experience working in various industries like Banking, Finance, e-commerce, Healthcare and Telecommunications. Strong experience in designing and implementing complex reporting solutions using SSRS and Power BI. Expert in creating Power pivots, Power views, and SSRS reports using tabular model (DAX), Cubes (MDX), SQL queries, and expertise in Microsoft BI suite of products including SQL Server, SSIS, SSRS, SSAS, T-SQL, Power BI. Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau. Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models and experience in developing Tabular models in SSAS. Extensive knowledge and contribution in various phases of the Software Development Life Cycle (SDLC) in Agile, Waterfall, Scrum environments. Expertise in developing, monitoring, and implementing ETL processes in SSIS using various tasks and transformations. Developed BI reporting solutions and dashboards in Power BI and SSRS. Experience in developing complex calculations for Power BI Reporting and Tabular models using DAX. Experience in transforming data using M language in Power Query for Power BI. Experience in creating Apps and Workspaces in Power BI service. Having good experience in requirement analysis and design the requirement definition document. Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Drill down / up charts and Highlight tables. Utilized Microsoft Power BI integration with R visuals to develop regression models to assist in product pricing forecasting and experience in Power BI, and Power BI Pro. Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reports in SSRS and Power BI. Expertise in configuration of report server and report manager scheduling, subscriptions and giving permissions to different levels of users in SQL Server Reporting Services (SSRS). Expertise in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio). Extensive experience in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio). Experience in working independently and quickly adapting to the technical environment. Possesses strong troubleshooting, organizational, communication, and self-managing skills. Ability to work in groups as well as independently with minimal supervision. Technical Skills: Database Technologies: SQL Server 2019/2021, Oracle 18c/19c, DB2, Teradata, Azure DevOps, OData, Azure SQL Database, Azure SQL Datawarehouse, Snowflake Datawarehouse. Business Intelligence: Power BI Service, Power BI Desktop, Azure Data Factory (ADF), Azure Databricks, U-SQL, Azure Analysis Services(SSAS), Databricks Delta(Delta Lake),Azure Data Lake Analytics, Azure Data Lake Store (ADLS), Power Apps, SSRS, SSIS, Microsoft Flow, Azure Logic Apps, Log Analytics, Spark SQL, Python, Scala, MDX, DAX, XMLA, Power Query(M Language), Pentaho, Tableau, SAP BO, Spotfire, Azure Event Hubs, Azure Stream Analytics, SSRS, SSIS, SQL, Excel. Programming Languages: C#, MDX, DAX, Python and SQL Tools: Visual Studio 2019. Operating System & Webserver: Windows Server, Linux, IIS 7.0 Defect Tracking Tool: IBM Rational Rose Clear quest, Mercury Quality Centre Version Control: Perforce, Visual Source Safe and Team Foundation Server Work Experience: Client: Discover, Riverwoods, Illinois Data Analyst/Power BI/Tableau Developer February 2023 Present Description: Discover is an American financial services multinational industry. Discover s credit card brand is issued primarily in the United States. Discover provides banking and credit products that help people achieve their goals from establishing good credit to paying for a college education to consolidating debt. In payments, discover networks connect banks, card members and merchants around the world with innovative commerce solutions. Discover s vision is to be the leading digital bank and payments partner and its mission is to help people spend smarter, manage debt better and save more so they achieve a brighter financial future. It offers multiple services like Financial Services, Credit Cards, Deposit Products, Consumer Lending, Consumer Savings, Payments, Payment Technology, Student Loans, Personal Loans, Home Loans, Home Equity Loans, and Debit and Transaction Services. Responsibilities: Experience in collecting, analyzing, designing, developing, and interpreting complex data sets to drive business insights and decision-making. Performed data manipulation, statistical analysis, data visualization and translated complex data into actionable insights, data-driven decision-making, and optimizes business process. Interacted with business stakeholders, Clients and director level members for requirements gathering and presented various solutions using best practices. Implemented ETL processes to extract, transform, and load data from various sources into data warehouses. Collaborated with cross-functional teams to gather and analyze data to identify trends, patterns, and opportunities for process improvement. Connected to multiple data sources like Azure SQL Database, Databricks, Snowflake, Microsoft SQL server, MySQL, Oracle, and Teradata for importing and transforming data into Power BI/ Tableau as per the requirements. Developed and maintained SQL queries and scripts for data extraction, transformation, and loading (ETL) processes. Expertise in data preparation with experience in blending Multiple data connections and creating multiple joins across same and various other data sources. Conducted exploratory data analysis (EDA) to uncover insights and prepare reports for key stakeholders. Developed SQL Queries, Common Table Expressions (CTE) & Sub queries for stored procedures in SQL server and performed daily testing of data using various SQL queries to support BI reports. Created CTE, Sub queries, Joins and cumulative queries for multiple types of reports. Used power query to extract data from external sources and modify data to certain amount as required. Involved in creating relational and dimensional data modeling and develop interactive visual reports, dashboards and KPI scorecards using BI tools like Power BI and Tableau and in writing SQL Queries to extract data from data warehouses & build complex data models. Excellent in Analytical thinking and translating data into informative visuals and reports. Used DAX (Data Analysis Expressions) functions for creation of calculations and measures in the Power Bi Developed Analytical solutions by defining and translating business requirements into dashboard & reporting solutions and implementing them within confidential power Bi desktop and visualizations. Added required measures, calculated columns by performing necessary calculations by keeping unnecessary columns hidden from reporting view in the power Bi/Tableau. Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expressions (MDX) to access them. Increased query performance by performing monitoring, tuning, and optimizing Indexes tasks using SQL profiler. Expert in creating Dashboard scorecards, views, pivot tables, charts for further data analysis using Power Bi/Tableau Developed different solution driven Power Bi/Tableau dashboards with various visualizations like Scatter plot, Clustered bar Chart, Pie Chart, box plot, Sankey Chart, Donut Chart, Line & Clustered Column Chart, water fall charts, statistical models, heat maps, geo-maps etc... in Tableau/Power Bi allowing end users to utilize full functionality of the Dashboard. Created complex dashboards using parameters, sets, groups, calculations, and drill down/up in worksheets and performed customization using filters and actions. Managed Power BI Portal Data refreshes / user management and set up gateway data refresh. Scheduled Monthly, Yearly, Quarterly, and daily basis reports in Power Bi and Tableau. Used parameters and Quick filters, Dynamic X and Y axes using parameters, Table calculations. Created KPI, Gauge, Clustered column chart, Slicers for better understanding of the report. Used indexing strategies and query optimization techniques to optimize Stored procedures and long running queries. Exceptionally deliver stunning interactive reports within the Power Bi Embedded service. Assisted in designing A/B Tests and analyzing results to optimize marketing campaigns, resulting in a % increase in conversion rates. Conducted performance tuning and optimization of BI solutions for improved efficiency. Assisted in the maintenance and enhancement of existing BI solutions and created data models and schemas to support reporting and analytics needs. Conducted data validation and quality checks to ensure data accuracy. Assisted in the documentation of BI processes and procedures. Performed unit testing on all the datasets and dashboards to ensure proper implementation before elevated into the production environment. Environment: Azure SQL Database, Amazon Redshift, DB2, Microsoft SQL Server, My SQL, Oracle, Snowflake, Salesforce, Teradata, SSRS, SSIS, SSAS, Visual Studio, Power BI, Tableau, DAX, M Language, Power Query, Excel, Python, R, OLTP, OLAP, ETL, SQL Server Management Studio. Keywords: csharp business intelligence rlang information technology microsoft