SUMMARY

• Over 12 years of experience as Information Technology Professional.
• 6+years solid experience in End - to-End Business Intelligence project delivery using several enterprise grade reporting tools.
• Enterprise Manager, OBIEE Administration Console and Oracle Analytics modules in 11G.
• In depth knowledge of RPD development (10G & 11G), Web catalog customization,Good knowledge ofWeb logic based security structure, Data Modeling (Star Schema) and overall playing hands on developer roles.
• Created, Modified and Developed BI10G/11G Metadata repositoryusing OBIEE Administration tool- 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 and 11.1.1.7 Oracle 10g and 11g Development and Administration.
• Developed Reports/Dashboards with different Analytics views (Pivot table, Charts, Views and Column selector with global and local filters) using Oracle BI Presentation Services
• Knowledege of processing data and objectsecurity 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

OBIEE infrastructure: Installation, Administration and configuration of 11.1.1.7 OBIEE Components.

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

Languages: PL/SQL

Databases / Analysis Tools: Oracle 10g/11g

Platform: Windows XP/Vista, Professional, Windows7 and 8Professional.

Project Management Tools: SAP, MS Office and Ms Publisher

Application Servers: Weblogicand OC4J

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

OBIEE Consultant

RESPONSIBILITIES:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago and ToDate functions for time series comparisons..
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Worked towards the Performance Tuning of Dashboards and Reports.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters.

Confidential, Greeley, CO

OBIEE Developer

Responsibilities:

• Gathered Data on all Studentfrom 28 Schools in the district
• Created/Modified Metadata repository (.rpd) by using OBIEE Admin tool: Physical, Business Model and Mapping, and Presentation Layers,
• Setting Students eating for freemeals,reduced and paying.
• Setting up re-embursements to either students or parents
• Generated Point of sale reports:
• Sales Transactions, National Meal Counts and Claims Reports

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 theapplication 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) inthe 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 basisPer: 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, Texas, TX

IT Technician Certified

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