Sr. Power BI Architect/Developer Resume

SUMMARY

Exceptional experience in the field of Business Intelligence
Extensive experiences with the Ralph Kimball, Bill Inmon, and Agile methodologies
Extensive experiences with the Data Warehousing, DataMart, Analytical Reporting, Dashboards
In - depth experiences with Microsoft, Oracle, and SAP Business Intelligence tools
Extensive experiences in the development of Informatica and SSIS Mappings, Workflow
Experienced in the use of JAD sessions, Storyboarding, and Wireframe methodologies

TECHNICAL SKILLS

Platforms: Windows, Azure, AWS

Languages: SQL*PLUS, PL/SQL, T-SQL, HTML, JavaScript, DAX

Database: Oracle, MS SQL Server

Data Modeling: Star Schema, Snowflake Schema

Data Analytics: MicroStrategy, Discoverer, BusinessObjects

Data Visualization: Xcelsius, Tableau, Power BI, Power APPS, Power Query, Power Pivot, M Query

Data Extraction (ETL): Informatica, SSIS

Methodologies: Agile, Bill Inmon, Ralph Kimball, WireFrame

PROFESSIONAL EXPERIENCE

Sr. Power BI Architect/Developer

Confidential

Responsibilities:

Architected and developed several solutions for fortune 100 and federal agencies on Oracle, SAP, and Microsoft Power BI platforms both on-prem and as well as Cloud to provide analytical reports and dashboards.
Developed Power BI data model based on SharePoint, Facebook, RDBMS, Flat Files, OneDrive, SAP BW, O365, ServiceNow, and other source systems
Developed live data steaming Dashboards and Reports in Power BI using Microsoft Flow, API, and SQL Server Database. Reports were deployed to Web Services and Mobile platform.
Developed Power BI reports using Bookmarks, Row Level Security, and Custom Interactions features
Defined the overall Business Intelligence data architecture, including ETL processes, ODS, and data marts
Architected, Developed, and Deployed several dimensional data models using Microsoft SQL Server, developed analytical reports (Webi and Desktop) and Dashboards using PowerBI, Tableau, and Xcelsius for over 3000 users located in 180 countries worldwide
Developed over 50 complex prototypes dashboards using Dashboard Designer, Power BI, and Tableau for enterprise users and armed forces.
Architected, developed, and maintained agency wide Enterprise Data Warehousing (EDW) environments (Development, Quality, UAT, and Production), which includes data analysis, installation, upgrades, Active Directory integration, Single Sign-On (SSO) configuration, cluster setup, auditing of the Business Intelligence suite of tools.
Served as an architect and developer on various projects, which included system integration of source systems including but not limited to Oracle, Microsoft SQL Server, Legacy Systems, and Flat Files.
Designed and deployed BusinessObjects universes; using aggregate awareness, contexts for multi subject universes, derived tables, and complex measures using functions, complex logical counts, and averages
Developed data models for the normalized Operational Data Store (ODS) and de-normalized Information Delivery Layer (IDL) for Enterprise Data Warehouse (EDW)
Performed data analysis and created Key Performance Indicators (KPIs), which increased business efficiency by 7%.
Designed, developed, and deployed Informatica mappings to load data from Enterprise Data Warehouse (EDW) to depended DataMart

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship