SUMMARY

• Over 12 years of experience as Information Technology Professional.
• 5 Years of experience in Oracle Business Intelligence (OBIEE) 10G/11G, gathering Business Requirements, Analysis, Design and Development.
• Enterprise Manager, OBIEE Administration Console and Oracle Analytic modules in 11G.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Created, Modified and Developed BI 10G/11G Metadata repository - three layers (Physical Layer, Business Model Mapping layer & Presentation Layer)
• Experience in OBIEE 10.1.3.3.2 , OBIEE 10.1.3.4.1 , OBIEE 10.1.3.4.2 , OBIEE 11.1.1.3.0 , Oracle 10g and 11g Development and Administration.
• Creating, modifying, and administering Analytics Intelligence Dashboards with drill down capabilities using global and local filters in BI Analysis
• Processed data and object security to meet business Requirements.
• Excellent verbal and written communication, as well as good listening skills.
• Good track record in demonstrating strong analytical and problem solving skills.
• Excellent team player.

TECHNICAL SKILLS

Reporting Tools: OBIEE 10g/11g BI Analysis, BI Console, BI Enterprise Manager

Languages: PL/SQL

Database: Oracle 10g/11g

Platform: Windows 2003 Server, Windows XP/Vista, Professional, Windows7 Professional.

Project Management Tools: SAP, MS Office and Ms Project

Application Servers: Weblogic and OC4J

PROFESSIONAL EXPERIENCE

Confidential, Greeley, CO

OBIEE Developer

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements. Participated in complete life cycle of the project
• Helped in creating users and groups with appropriate security details in Administration Console. Configured Security at the repository level, Catalog level and the application level
• Formatted column output and modifying column data using formulas
• Developed reports / Dashboards with different Analytic Views (drill-Down / dynamic, Cascading styles Sheets, Charts, global and local filters.
• Formatted requests using sorts, filters and prompts
• Worked on a Micro Strategy - to-OBIEE 11G report conversion project with focus on the International Sales area.
• Created dimensional hierarchies, aggregates, and key performance indiocators (KPI) in the BMM layer.
• Performed validation of data in the reports and dashboards against source systems.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Set up Scheduler and configured Job Manager.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.

Environment: OBIEE 11g, OBIEE, 11.1.1.5, SQL Developer, Web Logic, Windows XP Professional

Confidential

OBIEE Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Participated in the conversion of Wachovia branches into the Confidential system by Interacting with business representatives for requirement analysis and to define business and functional specifications.
• Created/Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers.
• Designed the Siebel Repository Physical layer by defining joins and configuring the Connection Pool settings and created the Star Schema in Business Model.
• Extensively worked on Data marts(different subject areas) for decision support based on the needs of a given department and setting up LDAP (ADSI) authentication.
• Managed the Analytics Cache environment.
• Configured Dimension tables.
• Specified the aggregation levels and configured measures in the Business Model Layer and mapped to Logical Source tables.
• Design, development and configuring of custom reports/Dashboards with different Analytics views(compound layout, Pivot table, chart, table) with local and global filters using Siebel analytics.
• Proficient in using the time-series functions to support historical time comparison analysis.
• Experience in creating reports, adding filters, creating prompts, and creating pivot tables using OBI Reports
• Sales Tracking generated on individual bankers on daily basis Per: Branch, District and Region,
• Incentive Reports based on all Team Players performance rewarded in financial benefits.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10G/11G, BI Analytics, BI Console, BIEnterprise Manager, WindowsXP Professional and Windows 7 Professional.

Confidential, Dallas, Texas

IT Technician

Responsibilities:

• General network maintenance and improvements of current IT infrastructure.
• Maintain a 50+ Windows office environment with users of non-technical and highly technical background.
• Maintain web, email, database, and computational servers, many of which are Linux based.
• Created and send trouble tickets to engineers and clients.
• Worked on autonomous transactions and solved issues regarding mutating tables.
• Extensive knowledge of Windows XP (x86/x64), and a good working knowledge of Windows 2000.
• Experience administrating server remotely and installing/Configuring and managing server software.
• Experience building desktop and repairing both desktop and laptop computers