SUMMARY:

• Experience providing business solutions in the areas of Business Intelligence, Data warehousing, Data Analysis and Application Development.
• Unix/Linux systems (RedHat5x/6x, CentOS6x/7x)administrator with experience configuring, monitoring, upgrading and maintaining systems hardware, software and related infrastructure.
• Experience providing Unix support to maintain systems in world - class production data centers.
• Experience in virtualization; especially with VMware workstation.
• Installed and configured Oracle Enterprise Manager 12c.
• Monitored all these targets using em12c (Databases, Middle-Tier, App-Tier & Web-Tier).
• Installation & Configuration of Oracle SOA 11g on Weblogic on Linux platform.
• Installation & Configuration of OBIEE 11g on Linux and Windows platforms.
• JVM Tuning for different Weblogic containers.
• Capable of developing end to end Business Intelligence solutions using Oracle Business Intelligence Enterprise Edition (OBIEE), good understanding of Data warehousing and OLAP concepts.
• Worked Extensively on Oracle BI Administration Tool, Oracle BI Answers, BI Publisher, Oracle Delivers (iBots), Interactive Dashboards and Security Implementation.
• Developed Metadata Repository (.rpd) using BI Server Administration tool by importing the required objects (Dimensions/Facts/Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) and Logical/Facts/Measure objects in Business Model Layer, and created Presentation Catalog in Presentation Layer.
• Experienced in building Interactive Dashboards with drill-down and drill-across capabilities using global and local filters, contextual navigation, guided analytics, business rules with user identity roles, profiles and personalization.
• Experience in implementing Oracle BI security setup according to user requirements by setting up group/data access/query privileges, Metadata Objects, Web Catalog Objects (Dashboards/pages/folders/reports).
• Experienced working on MAA implementation, using OBIEE clustering/scale out with multiple servers.
• Worked with Business Analysts/Partners/Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications, Traceability Matrix, Risk Analysis and Integration testing.

TECHNICAL SKILLS:

Operating Systems: WIN10/8/7x/5/me/xp/2k/2k3 server, Unix, Linux (RHEL, CentOS, Ubuntu, Oracle)

Databases: Oracle 8i/9i/10g/11g

App Server: Oracle WebLogic Server, WebSphere Application Server

Middleware: WebSphere MQ 6.0, 7.1 & 7.5, Websphere MB 6.0, 7.0, 8.0

Oracle Fusion Middleware Products: Oracle SOA Suite 10g/11g (OAM, SOA, OAM, ODI, OBIEE) Oracle WebTier 11g(OHS)

Reporting Tools: OBIEE 11.1.1x

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle Consultant

Responsibilities:

• Installed and configured Red Hat, CentOS on variety of different server platforms that contained Apache.
• Installed and configured Red Hat Enterprise Linux on VMware workstation pro.
• Ensured that assigned systems were engineered, configured and optimized for maximum functionality and availability.
• Rectified many issues by instituting best practices in system log analysis, backups, user account permissions, management and systems/software auditing.
• Installation of OBIEE and Oracle database on Red Hat Linux and CentOS.
• Install & Configure Oracle Webcenter Suite 11g on Linux environments.
• Created and monitored virtual machines using OVM.
• Configuring, monitoring, upgrading and maintaining systems hardware, software and related infrastructure.
• Managed daily activities to include user support and system administration tasks.
• Worked with data source systems and Client systems to identify data issues, data, gaps, identified and recommended solutions.
• Designed and developed Metadata Repository (.rpd) using BI Server Administration tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Involved in the Cache management to improve the overall system performance.
• Development and maintenance of Repository and OBIEE repository.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular) with Global and Local Filters using Answers in OBIEE.
• Created Filters and provided customized prompts appropriately to avoid excessive data showing in reports.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Configured iBots to deliver Analytics content based on schedule, automated iBots queries to obtain daily and weekly reports.
• Coordinated with the teams during the Defect Tracking process.

Environment: RHEL 6x, OBIEE 11.1.1.7x, BI/XML Publisher, Informatica, Oracle 11g/12c, OBIEE MUD, SQL Developer, Oracle WebLogic server, Oracle Fusion Middleware applications, SOA/BPEL/BPM, Web Center

Confidential

Technical Support Specialist

Responsibilities:

• Provide support to end users relating to hardware and software, computer applications, LAN components and peripherals.
• Carry out on-site analysis, identification, and resolution of difficult desktop problems for end users.
• Supervise complaint ticketing system and follow timely resolution of all work orders.
• Installation and configuration of RedHat Linux, CentOS and Ubuntu server on VMware.
• Install, organize, test, maintain, check and troubleshoot end user workstations and interrelated hardware and software.
• Recommend and apply solutions, including on-site repair for remote users.
• Installed Web logic cluster environment for RAC Databases.
• Experience in handling Production Fusion middleware and Troubleshooting.
• Install & Configure Oracle Fusion Middleware products on RHEL environments.
• Configure and migrate Operating System, Middleware Applications and Database.