Yaman Jain

Yaman Jain

$25/hr
Business Analyst. Excel/VBA Expert.
Reply rate:
-
Availability:
Part-time (20 hrs/wk)
Location:
Patna, Bihar, India
Experience:
10 years
- Yaman Jain - Automation Manager Patna, India linkedin.com/in/yamanjain github.com/yamanjain I translate technology, computer programs into process automations. Ethical hacker, I do most of my magic with plain old Excel WORK EXPERIENCE SKILLS Director Pahadiya Commercial Limited VBA 01/2009 - Present, Patna, India Authorized Dealership of Honda two-wheelers, HMSI(a 100% subsidiary of Honda Motor, Japan) Achievements/Tasks Recruited a team of 60 people across 3 verticals. • Data analytics to monitor high profit value added sales, monitor team and company performance. • hands-free barcodes to reduce customer wait-time. Python Informatica Selenium Power BI VB.Net VOLUNTEER EXPERIENCE Director Rotary Patna Youth 06/2018 - 12/2019, Tasks/Achievements Software Projects Python/SQL/Excel VBA 01/2009 - Present, Extensive developement on various software tools Tally ERP SQL Patna, India Founding Member Patna, India B2B projects, integrating Excel, Python with other tools creating automation. SQL based data analytics including auto-ordering, KPI monitoring, triggers for alerts/sms/email Python - Bank entries/reconcilliation, GST matching Python - Captcha Solver using tesseract Python - GMAIL API with batch email handing EDUCATION B.E. Computer Science P.E.S. Institute of Technoloogy 06/2004 - 06/2008, Bangalore, India Python to fetch weather data from IMD (Indian Metrological Department VBA with Autohotkey for RPA, APIs to send sms, email., word to produce bulk labels LANGUAGES VBA reporting with MS SQL, browser automation with Selenium, Tally ERP with XML. English Hindi Native or Bilingual Proficiency Native or Bilingual Proficiency VBA with word to produce instant/bulk custom labels. Spanish Kotlin based Android app to send canned auto replies on Whatsapp Associate Programming Analyst Goldman Sachs 06/2008 - 12/2008, Bangalore. India / New York, USA Financial Reporting / Data Warehousing Team Created the basic framework of a data warehouse for the Financial Reporting team. • Developed automation scripts for routine team tasks; brought down failed executions by 10%. Improved reporting data flow for business using ETL. Limited Working Proficiency INTERESTS Offbeat traveler (crossed over 15 borders) Avid swimmer and badminton player
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.