-
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