We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Detroit, MI

SUMMARY:

  • Power BI Developer/ Data analyst expert with around 7+ years of total IT experience. Working as a Report Developer/ Data analyst in a wide variety of projects and skilled in analysis, design, development, testing and implementation in Data warehouses environment using Power BI, Python, ETL (SSIS) and ELT (Azure Data factory).
  • Strong experience in Tableau Desktop, designed and developed multiple advanced visualization report and dashboard in using multiple relation databases like Oracle, SQL server and MySQL.
  • Experience of at complete project life - cycles involving SQL Server Analysis Services (Development, Deployment and Maintenance) Cubes (Tabular mode)
  • Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
  • Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status
  • Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL /MS excel.
  • Hands on Experience in performance tuning and query optimization in different databases like using SQL SERVER 2014/2016, Oracle 10g/11g.
  • Proficient in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
  • Heavily used DAX table functions including filter, all, values, distinct and related table.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
  • Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau
  • Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
  • Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
  • Generated context filters and data source filters while handling large volume of data using Power BI.
  • Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
  • Experience in Exploratory Data Analysis (EDA) process in identifying continuous/categorical variables, histogram, trendlines, outliers, clustering, missing values, correlation, boxplots, quantiles and data normalization.
  • Experience with Dimensions, Measures, Calculations, Cube design.
  • Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
  • Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
  • Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
  • Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
  • Performed Unit tests, Integration tests and helped users on Customer Acceptance tests (UAT).
  • Ability to deal with people with conflicting needs, prioritize and schedule multiple tasks and work under pressure and a great problem solver and team player.

TECHNICAL SKILLS:

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.x/9.x/10.2 Tableau Server, SQL server reporting services (SSRS)

ETL Tools: Azure Data factory, SSIS

Databases: Oracle 10g/11g, MS SQL server 2014/16, MYSQL

Operating System: Windows, UNIX

Languages: Python, C, C++, SQL, PL/SQL, T-SQL

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Power BI Developer

Responsibilities:

  • Coordinated with business user at various levels and call meetings during the different phase of projects to deliver successfully. interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.
  • Created Reporting Design Document from business requirements document (BRD).
  • Created source to target mapping sheet for report.
  • Analyzed the existing business logic to determine the reusability of the code.
  • Read data from multiple sources like CSV/SQL Server 2016/AZURE SQL DB through Power BI for creating Dashboards/ Reports.
  • Worked with ETL team to build data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
  • Implemented context filters and data source filters for handling large volume of data.
  • Created multiple data model with Power BI and used as a common data source for generating multiple reports.
  • Worked with different types visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the reports.
  • Used Power Pivot to create powerful data model and created power view for dynamic reports.
  • Utilized DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
  • Have refreshed/republish reports and data set manually.
  • Created various views using Power BI (Tree maps, Scatter plot).
  • Created calculated tables, Dimensions, calculated columns and measures.
  • Developed Microsoft Analysis Services cubes (Tabular) for performance improvement.
  • Wrote SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Created report test cases using different scenarios to verify each KPI; also involved in UAT.
  • Developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
  • Optimized report performance and tuned SQL queries so that report can run faster.

Environment: Power BI Desktop 26, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, AZURE SQL DB, SSAS, Advance Excel, SQL, T-SQL, SSIS

Confidential, SFO, CA

Power BI Developer

Responsibilities:

  • Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
  • Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
  • Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Read source data from Azure SQL DB, CSV, ORACLE 11g, SQL Server 2016. through Power BI.
  • Read different formats of Source data from hive like JSON, ORC, TXT.
  • Generated context filters and data source filters while handling large volume of data.
  • Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
  • Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
  • Have used Z-order to overlap the reports on each other using Power BI.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
  • Created multiple data model and used as a common data source for the reporting purpose.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
  • Created Row level security so based on role, the end user can view the data.
  • Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
  • Created no of views, calculated tables, calculated columns and measures.
  • Hand on Experience in Unix to write basic commands

Environment: Microsoft Power BI 2.6, SSIS, SQL Server 2016, ORACLE 11g, UNIX

Confidential, Dallas, TX

Tableau developer

Responsibilities:

  • Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
  • Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
  • Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Participated in building and visualizing dashboards using Tableau Desktop
  • Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
  • Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
  • Created story using sequence of worksheets to convey information using Tableau.
  • In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
  • Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
  • Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
  • Used different functions like number, string, date, Type conversions, aggregate functions.
  • Created performance recording to improve Tableau’s performance.
  • Effectively used data blending feature in tableau desktop
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Written complex SQL queries to read data from source databases like Teradata and SQL Server
  • Modified existing Unix shell script to automate the process.

Environment: Tableau Desktop 9.0, Tableau Server, MS Office Suite, Oracle 10g, Teradata 14, Unix, SQL Server 2014

Confidential, Austin, TX

Data Analyst

Responsibilities:

  • Troubleshoot and resolve the complex issues. Translating complex business requirements into technical solutions.
  • Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers using SQL server 2014/2012.
  • Modified the Stored procedures to log errors by scripting exceptional handling in all stored procedures using SQL server 2012.
  • Working in production support to tune and optimize the process for better performance.
  • Immensely used the transactions concept to take care of all the DML queries that are executed in the stored procedures and roll backed the transactions whenever the stored procedure is errored out.
  • Successfully managed ETL process by pulling large volume of data from various data sources using BCP/DTS/Import & Export in staging database from MS Access, Excel.
  • Worked with other DBA teams in the maintaining the databases and Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome the transformation constraints and limitations.
  • Good Experience in managing MongoDB environment from availability, performance and scalability perspectives.
  • Created MDX queries to extract data from the Data Mart.
  • Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SSMS for Developers.

Environment: MS SQL server 2014/2012, ASP.NET, BIDS, BML, T-SQL, Oracle, Tableau, .NET, Visual Studio 2015, SSIS, SSAS, SSRS, TFS, VSTS, Macros, Power BI, Crystal Reports, Power shell and Power Pivot.

Confidential

BI Analyst

Responsibilities:

  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults. Modified current database by adding tables, altering referential integrity and relationships to support online system.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Created DTSX Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards.
  • Worked on building/modeling the Enterprise Data Model.
  • Migrating data from Various data sources and creating on reporting data warehouse for business users.
  • Experience in star schema over one year by building relationships between Fact Table and Dimension tables.
  • Working with Sr. SQL Developers in handling data extract from Multiple Source Systems.
  • Created Logical and Physical Data Models for ODS.
  • Optimize SSIS Packages to fine tune the data loads and reduce the data load time and come up with Best Strategies in the data load process.
  • Created Several Types of reports using SSRS like Parameterized, Drill Down and Drill Through Reports.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
  • Developed Star schema using SSAS cubes.
  • Creating Custom Based and Ad Hoc Reports using MDX as Script.
  • Fine tuning SSAS cubes for performance improvement and creating proper partitions and designing aggregations to enhance the performance of reports.

Environment: MS SQL Server 2005/2008/2008 R2/2012, T-SQL, DTS, SSIS, SQL Server Enterprise Manager, SSAS, XML, DAX, MDX, ASP .NET, SQL Profiler.

Hire Now