Detailed Professional Experience

Confidential

Sr. OBI Programmer Admin

• Bank of America is the leading financial banking institutions that provide investments and insurances across the world. Business Intelligence in Bank of America develops dashboards that help the business to analyze the data on various projects implemented in the bank across the world. Worked in maintaining both OBIEE, Tableau and Informatica servers in the Bank involving Financial and HR LOB's
• Expertise in Business Technology group SME over OBIEE server configuration, storage/allocation to lead design process and build servers for new projects
• I meet with prospective bank user across the enterprise and work on projects involving OBIEE and Informatica attending business meetings demonstrating proposed architecture for customers business needs
• Designed data models for the business requirement based on the functional documents
• Architected, Configured, Installed and Clustered OBIEE 11.1.1.x version on both Linux Server and Windows Operating System in clustered environment
• Responsible for leading various projects for both HRIS and Finance LOB's on both OBIEE 10g and 11g versions
• Design and Implementation of OBIEE 11g BI Solution, RPD modeling and implementing best practices for RPD and Dashboard development
• Lead and upgraded 2 HRIS projects implemented using OBIEE 10g Platform to 11g on Linux 64 bit clustered environments
• Upgraded both OBIEE and BIPublisher reports from 10g to 11g on Linux Platform
• Implemented Single Sign-on SSO and Win-SSO for OBI using LDAP, AD Authentication
• Worked on various kinds of Authentication CDSN, AD and Authorization External Table, Enterprise Manager techniques for user and dashboard security
• Configured and Architected BIPublisher Plug-In to OBIEE Platform and created new Application Policies and Roles for BIP Users
• Installed Oracle 12c DB and SampleApp 309R2 for new features and better understanding of the tool
• Expertise in deploying all OBI Patches, Upgrades and Bug enhancements to current version in Linux and AIX platforms
• Expertise configuring Weblogic, Apache Web Server, BI Publisher, Usage Tracking, Scheduler iBot , MUD environment in OBIEE 11g
• Involved in Customizing Oracle BI Fusion Skins and Styles and web messages.xml files to better look and feel of the analytics dashboards as per the users requirements
• Lead both Non-Production and Production migrations for OBIEE and Informatica Projects across HR and Finance Projects
• Expertise in Upgrading OBIEE RPD and Web Catalog from 10g to 11g along with the Security User and Groups upgraded to Weblogic
• Maintained on a total of around 40-50 OBIEE and Informatica servers on day-to-day activities like Migration, Upgrades, Patches and Production Support
• Lead a major project in upgrading the entire HR Dashboards from OBIEE 10g to 11g on both Oracle and Essbase Databases
• Upgraded Informatica from 8.6.1 to 9.1 on a Linux Platform
• Expertise in maintaining Informatica Native Security with LDAP Integration
• Expertise integrating OBIEE with SmartView and creating new Application Roles as required
• Installed Configured Tableau 8.1 on the windows XP server with Active Directory Authentication and also creating users natively on the server
• Configured Caching using Data Connections, Email alerts by setting SMTP requests and maintenance of the servers by backup, upgrades
• Responsible for migrating the workflows and files across different environments using Informatica Repository Manager
• Effectively coordinated with the offshore team and business users during the complete design, production and post-production support
• Experience training the end users with Adhoc Functionality by preparing technical documentation for users analytics
• Helped architect manage risk analysis and mitigation plans, status reports, milestones and established critical success factor that leads to a successful environment

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.x , 10.1.3.4, Oracle BI Admin Tool, SmartView 11.1.2.5, Informatica 9.0.1, Tableau 8.1, SQL Server 2008, Oracle 10g/11g/12c, Essbase, Apache, Weblogic, MS Excel, TOAD, AIX, Red Hat Linux, Windows 7/XP,

Confidential

Sr. Consultant

CedarCrestone Business Intelligence team provides competitive advantage with our deep knowledge of ERP applications. CedarCrestone Business Intelligence has developed significant expertise in a number of niches including Higher Education, Energy Utilities and Healthcare organizations. Worked with projects in CedarCrestone as a OBIEE SME at different clients.

