We provide IT Staff Augmentation Services!

Business Intelligence Analyst/developer Resume

3.00/5 (Submit Your Rating)

Houston, TX

Hire Now

SUMMARY:

Data and Analytics professional with expertise in design and development of innovative BI solutions that exceed organizational expectations. Experience in various industry groups such as Health Care, Education, Insurance involving dashboard design, development, database development, data visualization, and data model design among others.

SKILLS:

RDBMS: Oracle, SQL Server, POST GRES

Operating Systems: Windows, UNIX, and MSDOS

Languages: C, PASCAL, COBOL, Perl, Visual Studio.NET in C#

Web Technology: HTML5, HTML, DHTML, and JavaScript

Utilities: MS - Office, SharePoint

Tools: TOAD, PVCS, DBA Studio, SQL Server Work sheet, SQL Loader, Developer 2000 Forms(Forms 5), SSIS

BI Software: OBIEE 12C , OBIEE 11G,OBIA 7964, OBIEE 10G, Q3Solutions IQ, Crystal Xcelsius, SAS 8(Using Enterprise Miner), Matlab, SAP Business Objects, Tableau 2019.2

PROFESSIONAL EXPERIENCE:

Business Intelligence Analyst/Developer

Confidential, Houston, TX

Environment: Tableau 2019.2, OBIEE 12C, 11G, SQL Server 2011, SharePoint, OBIA 7963, OBIA 7964Certified in EPIC Caboodle Data Model, EPIC Clarity Data Model - Resolute Hospital Billing

Responsibilities:

  • Extensive experience in design and development of high visibility dashboards and business critical reports using OBIEE 12C, 11 G, Tableau 2019.2
  • Work with back end specialists to create dashboards, OBIEE repository and Data Model design
  • Testing functionality and security of OBIA dashboards during 7963 to 7964 upgrade of HCM dashboard
  • Work with Business and team members to validate/customize OBIA 7964 HCM out of the box dashboard metrics (workforce, retention, recruitment)
  • Testing, Documentation, Data Validation, Performance Tuning,
  • Support for Oracle BI related questions, issues and requests
  • Expert in developing SQL Queries
  • Expert in requirements gathering and creating functional requirements document.

Implementation Specialist

Confidential, Louisville, KY

Responsibilities:

  • Design, test and execute database objects (schema, tables, views, functions, procedures) on Microsoft SQL Server / Oracle (8i, 9i, 10G) using scripts and tools
  • Create OLAP tables for the BI product by performing JOINS on relevant tables in the transaction database
  • Utilize ETL tools (SSIS, SQL Loader) to import data from diverse data sources (odbc,excel, as/400, csv, access, text) to the database.
  • Diagnose and troubleshoot problems that may occur during customer implementation.
  • Create web-based launch sites (using IIS) in local and remote locations.
  • Communicate with end users to fix issues, make additional changes, add new features
  • Support and maintain the product after implementation
  • Gather and document requirements from client for dashboard development
  • Create prototypes for dashboard design using OBIEE 10G Answers/Dashboards
  • Develop/Modify/Test Dashboards using OBIEE 10G
  • Tested and made modifications to the dashboards after upgrade to OBIEE 11G
  • Worked with Oracle to fix issues, tickets.
  • OBIEE's Guided navigation, pivot charts, view selector, dashboard prompts, conditional formatting were among some of the features used in development.

Tools: /Languages used: Microsoft SQL Server Management Studio(T-SQL),Microsoft Business Intelligence Development Studio, Query Analyzer, DTS Package, Oracle Enterprise Manager, DBA Studio, SQL Plus work Sheet, SQL Loader, PCAnywhere, Cisco VPN, Terminal Services, and Perl, SSIS.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship