We provide IT Staff Augmentation Services!

Senior Business Intelligence Developer Resume

Irving, TX

SUMMARY:

  • Accomplished technical professional with a demonstrated record of successfully completing large - scale enterprise-level reporting and information access projects within a business intelligence environment.
  • Specialize in using business requirements to conceptualize efficient designs and solutions in QlikView to help users better understand data and make better data-driven decisions.
  • Highly experienced developing different dashboards and reports using complex systems such as Qlinkview, Oracle Hyperion and Oracle OBIEE, with expertise in analysis, design, development, coding, testing, and implementation of business intelligence concepts.
  • Readily applies appropriate levels of security in QlikView application and personally tests applications to ensure deliverables meet client expectations.
  • Advanced communicator who works well with internal and external clients and stakeholders at all levels to understand business requirements, identify issues, and ensure full customer satisfaction.
  • Strong background in data integration design and development, data visualization and modeling, and business and data analysis across multiple subject areas and departments.

TECHNICAL SKILLS:

Operating Systems: Windows95/98/2000/NT/ 2003/2008/2012 R2, Sun Solaris 10/11.x

RDBMS: Oracle7.x/8.0/9/10g/11g, MS SQL Server 6.5/7.0/2005/2008

Oracle EPM: Oracle EPM 9.x/11.x - Hyperion Essbase, Hyperion Financial Reporting, Hyperion Interactive Reporting, Hyperion workspace, Hyperion Shared Services, SmartView, Excel-Addin, BI Office Plug-In Oracle OBIEE 10.x/11.x - Oracle BI Server, BI Admin, BI Answers, BI Dashboards, BI Interactive Dashboards, BI Publisher;

Data Discovery : Qlikview 10/11.x Tableau 9.0

Scripting: Java script, VB Script

Legacy Reporting: Visual Basic6, Forms 4.5 and Reports 2.5, Crystal Reports 9/10; Cognos 8.x/9.x

PROFESSIONAL EXPERIENCE:

Senior business intelligence developer

Confidential, Irving, TX

Responsibilities:

  • Assist the Confidential groups with the implementation of product performance dashboards that are used by the End User Services, Application Hosting, Software Asset Management, Planning and Core Functions groups.
  • Design and build the product performance dashboards for each group based on the functional requirements and provide the KPI’s that are helpful for the groups to carry out the day to day operations within the group.
  • Automation of the existing manual process for the data collection of the sources like Major incidents data, standard incidents data, financial data Etc.
  • Automate the month end refresh of the data from different systems into the Qlikview using the SQL like scripting that is available in Qlikview.
  • Provide insights of the KPI’s to product managers and help them analyze the data so that the product manager can work with the business operations, production operation teams.
  • Enhacements to the existing product performance dashboards based on the product manager’s approval.

Senior business intelligence developer

Confidential, Herndon, VA

Responsibilities:

  • Leading strategy and technology consulting firm.
  • Draw on deep technical expertise to transition into projects exclusively focused on QlikView software and application, primarily for improving reporting on enterprise systems and operations. Currently evaluating and enhancing internal reporting structures.
  • Provide help to different teams and business groups, including guiding the ERA group in updating and streamlining data and reporting (dashboards).
  • Additionally, participate in review sessions and demonstrations with business users then draft designs and solutions.
  • Partner with various teams and departments to obtain data used to create QlikView dashboards and reports.
  • Assist users in navigating dashboards, pivot tables, details results, and exports into Excel.
  • Develop SQL scripts for building summary tables and views using data from different sources and vital for QlikView analysis.
  • Assist with unit testing and UAT on report access problems, analyzing root cause of data issues, and user error source.
  • Document report logic and report navigation for end users.
  • Lead development of QlikView dashboards for all Enterprise Information Services sub-departments to replace manually maintained Excel reports, saving so much time that all reporting was automated using QlikView.
  • Designed and documented strategy for converting legacy reporting system and manually generated reports into QlikView.
  • Partnered with Marketing and Communications to design customized web analytics using data sourced from Google analytics using the QvSource Connector, information from Facebook using the Facebook Connector, and additional intelligence from various websites.
  • Improved performance by reviewing reporting process and teaching business users to troubleshoot issues with data, security, and user error.
  • Developed and implemented best practices such as development standards, modeling standards, and security models.

