Mark Kawayoshi

**** ******* ***. #*** *** Angeles, CA 90025

(213) 399 - 2152 • acqm7y@r.postjobfree.com

Summary of Qualifications

13+ years of working with financial technologies, focused on equity trading and compliance systems.

10+ years of working with Excel macros and VBA.

8+ years of working with SQL, Business Intelligence tools and reporting.

Ability to clearly communicate technical and non-technical materials to a wide variety of audiences.

Comprehensive leadership skills and team-oriented personality.

Proactive approach, always thinking of ways to streamline a process and improve a situation.

Professional Experience

The Capital Group Companies, 2002 – Present Los Angeles, CA

Business Systems Analyst (Order Management and Compliance) 01/2011 – Present

Product Owner for Capital’s proprietary order compliance system utilizing Agile Scrum software development framework. Collect and define user, technical, data requirements, and translate into functional design documents. Analyze end-to-end processes and re-engineer business processes as needed.

Work with development, engineering, and quality control teams to communicate requirements and participate in systems/software design, prototyping, construction and testing of new or enhanced systems/applications.

Plan, coordinate and implement projects and systems/software releases.

Develop user documentation and deliver user training.

Create reports using Crystal Reports, Tableau, Business Objects, and MS Excel to report figures such as holdings, limits, and other portfolio characteristics to Investment Committees.

Develop and support numerous shadow applications writing macros in MS Excel. In-house Excel VBA expert.

Project work includes Windows 7 migration and Lotus Notes to Sharepoint migration.

Contribute to multiple projects simultaneously and consistently met deadlines and milestones.

Other tasks include create/maintain compliance rules in Charles River Development and Sharepoint Site Administration.

Investment Technology Support Specialist Senior (Equity Trading) 06/2007 – 12/2010

Investment Technology Support Specialist Level II (Equity Trading) 06/2004 – 06/2007

Trading Room lead and was involved in projects consisting of application upgrades, researching and deploying new trading technologies, gathering user requirements, and disaster recovery.

Regularly met with brokers and vendors to evaluate and research equity trading technologies. Continually managing these relationships to keep current on present and future trading trends.

Specialized in equity trading systems, FIX protocol, dark pool trading systems (Pipeline, Liquidnet, ITG Channel), market data software including but not limited to Reuters, Thomson One Equity, and Bloomberg.

Performed business functions such as analyzing trade cost analysis, commission trends, set up trade cost reports, automated the processing of trade data.

Acted as a liaison between Equity Trading and IT application and development teams. Managed relationships between the departments to ensure the business goals were met.

Improved overall trading efficiency by creating shadow applications and MS Excel sheets that integrated with realtime market data, Excel macros, and incorporated websites into the workflow.

Established a virtual global trading support group internally to focus on trading technologies and strategize research globally. Established an internal wiki which later became a MS SharePoint site to manage data and information related to the business.

Responsible for resolving day-to-day IT issues, giving presentations about equity trading technologies, and providing training to other associates.

Investment Technology Support Specialist Level I 10/2002 – 06/2004

Assisted high priority Investment Managers and Analysts for system diagnosis and repair.

Authored support documentation for issues, updates, and general investment information.

Created processes to increase efficiency to the business.

Sitelite, 2001 – 2002 Irvine, CA

Network Operations Center Shift Supervisor 06/2002 – 10/2002

Supervised a team of administrators in a mission critical 24/7 network operations center (NOC).

Monitored network integrity, troubleshooting, and remote administration for various companies located throughout the US, Europe, and Asia.

Oversaw the daily work activities of analysts, and assisted management with employee rewards, recognition, appraisal, feedback, goals, objectives, staffing, development and training, and provided technical assistance to advanced technical issues.

Provided level III support to customers as needed.

Network Operations Center Analyst Shift Lead 2 11/2001 – 05/2002

Resolved client issues. Resolution included but was not limited to connecting to servers remotely to perform many administrative duties such as troubleshooting hung processes, performing backups, verifying database stability, starting/stopping services and processes, checking file systems, monitoring Oracle and SQL Server, and troubleshooting other everyday issues on all types of servers and environments (Solaris, Linux, HP-UX, IBM AIX, Windows 2000/NT).

Education

University of California, Irvine Irvine, CA

Bachelor of Arts in Economics, Minor in Computer Science

Technical Skills

Certifications: Certified Scrum Product Owner (CSPO)

Languages: Excel VBA, SQL

Software: CRD, Tableau, Business Objects, Crystal Reports, HP Quality Center, Bloomberg,

Reuters, Thomson One Equity, Lotus Notes, MS Word, MS PowerPoint, MS Excel,

(Macros, VBA, and Pivot Tables), MS Project, Rapid SQL.

Contact this candidate