Hi, I’m Diwakar Singh Negi. I’m a results-driven VBA Developer and BI/Automation Specialist with over a decade of hands-on experience building Excel/Access-based automation, data validation, and reporting solutions. I design end-to-end workflows that connect VBA, SQL Server, and web services to improve accuracy, transparency, and operational efficiency. I excel at modernizing legacy Access systems, migrating apps to .NET Core and web platforms, and delivering interactive dashboards with Power BI, SSRS, and Crystal Reports. I value collaboration with business stakeholders, ensure HIPAA and regulatory alignment, and strive for scalable, compliant tools that enable better decision making.

Diwakar Singh Negi

Hi, I’m Diwakar Singh Negi. I’m a results-driven VBA Developer and BI/Automation Specialist with over a decade of hands-on experience building Excel/Access-based automation, data validation, and reporting solutions. I design end-to-end workflows that connect VBA, SQL Server, and web services to improve accuracy, transparency, and operational efficiency. I excel at modernizing legacy Access systems, migrating apps to .NET Core and web platforms, and delivering interactive dashboards with Power BI, SSRS, and Crystal Reports. I value collaboration with business stakeholders, ensure HIPAA and regulatory alignment, and strive for scalable, compliant tools that enable better decision making.

Available to hire

Hi, I’m Diwakar Singh Negi. I’m a results-driven VBA Developer and BI/Automation Specialist with over a decade of hands-on experience building Excel/Access-based automation, data validation, and reporting solutions. I design end-to-end workflows that connect VBA, SQL Server, and web services to improve accuracy, transparency, and operational efficiency.

I excel at modernizing legacy Access systems, migrating apps to .NET Core and web platforms, and delivering interactive dashboards with Power BI, SSRS, and Crystal Reports. I value collaboration with business stakeholders, ensure HIPAA and regulatory alignment, and strive for scalable, compliant tools that enable better decision making.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert

Work Experience

Technical Consultant at Syscons Corporation – Stonewall Solutions & Cognizant (Merck: Millipore Sigma)
February 1, 2024 - Present
Redesigned and developed Microsoft Access applications with complex data transformation, validation, and reporting components. Built and maintained MS-Access and Excel automation solutions integrated with VBA, SQL Server, and APIs to streamline workflows and reduce manual effort. Created Excel-based reporting frameworks using pivot tables, Power Query, and advanced formulas for dynamic data analysis. Migrated legacy Access applications to modern .NET Core web platforms to improve scalability and security. Automated test management and QA reporting processes using Excel macros, Python, REST API, and VBA, improving efficiency and defect traceability. Implemented data import/transformation tooling for regulatory reporting and integrated with SQL Server, CSVs, and web services.
Software Development Specialist Advisor at NTT DATA – Point32Health (Harvard Pilgrim Healthcare)
February 1, 2024 - October 23, 2025
Designed and developed MS Access/Excel automation with VBA, SQL Server, and reporting modules to support financial, clinical, and operational analytics. Built Excel tools and dashboards to streamline reporting workflows. Re-engineered manual processes into automated, compliant solutions aligned with HIPAA and audit standards. Enhanced provider network and eligibility reporting with data validation and automated distribution. Delivered interactive dashboards and reports using Power BI, SSRS, Crystal Reports, and Excel-based tools. Collaborated with stakeholders to document requirements and re-engineer business processes for automation and modernization.
Software Development Advisor at Dell Services – Harvard Pilgrim Healthcare
March 1, 2016 - October 23, 2025
Managed HP ALM, Agile Manager, Performance Center, and HP PPM environments—installation, upgrades, patching, and performance tuning. Automated workflow processes with VBScript for test management and defect tracking, and built custom dashboards/reports in ALM. Developed PL/SQL scripts for backend validation and reporting automation, and automated requirement traceability matrices and test coverage reporting using ALM OTA API. Participated in requirements analysis, design reviews, and SDLC governance to ensure alignment with business goals.
Software Development Advisor at DELL Marketing LP – Harvard Pilgrim Healthcare
December 1, 2013 - October 23, 2025
Administered ALM/QC, Agile Manager, Performance Center, and UFT, including setup, maintenance, upgrades, migrations, user management, and customization of workflows. Designed and customized templates, workflows, and reports for requirements management, defect tracking, and reporting. Performed backend validation with PL/SQL and automated traceability and test coverage reporting. Contributed to requirement analysis, design reviews, and SDLC governance.
Computer Programmer Analyst at Perot Systems TSI (India) Limited
April 1, 2009 - October 23, 2025
Designed and developed scalable .NET-based applications using C#, ASP.NET, SQL Server, and SSRS. Built databases, stored procedures, and triggers to implement business logic, performed performance analysis and tuning of T-SQL, WCF, AJAX, and ADO.NET components. Implemented advanced T-SQL features and automated tasks to optimize ETL processes and reporting.
Software Engineer at Differential Technologies Ltd
October 1, 2005 - October 23, 2025
Designed and developed scalable .NET/C# applications with SQL Server and Crystal Reports, implementing business logic via stored procedures and triggers. Conducted performance analysis and optimization, and employed WCF/AJAX/AOD.NET techniques to enhance application reliability.
Software Engineer at Pioneer eServe Private Limited
February 1, 2005 - October 23, 2025
Designed and developed scalable applications using ASP, Visual Basic, SQL Server, and Crystal Reports, implementing business logic with stored procedures and triggers to support reporting needs.

Education

Master in Computer Application (MCA) at GIMT Institute of Management & Technology, Noida, India
January 11, 2030 - January 1, 2002

Qualifications

Add your qualifications or awards here.

Industry Experience

Healthcare, Professional Services, Software & Internet, Government, Education, Financial Services