We provide IT Staff Augmentation Services!

Business Analyst Resume

PROFESSIONAL SUMMARY:

  • Software Development - GAAP/IFRS /SEC Compliance-Trend Analysis ForecastingTesting & Documentation Risk & Quantitative Analysis-Executive Presentations-User Training & Support-Statistical Software Tools Policies & Procedures Documentation Management-Financial Modeling
  • 30+ years in various domain of Insurance, Banking& Financial Industry working in Asset Management or Investment Management, HealthCare, Telecom, Oil & Gas in the capacity of Business Analyst
  • 20+ years of experience as a Project Manager/Business Analyst
  • Strong knowledge of Excel, Access, statistical analysis, and financial modeling
  • Extensively involved in all the phases of Software Development Life Cycle (SDLC): feasibility studies, business modeling, process modeling, business requirements gathering and analysis via Agile, and Scrum.
  • Provide professional accounting services for individuals, businesses and government clients, from tax preparation to audit support, financial statement preparation, pro forma budgeting, GL accounting and bank reconciliation, reporting and analysis, treasury management, accounts receivable and payables, management of the Financial Audits
  • Helped businesses accelerate month-end close and payroll processing by up to 25% while reducing errors and increasing accuracy to new bests.
  • Assisted with SOX compliance by ensuring on-time delivery of supporting documentation to auditors.
  • Experience in Cerner CORE as it pertains to the design/build/troubleshooting of organizations, locations, position security, preferences, privileges, application/task access, and recommended Cerner practices
  • Constructs statistical and financial models with minimal direction to forecast business performance
  • Responsible to lead department specific and cross functional projects with full accountability and should expect to partner/consult with all levels of the organization
  • Interfaces with all areas affected by the project which include Sales, Finance, Marketing, Legal, Engineering, Customer Operations and IT
  • Develops detailed work plans, schedules, resource plans, and status reports
  • Conducts project meetings and is responsible for project deliverable
  • Recommends/takes action to direct the analysis of and solution to problems and build out the requirements as necessary
  • Served as Primary point of escalation for Cerner Core
  • Identify, define, and document business requirements using interviews, document analysis, requirements workshops, and other techniques
  • Experience managing multi departmental projects (operational or technical)
  • Self-motivated with strong organizational/prioritization skills and ability to multi-task with close attention to detail
  • Executes project plans, coordinate with project teams to ensure smooth execution and that timelines are met
  • Assisted client and Cerner teams collect data as it relates to organizations, locations, provider groups, security, and position design
  • Implementation, support, and maintenance of Electronic Health Record applications
  • Cerner Security, position design, provider groups, application groups, position based task access
  • Built and successfully implemented Health and Insurance plans for each MBO under their respective Cerner domains
  • Conducts and summarizes complex data and business analyses to develop business plans, including revenue and demand projections, workforce optimization, and channel management
  • Works with cross-functional teams to facilitate the data collection and performance measurement process, and escalates issues as necessary
SKILL: Cerner, Microsoft Office Suite, SAP,SAS, SQL, Oracle, Business Objects, Hyperion, AS 400, JD Edwards, PeopleSoft, Great Plains,UNIX, XML, HTML, Lawson, Kronos, Siterra, Solaris, Ceridian, Strata Tracks, Microsoft Schedule, SharePoint, Turbo Tax, QuickBooks, Peachtree, MS Visio and MS Project, IBM's Power5

WORK EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

  • Register patients through Cerner portal.. Confirm, enter, and/or update all required demographic data on patient and guarantor on registration system. Avoid overlays and duplicate patient medical records. Follow procedures when identifying a patient and applying the patient identification bracelet. Register patients during downtime following downtime procedures and enter data into registration system immediately upon system availability.
  • Obtain and explain copies of insurance card(s), forms of ID, and signature(s) on all required forms. Verify information on appropriate accounts to determine insurance coordination of benefits, pre-certification/prior-authorization if not verified by PASC. Complete the Medicare Secondary Payer (MSP) questionnaire when applicable. Verify insurance to determine coordination of benefits and obtain authorization and/or referrals as required. Screen for and process non-covered services and waiver of liability (ABN) through automated screening at time of service.
  • Inform self-pay patients of liability due, prepayment requirements and coordinate screening of alternate funding sources if applicable. Prepare estimate of procedures, calculate advance payment requirements on previous or bad debt and current balances. Refer potentially eligible patients to financial counseling and/or contract eligibility vendor(s). Coordinate with clinical areas and other ancillary departments to obtain accurate orders in order to establish patient financial expectations.
  • Collect patient payments and provide accurate receipt. Post all payments in system. Reconcile receipts with cash collected and completes required balancing forms. Document patient account notes for all interactions/transactions.
  • Assisted client and Cerner teams collect data as it relates to organizations, locations, provider groups, security, and position design
  • Cerner Security, position design, provider groups, application groups, position based task access
  • Built and successfully implemented Health and Insurance plans for each MBO under their respective Cerner domains
  • Experience in Cerner CORE as it pertains to the design/build/troubleshooting of organizations, locations, position security, preferences, privileges, application/task access, and recommended Cerner practices
  • Maintain departmental and/or individual work queues and reports as required.
  • Explain/answer patient billing inquiries and interpret statement data to resolve accounts.
  • Escalate account issues which cannot be resolved.
  • Update the emergency department room tracking system.
Business Analyst

Confidential, Richmond, VA

