Amit Kumar Singh

Amit Kumar Singh Power BI Lead Architect | Data Analytics Expert Email:-|| Mobile:- Professional Summary Lead BI Developer with over 12+ years of experience in Business Intelligence (BI), Data Analytics, and Power BI Development. Proficient in designing and implementing data-driven solutions using Microsoft Power BI, SQL Server (T-SQL), Azure SQL, SSIS, and SSRS. Expertise in data integration, dashboard development, and business process automation with Power Apps and Power Automate. Passionate about leveraging data analytics to drive strategic decision-making and operational efficiency. Skills & Competencies Business Intelligence & Data Analytics: Power BI (Advanced Reporting, DAX, Data Modeling, Visualization) MS SQL Server (T-SQL, SSIS, SSRS, Azure SQL) Data Integration & ETL (SQL, SSIS, Azure Data Factory) Microsoft Fabric (Moderate Level) Power Automate & Power Apps (Workflow Automation & Data Management) Data Governance & Security (Row-Level Security, Data Compliance) Cloud & Database Management (Azure SQL, SQL Server, Databricks) Soft Skills: Business Process Optimization Client Communication & Stakeholder Management Agile & Scrum Methodologies Problem-Solving & Analytical Thinking Professional Experience Lead BI Architect | MyData Insights Pvt ltd June 2024 - April 2025 | Bengaluru, India Spearheaded the architecture and delivery of enterprise-wide Power BI solutions for diverse industries including healthcare, logistics, and financial services. Led the design and implementation of modular, scalable BI frameworks with reusability across multiple clients, aligning with CI/CD and Microsoft Fabric principles. Architected Azure-based data pipelines using Data Factory and SQL Server for ingesting, transforming, and storing high-volume datasets from third-party sources (e.g., CRM, ERP, IoT systems). Enforced data governance and row-level security protocols across dashboards to ensure compliance and secure role-based access. Mentored and led a cross-functional team of BI developers, Power Apps engineers, and automation specialists to deliver end-to-end analytics and reporting solutions. Collaborated directly with C-level stakeholders to translate business objectives into actionable data models and insightful visualizations. Integrated Power BI with Power Apps and Power Automate for interactive reporting, real-time data capture, and workflow automation across departments like Sales, HR, and Operations. Senior Business Consultant | EY Oct 2019 - Jun 2024 | Bengaluru, India Provided Power BI consulting and developed business intelligence solutions for clients across various industries. Integrated SQL Server, Power BI, and Azure services for scalable analytics solutions. Developed custom reports, KPIs, and interactive dashboards for decision-makers. Project 1: Cloud Cost Analytics for Global Tech Enterprise Role: Power BI Solution Architect Role Description: Led development of a cloud cost optimization platform using Power BI and Azure SQL for real-time cost monitoring and forecasting across multi-cloud environments. Contribution: Designed Azure SQL-based data model for consolidating billing data from Azure, AWS, and GCP. Built interactive cost analytics dashboards with drill-through for department and service-level spend. Implemented Power BI Row-Level Security for stakeholder-specific access. Project 2: Healthcare Patient Analytics Platform Role: BI Consultant Role Description: Designed patient-centric performance dashboards to track appointment volume, wait time, and treatment adherence across hospital chains. Contribution: Integrated Azure Data Factory for ingesting EHR and scheduling system data. Developed KPIs for missed appointments, patient feedback, and department efficiency. Automated daily report refresh and alerts for high-risk patients. Project 3: Personal Financial Management Analytics Role: Power BI Developer Role Description: Built analytics dashboards for a fintech client offering budgeting and investment advisory services to end-users. Contribution: Developed dashboards for savings behavior, spending habits, and financial goal tracking. Integrated Power BI with API-based financial aggregators and transaction logs. Created customized visuals for net worth tracking and credit utilization. Senior Consultant | Accenture Mar 2015 - Sep 2019 | Pune, India Led BI strategy development and implemented data warehouse solutions. Developed SSIS packages for automated ETL pipelines. Created custom Power BI dashboards to analyze business performance. Project 1: SAP Utilities – Customer & Revenue Analytics Role: BI Developer Role Description: Built Power BI dashboards connected to SAP IS-U for visualizing customer consumption patterns and revenue realization. Contribution: Developed ETL using SQL Server for staging data from SAP IS-U. Created RLS-enabled reports for regional and business unit heads. Delivered operational dashboards for revenue leakage detection. Project 2: SAP HANA + Power BI Integration for Energy Analytics Role: Data Analyst Role Description: Supported end-to-end analytics workflow for real-time energy consumption analytics on SAP HANA data models. Contribution: Connected Power BI directly with SAP HANA calculation views. Created dashboards for energy load patterns and forecast vs. actual analysis. Supported POCs for near real-time monitoring use cases. Project 3: Utilities Billing Accuracy Dashboard Role: Power BI Developer Role Description: Created dashboards to analyze billing errors, customer disputes, and invoice reconciliation for a North American utilities client. Contribution: Created Power BI reports for SLA violations, first-time accuracy, and adjustment trends. Used advanced DAX to calculate bill cycle metrics and adjustment ratios. Automated refresh pipeline with SQL Server and SSIS. Project 4: SAP Utilities Workforce & Asset Analytics Role: BI Consultant Role Description: Delivered workforce scheduling, equipment uptime, and maintenance analytics using data from SAP PM and HR modules. Contribution: Developed dashboards for technician performance, downtime analysis, and asset lifecycle. Combined Power BI and SQL Server data models with SharePoint data. Implemented paginated reports for operational field teams. Business Analyst | CEVA Logistics Jun 2012 - Feb 2015 | Pune, India Built supply chain analytics dashboards using Power BI. Automated logistics reporting and streamlined inventory analytics. Developed SQL-based data warehouse solutions for reporting efficiency. Key Projects & Achievements Johnson & Johnson – Pharmaceutical Data Analytics Role: Power BI Solution Architect Role Description: Led the development of end-to-end BI solutions for pharmaceutical sales and market intelligence. Contribution: Built enterprise-level dashboards for analyzing sales growth, product performance, and market share across multiple geographies. Designed and deployed automated ETL pipelines using SSIS to transform raw sales and inventory data. Defined KPIs including Sales Growth Rate, Market Share, and Product Return Rate for strategic performance tracking. Oncology Analytics – Healthcare Data Insights Role: BI Developer Role Description: Developed healthcare reporting dashboards to support clinical operations and patient care insights. Contribution: Integrated EHR and treatment records into a centralized Power BI solution. Built custom dashboards to track patient demographics, treatment adherence, and health outcomes. Enabled physicians and administrators to monitor key oncology metrics across departments. Pregistry – Drug Analytics for Pharmaceutical Industry Role: BI Consultant Role Description: Delivered compliance-focused drug analytics for regulatory and commercial performance monitoring. Contribution: Created real-time dashboards for drug sales, market trends, and competitor benchmarking. Implemented compliance tracking system to meet pharmaceutical regulations using Power BI. Daily Census – Long-Term Care Health Analytics Role: Power BI Developer Role Description: Built financial and operational analytics for long-term care facilities. Contribution: Developed dashboards for daily admissions, discharges, occupancy, and revenue forecasting. Automated financial metrics tracking including revenue by facility and service line. Shipments Report – Logistics Data Management Role: BI & Automation Consultant Role Description: Built an integrated reporting and automation system for real-time shipment tracking. Contribution: Combined Power Apps, SQL Server, and Power Automate to track shipment status, delays, and delivery SLAs. Automated data error detection and reporting workflows using SharePoint and Power Automate. CR ACS Dashboard – 5G Network Operations Analytics Role: Power BI Consultant Role Description: Designed and deployed operational dashboards to monitor 5G rollout and performance metrics. Contribution: Created real-time dashboards to visualize deployment status, market coverage, and operational KPIs. Implemented review workflows for deployment issues using Power Automate. Trading Dashboard – Financial Market Analysis Role: BI Developer Role Description: Designed interactive dashboards to track trading performance and profitability. Contribution: Built visual reports on daily P&L, transaction volume, and cost trends. Implemented backend automation using SSIS for cost allocation and data integration. COVID-19 Outbreak Analysis – Global Pandemic Reporting Role: BI Developer Role Description: Created a real-time pandemic tracking system for public reporting and health planning. Contribution: Pulled live data from global APIs and structured it for visual insights. Delivered interactive dashboards on case trends, recovery, and mortality. Sales Analysis – Revenue & Market Trends Role: Power BI Analyst Role Description: Provided actionable sales insights across regions, products, and customer segments. Contribution: Created reports that enabled business teams to track acquisition, retention, and product performance. Helped stakeholders uncover revenue drivers and improve market targeting. Education Degree: Bachelor of Engineering – EEE University: Anna University Year of Graduation: 2012 Technical Stack BI & Reporting: Power BI, SSRS, Power Automate Databases & ETL: SQL Server, Azure SQL, SSIS, Data Factory Cloud & Automation: Azure, SharePoint Online, Power Apps Programming Languages: SQL, DAX, Python (Basic)