profile-pic

Hemnath K

11+years of experience in Account Receivable and Mortgage FLOD testing in 444 Financial Industries. Proficient in both Manual and Automation Testing with ability to manage the automation of the entire testing cycles and leading the testing team. Design & Developed Macro Tools to reduce manual works. Last 2+years of experience in python, macro, PDD, SSIS, SSAS, SSRS and Power BI. Experience inbuild out activities, Procedure enhancements and Rebuttal process. Discussed with Line of Business to enhanced the Standard Operating Procedure for our testing process to make the process in better way. +3900h saved on a monthly basis by implementing VBA automation tools. Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc. Excellent Knowledge in Database testing and SQL. Excellent communication, problem solving skills, coordination, documentation, project planning and interpersonal skills.
  • Role

    VBA Developer (Operations MI Analyst)

  • Years of Experience

    12 years

Skillsets

  • PowerBI - 4 Years
  • Data Visualization - 2 Years
  • SQL - 6.0 Years
  • Python - 4.0 Years

Professional Summary

12Years
  • May, 2023 - Present2 yr 6 months

    Operations MI Analyst

    EQUINITI INDIA Private Ltd.
  • Apr, 2019 - May, 20234 yr 1 month

    Analyst II (VBA Developer)

    Mr. Cooper Private Ltd.
  • Jul, 2015 - Jan, 20193 yr 6 months

    Senior Client Partner

    Access Healthcare Service
  • May, 2014 - May, 20151 yr

    Senior Customer Executive

    Dell International Service

Applications & Tools Known

  • icon-tool

    SSIS

  • icon-tool

    SSRS

  • icon-tool

    ETL

  • icon-tool

    Microsoft Power BI

  • icon-tool

    Azure DevOps

  • icon-tool

    VBA Excel

Work History

12Years

Operations MI Analyst

EQUINITI INDIA Private Ltd.
May, 2023 - Present2 yr 6 months
    Experience in developing, implementing, documenting, monitoring and maintaining the data ETL in the financial industry. Proficient in creating multiple kinds of data visualization dashboards.

Analyst II (VBA Developer)

Mr. Cooper Private Ltd.
Apr, 2019 - May, 20234 yr 1 month
    Audited and managed the Accounting and Reporting Team's monthly projections, ensuring adherence to Standard Operating Procedures (SOPs). Delivered contact center and back-office services like customer acquisition, account management, data processing, and collections.

Senior Client Partner

Access Healthcare Service
Jul, 2015 - Jan, 20193 yr 6 months
    Handled claim reconsiderations, ensuring required documents were attached for resolution. Collaborated with clinic admins and specialized teams to address and resolve claim-related issues.

Senior Customer Executive

Dell International Service
May, 2014 - May, 20151 yr
    Conducted backend testing using complex SQL queries to ensure data integrity and business logic implementation.

Achievements

  • Automated 40% of test IDs (out of 200+) for the FLOD process
  • Created a robust daily reconciliation macro to organize all transactions into respective bank transaction templates
  • Successfully built a production and non-production monitoring system using the Tkinter framework

Major Projects

3Projects

FLOD Automation

    Automated 40% of test IDs (out of 200+) for the FLOD process. Designed a macro to streamline the process by taking screenshots of reconciliation files and pasting them into the automation template corresponding to respective questions. The automation also incorporates functionalities from other macro tools, including File Retrieval, SharePoint Dump, Validation, Retrieve from SQL, and Bank Statement, ensuring a comprehensive and efficient workflow.

CRT Macro

    Created a robust daily reconciliation macro to organize all transactions into respective bank transaction templates. macro highlights relevant entries in blue and handles this complex task three times daily, showcasing reliability and adaptability under high-pressure conditions.

Python Project - IS Maintenance

    Successfully built a production and non-production monitoring system using the Tkinter framework. Enabled users to monitor their activities and generate detailed, interactive reports through Azure DevOps. Delivered a user-friendly and efficient solution tailored to streamline operational monitoring and reporting.

Education

  • MBA – Financial Management

    Tamil Nadu Annamalai University, Chennai, India

  • Bachelor of Engineering in EEE

    Anna University, Chennai, India

  • Diploma – Specialization EEE

    Panimalar Polytechnic College Nungambakkam, Chennai, India.