Obiee Sme Resume
Washington, DC
SUMMARY:
- A distinguished Leader of Information Technology and Software Services with over 22 years of experience in diverse range of technologies within multiple industry settings. Demonstrated success managing Software Design, Application Development, Infrastructure and Architecture, Quality Assurance, Internet Technology.
- Currently working as OBIEE SME on OBIEE 11g fusion platform integrating Hyperion EPM Planning, providing assistance with BI strategy, developing varions BI Publishers reports, dashboards and analytics reports.
- Experience working as BI Architect on the OBIEE 11g integrating HFM POV cubes, SAP Cubes, ODS warehouse data and other data sources into BI.
- Ten years of Siebel experience with over 10 full lifecycle implementations of Siebel Sales, Siebel Call Center, Siebel Marketing and Siebel Service application in horizontal and vertical industry specific areas.
- Seven years of Oracle Business Intelligenge (OBIEE) experience with three full lifecycle implementation of Oracle BI application with star and snow flake schemas using Ralph Kimball and Bill Inmon Methodology.
- Expertise in Design and implementation of Oracle BI and Data Warehouse/Data Mart, gathering business requirements, Infrastructure architecture, administration, design and dev using Star Schema, DAC (Data warehouse Admin Console), ETL using Informatica, building dashboards, reports, dimensional models using star schema, Integration of Oracle with Siebel applications.
- Very strong experience in developing OBIEE repository(.RPD) at three layers (Physical Layer, Business Model & Presentation Layer), Time series objects, Interactive dashboards with drilldown capabilities using global and local filters. Security setup (group,access/query/report privileges), configured analytics metadata objects (subject area, table, column), web catalog objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
- Expertise in developing informatica mappings/mapplets using various transformations for extraction, transformation and loading of data from multiple sources to data warehouse and creating workflows with worklets & tasks, scheduling using both workflow manager and unix shell scripts.
- Analyzed and used various data source - Oracle, Siebel, Excel & SQL server
- Expertise in database performance tuning by implementing parallel execution, partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the explain plan and SQL tracing.
- Two years of Oracle back office ERP application experience in Oracle Manufacturing and Financial applications.
- Fifteen years of expertise in Oracle OLTP, OLAP, SQL, PL/SQL on windows and UNIX operating systems
- Expertise in Information Technology, Project Management, Resource Management, Relationship Building, Onshore/Offshore Model Management, Business Process Development, Pre-sales Support, Client/server Technology, Internet Technology, Application Development and Release Management, Infrastructure, Architecture and Technical Solutions, Databases and Data Warehousing, Networking and Operating, Systems, Quality Assurance.
TECHNICAL EXPERTISE:
Operating Systems: UNIX (SUN Solaris, AIX & Linux), Windows OS
Hardware: SUN, IBM, Dell, HP, Compaq, NCR
Analytics: OBIEE 10G and 11G, OBIA Applications, BI PublisherStar Schemas, DAC
Fusion Middleware: Weblogic & Oracle Enterprise Manager
ETL Tools: Informatica 8.x
Data Warehouse: Oracle OLAP, Essbase & SAP Multi-dimensional cubes
RDBMS: Oracle (7, 8, 9i, 10g and 11g), SQL Server
Packaged Applications: Siebel CRM Applications (Sales, Call Center, ServiceMarketing), ERP Applications (Oracle Manufacturing and Financials)
Middleware: Siebel UAN, IBM MQ-SeriesWeb Methods
Software: MS Office (Access, Word, Excel, Power-point), MS ProjectMS Visio, MS IIS, LDAP, Active Directory
Languages: SQL, PL*SQL, Visual Basic, XML, HTML, UNIX shell scripts
PROFESSIONAL EXPERIENCE:
OBIEE SME
Confidential, Washington, DC
Responsibilities:
- Infrastructure and Architecture of EPM/BI environments
- Installation and Administration of EPM/BI and Fusion Middleware
- Setting up security via Shared services for EPM/BI
- Setting up Single sign-on (SSO) for EPM/BI
- Upgrade from OBIEE 11.1.1.5.x to 11.1.1.7.x
- Integration with Essbase cubes
- Oracle Data warehouse, star schemas and data modeling
- RPD Modeling
- Dashboard and Reports
- BI Publisher Reports
Oracle BI Architect
Confidential
Responsibilities:
- Developing OBIEE Roadmap for the University
- Process and solutions to BI IT Governance
- Process and solutions to Data Governance
- Peoplesoft to OBIEE - Functional requirements, mockups, gap analysis and data mapping
- Branding (Skin and Style) to fit U of M’s branding requirements.
- Infrastructure, Architecture, Installation and Administration of OBIEE 11g on Linux platform
- Single Sign-on using Shibboleth and OpenLDAP with WebLogic.
- Configuration of EPM RPD, creation of reports and dashboards
- Setup BI Publisher and creation of BI Publisher Reports
- Training users to create ad-hoc reports using answers
- Training developers with RPD customization and BI administration
Oracle BI Architect
Confidential
Responsibilities:
- Integrating HFM (hyperion) into OBIEE to provide enterprise level financial reporting
- EPM to leverage shared services for SSO authentication
- SAP cubes using MS Analysis services to build operational reports in BI
- ODS as data warehouse for operational reporting
- Other data source and excel spreadsheets to meeting reporting requirement
Oracle BI Architect
Confidential
Responsibilities:
- As a OBIA Lead was involved in translating functional requirements into technical requirements.
- Assisted in building detailed project schedule.
- Interacted with Business and Operation / Maintenance business representatives for gathering the OBIA Reports / Dashboards requirements and to define business and functional specifications
- Analyzed and used various data sources - Oracle, Siebel and Excel
- Architecture and Installation of Oracle BI and Informatica software. Provided high availability and scalable solutions.
- Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
- Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects
- Developed few 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.
- Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
- Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
Environment: OBIA, Informatica Power Center 8.1.1, Oracle 9i/10g
Manager/Solution Architect
Confidential
Responsibilities:
- I was involved in the infrastructure and architecture for a global solution of Siebel Sales application for user base spanning across North America, South America, EULA and Asia. UL had a hetregenous system landscape with Linux, Solaris and Windows OS for Siebel application.
- Performed band-width testing for different regions, assisted in VPN tunneling for offshore resources, setup Siebel/LDAP/Active directory authentication, setup and deployed Siebel remote to 150 plus users, setup multi-currency and global-time zone to support global users, data migration of customers and contacts from peoplesoft HR using informatica ETL tool, Siebel to Lotus notes integration for Siebel thin client and mobile client, provided expertise and solutions to issues faced during design to deployment.
- Prepare infrastructure project plan and timeline, managed team of 4 consultants in onshore/offshore model.
- Installation and configuration of Siebel Server, Web Servers, Report Servers
- Design and Development of the Call Center Application
- Design and integration of CTI
- Design and Development of Data Conversion
- Integration of Call Center Application to Analytics
- Application and database performance tuning
Managing Consultant
Confidential
Responsibilities:
- Involved in the architecture, administration, data migration, performance tuning and deployment of Siebel 7.5 Call center application and Siebel Analytics 7.7.1 (OBIEE).
- The OneSource Application is based on a foundation of Siebel COT package and Global Development Center (GDC) CRM Siebel Framework.
- The OneSource Application is comprised of using the Siebel eAutomotive and eDealer components.
- The technical foundation of the GM OneSource Application is eighteen SUN and HP servers residing in the EDS Global Web Hosting facility.
- The SUN servers support the Siebel application. SeeBeyond and Oracle databases for OLTP and OLAP. All remaining servers are HP supporting the Siebel Document functionality.
- The appropriate middleware software is installed on each server to support the designated functionality of the server.
- The middleware software consists of Siebel, Microsoft Office, SeeBeyond, Informatica, and Trillium software.
- The final layer is the Siebel application code to support the business functionality of the GM OneSource Application.
- Used DAC for repository migration, ETL data loads, monitoring ETL jobs and other administrative functions.
Managing Consultant
Confidential
Responsibilities:
- Installation and configuration of Siebel Server, Web Servers, Report Servers
- Design and Development of the Call Center Application
- Design and integration of CTI
- Design and Development of Conversion from interchange to Siebel
- Design and Development of Interface of Oracle Financials into Siebel
- Interface to filenet for image retrieval
- Design and development of various level of security of the system
- Application and database performance tuning
Solution Architect/Lead
Confidential
Responsibilities:
- Installation and configuration of Siebel Servers and Web Server on SUN Cluster
- Siebel Upgrade from Siebel 6.0 to Siebel 7.5
- Configuration and setup of Chart Server and Actuate report server
- Siebel 7.5 implementation of 2 projects namely Global Service Sales & Asia-Pac with multiple languages
- Performed Data Mapping and Data load of Opportunities, Accounts, Contacts and Activities data
- Data testing and performance tuning
- Prototype of Siebel Customer integration with SAP using Siebel UAN and WebMethods
Architect/Technical Lead
Confidential
Responsibilities:
- Installing and configuring Microsoft IIS Web Servers
- Installing and configuring Siebel Server and Siebel Web Servers
- Setting up the Work Flows and Communication Management components
- Migrating data from SQL Server to Oracle Database
- Install, Setup and configuration of Fulcrum Search on for dedicated and web clients