Yash Kumar Email & Phone Number

Noida, Uttar Pradesh, India

Developed an automation architecture for the Management Information System (MIS) of the organization, leading to a daily time savings of 3-4 hours of manual work.Conducted extensive data organization and cleaning to ensure high-quality, reliable datasets for data-driven analytics, optimizing the accuracy and efficacy of analytical processes.Designed a data schema from scratch for a dataset exceeding 1 million rows. Implemented an ETL (Extract, Transform, Load) script in Python with comprehensive logging. Employed pagination techniques to ensure seamless data ingestion into a PostgreSQL database. Integrated Google Sheets API into the ETL process for efficient data ingestion.Leveraged advanced SQL attributes such as window functions and Common Table Expressions (CTE) to derive critical insights from complex datasets, aiding in informed decision-making. Additionally, authored SQL procedures to precisely implement business logic, enhancing data-driven decision-making processes.Developed a model that calculates the Estimated Moving Average (EMA) to statistically assess the performance of partners. This model has been instrumental in helping the organization track movements and identify opportunities to enhance business flow.

Noida, Uttar Pradesh, India

Engineered ETL pipelines using Python, Pandas, and SQL Alchemy; extracted,transformed, and loaded data from multiple sources into an AWS RDS PostgreSQLdatabase; increased data processing speed by 25%. Executed data ingestion and analysis for an International School, PAN India, leveraging advanced SQL functionalities such as JOINS, Aggregate functions, Window Functions, and CTE in PostgreSQL, processing data from multiple sources and handling datasets of over 10,000 records. Optimized data integration processes, devised scalable data models and schemas, and monitored pipeline performance using AWS EC2, resulting in a 20% improvement in data quality and accessibility. Orchestrated multiple projects concurrently, augmenting the organization's work capacity by 30%. Applied forecasting techniques, including linear regression and gradient descent optimization, to provide accurate sales predictions, resulting in a 15% increase in forecast accuracy. Designed and implemented an automated data cleaning pipeline that identified and corrected errors in datasets, ensuring data quality and consistency. This work included normalizing data and ensuring compliance with ACID principles to maintain data integrity, resulting in a 15% improvement in data accuracy. Performed web scraping using Selenium and BeautifulSoup to gather real-time Aluminum stock prices from multiple sources, extracting and processing data from over 50 web pages, ensuring comprehensive market analysis and informed decision-making. Created Python and PostgreSQL-based interactive dashboards to provide key insights into company data, leveraging proprietary software and enhancing data visualization by 30%.

Noida, Uttar Pradesh, India

Analyzed complex data sets, identifying, analyzing, and interpreting trends andpatterns by conducting correlation analysis and creating insightful visualizationsusing charts and graphs, facilitating data-driven decision-making. Demonstrated strong adherence to established procedures and guidelines, performing routine tasks under direct supervision, ensuring consistent and accurate execution of assigned responsibilities.