LAKSHMIKANTH M. C

• Company Overview: IT
• Good experience in building persona-based reports
• Proficient in designing interactive reports and dashboards using Power BI Desktop & publishing reports
• Extensively worked on performing the ETL Activities in Power Query
• Good Experience in filtering the Unwanted Data in Power Query
• Extensively used transformations like add column, split column, pivot column, unpivot column, changing data type, Merge queries and Append queries
• Good experience in doing Data Modeling in Power Pivot Model
• Familiar to write the DAX queries in Power BI, creating calculated measures, computed columns and table using DAX
• Good experience in different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for creating new information
• Having experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report
• Having experience in creating Parameters, Hierarchies, sorting, grouping, binning and Drilldown Reports
• Good at creating native visualizations (table, matrix, kpi, gauge, various types of charts, and maps)
• Good knowledge on Power BI Service for creating APP Workspaces and adding the Members to APP Workspace to Manage the Content
• Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset
• Good experience in publishing the Reports and Dashboards to Power BI Service along the outputs with applying row level security
• Hands on Experience on writing SQL Queries as part of testing the Data
• Good knowledge on Data warehouse concepts like Star schema, snow-flake schemas etc
• Good experience in creating sample POC for Client
• Self-motivated team player with good communication, Analytical, Problem solving and Interpersonal skills to communicate effectively at all levels of the development process

• Lead operational improvement projects

• Company Overview: Retail

Project management

Project name: CRC (Carbon Tax Project)

• Conducting requirement analysis to design the statutory report which would fit the compliance with regulatory requirements which required a travel to the UK.
• Identifying the cost, quality, available resources, and a realistic timetable
• Establishing and maintaining CRC project monitoring, control and reporting system that supports on-going assessment of project performance and timely adjustment of project execution to achieve project objectives
• Developing and maintaining the Project Execution Plan related to project tracking, trending, reporting and change control elements
• Maintaining the project risk register
• Integrating project schedule(s) and performed critical path and variance analysis
• Designing Budgeting and Forecast model for multiple entities involved in the statutory project.
• Liaising with the internal auditors, government agency and other stakeholders.
• Preparing project closure document
• As a SME, independently delivered internal audit process and UK government audit for statutory project and passed the audit without any material audit concerns

Project name: Reengineering database for the ease of using humongous files

• Preparing a detailed Business case of the project to help the business understand the requirement of the project
• Creating a detailed project execution plan which includes financial plan, resource plan, risk plan
• Working with IT team to automate the existing process by sharing with them the automation requirements
• Testing the automated file to check if it is giving the desired result
• Preparing project closure document
• Project Reporting
• Preparation of project status report
• Gantt chart preparation
• Maintaining cost tracking reports
• Maintaining issue log
• Performing critical path and variance analysis

• Company Overview: Investment Banking
• Reporting
• Investment Banking