PROFESSIONAL SUMMARY:

• 13 + years of Total IT experience.
• 9+ years of BI Solution Specialist possess and Architect in Business Intelligence Applications using Bigdata Hadoop,OBIEE/BI Apps and Tableau, SAP BO, Hypérion Essbase with Oracle EBS R12 source background.
• Worked on all phases of DW/BI implementation lifecycle from conceptualization, requirement gathering, document Business requirements such as (Oracle standard MD - 50,MD-70 ), analysis, design, implementation, testing, Server Administration, maintenance and support.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partner’s relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Business Stakeholders to understand the future initiatives and define scope, high level application architecture, system impacts
• Tremendous client interfacing experience and exposure to Pre-Sales activities including PoC, Project Costing, Proposal Making, RFP, RFI.
• Expertise in Business Intelligence Applications using Oracle Business Intelligence (OBIEE/OBIA) in Financial, HR modules.
• Installation & Creating repository OBIEE 12c & 11g administration Tool on Linux/windows.
• Experienced installing, configuring, administering and troubleshooting of Oracle Fusion Middleware products (OBIEE/BI Apps,BI Publisher,OAM,OID etc).
• Implemented Migration projects from SAP BO and Cognos BI and Micro strategy to OBIEE.
• Setting up the OBIEE environments in Linux, UNIX, windows with SSO setup.
• Installation, Configuration & Administration on ODI 11g/12c environment with scheduling& monitoring.
• Experience using Oracle, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI).
• Experienced with Informatica ETL and Confidential configuration Administration and train developers.
• Installation, configuration of Exalytics box, OBIEE on Exalytics with TimesTen in-memory DB.
• Extensively worked on the Remediation projects on the Oracle BI Apps Financial Analytics.
• Studied the Existing Oracle EBS source data table structure and data flow and worked on the Fit Gap Analysis to implement BI Apps Project.
• Develop and maintain project plans, including Work Breakdown Structures, timelines, resource plans, training plans and any other project related plans.
• Good knowledge in Oracle Utility Analytics only functionally and technical process to implement.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Administration skills with Tableau Server Admin 9.0,Tableau Desktop, Tableau Online.
• Work directly with business units to define and prototype QlikView Applications

TECHNICAL SKILLS:

• Oracle Business Intelligence, BI Applications, BI Publisher
• Middleware Products: Weblogic, Portal, serviceBus, SOA, webcenter, OAM, OID
• Microsoft Business Intelligence Tools, SSAS, SSIS, SSRS
• Microsoft Windows Server, SQL Server, BIDS, SSMS, Data Tools
• Dashboards, Scorecards, Report Builder, Power View, Tableau
• Methodologies & Framework: Information Delivery, Data warehouse, Kimball, Data Science Life Cycle
• Technologies: Microsoft BI, OBIEE, Tableau, Confidential Neteza, QlikView, Business Objects
• Emerging Technologies: Hadoop, Statistical R, In- memory Analytics, Cloud,Splunk Monitoring.
• Industries: Manufacturing, Oil & Gas, Health Care, Retail, Manufacturing, Finance, Education / Publication
• Database & ETL/ELT Tools: Informatica, ODI, Oracle warehouse Builder Oracle, Plsql.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

OBIEE/ODI Architect/OBIEE Business Analyst

Environment: Oracle BIEE, BI Apps, Tableau, ODI 11g Database: Netezza DB, Oracle, flat files. Informatica 9.5

Responsibilities:

• Requirement gathering from the business and leading the project and creating the required design documents.
• Involved in assisting building detailed project schedule, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.
• Upgraded to higher version environment from OBIEE 11.1.1.7 to 11.1.1.9
• Designed and tested reports in the Dashboards for the Oracle HR Analytics modules like compensation, HR Performance, Retention and Workforce Profile.
• Assists in Self Service HR and Self Service benefits configuration and troubleshoot customization issue.
• Provided HR benefits and Salary base table and column information to technical team and assists them in defining OBIEE Repository requirements, and defines design and content requirements for Dashboards.
• Designing the whole solution to integrate Employee attributes from HR Analytics tables with timesheet data feed from Clarity tool. This is to create comprehensive data set that can be analyzed through Tableau.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Designing the solution to integrate existing Oracle data ware house data to GBS data ware house, this is to create comprehensive data set that can be analyzed through Tableau.
• Created parameters for Prompts in Calculations for various Tableau workbooks and dashboards.
• Executed and tested required queries and data before publishing Dashboard to Tableau Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created complex data Views manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Performed Tableau administration function like Migration of Tableau Workbook and Dashboard from one server /environment to others.
• Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Designed multiple Dashboards for CDI, helping them to convert from manual reporting
• Creating currency conversion table and loading currency conversion data from rss feed. Also loading factual data after converting it into US dollars using the currency conversion table.
• Set up the ODI Topology including physical architecture, logical architecture and context.
• Performed reverse engineering for the data sources and targets and performance tuning on ODI interfaces.
• Optimized the knowledge modules to improve the functionality of the process.
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Experience with MPP Databases like Netezza, ETL tools like Informatica & ODI.
• Coordinating with offshore development team and on shore business team for development and requirements gathering.
• Creating required views for reporting in Oracle BI & Tableau reports.

