Data Analysis Front End

RAVI CHANDRA LOKESH KUMAR REDDY ANNAPUREDDY

lokeshannapureddy +1-682-***-**** linkedin.com/in/Lokesh Annapureddy/

Executive Summary

An engineer by heart and Application Development Analyst by choice with commendable analytical and logical skills.

Willing to continuously pursue technical knowledge & skills to translate business requirements into foolproof technical & analytical solutions.

Expertise in various phases of project life cycles (Design, Analysis, Implementation and Testing).

Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.

Expertise in Data collection and cleaning involved gathering data from various sources and organizing it for accuracy and completeness.

Dealt with data modeling issues and managed an Operational Data Warehouse with numerous sources and tables.

Expert in developing action plans to mitigate risks in decision making while increasing profitability by leveraging data science.

Proficient in Predictive Modeling, Statistical Data Analysis, Hypothesis Testing using ANOVA, T Tests, Correlations etc.

Expertise in applying Statistical and Analytical techniques using tools Excel, SQL, Python and R to analyze and interpret data, identifying patterns, trends, and insights.

Extensively worked on Google BigQuery for Alphabet's operational data warehousing and handled access control.

Performed data analysis to provide actionable insights, identified opportunities for improvement, and supported decision-making.

Strong skills in visualization tools Tableau, Power BI, Confidential Excel – formulas, Pivot Tables and Charts.

Education

Masters in business Analytics in Data Science 05/2023

Wichita State University – Wichita, KS

Bachelors in computer science and engineering 04/2019

Gandhi Institute of Technology – Visakhapatnam, India

Technical Skills

Programming Languages: SQL, Java, Python, PySpark, R

Regression Algorithms: Linear Regression, Random Forest Regressor, SVM Regressor, Decision Tree Regressor

Classification Algorithms: Logistic Regression, SVM, Decision Tree, Random Forest, Naive Bayes, Ada Boost, Gradient Boost and XGBoost

Clustering Algorithms: K-Means, Agglomerative

Topic Modelling: Guided LDA

Sampling Techniques: Random, Stratified, Reservoir, Under Sampling and Over Sampling

Deep Learning: ANN, CNN, R-CNN, Fast R-CNN, Faster R-CNN, Mask R-CNN, YOLOv3, Inception V3 and RNN

Natural Language Processing: Tokenization, stemming (PorterStemmer, SnowballStemmer), Lemmatization (WordNetLemmatizer) and Named Entity Recognition (NER)

Frameworks: Keras and Tensorflow

Libraries: Numpy, Pandas, Scikit-Learn, Matplotlib and Plotly

Cloud and Database: PostgreSQL, MS SQL Server, Snowflake, GCP, Azure and AWS.

Data Visualization: Tableau, Power BI, Alteryx, Excel

Statistical Software: JMP, SAS, IBM SPSS.

Concepts/Techniques: ETL, ELT, Data Modeling (Snowflake and Star schema), Data Warehousing, Dimension Modeling, Data Lake and Data Migration.

Professional Experience

Application Development Analyst 06/2019 – 07/2021

Client: Google

Aimed at the development of analytical solutions for various Supply Chain applications managed internally by Google.

In my data modeling experience, I focused on understanding the specific business needs and requirements of the organization. I collaborated closely with stakeholders from different departments to gather insights and ensure the data model aligned with their goals. By adopting a business-driven approach, I was able to design and implement data models that effectively supported key business processes and decision-making.

Collaborated with stakeholders to understand business objectives and challenges, offering problem-solving and decision support.

Statistical and analytical techniques were applied using tools like Excel, SQL, Python, or R to analyze and interpret data, identifying patterns, trends, and insights.

Handled data issues, developed reports in SCM Module using PLX/Tableau.

Fixed ETL job failures by finding the exact root cause for the job failures.

Created new jobs/tables using Pentaho & MySQL based on business requirements.

Resolved Data Modelling issues, handled Operational Datawarehouse with 20+ sources and 1000+ tables.

Collaborated with other application teams to understand the flow of the data loads.

Completed the deliveries on time without missing SLA, worked on Data scheduling jobs & created data pipelines.

Skilled in leveraging GCP cloud computing services.

Worked extensively on Big Query for Alphabet's operational data warehousing handling the entire access control.

Collected Data and Cleaned by gathering data from various sources, including databases, spreadsheets, APIs, and other data repositories.

Cleaning and organizing the data to ensure its accuracy, consistency, and completeness.

Performed Data analysis to provide actionable insights and support decision- making. This involves identifying opportunities for improvement, optimizing processes, or addressing specific business questions.

Performed Data Analysis and Interpretation by applying statistical and analytical techniques to analyze data and identify patterns, trends, and insights. This involves using tools like Excel, SQL, or programming languages such as Python or R to perform data manipulation, aggregation, and calculations.

Software Engineer Intern 04/2018 – 06/2018

Grepthor Software Solutions

Developed and implemented front-end web application (matrimony website) using HTML, CSS, and JavaScript.

Collaborated with the design team to translate UI/UX wireframes and mockups into functional web pages.

Optimized web pages for maximum speed and scalability.

Conducted thorough testing and debugging of web applications to ensure seamless functionality.

Worked closely with back-end developers to integrate front-end components with server-side logic.

Collaborated with cross-functional teams, including designers and stakeholders, to gather requirements and ensured successful project implementation.

Provided technical support and troubleshooting for existing web applications.

Continuously optimized and improved the performance and user experience of existing websites.

Achievements and Leadership Experience

Elected as a TREASURER to the executive committee of the Graduate Student Council at Wichita State University.

Was a functioning individual in "Association for Computing Machinery (ACM)".

Won 16 decorations in Intercollegiate Sports and Athletics meet at college level & further, was an individual from the college "Volleyball" group.

Member of the “Budget Committee” of graduate student council at Wichita State University.

I have successfully completed a SQL certification program.

Organized a food stall in the college fest and achieved 100% ROI in two days.

I Was the Captain of our University Cricket team; our team was able to prompt the "Finals" in the year 2019.

Volunteered for many social welfare events as part of a Rotaract Club.

PERSONAL INTERESTS

Monitoring Stock Market Financial Education Playing Cricket Getting Involved in Social Activities within the Community

Contact this candidate