Data Analysis Sales Analyst

ASHIRWAD RAMAKRISHNAN IYER

Buffalo, NY • ad64au@r.postjobfree.com • 716-***-**** • LinkedIn • Github EDUCATION

M.S. MANAGEMENT INFORMATION SYSTEMS July 2023-May 2024 University at Buffalo, The State University of New York GPA: 4.0/4.0 Courses: Database Management Systems, System Analysis and Design, Data Visualization, Online Analytical Processing, Technology Innovation and Management, IT Process Quality Management, Predictive Analytics, Web Analytics for eCommerce. B.E. COMPUTER ENGINEERING Aug 2016-May 2020

University of Mumbai, Mumbai Distinction

Courses: Database Management System, Data Warehousing and Mining, Machine Learning, Big Data Analytics, and Management Information Systems

PROFESSIONAL EXPERIENCE

Data Analyst & Developer INTERN, MAPEM, New York, USA Jan 2024-May2024

● Collected and processed environmental data encompassing site details, contaminants, and chemical attributes.

● Developed SQL queries to efficiently retrieve and analyze data from the PostgreSQL database.

● Ensured data accuracy and integrity through validation, cleaning, and preprocessing of collected data.

● Collaborated with the team to optimize data workflows and enhance system performance.

● Developed a Node.js backend to manage environmental data in a PostgreSQL database and a React interface for user data visualization. Senior Systems Engineer, INFOSYS LIMITED, Pune, India Mar 2021-June 2023

● Worked successfully as a full stack developer and implemented automated testing frameworks for API testing, resulting in a 40% reduction in testing time and improved test coverage.

● Generated significant revenue for the company, reduced costs by 30% and increased productivity by 55%.

● Designed and leveraged SQL queries and database management systems (MySQL, PostgreSQL) to extract, transform, and analyze large datasets for insights into API performance and system behavior. and managed REST, SOAP, JSON formats.

● Developed a comprehensive report generation system to analyze API execution data, including detailed metrics on pass/fail cases, performance trends, and error analysis.

● Personally interacted with, handled, and developed new features according to client requirements from Fortune 500 bank, leading telecommunication, and world-renowned medical device company; organized multiple demonstration sessions.

● Integrated API-UI test automation framework coupled with CI/CD pipeline to accelerate integration and end-to-end testing. PROJECT EXPERIENCE

Soccer (FIFA) Data Analysis

● Handled missing values, outliers, and inconsistencies in the FIFA dataset using SAS.

● Created new features to improve model accuracy in predicting player potential.

● Trained and evaluated machine learning models to predict player potential, achieving high accuracy with the best model.

● Developed a Streamlit app for real-time prediction of player potential based on user inputs.

● Integrated visualizations to present data insights and model predictions interactively.

● Tools: Python, Pandas, Scikit-learn, Streamlit, Matplotlib, Seaborn, Orange, SAS Guac4U

● Designed and implemented a data warehouse using Talend Studio for a food and beverages retailer to create ad-hoc reports and dashboards and established OLAP Cubes and Data Marts to support business management. Netflix Data Analysis

● Cleaned and standardized Netflix data and performed trend analysis on show types and genres using Python libraries.

● Applied K-Means clustering and created interactive visualizations with Plotly and WordCloud to highlight content patterns.

● Developed machine learning models to predict show success and popularity, leveraging Scikit-learn.

● Tools: Python, Pandas, Matplotlib, Seaborn, Plotly, Scikit-learn, WordCloud TECHNICAL SKILLS

Languages- Python, Java, SQL, C, JavaScript

Tools and Frameworks - MySQL, PostgreSQL, Oracle, Spring Boot, Angular, Tableau, Power BI, Git, Talend Studio, SAS Studio Functional Skills - Data Analysis, Data Visualization, Data Mining, Data Cleaning, Business Intelligence & Reporting TECHNICAL CERTIFICATIONS

Microsoft- Introduction to Programming Using JavaScript IBM- Data Analysis & Visualization with Python University of Pennsylvania- People Analytics, Operations Analytics IBM- Databases and SQL for Data Science with Python Google Data Analytics Professional Certificate Lean Six Sigma Training by Meliora Consulting LEADERSHIP ROLES

● Appointed as the head of the Grievance Committee of the Computer Society of India, KGCE, for 2019-2020

● Event Head for CSI: Techfest 2018-2019

ACHIEVEMENTS/EXTRACURRICULAR

• Winner of Innovate our Ecosystem: A Hackathon organized by Blackstone Launchpad, University at Buffalo.

Contact this candidate