Prathap Kumar Gowda

**** ****** ******** * *** C*, Manchester, CT-06040

Phone: +1-860-***-**** Email:adhk4c@r.postjobfree.com

Skype name: prathapkumargowda

PROFESSIONAL PROFILE

* ***** ** **dustrial Expertise across the all the areas of SDLC. Have experience in Agile delivery methodology, OBIEE reporting, Informatica ETL development and maintenance. Worked with diverse client backgrounds like Insurance, CG&S, Pharmaceuticals, Resources and Hospitality managing multiple releases and was involved in development of Oracle BI reports across Financial, Planning and Promotion, Real time reporting areas. Worked across all the areas of SDLC and possess Working knowledge on MicroStrategy and SAS tools. Proficient in the areas of RPD Design, Dashboard & Answers management, Scheduler Configuration, Migrations, Version upgrades, Informatica mapping designs, DAC, Performance Tuning and Security Management.

TECHNICAL AND FUNCTIONAL EXPERTISE

Working experience of ORACLE, OBIEE (10G/11G), Informatica PowerCenter (9.0.1/ 8.6.1).

Experienced in performing OBIEE/Informatica Installations, Migrations and Performance Tuning.

Experienced in development and maintenance of Informatica Mappings and worked as L3 support.

Performance tuning of Informatica Mappings by analyzing the session logs across the threads.

Development of re-usable mapping.

Creating various analyses on OBIEE and troubleshooting any in case of any issues.

Worked as Lead Developer for various projects and managed multiple development projects parallelly. Have very good experience working in Offshore - Onshore model and handling team from Onshore.

Strong SQL knowledge for performing the data analysis and assist business for analysis, fine tuning requirements and User acceptance testing.

Experienced in creating data flow mappings using Informatica. Worked on end to end ETL data load using complex transformation logics.

Used various transformations like source qualifier, lookup, sorter, normalizer to transform data and load into target tables.

Worked at L3 support for various projects and helped the client in developing defect fixes and doing root cause analysis for any issues encountered.\

Load monitoring and debug for any issues that may come up in the workflow.

Experience in Different Types of Layers like Physical, BMM, Presentation Layer in both OBIEE 10g and OBIEE 11g.

Experience in Creating Dimensional Hierarchies, Measures, Time series, Variables and Caching.

Expertise Knowledge in Creating Reports, different charts, narrative view, column selector, view selector, pivot table and Dashboards with Prompts.

Expertise in Configuring Repository and Create / Manage Dashboards, Reports /Answers.

OBI Security Setup (groups, access / query privileges) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Implemented security based on LDAP Authentication.

Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.

Used SawSession service API for authentication and XMLView Service API for transferring the required data to external application.

Modified existing outbound SawSession service API's, XMLView Service API based on the requests of the user.

Worked on passing parameters from OBIEE report to an external website by ensuring we are navigating to the required webpage and passing values through the action links.

Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and managed security for groups in Answers.

Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Experienced in working on BI publisher and creating BIP reports

Possess working knowledge on Power BI and SAS reporting tools.

Provided guidance and support to end users during the implementation and in production.

Experienced in creating Informatica Mappings, Workflows and DAC Tasks.

Experienced in fixing the Informatica data issues.

Initiative-taking developer with strong Analytical and Development skills.

Having good exposure to Software Development Life Cycle (SDLC).

Capable of meeting deadlines, quick learning and ability to grasp new technologies

Have good knowledge on JIRA tool. Created project release and development tasks in JIRA tool.

Experience in User Support and training end users for efficient use of developed applications.

Excellent analytical and problem-solving skills with ability to communicate effectively with business users.

TECHNICAL AND FUNCTIONAL SKILLS

Reporting Tools

OBIEE 11, OBIEE 10, MicroStrategy, SAS,ORACLE

ETL /ELT Tools

Informatica Power Center 10.x, 9.x

Tools

Toad, SQL Developer, HP ALM, JIRA, SVN, Control-M, BI Publisher Desktop, Rally.

RDBMS

Oracle, DB2, SQL Server

Operating Systems

Windows Server, Unix

Languages/Scripting

SQL, PL/SQL, Unix

Framework

Agile Delivery Methodology

WORK EXPERIENCE

Current Company : Accenture (Feb 2012 – Till Date)

PROJECT ROLES AND RESPONSIBILITIES

Client: Prudential Insurance, Roseland, NJ

Project Duration: Aug 2020 - Present

Assigned Role: Reporting Consultant/ Informatica ETL developer

Tools Used: Rally, OBIEE 11.1.1.7, Informatica 9.0, DB2, JIRA, SQL DBX,ORACLE

Major Responsibilities:

Providing Technical and Functional assistance to team members for issues/queries.

Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.

Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.

Import the data sources and connect to AWS S3 for extracting the source files.

Develop Informatica Mappings and workflows to retrieve and transform data from their claims systems.

Develop workflows using tasks, worklets in workflow manager and added emails to receive alerts on status of loads.

Create payment and tax reports for the business using different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.

Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.

Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.

Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Developed Reports and Dashboards with

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Client: Travelers Insurance, Hartford, CT

Project Duration: Aug 2019- Aug 2020

Assigned Role: Reporting Developer / Product owner

Tools Used: Rally, OBIEE 11g, DB2, Informatica 9.0

Major Responsibilities:

Providing Technical and Functional assistance to team members for issues/queries.

Requirements gathering meetings with key project stakeholders.

Worked during the whole life cycle of the project from requirements gathering to deployment.

Created and refined user stories for the development work.

Participated and conducted the Agile ceremonies - Story Refinement, feature refinement and ART sync meetings

