SUMMARY:

• 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.

Other BI Tools & Cloud Tech: Power BI Desktop, PowerBI Services, power- BI Mobile, Azure

Version control tools: Microsoft VSS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Power BI Developer

Responsibilities:

• Interacted with the business users for understanding the business requirements and the existing system.
• Migration the reports from SAS to Power BI.
• Create the Reports /dash Boards based on client requirement.
• 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.
• Design, build and process Analysis Services Cubes with complex named and calculated measures and calculations.
• 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: Microsoft BI Stack-(Power BI, SSIS, SSAS, SQL 2016/2017). Oracle Server/Power BI Desktop/Outlook MS Office 365 /Mobile, Power BI Pro, Azure cloud and AWS cloud.

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/PowerBI Service/Power BIobile/Files/Azure/SSAS/SCRUM/SSAS Tabular model.

Confidential, Las Vegas, NA

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.