We provide IT Staff Augmentation Services!

Bi Analyst Resume

Fort Worth, TX

AREAS OF EXPERTISE

  • ETL Development
  • BI - OLAP cube design
  • Data Modeling STAR schema
  • BI-Report design
  • PL/SQL and SQL
  • Oracle DW
  • MS Access
  • IBM-Cognos BI
  • Data Quality
  • Data Auditing
  • Requirements Building
  • Reporting

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

BI Analyst

Responsibilities:

  • Created and maintained STAR schema on Oracle database.
  • Developed Informatica ETL process for GM Sales information providing a companywide tool currently utilized for further analysis for strategic planning by senior management.
  • Advanced skills in Informatica Power Center, Cognos Framework Manager, event bursts, tabular SQL, scheduling and multi-dimensional cube design.
  • Converted several SAS and PL/SQL processes using Informatica creating new Oracle database tables, Informatica mappings, sessions and workflows.
  • Key team lead on upgrade project of all owned Cognos objects from Cognos 7 to Cognos 10 creating new Framework Manager models and sources to replace Cognos Impromptu models and files.

Confidential, Arlington, TX

Operations Manager

Responsibilities:

  • Collaborated with Data Warehouse data modelers, ETL teams and other business team customers to resolve report/data issues.
  • Coordinated deployment of Informatica workflows developed by the team to a production environment.
  • Enhanced business procedures as well as source-to-target data enhancements.

Confidential, Fort Worth, TX

Account Representative

Responsibilities:

  • Developed an automated process dat created data from AS400 green bar reports utilizing Monarch, a markup software, to extract the report summaries and load them to an MS-Access database.
  • Created an MS-Access database to import data from a flat file and load to master table dat was used to compile flat files sent to the third-party payment VISA payment system.

Confidential, Dallas, TX

Technical Support Representative

  • Provided technical support of tax preparation software to professional tax preparers. Performed troubleshooting to resolve difficulties with Windows OS, modem communications and printer errors. Explained tax calculations of the program and fielded other tax related questions. Chosen as a tester for the next years tax software version.

Confidential, Fort Worth, TX

Auditor

Responsibilities:

  • Evaluated, identified weaknesses and recommended improvements for internal controls on each engagement.
  • Automation of data entry to increase departmental efficiency.

Hire Now