Systems Analyst

EXPERIENCE

Business Systems Manager · August **** – September 2020

Olympic Aviation · Cerritos, CA

• Managed general ledger tree and subledger GL mapping

• Prepared and executed company’s first accounting close

• Surfaced previously unknown revenue losses

• Created and documented new accounting procedures

• Proactively prevented data entry errors and other discrepancies

• Spearheaded planning and implementation of new technology with user group

• Performed ETL on newly acquired company’s Firebird SQL database to SQL Server

• Led IT system migration of company’s first acquisition

• Interim Controller

Senior Sales Manager · August 2016 – August 2017

HGC Global Communications · Diamond Bar, CA

• Consulted Fortune Global 100 and OTT on global network solutions

• Researched market and priced global networks

• Managed creation of new ultra-low latency product in China

• Streamlined commission achievement reporting and payment turnaround

• Negotiated agreements with new master agents

• Planned network implementation and scheduled cross connect installations

Financial Systems Analyst · March 2015 – August 2016

Volt Information Sciences · Orange, CA

• Assisted in SQL training classes

• Recreated VBA driven reports into SQL reducing risk of inaccuracy

• Slashed month end close processing time by 14 hours (50%)

• ERP system upgrade Six Sigma Black Belt team member

• Managed configuration of system allocations

• Planned mapping and migration of new general ledger accounts

• Automated validation of financial report templates

• Programmed tools for analyzing unstructured data

Business Development Manager · October 2012 – March 2015

HGC Global Communications · Los Angeles, CA

• Highest sales record in history of Americas BDM role

• Negotiated terms and MSAs with carriers in Africa and other regions

• Aggressively penetrated Africa market building new channels into NGO community

• Managed consortium Buy Program focused on NGOs in rural markets

• Interviewed new BDM candidates

Project Manager · October 2011 – October 2012

HGC Global Communications · Los Angeles, CA

• Led telecom projects for AWS, Samsung, GE, Tencent, HSBC, Deluxe Entertainment, Formula 1, NBA, Thomson Reuters, and The Coleman Company

• Visited vendors around the country to discuss expansion plans and ongoing projects

• Performed patch work and circuit testing

Operational Accounting Supervisor · August 2006 – October 2011

Volt Information Sciences · Orange, CA

• Primary resource for critical SQL queries used for legal and SEC restatements

• Performed UAT testing using test scripts for PeopleSoft 9.1

• Improved daily deadline achievement from 33% to 100%

• Reduced idle time between stored procedures

• Implemented new tools and techniques to improve server utilization

• Mapped out and redesigned procedures using Six Sigma methodologies with KPMG

Contact this candidate