• Worked as a SME in installing OBIEE 11g Enterprise Edition on Windows machine and also installed Informatica PowerCenter 9.0.1 Client and Server
• Experience working with PeopleSoft EMP Financial warehouse model, Establishing the connections between the Pre-built RPD and Web Catalog
• Expertise customizing the Pre-Built Finance RPD Subject Areas depending on the data and report requirements
• Expertise working on OBIEE Custom Repository in creating new Subject Areas, Importing tables/views from both Relational Multi-Dimensional Data Sources
• Experience in merging the RPD and migrating the Repository and Web Catalog across environments
• Created different Application Roles and assigned required Application Policies depending on the requirement
• Experience working on all kinds of OBIEE various views available in the Answers and Performance tuning of OBIEE reports using Indexes, Caching mechanisms
• Helped tuning the OBIEE environment by changing the governors limits for various views depending on concurrent count of the users and implemented caching mechanisms
• Worked directly with the end clients to gather the requirements and prepared Technical documents

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.x , Oracle BI Admin Tool,Informatica, Oracle 10g, PeopleSoft EPM, Data Stage, TOAD, Windows XP

Confidential

OBIEE Technical LEAD

Bank of America is the leading financial banking institutions that provide investments and insurances across the world. Business Intelligence in Bank of America develops dashboards that help the business to analyze the data on various projects implemented in the bank across the world. Worked different projects in Bank involving different LOB's on both the OBIEE 11g and 10g version on different databases like Oracle, SQL Server and Essbase

Infra-Technical Lead:

Installed and Configured Oracle Business Intelligence OBIEE 11g and 10g for both HR and Financial LOB Groups. Implemented Single-Sign-On SSO and WinSSO for HR and ML User respectively. Expertise in applying OBIEE one of patches, Upgrading RPD and Webcat from different versions. Good exposure to OBIEE 11g Weblogic security and migrations to different environments. Expertise in configuring customizing OBIEE Usage Tracking, Skins Styles. Worked on Cache Management Techniques and Governor Limit settings of Presentation Server. Experience Installing Informatica 8.1 9.1 on Windows Linux Server. Involved in both OBIEE and Informatica Server maintenance along with exposure to automate deployments using shell scripts.

Development Technical Lead:

• Experience working on Financial Standalone Reports using OBIEE 11.1.x. Expertise building various kinds of Interactive Dashboards and Reports using Relational and Multi-Dimensional databases like Oracle 10g, SQL Server 2008, and Essbase Cubes
• Used the Microsoft SQL Server Management Studio to analyze the data in the database and query the reports and created reports using SQL Server Database
• Developed Physical, Business Logical and Presentation Layers in the Repository of OBIEE 11.1.x. Experience working on both Star Snowflake Schemas for the adhoc functionality requirement for the end user to create custom reports/dashboards
• Build different levels of repository building like Alias Tables, Stored Procedures, Dimensional Hierarchies, Level-based measures, and Time-Series functions for YTD, MTD, Aggregation, Aggregate tables, Repository Variables, Session Variables, Data Level Security
• Created reports using different views like View Selector, Column Selectors, Charts, Tables, Pivot Tables, Embedded HTML GoURL, Gauges across various Portfolio and Hoshin Dashboards for the Strategic Scorecard reporting across different LOB's in the Bank
• Involved in the meetings that helped the business to better understand the tool and train them to use the BI Answers for the Adhoc reporting
• Worked closely with Oracle Support Team to resolve the SR's that occurred during the development of various projects and the patches that were released by the Oracle on the enhancement and bugs from the current versions.
• Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.x , 10.1.3.4, SQL Server 2008, Oracle 10g, Essbase, MS Excel, TOAD, Microsoft SQL Server Management Studio 2008, AIX, Red Hat Linux

Confidential

Sr. OBIEE Developer

• Navistar is the leading Automobile industries that manufacture heavy Engine trucks and Auto parts for the heavy bodies. Business Intelligence Team delivers Enterprise reporting capability using a powerful combination of Oracle's business Intelligence Suite OBIEE dashboards, Pre-built reports, Answers Capability and queries for Business Intelligence users that leverage these tools. They deliver reports that helps the business to understand there Sales, Purchase and the Forecast information of the different parts and items that they manufacture. Reporting and publishing capabilities deliver pre-built reports in support of standardized business processes and decision making activities.
• Worked closely with the business in preparing both Functional and Technical document necessary for the report dashboard design
• Install, configure, and administer the OBIEE 10.1.3.4 platform on Windows 2003
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool
• Worked on Repository by building different subject areas and BI Answers in generating the reports and dashboards
• Worked on creating reports build on 3NF in the Teradata and also worked on Adhoc-Functionality on a subject area as per the Business request
• Involved in Repository Configuration, Troubleshooting, and Migrations to/from all the environments LOCAL to DEV to QA to PROD
• Extracted data from various systems like Teradata, Access database, Excel sheets and also from Flat Files using various connection pools in the Physical layer of the RPD
• Designed the Star Schema for all the different subject areas and build hierarchies, level-based measures, Aggregate level, Alias tables, Implicit Facts
• Used the Catalog Manager for the migrations to different environments and worked on the security of different groups and users
• Maintained the dashboards and Answers and Used Analytics Web Catalog to set up groups, access privileges and query privileges
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Colored Gauges, Column Selector, View Selector, global and local Filters using Oracle BI Answers/Analytics
• Implemented both Object-level security and also the data-level security on the report dashboards depending on the business requirements
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include Managers, functional heads, Department Heads for better understanding of business
• Involved closely with the Business users, Analysts and also the Data warehouse Team in the meetings to build good efficient data model and also worked on the performance of the reports
• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Data stage 8.1, Oracle 11g, MS Access, Teradata 12, Teradata SQL Assistant, Windows XP, UNIX

