SUMMARY OF QUALIFICATIONS

Versatile information technology professional with over 8 years' experience in OBIEE Oracle Business Intelligence Enterprise Edition and a strong financial background. Extensive experience providing business solutions in the areas of Business Intelligence, Data Analysis and Application Development.

CORE QUALIFICATIONS

• Wide experience working on OBIEE Answers and Dashboards to create the reports as per the company requirements.
• Strong understanding of Transactional and Dimensional Data Modeling, Data Warehousing Data Mart Concepts, and Designing Star Snowflake Schemas for OLAP Systems.
• Experienced in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE 10g/11g.
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Develop different kinds of Reports pivots, charts, tabular using global and local filters.
• Knowledge of Oracle SQL and PL/SQL development.
• Experience in working with Business Users, Controllers, Directors, Senior Managers, Executives, Department Heads and Project Stake Holders.
• Excellent problem solving skills with strong technical background and good inter-personal skills, quick learner and excellent team player, ability to meet deadlines and work under pressure.

WORK EXPERIENCE

OBIEE Developer Confidential

• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers using global, local filters and page/dashboard prompts, pivot tables, charts and view selector.
• Developed Metadata repository RPD , Physical layer Business Model and Mapping, Web Catalog Objects as per the data requirements.
• Formatted requests using sorts, filters and prompts.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Used Filters and provided Customized dashboard prompts appropriately to avoid excessive data showing up on reports.
• Designed and developed new Aggregates using Informatics ETL processes.
• Created security authorization session variables and initialization blocks in the repository.
• Created Business Process specific Dashboards to provide insight into the sales/marketing/financial areas.

OBIEE Report Developer Confidential

• Interacted with management to identify information needs and business requirements for reports.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Developed Metadata repository RPD , Physical layer Business Model and Mapping, Web Catalog Objects as per the data requirements.
• Worked on BI Answers to build Interactive Dashboards with drill-down capabilities.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Used Filters and provided Customized dashboard prompts appropriately to avoid excessive data showing up on reports.
• Designed and developed new Aggregates using Informatica ETL processes.
• Created pivot tables enabling managers to analyze the business from different perspectives, provided optimized analytics requests using column selector and generated queries and placed filters in Oracle BI Answers and created numerous executive level reports.
• Created Business Process specific Dashboards to provide insight into the sales/marketing/financial areas.

OBIEE Report Developer Confidential

• Interacted with the business users and defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given business requirements.
• Customized the OBIEE Repository physical, BMM, and presentation layers and created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created logical tables, dimension hierarchies, aggregates, and keys for dimensional modeling design, defined drill- down time series other dimension hierarchies, and whole diagram using complex joints.
• Used Rename Wizard to remove underscore character, change all column names so that first letter of each word is uppercase and rest is lowercase.
• Used the security manager in OBIEE Admin tool to setup Users and Groups.
• Created security authorization session variables and initialization blocks in the repository.
• Assigned filters to objects and granted access privileges to users or groups.
• Deployed OBIEE rpd into BI Presentation Services ready for building reports/dashboards from the repository using OBIEE.
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers using global, local filters and page/dashboard prompts, pivot tables, charts and view selector.
• Used Prompts To Filter Data.
• Formatted requests using sorts, filters and prompts.
• Worked with data architect to implement the reference data change requests.

Siebel Analytics Developer Confidential

• Interacted with management to identify information needs and business requirements.
• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Configure Interactive Dashboards with delivers to alert the marketing about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Designed and developed new Aggregates using Informatica ETL processes.
• Created mappings for initial load and daily updates using Informatica.
• Worked with data architect to implement the reference data change requests.

Customer Service Manager Confidential

• Interfaced with distributors to resolve issues raised by consumers and retail stores.
• Responded to technical questions from customers.
• Conducted research and collaborated with technical experts to resolve cases.
• Processed consumers' requests for refunds and detected fraudulent claims.
• Contributed to 50 increase in call and email volume answered in 12 months by CS team.
• Specialized in making add-on sales by persuading clients to purchase more than what they initially wanted, increasing the value of each sale.
• Entrusted with the most complex customer service issues as a result of exceptional ability to promptly resolve concerns and satisfy customers.
• Saved the company thousands of dollars by effectively resolving claims and preventing losses.