Summary:

• Around 6.7 years of progressive experience in the IT industry with prime focus on analysis, modeling, design, development, implementation, testing, documentation, and maintenance of various Business Analytics in an effective way to deliver leading edge software solutions.
• Involved in all phases of design, development and implementation business Intelligence applications and my areas of expertise include business analysis, dimensional modeling, implementing Business Intelligence analytics solutions using Oracle BIEE 11g/10.1.3.x, Extraction Transformation and Load ETL using tools like Informatica Power Center, Expertise in Data Warehouse Administration Console DAC 11g/ 10.1.3.4.1 to configure, monitor and schedule ETL and system integration/user acceptance testing.
• Experience in implementing and providing solution for Financial, Sales, Manufacturing, Insurance business intelligence module.
• Proficient in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model and Mapping Layer Presentation Layer , Time Series Objects, configuring metadata, Answers, Delivers/ Interactive Dashboards/ Reports with drill-down drill-across capabilities using global local Filters, Security Setup Groups and Access Privileges , Web Catalog Objects and scheduling iBots.
• Experience in implementing Oracle Business Intelligence row level, Data Level and Object Level Security using LDAP.
• Extensively worked on implementing the LDAP, external table and database authentication in OBIEE 11g.
• Expertise in developing ad-hoc reports and dashboards as per business requirements using the OBIEE UI presentation services.
• Expert in configuring the delivers and scheduling the reports using the OBIEE Delivers.
• Solid understanding of Ralph Kimball approach and experience in Dimensional Data Modeling, Star Schema modeling, identification of Fact and Dimension Tables, Normalization, Physical and Logical Data Modeling.
• Extensively worked with Informatica Power Center Designer to create various mappings and maplets used for ETL operations.
• Extensively worked on Informatica Power Center Workflow Manager and Workflow Monitor to successfully perform the ETL.
• Experience in designing the data warehouse using the dimensional modeling techniques.
• Experienced in Installation, configuration, upgrade, migration and administration of OBIEE, Data Warehouse Administration Console DAC , and Informatica Power Center.
• Experience in designing DAC subject area, scheduling the execution plan using DAC client tool and debugging the ETL load using Informatica and DAC client tools. Configure, monitor and Schedule ETL routines of DAC.
• Highly experienced on Database such as Oracle 11g/10g/9i, SQL Server 2008.
• Extensively used SQL, PL/SQL to write stored procedures, functions, package and triggers.
• Experience in coordinating onsite/offshore team.
• Overall strength lies in precise translation of business requirements into technical documents. Ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

Technical skills:

Professional Experience:

Confidential

Data warehouse consultant

Responsibilities:

• Understanding and implementing the ever changing business requirements for Supply Chain and Finance modules.
• Interacted with managers, financial business team and other business users to gather the reporting requirements.
• Involved in installing and configuring the Manufacturing analytics - BI Apps 7.9.6.4. Also, involved in providing the proof of concept to the management team.
• Developed the OBIEE repository by Involved in designing the physical, BMM presentation layer using the OBIEE Admin tool.
• Involved in creating data filters in OBIEE Admin tool based upon the division.
• Developed ad-hoc manufacturing reports and manufacturing sales, production performance and inventory dashboards as per the BRD document using OBIEE UI.
• Involved in creating custom application roles to implement role based security in OBIEE 11g.
• Created Data filters to implement row level security in OBIEE Admin tool.
• Involved in migrating the OBIEE contents from one environment to other.
• Developed Custom Mappings and Workflows in Informatica to bring the data from Oracle EBS system.
• Involved in customizing the DAC execution plan.
• Monitored Incremental and full load of data through Data Warehouse Administration Console DAC .
• Worked on customizing the design, setup and execute tab of DAC on a custom created source system container.
• Involved in unit testing and integration testing of OBIEE reports and dashboards.
• Co-ordinated with testing team to fix the reports issues.

Environment: OBI EE 10/11g, OBIA, Informatica, ERP R12 Oracle EBS , Oracle DB.

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with Business Users, gathering the business and analytic requirements from different user groups.
• Design, setup security model and implemented single sign on SSO for OBIEE dashboard and BI publisher
• Configured LDAP server settings in the BI Server and BI publisher to set up users and groups.
• Used the Security Manager in Oracle BI Admin Tool to set up access privileges and query privileges.
• Implemented Query Federation Horizontal and Vertical using Essbase and Relational Database as the data source.
• Worked on the Double Column Feature.
• Implemented Parent-Child hierarchy using both Essbase and Relational Database as the data source.
• Worked in different coding of BI Publisher including XDOFX, XDOXSLT and FO.
• Implemented the concepts of using array in the BIP codes.
• Implemented bursting the BIP report to various users.
• Worked on the Data level Security part.
• Set up audit logs to retrieve information regarding the user, login time report accessed and others for BIP reports.
• Did Troubleshoot and performance tuning BI server, data warehouse, dashboard and answers and did cache management.
• Set up Multiuser Development Environment MUDE and created projects using the Project Manager utility.
• Implemented custom/OOB business intelligence solutions Metadata and Dashboards/Reports using the BI Applications Analytics platform.
• Created dimensional hierarchies, Level based measures, Fragmentation content, Aggregations, and complex joins.
• Performed installation and configuration of BI Scheduler for delivers.
• Installed the OBIEE and BI publisher and configured the data sources, security, setting up the super user for Publisher and integration with BI presentation services.
• SA System Subject area was configured to set the delivery profiles of all the users from LDAP directory.

Environment: OBI EE 11/10g, BI publisher, Oracle DB.