Confidential

Sr. OBIEE Consultant

• Description: New Breed is a logistics and supply chain company whose services range from distribution center operations and transportation management to highly sophisticated and technology-focused solutions. Primarily worked developing the reports for Verizon Wireless Communications data. This is a supply chain project with OBIEE, BI Publisher and also integrating Flash reports and giving the capability for the end user the adhoc functionality.
• Involved in all the meetings and worked closely with the business analysts from both the client and end client Verizon
• Also worked closely with Data warehouse team to get good knowledge on the data architecture to build efficient data warehouse with star schema
• Involved in migrations of the development from DEV to QA and finally to PROD environments on both Windows and Linux boxes using the version control tool called SVN
• Designed the star schema and snow-flake schema Physical, Business and Presentation in the repository as per the report design
• Created the hierarchies, drills, aggregation and level-based measures on different dimensions and measures in the BMM layer of the repository
• Worked efficiently in creating the session repository variables and also the assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns etc.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports
• Worked on BI Publisher reports in generating the templates PDF, and HTML from Analytics queries
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables
• Also worked closely with the Flex Developer while integrating the Flex in BI Reports for more flash and graphical reports
• Worked closely in migrating the RPD, Web Catalog, Security Groups, Users at the time of month end deployment
• Also applied the different OBI Patches both on the Windows and Linux boxes to the existing environment
• Used TOAD and SQL Navigator for the database queries.
• Efficiently coordinated with lead the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.

Environment: OBIEE 10.1.3.4. Oracle BI Publisher, Oracle 10g, Flash Builder 9, TOAD, , Windows XP, Red Hat Linux

Confidential

OBIEE developer

• Description: Cox Communications is a Telecom company that designs and manufactures the optical communication products like cables and wires. The company mainly deals with four main products like Data, Video, Telephony, and VoIP.
• NRSC project main aim is to develop a new data warehouse for the company using Oracle's out of box solution package with OBIEE and Informatica and thereby creating the reporting environment that helps the end users to analyze the reports.
• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform
• Worked closely with business users in the client side and designed the developed High Level Technical Documents required for building the project
• Involved in creating the Physical, Business Model Mapping Layer and Presentation layers in the repository
• Created connection pools, physical tables, defined joins in the physical layer of the repository RPD
• Built Time-Series calculations using AGO and TODATE functions, Hierarchies, Aggregation in the BMM Business mapping and modeling layer of repository
• Managed day-to-day RPD, Answers, Delivers/iBots as per the requirement
• Worked on various caching mechanisms to purge both BI Server and Presentation Server Cache
• Managed security privileges by maintaining both Data-Level Security and Object- Level Security
• Participated in the weekly/monthly code migration meetings during deployment cycle
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.
• Environment: OBIEE 10.1.3.4, Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Navigator, Windows XP

Confidential

Intern Developer

• Description: SUNY is one of the prestigious schools and universities in and around the New York City. The project was to centralize decision making system as part of data management which involved integrating and simplifying by dropping unwanted data elements, introducing new elements and combining data using ETL processes by providing composite and meaningful views to users which helps the managers to keep track of the sales information at various branches. It also helps in maintain the employees and students in the university.
• Involved in modifications of physical, business and presentation layers of metadata repository RPD using BI Administration tool
• Created Campaign Tracking Dashboards, Advisor Dashboards and Management Dashboard
• Generated various Analytics reports like Formulary Report and Direct Sales Report using different view available in OBIEE Analytics
• Managed appropriate security privileges on subject areas and dashboards according to business requirement
• Created IBots and delivered reports to subscribed users/groups
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Maintained existing subject areas and created new subject areas as per the modified Star schema information
• Worked with the end-users in developing ad-hoc reports using OBIEE Answers
• Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3, SQL Server 2005, MS SQL Server Management Studio, Windows NT