Sai Kumar Manku

PROJECT #1: Innoflex - Impact Dashboard

• Client: Unilever Industries Pvt Ltd
• Role: Power BI Lead
• Environment: Power BI, Azure analysis service, Power BI premium, Azure SQL, Azure data bricks, Azure data factory, Azure Devops,Microsoft Fabric
• Duration: August 2020 to Till Present

Roles and Responsibilities:

• Have experience of leading team.
• Worked on requirement gathering from client and ensuring the deliverables were deployed on time
• Developed effective Power BI reports
• Optimizing Power BI reports with a focus on usability and performance
• Develop and implement best practices in creating BI solutions
• Involved in writing business logics in SQL Stored Procedure, which supports PBI Reports
• Creating Facts and Dimensions (Data Modeling)
• Involved in optimize on data modeling techniques
• Able to implement row level security on data and understand application security layer models in Power BI.
• Designed and deployed RLS in Power BI to ensure data confidentiality and compliance with organizational policies. Successfully restricted data access based on user roles, enhancing data security for over 500 users.
• Knowledge on Power BI external tools (Tabular editor, ALM tool kit, DAX studio and Measure Killer)
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop.

PROJECT #2: LM GRS L3 SteadyState project

• Client: Liberty Mutual Insurance
• Role: Power BI Developer
• Environment: POWER BI, SQL Server analysis service (MDX), Share point, Sales Force
• Duration: October 2019 to August 2020

Roles and Responsibilities:

• Developing visual reports, dashboards and KPI scorecards using Power BI desktop
• Connecting to data sources, importing data and transforming data for Business Intelligence
• Able to implement row level security on data and understand application security layer models in Power BI
• Involved in creation of Tabular, Chart, drill down, Drill Through reports and Matrix reports for Business Analysis Purposes
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop
• Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling
• Knowledge in creating Bookmarks in Microsoft Power BI Desktop
• Validated the Data of the Report with External Data sources
• Created the end-to-end Power BI alert notifications to Send email Notifications to end users by Using Microsoft flow
• Knowledge in Creating the Natural Language Questions in Microsoft Power BI Desktop
• Knowledge in Optimize the Power BI Reports.

PROJECT #3 : ACE INA-LatAm Performance-APR

• Client : CHUBB Insurance
• Role : Power BI Developer
• Environment : POWER BI, SQL SERVER 20014
• Duration : February 2019 to October 2019

Roles and Responsibilities:

• Designing and creating dashboards with Interactive reports for better analysis in Power BI
• Publishing reports in server with row level security
• Involved in creation of Tabular, Chart, drill down, Drill Through reports and Matrix reports for Business Analysis Purposes
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop
• Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling
• Knowledge in creating Bookmarks DAX in Microsoft Power BI Desktop

PROJECT #4 : Customer Relationship Management (CRM)

• Client : US Ecology Corporation
• Role : Power BI Developer
• Environment : POWER BI, SSRS, SQL SERVER 20014
• Duration : FEB 2018 to till FEB 2019.

Roles and Responsibilities:

• Extensively worked in data Extraction, Transformation and Loading from source to target system using Integration Services
• Creating stored procedures to save data, delete data into database and pumping the data to Application
• Involved in creation of Tabular, Chart, drill down, Drill Through reports and Matrix reports for Business Analysis Purposes
• Hands on experience in scheduling and deployment of the reports and uploading files to a report server catalog from the report manger
• Involved in designing the OLAP cubes
• Involved in processing the cube to perform incremental updates
• Explored the cube data using Power BI
• Excellent in creating reports in MS Power BI Desktop and publishing in web version and Mobile
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop

PROJECT #5 United India Insurance Limited Feb 2017-Feb2018

• Designation: Power BI Developer
• Location: Chennai
• About Company: United India Insurance Company is a state-owned (wholly owned by Government of India) General insurance company in India
• About Project: PoC between UIIC and Microsoft India to create dashboards for Banc assurance, TPA and Executive members Skills used: T-SQL and SSMS Technology: Microsoft Business Intelligence
• Team Size: 2
• Tools used: SQL Server 2012, SSDT 2010, Power BI, Oracle DB 11g client

Roles and Responsibilities:

• Fetching data from Oracle DB to SQL server
• Designing and creating dashboards with Interactive reports for better analysis in Power BI
• Publishing reports in server with row level security
• Involved in Installation, Configuration and Publishing various types of Power BI reports using different Power BI gateway connection for Database and Power BI Desktop by refreshing the Reports
• Knowledge in connectivity of Power BI Desktop with various data bases
• Excellent in creating reports in MS Power BI Desktop and publishing in web version and Mobile
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop
• Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling
• Expert knowledge connecting Microsoft Power BI Desktop to various data sources, MS Excel, CSV and SQL Server
• Expert knowledge using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table).

PROJECT #6 Client: MAARTEN DIEPENMAAT | STATLER [MAARTEN@STATLER.NL], Singapore

• Skills used: T-SQL, SSIS, and SSMS
• Technology: Microsoft Business Intelligence
• Team Size: 3
• Tools used: SQL Server 2012, SSDT 2010, Power BI Work

Roles and Responsibilities:

• Designing and creating dashboards with Interactive reports for better analysis of sales by state, brands, size and time in Power BI
• Creating roles by state and management
• Knowledge in connectivity of Power BI Desktop with various data bases
• Excellent in creating reports in MS Power BI Desktop and publishing in web version and Mobile
• Knowledge in creating calculated measures and columns with DAX in Microsoft Power BI Desktop
• Experience in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling.

• About Project: Designing, implementing and maintaining dashboards for staler Hotel management
• Skills used: T-SQL, SSMS, and SSRS
• Technology: Microsoft Business Intelligence
• Team Size: 8
• Tools used: SQL Server 2012, SSDT 2010, Power BI

Work details:

• Importing data to SQL server from Excel
• Creating SSRS reports
• Adding roles in the database
• Proving queries for sales dashboard and Utilized Power BI Knowledge to create interactive reports