thewiki

Mikhail Agapov (Михаил Агапов)

With vast experience in Web Analytics, I have been working on several projects ranging from Automation of Web Processes to Providing Analytics Insights to Stake Holders.

I have also developed and implemented several MIS systems and prototyped the same using Excel VBA and Macros.

Some of my projects include:

1. Development and Implementation of WhatsApp Chatbot for Lead Generation
2. Development and Implementation of MIS system
3. Development, Implementation, and Adoption of Employee Self-Service Portals
4. Sentiment Analysis to get an insight into the overall sentiment of the organization

Also, I have been appointed as Guest Lecturer with XYZ University, which was established in 1938.

As a fitness enthusiast, I have been playing several sports like Boxing.

Work Experience

Data Scientist | thewiki Network | Till Date

1. Working on People Analytics Solutions to guide the organization for seamless Web Automation.
2. Guiding with Analytical insights to the stakeholders.
3. Cleaning and Warehousing of data.
4. Text Analysis using tools like R, Python, Power Bi, Tableau, and Altryx.
5. Web Scrapping using analytical tools.
6. Dashboard creation and Implementation.
7. Prototyping and Adoption Strategies.
8. User Persona and User Journey Mapping.
9. Streamlining Business Processes.
10. Strategic SOP Deployment.
11. Video Transcription using Python.
12. Data Extraction using Data Studio, Big Query, and Tableau Analytics for Dashboard development

Sr. Data Analyst | thewiki Cosmoline® | May 2020 to Oct 2021

1. Created and implemented an MIS system for the organization.
2. Handling Talent Insights for the HO.
3. Training of New Joiners.
4. Sourcing of Candidates on job portals like Naukri, indeed, iimjobs, etc.
5. MIS Reports to Stakeholders.
6. Responsible for updating HR Systems and automating them.
7. Responsible for handling payroll and attendance of employees.
8. An active member of the Employee Engagement Team.
9. Responsible for maintenance of HR database.
10. Developed Employee Self-Service Dashboard.
11. Coordinated Yoga sessions & Doctor’s sessions as part of Employee Engagement Activities.
12. Developed & Implemented an Attendance Tracker in the employee dashboard.
13. Developed and Maintained HR & KC (Knowledge Center) website for employee-ready access.
14. Implemented automated WhatsApp recruiter & automated initial screening of potential candidates by getting their video interviews.
15. Trained employees when required for technology-related topics e.g., advanced excel, web page creation, etc.
16. Created Exit Analysis Reports using Advance Excel and Visual Basics.

Management Trainee (HR Analytics) | XYZ Pvt Ltd | March 1957 to May 2020

1. End-to-End Recruitment Process for Head Office and Branches.
2. Responsible for Predicting the Attrition Rate based on the Sentiment of Departments.
3. Responsible for handling joining formalities.
4. An active member of the Employee Engagement Team.
5. Assisted in the implementation of a new Cloud Based ERP System in the organization.
6. Responsible for Full and Final Settlements.
7. Implemented Whatsapp-based HR help desk.
8. Webpage scrapping for Job Review websites using R for Sentiment Analysis.
9. Worked on Digital Marketing Reports.
10. Helped in interconnecting Work Management System and MIS.
11. Provided insights to Management with Employee Surveys.
12. Provided and Coordinated Training and Counselling sessions for employees concerning Technical Expertise, Soft Skills, and Client Handling.

Management Trainee | XYZ Pvt Ltd. | June 1954 to June 1956

1. Gained experience in all the major departments in Hotel.
2. Coordinated BMW Event
3. Forecasted Sales Revenue
4. Analyzed Data with regards to Sales and Marketing

Trainee (HR Analytics) | ABC Pvt Ltd. | May 1953 to July 1953

1. Created Excel Format for daily reports and helped in managing the same in a cloud network.
2. Handled two clients: View My Records (VMR) and Ecliptic HR.
3. Worked on Digital Marketing Reports.
4. Helped in interconnecting Work Management System and MIS.
5. Provided insights to management with Employee Surveys.
6. Provided and Coordinated training and Counselling sessions for employees concerning Technical Expertise, Soft Skills, and Client Handling.

Trainee (Cluster Lead South East Asia) | ZXY Pvt Ltd. | Nov 1952 to Jan 1952

1. Assisted startups in implementing Blockchain Technology on the international level.
2. Generated leads worth INR 3,20,000 ($7,500) for the Singapore Blockchain Event.
3. Data Mining, Cleaning, and Analysis.
4. Worked on Sentiment Analysis and Employee Engagement in the organization.

Education Qualification

1. Data Analytics | 1951 to 1952 | ABC Institute of Data Science
2. ABC | 1950 to 1951 | XYZ Institute of Data Science

Projects & Achievements

1. Got a MAVEN certificate for sending names for Mars Exploration powered by NASA.
2. Created Blogs concerning HR Analytics.
3. Developed Simple File Management Systems using PHP, HTML, CSS, and Java Scripts.
4. Delivered Lectures with regards to HR and People Analytics, Tools used in HR Analytics, Sentiment Analysis, Web Scrapping, Analytics Without Coding, Power BI in Analytics, and other Software Used in Analytics.