Analyst Engineering

Ranya I. Hasan **************@*****.***

**** ****** ****** ************ ** 19115 215-***-****

EDUCATION:

LA SALLE UNIVERSITY, College of Prof. & Continued Studies, Philadelphia, PA Master of Science, Graduation: May 2019

Major: Data Analytics

TEMPLE UNIVERSITY, Fox School of Business, Philadelphia, PA

Bachelor of Business Administration, Graduation: June 2015

Major: Economics Minor: Healthcare Management

EXPERIENCE:

AMTRAK, Philadelphia, PA March 2020- September 2020

Senior Business Analyst

•Supported Engineering Capital Budgeting Group with all aspects of monthly business and financial results ranging from $2.5 Million – $3 Million a month

•Executed daily reconciliation of SAP Master and Cost data using Microsoft Access

•Created journal entries for Engineering projects in SAP General Ledger

•Assisted in BPC annual, monthly budget, forecast submissions with a budget of 17 million annually

•Built monthly reports through Microsoft Access queries for engineering capital projects

ARAMARK, Philadelphia, PA January 2016- March 2020

Senior Business Analyst, Supply Chain August 2019- March 2020

•Managed supply chain market basket models for 9 lines of business with an overall annual spend of 2.3 billion dollars

•Collaborated with sourcing managers to obtain monthly SKU (stock-keeping unit) price projections for reporting

•Tracked, analyzed and interpreted the inflation and deflation of monthly internal purchasing of over 600 SKUs with BI tools

•Implemented updates with purchase data to market basket model in order to keep relevancy in analysis

•Reported internal supply chain purchases to senior management on a daily, weekly and monthly basis

Analyst II, Advanced Analytics February 2018- August 2019

•Supported the implementation of enterprise pricing software, called Catalyst, across all lines of business within the company

•Worked closely with software developers to ensure that the pricing software (Catalyst) included the needs users by request and testing

•Assisted in training of the development and application for the pricing software in webinars and online office hours for users

•Transferred funds from internal accounts ranging from $3,000 to $200,000 in Oracle database

•Created and submitted monthly expense reports to the corporate financial team

•Created highly sensitive HR data reports with SQL queries in SQL Developer

Pricing Analyst January 2016- February 2018

•Assisted AVP of Pricing Strategy in planning for financial yearly projections and forecasting

•Researched economic trends of food commodity prices, labor costs, and employee benefits through government websites, headlining news, and agricultural forums

•Managed Projects for new businesses ranging from $100,000 to $4 million by using pricing analytical processes for development and review

•Compile data from multiple sources to create and maintain account tracking lists for the use of building weekly reports, analyzing the progression of pricing, and creating workflow processes

•Convert 8-12 sets of data a day, mainly from POS systems, using software such as Microsoft Foxit and NotePad++ to manipulate data into formation for Excel

•Monitored communication between the field and the corporate pricing team with the use of tools such as Skype, SurveyMonkey, conference calls, and Aramark pricing official email

INDEPENDENCE BLUE CROSS, Philadelphia, PA July 2015- December 2015

Cash Applications Analyst

•Logged the unposted funds from one IBC account, and repost IBC account, then closed the request once post is completed

•Researched payments using different platforms: Highmark, Wells Fargo, PNC banking, PeopleSoft

•Received 80- 120 copies of checks and deposit statement from Wells Fargo bank, identified accounts for the payments, and submitted them to WLI Access program

•Analyzed accounts that are in the IBC migrated systems and un-migrated system

•Manually posted payments for IBC account, ranging from $25- $200,000 into an electronic bank lockbox

U.S. DEPARTMENT OF HUD, Philadelphia, PA May 2014- July 2014

Analytical Intern, Housing and Urban development

•Researched and entered census statistics for 200+ regions in the Maryland area into database

•Analyzed relationships with housing prices, location, and income of the Maryland Townships population

•Proofread 3-4 legal reports a day being processed for review and assessment

•Created copies of legal documents for closed cases for complainant by request

SKILLS & LANGUAGES:

•Microsoft: Word, Outlook, Publisher, Excel, PowerPoint, Foxit

•SQL: MySQL Server

•Database: Oracle, Microsoft Access, SAP

•Software: QlikSense, NotePad++, R Programing, Tableau

•Fluent in Arabic (Levantine dialect, and Classical Standard dialect)

Contact this candidate