Hi, I'm Rosy Pandey

Data Engineer & Developer

Transforming data into insights at Cedar Gate Technologies. Passionate about Python, AWS, Snowflake, and building scalable data solutions.

Get In Touch
Rosy Pandey - Data Engineer

About Me

A passionate data engineer with a journey from web development to data engineering, constantly learning and growing in the ever-evolving tech landscape.

My Journey

I began my career as a WordPress Backend Developer at Codewing Solutions, where I honed my skills in PHP, MySQL, and web development. This foundation gave me a solid understanding of data structures and backend systems.

My passion for data and analytics led me to transition into data engineering, where I now work at Cedar Gate Technologies. I specialize in building robust data pipelines, ETL processes, and working with cloud technologies like AWS.

I hold a Bachelor's degree in Computer Science & Information Technology (CSIT) from Farwestern University, where I studied everything from database management to cloud computing, laying the groundwork for my current expertise.

Current Role

Data Engineer at Cedar Gate Technologies

Education

Bachelor in CSIT, Farwestern University

Location

Kathmandu, Nepal

Skills & Technologies

A comprehensive toolkit for data engineering, web development, and cloud computing.

Programming Languages
Python90%
SQL85%
JavaScript80%
PHP75%
C++70%
Data & Cloud Technologies
AWS (S3, Redshift, Glue, EMR, Lambda)85%
Snowflake80%
Apache Spark75%
Hadoop70%
Amazon Redshift85%
Databases & Storage
MySQL85%
MongoDB75%
Data Warehouses80%
ETL Processes85%
Tools & Frameworks
Git/GitHub/GitLab85%
VS Code90%
WordPress80%
React75%
Linux System70%

Professional Experience

My journey through data engineering and web development roles.

Data Engineer
Cedar Gate Technologies
Remote
Present

Working with Python for data processing, ETL scripts, and automation. Utilizing data warehouses like Snowflake and Amazon Redshift for large-scale data operations. Implementing batch processing solutions using Apache Spark and Hadoop. Managing AWS services including S3, Redshift, Glue, EMR, and Lambda for comprehensive data pipeline solutions.

PythonSnowflakeAWSApache SparkHadoopETLData Warehousing
WordPress Backend Developer
Codewing Solutions
Kathmandu, Nepal
March 2023 - Present

Develop, optimize, and maintain custom WordPress plugins. Troubleshoot and debug issues while collaborating with cross-functional teams for seamless integrations. Provide technical support and stay updated with industry trends and SEO best practices. Resolve backend issues and bugs, providing prompt support to cross-functional teams.

WordPressPHPMySQLJavaScriptSEOPlugin Development

Featured Projects

A showcase of my work in data engineering, web development, and automation.

Online Food Ordering System

A comprehensive web application built for restaurant management and customer ordering. Features include admin dashboard for menu management, user authentication, order tracking, and payment integration. Built with modern web technologies and responsive design.

Key Features:

  • Admin panel for menu management
  • Customer ordering interface
  • Order tracking system
  • Responsive design
  • User authentication
PHPMySQLHTMLBootstrapAdminLTEJavaScript
Data Pipeline Automation

Automated ETL pipeline for processing large datasets using Python and AWS services. Implemented data validation, transformation, and loading processes with error handling and monitoring capabilities.

Key Features:

  • Automated data ingestion
  • Data quality validation
  • Error handling & monitoring
  • Scalable architecture
  • Real-time processing
PythonAWS LambdaS3RedshiftApache AirflowSQL
WordPress Plugin Development

Custom WordPress plugins for various client requirements including SEO optimization, custom post types, and advanced form handling. Focus on performance, security, and user experience.

Key Features:

  • Custom post types
  • Advanced form handling
  • SEO optimization
  • Performance optimization
  • Security best practices
WordPressPHPJavaScriptMySQLCSSjQuery

Get In Touch

I'm always open to discussing new opportunities, collaborations, or just having a chat about data engineering and technology.

Let's Connect

Whether you're looking for a data engineer, want to collaborate on a project, or just want to say hello, I'd love to hear from you.

Location

Kathmandu, Nepal

LinkedIn

rosy-pandey
Send a Message