We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

Philadelphia, PA

SKILLS:

Development of SQL statements and queries using: MySql and Oracle SQL Developer

Database Design: 1nf, 2nf, 3nf Data Mining and Visualization using Tableau

Geographical Information Systems: ArcGIS

Web Programing: HTML, JavaScript, CSS, JQuery, JSON, PHP

Enterprise Resource Planning (ERP) Tools: SAP, Oracle Financial, JD Edwards

Expert in: Microsoft Excel

Financial Analysis and Accounting: Life Cycle (AR, AP, GL, Accruals)

EXPERIENCE:

Confidential, Philadelphia, PA

Senior Business Analyst

Responsibilities:

  • Assisting in Duties for Business Analyst.
  • Conduct contract price analysis from Supplier Purchasing reports.
  • Summarize contract price analysis into pivot tables for management and collection from distributors.
  • Use Tibersoft analysis tool to locate contract price variations.
  • Gather requirements and perform QA test for Tibersoft tool rollout.
  • Perform cost analysis for entire Fleet Department.

Business Analyst

Confidential

Responsibilities:

  • Audit fuel purchasing cards to make sure fleet is compliant with enrollment policies.
  • Any ad - hoc reports as requested by the business.
  • Audit maintenance enrollment, compliance, and spend quarterly for line of business managers.
  • Evaluate fully amortized vehicles for replacement based on cost and future efficiencies.
  • Evaluate fleet purchases for volume rebates.
  • Edit and execute queries for price analysis from vendors.
  • Create and run SQL queries for contract price variance audits.
  • Aid planning finance quarterly meetings.
  • Aid planning department site visits and departmental outings.

Confidential, Bristol, PA

Senior Business Analyst

Responsibilities:

  • Prepare quarterly analysis of entire AP department for review by the Chief Accounting Officer.
  • Extract and organize data from accounting systems as outlined by management.
  • Participate in data conversion from vendors to accounting system.
  • Departmental lead - focal point for all technology needs.
  • Assist management in creating business processes within the accounts payable cycle.

Business Analyst

Confidential

Responsibilities:

  • Assist in Conversion from JD Edwards to SAP.
  • Track all monthly charges to ensure accuracy of vendor charges.
  • Develop advanced Excel Spreadsheets using Visual Basic for Applications
  • Reconcile large vendor accounts.
  • Process invoices for payment.
  • Post Journal Entries.
  • Provide MS Office and accounting system support for department of 50 users.

Confidential, Warminster, PA

Network Administrator

Responsibilities:

  • Windows NT 4/2000 and Exchange 5.5 Server Administration (supported 2000 users on the East Coast) Added user and machine accounts to domain, Monitored Server Activities
  • Level III desktop and notebook support - phone support, repaired and replaced desktop PCs due to software or hardware issues.
  • Created and maintained base and departmental images using Norton Ghost - installed operating system and drivers and all necessary software for each department in company.
  • Supported Database servers (Microsoft SQL Server, Oracle, Seibel Systems) and some DB Administration.
  • Participated in rollout of Sales Force software.

Hire Now