We provide IT Staff Augmentation Services!

Lead Architect Resume

SUMMARY:

  • Confidential is a Senior Level Certified BI/DW Solutions Architect with several years Data Warehousing and Business Intelligence experience.
  • He has more than ten (15) years of experience in Business Intelligence including Cognos, OBIEE, OBIA, DataStage, Informatica, OWB, and ODI.
  • He has completed seven (7) BI implementation projects.
  • He also has recent experience implementing Cognos in EPM and OBIA environments.
  • His OBIA experience includes Financial Analytics, HR Analytics, and Procurement & Spend Analytics.
  • He also has experience with Campus Solutions Intelligence Analytics the precursor to Student Information Analytics in OBIA.
  • His full life cycle experience including requirements gathering, functional and technical specifications, architecture, design, data modeling, development, data mapping, data migration, ETL/ELT, security, installation, configuration, performance tuning, disaster recovery, documentation,, and support.
  • He has held multiple roles including BI/DW Solutions Architect, Team Lead, Functional Lead, Report Developer, RPD Developer, ETL/ELT Developer, Administrator, and Programmer.
  • Designed and implemented Dimensional Data Modeling, Star Schema methodologies, ROLAP (Relational Online Analytical Processing), and MOLAP (Multidimensional Online Analytical Processing)
  • Installed and configured software ( Confidential DataStage, Infostage/OBIEE 11.1.1.xx); EPM setup and configured; developed/configured OBIEE RPD; configured, verified, and developed reports of OBIEE/OBIA dashboard for CSW/FMS/HCM Warehouse Intelligence
  • Designed and developed Data Warehouse and Data Mart design using Star Schema methodology; worked with clients’ requirements; configured, developed, and modified OBIEE RPD applications to suite client requirements
  • Designed and implemented change management strategies; provided leadership and mentored full - time employees on building successful change management process; managed teams including additional change, communication, and and deployment resources to achieve successful adoption of the change; determined barriers to change and worked with leaders to develop appropriate intervention measures
  • Successfully led development, testing, and deployment of OBIEE dashboards, analysis and raw programming data (RPD) and security, WebSphere, DataStage, and QualityStage ETL maps, PeopleSoft EPM foundation objects, data model, and extracted logics of EPM data marts; Toad Business Intelligence Suite (Toad data point and Toad intelligence central).
  • Built and configured the Enterprise Performance Management (EPM) rule and metadata components and developed custom software needed to map, validate, reconcile, and enrich data brought into the EPM environment.
  • Experience with the ETL Data quality and Master Data Management products, implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM hub implementation
  • Designed developed and implemented Master Data Management Solution Customer Party MDM Domain
  • Identified, analyzed, and modified the vanilla ETL/ELT maps for non-customized PeopleSoft tables; refreshed the source transactional database with current production data

KEY SKILLS:

  • Cloud Intelligence
  • Data Warehouse
  • Business Intelligence
  • Project Management
  • PeopleSoft Enterprise Performance Management
  • FMS
  • SCM
  • Campus Solutions
  • Global Consolidation
  • Activity Based Management
  • HCM
  • Budgeting and Planning
  • Projects
  • Student Information
  • Application Engine
  • PeopleCode
  • Query
  • Data Mover
  • Integration Tools
  • Integration Broker
  • Application Designer
  • Financial Analytics
  • Student Information Analytics
  • HCM Analytics
  • Project Analytics
  • SCM Analytics

TECHNOLOGY/TOOLS EXPERIENCE:

  • Discoverer
  • OBIEE
  • Confidential Websphere/Datastage
  • OBIA
  • EBS
  • Fusion
  • Weblogic
  • Tableau
  • OWB
  • Taleo
  • BI modeler
  • BI Cloud
  • PAAS
  • Enterprise Manager
  • Jasper Source
  • Erwin
  • OTBIE
  • APEX
  • Banner
  • DBAAS
  • BI Publsher
  • Cognos
  • Informatica
  • Microsoft SAS

PROFESSIONAL EXPERIENCE:

Confidential

Lead Architect

Responsibilities:

  • Subject matter expert driving solutions technology while managing requirements gathering and documentation.
  • Liaison between offshore and onshore resources communicating requirements and concurrent efforts
  • Mapping the lineage documentation of core application source systems (Fusion, EBS, and PeopleSoft) to Business intelligence Analytics layers.
  • Lead Design and creation of Human Capital management and Financials Logical and Physical models
  • Lead Design and creation of Human Capital management and Financials Analytics Subject Area models
  • Lead Design, development and testing of ongoing artifacts to meet requirements gathered.
  • Leading the development of Oracle business intelligence cloud application ( Confidential ) and Platform as a Service (PaaS) implementation.
  • Ensuring design, development and testing work is completed to standard and on time.
  • Captured and documented management business intelligence requirements from clients, via meeting sessions or documentation, ensuring suitable balance of business needs and delivery feasibility.
  • Co-coordinating on-shore and off-shore business intelligence development Teams.
  • Configuration and managing of the Business Intelligence Applications Configuration Manager (BIACM)
  • Worked on migration, deployment and performance tuning of repositories.
  • Created Data Visualization using mashups
  • Created design specifications and project documentation’s
  • Catalog and Data Model Snapshots and management
  • Developing and maintaining the core data model, identifying and documenting data sources, and maintaining the meta data repository
  • Development and support of BI dashboards, answers, analysis.

