Etl Qa Lead Resume
3.00/5 (Submit Your Rating)
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.