Confidential, Austin, Texas

OBIEE Architect & Sr Consultant

Environment: OBIEE 11g, Informatica,OWB Big Data, Oracle DB

Responsibilities:

• Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements
• Designed ETL strategy, performed data loads into the data mart and ensure data quality.
• Implemented the business logic using business layer with BI Administrator tool.
• Updated dashboards and report designs showing trends, patterns and other required data analysis using OBIEE Answers.
• Implementing & Administration security setup for OBIEE dashboards and KPI’s as per the requirements.
• Develop and support forms generated using legal pre-printed forms through Oracle BI Publisher
• Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.
• Analyze Freight Forwarding data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.
• Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher reports.
• Eliminate the need to copy data from the underlying storage system to HDFS
• Leverage rich, deep and fast analytics on Hadoop data files of various kinds
• Conducted statistical and analytical functions from HAWQ on HBase or Hive Data
• Run complex analytical queries that join in-database dimensional data with fact data stored in HBase.
• Performed the enhancements to the existing reports based on new requirements.
• Upgraded from 10 g to 11g environment and installed patches to the given versions.

Confidential, Austin, Texas

Oracle BI/BI Apps Sr Consultant/ Business Analyst & ETL Architect

Environment: OBIEE/BI Apps 11g, Informatica, Netezza DB, Oracle DBThis particular project was developed to maintain all the details of the details, Market retail sales and distribution and patience details that use their medication. All data maintained in the GBI for their sales force or call center in order to increase the sales using Oracle BI reporting data.

Responsibilities:

• Confidential DB source is implemented and Interact with Business users and understanding their requirements.
• Designed ETL strategy, performed data loads into the data mart and ensure data quality
• Implementing & Administration security setup for OBIEE dashboards and KPI’s as per the requirements.
• Initiated data management, data governance and data stewardship strategies
• Updated dashboards and report designs showing trends, patterns and other required data analysis using OBIEE Analysis.
• Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements
• Worked closely with and ETL development team Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Improved system responsiveness of Tableau Dashboards by implementing best practices for Tableau Desktop.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Analyzed the source data and handled efficiently by modifying the data types.
• Created tableau dashboards for measures with forecast and reference lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Assisted Business users and recommended features, charts, KPI's for their business analysis in Tableau.
• Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
• Trained senior executives/users in making the best use of the BI solution.

Confidential, California, CA

Oracle BI/BI Apps Lead Consultant

Environment: OBIEE, BI Apps, Oracle EBS, Oracle DB, Unix

Responsibilities:

• Involved in requirement gathering, As is study, To be study, GAP analysis, solution design, documentation, implementation of the project.
• Provided Functional on AP module in P2P cycle and also on PO, GL and AP related issues which are integrated with AP module.
• Migration from SAP BO reports to OBIEE using the universes.
• Develop metadata repository development, including development and implementation of a Global Business Metadata Repository, to ensure consistency and standards in data naming conventions, definitions, and corporate standards for formulas, calculations, and formats.
• Building the solution architect to connect multiple sources and generate financial analytics deliverables.
• Implementing the OBIEE dashboards and KPI’s as per the requirements.

Confidential, Irvine, CA

OBIEE/BI Apps Developer

Environment: OBIEE 11g, ODI 11g, Discoverer,BI Apps Financial Module 7.9.6.4,HR Analytics,Spend Analytics

Responsibilities:

• Analysis of the problem / issue reported on the tool and Suggest solutions.
• Interaction with users and seeking information as required for resolving the issue.
• Testing new business requirements in the Test Instance and validating the same in Production.
• Analysis of the issue reported on the tool and Suggesting solutions.
• Involved in creating invoices of type Standard Invoice, Debit Memo, Credit Memo, Invoice, Deposit Invoice, and Guarantee Invoice.
• Installed and configured OBIEE 11g, BI Apps 7.9.6.4
• Designed and customized OBIEE rpd as per HRMS and Financial modules.
• Integrated OBIEE11g, Informatica 901, DAC service components, High availability architecture, custom development.
• Implemented Absence, Compensation, HR Performance learning management,
• Recruitment, Workforce development, Retention, Workforce profile, AP, AR and GL dashboards.
• Created Custom reports based on HRMS module. Validated HRMS and financial reports metrics.
• Modified the OBAW schema by adding new Fact for better performance.
• Deployed and tested HR and Financial Analytics. Validated all the out-of-the box dashboards and resolved issues in configuration for the reports with errors.

