SUMMARY

• Around 9.0 years of experience in IT that includes 5+ in Oracle Business Intelligence (OBIEE) Administration & support and 3+years in Oracle Database Admin and support activities.
• Having diverse industry experience including Healthcare - Pharma, Retail & Banking-Finance
• Proven experience in Oracle Business Intelligence and OBIEE Administration. Worked on Oracle BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Working Knowledge of Informatica 8.x, ODI 11g, DAC and Oracle delivered data structures for OBIEE applications.
• Experience with the developing, supporting and maintaining OBIEE applications with the OBIEE 11g/10g platforms.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Experience working with Exalytics server.
• Experienced in providing end-to-end business intelligence solutions by installing, developing and configuring OBIEE Repository-RPD, OBIEE Answers, security implementation, Web Catalog Objects (Dashboard, Pages, Folders, and Reports) and Interactive Dashboards.
• Proven ability of providing production support for 24X7 on multiple databases.
• Experienced in supporting Oracle databases 9i/10G on UNIX platforms.
• Designed and developed plans to achieve high availability, scalability, recoverability of the Oracle RDBMS servers.
• Installation and configuration of Oracle Database and Application Server.
• Well versed in UNIX environment and UNIX commands.
• Experience in SQL*Loader, UTL FILE, and Oracle Import /Export utilities
• Creation of table spaces, user maintenance, database security imposition by creation and granting of roles and privileges, backups (Hot/Cold/Logical) also RMAN Backup.

TECHNICAL SKILLS

Operating System: UNIX - IBM AIX 5.1, Linux and MICROSOFT WINDOWS

DBMS: Oracle 9i/10g/11g, Exadata

Technology: OBIEE 10 g, OBIEE 11g, Informatica 8.1, DAC Oracle 9i/10g, ODi11g, Exalytics Enterprise Manager, Autosys, Serena Dimension Manager, Oracle11g Grid Control, Oracle Export-Import, RMAN.

Tools: MobaXterm, Peregrine Service centre, SQL Developer, SQL*LoaderPVCS Version Manager, Sql*Plus, Putty, DTS Package, Toad 16X, i report 3.0.0

Languages: SQL

PROFESSIONAL EXPERIENCE

Confidential, KS

OBIEE Administrator

Responsibilities:

• Being OBIEE Administrator, take care of installation and configuration of OBIEE tool in Linux environment.
• Installed the OBIEE 11.1.1.7 including components like OBIA, ODI and OBI and configured the data sources, security and configuration in Oracle Linux environment.
• Monitoring OBIEE, ODI, Hyperion servers and resolving the issues related to either configuration or settings within Production, QA and development environment.
• Administer ETL and data warehousing applications and tools like ODI 11g.
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• Whenever required Always prompt and in touch with oracle support for any unresolved query related to OBIEE components or patching, creation of service request, Follow-up and get the issue fixed.
• Perform validation of data on the reports and monitor the performance status of the same in servers and checking health and overload on servers as daily routine
• Prepare documentation and communicate the status of the project to the management
• Implementing OBIEE security from Security Infrastructure setup (WLS Console and EM) i.e LDAP and Data -Object level security setup thru rpd.
• Deployed OBIEE 11g platforms based on either Exalogic or else Exalytics.
• Creating users, assigning roles, application and privileges to users.
• Deployment of rpd and BI Presentation Catalog.
• Extensively worked on Installation and configuration of Oracle Advanced Planning Command Center (APCC), Supply chain and Order management Analytics and Procurement.
• Killing sessions and revoking user privileges and roles

Environment: Oracle 11g/Exadata, OBIEE 11g (11.1.1.7), Exalytics, ODI 11g (11.1.1), Oracle Linux 86-64, Hyperion 11.1.2.3, SQL, Windows XP/2007, MobaXterm, Sql Developer, Notepad++. WebLogic, BI Apps, RCU Repository Creation utility for various installers Oracle Fusion Middleware applications.

Confidential, TX

OBIEE Admin/Developer

Responsibilities:

