SUMMARY:

• 9 years of Complete Life Cycle Gathering Business Requirements, GAPS Analysis, identifying analyzing the source/feeder systems, Design Data Modeling, Development, and Testing implementation experience of Enterprise Business Intelligence EBI using Oracle BI.
• Good in analyzing, customizing, development, and implementation of OBIEE pre-built Analytics BI Apps .
• Strong Knowledge of all phases of Software Development Life Cycle SDLC such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support.
• Experienced in Global Delivery Model Onsite/Offshore . Coordinated activities onsite offshore towards meeting project timelines
• Expert in designing, development, and implementation of OBIEE pre-built Analytics with Informatica.
• Expertise in OBIEE OBIA Installation to set up the environment for Development/Testing/Production
• Experience in OBIEE HA set up
• Experience in Informatica Installation in AIX
• Expertise in developing Oracle BI Repository .rpd with necessary logic creating Physical, Business Model Presentation Layer, Hierarchies, Security Setup, External Tables, Web Catalog Objects .
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel/Oracle Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Expertise in developing Dashboards/Reports using Oracle BI Publisher.
• Expert in developing BI Publisher templates using template builder/xslt code, also have knowledge in building templates using excel.
• Worked with Business Analysts/partners/Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications, Traceability Matrixes, Risk Analysis, Integration testing.
• Experience in working with different operating systems like Linux, AIX and WindowsNT/2000/2003.
• Good Exposure on Informatica
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent communication skills and experience working with business user's community and leads/managers.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Siebel Analytics 7.x, OBIEE 11.1.1.5.0 11g /10.1.3.4/10.1.3.3, BI Publisher, BI Delivers, OBIEE Dashboards, OBIEE Answers, BI Apps 7.9.x. Languages: PL/SQL, HTML, XHTML and XML

Operating Systems: Windows NT, Windows 2000/98/95, LINUX, AIX Databases used: SQL Server 2005, Oracle 9i/8i/10g, and MS Access ETL: Informatica Power Center 9.1/8.6.1,8.1/7.5.3/7.1.4,ODI

EXPERIENCE DETAILS

Confidential

OBIEE Admin/Development/Lead

Environment: Oracle Business Intelligence OBI EE 11.x, BI Publisher 11.x, ODI, BI Apps 7.9.x, Oracle 11g.

Responsibilities:

• Having Test Lead experience on large ERP implementation projects.
• Identified key dimensions and measures for business performance, customizing the BI Apps OTB Metadata Repository .rpd using Oracle BI Admin Tool
• Customized the BI Apps repository, by building the new hierarchies, Logical Tables, Physical and Complex Joins according to the Client's Business without breaking the OBIEE Functionality.
• Involved design and development of repository RPD creating/Modifying objects in Physical, Business and Presentation layer and the process of repository migration
• Experienced in Installation and configuration OBIEE on various servers and System Administration using AIX.
• Implemented most of the OTB 'Out Of The Box' functionality, Customized some of the OTB reports without breaking the OTB functionality
• Having recent OBIEE testing experience developing test strategies on a data warehouse project.
• Having recent QA experience in Walgreens testing activities.
• Validated backend database when doing master data validation.
• Having experience writing test plans and test cases for data warehouse projects.
• Having experience with testing functionality of reports and reconcile back to source systems
• Having solid experience in using ALM
• Developing Reports/Dashboards using OBIEE front end OBIEE Presentation Services . Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.
• Expertise in creating Adhoc reports.
• Responsible for OBIEE reports.
• Responsible for cube validation with the database.
• Responsible for security validation.
• Responsible for task allocation to offshore team.
• Having good communication with business.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client's requirement.
• Developing highly formatted reports using BI Publisher, Developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client's requirement.
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Documented all the different technical and functional aspects of the project.
• Good experience in onsite-offshore model.

Confidential

OBIEE Admin/Development Lead

Environment: Oracle Business Intelligence OBI EE 11.x, BI Publisher 11.x, Informatica 9.x, BI Apps 7.9.x, DAC, Oracle 11g, AIX 7.

Responsibilities:

