PROFESSIONAL SUMMARY:

• Have 11+ yrs. of IT Experience in Leading, Design, Development, Migration and Support and Deployment and of Various applications using Business Intelligence Tools OBIEE Plus 11g/10g, Siebel Analytics 7.8.x, OBIA, Bi Publisher, Hyperion Financial Reporting, Hyperion IR, ETL Informatica, and ELT tool ODI and Multi - Dimensional Database Hyperion Essbase
• Have 11+ years of IT experience and technical Proficiency in Developing, Migrating, Leading and
• Managing Business Intelligence projects of medium to High complexity.
• Highly skilled in Project planning, tracking, execution and managing Global projects with virtual teams working in Onshore and Offshore model.
• Strong Project Management experience that covers Application development and production support in Banking and Finance across Market Risk, Liquidity Risk, Credit Risk, Regulatory Basel 2 & 3 and Group Controlling, Core banking
• Demonstrated ability to work with Users and Project managers to define Project Scope, objectives and approach.
• Managing the entire Oracle BI environments, including Installation, Configuration, Upgrades and build deployments on OBIEE/OBIA 11g and good experience in Administration of Web Logic server, EM and RPD in MUDE setups as well.
• Strong Technical experience in Business Intelligence platform like Oracle Business Intelligence Enterprise Edition, OBIA, BI Publisher, Hyperion Financial Reporting, Hyperion Interactive Reporting, Hyperion Essbase, ETL Tool Informatica, ODI, APEX, Oracle PL/SQL, Control M and UNIX Scripting.
• Extensive experience in developing the Data model in Oracle BI EE 10G and 11G RPD with multidimensional sources (Essbase Cubes), Transactional Sources, OLAP Sources, Dashboard Development, Setting up the Security(object & Data level Security)in an integrated environment, Cache Purging, Cache seeding using OBIEE 11G and 10G, Usage tracking and Performance Tuning.
• Extensive experience in Development of ASO, BSO, Calc Scripts, ESSCMD, Maxl Scripting, Developing Complexed reports using HFR, setting up the folders Security, Administrating the Shared services and Creating mapping, mapplets & workflows using Informatica etc..
• Involved in Installation & Configuration of OBIEE 11g/ 10g, Hyperion Essbase, HFR in the Integrated environments and worked on upcoming RFP s and RFC s on OBIEE and Hyperion EPM Space.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques as per the Best practices and tools to support task performance.
• Initiate sub - teams as appropriate to resolve issues and perform tasks in parallel.
• Exceptional Ability to quickly master new concepts, applications, exceptional technical, analytical and Communication Skills.
• Encourage creativity, risk-taking and constant improvement, Engaged with Various Teams and Monitored Proper Handovers, KT s are performed
• Providing Status Reports of the Team Activities, Task s and Issues to the Associate
• Managers and Ensure deliverables are prepared to satisfy the project requirements and schedule.

SKILL:

BI Tools: OBIEE 10g /11g/12C, OBIA, BI Publisher, Hyperion Financial Reporting, Hyperion IR, Siebel Analytics 7.8.X.

OLAP & Planning Tools: Hyperion Essbase 7.x/9.x/ 11.x, Hyperion Financial Management 11.x

Operating Systems: Windows Family, UNIX, Solaris

ETL/ELT Tools: Informatica and ODI

Relational Databases: MS SQL Server 2000/2005, Oracle 9i/10g and MS Access2000

Programming Languages: C, SQL, PL/SQL

Web Technologies: HTML, XML, ASP.NET, Java Script, VB Script

Utilities: Toad, Rapid SQL, SQL Loader

Incident Management Tools: Remedy, Symphony, Jira

Web Servers: Web Logic Server, IIS

Version Control Tools: Clear Case (SCM), Tortoise SVN Automation Tools: Control-M, QTP

PROFESSIONAL EXPERIENCE:

Confidential

Environment: OBIEE 11G, OBI Publisher, ODI, Oracle 11g R2, APEX, Solaris, Web Logic Server.

System Integration Advisor

