We provide IT Staff Augmentation Services!

Business Analyst / Operatonal Support Resume

Detroit, MI

PROFESSONAL SUMMARY:

Advance - degreed professional with 20-plus years of field experience as operations manager, senior business analyst, business analyst, project manager, staff accountant, application consultant, financial analyst and budget analyst, seeking position that will take advantage of experience and utilize aptitude for handling multiple projects, or a complex individual project, requiring functional and technical expertise.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

BUSINESS ANALYST / OPERATONAL SUPPORT

Responsibilities:

  • Provide operational support for automotive OEM Dealer Data Share ( Confidential ) program which collects data from 4,200 dealers, who use 15 different Dealer Management Systems (DMSs), and disseminates it to 30-plus retail marketing programs
  • Trouble-shoot, diagnose and coordinate resolution of data integration issues for Vehicle Sales, Repair Orders, Parts Sales, Parts Inventory, Vehicle Inventory and Service Appointment
  • Write and perform SQL queries to aid in the investigation of data issues
  • Review incoming XML business object documents in the Standards for Technology in Automotive Retail (STAR) format as part of diagnosing issues
  • Collect and document requirements for enhancing the existing system in order to support evolving business needs
  • Quality Assurance testing using XML Notepad to assure that incoming files adhere to standard schemas

Confidential, Southfield, MI

OPERATIONS MANAGER

Responsibilities:

  • Manage operations of data integrations between auto dealer systems and providers of after-market warranty, maintenance, insurance and protection products
  • Provide client and customer support of day-to-day activities; diagnose and facilitate resolution of system and transactional issues
  • Identify opportunities for improvements and work with development team to design, test and implement
  • Document existing business and technical processes
  • Project management for integrations with new providers and products

SENIOR BUSINESS ANALYST

Confidential

Responsibilities:

  • Manage the implementation of data integrations between retail automotive dealers and various lenders loan origination systems or portal
  • Integrations include credit applications from dealers to lenders, credit decisions from lenders to dealers and two-way credit comments
  • Document lender-specific requirements relative to data integrations
  • Review development work relative to requirements; Quality Assurance
  • Perform and work with lender customers to complete User Acceptance Testing
  • Coordinate implementation, pilot testing and general release
  • SDLC - Agile

Confidential, Livonia, MI

BUSINESS INTELLIGENCE BUSINESS ANALYST

Responsibilities:

  • Re-engineered process for tracking development requests; reduced number of systems involved in order to streamline the process in the interest of efficiency; documented new process using Microsoft Visio
  • Consolidated development requests from multiple sources to eliminate redundancies, review for appropriateness and provide visibility to the business leaders for ranking and prioritization; combined like requests to provide comprehensive solutions and reduce redundant effort
  • Facilitated gathering of requirements from team leaders for the administration of approximately 30 separate variable compensation plans; worked with developers to ensure proper programming and testing prior to implementation
  • Documented requirements for reporting numerous measurements of external vendor performance across multiple areas of the business; created mock-up of data presentation to be reviewed by leaders prior to development and refined as required throughout the development process
  • Created test cases and validated reports through the use of SQL queries and actual output
  • SDLC - Agile

Confidential, Farmington Hills, MI

BUSINESS ANALYST

Responsibilities:

  • Compiled and documented requirements, including use cases, to facilitate line of business transition from legacy system to new internally developed application
  • Created and validated release notes, installation guides and user training documents for new and upgraded systems
  • Performed and modified database queries as interim solution for collecting sales revenue data to be used as basis for monthly billing and accounting entries; created detailed process documents, with and without swimlanes, to facilitate the transition of duties from analyst to operational personnel
  • Defined new data tables and modifications to existing ones to facilitate changes in the business and improvements to existing systems; created insert and update SQL statements for new and modified data
  • Coordinated project with external vendor to facilitate integration of systems to provide automated solution for work previously done manually; integration facilitated by the use of XML messaging
  • Validated reconciliation of one year’s worth of activity between source system, billing reports and customer reports in order to identify system and business process shortcomings and improvements
  • Researched and documented process for adding new customers to existing system structure to include data flow requirements and mapping
  • Validated system enhancements and reporting results against test cases through the use of traceability matrices
  • SDLC - Agile

Confidential, Farmington Hills, MI

PROJECT MANAGER / SENIOR BUSINESS ANALYST

Responsibilities:

  • Created project plan for modifying existing Chrysler Financial point-of-sale contract validation system and implementing it for Confidential Financial
  • Created presentation for executive management describing approach, plan and resources required for aforementioned project
  • Reviewed and revised existing specifications in order to address business rule differences between existing and future implementations
  • Documented requirements for coordination of data flow and validation between interfacing systems
  • Identified specific data elements to be transmitted from external parties for use in internal systems through the use of XML messaging and in accordance with STAR standards
  • Worked with subject matter experts to identify and document required changes to existing business processes and functional requirements for new system
  • Reviewed existing reporting and documented changes necessary to facilitate reporting in new line of business
  • Designed test cases to be used for validating results once development is completed

Confidential, Farmington Hills, MI

SENIOR BUSINESS ANALYST

Responsibilities:

  • Business analysis, documented requirements and translated them into technical requirements for a major upgrade of home-grown software systems and portal; facilitated coordination between business users and technical support
  • Subjects covered included modifying existing system for enhancements and deficiencies in GUI, data capture, table structure and reporting ability
  • Using database queries, reviewed system data, identified abnormalities, created and implemented plan to correct existing data and prevent future occurrences, including designing system enhancements and revising business processes
  • Documented existing and future processes in writing and in flow charts and swimlane process diagrams
  • Coordinated technical aspects of sales campaigns between marketing, sales and external call center
  • Created and maintained tool and process for tracking progress and status of work to be completed
  • Facilitated reporting for revenue, commission and number of sales based on requirements jointly established with business users
  • SDLC - Agile

Confidential, Ann Arbor and Detroit, MI

BUSINESS ANALYST / PROJECT MANAGER

Responsibilities:

  • Business analysis, documented requirements, created Request for Proposal (RFP), reviewed available products in support of build/buy decision using Joint Application Design/Development (JAD) approach
  • Project management for the implementation, development and upgrade of multiple, integrated computer systems; business processes from order entry through invoicing and accounting
  • Coordinated with vendors of multiple commercial off-the-shelf (COTS) systems in the design, testing and implementation of custom functionality
  • Coordinated implementation/changes with users, including their approval at tollgates, other business analysts and systems
  • Documented business process using standard documentation practices including swimlanes and system support of business processes
  • Liaison between systems users, software vendors and Information Technology support
  • Report development, testing and implementation; wrote and performed database queries for reporting and issue diagnosis
  • Coordinated access and training for business users; determined appropriate roles and maintained application security
  • Risk application support including the maintenance and loading of pricing and basis curves and producing mark-to-market and position reports

STAFF ACCOUNTANT

Confidential

Responsibilities:

  • Prepared statements and presented monthly financial results to management
  • Performed month-to-month variance analysis
  • Prepared and reviewed journal entries
  • Analyzed and reconciled general ledger accounts
  • Performed, re-developed, and documented monthly accounting close procedures for multiple companies
  • After data analysis, created and maintained database retrievals to gain efficiencies and in response to customer requests
  • Streamlined processes to better manage increasing workload

Hire Now