Ajay Yadav

Ajay Yadav

Data Analyst
India
English, Hindi

About Me

Highly motivated and detail-oriented data analyst with expertise in Excel, SQL, Power BI, Tableau,Python and statistical analysis. Skilled in extracting actionable insights from complex datasets to drive business growth …

Experience

Graduate Mechanical Engineer

Endo India par formulation indore
Dec 2021 - Present · 4 years 7 months

Data engineer monitoring and maintained the area temperature and Rh data and create charts and dashboard using Excel and SQL.
Qualification and validation of area as per pharma standard making sop and protocol as per guidelines

Engineer

Endo india par formulation pvt lmt Pithampure Indore
Present

Utilized advanced Excel techniques to analyze data collected from Building Management Systems (BMS) within pharmaceutical facilities, enabling real-time monitoring and optimization of critical parameters such as temperature, humidity, differential pressure and energy consumption.
Developed comprehensive reports and dashboards to visualize trends, identify anomalies, and facilitate data-driven decision-making processes, resulting in enhanced operational efficiency and regulatory compliance.
Creating protocols for IQ (Installation Qualification), OQ (Operational Qualification), and PQ (Performance Qualification) in a pharmaceutical company is crucial for ensuring that equipment, systems, and processes meet the required standards and are capable of consistently producing high-quality products.

Engineer

Macleod pharma pvt lmt daman

Engineer

Mylan laboratories pvt lmt indore

HVAC Engineer in the pharmaceutical industry, adept at ensuring optimal performance and compliance of HVAC systems.
Proficient in conducting validation tests such as airflow velocity, HEPA filter integrity, particle counts, and temperature/DP monitoring.
Skilled in designing, implementing, and maintaining HVAC systems to meet stringent regulatory standards and ensure the integrity of critical environments.

Skills

Application Programming Interface (API) C# C++ Language (C++) Computer-Aided Design (CAD) Cascading Style Sheets (CSS) Data Analysis Professional HVAC (Heating, Ventilation, and Air Conditioning) Java JavaScript Development Linux Mechanical Engineering Product Design Project Leadership Python Windows Cloud Design Reviews Engineering Design Engineering Drawings Facility Finite Element Analysis Graduate Programs Hardware Maintenance Mechanical Equipment System Design Dispute Resolution Creo Jenkins SolidWorks CAD Excel Pivot Table Data Visualization SQL Power BI Tableau Dashboard NumPy Pandas Statistics ETL DAX Data Cleaning Data Modeling Forecasting Forecasting Models Decomposition Charts PowerPoint
Report this Profile?