SUMMARY

• Organize teams to provide world class support for internal and external clients around implementation of applications or providing analytical analysis and support.
• With 16 years of multinational companies experience with various ERPs, reporting tools and methodology, I focus to help organizations achieve higher standards of reporting including process change to enable capturing the data at the most optimal point ensuring the reliability and accuracy.
• Ensure continuous self development and team development through sharing knowledge and best practices.
• 8+ years of experience in Project and Product Management.
• 14 years experience in Financial Data Analytic area.
• Certified in SAFe Agile and project implementation knowledge of JIRA.
• Member of the PMI practice.
• Development of information experiences through tools like Tableau, Microsoft Power BI and Spotfire.
• Reporting tools like SAP BI/BW Data Warehousing, Report Painter, ABAP Query.
• Traditional ETL tools like Business Objects Data Services and Data wrangling tools like Trifecta.
• Experience in RDBMS through Oracle Databases, MySQL and Microsoft Access.
• SAP ERP FI/CO/SD (Module Certification training)/BW/BO.
• Ability to map integrations between real time data systems, legacy systems and their interphases in tools ranging from Visio to Oracle SQL Developer data modeler.
• ECC Material Management Module and Sales order processing (inquires, quotations and sales orders received by EDI interface).
• Salesforce Report design capabilities and knowledge of usage of Apttus plugin and CC360.
• Knowledge of Profitability Analysis Sap version 6.0.

TECHNICAL SKILLS

Dashboard tools: Tableau, Qlik, Power BI and Spotfire.

Other: SAP ABAP and Queries, BEx Analyzer, Business Objects Universe development.

Programming languages: HTML, XHTML,XML.

Intermediate knowledge and use of: SQL DDL, DML and TCL.

Content and Collaboration tools: Microsoft 365 SharePoint, Teams and Flow, Confluence.

Open source: Joomla and WordPress panels.

User acceptance tools: HP QC (ALM), Flow and JIRA.

Graphic tools: Visio, Adobe PhotoshopCS5, Adobe IllustratorCS5, Adobe Dreamweaver CS5.

Languages: Fluent in English and Spanish. Basic French.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Product Group Manager

Responsibilities:

• Leading the collection of data and metrics for the Projects we manage. Prepare roadmaps for the Portfolio of Products we deliver.
• Lead and coordinate intakes of Business Intelligence needs for the Financial, People Solution and Compliance Organization, gather feedback on improvements to the ad hoc reports and dashboards built and prioritize the list of changes that needs to be done.
• Monitor projects and releases are launched correctly and on schedule
• Lead Product owners that manage several products through their life cycles by leading different technical resources onshore and offshore.
• Oversee cross - functional team for migration of legacy applications.
• Document and provide knowledge transfer to the different level of customer service tiers for Application Security guidelines in Sharepoint or Confluence tools.
• Monitor and provide guidance to teams thro ughout the organization that look for Self Service Analytics.

Confidential

Business Intelligence Analyst

Responsibilities:

• Develop front end information experiences based on multi-platform databases that provide guidance and serve as a drive for better decisions in all areas of the company. For instance, Data Quality and Procurement expenditure dashboards.
• Assist users with questions on usage and best practices of the different softwares used in the Business Intelligence area such as Business Objects, Spotfire, etc.
• Admin Business Objects user groups on the legacy MTS side according to the security standards of the company.
• Gather requirements and deliverables with project managers and key users to translate that into actionable plans and designs, for data architects to implement a solution based on the current and future needs of the project.
• Coordinate the implementation of deliverables that modify databases in the legacy MTS side between data architects.
• Monitor daily data file loads for the legacy MTS databases in Data Stage Director between BW and Oracle.
• Design Business Object reports from creating dimensions and measures to scheduling automated outputs.
• Knowledge expert on the legacy MTS side of the database architecture collaborating with multidisciplinary teams in the design process of data structures that combine legacy MTS and legacy CHC data for different areas.
• Develop user programs with the objective of evolving the knowledge and practice of the community of Business Intelligence users from descriptive to predictive and prescriptive analytics.
• BI expert and designer for the Data Quality project and the ongoing MDM tool.

Confidential

Business Intelligence Analyst

Responsibilities:

