Pragnesh M. Mistri

IT professional with 13 years of expertise in data management, software development, and Crystal Reports development. Strong background in database technologies with 2 years of experience in Oracle PL/SQL and 2 years in AngularJS, MS SQL Server 2019, ASP.NET 2019, and JavaScript. 10+ years of experience in data analysis and management, specializing in the public health sector. Certified in Oracle DBA 9i Track from SQL Star International, Mumbai.

Currently working on Product-based Diamtrade Diamond ERP, managing sales and purchase modules for the diamond and jewelry industry.

Senior SQL Developer & Crystal Report Developer - Shaural InfoTech Pvt. Ltd.

(2024-08)

DiamTrade ERP is a fully customizable diamond and jewellery inventory management software. It offers stock tracking, MIS reporting, customer management, financial tracking, and multi-company data control with robust user roles and permissions. Reports can be customized and scheduled as per business needs.

• Developed stored procedures and views for Diamtrade ERP, managing purchases, sales, trade transactions, invoices, jewellery catalogue, and barcode/QR code reports.
• Designed and implemented Crystal Reports based on client specifications.
• Created SQL procedures for monthly and daily payable/receivable reports.
• Provided daily CRM support, ensuring timely resolution of ticketed tasks.
• Monitored data log files daily to analyse transaction flow and system performance.

Senior Executive (Grade E1) - Ram Ratna Wires Ltd. (RR GLOBAL)

(2023-01 - 2024-08)

Inventory Management System is a centralized solution for tracking IT assets, including hardware allocation, maintenance, and usage history. It ensures efficient inventory control, automated reports, and seamless asset monitoring for better resource management.

Corporate

Munim (CM) ERP is a configurable and dynamic enterprise solution for managing master and transaction data with utilities like field manager, dynamic menus, event creation, and form replication. It offers advanced search and catalog features for efficient data retrieval and management.

• Developed new replica forms in the ERP system and managed user rights.
• Developed and managed ERP forms, user rights, and sales/production targets.
• Designed and modified Crystal Reports as per business needs.
• Created an Inventory Management System for IT assets.
• Optimized SQL procedures for improved performance.
• Built inventory, requisition, and reel allocation systems with automated PDF/Excel generation.
• Generated monthly, quarterly, and yearly reports using SQL queries.
• Provided technical support for database-related issues.

Data Manager - Integrated Disease Surveillance Program

(2013 - 2023)

IDSP Software is an IT-enabled disease surveillance system designed to monitor disease trends and detect outbreaks early. It integrates data collection, analysis, and response coordination through surveillance units at the Center, State, and District levels. The system uses weekly reports on suspected, presumptive, and confirmed cases to track epidemics and enable rapid response teams (RRTs) to control outbreaks efficiently.

• Collected and organized disease surveillance data from Vadodara's health units.
• Prepared and submitted weekly, monthly, quarterly, and annual disease analysis reports to state-level management.
• Monitored disease trends and alerted management about potential outbreaks.
• Provided end-user training to health department staff and medical college doctors on new software releases.
• Maintained IT hardware and network systems for seamless data management.
• Planned and conducted ground-level disease trend analysis during outbreaks.
• Assisted the health department as a consultant for new state government portal launches.
• Performed quarterly and annual data backups for secure record-keeping.

Software Developer - Health India TPA Pvt. Ltd.

(2011 - 2012)

Claims Investigation Management System is a dedicated software platform for processing and verifying insurance claims at Health India TPA. It enables digital claim submissions, automated data verification, fraud detection, claims review, and real-time communication with hospitals and policyholders. The system also provides reporting and analytics for tracking claim trends and improving efficiency.

• Developed stored procedures for the Claim Investigation Program and optimized SQL queries based on user and management requirements.
• Migrated the Oracle database to SQL Server using SQL Manager and SQL Everywhere.
• Designed and modified Crystal Reports as per user needs.
• Created technical documentation for the Claim Investigation System.
• Provided database support and ensured data accuracy for claim processing.

Software Programmer - BIZOS Software Ltd.

(2008 - 2009)

• Gathered client requirements for the ERP system and documented specifications.
• Analysed the ERP database structure and understood its relationships.
• Developed and customized Crystal Reports as per user needs.

Master of Computer Application - Computer Application - Anand Institute of Information Science, Sardar Patel University (2008-04)