We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Rover, NA

SUMMARY:

  • Over 10 years of business side IT project management in the development of 7 enterprise wide global applications at Ford (Web, Client Server and Mainframe). IT teams ranged in size from 28 to 120.
  • Project delivery lead on 7 different Data Warehouse applications.
  • Experience with full Systems Life - Cycle in many different design methodologies (FUSION, Ford System Life Cycle, Unified Solution Delivery Methodology - USDM, RUP, Agile and Waterfall).
  • Application platforms involve Web, Client Server, Mainframe and BI - Data Warehousing.
  • 8 years of people management experience for a staff of 7 - 10 agency personnel.
  • Over 10 years experience with Security sub-system development experience for Role, Profile and Data level controls. Areas included enterprise controls, extra-net & firewall solutions, access authentication & authorization, and development of controls for proprietary Identity & personal data.
  • 7 years of experience developing and executing UAT test cases.
  • 4 years of experience with technical writing, end-user training and user guide documentation.
  • Over 10 years of mainframe FOCUS programming (BI special projects & reporting).
  • Over 15 years Web and Client Business Intelligence tools experience (7 - WebFOCUS, 8 - Business Objects, and 4 - Cognos Impromptu) and SQL development experience.
  • 2 years of Data Mining development experience with three different applications utilizing automated algorithms for intelligent analysis of business data and dashboard front ends of pattern results and key performance metrics.
  • 1 year of business systems management experience in Confidential .

ACQUIRED KNOWLEDGE / SKILLS:

  • Full life-cycle Project Management experience
  • IT Project Business Analyst experience
  • Programming experience on mainframe, client server and web BI special reporting tools.
  • Data Warehousing & Data Mining development experience
  • IT application development knowledge - Mainframe, Oracle Server and Web
  • Corporate database knowledge ( Confidential data, parts, dealers, vehicle BOM, warranty claims and product concern data)
  • Cross-functional team experience.
  • Confidential business & IT processes
  • Automotive Education
  • People management experience
  • Automotive product development knowledge
  • Vehicle diagnostic development experience.
  • Diagnostic Tool development knowledge
  • Vehicle Powertrain calibration development experience
  • Product quality concern identification & resolution process experience
  • Part procurement process knowledge
  • Recall process knowledge
  • Problem solving and analytical skills

TECHNICAL SKILLS:

  • iPlanet
  • Websphere
  • Java (J2EE)
  • DB2Connect (middleware communications)
  • Cobol
  • Oracle 9i
  • Oracle Reports
  • SQL Server
  • NET.DATA
  • ETL
  • Cognos Impromptu
  • Business Objects (web & full client)
  • WebFOCUS
  • Mainframe FOCUS
  • IMS / TSO mainframe environments
  • JCL
  • Sun and Unix Servers w/ web hosting and applications services layers
  • IBM 355 Mainframe w/ O/S 390 and DB2 database management
  • Teradata (SQL data warehouse platform)
  • Ngram Technologies (data mining) iGrafx - Flowcharter
  • Microsoft Office Word, Excel, Access
  • Microsoft PowerPoint (presentations)
  • Microsoft Project (project management)
  • Microsoft Visio (process flow)
  • Microsoft Outlook
  • IBM Lotus Notes
  • IBM SameTime

PROFESSIONAL EXPERIENCE:

Confidential, Rover, NA

Business Systems Analyst

Responsibilities:

  • Successfully analyzed Warranty Claims Data Warehouse architecture, database structures and transactional processing to identify major issues inherent in all current report programs.
  • Implemented changes in report program logic to allow staff in Warranty, CRC, Product Investigation, Litigation, Field Staff and Finance personnel to be able to accurately reflect and reconcile all Warranty performance and cost throughout the organization. Identified financial discrepancies in annual reconciliation valued at over $500,000.
  • Successfully analyzed supporting data and business systems to identify root causes for source system issues and provided recommendations for resolution.
  • Successfully managed and performed required programming for over two hundred business reports through the use of the WebFOCUS Special Reporting Tool.
  • Monitor, fix and upgrade all Special Reports required by business through the use of a WebFOCUS reporting environment. Instance architecture consisted of a production job scheduler (Report Caster) with over 100 reports run at various time intervals with output distributed through email, a “canned” reporting environment of 50 plus reports web delivered for end user ease of access and report run (Managed Reporting Environment) and adhoc delivery of required business data for day-to-day decision making.
  • Process requests of business data for the purpose of identify incorrectly coded Warranty Claims by company retailers which result in corporate cost saves.
  • Understand and investigate various business processes throughout the North American headquarters office and find opportunities to improve and automate for both efficiency and productivity.
  • Investigate and analyze corporate source system issues. Find business data anomalies, identify root causes and define recommendations for resolution.
  • Participate in the development of all new source system applications, by drawing on over 30 years of experience, to provide guidance and technical support to ensure that system designs meet business needs.

Confidential

Business Systems Project Lead

