Mani Deepa Parupudi

• Creating power bi reports using different data sources using the import, direct query, and live connection mode of connectivity in Power BI
• Transforming and creating the measures, custom columns on the data based on the user requirement in the Power Query Editor by using DAX functions
• Configuring the Row Level Security in Power BI desktop and assigning the roles in the Power Bi Service based on the level of access in the workspace
• Creating and maintaining the Power BI Apps and content packs in Power BI Service
• Managing the Power BI Administration from the tenant settings of the admin portal
• Experience with analyzing the error logs from the Power BI gateway and desktop traces from Power BI Desktop
• Configuring the schedule refreshes of the on-premises data sources by using the Power BI Gateway and troubleshooting the issue if there are any failure of the refresh
• Knowledge on different authentication types and the privacy level based on the type of data source used in the Power BI desktop, Power BI service and Power BI gateway
• Work with REST API to retrieve workspace details and usage metrics of each report based on the report usage to improve the performance of the reports
• Experience in creating the Paginated reports in the report builder and publishing the reports to the workspace in the Power BI service
• Working with internal teams to mitigate the discrepancies in the Vulnerability report & file a bug/exception on demand
• Analyzing incidents to determine root cause and mitigation plans, provide all necessary troubleshooting data to Development teams

Environment: Power BI Desktop, Power BI Services, Power BI gateways, SQL.

• Collaborated with system architects, design analysts and others to understand business and industry requirements.

• Collaborated with manager to gather all the information needed for data analysis and involved in all aspects like data collection, data cleaning, developing models, visualization
• Designed, developed the database, and implemented stored procedure, common table expressions, views, indexes, triggers and worked with writing complex SQL queries that involved reoccurring sub queries with the use of multiple joins and unions using SQL server
• Creating and managing SQL Server Maintenance Plans for routine tasks and backup solutions as well as ability to create, troubleshoot and monitor SQL Server Agent jobs
• Implemented SSIS packages to perform ETL data operations (data profiling, cleansing and verification) and FTP task for file transfer
• Performed query optimization, performance tuning on existing data objects by analyzing execution plan and traces SQL Server Profiler/Database engine tuning advisor
• Migrated on-premises data from Postgres SQL to cloud SQL by building a sampling data using the flat file
• Worked on the Data Plex: Automatically apply sensitivity tags in Data Catalog to files, databases, and Big Query tables using Sensitive Data Protection and Data flow
• Worked on Sample sales business model on both the current environment (MSBI) and proposal environment (Google Cloud) by using simulated data with the reference of real data
• Mainly focused on analytics services where the source data from Data warehouse/Database to pass through table relationships, measures and hierarchies.
• And finally visualize the data in reports
• Established a Report execution alert in Power BI
• Used Collibra to perform the data quality check by establishing the connection using the JSON key by creating a job using the dimensions

Environment: Microsoft SQL Server, SSIS, SSAS, SSRS, MS Office, GCP, Data plex, Collibra.

• Designed, developed, and tested stored procedures, tables, and triggers with T-SQL; create T-SQL scripts to perform complex queries and complex data manipulations
• Designed, developed, and published various Power BI reports from multiple data sources by blending data in Power BI Desktop by utilizing various graph features such as gauge, funnel, scatter plots, maps, area charts, bar charts, column charts, pie charts along with slicers and filters
• Used Power Query to extract data from external sources and cleaned, transformed, modified the data using DAX to ingest it into Power BI for reporting
• Implemented several DAX functions for various fact calculations, custom columns, measures, and created Drill through and drill down reports for efficient data visualization in Power BI
• Configured schedule refreshes of the dataset in power bi service using the power bi gateway by connecting to different types of data sources
• Experience in exporting the report to different formats such as PDF, PowerPoint, and CSV
• Environment: Microsoft SQL Server, Microsoft Power BI Desktop, Microsoft Power BI service, Power BI Gateway.

• Gained hands-on experience in creating and testing solutions for commercial off-the-shelf applications
• Enhanced skills in data modeling, performance tuning, and solution validation testing
• Learn and apply industry standards and tools for configuration management, ensuring compliance with governance and security requirements
• Environment: SAP FICO.

• Extensive experience in developing and implementing data warehousing solutions, with a strong understanding of SQL and ETL processes.

• Collaborated with manager to gather all the information needed for data analysis and involved in all aspects like data collection, data cleaning, developing models, visualization.

• Proficient in designing and developing data models, visualizations, and dashboards in SSRS and PowerBI Desktop.

• Skilled in using data integration, transformation, and loading between various data sources and Snowflake.

• Knowledge of cloud computing and big data technologies, AWS, and Hadoop, Hive with experience in deploying Snowflake on cloud platforms.

• Strong problem-solving and troubleshooting skills, with the ability to diagnose and resolve issues related to data pipelines, data models, and visualization.

• Experience in visualizing the data, scheduling and sharing the looks and dashboard.

• Experience with using Trend lines, group, hierarchies and sets to create detail level summary reports and dashboard using KPI’s

• Monitoring the development and the big fixes on SSRS reports and the Power BI report using JIRA software.

• Working with MSBI Stack (SSIS, SSAS, SSRS) to create Data marts Reports/Dashboard for the business users.

• Experience in providing optimal solutions to the SSRS reports, Power BI issues and major production failures.

• Configuring the Power BI Gateway to perform the schedule refresh of the datasets on Power BI Service.

• Maintaining the Power BI Admin portal for the organization to provide access to the users based on the requirements.

• Creating and maintaining the data driven subscription on the SSRS reports.

• Developing and maintaining Tabular and MDM cubes for achieving best performance at the reporting level

Environment: Microsoft SQL Server, Oracle, Microsoft SSRS, SSAS, SSIS, Predictive Modeling, Power BI Desktop, Power BI Services, JIRA, Control -M.