Having 3Years of professional IT experience in Visual Basic for Applications such as Excel, Advanced Excel, VBA Macros, MIS Analyst.
Preparing excellent documentation on business requirements.
Developing and delivering M…
Having 3Years of professional IT experience in Visual Basic for Applications such as Excel, Advanced Excel, VBA Macros, MIS Analyst.
Preparing excellent documentation on business requirements.
Developing and delivering MIS reports using Excel Macro’s for monthly, weekly and Daily reports to Management.
Strong knowledge on Excel Charts, Pivots, Slicers, Excel formulas, Dashboard views, Index Match, VLOOKUP, HLOOKUP, XLOOKUP, Offset, named ranges, data sorting and filtering.
Experienced in working with Pivot Tables, Graphs and Reports.
Creating basic level Dashboards and KPI’s with Tableau Data visualization tool.
Have work experience on Designing on New Dashboards and Changes in Existing Dashboards.
A professional, innovative, creative, and self-motivated team player who can guide/lead projects independently.
Developed report specifications based on user requirements.
• Monitoring the Applications vulnerabilities based on the Qualys & SSL Labs scan reports.
• Creating the tickets in JIRA Tool for applications with vulnerabilities.
• Contacting Application owners and System delegates regarding the JIRA tickets and finding the appropriate resolution to the tickets.
• Explaining the compensating controls to use the strong cipher suites and TLS protocols and closing open the tickets in JIRA Dashboard by attaching the information evidence that are collected from application owners and system delegates.
• Creating the daily, weekly and monthly reports for management level.
• Creating New Templates and update the Templates based on client requirements.
• Receiving and downloading data from different sources (SQL Server, Oracle) Cleaning and Formatting data using by EXCEL.
• Preparing the Data from multiple source SQL, MS Access By using Excel and VBA.
• Removing duplicate records from Data.
• Creating the small-scale Applications by Using VBA Automation to avoid the Manual Process.
• Interact with clients and gathering the requirement.
• Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.
• Updating Data and MIS Dashboard on daily and weekly basis.
• Create Small Scale Applications to automatically update Excel workbooks Using VBA.
• Expertise in MS Excel (Hookup, VLookup, XLookup look up, Pivot Table & PivotTable Chart, Charts, Macros and data validation & Scenarios)
• Testing and debugging the issues in Macros.
• Requirement Gathering Process and Documentation.
• And assisting my seniors on various activities like looking after connectivity issues and data analysis/inspection etc.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
Monitoring the applications vulnerabilities based on the Qualys & SSL Labs scan reports.
Creating tickets in JIRA Tool for applications with vulnerabilities.
Contacting application owners and system delegates regarding the JIRA tickets and finding the appropriate resolution to the tickets.
Explaining the compensating controls to use the strong cipher suites and TLS protocols and closing open the tickets in JIRA Dashboard by attaching the information evidence collected from application owners and system delegates.
Creating daily, weekly and monthly reports for management level.
Creating new templates and updating the templates based on client requirements.
Receiving and downloading data from different sources (SQL Server, Oracle).
Cleaning and formatting data using Excel.
Preparing data from multiple source SQL and MS Access by using Excel and VBA.
Removing duplicate records from data.
Creating small-scale applications by using VBA automation to avoid the manual process.
Interacting with clients and gathering requirements.
Handling multiple reports, working with formulae, pivot tables, pivot charts, and various other Excel sheet components for accurate data.
Updating data and MIS dashboard on daily and weekly basis.
Creating small-scale applications to automatically update Excel workbooks using VBA.
Testing and debugging issues in macros.
Requirement gathering process and documentation.
Assisting seniors on various activities like looking after connectivity issues and data analysis/inspection.
Extensively using Excel functions in development, focusing on read/write integration to databases.
Using SQL commands for interacting with relational databases including CREATE, ALTER, DROP, SELECT, INSERT, UPDATE, DELETE, and GRANT.
Using SQL constraints like NOT NULL, DEFAULT, UNIQUE, PRIMARY key, FOREIGN Key, CHECK, and JOINS.
Requirement gathering and preparing documentation on business requirements.
Developing and delivering MIS reports using Excel Macro’s for monthly, weekly and daily reports to Management.
Order management and resource management.
Receiving and downloading data from different sources (SQL Server).
Cleaning and formatting data using Excel.
Preparing reports with downloaded data from multiple source SQL and MS Access by using Excel and VBA.
Removing duplicate records from data.
Creating small-scale applications by using VBA automation to avoid the manual process.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
