Power Bi Software Development
Resume:
Name: Taruni Bojanna
******.*******@*****.***
PROFESSIONAL SUMMARY:
Over 11 years of extensive experience in the full life cycle of software development process including.
Database Design, Data Modeling, Implementation and Support of Microsoft SQL Server
2012/2016/2017/2019 Development, Testing and Production Environments, Data
Warehousing and applications for different domains.
Extensive experience in Microsoft BI tools (SSIS, SSRS, SSAS, Azure Data Factory, Power BI) - using.
integration services (SSIS)and Data Factory for ETL (Extraction, Transformation and Loading),
reporting services (SSRS)and Power BI for creating different types of reports and analysis services
(SSAS) for designing and developing complex cubes.
Extensive experience on using DAX Functions in Power BI Measures.
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.
Best coding programmer in writing complex T-SQL queries for Joins, views, Stored Procedures &
parameters, Triggers, User functions, Tables.
Expertise in Analysis Using Excel, Power Pivot Reports and Drill-Through Reports Dashboards Using
Warehouse and OLTP Connections.
Best coding programmer in writing complex T-SQL queries for Joins, views, Stored Procedures &
parameters, Triggers, User functions, Tables.
Expert in creating SSIS packages and Data Factory Pipelines for extracting data from various sources
like DB2, Oracle, Excel, Flat File, CSV, MS Access, and other OLE DB data sources.
Experience in Migration project from on-premises Data warehouse to Azure Cloud.
Expertise in creating linked services and merging data from various heterogeneous data sources,
populating Dimension and Fact tables in data warehouses and data marts, Cleaning and
Standardizing data loaded into OLTP and OLAP databases using SSIS and Azure Data Factory.
Solid understanding of Relational Database Systems (RDBMS), Normalization, Multi-Dimensional
(Star) and Snowflake schemas.
Highly motivated and process ability to think, to analyze and to communicate with users and discuss
their data, application and project requirements in a team environment.
Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with
MDX, Data Mining Models, developing reports using MDX and SQL.
Hands on experience on SQL Server Analysis (SSAS) and Azure Analysis Service (AAS) to create
reports based on Live connection in Power BI.
Solid understanding in Microsoft Azure cloud services, Azure Data Factory (ADF), Infrastructure as a
service (IaaS), Platform as a service (PaaS), Software as a service (SaaS), Azure Data warehouse.
Experience working with onsite and offshore models. Good communication skills, interpersonal skills, team coordination and versed with Software Development processes.
Experience in building Tableau reports used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations.
Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau.
PROJECT OVERVIEW:
Role: Power BI Admin/Developer March 2022 to till date
Projects Involved: Spring broad, Redwood.
Client: OSI Digital
OSI Digital is a global leader in offering business and technology solutions across industries that accelerate digital transformations.
ROLES & RESPONSIBILITIES:
●Scheduled meetings with Clients for requirement discussions.
●Participated in summits with the clients for live production.
●Documented the high-level architectural view of the organization.
●Built out the data and reporting infrastructure from the ground up using Power BI desktop and SQL to provide real time insights into product, marketing funnels and business K Pi’s.
●Built operational reports using Power BI and Snowflake, PostgreSQL to find areas of improvement for contractors in annual income revenue
●Installed power BI gateway and scheduled refreshes for the reports.
●Implemented row level security to grant access for only a few users in the security report.
●Created and maintained work spaces for different environments like development, QA and prod.
●Handled tenant level responsibilities such as subscriptions, users and groups.
●Assigned Power BI premium capacity to a workspace as dealt with large data sets.
●Updated the mapping document with the new updates.
●Documented the entire flow of demographic and transaction data flow with existing parameters.
●Used Power Automate to create workflows to synchronize files, get notifications, collect data.
●automated workflows for the business processes for up to date data.
●Added security labels for sensitive data for Security Governance.
●Experienced in DAX expressions in tabular models as per business requirements.
●Ingested data from disparate data sources using python.
●Used spark in python to distribute data processing on large streaming data sets to improve ingestion and speed.
●Used Service Now for ticket management and for CICD change management system.
●Communicated for Service now CICD approvals for the deployments.
●Troubleshooted existing reports which took a long time to load the visuals by using a performance analyzer.
●Built data marts for centralized experience from different sources like Oracle, Snowflake and PostgreSQL
●Optimized SQL queries which took long enough to run by using query execution plan..
●Created a branch and pulled requests for approvals to push the code in Azure DevOps.
●Gone through the change request process for the deployment process in Service Now.
●Responsible for creating service now tickets for change requests, incidents and DMO requests.
●Created Snowflake views for reporting purposes.
●Built composite and tabular model reports from different data sources.
●Built dashboards with different visuals such as KPI’ s, matrix, gauge, table and forecast ed using Line chart.
●Enabled cross filtering functionality and disabled edit interactions if not needed filtering capability in the dashboard.
●Wrote calculated columns and measures to get only necessary data.
●Added calculated columns in power query.
●Created step by step procedures in the documentation which is in Confluence for future references.
●Scheduled reports with incremental refresh to load real time data using parameters.
●Implemented static and Dynamic row level security using groups in security and assigned different user groups in service.
Client: Microsoft
Microsoft is a leading global vendor of computer software, hardware for computer, mobile and gaming systems and cloud services. Microsoft does business worldwide and have offices in more than 100 countries. We generate revenue by developing, licensing, and supporting a wide range of software products and services, by designing and selling hardware, and by delivering relevant online advertising to a global customer audience.
Role: Power BI Admin/Developer February 2021 to February 2022
Projects Involved: Fast Track Reporting, Fast Track Engineering
ROLES & RESPONSIBILITIES:
●Scheduled Meetings with Business Analyst in discussing the Business expectations and deadlines for the report release.
●Gathering all the data sources required to build the Business solution.
●Interacted with the business and technical team to get project requirements.
●Worked across product teams to help solve customer-facing issues.
●Participated in a full development life cycle including requirements analysis, design, development, deployment.
●Generated computed tables in Power BI by using Dax .
●Used copy, look up, filter activities in data flows to filter the data for the presentation layer.
●Experience in Cube designing in (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
●Created measures and aggregations in cube for reporting purposes.
●Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
●Created K PI's, Partitions, Perspectives, and Calculated Measures, used DAX queries.
●Experience on developing tabular cube in SSAS Analysis Service as well as connecting cube models on excel for data validation.
●Designed and implemented power BI Data flows and centralized work spaces backed up on premium capacity for the reports.
●Generated the weekly, monthly, and quarterly Budget and revenue reports.
●Preparing, Cleansing and Merging of the data coming from different sources (SQL Server, Azure SQL, SharePoint.
●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
●Implemented Row Level Security for Security and Compliance reports based on the workloads.
●Built Drill down and Drill through reports. Used Bookmarks to make the report navigation easy in Power BI Service.
●Built the Dashboards which includes visualizations from different reports and also optimizing the dashboard for the mobile as well.
●Distributing the content that was built in the workspace to the users by publishing an App from the App Workspace.
●Used Joins, correlated and non- correlated sub queries for complex business queries involving multiple tables & calculations from different databases.
●Shared Reports, data sets by maintaining Dev, UAT, and Production Works paces in Power BI; Packaged content through power apps.
●Used One Drive Share point for collaboration purposes.
●Used Azure DevOps for project management, tracking and to manage code.
Client: K12 Inc, Herndon, VA
K12 Inc. is an education company that sells online schooling and curriculum to state and local governments. Its educational products and services are designed as alternatives to traditional "bricks and mortar" education for public school students from kindergarten to 12th grade.
Role: Power BI Admin/Developer February 2018 to February 2021
Projects Involved: Public enrollments metrics dashboard (PEMD), RCP Reports, School Operations Dashboard,
School Staff data management (SSDM).
Responsibilities: -
●Interacted with the Schools business users for understanding the business requirements and the existing Source OLTP Systems like OLS, OMS, SAMS etc.
●Imported tables in import mode and direct query mode. Defined tables relationships and cardinality between the tables. for Ex: 1:1,1: Many, Many: Many.
●Extensively used almost all the features of Power BI Desktop: Live, import, Charts, Bookmarks,
Selection Pane, filters, Parameters, Custom functions, DAX, Time-Intelligence functions, Advanced
Analytic s, M-code, manage row level security, Publishing, Create Apps/Work spaces.
● Added required measures, calculated columns, keeping unnecessary columns hidden from reporting
view in Power BI Desktop.
● Implemented several DAX functions for various fact calculations for efficient data visualization
Create measures using the Dax language in Power BI.
• modified and troubleshooting existing Power BI reports.
●Used Merge Queries and Append Queries, remove columns and split columns, choosing required Columns in the data. (Power Query Editor, M).
●Created an app from within share point using power apps and embedded into share point online.
●Used power automate to integrate and streamline business process with Share point Online
●Used modeling tab in power bi to create start schemas based on Schools, students, courses, Classroom dimensions and enrollments facts.
●Created app works paces and published apps which included reports, data sets and dashboards.
●Created DAX functions using Filter, Mathematical, Logical, Statistical and Date Time functions to use in Power BI reports.
●Experienced with deployments, maintenance, performance and Troubleshooting database issues On-perm and in Azure SQL environments.
●Migrated Data sets/reports/Dashboards to Upper environments using deployment Pipeline in Power BI. Published Reports, Dashboards and Data sets to Cloud (Power BI Service).
●Worked on all Schools Students Activity, Outcomes Assessments reports based on Yearly, Quarterly, Monthly, and Daily. Created Drill Down Reports, Drill Through for all RCP & PEMD Reports.
●Implemented Row level security on all RCP Reports to restrict school’s data access for all schools’ teachers and admins.
●Extensively used DAX Functions like SUM, AVERAGE, MIN, MAX, CALCULATE and FILTER in almost all reports.
●Created reports using Web focus for Public enrollments metrics dashboard (PEMD).
●Create a logical and physical model of the data and design relationships by creating Star, Snowflake
or Hybrid schemas in the Azure Data warehouse (ADW).
●Used Power BI Gateways to schedule and refresh all the SQL Server On-Premises reports.
●Monitored Power BI reports and scheduled reports and made appropriate changes to run those at
at the Same time. Scheduled requested data sets/reports in Power BI Service.
●Worked Closely with the Corporate Services team to Integrate Power BI with Azure Active directory.
Provided access to end users by creating Azure AD groups and dynamic AD groups and assigned users to groups.
●Worked on creating and providing access to CAVA (California Virtual academy) guest users using Power BI Admin Portal-Azure active directory guest users to access Power BI. Shared Tenant URL to Guest users.
●Participated in reviews, meetings, status updates, Client Meetings, Client Presentation of documentation and code.
●Published/shared the reports on Power BI Cloud (Service) by creating Content Pack/Sharing the pbix file.
Environment: Power BI Desktop/Service, SSIS /SSAS/SSRS, MS SQL Server 2016/2019, Python, Py spark, Azure SQL, Microsoft Visual studio, SQL Developer, SharePoint, Confluence, Alation, ADF, ADLS/Azure data warehouse.
Client: Life touch Portrait Studios, Eden Prairie MN
The primary goal of the One Guest project is to allow for a single, high-quality and consistent view of each LPS guest to be available throughout the LPS organization. The One Guest project has been launched to address the LPS strategic initiative to better understand our guests and how we can better meet their needs.
Responsibilities:
Role: BI Developer/Admin. Oct 2015-Jan 2018
Projects: One Guest, Creation Center (CC), Online Appointments (OLA).
Responsibilities:
●Gathered requirements from the client and created tickets and maintained them on the Jira board.
●Designing new architecture to move existing on-premises data warehouse to cloud, setting up
development, testing and production environment in Azure.
●Worked with product owners to understand the requirements, creating user stories and documenting
Them. Analyzing business requirements and meeting Data owners from different domains for data discovery.
●Responsible for maintaining Enterprise Data Warehouse (Azure Data warehouse), creating database
Objects (Tables, Views, Stored procedures) and load data from heterogeneous sources (Flat File, SQL
Server, Oracle and Data Lake).
●Creating Partitions and Aggregations in the cube to improve Query Performance.
●Developing multiple versions of visual options for each report for discussion with stakeholders and
Customers.
●Participated in daily stand-up meetings, reviews, status updates, Client Meetings, Client Presentation of documentation and code.
●Documented the database models, ETL data flow from source to the Data Warehouse and all the
business rules implemented.
Created SSRS Invoice store specific reports for on prem sources.
Built wage paginated reports for all the employees across which is generated every month.
Performed Data Analysis using Excel with large data sets.
Environment: Azure Data Warehouse, Azure SQL Server, Microsoft SQL Server 2019/2017(SSAS, SSIS,
SSRS),Microsoft Visual studio 2019/2017, MS Excel 2016, MS EXCEL Power Pivot.
Client: Amway Grand Rapids, MI
Projects: Contracts & Renewals,
The Primary goal of this project is to integrate contracts from both Atlas and Legacy source systems in the ODS table that feeds GDW and ensure that the GDW picks up the atlas contracts, modify code and develop new code as necessary and standardize both atlas and legacy contract processes.
Role: Report Developer October 2013-September 2015
Responsibilities:
●Gathered and analyzed business end user data and identified solutions strategies for report requirements.
●Involved and worked in designing and developing the ETL flow that will update the data-structure related to Target Oracle tables using SQL Server Integration Services (SSIS).
●Designed and implemented a variety of SSRS reports on Report Server such as Parametrized, Drill-down, Ad hoc and Sub-reports using Report Designer/Report Builder based on the requirements.
●Developed and maintained Microsoft SSAS multidimensional data cubes and MDX queries.
●Designed end user documentation for training and reference purpose
●Used SM Ticketing tool for all tickets and project related activities
Environment: SSAS/SSIS /SSRS, SQL Server 2012, Oracle 11g, JIRA
EDUCATION:
Bachelor’s in Computer Science Engineer
from JNTU University
in 2013
Contact this candidate