SUMMARY:

• 20 years of experience in general IT; 18 years of experience in Business Intelligence administration and development.
• Strong in multiple disciplines including automation, scripting, report design, data warehousing concepts, system administration, and troubleshooting.
• Infrastructure design and administration experience using Business Objects Enterprise, Tableau Server, Microstrategy Server, Cognos TM1, and QlikView Server.
• Designed and administered 8 - node Business Objects Enterprise cluster which supported 72,000 unique monthly users while at Confidential Financial.
• Designed and administered a globally accessible Business Objects Enterprise cluster with multi-tenant security requirements for Confidential .
• Implement Single Sign-On using Kerberos to authenticate against Active Directory for multiple employers.
• While at Confidential, optimized queries and Tableau workbook design to improve user experience; dashboard load times reduced from 35 seconds average to 1.5 seconds average.
• Built and maintained Business Objects universes, from standalone single-table design to universes containing 180 tables, 3500 objects and multiple contexts for multiple employers.
• While at Confidential, designed a dynamic join mechanism using Aggregate Awareness to flip between inner and outer joins, removing a critical roadblock for BPXA’s adoption of Business Objects.
• At Confidential, worked with web portal developers, DBAs, and report developers to implement a single-pass report bursting solution to send personalized report packages to clients.
• Worked with Confidential web portal developers to upgrade their Business Objects SDK code to newer versions as part of regular upgrade processes.
• Regularly participated in development, troubleshooting, and strategy discussions to provide technical expertise and offer a technical opinion.
• Creation of batch files and scripts to automate routine tasks, gather and assess metrics, control system services, automate account management, assist with auditing, and automate disaster recovery processes.
• Work with Java developers to integrate BI platforms into custom web portals by modeling processes and methods, creating functional code samples for the developers, and assisting with troubleshooting.
• Learned basic concepts of Cognos TM1’s TurboIntegrator language to manage daily loads, perform dynamic weighted average calculations, and generate data feeds for other BI tools.

EXPERIENCE:

Confidential, Greenwood Village, CO

Lead Business Intelligence Administrator

Responsibilities:

• Administrator of Business Objects, SAP Data Services, and Tableau applications and servers used by internal and external customers. Total footprint for each application was:
• Business Objects - 23 servers across all environments
• Tableau Server - 12 servers across all environments
• Data Services - 16 servers across all environments
• Redesigned Business Objects infrastructure to support future growth, high availability, and fit within Confidential ’s Disaster Recovery protocols.
• Upgraded the External Business Objects reporting environment from XI 3.1 SP5 to XI 4.1 SP2 with minimal impact to approximately 16,000 users and their ~250,000 report instances.
• Participated in Confidential ’s bi-annual disaster recovery exercises; responsible for failing all production instances out to the DR site and troubleshooting any issues that arose.
• Coded a POC using Tableau’s JS API to demonstrate a method for changing between dashboards without tabs, automatically exporting workbooks, and changing dashboard visibility based on user interactions.
• Assisted web portal developers with adding new Business Objects functionality to their web portal, including publication scheduling, multiple CMS server support, and improved session handling.
• Assisted Tableau developers with troubleshooting Tableau performance issues.
• Used the Business Objects Java SDK to automate routine admin tasks, such as:
• Disable report processing during the nightly reporting database refresh
• Look up all content owned by a user across all BO instances (used for audits / terminations)
• Automatically purge inactive users who owned no content
• Automated Tableau user administration using CSV files, VBScript, and tabcmd commands.
• Participated in daily Scrum calls and Epic planning meetings.

Confidential, Englewood, CO

Application Engineer, BI Specialist

Responsibilities:

• Merged parallel production Business Objects platforms, XI 3.1 and XI 4.0, into a single instance.
• Worked with management to drive BI adoption by simplifying and reorganizing the Business Objects content, improving navigation, and adding additional capabilities such as Mobile BI.
• Installed, configured, and administered Cognos TM1 to support the Finance & Accounting project.
• Conducted performance tuning sessions on Cognos TM1 with developers to ensure the system and metadata models were continually capable of providing sub-second response times.

Confidential, Denver, CO

BI Contractor

Responsibilities:

• Improved stability and performance of Business Objects XI 3.1 and XI 4.0 production platforms by enforcing best practices, performance tuning, patching, and automating routine admin tasks.
• Implemented a scalable, personsalizable single-pass report bursting system for subscription-based scheduled report sent to approximately 850 external clients on a daily basis.

Confidential, New York, NY

Global BI Engineer

Responsibilities:

• Primary Microstrategy administrator for the Global / Confidential Microstrategy cluster; backup admin for the Microstrategy EMEA cluster
• Second tier administrator for Microstrategy servers in Asia Pacific and Mexico
• Worked with local Microstrategy administrators to upgrade all servers to version 9.2.1 without impacting the local users.

Confidential

BI Platform Manager

Responsibilities:

• Administered the Confidential Business Objects Enterprise environments.
• Technical lead on the BI re-platforming project.
• Worked with BI reporting teams in Confidential, Maxus, Mediacom, and MEC to determine current and future BI needs.
• Evaluated vendor offerings, and provided recommendations to senior management.

Global Business Objects Administrator

Confidential

Responsibilities:

• Built and administered the Confidential Global Business Objects Enterprise environments.
• Designed and implemented a scalable multi-tenant security model, including delegated administration, corporate and geographical hierarchies, security roles for content and application access, and data security down to cell-level.
• Upgraded from Business Objects XI R2 to Business Objects XI 3.1 to take advantage of custom access levels, simplifying the multi-tenant security model and improving maintainability.

Confidential, Anchorage, AK

Senior Software Engineer

Responsibilities:

• Worked with British Petroleum Exploration Alaska (BPXA) to develop and implement a long-term strategy to migrate 1,600 user from BrioQuery to Business Objects XI R2.
• Partnered with stakeholders and advocate to understand users’ need and challenges with BrioQuery and determine how to resolve them with Business Objects.
• Developed universes and reports for BPXA’s Finance Control and Accounting group. Reports were used for data validation, daily operations, internal reporting, and as part of mandated response to the Federal Energy Regulatory Commission (FERC).

Confidential, Tinton Falls, NJ

Software Engineer supporting

Responsibilities:

• Upgraded Business Objects Enterprise from version 5.1.7 to version 6.5.1 + Enterprise Performance Management.
• Customized Moai CompleteSource, a reverse auction e-commerce application, to meet various federal and Confidential regulations.
• Customizations included additional reverse auction formats, customized UI, improved auditing, and an uploadable Excel-based pricing ‘wizard’.