SUMMARY

•  Talent acquisition, employee development, knowledge transfer, and retention.
• Vendor management, project management, cost/benefit analysis, and consulting.
• Direct mail and telemarketing lead generation, call routing infrastructure, logic and reporting, and data-mining.
• Compensation planning, reporting, and payment, GAAP accounting standards, and financial statement generation and analysis.

TECHNICAL SKILLS:

Database-specific Skills:  OLAP and OLTP design and implementation, ETL, VLDB, XML, data migration, data validation, clustering, high-availability solutions, backup design and implementation, dynamic stored procedures, ODBC interface, data migration, insert, update, and delete triggers, transaction and locking optimization, hardware specification and acquisition.

Server-specific Skills: DHCP, DNS, DDNS, RAS, RRAS, FTP, WINS, LDAP/Active Directory, hardware RAID, SAN, fiber LAN, UPS, as well as system backup utilities and hardware.

PROFESSIONAL EXPERIENCE

Confidential, Dodgeville, Wisconsin

Business Intelligence DBA

Responsibilities:

• Brought on to backfill a resource and subsequently took installation and configuration project tasks from over a month behind to ahead of schedule.
• Performance tuned multiple Oracle Business Intelligence Applications (OBIA) 11.Oracle Retail Insights,
• Installed, configured, monitored, and performance tuned multiple instances of:
• Oracle Enterprise 12.1.0.2 Enterprise Exad Confidential RAC
• Oracle Business Intelligence Applications (OBIA) 11.1.1.10.2
• Oracle Retail Insight (RI) versions 16 and 16.0.1
• Oracle Retail D Confidential Extractor for Merchandising (ORDE) 16.0.1
• Oracle D Confidential Integrator (ODI) versions 11.1.19, 12.2.1, and 12.2.1.2
• Oracle Business Intelligence Enterprise Edition (OBIEE) versions 11.1.19, 12.2.1, and 12.2.1.2
• Oracle Weblogic Server versions 10.3.6, 12.2.1, and 12.2.1.2
• Compiled and performance tuned multiple ELT load plans:
• OBIA 11.1.1.10.2 (Procurement and Spend, Financials, and Asset Management)
• RI 16 and 16.0.1 (Retail)
• ORDE (Oracle Retail Merchandising System, Oracle Retail Invoice Matching, and Oracle Retail Price Management)
• Designed and configured a single end-user OBIEE by upgrading and merging OBIA 11.1.1.10.2 and RI 16.0.1 RPDs, Presentation C Confidential logs, and security models.
• Scripted automated startup and shutdown of application infrastructure.

Confidential, Menlo Park, California

Business Intelligence Architect

Responsibilities:

• Upgrade of Tableau 9.3 desktop installation to Tableau 10.0 desktop.
• Acted as subject matter expert for OBIEE 11.1.1.7 high-availability cluster configuration.
• Developed first ever real-time-reporting for Oracle Webcenter Forms Capture and Conversion using Tableau to support global invoice processing automation initiative.
• Real-time integration Oracle EBS R12 with Pega service implementation using PL/SQL and JSON to provide supplier-related analytics.
• Development of custom Tableau 10.1 reporting from Oracle EBS R12 Purchasing (PO) Payables (AP) and Accruals (GL) to provide insight into liabilities reconciliation for consigned inventory for Oculus finance executives.
• Architectural advice and troubleshooting of highly-customized OBIA 7.9.6.3 Informatica 9.0.1 and DAC 10.1.3.4.1 implementation to support Revenue (AR) analytics.

Confidential

Business Intelligence Architect

Responsibilities:

• Responsible for functional and technical tasks associated with audit, roadmap, and customization of OBIA 11.1.1.9.2 installation sourced from an Oracle EBS 12.1.3 implementation.
• Acted as functional liaison with business executives in the following departments:
• Procurement
• Tours
• On-property revenue (including food and beverage)
• Corporate finance
• Led development efforts to support sales revenue reporting including:
• Custom d Confidential warehouse design
• Custom repository design (RPD)
• D Confidential base materialization and partitioning recommendations for General Ledger Journal Entries
• Responsible for the following project management tasks:
• Sales Revenue scoping
• Project Roadmap timelines and milestones
• Resource plan
• Infrastructure audit
• Assisted with audit, ETL, and configuration of:
• OBIEE 12.2.1.0
• ODI 12.1.2.0.0
• OBIA 11.1.1.9.2
• WebLogic 12.1.2.0.0

Confidential, Houston, Texas

