Data Analyst - POwer Query, Power Pivot, VBA

IMRAN ISSHACK

Address: Jamaica, NY, ***** Email: *.***********@*****.***

LinkedIn: https://www.linkedin.com/in/imran-isshack-690935162/ Mobile: 347-***-****

SUMMARY:

Adaptable Data Analyst seeking an opportunity to leverage my strong skills and experiences in Data Analysis using Microsoft Excel. Advanced proficiency in all aspects of Excel, including Excel Automation, Pivot Tables, VBA, Power Pivot, and Power Query to analyze data and provide business insights. Analytical mindset, problem-solver with keen attention to customer needs and details. Additional training and practical experience in accounting.

KEY ACCOMPLISHMENTS

Designed and implemented multiple MS Excel VBA models that reduced manual processes time significantly

Developed MS Excel Power Query model to automate data cleaning, transformation, and data manipulation

Implemented key Accounting Internal Controls to prevent pilferage, fraud, and manipulation for personal gains

PROFESSIONAL EXPERIENCE

DO & CO New York Catering New York, NY

Data (Costing Analyst) August 2024- current

Proficient in leveraging advanced AI tools (Open Ai-ChatGPT, Google Gemini) to accelerate development of DAX measures, Power Pivot models, Excel VBA automation, and Power Query transformations—enhancing efficiency, accuracy, and reporting speed

Cleaned and transformed unstructured datasets using Power Query, ensuring accuracy and consistency for reporting.

Built interactive dashboards, charts, and dynamic reports in Excel using Power Query and advanced visualization techniques.

Developed data models with multiple data sources in Power Pivot, including creating relationships and data mappings.

Wrote and optimized DAX measures to deliver accurate calculations and business insights.

Automated repetitive data-cleaning and consolidation processes using VBA, significantly improving efficiency.

Performed data reconciliation of remittance and invoice files, identifying balances, payments, voids, and pending statuses.

Provided Excel expertise and troubleshooting support to teammates, improving overall team productivity

Developed and applied advanced, dynamic nested lookup formulas in Excel to streamline data retrieval and improve accuracy in complex datasets – XLOOKUP, FILTER, UNIQUE, TEXTSPLIT, CHOOSECOLS, CHOOSEROWS

Labaton Sucharow LLP New York, NY

Data / Billing Analyst -Contract November -December 2023/2024

Updated model created last year with new data.

Reviewed, cleaned and validated data entered manually from Case files

Designed data validation model to capture duplicated data line items and flagged them for deletion

Resolved formula issues and errors

Validated formula results with dynamic Pivot tables(DAX) models

Presented completed report to management

Consolidated Edison of NY New York, NY

Data Analyst -Contract May 2023 – October 2023

Pulled data using MS SQL Studio

Used complex MS Excel formulas, such as the Multiple Switch (AND/OR) nested function, Nested Xlookup, Nested IF(Vlookup) with COLUMNS to determine whether several conditions are true before returning the results

Utilized MS Excel Power Query to perform daily, automatic data cleansing of .csv files

Developed pivot tables for data analysis

Created reports with Power BI: Decision Tree, tables, and for weekly meetings

Profield Software administrator (ticketing system) – granted access, reset password, and reactivate accounts.

Consulted the Workday employee directory to find the managers and supervisors of the staff members; this reflected the Profield structure.

Designed MS Excel data model for billing schedule

Routed jobs to different Boroughs team teams for Meter installation

Assigned jobs to MIIG Team analysts

Labaton Sucharow LLP New York, NY

Data / Billing Analyst -Contract October 2022 – November 2022

Utilized MS Excel Advanced and Statistical Functions to help analyze Labaton Billing rates, as compared to the market