Responsibilities:

• Worked on End to End Implementation of this Requirement Gathering, Various CR’s Design, Development, and Security setup, Performance Tuning, Testing and Deployment for all OBIEE Modules.
• Worked on Installations and Configurations and Migration of OBIEE 10 G to 11G.
• Extensive experience in Gathering Requirements, converting functional specs to Technical specs.
• Expertise in Providing Technical Specification for the CR’s and provided various handover docs.
• Handled multiple Projects, as part of the Customization Requirements worked for couple of CR developments.
• Implemented Active Directory LDAP with OBIEE 11G along with SSL and implemented Object Security and managing application roles and policies.
• Provided solutions for complexed CR’s and Vulnerabilities. PCI Vulnerabilities did R& D and found ways to fix the PCI Vulnerabilities like cross site Request Forgery, missing secure attribute with SSL, Password Complexity etc..., Created Dashboards and RPD for the CR’s and provided various Customizations.
• Created Reports ex: Invoice Summary PDF and Excel Templates, Affiliate statements etc… using BI Publisher
• Handled multiple deployments of artifacts to higher environments.
• Responsible for the Deliverables for OBIEE Modules, Technical specs, Handover docs. Etc. and created Reports using OBI Publisher and OBIEE 11G and configured the GFT Frameworks for bursting.
• Initiated lot of Performance Improvements plans for the applications and successfully executed those like DR setups, Switching between DR and Prod, Data Retention of the files w.r.to database and also Obiee. Etc…
• Fine tuning of BI Publisher reports and OBIEE RPD and Rebranding for all Reports and GFT Frameworks and integrated with applications etc…
• Created Views, Tables, Packages, and implemented various logics as part of CR’s and modified many Database Objects, Packages etc…
• Created and Configured APEX Screens, and End to end development for various CR’s from all applications perspective and interacting with Business Users for the requirements.
• Worked on various upcoming RFC’s and POC’s on OBIEE Plus suite, Noetix Migration to OBIEE, Hyperion OBIEE Plus, and Discoverer to OBIEE Migration.
• Created multiple views like Graph, Pivot, Gauge and Dynamic Ticker Views for the KPIS.
• Worked on various upcoming RFC’s and POC’s on OBIEE Plus suite, Noetix Migration to OBIEE, Hyperion OBIEE Plus, and Discoverer to OBIEE Migration.
• Responsible for Sprint Planning and assigning the tasks to the team and preparing the Status Reports etc...
• Preparing materials and providing to internal resources etc...
• Good experience in deploying the RPD and Catalog using Enterprise Manager.
• Customized the UI with Custom Logos in OBIEE 11g.
• Provided Technical specs, Mapping Documents, exported Meta data Dictionary.

Confidential

Environment: OBIEE 11G, Oracle 11g R2, ODI, Web Logic Server.

System Integration Advisor

Responsibilities:

• Worked on End to End Implementation of this Project for Design, Development, Security setup, Performance Tuning, Testing and Deployment
• Installed and configured OBIEE 11.1.1.7.1 in the VM Server
• Designed and developed the RPD as per the Confidential Call center Analytics Requirements.
• Created Confidential with multiple Pages SL, Abandons, ASA, AHT
• Created multiple views like Graph, Pivot, Gauge and Dynamic Ticker Views for the KPIS.
• Worked on RFP’s for Hyperion Related stuff.
• Good experience in deploying the RPD and Catalog using Enterprise Manager.
• Customized the UI with Custom Logos in OBIEE 11g.
• Installed and Configured Mobile Apps Designer to enable Touch screen Facility.
• Provided Technical specs, Mapping Documents, exported Meta data Dictionary.
• Setup the Team of 6 people and lead the team.

Confidential

Environment: OBIEE 11G, Oracle 11g R2, Solaris, Web Logic Server.

Senior OBIEE Consultant

Responsibilities:

