Power Bi / Data Analyst Resume
Minneapolis, MN
SUMMARY
- An overall experience of 6+ years in Developing visualization solutions using Tableau / Power BI; skilled in analysis, design, development, testing and implementation in Data Warehouse/ BI Environment.
- Strong experience in Tableau / PowerBI designed, developed, and published multiple advanced visualization reports and dashboard in on premises /Azure cloud environment.
- Strong experience in Tableau Desktop designed and developed multiple advanced visualization reports and dashboard in using multiple relation databases like Oracle, SQL server and MySQL.
- Experience in working with ETL team on Data integration using ETL tools like SSIS and DataStage.
- 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 SQL query/MS excel.
- Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
- Published Tableau Reports in the required originations and Made 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 Tableau and Power BI.
- Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Tableau and Power BI.
- Performed Unit tests, Integration tests and helped users on User Acceptance tests (UAT).
- Hands on experience on writing complex SQL queries, creating tables, joining, analytics functions etc.
- Good understanding of Data warehouse which include dimension table, fact table, star schema and snowflake schema.
- Experience in interacting with clients, understanding Business Applications, Business Data Flow and Data Relations.
TECHNICAL SKILLS
Methodologies: Agile, Waterfall
Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop, Tableau Server, SQL server reporting services, SQL Server Analysis Services (SSAS).
ETL Tools: SQL Server Integration Services and Azure Data factory
Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB
MS tools: MS Office, MS Excel, MS Visio and Power Point
Others: SQL, SQL Developer, SQL Server management studio, MS Office, FTP, Control - M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub
PROFESSIONAL EXPERIENCE
Confidential, Minneapolis, MN
Power BI / Data Analyst
Responsibilities:
- Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
- Interacted with Business Analysts, Data Modelers and team members within the organization to understand business processes, implement the logic.
- Created source to target mapping sheet for report.
- Analyzed the existing business logic to determine the reusability of the code.
- Coordinated with cross functional teams to get the required data for the reports/Dashboard.
- Implemented context filters and data source filters for handling large volume of data.
- Worked with different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the reports.
- Have refreshed/republished reports and dataset manually.
- Created KPI, calculated columns and measures for Reports.
Environment: Microsoft Power BI, SQL, Advance Excel, SAP Hana.
Confidential, Minneapolis, MN
Tableau Developer/Data Analyst
Responsibilities:
- Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
- Interacted with Business Analysts, Data Modelers 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.
- Extract data from multiple sources like Oracle, CSV for creating Dashboards/ Reports.
- Coordinated with ETL team to ingest data into data mart, prepare source to target mapping.
- Implemented context filters and data source filters for handling large volume of data.
- Worked with different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the reports.
- Have refreshed/republished reports and dataset manually.
- Created KPI, calculated columns and measures for Reports.
- 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.
- Optimized the report performance and tuned SQL queries so that report can run faster.
Environment: Tableau 2019.3, SQL Server 2017, Oracle 12c, MySQL, Advance Excel, SQL, SSIS
Confidential, Eagan, MN
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 the 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.
- Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts etc.
- Blended data from multiple sources like SQL Server 2014, PostgreSQL, Oracle 10g, and 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, and 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 10.2, MS Office Suite, Oracle 10g, Teradata 15, Unix, SQL Server 2014
Confidential, Chicago, IL
Tableau Developer
Responsibilities:
- Worked with Business users to analyze the data specifications and developed relationships between source data and worked with data modeler to build tables from different source data.
- Developed custom SQL queries to minimize the data to improve the performance in Tableau.
- Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
- Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
- Defined best practices for Tableau report development and effectively used the data blending feature in tableau.
- Worked with different types of 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 tableau reports.
- Used Power Pivot to create powerful data models and created power views for dynamic reports.
- Utilized advanced features ofTableausoftware like link data from different data sources together on one dashboard to filter data in multiple views.
- Developed storytelling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Scheduled data refresh onTableauServer for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
- Tested reports and uploadedtableaudashboards onto the server and provided production support for tableauusers.
- Done performance tuning for the developed dashboard/report.
Environment: Tableau 8.7, Tableau server, Oracle 10g, TOAD, UNIX, MS Office Suite.