Venugopal Challa Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

--> Architected & implemented robust data engineering pipelines tailored for Finance operations, eliminating the reliance on Excel as a storage solution.--> Employed Python scripting to automate intricate calculations and finance logic, significantly boosting accuracy & operational efficiency across the organization.--> Orchestrated the extraction of crucial accounting, revenue & headcount data from disparate systems, meticulously transforming and loading it into Snowflake, a leading cloud data warehouse platform.Integrated Power BI seamlessly with Snowflake to harness its capabilities in generating dynamic reports & interactive dashboards, empowering stakeholders with real-time insights into financial performance & trends.--> Leveraged advanced DAX (Data Analysis Expressions) and Power Query Logic within Power BI to craft visually captivating finance dashboards, offering actionable insights for strategic decision-making.Led the development of an intuitive user interface (UI) catering to the needs of the Financial Planning and Analysis team, enabling seamless CRUD (Create, Read, Update, Delete) operations on financial and accounting data stored in Snowflake.--> Developed PowerBI applications containing multiple dashboards & implemented Row-Level Security (RLS) to tailor data access for different users. Published these apps to ELT members of the company, enabling them to visualize the company's financials. --> Employed React JS & nextjs to engineer the CRUD application, with plans underway to deploy it as a microservice on a Kubernetes cluster, ensuring scalability and resilience.

Bangalore Urban, Karnataka, India

--> Spearheaded the development of a robust data pipeline tailored for healthcare data ingestion into the Snowflake data warehouse. The pipeline, powered by Python scripting atop AWS infrastructure, efficiently managed the entire Extract, Transform, Load (ETL) process, ensuring seamless data integration.--> Implemented a comprehensive version control system by consolidating the codebase within GitLab, facilitating streamlined management & seamless collaboration among team members, thus enhancing productivity and code quality.--> Automated code deployment across diverse environments utilizing GitLab & Octopus Deploy as integral components of our Continuous Integration & Continuous Deployment (CI/CD) strategy, significantly accelerating the deployment process and ensuring consistency.--> Containerized the Python codebase & stored it in Amazon Web Services' Elastic Container Registry (ECR), ensuring consistent & efficient deployment across various environments, thereby enhancing scalability & reliability.--> Orchestrated data pipelines using Apache Airflow's Kubernetes Pod Operator, effectively managing Kubernetes clusters within AWS Elastic Kubernetes Service (EKS), thus optimizing resource utilization and operational efficiency.

Chennai, Tamil Nadu, India

--> Conducted thorough exploration of business requirements and meticulously gathered data from diverse business units, including Global Vehicle Recall, Vehicle Issue Management System, and Supplier Database, ensuring comprehensive insights into operational dynamics.--> Spearheaded the development of a dynamic Warranty Management Dashboard utilizing QlikView, with data processing orchestrated seamlessly through Alteryx and Advanced Excel, enabling streamlined data visualization and actionable insights generation.--> Engineered a sophisticated QlikView Dashboard tailored for in-depth analysis of vehicle user behavior, focusing on critical metrics such as daily habitual distance traveled and Engine idle state calculation, leveraging Connected Vehicle data. The ETL process, parallelization, and scalability of data extraction were meticulously designed and executed within Alteryx Core Designer, ensuring optimal performance and efficiency.

Chennai Area, India

Chennai, Tamil Nadu, India

**Project 1:**Project description: Build a system to process the material requests in manufacturing industryProcess : -- Replicating the request data from SAP Hana to the local Redshift database in AWS and scheduling the process on daily bases.-- Preprocessing the request like Regex, stop word removal, bag of words using the TFIDF techniques using the NLTK, text blob and sklearn.-- Using N-grams to cluster the words and find the Cosine Similarity Scores between the different requests.-- Passing the processed data to Spotfire for visualization that presented to client.**Project 2: **Project description: To Build a Predictive Model and find out the sales of each product at a particular Retail StoreProcess:-- Performed extensive analysis in order to understand the properties of products and stores which play a key role in increasing sales through graphical representation.-- Explore and visualize the data, build simple, base models for benchmark.-- Conceptualized feature engineering and leveraging the business insights from Case Review like (Count of Outlet Identifiers, Count of Item Identifiers and Outlet Years etc.) and setup a robust/thorough validation framework consistent with the evaluation metrics.-- Performed methodical experiments for the selection of optimum Tree based parameters.-- Used various ML Models like Linear, Decision Tree but Random Forest outperforms other models with its lowest RMSE value.

Bachelor Of Technology (B.Tech.), Electronics And Communication Engineering

Activities and Societies: Bachelore of Technology(B.Tech)I Graduated here in Elecronics & communication Stream with aggregate of 75.4%

S.S.C, S.S.C

I done my S.S.C here with aggregate of 88.9%