SUMMARY:

• My specific OBIEE (10.1x - 11g) experience has been in the Applications (7.6-11.9x), DAC and ETL (Informatica 7x-9x) for companies.
• The positions have been Architect, Technical + Project Manager, DBA, Developer in the Supply Chain, Order Management, Inventory, Sales, Service, Service Contracts, Human Resources, Financials applications.
• Over 16 years of experience in information technology with at least 15 of those years in data warehousing, data marts, and data management.
• I have designed, deployed and supported several large (3-500TB) and complex data warehouses and marts.
• I have extensive experience developing dimensional models for data in VLDB’s with real-time, batch, historical and bulk data environments.
• I have experience as an Oracle (versions r5c-11g) DBA (on sites with hundreds of databases - > 500) with proven experience with a large range of Oracle, Confidential, MS, Informix, Pick RDBMS and data warehousing tools in many operating environments including Linux, Sun Solaris, UNIX, AIX, HP/UX.
• I also have many years practicing global and local partitioning and indexing of various database objects.
• I have over 10 years of experience with SDLC processes, focusing on the requirements (BRD), analysis (SRD), development (DDD), Testing (SIT, ST, UAT) and Knowledge Transfer (KT) phases.
• I have reviewed data and technology architectures and designed key application projects to ensure alignment with the enterprise standards, multiple source-target architecture and roadmaps.
• I am detail-oriented with excellent documentation skills combined with extensive experience and judgment to plan and accomplish goals.
• I can consistently and predictably deliver on the plan
• I institutionalize a culture of review and refinement to improve processes and practices to optimize results and increase efficiency.
• I have an exceptionally strong track record in successfully managing and executing large projects ($3-300 million level) coupled with strong verbal and written communications skills and the ability to articulate the benefits of a testing and quality assurance program to all stakeholders while successfully working with cross-functional teams (ex: process, development, product management, etc.)
• I have extensive e xperience in operations, quality assurance, release management, full product life-cycle methodologies (CMMI, Agile, Scrum, etc.) and project management (SLDC, Agile).

SKILLS SUMMARY:

• RDBMS 5 - 11g
• Triggers
• Packages
• ODI (Data Integrator) 10-12
• Oracle Fusion MW
• BEA + WebLogic
• J/Developer
• Data Cleansing, Profiling
• OBIEE (7-11x)
• Pro*C
• OLAP 10-11g
• Oracle Applications (10-12)
• Partitioning
• Answers/Dashboards
• XML
• PL/SQL
• DBA (DB2 + Oracle 5-12g)
• Materialized Views
• Discoverer
• Data Modeling
• Data Conversions-Migrations
• Data Warehousing
• Indexing Strategies
• Confidential 6-9x PeopleSoft 9x
• UML Modeling
• RAC
• EBS (mfg, fin, hr, scm/om, svc)
• RICE1 CEMLI2
• Financial Reporting
• General Ledgers
• Payables
• Receivables
• Sales Analysis
• Cost Accounting
• Earned Value MS
• Performance Measures
• Managerial Accounting
• Property Management
• Tenant Management
• Construction Accounting
• CRM
• Lease Management
• Unix/Linux + shells
• Solaris + shells
• Cognos 7-8x
• EA/Sparx Modeling
• Quest TOAD
• MS Project
• Quest SQL*Impact
• Quest SQL*Lab Xpert
• Microstrategy 8x
• Quest Spotlight
• SAP PowerDesigner Modeling 16x
• Awk, Sed
• JIRA (Althassian)
• PVCS Version Control
• Perl
• Hyperion (5- 11x) Essbase
• C & C++
• Crystal Reports
• Microfocus COBOL
• Behavior + Identity Profiling
• ErWin Data Modeling
• Visio
• Business Objects (5-xi)
• HTML (JSP)
• Informatica 5-9x
• ETL + BI tools
• MS Office tools
• Pick
• Datastage (5-7x)
• Windows/2008-12 Server/10
• Java
• JavaScript
• Vi
• Affinium/Unica (Marketing)
• Apache WS
• Project Management
• SQL Server (db,ssis,ssas,ssrs)
• Jython
• Remote Desktop/VPN

EMPLOYMENT HISTORY:

Data Architect + Senior Oracle Data Integrator and Business Intelligence Applications

