VENKATARAMANA KOKKULA

Project: 1Click Tagging - Cloud Based Document Classification Solution

The “1-Click-Tagging" project is a Google Workspace add-on for Airbus users to manage document metadata and improve data security. It applies Google Drive labels (Data Classifications), manages Export Control Classifications, supports Google Drive, Docs, Sheets, and Slides, embeds visual markings, saves favorite label templates, and enables bulk tagging. The third version is built on Google Cloud Platform (GCP) with a Node.js backend on Cloud Run and a Card Service UI. Firestore stores the hierarchical classification dictionary, while Cloud SQL (PostgreSQL) manages user preferences and audit logs.

• Architectural Design and Strategy: End-to-End Solution Design: Architected migration of 1-Click-Tagging Google Workspace add-on to Google Cloud Platform (GCP) (Version 3), enhancing application performance and scalability.
• Integration Framework: Designed the integration framework connecting the add-on with core Google Workspace services, establishing seamless interactions with the Google Drive Labels API for metadata application and Google Docs, Sheets, and Slides APIs for automated visual stamping.
• Data Management Architecture: Designed a dual-database storage strategy, utilizing Firestore (NoSQL) for direct JSON compatibility with the hierarchical classification dictionary, and Cloud SQL (PostgreSQL) to ensure write integrity for user preferences, division tracking, and historical action logs.
• Deployment, Security, and Delivery: CI/CD Pipeline Implementation: Automated DevOps pipeline using Jenkins on AWS architecture, configuring agent machines with Terraform and Google Cloud CLI (gcloud) to streamline container image builds and GCP resource deployments.
• Cross-Cloud Authentication: Established secure connectivity between AWS Jenkins environment and GCP using Workload Identity Federation (WIF), facilitating deployments through dedicated service accounts and eliminating reliance on long-lived credentials.
• Security and Compliance: Ensured infrastructure adherence to Airbus Public Cloud Platform (PCP) guidelines (e.g., using 'internal-and-cloud-load-balancing' for Cloud Run) and managed application security through OAuth 2.0 scopes, service accounts, and precise Firestore/Cloud SQL access controls.

Project: Inbound Damages Data Enablement (Mondelez International Inc.)

This project focused on modernizing the capture of product damage data, replacing cumbersome SharePoint forms with a scalable solution using PowerApps Dataverse. I provided the complete architectural design for the data flow, designing the integration framework to seamlessly connect the Power Platform Dataverse system with Talend and GCP environments. The architecture specified the flow for extracting data from Dataverse DB using Talend Components, staging it in the GCP landing zone, and creating Raw, Harmonization, and Product layers in BigQuery for Power BI visualization.

• Developed comprehensive architectural design for project.
• End-to-End Solution Design: Provided the architectural design for the Inbound damage data flow, replacing legacy SharePoint forms with PowerApps Dataverse.
• Integration Framework: Designed the data integration framework to seamlessly connect the Power Platform Dataverse system with the Talend and GCP environments.
• Data Ingestion Pipeline: Architected the flow for extracting data from Dataverse DB using Talend Components, staging in the GCP landing zone, creating Raw, Harmonization, and Product layers for Power BI visualization.
• Managed project delivery phases, coordinating efforts across teams to align with project goals.
• Created Project Timelines for all phases (Build, System Testing, UAT, Prod Migration, Hypercare) by splitting activities into Agile sprints.
• Estimated technical efforts based on Macro Capex business requirements, facilitating resource allocation and planning.
• Led the migration of Talend ETL interfaces and RCTL entries to production using CI/CD pipelines.
• Implemented optimization techniques before the UAT phase to ensure pipeline performance.

Project: MARCO CAPEX (Mondelez International Inc.)

MARCO CAPEX aimed to replace manual Excel-based solutions with a centralized platform for visualizing Capital Expenditure (Capex) data across regions for critical decision-making. I designed the Solution Architecture for data ingestion, establishing connectivity with the CAPEX DB hosted on the Microsoft Project Online platform using REST API calls via the Talend Framework. The data extraction process utilized Postman to validate API connections and defined the transformation architecture for converting data into CSV files, placing them in the GCP landing zone, and ultimately establishing the Raw, Harmonization, and Product layers for Tableau reporting. I authored the Technical Design Documents in collaboration with Data Modelers, managed technical estimations and project timelines, and ensured smooth product migration of Talend ETL interfaces.

• Developed solution architecture for data flow management to streamline data processes and enhance integration efficiency.
• Data Transformation Architecture: Designed the flow for converting extracted data (via API/Talend) into CSV files, placing them in the GCP landing zone, and then establishing the Raw, Harmonization, and Product layers for Tableau reporting.
• Technical Design Documentation: Authored Technical Design Documents in collaboration with Data Modelers to formalize the data architecture.
• Facilitated stakeholder engagement sessions to gather and clarify business requirements, driving alignment with project goals.
• Engaged in extensive working sessions with the customer to understand Marco Capex business requirements, which supported financial performance reviews and Capex decision-making.
• Provided technical estimations for project efforts and created project timelines aligned with Agile sprints, ensuring accurate resource allocation and timely delivery.
• Managed the resolution and fixing of UAT defects, ensuring smooth product migration of Talend ETL interfaces to production.

Project: CSRP FATS EMST Edge Remediation (SCE)

• Served as the System Design Authority, designing the solution architecture and ETL framework for migrating data between legacy FATS/EMST applications and SAP IS-U.
• Designed and developed Talend Real-Time Big Data ETL interfaces for processing and transforming SAP IS-U data into the Hadoop data lake.
• Defined scalable and reliable integration architecture through data lineage, impact analysis, and solution evaluations.
• Led Proof of Concepts (POCs) and provided architectural guidance, enhancing development teams' understanding through authored functional/technical design documents.
• Mentored testing teams and reviewed solution designs, ensuring successful implementation via unit testing and streamlined production deployment.

Project: CSRP (Southern California Edison)

• Collaborated with business stakeholders to define architecture and evaluate solution options, enhancing Agile delivery processes.
• Designed and implemented Talend-based ETL architecture, facilitating seamless migration of data from legacy CSS to SAP IS-U.
• Built scalable data pipelines using Talend, Hive, and Impala for Source, Stage, and Core HDFS layers, optimizing data processing workflows.
• Implemented Change Data Capture (CDC) using Delta Logic and Hive Insert Overwrite for incremental processing.
• Designed Hive data models and enforced data quality and compliance checks.

Project: GRIDMOD - Weather Data Mart (SCE)

• Designed data ingestion architecture for centralized Weather Data Mart on Cloudera Hadoop, enhancing data accessibility and analysis.
• Developed Talend ETL pipelines with Hive, Impala, Oracle, and R for seamless weather data integration, improving data flow efficiency.
• Optimized Hive queries and leveraged Hive on Spark/MapReduce to improve ETL performance.
• Built audit and data quality frameworks, ensuring reliable and traceable data processing for enhanced decision-making.
• Integrated Redwood Scheduler with Talend Administration Console for automated workflow execution.

Project: Enterprise Search & Analytics (BMG)

• Designed big data analytics platform with Hadoop, Elasticsearch, and Kibana to enhance business reporting capabilities.
• Developed Sqoop and Hive-based data ingestion and transformation pipelines to streamline data processing.
• Built Elasticsearch indices and Kibana dashboards for high-performance analytics and visualization.
• Applied data modeling techniques and optimized database queries to improve reporting performance.
• Contributed to deployment automation and performance tuning to optimize platform efficiency.

Project: InteractEdge Conversion Services (Payless)

• Developed Hive and MapReduce-based data processing pipelines, enabling campaign analytics and P&L reporting on Hadoop.
• Automated ETL workflows with UNIX shell scripting, Hive scripts, and CRON scheduling, streamlining data processing.
• Conducted Root Cause Analysis (RCA), optimized critical data processing interfaces, and enhanced performance through tuning.
• Supported Hadoop cluster scalability and collaborated with stakeholders to deliver data engineering solutions.

Project: e-Merchandising (Retail Corporation, USA)

• Led development team and coordinated with client stakeholders to enhance applications and provide production support.
• Managed project delivery for Merchandising, Promotions, and Event Management modules, ensuring alignment with client objectives.

Project: Regulatory Compliance (British Automotive Manufacturer)

• Developed enterprise Java web application using ICEfaces, Web Services (WSDL), and WebSpace Server to support regulatory compliance solution.

Project: Municipality Information Tracking System (MITS) (Municipality of the Philippines)

• As a core team member on this intranet application, I focused on application development, implementing the DAO layer and writing queries using the Hibernate Framework, and developing Action Form/Action Class components using the Struts framework.
• As a Team member, I implemented the DAO layer and wrote queries using the Hibernate Framework.
• Developed JSPs and implemented Action Form/Action Class components using Struts for this intranet application.