Ajay Kolaventi

Data Analyst

Contact: 203-***-****, Email: ad4qh8@r.postjobfree.com, Location: New Haven, CT SUMMARY

Experienced Data Analyst with 3+ years of hands-on expertise in extracting meaningful insights from complex datasets.

Skilled in implementing Agile methodologies and leveraging diverse data tools to extract insights and drive informed decision-making.

Profound knowledge of data analysis libraries and tools, such as NumPy, Pandas, Matplotlib, Seaborn, Scipy, ggplot2, and Plotly, ensuring accurate data insights and visualizations.

Experienced in data visualization using tools like Tableau and Power BI, ensuring complex data insights are communicated effectively.

Proficient in working with various databases including SQL Server, and MySQL.

Familiar with cloud technologies, specifically AWS and Azure, facilitating data management and analysis in cloud environments.

Seeking to contribute analytical expertise and problem-solving abilities to a forward-thinking organization. EDUCATION

Master in Business Analytics June 2021 - May 2023

University of New Haven, West Haven

Bachelor in Mechanical Engineering Sept 2014 - April 2018 Maharaja Vijayaram Gajapathi Raj College of Engineering, Andhra Pradesh, India SKILLS

Methodologies: SDLC, Agile, Waterfall

Languages: SQL, Python, R, MATLAB

IDEs: Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, Seaborn, Scipy, ggplot2 Visualization Tools: Tableau, Power BI, MS Excel

Cloud Technology: AWS

Databases: MySQL, SQL Server, NoSQL

Other Skills: Data Cleaning, Critical Thinking, Communication Skills, Presentation Skills, Problem-solving, Statistics Operating Systems: Windows, Linux

EXPERIENCE

Northern Trust, USA Aug 2023 - Current

Data Analyst

Apply Agile methodologies, enhancing team collaboration and streamlining data workflows, resulting in a 25% reduction in project completion time.

Conducting SQL optimization, reducing computation time for critical KPIs by 50%, facilitating quicker decision-making processes.

Employing NumPy arrays for advanced numerical operations and Pandas Data Frames to perform data cleaning, filtering, and transformation.

Utilizing Python and R for advanced predictive analysis, contributing to proactive business strategies.

Creating interactive dashboards in Tableau, facilitating cross-departmental data-driven decision-making processes.

Utilizing AWS Redshift for data warehousing, enabling high-performance querying and analytics for business intelligence and reporting purposes.

Enable functional groups for product management portal using MySQL, thereby increasing operational efficiency and data accessibility by 35%. Amazon Development Centre India Pvt. Ltd., Hyderabad, India Feb 2020 - Dec 2021 Operations Analyst, AVOC Ops Tech IT

Empowered by an innovative mindset, collaborated with the Amazon GO team in the US and the UK to streamline operations, optimize efficiency, and ensure seamless customer experiences.

Led automation efforts to reduce manual tasks, improving operational efficiency and customer experience.

Conducted 80,000 defect submissions in European and North American FCs, saving $150,000 daily.

Oversaw Inventory Control and Quality Assurance teams to rectify errors and enhance inventory management.

Provided technical troubleshooting support and reported complex issues to technical support teams.

Analyzed real-time data from cameras, sensors, and customer interactions to optimize store operations.

Developed machine learning algorithms for predicting customer behavior and enhancing the shopping experience.

Leveraged advanced data analytics to derive actionable insights, enabling data-driven decisions for store layout optimization and inventory management.

Zensar Technologies, India June 2019 - Jan 2020

Data Analyst

Employed Waterfall-driven techniques for data cleaning, ensuring a 30% reduction in data errors and maintaining data integrity.

Developed automated data cleaning scripts using Python, reducing manual efforts by 50% and improving data quality across databases.

Conducted comprehensive data analysis using SQL and Excel, supporting dynamic business requirements.

Developed interactive dashboards and reports in Power BI to visualize and communicate key findings, facilitating data-driven decision-making across various departments.

Leveraged cloud infrastructure for data storage, optimizing resource allocation and reducing operational costs by 15%.

Created informative and visually appealing data visualizations using Matplotlib and Seaborn, enabling clear communication of insights.

Monitored and optimized costs associated with cloud resources on both AWS and GCP, ensuring cost-effective data analysis solutions.

Contact this candidate