We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • Total 7+ Years of experience in the analysis, design, development, implementation of client/server applications. 2+ years of experience on Power BI.
  • Designed and developed Power BI reports, dashboards, visuals on Power BI Desktop and published to Power BI Services
  • Used DAX functions to create measures and columns,, use of Filters, drill down and drill through reports
  • Created required Gateways to pull data directly from databases to get refreshed data regularly
  • Worked on Row level security to restrict data access at hierarchical level in Power - BI
  • Use of various visualizations and KPI scorecards to help client with informed business decisions
  • Created necessary Data Models to accomplish various report requirements for the client
  • Designed and developed reports from Data Warehouse using SSRS
  • Inspired, amiable, team player, independent, good at problem solving, multitasker, completes tasks on time, great communication and interpersonal skills

TECHNICAL SKILLS:

OLAP/Reporting tools: Power BI 2.52/2.41, MSBI - SSRSS,SSAS, Business Objects XI/R3.1/R3/R2/6.x/5.x,SAP BI 7.0 (Universe Design, Desktop Intelligence, Web Intelligence, Salesforce, Tableau, ERP

MSBI: SSIS, Data stage 9.X/8.X/8.7

RDBMS: MySQL, MS SQL Server 2016,2014,2012 Denali, Oracle 12c/11g/10g/9i,Teradata, DB2

Languages: SQL, PL/SQL, HTML, XML, Python, Java, C, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

  • Understanding the business requirements and providing solutions through appropriate Power BI Reports
  • Determining connectivity mode to get data to from the data source, SQL, DB2 to Power BI desktop
  • Developing Power BI reports, dashboards and publishing to Power BI Services
  • Created necessary Data Models to accomplish various report requirements for the client
  • Use of DAX function to create measures and columns for reports
  • Use of various visualizations and KPI scorecards, creating bookmarks and alerts for reports
  • Use of append and merge queries, parsing parameters
  • Using Filters, generating Drill through and Drill down reports with Drop down menu option in Power BI Reports
  • Created required Gateways to pull data directly from databases to get refreshed data regularly
  • Implementing hierarchical row level security as applicable to restrict data access
  • Maintaining technical standards for design development, configuration and testing of BI reports and dashboards,
  • Coordinating with onshore and offshore teams for smooth development of the project

Environment: Power BI, MSBI (SSIS,SSAS,SSRS), DB2, SQL Server, Microsoft office 365, Azure DevOps, Oracle, Windows 10 / Sever UNIX

Confidential , Ann Arbor, MI

Power BI - Developer

Responsibilities;

  • Designed and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements.
  • Creating Gateways and other related data connections
  • Used Filters to genera te Drill through and Drill down reports with drop down menu option, sorting the data, and defining calculation s for Power BI reports
  • Use of DAX function to create various measures and use of advance calculations for reports .
  • Created various visual s as per client requirements like slicer, cards, Pie and donut charts, clustered bar and column charts, ribbon chart
  • Applied Row level security to restricting data access
  • Scheduled the data refresh for dashboards and reports to show the live data.
  • Created SQL Queries, database scripts and Created and modified Stored Procedures, Functions, and Indexes.
  • Experience in transition of the new applications from development team to Support team

Environment: Power BI 2.41, SSAS,, SSRS, SQL Server, Microsoft office 365, Azure DevOps, Oracle, Oracle, Microsoft office 365, Windows 10 / Sever UNIX

Confidential, Springfield IL

MSBI Developer

Responsibilities:

  • Understand and translates business use cases and requirements into data analysis and data mapping and consequently data integration
  • Identified data sources, provides data flow diagrams and documents source to target mapping and process.
  • Designed, implemented and maintained database objects (tables, dimensions, views, cubes etc.) and database security
  • Created necessary Data Models to accomplish various report requirements for the client
  • Designed, created and tested reports using SSRS with use of required partitions, aggregations, calculations and use of KPI’s in reports for informed business decisions
  • Transform ad hoc and manual processes into sustainable, repeatable, scalable, automated solutions
  • Create and maintain visual dashboards to monitor the product
  • Design, develop, and support multi-dimensional analysis with various OLAP technologies.
  • Perform data analysis to troubleshoot data issues with the BI solutions and data integration process

Environment: SSAS, SSRS, SSIS, T SQL, MDX, SQL Server, ETL, Oracle, Microsoft office 365, Visual Studio, Windows 10 / Sever UNIX

Confidential, Indianapolis, IN

BI Analyst

Responsibilities:

  • Understand existing business processes and designed and developed reports as per requirement
  • Work with production data to design access structures, Identify the performance bottle-necks in the report and resolve the same, Performance Tuning and Optimization of reports,
  • Create data results through techniques and tools such as basic queries, data mining and multidimensional analysis
  • Understand the data structure and meaning in both the source and the target BI systems, identify and assess data sources, created source/target mappings
  • Validated hierarchies, developed security rules/standards
  • Converted existing reporting applications to the environment and developed new periodic report applications, perform query tuning and optimized existing production procedure code.
  • Working with Global team and onshore team to ensure timely progress of the project
  • Weekly & Monthly progress reports of the projects to top management
  • Involved as a liaison between technical development team and top level management

Environment: XML, Control M, IBM Data Stage, IBM WebSphere, Unix, Business Objects XI R2, Oracle 10g. Microsoft office, Windows 10 / Sever UNIX

Hire Now