We provide IT Staff Augmentation Services!

Etl Qa Lead Resume

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.

Hire Now