We provide IT Staff Augmentation Services!

Sr. Power Bi Developer Resume

San Jose, CA

SUMMARY:

  • A dynamic professional with 12 years of experience in Cognos and Power BI Technology in Data Warehousing Environment in debugging, testing, maintenance, design, development and customer support. Experience in different versions in Cognos 8/10, Power BI Desktop and Services.
  • Power BI experience in Business Intelligence, Data warehousing, Data Modeling Experience including analysis, modeling, design, and development of Power BI reports and dashboards for analytics.
  • Good understanding of Power BI architecture, design, development and end user experience.
  • Have handled various filter types including Data source filter, extract filter, Context filter, Global filter, Dimension and Measure filter.
  • Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
  • Developed professional reports as per the business requirements using Power BI.
  • Expert in designing and creation of Power BI storyboards which can give a summarized story of the data about the business.
  • Published dashboard, reports to online Power BI could service for the use of report consumers
  • Worked on complete lifecycle development process which includes analyzing business needs, documenting business information requirements, technical designs, developing, integrating, Implementation and production support using Cognos as a BI tool.
  • Strong understanding of dimensional modeling of Star Schemas, Snow - Flake Schemas methodologies.
  • Experience in installing, configuring, maintenance and administration of Cognos BI suite in different environments.
  • Implemented enterprise level Cognos security and server administration using Cognos 10.x/8.x/7.x and administration of security access using Access Manager, LDAP and custom authentication provider.
  • Extensive knowledge in creating models in Framework Manager (Physical layer, Business layer and presentation layer) and exporting packages to use it for report building.
  • Expertise in creating complex reports using lists, charts, crosstabs, drill-through, Master-detail reports, dashboards and cascading the reports using Report studio.
  • Good analytical, problem solving and interpersonal skills. Ability to work on a team environment or independently and handle multiple tasks concurrently.
  • Team Player with the ability to communicate effectively at all levels of the development process.
  • Implemented and designed Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements (SSAS)
  • Built a Tabular model cube from scratch data and by multi-dimensional expression (MDX) queries fetched data to SSRS and Power BI reports.
  • Designed a Data model with multiple Fact Tables and Dimensions depending on the business requirements.

TECHNICAL SKILLS:

Databases: Oracle 9i\10g\SQL Server2000, 2005, 2008,2012

Programming: VB, C, C++ & SQL

Operating System: Windows 2000/2003/XP/Vista

BI Tools: Cognos Report Studio, Cognos Framework manager, Cognos Power play transformer, Power BI Desktop, Power BI Services, power- BI Mobile, Azure, SSAS Tabular model

Version control tools: Microsoft VSS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Power BI Developer

Responsibilities:

  • Interacted with the business users for understanding the business requirements and the existing system.
  • Developed Reports to visually explore data and create an interactive report Excel and power bi.
  • Using a Query Editor in power bi performed certain operations like Fetching data from different file.
  • Working with import and direct query, creating custom table in the power bi.
  • Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
  • Working with different transformations, Applied steps in query editor.
  • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
  • Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
  • Used Jira for task assignments for new development, enhancements and bug fixing
  • Used Git repository for project related documents and code.
  • Created Tabular Models using DAX queries in analysis services and deployed it.
  • Developed and maintained multiple power bi dashboards/reports and content packs.
  • Design and model data sets with power bi desktop based on measure and dimension requested by customer and dashboard needs.
  • Created power bi Visualizations and Dashboards as per the requirements.
  • Created the LDAP Group and shared the reports/dashboard to the users.
  • Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS.
  • Created Tabular Models using DAX queries in analysis services and deployed in to the SQL Server.
  • Developed and maintained multiple power bi dashboards/reports and content packs.
  • 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.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Used various sources to pull data into power bi such as Excel, SharePoint and salesforce.
  • Created different visualization in the reports using Bar Charts, Pie Charts, Line Charts, Cards, Slicers, tree maps, map, etc.
  • Hands on experience with Security implementation.

Environment: M icrosoft BI Stack-(Power BI, SSIS, SSAS, SQL 2016/2017). /Power BI Desktop/Outlook MS Office 365 /Mobile, Power BI Pro, SharePoint, SAS Reports Migration, Visual Studio2017.