Confidential, Sunrise, FL

Responsibilities:

• Configured and Deployed ODI with custom work extending Confidential v 11.1.1.7 for the company’s service network of providers, along contracts, compliance and warranty coverage on Exadata Oracle 11.2.0.4 on 2 nodes with 4 TB of data and scalable to 70 TB.
• Designed new and refactored Answers reports to improve performance (reduced load time from hours to 2:30 hours) and scalability (introduced ELT design patterns to do incremental and SCD loads based on XACT/SNP/Aggregations and conformed dimensions) for their multi-state sites and off site offices/call centers that provide customer support using a custom version of EBS, a modified in-house web portal.
• They support over 600,000 customers in many states around the clock and manage over 4,000 providers who help their customer’s home appliances and other service products for groups like Sears, HMS and others.
• My role covers many areas from modeling new data extensions to adding entire schemas to improve performance using parallel programming for ELT workflow and tracking EBS 11.5.10.1 defects or data correction tasks.
• These efforts were monitored using JIRA by Althassian, SQL*Developer and Modeler, Oracle Data Integrator (11g/12c), OBIEE Answers and Publisher, Microsoft Project and Visio.
• Migration of entire load plans between development, QA, CI (continuous integration) and production.
• Trained staff in ODI ELT, modeling, topology configuration, security, Web Logic servers, Enterprise Manager Grid.
• Designed hybrid data ecosystem patterns for the management to express their data virtualization initiatives that the company was adopting.
• The effort was to integrated telephony data with web services with financial data with claim and contract data with chat data and many other subsystems.

Senior Oracle Data Integrator and Business Intelligence Applications

Confidential, Houston, TX

Responsibilities:

• Configured and Deployed OBIEE Confidential 11.1.1.9.1 for the Confidential International (commercial motors, pumps, electronics distribution and VAR services); implementing high performance tuning techniques, deployment strategies, reporting architectures, scheduling practices.
• Configured, coded/customized ETL and deployed Confidential with Oracle Data Integrator.
• Confidential modification based on EBS 12.2.2 (manufacturing, service, financials, projects, procurement, supply chain) on HP Super Cluster running Exadata, OBIEE and RDBMS 11.2x. Unix virtual machine systems.
• The project manages the entire supply chain, order management, bill of materials of their motor and pumps business for the oil and gas business model.
• This is a state and national implementation of a specific business sector for Confidential International Corporation (Motors and Drives Division, Power Electronics Division, Energy Transmission and Distribution Division) which serves the mining, oil/gas, power utilities, water/wastewater, agribusiness, medical, aggregates/cement, food/beverages and pharmaceuticals and pulp and paper industries. The project cost is over $75 million.

Senior Oracle Data Integrator

Confidential, Madison, WI

Responsibilities:

• Installed and configured Oracle Confidential OBIEE sourced from PeopleSoft 9.2 offerings of Financials, Projects, Procurement, Supply Chain Management (FSCM), Human Capital (HCM) and Learning Modules (LM) for the state of Wisconsin with the goal of consolidating all of the state agencies (50); implemented and extended Oracle Data Integrator (ETL) 11g (11.1.1.8.1 ) and customized it to support development, test and production environments under Oracle Exalytics, Exadata and Exalogic 12.
• Enhanced the OBIEE data model (set of > 4800 tables) that is sourced from PeopleSoft 9.2 (> 70,000 tables) and modified countless mappings to support State requirements, wrote numerous how-to manuals to explain the data modeling changes and deployment strategies from interfaces, packages, scenarios, variables, functions, procedures, knowledge modules, load plans, domain data mapping, data load parameters; extensive use of agile processes to track changes to the > 6000 dashboard reports, prompts, dashboards, customizations, security
• Implemented data lineage (from source to target following the SDE/SIL/PLP patterns3) from source to target and loaded the results as a web page attached to the main menu
• Conducted knowledge transfer sessions and group configuration sessions; extensive use of modeling tools such as Sparx EA 11-12.from OLTP to ODI stages, persistent stages and dimensional star models, hierarchies and aggregates. Conducted knowledge transfer (KT) sessions for operators and support; prepared custom technical documents to control changes to OOTB OBIA ETL for deployment and to permit painless upgrades (deployment checklists and modification steps.).

