Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I am Ratan Patlolla, a Senior Software Engineer at Oracle India with 15 years of IT experience in ETL and Analytics Cloud development, designing adaptive, resilient and high-performance data warehouses and BI solutions.\n\nI thrive on translating complex business needs into scalable data architectures, with hands-on expertise in Informatica PowerCenter, ODI, OBIEE, DAC, Hadoop, and Oracle Endeca Information Discovery integration with OBIEE.…I am Ratan Patlolla, a Senior Software Engineer at Oracle India with 15 years of IT experience in ETL and Analytics Cloud development, designing adaptive, resilient and high-performance data warehouses and BI solutions.\n\nI thrive on translating complex business needs into scalable data architectures, with hands-on expertise in Informatica PowerCenter, ODI, OBIEE, DAC, Hadoop, and Oracle Endeca Information Discovery integration with OBIEE.

Ratan Patlolla

Developer, Data Scientist, Data Analyst, +3





I am Ratan Patlolla, a Senior Software Engineer at Oracle India with 15 years of IT experience in ETL and Analytics Cloud development, designing adaptive, resilient and high-performance data warehouses and BI solutions.\n\nI thrive on translating complex business needs into scalable data architectures, with hands-on expertise in Informatica PowerCenter, ODI, OBIEE, DAC, Hadoop, and Oracle Endeca Information Discovery integration with OBIEE.…I am Ratan Patlolla, a Senior Software Engineer at Oracle India with 15 years of IT experience in ETL and Analytics Cloud development, designing adaptive, resilient and high-performance data warehouses and BI solutions.\n\nI thrive on translating complex business needs into scalable data architectures, with hands-on expertise in Informatica PowerCenter, ODI, OBIEE, DAC, Hadoop, and Oracle Endeca Information Discovery integration with OBIEE.

Available to hire

I am Ratan Patlolla, a Senior Software Engineer at Oracle India with 15 years of IT experience in ETL and Analytics Cloud development, designing adaptive, resilient and high-performance data warehouses and BI solutions.\n\nI thrive on translating complex business needs into scalable data architectures, with hands-on expertise in Informatica PowerCenter, ODI, OBIEE, DAC, Hadoop, and Oracle Endeca Information Discovery integration with OBIEE.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Intermediate

Language

English

Fluent

Work Experience

Senior Software Engineer at Oracle India Pvt, Ltd.

July 1, 2016 - Present

CEA is a Data warehouse project delivering MIS reports for the acquired Merchants of Citi Bank. Responsibilities include interacting with Users and Business Analysts, defining requirements, customizing Oracle Analytics functionality, creating Dimensional Hierarchies and security provisioning, building data flows, datasets and replication from diverse sources, and delivering visualizations and reports. Involvement across Finance Cloud Analytics and Retail Cloud Analytics, migration of on-prem OBIEE to Analytics Cloud, and leading data integration activities using Informatica, Teradata, Oracle DB, and DAC scheduling.

Senior Informatica/OBIEE Developer at eVerge Group, Inc.

April 1, 2015 - June 30, 2016

Ascension Health project automating ETL for Value Creation Office Data into MIC EDW and Hyperion Financial Management. Loaded data from flat files, coordinated with OMCS for infrastructure issues, monitored full/incremental ETL loads in DAC, customized SDE/SIL mappings, resolved OBIEE reporting issues, and delivered HR analytics requirements and aggregates.

Senior OBIEE Developer at eVerge Group, Inc.

March 1, 2014 - August 31, 2014

FADV Sales & Service Analytics: gathered reporting requirements, implemented ODI 11g and OBIEE 11g/12c, BIAPPS 7.9.6.4, integrated Siebel sources, monitored ETL with BIACM scheduler, performed performance tuning, extended data lineage, and delivered interactive reports and dashboards.

Senior BI Consultant at eVerge Group, Inc.

October 1, 2012 - March 31, 2015

KEYSTONE (Phase 2): Integrated Sales, Service, CRM Marketing and loyalty analytics within BI Apps/DWH, decommissioned SQL Server to Oracle, converted PL/SQL packages to Informatica mappings, implemented BI Apps and partitioning for performance improvements, and delivered comprehensive documentation.

Senior BI Consultant at eVerge Group, Inc.

July 1, 2012 - October 31, 2013

5MAF: Medical marketing analytics project; imported Siebel sources, monitored DAC ETL jobs, handled user provisioning and infrastructure issues, and customized SDE/SIL mappings across dev/QA/prod environments.

Senior Consultant at eVerge Group, Inc.

December 1, 2011 - June 30, 2012

6GCCS: Visa Global Customer Care Services project; developed Subject Area, Table Groups and DAC mappings; created custom SDE/SIL mappings and DAC configurations; managed Informatica repository and scheduling tasks.

IT Analyst at TCS Bangalore

August 1, 2010 - August 31, 2011

7Sourcing WorkBench: Dragon2 project for GE HealthCare; loaded SSP data to Teradata ODS, modified PRODERP/GLPROD structures, created BTQs/Jobs, and ensured daily/monthly data loads with OBIEE reporting integration.

ETL Developer/Production Support Executive at TCS Bangalore

February 1, 2010 - July 31, 2010

8Ameriprise Financials (Infrastructure Production Support): Production monitoring and scheduling across 40-55 applications using Control-M; issue resolution, environment maintenance, and data loads from source to DWH.