Iris Z. Email & Phone Number

Seattle, Wa, Us

Dallas, Texas, Us

Tools used: O9 Platform, Python, SQL, Excel● Implement the platform for one of the largest lumber company to help them visualize inventory data and make predications● Review issues & gaps identified in UAT with clients and IT and bring those items to closure● Analyze business processes and translate them into test cases and scripts● Support, as required, the documentation of user stories / functional requirements● Report UAT progress

Charlotte, Nc, Us

BI tools: Tableau, Alteryx, Excel, Teradata, SQL, Access, Toad, SSIS● Create Microsoft SharePoint sites● Implemented ETL pipelines through Alteryx workflow and developed dashboards and reports using Tableau● Run SQL queries to analyze, test and report data for multiple source database systems● Build SQL Server schemas, tables, views, and stored procedures

Dallas, Texas, Us

● Collaborated with team members to provide data analytic support to the advisory team for accurate financial reporting ● Performed data cleansing and data analysis on over 130+ clients’ balance sheets under tight deadlines● Established ETL processes using MS SQL and Access to extract, transform and load financial data into warehouse ● Created and executed SQL queries to access the data in SQL Server and prepared the data results for reports

London, Gb

● Cleansed and consolidated 4M+ market data for Alibaba using Excel and pivot tables ● Synthesized data from over 10 different sources using VBA macros to create a centralized dataset for easy updating● Conducted extensive market research and collected social data from 10 different social media platforms● Performed data analysis on prospective customers, competitors, sentiment and potential business opportunities● Designed weekly analytical reports including graphs with statistical results that interpret customer behavior, trends and marketing results; developed social media strategies to assist management in decision making processes

Dublin 2, Ie

● Reviewed and verified details of up to 1000 purchase orders, check payments, and invoices from vendors per month● Analyzed and reconciled invoice discrepancies and ensured all period related vouchers were posted prior to payment● Updated vendor databases and accurately entered all invoices into SAP system to generate payment vouchers; achieved 20% higher accuracy rate than average● Prepared detailed records for all transactions in Excel and performed month end account analysis with minimal error

Columbus, Ohio, Us

● Lead orientation events & small group discussions on campus and in Columbus, work with 20 Orientation Leaders and the Office of International Affairs staff to ensure positive orientation experience for new students● Managed and performed presentations and information sessions ● Welcomed 2000 new international students, answer questions about transportation, life on campus, and acquaint new students with campus services, building locations, and university policies and procedures; achieved 98% positive event feedback from final survey

Springfield, Mo, Us

● Instructed and assisted 150+ students to help them comprehend the core concepts of computer science● Maintained scheduled office hours to advise, teach, and give performance feedback to students● Prepared and led review sessions in the fundamentals of computer programming and computer networks

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Double Major: Accounting, Finance. Minor:Economics