Hyperion reporting Developer

Confidential

Responsibilities:

  • Designed summary dashboard and detailed reports in Hyperion IR, validated data, established testing environment, identified root cause of data discrepancy, and provided end-user training on analyzing reports and exporting data from dashboards into Excel.
  • Key contributor in converting legacy Excel reports for Cigna Home Delivery into Hyperion Interactive Reporting (IR) dashboards.
  • Designed Hyperion IR dashboards and used Java Script to customize dashboards according to user requirements.
  • Developed SQL Server procedures to populate reporting tables and SQL scripts to build Oracle object tables and summary tables/views used by IR dashboards.
  • Designed data reporting models in Hyperion IR that enabled end-user adhoc drag and drop reports.

Confidential

Hyperion Reporting Developer/Administrator

Responsibilities:

  • Created users and groups in Hyperion Workspace and scheduled Hyperion IR reports to run daily.
  • Developed new reports for the Treasury Department, capitalizing on additional functionalities of the summit application.
  • Upgraded Summit to most recent version and resolved resulting issues, including modifying reporting inventory, creating new PL SQL stored procedures to read database, and reformatting underlying source tables in Oracle.
  • Limited impact of Summit upgrade and improved reporting functionality by adding new fields to reports and changing calculation logic.

Hyperion reporting developer/administrator

Confidential, Herndon, VA

Responsibilities:

  • Focused on helping create new reports for end users of Hyperion tool.
  • Delivered expanded reporting to acquisitions (for contracts management), finance, and HR teams.
  • Additionally, worked with Confidential internal teams to provide enhanced internal reporting.
  • Built data models for the acquisitions team with data sourced from sub-contract management systems.
  • Configured DAS to access relational data from different environments in Hyperion shared services, including DEV, QA, PRD, and user security.
  • Designed BQY documents based on functional requirements, created OCE files in Hyperion workspace, and defined users/groups.
  • Provided user training on data models, production support materials, and Level 3 support for Hyperion BIPlus Reporting.
  • Configured BQY documents as jobs in Hyperion workspace and scheduled files to be automatically emailed to user groups.
  • Extracted data from SQL server to Oracle database and built new tables/views, using the information to design adhoc data models using Hyperion Interactive Reporting for acquisition power users, people services, PBS, and SBS groups.
  • Developed dashboards for: Standard headcount reports per functional specifications as well as single/multiple selections using controls.

Hyperion reporting developer/administrator

Confidential, Birmingham, AL

Responsibilities:

  • Partnered with retail/credit card unit to enhance existing Hyperion reporting application used for assessing employee performance to also calculate retain incentives.
  • Worked with IT team and business process unit. Project was primarily maintenance focused with minor upgrades/changes.
  • Enhanced and improved existing retain incentives system using Hyperion Essbase.
  • Designed data flow for inputs into Hyperion Essbase cubes for incentive calculations.
  • Defined data load rules and created MaxL scripts.
  • Performed end-user training that covered analyzing reports as well as other data analysis such as slice and dice of the cubes.
  • Provided user support with reporting fixes, Excel addin fixes, and data validations.
  • Created Hyperion interactive Reporting dashboards for the PORTFOLIO and RISC business groups that were based on user requirements.
  • Developed retail incentives systems applications (using Hyperion reporting applications) for retail financial planning group.
  • Designed data flow architecture governing input of data into Essbase for automatic calculation of retail incentives.
  • Streamlined reference bonus calculation by developing process for retain incentives calculations according to business requirements.
  • Oversaw installation of Oracle EPM Fusion Edition on the sandbox with the components Foundation Services, Essbase, Reporting, and Analysis. Configured repositories, application servers, users, and groups.

