Mallikarjuna Rao S
Senior Data Engineer
Bangalore
Overview
7
7
years of professional experience
2
2
Certifications
Work History
Senior BI Developer
SMEDC Service Private Ltd
Bangalore
12.2020 - 12.2021
- Transaction handover to EcoLab Digital Center
BI Developer
Deloitte Touche Tohmastu India LLP
Bangalore
10.2018 - 12.2020
BI Developer
Capgemini India Pvt Ltd
Bangalore
07.2014 - 09.2018
Education
Master of Computer Application -
Periyar University
Skills
Windows 7/10T-SQLPower BIReport BuilderTableau
Certification
Tableau
Profile
MallikarjunaRao BI-Developer, 09/06/1985, Bangalore, Indian, Married, Male, K3234084, 06/22/2012, 06/21/2022, India
Projects
Billing, Ecolab-NA & EU, Azure AS/Power BI Developer/ThoughtSpot/Snowflake, Understand Business Requirement and Created Modeling using Tabular Model, Involved in creation of Billing Logical Data model, Having good Experience in creating data model in Power BI and ThoughtSpot, Involved in Improving Dataset and report performance, Involved in implement different level of Securities, I have good experience creating Connection, worksheets, and live boards, I have good experience implementing security, worksheets, Views in TS, I have good experience working with TML in TS, I have good experience in writing custom experience, I have good experience in access control, spot Apps...Involved in supporting technical assistance to my team, Involved in Training for business users on power bi and ThoughtSpot, AAS/Power BI/ThoughtSpot/Snowflake, End Users, Division Finance and Customer Service would like to leverage the MAP generating Power BI reports to fulfill Orders, Billing Reporting needs. The End Users & Div Finance teams would like to update and track status of customer orders and have intramonth/unbilled sales visibility to manage month end finish. The Customer Service team would like to see order volume and trending by division, entry channel, Delivered in Full on Time (DIFOT), and workloads Orders, Ecolab-NA, ADF/Azure AS/Power BI Developer/Snowflake, Understand Business Requirement and Created Modeling using Tabular Model, Created Partitions, Perspectives, and roles, Created Calculated Tables, Columns and Measures, Deployed AAS Models to Different Environment and Automated Process, Implemented RLS as per requirement, Implemented best practices for AAS, Good at creating different type of calculations using DAX, Good experience on collaboration of reports and Microsoft Flow, Good experience on providing security for reports to end users, Embedded power bi reports into OneFPS applications, Created Pipelines for Automate the AS Process, Trained the users and helped them to improve and maintain their reports, AAS/Power BI/Snowflake, End Users, Division Finance and Customer Service would like to leverage the MAP generating Power BI reports to fulfill Orders Reporting needs. The End Users & Div Finance teams would like to update and track status of customer orders and have intramonth/unbilled sales visibility to manage month end finish. The Customer Service team would like to see order volume and trending by division, entry channel, Delivered in Full On Time (DIFOT), and workloads Orders, Ecolab-NA, ADF/Azure AS/Power BI Developer, Understand Business Requirement and Created Modeling using Tabular Model, Created Partitions, Perspectives, and roles, Created Calculated Tables, Columns and Measures, Deployed AAS Models to Different Environment and Automated Process, Implemented RLS as per requirement, Implemented best practices for AAS, Good at creating different type of calculations using DAX, AAS/Power BI/Snowflake, End Users, Division Finance and Customer Service would like to leverage the MAP generating Power BI reports to fulfill Orders Reporting needs. The End Users & Div Finance teams would like to update and track status of customer orders and have intramonth/unbilled sales visibility to manage month end finish. The Customer Service team would like to see order volume and trending by division, entry channel, Delivered in Full On Time (DIFOT), and workloads OneFPS, Shell, ADF/Azure AS/Power BI Developer, Understand Business Requirement and Created Modeling using Tabular Model, Created Partitions, Perspectives, and roles, Created Calculated Tables, Columns and Measures, Deployed AAS Models to Different Environment and Automated Process, Implemented RLS as per requirement, Implemented best practices for AAS, Good at creating different type of calculations using DAX, Good experience on collaboration of reports and Microsoft Flow, Good experience on providing security for reports to end users, Embedded power bi reports into OneFPS applications, Created Pipelines for Automate the AS Process, Trained the users and helped them to improve and maintain their reports, AAS/Power BI/Sql Server 2017, Shell is vertically integrated and is active in every area of the oil and gas industry, including exploration and production, refining, transport, distribution and marketing, petrochemicals, power generation and trading. It also has renewable energy activities, Shell has operations in over 70 countries, produces around 3.7 million barrels of oil equivalent per day and has 44,000 service stations worldwide Consumer Goods, Unilever North America, Azure AS/SQL Server/Power BI Developer/ADF, Created Analysis services Tabular Models using Visual Studio 2016, Created Dimension modeling in AAS, Created Partitions, Perspectives, calculated tables, Created calculate Measures and columns, Generated the XMLA scripts for deployment the cube into production Environment, Created power bi Reports using Power Bi Desktop, Created apps in power bi services for business users, Implemented Security for reports, ADF/SSAS, SQL Server and Power BI, Purpose of this project is sending monthly reports to Key Clients. Customer Charter system aims at better customer relationship. Application provides different reports at the level of Customers (also Clients) and KCMs (Key Client Managers). These reports helps customers to visualize there business and improvement. KCMs can monitor growth of business with respective clients and help to improve more business. Along with this KCMs are also responsible to handle issues from Clients (for e.g. numbers for clients in reports are not matching with their expectations).Reports in CT application for Clients are divided in 3 categories: Reliability, Ease of doing business and Environmental performance. IMS Tools, HP, Power BI Developer, Having Good Experience in optimizing Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization, Having Good Experience on Build the Power BI Report Modeling, Implemented Row Level Security by defining various constraints for each defined Role, Having Good Experience in creating calculated measures and columns with DAX, Good at creating different visualizations using Slicers, Lines, Pies, Maps, Waterfall, Heat Maps, Tree maps etc, Having Good Experience in transform the data using power bi desktop, Good experience configuring gateways and scheduled power bi reports, Implemented different types of filters in Power BI, Good Knowledge on collaboration of reports and Microsoft Flow, Good experience on providing security for reports to end users, Embedded power bi reports into client applications, Trained the users and helped them to improve and maintain their reports, ADF/A AS/Power BI/Sql Server 2014, IMS Tools is a collection of web-based applications in support of the ink manufacturing process, in this we have 3 separate application for manufacturing INK.
Ink Commander – It is a web-based application for executing commands for the completion of the ink manufacturing process.
Part Tracking - Material Entry System – It is a Web-based application for raw material data gathering and reporting.
QC Tracking - IMS QC Tracking System is an Integrated Laboratory Information Management System (LIMS), in support of the Ink. SMO, Apps NA, BI Developer, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI, Having good Experience in creating dashboards, volume reports, operating summaries, and presentations and graphs, Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance, Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes, Creating packages on SSIS by using different data transformations like Derived Column, Conditional split, Pivot,Multicast,Sortand Execute SQL Task to load data into data warehouse, Created and Deployed packages successfully, Scheduled the ETL Package Using SQL Server 2008 R2 Management Studio, SSAS, SSIS, SQL Server 2008R2, The SMO organization is involved in each stage of a deal starting from the pursuit stage to setting up services during transition to being involved in delivering SMaaS services as a part of sustain.
Timeline
Senior BI Developer
SMEDC Service Private Ltd
12.2020 - 12.2021
BI Developer
Deloitte Touche Tohmastu India LLP
10.2018 - 12.2020
BI Developer
Capgemini India Pvt Ltd
07.2014 - 09.2018
Master of Computer Application -
Periyar University