Confidential, California, CA

OBIEE/OBIA Sr Solution Architect

Environment: OBIEE 11g, BI Apps, Informatica, Oracle DB

Responsibilities:

• Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point.
• User requirements identified various fit-gaps on existing Oracle analytics warehouse and developed solutions to meet requirements and loaded the user required data into the OBAW
• Involved in developing Project Plan for the future scope of the Financial Analytics project which includes developing learning management and recruitment subject areas from flat files provided by third party vendors using Universal adapters
• Involved with Project managers and users to gather KPI's from warehouse for Financial reporting
• Administrated BI Environment by debugging identified issues and delivered solutions
• Identified Financial Analytics facts, dimensions & star schema models of workforce profile.

Confidential

OBIEE/OBIA Sr Solution Architect & Pre sales Lead

Environment: OBIEE, BI Apps, ODI, Exalytics, Golden Gate, Oracle DB

Responsibilities:

• Delivering critical solutions Confidential various levels in the field of Project solution.
• Development and client interfacing experience and exposure to Pre-Sales activities
• Due Diligence including POC, Project Costing, Proposal Making, RFP, and RFI.
• Installation, configuration of Exalytics box, OBIEE on Exalytics with TimesTen in-memory DB.

Confidential

OBIEE SME/ Business Analyst - Advisor

Environment: OBIEE 11g, Informatica, SAP BO, Oracle

Responsibilities:

• Collect data change requests and coordinate information gathering to ensure that the data Domain owners have all required information to approve changes.
• Facilitate meetings with data users, data stewards and other stakeholders to ensure data governance rules and standards are applied to data related changes/projects
• Leading the OBIEE Designing and Implementation team as part of SME role and Advisor to OBIEE Sizing and capacity planning on OBIEE infrastructure.
• Project management understanding of project management concepts and ability to perform duties within the construct of a project up to and including leading the project.

Confidential

OBIEE Systems Lead Specialist

Environment: OBIEE, ODI, Informatica, OWB, DAC,Oracle DB

Responsibilities:

• Involved in completely on Oracle BI servers and applications, setting up the Oracle BI environments for different projects.
• Involved working with Development teams on the environmental systems.
• Supporting and Maintain the Siebel analytics clients and servers, BI Publisher, DAC, Informatica including Siebel Analytics Applications, and as per agreed service level agreements.
• Provide technical/user documentation and training.
• Perform peer reviews of work items produced Confidential various stages of the project.
• Effectively communicate with various teams and stakeholders, escalate technical and managerial issues Confidential the right time and resolve conflicts.

Confidential

Systems Operations Lead Specialist

Environment: Siebel Analytics 7.7, Informatica, DAC ETL, Confidential DB, AIX

Responsibilities:

• Maintaining the Siebel Analytics servers, which includes DAC and Informatica server
• Resource planning and work allocation based on skill set of the team member and ensuring service delivery on time, planning technical and process training desired by the team.
• Providing Technical Support to Issues related to Opportunity, Service Request, Accounts, Contacts and other Siebel functionality.
• Troubleshooting issues related to Workflow, Assignment Manager, Call Center Server Components and other Siebel Object Managers.
• Implemented Changes related to Siebel, AIX and DB2 environments Troubleshooting Maintenance Jobs related to Flash copy, ADB Data Mart Extract, SNR ETL Extracts, Audit DB ETL, Backup Jobs
• Perform Daily System Health Checks related to AIX, DB2 and Siebel.
• Performance tuning the Siebel application and providing recommendations for performance enhancement.
• Performing Migration and Staging environment refresh.
• Running and troubleshooting EIM loads.

Confidential

Environment: Siebel 7.5.3 Tools Enterprise Application, Oracle 9i, Win-XP

Responsibilities:

• Configuring and working with siebel analytics Answers, Dashboards, Scheduler, delivers and configuring IBOTS and Configure Symbolic URL
• Able to configuring Enterprise Integration Manager, running database scripts for Siebel Tools, Repository Management, installing Siebel server software, scheduling and running Siebel server processes
• Accountable for User administration such as creating initial user and developer accounts, setting system parameters, establishing mobile clients for front-end developers.
• Release and deployment management
• Siebel report server administration, Siebel anywhere, Assignment administration Remote Administration and Thin Client Administration.