Tousif Imran

Senior Developer and Data Automation Specialist with 11 years of experience in designing, developing, and supporting enterprise-grade applications using VBA, SQL, MS Access, Excel, APIs, and reporting platforms. Proven expertise in process automation, data integration, dashboard development, and system modernization across insurance, utilities, finance, healthcare, and legal domains.

Experience in API calls using Payload response/ Parsing JSON & SOAP and migrated APIC to APIM credentials.

Experience in creating Dashboards & UserForm in Excel/MS Access. Expertise in Data Remediation, Root Cause Analysis and performs corrective action and processes the problems. Create, maintain and provide production support to MS Access Databases and Excel Tools using VBA extensively. Automate, modify, and optimize Reports in Excel & MS Access.

Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel & Access 2007 / 2010/ 2013/2016/2021 & Office 365.

Experience in developing Macros, advanced Excel and its features like Pivot Tables, Charts, Function, V-Lookup, X-Lookup etc. and transform a flat file/report to a PDF through VBA.

Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.

Experience in SQL statements & stored procedures using SQL server.

Experience in extracting, transforming and exporting data between different RDBMS using SSIS. Used MS Excel/Access VBA & SQL to send system generated e-mails.

Experience in generating reports using MS Access & SSRS. Good experience in the implementation of all phases of SDLC from requirements gathering through implementation. Excellent team co-ordinational, organizational and interpersonal skills with result-oriented approach.

Sr. IT Systems Analyst - National Grid - Syracuse, NY

(2025-11)

• Enhanced the Sagebook Estimate tool to improve overall performance and resolved complex technical issues through targeted troubleshooting.
• Assisted in the development of the CLCPA dashboard using Python. Extracting data from various sources and creating data pipelines to facilitate dataset uploads into Snowflake.
• Successfully migrated the Underground Cable Database to SharePoint.
• Modernized the system by standardizing tables and optimizing the queries, forms, creating indexes, and establishing formal relationships.
• Integrated a search form using VBA and SQL queries, allowing users to open associated forms directly from selected records.
• Rationalized & Optimized several data entry forms to provide more efficient and user-friendly interface.
• Automate the manual processes through VBA and creating complex queries.
• Remodel the CIAC report with additional Contingency within the tool.

Sr. Developer - Everest Insurance - Warren, NJ

(2022-07 - 2025-11)

• Designed and enhanced large-scale Excel VBA rating and underwriting tools used enterprise-wide.
• Built ACO Bordereau automation using Excel VBA with ADO to integrate SQL Server and Access databases.
• Developed Workers' Compensation tools leveraging XML imports, data validation, conditional formatting, and automated PDF generation.
• Integrated REST APIs (JSON payloads) to automate forms through third-party system interactions.
• Rebranded the EEP & CEEP rater with tons of enhancements including the PDF generation through bookmarking the MS Word template and populating the data directly from the EEP & CEEP rater.
• Implemented APIC call to the Tax tool to generate taxes and surcharges for the different States, Municipalities and Counties automatically into dozens of raters based on the premium, effective date and the company name. Led APIC → APIM migration, updating VBA logic, endpoints, and security credentials.
• Assisted with the Data governance process to ensure integrity of the data.
• Enhance the Energy rater with numerous rebranding updates and automate the NAICS/SIC updates through Escape mapping.
• Integrate the Wrap functionality & other updates to the Wholesale Causality rater by modifying the xml mapping using VBA scripts.
• Added numerous forms to the Excess Casualty rater based on the criteria selection and implemented several updates per the Actuarial team.
• Enhanced multiple raters using VBA logic, Data mapping & complex formulas.
• Produced detailed technical and user documentation and supported Agile methodology (Scrum / bi-weekly Sprint - backlog refinement).

IT Systems Analyst - National Grid - Syracuse, NY

(2022-02 - 2022-07)

• Architected a secure MS Access & VBA application to manage Interconnection projects.
• Developed dashboards, advanced queries, and automated reports using VBA and SQL.
• Built Excel-based cost estimation and summary tools with dynamic forms and PDF outputs and used by 50+ users.
• Provided security of the Database by providing User login with user authentication. Created Tables, Relate tables, Queries, Forms and Reports in MS Access from scratch.
• Scrubbed and cleaned the raw data and standardized the complex database.
• Created tables, assign indexed and create relationship between the tables and developed compound queries, forms and reports.
• Extensively used VBA logic and SQL Queries to fetch and populate the data with the Statistic Charts.
• Developed complex reports based on user selection from the Data Grid – Sub-form.
• Developed the Matting Calculator & CIAC report within the tool.
• Produced detailed technical and user documentation/ Job Aid for the future new users.

VBA Developer - Venable LLP - Washington, D.C.

(2021-10 - 2022-02)

• Developed Excel-based automation tools for HR, Benefits, and Wellness teams using VBA, PivotTables, and SQL.
• Built automated data pipelines from SQL Server to Excel and Access for analytics and reporting.
• Created reusable VBA modules to support scalable & maintainable workbook automation.
• Developed Excel based application to move / format data between sheets based on selection criteria using the Excel Object Model, VBA, Events & Combo boxes for HR Department.
• Designed automated reporting tools querying other data sources utilizing VBA & SQL for the Benefit and Wellness Team.
• Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.
• Supported full SDLC: requirements, development, testing, deployment, and documentation.

VBA Developer/Data Analytics & Reporting - Spectrum (Charter Comms.) - Stamford, CT

(2020-10 - 2021-06)

• Enhanced the automated reporting solutions using VBA, SQL Server, Python, and Tableau.
• Built executive dashboards comparing sales, incentives, and performance metrics.
• Normalized databases created data dictionaries, and optimized reporting workflows.
• Designed automated Reporting tools querying SQL database and other data sources utilizing VBA & SQL.
• Designed Dashboards & Models to compare Weekly/Monthly Sales & Incentives programs in Excel.
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing dashboards.
• Developed dashboards and visualizations on Tableau that empower decision makers.
• Supported data integrity and troubleshooting for enterprise dashboards and reports

Sr. Data Analyst - Danone - White Plains, NY

(2016-03 - 2020-07)

• Delivered large-scale financial and operational KPI dashboards supporting 12 factories and 150+ KPIs.
• Automated YTD, YTG, forecasting, and variance analysis using advanced Excel and VBA.
• Integrated multi-source data via SSIS, improving data lineage and quality.
• Built executive-level visualizations, including waterfall and trend analysis charts.
• Developed several Data Entry files for the users with automatic Links Update, Year to Date, Year to Go, 3 Month to Date & Full Year Calculations for a given dynamic time.
• Developed the tool with KPIs comparison between Actual vs Budget, Actual vs Prior Year, Budget vs Prior Year as well as GPS/RF.
• Designed & Developed the NORAM Dashboards to Compare around 150 KPIs for 12 Factories.
• Created Data Flow Diagram and documented the current data flow data elements.
• Linked data lineage to data quality and performed data remediation by organizing, cleaning and sorting the valuable data.
• Created functionality to calculate Cost related KPIs and display the numbers in Euro Currency for the Consolidated Files consisting of different local currencies.
• Developed automated Waterfall Charts to display Productivity variances.