Jyothirmayee Kothakota

About Jyothirmayee Kothakota

Astute Data Analyst with experience identifying and translating the data into tangible analysis that helps in making key business decisions. Highly successful in leveraging data trends and patterns to predict fraud risk and recommend potential investments with good returns. Worked extensively with extracting the raw data from Excel to analyze trends - which includes building queries using SQL, identifying performance metrics, visualizing reports with Tableau and building Python scripts to plot graphs.TECHNICAL SKILLS• Languages- Python, R, SQL, Spark, C, JAVA.• Tools- Salesforce, AWS, Git, Alteryx,Jira• Databases- Oracle, MySQL, Microsoft SQL Server, MS Access.• Visualization- Power BI, Tableau, Excel, Google Sheets, Salesforce Dashboards, Python, R• Machine Learning- Classification, Regression, A/B testing, NLP, Statistical Analysis, Hypothesis Testing, Clustering. • Package Libraries- Pandas, NumPy, Scikit, MatPlotLib, ggplot2, TensorFlow, Keras, Seaborn, NLTK.• Web Frameworks- Rshiny, Flask

Experience

1. Data Engineer

   Bayer

   Oct 2020 — Present · St Louis, MO, US

   Extracted data from multiple structured and unstructured data sources, transformed, processed, and loaded into relational and non-relational databases * Used cloud data storages like AWS and Google Cloud Platform - Big query to retrieve the data.* Design and build ETL pipelines to automate the ingestion of structured and unstructured data for data analysis * Developed complex Oracle SQL queries and Microsoft SQL queries to improve the performance time.* Fine-tuned SQL queries for maximum efficiency and performance for generating reports.* Wrote Python Script to connect to Cloud data warehouse and retrieve the data from various schemas.* Developed R script to read the data from various REST API’s.* Authenticated and migrated the existing API from PING Authentication to AZURE Authentication.* Used Data mining tools like Pipeline pilot to clean the data and develop the metrics based on business requirements.* Created automated jobs to run the pipeline pilot protocols to use the updated data.* Used Data Preparation tools like Tableau Prep to prepare the data for Analytics.* Built Spotfire and Tableau reports by to gather the business requirements working with Clients and managers * Performed data analysis, outlier detection, anomaly detection, data profiling, trend analysis, financial/statistical analysis & reporting for new and legacy data sources.* Prepared technical documents by understanding the business requirements and design the ETL applications based on that.* Eliminated Spreadsheet reporting, reducing 99% processing time and increasing report accuracy(Python/AWS)* Involved in software development life cycle which followed agile methodology which helps to improve the SDLC process to boost the faster delivery of the software services.

Education

• Jawaharlal Nehru Technological University

  Bachelor's degree, Electronics and Communications Engineering

  2011 — 2015

• Maryville University of Saint Louis

  Master's degree, Data Science

  2019 — 2020