Executive Summary

• More than Seven years of experience in IT implementing full life cycle of Business Intelligence solution with System & Data Analysis, Application Design & Dimensional and Data Modeling with Design, and Documentation with applications on various flavors 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 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 within OBIEE Suite.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Performed Cache Management at repository level.
• Developed Delivers iBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.
• Possess good knowledge on Hyperion Essbase.
• Possess knowledge about SmartView.
• Experience in working with Informatica Power Center in applying transformations, creating mappings & loading data into the data warehouse.
• Excellent interpersonal and communication skills for efficient client interaction.

Technical Skills:

OLAP Tools: Siebel Analytics 7.8.3, OBIEE 11.1.1.5, 10.1.3.3/10.1.3.4, Oracle BI Apps, BI
Publisher
Databases: Oracle 10g/9i
DB Analysis Tools: SQL* Plus, ODBC, SQL Developer, TOAD.
ETL Tools: Informatica Power Center 8.6/8.1/7.x
Languages: PL/SQL, C, UNIX Shell Scripting, .NET
Web Technologies: HTML, JavaScript, XML, MS FrontPage
Operating Systems: Windows-All versions, Linux-Red Hat, Fedora and Ubuntu
Networking: Routers-LAN/WAN configuration, Firewall configuration, VPN configuration, Wireless configuration, services like FTP, TELNET, SSH.

Education:
Bachelor of Technology in Computer Science

Professional Experience:

Confidential, TX April 2011 – Till Date
[OBIEE Developer]

Roles & Responsibilities:

• Translated Business requirements into technical requirements.
• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
• Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.
• 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.
• Extensively worked on Informatica PowerCenter 8.6 tools – Designer, Workflow Manager, Workflow monitor.
• Upgraded from OBIEE 10g to 11g.
• Designed and developed complicated/complex reports.
• Followed best practices to make sure there was good performance.
• Administered MUD rpd, reviewed developers’ rpd development before merging into MUD server.

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

Confidential, MI July 2010 – April 2011
[Sr.OBIEE Consultant]

Roles & Responsibilities:

• Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.
• Created transformations like Expression builder, joiner, and router.
• Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.
• Tuned the performance of the reports by creating various types of indexes wherever appropriate.
• Configured MUD for OBIEE Tool
• Used existing data from Hyperion Essbase for analysis.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension
  hierarchies.
• Created variety of interactive dashboards containing charts, graphs and pivot tables using BI Answers.
• Utilized features like narrative views, dashboard prompts to create interactive dashboards.
• Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.

Environment: OBIEE-10.1.3.4, Oracle DB 10g, SQL* Plus, PL/SQL, Informatica Power Center 8.6.

Confidential, FL August 2009 – July 2010
[Sr.OBIEE Consultant]

Roles & Responsibilities:

• Gathered User requirements, reporting requirements and the document for requirement specifications.
• Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.
• Created dimension hierarchies, aggregates and keys in BMM layer.
• Worked on session variables and dynamic variables along with initialization blocks.
• Created users and groups in the repository and granted privileges and group inheritance.
• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
• Involved in troubleshooting of Informatica Mappings and Workflows
• Compared data from Hyperion Essbase with the OBI for data validation.
• Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).
• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.

Client: Confidential, NY July 2008 – August 2009
[OBIEE Developer]

Roles & Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Imported physical tables and defined relations between Physical tables at the Physical Layer.
• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
• Utilized Aggregation to improve query performance
• Created Reports using different views
• Implemented BI Security using External Table for Authentication and Authorization
• Worked on iBots using BI Delivers for issuing Alerts and setup a Delivery Profile to email reports to various power users at scheduled intervals.

Environment: OBIEE 10.1.3.3, 10.1.3.4, Oracle 10g, MS Excel, Linux, Windows XP, SQL Plus

Client: Confidential, PA August 2007 – May 2008
[Siebel Analytics Developer]

Roles & Responsibilities:

• Involved in gathering the reporting requirements from Operation and Marketing departments.
• Identified the GAPs by analyzing the Data mart instance and provided alternative solutions as well recommended changes to database.
• Analyze Design and Developed Metadata repository (.rpd) that consists of physical layer, multiple business models with dimensions & time series objects, presentation layers with catalogs, external table security using session variables, LDAP authentication, assigning catalog objects & Web modules to users & groups etc.
• Designed and developed the various Dashboards/Reports that are Dynamic & Interactive with drill-down capabilities and local & global filters and cache monitor using Siebel Analytical Web. Extensively used Siebel Delivers and iBots.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performed Unit testing and Integration testing to validate Dashboards/Reports.
• Developed/Updated Informatica Mappings and Workflows for ETL processes per reporting requirements.

Environment: Siebel Analytics 7.8.3, Informatica Power Center 7.1.2, Oracle10g,

Confidential, MI Jan 2006 – July 2007
[Informatica Developer]

Roles & Responsibilities:

• Created new ETL transformations, mappings, mapplets, workflows and loading data into DW transforms.
• Tracking long running Transformations and Loads and was involved in performance tuning the SQL queries.
• Executing Day to Day Operations which include rerunning the jobs on failure, fixing the transformation issues and verify data quality of the tables.
• Developed and tested stored procedures, functions in SQL for data ETL Process.
• Handled dynamic data load via staging tables in the ETL Layer.

Environment: Informatica Power Center 7.1.2, Oracle 10g, Windows, TOAD

Confidential, Hyderabad, India
HQ: TeamF1, CA Jan 2005 – Jan 2006
[Software Engineer]

Roles & Responsibilities:

• Developed core modules which are the major components of the product.
• Coordinated with other teams for quality performance and resolving at critical stages.
• Debugged issues reported by QA team and customer.
• Maintained projects after stable release.
• White box testing of the components.

Environment: gcc, Windows and Linux, shell scripting, C,