UDIT LODHI

Understood business requirements in the BI context and designed data models to transform raw data into meaningful insights.

• Created dashboards and interactive visual reports using Power BI, tailored to meet specific business needs.
• Performed DAX queries and functions to enhance data analysis and reporting capabilities.
• Processed strong knowledge of parameters, appends, merges, filtering, referencing and duplicating tables in the Power BI Query Editor.
• Designed and modelled data using star schema patterns for optimized performance.
• Established relationships between data tables and developed tabular data models.
• Conducted SQL querying to generate optimized results and used filters and graphs for better data understanding.
• Worked with users and team members at all levels to gather feedback and drive performance improvement through suggestions and enhancements.
• Used Agile methodologies to adapt to dynamic priorities, deliver rapid prototypes, and implemented feedback for continuous improvement.

Key Projects :

Project 1

Role: Power BI Developer

Client: Infosys Limited

Technology Used: Power BI Desktop, Power BI Report Builder, Power BI Services, SQL, MS-Excel, Sharepoint

Time Period: Feb 2024 - Present

• Collect data from various sources including internal databases and servers.
• Ensure that the data is relevant and up-to-date to reflect the current state of project.
• Clean and preprocess data to remove inaccuracies, handle missing values and ensure consistency across datasets.
• Merge data from different sources to create a comprehensive view that can be used for analysis.
• Wrote and maintained SQL queries to extract data from various sources, resulting in 25% reduction in the time required for data extraction and improved efficiency.
• Created technical documentation for Power BI reports, SQL queries, and ETL processes.
• Included complex measures and calculated columns in visuals using DAX, and created common dataflow for different dashboards using power BI service.
• Designed Star Schema Data Model by integrating tables from different sources and performed complex calculations in transformations for reporting.

Project 2

Role: PL/SQL Developer

Client: Blue Shield of California

Technology Used: Oracle SQL, Bitbucket

Time Period: Dec 2022-Jan 2024

• Analyzed the existing stored procedures and data flows to further stages according to the requirements.
• Developed complex PL/SQL stored procedures to process the data filtering in migration to salesforce velocity through Dell Boomi.
• Tuned long-running SQL queries using indexing strategies, improved performance by 25%.
• Participated in code reviews, ensuring adherence to coding standards and best practices.