Business Intelligence Architect

Responsibilities:

• Responsible for functional and technical strategic direction of OBIA 7.9.6.3 to 7.9.6.4 upgrade, in support of a multi-source PeopleSoft ERP 9.1 to 9.2 upgrade.
• Acted as functional lead with business executives in the following departments:
• Research Grants
• Finance
• Human Resources
• Led production troubleshooting and resolution efforts, including:
• DAC and Informatica nightly ETL failures
• WebLogic (J2EE) Application Deployment crashes
• OBIEE Presentation Services crashes
• Infrastructure memory and processor bottlenecks
• Responsible for the following project management tasks:
• Deliverables scoping
• Project timelines and milestones
• Resource allocation
• Infrastructure capacity planning
• Oversaw and documented installation, patching, and configuration of:
• OBIEE 11.1.1.7
• Informatica 9.5.1
• DAC 11.1.1.6.4
• WebLogic 10.3.6

Confidential, Memphis, Tennessee

Business Intelligence Architect

Responsibilities:

• Led the OBIEE 11.1.1.7.1 and OBIA 7.9.6.3 (Human Resources Analytics) customization effort sourced from the following systems:
• PeopleSoft 9.1
• PRSIM (legacy mainframe HR system)
• Designed and oversaw development of Fedex-specific managerial hierarchy to support current, historical, and trend reporting rollups.
• Designed and developed Fedex-specific HR Organization Dimension to support current, historical, and trend reporting rollups.
• Designed and developed ETL processes to merge Fedex-specifc HR Organization workforce events into existing OBIA workforce event and workforce event snapshot d Confidential without adverse effects on existing headcount reporting and dashboards.
• Designed and developed ETL processes to support one-time load of historical Fedex-specifc HR Organization workforce events into existing PeopleSoft OBIA workforce event and workforce event snapshot d Confidential without adverse effects on existing headcount reporting and dashboards.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

• Led the OBIEE repository (RPD) 11.1.1.6 creation effort for the following Oracle eBusiness Suite (EBS) modules:
• Financials (GL, AP, AR, Fixed Assets)
• Inventory Management
• Purchasing
• Project Accounting
• Led the development effort for reporting delivery (Balance Sheet, Income Statement, Project Spend, Open Purchase Orders, etc.) across a global enterprise with local and global charts of accounts.
• Created OBIEE project efficiencies to reduce the OBIEE RPD development time by a month.
• Implemented and managed OBIEE RPD parallel development and merge processes.
• Provided budgetary, timeline, and resource management for the entire OBIEE-EBS development initiative.
• Upgraded EBS OBIEE implementation from 11.1.1.6.6 to 11.1.1.7.1 .
• Documented test cases, migration plans and technical specs for over EBS 40 reports.
• Defined OBIEE security to mimic EBS security across a global implementation

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

• Oversaw OBIEE repository (RPD) 11.1.1.6 in-place upgrade to support JD Edwards (JDE) 8.1.2 to 9.1 source system and RapidDecision 5.5 to 6.2 d Confidential mart upgrade.
• Ensured the automated, seamless cutover of more than 2000 reports General Ledger, Accounts Payable, Accounts Receivable, Expense Management, and Fixed Assets.
• Designed indexing strategy to reduce the runtimes of more than 450 high-usage General Ledger transactions reports.
• Designed materialization and OBIEE aggregate awareness approach to increase performance for more than 70 high-usage General Ledger Balances reports.
• Provided budgetary, timeline, and resource management for the OBIEE JDE Finance upgrade project.
• Oversaw upgrade of JDE implementation OBIEE from 11.1.1.6.6 to 11.1.1.7.1
• Planned, developed test cases for, and oversaw regression testing of over 2000 JDE-specific OBIEE reports.

Confidential, Washington, D.C.

Business Intelligence Architect

Responsibilities:

• Directly responsible for the diagnosis, solution, and closure of 21 of the highest priority OBIEE 10.1.3.4.1 end-user issues, facilitating insight into Siebel 8.1.1 Call Center.
• Troubleshot and optimized Segmentation (for list camp Confidential n list generation) for integration with Siebel Marketing 8.1.1 for automation of camp Confidential n list load.
• Led the stabilization effort for the following Oracle Business Intelligence Applications (OBIA) 7.8.5:
• Service
• Marketing
• Call Center
• Reduced Informatica 8.6.1 and DAC 10.1.3.4.1 nightly ETL load from 15 hours to 4 hours.
• Led a mixed on-site off-site team of seven resources.
• Standardized OBIEE RPD development process and coordinated development resources, project managers, Oracle On Demand support staff, and end-users.
• Provided managerial and technical direction to Oracle On Demand support, as leading a team of off-site OBIEE resources.

