Tanvi Paliwal
Arlington Heights,IL
Summary
- Experienced Business Intelligence Engineer with a passion for using data visualization to develop a meaningful storyline with the data.
- Proficient in the analysis, design and development of database and Business Intelligence solutions. Detail-oriented team player with strong organizational skills.
- Ability to handle multiple projects simultaneously with a high degree of accuracy. Skilled in developing the logical and physical data model and designed the data flow.
- Experienced in creating SQL queries, derived tables, common table expressions (CTEs), stored procedures and views.
- Experience of participating in configuration of on-premises Power BI gateway to refresh datasets of Power BI.
Overview
6
6
years of professional experience
Work History
PowerBI Developer
DataDelivers LLC
Schaumburg, IL
10.2022 - Current
- Analyzed user requirements and defined functional specifications
- Defined conceptual, logical, and physical architecture for Business Intelligence platforms
- Participated in the solution life cycle process to gather requirements, design, develop, deploy, and maintain PowerBI visualizations and reports
- Configured and connected the PowerBI with AWS Big Data repositories
- Designed and build dashboards and reports using PowerBI
- Supported bug fixes and maintenance of existing reports on Qlik sense
- Migrated data models and standard reporting suite from Qlik sense to Power BI
- Enhanced the PowerBI landscape in production and development environment
- Developed and implemented test validations of the platforms and applications
- Analyzed test results and recommended modifications to meet project specifications
- Documented source-to-target mappings, data dictionaries and structuring of Power BI report suite
- Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
Business Intelligence Engineer
Rocket Auto LLC
Detroit, MI
12.2020 - 09.2022
- Gathered and documented business requirements for analytical reports
- Participated in grooming and sprint planning sessions
- Interacted with technologists and business partners to understand the abstract business problems and presented optimal solutions
- Integrated Custom Visuals based on business requirements using Power BI desktop
- Developed complex calculated measures using Data Analysis Expression language (DAX)
- Collaborated with the team to work collectively on the custom visuals and made the report design more effective for the business users to make their strategic decisions
- Developed automated BI solutions to address client questions
- Leveraged data and Business Intelligence tool like Power BI to turn data into useful insights
- Developed JSON themes to be used as the standard layouts in the report across the organization
- Developed Power BI reports/dashboard based on the requirements from the business user
- Developed Executive metrics dashboard which helped the Leaders in making strategic decision for the business
- Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
Power BI/Data Analyst
California Creative Solutions Inc
Poway, CA
07.2019 - 11.2020
- Conducted team meetings and one-on-one sessions with the stakeholders/business owners to collect the new business requirements
- Documented data flows
- Analyzed the data sources and studied the data model to identify the type of data and relationships
- Performed GAP to analyze the variance between the system capabilities and business requirements
- Contributed to perform data analysis and data validation by writing complex SQL queries
- Performed certain quality check tasks like identifying duplicates, blank cells, truncation issue and other inconsistencies in the data
- Identified patterns and trends in data sets
- Build SQL queries to fetch data required based on the requirements
- Compiled the analyzed data to be consumed in the form of reports for the use of stakeholders & business owners
- Connected to the different data sources line Netezza database through OLEDB source, Excel from SharePoint site and importing the data in PBIX file
- Build Power BI data models that involved query optimization and query profiling
- Developed various Power BI reports and dashboards with effective visualizations as per business requirements
- Created different trending line and bar charts showing day-to-day, weekly, quarterly, and monthly comparisons
- Used time intelligence DAX functions to accomplish the trending charts
- Helped the business users to take better decisions by presenting Incident Management Analysis data
- Demonstrated ability of recognizing opportunities to solve problems by developing automated BI solutions
- Worked with Power BI Premium capacity and also developed front end input forms using Power Apps
- Implemented features such as bookmark and selection pane in Power BI dashboards for better visibility
- Wrote calculated columns, measure queries in Power BI Desktop to show good data analysis techniques
- Implemented numerous filters in Power BI such as page level, report level and drill through filters
- Participated in configuring on-premises Power BI gateway to refresh datasets of Power BI reports/dashboards
- Utilized multiple new custom visuals like decomposition tree and Zebra BI charts for enhanced data analysis
- Documented the report/dashboard functionality and dataset details on confluence for future reference.
Data Visualization/Analysis Developer
California Creative Solutions Inc
Poway, CA
03.2019 - 06.2019
- Interacted with business users to gather requirements for preparing Power BI report
- Prepared data mapping document and worked with technical SME’s for gathering the information
- Analyzed the existing data model and incorporated new additions for the advancement data into the data model ensuring proper referential integrity of the system
- Formulated SQL scripts to analyze historical data and extract required data for supporting management decisions
- Created SSIS packages for the ETL process to load the data from source to destination
- The source database was on Oracle and the destination database was on SQL server
- Developed Power Bi reports and dashboard as per the business requirements using various slicers, drill down donut chart, pie chart and multiple graphs
- The source used for reporting was SQL Server Database
- Utilized various DAX functions such as Calculate, Value and some Logical and Aggregate Functions to create different measures on the Power BI report
- Configured Power BI Enterprise Gateway for the refreshing of the reports
- Presented the dashboard to the business users and gave demo on its working process
- Prepared a user guide documentation explaining the working functionalities of Power BI report using Confluence
- Determined calculations to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas
- Published Power BI reports to the Power BI self-service and troubleshoot deployment and performance issues
- Created visually appealing and highly informative dashboards in Power BI
- Utilized slicers and sync slicers as required to control the data displayed within the Power BI dashboards
- Developed the Power BI reports to meet the defined accessibility standards to make it accessible through keyboard and for the screen reader
- Created Email Subscription for Power BI reports using app.powerbi.com (Power BI Services).
Data Analyst/Power BI Developer
California Creative Solutions Inc
Poway, CA
12.2018 - 03.2019
- Created system requirement gathering documents based on extensive JRD and JAD sessions
- Identified and mapped various data sources and their targets to create a fully functioning data repository
- Created complex stored procedures to perform index maintenance, data profiling, and metadata searches
- Redesigned and optimized existing stored procedures, triggers, and views
- Optimized SSIS packages with non-blocking/synchronous transformations and task/transformation properties
- Designed usage-based optimizations for better query performance in SSAS as per business requirement
- Developed multitude of reports using multiple graphs, pie charts, slicers, maps, heat maps utilizing Power BI Desktop
- Created data alerts on several thresholds in Power BI dashboards using Power BI services
- Prepared a user manual explaining all the features of the Power BI reports and several functionalities possible
- Identified and displayed various metrics such as Client growth rate, Client retention rate, Gross profit margin and Resource Utilization in Power BI dashboard
- Developed various operational drill-through and drill-down reports using SSRS
- Worked on report design, report model, report configuration and deployment using SSRS
- Scheduled data driven mailing subscriptions on SSRS reporting server
- Utilized Azure for data migration from On-Premises system to cloud OLAP system.
Business Analyst
Genius Minds LLC
Tacoma, WA
08.2018 - 12.2018
- Collaborated with stakeholder groups across the organization to ensure business and technology alignment
- Proposed solutions meeting defined specifications and needs
- Gathered technical requirements and participated in design sessions
- Developed project plan timelines and manage workflows to meet project timelines
- Worked closely with liaison side, development/testing side and estimating the time required to complete the project requirements
- Identified process bottlenecks and implemented new and improved processes and policies.
Education
Master’s in Information Technology and Management -
Illinois Institute of Technology
Skills
Database: SQL Server 2018, 2016, 2014, 2012, 2008/R2, Netezza, AWS
SDLC: Agile, Scrum, Waterfall, and Spiral
Data Modeling: Erwin, MS Visio
Database Programming: T-SQL, MDX, DAX
Development Tools: SSDT, SSMS, Aginity Workbench, DAX Studio, Amazon Athena
Integration Tool: SSIS
Analysis Services: SSAS, OLAP Cubes, Tabular Model
Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI, Qlik Sense
Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint
Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory,
MS Azure Synapse, Azure Storage (BLOB, Tables, Queues, and File Share)
Timeline
PowerBI Developer
DataDelivers LLC
10.2022 - Current
Business Intelligence Engineer
Rocket Auto LLC
12.2020 - 09.2022
Power BI/Data Analyst
California Creative Solutions Inc
07.2019 - 11.2020
Data Visualization/Analysis Developer
California Creative Solutions Inc
03.2019 - 06.2019
Data Analyst/Power BI Developer
California Creative Solutions Inc
12.2018 - 03.2019
Business Analyst
Genius Minds LLC
08.2018 - 12.2018
Master’s in Information Technology and Management -
Illinois Institute of Technology
Similar Profiles
Stacey MangumStacey Mangum
Store Manager at Gunsmoke Firearms LLC Formerly Hi-Caliber LLCStore Manager at Gunsmoke Firearms LLC Formerly Hi-Caliber LLC
Emma LuvianoEmma Luviano
Billing Manager at KDT LLC & KIDS DC, LLCBilling Manager at KDT LLC & KIDS DC, LLC
Kyle HornerKyle Horner
CSR & Logistics Coordinator at Global Plastics, LLC. - MGI International, LLC.CSR & Logistics Coordinator at Global Plastics, LLC. - MGI International, LLC.
EDITH GONZALEZEDITH GONZALEZ
Sales Manager at Luxottica RetailSales Manager at Luxottica Retail
Tom Williams Jr.Tom Williams Jr.
Supervisor – Revenue Cycle Management AR Collections at OptumRx, United Health Group (NYSE: UNH)Supervisor – Revenue Cycle Management AR Collections at OptumRx, United Health Group (NYSE: UNH)