We provide IT Staff Augmentation Services!

Senior Business Systems Analyst Resume

Ontario, CA

SUMMARY

  • Senior Business Analyst professional possessing years of experience within the International Business Operation, Financial and Information Technology environments.
  • Experience in project, budget and credit analysis with major financial institutions.
  • Experience in identifying opportunities, solutions and strategies for business development and expansion.
  • Adept at analyzing and documenting business processes and procedures to provide result - oriented workflows.
  • Proficient with Microsoft platform skills implementing databases, ecommerce and management systems.
  • International procurement and logistics experience.

TECHNICAL SKILLS

  • Software: MS Office Suite
  • MS Access
  • Advanced Excel
  • SharePoint
  • Cognos Query Studio
  • Navision
  • Mosaic
  • Actuate
  • WinSQL
  • SQL Server
  • Dynamics CRM
  • Dynamics AX
  • Crystal Reports
  • SSRS
  • Oracle PeopleSoft
  • QuickBooks
  • GoSystems
  • Smart Stream.

PROFESSIONAL EXPERIENCE

Confidential, Ontario, CA

Senior Business Systems Analyst

Responsibilities:

  • Negotiated procurement contracts, pricing and SLAs with vendors, manufacturers, suppliers and third-party agents to ensure cost TEMPeffective secured supply chain deal proposals.
  • Procuring inventory orders, vendor samples and efficiently tracking order confirmations with invoices to ensure data accuracy and balance payments.
  • Communicating with vendors about any damages and product issues to resolve problems and ensure dat subsequent orders meet quality specifications.
  • Gatheird requirements through stakeholder’s engagement interviews, business process descriptions, user stories, business analysis as well as task and workflow analysis.
  • Maintained strategic relationship with international suppliers in translating customer and business requirements into functional requirements for product development.
  • Liaised between the internal units and external customers as well as the IT team and Finance department to clarify requirements for the RFP and RFI process overhaul.
  • Implemented and documented gap analysis comparison between the current business processes ‘as is’ to ‘desired’ business outcomes and provided recommendations for solving the gaps to assist stakeholder’s decisions.
  • Used Dynamics CRM, AX, MS Access, Excel and SQL DB Queries for data analysis, reconciling, processing and ad-hoc reporting.

Confidential

Senior Business Systems Analyst

Responsibilities:

  • Elicited requirements through stakeholder’s engagement interviews, requirements workshops, business process mapping, use cases and scenarios, business analysis as well as task and workflow analysis.
  • Reconciled and documented business accounts balances with bank account statements
  • Participated in Agile Scrum sprints and developed business cases and product requirement documents for new products and feature enhancements.
  • Supervised Business Analysts in translating user and business requirements into functional requirements both in local and international markets with strong financial, analytical and modeling skills.
  • Maintained strategic relationship with international suppliers in translating customer and business requirements into functional requirements for product development.
  • Performed business data analysis and SQL report generation to facilitate process decision-making and efficiency.
  • Lead business team in building detailed inventory system to support and enhance business continuity.

Confidential, Bethesda, MD

Senior Business Systems Analyst

Responsibilities:

  • Administered PeopleSoft trainings and Business Support to Time Admins/HR in PCDW Cognos, Mosaic and Actuate.
  • Developed and customized budget schedules in Excel providing Microsoft application support including macro and VBA scripting and maintenance.
  • Designed and developed functional Access Database Application used for the documentation to develop PeopleSoft queries for the new system upgrade.
  • Generated PeopleSoft business and Access reports periodically to manage and track requirements status.
  • Created an Excel Spreadsheet Upload Template interface designed to validate, export and set environments to produce different output formats consumable by the CI interface to upload Bill Rates, Project Resource, Order and related information into PeopleSoft Systems Application.
  • Analyzed and documented requirements used for project upgrades and implementations.
  • Built and maintained Access databases for Finance department use and provided software and hardware support to internal users.

Confidential, Washington, DC

Senior Business Analyst

Responsibilities:

  • Reduced a four-year’s backlog to less TEMPthan 6 months by streamlining all credit enhancements processes with Mortgage Insurance Companies and lenders which increased the transaction management output.
  • Recorded and processed transaction requests associated with credit enhancements.
  • Documented processes and procedures, identifying opportunities for system enhancements to better support business needs/objectives.
  • Performed monthly production and reconciliation activities, conducting data analyses to uncover and resolve data discrepancies using applied analytic skills to identify root cause of variances.
  • Interpreted and managed complex contracts to resolve secured deals approaching milestones.
  • Utilized MS Access, Excel and WinSQL for tracking, reconciling, processing and reporting credit enhancement transactions using DB Queries to accomplish data analysis and the subsequent metrics reports.
  • Performed monthly asset update and monthly loan level and pool level reconciliation activities.

Confidential, Alexandria, VA

Financial Analyst

Responsibilities:

  • Managed several accounts for Non-Profit Organizations dat required contract analysis, structuring of rates and discount, monthly auditing and addressing billing and reporting issues of NPIM customers.
  • Performed corporate account maintenance and reviewed monthly invoices statements.
  • Provided administrative and financial support to the Resource Center including account billing analysis.
  • Prepared and forecasted monthly collection objectives utilizing Access and Excel as analysis tools.
  • Prepared monthly report statements and maintained schedules; prepared cost proposals and request for quotes; managed outstanding accounts receivables; and maintaining payment history database.
  • Provided exceptional bookkeeping services interacting with Clients to solve contract disputes and billing errors.

Confidential, Lanham, MD

Financial Analyst

Responsibilities:

  • Liaised between the IT and Finance Department maintaining a high level of interpersonal relations with the clientele.
  • Worked with the Finance department team to record Actual Values into the System and generated Crystal reports.
  • Developed VBA script in Excel for Budget Analysis purposes and developed customized Data: Entry forms involving the use of dynasets, functions and expressions, bitmap, data validation controls, OLE Objects, Macros and VBA code.
  • Participated in the implementation of an inventory management system and also developed a client database system.
  • Reconciled and analyzed General Ledger accounts and assisted with assigned special accounting projects.

Confidential

Accountant

Responsibilities:

  • Prepared Statistical Report, Benefits Paid Report, Rent Letters, and Bank Reconciliation.
  • Maintained Excel Schedule; key journal entries to Workbench, Prepare Journal Entry Worksheets for all plans, and wrote up disbursement sheets; writing code on A/R Contributions for input into the Mainframe.
  • Processed work paper analysis and assisted with the preparation of year-end work papers and 1099s.
  • Used GoSystems Accounting software for ATB; maintaining and updating the Pension Excel Schedule Database.
  • Exported data from GoSystems to Excel for month end closings and processed AP Disbursements and Transfers.

Confidential

Accountant

Responsibilities:

  • Prepared and maintained general accounting books and ledgers daily, weekly, and monthly.
  • Compiled and analyzed financial information to record entries to the general ledger accounts.
  • Bank Reconciliation & Payroll entries; managed Credit Control Unit.
  • Maintained accounts payable and receivable bookkeeping records.

Hire Now