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
• 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
• 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