adbdb2@r.postjobfree.com

Mobile: +1-717-***-****

Areas Of Expertise

Working as INFORMATICA MDM QA/OBIEE development/DAC exertise/Informatica Production support team lead.

Tested MDM “Hub” inclusive of current Customer Master Capabilities (data elements, source systems, and matching logic) plus key data elements and MDM mastering logic specific to Bank of the West and BNPP KYC and broader Compliance requirements. MDM data domains will include Party, Account, and Product

Analyzed and reviewed ETL (Informatica) mappings to understand the technical implementation of the business rules

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 of Answers, 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.

Trainings & Certifications

IZO-051 ORACLE DATABASE 11G FUNDAMENTALS

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),

Education

PG in Business Management

(Oxford Business College,Oxford UK 2008)

Bachelor of engineering Computer Science and Technology (DR BAMU university Aurangabad Maharashtra 2003)

Board of intermediate

(MPC) (Vignan Co-operative Junior college Guntur 1998)

SSC 10th

(Vijay Public School 1996)

Software Engineer

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.

Professional Experience

ETL/MDM QA Lead ( FEB-2019 to Current Date)

Client :Bank Of The West. Organization:-TechMahindra.

• ETL validation of master data management program, to ensure data consistency and quality is governed across the enterprise with over (200+) data elements across systems without a consistent way of identifying customers and related information including parties, accounts, relationships

• ETL validation of KYC program to meet compliance and regulatory goals.

• Analyzed and understood the testing requirements from business requirement document, technical

Requirement specs

• Analyzed and reviewed ETL (Informatica) mappings to understand the technical implementation of the business rules

• Designed and documented Data warehouse (EDW) testing strategy covering the test cases for validating the data completeness and correctness, system performances of the ETL processes etc.

• Data Quality check

• Involved in testing all the three layers such as Data Sourcing, Data Quality & MDM STG and also involved in MDM HUB & Views testing as well.

• Tested MDM “Hub” inclusive of current Customer Master Capabilities (data elements, source systems, and matching logic) plus key data elements and MDM mastering logic specific to Bank of the West and BNPP KYC and broader Compliance requirements. MDM data domains will include Party, Account, and Product.

• Tested Unique Party ID for active distinct Party and related party records

• Involved in testing the master record with all the approximate.131 attributes from 21 source systems for the unique Party IDs based on the survivorship rules and administrative processes

• Tested the Flag Master record for data quality, completeness and accuracy (Mandatory Fields + Non Mandatory) for exception handling based on EDG target data standards

• Tested the LOB Ownership for each Party and related Party record for Data Administration 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.

•Responsible running the MDM_WRK loads, Stage loads, Unmerge jobs, Hubloads,Post Merge batch group jobs through tidal setup.

•Writing the test cases based on ETL mapping document.

OBIEE Prod SupportTech Lead for TechMahindra(19-Mar-2014 Till FEB-2019)

Client :AT&T Organization TechMahindra.

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 Techmahindra.

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,PUNE(SERENE CORPORATION) FROM(29/SEP/2013) TO (03/Jan/2014)

CLIENT:TAUBMAN,Ansys,Cedar Organization:- SERENE CORPORATION PUNE

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

OBIEE REPORTS DEVELOPER,UK

CLIENT :STRATEGYC SOLUTIONS UK LIMITED(NHS)

Software Engineer (APRIL 2012 to JULY 2012)

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.

STRATEGYC SOLUTIONS UK LTD, CLIENT: AMGEN GROUP

(CONTRACT : FEB 2011 – SEP 2011)

Amgen Pharmaceuticals is a speciality pharmaceutical company engaged in the research, development, sale and marketing of branded and generic prescription pharmaceuticals used primarily to treat and manage pain. The project deals in creating an Enterprise Data warehouse consisting of the Sales, Distribution, and Location subject areas as data marts. The sources being dealt are extracted from various databases. Data warehouse was built in order to provide standardized reporting process for the sales force data. Oracle BI Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse.

Primary responsibilities include gathering business requirements, designing the functional and technical specifications.

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.

STRATEGYC SOLUTIONS UK LTD/ CLIENT: WELCH’S FOODS OBIEE Developer ( JAN 2010-OCT 2010)

Welch's is the food processing and marketing arm of The National Grape Cooperative Association, which comprises 1,300 grape growers located in various states in USA. The company also manufactures and markets an array of other products, including refrigerated juices, frozen and shelf-stable concentrates, organic grape juice and dried fruit. Welch's has also licensed its name for the Welch's line of grape-flavored soft drinks, since 1974.

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.

Customized Reports look and Feel using Column Formatting, Conditional formatting.

STRATEGYC SOLUTIIONS UK LTD/ CLIENT: CAPITA GROUP COGNOS DEVELOPER (Sep 2008 - Dec2009)

The project is for providing solution for daily transactional data for the Capita Group business for their Finance Process.Capita Group deals with different insurance companies. The objective is to generate Intelligent Informational reports based on the client’s requirement monthly or periodically which enables to make business decisions and Future forecast for the business through web technology

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.

STRATEGYC SOLUTIONS/ CLIENT: BARCLAY BANK plc Cognos 8 Developer (JAN 2007 - SEP 2007)

Worked on multiple projects including mortgage transformation and CPMO (Project Management and Tools) for 9 months. As a part of BI Mortgage Transformation effort, Operational Reporting Project was initiated to enhance and convert all the existing crystal reports across the company to a dynamic, flexible, user friendly parameterized reports using Cognos ReportNet. As an initial Report rationalization attempt 100+ Crystal reports were successfully consolidated to 40 parameterized reports as per the business requirement. Additionally more business rules were incorporated into these Cognos Reports

Involved in the entire project life cycle from evaluation, installation and development of end user reports and cubes.

Gathered detailed technical client reporting requirements from the business users and interacted with the users regularly till the satisfied end product was developed.

Analyzed and mapped all the existing Crystal Reports against the database to import the metadata for building the Framework Manager Model, and made sure that all the business rules are intact.

Involved in installing and configuring the ReportNet server.

Created complex reports using Report Studio in the Cognos 8 / CRN 1.1 environment.

Created periodical jobs and maintained schedules using the schedule management tool.

Created and provided drill-through capability to drill down to reports from Report Studio.

Performance tuned the reports by optimizing the report SQL.

Provided end user training and support to the business users

Contact this candidate