Ankit Dwivedi Email & Phone Number

Noida, Up, In

Noida, Uttar Pradesh, India

Key Projects: 1. Contract BOT: Developed and delivered LLM based chatbots (RAG) for pre and post sales teams to query from around 2000+ contracts (image pdf) which saved 90% of the user’s time by providing direct answers through slack bot. Similar Projects such as Email Summarization, Sentiment Analysis for adobe’s customer views and JIRA Ticket Answering Tool were also implemented parallelly. Handled this project End to End including the product management part.2. Automation of Reports: Automated 300+ monthly usage reports and reduced effort by 80% and ensured on time delivery. Using Power pivots, Power Query, Python, VBA and Excel.3. Customized Dashboards and Reports: Developed customized dashboards for leadership and CSMs, offering actionable insights on financials, contracts, product adoption, and consumption trends for digital experience products including the forecast to alert in advance.4. Customer Usage Insight using Azure Data Factory and Databricks: Data from SAP is ingested and transformed via Azure Data Factory, while Databricks enables advanced analytics to deliver real-time customer insights. These insights drive informed decisions, enhance engagement, and optimize offerings, supported by a scalable and high-performance cloud architecture.Tools and Skills Used: Digital Marketing (B2B), Azure AI Studio (Cognitive Search, Form Recognizer, Blob, Chat GPT4o, Data Factory, Azure Databricks), Python, GitHub, Power BI, Power Query, SQL Server, VBA, Advanced Excel, Prompt Engineering, JIRA, Agile Methodology, Product Management, Prototyping, Stakeholder Discussions, Project Monitoring, Adobe DX/Figma, Redis

New Delhi, Delhi, India

Project: Led state-level implementation of the National Urban Digital Mission (NUDM) to enable online municipal services for Urban Local Bodies (ULBs) in MP, CG, and MH as a central government representative to drive API-based integration of state municipal services' MIS data into AWS cloud for real-time national dashboard visualization. Responsibilities: Briefing stakeholders on platform architecture, conducting ETL and gap analyses using Power BI, reviewing technical documents (BSD, FSD, SRS), creating wireframes and test cases, and overseeing module development, API integrations, and UAT processes using Agile methodologies.Tools and Skills Used: Stakeholder Management, Agile Methodology, Power BI, Advanced Excel, SQL Server, Gap Analysis, AWS, Python, GitHub, Data Visualization, Figma (Prototyping), Data Warehousing

Mumbai, Maharashtra, India

Project Co-ordination, Client Management, Primary and Secondary Survey data analysis, Census data analysis and Forecasting, Data visualization in Power BI and Arc GIS, Report Compilation and Presentation, NPV/IRR. EDA and Predictive Analysis for Traffic, Population and City level data stored in SQL DB using Python(Pandas and Matplotlib), Data Modelling, Data Warehousing

Hyderabad, Telangana, India

EDA and Predictive Analysis for Traffic, Population and City level data stored in SQL DB using Python(Pandas and Matplotlib) and Tableau/Power BI (ETL and Visualization). GIS for spatial data analysis.

Bareilly Area, India

Worked on “Smart City Proposals” for Bareilly under Smart City Mission Key Learning: . Data Compilation and Presentation, Costing and Financial Analysis

Pune Area, India

Business Analytics/Data Science

Machine Learning Models and Algorithms for Supervised and Unsupervised learning such as Classification, Regression and Clustering.

Masters In Planning, 8.4/10

B.Tech, 7.2/10

Higher Secondary Education, Physics,Chemistry,Mathematics,English,C++

High School, Science,English,Hindi