Pranav K
Bengaluru, India 560050 kpranav2002@[Link]
7075066891 [Link]
Results-driven Data Engineer at LTI with expertise in Power BI and SQL, successfully developed over 30 applications that enhanced operational
efficiency by 50%. Adept at data analysis and interactive dashboard design, excel in collaborating with cross-functional teams to deliver high-
performance solutions.
Skills
• Data analysis • Business intelligence
• Interactive dashboard design • POWER BI developer
• SQL • PYTHON
Work History
Data Engineer January 2024 - Current
LTI, Bengaluru, India
Job Description: Data Engineer (Client: Carrier)
Jan 2024 – Present | LTI Mindtree, Bengaluru
Developed and deployed more than 30 stunning reporting dashboards data pipelines related to sales, backlog, supply chain, transportation, logistics,
Shippable Orders, and key financial metrics.
Leveraged the power of Power Apps, seamlessly integrating with Power BI to automate data entry processes and access management, driving
operational efficiency by 50% and attention to detail-oriented manual effort by 60%.
Created and managed various Power BI refresh strategies, including scheduled refresh and incremental refresh, to track the complete history of
Power BI datasets.
Tracking of KPIs (key performance indicators) and other metrics with drill-through, Bookmarks, Page navigation functionalities to ensure the users
can perform all various operations to enhance granularity and interactivity.
Worked on the development of Executive level dashboards to streamline the process of tracking Key Performance Indicators (KPIs).
Ingestion of data from diverse sources such as Snowflake, Hana, SAP BW, Azure, AWS SQL and sharing cross-functional BI reports for business
analytics and reporting.
Optimizing performance of the reports through effective tuning of the data model, chose the right storage mode.
DAX queries by using DAX Studio to reduce report visual loading by limiting the load time under 5 secs for all visuals.
Implemented Row Level Security for cloud and on-premises data to increase user engagement.
Proficient in ETL Data marts, Data warehouse concepts (star schema, snowflake schema, dimensional modeling).
Orchestrated Power BI gateways to establish seamless connectivity and enable real-time data synchronization.
Incorporating Power Automate Flows with Power BI dashboards for implementing automation in the reports reducing time by 80% and ensuring real-
time.
Demonstrating proficiency in Power BI Desktop, Power BI Service, and Power BI Mobile, expertly adapting to diverse requirements.
Collaborated with cross-functional teams and business stakeholders to comprehend the business requirements to ensure the successful
implementation of BI solutions.
Education
Bachelor of Engineering in Electronics And Communication Engineering June 2023
JSS Academy Of Technical Education, Bengaluru, India