SUMMARY:

• Working as INFORMATICA MDM QA
• Creating and modifying metadata repository using OBIEE Admin tool.
• Creating Reports and Dashboard using OBIEE Presentation Services.
• Working with Aggregate Tables and defining Levels for logical table Source Design and customization ofAnswers, Reports and Dashboards.
• Reports look and Feel using Column Formatting, Conditional formatting.
• Performed security administrative tasks like creating users and assigning them privileges to groups.
• Creating Hierarchical Reports in OBIEE 11g
• Creation of unit test cases and unit testing.
• Migrated reports from 10g to 11g
• Implementing Security For
• OBIEE Reports.
• Hands on Informatica Powercenter
• Expertise in DAC Tasks creations/Building the plans/scheduling.

PROFILE:

• 9+ years of IT experience in Analysis, Design, Development and Deployment of Data Warehousing applications using OBIEE11/12C, Cognos 8,Cognos ReportNet, Informatica,MDM and database applications like Oracle, DB2, MS SQL Server and MS Access for internal and external clients.
• Currently working as Informatica MDM QA.
• Have good knowledge and experience in the areas of Data Warehousing Concepts & Report development. Extensive expertise at developing and scheduling ad - hoc and canned Analytics Reports using OBIEE Answers(Reports), Dashboards.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment.
• Translating business requirements into logical business dimensional model. Defining various logical subject areas and organization of Presentation Layer metadata; Understanding and defining key metrics, dimensions, hierarchies and attributes.
• Developed various reports based on different Views in OBI Answers and developed Dashboards.
• Good knowledge of how business processes work and interact.
• Proficient in using the following tools: Oracle BI Administration, Oracle BI Answers, Oracle BI Dashboards KPI’S.
• Self-reliant and Proactive to identify and understand business problems and develop solutions.
• Extensive experience in design and development of metadata models utilizing Framework Manager(COGNOS 8X).
• Extensive utilization of Framework Manager to manage relationships, data source, namespace, query subjects, query items, packages and publishing to Cognos 8 portal and Report Net environment.
• Created different reports including List, Sub and Cross-Tab type reports using Cognos8, Report Net.
• Experience developing various reports and queries utilizing Report Studio, Query Studio, Analysis Studio, Report Net, for both internal and external clients
• Comfortable with collecting business requirements and presentations of end products to members of management teams and end users.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2000/NT/98/95, Linux

Databases: Oracle 8i/9i, 11g

Other Tools: Toad 9.5, SQL Developer.

Web Development Applications: HTML.

Methodologies/Process/Tools: OBIEE11g(11.1.1.7.x)Software Engineer

PROFESSIONAL EXPERIENCE:

ETL QA Lead

Confidential

Responsibilities:

• Developed test plans, test scenarios, test cases, test data and test scripts for different types of testing activities. execution of test cases, test scripts, captures test results, test metrics.
• Working closely with LOB owners and testing the production code which is to be deployed.
• Identified bugs and tracked system defects, Performed root cause analysis of the defects and worked with the development team to resolve them.
• Partners with test leads and architects to develop and establish Quality Assurance standards and best practices.
• Managed regression test for month end release.
• Executed batch commands from source to MDM WRK and from MDM WRK to HUB.
• Validated the source and target data.
• Involved in automation Scripts.

OBIEE Prod Support Tech Lead

Confidential

Responsibilities:

• Responsibilities: - Handled 3 months Transition part from the client.
• Gathered the required information & Installed Informatica client version,DAC,Toad.
• Expertise in Informatica,DAC Tasks creation/building plans/migrating and deploying to production.
• Involved In resolving the firewall issues to access the Informatica with Client and Confidential .
• Primary responsible to resolve any production issues in DAC,OBIEE11/12CV,BIP & Informatica.
• Clearing the Fact Staging Error table By analyzing the Informatica workflow SDE and SIL Log s by analyzing the query.
• Handling OBIEE TICKETS.BI PUBLISHER TICKETS. Resolving the issues by fetching the physical queries from the log s.
• Resolving RPD issues In physical/BMM/Presentation Layers.
• Resolving/Fixing OBIEE production issues & standalone BI Publisher production issues.
• Resolving issues related to OBIEE analytics like combined analysis, Dashboard Prompts.
• Resolving Data discrepancy issues by taking OBIEE Report logs and analyzing the Physical Sql query.
• Scheduled BIP Reports, Migrated Data model and standalone BIP reports with in the Test env s

OBIEE REPORTS DEVELOPER

Confidential

Responsibilities:

• Analyzed the business requirement as the business involves in constructing and Leasing out the shopping malls across the USA & Asia
• Developed Reports to analyze the Lease commencing date (LCD) & Lease Termination Date (LTD) and avg rent calculation of the shopping malls.
• Developed the reports as per the user requirement like the reports should display in different formats for USA & Asia
• Used combined analysis, pivot tables, Narrative views, Presentation variables,
• Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot chart views in OBIEE Answers and embedded them into new/existing dashboards pages as required by the project.
• Used combined analysis to develop a report.
• Fixed One BIPublisher(BIP) Report for Ansys Client
• Got Hands on POC for cedar consulting(UK). Database used Peoplesoft integrated with OBIEE11V

Confidential

Software Engineer

Responsibilities:

• Developed simple reports for the company
• Mainly to over look the of the Organization progress year wise by Developing the dashboards and various other reports
• . Developed Reports and Dashboards using OBIEE11g.
• Developed Reports using Guided navigation and Dashboard Objects in OBIEE11g
• Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot chart views in OBIEE Answers and embedded them into new/existing dashboards pages as required by the project.
• Extensively used Variables (repository and presentation) in the process of making the reports.
• Implement cache management for repository, Dash board level security
• Creating the Dashboard prompts.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.

Confidential

Software Engineer

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool. connection pools, physical tables, defined joins and implemented Created authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Analysis and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Migrated reports from 10G to 11G
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.

Confidential

OBIEE Developer

Responsibilities:

• Used Admin tool to creation of repositories by using physical layer,BMM layer and presentation layer.
• Worked on BMM layer to customize the tables,hierarchies,dimensions and aggregations and calculations
• Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot, chart views in OBIEE Answers and embedded them into new/existing dashboards pages as required by the project.
• Extensively used Variables (repository and presentation) in the process of making the reports.
• Implement cache management for repository, Dash board level security
• Creating the Dashboard prompts.

Confidential

COGNOS DEVELOPER

Responsibilities:

• Created the reports by using ReportStudio .
• Updated the reports according to the clients requirement.
• Created list reports, cross-tab reports.
• Created list reports by applying cascading prompts.
• Created different types charts like column charts and Bar charts
• Created Master-Detail Reports and Drill Through reports
• Worked with Data Formatting properties.
• Created Name space,Query subject to develop and Publish Packages using Frame work Manager.