SUMMARY:

• Over 7 years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence (BI) applications using OBIEE and BI Apps.
• Extensive experience in OBIEE 12c/11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6 which includes creating, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), OBI (BI Scheduler), BI publisher, BI (RPD and Web - catalog) administration.
• Experience working with GoldenGate.
• Experience with Multiple Business Intelligence tools like Tableau, SAP BOBJ, Power BI etc.
• Strong understanding of Data Warehouse concepts ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
• Strong working knowledge in Metadata modeling in all three layers (physical, BMM, presentation).
• Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
• Experience in administering various OBIEE environments with large number of users and providing optimum system uptime and performance; designing security matrix, configuring authentication and authorization architecture, and providing permissions to users per their role.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Expertise in developing OBIEE repositories from scratch, and 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 OBIEE Answers/Dashboard.
• Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts using Answers
• Extensive Knowledge on Oracle Delivers and Implemented schedule based iBots to deliver reports
• Worked Extensively on OBIEE Administration Tool, OBIEE Presentation Services, Answers, Interactive Dashboards and BI Publisher.
• Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2
• Strong Knowledge in Oracle SQL queries Performance tuning using Explain plan.
• Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Started Working on creating various Machine Learning Models to solve complex Business Problems with Python.

TECHNICAL SKILLS:

• Oracle EBS: R12/11.5.10
• HP Quality Center
• OBIEE 10.1.3.X
• 11.1.1.X & BI Applications 7.9.X
• Oracle 9i/10g/11g
• SQL Server 2000/2005
• Teradata
• Tableau
• Win XP/2003/2008 Win 7
• Windows NT/98 & UNIX (Linux)
• C
• C++
• SQL
• PL/SQL
• VS COBOL II
• Mainframe Focus
• Core JAVA
• Shell Scripting
• Informatica Power Center 8.6/8.1
• DAC 7.x
• HTML
• XML
• TOAD
• SQL*plus
• ODBC
• SQL*Loader
• SQL Developer
• Oracle BPEL
• ESB
• JDeveloper 10.1.3.3
• 10.1.3.4
• MS Project
• RMAN
• Oracle UCM
• Python
• Anaconda
• R
• Octave

PROFESSIONAL EXPERIENCE:

Confidential, Elk Grove Village, IL

BI Specialist - OBIEE and Data warehousing

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Documented and Managed OBIEE 11.1.1.7 Upgrade to OBIEE 12c
• Converted Reports from Discover(Legacy Software) to OBIEE
• Conducted Functional Requirements review and walk through with Stakeholders.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirement
• Assisted BI Admins in troubleshooting and root cause analysis of OBIEE Outages
• Worked with DBA’s on creating workarounds or reducing timings of long running queries
• Developed measure for time comparison using time functions, ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Implemented Row and Data Level security.
• Created Important KPI’s to serve the Leadership Team in Decision Making
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked on the memory utilization and reports using report optimization technique.
• Created Documentations of Test Cases, Developed Business Models, RPD Documentation to insure continuous stability and successful deliver of Projects
• Automated the Services Start and Stop using Shell Scripts
• Automated backup of Catalog, Repository and Config Files using Shell Scripts
• Extensively involved in tuning the server.
• Provided 24x7 on-call support for production / non-production environments.
• Involved in documentation of environment using Visio tool.
• Applied the patches to the WebLogic servers.
• Worked with ODI Architects to implement Business cases in ODI.
• Created Machine Learning Models for Quality Control
• Created Models to Identify the Customers at risk using Convolutional Neural Network(CNN)

Environment: OBIEE 12C, OBIEE 11.1.1.7, Oracle BI Publisher 11.1.1.7 SQL, Oracle Database 10g/11G Red Hat Linux 6 and IBM AIX 7.1, Keypass, Oracle UCM 11.1.1.7. Python, R, Anaconda, Octave, Matlabs

Confidential, Greenwood Village, CO

Principal Consultant - BI Apps

Responsibilities:

• Lead a Team of 2 Developers and 1 Admin(Offshore) in several successful BI Apps implementations.
• Managed Delivery and Sanitation of BI Apps Projects.
• Successfully implemented Oracle HR Analytics, Order Management Analytics, Procurement and Spend Analytics BI Apps modules.
• Created Data Model for BI Publisher Reporting.
• Installed and configured of Oracle BI Publisher on Red hat 5.0, IBM-AIX 7.1
• Installed and configured OBIEE on Red hat 5.0, IBM-AIX 7.1
• Configured UCM with BIPublisher/OBIEE
• Prepared the webcat and repository. Created security groups and application roles.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Managed Upgradation of OBIEE 11.1.1.7. to OBIEE 12c
• Developed Reports and Dashboard in OBIEE 12C
• Developed measure for time comparison using time functions, ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data Level Security.
• Expert in using OBIEE Analysis to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy.
• Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and managed security for groups in Analysis.
• Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables
• Worked on Repository (. rpd), customized the RPD with the requirements of the End User. Designed and Developed the three layers (Physical, BMM, Presentation)
• Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Implemented Delivers using iBots for delivery of report through email, hand held devices and mobile phones.
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Implemented Row Level Security.
• Lead of analytics tier in disaster recovery activity. Activity objective is to bring the application live after complete disaster of the environment. Involved in cross training to the new employees to understand the Application and responsibilities
• As per client requirement I have done the Skin and Custom Style Changes in Analytics.
• Integrated OBIEE with OUD and OAM.
• Automated the Services Start and Stop using Shell Scripts
• Automated backup of Catalog, Repository and Config Files using Shell Scripts
• Configured OBIEE and BIP with Oracle UCM (Web Center Content)
• ñ Installed, Configured and administered Oracle WebLogic Server 10/11g, and Webservers like iPlanet/Apache in
• Development, Test and Production Environments.
• Deployed applications (WAR, JAR and EAR) using WLST, Anthill
• Maintained Load balancing, high availability and Fail over for the servers
• Installed and Configured iPlanet/Apache Plug-ins for WebLogic.
• Installed and configured Siteminder for Sunone.
• Configured and created JMS queues & topics, Connection Factories, Datasources, connections pools & multi
• Connection pools.
• Extensively involved in Tuning the server.
• Set up Secure Sockets Layer (SSL) communication between iPlanet and the WebLogic Application Server.
• Writing various posting scripts for log rotation, log analysis.
• Migrated WebLogic Server applications from existing version to 10 to 11g
• Involved in performance tuning of JVM and used Garbage Collection Algorithms for better performance.
• Monitor and managing the weblogic server instances using WSLT and for the automation purpose.
• Involved in trouble shooting and fixing day-to-day problems of the applications in production, production-Fix and testing environments.
• Configured LDAP using directory Server for user authentication
• Installed BEA patches using Smart Update tool, and troubleshooting application and post- installation issues.
• Installed and Configured Wily Introscope and to monitor weblogic servers.
• Provided 24x7 on-call support for production / non-production environments.
• Involved in documentation of environment using Visio tool.
• Applied the patches to the WebLogic servers.

Environment: OBIEE 12C, OBIEE 11.1.1.7, Tableau, Oracle BI Publisher 11.1.1.7 SQL, Oracle Database 10g/11G, EBS R12.1.3, SQL Developer, RMAN, EXADATA, Red Hat Linux 5.5 and IBM AIX 7.1, Keypass, Oracle UCM 11.1.1.7.

Confidential, Chicago, IL

BI Apps Technical Lead

Responsibilities:

• Involved in upgrade of existing Sprint 2 system to Sprint 2.1 in test, UAT, production, break fix and training environment.
• Involved in upgrade where OBIEE 10g was replaced by OBIEE 11g in spectrum along with the existing environment.
• Involved in setup, installation, configuration of OBIEE 11g in Linux operating system also integrating with the existing environment. Involved in trouble shooting of errors encountered. And worked with Oracle support to analyze the issue.
• Executed the run installer for Data ware house and Informatica mappings as a standard process. Emplacing the OHSCDA help and image files and folders.
• Prepared the webcat and repository. Created security groups and application roles for OHSCDA.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Worked on Oracle application server and Apache web server.
• Worked on the environment setup of development, Test, Production, UAT, Training and break fix servers.
• Worked across Hyperion System and Essbase to create functional reporting structure for the finance Team
• Implemented and documented the best practices which are followed during the application installation and configuration.
• Worked on the Production environment and configured the clustered environment on the Linux system.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data Level Security.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy. Migration of Repository, Webcat and Informatica mapping across the environment.
• Create new tables and schemas as a part of Fusion middle ware setup. As part of OHSCDA2.1 upgrade new informatica mappings were created and synchronized by creating new database tables in the Data ware house.
• Created shell scripts to automate the start and stop services of the Admin server, node manager, Managed server and OBI server component services.
• Worked on various layers of OBIEE architecture Application layer, Presentation layer.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various
• Transformations and Workflows with Sessions or Tasks.
• Extensively worked on OBIEE repository modeling at Physical, BMM and presentation layer
• Designed, developed and customized Reports and Dashboards using different analytical views.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the adhoc reports per the client needs.
• Extensively worked with BI Publisher Reports and resolved the issues relating to BI Publisher and OBIEE integration.
• Created BI Publisher reports using OBIEE Answers: Union Report, Chart View, Drill Down.
• Created session variables for users to provide row- level security to build the query
• Implemented Row level, Column level and object level security.
• Used various options in an OBIEE to improve the performance of reports.
• Used OBIEE Answers to create the Financial Statement reports and Dashboards as per the detailed design requirements
• Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.
• Merged Presentation Catalogs (Web Catalogs) using OBIEE Catalog Manager
• Set permissions on users in Catalog Manager.
• Involved in setting up and working in multi-user developer (MUD) environment.

