Data Analytics and Power bi Developer Phone no.:- +91-898*******
Hoonar Teckwurks Pvt Ltd Email:- ***************@*****.*** LinkedIn:- linkedin.com/in/thevisheshgarg Github:- github.com/VisheshGarg-99 Professional Expertise:
I have 4 years of experience in data cleaning, ETL processes, analytics, warehousing, and visualization, along with providing technical training and mentorship. I’ve managed client interactions and project delivery, collaborated with stakeholders, and contributed to wireframing for effective system design. My skill set enables me to deliver data-driven solutions that align with both technical and business goals. Projects:
• Data Migration to Databricks and SSRS Reports creation for Indusind Bank: This project involves migrating data to Databricks and performing the necessary query conversions to ensure compatibility with Databricks Spark architecture. The goal is to create SSRS reports from Databricks data, ensuring quality and integrity of the data.
• Data Migration from Cloudera to Snowflake and Query Conversion for XL Axiata: This project involves migrating data from the Cloudera environment to Snowflake and performing the necessary query conversions to ensure compatibility with Snowflake's architecture. The goal is to facilitate a seamless transition, ensuring data integrity, improving query performance.
• FinTech Transformation: Tailored Funding Solutions for TaliMar Financial: Optimizing funding processes for hard money ventures. Specialized in Fix and Flip, Fix and Hold, Bridge, and New Construction loans. Enhanced efficiency and support for diverse real estate financing needs.
• CAT Pontiac, optimizing industrial machine monitoring for enhanced efficiency and insights: Implemented IIoT integration, enhancing industrial machine monitoring. Leveraged Power BI for data visualization and optimizing performance. Contributed to informed decision-making and research strategies.
• CAT Minneapolis: IIoT Integration & Power BI for Assembly Line Optimization: Revolutionized assembly line management by seamlessly integrating industrial machines with IIoT and implementing Power BI for real-time data visualization. Improved operational efficiency, transparency, and decision-making within the production environment. Project Activities:
• Fetched the data from Database. Cleaned the data by transforming it through M-query. Prepared the modeling between the created tables. Written the DAX queries & converted the business requirement into visualization.
• Created the reports & dashboard and created the power bi workspace, data sources to access Database, configured the security & data refresh rate using power BI services.
• Generated email alerts using Power Automate via powerbi and created Wireframes using tools like Balsamiq and Figma.
Work and Educational Details:
• Consultant at Hoonar Tekwurks (2024 - Present)
• Software Engineer at BitCot Technologies (2023 - 2024)
• Software Engineer at Yash Technologies. (2021 – 2023)
• B-tech in Electronics & Communication Engineering from Medi-Caps University (2017 – 2021) Technical Skills:
• Technical Skills: Python, SQL, DAX and M query, Wireframing, RPA, ETL
• Power Tools: Power Bi, Power Automate, Power Virtual Agent
• Other Tools Azure, Microsoft Fabric, AI Tools, Databricks, Data Factory, Pyspark Internship Experience:
• Data Science and Business Analytics Intern The Spark Foundation
• Industrial Training In Basic Telecom, BSNL
VISHESH GARG