Functioned as a liaison between business users and BI team to facilitate understanding of business requirements.

Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.

Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.

Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.

Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.

Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.

Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Used SawSession service API for authentication and XMLView Service API for transferring the required data to external application.

Modified existing outbound SawSession service API's, XMLView Service API based on the requests of the user.

Worked on passing parameters from OBIEE report to an external website by ensuring we are navigating to the required webpage and passing values through the action links.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Client: Marriott International, Bethesda, MD

Project Duration: Jan 2017- Aug 2019

Assigned Role: Reporting Consultant / Product Owner

Tools Used: Rally, SAS, Informatica 9.0, DB2, Netezza, JIRA, SQL Developer, Unix, MicroStrategy

Major Responsibilities:

Requirements gathering meetings with key project stakeholders.

Creation of Business Process documents.

Creation of Configuration documents and System Configuration.

Creation and updates to Functional documents.

Worked during the whole life cycle of the project from requirements gathering to deployment.

Created and refined user stories for the development work.

Participated and conducted the Agile ceremonies - Story Refinement, feature refinement and ART sync meetings

Functioned as a liaison between business users and BI team to facilitate understanding of business requirements

Created informatica Mapping object for historical data load from legacy systems as part of data migration project.

Utilized UNIX scripts in informatica for creating pipe files before executing the batch jobs to load the Netezza tables.

Worked in development and data validation of SAS reports

Utilized the reusable MACROS for time identification and Libraries for creating SAS reports.

Ensured the data validation on the report is done by using NODUP KEY functions.

Providing Technical and Functional assistance to team members for issues/queries.

Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.

Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.

Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.

Developed reports capacity and occupancy reports for the hospitality client in MicroStrategy reporting tool

Worked with UAT and QA teams to ensure the data migration validation is done between the source and destination systems.

Client: Consolidated Edison, New York, New York

Project Duration: Dec 2016 - Jan 2017

Assigned Role: Reporting Consultant/ETL developer

Tools Used: Rally, OBIEE 11.1.1.7, Informatica 9.0, JIRA, SQL developer

Major Responsibilities:

Providing Technical and Functional assistance to team members for issues/queries.

Functioned as a liaison between business users and BI team to facilitate understanding of business requirements.

Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.

Provided insights on existing mapping and

Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.

Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.

Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Client: Cisco, San Jose, CA

Project Duration: April 2016 - Dec 2016

Assigned Role: OBIEE/Informatica developer

Tools Used: Rally, OBIEE 11, Informatica 9.0, Oracle 11, SQL Developer, Rally

Major Responsibilities:

Provide estimates for new requirements or projects and present estimations to Accenture onshore project manager for approval. Estimating effort and bandwidth of each resources and creating plan for future changes.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.

Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.

Develop Mapping and analyze the existing mappings on Informatica.

Involved in Performance tuning of Informatica Mappings.

Client: BMS, New Jersey

Project Duration: Oct 2015 - Apr 2016

Assigned Role: OBIEE/Informatica Developer

Tools Used: Rally, OBIEE 11, Informatica 9.0, DAC,BI Publisher

Major Responsibilities:

Providing Technical and Functional assistance to team members for issues/queries.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Work with MUDE utility on OBIEE for simultaneously working with the other developers on the team.

Created data flow mappings using Informatica power center to load data from various source systems like customer care, sales, business and automotive to Oracle Datawarehouse.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Created workflows using tasks, worklets in workflow manager and added emails to receive alerts on status of loads.

Run Jobs on DAC scheduler on for daily and weekly Jobs.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Work with Offshore team to complete build on time by sharing work and review the Status of work every day by having status calls with onshore team.

Perform the Build Review with Client Technical Team and based on sign off performing the Migration Activities to the QA, UAT and Production Environments.

Client: Procter & Gamble, Cincinnati, Ohio

Project Duration: Feb 2012 - Oct 2015

Assigned Role: OBIEE/ETL Developer

Tools Used: Rally, OBIEE 10G, Informatica 9.0, Oracle Database 11g, Quality Manager, Informatica 9.0, HP ALM, SQL, Oracle BI Administration

Major Responsibilities:

Worked as Lead offshore developer handling team of 5 to successfully complete all project phases. Involve in daily status call meetings with onshore team and provide project status and bottle necks in project timeline.

Fix Compatibility issues in OBIEE and Informatica like query performance issues, change in report calculations and modify existing reports to use new functionalities to improve performance.

Improved performance of existing Informatica mappings by converting database functions to lookup and split query to make sure loads complete before 6AM.

Configured OBIEE RPD and created the new Reports based on the requirements.

Improved performance of existing reports by creating summary tables and indexes.

Created new Informatica Mappings using multiple Transformations for new model change requirements.

Scheduled and handled Status Meetings and UAT Sessions with business users from offshore.

Designed and Implemented Security model for product owners to restrict and present relevant data to business users.

Created IBOTS to seed Cache for most used reports and email Daily Status Reports.

Work with UAT and SIT teams to successfully complete project testing and fix any defects raised by QA team.

Providing Technical and Functional assistance to team members for issues/queries.

Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.

Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.

Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.

Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.

Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Used OBIEE Web Catalog to set up groups, access privileges and query privileges.

Education and Certifications

Certified as AWS Cloud Practitioner

Certified as Scrum Product Owner from Scrum Alliance

Bachelor’s Degree with Distinction from Sir MVIT College, Bangalore affiliated to Visvesvaraya Technological University with 76% Aggregate.

Pursuing Online master’s in information science – Specialization in Business Intelligence and Analytics – Expected Graduation in May – 2021

Accenture Training and coursework

Declaration

Declare that the information and facts stated herein above are true and correct to the best of my knowledge and belief.

Date: Oct 26th, 2020 Prathap Kumar Gowda

Contact this candidate