SUMMARY:

• Senior Business Intelligence (BI) Consultant and Accomplished Project Manager with a strong record of delivering business and technical results across multiple industries, applying a tenacious desire to never give up. Practical knowledge and experience with the challenges and critical success factors involved in building and managing high - performance BI systems.
• Translates the customer’s needs into technical specifications, allowing for overall project integration.
• Applies innate, analytic intelligence and creative talents to offer a unique prospective on any project.
• Works comfortably in global environments, utilizing fluency in French and English.

TECHNICAL SKILLS:

BI Tools: BusinessObjects (Data Services, Universes, Upgrade Tool, Platform Administration, LCM, SDLC, Webi, Design Studio, and Analysis), Query Designer (BEx), BW, Tableau

Languages: Java, Python, Javascript, Shell

Databases: Oracle, SQL, Access

Systems: Unix, Windows

Methodologies: Agile, Scrum ()

WORK EXPERIENCE:

Confidential

Responsibilities:

• As a BI Consultant and Project Manager, provides key contributions to client engagements, working throughout the project lifecycle. Involved in all aspects of implementing new BI solutions or upgrading existing solutions, with contributions from impact analysis to operational support. Completed numerous projects, utilizing skills in the installation, configuration, administration, support, and application of BusinessObjects platforms. Served as a team manager to junior consultants, developing individual and team skills.

Confidential

Consultant and Manager

Responsibilities:

• Selected by customer to take on a struggling B2B project, due to ill-defined requirements, to allow business partners to access their KPIs on a corporate portal.
• Created a giant, yet high-performance, data mart by consolidating 10 marts together. Utilized expertise in requirements gathering to engage customer in discussions about the necessary data detail.
• Reduced the initial scope of the data by more than 70%, allowing the servers to handle data in a couple of hours rather than most of the day.
• As part of a team effort, methodically reviewed and changed every single query written in the specification file, in order to drive the project forward.
• Led team in identifying and fixing errors in the data flow and tables. Performed project work that included testing and validating requirements execution and administering the project lifecycle.
• Performed business requirements analysis, working with the key business user to define the structure of new Webi reports with the overall goal to accelerate report delivery. As part of a team effort, designed a metrics-driven strategy to create the necessary ratios while also eliminating many obsolete ones.
• Implemented projects in French, Spanish, and English, as requested.

Confidential

Responsibilities:

• Performed work that included the analysis of known issues, followed by the proposition of short- and middle-term solutions. Tested upgraded reports, and counseled on best practices and technical operations.

Confidential

Responsibilities:

• Managed the added complexities of a project staffed with junior people. In addition to the normal upgrade activities — installation, configuration, and testing — took on responsibility for project guidance, risk mitigation, and knowledge transfer.
• Managed team throughout the end-to-end project lifecycle, including installation, configuration, testing and QA, deployment, and documentation and end-user .
• Performed work that included an upgrade of 400 Webi reports to the BI 4.1 version, configuration of Webi’s publications, set up of the audit database and reporting environment, as well as the conversion and troubleshooting of 50 Deski reports.

Confidential

Responsibilities:

• Validated process steps, which were vital toward ensuring compliance with the Drug Authority, for a pharmaceutical company within multiple departments: Clinical, Research, Pharmacovigilance, Sales.
• Completed data management work that included data quality and security controls, as well as establishing Oracle data flows.
• Administered the BusinessObjects platform in regards to security, access levels, and users. Executed a change management plan to adjust for any necessary changes, without experiencing scope creep.
• Adhered to security regulations for user account and password management and access to sensitive data.

Confidential

Responsibilities:

• Completed upgrade while working with the Business Intelligence team to ensure a smooth deployment.
• Performed data integration work that included establishing an SSIS dataflow to meet a user’s unique needs, as well as information delivery work that included creating new BO reports, upgrading existing ones, and providing user support and .

Confidential

Responsibilities:

• Produced deliverables that included prioritizing tasks for a global, outsourced team, installing the interfaces within test and production environments, and developing at the command line.
• Utilized Toad to reduce the time and effort required to create queries that accessed Oracle and Argus tables.
• Evolved and unified the clinical studies qualification by authoring qualification and installation protocols (French & English) and developing shared qualification reports for all interfaces (French and English).

Confidential

Responsibilities:

• Performed activities that included: installation of ODI and OBIEE; creation of repositories, schemas, and tables; data capture and loading from diverse sources; as well as the design of OBIEE reports and tutorials.
• Internal Assignment: Installed, configured, and deployed Roambi over the Amazon cloud.
• Performed activities that included synchronizing tools with the existing OBIEE portal, creating views, and key users.
• Internal Assignment: Created an environment to demonstrate a prospective customer’s requirements.
• Configured a Hyperion Planning application that was successfully used as a presales demo.
• Conducted a gap analysis to identify the current environment and to align project with stakeholder needs.
• Administered users, dimension groups, and scenarios. Created new processes, including automated alerts.

Confidential

Responsibilities:

• Upgraded 80 universes and 380 reports, and authored a document regarding the complexity of each report in order assess upgrade costs.
• Modified and tested the Deski VBA bursters to take account of the new platform.

Confidential

Responsibilities:

• Developed the BusinessObjects universes and reports, and managed the installation and maintenance.

Confidential

Responsibilities:

• As part of the requirements gathering process, conducted business user interviews to define key stakeholder needs. Identified associated costs for the offered solution.
• Established a roadmap for the IT direction, and identified data flows between applications and possible upgrades.

Confidential

BI Developer

Responsibilities:

• Developed BusinessObjects reports, using the new Sales universe, for a recognized leader in healthcare products and services.
• Worked with the Sales Department to define the project requirements, and participated in intercompany and inter-team project management meetings to ensure upgrade efficiency.
• Created Webi reports, and sourced reports using data through the ERP and CRM systems. Trained users for program support.