Senior OBIEE + Data Warehouse Architect

Confidential, Galveston, TX

Responsibilities:

• Design a large scale data warehouse based on Kimball’s Methodology using Oracle RDBMS 11gR2 on Exadata servers and OBIEE 11g on Linux servers.
• Designed dimensional structures to support regulatory agencies (Centers of Medicare and Medicaid Services) regarding evidence-based intervention statistics.
• This involved the development of data structures to support the segmentation of the target population based on geography, medical encounter, demographics, financial class, medical diagnosis, insurance coverage, diagnostic ontology (icd9/10) of what has become known as Delivery System Reform Incentive Payments ( Confidential ) for the State of Texas.
• This is a federally-sponsored pay-for-performance initiative with the triple aims of better care for individuals (including access to care, quality of care, health outcomes), better health for the population and lower cost through improvement and innovation.
• The Confidential program transitions supplemental funding to a rewards-based payment structure that is contingent on achieving well-defined health improvement goals.
• My role as the architect was to design a robust database structure that would extract, transform and load data from relational and other 3rd party products such as Clarity from EPIC (i.e., software publisher for mid-size and large medical groups, hospitals and integrated healthcare organizations), web services and survey products like the Confidential results into federated schemas so as to deploy a custom RPD based on subject areas and KPI’s to support the reporting requirements of the project.
• The scope of the data was 10-years using hierarchical data structures to pivot the data into baseline sets along the month, quarter and yearly cycles.
• Also I developed structures such as dashboards, Answers reports and KPI structures to support targets and monthly results against these targets and be able to demonstrate progress along the state and federal Confidential guidelines.
• I also implemented the structures using financial classes, ICD9 diagnostic and procedural codes based on inpatient and outpatient encounters at hospitals and clinics.
• The general patterns used here were population segmentation, financial class segmentation, demographics, ETL, data integration, heterogeneous environments, big-data designs for medical flow sheets, large-scale medical diagnostic and procedural ontologies, data cleansing and MDM architecture for foundational data stores.

Senior OBIEE + Data Integrator Project Lead

Confidential, Ada, MI

Responsibilities:

• Lead the development of ELT4 (Extract Load and Transform) based extensions to a global business intelligence project for their products, sales, marketing, financials, order management and supply chain management following SDLC control methods (BRD, FDD, TDD templates) amongst other deliverables using an iterative agile methodology, take ownership of the workflow from the source systems (AS/400, Confidential, Oracle EBS, SQL Server applications and IMS) to the presentation subject areas that OBIEE delivers on a web interface using Oracle Data Integrator (ODI version 10x-11x) using a global data warehouse model.
• There are several operating systems (Windows, UNIX, Linux, AIX, HPUX, AS/400) where Oracle is mounted on an Exadata service with > 100TB of storage for all the instances and environments (DEV/TEST/QA/PROD) and business segments (atomic, key, operational data store, stage and data warehouse areas).
• Modeling was done using Sparx’s Enterprise Architect.
• These systems service their world-wide operations including the Euro-zone, the Americas and the Asia Pacific zone.
• The data follows a cross functional federation and integration model. Manage a team of 3 F/T ETL developers and support the organizations internal business and IT staff.
• Used probabilistic and deterministic identity resolution and profiling services via derived behavioral analysis for credit and marketing worthiness.
• The impetus for the project comes from the executive officer’s awareness that mature markets require analytical support and that a global enterprise needs to be able to crunch trends and develop forecasts in a very small time frame so that they can react to the ever changing market forces that the 21st century are presenting with the rapid rise of Confidential markets, the maturing North-Central-South American and European segments that include Russia.
• The project has various phases which began in 2011 with final delivery in 2015.

Senior OBIEE Business Intelligence Architect + Developer

Confidential, Saint Paul, MN

Responsibilities:

