Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Balakrishna Rangisetti

Hyderabad

Summary

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
  • Environment: OBIEE 11.1.1.5, Informatica 9.1, Oracle 9i

Oracle BI/ODI Developer

Oracle
Hyderabad
07.2010 - 10.2011
  • 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

Timeline

Data Warehousing and Data Analytics developer

Forsys India Inc
07.2018 - Current

DW/BI Developer

Igloo Products Corp.
07.2018 - Current

Lead consultant

Deloitte Advisory
07.2017 - 05.2018

OBIEE / Developer

General Organization for Social Insurance
07.2017 - 05.2018

OBIEE /Informatica Developer

Abu Dhabi Food Control Authority
08.2016 - 06.2017

Lead Application Developer

Fujitsu Consulting India Ltd
06.2016 - 06.2017

Technical Lead, OBIEE/Informatica Developer

GlaxoSmith Kline
10.2013 - 02.2016

Technical Lead, OBIEE/Informatica Developer

Rheem
11.2012 - 03.2013

OBIEE Developer, Onsite coordinator

Scottish Water
11.2011 - 10.2012

Oracle BI/ODI Developer

Oracle
07.2010 - 10.2011

Technical Lead

Wipro Technologies
05.2010 - 03.2016

Oracle BI Developer

Wal-Mart
09.2009 - 05.2010

Oracle BI Developer

Merck Serono
12.2008 - 08.2009

Oracle BI Developer

Pfizer
11.2007 - 12.2008

Technical Analyst

Cognizant Technology Solutions
08.2007 - 05.2010

M.Tech - Power systems

IT-BHU

B.Tech - EEE

Acharya Nagarjuna University
Balakrishna Rangisetti