ANAND KUMAR DWIVEDI
Noida
Summary
Dynamic Senior Tech Architect with extensive experience at Citiustech, specializing in Business Intelligence and analytics. Proven track record in implementing Power BI solutions, enhancing data integrity, and leading cross-functional teams. Expert in DAX and stakeholder management, driving successful migrations and optimizing BI costs for impactful results.
Overview
19
19
years of professional experience
Work History
Senior Tech Architect
Citiustech
09.2024 - Current
- Heading the Practice Domain for BI as Practice Lead & Individual Contributor
- Conversational implementation in Power BI (Co-pilot, Agents), Looker (Gemini), Tableau Pulse
- Successfully migrated Power BI premium to MS Fabric 64SKU
- An Individual Contributor implemented write back in Power BI via translytical task flows saving the cost
- By replacing Power Apps & Power Automate meant for same purpose.
- Fabric data agent integration with Co-pilot in Power BI with Snowflake Cortex or Data Bricks Genie AI/BI
- Using Azure OpenAI to utilize the capabilities of BI and Azure LLM.
- Guiding POV for Agentic AI in MS Fabric and components.
- POC of latest features of Power BI MCP Servers for Natural Language modelling & Custom agent development.
- Participating actively with the Sales & Presales team to develop the technical architecture for BI & Agentic Approach.
- Assisted Organization in successful bids many were above 1M value.
- Participate in Optimization of Licence costs of BI & Agents Implementation.
- Managing 200+ resources for in practice team for their successful allocation in Business teams and assist their Skill mapping & enhance programs. Levels vary from Architects to Associates.
Senior Tech Architect
Indium Software
12.2023 - 08.2024
Senior Tech Architect
iLink Digital
02.2023 - 12.2023
- Case Studies for Ms Fabric cost benefit analysis.
- Migrated SAP BO, HANA reports to Power BI where data sources were SAP BW, SAP Universe.
- Interact and collaborate with multiple teams (Data Science, Consulting & Engineering) and various stakeholders to meet deadlines, to bring Analytical Solutions to life
- Working with Pre-Sales team for case studies & Presale RPF and RPQ
- Implement Dev Ops best practices of BI CI/CD pipelines.
- Administration and POC and implementation of Best Practices
- Leading the development team for architecture, DAX and visualization
- Case study of Different BI tools for COE, Like Snowflake Sigma, Looker Studio
- Bosch Health care lift and shift from Qlik to Power BI. It included asset Management Dashboard.
- Worked as Architect Power BI for Blue Yonder on behalf of ETG Digital for to create Cards with embedded with Snowflake
Power BI Architect
IPacesetters LLC
04.2019 - 02.2023
- Automation & Dashboard using Power BI, R & Python.
- Administration of Workspaces and licences.
- Sales Analytics in Power Platform (Power BI, Power Automate, Apps)
- Decision Analytics feasibility using Azure SSAS, Data bricks and Synapse in Azure.
- Sentiment Analysis for Chat bot
- Customer Churn Analytics using Power BI, Python & Azure Data bricks
- Successfully migrated several projects from Qlik / Tableau to Power BI guiding the team and writing complex DAX and data modelling.
- Technical Lead for the team of 10 members at Client side as Solution Architect for Self Service BI.
- Provide on-the-job training for new or less experienced team members.
- Implemented Heath Care BD, Becton Dickinson diagnostic and pathology BI Dashboard And Architecture.
Manager Reporting & Analytics
Sun Life Financial
04.2018 - 04.2019
- Technical Lead for the team of 10 members at Client side as Solution Architect for Self Service BI.
- Business Forecasting and Planning & Strategy execution of Reports.
- Back office Automation, Reporting & Visualization using Power BI & Tableau 10.5 i.e. Self-Service BI.
- HR Analytics for organizational structure.
- Automation & Dashboard using Tableau R & Python.
- Comparison of different Analytical Tools for Visualization and execution with R & Python.
- Case study for implementation of RPA technologies.
Manager
Cognizant
08.2016 - 04.2018
- Technical Lead for the team of 12 members at Client side as Solution Architect.
- Business Forecasting and Planning & Strategy execution.
- Implemented Text Analytics using R (NLP & Open NLP) with Power BI to for sentiment analysis.
- It solved the problem of high-rise claims for certain geographical areas. It involved Time Series Analysis as well.
- Implemented Power + R + SSAS tabular + Azure Analysis services with Office 2016 for reporting and data insight.
- Work allocation among team members for SQL, VBA, BI, Application data reconciliation support.
- Client interaction for on time delivery of modules.
- Interaction with Microsoft on behalf of Client for implementation and comparison of latest Analytics tools such as POWERBI + SSAS Tabular + R+ Python.
- Analyse and implement Data Visualization techniques for Actuarial Team members.
- Solution Architect for complex Excel VBA + SQL applications and guide the team to adapt Excel BI features like Power Pivot, Power Query.
Sr Executive (M2G3)
SAMSUNG HEAVY INDUSTRIES
08.2011 - 08.2016
- Implemented Tableau, Power BI (Desktop), Excel Power BI for quick dash boarding and in sighting for PEM and Planning related to Project and activities data.
- Forecasting availability of Man-hour based on different scenarios.
- Developing Applications for Finance, HR for recruitment process as well as for different Engineering Departments for their calculation and Reporting process.
- Manage entire organizations HR reports for monthly manpower analysis, attrition and Variance.
- Actively involved in salary survey dashboard for to industry i.e. find the mean across different dimensions and eliminating the outliners.
- Handling a small team meant for the same purpose.
- Financial Calculations & Dashboards like OT expanse, Project Costing, Travel Deputation.
- Built Reports and Input Templates in support of Finance, Accounting Operations (SQL, DAX, VBA and Plain old Excel formulas\functions).
- Worked with finance team to monitor Asset Management system.
- Manage & Analyze the Organization’s Transport Management System (TMS) using Sql Server & Excel & Power BI Dashboard.
MIS Executive
HCL Technologies Ltd
09.2006 - 08.2011
- Major part of entire project done by me included Requirement gathering, Code, Report Generation and training the operation team about the product.
- This application was transferring data from Symposium Database (Sybase) to SQL Server and providing Reports which was generating interval wise data operation Majors like Service Level, AHT, Calls, Offered Handled etc.
- Moreover, it was stating associate wise Performance details. Almost entire Voice Operation was dependent on the application.
- It Generated several automated MIS reports which helped in the analytical process.
- Coordinated with SL desk team & WFM team for the smooth functioning of Voice Operation so that the Real Time reports could be generated and analyzed.
- Developed VBA application for Overtime Calculation of employees working in the Phoenix Calling Process.
Education
Bsc /Msc -
Skills
- Reporting governance
- Dashboard
- Business intelligence
- analytics
- Agentic implementation
- Technical solutions
- Self-serving BI
- Analytic techniques
- Cross-functional collaboration
- Consumer insights
- Estimation
- Project planning
- Cost-benefit analysis
- Stakeholder management
- Best BI practices
- Data quality
- Data integrity
- Data reliability
- Power Platform
- Power BI
- Tableau
- Text Mining
- Sentiment Analysis
- Excel
- VBA
- R
- Python
- Azure
- Ms Fabric
- Conversational Analytics
- Looker Studio
- DAX
- M-language
- Power App
- Power Automate
- Tableau Prep
- Sigma Bi
- Qlik
- Power BI, MCP Server
- Agents in Azure Foundry
- Co-pilot implementation
- VBA M-Lang
- t-sql
- SQL Server
- SSAS tabular
- Azure Analysis Services
- Azure Databricks
- Azure SQL
- Amazon Web Services
- Snowflake
- Ms Fabric, one lake
- Sap BW
- sap hana
- SSIS
- Power Query
- Data flow
- Ms Fabric Data Factory
- Crystal report
- SSRS
- QlikView
- Spotfire
- Data visualization
- Cloud architecture
- DevOps practices
Academic Qualification
Bsc /Msc
Domain
- Insurance
- BPO/KPO
- OIL & GAS
- Telecom
- Contact Centre
- Finance
- HR
- Health Care
Core Competencies
Ms Fabric, Power BI Desktop, DAX, M-language, Power App, Power Automate, Tableau, Tableau Prep, Sigma Bi, Looker Studio, Qlik, Power BI MCP Server, Agents in Azure Foundry, Co-pilot Implementation, VBA M-Lang (Power Query), DAX (Power Pivot), T-SQL, R (Programming), Python, SQL Server, SSAS Tabular, Azure Analysis Services, Azure Data bricks, Azure SQL, Amazon Web Service (Redshift, Athena), Snowflake, Ms Fabric One lake, SAP BW, SAP HANA, SSIS, Power Query, Tableau Prep, Python Script, Data Flow, MsFabric Data Factory, Crystal Report (Business Objects), SSRS, Power BI, QlikView, Tableau, Spotfire, Python, Sigma Bi, Looker Studio
Timeline
Senior Tech Architect
Citiustech
09.2024 - Current
Senior Tech Architect
Indium Software
12.2023 - 08.2024
Senior Tech Architect
iLink Digital
02.2023 - 12.2023
Power BI Architect
IPacesetters LLC
04.2019 - 02.2023
Manager Reporting & Analytics
Sun Life Financial
04.2018 - 04.2019
Manager
Cognizant
08.2016 - 04.2018
Sr Executive (M2G3)
SAMSUNG HEAVY INDUSTRIES
08.2011 - 08.2016
MIS Executive
HCL Technologies Ltd
09.2006 - 08.2011