Nitin T John

About Nitin T John

Working as Ms-Excel VBA Automation developer @TCS currently->Studying Web Development, Python, Statistics, System Design related to Full Stack Web Developer. VBA | REST API | Excel | SQL | Power Query | Power Pivot | Problem SolverKnack for debugging, problem solving. Want to do jobs related to development of Solutions Screens.#ProblemSolverWish me Luck

Experience

1. Vba Automation Developer

   Tata Consultancy Services

   Mar 2020 — Present · Thane, IN

   Excel VBA Macros Job Works:Major Industries where Services Provided - Food, Pharmaceutics, Health Care, Production, Human ResourceMajor Solutions Where Services Provided - Payroll, Manufacturing, HRMS, CRM.Developed several VBA Macros tools for automating Excel requirements Client specific as well as Internal Management. Developed Several Manufacturing Calculators. Created Several Forms/Tools with User-Friendly UI to Facilitate the Master Data transfer to the Template which is going to be used to populate data in DB, Which Going forward was used by several Clients as an Generic Tool.Made several Macros tools for Internal/Client Higher Management, Going forward became Critical in Day-To-Day business operations. Created Weekly, Monthly, and Quarterly Management reports for several levels of authority and other general reports where merging multiple reports to create a single final report for analysis.Created several dynamic reports which is used by several clients which omitted the time in creating the analysis report every single time for analysis by saving 300+ hours of manual work. Created several Dynamic / Static Offer, Appointment, Increment letters where macros tool was used to provide final data by merging several Enterprise Reports from Payroll and HRMS solution to generate letters in pdf format as per the clients requirements. Provided functionality through Macros where through Enterprise Reports alone was not possible.

Education

• Pillai College of Arts,Commerce and Science

  Master's degree