SUMMARY:

• Overall 8+ years of experience in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design / Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.
• Strong technical knowledge of OBIEE Architecture.
• Very strong experience in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling Agents.
• Experience on Multi-User Development Environment (MUDE).
• Experience on EBS modules like Financial, Supply chain Management and HR etc
• Implemented Usage tracking to analyze and tune the query performance.
• Expertise in creating Calculation Measures and Dimensions, using Initialization Blocks and Variables (Session and Repository), adding multiple sources, executing direct Database requests, Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on (SSO) etc.
• Executed software projects for Insurance, Healthcare and Power & water domains.
• Changing parameters in Presentation and BI Server configuration files based on report requirements.
• Worked on Cleanup project to reduce the size of repository and catalog by deleting unused user reports for past one year
• Worked on Retirement project that reduces ETL loads twice by pointing repository and reports to original ETL tables rather than developer created customized physical tables
• Bouncing the OBIEE Services such as Admin server, managed server and system components.
• Business Analysis experience with excellent communication & interpersonal skills, broad understanding of business operations and requirements.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• OBIEE Repository and Catalogs as well as BI Publisher reports migrations
• Install, upgrade, configuration, maintenance and troubleshooting of OBIEE environments
• Experience on upgrading from 11.1.1.6.8 to 11.1.1.6.12, 11.1.1.7.150120 and 12.2.1.0, 12.2.1.1.0
• Multi-platform experience on UNIX / Linux /AIX and Windows Server family.
• Worked on User management in OBIEE, Informatica and DAC
• Experience on OBIEE 12C installation and configuration
• Staring & stopping of Informatica services such as Integration service, Repository service at the time of several outages.
• Killing user connections/locks of PowerCenter objects.
• Deploying of Informatica objects, parameter files and the scripts among different environments using PowerCenter manager/designer/repository manger.
• Worked on four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Created mappings using various transformations of Lookup, Aggregator, Expression, Stored procedure, Sequence Generator, Router, Filter, and Update Strategy.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience on informatica IDQ
• Monitored Execution plan runs in DAC client and worked on issues such as making DAC server up, checking DB connectivity.
• Worked on changing settings like Informatica servers, Physical data sources in DAC client.
• Participated in review meetings and weekly status meetings.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans.
• Strong knowledge in data warehousing and data modeling
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

OLAP/Reporting Tools: OBIEE 12.2.1.2,OBIEE 12.2.1.1.0, OBIEE 12.2.1.0,OBIEE 11g,OBIA, Discoverer, Tableau 9.3

ETL Tools: Informatica PowerCenter 9.1.0

Databases: Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2008

Data Modeling: Dimensional Data, Star Schema, Snowflake, Tables, Physical, Logical

Languages & Scripting: SQL, PL/SQL, Java, J2EE, XML, HTML, C, C++

Schedulers: DAC 11g

Operating Systems: IBM AIX 7.1, UNIX, Linux, Windows 9x, XP, Windows Server 2008,2012

PROFESSIONAL EXPERIENCE:

Confidential, Germantown, MD

OBIEE Admin

Responsibilities:

• Hands on experience in OBIEE 12C installation and configuration.
• Hands on experience OBIA 11.1.1.10.2 installation and configuration.
• Hands on experience OBIEE 12.2.1.0 to 12.2.1.1 & 12.2.1.2.
• Hands on experience on Active Directory set up.
• Worked on EJB creation, deployment and configuration to enable shared path configuration functionality to save the OBIEE reports Outputs.
• Worked on scripts for appending date & time stamp as prefix for scheduled BIP report outputs.
• Worked on scripts that monitors the OBIEE services status for every 1hour.
• Worked on script that archives complete BI services instance as a backup.
• Worked on major server issues such as No predefined scripts (start/stop/status) running, No device space left on device, Java heap
• Size, Unable to run wlst.sh - No class loaded .
• Worked on critical server to function properly in severe stage which decided to rebuild the environment by clearing the trillions of Map
• Viewer image files which occupied 100% of INodes and mount space.
• Worked on Oracle Advanced Security settings for production databases that caused BI Server, Scheduler and Presentation services down
• After application set up
• Worked on RPD deployment and catalog migration.
• Worked on Administration tab in analytics issue.
• Worked on user access to development/QA/PROD environments.
• Worked on configuring SMTP, FTP and Printers as delivery destinations for OBIEE & BIP reports scheduling.
• Worked on configurations that helps to download/export 5 millions of records in reports
• Worked on migration of OBIA - OBIEE 11g APPS contents to OBIEE 12.2.1.0 application.
• Worked on installation of OBIEE on Azure environment.
• Worked on image sizing and deployment on images server paths
• Worked on application performance tuning.
• Leads offshore and onshore Admin Team
• Trains development and testing team.

