TECHNICAL SUMMARY:

• MVS/ESA, UNIX, MS SQL Server 2016, WINDOWS XP/7/8/9/10, VM, VMS
• Business Objects XI R2/R3/R4.2 - Administration, Universe development (IDT/UDT, Webi Rich Client, Webintelligence, Xcelsius Dashboards, Infoview/BI Launchpad, BI Workspace development, Explorer, BOE installations, upgrades, and customization. BO Security (SAP/AD/LDAP/UX), Lumira.
• Crystal Reports 2012
• Spotfire 7
• MS Power BI (Pro)
• ETL tools: Data Stage, SAS DW Mgr, Informatica, PL/SQL
• ORACLE 11, SQLPLUS, PL/SQL, Oracle SQL Developer/TOAD
• DB2, DB2 Client Modules
• Netezza
• Teradata, SQL Assistant 9.2
• MS SQL Server 2016, MS ACCESS
• MS Office 2012, MS Excel, MS Visio, MS Teams.

PROFESSIONAL EXPERIENCE:

Senior Business Intelligence Architect

Confidential, Winston-Salem, NC

Responsibilities:

• Working as a Developed assorted applications in the SAP Business Objects and MS Power BI tool suites for various departments.
• Applications ranged from HR applicant tracking universe/dashboards (MS SQL Server DB), AP universe interfaced with Lawson tables (Oracle DB), and Surgical Implant Tracking universe from Epic DB (MS SQL Server).
• Created SAP BOE repository reports on universe, report, and group usage metrics used for BOE planning.
• Wrote Exam Room availability universe and Webintelligence reports based upon Epic’s Clarity DB. Application tracked exam room availability metrics across the enterprise.
• Created BI Workspaces POC for the Confidential .
• Created real time Power BI dashboards for Supply Chain hospital requisition/purchase order tracking and metrics.

Senior Business Intelligence Architect

Confidential, Columbus, GA

Responsibilities:

• Working in an EDW build project, using the Business Objects 4.1 Audit universe and the Sherlock repository analysis tools to an analyze the content of the entire R4.1 BO repository with the goal of migrating appropriate reports and applications to the Tibco Spotfire visualization and predictive analysis tool set.
• Created a suite of BO repository analytic reports and dashboards for the BO 4.1 Audit universe in Webintelligence.
• Also created a suite of custom Sherlock repository utilization analytics for use in measuring and managing the BO tool resources.
• Analyzed various legacy processes including bank card, Sales and Referrals, and BAI, and wrote the functional requirements documents to create new EDW applications utilizing Spotfire.
• Created Spotfire visualizations for the EDW Data Governance group for data lineage, data typing, EDW composition, BO universe dictionary, and the EDW Data dictionary. Made enhancements to BO environment and universes as necessary. Downloaded BOE 4.2 and configured it in the development environment.

Senior Business Intelligence Architect

Confidential, Alpharetta, GA

Responsibilities:

• Conducted an inventory of the current Business Objects R3.1 repository using the Audit DB and analyzed usage of universes, reports, connections, and user login trends.
• Based upon the repository review, the report inventory was reduced by 55%, universes were reduced from 28 to 16, with corresponding reductions in connections.
• Created a new report and universe folder and security structure based upon department usage.
• Also, reconfigured the existing user groups to reflect the new folder/security structure.
• Downloaded BOE R4.1 from SAP and created two new BOE release 4.1 instances.
• Migrated the BOE R3.1 repository structure using the Upgrade Management tool to the new BOE 4.1 test instance.
• Configured R4.1 instances for MS AD authentication, customized user group access to the BI Launchpad, and home page logos.
• Conducted user acceptance testing of release 4.1 functionality

Senior Business Intelligence Architect

Confidential, Ft Lauderdale, Fl

Responsibilities:

• Conducted a repository analysis of universe usage with the SAAMA repository diagnostic tool.
• Converted the MPE universe from derived tables to MS SQL Server DB.
• Added new tables and objects to 5 different universes, as well as pre defined conditions and time dimensions for additional fiscal reporting.
• Fixed universe parsing errors in numerous universes.
• Re wrote all Crystal reports on a dedicated server into Webintelligence and retired the instance, saving the company for paying an additional maintenance fee for a Crystal reports instance.
• Made recommendations to the IT leadership for best practices moving forward.
• Assisted other developers in testing BOE 4.1.

Senior Business Intelligence Architect

Confidential, Tallahassee, Fl

Responsibilities:

• Analyzed end clients existing Business Objects 3.1 configuration, repository metadata, and inventory to evaluate current procedures and practices and make recommendations to the client leadership for enhancements to the current production instance.
• Produced reports based upon BOE XI R3 audit database tables on online usage, number of publications, number of scheduled reports, reports using most processing time, reports not used, and reports most used.

Senior/Lead Business Intelligence Architect

Confidential, Miami, Fl

Responsibilities:

• Senior Business Intelligence architect and team lead for Fedex division. Completed upgrades of Business Objects from release 2 to releases 3.1 and 4.0.
• Designed BO architecture and security models, created BOE folder and group structures.
• Architected server configurations, modified XML in BOE config files, and customized the tool suite for company.
• Wrote UNIX shell scripts for BOE functions. Supported multiple BOE sites and instances across Fedex.
• Designed numerous universes using aggregate awareness, index awareness,
• Mentored other team members, as well as the division’s Business Intelligence customers.
• Designed Explorer information spaces using Explorer tool.
• Designed BO publications for Fedex sales and marketing teams utilizing dynamic data recipients, Xcelsius dashboards with division KPI’s for executive management and complex analytic and operational dashboards and reports from Oracle, UDB2, MS SQL Server, and Teradata data sources.
• Created additional scorecard visualizations in Tableau

Business Objects Architect

Confidential, Clearwater, Fl

Responsibilities:

• I developed a proof of concept (POC) application utilizing Business Objects Webintelligence with the SAP Business Warehouse (BW).
• Created Business Objects universes from the SAP Business Explorer (BEX) queries and resulting data cubes; created classes and objects from formulas for inclusion in universes, established hierarchies for report drill down, and worked with SAP BW personnel to streamline background BW queries.

Business Objects Universe and Reporting Lead

Confidential, Orlando, Fl

Responsibilities:

• Working in a Teradata/Oracle data warehouse environment with Business Objects XI R3 as the reporting tools, I gathered user requirements, wrote complex BO Webi and Rich Client reports for two different projects.
• The first project was the Simba supply chain and marketing initiative to unify all Disney merchandizing, inventory, and ordering across the company.
• Reporting tracks included financial, replenishment, inventory, and purchase order tracking.
• The second project involved various metric reports for the Special Events department.

Business Objects Universe and Reporting Lead

Confidential, Tampa, Fl

Responsibilities:

• As the Business Objects universe and report lead I Implemented Business Objects in a new data warehouse environment using the DB2 and SQL Server RDBMS.
• Duties included the setup of BO group, folder, and row level security using a combination of LDAP, BO, and SQL based solutions.
• Gathered data and reporting requirements for the clients MAP application.
• Wrote design documents for all BO universes and required reports, drafted the requirements for star schemas and BO universes with the project data analyst.

Business Objects Designer - Business Objects Reporting Specialist

Confidential, Santa Cruz, Ca

Responsibilities:

• Working in a property management and development company I wrote various reports based upon the real estate MLS (multiple listing service).
• Rolled out Business Objects on the company LANS using the BO Supervisor module.
• Used MS Access as the repository database. Developed Business Objects universes as needed

Business Objects Universe Designer / Administrator

Confidential, Sunnyvale, Ca

Responsibilities:

• Served as Corporate Business Objects Administrator migrating all (167) Confidential Business Objects production universes from a Sybase repository to an Oracle repository making changes necessary to the SQL in the universes to translate Sybase functions and SQL syntax to Oracle functions/syntax.
• Parallel tested all converted universes using production reports furnished by department report administrators.