Hyperion reporting developer/administrator

Confidential, Warren, NJ

Responsibilities:

  • Supported Basel implementation to improve analysis and reporting technology; used Basel Standards (rules and policies).
  • Personally loaded finance and risk data into Hyperion Essbase and built fact and dimension tables in Oracle.
  • Developed simple, medium, and complex calc scripts in Essbase to shape business logic.
  • Authored Excel add-in reports as part of user training.
  • Enabled the production of significantly better reporting capabilities via Basel implementation.
  • Key contributor in IT group achieving implementation that met new compliance standards.
  • Drove user success and enhanced production support team’s success by documenting the end-to-end process of cube building.
  • Led development of Hyperion Interactive Reporting Dashboards for finance and risk users.
  • Created medium-to-complex formulas to execute business logic.
  • Implemented user-defined SQL - Template SQL script to load data into the cube.
  • Set transformation rules within the OLAP Meta outline based on requirements like filtering records and concentrating fields.
  • Added Excel addin reports to user training and documentation.
  • Documented end-to-end cube build process for operations/production support teams.
  • Wrote SQL scripts that built views/tables for specified requirements and used in Hyperion Integration Services in dimensional tables.
  • Developed OLAP Model for finance and risk cube using tables/views, creating dimensional hierarchies in OLAP Meta Outline.
  • Improved user-defined data load SQL by implementing the parallel and default hints in Oracle.
  • Created .cbs scripts, which are scheduled in Autosys, for the automation of cube build.
  • Optimized data load, database calculation, and database retrieval using industry-best techniques.
  • Developed SQL scripts to validate cube data against the relational source data.
  • Based on user requirements, developed drill-through reports in EIS by defining Intersection levels from each dimension and defining drill-through report columns.
  • Assisted with requirements gathering for relational reporting, developed TSDs based on Hyperion interactive reporting.
  • Designed data models in interactive reporting that allowed end-users to produce drag and drop reports.
  • Developed Hyperion interactive reporting dashboards, using Java Script to customize dashboards according to user requirements.
  • Enhanced security in shared services by creating users/groups and assigning the right access privileges.
  • Produced Java Scripts that enabled drill-down functionality, from reporting summary pivots to selected details.
  • Initiated the strategy and oversaw execution for migrating Hyperion Brio 8.5 Reports to Oracle EPM 9.3.
  • Installed and configured system 11 on sand box for testing and validation of new version features.

Hyperion reporting developer/administrator

Confidential, Dallas, TX

Responsibilities:

  • Leading consumer and healthcare company.
  • Active contributor to the Corporate Reporting Group, focusing on implementing, maintaining, and upgrading Hyperion applications and tools to improve reporting capabilities.
  • Led migration from Hyperion Essbase 6.5 to 7.1.6, with authority over reporting, testing, end-user training and support as well as documentation of pre- and post-migration strategies.
  • Upgrade provided new/better functionality that improved reporting for the end user.
  • Ensured data integrity by developing scripts that validated the Essbase Cubes after migration.
  • Engineered management reporting cube for the Canada business segment using data from mainframes.
  • Developed calc scripts to implement business logics, dynamic dimension building scripts, and calculation scripts and implemented the transformations business logic using the data prep editor.
  • Created simple to medium member formulas to derive and ensure accuracy in calculations.
  • Designed MaxL scripts that automated daily GL transaction data to upload into the cube.
  • New capabilities include income statements, profit and loss statements, and balance sheet reports.
  • Directed modification of existing Brio dashboards, customizing current dashboards to in corporate business segment requirements and requests.
  • Improved security by modifying user profiles to align with access restrictions defined by corporate reporting.
  • Developed/modified filter that governed access restrictions at the cell level.

Hire Now