Experience

Versivo

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Business Analyst

  • Mar 2016 - Present



Freddie Mac

• United States
• Financial Services
• 700 & Above Employee

• Business Analyst

  • Mar 2015 - Mar 2016



Public Company Accounting Oversight Board (PCAOB)

• United States
• Financial Services
• 700 & Above Employee

• Business Intelligence Team Analyst

  • May 2013 - Mar 2016

  • Created Internal Database: ARIA & RASR, using combination of VBA, SAS, and SQL.• Built data transforming process from External Database: S&P and CapIQ, by coding data export and report generation functions.• Validated periodic reports and ad hoc reports by conducting research with Data Vendors: Audit Analytics and Edgar.• Constructed macros within Excel to automate business processing, resulting in efficiency improvement of 90%.• Implemented Data Extract, Transform, Cleanse, and Analysis using Excel macro for 800+ accounting firms’ survey.• Used SQL assisting Office of Research and Analysis in collecting and analyzing data from over 15,000 issuers’ financial reports; identified discrepancies that might trigger audits and communicated discrepancies to team.• Validated 680 global companies’ financial and audit data through 10-K and Audit Analytics; shared problems with inspection team for further inspection planning.• Contributed to Business Intelligence Team’s strategic decisions for implementation of projects at weekly meetings.



International Monetary Fund

• United States
• International Trade and Development
• 700 & Above Employee

• Intern of Secretary Department

  • Feb 2013 - Mar 2013

  • Assisted conference office in managing annual IMF meeting, including: space design, budget and project management.• Created table for scheduling all 200+ meetings for conference using Share Point.• Developed brochure with a summary report of all merchandising since 2011 to assist conference planners forecast merchandising endeavors for future meetings.• Input meetings requests and updated meeting proposals into meeting management database. • Assisted conference office in managing annual IMF meeting, including: space design, budget and project management.• Created table for scheduling all 200+ meetings for conference using Share Point.• Developed brochure with a summary report of all merchandising since 2011 to assist conference planners forecast merchandising endeavors for future meetings.• Input meetings requests and updated meeting proposals into meeting management database.



PUBLICIS GROUPE

• Full Time Trainee for CSR Annual Reporting

  • Jan 2012 - Jul 2012

  • Gathered 48,000+ pieces of data using company’s Hyperion Financial Management database over two month period.• Analyzed, filtered and tested data of six levels of data from 794 business units; shared findings on improving data quality and worked through issues with Financial Managers of each business unit.• Processed rough data in scopes and calculated into 20 indexes for reports delivered to CFO and CSR Vice President for both internal and external audits. • Gathered 48,000+ pieces of data using company’s Hyperion Financial Management database over two month period.• Analyzed, filtered and tested data of six levels of data from 794 business units; shared findings on improving data quality and worked through issues with Financial Managers of each business unit.• Processed rough data in scopes and calculated into 20 indexes for reports delivered to CFO and CSR Vice President for both internal and external audits.



Citi

• United States
• Financial Services
• 700 & Above Employee

• Assistant Data Analyst

  • Jul 2011 - Aug 2011

  • Led team of 10 in developing new financial product for Citigroup based on surveys and calculations within one month.• Developed survey to investigate investment methods of customers among community of 8000 in Shanghai.• Projected investment behaviors; collected data from 800 surveys and classified data into categories of potential customer investment behaviors. • Led team of 10 in developing new financial product for Citigroup based on surveys and calculations within one month.• Developed survey to investigate investment methods of customers among community of 8000 in Shanghai.• Projected investment behaviors; collected data from 800 surveys and classified data into categories of potential customer investment behaviors.