Rahul Shengavula Email & Phone Number

I have a strong background in designing, developing, and maintaining functional reports based on user requirements, utilizing tools like Python and SQL. My experience includes optimizing SQL queries within Python scripts, implementing error handling in ETL processes, and creating validation reports in Databricks. I have also developed solutions for streamlining data quality checks and managed requests from analysts regarding the warehouse environment.My work involves close collaboration… Show more I have a strong background in designing, developing, and maintaining functional reports based on user requirements, utilizing tools like Python and SQL. My experience includes optimizing SQL queries within Python scripts, implementing error handling in ETL processes, and creating validation reports in Databricks. I have also developed solutions for streamlining data quality checks and managed requests from analysts regarding the warehouse environment.My work involves close collaboration with business users, ETL developers, project managers, and QA teams to ensure seamless data integration and migration processes. I have successfully migrated client data warehouse architecture to Azure cloud, monitored end-to-end integration using Azure Monitor, and implemented Databricks clusters. Additionally, I have provided ad-hoc SQL query support to end-users and stakeholders, enhancing data-driven decision-making processes.I am proficient in a variety of data tools and platforms, including Tableau, Power BI, Snowflake, Hadoop, QlikView, and Erwin Data Modeler. My expertise extends to developing analytical products, managing Tableau Server, designing Hadoop HDFS storage configurations, and implementing machine learning models in Jupyter Notebooks. I have also conducted extensive data analysis and reporting using SAP, Google Analytics, and RapidMiner, ensuring accuracy and consistency across datasets. Show less

In my role, I consistently engaged with client subject matter experts to gather functional business requirements and participated in the migration from Teradata Data Warehouse to AWS S3-based data lakes. I was responsible for extracting data from sources like S3 buckets and OneLake, loading it into Snowflake for various uses, including validation, manipulation, reporting, and dashboarding. My tasks also involved performing data analytics, transformation, quality checks, and governance using SQL… Show more In my role, I consistently engaged with client subject matter experts to gather functional business requirements and participated in the migration from Teradata Data Warehouse to AWS S3-based data lakes. I was responsible for extracting data from sources like S3 buckets and OneLake, loading it into Snowflake for various uses, including validation, manipulation, reporting, and dashboarding. My tasks also involved performing data analytics, transformation, quality checks, and governance using SQL and Python.I created jobs using Python, PySpark, and Snowflake for data extraction, cleaning, and analysis, and wrote complex SQL queries to support data profiling and analysis across systems like Microsoft SQL Server and Oracle. Utilizing Informatica Workflow Manager, I scheduled and managed data batches and sessions. I also implemented data ingestion pipelines with Apache Flume, developed MapReduce jobs, and used Apache Spark for processing both structured and unstructured data.Additionally, I collaborated with data architects and business stakeholders to define ETL requirements and integration strategies, optimized Power BI reports, and performed data mapping and transformation using Erwin. My work included developing data validation processes in SAP, creating custom reports in Google Analytics, and documenting machine learning workflows in Jupyter Notebooks. I also worked closely with cross-functional teams, ensuring accurate project tracking and management in JIRA. Show less

At IIFL Samasta Finance Limited, I developed reports using Business Objects Web Intelligence to meet Ad-hoc reporting needs and interacted with business users to gather requirements. I conducted performance tuning and optimization of Python code for large-scale data processing tasks and integrated Apache Hadoop with Azure Blob Storage for hybrid cloud data processing.I managed database connections, SQL joins, and hierarchies, and performed financial modeling and forecasting in Excel. My… Show more At IIFL Samasta Finance Limited, I developed reports using Business Objects Web Intelligence to meet Ad-hoc reporting needs and interacted with business users to gather requirements. I conducted performance tuning and optimization of Python code for large-scale data processing tasks and integrated Apache Hadoop with Azure Blob Storage for hybrid cloud data processing.I managed database connections, SQL joins, and hierarchies, and performed financial modeling and forecasting in Excel. My role also included utilizing SAS for statistical analysis, conducting data preprocessing in Jupyter Notebooks, and providing training on Alteryx best practices. Additionally, I performed data cleaning and transformation in Excel to prepare datasets for analysis.I implemented Tableau server configurations to manage access control, integrated Google Analytics with other tools for enhanced data analysis, and supported team collaboration with document features in Word. My environment included Python, Hadoop, Azure, SQL, Excel, SAS, Jupyter Notebooks, Alteryx, Tableau, and Google Analytics. Show less

At CITRIX, I gathered, analyzed, and documented business and functional requirements for Business Objects Universes and Reports. I managed AWS storage using S3, created EC2 instances to run automated Python scripts, and wrote SQL queries on data staging and warehouse tables for validation. I also participated in the installation and configuration of Tableau in both Standalone and Distributed environments.I was responsible for daily communications regarding project status to management… Show more At CITRIX, I gathered, analyzed, and documented business and functional requirements for Business Objects Universes and Reports. I managed AWS storage using S3, created EC2 instances to run automated Python scripts, and wrote SQL queries on data staging and warehouse tables for validation. I also participated in the installation and configuration of Tableau in both Standalone and Distributed environments.I was responsible for daily communications regarding project status to management and internal teams. Additionally, I implemented JIRA plugins to enhance project management capabilities and developed automated Word macros to streamline repetitive tasks. I integrated Excel with other data sources and developed SAS programs to analyze and manipulate large datasets for business reporting.This role provided me with extensive experience in managing AWS environments, data validation, and enhancing project management and analytical capabilities using tools such as Python, SQL, Tableau, JIRA, Word, Excel, and SAS Show less