Karma Sonam Gurung
West Caldwell,NJ
Summary
Proven expertise in database migration and data pipeline development, demonstrated during my tenure at New Jersey Botanical Garden. Leveraged Python and AWS to enhance data processes, showcasing strong analytical skills and a commitment to efficiency. Excelled in collaborative projects, highlighting exceptional teamwork and problem-solving abilities.
Overview
1
1
year of professional experience
Work History
Human Resources Intern
William Paterson University
05.2024 - Current
- Assisted with updating the department’s webpage using dotCMS.
- Supported daily operations, including troubleshooting and administrative tasks.
- Contributed to various HR projects, such as the Employee Value Proposition (EVP) initiative, Pioneer Awards, and employee engagement programs.
- Assisted with database management tasks, focusing on analyzing and optimizing data storage solutions
- Used AWS tools like QuickSight to develop reports.
Database Migration Intern
New Jersey Botanical Garden (NJBG)
06.2024 - Current
- Migrated legacy Microsoft Access databases to AWS DynamoDB, enhancing data storage and retrieval processes
- Developed automated data pipelines using Python scripts and Lambda functions, processing large volumes of membership data
- Applied data validation techniques to improve data quality and consistency during migration
- Supported the development of data visualization dashboards using AWS QuickSight for better decision-making insights
IT Intern
Caldwell University
Caldwell, NJ
09.2023 - 05.2024
- Assisted in network configuration and database management, gaining experience with ETL processes and big data technologies
- Participated in troubleshooting database issues and optimizing performance by tuning SQL queries
- Strengthened understanding of cloud-based data solutions, including AWS infrastructure components
Education
Bachelor of Science - Computer Science, Cognitive Science Honors
William Paterson University
Wayne, NJ05.2026
Skills
- Python
- SQL
- JavaScript
- KornShell
- AWS (S3, DynamoDB, Lambda)
- Hadoop
- Apache Spark
- Tableau
- AWS QuickSight
- SQL/NoSQL databases
- Data Lakes
- Data Warehouses
- ETL
- Data transformation
- Data pipeline development
- HTML
- CSS
- Microsoft 365
- Jira
- Slack
- Git
Leadership Experience
- Participant, Java Developer Bootcamp (2024)
- Active member, Cognitive Psychology course projects (Psy 3750)
- Volunteer, Technology Tutoring Programs for local community members
Coursework
- Data Structures & Algorithms
- Database Management Systems
- Networking Essentials
- Advanced Java Programming
- Cognitive Science: Memory and Processing
Projects
End-to-End Data Analytics and Reporting Solution
- Developed a full data management and reporting system to enhance business intelligence.
- Designed and implemented a scalable, normalized data schema.
- Built automated ETL pipelines using Python and Apache Spark for high-quality data processing.
- Created a data warehouse with AWS Redshift and DynamoDB, optimizing query performance.
- Developed interactive dashboards with AWS QuickSight and Tableau for insightful analytics.
- Collaborated with teams and provided training on dashboard usage.
Cloud-Based Data Migration and Analysis Platform
- Led migration from Microsoft Access to AWS DynamoDB using Python and AWS Lambda.
- Automated real-time data processing pipelines, improving accuracy.
- Utilized Apache Spark and Hadoop for efficient big data processing.
- Optimized complex SQL queries for large-scale reporting.
- Documented processes and set up proactive monitoring tools.
Timeline
Database Migration Intern
New Jersey Botanical Garden (NJBG)
06.2024 - Current
Human Resources Intern
William Paterson University
05.2024 - Current
IT Intern
Caldwell University
09.2023 - 05.2024
Bachelor of Science - Computer Science, Cognitive Science Honors
William Paterson University
Similar Profiles
Isaiah BarnesIsaiah Barnes
College Football Player at William Paterson UniversityCollege Football Player at William Paterson University
Calum ErlenbornCalum Erlenborn
Assistant Coach at William Paterson University Of New JerseyAssistant Coach at William Paterson University Of New Jersey
SOLOMON NYAANGASOLOMON NYAANGA
Associate Professor at William Paterson University, Wayne, New JerseyAssociate Professor at William Paterson University, Wayne, New Jersey
Jose HernandezJose Hernandez
Electrician at William Paterson UniversityElectrician at William Paterson University
Angelina SquitieriAngelina Squitieri
Server at Tavern 73Server at Tavern 73