Environment: OBIEE 10.1.3.4.1/11 g, Oracle BI Applications 7.9.6.2/3, Oracle DAC BI Publisher SQL, PL/SQL, Oracle Database 10g, Teradata, Oracle EBS R12, Oracle 10g/11g, SQL Developer, Windows2003 server and Red Hat Linux 5.2

Confidential, Wooddale, IL

BI Analyst

Responsibilities:

• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements.
• Prepared Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
• Installed and Configured OBIEE11g (11.1.1.7) server on UNIX (Linux).
• Upgraded OBIEE 10g Reports to OBIEE 11g (11.1.1.7).
• Administered Web logic for OBIEE.
• Monitoring the progress of all the developers who built their respective dashboards.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Worked on fragmentation and partitioning concepts to enhance performance of the model.
• Used Evaluate function in rpd to push some of the functions to database.
• Created init blocks, session variables and used them in front end to set these variables.
• Involved in taking backups of Repository and Web Catalog files.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Created Time Series measures using AGO, To Date and Period Rolling functions.
• Created new Repositories/Subject areas and merged the same with different environments which are Development, Test, Stage and Production using Subversion.
• Developed automation tool to seed and purge the cache in Admin tool.
• Created users and granted permissions using BI Admin tool.
• Involved in Performance Tuning in BI by implementing aggregate navigation and cache management.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the OBI Application level.
• Extensively used write back, solution for insert and update in database.
• Created Presentation catalogs, and Folders in Presentation Layer in Oracle BI Administration Tool.
• Enabled Usage Tracking Table and Dashboards.
• Implemented dynamic dashboard prompts to zoom into segments of the business in a performance-optimized manner.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and from the data available in the Cache.
• Involved in setting up Ibots (Agents) to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Designed and developed Security Strategy and worked with Middleware to implement this in FMW.
• Modified NQSConfig, NQServer, Instanceconfig.xml files for Server configurations and troubleshooting reports performance.
• Developed Ad-hoc and standard Reports/dashboards with different Analytics Views - Drill Down, Drill across Cascading Style sheets, Pivot Table, Chart, Column Selector and Tabular with Prompts, Global and local Filters, Contextual Navigation, Business rules with user identity and role within the OBIEE suite.
• Worked in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.
• Implemented Data Level Security and Object Level Security using LDAP and External Tables.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Set up BI publisher Security to control access given to business users.
• 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.
• Used the OBIEE 11.1.1.x Administration tool to develop and enhance meta-data.
• Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
• Involved in One on One meeting with SME to understand the business scenario and process flow.
• Used Filters (Global) and provided customized prompts to avoid excessive data showing up in the reports.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Involved in setting up methods of usage tracking using Direct Insertion and setting up Log File. Merged the Usage Tracking Repository with the main repository (. rpd) to have dashboard based usage tracking.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository and TIMESTAMP Functions in the Answers.
• Worked on data from different sources and data at different levels of granularity to build the required functionality.
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources.
• Worked with Other Teams of Reporting, Data warehouse Developers and DBA's along with the Business Analysts and BRM's for requirement Gatherings and Feasibilities, Standards and Troubleshooting with the Issues along with QA Teams.
• Implemented user security authentication using LDAP server directory
• Involved in performance tuning for BI server and Oracle SQL queries.
• Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Performance Enhancement of the data ware house using indexing, partitions and running statistics.