Summary
Overview
Work History
Education
Skills
Timeline
Generic

MOUNICA MUKKU

BUSINESS INTELLIGENCE DEVELOPER

Summary

Highly skilled Business Intelligence Developer with over 7+ years of experience in designing, developing and implementing BI Solutions. Expertise in Business Intelligence tools such as Microsoft Power BI Desktop, Tableau, QlikView, Snow Flake for Reporting and Dashboard creation.

Overview

8
8
years of professional experience

Work History

Power BI/SQL Developer

Murad LLC
04.2023 - Current
  • Continuous interaction with Business Analysts and end users to gather business requirements and layouts of dashboards to be developed and defining requirements and Data Strategies
  • Understanding business KPI's, requirements and functionalities from specifications and creating SSIS packages to import and export data from Excel spreadsheets, Peoplesoft, Oracle database, CSV files and various direct sources.
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications leading to 6% increase in data driven decision making across organization.
  • Developed various dashboards to know Sales insights of Murad products in Sephora, Ulta and Macy's and user interactive reports, Ad-hoc reports, Drill down reports according to business requirements in time restricted environment.
  • Experience in creating DAX measures for Month-to-date(MTD), Quarter-to-date(QTD), Year-to date(YTD) sales growth analysis
  • Created several Complex Reports (sub reports, graphical, multiple groupings, drill downs, parameter driven, formulas, summarized and conditional formatting).

Business Intelligence Analyst

Ria Money Transfer
12.2022 - 04.2023
  • Standardized best practices in report generation across departments to ensure consistency in presentation formats as well as analysis methodologies employed.
  • Collaborated with Financial team to develop and publish Daily Financial Reporting dashboard both in Power BI service and Tableau which was used by all finance teams across Ria
  • Wrote T-SQL queries and stored procedures and used them to build packages and handled slowly changing dimensions to maintain history of data
  • Designed and created innovative and valuable visualizations to identify patterns, trends and exceptions which enabled business executives and senior leadership to make data driven decisions and developed various solution driven reports for Financial information of Ria for Georgia and Malaysia
  • Developed Tabular models by implementing interactive visualizations resulting in simplified data interpretation and decision making
  • Conducted Data Cleaning and validation to ensure data accuracy and consistency.

Associate Power BI Developer

Tema Business Systems Pvt Ltd
09.2019 - 12.2022
  • Extracted data from various sources like Oracle, Flat files and XML files and loaded into Fact and dimensional tables of data warehouse
  • Extensively involved in SSAS storage and partitions, aggregations, calculation of queries with MDX, Data Mining Models, and Tabular developing reports using MDX and SQL.
  • Designed, developed and implemented Tableau Business Intelligence Reports.
  • Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly, and quarterly reports including current status and involved in generating Matrix reports, Sub reports and complex reports.
  • Provided ongoing QlikView implementation and support.
  • Took part in creating Star Schema, and Snowflake dimensional schema in MS analysis services (SSAS).

Data Visualization Consultant

Cognizant Technology Solutions
11.2015 - 02.2019
  • Utilize business analytics to create performance analysis reports and compile data to drive process improvement opportunities.
  • Supported clients with business analysis, documentation, and data modeling.
  • Generate Client Specific Reports relating to operations and respond to data requests and other inquiries from client
  • Extract and organize datasets using Excel to create business models and compile data for organization's risk index.

Education

06.2015

Skills

  • SQL Server Management Studio
  • Business Intelligence Development Studio (BIDS)
  • Visual Studio
  • TOAD
  • Power BI Desktop
  • Tableau Desktop
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • Data Transformation Services (DTS)
  • SQL Server Analysis Services (SSAS)
  • MS Visio
  • Snowflake
  • Oracle
  • Azure SQL Database
  • Data bricks

Timeline

Power BI/SQL Developer

Murad LLC
04.2023 - Current

Business Intelligence Analyst

Ria Money Transfer
12.2022 - 04.2023

Associate Power BI Developer

Tema Business Systems Pvt Ltd
09.2019 - 12.2022

Data Visualization Consultant

Cognizant Technology Solutions
11.2015 - 02.2019

Similar Profiles

CREATE PROFILE
MOUNICA MUKKU