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.
• ImplementedUsage trackingto 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.
• 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
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• OBIEE Repository and Catalogs as well as BI Publisher reports migrations
• Experience on upgrading from OBIEE 11g to 12C and internal OBIEE 12C versions
• Multi - platform experience on UNIX / Linux /AIX and Windows Server family.
• Worked on User management in OBIEE, Informatica and DAC
• Worked on four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• 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.
• Strong knowledge in data warehousing and data modeling
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

OLAP/Reporting Tools: OBIEE 12C, OBIEE 11g, OBIA, Discoverer, Tableau 9.3

ETL Tools: Informatica Power Center 9.1.0, ODI

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, Buffalo, NY

Senior Obiee Consultant

Responsibilities:

• Develops reports using different Analytics Views. Design and customization of Answers, Reports and Dashboards.
• Works on developing BI Publisher reports and bursting the reports to save to shared drive.
• Works on creating financial reports to business owners.
• Works on OBIEE & BIP reports enhancements.
• Works on bursting BI publisher reports to business owners for 4th & 5th business day of every month.
• Works on creating agents for OBIEE dashboards.
• Works on reports production issues.
• Works on RPD deployment.
• Works on catalog migration in DEV, QA and production environments.
• Works on user access management.

Confidential, Germantown, MD

Senior Obiee Consultant

Responsibilities:

• Works on JIRA, ServiceNow, CMMS ticketing applications on daily basis.
• Works on users management for DEV/QA/PROD environments.
• Hands on experience on LDAP, SSL, TLS, SSO, OHS set up.
• Works on PCI remediation for OBIEE vulnerabilities reported by Security team.
• Experience on EBS modules like GL, AP, AR, Supply Chain Analytics etc
• Hands on experience OBIA 11.1.1.10.2 installation and configuration.
• Participates in requirements gathering and functional design reviews
• Writes and execute detailed test scripts for OBIEE reports
• Experience on performance tuning of OBIEE reports.
• Experience on creating custom Visual reports in Power BI
• Experience on high availability and disaster recovery environment set up for NJ EZPass & FL Sunpass Tolling projects.
• Works as CM for production RPD, Oracle BI & Catalog maintenance and migrations.
• Assist with creation and updating of support/RCA/Resolution documentation.
• Participates in review meetings and weekly status meetings.
• Worked on application performance tuning and applying patches.
• Participates in application audit, risk execution and compliance requests.
• Provides prompt response on user/business requests for information.
• Leads offshore and onshore production support Team
• Works with Network, Database, Windows & Linux support team.
• Hands on experience on upgrade of 11g to 12C and OBIEE 12C
• Works on BI Publisher runtime properties.
• Works on export/import catalog objects in OBIEE.
• Participates in daily status calls, ensure project are deliverables on time.
• Works on creating RTF/PDF Templates for BI Publisher reports.
• Experience on migrating Crystal reports to OBIEE.
• Hands on experience on 11g to 12C upgrade.
• Hand on experience with SQL Developer & TOAD.
• Worked on BI Publisher runtime properties.
• Exposure on Microsoft power BI.
• Worked on configuring SMTP, FTP and Printers as delivery destinations for BIP reports scheduling.
• Works on EJB creation, deployment and server configuration to enable shared path configuration functionality to save the OBIEE reports Outputs to Linux server paths.
• Works on scripts that monitors the OBIEE services status for every 1hour
• Worked on Oracle Advanced Security settings for production databases that caused BI Server, Scheduler and Presentation services down After application set up due to security errors.
• Worked on migration of OBIA - OBIEE 11g APPS to OBIEE 12.2.1.0.0 application.
• Worked on installation of OBIEE on Azure environment.
• Imported Physical tables and defined relations between Physical tables at the Physical Layer.
• Created Hierarchies, Levels, and implemented Business Logic by creating level-based measures.
• Developed reports using different Analytics Views (Pivot Table, Chart, Column and View Selector).
• Design and customization of Answers, Reports and Dashboards.
• Creating the Dashboard prompts.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Measures in the BMM layer.
• Worked on session, repository variables, Presentation variables.
• Implemented the data level and object security in OBIEE end to end instances (DEV, UAT)
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges.
• Configured Agents in Delivers to send alerts to subscribed users.
• Creating Action Links and Master Detail Links for reports
• Implemented dynamic header and footer with logos for all reports using MS Word
• 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 Analytics Repository

Confidential, Malvern, PA

OBIEE Analyst

Responsibilities:

• 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 Markup 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.
• 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.
• 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.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Developed Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill- down capabilities, charts, and tabular using global and local filters.
• Developed intuitive and user-friendly Dashboards by appropriately including guided navigational links, prompts, and drill downs

Confidential

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

Confidential

Package Solution Consultant

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• 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.
• 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.
• 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.

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

Confidential

Software Engineer

Responsibilities:

• 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.
• Assess production faults and critical issues followed by identification of the root cause
• 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.
• Prepare documentation and communicate the status of the project to the management.
• 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.
• 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
• 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.

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.