V

Vivek Panchaman

Associate Consultant

Bengaluru, Karnataka, India9 yrs 4 mos experience

Key Highlights

  • Over 4 years of experience in data analysis.
  • Expert in SQL and Power BI for financial insights.
  • Proven track record in optimizing business processes.
Stackforce AI infers this person is a Data Analyst specializing in Fintech and Marketing analytics.

Contact

Skills

Core Skills

Power BiSqlData Analysis

Other Skills

3D ModelingANSYSAnalytical SkillsAssembliesAzure SQLBIWCADCAD/CAM SoftwareCATIACNCCad/camDAXData CleaningDesign EngineeringEngineering

About

Hey there! 👋 So, picture this: I'm your friendly neighborhood Business Analyst, armed with over 4 years of experience and a love for all things data-related. Right now, I'm knee-deep in the world of Harley Davidson Financial Services, where I'm cooking up some seriously cool campaigns to jazz up marketing and keep those customers engaged. But that's not all—I'm also a bit of a data wizard. SQL, Azure SQL, Power BI—you name it, I've probably dabbled in it. I've got this knack for turning piles of data into beautiful, easy-to-understand reports that'll knock your socks off. And when it comes to chatting with the bigwigs? Well, let's just say I've got a knack for making even the most complex data insights sound like a casual chat over coffee. From discussing challenges to uncovering opportunities, I'm your go-to guy. So, if you're looking for someone to sprinkle a bit of human touch on your data projects, you've come to the right place. Let's make some magic happen together! ✨📊

Experience

Neudesic, an ibm company

Consultant II

Apr 2025 – Present · 11 mos · Bengaluru, Karnataka, India · Hybrid

Caterpillar inc.

Senior Data Analyst (Via IDC Engineering India)

Feb 2024 – Apr 2025 · 1 yr 2 mos · Bengaluru, Karnataka, India · Hybrid

  • Partnered with Caterpillar to design and deliver tailored Power BI solutions, focusing on dealer financial data and performance analytics.
  • Developed interactive Power BI dashboards and reports to analyze key metrics such as Assets, Liabilities and financial performance, enabling informed decision-making.
  • Leveraged advanced DAX and semantic modeling to create efficient data models and generate actionable insights.
  • Processed and analyzed large datasets using SQL, ensuring accuracy and reliability in dealer financial reporting.
  • Optimized report performance, reducing load times and enhancing the user experience for financial data consumers.
  • Created and presented Proof of Concepts (POCs) to stakeholders, demonstrating innovative reporting solutions for complex business requirements.
  • Collaborated with cross-functional teams to translate business requirements into technical solutions, ensuring alignment with Caterpillar's goals.
Power BIDAXSQLData Analysis

Harley-davidson motor company

Business Data Analyst (via Vertisystem)

Sep 2022 – Feb 2024 · 1 yr 5 mos · India · Remote

  • As a Business Analyst, I have had the opportunity to work with Harley Davidson, primarily focusing on Harley Davidson Financial Service. My role involves actively participating in the creation of various business campaigns to drive marketing initiatives and enhance customer engagement.
  • Understanding the needs of the business owners is crucial in my role. I collaborate closely with stakeholders to identify their requirements and pull relevant data from databases. This data serves as the foundation for creating insightful reports that guide strategic decision-making.
  • SQL is the primary tool I employ to extract data, particularly utilizing Azure SQL. With my expertise in Azure SQL, I efficiently retrieve and manipulate data, enabling me to generate accurate and comprehensive reports.
  • Ensuring data accuracy is a top priority for me. I work closely with the data engineering team, validating data integrity and rectifying any issues identified. In cases where data discrepancies arise, I initiate JIRA tickets and collaborate with the data team to investigate and resolve these discrepancies effectively.
  • Regular meetings with data leadership teams play a significant role in my work. These meetings allow me to discuss data-related challenges, present insights from marketing campaigns, and explore opportunities for improvement and optimization.
  • I possess end-to-end experience in the reporting process. This involves creating queries in Azure, extracting relevant data, and importing it into Power BI to develop visually appealing and impactful reports. This holistic approach enables stakeholders to gain valuable insights and make informed decisions.
  • In addition to my SQL expertise, I have also worked with Azure Synapse. This includes tasks such as uploading output files and efficiently managing data by utilizing containers. My experience with Azure Synapse has further enhanced my capabilities in data management and analysis.
SQLAzure SQLPower BIData Analysis

Trashcon

Manufacturing Analyst

Nov 2019 – Jul 2022 · 2 yrs 8 mos · Greater Bengaluru Area

  • Developing visual reports, KPI scorecards, and dashboards using Power BI desktop
  • Was involved in data cleaning and organizing the products based on industry verticals
  • Optimized the process of inventory and improved efficiency by 20% and reduced the organization
  • costs by 30%
  • Process purchase orders and requisitions for products.
  • Communicate with prospective vendors to determine terms and availability
Power BIData CleaningKPI ScorecardsData Analysis

Arunoday machine builders

Production Engineer

Jan 2017 – Nov 2019 · 2 yrs 10 mos · Bangalore

  • Managed complex projects from start to finish
  • Procure, analyze and process data required for Construction Machineries
  • Identification of customer requirements from multiple business lines.
  • Management of multiple stakeholders and priorities.

Advanced structures india

Application Engineer

Sep 2016 – Jan 2017 · 4 mos · Bengaluru Area, India

  • Develop understanding of product line.
  • Make necessary engineering calculations to support product selection/recommendation.
  • Assume the primary technical relationship with the customer.
  • Identify customer requirements by establishing personal rapport with clients.
  • Provide input to product feature enhancements and process improvements.
  • Support R&D engineering in translating customer's needs into a manufacturable product.
  • Provide engineering support.

Ace designers

Intern

Jul 2015 – Jul 2015 · 0 mo

Education

Dr. Ambedkar Institute Of Technology

Bachelor of Engineering (B.E.) — Mechanical Engineering

Jan 2012 – Jan 2016

Visvesvaraya Technological University

Bachelor of Engineering (B.E.) — Mechanical Engineering

Jan 2012 – Jan 2016

Stackforce found 100+ more professionals with Power Bi & Sql

Explore similar profiles based on matching skills and experience