• Develop a complete OBIEE full cycle system deployment for MnDOT based on their proprietary operational and financial systems. The practice is based on the agile project management methodology
• Written gap requirements gathering, designed OBIEE (11.1.1.3-11.1.1.6 x) dashboard Answers prompts and reports
• Developed Oracle Data Integrator 11g Topologies, knowledge-modules, ETL interfaces, scenarios, packages, functions, knowledge modules, procedures and schedules and migrations between development, test and production environments
• Configured WebLogic 10-11g installations of OBIEE and ODI web services
• Modeling using Sparx’s Enterprise Architect (EA), SAP’s Power Designer (PD16) and Visio; used TOAD, SQL*Developer and SQL*Modeler to do data discovery; prepared training modules to explain data processes (hierarchies, SCD, ODI workflows, database normalization standards, data hygiene procedures, producing derived data, data aggregations and performance tuning) hosted on Wintel 2008 r2 and RHEL 5/6 (Linux)
• Managed dozens of schemas with hundreds of tables and thousands of columns as well as data flows under Oracle RDBMS 10-11g (PSFT).
• Designed of enterprise models (EDW), Staging normalized data warehouses (ODS) and dimensional data structures (DM);
• Developed, tested and deployed ETL workflows from DOT’s operational source systems both custom and PSFT
• Developed and trained staff to write dashboards, metadata and presentation artifacts for bridge deterioration, structural analysis, load carrying,, roadway construction, pesticide applications and snow and ice activities (operational and financial), financial projections (PeopleSoft Financials) and the associated costs (bare lane metrics)
• Created and resolved support requests with Oracle support as well as in-house support for the entire OBIEE technology stack
• Created, modified and supported many RPD’s (repository presentation design) and database deployments, migrations and upgrades
• Designed the branding and navigation path of OBIEE so that navigation interface would be seamless with other sites that have been previously developed. Future activities will integrate various business segments such as finance and human resources into their respective subject areas.
• Developed a data integration effort to use the RPD to extend the physical, logical and extended hierarchies for fiscal calendars, activities, organizations and operational groups as well as to aggregate data from a myriad of in-house systems.

Senior OBIEE + MSTR Business Intelligence Developer + Architect

Confidential, Rockville, VA

Responsibilities:

• Develop POC for their internal financial and technology reports source from Essbase Hyperion 11g. Import the cube and create the Confidential and Subject Areas for periodic daily refreshes. Develop several dashboards and reports to reflect current reporting strategies with flexible prompting ability to change scenarios, products, organizations, projects, amongst other parameters without to rewrites as well as write-back capabilities.
• The data source was their current production Essbase system and the customer is an internal audience that required timely data with the ability to drill up, down and across their entire product line and projects across the globe.
• The database is Oracle 11g and SQL Server 2008 running OBIEE 11g (11.1.1.5) and a custom RPD on an Windows Server 2008 r2 and Essbase 11g with member running into the 10’s of thousands and 16 dimensions under an ASO Essbase structure.
• Architect a new Oracle OBIEE enterprise deployment of OOTB Informatica ETL, Oracle DAC and financials, projects, HR dashboards, Oracle Essbase conversion using Oracle OBIEE Applications 7.9.6.2, Windows 2008 r1/2, SharePoint, write run-book guides for installation, manage hardware design book authorizations using EMC ESX VM cloud configuration and non-VM deployments in a development, QA and production topology and based on clustered and non-clustered Windows 2008 r1/2 VM servers and Linux RHEL 5 servers. The long term goal is to use OOTB and in corporate federated data from legacy EDW, Oracle PeopleSoft, SAP, Business Objects, Cognos and COTS applications with the idea of managing ever larger implementations and projects for their external and external customers. Science Applications International Corporation (SAIC) is a Fortune 500 scientific, engineering, and technology applications company that solves problems of vital importance to the nation and the world, in national security, energy and the environment, critical infrastructure and health. This deployment will service over 43,000 employees. I prepared dozens of formal documents around repeatable data integration processes and standard JAD templates following an enhanced project lifecycle based on an agile strategy that delivered quick results which took the modeled data sources (Deltek) into the database and conforming the structures to Oracle’s OOTB structures, ETL and reports. This practice generated CONOPS, use case diagrams, run books, requirement plans, data models, a release plan strategy, a traceability matrix and a dashboard prototype amongst other products. My role is onsite and covers the entire product deployment from hardware to software to training of project staff, platform engineers and database administrators, technical and functional managers who participate in the rollout and maintenance of the system over its lifecycle. Windows 2008 r1/2, Microsoft Visual Studio 2010, Informatica 8.6, OBIEE11g, Cognos 9, SAP Business Objects 3x, Hyperion Essbase 11g, Oracle RDBMS 11g, DAC 10g, WebLogic 10g, RHEL Linux 5x, PowerBroker. The total data volumes > 4 terabytes with daily loads > 1 million rows.
• New OBIEE 10g ( 10.1.3.4.1 ) and OBIEE BI Apps 7.9.6.1 implementation. Direct ETL, RPD team by reviewing processes and custom code so as to stabilize the data management process which was significantly damaged as a result of diverse teams accessing and modifying standard processes to accommodate business requirements. Track performance issues and provide a significant ETL improvement based on database, ETL and dashboard requirements which resulted in activities hardware (cpu, swap space, memory factors), database (physical layout, partitions, indexing, parallelization) and reporting configuration parameters; conducted JAD session and operational ticket issues to resolve requirements around EBS and non-EBS data federation issues. I developed a physical and logical system topology diagram to reflect performance bottlenecks and resolution. I prepared formal documentation around repeatable data integration processes using UML diagrams and standard JAD templates following an enhanced project lifecycle based on an agile strategy that delivered quick results which took the modeled data sources into the database with a rapid subject area review ready for dashboard prototyping. This practice generated use case diagrams, context diagrams, activity diagrams, state transition diagrams, requirement plans, data models, a release plan strategy, a traceability matrix and a dashboard prototype amongst other products.
• New Confidential implementation using OBIEE 10g ( 10.1.3.4.1 ) to develop custom subject areas for the Service Work Order segment. Created custom models to support dimensions and facts that track service activity on a national basis. Developed ODI driven ELT code work to load data from JDE into a custom OBIEE RPD and writing Data Profiling and Data Quality processes. Create several dashboard reports (Dashboards and BI Publisher) for the quality teams that replaced an MS ACCESS manual tracking system and provide lights out custom reporting anywhere anytime.. They have an ambitious growth goal of over 15% year to year. They were recently acquired by a hedge fund and have been generating a very aggressive growth strategy.

