Prithvi R Email & Phone Number

United States

United States

Paris, France, Fr

Oracle to Postgres Data Migration:o Working on the migration of database objects from Oracle to PostgreSQL, ensuring data integrity and optimal performance.o Develop and execute comprehensive migration plans, including schema conversion, data transformation, and validation processes.o Utilize the AWS Schema Conversion Tool (SCT) to convert Oracle database schemas to PostgreSQL-compatible formats, addressing any compatibility issues.o Implement data migration strategies using AWS Database Migration Service (DMS) to efficiently transfer data from Oracle to PostgreSQL, ensuring minimal downtime and data loss.o Perform historical data loading to migrate legacy data from Oracle databases to PostgreSQL databases, ensuring the completeness and accuracy of historical data.o Develop scripts and automation processes to handle large volumes of data, leveraging Python and SQL to streamline data migration tasks and ensure data consistency.o Developed Triggers and Stored procedures to capture critical migration logs to ensure data atomicity.o Manage and maintain both Oracle and PostgreSQL databases, including installation, configuration, and performance tuning to ensure optimal database performance and reliability.o Monitor database performance using tools like AWS CloudWatch and pgAdmin, optimizing queries and indexing strategies to enhance data retrieval speeds.o Perform regular backups, implement recovery procedures, and plan disaster recovery strategies for both Oracle and PostgreSQL databases to ensure data security and availability.o Leverage AWS Redshift for data warehousing solutions, enabling efficient data analysis, reporting, and business intelligence activities.

Stamford, Connecticut, Us

o Developed Python-Based Data Solutions: Designed and implemented efficient data solutions using Python, focusing on scalable and reliable architectures for complex data processing.o Advanced Data Manipulation with Pandas performed data cleaning, transformation, and aggregation using Pandas, supporting in-depth business analytics.o Efficient Database Operations via SQLAlchemy utilized SQLAlchemy for seamless database connectivity and manipulation, optimizing database operations within Python applications.o Built Custom Data Frameworks contributed to the design of custom frameworks that enhanced data processing speed, reliability, and maintainability.o Data Visualization with Tableau created insightful visualizations in Tableau, effectively communicating complex data insights to non-technical stakeholders.o Collaborated on Data Requirements: Worked closely with cross-functional teams to understand data requirements and deliver tailored data solutions, improving decision-making accuracy.o Optimized Data Workflows: Focused on refining data processing tasks, significantly improving efficiency and turnaround times for analysis projects.o Integrated Latest Technologies stayed current with Python, data engineering, and visualization trends, incorporating the latest tools and techniques to enhance solutions.o Problem-Solving Expertise addressed challenging data scenarios with innovative solutions, ensuring smooth, reliable data flows across projects.o Distributed Computing with Apache Spark familiar with leveraging Apache Spark to support high-performance distributed data processing for large-scale datasets.o Optimized ETL Pipelines streamlined ETL processes for speed, scalability, and reliability, ensuring seamless data integration across various systems.o Managed Data Projects oversaw multiple data-centric projects, consistently delivering high-quality outcomes on time, often exceeding expectations.

Dallas, Tx, Us

o Automated the data transformation process from Teradata to Snowflake on Azure Cloud as part of Project ColdFusion, reducing manual effort and increasing efficiency.o Implemented automated migration applications to streamline the transfer of data, collaborated with frontend developers to ensure seamless integration, and utilized shell scripting to automate backend data processing tasks.o Validated Talend data pipelines for Snowflake to ensure data accuracy and consistency.o Created reporting views and executed queries in Snowflake for data analysis and visualization.o Supported product teams by troubleshooting data-related issues and optimizing data pipelines.o Utilized Power BI, Tableau, Mode Analytics, and Looker for data reporting and visualization.o Automated self-service tools for advanced targeting and presented insights using Power BI Pro.o Managed Snowflake databases built Snowpipe for continuous data loading and handled ETL pipelines for various data sources.

Irving, Texas, Us

o Worked on Snowflake data warehousing, designing, and implementing data warehouses, managing data pipelines, and optimizing performance.o Developed and maintained backend systems using Snowflake, designing database schemas, writing SQL scripts, and building data pipelines.o Integrated Snowflake with other systems and technologies, such as ETL tools, BI platforms, and analytics tools, and built data pipelines that extract, transform, and load data into Snowflake.o Worked on AWS Elastic load balancing for deploying applications in high availability.o Experience in working on cloud EC2, S3, RDS, Load Balancer, Auto Scaling with AWS command line interface and AWS python SDK.o Managed AWS infrastructure as code using cloud formation.o Worked on policy enforcement and automation for S3. o Integration of ServiceNow with AWS for incident management using service management connector.o Customized the connector to perform customer specific requirements. o Implemented DataSync service to migrate terabytes of data to S3.o Worked on automation, logging, and monitoring of data transfer services.