SUMMARY

• Created, modified, and administered Oracle BI Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Worked with PowerCenter Designer, Workflow Manager to design mappings sessions and workflows in Informatica 8.6/9.01
• Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle BI Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (drill - down Hierarchies) and Logical and Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository..
• Experience in ETL using Informatica, ODI to facilitate Extraction Transformation and data Load from OLTP systems to Essbase Cubes, OLAP systems.
• Experienced in integrating various data sources like Oracle, SQL Server, Fixed Width delimited Flat Files & XML Files. Good understanding of Project Life Cycle and gathering requirements for ETL Development.
• Experience in Database Design, Entity-Relationship Modeling, Dimension Modeling, Star Schema & Snowflake with Kimball methodologies
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, OBIEE Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using BI Publisher.
• Experience in creating Dashboards with spatial interaction using OBIEE11g MapViewer with Google Maps and NAVTEQ Digital Maps.
• Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP Ability and aptitude in scheduling, tracking and prioritizing activities.
• Excellent analytical, interpersonal, problem-solving, troubleshooting skills.
• Ability to set and achieve goals, work well independently or in team, skills in identifying problems and meeting goals.
• Experienced in integrating JavaScript into Dashboards to enhance functionality.
• Experienced with various Hyperion, Essbase tools: Essbase Studio, Essbase Administration Console, Maxl, Hyperion Workspace, Smart View and Excel Add Ins
• Fluently speak and write English, French and German.

TECHNICAL SKILLS

BI Tools: OBIEE11g/10g; Oracle BI Publisher; Oracle BI answers; OBIEE11g/10g Administration Tool; Hyperion Financial Studio; Hyperion Workspace; Oracle Reports; Cognos 10/8.4/8.3; Framework manager; Cognos connection; Report Studio; Query Studio; Analysis Studio; Event Studio; Cognos Insight.

Databases: Oracle 9i/10g/11g; SQL Server 2008; Essbase.

Operating System: Linux; Windows 2000/03/ NT/XP, 7.

ETL: Informatica 8.6, 9.0; Oracle Data Integrator 11g; SSIS 2008.

Data Modeling: Erwin.

Languages: SQL; PL/SQL; MDX; CSS; JavaScript; XML; HTML

ERP: Oracle E-Business Suite R12.

Tools: SQL*Loader; Toad; SQL Developer; IBM Clear Case.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

OBIEE Admin/Developer

Responsibilities:

• Collaborate with business users to capture & define business requirements and define the appropriate data warehouse BI solution.
• Design, develop and implement complex OBIEE user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.)
• Integrate SSAS Cubes into OBIEE11g, use Hyperion Essbase to create additional Cubes in Oracle environment.
• Set Up Active Directory integration into OBIEE, Row wise Initialization, front end objects permissions.
• Monitor metrics and throughput gathered using JMX Mbeans, view and manage log files produced by the BI components.
• Managed performance options using the query cache and various settings used by the BI Presentation server components.
• Deploy repositories and catalogs, configured shared repositories and caches for the clustered environment.
• Move repositories, catalog and security settings between environments using Enterprise Manager, WLST and the BI Administration Tool

Confidential, Arlington, VA

OBIEE/ETL Consultant

Responsibilities:

• Effectively interacted with the end users for requirements gathering and defined requirement specifications document
• Worked extensively with Physical Layer, Business Layer and Presentation Layer, Built Hierarchies (Parent-Child and Level based) in the RPD.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables, built Business model and created joins both in the physical and Logical layer.
• Created different types of Customized Reports, Drilldown, and Aggregation, to meet client requirements.
• Created business reports, Dashboards, BI Publisher using OBIEE Analysis and Hyperion Financial Studio
• Managed/Set security privileges for each subject area and dashboards according to user requirements
• Set up LDAP authentication to enable Single Sign on for Users in various environments.
• Configured and managed Application role & Application Policies for Users & Users group using Enterprise manager.
• Completed migration of Web Catalog, RPD, Security settings between environments.
• Developed Cubes using Essbase Administration Services and imported them in OBIEE11g for reporting purposes.
• UsedRules filesto build dimensions and load data into the Essbase Server.
• Created and maintained Essbase application objects includingDatabase outline,Calculation scriptsandsecuritysettings.
• Trained End Users and Pilot Users on OBIEE Tools.
• Converted Oracle Reports to BI Publisher Reports.
• Performed configuration settings by modifying specifics files either manually or with Enterprise Manager, customize User Interface using CSS, HTML and XML as per client requirement.

Confidential, Rockville, MD

OBIEE/Informatica ETL Consultant

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics platform.
• Involved in the detailed design of the reports/dashboards and data model.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Also created hierarchies, variables, and event poll strategies in the repository.
• Enhanced performance by creating Aggregate tables, Indexes, Materialized Views and managing Cache.
• Modified some of the existing reports and dashboards, and fixing issues related to performance, data quality etc., during production support.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Extensively used Informatica to load data from wide range of sources such as flat files (CSV, fixed length), Oracle to Oracle.
• Used BI Publisher to create reports directly from the Database and from external Excel Files.
• Built BI Publisher RTF Templates using Template builder, Microsoft Excel, Microsoft Word Adobe Acrobat and XML. Created Bursting control files for developed reports.
• Created MapViewer metadata for spatial tables containing columns of type SDO GEOMETRY.
• Used Oracle Map Builder to in corporate customs map layers, Used OBIEE11g to manage, edit and customize Layers and background Maps.
• Created Map driven filters, prompts, Master-detail linked reports in OBIEE Dashboards.
• Identified and eliminated duplicates in datasets using Informatica
• Created transformations and mappings usingInformatica 9Power center to move data from multiple sources into targets.

Confidential, Madison, WI

OBIEE Consultant

Responsibilities:

• Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Used Oracle BI Analytics for generating Sales reports, which provides web-based reports for executives, managements and individuals.
• Extensively used BI Administration Tool for customizing and modifying the Physical, Business and Presentation layers of metadata repository.
• Created connection pools to retrieve data from Oracle Database.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Created custom mappings to accommodate customized fields. Utilized Intelligent Dashboards, Oracle BI Analysis, and BI Publisher for reporting requirements.
• Worked Extensively on Oracle BI Analysis, BI Publisher to create reports as per client requirements.
• Used Filters and provided Customized prompts appropriately for Reports performance.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Migrated Reports from OBIEE10g to OBIEE11g.

Confidential, Saint-Louis, MO

Cognos Developer Consultant

Responsibilities:

• Gathering the Requirements from the Management and Development teams for creating the Framework packages.
• Designing, Constructing the Framework Manager Models and publishing Packages to the Cognos Connection using Framework Manager.
• Created Framework Manager Models with multiple Namespaces.
• Created metadata model using Framework Manager, Created packages and published packages in Cognos Connection.
• Optimized the Models by using filters and calculations for better efficiency.
• Created reports using List, Cross tab and pie charts.
• Extensively worked on Report studio to develop complex reports using prompts like Cascading prompt, Select & Search prompts.
• Merged reports and formatted the reports, Created dashboard Reports in Report Studio.
• Involved in testing, validation and documenting the results.
• Participated into migration between instances.
• Set up object security based on users authorization privileges.

Confidential, Framingham - MA

ETL/Informatica Developer

Responsibilities:

• Member of warehouse design team, assisted in creating fact and dimension tables based on specifications provided by managers.
• Load data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Debugged mappings by analyzing data flow, evaluating transformations and create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Performed SQL Queries against Source and Target Databases to validate data.