Technical Lead / Business Intelligence & Analytics Application Architect Resume
Broomfield, CO
SUMMARY:
Seasoned Business Intelligence & Analytics Applications Data Integration Architect who possesses over sixteen years of experience as an IT Professional, specializing in all phases of the Software Development Life Cycle (SDLC), for BI and data warehousing efforts, from gathering requirements to testing, data modeling, implementation, and support. Highly skilled configuring, analyzing, modeling, customizing, extending, and implementing Oracle Business Intelligence Warehouse Applications (OBIAW). Extensive knowledge of BI Data Visualization Reporting and ETL Tools, like (Tableau, OBIEE, BICS DVCS, DVD, ODI, and Informatica).
TECHNICAL SKILLS:
Business Intelligence Applications: OBIA/11g Application Suites, (OBIAW,OBIEE, EM, WLS), BICS DVCS, DVD), OTBI, Tableau Desktop & Server 10.x, 9.x.
Data Warehouse Applications: Oracle Business Intelligence Analytic Warehouse 11g (OBIAW), Data Warehouse Administration Console (DAC/11g).
ETL Tools: Oracle Data Integrator Enterprise Edition (ODI 12c/11g), Oracle Golden Gate 12c. Informatica Power Center (9.1/8.11).
Programming Languages: SQL, PL/SQL, C/C++, ER, NER, RPGLE, RPGIV, and CL
Operating Systems: Linux, UNIX, OS/400/38/36, Windows Server 2012/2008.
Databases: Oracle Database (12c/11g), DB2/400 MS/SQL Server.
Database Utilities: SAP Query, Toad, SQL/Developer, AS/400/Query & DBU.
Data Modeling: Oracle SQL Developer Data Model.
P.C. Software: Microsoft Office Tools (Excel, Word, Project and Visio).
PROFESSIONAL EXPERIENCE:
Confidential, Broomfield, CO
Technical Lead / Business Intelligence & Analytics Application Architect
Responsibilities:
- Manage full life cycle of BI project efforts, to deliver on - time, on-cost, on-requirements, and on- quality.
- Responsible for implementing best business practices, manage project team spanning custom development while at the same time deliver under the budget.
- Deploying and Configuring OBIA Applications Suite (OBIAW, OBIEE, BIACM, FSM, ODI, EM, WLS, BIP), financial Analytics (GL, AR, AP), supply chain and manufacturing analytics, on top of Oracle E-Business Suites (EBS/R12.1.3).
- Technical Lead Installing and configuring OBIEE12c on High Availability (HA) active/active Load Balancing (LB) environment. Upgrading OBIA/OBIEE11g platform to OBIEE12c, including artifacts (RPD, web catalog, application role security etc.).
- Build and deploy OBIEE12c Business intelligence Archive (BAR) file, using OBIEE Lifecycle Management (LCM) administration and BI-Tools Command Line Interface (CLI).
- Technical Lead building Tableau 10x, 9x solutions (Workbook, Dashboard, Story board) from the ground up that are visually stunning, scalable, and very fast.
- The Tableau workbook data visualization profit and sales analysis included interactive KPI’s and dashboard (Maps, Region, State Profit, and Commission Percentages). Lead the integration of Tableau and mapbox. Wrote mapbox API’s to be used on maps sales and profit visualizations.
- Mentor Business users on tableau reporting design.
Confidential, Naperville, IL
Senior Business Intelligence & Analytics ApplicationArchitect
Responsibilities:
- Deploy and Configured OBI A Applications Suite ( OBIAW, OBIEE, BIACM, FSM, ODI, EM, WLS, BIP ).
- Financial Analytics(GL, AR, AP) Supply Chain and Manufacturing Analytics, for Oracle E-Business Suites (EBS/ R12.1.3). Provided end to end BI solution, scheduling and organizing BI fit/gap analysis sessions with end users, to identify business processes requirements, enhancements, and given a solution to fit the gap (specifications, customization, ODI/ETL/mapping, answers reports and dashboard).
- Wrote complex SQL queries to research and analyze source to target data issues. Scheduled meeting with end user for dashboard data validation.
- Customize OOTB/OBIEE analysis, prompt and dashboard to meet customer requirements.
- Technical Lead building Tableau 10x, 9x solutions (Workbook, Dashboard, Story) from the ground up that are visually stunning, scalable, and very fast.
- The Tableau workbook data visualization analysis included interactive KPI’s and dashboard (Maps, Region Profit, and Commission Percentages, Time Series, Filters and drill down Hierarchy).
- Create SQL/views, combined and blend multiple data sources, to build Tableau analysis like (Oracle, SQL Server and Excel), including BI/DW fact and dimension tables.
- Extensive knowledge of Tableau server administration. Participation on the installation, configuration, and troubleshooting of on-Premise Tableau Server.
- Demo Tableau dashboard visualization to top management, and end-users. Converted OBIEE financial analysis, KPI’s including dashboard to Tableau visualization.
Confidential, Miami, FL
Senior Consultant Business Intelligence Applications Architect
Responsibilities:
- Installed, and configured OBIEE/11g, and ODI/12c.
- Migrated ODI/11g to ODI/12c, Architecture Infrastructure (Repository, Data Server, Physical and Logical Connections and Context).
- Reverse-Engineer Metadata Data stores into ODI Data Models Repository.
- Designed, wrote and implemented E-LT Interfaces, Mappings, PL SQL, SQL Stored Procedures, and analytical functions to load and maintain data into a custom (BI/EDW) Ship to Shore Start Schema, using ODI Studio Application Development Tools.
- Wrote complex SQL queries to research and analyze source to target data.
Confidential, Miami, FL
Managing Consultant / OBIA Application Architect
Responsibilities:
- Manage full life cycle of multiples BI project efforts, to deliver on-time, on-cost, on-requirements, and on- quality.
- Build end to end Project Plan.
- Responsible for implementing best business practices, manage project team spanning custom development while at the same time deliver under the budget.
- Manage the installation, configuration, analysis, and customization of Oracle Business Intelligence Data Warehouse Applications (OBAW, OBIA, OBIEE, DAC, Informatica).
- Build Oracle EBS Trade Management star schema, and integrated to OBIAW, delivering specifications, customization, ETL/mapping, RPD customization, OBIEE KPI’s, answers analysis and dashboard.
Confidential
Senior Package Solution Consultant, Business Intelligence, and Data Warehouse Applications
Responsibilities:
- Technical Lead building financial OBIA/OBIEE analysis and dashboard (GL, AR, AP, and Profitability), Supply Chain Order Management Analytic (SCM), Human Resources Analytic (HR), and Enterprise Asset Management (EAM).
- Wrote complex SQL queries to research and analyze source to target data issues.
- Provided end to end BI solution scheduling and organizing BI fit/gap analysis sessions with end users, to identify business processes requirements, enhancements, and given a solution to fit the gap (specifications, customization, ETL/mapping, answers reports and dashboard).
- Build DW Logical and Relational Modeling including DDL using oracle SQL Developer Data Modeler. Leaded building OBIEE Metadata Repository (RPD), (Physical, BMM and Presentation Layer), for a custom enterprise data warehouse.
- Troubleshoot OBIEE Application performance (Cache, Connection Pools, and Aggregate Navigations).
Confidential, Miami, FL
Senior Principal Consultant, Business Intelligence Architect
Responsibilities:
- Deploy and Implement Oracle Business Intelligence Data Warehouse Applications (OBAW, OBIA, OBIEE, DAC, Informatica).
- Developed custom interactive BI Finance, EAM and HR analysis/reports, metrics, KPI’s and dashboard, using OBIEE/Answers features, like pivot tables, columns and view selectors, graphical charts with drill-down navigation reports, including dashboard prompts.
- Customization of OBIEE/RPD ledger (Physical, BMM and Presentation Services) to accommodate customer requirements, including data warehouse table extension.
- Make recommendations to Business Intelligence Management for reporting system enhancements, process improvements, and innovation.
- Scheduled meeting with end user for dashboard data validation.
Confidential, Carmel, IN
Senior Business Intelligence Data Warehouse and ERP Applications Developer
Responsibilities:
- Deploy and Implement Business Intelligence Data Warehouse Applications (OBAW, OBIA, OBIEE, DAC, Informatica, and ODIEE).
- Implementation and development of Enterprise Requirement Planning (ERP) JD-Edwards Enterprise One (JDE/E1).
- Troubleshoot OBIEE Application performance (Cache, Connection Pools, and Aggregate Navigations).
- Developed OBIEE (Siebel/CRM) customers marketing segmentation and segment tree solution, RPD/metadata marketing metrics, using OBIEE/Answers features, like pivot tables, columns and view selectorsgraphical charts with drill-down navigation analysis/reports and interactive marketing dashboards.
- Integrate reports and dashboard with OOTB Oracle Siebel Analytics Marketing dashboard applications.
Confidential, Redwood City, CA
Principal Consultant, Business Intelligence Data Warehouse, and ERP Applications
Responsibilities:
- Full participation on the implement and deployment of Oracle Business Intelligence Application (OBIA, OBIEE, BI Publisher, ODI) for JDE/BI projects.
- Translated business requirements into business dimensional model (OBIEE/RPD/Metadata), dimensions, hierarchies, attributes and measures to achieve drill down functionality.
- Build DW Logical and Relational Modeling including DDL using oracle SQL Developer Data Modeler.
- Wrote ODI packages to automate daily and nightly processing of interfaces. Used ODI functions to get and FTP files to other systems, and send email alerts in case of interface or package failure.