Confidential, Houston, TX

Solutions Architect & Managing Consultant

Responsibilities:

  • Managed the Implementation and Development of Cognos using PeopleSoft EPM 9.1 as the Data Warehouse and PeopleSoft HCM 9.2 and FSCM 9.2 as the source system.
  • Work with clients and other internal resources to effectively communicate, design, plan and implement capabilities that provide value to customers.
  • Work with key stakeholders and understand their needs to develop new or improve existing solutions around data and analytics.
  • Activities include solution demonstrations and prototypes; customer meetings and technical presentations; account technical support; software installations/evaluations; application compatibility determinations; assessment of business problems and identification of solutions.
  • Part of the Data Science Innovation team that works closely with external clients in all phases of the prototype development for OBIEE, OBIA, ODI, DataStage.
  • Mentor and train individuals who are new to the PeopleSoft EPM and Cognos.
  • Led Development and support of operational and ad-hoc reports using the Cognos tools which include Framework Manager, Transformer, Query Studio, Reporting Studio, Metrics Studio, Events Studio and Cognos SDK (Software Development Kit).

Software Version & Environments: OBIEE (Oracle Business Intelligence Enterprise Edition 11.1.1.9.1 ), OBIA (Oracle Business Intelligence Applications 7.9.6.4), Cognos, Ellucian Banner, PeopleTools, nVision, PS Query, ODI (Oracle Data Integrator 11.1.1.9.1 ), WebLogic server to 10.3.6, Confidential WebSphere DataStage and QualityStage version 8.5

Confidential

BI/Data Warehouse Manager

Responsibilities:

  • Leading and managing the BI team support and upgrade efforts of Confidential Cognos (Report Studio, Framework Manager, Cognos Transformer, and Configuration Manager) and OBIEE development efforts and upgrade.
  • Planning and installation of OBIEE (Oracle Business Enterprise edition)/OBIA (Oracle Business Intelligence Applications) and ODI (Oracle data Integrator) 11g for HR and Financial Analytics
  • Responsible for managing, coordinating, directing, and facilitating the day to day affairs of the data warehouse team consisting of the Data Delivery and Reporting team.
  • Managing the daily incident and service requests of the data warehouse team.
  • Responsible for design and development of analytic reports, performance and data integrity, business requirements are properly addresses by solutions.

Software Version & Environments: OBIEE (Oracle Business Intelligence Enterprise Edition 11.1.1.9.1 ), OBIA (Oracle Business Intelligence Applications 7.9.6.4), Cognos, Ellucian Banner, PeopleTools, nVision, PS Query, ODI (Oracle Data Integrator 11.1.1.9.1 ), WebLogic server to 10.3.6, Confidential WebSphere DataStage and QualityStage version 8.5, Linux, Unix s, Banner ODS, OWB

Confidential, Miami, Florida

Senior Manager - OBIEE, OBIA

Responsibilities:

  • Responsible for leading technical and functional requirements gathering, design, development, and testing of Oracle Project Analytics, Procurement and Spend, Oracle Financial Analytics.
  • Major responsibilities included administration and managing the RPD, OBIEE dashboard and analysis design and developments.
  • Developing and Executing Data Governance & Data Planning and Strategy Programs Including planning resources (Onshore/Offshore), day to day operations, and tasks
  • Holds meetings with business users to gather requirements and advises accordingly on reporting strategies
  • Responsibilities included planning resources (Onshore/Offshore) day to day operations and tasks.
  • Meetings with business users to gather requirements and advise accordingly on reporting strategies.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Trained and transferred knowledge to client’s full-time employees.

Software Version: OBIEE 11.1.1.9.1 , OBIA 7.9.6.2, ODI, WebLogic server to 10.3.6, Oracle EBS 11&12g, Informatica, SQL Server, Linux, Unix

Confidential, Atlanta, GA

OBIEE/EPM Solutions Architect