• Install, upgrade and configure all components of OBIEE
• Used Administration tool for developing, customizing and modifying the Physical, Business and Presentation layers of the metadata repository,
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Experience working on Installation and configuration of Financials Analytics, Supply chain and Order management Analytics, HR Analytics, and Procurement and Spend Analytics.
• Created variables, initialization blocks, logical columns as per business requirement.
• Worked on various L3 tickets like Evolution/Request for information/Anomaly and resolved accordingly,
• Creating/Modifying Reports, Dashboards, New Models, Delivers.
• Testing and Ensuring all the migrated reports and Deliverers for proper functioning, testing the Adhoc reports of production with Development to crosscheck the modifications done.
• Understanding and analysis of new requirements/Enhancements with SLB leaders as per the ticket raised and designing and configuration of Business Intelligence Server repository,
• Monitored Production exploitation, Data Quality support and performance follow up of SLB reporting application
• Testing and Ensuring all the Hierarchies Levels and Permissions
• To explore the capabilities and possibilities of the tools to leverage its features.

Environment: OBIEE 11g (11.1.1.7), Oracle 11g, Informatica 8.1, Autosys, UNIX, SQL, TOAD 10.5 Windows XP/2007, Serena Dimension Manager, Note Plus.

Confidential

OBIEE Admin/Developer

Responsibilities:

• Install and configure OBIEE in windows platform.
• Perform other administrative duties related to OBIEE as and when assigned and also Provide support in the implementation of OBIEE components
• Coordinated the Analytics of RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment
• Administering the OBIEE includes creating new users assigning roles and responsibilities to new users and also took care of monthly and weekly loads,
• Customizing and development of dashboards according to the requirement by the business users
• Designing/Modifying new Subject Areas, working on creating new tables in existing Subject areas in a RPD as per the requirement
• Gathering information from the client, preparing the test cases and testing for the proper functioning of reports Prepare documentation and communicate the status of the project to the management
• Work on Web servers, UNIX and Windows administration
• Perform testing sessions for reports and dashboards and resolve process issues (if any)
• Research and remain abreast with latest technologies and techniques to recommend new changes or upgradations
• Testing of various reports from Production to Development region.

Environment: OBIEE 10g, Informatica, DAC, UNIX, SQL, Windows 2007, Peregrine Service centre TOAD 10.5, Ultra Edit-16, Oracle 10g.

Confidential

Oracle Admin and Support

Responsibilities:

• Install and configure Oracle software and database.
• Creation of table spaces, user maintenance, database security Imposition by creation and granting of roles and privileges, backups (hot/cold).
• Implement and maintain database security (create and maintain users and roles, assign Privileges).
• Migrating data from different and disparate data sources using technologies like SQL loader, export and import.
• Work as part of a team and provide 24x7 supports when required.
• Backup and recovery utilizing RMAN.
• Created and managed both system level and object level roles and privileges for various users.
• Worked on export and import utilities.

Environment: SQL, Java, Linux, Oracle 9.2.0.0/10g,Oracle Enterprise Manager, PL/SQL, ToadWindows2000/XP, Oracle

Confidential, NJ

Oracle Administrator

Responsibilities:

• Installation and configuration Oracle database. Providing production support 24*7 database availability for Oracle Database.
• Worked on SQL scripts, with UNIX shell scripting for the generation of Bank reports.
• As per requirement created packages for Promotion planning which includes procedures and functions.
• Space Management which includes table space creation, adding new data files
• Managed Table spaces, Rollback Segments, Redo Logs and other database object.
• Designed and implemented crash recovery strategies, hot and cold backups.
• Carried out the setting up of RMAN back up schedules of databases.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Environment: - IBM AIX 5.1, Linux, Oracle 9.2.0/10g,Oracle Enterprise Manager, PL/SQL, RMANWindows XP/2000, TOAD, Autosys, Explain Plan, PVCS Version Manager

Confidential

Migration Developer

Responsibilities:

• As per requirement Designed and developed anonymous PL/SQL scripts. Used aggregate functions of SQL.
• Developed reports for the banks, like annual statements, trial balance summary reports etc.
• On Site coordinator for Trade Finance module (Responsible for gathering the requirement, development and implementation singly handled.)
• Worked on all type of joins and sub queries to produce valuable output.
• Developed data flow diagrams also Performed Gap Analysis & Documentation
• Worked on all type of joins and sub queries to produce valuable output.
• Writing SQL scripts to convert old data to new structures.

Environment: IBM UNIX, Oracle 9i/10g, SQL, COBOL, Oracle Enterprise Manager, SQL, Oracle Developer, Windows 2000, Sql*Loader.