Business Analyst / Accounting System Analyst

SELLENA MENG CAO

Email: **********@*******.*** Cell phone: 781-***-****

SUMMARY

Blends academic training in data analytics, information technology and business with hands-on experience in professional accounting analysis, business analysis, project analysis and system analysis to offer a track of record to deliver on tasks accurately, efficiently, and promptly. Superior communication skills with a proven sense of urgency and detailed orientation.

Core Skills: SQL, Advanced Excel (VBA/Pivot), JIRA Agile, Requirements Gathering, Project Coordination, Solutions Design, Java, Python, R, Tableau, SPSS, MySQL Workbench, HTML5 and CSS3. EDUCATION

Master of Science in Strategic Analytics (Predictive Analytics), GPA: 3.83 03/2018 Brandeis University, Waltham, MA

Master of Science in Information Technology, GPA: 3.81 08/2017 Endicott College, Beverly, MA

Master of Business Administration, Accounting Concentration, GPA: 3.56 08/2015 Endicott College, Beverly, MA

Bachelor of Arts in Finance and Accounting

Shanghai Normal University, Shanghai, China

PROFESSIONAL EXPERIENCE

Data Analyst Intern 06/2016 – 09/2016

Shanghai Information Center, Shanghai, China

A government’s decision-making advisory body of macroeconomic and social management policies.

Participated in the Governmental Social Credit System project to analyze the public credit scores of citizens and businesses. Created, designed and standardized the data catalog to ensure data integrity and accuracy.

Performed data mining, cleaning, extraction, storage, and analysis while maintaining account setups, reports, dashboards, workflows and other routine tasks.

Centralized and streamlined raw data collection process. Provided ad hoc reports to senior management. Accounting Supervisor 04/2009 – 04/2013

Inditex Group, Shanghai, China

A Spanish international clothing company that owns brands such as Zara etc.

Managed financial controls including initializing the projects, estimating, analyzing, reporting, forecasting, and taking corrective actions for both e-commerce platforms and offline stores.

Analyzed the annual budget of operational expenses, service fees, staffing forecasts and statistical reporting. Provided monthly management reports, accompanying detailed schedules and narratives.

Implemented recommendations for executive teams to improve operational efficiency as well as to facilitate the Group’s rapid expansion into the Chinese market. Provided overseas accounting support for store openings in Korea, Macau, Taiwan and India.

Implemented new systems to resolve issues in accounting processes and improved internal controls environment: o Worked with the cross-functional teams to analyze the business requirements and accounting systems performance. o Designed functional test scenarios based on gathered requirements of key features to ensure all business cases are covered. Performed test planning, management, and verification for internal interface work streams. o Led the development of a payment system to collect, record, and report the expenses of domestic transactions and inter-company activities.

o Refined and visualized key KPIs and Metrics at the program level to assess size & scale, uniqueness, and agility. Documented application workflow to represent proposed functionality (Data flow / Context Diagram / Feature Decomposition).

o Troubleshot system to ensure data integrity and database availability in daily transactions. o Developed a vendor management system as the subsystem of payment system. Integrated with the accounting system database, evaluated the operational and administrative information gathered from multiple sources, reconciled variances, decomposed information into detailed procedures, and summarized general interpretations for financial planning.

ACADEMIC PROJECTS

Churn Analysis Project

Implemented K-means clustering analysis in data mining and analyzed customer churn using logistic regression model and predicted call center performance using time series forecasting.

Elicited requirements and gathered edge use cases regarding the end-to-end participant experience. Database Management System Design Project

Identified the proper business rules and functional area and created ERD diagram by MySQL Workbench.

Designed logical database and created database with tables, keys and constraints using SQL.

Documented use case requirements for systems testing the feature.

Contact this candidate