SUMMARY:

• Dynamic and results - driven BI Developer with Around 4+ years of experience in BI, Databases, AWS and Azure in addition to the right set of skills and attitude to get the job done. Looking forward to associate with a vibrant organization, to fully utilize my knowledge and skills which conduce to the overall growth of the organization.
• Proficient Power BI Developer with an experience of 4 years in design and development of Business Intelligence applications across various domains.
• Performed Data visualization, Dashboard design/implementation, Reporting, Self-service BI, extraction, transformation, migration, and integration and other analytics.
• Experience in Power BI, Power BI Pro, Power BI Mobile.
• Working Knowledge in Cloud Azure Portal, Azure Data Lake store, Azure Data factories and Azure SQL databases.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Having good experience in requirement analysis and design the requirement definition document.
• Strong knowledge OLAP and OLTP systems.
• Created dashboards in line with the analytical uniformity using the advanced analysis features of Power BI Desktop.
• Experience in Data analysis, with good data modeling exposure.
• Expert in creating Power pivots, Power views reports using tabular model (DAX), Cubes (MDX) and SQL queries
• Good experience on creating Power BI dashboard from scratch and handling Workspaces, Apps and User Security in Power BI Service
• Developed reports using Tableau and Qlik view
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Educated the business users on how to use the reports and dashboard
• Worked on all types of transformations that are available in Power BI query editor.
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication.

PROFESSIONAL EXPERIENCE:

Power BI Developer

Confidential, Dallas TX

• Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reports in SSRS and Power BI
• Data modeling inside of Power BI with mashup code and query editor
• Gathered user requirements and analyzed and designed the dashboard layout.
• Designed and documented the entire Architecture of Power BI for Poc
• Created Azure Data Factory for Data movement from various sources to Azure SQL Data Warehouse
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using Dimension modelling with Teradata.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps
• Executed SQL queries using TOAD for Oracle dB and AQT for DB2, for data extraction and validation
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Worked on Custom Visualizations like Chicklet Slicer, Synoptic Panel, Play Axis and Word Cloud.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Power BI Developer

Confidential, Plano TX.

• Working directly with stakeholders for requirements gathering and developing various decision making Dashboards.
• Created hierarchies and attributes as part of dimensional modeling.
• Generated computed tables in Power BI by using Dax.
• Provided guidance and insight on data visualization and dashboard design best practices in Tableau.
• Worked on Azure Data Factory to move data from SQL Server DB to Azure SQL DB.
• Utilized T-SQL constructs such as joins, subqueries, derived tables and views for querying data
• Participated in the Agile methodology daily scrum and other sprint meetings.
• Developed and prioritized product backlogs and the sprint burn down charts etc. to meet the daily deliverables and timelines.
• Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View, Power Map to visualize reports.
• Involved in validating data between Qlik Sense and Cognos reports
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Star Schema, Snow Flak Schema. Working knowledge of Functions, Packages, Triggers, and scripting languages.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Published reports and dashboards using Power BI.

Power BI Analyst

Confidential, Addison TX

• Created Dax Queries to generated computed columns in Power BI
• Created power BI dashboards and reports for sales group by connecting Oracle database.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Creating Database objects - tables, views and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Responsible for creating datasets using T-SQL Stored Procedures and involved in Data visualization.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Scheduled jobs and alerts using ADF Triggers.
• Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements..
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created and schedules tasks for reloading and distribution of Data in Tableau
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Followed the AGILE methodology for the entire “SDLC”.
• Worked with DBA, data modeling team, Application management team to understand the database structure, tables and their relations and to apply security
• Validated data against database by creating and running SQL queries.