Confidential, Malvern, PA

OBIEE Analyst

Responsibilities:

• Hands on experience in installing, upgrading from 11.1.1.17.150120 to OBIEE 12.2.1.0, OBIEE 12.2.1.1.0, OBIEE 12.2.1.2
• Understand and enforce the best practices of OBIEE environment
• Handle multiple environment administration simultaneously
• Assess OBIEE environment faults and issues followed by identification of the root cause
• Provide remedial measures to the OBIEE environment issues or failure
• Implement and maintain Clustering, Fail over/Disaster Recovery and scale out setups
• Sizing & capacity planning of the environment
• Configuring and maintaining Security setups, SSO configurations in OBIEE
• Administering system backups and recovery when required
• Monitoring and ensuring optimal and consistent system level performance
• Tuning of performance levels when required
• Liaison with Database DBAs, network admins, UNIX/LINUX admins to ensure optimum service levels
• Outage planning and administration
• App server/Weblogic server configuration & maintenance
• Implemented SAML, AD Authentication
• Worked with Windows team to reroute the server urls to BIG IP urls
• Implemented ACT AS functionality for users to access catalog folders which has data level security.
• Worked with DBA to create DB link and triggers to access the OBIEE 11g and 12C related databases at a time.
• Worked on BIP Schedules migration and upgrade from 11g to 12.2.1.1.0
• Proactively worked on defects raised during QA and PROD UAT.
• Worked on connection profile which has all connection pool details that overrides with MUDE RPD with environment specific connection pools to avoid manual effort of changing connection pool for each and every environment.
• Worked on scripts that takes latest MUDE RPD, copies the current RPD to local path, overrides the connection profile and upload the RPD in 12.2.1.1.0
• Worked on several configuration changes like increasing the number of BI Publisher scheduling jobs count, Online reporting data size issues and excel export more than 170k rows.
• Applied patches for OBIEE 12.2.1.1.0 breadcrumbs, hyperlinks enabling for non-hierarchical columns, the opening dashboard page next to hidden page makes other pages invisible, Home page VA & Go to Home Page and HTML Mark up not working in migrated reports from 11g to 12.2.1.1.0 issues.
• Worked on configuration changes of Skin & Style of OBIEE & BI Publisher which has column headers wrapping, data cells spacing and prompts alignment issues by default skin of 12.2.1.1.0 version, disabling the scrollbar in all reports,BI Publisher scheduling jobs, SQL Query timeout and report data exceeded maximum limit issues.
• Worked on GO URL implementation in ActionFrameworkConfig.xml file, created a bi server variable that takes the server details of current environment and makes Action links to work without manually effort of changing the server details in all environments when we migrates the catalogs.
• Proactively worked with Oracle Support for functionalities issues in 12.2.1.1.0 and resolved them.
• Participating in daily upgrade scrum calls both with Offshore and Onsite clients, UAT calls, gathers the open issues and resolved them within estimated timeliness.
• Worked on complete instance validation and listed intended behavior changes like graphs reverse order, column header coloring in pivot, additional dashboard sub page, New Dropdown change, additional more option in dashboard properties, ability to change the Subject Area sorting in 12.2.1.1.0 version.
• Worked on creating the VA role, script to revoke the Author Role access and providing access to VA Role to restrict the VA usage to all users.
• Analyzing the performance of VA like dashboard folders taking time to open, enabling Case insensitive search and contains search by default, Multiple Queries getting triggered while performing search, Cancel of a report in VA does not cancels the associated database session and provided the root cause analysis to Oracle for product enhancement.