Confidential, Houston TX

Sr. Power BI Developer

Responsibilities:

  • Interacted with the business users for understanding the business requirements and the existing system.
  • Developed Reports to visually explore data and create an interactive report Excel and power bi.
  • Using a Query Editor in power bi performed certain operations like Fetching data from different file.
  • Working with import and direct query, creating custom table in the power bi.
  • Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
  • Working with different transformations, Applied steps in query editor.
  • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
  • Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
  • Used visual studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.
  • Created Tabular Models using DAX queries in analysis services and deployed it.
  • Developed and maintained multiple power bi dashboards/reports and content packs.
  • Design and model data sets with power bi desktop based on measure and dimension requested by customer and dashboard needs.
  • Created power bi Visualizations and Dashboards as per the requirements.
  • Created the LDAP Group and shared the reports/dashboard to the users.
  • Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS.
  • Created Tabular Models using DAX queries in analysis services and deployed in to the SQL Server.
  • Developed and maintained multiple power bi dashboards/reports and content packs.
  • 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.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Used various sources to pull data into power bi such as My Sql, HIVE, Excel, SharePoint.
  • Created different visualization in the reports using Bar Charts, Pie Charts, Line Charts, Cards, Slicers, tree maps, map, etc.
  • Hands on experience with Security implementation.

Environment: M icrosoft BI Stack-(Power BI, SSIS, SSAS, SQL 2016/2017). /Power BI Desktop/Outlook MS Office 365 /Mobile, Power BI Pro, SharePoint, SAS Reports Migration, Visual Studio2017.

Confidential, Pittsburgh, PA

Sr. Power BI Developer