• Worked on End to End Implementation of this Project Design, Development, Security setup, Performance Tuning, Testing and Deployment
• Gathered Requirements for FL Intelligence Application and converted them to Technical Specs provided a Reporting platform for the FL Users to analyze their Core banking Functions
• Developed the RPD with multiple fact tables and Dimensions from both TP Systems and the Data Mart.
• Built the BMM layer to suit my Ad-hoc Catalog requirements and also the Pre canned Reports and Dashboards and created computed columns for the measures to readily available for the users.
• Created the Data Model in RPD level and involved in the Data Model Changes at the Data Mart Level to enhance the Performance.
• Created multiple Subject Areas for Different User Portfolios to suit their real time reporting and make decisions on day to day basis based on their Privileges. Created Reports using Hyperion SQR and OBIEE 11g and integrated with OBIEE Dashboards.
• Implemented Object, Data level and User level Security based on the Countries.
• Added users and configured security in web logic console of OBIEE 11g.
• Created Reports and Dashboards with different views like Pivot views, charts.
• Managed security privileges for each subject area and dashboards according to user requirements
• Created Technical Design Documents, Mapping Documents, Migration Docs, Go-Live Check lists, Developed & Migrated the Resources to UAT and PROD in liasing with multiple Teams.
• Reviewed the Code, Performed Unit Testing of the Reports and Dashboards, fixing the bugs in UAT and

Confidential

Environment: OBIEE 11G, SAP Business Objects, Solaris, Oracle 11g, Web Logic Server.

Senior OBIEE Consultant

Responsibilities:

• Developed Global MIS Reports - RWA by Business Lines Reports and Developed the RPD Changes and Custom Formulas as part of Basel 3.
• Created Dashboard Filters and 3 Dashboards and calculated Ops, Risk, Credit Risk, Market Risk, Pure RWA, Pure RWA Limits, Total Deductions and Total Deductions Limit for the chosen COB Date & Prior COB Date
• Worked on the Performance Tuning of the Reports as part of Basel 3.
• Implemented the RPD Changes for these enhancements and for Basel 3 new Requirements.
• Analyzed the Requirements and created Repository for these CR’s for BMR Data Mart as part of Basel 2.5 and Developed V& E Reports and Dashboards.
• Created Pseudo Columns in the Opaque View at RPD Level in order to display all duplicate records from both Star and COMET Applications in the Dashboards
• Provided Customizations to the User as requested like disabling the PDF, Download to Excel with Selected COB Date and also provided single go button for multiple Dashboard Prompts using Java Script.
• Provided lot of customizations as per the look and feel requested by the User.
• Tested all the Dashboards TB Securitization V&E Reports and Deployed to FT ad liased with multiple teams to release to Production.
• Worked on the performance Initiative for improving the performance of Dashboards and Cleaned up the Repository Provided a Design approach and implemented a Single Schema STAR RO USER instead of having 2 schemas, removed all unnecessary joins and duplicate Tables.
• Tested all the Dashboards like Ultimate Rec Report, Cluster Pack, MIS Reports and V&E Reports etc…

Confidential

Environment: OBIEE 10.1.3.4.1.2 . , Informatica Power Center 8.6.1, OFSAA, Solaris, Oracle 11g, Web Logic Server.

Senior Consultant

Responsibilities:

• Converted the business rules into technical specifications for ETL process for populating Fact and
• Dimension table of FDW Data mart
• Developed the code to deliver required functionality in accordance with Confidential development standards, reusing existing code wherever possible
• Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for the counterparty applications.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Data for Counterparty to the FDW data mart according to the business logic.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads
• Created Technical Design Documents and completed the 1st phase of Construction.
• Performed End to End Testing of Workflows and Responsible for the Migration of All Objects.

Confidential

Environment: OBIEE 10.1.3.4.1.2 , Hyperion Financial Reporting 11.1.1.2, Hyperion Essbase 11.1.1.2, Solaris, Oracle 10g, Web Logic Server and LCM.

Senior OBIEE Consultant

Responsibilities:

• Worked on End to End Implementation of this Project Design, Development, Testing and Deployment and also played an Administration Role in Setting up the Security for OBIEE Dashboards and also the Folder Security in Financial Reporting (both Object Level and Data Level Security)
• Gathered Requirements for Confidential Application and distributed the Work among the Team, Developed the Complexed Reports like Headcount and FX Neutral in Various Packs, Dashboards like CFO, SHS Overview etc.. Various divisions with Customizations as per the Business Req using OBIEE and HFR.
• Created RPD with multiple Sources like Essbase, Oracle Tables and implemented security using Custom Authenticator. Created FX and Headcount Reports using HFR and integrated with OBIEE and used a common reporting space as Workspace.
• Implemented Object and Data Level Security using Shared services Security. Created Users and Groups @Shared Services level and Filters @Essbase Cube Level as per the Requirements.
• Created Technical, Migration Docs, Go-Live Check lists, Developed & Migrated the Resources to UAT and PROD in liasing with multiple Teams.
• Engaged with Various Teams and Monitored Proper Handovers, KT’s are performed.
• Reviewed the Code, Performed Unit Testing of the Reports and Dashboards, fixing the bugs in UAT and
• SIT phase and involved in Performance tuning of the reports and Dashboards.
• Provided MUDE Design Documents, Demonstrated to the Team and also Implemented the Security using UDML into the RPD as a part of Project Proposals.
• Handled multiple Releases and ensured Dependent Deliverables and Jobs are released within Timelines by making sure that the Prod System is Stable.

Confidential

Environment: OBIEE 10.1.3.4, Hyperion EPM 11.1.1.2, Oracle 10g, Solaris.

OBIEE & Hyperion Admin

Responsibilities:

• Involved in Requirements gathering and Repository Development for Market risk Application.
• Created the RPD with multiple Data Sources and Developed Hierarchies in the RPD.
• Created Advanced and Complex Reports Drill - Down, Navigated, Trend, Union Reports with different types of views like Pivot View, Chart View, Dynamic Ticker, Guages and Customizations across the Reports and Dashboards level as per the Business Req. etc. using Oracle BI Presentation Services and CSS Styles and optimized the Performance and worked on Caching (Cache seeding and Cache Purging) for both Market Risk and Liquidity Risk Applications.
• Configured iBOTS to deliver Analytics content based on Schedule, automated iBOT queries to obtain daily and weekly Reports.
• Resolved issues in the Production Support based on SLA s provided by the Client.
• Created Support Manuals for both Market Risk and Liquidity Risk Reporting applications.
• Involved in L3 and L2 Support by creating, deleting the users and resolved Data Quality issues, worked on Enhancements as a part of Change Request and Monitoring the Cube builds and Jobs and involved in Performance tuning of the Reports and Dashboards
• Provided Mapping, Hand-Over documents and Cubes Documents to the RTB.

Confidential

Environment: OBIEE 10.1.3.4, OBIA 7.9.5, OWB, DAC, Oracle Apps R12, Windows.

Technical Oracle BI Consultant

Responsibilities:

• Developed a Solution Using OBIEE by customizing it to Oracle Suite of Products (OWB instead of Informatica, Oracle Apps R12 as the Data Source) for the Financial Vertical as a part Of IP Development Activity with the following Responsibilities which would be helpful for the financial vertical.
• Created Warehouse Design Documents as per the requirements from BA.
• Created Data Model using OBI Admin Tool with the necessary Hierarchies and Security Implemented.
• Developed Dashboards and Reports with different types of views with all the navigations and drill down facilities using OBI Presentation Services.
• Created iBots and scheduled the jobs to specific recipients through mail.
• Configured the OBI Scheduler, BI Office Add - in and Disconnected Analytics.
• Delivered 6 Dashboards with 25 Reports as a part of IP Development Activity to our AGM.
• Provided Technical Support through documentation during the Project Proposals for Financials and SCM Verticals for OBIA Competency which Explains about the full functionality of KPI's (metrics).
• Worked on the Installation of OBIEE and configuration of the different Databases for the Business
• Analytics RPD as a part of the proposal. Customized different Reports for the Project Proposals.