Responsibilities:

  • Participated in the successful source system upgrade to PeopleSoft v8.9.
  • Successfully managed all source system data improvements through ELT and Data Warehouse enhancements.
  • Acquired knowledge of all Confidential source systems and Business Intelligence applications to handle Level 2 Help Desk support for Confidential employees & non-employees globally.
  • Direct all workflow for the design, content and data integrity of the Confidential Data Warehouse. Workflow included business customer interface for new sources of Confidential data as-well-as defining requirements, maintaining the system Change Control process, setting IT work priorities, chairing project status meetings with IT and providing project status to upper management.
  • Monitor all processes and manage changes for Confidential data extracts sent external to the organization. Extracts included data feeds for Confidential Management and Executive compensation to supplier Towers Perrin, a data feed of corporate employee Service Anniversary recognition data to supplier Tharpe Robbins, a feed to the corporate web portal for Confidential Financial staff access, and a feed to the Daimler Corporation for global Confidential data record integrity between the global entities.
  • Manage and maintain the Security of the Confidential Data Warehouse. Tasks included leading efforts on design and strategy of the security system, approving and implementing security access for global Confidential representatives, managing Sarbanes Oxley security compliance efforts such as annual Security renewal for all users and a quarterly review of all security implemented for access integrity and non-use.
  • Acquire and utilize enterprise knowledge on all corporate Confidential production systems to provide Level 2 support for two Help Desks ( Corporate and Confidential ). Expertise required for the Person Data Management system for Identity Management of corporate personnel (employee & non-employee), My Profile for employee “self-service” of maintaining personal data, the PeopleSoft system for corporate management of all Confidential employee data & employment processes. Regular tasks included diagnosing Confidential data integrity issues and approving the correction for Confidential data to all downstream corporate systems.

Technologies :

  • PeopleSoft
  • Cognos Impromptu (and SQL)
  • Lightweight Directory Access Protocol (LDAP)
  • Java Script
  • DB2 Connect
  • Cobol

Confidential

Business Analyst

Responsibilities:

  • Develop Business & Systems Requirements Specifications document to capture all the business and IT requirements related to the Parts Distribution and Part Claims Handling for VW North America on a joint venture vehicle program with Confidential .
  • Workflow involved coordination between a client side Project Manager, IT side Project Manager, a project side Technical Architect and various business management and end user business team members to document all requirements.

Technologies :

  • Utilized a VW of Germany adapted Waterfall systems design methodology.
  • Microsoft Word, Excel and Visio

Confidential

Business Technical Project Lead

Responsibilities:

  • Led IT and Business teams through the conversion and changes of the Vehicle Targeting sub-system. This sub-system is utilized by global Field Service Action (FSA) Coordinators to target affected vehicle populations involved in a given quality issue.
  • Led IT and Business teams though the development and launch of the application Security sub-system to deliver the proper authentication, validation and authorization for system access.
  • Led IT and Business teams through the development and launch of the Records Management sub-system to enable the organization to have effective document controls.
  • Led IT and Business teams though the design, development and launch of the Special Reporting data warehouses (on Teradata) for Vehicle Targeting and for Field Service Action execution and repair completion performance metrics..
  • Initiated, developed and executed computer programs to automatically assign new Responsible Dealers for terminated dealers or customer relocation conditions. The programs merge dealership Market Area Point data and Dealer Master data to perform proximity that would optimize dealer assignments within closest geography to the customer.
  • Participated in the launch of the Business Objects client server special reporting tool to maximize end-user utilization of FSA data for Business Intelligence. Developed training materials and helped with the training sessions.

Technologies:

  • SUN Applications Servers - Web in iPlanet - App Services in Websphere
  • Web application screens and business logic in java script using J2EE
  • Application Services Layer - Security DB SQL Server - Reporting Svc in Oracle Reports
  • Affected FSA Data Mart for interface communications in SQL Server
  • IBM 355 Running OS/390 - I/O handled running Cobol stored procedures to DB2 databases
  • Middleware communications handled through DB2Connect
  • Data Warehouse on Teradata with BI analytical service in Business Objects 9 (and SQL)
  • Over 30 global interfaces to other Web, Mainframe and Vendor applications & databases.
  • Microsoft Office Suite, Visio and Project

Confidential

Field Service Action Coordinator

Responsibilities:

  • Set-up / coordinate vehicle concern Technical Review meetings with Engineering and Confidential Recall program management staff.
  • Derive vehicle attributes for data selection from involved vehicle descriptions in 14D document on potential Field Service Actions (Recall or Customer Satisfaction programs).
  • Use vehicle selection criteria in queries against the Vehicle Data Mart to target involved vehicles in the Campaign Targeting System (CTS).
  • Load affected vehicle population records into the Corporate North American Campaign System (CNACS) for someone else to process the Field Service Action (FSA) launch steps.
  • Maintain potential FSA process status and affected vehicle volumes in the Field Service Action Online database for weekly Concern Status Review meetings.

Confidential

Quality Office Team Leader