Senior OBIEE Business Intelligence Developer + Architect + Technical Manager

Confidential, Sarasota, FL

Responsibilities:

• New EBS r12.1.1 and OBIEE 10.1.3.4.1 and OBIEE Applications 7.9.6.1 custom implementation of a revenue dashboard, an inventory and supply chain custom reporting replacing Business Objects and MySQL proprietary applications for a very large manufacturing business with over 100 years of continuous commercial success.
• The goal is to improve internal processes to achieve a larger market share.
• My role is to introduce SDLC practices, scrum and agile techniques with a geographically dispersed team on 3 time zones of a revenue and sales report every two hours, an executive dashboard and a drill down set of inventory reports that detail customer, sales and marketing dashboards.
• The control tools are a rewritten project plan using Project Insight on the existing backlog of deliverables.
• I improved the scheduling of design-construction-deployment of data structures, subject areas and dashboards with reports (OBIEE Answers, BI/Publisher and Delivers).
• The agile scrum made them accountable on a daily basis with daily benchmarks and deliverables with the technical team and with weekly conferences with the steering committee, SME’s, and business users.
• The result replaces > 355 reports for a privately owned business working itself into a strong 21st century enterprise.

Senior OBIEE Business Intelligence Architect + Project Manager

Confidential, San Jose, CA

Responsibilities:

• Closing a 2-year overdue project that was over budget by $10m.
• This is an OBIEE ( 10.1.3.4.1 ) custom implementation of a revenue dashboard based on PeopleSoft 8/9 (with an upgrade).
• The project has 40 people including SME’s, Developers and business side managers.
• The delivery and control methods were 3 releases within a short period using scrum and agile techniques with a geographically dispersed team for an international consumer audience in 3 continents and 9 time zones of a revenue flash report every two hours, an executive dashboard (using Dashboards and BI Publisher) and a drill down set of revenue reports that detail inventory, sales and marketing dashboards.
• The control method was a rewritten project plan on the existing backlog of deliverables using the design-construction-deployment of data structure, data and dashboards with reports (OBIEE Answers and BI Publisher).
• The agile scrum made them accountable on a daily basis with daily benchmarks and deliverables with the technical team and with continuous conferences with the steering committee, SME’s, and business users.