• Interacted with business team and vendors to gather Business Requirements as well as to define business and functional specifications.
• Build OBIEE environment for DEV/SIT/PROD AIX.
• Installed all the components separately by selecting Software Only when installing OBIEE.
• Applied latest OBIEE Patches.
• Build OBIEE in 2 servers in that second one is Scaled Out.
• Done OBIEE HA set up in all the servers.
• Build Informatica environment in AIX.
• Modified Config files in OBIEE.
• Implemented company LOGO instead of default Oracle logo.
• Provided user training to make users familiar with new OBIEE 11g environment.
• Prepared hardware sizing document.
• Designed and Developed new security model for 11g based on the new 11g security setup roles and policies .
• Involved design and development of repository RPD creating/Modifying objects in Physical, Business and Presentation layer and the process of repository migration.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports to improve performance.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Reponsible for implementing Object level security for the various users who would be using the BI system.
• Extensively involved in setting up Data level security for the BI Reports and also handled thesecurity and privileges from the Database to the Oracle repository.
• Setting up the Administered Privileges and Security for various users using the LDAP security.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problemsby reviewing design changes made to production systems and made corresponding changes toRepository.
• Experienced in Installation and configuration OBIEE on various servers and System Administration using AIX.
• Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents BRD's , preparing high level and low level design documents, Development, Support.
• Participated in Business Requirement Documents review, HLD, LLD and Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.
• Participated in GAP analysis, Impact Analysis.
• Expert in presenting the designs to business and in getting signoff's with some report mockups without actual developing the reports .
• Expert in designing and developing Rpd repository using OBIEE Admin tool. Developing all the three layers Physical, Business Model and Mapping, Presentation with oracle's best practices.
• Developing Reports/Dashboards using OBIEE front end OBIEE Presentation Services . Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client's requirement.
• Modifyied some of the OTB reports and dashboards, and fixing some of the issues related to performance, data quality during production support.
• Developing highly formatted reports using BI Publisher, Developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client's requirement.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Documented all the different technical and functional aspects of the project.
• Performed stakeholder analysis team and weekly status reports to leadership teams

Confidential

OBIEE Admin/OBIEE Development Lead

Environment: Oracle Business Intelligence OBI EE 10.x, BI Publisher 10.x, Informatica 8.x, BI Apps 7.9.x, DAC, Oracle 11g, Teradata, Exadata, UNIX.

Responsibilities:

• Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents BRD's , preparing high level and low level design documents, Development, Support.
• Participated in Business Requirement Documents review, HLD, LLD and Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.
• Participated in GAP analysis, Impact Analysis.
• Expert in presenting the designs to business and in getting signoff's with some report mockups without actual developing the reports .
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Implementing MUD Multi User Development environment across the whole organization which helps in smooth, easy, fast rpd development.
• Expert in designing and developing Rpd repository using OBIEE Admin tool. Developing all the three layers Physical, Business Model and Mapping, Presentation with oracle's best practices.
• Developing Reports/Dashboards using OBIEE front end OBIEE Presentation Services . Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client's requirement.
• Developing highly formatted reports using BI Publisher, Developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client's requirement.
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Implementing MUD Multi User Development environment across the whole organization which helps in smooth, easy, fast rpd development.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments SIT, UAT, and Production .
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Leading a team of 3 members Offshore , Delegating work equally and effectively among team, helps in meeting the deliverables.
• Performing Unit testing, providing test cases for the QA team TCOE .

Confidential

Sr OBIEE Developer

Responsibilities:

• Created Physical joins, logical joins and complex joins in physical and BMM Layer
• Implemented complex data models in Business and Physical Layer.
• Extensively worked with complex reports.
• Working in OBIEE Answers to build various reports like Static Text view, Pivot table view, narrative view etc.
• Used View Selectors, column sectors, Filter views, No Result Views .
• Prepared test plans and documented test results
• Went through UAT User Acceptance Test . There were data issues as well which were resolved within specified time.
• Resolving issues faced in production environment.
• Interacting with customer to understand the requirement via email, Same Time ST , telephone.
• Code review, FE review, suggesting the possible solutions for problems, taking part in internal meetings.

Environment : OBIEE 10.1.3.2, Informatics 8.X, Oracle 9x.

Confidential

Responsibilities:

• Understanding requirements and customizing the Repository to meet the requirements
• Created Physical joins, logical joins and complex joins in physical and BMM Layer
• Implemented complex data models in Business and Physical Layer.
• Extensively worked with complex reports.
• Documentation of various activities in the project
• Created new Dashboard for Churn.
• Prepared test plans and documented test results
• Understanding the quality process and implementing the same in the project quality assurance.

Environment : OBIEE 10.1.3.2, Informatics 8.X

Confidential

Responsibilities:

• Created Physical joins, logical joins and complex joins in physical and BMM Layer
• Created reports using Pivot, Table, Chart views
• Extensively worked with complex reports.
• Enhancing the subject areas as and when suggested by the business analysis
• Customized requests by using different views Chart, Pivot table etc,

Environment : OBIEE 10.1.3.2, Informatics 7.X

Confidential

Tester/QA

Responsibilities:

• Preparing the Test Cases.
• Performing Manual Testing.
• Preparing Documents related Test Cases.

Environment : ASP with SQL Server