Avinash Kumar Singh

Experience

• 

  R Systems

  Nov 2014 - Jul 2018

  • Spearheaded support for a one-terabyte data warehouse, demonstrating adept management skills for optimal data accessibility.• Successfully established a resilient two-node Real Application Cluster (RAC) with Automatic Storage Management (ASM) on Linux.• Actively engaged in the implementation and fine-tuning of features like AWR, ADDM, and performance statistics.• Proficiently executed data export and import operations using utility tools to ensure seamless and secure data transfer.• Addressed and resolved performance tuning issues, reports, and queries, contributing to enhanced operational efficiency.• Orchestrated the setup of a Data Guard Physical Standby for disaster recovery, ensuring high availability.• Led the end-to-end migration of a complete database from SQL Server to MySQL.• Demonstrated expertise in troubleshooting issues and implementing robust backup and recovery strategies using RMAN.• Effectively managed SQL Server and MySQL databases, ensuring optimal performance and data integrity.• Applied experience in working with MongoDB and other NoSQL environments, contributing to a diverse range of data management capabilities. Show less

  • Data Scientist

    Jun 2017 - Jul 2018

  • Oracle Database Administrator

    Nov 2014 - May 2017
• 

  Reliance Industries Limited

  Feb 2019 - Nov 2019

  Senior Data Scientist

  • Spearheaded the implementation of an Optical Character Recognition (OCR) System, leveraging a multilayer neural network classifier for invoices and receipts, resulting in cost savings exceeding 40%.• Led a 3-member data science team to model the ordering process in 5 unique ways, presented results, and provided recommendations, contributing to a 9% increase in order output.• Successfully completed a Proof of Concept (POC) on tools such as H2O.ai and VoltDB.• Explored various Machine Learning tools, presenting findings to the Management team for informed decision-making. Show less

• 

  Data Scientist and Technical Trainer

  Dec 2019 - Jul 2023

  AI/ML Engineer

  • Developed a bespoke chatbot powered by ChatGPT from OpenAI, utilizing Large Language Models (LLMs) and an iterative prompt development approach.• Engineered a Customer Segmentation Model using clustering techniques, resulting in improved monthly client retention rates.• Served as an AI/ML Technical Trainer for multiple teams, conducting training sessions and workshops on Linux, SQL, Python, RDBMS, and Machine Learning Algorithms for engineering students.

• 

  Enterprise Monkey

  Aug 2023 - Jan 2024

  Lead AI Developer

  • Led the creation of a new Amazon S3 bucket, establishing a foundation for data storage and accessibility.• Set up an Amazon Redshift cluster, optimizing data warehousing capabilities and infrastructure scalability.• Developed a seamless ETL job in AWS Glue, ensuring efficient data extraction, transformation, and loading processes.• Orchestrated the configuration of a comprehensive VPC, defining subnets, availability zones, and internet gateways for a secure network architecture.• Implemented granular security measures, including Network ACLs, Security Groups, and IAM Role configurations, enhancing data protection.• Ensured optimal performance and data integrity by facilitating the efficient loading of data from Amazon S3 to Redshift.• Leading the development of a machine learning model aimed at predicting the "Student Success" metric for Gordon University in Australia. Aggregating data from diverse sources, including the student management system, learning management system, and BCSS Feedback survey, to enhance predictive accuracy and insights. Show less

• 

  Vodafone Idea Limited

  Jan 2024 - now

  Assistant General Manager - Data Scientist