Confidential

Business Intelligence Architect

Responsibilities:

• Identified solutions for client global currency enhancement requests for ETL extensions to the General Ledger mart functionality.
• Designed and oversaw development of customized Accounts Receivable and General Ledger reporting.
• Worked with internal IT staff and consulting resources to identify and rank reporting requirements.
• Responsible for OBIEE project management as well as on-site and off-site OBIEE consulting resources.
• Conducted knowledge transfer with Confidential resources on performance tuning and indexing strategies.
• Led effort to configure OBIEE Presentation C Confidential log as per client enhancement requests, including custom skins (HTML, JavaScript, and CSS).
• Designed and oversaw implementation of OBIEE-centric solution to simply prompting for balance and net positing measures.

Confidential, Purchase, New York

Pre-Sales Business Intelligence Architect

Responsibilities:

• Worked with business users and internal IT staff to identify and rank reporting requirements.
• Designed and documented multiple solutions for client enhancement requests for Accounts Payable mart functionality.
• Conducted knowledge transfer with client resources on Work Order mart.
• Presented OBIEE-centric options to support client requests for cross-mart reporting functionality.

Confidential, Northridge, California

Business Intelligence Architect

Responsibilities:

• Architected, installed, and configured three Weblogic/OBIEE 11g environments on 64-bit Linux, two of which were clustered.
• Developed procedures and best practices for OBIEE metad Confidential multi-user development and change control.
• Integrated OBIEE 11.1.1.5 with Oracle Hyperion Planning 11.1.2.
• Implemented OBIEE reporting based on Demantra demand forecasts, Hyperion financial plans, and JDE actuals.
• Leveraged Active Directory (LDAP) security model for OBIEE 11g authentication and authorization.
• Conformed transactions from Hyperion Planning (Plan) Demantra (Forecast) and JDEdwards (Actual) across product, customer, geography and time hierarchies.

Confidential, Fairfield, Connecticut

Business Intelligence Architect

Responsibilities:

• Architected strategy to coalesce multiple Confidential Corporate Finance OBIEE instances into a single footprint for director-level executives.
• Installed and configured OBIEE 11g and Oracle Weblogic 11g.
• Integrated OBIEE 11.1.1.3 with Oracle Essbase 11.1.2.
• Designed “stoplight” dashboard combining General Ledger, ETL process, and Essbase multi-dimensional statistics.
• Integrated OBIEE with conversion of Business Objects Planning application to Oracle Planning.
• Liaised with internal and offshore resources to coordinate tactical delivery.

Confidential, Rockland, Massachusetts

Business Intelligence Architect

Responsibilities:

• Liaised with internal resources to ensure system compliance with FDA-mandated regulations for new drug rollout.
• Documented current state of the Siebel Analytics Business Intelligence Service 7.8.5 Application sourced from a Siebel 7.8.4 ePharma Call Center.
• Architected short-term technical strategy to meet current project requirements.
• Conducted a successful upgrade, in the midst of the project cycle, from Siebel Analytics 7.8.5 to OBIEE 10.1.3.4.1 , including DAC 10.1.3.4.1 and Informatica 8.6.1.
• Defined long-term technical roadmap for a "green field" system re-implementation to support current and future business processes.
• Conducted, knowledge transfer, and mentoring sessions with technical resources.
• Designed custom execution plans, ETL mappings, and d Confidential warehouse tables to support, enrollment, marketing, medical history, and order fulfillment business processes.
• Designed custom dashboards combining prescription, sales, service request, adverse event, and vendor service level agreement metrics.
• Responsible for all OBIEE-related project deliverables.

Confidential, Raleigh, North Carolina

Business Intelligence Architect

Responsibilities:

• Provided guidance on strategy and risk mitigation to director-level executives.
• Architected a custom OBIEE 10.1.3.4.1 application sourced from Siebel 8.1.1 eClinical.
• Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
• Integrated OBIEE and Siebel User Interfaces, as well as the Authentication (SSO), Privilege, Authorization, and Row-Level Security topology.
• Designed a custom d Confidential store based on real-time feeds from Siebel Enterprise Business Components.
• Conducted knowledge transfer on report and dashboard design and development best practices.
• Acted as Subject Matter Expert for design and configuration of highly-available and scalable enterprise Test and Production OBIEE 10.1.3.4.1 environments.