Responsibilities:

  • Interacted with the business users for understanding the business requirements and the existing system.
  • Analyzed the functionality and formulas of the data and created metric (KPI's) dashboard reports using the visualization tool.
  • Implemented Role based access security using Microsoft Power BI.
  • Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
  • Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
  • Lead the team and Lead the team and mentored them in prioritizing and distribution other tasks.
  • Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Microsoft Power BI data visualization tools.
  • Published reports and dashboards to the Power BI service through the Office 365 integration. Shared the dashboards among multiple users in the group.
  • Good Knowledge and experience on Power BI Gateways (Personal and On-Prem gateways).
  • Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
  • Expert in implementing business related custom visuals in addition to the visualization tool to showcase the data in a easy and efficient manner.
  • Developed professional reports as per the business requirements using Power BI.
  • Expert in designing and creation of Power BI storyboards which can give a summarized story of the data about the business.
  • Published dashboard, reports to online Power BI could service for the use of report consumers.

Environment: Oracle Server/Power BI Desktop/Outlook MS Office 365 /Mobile, Power BI Pro, Azure cloud and AWS cloud.

Confidential, Reston, VA

Sr. Power BI Developer

Responsibilities:

  • Having Experience on Microsoft Power BI (Desktop, Service, Mobile), Database performance tuning.
  • Built and published customized interactive dashboards utilizing Power BI. Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
  • Experienced in developing power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
  • Created new measures and new calculated columns for reports and dashboard analysis.
  • Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
  • Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
  • Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
  • Designed, built and processed Analysis Services Cubes with complex named and calculated measures and calculations.
  • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
  • Design, build and process Analysis Services Cubes with complex named and calculated measures and calculations.

Environment: SQLServer2014/Power BI Desktop/ Power BI Service/Power BI Mobile/Files/Azure/SSAS/SCRUM/ SSAS Tabular model.

Confidential, Las Vegas, NV

BI Developer

Responsibilities:

  • Proficient in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snow flake Schema, Fact and Dimension tables.
  • Proficient in creating joins for queries involving multiple tables.
  • Proficient with T-SQL to create Tables, Views and Stored Procedures.
  • Proficient in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
  • Designed, built and processed Analysis Services Cubes with complex named and calculated measures and calculations (SSAS).
  • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements (SSAS).
  • Design, build and process Analysis Services Cubes with complex named and calculated measures and calculations (SSAS).
  • Designed developed and deployed reports, sub-reports, drill down reports, and drill through reports and parameterized reports and adding new features to the reports in MS SQL Server environment using SSRS.
  • Possess technical skills in defining Source and target metadata definitions for Source to Target mapping specification.
  • Designed and developed SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
  • Worked with subject matter experts (SME's) and project team to identify, define, collate, document and communicate the data migration requirements.

Environment: SQL Server 2014, Microsoft Visual Studio 2012, Windows 7, MS Office 365, Dax, SSIS, SSAS, SSRS, Power pivot, Power view, Power BI.

Confidential

Sr. Cognos Developer

Responsibilities:

  • Develop, organize, manage/maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
  • Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.
  • Performed Unit testing on Dev and supported the users on UAT and Production.
  • Extensively worked on performance tuning both at Cognos and database level.
  • Developed and Maintained technical documentation of the implementation.
  • Supported existing reports in production environment.
  • Design and review Technical Design Documents and queries through onsite/offshore mail coordination

Environment: Win 2010/Cognos10.1.1/Sql Server2012.

Confidential

Sr. Cognos Developer

Responsibilities:

  • Develop, organize, manage/maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
  • Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.
  • Performed Unit testing on Dev and supported the users on UAT and Production.
  • Extensively worked on performance tuning both at Cognos and database level.
  • Developed and Maintained technical documentation of the implementation
  • Supported existing reports in production environment.
  • Design and review Technical Design Documents and queries through onsite/offshore mail coordination.

Technologies: Win10/Cognos10.1.1/Cognos Framework Manager/Sql Server2005.

Confidential

Sr. Cognos Developer

Responsibilities:

  • Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
  • Collaborated with business to develop high-level designs including logical models and functional specification documents.
  • Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
  • Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
  • Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
  • Recommended and designed summary tables to be used in reports to optimize performance.
  • Managed Package Migrations and Deployments from one Environment to another.
  • Developed a metadata model in Framework Manager by following best practices.
  • Supported existing reports in production environment.
  • Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.

Environment: Windows 10/ SQL Server2005/Cognos 10.1, Power play Transformer7.4, Framework Manager

Confidential

Sr. Cognos Developer

Responsibilities:

  • Interaction with the client for requirements gathering and analysis.
  • Developed List Reports which includes Complex formatting in report studio.
  • Creation of Calculations, Filters at reports designing.
  • Developed reports which include Grouping, and sorting.
  • Developed reports which include Page breaks and Sectioning.
  • Created text based prompts, date prompts and value prompts.
  • Worked with reports, which include joins and unions in report studio.
  • Involved in creating, re-ordering, modifying and deleting prompts in a report.
  • Developed reports which includes Page rendering and List rendering and Field rendering.
  • Developed reports which include Conditional formatting.
  • Developed complex reports which includes charts, crosstab and drill through.
  • Testing the reports for data accuracy and consistency.

Environment: Windows Server 2003/ DB2/ Cognos 8.4.

Confidential

Cognos Developer

Responsibilities:

  • Gathered requirements from financial analysts, field managers and translated them into business requirements.
  • Developed the model using Framework Manager, created dashboards and reports using Report studio.
  • Implemented Framework Manager Security for Data access, Object level access and Package.
  • Developed Cube based solutions for multi-dimensional analysis
  • Used Service Now (Ticket Management Tool) for Request tickets, incident tickets, Change management.
  • Plan and scheduled the report to run at desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using Autosys tool.
  • Provided user training to basic and advanced users and supported any adhoc requests.

Environment: Windows 7/ Oracle8i/Toad/Cognos8, Cognos Transformer7.4.

Confidential

Cognos Developer

Responsibilities:

  • Creating\Modifying the catalogs and impromptu reports as per the client specifications.
  • Creating user classes & users and setting up necessary access using Access manager.
  • Publishing the cubes to the upfront and maintaining the existing cubes, models & IQDS.
  • Developed chart, list, cross tab, drill through, master detail and multiple reports leveraging prompts, calculations, conditions & filters, conditional formatting and aggregations.

Environment: Windows Server 2000/ SQL Server2000/Cognos7/Cognos8 migration, MS Project.

Hire Now