Fangming Rempala Email & Phone Number

Houston, Tx, Us

Houston, Texas, United States

Houston, Texas, United States

Houston, Texas, United States

*Processed large amount of raw data from SAP, created over 15 charts for half year scorecard of 2020 and 2021 in 20 days to present comparison of all purchase orders*Normalized and validated over 2000 vendors in Chinese and English to build parent-child relationship, and create Pareto chart by applying 80/20 rule*Standardized vendor category mapping with reports extracted from SAP and internal data to assign over 2000 vendors to accurate category*Collaborated with Power BI team to test existing scorecard dashboard with SAP raw data, developed new metrics for updated dashboard, and provided assistance for both Power BI team and Procurement Department globally*Established Smartsheet reports for Procurement team and Power BI team with vendor normalization data from 3rd party*Performed inflation risk analysis with reports from SAP to map location of top 80% vendor under each category to evaluate vendors, and calculated predictive spend in 2022 for future risk management*Delivered on-the-spot support for global Procurement team on e-Procurement platform selection, conducted research about all 3 vendors and translated post-meeting surveys from English to Chinese*Constructed slide decks for ad-hoc reports and present in group meetings contain 3 to 70+ co-workers

Columbus, Oh

* Facilitated finance/accounting department in full-cycle accounting, up-to-date bookkeeping, daily cash flow prediction, and implementing accounting procedures* Played pivotal role to assist Team Manager in scrutinizing financial data and transactions daily and weekly by employing automated accounting systems to assess revenue* Prepared data analytics projects in Excel by using pivot table/chart with accounting team by reading annual reports based on financial criteria such as revenue growth, net income, and EBITDA margins

Columbus, Ohio, United States

In this position, I helped a group of Chinese major students at Ohio State with questions about Chinese culture and literature after class. During the weekends, I practiced oral Chinese with them and helped them with the pronunciation.

Columbus, Ohio Area

Changchun, Jilin, China

* Collaborated with financial analysts to research, analyze and interpret individual/business financial data in Excel to make data-driven decision for clients' loan applications* Acquired in-depth knowledge of BOC system tools and applications in support of Accounting Ledger processing to work with financial analysts on a daily basis* Provided accounting support to the Team Manager including responses to ad hoc requests and PowerPoint presentations

Changchun, Jilin, China

* Monitored daily, weekly, monthly and annual customer call trends and present analytical findings applying visualization tools to Team Managers with the objective of increasing organizational efficiencies* Handled 50 - 60 walk-in customers daily and collected relevant data by building lucrative relationships with clients with positive attitude and patience

Jilin, Jilin, China

It was a part-time job which allowed me to have enough time to get along well with the students there. My job there was the TA and helped them solve the problems they faced with teachers.

Jilin, Jilin, China

It was a part-time job and I ordered food for customers and collected money. Sometimes I also help other clerks to make sandwiches.

Changchun, Jilin, China

I worked in that hospital to help the doctors and nurses to do some jobs. Most time of my job was to take care of the patients in hospital.

Master Of Science - Ms, Applied Analytics

Relevant course work: R Programming, Data Management, Strategy and Analytics, Storytelling with Data

Bachelor Of Science In Business Administration- Bsba, Accounting

Activities and Societies: Member of Accounting AssociationRelevant course work: Business Analytics, Business Finance, Statistics.

Language Program, English Language And Literature, General