SUMMARY:

• A Senior BI Technical Solutions Architect possess 13 years in the field of Business Intelligence & Applications and Data warehousing experience in IT cutting across OBIEE/BI Apps, ODI Apps, ODI11g, ODI12c, PBCS, BICS, ODI11g, OBIA, OBIEE10g, OBIEE11g, OBIEE12c, Hyperion, ODIA, Informatica, Exalytics, Exadata, Exalogic, Tableau, Big data, Data Modelling, OBIA Cloud Services, Performance Tuning.
• Highly competent Business Intelligence/Data Warehouse expert on OBIEE, ODI, ODI Apps, OBIA (Out of the Box Prebuilt Applications), and Oracle BI tools, ERP’s, OLTP & OLAP Applications.
• A dynamic professional with over 13 years of rich experience in Business Analysis, adept at QA methodologies, business process analysis & change management communication on complex projects.
• Involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics, Project Analytics, Manufacturing analytics .
• Implemented prebuilt solutions using ERP systems like Oracle EBS, PeopleSoft, and JD Edwards Enterprise One into Enterprise Business Analytics Warehouse (BAW).
• Strong experience in Project methodologies, SDLC, DW and BI infrastructure and architecture using middleware OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, and dimensional modelling using Star schema in Data warehouse life cycle.
• Hands on experience on metadata modeling Architecting BI/DW projects, configuring Data Warehouse Administration Console (DAC), Informatica ETL Process and a technocrat with expertise in systems design, implementation and testing.
• Responsible for the delivery of the DW/BI project and developing the solution architecture for the project.
• Coordinate with the implementation partner and business functions to finalize the requirements and deliver them in a timely manner
• Responsible for setting up the necessary infrastructure for the project and coordinating with various departments in IT for the interfacing requirements for developing the necessary extractions from source systems .
• Involved in end to end Hyperion suite installation and configurations.
• Expertise in ODI custom development.
• Expertise in Installation / Maintenance / Administration on OBIEE, OBIA, ODI, Hyperion suite , Exalytics, Exalogic with Exadata Servers .
• Implemented various SSO Integrations.
• Extensive knowledge of LCM (Life Cycle management).
• Expertise in Setting up of Cluster system for Fail Over and maintaining the
• Active/Passive structure.
• Installation on all the OBIEE components including ODI, Informatica, DAC, OBIEE10g OBIEE11g,OBIEE12c, ODIApps , BIApps in Windows, Linux, AIX, HP Unix and Solaris environments with experience in 20+ projects.
• Experience in OBIEE11g includes WebLogic and Enterprise Manager Configuration, Administration, implementing features like Map viewer, Master - Detail events, KPIs, Scorecards and upgrading deployments from 10g to 11g.
• Expertise in Merging, migrating the BI & ETL, ELT metadata and custom code, deploying Rpds and Catalogs between different environments and setting up, using Multi-user development environment.
• Implemented OBIA Clustered environments on Exalytics, Exalogic.
• Expert in fixing Performance related issues.
• Expert in fail over and load balancing for Servers.
• Expertise in OBIEE Repository component includes making changes to Physical, Logical and Presentation layers in BI Apps or custom rpd’s to accommodate changes made to the data model.
• Extensive experience in designing new rpd’s, data modeling in physical layer, creating different types of hierarchies, aggregate tables, calculated and time-series measures, creating variables, applying security and usage tracking.
• Experience in ETL includes configuring and loading BI Apps data for different source systems, customizing the OBAW warehouse, Using ODI tools and Informatica .Creating new mappings to fetch data from source tables and load it in to modified target tables.
• Experience in OBIEE11g includes WebLogic and Enterprise Manager Configuration, Administration, implementing features like Map viewer, Master-Detail events, KPIs, Scorecards and upgrading deployments from 10g to 11g.
• Experience in OBIEE Delivers configuration and creating and scheduling iBots/Agents for delivering reports to different targets including seeding cache.
• Set up SSO authentication and LDAP configuration, OBIEE Integration with Siebel OLTP.
• OBIEE Cache Management, OBIEE Performance Tuning, Architecting end state OBIEE Platform.
• Troubleshooting and Performance tuning with Oracle BI servers.
• Expertise in implementing Data security using Group and UI security with Web groups in OBIEE.
• Implemented in Financials, Procurement and Spend, Supply Chain and Order Management, Project, Manufacturing modules on Exalytics, Exalogic and Exadata Servers.
• Implemented ODIApps / BIApps Project on Exalytics, Exalogic, Exadata machines.
• Hands-on experience in using SQL, PL/SQL, Oracle Stored Procedures, Packages and Object types to meet data integration and processing requirements.
• Experience in handling Third party tools such as SQL Developer, SQL*Loader and Toad.
• Knowledge on database design - Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the database.
• Has Good knowledge on Oracle Data integrator, Oracle ADF and BI Publisher.
• Decisive with strong leadership qualities and flexible in work schedules.
• Experience in communicating with Onsite teams, Clients and managing offshore project teams numbering up to 12 resources.

