Roopa Nagaraj
Data Analyst Data Engineer
Irvine, CA 949-***-****
**************@*****.***
Data Analyst/Data Engineer with 5+ years of experience in data analysis, engineering, data visualization and automation. Expertise in developing data pipelines, preprocessing, data visualization, and building interactive dashboards to support business decision-making. Proficient in Python, R, SQL, and tools like Tableau and ELK stack, with experience in creating efficient workflows and enhancing data quality.
TECH STACK
Tools: ELK (Elasticsearch, Logstash, Kibana) Tableau Git Agile Matplotlib Plotly Languages: Python R SQL
Data Skills: Data Preprocessing Database Schemas Data Visualization Pivot tables Vlookups Other Skills: Data Integration SAP Automation UiPath RPA Pandas Scikit-Learn NumPy Jupyter Notebooks EXPERIENCE
Independent Learning and Professional Development July 2021—Present
● Google Data Analytics Professional Certificate
● Microsoft Power BI Data Analyst - Intermediate
● Gained practical knowledge in data visualization, creating reports, and analytical models using Tableau, Power BI.
Data Analyst/Engineer - Continental Automotive components • Bangalore Sep 2018—July 2021
● Led data extraction automation using Ephesoft and Python, integrating data between SAP systems and internal platforms, improving process efficiency by 40%.
● Performed ETL by designing and implementing robust data pipelines for extracting, transforming, and loading large volumes of text data for analysis reducing manual data entry and enabling faster decision-making.
● Developed interactive dashboards and visualizations that enabled key stakeholders to access real-time insights, optimizing decision-making processes.
● Implemented SQL queries for complex data analysis, improving reporting accuracy and reducing errors.
● Worked closely with cross-functional teams to design and deploy automated workflows, reducing costs and boosting productivity.
Junior Data Analyst/Engineer - Continental Automotive components • Bangalore July 2017—July 2018
● Used tools such as ELK stack (Elasticsearch, Logstash, and Kibana) to create data visualization solutions, resulting in reduction in report generation time by automating data aggregation and visualization process.
● Developed interactive dashboards and visualizations that improved decision-making efficiency, enabling faster and more informed decision making across multiple departments.
● Implemented data preprocessing tasks using Python, which increased data processing speed by 40% and enhanced data quality, improving accuracy of business insights. PROJECTS
Customer Demand Analysis Tool for Supply Chain Management Sep 2018—Feb 2019
● Developed a data preprocessing pipeline using R programming to clean and structure customer demand data, ensuring high data quality for analysis.
● Designed and implemented algorithms to analyze and visualize customer demand trends, enabling planners to make data-driven decisions based on actionable insights.
● Created advanced visualizations to compute and present covariance among yearly demand predictions, enhancing the accuracy of demand forecasting.
● Delivered a user-friendly, interactive dashboard that empowered planners to explore data trends independently, improving decision-making efficiency.
● Leveraged data modeling and advanced forecasting techniques to predict demand trends, improving planning accuracy by 85%.
● Reduced data preprocessing time by 30%, enabling faster decision-making. AI for Trade Tax Process Feb 2019—Jan 2020
● Developed Python scripts to automate the upload of information and post-processing tasks in tax department workbooks.
● Implemented algorithms for accurate tax calculations and efficient currency type conversion.
● Designed functionality to dynamically highlight data using color codes for improved visualization and analysis.
● Reduced manual work and errors, boosting efficiency and productivity by 50% in the tax department. AI4RE (AI For Requirement Engineering) Feb 2020—Dec 2020
● Utilized NLP techniques such as tokenization, stemming, and word embedding to preprocess and analyze large volumes of text data comprising hardware and software requirements.
● Developed custom similarity mapping algorithms, including cosine similarity and Jaccard similarity, to quantify the degree of similarity between different sets of requirements.
● Implemented robust data pipelines to handle text data ingestion, preprocessing, feature extraction, and similarity computation efficiently.
Conversational AI For Digital Companion Jan 2021—July 2021
● Designed and implemented a conversational AI system using RASA framework to facilitate natural language interactions for music requests.
● Integrated the system with Spotify’s API to enable direct access to Spotify’s extensive music library, resulting in functionalities to manage music playback, playlists and recommendations based on user preferences and requests.
● This project resulted in improved Personalized recommendations and user experience. EDUCATION
MASTERS IN Software Engineering Sep 2016—Nov 2018
JSS Science and Technology University, Mysore
Bachelor's in Computer Science and Engineering Aug 2012—Jun 2016 Government Engineering College, Mysore
CERTIFICATION AND AWARDS
Automation Explorer Training
NLP Using TensorFlow
Machine Learning from Coursera
Contivation Award: Proposed an Idea to Setup Chatbots for Use in IT Helpdesk