SUMMARY:

• High - performance Technical Project Lead/Pre - sales Exec with an outstanding track record of success in business intelligence, financial reporting, project management, and software development to lead / plan the analysis, architecture and development of software solutions.
• Demonstrated ability to lead, manage and deliver results on both strategic and tactical levels, with domain expertise that includes finance, e-commerce, oil and gas, retail, pharmacy, insurance, public sector, and medical / emergency medical services.
• Twenty plus years of experience analyzing, designing, developing, implementing, tuning and supporting Oracle Databases, OAS,IAS, Weblogic, EBS, Hyperion (Brio) Suite, including OBIEE, Hyperion, Cognos, as well as single sign on (SSO) integration against user stores. Including EBS,Peoplesoft, SQL Server AD to OID/OAM.
• Broad-based skills in every aspect of the project life cycle, including requirements gathering, creating work plans, functional requirements and unit testing plans.
• A practiced mentor and advisor; able to establish rapport and trust with diverse groups of people at all levels.
• Highly regarded an analytical problem solver and solutions provider with strong organizational and supervisory skills.
• Expert Performance Tuner (Oracle) and modeler for extending and creating new containers.Rational Unified Process (RUP) and Agile software development techniques.

PROFICIENCIES / TECHNICAL SKILLS:

• ERv-Diagrams (Multiple tools)
• Performance tuning
• Oracle 11g,12c working with DBA’s
• Code migration expert
• Ability to Apply Technical Solutions to Business Issues
• Hardware and Software Evaluation
• Promote IT Principles, Policies and Processes
• User and Staff Training / Development
• Process Improvement
• Client Need Analysis and Management
• Process Discipline
• Coaching / Mentoring
• Project Management and Development
• Data Analysis

BUSINESS INTELLIGENCE SKILLS:

• OBIEE 10.2.x 11.1.1.9, 12.2
• Oracle BI Interactive Dashboards
• Oracle BI Answers
• Essbase Versions 11.x, 9.x
• Crystal Reports: BO
• Essbase Studio
• Hyperion Financial Reporting
• Cognos
• Hyperion Planning
• Oracle 7x: 12c
• Postgress
• Solaris
• MSSQL Server 2003 2012
• DB2
• Wintel
• Unix
• Sybase
• Linux

PROFESSIONAL EXPERIENCE:

Confidential, Mechanicsburg, PA

Responsibilities:

• Configured XML option to report on instead of producing PDF’s.
• Match changes and support Transport of code design across domains.
• Migration of DODAF 1.0 to 2.0 standards
• Role access to resolve requests through RBAC
• Custom design new entities and attributes for SAP custom areas
• Maintain metadata repositories using sychrinization between subject areas and environments (Dev, Unit Test, QA, PRD)

Confidential, SC

Senior Data Architect

Responsibilities:

• Used Toad to maintain objects and performance tune queries
• Coordinate with Goldengate team on replicated objects from OLTP to OLAP (DW)
• Follow best practices for design, naming standards
• Reengineer DFD’s from legacy tools to Powerdesigner (15 SP2)
• System integration and integration of Marriot systems due to merger
• Troubleshoot SR’s with Oracle for in place upgrades such as scheduler, RPD

Confidential, Charleston, SC

Senior Security consultant/Data Architect Integration Oracle Access Manager

Responsibilities:

• Installed and Configure OAM/OIM/OID.to utilize EBS priviledges against OBIEE via OID
• Setup OPSS 11.1.2.0x passwords in through the Credential Store Framework.(policies,accounts, and tables) as well as RCU setup for report auditing.
• Using OPAM command interface opam.sh to display targets audit, remove accounts, etc…
• Report conversions from Discoverer to OBIEE
• Follow best practices for RPD, connection pools, Alias’, naming standards
• Provide detailed installation docs
• Tested in SRC’s dev lab to be handed over to Navy/Marines.
• Troubleshoot SR’s with Oracle for in place upgrades such as scheduler, RPD

Confidential, Erlanger, KY

Senior DW Architect/Modeler Governance Manager Integration Oracle Access Manager

Responsibilities:

• Installed and configure OBIEE. Acting metadata Admin
• Migration of DEV,Test, and Prod on daily basis for 30 applications and developers.
• New MUDE integration process developed
• Running of governance meeting calls for director
• Installed and Configure OAM/OIM/OID.to utilize EBS priviledges against OBIEE via OID
• Administer Hadoop Clusterware utilizing Hortonworks to open up data mining trends
• Performance tune SQL generated from OBIEE 11.1.1.7 patch release
• HA configuration using Dataguard
• Troublshoot code issues with development team of 30 developers
• Load balancing managed servers through F5 with active clusters containing 2 managed servers on P77 AIX server

Confidential, Pennington, NJ

DW Architect/Modeler

Responsibilities:

• Source to target mappings from ODS to intermediate DDS to MDS Lifecycle management
• Promote SAP Business Objects elements (Reports, users, Access Level, connection, user groups) to other LCM’s
• Forward engineer logical to physical models into ddl scripts using SVN for release management

Confidential, Austin, TX

Data Architect/ Oracle/OBIEE/ODI Analytics SME

Responsibilities:

• Conducted gap analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
• Involved in translating functional requirements into technical requirements.
• Interacted ETL team / DBA group / Middleware Group to develop platform HA design and landscape.
• Analyzed and used various data sources, both ROLAP and MOLAP design
• Dimensional modeling design to facilitate Star schemas,, Levels / Hierarchies, and semantic metadata .
• Customized developed meta data repository to maintain presentation and semantic layers
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics web.
• Reports scheduling to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups using SSO AuthZ and AuthN, against User store for application Security.
• Performed Unit, Integration, and Regression testing to validate reporting result.
• Used MS office plug-in for analyzing data.
• Created pixel perfect reports using BI Publisher.

Confidential, Pittsburg, PA

DW Director - Oracle/OBIEE/OAM/OID Analytics SME

Responsibilities:

• Source to target mappings from OEB (GL and HRMS, Projects) and other systems to OBIEE/Hyperion
• OBIEE MUD setup. Persistant Aggregation Wizard, Dashboards, Analysis Queries.
• Created Data Model / Dictionary in Erwin (RPD) for Logincal, Physical layers tracking SCD’s.
• Physical implementation of model, including partitioning, Materialized views for hierarchies,triggers,sequences.
• ODI 11 Agent Configuration (WLS J2EE, Standalone agent), Installation, Architecture and mappings.
• Performance tuning of ODI mappings, partition tables using composites, bitmapped indexes, DB parameters.
• Preparation of BRD’s, FRD’s, Technical Design Document adhering to the client specifications.
• SQL Tuning of OBIEE Queries, pushdown predication.
• Alignment of hierarchies and EDW for creation of CIM-common informational model.
• Mentor OBIEE / ELT, OAM developers and client on best practices and POC’s on Test
• Presentations to client teams and steering committees for decisions on project direction
• OBIEE capabilities such as trellis views, prompting
• Exalytic’s box setup for in caching response times with backend exadata on Linux enterprise RH 6

Confidential, White Plains, NY

DW/ MDM /OBIEE SME /Technical Director of Data Center

Responsibilities:

• A web-enabled, fully operational metadata repository, configuration management database (CMDB) and business rules management, and workflow auditing application using PHP to maintain transactional aspects and OBIEE to compare usage from disparate systems utilizing Global ID’s data profiling, Hadoop cluster on Red Hat
• Formalized, ITIL-based service design, service transition and service operation framework for managing the lifecycles of the information-based products sold to clients, information lifecycle management of the inputs
• KPI’s, Dashboard reports developed as per business requirements gathered through JAD
• Deployment of OBIEE on Windows 2012 Server, Web logic, PHP/Apache, Hadoop 1.0.3,Oracle 11gR2 Database.
• Metadata model semantic layer, conversion of data into faceted taxonomy.

Confidential, Pittsburg PA

OBIEE 10.1.3.x 11.1.1.5/DW Admin, OBIEE SME, Solutions Consultant/Performance Tuner

Responsibilities:

• Create and performance Tune complete INFORMATICA and OBIEE reports using indexing, hints, stored procedures, materialized views.
• Modeling and mapping of existing DW structures using Toad Data Modeler for default and customized containers
• Identify issues to upgrade RPD to 11.1.1.5 version via repository redesign (aka no more bridge structures, etc)
• BI tools10.3.1.4, 11.1.1.5, architecture, CA Erwin 7x, Toad 10x, INFORMATICA 8x, R12 EBS/7.9.6 OBIA, DAC 10x, Oracle 11gR2
• Identify issues to upgrade 11.5.10 version to 12.1 including OATM tablespaces,extents,temp space…
• INFORMATICA tuning using session log statistics to determine lookup cache, bulk loads verses insert/update routines for both SDE and SIL mappings.
• Spatial data used to create US Maps by block groups.
• Improve direct client reports from hours to minutes through SQL rewrites and indexing.
• INFORMATICA, DAC,OBI Repository backup and restore

Confidential, NY

Solutions Consultant - DBA/Modeler/Developer

Responsibilities:

• Star Schema design of Type 6 slowly changing dimensional data marts.
• Performance Tune complete INFORMATICA and OBIEE reports using indexing, hints, stored procedures, materialized views.
• BI tools10.3.1.4, architecture, CA Erwin 7x, Toad 10x, INFORMATICA 7x
• Complete configuration and implementation of Oracle Data warehouse Model, sourcing any and all legacy systems for conversion via Dimensional Star schema.
• POC of Portfolio analytics for fixed income and equity positions. Migration platform setup for 11G OBIEE
• Develop best practices for BICOE Team.
• Administer security via LDAP, authorization and authentication documentation and implementation using LDAP ADSI.
• Configuration of local and global caching for HA environments.
• Complete build of all feature functionality exploiting the tools strengths, as well as custom UI for prompts and custom deployment of WAR/EAR file using firebug to facilitate locating backend objects.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Architect role in charge of 2 employees, 2 contractor team.
• Complete documentation of FRD, SDD, TDD for reporting.
• BI tools, architecture, including full ETL using INFORMATICA Power Center, DAC integration using EBS 11I, with Oracle 7.9.5
• Complete configuration and implementation of Oracle Data warehouse Model, sourcing any and all legacy systems for conversion.
• As a OBIEE Lead was involved in translating functional requirements into technical requirements
• Multiuser environment setup (MUDE), and RPD merging and matching.
• Administer security via LDAP, presentation catalog using Catalog Management for online changes.
• Configuration of local and global caching for HA environments.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• BI tools, architecture, functions, and features with strong technical background including relational databases, multi-dimensional databases, OLAP and/or reporting tools and metadata management. Develop answers, and dashboards using production data, and existing SQL server data warehouse using Star schema designs.
• Installation of OBIEE BI Server, HTTP, Presentation services, and SAW Scheduler.