Confidential, Dallas, Texas

Business Intelligence Architect

Responsibilities:

• Provided guidance on approach and timelines to director-level executives.
• Implemented Oracle Business Intelligence Applications 7.9.6 for Service and Marketing.
• Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
• Configured D Confidential Warehouse Administration Console (DAC) 10.1.3.4.1 to support Informatica customizations.
• Upgraded and merged both a Siebel Analytics 7.0 Repository (RPD) Web C Confidential log (HTML, JavaScript, and CSS) with an OBIEE 10.1.3.4.1 Repository and Presentation c Confidential log to support legacy reporting and camp Confidential n list generation.
• Configured Marketing Target Levels, Qualified List Items, Segmentation (for list camp Confidential n list generation), and integration with Siebel Marketing 8.1.1 for automation of camp Confidential n list load.

Confidential, Salem, Oregon

Business Intelligence Architect

Responsibilities:

• Interacted with c-level executives to determine project vision and strategy.
• Implemented RapidDecision (JDE Enterprise One sourced) GL, AR, AP, FA, and Property Management Marts.
• Designed and built Balance Sheet, Income Statement, and P&L financial statements.
• Installed and configured 2 OBIEE 10.1.3.4 environments on Windows Server 2003 virtual machines.
• Designed and built custom Narrative Views, metad Confidential, and d Confidential base objects to enable prompt display in excel.
• Integrated OBIEE security (user authentication and authorization) with JDE Enterprise One.

Confidential, Los Angeles, California

Business Intelligence Architect

Responsibilities:

• Conducted knowledge transfer on OBIEE systems administration best practices for client resources.
• Load testing and monitoring of OBIEE environment to determine performance bottlenecks.
• Designed enterprise architecture to support high-availability, scalability, and concurrent development cycles.
• Installation and configuration of 7 separate OBIEE 10.1.3.4 environments on AIX 6.1.
• Installation and configuration of 7Oracle Application Server 10.1.3.3 environments on AIX 6.1.
• Integration between Oracle Single-Sign-On, OBIEE, Oracle Application Server, and BI Publisher.

Confidential, Austin, Texas

Business Intelligence Architect

Responsibilities:

• Designed and implemented custom ETL to load and telephony reporting elements into Call Center Analytics.
• Modification of Informatica ETL routines to include extension public sector reporting fields.
• Development of state and county portal dashboards and reports.
• Implementation Single-Sign-On via two authentication methods across multiple firewalls and disparate application topologies.
• Sole OBIEE liaison for end-user requirements gathering and technical resource knowledge transfer.

Confidential, Dayton, Ohio

Business Intelligence Architect

Responsibilities:

• Repository customization to facilitate Confidential -Nexis-specific sales pipeline forecasting indicators.
• Modification of Informatica ETL routines to include extension CRM sales forecasting columns.
• Development of custom dashboards and reports for enterprise sales pipeline analysis.
• Implementation of multi-user development and change control processes.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

• Improved report performance from 5+ minutes to less than 20 seconds using aggregation strategies.
• Instruction and documentation on governance best practices.
• Change control instruction and documentation, including Presentation C Confidential log migration, Repository merge and multi-user development.
• Tuned custom dashboard and reports filters using repository variables.
• Customized Impact source-to-target mapping application to support multiple repositories (RapidDecision, OBIEE Applications, and custom-developed).

Confidential, Libertyville, Illinois

Business Intelligence Architect

Responsibilities:

• Custom report and dashboard development to support decommissioning of in-house custom java reporting application.
• Custom Repository development to join heterogeneous d Confidential sources.
• Custom d Confidential warehouse tuning to conform financial and manufacturing transactions.
• Configuration and installation of Linux high availability infrastructure.
• Configuration of load balanced WebLogic application servers.

Confidential

Business Intelligence Architect

Responsibilities:

• Installation and configuration of Ubuntu OBIEE VMWare image.
• BI Server and Presentation Services tuning.
• Instruction and documentation on change control best practices.
• Re-configured custom dashboard and reports to conform to best practices.
• Tuned custom OBIEE Repository to enhance performance.

Confidential, Grand Rapids, Michigan

Business Intelligence Architect

Responsibilities:

