Analytics Solution Architect Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Experienced on Oracle’s overall BI product footprint: Oracle Analytics Cloud (OAC), Oracle Autonomous Data Warehouse (ADW), Oracle Data Visualization, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA) and Oracle Data Visualization Cloud Service (DVCS). Extensive experience with OBIEE (OAC/BICS) RPD modeling/Report development, data warehousing concepts and data mapping.
- More than 20 years of experience in system analysis, design and development of enterprise wide application; 23 years in data modeling, data washhouse and ETL design; 18 years in Oracle Business Intelligences Enterprise Edition (OBIEE, formerly Siebel Analytics) and Oracle Business Intelligence application (OBIA, formerly Siebel Analytics applications)
- Oracle Business Intelligence Foundation (OBIEE) Certified Implementation Specialist with extensive experience in multiple engagements across industries and common business processes in lead roles implementing Oracle Business Intelligence Enterprise Edition cloud and on - premise (OAC/OBIEE, formerly Siebel Analytics) components in standalone configuration or as part of the Oracle Business Intelligence application (OBIA, formerly Siebel Analytics applications).
- Excellent balance between technical and business process skills: Able to interact with users and business owners across multiple industries and business processes, while still maintaining a deep technical competency to interact with technical teams.
- Self-reliant and quick to identify and understand business problems and develop solutions; Strong communication skills in a client-facing role; in addition to team leadership, provide hands-on delivery.
PROFESSIONAL EXPERIENCE
Confidential
Analytics Solution Architect
Responsibilities:
- For a large hospital system in South Florida that has a robust OBIEE 11g implementation of OBIA 7.9.6.4 led technical effort to upgrade to OAC: Worked with this client before implemented OBIA 7.9.6.4, so I had a deep understanding of client’s OBIEE environment and process so I was able to developed recommendations to achieve similar goals in OAC also developed alternate solutions when a desired goal cannot be achieved with out of the box OAC products.
- For a Manhattan-based not-for-profit organization that provides vocational training and employment resources to those who face barriers to employment: designed and built a General Ledger, Sub-Ledger and Account Receivables BI applications in Oracle BI cloud services (BICS) sourcing data from Oracle Fusion Applications Cloud and OTBI; responsibilities include: design ETL, model metadata, design and develop reports and dashboards.
- For a higher education institution in the Midwest: designed and built a financial aid BI application in OBIEE 12c sourcing data from PeopleSoft and custom-built data warehouse, responsible for model RPD metadata.
- Worked in multiple engagements designing and building custom reports, analysis and dashboards from scratch as well as utilizing “out of the box” items where possible or as a jump off for customization in Oracle Transactional Business Intelligence (OTBI)
Confidential
OBIEE Server Architect Consultant
Responsibilities:
- Leverage knowledge of current data warehouse and software development methodologies along with a good understanding of Oracle pre-built BI applications to contribute to the overall planning of project by recommending approaches, identifying resources, and developing timelines.
- Translate high-level business requirements into a logical business dimensional model and define key metrics, dimensions, hierarchies and attributes while conducting gap analysis to maximize utilization of out of the box functionality.
- Help configure BI Applications, lead fit/gap session and design, build, test the solution.
- Customize the RPD (Physical, Logical, Presentation layer) including hierarchies, security
- Customize pre-built dashboards and reports, OBAW meta data, web catalog and deploy web catalog, rpd
- Enhance BI server metadata based on business requirements for custom BI application and extend Oracle Business Analytics Warehouse (OBAW) and led the design of customization to ELT mappings.
Confidential
Analytics Solution Architect
Responsibilities:
- Worked on client engagements as a subject matter expert on Oracle’s overall BI product footprint (OBIEE 11g/12, Oracle BI applications version 7.9.6.4 and Data Visualization Desktop) and Tableau.
- Led efforts involving analysis, design, development, testing, documenting, implementation and support of new and existing business intelligence applications and solutions, using the OBIEE 11g/12c.
- Participated in business intelligence application/architecture design and development reviews as appropriate to ensure working within appropriate technology/standards. Responsible for helping establish best practices, standards, and architectures working with co-development leads/Developers.
- Managed team of technical resources (both onsite and offsite) and ensure project delivery.
- Extended BI App version 7.9.6.4 modules: Financial Analytics and Project Analytics; responsible for extending out of the box RPD metadata for the design and develop custom reports and dashboards; led the design and development of customization to extend Oracle Business Analytics Warehouse (OBAW) Informatica ETL mappings and DAC execution plans.
- Built custom BI application sourcing data from Essbase ISO reporting cube with planning data and CapEx planning cube; responsibilities include: model RPD metadata, develop reports and dashboards.
- Worked on proof of concepts on Big Data projects building advance analytic/BI visualization using Tableau Desktop 10 and Oracle Data Visualization Desktop 12.
Confidential
Analytics Solution Architect
Responsibilities:
- Worked on client engagement as a subject matter expert on Oracle’s overall BI product footprint (OBIEE 11g and Oracle BI applications version 11.1.1.8.1 and 7.9.6.4)
- Implemented the following Oracle BI applications (OBIA): Financial Analytics, Supply Chain and Order Management Analytics, Procurement and Spend Analytics, Human Resources Analytics, Manufacturing Analytics and Project Analytics for clients in manufacturing and health care industries sourcing data from Oracle EBS R12 and PeopleSoft 9.1.
- Leveraged knowledge of current trends in BI and data warehouse project methodology along with good understanding of Oracle pre-built BI applications to contribute with overall planning of projects by recommending approaches, identify resources, and developing of timeline.
- Responsible for understanding business requirements, defining the solution formulating the design and leading the implementation of complex BI solutions that include OBIEE and Oracle BI applications.
- Configured OBIEE and Oracle BI Applications (OBIA), leads fit/gap and design sessions, architects the solution and develops and delivers the end-to-end solution.
- Customized the RPD (Physical, Logical, Presentation layer) including hierarchies, security, etc.
- Worked closely with the team lead, to understand the functional requirements. Helped define the ETL approach; developed ETL technical specifications for integrations with OBIA.
- Managed team of technical resources (both onsite and offsite) and ensure project delivery.
Confidential
Senior Consultant/Senior Product Specialist
Responsibilities:
- Worked on client engagements as a subject matter expert on Oracle’s overall BI product footprint (OBIEE 10g/11g and Oracle BI applications version 7.9.6.3 or later solutions)
- Implemented the following Oracle BI applications (OBIA): Financial Analytics, Supply Chain and Order Management Analytics, Procurement and Spend Analytics, Human Resources Analytics and Project Analytics for clients in the oil, manufacturing and health care industries.
- Led all aspects of OBIEE/OBIA implementation and architects the overall Business Intelligence solution based on customer needs.
- Leveraged knowledge of current data warehouse and software development methodologies along with a good understanding of Oracle pre-built BI applications to contribute to the overall planning of project by recommending approaches, identifying resources, and developing timelines.
- Translated high-level business requirements into a logical business dimensional model and define key metrics, dimensions, hierarchies and attributes while conducting gap analysis in order to maximize utilization of out of the box functionality
- Enhanced analytics server metadata based on business requirements for custom BI application and extend Oracle Business Analytics Warehouse (OBAW) and led the design and development of customization to Informatica ETL mappings and DAC execution plans.
- Supported sales team through providing implementation estimates, assist with proposals, Demos and participate in client interviews.
- Installed OBIEE 11g, OBIA ((version 7.9.6.3 or later) and Informatica ETL/DAC platform components in Development, Test and Production Environment sourcing data from Oracle EBS R12 and JD Edwards.
- Experience using OBIEE to support both real time and DW reporting.