Experience

CONSOLIDATED EDISON CO OF NEW YORK

• United States
• Non-profit Organizations
• 100 - 200 Employee

• Data Analyst

  • May 2023 - Present

  • Pulling data using MS SQL Studio • Using complex MS Excel formulas, such as the Multiple Switch (AND/OR) nested function, Nested IF(Vlookup) with COLUMNS to determine whether several conditions are true before returning the results • Using MS Excel Power Query to perform daily, automatic data cleansing of .csv files • Developing pivot tables for data analysis • Creating reports with Power Bi Decision Tree, tables, and for weekly meetings • Profield Software administrator – granting access, reset password and reactive accounts Show less



Labaton Sucharow LLP

• United States
• Law Practice
• 100 - 200 Employee

• Data / Billing Analyst -Contract

  • Oct 2022 - Nov 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. • Redesigned a static MS Excel model to make it dynamic and automated • Created Pivot tables as a means to validate the formula results • 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. • Redesigned a static MS Excel model to make it dynamic and automated • Created Pivot tables as a means to validate the formula results



National Grid

• United Kingdom
• Utilities
• 700 & Above Employee

• Technology Business Management Analyst (TBMA) -Contract

  • Apr 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 • 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 Watson Media

• Data Analyst

  • Jun 2021 - Mar 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 • Monitored Ads performance Metrics: CPM, Fill Rate, Daily Revenue etc • Created MS Excel Pivot Table models Show less



FedEx Ground

• United States
• Freight and Package Transportation
• 700 & Above Employee

• Compensation Support Representative

  • Jan 2021 - Jun 2021

  • Utilizing MS Excel VBA & Excel Power Pivot to automate Score Card Weekly reports. • Speeding up slow, large MS Excel files that had slow, long nested Lookup formulas • Updating weekly MS Excel Surge Files based on various Sorts: ALL, AM, PM, Weekend. • Utilize MS Excel tools to update Rate Overview Files & Surge Files • Use advanced MS Excel nested IF(AND/OR), DATEDIF, DATE VALUE Functions to calculate retro pays • Data migration from Rate File to Surge File • Automating Customized data reports from Workday using MS Excel Power Query tools • Automating manual weekly Mail Merge process with MS Excel VBA, saving approximately 4 hours per week • Power Query Training for co-workers Show less



Institute of International Education

• United States
• Non-profit Organization Management
• 500 - 600 Employee

• Data Operations Analyst

  • Dec 2019 - Apr 2020

  • Extract data from CRM and PeopleSoft and use MS Excel VLOOKUP against each other to ensure that modules/systems are “talking to each other” • Designing MS Excel Model to highlight Duplicates account in CRM • Utilizing MS Excel advanced function (VLOOKUP, COUNTIFS & Pivot Tables) to identify duplicate records for deletion • Extract MS Excel reports from CRM and run absent • Resolve tickets in Participant Systems- process email and insurance updates • Check daily reports in CRM to ensure that data are integrating correctly and that queues are not stuck • Checking daily report and nudge records to ensure proper integration • Deleting duplicate accounts in CRM • Ensure that Students, Vendors and Institutions accounts from CRM is integrating to PeopleSoft correctly Show less



Guardian Life

• United States
• Financial Services
• 700 & Above Employee

• Data Analyst

  • Mar 2019 - Oct 2019

  • Used MS Excel VBA to speed up manual processes – sent emails to multiple MS Outlook users with their individual 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 individual named files, with MS Excel VBA • Utilized MS Excel tools such as Pivot Tables, Vlookup, Index & Match to compared 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 • Reported periodically to project stakeholders regarding current status Show less



Univision Communications Inc.

• United States
• Telecommunications
• 1 - 100 Employee

