Prashanth Panchineni
OBIA/Tableau Consultant
ac2ez2@r.postjobfree.com
Cell: 617-***-****
Over 8 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Data Warehousing/ Decision support systems and Business Intelligence (BI). 5+years of experience in Designing and Development of Business Intelligence applications with BI Apps, Informatica and DAC also had good experience in Tableau.
Professional Summary:
Worked on multiple Full Life Cycle developments including Planning, Analysis, Design, Testing and Production Support for OBIEE and tableau applications.
Extensive knowledge on Data modeling, Dimensional Modeling, Star/Snowflake Modeling, Data Marts, OLTP, OLAP, FACT& Dimensions tables, Physical & Logical data modeling.
Expertise in designing and developing dashboards using OBIA by extracting the data from multiple sources (Oracle, SQL Server, Access and Flat files).
Designed and implement test and QA strategies and prepared test case documents and assuring data validation and integration to get approval for prod migrations.
Experienced in loading data from different data sources and incremental loads.
Implemented security in RPD, reports and in admin console as per the user EBS application roles and provided appropriate security in OBIEE.
Good Knowledge and experience in Performance Tuning of the reports and remediating issues with complex database joins and refining query logic in the reports without compromising on the reporting results and functionalities.
Expertise in creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Strong data analytical and debugging skills to ensure accuracy and data integrity.
Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2000/2005.
Expertise in OBIEE 10g/11g, Informatica Power Center and Data Warehouse Administration Console (DAC).
Customizing standard dimensions and facts as per business Requirements.
Diversified experience in implementation of BI systems in SCM and Financials for Healthcare industries
Understanding of Data Warehouse and modeling techniques
Expertise in ETL (Data Extraction, Transformation & Loading) using Informatica
Proficient in coordinating and managing the activities between on-site and off-shore teams.
Education:
Master of Computer Applications (M.C.A) from Kakatiya University in 2007
Technical Skills
Languages:
SQL,PLSQL
Tools/Applications
OBI Apps, Informatica, DAC and Tableau
Operating System
UNIX, Linux and WINDOWS family
Databases
Oracle RDBMS, Oracle 8i /9i/10g/11g
Professional Experience:
Project 1 : Sensata Global Fill Rate . May’17 to Till Date
Customer : Sensata
Technologies : BI Apps, Informatica, DAC and Tableau
Role/Responsibilities:
Participated in Requirement gathering and identified the gaps between the Source and Warehouse.
Modified existing ETL mappings and RPD to particular Subject Area to apply the new Trackwise application changes and incorporated the changes in OBIEE.
Prepared the test cases to validate the report results against source using SQL Queries.
Handled different type production support issues and addressed Break Fix incidents with in timelines.
Building, publishing customized interactive reports and dashboards, report scheduling using Agents.
Restricted data using Row level security and User filters.
Migrated web catalog across diff instances as per requirement at the time of users started testing new changes.
Gathered access needs based on user available Application roles in EBS and designed BI security based on roles.
Designed RPD and dashboards using variables, dimension hierarchies, level based metrics and aggregate tables
Generated context filters and data source filters while handling huge volume of data.
Involved in customizing and extending the warehouse tables using Informatica.
Resolved data issues by debug the ETL mappings and identified the logic breaks.
Validated warehouse data with source data and backtracked source using Informatica and DAC
Created agents and managed to deliver them successfully after Prod ETL’s completion.
Created custom mappings in Informatica then register the tasks and created Execution plans in DAC .
As part of production support handled ETL failures and delivered agents on time.
Provided access to users based on their roles by applying data level security.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
Project Summary
Sensata Technologies used many flat files to generate Global fill report which includes lot of manual work. This report used to compare the week over week price impact analysis. We automated the process by creating warehouse tables and created BIP report to fulfill the requirement. Sensata modified existing Trckwise application which is used to support all Customer and Supplier cares. As part of this we modified existing ETL mappings and RPD to incorporate these changes in existing OBIEE reports and dashboards.
Project 2 : Hologic Sales Scalability Project. Aug’14 to Apr’17
Customer : Hologic
Technologies : OBIEE11g, Informatica 9.0, DAC
Role/Responsibilities:
Extracted Data from various data sources such as Oracle 11g, CSV files and Text files and stored them into warehouse using Informatica
Used various charts like Bar, Line, Combo, Pie charts to show various KPI’s and Scorecards.
Created a security layer for the secured files by providing access at the user level.
Created front end UI objects and implemented the desired navigation.
Created reports and dashboards as per the business requirement.
Distributed and shared tasks efficiently and effectively with off-shore team Prepared test cases by validating source and warehouse.
Worked on production support for running business by monitoring scheduled ETL Jobs and delivering agents on time.
Resolved data issues by debug the ETL mappings and identified the logic breaks.
Validated warehouse data with source data and backtracked source using Informatica and DAC
Created agents and managed to deliver them successfully after Prod ETL’s completion.
Created custom mappings in Informatica then register the tasks and created Execution plans in DAC .
As part of production support handled ETL failures and delivered agents on time.
Provided access to users based on their roles by applying data level security.
Involved in Weekly and Monthly Business reviews.
Created test cases to validate report results against Warehouse and Source.
Coordinated with DB server support team, source EBS/ Siebel teams and based on their scheduled maintenance rescheduled production ETLs.
Worked on extracting and loading the data into warehouse using Informatica
Distributed and shared tasks efficiently and effectively with off-shore team Prepared test cases by validating source and warehouse.
Worked on production support for running business by monitoring scheduled ETL Jobs and delivering agents on time.
Validated warehouse data with source data and backtracked source using Informatica and DAC
Worked on DAC to register tasks and created Subject Areas and Execution Plans
Project Summary:
Hologic changed the existing design to load the data into warehouse. As part of this project, there are major changes in the ETL mappings and OBIEE Reports. Need to validate and the data in the Dashboards and modify as per the new design change. Then Hologic migrated all OBIEE reports into QlikView. We build a warehouse by integrating oracle EBS and Siebel systems as a source systems.
Project 3 : Sensata RISE Feb’12 to July’14
Customer : Sensata
Technologies : OBIEE 11g, BI Apps, Informatica, DAC.
Role/Responsibilities:
Participated in Requirement gathering and identified the gaps between the Source and Warehouse.
Prepared the test cases to validate the report results against source using SQL Queries.
Handled different type production support issues and addressed Break Fix incidents with in timelines.
Building, publishing customized interactive reports and dashboards, report scheduling using Agents.
Restricted data using Row level security and User filters.
Designed RPD and dashboards using variables, dimension hierarchies, level based metrics and aggregate tables
Built dashboards for measures with forecast, trend line and reference lines.
Involved in customizing and extending the warehouse tables using Informatica.
Resolved data issues by debug the ETL mappings and identified the logic breaks.
Validated warehouse data with source data and backtracked source using Informatica and DAC
Created agents and managed to deliver them successfully after Prod ETL’s completion.
Created custom mappings in Informatica then register the tasks and created Execution plans in DAC .
As part of production support handled ETL failures and delivered agents on time.
Scheduled the agents to deliver reports based on different division’s user requirement.
Involved in the developing of star schema and snow flex schema dimensional data models based on the requirement.
Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
Project Summary:
Sensata Technologies is re-implementing the source system and they would like to maintain centralized reporting system across organization than maintaining multiple tools. As part of this they would like to Implement BI Apps finance, SCM, Procurement and spend Manufacturing and Project Analytics. They implemented BI on source system using SCM.
Project 4 : PHT Dec’10 to Jan’12
Customer : PHT Corporation
Technologies : OBIEE 11g, BI Apps, Informatica, DAC.
Role/Responsibilities:
Participated in Requirement gathering and identified the gaps between the Source and Warehouse.
Involved in customizing and extending the warehouse tables using Informatica.
Handled production ETL Scheduling and monitoring by coordinate with DBA support team based on their
Scheduled Maintenance activities.
Created reports and dashboards as per the business requirement.
Involved in RPD changes to extend columns into physical layer to Presentation layer.
Scheduled the agents to deliver reports based on different level of user’s requirement.
Involved in the developing of star schema and snow flex schema dimensional data models based on the requirement.
Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
Prepared the test cases to validate the report results against source using SQL Queries.
Resolved data issues.
Involved in Weekly and Monthly Business review meetings.
Created ad-hoc reports for usage tracking based on user requests.
Closely worked with multiple teams like EBS team, DBA team to resolve the data issues and server side issue.
Project Summary
PHT Corp was implemented the reporting system across organization than maintaining multiple tools. As part of this they would like to Implement BI Apps finance, SCM and Project Analytics.
Project 5 : Osmose PeopleSoft Financials Implementations. May’10 to Nov’10
Customer : Osmose
Technologies : OBIEE11g, BI Apps 7.9.6.3, SQL Server, Informatica
Role/Responsibilities:
Extracted and loads the data into warehouse using Informatica from different sources.
Handled prod ETL Schedules and monitor according to DB Server schedule down times.
Created Reports and Dashboards in OBIEE as per business requirement.
Involved in registered the Tasks, created Subject Areas and Execution Plans in DAC.
Validated warehouse data with source data and backtracked source using Informatica and DAC
Provided access to users based on their Role in OBIEE using different application roles.
Extended custom columns in Informatica and RPD.
Handled Prod ETL failures with in time frame and supported for smooth running business by delivering Agents on time.
Resolved data issues by debug the ETL mappings and identified the logic breaks.
Prepared test cases to validate report results against warehouse as well as source.
Created an Agents and deliver the agents daily based on ETL completion.
Project Summary
Osmose selected Oracle Business Intelligence as their Reporting solution and as part of it, we are implemented financial related reports Data in OBIEE.
Project 6 : AJG – OBIEE iCapture Apr’09 to Apr’10
Customer : Arthur J. Gallagher & Co.
Technologies : OBIEE 10g/11g, Oracle 11g, Informatica, DAC
Role/Responsibilities:
Involved in the collecting the requirements and creating new custom ETL mappings.
Involved in analyzing and designing the data model based on the existing Source system data model.
Created the custom mappings using Informatica and loads data from multiple data sources to build warehouse.
Handled prod ETL Schedules by coordinate with DB server support team.
Provided access to users using data level security.
Validated reports output data against source system data by writing SQL queries.
Created agents and scheduled as per business requirement.
Involved in RPD changes while extending columns from physical layer to presentation layer.
Resolved data issues by debug the ETL mappings with the help of DAC.
Created Reports and Dashboards in OBIEE as per business requirement.
Project Summary
AJG Corporate HR selected Oracle Business Intelligence as their Reporting solution and as part of it, We implemented the iCapture SR Tool related Data in OBIEE.