Professional Summary

• 9 years of IT experience in software analysis, design, development for various software applications with over 6 1/2 years' experience in handling Data warehousing and Business Intelligence tools like OBIEE 11g, OBIEE 10.1.3.x and Siebel Analytics 7.7 and Informatica
• Expertise in building Metadata Repository, Designing Business and Presentation Layers, creating Interactive Dashboards and Reports using Siebel Analytics/OBIEE
• Acted as Project Manager and played critical role in the planning, scheduling, monitoring and execution of projects to support of business objectives for different clients in financial domain
• Data modeling experience using Dimensional Data modeling, Star/Snow flake schema, Fact and Dimension tables, Physical and logical data modeling
• Data sources include Oracle EBS 11i, R12, Custom Sources
• Experience using Informatica PowerCenter 8.1/7.1
• Expertise in ETL design, developing and loading of data into the Warehouse using Informatica.
• Study of Current Business Processes, Future Business Flow and identification of GAP/Workaround
• Expertise in implementing Dimensional hierarchies and OBI Security
• Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring Agents/iBots, and building Alerts.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Expertise in Data Warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Experience in Oracle SQL Server - design and developing Stored Procedures/Packages using SQL, PL/SQL
• Extensive Knowledge in troubleshooting, Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards / Reports to improve performance at Database.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.
• Excellent communication, leadership, organizational, analytical and problem solving skills.
• Good Knowledge in Performance Tuning of Dashboards and on database side
• Also handling project management activities like Invoicing, resource managing
• Mentoring fresher's in OBIEE

Technical Skills

Confidential

Role: OBIEE Lead

Responsibilities:

• Gathered Report Requirement and Specification from the Business.
• Performed Unit testing on the Data and customized the ETL OBIEE to cater to the Clients Business operations.
• Designed their custom reporting structure with few new Star schemas for their custom Datawarehouse.
• Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.
• Designed Data Models and Metadata Repository .rpd with multiple business layers using complex joins
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Involved in designing multiple hierarchies and Time series measures
• Improved Performance by creating materialized views
• Created Agents to run dashboards every day
• Worked on merging the repositories
• Building complex adhoc queries
• OBIEE Report Development and Architecture Skills

Environment: OBIEE 11.1.1.7, Oracle 11g, DAC, Informatica 9.0.1, Unix, Oracle Applications EBS R12/R11

Confidential

Role: OBIEE Lead

Responsibilities:

• Gathered Report Requirement and Specification from the Finance Department.
• Documented a Business Requirement Document with the Input from the Business Users.
• Performed Unit testing on the Data and customized the ETL OBIEE to cater to the Clients Business operations.
• Designed their custom reporting structure with few new Star schemas for their custom Datawarehouse.
• Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.
• Designed Data Models and Metadata Repository .rpd with multiple business layers using complex joins
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards off Peoplesoft 9.0
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Involved in designing multiple hierarchies and Time series measures
• Worked and implemented Oracle 11i Financial EBS. Supported Oracle Modules which includes, General Ledger, Fixed Asset, Accounts Payables and Receivables
• Expertise in implementing the data level security
• Improved Performance by creating materialized views
• Created Agents to run dashboards every day
• Worked on merging the repositories
• Building complex adhoc queries
• Involved in debugging Informatica mappings and fixing the source queries
• OBIEE Report Development and Architecture Skills
• Provide remedial measures to the production issues or process failure
• Proactively involved in getting the process into the project
• Mentoring fresh resources in the project.

Environment: OBIEE 11.1.1.6, OBIA 7.9.6.4, Oracle 11g, DAC, Informatica 9.0.1, Unix, Oracle

Applications EBS R12/R11

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Fine Tuned the Customized Workforce Profile Subject Area by editing the Custom Dimensions and Hierarchies at the Report, RPD Database level.
• Met the Business and gathered all the custom requirements for Pipeline and few more subject areas
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Pull the US GAAP taxonomy using the Row set in R12 Oracle Financials' Financial Statement Generator FSG to prepare for the XBRL taxonomy build
• Involved in designing Custom Star schemas
• Built New Reports and Dashboards using BI Answers apart from modifying the Vanilla Dashboards to analyze the Metrics using the custom Hierarchies.
• Documented every step across the SDLC and trained internal folks on Custom reports
• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code
• Expertise in providing end-to-end business intelligence solution by configuring metadata building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x
• Use the best practices of business intelligence to meet project and company objectives
• Provided complex data structures, dashboards and ad hoc reporting
• Worked on production issues which need immediate resolution
• Caching the reports using ibots
• Import data, RPD development, hierarchies and in the BMM/logical layer
• Worked on resource management, invoicing data and other management activities
• Proactively involved in modifying the existing design model

Environment: OBIEE 10.1.3, Oracle 10g, DAC, Informatica, Windows, Siebel Sales 7.x, Oracle

Applications EBS R12/R11

Confidential

Role: OBI Developer

Responsibilities:

• Created various user groups and assigned them appropriate permissions and privileges.
• Developed various kinds of reports in various views Pivot Table, Chart, Tabular, narrative, View Selector, etc. for better user readability
• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer.
• Customized and developed the OBIEE Business Model and Mapping layer.
• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code
• Worked with SQL Server SSIS Packages
• Worked on monitoring the services of Siebel Services
• Worked on automation of Score card report data
• Fixing the production data issues
• Creation/ Modification of existing and new reports in Siebel Analytics
• Developed various Ad Hoc reports for business
• User training on the newly developed reports
• Worked with offshore team for on time deliverables
• Worked on data cleansing
• Worked on resource management, invoicing data and other management activities

Environment: Siebel CRM Sales 7.7, Siebel Analytics 7, SQL Server, Windows

Confidential

Role: Module Lead

Responsibilities:

• Worked on EIM jobs for data manipulation
• Testing the developed EIM jobs
• Training new resources in the team technically
• Planning and delegation of the tasks to the offshore
• Worked on designing the solutions and responsible for the deliverables
• Interacting with business for requirement gathering
• Worked on the requirements for High level design, Detailed Level Design docs, Functional code

Environment: Siebel Sales 7.7.2, Oracle 9.2.0.6, EIM, Windows

Master of Computer Applications MCA from Andhra University, India in 2004