Ashutosh Kumar
Kolkata
Summary
Accomplished Senior Software Engineer and Lead Data Engineer with over 10 years of experience in designing and delivering comprehensive data and analytics solutions across B2B and enterprise domains. Currently spearheading the design and implementation of a centralized data platform at Concentrix, focusing on the ingestion and harmonization of B2B transactional data to provide complete end-to-end visibility for business users. Proven expertise as an architect, hands-on developer, and technical lead, adept at driving project deliverables while mentoring teams and resolving complex challenges. Recently expanded skill set to include Generative AI by developing RAG solutions with vector databases such as Qdrant and Milvus, successfully integrating advanced AI patterns into production environments.
Overview
12
12
years of professional experience
2
2
Certifications
1
1
Language
Work History
Sr. Software Developer
Concentrix
12.2021 - Current
- Role: Developer Team Lead.
- Tech Stack: - Qdrant DB,Cursor, Spark, pyspark, Hive, Hadoop, Python 3.0, API integration, Database integration, Elastic search, Kibana, Apache Nifi
- File type: -Parquet, Avro, ORC, CSV, EDI, Json, XML, . PDF.
- Latest Tech: - Azure OpenAI integration with Nifi.
- Noteworthy Projects so far in Concentrix: -
- Integration of Teams Bot with agentic AI ,Generative Ai for order updates.
- This project is aimed to create a Data pipeline to ingest all B2B different domains data to a central repository using spark as data processing framework and Hadoop/Hive as storage layer.
- 2. Email Text Extraction Using Azure OpenAI (JAN 2024 – Till Date) :- This project is aimed to read email and extract business information in a predefined schema and the use the existing framework to extract and process the information.
Manager IT
Grant Thornton India
07.2018 - 12.2021
- This is an audit and risk analytics project aimed to help CA’s to do the statuary audit and internal audit. It helps CA’s to run their predefined/ad-hoc analysis on the client’s huge data sets. It also Visualize various analytics graphs based upon different scenarios, which would help auditors to find financial or other anomalies. Which can be flagged out to complete the audit process.
- Client: In-house project
- Major Projects in Grant Thornton: -
- 3. statutory audit Analytics (July 2018 – may 2019):- This project was aimed to develop a Tool for CA people who can feed their requirement upon audit portal and the toll will churn the data and provide them with useful insight .
- 4. Internal audit Analytics (Feb 2019 – DEC 2021):- This project was aimed to develop a Industry focused Analysis tools which can churn Audit reports related to that particular industry .configured industry Health, Insurance , banking , retails , gaming ,media
- Technology used: -Apache Nifi , CDH distribution, HDFS, Hive, PySpark, Kylo, MySQL, Shell scripting, Python, Azure AD.
IT Analyst
Tata Consultancy
03.2014 - 07.2018
- Major Projects in TCS: -
- 5. Data warehouse Reporting (March 2014 – July 2018) :-The project is aimed to build various OBIEE reports for the clients. It is a data warehouse project where we receive data from different components using various type of interface like FTP, SFTP, XFB, MQ, AQ, DB link via intermediate schemas. Depending on the type of interface we load the data in RDBS system using external tables and CTL files. we use delta tables and fact tables to process the data in an efficient manner and shoe the reports biased on time and geographical representation in OBIEE.
- Role: Developer
- Technology used : ETL, Pl/SQL, shell scripts, Tortoise SVN, OBIEE.
- 6. REAL TIME DATA PROCESSING (March 2014 – July 2018) : The project aimed to process the data in near real time and provide the data to the front end team which would show data on their portal. We receive data from different component in near real time via OSB (MQ interface) and AQ interfaces in the form of XML (payload). We extract data from those XML’s and store them at our database in near real time. Then we apply different type of logic to provide the required data in the cursor to front end portal team. We basically show the current status of order and fault on portal.
- Client: British Telecom
- Role: Developer
- Technology used :Pl/SQL, shell scripts, Tortoise SVN, OBIEE Tools.
- 7. Oracle Database migration from 11g to 12c (March 2014 – July 2018) :- The project aimed to full lift and shift of all application hosted on 11g to 12c. I have worked as a developer to develop the parallel run quires which check the data and its integrity in both the versions and make sure that our packages and procedures are working as expected after migration. We have achieved better runtime of packages after migrating to 12c.
- Client: British Telecom
- Role: Developer
- Technology used: PL/ Sql development.
- 8. Migration from sql server to oracle server: (March 2015 – July 2018) - The project aimed recreates the objects and DTS which were running in sql server to oracle server. We converted all the DTS, functions procedures which was running at sql server into their counterpart in oracle server. This was very challenging work to convert all the sql queries into oracle. Although both are sql but there are various differences which we have to take care of, like null and blank value. Case sensitive and many other.
- Client: British Telecom
- Role: Developer
- Technology used: SQL server, DTS, oracle PL/sql.
Education
B.Tech - Electrical & Electronics Engineering
V.I.E.T
G.B. Nagar01.2013
12th - undefined
Satyendra Narayan Singh College
01.2008
10th - undefined
Sahyogi High School
Hajipur01.2006
Skills
Generative AI integration in projects
Certification
Oracle certification: Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I in 2016.
Interests
Listening Music, watching movies & Documentaries, Learning new technologies and always try to make something meaningful out of that
Achievements and Extra Co-Curricular Activities
Awarded the “Excellence in academics” in year 2004 in school. Awarded 4 times “Diligence in academics” in school. Received Prize in the “General Knowledge Competition. Started an NGO named ENSO in my first year of college, which is still run by juniors. Co-ordinated Workshop on ROBOTICS, conducted by Robo-sapiens, Organized in V.I.E.T. Worked for EATO, a technical society in college V.I.E.T for the period 2010-2012
Personal vitae
- Name : Ashutosh Kumar
- Languages : English and Hindi (Reading, Writing and spoken)
- Place: - Kolkata.
Timeline
Sr. Software Developer
Concentrix
12.2021 - Current
Manager IT
Grant Thornton India
07.2018 - 12.2021
IT Analyst
Tata Consultancy
03.2014 - 07.2018
12th - undefined
Satyendra Narayan Singh College
10th - undefined
Sahyogi High School
B.Tech - Electrical & Electronics Engineering
V.I.E.T