Management Data Analyst
Resume:
SHAILA R. AHMED
**** ***** *** ** *******, WA ***53
**********@*******.***
SUMMARY
Analytical and agile, with core strengths in strategic financial management and planning. Dedicated, diligent and empathetic with proficiency to work in diverse, ambiguous and collaborative environments. Knowledge of Generally Accepted Accounting Principles (GAAP),budgeting and forecasting.
WORK EXPERIENCE
Jan 2016- Mar 2016 Business Analyst, Holland America Line – Seattle, Washington (Contract Position)
Supported the agile project management team namely “FOCUS” team
Responsible for creation of ad hoc reports
Analyzed Holland America internal processes
Tools used: MS Excel, MS Access and MS Word
Jun 2015- Dec 2015 Analyst, Microsoft -Washington (Contract Positions)
Sep 2015- Dec 2015 Financial Analyst, Microsoft -Bellevue, Washington (Contract Position)
Responsible for creation of ad hoc reports for the SMSP SMB Finance Team
Created and analyzed reports through Orbit and MSSales.
Established common parameters to verify data within the reports
Wrote cube formulas to interpret current financial parameters
Managed SharePoint site for SMB team
Built financial models for budgeting and forecasting purposes
Tools used: MS Excel ( Powerpivot, Powerview and VBA), MS Sales, Orbit, Sharepoint and Mercury
Jun 2015-Aug 2015 Operational Compensation Analyst, Microsoft - Redmond, Washington (Contract Position)
Supported the Dynamics Compensation Group; Worldwide, Americas and Asia
Analyzed the Compensation through MS Sales, xCAT and MIC
Created territories and participant records through xCAT
Managed accounts for sellers in Dynamics
Tools used: MS Excel ( Powerview and Powerpivot), xCAT and MIC
May 2013 - Sep 2013 Financial Reporting Analyst, Sur La Table – Seattle, Washington
Created and modified reports on a weekly and monthly basis
Analyzed the financial parameters of the reports in order to determine the valuation of the company
Prepared ad hoc reports for management
Established a modified procedure to update and verify vital financial information
Prepared instructions on reporting technique
Tools used: MS Excel, Access, PowerPoint and Internal Reporting Tool.
Jun 2012- May 2013 Data Analyst, Amazon Inc.-Seattle, Washington (Contract Positions)
Mar 2013-May 2013 Data Analyst, Amazon Inc. – Seattle, Washington (Contract Position)
Identified discrepancies in video records through Microsoft Excel
Responsible for security implementation of video records
Tools used: MS Excel, SQL and ETL manager
Jun 2012- Jan 2013 Data Analyst, Amazon Inc. – Seattle, Washington (Contract Position)
Automated analysis & identification of defects in apparel records through SQL & Microsoft Excel
Automated organization of apparel records & resolution of defects
Recommended process and quality improvements for defect identification & resolution
Tools used: MS Excel, SQL and ETL manager
EDUCATION
2010 – 2012 Master of Business Administration (Finance)
City University of Seattle – Bellevue, WA
Dean’s list Spring, Summer & Fall 2012
2000 – 2007 Bachelors of Medicine and Surgery
Dow University of Health Sciences – Karachi, Pakistan
BUSINESS SKILLS
Profit & Loss Management
Financial & Strategic Planning
Business Strategy and Operations
Project Management
Project Portfolio Evaluation
Forecasting
Auditing & Compliance
Budget Development & Management
Cash Flow Management & Modeling
Competitive Analysis of Global Markets
Business Valuations
Managerial Accounting
Corporate Management
Health Care Economics
CAPEX/OPEX
TECHNICAL SKILLS
Proficient in Tableau,SQL, MS Office: MS Word, Excel (Pivot tables, Powerview, Powerpivot, VBA, Macros and VLookups), Access, SharePoint & PowerPoint
Proficient in internal Microsoft BI tools namely MS Sales, Mercury, xCAT, Orbit and MIC
Contact this candidate