• Coordinate efforts between different technical and functional areas to develop reporting solutions for decommissioning databases.
• Provide assistance and technical support for existing Business Object users in creation of New Reports.
• Analyze and provide solutions for Business unit and project teams
• Design dashboard systems to track Financial reporting solutions.
• Provide metrics of support tracking systems to higher management.
• Review BW information flows to customize and make adjustments to current state information flow to be able to deliver the appropriate reporting solutions.
• Develop and maintain technical documentation of different internal processes and update with related changes as new sources are added in the RDBMS solutions.
• Coordinate and provide training for Business Object users onsite and remote.

Confidential

Financial Reporting Optimization Project

Responsibilities:

• Coordinating the efforts of different technical and functional areas to develop a data warehouse in Oracle in order to merge information from different sources such as SAP ECC, Salesforce.com and legacy systems.
• Analyze financial, profitability and sales data to present and serve better reporting solutions to the Business Units in the organization such as Finance, Deferred Revenue Accounting on the MTS division.
• Lead and work with project members to complete project outlined scope, goals, deliverables, required sources, and timing through Joint Application Development Sessions.
• Review architectural RDBM solutions with ECC, BI & BW architects to deliver the appropriate solutions.
• Held review sessions in conjunction with technical teams onsite and offshore to optimize the solutions for transferring data files between RDBM Systems with Development Teams and Production Support Teams and propose best possible solutions for the process.
• Reconciliation methodology and processes identified and developed to meet the PRISM objectives.
• Review and design in conjunction with BI architects the adoptions needed to the technical projected solution after unitary testings as well track defects on each of the development and testing phases.
• Work with technical onsite and off-shore Development teams to ensure master data loads are done in a timely manner along with the reconciliation needed to be performed in the RDBMS, prior being released for user consumption.
• Pre-test staging and transactional tables in the RDBMS before releasing solution to user testing.
• Develop testing scenarios in coordination with users and managers to sign off each implementation change.
• Provide assistance and technical support for existing PRISM Business Object users in creation of New Reports.
• Design useful new Reports in the available MTS tools to create financial insight on the Business Unit operations.
• Develop and maintain technical documentation of the Project updated with related changes of the product as new sources are added in the RDBMS.
• Lead, create and coordinate follow up on the resolutions on the Remedy Tickets created for PRISM database.
• Support communication and presentations to Leadership Team regarding the PRISM Project.
• Coordinate and train super users in Business Objects skills, throughout different levels of expertise.
• Prepared and conducted training for delivered solutions and developed change management documentation for Internal databases and intranets.
• Track and provide milestones status of the project to the Leadership Team and upper management.
• Defined how results will be measured and complete a post-project evaluation to determine how timely results were achieved.

Confidential

Senior Business Analyst on ETEDS Project.

Responsibilities:

• Provided quality financial analysis of the current state of data using tools like Microsoft Access.
• Responsible for delivering the project business and technical requirements and develop implementation strategies and plans with business units and IT. Prepared functional and technical design specifications in adherence to the project and company standards. Developed test scripts for the solution in tools such as HP QC. Tested and tracked business cases in Development and Quality environments, for Data Analysis and validati on.
• Defined business cases and fed Project tracking systems, provided input and follow up to test planning and execution.
• Reviewed changes needed to the projected solution and track defects on each of the steps of the different phases.
• Analyzed data to review the processes and practices.
• Supervised the development work of various onsite and off-site development teams in the following areas BI/BW, CRM, ABAP.
• Document and provide knowledge transfer to the different level of customer service tiers.
• Prepared training manuals and develop documentation for Internal databases and intranets.

Confidential

Senior Business A nalyst.

Responsibilities:

• Lead technical and Business unit teams in JAD sessions to gather and document SAP requirements. Worked with both internal and external parties (Consulting and implementation partners, customers and prospects) to develop integration solutions, implementation strategies, training materials and best practices.
• Reviewed and developed methodologies for the accounting process integration on FI-CO and SD modules and the new RDBMS. Successfully executed Month end, quarter end and Year-end activities.
• Facilitate sessions in conjunction with the Technical teams to define the proposed Security user profiles for the use and report on the RDBMS based on key user roles and responsibilities.
• In conjunction with development teams planned and scheduled master data loads and databases prior to the release of the information.
• Perform detailed reconciliation analysis of business RDBMS through different tools such as Microsoft Access, Excel, and SAP modules (MM, SD, FI) feasibility design and integration of databases.
• Prepare detailed Functional Specification documentation with use cases, PowerPoint presentations, and other documents to explain requirements internally and externally.
• Worked on team leading the project to customize new vendor master data, payment terms, payment methods and house bank details.