Monica Karunaimalai
Summary
- Over 7 years of professional experience as a Power BI Developer.
- Proficient in Microsoft Power BI Reporting Tool for creating visually rich reports, including Pie & Line Charts, Tree Maps, Tabular, and Matrix Reports.
- Skilled in utilizing various Power BI Visuals such as Tree Maps, Pie Charts, Funnels, Scatter Bar Charts, and Column Charts, and managing Visual Properties.
- Experienced in Column (Field) Grouping, Hierarchies Creation, and Utilization, implementing Drill Ups,Drill downs, and Field Expansion.
- Proficient in utilizing Edit Interactions, Bookmarks, including Buttons and Actions, to enhance report interactivity.
- Well-versed in creating Maps and Interactive Visuals, including Slicers and Visual Sync.
- Proficient in Power BI Modeling Techniques using Power Query [M Language] and DAX.
- Skilled in DAX query Language, implementing DAX Measures and Calculations for Accounting Aggregations, and creating DAX Quick Measures.
- Experienced in creating, maintaining, and scheduling reports in Power BI Desktop, and publishing reports to Power BI Service.
- Extensively worked with Power BI Personal and Enterprise Gateways.
- Proficient in creating Power BI Dashboards with Tiles and Pins, and working with IMPORT and UPLOAD options for Dataset Creations.
- Experienced in utilizing Power BI Report Server for Paginated Reports and the Report Builder Tool.
- Proficient in creating and working with Power BI Mobile Reports and Mobile/Phone Options in Desktop and Cloud environments.
- Skilled in sharing Reports, Dashboards, Organizational Content Packs, and App Workspaces.
- Proficient in creating complex Stored Procedures, Tables, and SQL Joins and Statements for Applications.
- Experienced in all phases of the Software Development Life Cycle (SDLC).
- Proficient in manual and automation testing, including writing SQL Queries for test case execution and bug fixing analysis.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Power BI Developer
Intel Corporation
Portland, OR
10.2021 - Current
- Analyzed batch processing performance and suggested improvements where appropriate
- Involved in the development and implementation of SSIS and SSRS application solutions for various business units across the organization
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts
- Good Experience on DAX expressions like filters, Aggregate, Functions, and time intelligence etc
- Used SSAS tabular Model for Power BI and excel reporting applications
- Implemented row-level security & groups to restrict data access in Power BI reports
- Well versed in building & deploying reports/dashboards using SSRS and Power BI
- Integrated custom visuals based on business requirements in Power BI Desktop
- Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the internal teams for strategic planning
- Created SSIS Packages to load data from sources like Flat files, Excel, OLEDB, and Oracle to SQL Server
- Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL Server Agent
- Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column, etc
- Utilized JIIRA to create agile user stories, Log bugs, Track and escalate issues
- Worked with QA team on the reports and documented all test procedures and worked closely with End users
- Created report formats and delivered personalized messages from the data warehouse through server to a wide range of users.
BI Developer
T-Mobile
Bellevue, WA
09.2018 - 10.2021
- Developed SQL solutions including tables, stored procedures, views, indexes, Triggers, Constraints, temporary tables, and user-defined data types & functions
- Crafted executive summary dashboards in Power BI to present performance monitoring metrics
- Configured Power BI data model refresh using Power BI gateways, enhancing report optimization through query and stored procedure adjustments
- Applied advanced calculations to datasets and customized columns and tables within Query editor
- Established data relationships and built tabular and multidimensional data models
- Proficient in utilizing DAX expressions for filtering, aggregation, functions, and time intelligence in Power BI
- Created visual reports, dashboards, and KPI scorecards using Power BI desktop
- Managed live connections to Power BI with Tabular cubes, optimizing cube refresh processes through partitioning across databases
- Contributed to the design and construction of data pipelines and streams using Azure
- Engineered short-term solutions and devised data roadmaps for management to achieve strategic goals.
Jr Power BI Developer
Bank of America
Charlotte, NC
09.2017 - 08.2018
- Developed customized calculated measures using DAX within Power BI to address specific business needs
- Played a pivotal role in crafting dashboards for effective visualization of customer-related data
- Created Power BI visualizations tailored to the requests of business users
- Managed Power BI Admin portals, overseeing user setup and access management
- Established Power BI Workspaces & Apps within the Power BI Service to streamline content organization
- Applied DAX expressions such as Total YTD and Total MTD for precise sales figure computation
- Orchestrated scheduled data refreshes for dashboards and reports to ensure real-time data updates
- Developed and managed multiple Power BI dashboards, reports, and content packs
- Structured and designed datasets in Power BI Desktop aligned with customer requirements and dashboard specifications
- Implemented intricate DAX expressions encompassing user relationships, summarization, and calculation
- Crafted Power BI Dashboards utilizing both Tabular and Multi-Dimensional Models
- Provided graphical analysis of data content to enhance insights
- Contributed to solution development and test plan formulation through the application of dimensional cube data modeling techniques, including DAX scripting.
Education
Master of Science - Computer Science
Texas Southern University
08-2017
Skills
- BI TOOLS : POWER BI
- DATABASE : SQL SERVER
- SQL Tools : SQL server Management Studio
- Scripting & Programming Languages : Transact- SQL, PL-SQL, Python
- Microsoft Office : Word, Excel, PowerPoint
Certification
- Microsoft Certified: Power BI Data Analyst - Expires : 04/16/2025
Timeline
Power BI Developer
Intel Corporation
10.2021 - Current
BI Developer
T-Mobile
09.2018 - 10.2021
Jr Power BI Developer
Bank of America
09.2017 - 08.2018
Master of Science - Computer Science
Texas Southern University