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
Varanasi06.2007
B.Tech - EEE
Acharya Nagarjuna University
Gunur, A.P05.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
Similar Profiles
Anshul GuptaAnshul Gupta
Delivery Director at Forsys Software India Private LimitedDelivery Director at Forsys Software India Private Limited
Venkata Rama Raju PVenkata Rama Raju P
Software Engineer at Forsys Software India Pvt LtdSoftware Engineer at Forsys Software India Pvt Ltd
GAURI BOKILGAURI BOKIL
Marketing Analyst at Forsys Inc.Marketing Analyst at Forsys Inc.
Nithin SaraNithin Sara
Sr. Product Engineer at TECHMAHINDRA LTDSr. Product Engineer at TECHMAHINDRA LTD
SASIDHAR RAYALASASIDHAR RAYALA
Senior Accounts Executive at Select CarsSenior Accounts Executive at Select Cars