RUSHNA BHESANIA

***** ***** ***** *.*.

Kirkland, WA 98034

425-***-**** acxfuy@r.postjobfree.com

SUMMARY Self-motivated, dedicated, and results-oriented degreed individual with a combination of over 10 years of pharmaceutical, airline, computer systems, and financial services experience. Proven problem-solving ability with excellent attention to detail and organizational skills. Seeking to obtain a position in Mathematical Sciences or related field where my analytical, leadership, and team-building skills can contribute to the firm’s success.

EXPERIENCE MICROSOFT via RYLEM LLC., Redmond, WA 2016

Business Financial Analyst – WW Services Finance

Played an instrumental role in supporting the Services Delivery Transformation (SDT), specifically in the implementation of hierarchies, allocations and resource movement to the appropriate cost centers in budget

Worked with Domain Controllers to verify SDT file ties to transformations in Budget Workbench (BWB)

Tested and validated EMR Standard P&L, CorpHQ, & Domain Forecast Tools to the EMR Pivot

Key accomplishments included: Manually achieved a reorg of 8,000 heads in BWB from subsidiaries to Domains during SDT (in 6 business days). Identified 5 mission critical bugs before deployment.

MICROSFT via VOLT TECHNICAL RECRUITING, Seattle, WA 2012

Campaign Data Analyst – Wunderman // Project with Microsoft

Primary tasks included: understanding business needs, gathering & analyzing data, creating presentations/reports for client, project planning and development

Key accomplishments included: development of ROI reporting, preparation of written analysis and presented findings on Power Point to internal and external clients

SEARS HOLDINGS CORPORATION, INC., Hoffman Estates, IL 2008 - 2011

Marketing Operations Analyst – Kmart Pharmacy Group

Developed coupon life-cycle management in conjunction with Marketing Team

Built & maintained barcodes used in Marketing Initiatives (coupon offers)

Co-ordinated & approved design, structure, and content of Marketing Initiatives

Tracked redemptions on Marketing Initiatives to determine how to optimize future Marketing Programs

Conducted data analysis to maximize profit optimization on Third Party Programs

Spearheaded the transactional level analysis on Kmart Pharmacy’s Smart Squad Associate Incentive Program

UNITED AIRLINES, INC., Elk Grove, IL 2008

Senior Analyst in Planning & Development – Revenue Management Group (Furloughed)

Implemented and updated new ORION GUI (optimization tool used to maximize revenue through passenger valuation) system and training material.

Worked with market analysts to gather requirements, document, and communicate the requirements to Enterprise Optimization and Information Systems Development.

Trained on pricing and inventory seat management to maximize revenue with minimal disservice to the customer.

AUTOMATIC DATA PROCESSING (ADP), Inc., Hoffman Estates, IL 2006 – 2008

Statistical Analyst

Developed framework for the analysis of lost customers related to CRM data but could be applied across ADP’s various front end businesses and made recommendations to help ADP reduce losses.

Collected / analyzed lost client data using Data Analysis tools / Pivot Tables in Excel.

Conducted lost client surveys and ranked survey results; spoke to over 80 Sites

Used Cognos Cubes to pull information from Data Warehouse to translate business questions into reports

Built queries/reports in Cognos to track the utilization of Credit Checks then transferred reports into Access Database and set-up Forms of client information per client for follow-up

Rushna Bhesania Page 2

BANK OF AMERICA, Chicago, IL 2002 – 2004

Financial Analyst – Profit and Loss Balance Sheet

Reconciled and reviewed trading revenue results of Global Derivative Products division.

Created and distributed senior management reports on business unit performance daily.

Built macros in Excel to investigate sub-system, general ledger and dataflow discrepancies to maintain current procedure manuals.

Provided recommendations about the content and structure of revenue reporting and assisted in the planning/development for product group presentation

Securities Operation Analyst

Generated and distributed invoices for energy and power settlements

Prepared and balanced cash flow worksheets using Excel.

Investigated payment discrepancies and reported them to Middle Office.

Maintained static data tables by monthly reporting and analysis.

INTERNSHIPS Treasurer’s Office, DePaul University 3/2002 - 7/2002

Treasury Management Association of Chicago (TMAC) Intern

American Express, Schaumburg, IL 6/2001- 9/2001

Financial Advisor Intern

Motorola Inc., Schaumburg, IL 1999 –2000

Communications/ Research Intern

EDUCATION University of Illinois at Chicago, IL { G.P.A. 3.4/4.0 }

Master of Science in Mathematics with concentration in Probability and Statistics, 2006

DePaul University, Chicago, IL { G.P.A. 3.4/4.0 - Dean’s List}

Bachelor of Science in Honors Finance with Minor in Information Systems, 2002

HONORS Sigma Lambda Theta Fraternity, Business Honor Society

Recipient of Outstanding Senior Leader Award at DePaul University

2004 Outstanding ZAC (Zoroastrian Association of Chicago) Youth Award

COMMUNITY Zoroastrian Society of Washington State, Board of Directors (2016-2018)

ENGAGEMENT Manage finances, budgets and organizational development.

Zoroastrian Association of Metropolitan Chicago, Assistant Treasurer (2003 – 2005)

Built, managed and summarized financial reports and presented to Board of Directors monthly.

COMPUTER Microsoft Windows 10, Office 2016, VB, SQL, Cognos, Building & Maintaining Databases, Matlab,

SKILLS Lindo, SAS & SPSS (beginner), ORION & Apollo (airline industry), IMS (Item Maintenance System)

Microsoft internal tools proficiency: Mercury, BWB (Budget Workbench), HeadTrax, EMR, PlanCast

INTERESTS Actively involved in community service. Enjoy playing racquetball and tennis; intermediate in Yoga. Like to work on Sudoku, Scrabble, and logical puzzles in spare time. Traveled to many interesting locations. Conversational in Gujarati. Learning Sign Language to communicate with my sons.

Contact this candidate