`
KEERTHI ERRAM
****************@*****.*** +1-940-***-**** Denton, TX 76205 linkedin.com/in/keerthi-erram/ Summary
Master’s student in Advanced Data Analytics from University of North Texas with expertise in machine learning, data engineering, and cloud technologies. I am currently seeking a full-time role as Data Analyst. Skills
Programming Languages: C/C++, Python, Java, R, SQL, Matlab, PHP, JavaScript.
Databases: MySQL, Postgres, SQL, NoSQL, DBMS.
Data Analytics & Visualization: NLP, Machine Learning, Tableau, Power BI, Looker, SAS.
Cloud & Big Data: AWS, GCP, Snowflake, Spark, Hadoop.
Tools & Platforms: ETL Tools (Informatica, GCP), MS Office Tools (Word, PowerPoint, Excel), Advanced Excel
(Pivot Tables, VLOOKUP, Macros).
Data Engineering & Analytics: Data Modeling, Risk Management, Data Structures, Agile Frameworks for Analytics, Digital System Design, Digital Signal Processing, Network Analysis. Experience
Bigperl Solutions PRIVATE LIMITED Bengaluru, India Software Engineer
11/2022 – 08/2023
Developed and maintained software applications to meet business needs.
Collaborated with teams to gather requirements and deliver solutions.
Improved system performance by optimizing existing features.
Automated processes to reduce manual effort and increase efficiency.
Participated in code reviews, debugging, and ensured code quality.
Applied Agile methodologies to manage project timelines. Cognizant Hyderabad, India
Programmer Analyst Trainee
02/2022 – 10/2022
Worked with various programming languages (SQL, Java, GCP).
Completed SQL projects and visualized data using Tableau, Power BI, and QlikView.
Hands-on experience with GCP Big Data tools for data processing and analysis.
Developed complex analyses, enhancing customer journeys in commerce and marketing.
Proficient in statistical modeling, machine learning algorithms, and A/B testing. SmartInternz Hyderabad, India
Intern
07/2021 – 12/2021
Developed a library management chatbot using Python, NLP, SQL, and AWS.
Enhanced user interaction through NLP techniques.
Experienced in BI architecture, creating dashboards and reports. KE
Proficient in SQL for handling large datasets and optimizing database performance. Katyayani Sree Communications India
Data Analyst
08/2020 – 02/2020
Analyzed sales data to optimize stock levels and improve inventory management.
Conducted customer behavior analysis to guide product recommendations.
Provided data-driven insights for sales performance and demand forecasting. Srinivasa Super Market Vemulawada, India
Data Analyst
06/2019 – 11/2019
Analyzed customer data, improving customer engagement and retention by 15%.
Optimized inventory management and reduced excess stock by 10%.
Generated detailed reports and dashboards for data-driven decision-making. Tehsil Sircilla, India
Data Entry
03/2018 – 09/2018
Entered and updated records into the system, ensuring accuracy and completeness.
Verified and cross-checked data for any errors or discrepancies.
Assisted with organizing and managing physical and digital files.
Supported the team with basic administrative tasks related to data handling.
Maintained confidentiality of sensitive information. Education
University of North Texas US
M.S. in Advanced Data Analytics
Expected in 12/2024
GPA: 4
Relevant Courses: Data Analytics, Data Visualization, Big Data, Agile Frameworks, Harvesting Storing and Retrieving the Data, Deep Learning
Malla Reddy Engineering College for Women India
Electronics and Communication Engineering
05/2022
GPA: 3.652
Certifications
SQL Associate from DataCamp (2024)
Google Cloud Professional Data Engineer Certification (2024)
Associate Data Analyst from DataCamp (2024)
Microsoft Power BI Data Analyst Certification (2024)
Advanced Data Visualization with Tableau (2024)
Cisco Data Analytics Essentials Certification (2024)
Tableau Certification from Simplilearn (2023)
Oxford Achiever Award (2019)
Projects
Fraud Detection in Financial Transactions: Developed a system using machine learning and statistical analysis to detect fraudulent transactions in large financial datasets.
Global Analysis of COVID – 19 Cases and Deaths across Continents and Years: Analyzed global COVID-19 cases and deaths using Python, identifying trends across continents and years to support global health policies.
Retail Sales Performance Dashboard: Created a Power BI dashboard to track sales trends, customer preferences, and forecast inventory management using DAX.
Predictive Modelling and Analysis of Hospital Inpatient Stays and Costs: Analyzed and predicted hospital costs and length of stay using linear regression and KNN for New York's SPARCS dataset.
Auto-App that helps Customers understand different Automobile Models: Developed a mobile app providing detailed insights and comparisons of car models to aid consumer purchasing decisions.
Customer Churn Analysis in Looker: Built a Looker dashboard to analyze customer churn and provide insights for retention strategies using LookML.
Optimizing Non-Profit Efficiency: Advanced Data Analysis Strategies: Enhanced marketing campaign efficiency with SAS Enterprise Miner by optimizing donor targeting and donation predictions.
Analyzing Job Trends for Data Scientists in the US: Created a Tableau dashboard to analyze US job trends for data scientists and identify in-demand skills.
A Holistic View of Nations Impacted by Terrorism: Analyzed terrorism data to identify high-risk areas, visualized results using Tableau for business and security insights.
Statistical Analysis of Hotel Booking: Used statistical analysis to improve pricing and customer service strategies in hotel bookings.
Employee Productivity and Attendance Dashboard: Developed a Power BI dashboard to track employee productivity and attendance for HR optimization.
Data-Driven Decision Making Using GCP's Big Data Tactics: Led a data integration project using GCP tools like BigQuery and Open Refine to improve data-driven decision-making.
Power Generation for Auto Street Light: Designed a piezoelectric-based system to convert mechanical energy into electricity for urban energy efficiency.
Safety Helmet for Mining Workers: Developed a smart helmet with sensors for gas detection, accidents, and temperature monitoring to enhance worker safety.