Power Bi Developer Resume
Atlanta, GA
SUMMARY
- Having 9+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
- Around 4+ years of 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) and SQL queries
- Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
- 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.
- Experience in Power BI, Power BI Pro.
- Experience on SQL Server Reporting Services (SSRS).
- 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 give permissions to different level 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.
- Possess strong troubleshooting, organizational, communicational, and self - managing skills.
- Ability to work in groups as well as independently with minimal supervision.
TECHNICAL SKILLS
Databases: Oracle, SQL server, DB2, Teradata, Azure DevOps, OData
Reporting Tools: Power BI Service, Power BI Desktop, SSRS, SSIS, SQL, Excel
Software: Microsoft XP/Vista, MS Windows 8/10
Programming Languages: MDX, DAX, SQL
PROFESSIONAL EXPERIENCE
Confidential, Atlanta GA
Power BI Developer
Responsibilities:
- As a POWER BI Developer, created Power BI dashboard and generated reports using the Snowflake server tables as Data source using SQL & M Query Language.
- Responsible for design and development Power BI data visualization using cards, cross tabs, gauges, scatter plots, bar and Table with Row level security (RLS) and integrating custom visuals based on business requirement using Power BI desktop.
- Developing Power BI dashboards and reports from multiple data sources by using data blending technique and deploying it in SQL Power BI Report Server.
- Creating many calculated columns and measures using DAX in Power BI based on report requirements and published Power BI reports to end user via mobile.
- Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column
- Integrating custom visuals based on business requirement using Power BI desktop.
- Transforming and combining the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.
- Managing all generated reports using and committing the developed report in BITBUCKET (GITHUB).
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
- After Publishing Front end team integrates the same report to Production where end user can access the created report.
- Developing Custom Reports and different types of Power BI Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using Old SQL Server Reporting Services (SSRS)
- Identify bottlenecks and defects, and devise solutions to mitigate and address these data discrepancies issues between different systems and fix them or suggest solutions to fix them.
- Experienced in different phases of SDLC with expertise in client interactions, documenting functional and technical specifications, user stories.
- Having exposure working on agile projects and scrum team and handled sprints and status tracking and delivered the projects in Agile Methodology.
- Involved in preparing deliverables i.e., status reports, test summary reports and validation documents and walkthrough with the business team for a decision making as part of UAT support.
Environment: Power BI, M Query, TSQL, SQL, DAX, SSMS, Snowflake, SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS), SQL Server Analytical Services, GITHUB, MS Excel, MS Visual Studio, MS Office.
Confidential, Dallas TX
Power BI Developer
Responsibilities:
- Imported data from various data sources such as SQL Server DB, Azure SQL DB to Power BI to generate reports.
- Created DAX Queries to generated calculated columns in Power BI.
- Worked as a part of core team to develop the reports and data models using agile methodology.
- 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.
- Imported and selected data from various categories of Jira fields including Agile, Service Desk, Custom, Time Reporting and History fields
- Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
- Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
- Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.
- Modelled data in a variety of ways and across multiple visualizations using Power BI.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
- Published reports and dashboards using Power BI.
- Experience in using Microsoft Azure REST Services for storing and accessing data on the cloud.
- Experience in using Power BI Embed to deploy reports in SharePoint Site using Microsoft Azure.
- Knowledge on implementing SharePoint, Project Online systems.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Knowledge on implementing SharePoint, Project Online systems.
- Upgrade/migration expertise on on-premises environment to on-premises environment & Online.
Environment: Azure, SharePoint, Project online, MS SQL Server 2012/2008/R2, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, Jira.
Confidential, Plano TX
Power BI Developer
Responsibilities:
- Communicate with clients and capturing site scheduled dates and production Lines and manufacturing equipment's information.
- Attending project discussions & meetings with SME and business users.
- Developed Power BI reporting modules for shipments and analytics portals.
- Writing complex queries using DAX functions in Power BI and Power Pivot.
- Used various sources to pull data into Power BI such as SQL Server, Oracle and SAP.
- Created refresh-based reports and automatic refresh in Power BI service.
- Created stored procedures and queries to pull data into Power Pivot model.
- Used joins and sub queries to simplify complex queries involving multiple tables.
- Developed reports for different teams include Quality, Production and Warehouse based on the client requirements.
- Utilized Power BI view to create various analytical dashboards that depicts critical KPIs such as efficiency, quality and availability of the equipment.
- Providing hyper care support after the implementation and clarifying business/site user queries.
- Share the validation results and confirmation to client project team for sign off.
- Documenting the issues faced during the project implementation.
- Working on bug fixing and enhancement on reports.
- Perform Quality Assurance activities as per Flex policies.
Environment: Oracle, SAP, MS SQL Server 2008R2/2012, SQL server Reporting Services 2008R2, SSIS, SSAS, PL/SQL, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, TFS, CRM Saratoga and Pivotal.
Confidential, IL
SQL BI Developer
Responsibilities:
- Analyzed the requirements and selected the appropriate fact tables/created fact tables
- Created the storage type (ROLAP), Created cubes for Business Intelligence.
- Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
- Creating Static Reports using MDX queries and creating MDX Base Report Definition.
- Experience in building and maintaining Data marts. Created roles for using the cubes
- Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
- Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
- Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
- Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
- Created SQL Server Reports based on the requirements using SSRS 2012,2014
- Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
- Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
- Experience in creating XML files by designing the SSIS packages and SQL server.
- Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
- Troubleshooting performance issues and fine-tuning queries and stored procedures
- Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
- Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
Environment: SQL Server 2008/2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, XML, C#.NET, MS PowerPoint, MS Project, Windows Server 2008, Oracle.