Business Analyst (Consultant) Resume

SUMMARY:

This experienced business analyst seeks to use her technical, analytical, communication and documentation skills in various business environments with multiple database and business intelligence programs to assist in optimizing data collections and disseminations, identifying and resolving issues
Participating in your organization's goal of maximizing operations and revenue.

SKILLS & ABILITIES:

Computer Skills - Report Writing and Development:

SQL (Teradata/PL-SQL)
Oracle
Teradata
Cognos
MS Office (Word, Excel, Access (Microsoft Certified), Power Point, Project, Visio)
SQL Express

Communication:

Developed numerous computer and legal documentation manuals, training materials, data flows, data maps, etc.
Liaising between functional users and information technology personnel to create usable technical plans
Planned and conducted numerous training sessions for program users

Leadership:

EXPERIENCE:

Business Analyst (Consultant)

Confidential

Responsibilities:

Perform analysis and support for several large finance database programs/data warehouse in Boeing Finance Department, using Access, Cognos, Oracle, Toad and Teradata.
Assist in the implementation of new accounting, business intelligence and MRP (manufacturing resource planning) programs and data warehouse reporting packages, including (1) comparing functionality of the new program to operations of the existing mainframe programs that were replaced; (2) planning for the migration of existing data and development of programs for retention of historical data; (3) identification of key data to be migrated to new Cognos reporting packages; (4) data mapping from old to new programs; and (5) related activities.
Assist in the development and testing of reporting packages for data warehouse (including relationship identification for joins), and develop and maintain over 150 Cognos reports in various reporting packages using parameter, union and other standard query types.
Program and maintain multiple Access and SQL Express databases and Excel macros used for merging and post-processing of data from disparate systems to provide cohesive reports with user-controlled filtering parameters. These include databases and other tools used to adjust unit costs for material estimating purposes, and reports relating to supply/demand, procurement, accounting data, inventory and forecasting.

Senior Business Systems Analyst

Confidential

Responsibilities:

Analysis of data and system issues for Oracle, mainframe and various PC systems and databases.
Development of multiple new databases and conversion of older, unsupported databases to MS Access, and maintenance of databases, including report development and enhancements.
Program unidirectional feeds between Oracle and mainframe programs to department databases.
Develop add-on applications to provide further analysis and utility for mainframe data, including limited mainframe report development.
Development of training materials for new computer programs and training staff on software use;
Liaison between Purchasing and Technology Departments for changes and upgrades to programs, and implementation of new programs, including assisting with development of data feeds between programs.