Roopleen Kaur
Mather California 95655
ad2if9@r.postjobfree.com
https://www.linkedin.com/in/roopleen-kaur98/
Summary
Accomplished technology analyst with a passion for delivering valuable data and insights. Proficient in leveraging statistical methods using Python and data visualization tools for effective decision-making and to drive business solutions. Analyzed large datasets using SQL for meaningful outcomes with proven ability to optimize processes, drive cost reductions and improve efficiency. Worked within teams to ensure scalable solutions that align with organizational goals.
Technical Skills
Adept in Python for data manipulation and statistical analysis, utilizing libraries like Pandas, NumPy and PySpark for large-scale data processing
Skilled in SQL for database querying, alongside tools like Snowflake for data warehousing
Competent in Microsoft Excel and Google Sheets for data analysis, dashboard creation and report generation
Experienced in unit testing methodologies for data pipelines
Proficient in version control with Bitbucket, API testing with Postman, and workflow management using Airflow for efficient data pipelines
Utilizes visualization tools such as Matplotlib and Tableau for insightful data representation
Experience
Technology Analyst
Infosys Ltd. (July 2023 – October 2023)
Developed an end user software tool using PySpark and Python to automate migration of data from one database (Oracle, Bigquery, etc.) to other platforms including Cloud
Used different python modules/libraries for database connectivity, loading inventories, along with validating the migrated data using cell-to-cell, row-level, schema level and SHA-256 validation techniques
Recruited and onboarded new team members through comprehensive interviewing processes. Conducted knowledge transfer sessions to facilitate seamless integration and skill acquisition within the team
Senior Systems Engineer
Infosys Ltd. (April 2022 – June 2023)
Specialized in ETL processes within the pharmaceutical sector, leveraging AWS sandboxes and orchestrating EMR clusters. Ensured compliance and operational efficiency, collaborating with industry leaders to optimize data processes, adhering to regulatory standards while extracting, transforming, and loading data into targeted systems
Contributed to the development of dashboards and reports, utilizing SQL queries to optimize costs and reduce churn rates. Operated within established deadlines, employing Agile methodologies and Jira for effective task management
Systems Engineer
Infosys Ltd. (October 2020 – March 2022)
Contributed to system operations and reliability. Collaborated on system design, integration, and maintenance while leveraging MS Excel for data analysis. Supported projects enhancing system performance and efficiency within cross-functional teams
Education
Bachelors of Technology in Computer Science and Engineering
University College of Engineering, Punjabi University – Patiala, Punjab, India
(August 2016- May 2020)
Graduated with "First with Distinction" division for exceptional academic performance
Completed an immersive, internship program in Data Science at Infosys Mysore training campus, gaining hands-on experience in Python programming for data analysis, SQL for database querying, and practical applications of machine learning and data analysis as a part of my degree course
Soft Skills
Effective Communication
Team Collaboration
Problem-solving
Adaptability
Fast Learner
Courses and Certifications
Data Science and Machine Learning Course– SCALER
(January 2023 - January 2024)