Customer Service Data
Resume:
Current Address:
Yunqi Ma
Permanent Address:
**********@*****.***
Elmhurst, IN 11373
Elmhurst, NY 11373
EDUCATION
Indiana University, Kelley School of Business, Bloomington, IN December 2019 Bachelor of Science in Business
Majors: Accounting & Information Systems
Academic Honors:
Global Engagement Scholarship
The National Society of Collegiate Scholars
PROFESSIONAL EXPERIENCE
Santander Bank, N.A., Holmdel, NJ June 2019-August 2019
Business Analyst Compliance & Quality Assurance
Cooperated with compliance department and development team to develop new system with scrum team using Agile
Utilized Fircosoft Trust to conduct biweekly OFAC 314a sanction screening for the compliance team
Conducted various testing through FFF classic, utilized FMM to convert txt lists to kz files, FML to manage rules being developed and FUM for user access
Organized post-production monthly optimization meeting with compliance team to write rules to eliminate false positive alerts
Managed and periodically updated good guy and bad guy lists for the compliance team
Wrote Business Requirement Document to document system development, developed user stories from in scope requirements
Organized daily scrum meeting with BA team and documented project progress
Conducted UAT session with business users, demonstrated functionality with historical transactions and discussed in scope improvement direction
Utilized JIRA to manage the project, time allocation across the team and project progression tracking
Conducted enhancement test and smoke testing through SailPoint with QA team, documented and archived test results on SharePoint
Coordinated with development team and technology consultants on enhancement test data update and reconciliation
Wrote test plans to document testing approach and strategy, and wrote test cases to check each individual defect
Mapped Requirement Traceability Matrix to link user requirements to different test cases and results
China Construction Bank, Beijing, China May 2017-August 2018
Business Analyst Compliance
Applied SQL to integrated 200+ online user transaction database, increased department’s data sufficiency
Analyzed newly launched customer service advantages and disadvantages, completed SWAT analysis process
Led 4 people group to conduct client transaction analysis, generated monthly report for client strategy department’s performance reference
Utilized Actimize SAM to conduct 100+ transaction monitoring and made sure alert is properly generated through RCM
Worked with Product Owners to develop product backlog and organized regular sprint meetings
Assisted director on writing Functional Requirement Document, created use case diagrams through Visio
Conducted data cleansing on data drawn from data warehouse using various Excel functions
Loudoun County Government Center, Leesburg, VA May 2016-July 2016
Business Analyst
Reconciled data inconsistency on multiple construction projects from data warehouse using SQL aggregate functions
Wrote SQL Queries to request Federal funding and construction project data information
Built project financial performance forecast diagrams through various Excel functions and Power BI, guided future funding distribution
Collaborated with department controller to clarify Federal contract term confusion through weekly meetings, documented conciliatory notes to help department’s financial research
Improved financial department’s quarterly national report through group discussion to enhance presentation quality, assisted national financial presentation in NYC
SC-ope, Bloomington, IN August 2015-April 2016
Business Analyst
Evaluated newly launched product performance analysis through client meetings and online surveys, gathered feedback information for market research and development guidance
Pulled database from SQL server to Excel, analyzed customer trend and product preference through Excel functions such as VLOOKUP, HLOOKUP and Pivot Table, and Power BI for profit optimization report, increased revenue by 3%
Conducted product analysis presentation in front of marketing team, reported profitability and ROI performance and suggestion
Monitored product research and improvement through regular feedback and advising session, met deadlines with anticipated result
Organized regular 5-10 staff meetings for performance check point and goal setting, reduced 10% miscommunication and goal misses
Additional Skills
Access, C#, HTML, Java, Visual Studio, XML
Contact this candidate