# migrations

dir: embeddings_queue
filename: 00001-embeddings.sqlite.sql
hash: d3755dfd232be8e8301f4d7fcfb3a486
sql:
CREATE TABLE embeddings_queue (
    seq_id INTEGER PRIMARY KEY,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    operation INTEGER NOT NULL,
    topic TEXT NOT NULL,
    id TEXT NOT NULL,
    vector BLOB,
    encoding TEXT,
    metadata TEXT
);


dir: sysdb
filename: 00001-collections.sqlite.sql
hash: 38352d725ad1c16074fac420b22b4633
sql:
CREATE TABLE collections (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    topic TEXT NOT NULL,
    UNIQUE (name)
);

CREATE TABLE collection_metadata (
    collection_id TEXT REFERENCES collections(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (collection_id, key)
);


dir: sysdb
filename: 00002-segments.sqlite.sql
hash: 2913cb6a503055a95f625448037e8912
sql:
CREATE TABLE segments (
    id TEXT PRIMARY KEY,
    type TEXT NOT NULL,
    scope TEXT NOT NULL,
    topic TEXT,
    collection TEXT REFERENCES collection(id)
);

CREATE TABLE segment_metadata (
    segment_id TEXT  REFERENCES segments(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (segment_id, key)
);


dir: sysdb
filename: 00004-tenants-databases.sqlite.sql
hash: 048867ce8fcdefe4023c7110e4433591
sql:
CREATE TABLE IF NOT EXISTS tenants (
    id TEXT PRIMARY KEY,
    UNIQUE (id)
);

CREATE TABLE IF NOT EXISTS databases (
    id TEXT PRIMARY KEY, -- unique globally
    name TEXT NOT NULL, -- unique per tenant
    tenant_id TEXT NOT NULL REFERENCES tenants(id) ON DELETE CASCADE,
    UNIQUE (tenant_id, name) -- Ensure that a tenant has only one database with a given name
);

CREATE TABLE IF NOT EXISTS collections_tmp (
    id TEXT PRIMARY KEY, -- unique globally
    name TEXT NOT NULL, -- unique per database
    topic TEXT NOT NULL,
    dimension INTEGER,
    database_id TEXT NOT NULL REFERENCES databases(id) ON DELETE CASCADE,
    UNIQUE (name, database_id)
);

-- Create default tenant and database
INSERT OR REPLACE INTO tenants (id) VALUES ('default_tenant'); -- The default tenant id is 'default_tenant' others are UUIDs
INSERT OR REPLACE INTO databases (id, name, tenant_id) VALUES ('00000000-0000-0000-0000-000000000000', 'default_database', 'default_tenant');

INSERT OR REPLACE INTO collections_tmp (id, name, topic, dimension, database_id)
    SELECT id, name, topic, dimension, '00000000-0000-0000-0000-000000000000' FROM collections;
DROP TABLE collections;
ALTER TABLE collections_tmp RENAME TO collections;


dir: metadb
filename: 00001-embedding-metadata.sqlite.sql
hash: 2b4cf52c4bb2676e21d6860a4409f856
sql:
CREATE TABLE embeddings (
    id INTEGER PRIMARY KEY,
    segment_id TEXT NOT NULL,
    embedding_id TEXT NOT NULL,
    seq_id BLOB NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE (segment_id, embedding_id)
);

CREATE TABLE embedding_metadata (
    id INTEGER REFERENCES embeddings(id),
    key TEXT NOT NULL,
    string_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (id, key)
);

CREATE TABLE max_seq_id (
    segment_id TEXT PRIMARY KEY,
    seq_id BLOB NOT NULL
);

CREATE VIRTUAL TABLE embedding_fulltext USING fts5(id, string_value);


dir: metadb
filename: 00002-embedding-metadata.sqlite.sql
hash: 12a570f7121b3a8ce750a2a7c36da20f
sql:
-- SQLite does not support adding check with alter table, as a result, adding a check
-- involve creating a new table and copying the data over. It is over kill with adding
-- a boolean type column. The application write to the table needs to ensure the data
-- integrity.
ALTER TABLE embedding_metadata ADD COLUMN bool_value INTEGER


dir: metadb
filename: 00003-full-text-tokenize.sqlite.sql
hash: f97ad6334aeaa8f419f01110b648b97a
sql:
CREATE VIRTUAL TABLE embedding_fulltext_search USING fts5(string_value, tokenize='trigram');
INSERT INTO embedding_fulltext_search (rowid, string_value) SELECT rowid, string_value FROM embedding_metadata;
DROP TABLE embedding_fulltext;


# embeddings_queue

created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b1-8606-11ee-93f1-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "About TechKnowGram Limited:\nTechKnowGram Limited is a leading technology company based in Bangladesh that specializes in providing web-based customized solutions in various areas, including ERP, AI, Data Analytics, Robotics, Embedded Solutions with Beacon, AR, VR Applications, Gaming, and Animation. The company is globally recognized for its expertise in the Japan ICT market, where it has been operating for over 20 years. Additionally, TechKnowGram Limited also has a strong presence in the USA and Europe markets. With over 25 years of combined professional experience, the company's team of experts is dedicated to delivering innovative solutions to its clients. TechKnowGram Limited is proud to be an ISO 9001: 2015, ISO 14001: 2015, and ISO/IEC 27001: 2013 certified company and a member of several reputable organizations, including Bangladesh Association of Software and Information Services BASIS, Bangladesh and Japan Chamber of Commerce & Industries JBCCI, Bangladesh Computer Samity BCS, Bangladesh Association of Call Centers and Outsourcing BACCO, Ecommerce Association of Bangladesh e-CAB, CTO Forum of Bangladesh, and SheTrades Commonwealth Program by International Trade Centre ITC."}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b2-8606-11ee-9c6b-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Founder and CEO:\nAhmedul Islam BABU\nAbout Founder & CEO:\nAKM Ahmedul Islam BABU is the Founder Managing Director and CEO of TechKnowGram Limited with extensive experience of over 25 years in BPO, outsourcing, the software industry, and the Japanese market. He is recognized as one of the pioneers in the ICT industry and has held crucial positions at various multinational companies, including NIIT, Metrocomia South Asia, BJIT, SeBPO, Divine IT, and AtomAP. Since 1998, Ahmedul BABU has been actively involved with the Bangladesh Association of Software and Information Services (BASIS). Currently, he is serving as the Director of BASIS and Chairman of the BASIS Japan Desk. He is also the 1st Convener of 1st BASIS Japan Focus Group in 2016 and additionally now serving as Director-in-Charge of standing committees including International Market Development and Digital Education, and a member of BASIS e-GovHUB. Moreover, he serves as a Director of the Bangladesh Association of Contact Center and Outsourcing (BACCO) and a member of the Bangladesh Japan Chamber of Commerce of Industries JBCCI, Bangladesh Computer Samity (BCS), e-Commerce Association of Bangladesh (eCAB), and a Life member of CTO Forum of Bangladesh. Apart from his management and business acumen, Ahmedul BABU has a journalistic background. He has previously served as the executive editor of the Monthly Computer Barta and senior correspondent for the Bangladesh Observer. Additionally, he is the founder and founding president of the Bangladesh ICT Journalist Forum (BIJF). Ahmedul BABU holds Bachelor's and Master's degrees in Applied Physics Electronics and Communication Engineering from the University of Dhaka. He also holds an MBA degree from the Presidency University of Bangladesh and ACMP 4.0 from IBA, University of Dhaka."}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b3-8606-11ee-a41e-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Leadership:\nSahera Islam--Chairman\nAKM Ahmedul Islam--Founder & CEO\nZinat Humaira Khanam--Director\nAyumu Takahashi--Director\nDr. Mahmud Zubayer--Director\nMd. Ariful Alam--Director\nFaruque Hossain--Advisor\nJean-Marc Pelletier--Advisor\n\n\nMembers:\nBasis, BCS, BACCO, JBCCI, e-CAB, ITC, She Trades\n\nMajor Clients & Partneres:\nICT DIVISION, CCA, Bangladesh ARMY, GAS TRANSMISSION COMPANY LIMITED, BANGLADESH AIRFORCE,RHD, MARINE ACADEMY, BSBK,BANGLADESH MADRASAH EDUCATION BOARD, JICA, WATA CHEMICALS LIMITED, JINIYA CONNECT, UNITED NATIONS, UNDP, JRF, ARTICLE,OXYDATA,BANGLADESH HIG TECH PARK, CIC, SPELET, CIRCLE, WOMEN EMPOWERMENT,NITOL-NILOY, E-CAB, BSCCL, BAT, SIEMENS, UNIFON, FU-WANG, GRAMEENPHONE, ROBI, BKASHRFL, BENGAL GROUPS, PRAN, BDJP CONSULTING, JOBBAR< NANMA, MICROSENSE"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b4-8606-11ee-bee3-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Products:\n1.TKGL ERP\nhttps://tkgerp.com/\nTechknowGram Limited offers its own Enterprise Resource Planning solution called TKG ERP, which can be tailored to meet the unique needs of any business entity, including those in the Construction Industry, Education, Manufacturing, Workshops, and RMG industry. This ERP is developed and supported with the latest 4IR technology.\n2.QuizWin\nhttps://quizwin.xyz/\nQuizWin is an interactive quiz platform for knowledge enthusiasts, as its name implies.We offer a range of quiz events that users can participate in and potentially win prizes. The leaderboard provides a complete competitive experience.Ideal solution for effectively organize for any Quiz or assessment even.\n3.Prostuti\nhttp://prostuti.net/\nTechKnowGram has created Prostuti,an exam management platform for institutes to administer exams. The platform was designed with the goal of automating the exam process, which can often be tedious and repetitive. Prostuti simplifies the entire process and provides convenience for both examiners and examinees. It streamlines exam arrangements, management, and attendance, making the entire experience more efficient and user-friendly.\n4.KHOZ\nhttps://techknowgram.com/\nKHOZ is a recently developed project for Beacon-based Indoor Navigation System that incorporates IoT technology to deliver precise and up-to-date location data to users navigating indoor environments. The system operates by using beacons - small, cost-effective, and battery-powered devices that emit a Bluetooth signal that mobile devices like smartphones can detect. Ideal solution for event management at supermarkets for location and promotions."}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b5-8606-11ee-b531-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Services:\n1.BMS:\nThe Roads and Highways Department (RHD) of Bangladesh Government is responsible for maintaining and managing the country's road and bridge infrastructure. To ensure the safety and reliability of bridges, the RHD has adopted the use of Bridge Management System (BMS) software. BMS is a comprehensive tool that helps Bridge Management Wing (BMW) of RHD to monitor the health and performance of bridges, assess their performance, and schedule maintenance and repair work. The four key components of a BMS system that the RHD can use to manage its bridges effectively are Bridge Basic Data Input, Bridge Inspection, Bridge Evaluation and Bridge Remedy. Readless\n2.Custom Solution Development:\nAnalysts & Developers of TechKnowGram Limited love creating application and tools to solve your specific business issues but, our first job, as creative software specialists, is to listen you. We want to hear about your business challenges so that we can help you to solve them. Readless\n3.Skill Migration Education Investment to Japan, Malaysia:\nSkill Migration Education Investment to Japan, Malaysia for Bangladeshi personnel to Japan, Malaysia & Canada. We have 1000+ Japanese Known personnel\u2019s\u2019 CV for Japan market and the Japanese company in Bangladesh. Readless\n4.AI AR VR Big Data Robotics IOT:\nTechKnowGram is a realising different kinds of AI, IOT, AR, VR, Big Data, Application & Solutions to meet the demands of 4Th 4IR Industrial Revolutions 4IR for IQ, education, sense, risk prevention, advanced tech-enabled gadgets & solutions Readless"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b6-8606-11ee-bb78-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Jobs:\n1.Data Analyst\nJob Title: Data Analyst\nDescription:TechKnowGram Limited is looking for Data Analyst for its US Client. Data Anlyst, you will be responsible for Data scrapping, validating and CRM Maintaining.\nSkill set:\nStrong experience English understanding (reading and Writing) Skill\nExperience on Online Marketplace\nStrong understanding of Digital marketing and tools\nExperience with Team Work\nCreative and detail oriented, good at solving problems and deriving solutions\nWilling to work in a dynamic environment and keep picking up new technologies / ideas\nStrong problem-solving skills and ability to work independently\nStrong communication skills and ability to work in a team environment\nEducation: Bachelor's degree\nApply now at:\nTechKnowGram Limited\n5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh\nJobs@techknowgram.com\nOR /CC\nJobs.tkgl@gmail.com\n(Please mention the Job title in Subject Line as Data Analyst)"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b7-8606-11ee-95c8-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "2.Senior Angular Software Engineer\nDescription:TechKnowGTechKnowGram is looking for a Senior Angular Software Engineer for its US Client to join our team and lead the development of our web applications. The ideal candidate will have a strong background in web development, with a focus on Angular, and experience leading and mentoring other developers. In this role, you will be responsible for designing and developing complex web applications using Angular and collaborating with other developers and stakeholders to ensure the delivery of high-quality productsram Limited is looking for Data Analyst for its US Client. Data Anlyst, you will be responsible for Data scrapping, validating and CRM Maintaining.\nSkill set:\nDesign and develop complex web applications using Angular\nLead and mentor other developers on the team\nWrite clean, maintainable, and efficient code\nCollaborate with other developers and stakeholders to deliver high-quality products\nStay up-to-date with the latest developments and trends in web development\nProvide technical guidance and support to the team\nStrong problem-solving skills and ability to work independently\nStrong communication skills and ability to work in a team environment\nEducation: Bachelor's degree\nApply now at:\nTechKnowGram Limited\n5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh\nJobs@techknowgram.com\nOR /CC\nJobs.tkgl@gmail.com\n(Please mention the Job title in Subject Line as Data Analyst)"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b8-8606-11ee-b9a9-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "3.Senior Flutter Developer\nJob Title: Senior Java Developer\nDescription:TechKnowGram is looking for a Sr. JAVA Developer for its JAPANESE Client..\nSkill set:\nStrong experience English understanding (reading and Writing) Skill\nExperience on Online Marketplace\nStrong understanding of Digital marketing and tools\nExperience with Team Work\nCreative and detail oriented, good at solving problems and deriving solutions\nWilling to work in a dynamic environment and keep picking up new technologies / ideas\nStrong problem-solving skills and ability to work independently\nStrong communication skills and ability to work in a team environment\nEducation: Bachelor's degree\nApply now at:\nTechKnowGram Limited\n5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh\nJobs@techknowgram.com\nOR /CC\nJobs.tkgl@gmail.com\n(Please mention the Job title in Subject Line as Data Analyst)"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297b9-8606-11ee-bdcc-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "4. Job Opportunity in Japan\nJob Title: Job Opportunity in Japan\nDescription:Are you looking for an opportunity to work in Japan?\nSkill set:\nAre you looking for an opportunity to work in Japan? If so, could you send your RESUME (DOC file only) right away? Whether you are interested in software development, web design, data analysis, or digital marketing, TechKnowGram has a position for you. Don\u2019t miss this opportunity to work in Japan with TechKnowGram. You will have the chance to work on exciting projects with global clients, learn from experts in your field, and enjoy the benefits of living and working in Japan.Apply now and start your journey to success!jobs.tkgl@gmail.com jobs@techknowgram.com\nApply now at:\nTechKnowGram Limited\n5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh\nJobs@techknowgram.com\nOR /CC\nJobs.tkgl@gmail.com\n(Please mention the Job title in Subject Line as Data Analyst)"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297ba-8606-11ee-bf3b-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "Contact with us: \nTechKnowGram Limited\n5/9 Block B, Lalmatia, Mohammadpur\nDhaka 1207, BANGLADESH\nPhone:+88 02 55008199\nMobile/Whatsapp:+88 01819250309\nEmail: info@TechKnowGram.com\n\u5408\u540c\u4f1a\u793eTechKnowGram\n\u6771\u4eac\u90fd\u4e16\u7530\u8c37\u533a\u5c3e\u5c71\u53f0\n1\u4e01\u76ee10\u756a4\u53f7, \u65e5\u672c\nPhone:+88 02 55008199\nMobile/Whatsapp:+88 01819250309\nEmail: info@TechKnowGram.com"}


created_at: 2023-11-18 11:33:53
topic: persistent://default/default/b074660d-eabf-4239-88ed-8ddcf77fc534
id: 586297bb-8606-11ee-bfd0-dc7196dd21aa
encoding: FLOAT32
metadata:
{"source": "C:\\Users\\user\\Documents\\GitHub\\TalkGPT\\TalkGPT Project\\test features\\Chatbot\\test 3\\TechKnowGram Information.txt", "chroma:document": "WHAT CLIENTS SAYS:\n1. Kinya Ishii:TechKnowGram and Ahmedul worked for us for quite sometime. The whole team of Ahmedul became solution provider. They presenteda remarkable positive attitude. All the work was done in a short span oftime and the team achieved the impossible.\n2.Malliga Subramanium:TechKnowGram\u2019s team provided fast and flexible service with considerable expertise. Their unique approach to\nassessing feedback helped me solve my problem. Ahmed, their leader, is highly regarded for his unwavering commitment to justice.\n3. Kenta Kato:TechKnowGram delivered our work quickly and provided designs that attracted both our clients and partners, while also eliminating the need for a business analyst. They offer a complete solution for all client requirements, making them a valuable asset for any customer.\n4.Hirokazu Yoshida:Ahmedul had been brilliant in getting my work done.He and his team are problem solvers and provided a spontaneous vision of how to build on and clarify whatever was requested. TechKnowGram is praised for its ability to develop workable solutions and for its attention to professional service."}


# embedding_metadata

key: source
string_value:
C:\Users\user\Documents\GitHub\TalkGPT\TalkGPT Project\test features\Chatbot\test 3\TechKnowGram Information.txt


key: chroma:document
string_value:
About TechKnowGram Limited:
TechKnowGram Limited is a leading technology company based in Bangladesh that specializes in providing web-based customized solutions in various areas, including ERP, AI, Data Analytics, Robotics, Embedded Solutions with Beacon, AR, VR Applications, Gaming, and Animation. The company is globally recognized for its expertise in the Japan ICT market, where it has been operating for over 20 years. Additionally, TechKnowGram Limited also has a strong presence in the USA and Europe markets. With over 25 years of combined professional experience, the company's team of experts is dedicated to delivering innovative solutions to its clients. TechKnowGram Limited is proud to be an ISO 9001: 2015, ISO 14001: 2015, and ISO/IEC 27001: 2013 certified company and a member of several reputable organizations, including Bangladesh Association of Software and Information Services BASIS, Bangladesh and Japan Chamber of Commerce & Industries JBCCI, Bangladesh Computer Samity BCS, Bangladesh Association of Call Centers and Outsourcing BACCO, Ecommerce Association of Bangladesh e-CAB, CTO Forum of Bangladesh, and SheTrades Commonwealth Program by International Trade Centre ITC.


key: chroma:document
string_value:
Founder and CEO:
Ahmedul Islam BABU
About Founder & CEO:
AKM Ahmedul Islam BABU is the Founder Managing Director and CEO of TechKnowGram Limited with extensive experience of over 25 years in BPO, outsourcing, the software industry, and the Japanese market. He is recognized as one of the pioneers in the ICT industry and has held crucial positions at various multinational companies, including NIIT, Metrocomia South Asia, BJIT, SeBPO, Divine IT, and AtomAP. Since 1998, Ahmedul BABU has been actively involved with the Bangladesh Association of Software and Information Services (BASIS). Currently, he is serving as the Director of BASIS and Chairman of the BASIS Japan Desk. He is also the 1st Convener of 1st BASIS Japan Focus Group in 2016 and additionally now serving as Director-in-Charge of standing committees including International Market Development and Digital Education, and a member of BASIS e-GovHUB. Moreover, he serves as a Director of the Bangladesh Association of Contact Center and Outsourcing (BACCO) and a member of the Bangladesh Japan Chamber of Commerce of Industries JBCCI, Bangladesh Computer Samity (BCS), e-Commerce Association of Bangladesh (eCAB), and a Life member of CTO Forum of Bangladesh. Apart from his management and business acumen, Ahmedul BABU has a journalistic background. He has previously served as the executive editor of the Monthly Computer Barta and senior correspondent for the Bangladesh Observer. Additionally, he is the founder and founding president of the Bangladesh ICT Journalist Forum (BIJF). Ahmedul BABU holds Bachelor's and Master's degrees in Applied Physics Electronics and Communication Engineering from the University of Dhaka. He also holds an MBA degree from the Presidency University of Bangladesh and ACMP 4.0 from IBA, University of Dhaka.


key: chroma:document
string_value:
Leadership:
Sahera Islam--Chairman
AKM Ahmedul Islam--Founder & CEO
Zinat Humaira Khanam--Director
Ayumu Takahashi--Director
Dr. Mahmud Zubayer--Director
Md. Ariful Alam--Director
Faruque Hossain--Advisor
Jean-Marc Pelletier--Advisor


Members:
Basis, BCS, BACCO, JBCCI, e-CAB, ITC, She Trades

Major Clients & Partneres:
ICT DIVISION, CCA, Bangladesh ARMY, GAS TRANSMISSION COMPANY LIMITED, BANGLADESH AIRFORCE,RHD, MARINE ACADEMY, BSBK,BANGLADESH MADRASAH EDUCATION BOARD, JICA, WATA CHEMICALS LIMITED, JINIYA CONNECT, UNITED NATIONS, UNDP, JRF, ARTICLE,OXYDATA,BANGLADESH HIG TECH PARK, CIC, SPELET, CIRCLE, WOMEN EMPOWERMENT,NITOL-NILOY, E-CAB, BSCCL, BAT, SIEMENS, UNIFON, FU-WANG, GRAMEENPHONE, ROBI, BKASHRFL, BENGAL GROUPS, PRAN, BDJP CONSULTING, JOBBAR< NANMA, MICROSENSE


key: chroma:document
string_value:
Products:
1.TKGL ERP
https://tkgerp.com/
TechknowGram Limited offers its own Enterprise Resource Planning solution called TKG ERP, which can be tailored to meet the unique needs of any business entity, including those in the Construction Industry, Education, Manufacturing, Workshops, and RMG industry. This ERP is developed and supported with the latest 4IR technology.
2.QuizWin
https://quizwin.xyz/
QuizWin is an interactive quiz platform for knowledge enthusiasts, as its name implies.We offer a range of quiz events that users can participate in and potentially win prizes. The leaderboard provides a complete competitive experience.Ideal solution for effectively organize for any Quiz or assessment even.
3.Prostuti
http://prostuti.net/
TechKnowGram has created Prostuti,an exam management platform for institutes to administer exams. The platform was designed with the goal of automating the exam process, which can often be tedious and repetitive. Prostuti simplifies the entire process and provides convenience for both examiners and examinees. It streamlines exam arrangements, management, and attendance, making the entire experience more efficient and user-friendly.
4.KHOZ
https://techknowgram.com/
KHOZ is a recently developed project for Beacon-based Indoor Navigation System that incorporates IoT technology to deliver precise and up-to-date location data to users navigating indoor environments. The system operates by using beacons - small, cost-effective, and battery-powered devices that emit a Bluetooth signal that mobile devices like smartphones can detect. Ideal solution for event management at supermarkets for location and promotions.


key: chroma:document
string_value:
Services:
1.BMS:
The Roads and Highways Department (RHD) of Bangladesh Government is responsible for maintaining and managing the country's road and bridge infrastructure. To ensure the safety and reliability of bridges, the RHD has adopted the use of Bridge Management System (BMS) software. BMS is a comprehensive tool that helps Bridge Management Wing (BMW) of RHD to monitor the health and performance of bridges, assess their performance, and schedule maintenance and repair work. The four key components of a BMS system that the RHD can use to manage its bridges effectively are Bridge Basic Data Input, Bridge Inspection, Bridge Evaluation and Bridge Remedy. Readless
2.Custom Solution Development:
Analysts & Developers of TechKnowGram Limited love creating application and tools to solve your specific business issues but, our first job, as creative software specialists, is to listen you. We want to hear about your business challenges so that we can help you to solve them. Readless
3.Skill Migration Education Investment to Japan, Malaysia:
Skill Migration Education Investment to Japan, Malaysia for Bangladeshi personnel to Japan, Malaysia & Canada. We have 1000+ Japanese Known personnel’s’ CV for Japan market and the Japanese company in Bangladesh. Readless
4.AI AR VR Big Data Robotics IOT:
TechKnowGram is a realising different kinds of AI, IOT, AR, VR, Big Data, Application & Solutions to meet the demands of 4Th 4IR Industrial Revolutions 4IR for IQ, education, sense, risk prevention, advanced tech-enabled gadgets & solutions Readless


key: chroma:document
string_value:
Jobs:
1.Data Analyst
Job Title: Data Analyst
Description:TechKnowGram Limited is looking for Data Analyst for its US Client. Data Anlyst, you will be responsible for Data scrapping, validating and CRM Maintaining.
Skill set:
Strong experience English understanding (reading and Writing) Skill
Experience on Online Marketplace
Strong understanding of Digital marketing and tools
Experience with Team Work
Creative and detail oriented, good at solving problems and deriving solutions
Willing to work in a dynamic environment and keep picking up new technologies / ideas
Strong problem-solving skills and ability to work independently
Strong communication skills and ability to work in a team environment
Education: Bachelor's degree
Apply now at:
TechKnowGram Limited
5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh
Jobs@techknowgram.com
OR /CC
Jobs.tkgl@gmail.com
(Please mention the Job title in Subject Line as Data Analyst)


key: chroma:document
string_value:
2.Senior Angular Software Engineer
Description:TechKnowGTechKnowGram is looking for a Senior Angular Software Engineer for its US Client to join our team and lead the development of our web applications. The ideal candidate will have a strong background in web development, with a focus on Angular, and experience leading and mentoring other developers. In this role, you will be responsible for designing and developing complex web applications using Angular and collaborating with other developers and stakeholders to ensure the delivery of high-quality productsram Limited is looking for Data Analyst for its US Client. Data Anlyst, you will be responsible for Data scrapping, validating and CRM Maintaining.
Skill set:
Design and develop complex web applications using Angular
Lead and mentor other developers on the team
Write clean, maintainable, and efficient code
Collaborate with other developers and stakeholders to deliver high-quality products
Stay up-to-date with the latest developments and trends in web development
Provide technical guidance and support to the team
Strong problem-solving skills and ability to work independently
Strong communication skills and ability to work in a team environment
Education: Bachelor's degree
Apply now at:
TechKnowGram Limited
5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh
Jobs@techknowgram.com
OR /CC
Jobs.tkgl@gmail.com
(Please mention the Job title in Subject Line as Data Analyst)


key: chroma:document
string_value:
3.Senior Flutter Developer
Job Title: Senior Java Developer
Description:TechKnowGram is looking for a Sr. JAVA Developer for its JAPANESE Client..
Skill set:
Strong experience English understanding (reading and Writing) Skill
Experience on Online Marketplace
Strong understanding of Digital marketing and tools
Experience with Team Work
Creative and detail oriented, good at solving problems and deriving solutions
Willing to work in a dynamic environment and keep picking up new technologies / ideas
Strong problem-solving skills and ability to work independently
Strong communication skills and ability to work in a team environment
Education: Bachelor's degree
Apply now at:
TechKnowGram Limited
5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh
Jobs@techknowgram.com
OR /CC
Jobs.tkgl@gmail.com
(Please mention the Job title in Subject Line as Data Analyst)


key: chroma:document
string_value:
4. Job Opportunity in Japan
Job Title: Job Opportunity in Japan
Description:Are you looking for an opportunity to work in Japan?
Skill set:
Are you looking for an opportunity to work in Japan? If so, could you send your RESUME (DOC file only) right away? Whether you are interested in software development, web design, data analysis, or digital marketing, TechKnowGram has a position for you. Don’t miss this opportunity to work in Japan with TechKnowGram. You will have the chance to work on exciting projects with global clients, learn from experts in your field, and enjoy the benefits of living and working in Japan.Apply now and start your journey to success!jobs.tkgl@gmail.com jobs@techknowgram.com
Apply now at:
TechKnowGram Limited
5/9 Block B, Suite B1, Lalmatia, Dhaka 1207, Bangladesh
Jobs@techknowgram.com
OR /CC
Jobs.tkgl@gmail.com
(Please mention the Job title in Subject Line as Data Analyst)


key: chroma:document
string_value:
Contact with us: 
TechKnowGram Limited
5/9 Block B, Lalmatia, Mohammadpur
Dhaka 1207, BANGLADESH
Phone:+88 02 55008199
Mobile/Whatsapp:+88 01819250309
Email: info@TechKnowGram.com
合同会社TechKnowGram
東京都世田谷区尾山台
1丁目10番4号, 日本
Phone:+88 02 55008199
Mobile/Whatsapp:+88 01819250309
Email: info@TechKnowGram.com


key: chroma:document
string_value:
WHAT CLIENTS SAYS:
1. Kinya Ishii:TechKnowGram and Ahmedul worked for us for quite sometime. The whole team of Ahmedul became solution provider. They presenteda remarkable positive attitude. All the work was done in a short span oftime and the team achieved the impossible.
2.Malliga Subramanium:TechKnowGram’s team provided fast and flexible service with considerable expertise. Their unique approach to
assessing feedback helped me solve my problem. Ahmed, their leader, is highly regarded for his unwavering commitment to justice.
3. Kenta Kato:TechKnowGram delivered our work quickly and provided designs that attracted both our clients and partners, while also eliminating the need for a business analyst. They offer a complete solution for all client requirements, making them a valuable asset for any customer.
4.Hirokazu Yoshida:Ahmedul had been brilliant in getting my work done.He and his team are problem solvers and provided a spontaneous vision of how to build on and clarify whatever was requested. TechKnowGram is praised for its ability to develop workable solutions and for its attention to professional service.


