SUMMARY:

• Expert experience with various BI tools, including: OBIEE, COGNOS, SSRS, Informatica and Extensive experience with implementation, development, and customization for multiple projects.
• Strong BI & DW experience as a reporting developer (data model creation in the Repository, reports development at BI Answers, BI Dashboards, BI Publisher, Cognos Report Studio, SSRS) worked in implementation of DW projects from scratch following various SDLC cycles.
• Provided UAT & production support along working with the Engineering & Development teams on Oracle and SQL Server Data warehouses.
• Strong experience in using tools like Essbase Administration Service, Oracle OLAP and SSAS to develop Cubes for integration with reporting tools.
• Additional Experience with Oracle EPM products like Hyperion Financial Management and Hyperion Planning.

TECHNICAL SKILLS:

BI Tools: OBIEE12c/11g/10g; Oracle BI Publisher; Oracle BI answers; OBIEE12c/11g/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/12c; 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.1.3 Tools SQL*Loader; Toad; SQL Developer; IBM Clear Case.

OLAP Tools: Oracle OLAP, Oracle Essbase, SSAS.

PROFESSIONAL EXPERIENCE:

Confidential, Merrimack, NH

OBIEE Admin/Developer

Responsibilities:

• Installs OBIEE 12c on a Windows Server environment.
• Configures OBIEE 12C.
• Develops Repository, using BI Administration Tool.
• Creates OLAP Cubes using Oracle Workspace Manager.
• Creates Analyses and Dashboards.
• Develops Test scripts.
• Migrates OBIEE Objects to various environments.

OBIEE/BI Publisher Admin/Developer

Responsibilities:

• Collaborated with business users to capture, define and translate business requirements, to propose the appropriate data warehouse BI solution.
• Developed BI Publisher Data Models from various data sources, SQL, EXCEL, XML and others
• Developed Reports using BI Publisher with data coming from Hyperion Applications and other databases.
• Created Dashboards and configure proper access using Row-Level Security as well as Object Security for various users.
• Provided Users training and Application Support
• Migrated OBIEE/BI Publisher objects between various environments
• Developed Dashboards actionable Intelligence objects to support the Business processes.
• Created BI Publisher templates and sub-templates using from previous existing templates in format like Word, Excel and PDF.
• Created testing scenarios.
• Configured security settings for the reporting environment.
• Configured Bursting functionality for report distribution.
• Installed and configure OBIEE11g on a Windows environment.
• Managed Backups, Patches for the environment and Provide Production support.
• Developed Financial Reports using Oracle Financial Studio.

OBIEE Admin/Developer

Responsibilities:

• Collaborated with business users to capture & define business requirements and define the appropriate data warehouse BI solution.
• Designed, developed and implemented complex OBIEE user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.)
• Designed and developed the repository using BI Administration tool to support the reporting requirements.
• Implementeded and integrated metadata from multiple data sources into a single metadata database to allow for the integrated reporting of the data from those multiple sources.
• Set up Active Directory integration into OBIEE, Row wise Initialization, front end objects permissions.
• Managed performance options using the query cache and various settings used by the BI Presentation server and the BI Server components.
• Deployed repositories and catalogs, configured shared repositories and caches for the Cluster environment.
• Moved repositories, catalog and security settings between environments using Enterprise Manager, WLST and the BI Administration Tool.
• Applied patches to existing version of OBIEE as needed.
• Built Cubes with SSAS to use them as source in OBIEE.

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.
• Used Rules files to build dimensions and load data into the Essbase Server.
• Created and maintained Essbase application objects including Database outline, Calculation scripts and security settings.
• 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.

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.
• 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 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
• Extensively used Informatica to load data from wide range of sources such as flat files (CSV, fixed length), Oracle to Oracle.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.

OBIEE Consultant

Responsibilities:

• 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.

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, set up Microsoft Active Directory for authentication.

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.