Masood

Excel Reporting and Automation Specialist

Upwork • Freelance

Jan 2020 - Present • 6 yrs 8 mos

Data Analysis & Reporting Projects • Delivered Unique and automated SKU Generation in Excel for multi category, multi warehouse company • Developed automated invoice trackers, Inventory Tracker and Budget/Expense Tracker for accurate reporting • Financial records and trading reconciliation (Bank Accounts transactions VS trading, Bank Account Transactions VS expenses) • Designed customized Invoice, Delivery Order, Way Bill, Purchase Order templates • Developed automated workflows in MS Power Query & MS Excel for data mining and clean up for messy data from multiple PDFs and CSV files for cleaned and analysis ready report Al Mabrook • Process development and Improvement for investment platform web app • Crafted User Manuals for internal and external investment platform users • Sales and Marketing KPI developement, Sales Pipelines, GTM Stretegy • Developed FSD and performed UAT for mapping business requirements Premio Mart - E Commerce Store • Developed comprehensive dashboard visualizing E-Commerce store performance, break-even and ROI based on agreed KPIs • Processed accurate sales and incentives to sales representatives and referrals • Set up automated workflows for email marketing campaigns using Brevo CRM which resulted in 15% sales growth V-Track • Developed Sales Dashboard for visualizing daily, weekly and monthly sales performance • Prepared monthly Marketing Performance Report for CEO

Operations & Business Analysis Manager

Adamjee Insurance Company Limited • Tiempo completo

Apr 2007 - Jan 2020 • 12 yrs 9 mos

• Developed MS Excel based payment verification system which processed PKR 200 Million p.a. verified payments to vendors • Developed and Improved Tracker Installation, Dismantling, Recovery, Payment processes for measuring and improving operational performance • Liaison with technology teams for ICT business analysis activities such as. requirement gathering, process development, UAT and training • Formulated annual department budget of PKR 17 Million; to ensure fund availability and smooth operational continuity

MIS Analyst

Standard Chartered • Tiempo completo

Mar 2005 - Mar 2007 • 2 yrs

*Ex Union Bank staff member which merged into Standard Chartered* • Developed daily, weekly and monthly visibility Excel MIS reports for nationwide Credit Card's sales performance monitoring • Processed salary commissions & for 70+ sales representative as per verified salary and incentive commission criteria in MS Excel • Data cleanup for credit card's regulators monthly, quarterly and annual reporting on sales, credit disbursement and recovery