Raviteja Kakarla

Team: Product Analytics. Tools: Google Cloud Platform, Kafka, Python, Lua Scripting, Exasol, SQL, PL/SQL. Project 1: GCP Migration - Designing pipelines for Product Analytics DW in GCP using Dataflow, Dataform & Big Query. Orchestration of pipelines Cloud Composer (Airflow). Designing dataflow pipelines for streaming data(Kafka). Migrating self-service data models from Legacy DB to Big Query. Lead team for migration of Product analytics data to GCP. Project 2: Equinix Metal DW - Integration of Metal data from Source DB to Big Query using Dataflow. Data Modeling Metal DW by analyzing source data. Created reusable objects and python scripts for integration of Rest APIs to Google Cloud Platform. Developed Metal Revenue, Contracts, Usages Self Service Data Models. Project 3: Interconnection Opportunity Matrix - Creating Automated PPT with products for given customers using Python Script. Powerpoint has been integrated with customer usage of products and predictions generated through ML models for cross-selling of products. Integrated this solution to Tableau to enable access for sales reps. Saved 1000+ work hours by automating creation of power points. Project 4: Snapshot Framework - Developed framework to capture time sensitive Snapshots like weekly, Monthly, Daily..etc. Orchestration Snapshot framework using cloud composer. Performance optimization for data models build on snapshot Entities. Developed curated metrics for snapshots which are using in 100+ Dashboards.

Project Name: Customer Information Data Warehouse (CustDW). Tools: Informatica Powercenter 10.x, IDQ, Unix, Oracle 11g/12C. Customer Information Data Warehouse (CustDW) is project to pull account information and products associate wholesale customers across different SORs. This project is key for performing customer experience analytics and Cross selling of products in wholesale banking. Roles & Responsibilities: Ensuring high availability of data for reporting and analytic needs of LOB. Design and development of rule-based architecture form different SORs to fetch customer account architecture. Need to have strong functional know understand the business needs. End to End development-testing life cycle support.

Customer: Ahold. Project Name: EDW AHOLD. Tools: UNIX, Oracle 11g, Informatica, IDQ. An Enterprise Data Warehouse (EDW) is a key factor for Ahold USA to promote its distinguishing business vision and to achieve its strategic business goals. Properly architected and implemented EDW would address immediate business and operational issues and further enable many of the functional areas within the company by providing increased flexibility and independence in accessing complete, consistent, and accurate enterprise information for all business users. Roles & Responsibilities: Ensure Data availability on outbound feeds as per the SLAs. Issues and incident handling, resolving data anomalies and preserving data integrity within the scope of data loads. Handling Change Requests (CR) for minor enhancements. Closely working with application team and System DBAs, Operating System Administrators (OSA) and Change Team.