Responsibilities:

  • Provided highly complex technical expertise in analyzing, developing, and executing the distribution of state funding for public education.
  • Responsibilities include working directly with local and state officials (such as VA schools, State Departments Office and the General Assembly) to ensure that funding issues are appropriately identified and analyzed in the budget development process.
  • Knowledge of government budgetary and financial operations, including budget development and execution processes, funding allocations, financial reporting, and financial computer applications.
  • Provided spreadsheet and relational database applications including macro programming and V-lookups.
  • Conducted cost analysis of programs, developing and implementing funding formulas, performing research and statistical analyses to reach sound results and conclusions, and developing and presenting complex technical information to various audiences.
  • Managed spreadsheet and query-based relational database applications; applying internet- and macro-based technology is preferred. High-level writing and presentation skills.
  • Developed and executed budgets using various computation methods, formulas, forecasting models, and computer applications. Designed and conducted large-scale data collections and maintained large databases and multiple data files. Managed multiple projects on an on-going basis while meeting critical deadlines.
  • Accessed a variety of information resources and applying various computer applications to complex funding issues.

Business Analyst

Confidential, Richmond, VA

Responsibilities:

  • Served as the Chief Financial Officer, responsible for overall financial management of the organization sing PeopleSoft software.
  • Ensured compliance with audit standards and proper handling of donor funds.
  • Create job descriptions and company policies and procedures.
  • Supervised the finance and internal audit teams.
  • Prepare business, workflow and system requirements.
  • Participate in highly complex.
  • Analyzed general ledger account balances and taxes.
  • Implemented software system and created databases.
  • Ensured efficient functioning of the management information system.
  • Established service standards.
  • Structured and managed internal contract management function.
  • Performed and test development deal analysis and reporting.

Analyst

Confidential, Richmond, VA

Responsibilities:

  • Generating a comprehensive report of all disbursed money in order to ensure all 1099’s have been generated and issued via PeopleSoft and Oracle.
  • Calculating and test equity due to the home owners using information provided by the ORT Research Team, the Case Shiller Valuation Tool and the Confidential equity calculation spreadsheet.
  • Generating an Explanation of Disbursement for all harmed mortgage loans.
  • Calculating Interest owed database to the borrower based on a rate of 3.26% and fees that were erroneously paid by the borrower.
  • Serving as the liaison between ORT and DACS for: checks to be processed, fees to be reversed and payee headers to be set up.
  • Serving as the liaison between ORT and STOLI to ensure all customer tax id information is updated based off of the returned W9.
  • Assist the Operational Remediation Team in identifying process and/or training gaps and trends, and notifying Queue and Operations Managers of any significant findings.

Analyst

Confidential, Richmond, VA

Responsibilities:

  • Created database budgets, workflow, organization charts and graphs, grants and other source funding.
  • Prepared and processed audit schedules.
  • Downloaded reports from QuickBooks database into Excel spreadsheets.
  • Managed the petty cash fund, payroll, taxes and prepared financial reports in US currency and Tanzania.

Project Manager/SAS Developer

Confidential, Richmond, VA

Responsibilities:

  • SAS programmer, using SAS 9.1.3 in a UNIX environment, particularly PROC SQL, PROC REPORT, SAS/GRAPH, ODS, SAS macro and SAS/Access.
  • Extracted high complex data from various databases and created reports for business units.
  • Created and test Data Mart to support the PCSAS Reporting Tool. Databases consist of SQL, Visual Basic, PeopleSoft 9.1, 9.2, DB2, Oracle, ALS, Mosiax, DOORS and CISCO.
  • Demonstrated ability for creating system and coding changes from technical requirements.
  • Created and tested technical changes that met specific requirements.
  • Communicated with leaders and project managers through work flows charts and graphs.

Project Manager/ Analyst

Confidential, Richmond, VA

Responsibilities:

  • Created scope of services and a pricing model for the revenue collection services to be solicited from the financial institutions.
  • Data mapping, financial analysis, Agile, NPV modeling, P& L management and project management.
  • Developed and updated complex financial models to perform horizontal analysis & long-term plans. Technical environment included; People Soft 9.2, 9.1 and 8.5, SQL, MLS, MPC, Global Finance, ALS, Focus, and PowerPoint and Excel database.
  • Performed financial data analysis, budgets and variances in preparing Profit & Loss or other statements.
  • Forecasted variance explanation and CFAR reporting.
  • Summarized and converted data. RAN/SAS ABM Model. Verified, analyzed and communicated output data.
  • Prepare estimates on transition cost that calculate the cost of the new FA taking responsibility for existing customers, existing hardware and peripherals (e.g., card terminals, check scanners, PIN pads, etc.), and the technical costs (e.g., development, infrastructure) necessary to seamlessly cutover endpoints to assure daily operations.

Analyst

Confidential, Richmond, VA

Responsibilities:

  • SAP, SAP FI/CO, Agile and SQL database. Daily resolution of P2P exceptions.
  • Performed root analysis and problem resolution to eliminate future exceptions.
  • Worked with BU Supply Manager/Commodity Manager on findings to resolve.
  • Supply Chain and Logistics via COBOL 4.2 and 5.1
  • Audited daily $50,000 and greater invoices in compliance with budgets.
  • Supported day-to-day optimization and optimization team.
  • Managed exceptions of ERS/EDI Invoicing.
  • 1099 reporting and resolution.
  • Escheatment reporting and resolution.

Project Manager/Financial Analyst

Confidential, Richmond, VA

Responsibilities:

  • Managed the Accounting department. Agile, Oracle, SQL, and Excel database.
  • Designed the forecasting/budgeting/variance module for the Richmond, VA, Norfolk, VA, Greenville, SC, Columbia, SC, District of Columbia and Baltimore, MD markets.
  • Managed the Siterra Database system.
  • Imported vendor contract data for staffing and goods and services.
  • Documented the process for competitive vendor bids and portfolios to corporate for the launching of telecommunication services.

Hire Now