SUMMARY

• Over 7+ years of experience in IT implementing full life cycle of Business Intelligence solution with System & Data Analysis, Application Design & Dimensional and Data Modeling wif Design, and Documentation wif applications on various flavor’s of UNIX and Windows.
• Good knowledge about different tracks like Financials, Supply Chain & Order Management, Procurement and Spend Analytics.
• Experience using Oracle Business Intelligence Enterprise Edition 10g/11g and Oracle BI Apps.
• Experience in end to end implementations of BI solutions for implementing Financials, Supply Chain and Order Management, Procurement and Spend Analytics.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher and IBots wifin OBIEE Suite.
• Expertise in Developing Repository (RPD) involving multiple Sources including OLTP, OLAP and Three Dimensional Structures .
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Experience in designing Data model i.e. Star Schemas/Snow Flake Schemas.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Experience in setting up Multiuser environment (MUDE) repository.
• Experience in configuring interactive Dashboards wif drill - down, drill across capabilities using Filters and Dashboard Prompts, Metadata Objects (Subject Area, Table and Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different autantication methods.
• Performed Cache Management at repository level.
• Developed Delivers IBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and also in creating Workflows.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS

Languages: C, C++,PL/SQL, Java

Databases: Oracle 10g/9i/8i,DB-2, MS-Access, SQL Server, EBS

Database Clients: Oracle SQL Developer,Toad 8.x/9.x.

Reporting Tools: OBIEE 11g (11.1.1.7.1 )/10.1.3.x, OBIA Apps 7.9.6.3, BI Publisher 10.1.3, Crystal Reports 8X.

ETL Tool: Informatica Power Center/Mart 5.x/6.x/7.x/8.x, DAC 10.1.3.4

Operating Systems: Windows-XP/7/NT/98/2000/Server 2003, UNIX, LINUX, MS-DOS

Web Technologies: HTML, XML, Java Script, VB Script, ASP, Shell

PROFESSIONAL EXPERIENCE

Confidential - Houston, TX

OBIEE Developer

Responsibilities:

• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Worked wif OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.
• Translated Business requirements into technical requirements.
• Created Dashboard prompts and advanced filter criteria.
• Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).
• Customized reports from BI Apps (OOB-prebuilt) seeded reports.
• Used BI Apps prebuilt Informatica mappings for development.
• Fixed many OOB issues. Created major and important dashboards like Customer Profitability from the scratch including
• The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.
• Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
• Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Designed and developed complicated/complex reports.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Administered MUD rpd, reviewed developers' rpd development before merging into MUD server.

Environment: OBIEE-11.1.1.7, OracleBI Apps, Oracle DB 11g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC.

Confidential - Los Angeles, CA

OBIEE Developer

Responsibilities:

• Interacted wif Business Users and Business Analysts for gathering business requirements and also understand the current requirements and Data Analysis.
• Involved in designing the dimensional model for Equity Commission project as per the reporting requirements by using the Microsoft Visio.
• Prepared Technical Requirement documentation based on reporting requirements.
• Designed and Developed OBIEE Repository.
• Worked extensively on OBIEE Repository and Dashboards.
• Created number of Complex measures and Logical columns in BMM Layer as per business requirements by using Different TimeSeries functions like Ago, Todate and other Business logics.
• Created lot of dynamic repository variables and Initialization Blocks for different purpose.
• Extensively working on Merging and Migration of RPD and Catalog to higher environment on a weekly basis.
• Implemented the Security by creating the Users, Groups, Web Groups and Web Catalog
• Implemented external tables for Autantications and Authorization by using VPD.
• Performed Unit testing to validate report and fixed the issues opened by QA and BA team.
• Resolved Post Upgrade RPD Consistency check issue and fixed all the issue related to reports and dashboard after the upgrade in 11g.
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Modified default Configuration settings in NQSconfig.INI by using the Enterprise Manager and added new tags in instanceconfig.INI files as per OBIEE 10g configuration files.

Environment: OBIEE 11.1.1.5, Informatica 8.6.1, Oracle10g, Microsoft Visio, SQL Developer, Linux and Windows XP.

Confidential, Richmond, Virginia

Obiee Developer

Responsibilities:

• Analyze business requirements and translate them into technical design solutions.
• Development, Implementations and Documentations of Data Warehouse / Data Marts deployments and Business Intelligence solutions.
• Worked closely wif theETLteam to determine the granularity and figure out the facts and dimensions.
• Building executive Performance Management Systems using OBIEE interactive Dashboards.
• Configured Analytics Reports, dash boards, web catalog and the RPD using OBIEE Administration tool 10.1.
• Developed Dashboards / Reports wif different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards wif drill - down capabilities.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and deletion of accounts.
• Created materialized views and aggregates to improve performance.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Involved in the logical and physical models of the warehouse.
• Performed unit testing, integration testing on the deliverables to analyze the errors and fix them.

Environment: OBIEE 10.1.3.4.1 , Oracle10g/9i, OBI11g, BI Publisher 10.1.3, DAC, Informatica 8.6.0, SQL, PL/SQL, Toad, Unix Shell Scripts, Windows and AIX.

Confidential

Responsibilities:

• Using Crystal Reports developed Branch wise, Add-on, Manufacture wise, Discount type Reports.
• Interacting wif user to know their requirements.
• Developing database.
• Developing reports and Analyzing and developing user interfaces wif validations Programming for data access.

Environment: MS Access, Oracle7.0, Visual Basic Crystal Reports and Windows 95.

Confidential

Responsibilities:

• Involved in feasibility study and system study.
• Designed database and user interface individually.
• Designed and developed Oracle forms and Reports.
• Reviewed the code at regular intervals for fine-tuning.
• Prepared materials to halp the users for normal maintenance and operation of dis package.

Environment: IBM Pentium, UNIX, Oracle 6.0, Forms and Reports