Used Pivot Table, Power Query, Filter, Unique, TRIM & Clean, as well as Statistical Functions: MINIFS, MAXIFS, PERCENTILE (IF, PERCENTRANK functions to evaluate the data

Designed a MS Excel model to flag leading and trailing spaces in source data, created VBA to resolve these issues

Transitioned a static MS Excel model (fixed range references) to a dynamic and automated models with array functions: FILTER, UNIQUE, SORT etc.

Validated formula results with dynamic Pivot tables models

National Grid LLC New York, NY (remote)

Technology Business Management Analyst (TBMA) -Contract April 2022 – May 2022

Updated data tables with new data source – mapping and vendors files in Apptio

Identified cost dropouts (Cost not allocating), then updated related tables in Apptio

Loaded vendor’s new invoices into Apptio

Configured new reports and exported data from Apptio

Created vendor data files in MS Excel, then loaded them into Apptio

IBM (The Weather Channel – Programmatic Team) New York, NY (remote)

Programmatic Analyst - Contract June 2021 – March 2022

Reports Automation - Manipulated data with MS Excel VBA & Excel Power Query to automate multiple reports

Updated Power Bi Reports- displays KPIs used by the Programmatic Team

Pulled Google Ad Manager Daily Reports > updated MS Excel Template > Updated Power BI Model

Ran daily Amplitude, Teads, Connatix UI > Updated Excel Model and Power Bi with the data

Processed(daily) large data files with over 2M rows (per dataset) of data as Notepad++ data format

Created dynamic data models in MS Excel Power Query and Power Bi

Monitored Ads performance Metrics: CPM, Fill Rate, Daily Revenue, etc

Created MS Excel Pivot Table models

FedEx (Ground) – Courier Service Pittsburg, Pennsylvania (Remote)

Compensation Support - Contract January 2021 – June 2021

Utilized MS Excel VBA & Excel Power Pivot to automate Score Card Weekly reports.

Sped up slow, large MS Excel files that had slow, long nested Lookup formulas

Updated weekly MS Excel Surge Files based on various Sorts: ALL, AM, PM, Weekend.

Created MS Excel tools to update Rate Overview Files & Surge Files

Used advanced MS Excel nested IF(AND/OR), DATEDIF, and DATE VALUE Functions to calculate retro pays

Data migration from Rate File to Surge File

Automated Customized data reports from Workday using MS Excel Power Query tools

Automated manual weekly Mail Merge process with MS Excel VBA, saving approximately 4 hours per week

Power Query Training for co-workers

Institute of International Education 809 United Nation Plaza, New York

Data Operations Analyst -Within IT Business Dept – Contract December 2019 – April 2020

Extracted data from CRM and PeopleSoft and compared using MS Excel VLOOKUP and Pivot Tables

Utilized MS Excel advanced function (VLOOKUP, COUNTIFS & Pivot Tables) to identify duplicate records for deletion

Resolved tickets in Participants Systems- processed email and insurance updates

Checked daily reports in CRM to ensure that data are integrating correctly and that queues are not stuck

Checked daily reports and nudge records to ensure proper integration

Deleted duplicate accounts in CRM

Ensured that Students, Vendors, and Institutions' accounts from CRM are integrating into PeopleSoft correctly

Guardian Life Insurance 10 Hudson Yards, New York NY 10001

Data Analyst -Within IT Security - Contract March 2019 – October 2019

Used MS Excel VBA to speed up manual processes – sent emails to multiple MS Outlook users with privileged access MS Excel data with the click of a button. This task typically took a few days when done manually

Used advanced MS Excel tools – MS Power Query to clean, manipulate and generate reports from .txt files.

Dynamically separated large MS Excel data sets by users or access type and saved to individually named files, with MS Excel VBA(Macros)

Reduced user entitlements in RACF (Old Server) by 35% - exceeded the target of 25%

Utilized MS Excel tools such as Pivot Tables, Vlookup, Index & Match to compare Data Tables in RACF vs Mainframe

Aided in the implementation of new privileged access roles on the Windows and Mainframe Platforms

Evaluated current users' privileged access via MS Excel Entitlement Reports

Mapped current access to new privileged roles to allow for migration to new roles

Drive migration to new privileged access roles through communication to privileged users and their managers

To email managers regarding access, a master list of employees and their managers was extracted from Workday reports

Reported periodically to project stakeholders regarding the status of projects

Created Tickets in Service Now Ticketing System to add or remove users or users’ access.

Univision Communications Inc 419 Lafayette Street, New York 10003

Digital Yield Analyst - Contract July 2018 – November 2018

Implemented VBA to assist with automation and to create efficiency in the processes. This initiative reduced each task by approximately 2 hours and reduced human error to zero.

Created Models using MS Excel Pivot Tables, Sumifs, Index Match, Vlookup

Updated all existing MS Excel Models to make them dynamic using MS Excel Name Ranges and Offset Functions

Upgraded MS Excel lookup formulas to improve the calculation speed of large files

Prepared and circulated daily error reports for active digital orders with high error rates

Digital Audio Reporting – Owner of all digital audio reporting and review for the Digital Revenue Operations team

Prepared weekly revenue at risk reporting for audio – circulated inactive/missing creatives at risk

Created and circulated Video Analysis Report – tracks overall digital video ad performance metrics daily and flagged items with potential issues to the Ad Ops team

Weekly Revenue at Risk – Prepared weekly revenue at risk that flagged orders that are at risk of not delivering to the goals as contracted in the sales order. Circulated to Media Strategists team for confirmation – followed up with the team about why the lines are at risk and discussed how to mitigate these risk

Ad Hoc projects as assigned by Executive Director and Senior Analyst

Software: Advance MS Excel, Google Ad Manager, Google Docs, WideOrbit Traffic, WideOrbit Streaming, FreeWheel, AdJuster

Rabin Martin (Subsidiary of Omnicom Group-Fortune 500 Listed) West 40th Street, New York, NY

Staff Accountant - Fulltime June 2016 – March 2018

Designed MS Excel VBA to extract, compile, track and analyze data to generate reports used to bill clients.

Created MS Excel search engines and models for project consultants

Working Capital – prepared and submitted weekly MS Excel working capital schedule using PIVOT TABLES, VLOOKUP, SUMIFS, SUMPRODUCT, INDEX/MATCH

Resolved data discrepancies issues in Intacct Sage (Accounting Software) modules using MS Excel

Programmed MS Excel Advanced Tool – Excel Solver – an identified combination of invoices that makes up a deposit

Revenue Projections - Maintained Sales Tracker and Sales Pipeline (Dashboard) MS Excel models - tracks variances

Prepared monthly Staff Capacity Forecast and Staff Historical Utilization Reports using MS Excel Lookup Functions

Assisted with month-end close procedures, preparation of financial reports including Balance Sheets, Income Statements

Performed monthly reconciliation for both Balance Sheet and P&L accounts

Managed Accounts payable and accounts receivable (including billing)- the entire cycle

Assisted with the preparation of monthly budgets and uploading the template to the Oracle ERP system

Reconciled: Bank, credit card, payroll, petty cash, general ledger, balance sheet, vendors, customers, and revenue reconciliations

Supported monthly, quarterly, and year closing on time

Ad hoc financial analysis

Software: Advanced MS Excel, Intacct Sage, EP -HFM Oracle

Parts Authority – Auto Parts Dealer- 83 Branches Nation Wide Rockville Centre, Long Island, NY

Pricing Department (Purchasing/Pricing Analyst) - Fulltime July 2014 – November 2015

Supported the Data Department - working with very large data sets in MS Excel – typically millions of rows of data to update the database using Excel’s Pivot tables and Power Pivot

Analyzed Sales with Pivot Tables as per product lines/vendor – recommended selling price changes

Retrieved ProntoNet (Vendor’ Database) files daily – compared to the database (DST) via MS Excel’s VLOOKUP to ensure prices are accurate

• Utilized MS Excel tools (pivot tables and macros) to evaluate and implement changes to the DST database when suppliers report cost changes. Communicated implications of those changes to the purchasing department and stock managers to ensure no loss of margin

• Worked with data received from vendors in different file formats’ – Txt, CSV, and Microsoft Access manipulated data and loaded it into the database

• Excel Programming - designed MS Excel Macros/VBA for the accounts payable department to facilitate vendors’ reconciliation reports. This saves the company 40 minutes per report multiplied by fifteen staff

• Performed market research to understand competitors’ pricing and maintained records of price trends

Compared Vendors’ soft copies of packing slips to items scanned into a database using Vlookup, to ensure that all items ordered were received and were of the right specifications, quantity, and quality

Software: Advance MS Excel, DST

EDUCATION

Baruch CUNY College, New York NY 10010 Expected: May 2024

Degree: BBA, Data Analytics

Association of Chartered Certified Accountants Technician’s Course (CAT)

(Degree: Accounting)

London Chamber of Commerce (LCC) Certificate: Audit and Economics

Udemy Courses

Microsoft Excel: Business Intelligence with Power Query & DAX

Microsoft Power BI Desktop for Business Intelligence - in Progress

Microsoft Power BI With Augmented Analytics & Auto Machine Learning (ML) – In Progress

BUSINESS PROFICIENCY

Microsoft Office (Advance Excel – Pivot Tables & Pivot Charts, Power Pivot, Power Query, Macros/VBA, VLOOKUP, Index & Match, Solver, Offset Functions). Basic MS Access, Power BI - Intermediate

QuickBooks, Intacct

Contact this candidate