Pavan G Email & Phone Number

Dallas, Tx, Us

Denver, Colorado, United States

At Maximus, I led the development of ETL processes in Databricks on Azure, improving data migration to S3 and enhancing data processing efficiency. I utilized PySpark for data cleaning and crafted scalable ETL pipelines, integrating GCP's BigQuery for large-scale data analyses and Google Cloud Pub/Sub for real-time data streaming. Additionally, I optimized data synchronization and updates from Redshift to MongoDB and PLM systems to Snowflake, minimizing system impact. My integration of Informatica IICS and AWS Athena supported complex transformations, enhancing decision-making, while my use of the ELK Stack improved real-time monitoring and visualization of the ETL process.

Dallas, Texas, United States

At CBRE, I successfully integrated Salesforce with GCP, boosting marketing ROI by 15%, and spearheaded ETL processes using Informatica IICS while enhancing data warehousing with Snowflake, achieving a 25% increase in data processing efficiency. I incorporated Databricks, hosted on Azure, for advanced data analytics and utilized Kafka for real-time data streaming, further facilitating data migration from Cosmos DB to MongoDB. In addition, I integrated SAP S/4HANA and BW to streamline our financial and business warehousing solutions, significantly improving data accuracy and availability.To manage and automate these workflows, I implemented Apache Airflow, orchestrated via Astronomer on Azure, optimizing the scheduling and monitoring of our data pipelines. I also developed dynamic, interactive interfaces and backend services using Angular and Node.js, significantly enhancing data interaction and business intelligence capabilities. Additionally, I managed AWS services, automated processes with Autosys, and employed Python with IICS to further optimize data operations and support decision-making, integrating Team Center to enhance product lifecycle data management across platforms.

Indianapolis, Indiana, United States

At Global Atlantic, I developed real-time data processing systems using Spark and Kafka on AWS and contributed to migrating ETL processes to IICS for scalability. I automated data pipelines and improved data quality with Informatica, leveraging PySpark for efficient data analysis. Additionally, I enhanced customer engagement by 20% by integrating Microsoft Customer Insights, which enabled targeted marketing campaigns and advanced analytics, significantly improving data-driven decision-making.

Hyderabad, Telangana, India

At Avon Technologies, I enhanced our data processing and warehousing capabilities by integrating technologies such as Hadoop, Informatica PowerCenter, Kafka, and AWS, including Redshift. My role centered on designing data architectures that supported strategic business decision-making. I spearheaded initiatives to refine ETL processes, advanced our data warehousing using Redshift, and crafted real-time data pipelines employing Kafka and Java.Further, my work involved scripting automation in Unix and developing robust big data applications using Hadoop and Spark, which significantly expanded our analytical capacity. By deploying services on AWS EC2 and Lambda, I ensured our data infrastructure was both scalable and efficient. Additionally, I contributed to data governance, created meaningful visualizations using Tableau, and provided mentorship to team members, thereby aligning our data engineering efforts with the company’s strategic objectives.

Hyderabad, Telangana, India