We provide IT Staff Augmentation Services!

Business Intelligence Specialist Resume

SUMMARY:

  • Design and implement business solutions using Business Intelligence, Advanced PL/SQL, Database Technologies.
  • Develop customized applications and business intelligence reports.
  • Work diligently, catching on to new information quickly and frequently pursuing additional skills.
  • Lead projects with exceptional oral/written communication and problem - solving skills.
  • Analyze database structures and create objects utilizing advanced database languages, ETL processes, and Oracle development tools.
  • Reporting Services ( Microsoft BI Stack SSRS/SSIS/SSAS and Oracle BI Report) |Power BI | BI Publisher Interactive Web Reports |
  • Customized Dashboards| ETL Data Processing

TECHNICAL SKILLS:

Languages: SQL, Transact SQL,PL/SQL,XML, HTML, JavaScript, C#, Unix Scripting

Platforms: Snowflake, Azure Dev Ops, Microsoft SQL Server(SSIS/SSRS/SSAS), Oracle, Unix

Applications: Microsoft Power BI, Oracle E-Business Suite, BI Publisher, Oracle Forms/Reports, Oracle Workflow Builder

Databases: MS Server 2005-2016, Oracle 8i R12

Tools: Visual Studio 2010-2017 MS Versioning, MS Flow, MS Teams, SQL, Python, R, Jdeveloper, PL/SQL Developer

EXPERIENCE:

Confidential

Business Intelligence Specialist

Responsibilities:

  • Leading BI software development, deployment, maintenance report curation and data modeling
  • Developed robust core framework for analytics platform
  • Creation of data visualization and interactive dashboards in Power BI
  • Data Warehouse design document meta data storage and technical documentation for BI tools.
  • Created visualizations, reports and dashboards for requested projects
  • Maintain File storage via Azure

Confidential

Business Intelligence Specialist

Responsibilities:

  • Designed, built and deployed BI solutions with SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS) and SSAS
  • Translated business needs to technical specifications
  • Evaluated and improved the existing BI systems
  • Developed and executed database queries and conducted analyses
  • Created visualizations, reports and dashboardsfor requested projects
  • Developed and updated technical documentation

Confidential, Broomfield , CO

Senior Programmer / Analyst

Responsibilities:

  • Developed, maintained and supported application programs for Reporting Services Department.
  • Performed Data Modeling and Design of Interactive Web Reports, Dashboards with Oracle BI Publisher 11g..
  • Processed ETL Data from Oracle 11g database.
  • Developed Database Objects utilizing advanced PL/SQL and SQL.
  • Maintained and developed Crystal Reports utilizing Microsoft SQL Server(SSRS).

Confidential, Denver, CO

Software Developer / Analyst

Responsibilities:

  • Performed Software Development work for Confidential s Clients on the East Coast.
  • Responsible for the creation of Reports, Conversions, Interfaces, Extenstions.
  • Developed Procedures, Packages and Functions for Oracle EBS R12 utilizing PL/SQL .
  • Created custom WEB ADI integrators for HR module.
  • Maintained code for CWB Compensation Work Bench.

Confidential, Aurora, CO

Oracle Federal Financials Developer

Responsibilities:

  • Designed and developed a Claims Disbursement Application utilizing Oracle Forms 10g, Oracle R12 Database and Advanced PL/SQL skills.
  • Built Federal Financial Reports to interact with Claim Forms using Oracle Reports 10g.
  • Developed SFIS compliant GL Data interface for existing Oracle Apps 11i - Modules AP, AR, PO.
  • Processed ETL Data from legacy applications using Unix Shell Scripts and Advanced PL/SQL.

Confidential, Lakewood, CO

Oracle Developer

Responsibilities:

  • Supported Oracle Applications 11i EBS. Created designs in compliance with all Federal DOE regulations.
  • Developed Federal Financials Module utilizing PL/SQL.
  • Worked in Oracle 11i Modules GL, AP, AR, Assets, Cash Management, Project Costing, Project Management, Treasury.
  • Deployed, tested and developed custom reports, forms, and workflows in Unix Environment.

Confidential, Denver, CO

PL/SQL Developer

Responsibilities:

  • Developer for several local Confidential client projects.
  • Customized Dashboards within Oracle's Project Accounting Module for forecasting Revenue, Expenditures and Cost.
  • Created the workflow process for expense reports utilizing Oracle Workflow Builder.
  • Resolved defects fixes, provided on call support and trouble shooting.
  • Developed a Data Warehouse interface utilizing Microsoft SQL Server (SSIS/SSRS), (T-SQL), PL/SQL, and JavaScript to support Data Modeling for ARCA reporting solution.
  • Performed Extract, Transform, Load-ETL processes for the Data Warehouse.
  • Tracked and coordinated testing and related activities for assigned projects.
  • Supervised Offshore and Onshore Test Team members.
  • Reported to Project Manager on issues effecting team’s ability to complete deliverables on time and successfully pass testing phase.
  • Developed new functionality and resolved defect fixes within Oracle Siebel CRM Applications 7.8. for Call Center application .
  • Created and maintained custom Siebel eScript routines used to extend the application.

Confidential, Englewood , CO

Programmer/Analyst

Responsibilities:

  • Responsible for Administration and Reports Development of Oracle EBS Applications.
  • Configured and validated setups in Oracle EBS 9i/11i modules-Finance, CRM, HR, Manufacturing and Inventory.
  • Workflow creation and maintenance, custom setups, and CRM Alerts.
  • Creation of database constructs using PL/SQL.

Hire Now