PRASHANT SRIVASTAVA

Project: School ERP & Government Data Systems

• Designed and optimized ETL pipelines to process large volumes of student and government records, ensuring faster and more reliable data flow.
• Streamlined database schema and queries to improve reporting efficiency and reduce query response time.
• Collaborated with the team on Extract, Transform, Load (ETL) tasks, validating data accuracy and monitoring pipeline performance for stability.
• Enhanced data quality by implementing robust data cleaning, validation, and transformation processes before loading into reporting systems.
• Automated repetitive manual tasks with Python scripts, improving team productivity and reducing human errors.
• Delivered customized data reports and dashboards for schools and government stakeholders, enabling better decision-making.

• Compiled and cleaned large datasets from multiple sources for policy analysis & reporting.
• Contributed to 23 committee reports with 300+ recommendations on Public Undertakings.
• Built ETL workflows & dashboards (Excel/Power BI) to support MPs and decision-makers.
• Led CSR project, analyzing data of 81K+ students across 750 schools to identify beneficiaries.

• Analyzed large-scale engagement & campaign datasets from social media and government welfare schemes.
• Built dashboards (Excel) to track scheme adoption and campaign performance.
• Ensured data validation & transformation, improving accuracy of welfare and communication reports.
• Supported digital platforms by combining social media insights with citizen scheme data for decision-making.

• Spearheaded the development of the official website for the Minister of Labour & Employment using WordPress, integrating data-driven content modules.
• Designed and implemented the technical framework for Santusht Cell to manage employee queries and welfare data under ESIC & EPFO.
• Built dashboards for monitoring welfare schemes and COVID-19 relief initiatives.
• Formulated data-backed strategies for digital campaigns during the 19th Lok Sabha elections.

Project: HRM (Heart Rate Monitor) with IoT Implementation

• Developed an IoT-based HRM system integrating MongoDB and Python for real-time data storage and processing.
• Designed data models and reporting structures to manage employee and organizational data.
• Facilitated efficient data storage, validation, and management across business units.
• Contributed to the ERP module by implementing data flows and business hierarchies using the Tryton framework.