Business Analyst Resume

TECHNICAL SKILLS:

Microsoft SQL Server - various versions

IBM - DB2 & DB2 BLU, iSeries, AS/400

Amazon - Redshift & SQl Server

Oracle-versions 9, 10, 11

SAP Hana

MySql-Free version and also Enterprise version

Teradata

SQL Tools-Aqua Data Studio, Toad, Oracle, MS SQL Developer

Cognos Analytics - version 11.0 thru 11.0.6

Cognos Add In for Microsoft Excel - Café

Cognos: versions 8, version(s) 10.0 to 10.2.2

Cognos Enterprise Planning- v 8.4

Framework Manager, Report Authoring, Query Studio, Analysis Studio, Cafe

Cognos Transformer for modeling and creating cubes

Tableau version 10

Active Directory (AD) security maintenance

Deltek Costpoint Government Contract Billing

Server Administration

OBIEE - Oracle Business Intelligence version 11.1

Service Now Ticketing Application

Sharepoint-Utilized for support & documentation

MS Office: Including Project, Excel, Visio & PowerPoint

EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

Member of the IT Services Management team, preparing detailed excel reports and charts for upper management, coordinated various projects and online meetings for new software deployments, develop BI reports using MS Power BI, updates to corporate application inventory databases, updates to Sharepoint sites.

Business Intelligence Consultant

Confidential

Responsibilities:

Short term remote assignment to assess clients Cognos 10.2.2 environment, install Cognos Analytics version 11.0.7.
Developed detailed recommendations and reviewed with key Confidential IT employees and Cognos developers.
Conducted numerous training sessions in framework manager best practices and building cubes using Transformer.
Project was completed within the client’s 2 month timeline.

Business Intelligence (BI) Developer/Admin/Project Analyst

Confidential

Responsibilities:

Support Cognos Analytics version 11 & version 10.2.2 environments for Development, QA/Test, Production
SQL Data Analysis using UCSD provided tools
Project Analyst/Manager on numerous financial related projects
Develop Framework Manager meta data models/packages (15+) leveraging data from many databases
Cognos Report Developer creating numerous reports and executive dashboards
Created numerous cubes (10+) using Transformer which were for financial reporting.
Gather User Reporting requirements for reports, dashboards and cube design
Configure & publish Tableau Data Sources and custom views
Collaborate with end users to develop Tableau reports and charts
Create Technical documentation to assist Cognos and Tableau developers
Report and resolve technical issues with IBM support for Cognos 10.2.2 and Cognos Analytics v11
Primary Cognos administrator for version 10.2.2 responsible for applying fix packs and ad hoc issues

BI Developer/Financial Project Analyst/Administrator

Confidential

Responsibilities:

Responsible for supporting all aspects of BI including Administration, framework models including dimensional models (DMR)
Supported Enterprise Planning budgeting
SQL Data Analysis using Microsoft tools
BI Report Developer models including dimensional models
Supported Financial Analysts, Accounting staff and sales department
Supported & installed CAF (Cognos Add in for Microsoft Excel) for financial analysts

BI Consultant/Project Analyst

Confidential

Responsibilities:

Assisted Confidential clients with their BI Cognos reporting requirements
Mentored and trained client employees on BI best practices for report writing & framework manager
Data Analysis utilizing client provided client provided software tools
Clients included Rancho California Water District and Vistage
Prepared technical documentation based on client s data & environments

BI Consultant

Confidential

Responsibilities:

Assist in the implementation of the Kuali ERP applications
Met with USC staff to document their BI reporting requirements
Mentor USC IT staff on BI report development & best practices
Data warehouse Analysis and prepare technical documents

BI Consultant

Confidential

Responsibilities:

Assisted Confidential s client Confidential with implementation of Oracle Financials & OBIEE
Conversion of Cognos Enterprise
Planning budgeting data into the Oracle Financial reporting suite of products
Created technical documentation on the methodology used in the conversion processes and steps
SQL Data Analysis using Oracle tool set

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship