Sowjanya P Email and Phone Number

• Proficient in leveraging python for predictive modeling along with Google Cloud to extract actionable insights from Firestore.• Leveraged pub/sub for asynchronous messaging and managed Apache Kafka on GCP for scalable and fault-tolerant streaming.• Employed Big Query for high-performance data warehousing and analytics, handling massive datasets efficiently by 30%.• Created custom SQL scripts for complex analytical requirements and designed streaming dashboards for intricate insights.• Worked extensively in writing complex ad-hoc SQL queries on-demand, utilizing joins, sub-queries, CTEs, date and analytical functions. Enhanced data retrieval speed by 10% through index and partition validation and optimization during SQL tuning.• Utilized Alteryx server and scheduler to automate repetitive data preparation tasks and workflows to improve efficiency by 40%.• Proposed analytics solutions using Power BI, employing clustering algorithms, regression models for data-driven decision-making.• Streamlined deployment processes by integrating Git for version control with Jenkins in a CI/CD pipeline, resulting in 30% reduction in deployment time and 35% decrease in manual errors.

Executed end-to-end data analytics lifecycle, employing Python libraries (pandas, NumPy, Scikit-learn,Matplotlib)for data mining, cleaning, collection, model development, validation, and visualization.Improved data processing speed by 40% through the strategic implementation of Pyspark on large streamingdatasets, showcasing a commitment to optimizing performance.Implemented advanced transformation logic using Big Data Technologies (Hadoop, MapReduce Frameworks,HBase, Hive), including table partitioning in Hive and optimizing data storage with ORC file formats in Hadoop.Automated ETL tasks, reducing manual intervention by 30% and enhancing operational efficiency. UtilizedAirflow scheduling tools for timely execution.Applied EMR for large-scale data processing and analysis, leveraging frameworks like Apache Spark and ApacheHadoop to extract meaningful insights.Developed optimized SQL Queries and PLSQL scripts, resulting in a significant 35% improvement in data retrievalspeed. Designed and implemented data visualization dashboards and sheets using Tableau Desktop for clear andaccessible insights.