We provide IT Staff Augmentation Services!

Systems Analyst Resume

SUMMARY:

Experienced Business Systems Analyst with a strong finance and accounting background in areas including Media and Entertainment, Investment Fund Management and Banking. Expertise in gathering and documenting business requirements from both internal and external business users.

TECHNICAL SKILLS:

  • SAP, Oracle, Microsoft Dynamics AX, QuickBooks, MAS500; PeopleSoft ERP and various in - house systems
  • SQL Queries
  • Advanced Excel user including advanced functions, pivot tables and macros
  • Proficient in Access, Word, Visio, PowerPoint and MS Project

EXPERIENCE:

Confidential

Systems Analyst

Responsibilities:

  • Develop testing plans and execute test scripts for enhancements and other initiatives for Research and Finance ERP modules
  • Document technical requirements for system enhancements
  • Use SQL queries to troubleshoot system issues

Confidential

Senior Business Analyst

Responsibilities:

  • Gathered and documented user requirements for both internal business users and external clients
  • Performed unit testing to determine that all user requirements were met by development team
  • Documented “as - is” and “to-be” process flows
  • Performed gap analysis for external client reporting requirements and internal system generated reports
  • Documented conversion strategy process for new client on-boarding
  • Worked with QA and UAT to develop effective testing strategies for system enhancements
  • Presented enhancements to internal users and external clients
  • Analyzed project tasks to determine resources needed to meet timeline for long term conversion project
  • Developed requirements for client onboarding tool to track project progress and completion
  • Completed complex data analysis using queries and spreadsheets to facilitate data mapping
  • Managed workload and delegate tasks to team members to efficiently meet project deadlines

Confidential

Business Analyst

Responsibilities:

  • Created documentation for data migration for Residual Accounting system conversion
  • Performed SQL queries to validate mapping of conversion data and assess data integrity through data analysis
  • Created functional process flows for conversion/reconciliation process for outsourcing model
  • Monitored and reviewed accounting team’s tasks for both accuracy and timeliness
  • Created documentation for business processes and procedures including flow charts
  • Prepared quarter end close journal entries and general ledger account reconciliations
  • Created daily reconciliation files using advanced Excel formulas and researched variances for multiple banks
  • Researched variances between custodian bank reports and investment manager reports

Confidential, Los Angeles, California

Manager, Revenue Share Accounting

Responsibilities:

  • Maintained database to track contract milestones for payment
  • Supervised preparation of revenue share calculations for over 100 clients in all territories
  • Analyzed profit margin by product line and territory
  • Prepared reconciliation of accrued return reserves to actual returns and analyze variance
  • Prepared aging reports for accounts payable and accounts receivable
  • Established new department procedures and procedure documentation process for improved internal controls
  • As part of Microsoft AX Dynamics implementation team, responsible for uploading and reconciling data for N. America and global entities

Finance and Accounting Consultant

Confidential

Responsibilities:

  • Supervised project to research royalty rates for digital music downloads
  • Assisted with month end close process including account reconciliations, bank reconciliations, analysis, and adjusting entries
  • Compiled summary of financial information and key ratios from foreign regions for use by corporate executives
  • Researched variances between custodian bank reports and investment manager reports
  • Prepared compliance schedules for mutual funds
  • Prepared lead sheets and financial statements for funds
  • Performed variance analysis between general ledger accounts and royalty reporting
  • Prepared gain/loss analysis for fixed asset disposal
  • Reconciled gift card sales and redemption activity to outside vendor and general ledger

Confidential, Chatsworth, California

Manager, Royalty Accounting

Responsibilities:

  • Supervised preparation of royalty statements and administration of participation deals
  • Prepared month end account reconciliations and variance analysis
  • Calculated and analyzed profit margins for products
  • Analyzed asset accounts to ensure adequate amortization of balances
  • Coordinated month end close process
  • Worked with Information Technology Department to determine system requirements for a royalty accounting system
  • Coordinated testing and parallel processing for new system
  • Set up new department procedures and internal controls to accommodate change of business structure and growth of company

Hire Now