Amit Bisht
Data Analyst
Delhi,
Summary
Results-driven Data Professional with 12+ years of experience in data analysis, business intelligence, and data transformation. Proven expertise in leveraging tools like Power BI for interactive dashboarding and reporting, SQL for advanced data querying and optimization, and DBT (Data Build Tool) for building scalable, version-controlled data pipelines. Strong background in translating business requirements into actionable insights, improving data quality and reporting efficiency across diverse domains including e-commerce, finance, and operations. Adept at working with cross-functional teams to drive data-informed decision-making and deliver measurable business impact.
Overview
13
13
years of professional experience
1
1
Certification
2
2
Languages
Work History
Team Lead
Accenture
10.2024 - Current
- Built and maintained modular, version-controlled data transformation pipelines using DBT, improving data pipeline maintainability and transparency.
- Designed and developed DBT models (staging, intermediate, and marts) to clean, standardize, and aggregate raw data from sources like orders, customers, and product inventory.
- Optimized SQL models in DBT to improve query performance and reduce data latency for downstream reporting tools.
- Integrated DBT models with Amazon Redshift / Snowflake for scalable data processing.
- Created Power BI dashboards for sales performance, customer segmentation, product analysis, and marketing campaign tracking, enabling stakeholders to make informed business decisions.
- Collaborated closely with cross-functional teams (marketing, product, and finance) to understand analytical needs and translate them into data-driven solutions.
- Implemented data validation and testing in DBT to ensure accuracy and trust in the transformed datasets.
- Leveraged Power BI's DAX and visualization features to create interactive reports and KPIs, tailored to the e-commerce domain (conversion rates, cart abandonment, CLV, etc.).
Associate Manager
HCLTech
06.2022 - 10.2024
- Did the migration project of 5 dashboards from Tableau to Power BI, ensuring seamless transition and improved functionality.
- Collaborated closely with stakeholders including business analysts, data engineers, and end-users to understand requirements and optimize dashboard performance.
- Developed a comprehensive migration plan outlining timelines, dependencies, and resource allocation, resulting in minimal disruption to ongoing operations.
- Conducted thorough analysis of existing Tableau dashboards to identify key functionalities, data sources, and visualization types for replication in Power BI.
- Spearheaded the development and management of Microsoft Power BI HRSS reporting solutions, leading to improved HR metrics tracking and enhanced reporting accuracy.
- Created visually appealing, informative dashboards that track crucial HRSS KPIs, such as employee turnover, recruitment efficiency, and employee satisfaction.
- Supported HRSS teams with ad-hoc reporting requests, troubleshooting data discrepancies, and delivering Power BI training sessions.
- Implemented Hierarchical row-level security (HRLS) model to restrict data access at a row level based on the user's position within an organizational hierarchy where employees have different levels of access to data based on their role and position in the hierarchy.
Sr. Software Engineer
Thoughtsol Infotech Pvt Ltd
11.2016 - 06.2022
- Created Power BI dashboards to provide real-time or near-real-time updates on sales performance, including metrics such as total sales revenue, units sold, average transaction value, and more.
- Analysed the performance of individual stores or branches, comparing sales, foot traffic, and profitability across different locations.
- Analysed different tender types payment methods including fintech which helped brand to understand how customers are paying for their products.
- Analysed the performance of their products or product categories using Power BI.
- Gained insights into customers' behaviour and preferences which allowed me to segment customers based on their purchase history, demographics, and buying patterns.
- Optimized inventory levels by providing insights into stock levels, turnover rates, and demand forecasting.
- Evaluated the impact of promotions and pricing strategies on sales by analysing the effectiveness of discounts, special offers and sales events.
- Uncovered patterns in customer purchasing behaviour, such as which products are often bought together.
- Analysed historical sales data to identify trends and seasonal patterns.
- Gained visibility into the supply chain by tracking orders, shipments, and delivery performance.
- Did geospatial analysis to understand the impact of location on sales.
Sr. Implementation Consultant
Spectrum Innovative Technologies Pvt Ltd
12.2012 - 11.2016
- Managed a team of support engineers who answer customer queries regarding usage of North Star Club Management Software and troubleshooting problems while running North Star Club Management Software.
- Facilitate customer resolution for escalated calls and engage the necessary technical support.
- Coordinating with professional services team and managing transition of clients for product support.
Education
Bachelor of Engineering - Electronics & Communication
Visvesvaraya Technological University
Belgaum, KarnatakaSkills
- Power BI
- SQL
- DBT (Data Build Tool)
- Microsoft Excel
- Data Visualization
- Data Modeling
- ETL Processes
- Data Analysis
- Report Development
- Data Governance
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Timeline
Team Lead
Accenture
10.2024 - Current
Associate Manager
HCLTech
06.2022 - 10.2024
Sr. Software Engineer
Thoughtsol Infotech Pvt Ltd
11.2016 - 06.2022
Sr. Implementation Consultant
Spectrum Innovative Technologies Pvt Ltd
12.2012 - 11.2016
Bachelor of Engineering - Electronics & Communication
Visvesvaraya Technological University
Similar Profiles
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture
Sumit PatilSumit Patil
SAP Security and GRC Consultant at AccentureSAP Security and GRC Consultant at Accenture
Sajal BhardwajSajal Bhardwaj
People Advisor Analyst, HRBP at AccenturePeople Advisor Analyst, HRBP at Accenture
Priyanka GhoshPriyanka Ghosh
Instructional Design Analyst at AccentureInstructional Design Analyst at Accenture
Kimberly DroskiKimberly Droski
Food and Beverage Team Lead, Closing Team Lead/General Merchandise Team Lead/Inbound/Logistics Team Lead/Food and Beverage Team Lead at TargetFood and Beverage Team Lead, Closing Team Lead/General Merchandise Team Lead/Inbound/Logistics Team Lead/Food and Beverage Team Lead at Target