We provide IT Staff Augmentation Services!

Business Systems Analyst / Project Manager Resume

5.00/5 (Submit Your Rating)

Los Angeles, CA

TECHNICAL SKILLS:

Advanced knowledge of Financial and ERP systems: Confidential, AMSI (Infor), JD Edwards E1BlackLine, Hyperion

Advanced knowledge of BI: IBM Cognos TM1 Advanced Knowledge of SQL, VBA Knowledge of SSRS, Visual Studio Advanced use of Microsoft Office Suite (Excel, Access, Visio, Word, and PowerPoint) Excellent customer service skills Multilingual abilities (English, Italian, Spanish)

PROFESSIONAL EXPERIENCE:

Business Systems Analyst / Project Manager

Confidential, Los Angeles, CA

Responsibilities:

  • Provide technical support of the Confidential application, an industry - leading asset and property management software, and work closely with Property Operations and other internal user groups on Confidential implementations, budget, CAM automation, forecasting, AP, AR, Job Cost and ETL upload processes.
  • Design, create and customize reports in Sequel Scripting, SSRS and Confidential Spreadsheet Reporting.

Business Systems Analyst

Confidential, Los Angeles, CA

Responsibilities:
  • Administer accounting software (AMSI), accounts payable software (Nexus) and utility billing system.
  • Create and set up Excels reports based on SQL queries and stored procedure to allow users to enter parameters and refresh data.
  • Create Macros in Excel with VBA to automate and improve business processes.
  • Create Ad-hoc reports for management.
  • Ensure operational support of all IT systems.
  • Deliver cost-effective and right-sized infrastructure solutions in support of business objectives and corporate strategic direction.
  • Monitor projects progress and performance.

Financial Systems Analyst

Confidential, Agoura Hills, CA

Responsibilities:
  • Support the implementation of Confidential, maintain and administer the system.
  • Train and support the end-users.
  • Create, modify and maintain SQL reports, stored procedures and workflows in Confidential .
  • Create and maintain forms by using Excel/VBA to upload ETL files to Confidential .
  • Participate in the design, installation and maintenance of system projects, collaborate with the development team and other departments to fix problems and incidents encountered in production, and design long term solutions to enhance production environment.

Consultant

Confidential, Century City, CA

Responsibilities:
  • Work on system integration between WLMS, E1 and TM1, system enhancements and project work.
  • Streamline existing excel reports and develop new reports utilizing VBA and TM1. Develop ad-hoc reports to manage the business.

Financial Systems Analyst

Confidential, Century City, CA

Responsibilities:
  • Serve as financial systems analyst in supporting and enhancing JD Edwards Enterprise One (E1), IBM Cognos TM1 for finance, accounting and related departments to support the financial close, reporting, budgeting and forecasting processes.
  • Provide application expertise and training to end users on supported applications.
  • Work closely with business partners to investigate and quickly resolve system issues encountered by users and functional teams.
  • Develop and maintain standard and ad hoc reports in IBM Cognos TM1.

Financial Analyst

Confidential, Lake Forest, CA

Responsibilities:
  • Perform financial analysis to determine present and future financial performance.
  • Gather, analyze, prepare, and summarize recommendations of financial plans and forecasts.
  • Manage planning, budgeting, forecasting and reporting processes analyzing trends and variances in actual performance to budget and recommending corrective actions.
  • Assist in streamlining analysis and reporting routines.
  • Recognize and solve problems through financial analysis. Prepare internal financial reporting for various levels of the organization.

We'd love your feedback!