Confidential, Charlotte, NC

Sr OBIEE Developer/Administrator

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Migrated and merged OBIEE Repository.
• Server Space management as per the need.
• Worked on creation of weekly reports on change requests, service requests, incidents and problem tickets.
• Extensive experience on Service now and ALM tools
• Bouncing the OBIEE services to support quarterly Linux servers patching.
• Worked on configuration file changes according to developer requirements.
• Worked on Cache management and created automation scripts for cache purge.
• Worked on 12C installation, configuration and upgrade.
• Worked on setting up Audit feature in OBIEE.
• Extensive experience on performance tuning.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security.
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Experience on configuration file changes for user requirements.
• Worked in End to End construction of the BI model from repository to reports development.
• Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, graphs, conditional formatting of reports to satisfy the end users.
• Designed and developed physical, logical and presentation layers of the repository with new data model changes.
• Developed dimensional hierarchies to facilitate the drill down and report navigation.
• Customizing the Look and Feel of OBIEE Application as per the requirements using CSS style sheets.
• Created connection pools, physical tables, defined joins in the physical layer of the repository.
• Creating column level prompts, page level, global prompts in answers and dashboards.
• Configured Bi Scheduler and created agents to schedule and deliver Analytics content to multiple delivery destinations
• Enabled Usage Tracking to monitor the usage and performance of reports.
• Worked on MUDE (Multi User Development Environment) in OBIEE.
• Worked on External table authentication.
• Worked on writeback functionality.
• Experience in OLTP / OLAP System Study, Analysis and ER modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modelling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modelling.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Acted as a bridge between end users (Business Analysts) and Infrastructure team.
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.
• Validating the data and formats for the existing reports in the Dashboards.
• Worked on bursting the reports as per the annual release.
• Working on the converting the logical sql to physical sql in the BI publisher reports and improve the performance of the BI Publisher reports during the bursting.
• Experience in designing Mini Schemas/Data Models/Data Marts for Legacy Systems in Oracle and develop Reports out of OBIEE answers, dashboards as per business requirement.
• Responsible for project documentation (documenting functional, technical documents, preparing test cases/test plans and KT plans).

Environment: OBIEE 11.1.1.7/11 g,OBIEE 12C, RPD, Datastage, XML/BI Publisher, SQL Developer, Unix/Linux, HTML, Javascript.

Confidential, Charlotte, NC

OBIEE Consultant

Responsibilities:

• Worked on building reports in answers and placing them in dashboards and formatting changes as per requirements
• Implemented RPD for Project Accounting, and created the reports and worked on RPD Model Changes for different requirements.
• Modified some of the existing reports and related dashboards, and fixed the issues related to reports, performance, during production support.
• Worked on LDAP implementation and External table authentication.
• Worked on merging Repositories.
• Worked on setting usage tracking in OBIEE.
• Worked on creation of repository variables and session variables.
• Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
• Created connection pools, physical tables, defined joins in the physical layer of the repository.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Configured Agents to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 11.1.1.7/11 g,RPD,Informatica Power Center 9.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 11g, XML/BI Publisher, SQL Developer, Unix/Linux.

Confidential, Dallas, TX

OBIEE Developer

Responsibilities:

• Interacted with business end-users, management, and other customers to assess computing needs and requirements system
• Consult with Business Analysts in analyzing Functional Requirements, and with Business Users in Prototyping Dashboard User Interface.
• Worked extensively on customizing.
• Customizing OBI Repository (Physical, Business and Presentation layers).
• Implement object and Data level security, includes Web Administration, repository administration, creation of user groups and granting privileges.
• Identify causes of performance issues and helped to resolve the same.
• Train business users on Analytics dashboards, and technical super-users on repository migration from test to production environment: s in compliance with Oracle best practices.
• Design the test cases for all the initial requirements.
• Involved in configuring, creating and modifying repository for various modules for necessary customizations.
• Interacted with end users and developers to validate the data model.
• Requirement validation of the reports and drilldowns with business users.
• Customized the repository and created new requests using Answers.
• Extensively used repository variables, session variables and presentation variables.
• Worked on setting up column level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository
• Performed migrations (rpd and webcat) from Development to QA and QA to Production environments.
• Worked on Multi-User Environment (MUDE) by merging and importing multiple projects throughout the development phase.
• Created, modified, and administered analytics intelligence dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Created user level security for intelligence dashboards based on Business Requirement.

Environment: OBIEE 11.1.1.7/11 g,RPD, Unix/Linux, Informatica Power Center 9.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 11g, XML/BI Publisher, SQL Developer.

Confidential

OBIA (OBIEE, Informatica & DAC) Administrator

Responsibilities:

• As an OBIEE Administrator, was responsible to deal with,
• Design and implement data in various layers including physical, business and presentation.
• User management like creation, deletion of users and groups and assigning roles to them.
• Maintains overall security, SSO, OBIEE content and Data level security.
• OBIEE Repository and Catalogs migrations.
• Server space management for various log file, cache files, back up files.
• Monitoring the overall OBIEE usage on server and capture the usage spikes to improve the performance.
• Changing parameters in Presentation and BI Server configuration files based on report requirements.
• Bouncing the OBIEE Services such as Admin server, managed server and system components.
• Assess production faults and critical issues followed by identification of the root cause
• Daily monitoring of OBIEE Services on servers.
• Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise.
• Work in collaboration with development and software support team
• Deal with on-shore and off-shore clients and ensure project delivery on time.
• Extensive experience on Service Now tool.
• Worked on setting up Auditing and monitoring in OBIEE.
• Worked on several changes request, problem and incident tickets for OBIEE report and data issues.
• Experience on upgrade of 11.1.1.6.8 to 11.1.1.6.12 and 11.1.1.7
• Prepared Weekly reports to present to client in status meetings.
• Created automated scripts for cache management in Dev, QA and Production environments.
• Worked on LDAP Authentication.
• Resolved all critical issues within SLA.
• Worked on enabling usage tracking in all environments.
• Research and remain abreast with latest technologies and techniques to recommend new changes or upgradations
• Prepare documentation and communicate the status of the project to the management.
• As an Informatica/DAC Administrator, was responsible to deal with,
• Creation, modification and Access of Users, Folders and Connections.
• Maintaining all level of securities for all Repositories
• Responsible for the Administration of Informatica Server, User Administration.
• Staring & stopping of Informatica services such as Integration service, Repository service at the time of outages.
• Killing user connections/locks of PowerCenter objects.
• Deploying of Informatica objects, parameter files and the scripts among different environments using PowerCenter manager/designer/repository manger.
• Creation of Connections from the Informatica level. Creation of Oracle, Teradata, ODBC, SAP, Sales force and Sybase connections.
• Scheduling using Informatica PowerCenter Manager
• Fixing the issues related to database/connectivity/code while monitoring the loads by checking the logs and taking necessary action. Involving DBA/Support teams if needed to work together and fix the issues quickly
• Checking the mount points space, server memory utilization and take necessary action to maintain the better performance
• Take the .profile backup for maintaining safety & adding the new entries during new installations.
• Solving tickets and working with the Dev/support teams to help them completing the projects in time.
• Responsible for the Quarterly outage of recycling the servers by sending communication to the business and working along with the DBA and server teams during the outage and bounce the applications accordingly.
• Monitoring of Execution plan runs in DAC client and taking necessary actions such as making DAC server up, checking DB connectivity.
• Changing the various settings like Informatica servers, Physical data sources in DAC client.

Environment: OBIEE 11.1.1.7/11 g,RPD, Unix/Linux, XML/BI Publisher, SQL Developer, Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 11g.

Confidential

Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 9.1.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote Unix scripts, perl scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Unix/Linux, Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 11g, SQL Developer.