Pranathi V Email and Phone Number

I excel in end-to-end data processing and analytics, specializing in real-time data handling with Kafka, Spark, and Scala. My expertise includes designing ETL pipelines, optimizing Snowflake resources, and enhancing RDBMS query performance. Data security is a top priority, with measures like RBAC and encryption. I architect cloud-based data solutions on AWS, using services like S3, Glue, Redshift, and EMR, and streamline ETL workflows with AWS Glue. My skill set covers scaling Snowflake warehouses, Python-based data ingestion, data cleansing, and SQL-driven workflows. Proficiency in Hive, CI/CD orchestration, PostgreSQL data migration, and Tableau visualization further enhances my capabilities.My professional journey demonstrates my proficiency in managing data migration projects involving PostgreSQL databases. I excel in data extraction, transformation, and loading (ETL) tasks, ensuring seamless data transfer. Collaboration is central to my approach, as I work closely with business stakeholders to automate processes and create impactful data storytelling visualizations in Tableau. I also leverage Databricks Delta Lake, enabling the creation of versioned Apache Parquet files with transaction logs and audit history for data reliability and traceability. To optimize data processing, I employ SSIS parallelism and multithreading, resulting in improved performance and reduced ETL durations. Crafting visually appealing dashboards on Power BI to provide valuable insights for data-driven decision-making is another strength.Furthermore, I've honed my skills in working effectively with the Cloudera distribution on AWS EC2 Instances, specializing in Spark for performance optimization. My commitment to efficient code management is evident through my extensive use of version control tools like Stash, Bit-Bucket, and GitHub.

I specialize in designing robust and scalable data-driven solutions using Python. I'm experienced in automating data ingestion, processing, and delivery for both structured and unstructured data, including real-time streaming. Additionally, I excel in building and managing Azure-based big data solutions, utilizing technologies like Azure HDInsight, Azure Data Lake Storage, and Azure Stream Analytics, while ensuring data security and compliance through features like Azure Active Directory integration and encryption.My expertise extends to data warehousing, where I create structures and employ dimensional modeling techniques, including Star and Snowflake schemas. I'm well-versed in NoSQL databases such as Cassandra and MongoDB, enabling me to work with diverse data storage solutions.Furthermore, I develop Spark applications in Scala, facilitating data processing from various sources. I specialize in transforming data within Spark DataFrames for in-memory computation and generating customized Tableau and Data Studio dashboards. My proficiency extends to configuring PostgreSQL security, including user access control and data encryption, and I'm knowledgeable in Microsoft BI technologies like SQL Server, SSIS, SSRS, Azure Data Factory, and Power BI.

I specialize in creating robust, scalable data-driven solutions using Python, covering data ingestion, processing, and delivery for structured, unstructured, and real-time data. Moreover, I excel in constructing and managing Azure-based big data solutions, leveraging technologies like Azure HDInsight, Azure Data Lake Storage, and Azure Stream Analytics. My top priority is ensuring data security and compliance, achieved through Azure Active Directory integration and robust encryption mechanisms.In the realm of data, I am proficient in data warehousing, adept at building structures and applying dimensional modeling techniques like Star and Snowflake schemas. My versatility extends to NoSQL databases, including Cassandra and MongoDB, enabling seamless work with diverse data storage solutions.Furthermore, I specialize in Spark application development using Scala for streamlined data processing from various sources. This expertise includes data transformation within Spark DataFrames, facilitating in-memory computation and the creation of customized Tableau and Data Studio dashboards. Additionally, I possess extensive skills in configuring PostgreSQL security, managing user access control, and implementing strong data encryption. I am also well-versed in Microsoft BI technologies, encompassing SQL Server, SSIS, SSRS, Azure Data Factory, and Power BI.

I conducted comprehensive data analysis using SQL queries to ensure data quality and identify discrepancies in source systems. My role involved integrating data from diverse sources, including on-premises databases, cloud storage, and external APIs, into Azure. This was essential for maintaining data accuracy and consistency in data-driven initiatives.I demonstrated expertise in configuring Snowflake Cloud Data Warehouse environments, tailoring them to meet specific business requirements. This included designing and managing data integration programs in both Hadoop and RDBMS environments, working seamlessly with relational and NoSQL data stores for efficient data access and analysis.I excelled in data visualization and analysis, creating Tableau dashboards with various visualization techniques such as stack bars, bar graphs, scattered plots, and Gantt charts. I also leveraged Python for data cleaning, manipulation, and visualization to extract actionable insights, supporting data-driven decision-making. Using SQL queries, I extracted, preprocessed, and visualized data in Tableau, producing interactive and informative visualizations to gain valuable insights.