Responsibilities:

  • Participate with Quality Office team and vendor team (Triada) to develop a corporate data mining application to house all corporate quality indicator data.
  • Developed data optimization techniques to support the full analytical capabilities of several data mining software suites. Techniques were documented in a patent submission.
  • Participated in various data mining research efforts conducted by Ford Scientific Research Laboratories. The tasks involved work with software tools such as Triada Ngram technology, Themescape by Confidential, Inc. and Text-O-Scope by Instinct Software (now ClearForest).
  • Led offshore development project for Confidential Web application with Confidential, the Quality Office and Confidential Computers (located in India).
  • Led IT team of 5 in the development of WebFOCUS BI analytical application running against a Data Warehouse on a Teradata platform. Existing mainframe FOCUS application was migrated to WebFOCUS.

Technologies:

  • Unix Applications Servers
  • Web application screens and business logic in java script
  • IBM 355 Running OS/390 - I/O handled running Cobol stored procedures to DB2 databases
  • Middleware communications handled through DB2Connect
  • WebFOCUS BI Tools on Teradata Data Warehouse (and SQL)

Confidential

IT Project Leader

Responsibilities:

  • Successfully led the development and launch of multiple sub-systems for mainframe CQIS application.
  • Roll-out of the CQIS application to 4200 users at global Ford locations.
  • Managing the successful development of the mainframe FOCUS BI system.
  • Development of a 3 & 5 year Global Business / IT Plans for on-going system development.
  • Management of 7 - 10 people for 8 years on day-to-day work priorities.
  • Participation in the successful development and launch of the web based Global Concern Reporting application (GCR).
  • Performed in a Business & Systems planning capacity to develop and implement a global business plan for rolling out CQIS and reporting processes to Global Confidential Regions/Markets for global enterprise product quality early concern identification, quality tracking and resolution management.
  • Initiated and led the Administration team in a marketing and awareness strategy for the use of CQIS, which yielded 4200 users in 311 global Ford organizations in 33 countries for business process consistency.
  • Led the National Hotline activity (NHL) and Confidential Service Improvement Operations activities in the development and implementation of a sub-system in CQIS called Technical Assistance Referral (TAR). This sub-system provided a communication interface between the Hotline and 19 Confidential Regional Offices on “tough to fix” vehicle concerns. The communications resulted in on-site support from regional Field Service Engineers (FSEs) to dealership personnel with technical support to resolve customer vehicle concerns.
  • Led IT activity and the Confidential Plant Vehicle Team (PVT) representatives in the development and implementation of a sub-system called the Concern Tracking System. This sub-system was used to track and status of both Quicker Service Fix and normal vehicle concerns through to resolution. The system allows all plant PVT teams to monitor all vehicle concerns though the entire concern resolution process.
  • Initiated and led the agency staff through the development and implementation of a mainframe FOCUS based Menu Reporting System. This system housed more than 163 unique special reports for problem solving, data input metrics and administrative metric reports. The output from this system interfaced to all Microsoft Office software to extend the analytical capabilities of the CQIS data.
  • Participate in the team effort to develop and implement the Global Concern Reporting web application (GCR). Provided solutions that enabled the application to accept vehicle concern reports on any Confidential vehicle globally and move the report data into the quality indicator repository for early concern identification and tracking.
  • Participate in the Systems development of the Vehicle Data Mart. The database enabled the merger of both manufacturing (BOM) and sales data for all of Ford North America and Ford of Europe produced vehicles.

Technologies:

  • IBM 355 Running OS/ 390 - I/O handled Cobol programs to DB2 databases
  • Interfaces managed through 3270 Terminal Emulation
  • Data Warehouse on Teradata with BI analytical service in Mainframe FOCUS (and SQL)

Confidential

IT Project Coordinator

Responsibilities:

  • Successfully led the development of mainframe Common Quality Indicator System (CQIS), phase 1.
  • Prompt Office Automation Support to over 70 PCs in Service Engineering Office.
  • Participation in Rapid meetings to identify main functions and content for the application.
  • Led user groups and IT through the detail specification development, design and implementation of sub-systems. The scope for this phase of the design included:
  • General and Fleet Hotline report entry sub-systems.
  • Problem solvers “Tool Kit” to handle the review of product quality indicator reports with report summary count analysis.
  • Electronic foldering of quality indicator data for concern business case development in preparation for problem resolution process steps.
  • Electronic report forwarding interface for Service Engineers to communicate critical Safety & Emissions concerns to the Recall activity.
  • Electronic Technical Library sub-system to hold all known published product concern communications to the field
  • Provided the Service Engineering Office, staff of 70 plus, with PC office automation support. Tasks involved staging PCs with Ford approved standard software loads, new updates/patches, and help desk “like” PC trouble-shooting (2 years of OA experience). Interfaced with divisional / corporate office automation activities and end-users.

Technologies:

  • IBM 355 Running OS/ 390 – I/O handled Cobol programs to DB2 databases
  • Interfaces managed through 3270 Terminal Emulation
  • Data Warehouse on Teradata with BI analytical service in Mainframe FOCUS

Hire Now