Seasoned Data Warehousing and Analytics professional with a proven track record at Forsys India Inc. Expert in leveraging Informatica PowerCenter and SQL/PL SQL programming to drive business insights and operational efficiency. Demonstrates strong analytical skills and a collaborative approach, significantly enhancing data-driven decision-making processes.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Data Warehousing and Data Analytics developer
Forsys India Inc
07.2018 - Current
DW/BI Developer
Igloo Products Corp.
Hyderabad
07.2018 - Current
Company Overview: Igloo Products Corp
Is an American manufacturer of ice chests, drink containers and supporting accessories
Igloo bi analytics provides igloo business users the ability to analyse sales, orders, manufacturing processes and forecast information
Datawarehouse sources data form Oracle EBS
Liaise with EBS team and Customer in achieving business requirements
Design and Development of data warehousing solution using snowflake, ODI12c
Implementation of migration from OBIEE 11g to OAS 5.5.0
Design and development of incremental data load in ODI
Development of rpd, creation of Logical facts, dimensions, hierarchies, initialization blocks and variables
Implementation of data visualization reports in OAS
Development of reports on Supply chain management, Inventory and finance modules of Oracle E Business suite
Fixing bugs of OBIEE and ODI during system integration testing
Igloo Products Corp
Is an American manufacturer of ice chests, drink containers and supporting accessories
Igloo bi analytics provides igloo business users the ability to analyse sales, orders, manufacturing processes and forecast information
Datawarehouse sources data form Oracle EBS
Environment: OAS 5.5.4, ODI 12c, Oracle DB 11g, Python, Tableau
Lead consultant
Deloitte Advisory
07.2017 - 05.2018
OBIEE / Developer
General Organization for Social Insurance
Hyderabad
07.2017 - 05.2018
Company Overview: The General Organization for Social Insurance is a Saudi Arabian government agency concerned with social insurance in the country
FMS solution provides the alerts to Business on various frauds associated with Social insurance
Liaise with Data modelling team and Customer in achieving business requirements
Build of Sqls to analyze various frauds associated with GOSI Social Insurance
Design and Development of OBIEE reporting solutions
Design and Development of ODI Interfaces to load BI reporting tables
Fixing bugs during system integration testing
The General Organization for Social Insurance is a Saudi Arabian government agency concerned with social insurance in the country
FMS solution provides the alerts to Business on various frauds associated with Social insurance
Environment: OBIEE 12c, Oracle DB 12c, ODI 11G
OBIEE /Informatica Developer
Abu Dhabi Food Control Authority
Abudhabi
08.2016 - 06.2017
Company Overview: Abu Dhabi Food Corporation control authority is Abudhabi state owned regulatory which is authorized to inspect and provide permits for Food manufacturing establishments and food retail organizations in Abu Dhabi
Creation of Informatica mappings and workflows to load dimensions and facts
Design and development of ETL and reporting application
Requirement gap analysis and customization of Informatica Siebel adapter and data warehouse tables to achieve the requirements
Customization of BI Applications Service Analytics and Case Analytics to achieve FIS requirements
Monitoring of data loads for Oracle BI Applications Financials and HR modules
Created sessions for incremental and full load of DB tables
Performance tuning of Informatica sessions
Debugging and fixing of data and run time issues
Interaction with business users and OLTP team to achieve business requirements
Abu Dhabi Food Corporation control authority is Abudhabi state owned regulatory which is authorized to inspect and provide permits for Food manufacturing establishments and food retail organizations in Abu Dhabi
Environment: OBIEE 11g, Informatica 9.5.1, DAC, Oracle DB 12c
Lead Application Developer
Fujitsu Consulting India Ltd
06.2016 - 06.2017
Technical Lead
Wipro Technologies
05.2010 - 03.2016
Technical Lead, OBIEE/Informatica Developer
GlaxoSmith Kline
Hyderabad
10.2013 - 02.2016
Company Overview: GlaxoSmith Kline is one of the World’s largest pharmaceutical companies in the world
Interaction with business analysts and other stakeholders of the project to address business requirements
Analysis of business requirements and preparation of ETL Design to build and load dimensions and facts
Development of preload, SDE, SIL, post load mappings and sessions to load dimensions and facts through Informatica power center
Partitioning of Facts and aggregate tables to improve performance of ETL
Analysis of change requests and design and development of OBIEE rpd and reports
Customization of Oracle BI Applications Service Analytics and HR module to achieve requirements
Development of KPIs in rpd and reports
Creation of reports using Oracle BI Discoverer and BI Publisher
Configuration of usage tracking, write back in OBIEE
Up gradation and patching of OBIEE
Monitoring of Informatica ETL loads and fixing run time issues
Performance tuning of oracle bi reports and Informatica sessions
Implementation and migration of security in OBIEE
Fixing of bugs during system integration testing and user acceptance testing on coordination with SIT team and business user
GlaxoSmith Kline is one of the World’s largest pharmaceutical companies in the world
Environment: OBIEE 11.1.1.7, Informatica 9.6.1, Oracle DB 11g, 12c
Technical Lead, OBIEE/Informatica Developer
Rheem
Hyderabad
11.2012 - 03.2013
Design of upgrade strategy
Up gradation of OBIEE from 10.1.3.4 to 11.1.1.6 using upgrade utility
Fixing of Warnings and errors in RPD and Fixing of web catalog issues after upgradation
Customization of Oracle BI Applications Supply Chain management and Project Analytics modules
OBIEE Security migration
Monitoring of Informatica ETL loads and fixing run time issues
Environment: OBIEE 11.1.1.7.7, Informatica 9.1.1, DAC, Oracle DB 11g
OBIEE Developer, Onsite coordinator
Scottish Water
Glasgow
11.2011 - 10.2012
Company Overview: Scottish Water is a statutory corporation in Scotland that provides water and sewerage services to both domestic and non-domestic customers
Coordination with business analysts in gathering and analyzing the requirements
Design and development of BI Reporting Solution, RPD, Catalog upon OLTP
Security set up in Fusion middleware
Deployment and migration of BI reporting solution
Performance tuning of Oracle BI Reports
Development to Informatica mappings and sessions to load Vacancy reporting data
Preparation of ETL design document
Used various transformations like look up strategy, update transformation, filter, transaction control transformation to ETL data
Scottish Water is a statutory corporation in Scotland that provides water and sewerage services to both domestic and non-domestic customers
Oracle Tax Analytics is an analytic solution to analyze various taxation aspects like Tax, Registration forms processing, Payments distribution and trends, Tax payer Accounting and Revenue Accounting
Oracle Tax Analytics has built through OBIEE 11G as analytic Platforms and ODI for ETL loading
Various OBIEE 11G features like Maps, Scorecards, KPI to analyze Taxation KPI are utilized
More than 200 reports and 150 ODI interfaces has been built
Oracle BI Developer
Wal-Mart
Chennai
09.2009 - 05.2010
Company Overview: Wal-Mart is one of the largest Retail companies in the world
Wal-Mart Central America BI is to provide OBIEE based reporting and analytical capabilities for Wal-Mart Merchandising
The objective of this solution is to analyze the sales, inventory details, shipping costs, Retail Amounts, Markdowns, and Performance of Suppliers of Wal-Mart Merchandising Section
Wal-Mart is one of the largest Retail companies in the world
Technical Analyst
Cognizant Technology Solutions
08.2007 - 05.2010
Oracle BI Developer
Merck Serono
Kolkata
12.2008 - 08.2009
Company Overview: The client is one of the largest pharmaceutical companies in the world
The main objective of this solution is to analyze the sales, product information, and inventory details and also updated information of marketing representatives regarding their call activities and also information of the hospitals
The client is one of the largest pharmaceutical companies in the world
Oracle BI Developer
Pfizer
Kolkata
11.2007 - 12.2008
Company Overview: Pfizer Inc
Is a major research-based pharmaceutical company, which ranks number two in sales
The project was basically to build a Oracle Business intelligence Application, which shows the sales measures of various Products (Medicines) done by the Sales Representatives and compares the sales with corresponding Activities done by Sales Reps
Pfizer Inc
Is a major research-based pharmaceutical company, which ranks number two in sales
Education
M.Tech - Power systems
IT-BHU
Varanasi
06.2007
B.Tech - EEE
Acharya Nagarjuna University
Gunur, A.P
05.2005
Skills
Informatica PowerCenter
OAS 550
ODI
Apache Spark
SQL/PL SQL programming
Python
Oracle BI Applications
Oracle Tax Analytics
Oracle Utility Analytics
Unix/AIX
Windows 2000/XP/Server 2003
Oracle 9i/10g
11g
12c
19c
Teradata V2R5
Snowflake
Tableau
Certification
Oracle Business Intelligence foundation certified, Oracle Business Intelligence (11g) implementation specialist
Informatica University certified, Informatica Power Center10 implementation specialist