TECHNICAL SKILLS:

High-end Servers: Exalytics, Exadata, Exalogic

DWH ETL/ELT Tools: Informatica 8.6, 8.6.1, 9.0.1,9.1.0,9.5.0,9.6, ODI 11.1.1.X,12c,Scoop

Databases: Oracle Database 10g,11g, Teradata, MSSQL

Reporting Tools: OBIEE, BI Publisher, Tableau, TIBCO, Pentaho, Splunk

Application Servers: Tomcat, WebLogic, Resin, Openlazlo, JBoss, OHS, OC4J

Programming Language: C, C++, PL/SQL, Java, Shell Scripts, Bash Script

Development/Productive Tools: SQL*Plus, TOAD, PL/SQL Developer

OOPS: JDK 1.4, JDK 1.5, JDK 1.6, C++.

Applications & Languages: J2EE (Servlets, JDBC, JSP), HTML, DHTML and XML, java, C, JavaScript, Hadoop

Web Servers: Tomcat 5.0,Apache,Resin,Openlazlo,lightstreamer,OHS

Database Servers: Oracle 10g, 11g, MySQL server, MS SQL server

Operating System: Windows 2003,2008, XP,7, 8,10, Linux, HP, AIX, Solaris

Tools: Dreamweaver, SSH, Putty, Toad

PROFESSIONAL EXPERIENCE:

Confidential, DETROIT, MI

Security Integration Architect / Sr Tech Lead / (OBIA with ODI11g) / Financials Techno Functional Consultant

Responsibilities:

• Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.
• Installed and configured OBIA and ODI on different environments.
• Implemented Financials, Procurement, Spend and Order Management analytics
• Implemented Custom BCBSM Budget reporting analytics
• Implemented Custom HR Attendance reporting analytics
• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Documented the OBIA ODI technical architecture, physical components, requirements and delivery of the components.
• Defined Data Standards, Guide Lines and Best Practices.
• Integrated OBIA LDAP authentication with AD servers
• Created principal users and SPNs.
• Defined Service Principal names and integrated with JAAS API
• Generated Custom Key tabs for SPN account
• Integrated Authentication headers and negotiate headers with WebLogic client and server
• Configured Kerberos config as per AD and WebLogic server
• Defined Roles and privileges
• Raised a new Oracle Product Enhancement requests for new SPN.
• Did Performance testing in several phases.
• Integrated applications based on Kerberos client / server authentication.
• Troubleshooted all issues while in development and execution.
• Migrated jobs in different environments.
• Scheduled ODI jobs in auto mode.
• Configured the WebLogic configuration and OBIEE Server configuration.
• Deployed new customized applications
• Redesigned new templates and configurations
• Fixed metadata related issues in ODI11g.
• Worked on custom development of Budget reporting.
• Built ODI mappings from Informatica mappings.
• Responsible for all activities related to the Implementation, administration, enhancements and support of ETL ODI processes including customization of several projects.
• Extensive knowledge of LCM (Life Cycle management).
• Migrated the artifacts from one environment to other using LCM.
• Expertise in Installation and Maintained Oracle data integrator (ODI).
• Validated the logical and physical architecture in ODI topology and context models.
• Responsible for viewing and managing production integration jobs using ODI Operator.
• Worked with ODI Graphical Modules (Designer, Topology Manager, Operator,
• Security Manager)
• Used ODI Security Manager for adding users and maintaining and restricting their privileges depending on the role of a team member.
• Expertise on ODI custom development.
• Coordinated monthly accounting close process managed administration of the Hyperion system (Essbase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment.
• Managing applications, databases, backups and restore; managing user security in shared services.
• Worked on maintenance, application and data backups and security.
• Responsible for Migration of application from One Environment to other.
• Responsible for looking into the performance issues, Disc space.
• Responsible for applying the needed Patches.
• Worked on Setting up of Cluster system for Fail Over and maintaining the Active/Passive structure.
• Knowledge of Change management for the System/Infrastructure Changes.
• Installed OBIEE12c on Linux machine
• Have done capacity planning for the OBIEE12c Server to support 500 users.
• Upgraded OBIEE11g rpd and catalog using migration utility and BAR utilities
• Migrated Security from 11g to 12c
• Integrated LDAP MSAD with OBIEE12c
• Configured Visual Analyzer connections for data mashups
• Configuring single sign on with Kerberos on OBIEE12c
• Configured BISQL and AD authenticators in OBIEE12c
• Implemented various roles and security access for various reports and dashboards.

Environment: OBIEE 11.1.1.7.1 , OBIEE 11.1.1.9.160419 , OBIEE12c, Oracle 11g, ODI11g, OBIA 11.1.1.9.2 , OBIA 11.1.1.10.1 , OBAW, Web Logic Server, Linux, SQL, PL/SQL, LDAP, Kerberos, WNA, PeopleSoft, DAC, Hyperion 11.1.1.2, Dimensional Modeling.

Confidential, Dublin, CA

BI Architect /Sr Tech Lead

Responsibilities:

• Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.
• Installed and configured ODI on different environments.
• Configured and Migrated ODI projects and metadata in different environments.
• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Documented the ODI technical architecture, physical components, requirements and delivery of the components.
• Built Custom Projects based on custom business requirements.
• Defined Data Standards, Guide Lines and Best Practices.
• Built ODI Interfaces/mappings as per custom requirements
• Built ODI Packages as per custom requirements.
• Built ODI Procedures as per custom requirements.
• Generated ODI Scenarios as per custom requirements.
• Scheduled ODI jobs in auto mode.
• Automated ODI Jobs in Control M Servers.
• Defined ODI Models and Logical connections.
• Defined Users Security in ODI 12c.
• Migrated ODI customizations to different environments.
• Fixed metadata related issues in ODI12c.
• Upgraded Exalytics server applied patches for fixing issues.
• Defined own custom shell / batch scripts invoked in ODI.
• Debugged ODI issues during runtime errors and automatized sending alerts from ODI to business users.
• Responsible for all activities related to the Implementation, administration, enhancements and support of ETL ODI processes including customization of several projects.

Environment: Exalytics OBIEE 11.1.1.7.1 , Oracle 11g, Exadata, ODI12c, OBAW, WebLogic Server, Linux, SQL, PL/SQL, Exadata Oracle 11g, Dimensional Modeling.

Confidential, Baltimore, MD

Architect (OBIA/ODI/Exalogic/Exadata)

Responsibilities:

• Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.
• Documented the technical architecture, physical components, requirements and delivery of the components.
• Installed OBIA 11.1.1.9.2 on Exalogic server
• Installed High availability clustered servers on Exalogic
• Installed ODI and OBIEE on clustered environments
• Balanced load configurations on Exalogic servers with load balancing and OHS servers
• Defined Application tier, ELT and Database tier for OBIA architecture.
• Configured BI APPS 11.1.1.9.2 (ODI/ETL, Configuration/Functional Setup Manger and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.
• Defined Data Standards, Guide Lines and Best Practices.
• Customization and validation of all the OOB Dashboards: Financial and Project Analytics dashboards with PeopleSoft Source.
• Configured BIACM components, Dimension and fact groups as per ODI Load plan.
• Configured ODI Domain load only plan and Custom data plan for loading the data
• Monitored and fixed the issues during the ODI full load and incremental Load.
• Built ODI Yellow Interfaces, Blue Interfaces /mappings as per custom requirements
• Built ODI Packages as per custom requirements.
• Built ODI Procedures as per custom requirements.
• Generated ODI Scenarios as per custom requirements.
• Scheduled ODI jobs in auto mode.
• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Validated the Source data and Target warehouse data after loads.
• Responsible for all activities related to the Implementation, administration and support of ETL ODI processes including customization of Prebuilt (OOB) Applications.

Environment: OBIA 11.1.1.8.1 , OBIA 11.1.1.9.2 , Oracle 11g, Exalogic, Exadata, ODI Apps, PeopleSoft 9.2, OBAW, Exalogic Web Logic Server 10.3.6, Linux, SQL, PL/SQL, Oracle 11g, Dimensional Modeling.

Confidential, Atlanta, GA

Architect (OBIEE/OBIA/ODI)

Responsibilities:

• Conducted meetings and Design sessions with Business Users, Analysts from OLTP and OLAP.
• Documented the technical architecture, physical components, requirements and delivery of the components.
• Configured BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manager and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.
• Documented the technical architecture, physical components, requirements and delivery of the components.
• Defined Application tier, ELT and Database tier for OBIA architecture.
• Configured BI APPS 11.1.1.7/8 (ODI/ETL, Configuration/Functional Setup Manager and OBIEE/RPD/Reports/Dashboards) on distributed environment and implemented Oracle out of the box Prebuilt Analytics.
• Defined Data Standards, Guide Lines and Best Practices.
• Customization and validation of all the OOB Dashboards: Financial Analytics dashboards against EBS 12R3 Source.
• Built ODI Yellow Interfaces, Blue Interfaces /mappings as per custom requirements.
• Built ODI Packages as per custom requirements.
• Built ODI Procedures as per custom requirements.
• Generated ODI Scenarios as per custom requirements.
• Scheduled ODI jobs in auto mode.
• Configured BIACM components, Dimension and fact groups as per ODI Load plan.
• Configured ODI Domain load only plan and Custom data plan for loading the data
• Monitored and fixed the issues during the ODI full load and incremental Load.
• Defined Data Standards, Guide Lines and Best Practices.
• Customization and validation of all the OOB Dashboards: Financial and Supply Chain Analytics dashboards against Oracle EBS Source System.
• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Responsible for all activities related to the Implementation, administration and support of ETL ODI processes including customization of Prebuilt (OOB) Applications.
• Customized GL related stack as per business requirements.

Environment: OBIEE 11.1.1.8.1 , Oracle 11g, Exadata, ODI Apps, ODI11g, Oracle EBS 12R23, OBAW, Web Logic Server, Linux, SQL, PL/SQL, Oracle 11g, Dimensional Modeling.

Confidential, Foster City, CA

Architect

Responsibilities:

• Installation and Configuration, Upgradation with OBIEE 11g, BI Apps 7.9.6.4 on Linux 64 bit server.
• Provided the OBIEE architecture with client specific design.
• Designed packages and deployed as per the client EBS HRMS module.
• Configured ETL Source files for HRMS and Financial modules. Designed and customized OBIEE RPD as per HRMS and Financial modules.
• Done Fit Gap analysis to meet system and Business requirements
• Integrated OBIEE11g, Informatica 901, DAC service components, High availability architecture, and custom development.
• Worked on performance tuning of the custom reports.

Environment: OBIEE 11.1.1.7, Oracle 11g, BI Apps 7.9.6.4, EBS11.1.5.8, EBS12R13.

Confidential, CA

Sr BI Lead

Responsibilities:

• Installed and upgraded OBIEE 11g, BI Apps 7.9.6.3, on Linux 64 bit Exalytics server.
• Provided the OBIEE architecture with client specific design
• Validated all the out-of-the box dashboards and resolved issues in configuration for the reports with errors.
• Worked on reports Performance tuning.
• Implemented object and data level security & custom Aging Buckets beyond the ones supported out-of-the box.
• Implemented Usage Tracking and developed custom reports with new aging buckets.
• Deployed and tested Financial, Procurement Spend, and Manufacturing Analytics.
• Worked on performance tuning of the custom reports.
• Integrated OAM SSO with OBIEE11g & PHP with OHS server and OBIEE11g.

Environment: OBIEE 11.1.1.6.9 , Linux 64 Bit, Exalytics, Exadata, OBIEE 11g on Windows, BI Apps 7.9.6.3

Confidential, WI

Sr BI Lead

Responsibilities:

• Implemented Initialization blocks to populate Session and Repository variables which were used to default the reports for Current Quarter id, Current Month id etc.,
• Created Conditional Agents to trigger Alerts and send email to users notifying the action to take. Dashboard Page which is used to get the Shipment details regularly.
• Implemented Guided Navigation to let users see only relevant reports based on different business scenarios.
• Worked on Agents to send alerts to the Managers.
• Enables Caching for better performance and implemented Event Pooling for Automatic Purging of Stale data.

Environment: OBIEE 11.1.1.5 , Oracle 11g , EBS AIX 64 Bit, OBIEE11g on Windows, BI Apps 7.9.6.3

Confidential

Sr BI Lead

Responsibilities:

• Inventory Daily Balance Fact
• Inventory Monthly Balance Fact
• Material Transaction fact
• Items Metrics
• Resources Metrics
• Standard Operations Metrics
• On-Hand Inventory by Item Metrics
• Production to Plan Metrics
• Analyzed the Source qualifier queries from Informatica mappings SQL Query mapplets.
• Picked up the Source qualifier queries, based on joins, builded Yellow interfaces and Blue interfaces.
• Built custom Procedures and mappings/interfaces.
• Based on lookups in Informatica converted the lookup data in the ODI mappings/ interfaces.
• Built Packages based on flow control and check control.
• Generated/ Built Scenarios for automated Load Plan.
• Defined Mail alerts to business users based on Job flows.
• Ran the ODI scenarios/Packages meet the existing processed data.
• Verified and validated the data from one environment to other environment.
• Automated ODI jobs based on task level.
• Defined load plan executions.
• Migrated custom code to different instances.

Environment: OBIEE 11.1.1.5 , Oracle 11g , Linux 64 Bit, OBIEE11g on Windows, BI Apps 7.9.6.3, Informatica 9.0.1, ODI 11g

Confidential

BI Lead (OBIEE/OBIA)

Responsibilities:

• Installation, configuration using OBIEE 11g, BI Apps on Linux 64 bit server using HR/Financial Analytics.
• Provided the OBIEE architecture with client specific design
• Integrated OBIEE11g, Informatica 901, DAC service components.
• Implemented Security concepts like Authentication, Authorization and LDAP Configuration.
• Implemented Usage Tracking.

Environment: OBIEE 11.1.1.5, Oracle 11g, PeopleSoft 9.0, Linux 64 Bit, Windows, BIApps 7.9.6.3

Confidential

BI Consultant

Responsibilities:

• Installed OBIEE11g and configured the new Rpd and catalog.
• Implemented most of the OBIEE 11G features like Map viewer, Master Detail Hierarchies, Master Detail Linking, Slider functionality and etc.
• Involved in Design and Development of OBIEE 11g Rpd and Reports.
• Delivered robust technical solutions by leveraging the technical expertise.
• Developed various Complex OBIEE reports using various report views.

Environment: OBIEE 11.1.1.5, Oracle 11g, Win 2003

Confidential

Sr Software Engineer

Responsibilities:

• Partnered with the OBIEE team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.
• Worked with the ETL team to design the Star Schema and populate the Data warehouse.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports) and Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Created Users, Groups and giving the permissions in Administration Tool and verified the permissions of the users in the OBI domain
• Designed Interactive Reports & Dashboards and created dashboard prompts with multiple selections.
• Integrated reports created in Oracle BI Publisher with Oracle Business Intelligence Enterprise Edition.

Environment: OBIEE 10.1.3.4 , Oracle 10g , Win 2003