• Configured first comprehensive RapidDecision write-time finance d Confidential mart for OBIEE.
• Performance tuned Oracle 10g General Ledger, Accounts Payable, Accounts Receivable, Expense Management, and Fixed Assets d Confidential marts.
• Constructed first-ever link between JDE Confidential payables and receivables.
• Conducted end-user discovery, requirements gathering, and sessions.
• Designed and developed custom operational reporting subject area for JDE chart of accounts.
• Configured first comprehensive RapidDecision write-time finance d Confidential mart for OBIEE.

Confidential, Reston, Virginia

Business Intelligence Architect

Responsibilities:

• Oversaw and conducted configuration of Oracle Financial Analytics.
• Designed and developed custom ETL to support Oracle Financial Services Generator (FSG) reports in Oracle Financial Analytics.
• Conducted Oracle Financial Analytics gap analysis, provided solutions, and level of effort estimates.
• Developed custom ETL and metad Confidential to display support Oracle Financials Accounts Receivable targets and budgets.
• Led various end-user requirements sessions and produced requirements documents.
• Acted in team project management role coordinating on-site, off-site, and client resources.
• Trained two BICG resources on Oracle Business Intelligence Applications.

Confidential, Mountain View, California

Business Intelligence Architect

Responsibilities:

• Developed and conducted ETL proof-of-concept performance testing for out of the box and custom loads into Oracle Financial Analytics.
• Developed and conducted dashboard proof-of-concept performance testing for out of the box Oracle Financial Analytics.
• Oversaw installation of Oracle Business Intelligence 10.1.3.3 Platform and Financial Applications 7.9.4 on Solaris.
• Developed custom Oracle Business Intelligence dashboards to display system performance information.
• Conducted various end-user demonstrations of Oracle Business Intelligence to various executives.
• Acted as proxy for Confidential System Resource Engineering team during proof-of-concept.

Confidential, Pittsburgh, Pennsylvania

Business Intelligence Architect

Responsibilities:

• Designed 4 custom Dashboards and 40 custom reports to support 4 functional business units.
• Installed and configured Oracle Business Intelligence Platform 10.1.3.2.1 on Linux with Oracle 10g on Linux custom d Confidential warehouse.
• Integrated custom metad Confidential with OID.
• Integrated Platform with pre-existing Oracle Application Server.
• Led Confidential effort to implement business intelligence application lifecycle implementation methodology.
• Designed and built custom hierarchies in OID to enable user maintenance and Oracle Business Intelligence link.

Confidential, St. Louis, Missouri

Business Intelligence Architect

Responsibilities:

• Installation of Oracle Business Intelligence Platform on Linux RedHat.
• Configured and installed EBS Fusion Analytics.
• Troubleshooting Oracle Daily Business Intelligence materialized view creation.
• Integrated EBS Fusion Analytics with EBS security model.
• Configured CUPS printing and integrated security BI Publisher.

Confidential

Business Intelligence Architect

Responsibilities:

• Installed Oracle Business Intelligence Platform 10.1.3.2 and EPM Fusion Financial Analytics on Windows Advanced Server 2003 with Oracle 10g on Linux source and target d Confidential bases.
• Configured PeopleSoft Human Resources and Financials Fusion Analytics integrated security model.
• Configured LDAP authentication
• Developed custom documentation on migration and change control best practices.
• Compiled Statement of work, including financial models, deliverables, timetables, and resource allocation for second phase of implementation.

Confidential

Business Intelligence Architect

Responsibilities:

• Migrated email response tracking from hosted reporting solution to internal Siebel 7.8 Marketing-sourced Marketing Analytics application.
• Installed Oracle Business Intelligence Platform 10.1.3.2.1 and Marketing Analytics Applications 7.9.3 on Windows Advanced Server 2003 with SQL Server 2000 source and target d Confidential bases.
• Developed custom interface to mimic legacy reporting application.
• Conducted gap analysis on extension source fields as well as custom metrics from legacy system.
• Built fully integrated Confidential Institute-branded Oracle Business Intelligence-Siebel Marketing prototype to achieve user sign-off.
• Configured Siteminder SSO integration.
• Led Confidential Institute effort to implement business intelligence application lifecycle implementation methodology.

Confidential

Business Intelligence Architect

Responsibilities:

• Designed Custom Dashboards and reports for inside and outside sales teams.
• Implemented fully-integrated, customized Oracle Business Intelligence Financial Services Application for insight into a customized Siebel 7.8 CRM transactional system.
• Scoped level-of-effort for d Confidential warehouse schema modifications.
• Installed Oracle Business Intelligence Platform 10.1.3.2 and Financial Services Applications on Windows Advanced Server 2003 with DB2 (Z/OS) source and target d Confidential bases.
• Led Confidential Century effort to implement business intelligence application lifecycle implementation methodology.
• Configured LDAP authentication.