• Digital Yield Analyst

  • Jul 2018 - Nov 2018

  • Prepared and circulated daily error reports for active digital order with high error rate • Digital Audio Reporting – Owner of all digital audio reporting and review for 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 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 why the lines are at risk and discussed how to mitigate these risk • Assisted with the creation of various reporting templates and models. Implemented VBA to assist with automation and to create efficiency in the processes • Ad Hoc projects as assigned by Executive Director and Senior Analyst • Software: Advance MS Excel, Google Ad Manager, WideOrbit Traffic, WideOrbit Streaming, FreeWheel, AdJuster Show less



Rabin Martin

• United States
• Business Consulting and Services
• 1 - 100 Employee

• Staff Accountant

  • Jun 2016 - Mar 2018

  • Assisted with month end close procedures, preparation of financial reports including Balance Sheets, Income Statements, and Cash Flow Projections • Performed monthly reconciliation for both Balance Sheet and P&L accounts • Maintained supporting schedules for Fixed Assets, Depreciation, Lease Amortization and Prepayments/Accruals including Journal entries for these accounts • Supported the completion of monthly, quarterly and annual closing procedures and financial reporting requirements and reported to parent company via Oracle systems • Responsible for full cycle Accounts Payable and Receivables processing • Reconciliations: Bank Accounts, Credit Card, Payroll, Petty Cash and Revenue Reconciliations. • Interpreted clients’ contracts for proper revenue recognition • Prepared monthly Staff Capacity Forecast and Staff Historical Utilization Reports via MS Excel • Updated working capital schedule using advanced MS Excel and reported to parent company • Designed MS Excel VBA to extract, compile, track and analyze data to generate reports use to bill clients • Created MS Excel search engines and models for project consultants • Revenue Projections - Maintained Sales Tracker and Sales Pipeline MS Excel model Show less



The Parts Authority

• United States
• Motor Vehicle Parts Manufacturing
• 700 & Above Employee

• Pricing Analyst

  • Jul 2014 - Nov 2015

  • Retrieved ProntoNet daily updated file, compared against a database (DST) via MS Excel’s VLOOKUP to ensure prices are accurate • Utilized MS Excel tools (pivot tables and macros) to evaluate and implemented changes to DST database when suppliers’ report cost changes. Communicated implications of those changes to purchasing department and stock managers to ensure no loss of margin. • MS Excel Programming -designed excel macros for payable department to facilitate vendors’ reconciliation reports. This saves the company 40 minutes per report multiplied by twenty staffs. • Performed market research to understand competitors’ pricing and maintained records of price trends • Compared Vendors’ soft copy 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 and quantity • Support the Data Department - Work with very large data sets in MS Excel – typically millions of rows of data Show less



Meditron Inc

• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Accountant

  • Feb 2012 - Aug 2013

  • Designed, implemented and monitored internal controls to ensure compliance • Supervised and reviewed expenses, payroll, and invoices to resolve discrepancies • Supervised sales and purchases personnel, in accordance with International Accounting Standard (IAS 18) • Collaborated with external auditors to complete company audits • Prepared Financial Statements, Cost Accounting Reports, Value Added Tax, Bank Reconciliations, Fixed Assets Schedule, Budgets, Cash Flow Projections to aid Senior Finance leaders in decision making • Mentored and supervised five accounting, clerical staffs • Data entry for: payables, receivables, bank deposits, expenses, incomes, inventory • Inventory: Ensured receipts and issues are duly accounted for and entered accurately in QuickBooks in a timely manner, performed analytical review on selected General Ledger accounts and researched unexpected or unusual results Show less



Anral Investments Ltd

• Financial / Cost Accountant

  • Jun 2008 - Jan 2012

  • Prepared monthly Financial Reports, Bank Reconciliations, Budgets, Cost Reports, Financial Forecasts, and Variance Analysis Report to aid Strategic Decision Making • Analyzed potential shipping routes and advised management on basis of profitability and other criteria • Reconciled and maintained database of Creditors and Debtors on a weekly basis • Analyzed daily sales report, and monitored expenses to aid in internal controls • Created best practices and models to aid decision making for shipping routes Show less