Responsibilities:

  • Responsible for facilitating, directing, and communicating directly with end client business and technical stakeholders to understand the information sought from reports and dashboards and the nature of the available data sources feeding the reports
  • Implementation and Development of Campus Solutions Intelligence Analytics (the Precursor to OBIA Student Information Analytics - SIA) including ETL Development, RPD Development, and Reports & Dashboard Development.
  • Included planning resources (Onshore/Offshore), day to day operations, and tasks
  • Held meetings with business users to gather requirements and advise accordingly on reporting strategies
  • Trained and transferred knowledge to client’s full time employees
  • Used ETL tools and data warehouse concepts to transform data into Oracle 11g databases so that it was optimized and normalized for reporting in a data warehouse
  • Worked with stakeholders to understand and prioritize commitment to the changes
  • Installed PeopleTools 8.52 for Campus Solutions 9.0 including patch releases and related support software
  • Installed and configured OBIEE 11g and EPM 9.1 CSW Warehouse and deployed EPM 9.1 RPD w/ Catalog
  • Created DataStage Projects and imported CSW DSX files including Installation Verification Test for EPM 9.1 CSW
  • Validated and verified Requirements including customizations (CS 9.0 Object and Data Changes)
  • Built, configured, and loaded EPM Warehouse including audits of EPM Objects, identification of Load Jobs OWS to MDW and OWE to MDW Jobs, and Configuration & Confirmation of EPM Foundation
  • Loaded Converted CS 9.0 Data into EPM Foundation and remaining OWS, Common Dimensions, Global Dimensions, MDW, Local Dimensions and confirmed Overall EPM Foundation Configuration
  • Designed, and developed OBIEE Reports and delivered Dashboards and modified RPD
  • Built and migrated EPM/OBIEE Hierarchies and Load Trees in EPM
  • Major Milestone was completion of EPM Warehouse Configuration, Build and Load
  • Performed Data/Report Verification and Testing
  • Prepared documents and deliverables, reviewed final outcome and deliverables

Software Version: OBIEE (Oracle Business Intelligence Enterprise Edition 11.1.1.7.1 ), PeopleTools, nVision, PS Query, WebLogic server to 10.3.6, Confidential WebSphere DataStage and QualityStage version 8.5, Linux, Unix environments

Confidential, Houston, TX

Senior Managing Consultant

Responsibilities:

  • Responsible for the Business Intelligence Division tasked in designing and implementing interactive reports and dashboards using Oracle Business Intelligence Enterprise Edition Exalytics
  • Designed and developed BI reports to meet client’s requirements
  • Created custom Data Models including ETL and RPD for Analytics.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports Developing and Executing Data Governance & Data Planning and Strategy Programs
  • Work with the team and mentoring on MDM best practices and assist with enhancement of their skill sets.
  • Ensured BI Publisher quality of development deliverables by applying proven testing methodologies
  • Project Type: Implementation and support, Software: OBIEE (Oracle Business Intelligence Enterprise Edition 11.1.1.7.1 ), OBIA (Oracle Business Intelligence Applications 7.9.6.1), PeopleTools, nVision, PS Query, ODI (Oracle Data Integrator), Toad Business Intelligence Suite (Toad data point and Toad intelligence central), Oracle EBS (Enterprise Business Suite) 11&12g, Informatica, Unix environments, Modules: PS Financials and HCM, Oracle

Confidential, Tallahassee, FL

Business Intelligence/EPM Lead

Responsibilities:

  • Responsible for mentoring developing business rules, data lineage, audit and data mapping standards to meet user requirements
  • Leading and conducting all walkthrough reviews for data mapping and ETL and OBIEE reports. Design and developed detailed project plans and technical specifications for ETL maps and OBIEE dashboard
  • Created and developed functional and technical reporting scenarios and scripts for unit and integration testing’s
  • Integrate Maps with OBIEE and Designed World level OBIEE Maps
  • Design and developed Data warehouse and data mart design using Star Schema methodology
  • Working with client’s requirements, configured, developed and modified of OBIEE RPD applications to suite client requirements

Software Version: PS9.1 OBIEE 10g/11g Confidential WebSphere 8.1

Confidential, Cedar Falls, IA

Business Intelligence/EPM Lead

Responsibilities:

  • Team lead responsible for the planning, managing, and supporting the Installation and configuration of Oracle Business Intelligence Enterprise Edition (OBIEE) versions 10g upgrade to 11g
  • Maintenance of Confidential WebSphere DataStage and QualityStage version 8.1, PeopleSoft Enterprise Performance Management (EPM) 9.1 software’s from General Availability (GA) release to Maintenance Pack 3 (MP3)
  • Integrate Maps with OBIEE and Designed World level OBIEE Maps. Implemented, Design and developed Data warehouse and data mart design using Star Schema methodology

Project Type: Upgrade, Software Version: PS 9.1 OBIEE 10g/11g Confidential WebSphere 8.1

Confidential, Houston, TX

Business Intelligence/EPM Lead

Responsibilities:

  • Responsible for the planning, managing, and supporting the Installation and configuration of Oracle Business Intelligence Enterprise Edition (OBIEE) versions 10g and 11g, Confidential WebSphere DataStage and QualityStage version 8.1, PeopleSoft Enterprise Performance Management (EPM) 9.1 software’s
  • Implemented, Design and developed Data warehouse and data mart design using Star Schema methodology
  • Leading development, testing and deployment of OBIEE dashboards, analysis and raw programming data (RPD) and security, WebSphere DataStage and QualityStage ETL maps, PeopleSoft EPM foundation objects, data model and extract logics of EPM data marts

Software Version: PS9.1 OBIEE 10g/11g Confidential WebSphere 8.1

Hire Now