Confidential

Business Intelligence Architect

Responsibilities:

• Built 85 Reports and 4 Dashboards in 3 months.
• Implemented Custom Oracle Business Intelligence Application for insight into a custom OLTP environment.
• Developed completely new rapid application development approach to support client requirements.
• Migrated Oracle Business Intelligence from version 7.8.4 to 10g (10.1.3.2).
• Acted as Subject Matter Expert for client CIO on d Confidential warehousing best practices.
• Designed Custom Metad Confidential and D Confidential base Schema to support both Operational and Analytics needs.
• Built Logistics Process Monitor to completely eliminate 3200 order issues and 2500 open trouble tickets.

Confidential

Business Intelligence Architect

Responsibilities:

• Acted as Liaison between Oracle, HP, and Analytics Teams for Sales cycle.
• Developed customized, full integrated Oracle Business Intelligence-Siebel CRM proof of concept.
• Led team for the first integrated install of OBI-Siebel CRM in Turkey.
• Compiled Statement of work, including financial models, deliverables, timetables, and resource allocation.
• Developed skill-sets of local Oracle Turkish resources to support future Oracle Business Intelligence engagements.

Confidential

Business Intelligence Architect

Responsibilities:

• Led Informatica ETL incremental and full load customization effort.
• Installed, configured, and customized the Siebel D Confidential warehouse Application Console, including CRM 7.0 to Analytics 7.8 bridge.
• Acted as on-site Analytics Subject Matter Expert and liaison with Siebel Technical Account Manger.
• Customized Siebel 7.8.4 RMW to support custom Siebel 7.0 CRM fields.
• Conducted CRM language-support troubleshooting in support of Siebel Analytics requirements.

Confidential

Business Intelligence Architect

Responsibilities:

• Compiled Statement of work, including financial models, deliverables, timetables, and resource allocation.
• Developed Custom Informatica ETL Mappings to link separate Siebel Marketing 7.8 and Siebel CRM 7.5 to Siebel Analytics 7.8.4 RMW.
• Integrated DAC with separate Marketing and CRM instances, resulting in the load of a single, unified RMW.
• Acted as Subject Matter Expert for integrated Siebel Analytics implementation and engagement methodology.
• Designed Custom Siebel Analytics Application for Informatica Mapping change impact analysis.

Confidential

Business Intelligence Architect

Responsibilities:

• Designed Siebel Analytics Applications 7.8 RMW to client enterprise d Confidential warehouse load.
• Built integrated Siebel Analytics-Siebel CRM prototype to educate users on Analytics features and benefits.
• Conducted Gap Analysis on Siebel 7.8 CRM-system versus Siebel Analytics 7.8.5.1 Requirements.
• Led team for first client install of Siebel Analytics 7.8.5.1 worldwide.
• Ran Beta-Test for Hebrew language Support in Webc Confidential log/Corda Chart Engine (HTML, JavaScript, CSS).
• Integrated Siebel CRM OLTP, Siebel Analytics RMW, and client enterprise d Confidential warehouse Row-Level Security.
• Defined Analytics Project Plan, Timeline, Scope, and Process.

Confidential, San Jose, California

Business Intelligence Architect

Responsibilities:

• Designed custom regression analysis functionality in Siebel Analytics, resulting in the production of a white paper on the same subject.
• Acted as Primary interface with business units and information technology resources.
• Designed custom JavaScript functionality in order to forward Siebel Analytics filters to a third party application.
• Led team responsible for new Analytics 7.8.2 install.
• Implemented, and educated client on, Siebel Analytics development methodology.

Confidential, San Jose, California

Business Intelligence Architect

Responsibilities:

• Designed Siebel Analytics integration with Confidential custom user security application.
• Built custom Siebel Analytics application for Oracle Financials and Confidential 's enterprise inventory application.
• Implemented, and educated client on, Siebel Analytics development methodology.
• Upgraded Siebel Analytics from 7.7.1.3. to 7.8.1.
• Designed Custom D Confidential Mart schema specific to this Siebel Analytics implementation.

Confidential Palo Alto, California

Business Intelligence Architect

Responsibilities:

• Designed and managed deployment of Siebel Analytics 7.7.1.3 Disconnected, Integrated Pharma Application.
• Led team of three Analytics developers.
• Rolled-out disconnected CRM and Analytics application during quarterly sales meeting in Dallas, TX.
• Customized Disconnected Application to support client requirements for internal and syndicated d Confidential .
• Configured a combination of delivers, sourcing queries, and row-level security to reduce disconnected application synchronization times.

Confidential

Business Intelligence Architect

Responsibilities:

• Compiled budgetary projections for time and expense run rate.
• Architected Oblix-Siebel Analytics custom single sign-on solution.
• Designed optimized, conformed Oracle 9i Marketing D Confidential base for Siebel extracts.
• Acted as SME for Siebel Marketing and Analytics Application 7.7 HP-UX 11i installation.
• Customized Analytics Repository, Informatica Mappings, and Siebel RMW to enable Confidential geography-organization reporting for the first time in the enterprise.
• Designed EIM procedures to in corporate industry and exogenous customer marketing d Confidential sources.

Confidential, San Jose, California

Business Intelligence Architect

Responsibilities:

• Integrated Siebel Marketing Analytics Application with Siebel Call Center Application.
• Mapped Confidential d Confidential entities to out of the box Siebel OLAP d Confidential base schema.
• Customized Siebel RMW Marketing stars to meet Confidential requirements.
• Managed team of six developers.
• Coordinated interfaces with Harte-Hanks, Accenture, Siebel, and Confidential resources.
• Defined and negotiated Statement of work and project scope.

Confidential, San Jose, California

Business Intelligence Architect

Responsibilities:

• Configured 32 Siebel Analytics 7.7 reports with customized JavaScript.
• Designed Oracle 9i materialized views for OLTP d Confidential access.
• Designed Custom Informatica full and incremental 5.1.1 and 6.3.2 mappings to transfer d Confidential from OLTP to OLAP environments every 30 minutes.
• Oversaw Siebel Analytics upgrades from 6.5.2.11 to 7.7.0.1 to 7.7.1.3 on Solaris 8.
• Managed efforts between internal, on-site, and off-site developers.
• Used Siebel Analytics Dashboard union reporting functionality to integrate non-conformed d Confidential types between production and legacy systems.

Confidential, Long Beach, California

Business Intelligence Architect

Responsibilities:

• Designed Siebel Analytics 7.5.2 and Siebel 7.7 Sales Analytics Applications to display FCG-specific Pipeline and Forecasting metrics.
• Migrated between development, test, and production SQL Server 2000/2000 Advanced Server environments.
• Developed Informatica 5.1.1 and 6.3.2 mappings to surface FCG extension columns in the Siebel RMW.
• Optimized SQL Server d Confidential base through log, index, and schema modification.
• Integrated Customized Siebel Sales 7.5.2 with Customized Siebel Analytics 7.7 on Windows 2000 Advanced Server.
• Managed FCG Siebel Analytics implementation team.

Confidential, Minneapolis, Minnesota

Business Intelligence Architect

Responsibilities:

• Designed Siebel Analytics platform to upgrade analytical and business reporting functionality for Confidential Sales Business Unit.
• Prototyped Oracle 9i d Confidential base modifications including: schema changes, index optimization, partitioning, page size, and tablespace size.
• Siebel Analytics 7.7 software installation and customization.
• Conformed dimensions across Finance and Planning d Confidential bases using custom ETL.
• Converted Business Objects 6.1 reports to Siebel Analytics 7.7 reports.
• Integrated Oracle 9i OLAP and OLTP systems on AIX 5.2.

Confidential, Los Angeles, California

Business Intelligence Architect

Responsibilities:

• Consolidated more than 50 static Excel spreadsheets into seven real-time Analytics dashboards with custom drill down functionality.
• Merged Siebel Sales Analytics and Oracle financial information for seven independent subsidiaries to provide consolidated, meaningful Analytics metrics.
• Expanded Siebel CRM reporting and Analytics d Confidential to increase visibility of specific sales pipeline stages.
• Customized Analytics interface to deliver distinct d Confidential sets based on user profile.
• Designed interactive Analytics reporting interface to address specific Confidential Sales Business Unit needs.
• Integrated Oracle 9i OLAP warehouses and DB2 8.1 OLTP Siebel and financial systems using Informatica 6.0 in a mixed AIX 5.2/Solaris 8.7 environment.

Confidential, Denver, Colorado

Application Architect

Responsibilities:

