Bibek Mondal

Experience

• 

  Abcon Technologies Pvt. Ltd.

  Jul 2002 - Feb 2003

  Programmer

   To perform database designing for Paramount Hospital Pvt. Ltd. (Including Inpatient, Out-Patient, Diagnostics, Billing & etc.) To create data entry forms for different Masters, Transactions and to design MIS reports.

• 

  Cyber Craft

  Feb 2003 - Feb 2004

  Senior Developer

   To perform database designing for Sanjoy Beverages, Drangchu Beverages (Pepsi - Bhutan), Supreme Oil Industry (I) Ltd. To create procedures to handle complex business logic for data manipulation and MIS reports.

• 

  Euphoria Infotech (I) Pvt. Limited

  Feb 2004 - Sept 2006

  Senior Developer

   To perform database designing for Calcutta Telephones (BSNL) and West Bengal Telecom Circle (BSNL) To create packageso Which automatically handles inventory stock statistics.o To calculate temporary disconnection able mobile numbers.o To calculate reconnection of eligible mobile numbers.o To calculate agent commissions with given date parameter.o To calculate PF, EPF in payroll system.o To generate pay slip for each employee in payroll system. Actively involved in project planning and application development. Show less

• 

  Pss IT Services Private Limited

  Oct 2006 - Jan 2007

  Senior Developer

   To create various Oracle database packages to support font end ASP.Net forms/pages and to create Report from back end (as a text file output)

• 

  Total Solution Group

  Feb 2007 - May 2007

  Consultant Oracle

   To create various procedures to collect data and aggregate data to produce data to warehouse data. To perform data pulling with business logic in 114 global servers through custom procedure.

• 

  Intellicus Technologies

  May 2007 - Aug 2015

  Lead Software Engineer- PL/SQL Oracle

   To spearhead a team of 5 members and responsible for the entire backend or database development. Proficient in developing the semantic and dynamic schematic models of Data Warehousing Project which is auto-discovery in nature and contains nested tables. Demonstrated outstanding expertise in creating various packages to perform dynamic schema creation, dimension data with configurable and dynamic set of roles, to rebuild all indexes automatically, to compute aggregate statistics for mobile and to automatically partition tables etc. Adeptly planned, coordinated and managed to tune around 100 database schemas which includes a minimum of 6 GB to 15 GB of fresh data for each database daily. Accountable for reporting daily status and to resolve client’s queries promptly to ensure satisfaction. To create various types of DBMS SCHEDULER jobs to automatize the database event/process handling. Show less

• 

  Milliman

  Sept 2015 - Jun 2017

  Senior Datawarehouse Specialist

   Provide professional service to clients to implement and customize client data to fit for industry. To perform data auditing and data profiling as a major task for a Medical Insurance Domain.

• 

  Intellicus Technologies

  Jul 2017 - Apr 2022

  Associate Architect

  Database architect, big data Hadoop, data warehouse, AWS, EMR, S3 and BI solution architect.I am responsible for end to end data flow like source data to ETL, ETL to data warehouse and OLAP/BI consumption layer. And, fully responsible for database development and management (Database architect).

• 

  Confidential

  May 2022 - now

  Senior Architect

  Technology Head - AI driven solutions