• Designed and implemented custom PL/SQL ETL to integrate Caller ID and name and address information between Oracle 9i and Oracle 8i.
• Led team of 7 FTEs in development of n-tier CTI-d Confidential base-driven application.
• Two Full Brio 8 NT software and hardware installations.
• Installed and maintained Oracle 9i instance on HP-UX 11 on HP Superdome and HP XP1024.
• Managed vendor business relationships on behalf of client, including SLAs, SOWs, and contract pricing.

Confidential, Los Angeles, California

Business Intelligence Architect

Responsibilities:

• Led knowledge transfer and documentation effort to educate internal company resources.
• Full Siebel 7.5 Analytics Applications software and hardware installation.
• Implemented custom daily refresh for Siebel Analytics business intelligence application to replace monthly, hard copy reports.
• Provided first integrated view of Peoplesoft Financials, Human Resources, and Siebel sales d Confidential .
• Integrated Oracle 9i OLTP systems and DB2 8.1 OLAP warehouse using Informatica 5.1, in an AIX 5.2 environment.

Confidential, San Jose, California

Business Intelligence Architect

Responsibilities:

• Developed this fortune 100 company’s first business intelligence solution, using Siebel Analytics 7.5 to combine marketing d Confidential from EMEA, APAC, Japan and Americas.
• Integrated Sales, Marketing, and Expense d Confidential to increase camp Confidential n efficiency and reduce cost.
• Designed Informatica5.1/Perl ETL solution to integrate 6 Solaris 8/Oracle 8.1.7 d Confidential bases.
• Discovered 15Business Intelligence Architect0 million dollars in previously unknown marketing expenses.
• Established separate development, QA, and production environments as well as change control procedures governing those environments.

Confidential, Phoenix, Arizona

Business Intelligence Architect

Responsibilities:

• Ported Siebel 6.5 reporting functionality to Siebel 7.5 Analytics Applications to enable real-time customer satisfaction tracking.
• Customized Informatica ETL for Siebel 6.5 to consolidate business intelligence metrics in the Siebel RMW.
• Optimized an AIX 5.1/Oracle 8.1.7 d Confidential mart to cut web reporting response times from 5 minutes to less than 15 seconds.
• Requisitioned and configured hardware for a test environment to enable multi-user simultaneous development separate from the production environment.
• Designed custom d Confidential warehouse to enable end-users to integrate sales, service, and inventory reporting across a $24 billion, Fortune 100 enterprise.

Confidential, New Braunfels, Texas

Senior D Confidential base Consultant

Responsibilities:

• Reduced annual direct mail costs by $704,000 by developing logic to identify and mail households in prospect d Confidential while ensuring the flexibility to mail to either households or individuals.
• Designed and implemented Business Objects 5.1/SQL Server 2000 (clustered) d Confidential warehouse and enterprise reporting solution to provide analysis from prospect purchase to customer acquisition.
• Created an automated ETL process from ADP HR Perspective for Oracle 8.1.7 to SQL Server 2000, in addition to providing Oracle recovery expertise.
• Generated an annual cost savings of $840,000 and increased weekly camp Confidential n generation capacity from 12 to 80 by developing a Business Objects Set Analyzer/VB/SQL Server 2000 (clustered) client-server solution.
• Hired, trained, and developed 3 new Confidential Store employees on T-SQL best practices, Confidential Store-specific business knowledge, and vendor management.

Gateway, Lakewood, Colorado

Network Operations Manager

Responsibilities:

• Led team that cost-justified, requisitioned, installed, configured and maintained 5 fault-tolerant/redundant SQL/NT & SQL/2000 systems.
• Developed and staffed a 24x7 support organization for enterprise call routing.
• Managed and developed a team of 5 Network Operations employees.
• Created a VB Script/VB/SQL 7.0/Hummingbird application to provide called number to destination visibility for all Gateway routing solutions.
• Implemented, oversaw, and planned Hispanic tech support outsource initiative in York, Pennsylvania and in Ft. Lauderdale, Confidential .
• Accountable for vendor SLA’s on 3 separate accounts.

Confidential , Colorado Springs, Colorado

Senior D Confidential base Analyst/Administrator

Responsibilities:

• Requisitioned, installed, configured and maintained 8 SQL/NT servers.
• Created a new, more efficient SQL 7.0/Oracle 8 call center d Confidential feed process, improving reporting visibility for corporate d Confidential management, marketing and reporting teams.
• Developed one VB/SQL 7.0 and two VB Script/SQL 7.0 client-server applications to provide previously inaccessible information to national strategy groups.
• Managed the development team for a SQL 7.0 RDBMS for Rockwell and Intecom Automated Call Distributor statistics.