RUMA DUTTA (B.E. / M.E. / Ph.D.)

Address:BC-***, Salt Lake, Sector - 1, Kolkata - 700064

E-Mail:adoa42@r.postjobfree.com / Mobile: +91-916**-*****, +91-33-233*-****

Seeking assignments as Data Scientist / Research Specialist / Training Manager /Project Manager Research & Development ~Data Mining ~DataWarehousing ~Web Mining ~Database Applications

EXECUTIVE SUMMARY

Ph.D. (Engineering) )with over 27 years of in-depth & extensive experience involvi over 10 years in the field of Technical Consultancy, Software Development, Project management and nearly 17years in Teaching, Research & Development, Training and Administration in a reputed Educational Institution.

Associated with NetajiSubhash Engineering College, Kolkata as Associate Professor.

Expertise in managing Data Research activities including Data Mining, Data Warehousing, Web Mining, Database applications, etc.

Holds insightful exposure of working with some leading Corporate Houses including PricewaterhouseCoopers India Ltd., ORACLE Corporation, Tata Consultancy Services, etc.

Experience in end-to-end monitoring / trackingof projects with respect to budgeted cost, demand forecasts, time over-runs to ensure timely execution of projects.

Possesses demonstrated experience & skills in developing curriculum to accommodate different learning styles & maximizing students’ comprehension.

Strong acumen in facilitating/coaching engineering students by using interactive discussions and “hands-on” approaches to help students learn and apply concepts in subjects.

Dedicated & self motivated leader with strong interpersonal skills to relate to teachers/students at all levels.

TECHNICAL SKILLS

Programming Language / Scripts / Templates: C, COBOL, PL/SQL, Java, Python

Development Tools / IDE: Developer 2000, TOAD, Visio

CASE Tools: ERwin

Configuration Management Tools: Microsoft VSS, PVCS

RDBMS: Oracle, SqlServer 2000, DB2

OLAP Tools: Oracle Discoverer, MS Analysis Services 2000 CRM Tool: Siebel

Operating System: Windows, UNIX

Platform: Intel

Data Miner Tool: Oracle DataMiner

EXPERIENCE FORTE

Since Jan’03 NetajiSubhash Engineering College, Kolkata

Growth Trail

Jan’03 – Jan’04 Lecturer

Feb’04 – Jan’08 Senior Lecturer

Jan’08 – Oct ‘11 Assistant Professor

Jun‘10 – Apr ‘11 HOD, CSE

Nov’11 – Apr’20 Associate Professor

Key Responsibilities

Strategic Management/ Operations

Supervising and managing the overall administration & operations in the department, ensuring compliance with policies and regulations.

Administering the contracts and taking care of fund granting, approving and monitoring budget expenditures; preparing status reports.

Networkingand teaming upwith students, parents, and the community to build an environment that maximizes learning, academic performance, and social growth.

Teaching & Tutoring

Teaching and guiding as per academic curriculum to students, recognizing & nurturing the creative potential of each student.

Organizing exercises, questionnaires and assignments for students at various levels; responding to the queries in a spontaneous manner.

Assessing students' work for internally assessed components of qualifications; observing students' work, behaviour, maintaining records and writing reports on students.

Research and Development

Leading the R & D operations & modification of existing ones, based on market feedback & trends. Facilitating method development and validation i.e. rigorous testing of the methods to ensure that they are precise, accurate, reproducible, "fool-proof" and specific to the product, etc.

Accomplishments

Supervised the overall administrative activities of the department and ensured its smooth functioning. Successfully organized various activities for Infosys Campus Connect Program, an Industry Academia initiative of Infosys.

Taught and mentored the post graduate students leading to contribution in research papers. Oversawand contributed in the research papers of the research scholars.

Actively participated in various symposiums, delivered numerous seminars, travelled overseas & authored several research papers and played with vast success and abilities in planning, directing and coordinating various aspects of the operating area.

Past Employment

Dec 1997 to Sep 2002 PricewaterhouseCoopers India Ltd., Kolkata as Consultant Jan 1996 to April 1996 ORACLE Corporation in USA as Developer

Mar 1994 to Nov 1997 Tata Consultancy Services, Kolkata

Growth Trail

Mar 1994 to Mar 1995 Associate System Analyst

Apr 1995 to Mar 1997 System Analyst

Apr 1997 to Nov 1997 Senior System Analyst

Apr 1991 to Aug 1991 ADA Software Pvt. Ltd., Kolkata as Associate System Engineer Mar 1990 to Jan 1991 DPS Software Ltd., Kolkata as Associate System Engineer

Accomplishments:

Managing overall operations for executing projects involving scoping, design & architecture & sourcing. Monitored and resolved all the important issues, defining best practices for the overall project support and documentation.

Ascertained networking with the client & system engineering team for the requirements gathering and scoping. Managing the designing and architecture solution for the product; handling process setup & undertaking code review, debugging & troubleshooting software.

Efficiently extended the post go-live and application maintenance support to the client. Successfully handled IT operations and other related business units; mapping business processes and studying workflow to design solutions.

Ensured the business functionality adherence and enhancing competitive advantages. Mapped and undertook the business planning, forecasting and analysis for assessing revenue potential in opportunities.

Consistently monitored the projects with respect to different risks ensuring timely execution of projects. Efficiently developed and designed the solution for the product.

TECHNICAL COURSES AND TRAININGS

Underwent various Technical courses and Trainings such as: Oracle DBA (SQL star)

COGNOS (PwC India)

Business Warehouse (PwC India)

Siebel (PwC India)

Data Warehouse Bootcamp (PwC India)

Internal Audit (PwC India)

ACADEMIA

Developer 2000 and Oracle 7 (TCS) Visual Basic (TCS)

COBOL, C, Data Structure (DPS) Probationer’s Training (TCS) includes structured Analysis and Design, C++ and object oriented methodology.

2010 Ph.D.(Engineering &Computer Science) from Jadavpur University

1994 M.E. (Computer Science &Technology) from B.E. College (IIEST, Shibpur), Calcutta University 1989 B.E. (Electrical) from B.E. College (IIEST, Shibpur), Calcutta University

THESIS WORK

Completed Thesis on the topic Offering New Web Services for Efficient Web-Page Prediction

RESEARCH WORK

Research aimed at to proposing different techniques for Web-page prediction to enhance prediction accuracy in different application area. These techniques also keep memory requirement low. Research also involved product recommendation, heterogeneous distributed environment, demand forecast etc.

ParthaGhosh, ChameliDebnath, DipjyotiMetia, Dr. Ruma Dutta. An Efficient Hybrid Multilevel Intrusion DetectionSystem in Cloud Environment. IOSR Journal of Computer Engineering (IOSR-JCE).Vol.16, Issue 4, pp.16- 26(2014).

SushantaSengupta, Ruma Dutta, “ Comparative Study of Demand Forecast Accuracy for Healthcare Products Using Linear and Non Linear Regression”; International Journal of Business and Management Invention; Volume 3, Issue 5, pp 1-10; May 2014.

ParthaGhosh, RiaGhosh, Ruma Dutta, “An Alternative Model of Virtualization-based Intrusion Detection System in Cloud Computing” ; International Journal of Scientific & Technology Research; May, 2014. SushantaSengupta, Ruma Dutta,”Identification of Demand Forecasting Model Considering Key factors In the Context of Health Care Products”; International Journal of Application or Innovation in Engineering & Management; Volume 3, Issue 3, pp.365-369;March 2014.

Ruma Dutta, AnirbanKundu, DebajyotiMukhopadhyay, “Clustering based Web Page Prediction” ; International Journal of Knowledge Engineering & Web Intelligence;Inderscience Publishers. Volume 2 No. 4; pp. 257-271; 2011. Ruma Dutta, AnirbanKundu, RanaDattagupta, DebajyotiMukhopadhyay; “An Approach to Web Page Prediction Using Markov Model and Web Page Ranking”; International Journal of Convergence Information Technology; Korea; Vol.4, No.4; December 2009; pp.61-67. in 2009.

Ruma Dutta, IndranilGhosh, AnirbanKundu, DebajyotiMukhopadhyay; “An Advanced Partitioning Approach of Web Page Clustering utilizing Content & Link Structure”; International Journal of Convergence Information Technology; Korea; Vol.4, No.3; September 2009; pp.65-71 in 2009.

AnirbanKundu, Ruma Dutta, RanaDattagupta, DebajyotiMukhopadhyay; “Mining the Web with Hierarchical Crawlers - A Resource Sharing based Crawling Approach”; International Journal of Intelligent Information and Database Systems; Inderscience Publishers; UK; Vol.3, No.1, 2009.

AnirbanKundu, Ruma Dutta, DebajyotiMukhopadhyay; “Design of SMACA: Synthesis & its Analysis through Rule Vector Graph for Web based Application”; International Journal of Intelligent Information and Database Systems; Inderscience Publishers; UK; Vol.2, No.4, 2008; pp.397-421 in 2008.

DebajyotiMukhopadhyay, Ruma Dutta, AnirbanKundu, RanaDattagupta; “A Product Recommendation System using Vector Space Model and Association Rule”; 11th International Conference on Information Technology, ICIT 2008 Proceedings; Bhubaneswar, India; IEEE Computer Society Press, California, USA; December 17-20, 2008.

Ruma Dutta, AnirbanKundu, DebajyotiMukhopadhyay; “Offering Memory Effciency utilizing Cellular Automata for Markov Tree based Web-page Prediction Model”; 10th International Conference on Information Technology,

ICIT 2007 Proceedings; Rourkela, India; IEEE Computer Society Press, California, USA; December 17-20, 2007; pp.252-257 in 2007.

AnirbanKundu, Ruma Dutta, DebajyotiMukhopadhyay; “Converging Cellular Automata Techniques with Web Search Methods to Offer A New Way to Rank Hyper-Linked Web-Pages”; International Symposium on Information Technology Convergence, ISITC2007, Jeonju, Korea; IEEE Computer Society Press, California, USA; November 23- 24, 2007; pp.291-295 in 2007.

AnirbanKundu, Ruma Dutta, DebajyotiMukhopadhyay; “Generation of SMACA and its Application in Web Services”; 9th International Conference on Parallel Computing Technologies, PaCT 2007 Proceedings; Pereslavl Zalessky, Russia; Lecture Notes in Computer Science; Springer-Verlag, Germany; September 3-7, 2007; LNCS 4671 pp.140-152 in 2007.

AnirbanKundu, Ruma Dutta, DebajyotiMukhopadhyay; “An Alternate Way to Rank Hyper-linked Web Pages”; 9th International Conference on Information Technology, ICIT 2006 Proceedings; Bhubaneswar, India; IEEE Computer Society Press, California, USA; December 18-21, 2006; pp.297-298 in 2006.

AnirbanKundu, Ruma Dutta, DebajyotiMukhopadhyay, Young-Chon Kim; “A Hierarchical Web Page Crawler for Crawling the Internet Faster”; International Conference on Electronics & Information Technology Convergence, EITC 2006 Proceedings; Yang Dong Publication; ISSN 1975-809X; Republic of Korea; December 8, 2006; pp.61-67.

Ruma Dutta, AnirbanKundu, DebajyotiMukhopadhyay, Young-Chon Kim; “An Alternate Approach for Efficient Web Page Prediction”; International Conference on Electronics & Information Technology Convergence, EITC 2006 Proceedings; Yang Dong Publication; ISSN 1975-809X; Republic of Korea; Dec 8, 2006; pp.197-203 in 2006.

DebajyotiMukhopadhyay, AnirbanKundu, Ruma Dutta, Young-Chon Kim; “An Idea To Minimize Memory Requirement and Redundancy Adopting Cellular Automata While Building Index File By Web Search Engine”; 6th International Workshop MSPT 2006 Proceedings; Youngil Publication; ISBN 89-8801-90-0, ISSN 1975-5635; Republic of Korea; November 20, 2006; pp.67-79 in 2006.

DebajyotiMukhopadhyay, Ruma Dutta, AnirbanKundu, Young-Chon Kim; A Model for Web Page Prediction using Cellular Automata; The 6th International Workshop MSPT 2006 Proceedings; Youngil Publication; ISBN 89-8801- 90-0, ISSN 1975-5635; Republic of Korea; November 20, 2006; pp.95-100 in 2006.

PROJECTS SUPERVISED

Sl. No.

Year

Student Name

Thesis Title

1

2015

Mr. Amitava Jana

An Approach to Association Rule Mining Using Correlation Coefficient

2

2014

Mr. AmritChowdhury

Web Page Prediction Using Hidden Markov Model

3

2014

Mr. Rudra Prasad

Chatterjee

Web Page Prediction Using Association Rule Mining

4

2013

Ms. Swagnika Roy

Web Page Prediction Using Neural Network

5

2013

Ms. SoumiBasak

Design and Implementation of a Parallel Web Crawler

6

2013

Mr. Mainak Nandi

Web Page Prediction Using Pairwise Sequence and frequency occurrence

7

2012

Ms. SnigdhaMazumder

Offering Memory Efficiency Using Cellular Automata and its application in Web page Prediction

8

2011

Ms. DebjaniSinha

Automatic Schema Matching between Heterogeneous Databases having Semantic Relations

9

2011

Ms.SomsuklaBhaduri

An Approach to vertical Fragmentation in Distributed database Systems

10

2010

Mr. SubhojitGhosh

Comparative Study of Hyperlink Text Analysis

11

2010

Mr. RakeshRanjanDey

Structured Data Extraction

12

2010

Mr. IshanGhosh

Web Page Prediction Using Neural Network

13

2009

Mr. SumanSaha

Priority Search Engine

14

2008

Mr.

SabyasachiChakraborty

Web Page Prediction

15

2008

Mr. IndranilGhosh

An Approach to Web Page clustering

PERSONAL SNIPPETS

Date of Birth 9th March 1967

Please refer Annexure for Project Details:

ANNEXURE

PROJECTS HANDLED

Duration: Nov’01 –Apr’02 Project:Development of Advertising data mart For ABP Ltd. Role: Project Leader

Involved in the project from design to implementation.

The aim of the project was to develop an advertising data mart which involves development for volume and revenue analysis of classified and display ads as well as ads in magazines.

The source system was on ingres from which data was extracted to Sqlserver staging area. Sql server staging area data was loaded into SQLserverDatawarehousethorugh DTS package and T-SQL procedures.

Then the cubes were loaded which are created through Analysis services.

From cubes data is accessed by Excel 2000 front end.

The team had made some canned reports which will be accessed by end user through Internet Explorer. Technical Environment: Erwin, SQLServer 2000, DTS, T-SQL, Analysis Services, IIS

Duration: Sep’01 – Oct’01 Project:Development for Resorts Condominium International Technical Environment:DB2, Stored Procedure, VB

The Project was the development of VB screens in Windows NT which talks to DB2 database in Mainframe with COBOL acting as Middle tier. Ruma was the leader in Infrastructure and configuration management. She was also involved in writing Stored Procedures. Ruma also acted as DBA in Windows NT.

Duration: Jul’01 – Aug’01

Involved in writing procedures for datawarehousing and data mining practice as PwC is going for SEI CMM certification in this area. Ruma was leading a team of 4 Consultants.

Duration: Jun’01 – Jul’01 Project:Siebel Prototype Development for Pharmaceutical Industry Role: Team Leader

The objective of the prototype was to implement a Siebel eBusiness application to provide a sales application for Pharmaceutical industry.

During the prototype design and development Ruma was involved in business analysis as well as development of Siebel application (screenflow diagram, data loading using Enterprise Integration Manager, defining workflow and assignment rules).

Duration: May’01 – Jun’01 Project:Siebel Prototype Development The objective of the prototype was to implement a Siebel eBusiness application to provide a complete, integrated system capturing, processing, storing, retrieving and reporting all information related to customer and prospect interaction with the company.

The scope of the integrated system was the Incoming Calls Group (ICG), Telesales, Field Sales, Literature Fulfillment and Order Fulfillment.

During the prototype design and development, involved in business analysis as well as development of Siebel application (screenflow diagram, data loading using Enterprise Integration Manager, defining workflow and assignment rules).

Specifically involved in loading data from csv files using SQL Loader into the Siebel EIM Interface tables and then running a Server Task to populate the Siebel User Tables.

These steps also included mapping the source data to the Siebel User Tables, identifying the columns to be loaded and then finding the relevant interfacing tables.

Environment:

Operating System : Windows NT ver 4.0 sp 6,Win98

Database : Oracle ver 8.1.6

Client Development Tool : Siebel Tools/Siebel 2000

Duration: Nov’00 – Mar’01 Project:Financial Accounting System for Department of Power, Bhutan

Role: Module Leader of the Energy Accounting System of the project.

The system takes Audit meter reading as input, calculates the output as summation of the consumption as collected from billing system and calculates the technical loss as well as commercial loss for better control of the electrical system.

For calculating the technical loss, switching information had to be entered and that determines actual time of energization of different equipments.

Analyzed the client requirement and implement those in the system. Being an Electrical Engineer Ruma could apply functional knowledge to fulfill the client requirement.

Leveraged prior experience in Energy Accounting system in this project. She was also involved in testing of other modules, which enriches her knowledge of business processes.

Technical: Developer 2000, Oracle 8, PL/SQL

Duration: May’00 – Nov’00 Project:Retirement Benefit Management System for Calcutta Electric Supply Role: Project Leader

Led team of 5 Consultants and regularly kept track of the progress of the project.

The project consists of 8 modules, they are Refundable Loan, Non refundable withdrawal, Investment, Life Insurance Premium, EDLI, Group Saving Linked Insurance, Settlement, Senior Staff Provident Fund. It was a very complex project. Applied her experience in understanding system and was involved in system testing, acceptance testing of the eight modules.

Involved in preparing system test plan and acceptance test plan and time-to-time she has given her feedback to respective team members.

Actively involved in creating database and installing the software in client’s place before starting the acceptance testing.

During acceptance testing she has interacted with the client and made them comfortable with the system. Also maintained Quality Records of the project as part of project management.

Technical Environment: Developer 2000, Oracle 8, PL/SQL

Duration: Nov’99 – Apr’00 Project:Energy Account System for Dishergarh Power Supply Role: Module Leader

Led a team of 4 Consultants. The system calculates technical loss as well as commercial loss location wise, voltage wise and equipment wise.

This is a system where complete knowledge of Electrical Engineering could be applied. Involved in low-level designing, construction and testing phase.

Took active participation in preparing acceptance test plan.

Being a senior member in the team, has guided other members in the team technically. Technical Environment: Developer 2000, Oracle 8, PL/SQL

Duration: Apr’99 – Oct’99 Project:Data Ware Housing project for Dishergarh Power Supply The project is to develop a Management Information System using data warehousing methodology. It has different modules as Energy Accounting System, Materials Management system, Billing and Collection system, Customer Enquiry System and Work Order Monitoring system.

Involved in analysis, design and construction of Customer Enquiry system and Work Order Monitoring System. Actively involved in data model design using star schema methodology and design, construction of the extraction, loading programs.

Used Discoverer 3.1 before, guided other team members to use the tool and also used it as front end development tool.

Applied her knowledge of business processes of the OLTP system implemented in Dishergarh Power Supply. Technical Environment: Erwin, Discoverer 3.1, Oracle 8, PL/SQL

Duration: Nov’98 – Mar’99 Project:Management Information System for Dishergarh Power Supply Involved in analysis, design of the project. Worked as Technical Expert in this project

Actively involved in understanding all modules implemented in Dishergarh Power Supply. Prepared the Requirement Definition Document compiling understanding of the system. Led the team in designing the system and prepared System Design Document.

Technical Environment: Discoverer 3.1, Oracle 8, PL/SQL

Duration: Apr’98 – Oct’98 Project:Empower for Dishergarh Power Supply Involved in Construction of Materials Management System.

Gathered business process knowledge of MMS. She has constructed several stored procedures and forms 4.5 and reports 2.5.

Technical Environment: Developer 2000, Oracle 7.1, PL/SQL

Duration: Dec’97 – Mar’98 Project:Quality Group

Role: Quality Coordinator

Coordinated all quality activities such as review of documents in PricewaterhouseCoopers, India. Responsible in maintaining all QMS documents.

Duration: Dec’96 – Nov’97 Y2k Tool Design, Development Analysis, Design, Development, testing of Y2K tool for C language.

The tool takes C program file as input and detects all date fields which can be seen through various reports. Actively involved in writing and reviewing of System Requirement Specification, System Design Document, and Test Plan, etc.

Technical Environment: C, PRO*C,LEX,YACC in UNIX, ORACLE7.1

Duration: May’96 – Nov’96 Project:Quality Group

Role: Reviewer in Quality Group.

Actively involved in Facilitation to projects about TCS QMS procedures and responsible of activities like reviewing various documents including system test plan, system design document, quality plan.

Worked as External Quality Tester of many projects.

Duration: Jan’96 – Apr’96 Project:Developing Credit Control System for CCA, USA. Actively involved in making prototype for CCA, USA using Developer 2000, mainly Oracle Graphics and Oracle forms 4.5.

Made some forms using Designer 2000.

Involved in loading the data from COBOL system to ORACLE.

Written some stored procedures using PL/SQL and witten some programs using Pro*C. Also involved in documentation.

Technical Environment: ORACLE 7.2,DESIGNER 2000, DEVELOPER 2000,PL/SQL,Pro*C

Duration: Nov’94 – Dec’95 Project:Maintenance of Fixed Deposit System for Tata Tea Responsible to enhance and maintain the system according to client’s requirement.

Technical Environment: VMS-COBOL

Duration: Apr’94 – Oct’94Project:Maintenance of Planning and Production System for Steel Authority of India Description: The project consisted of two modules one for Central marketing office and another for regional offices. Involved in Central Planning and production system.

Responsible to enhance and develop the system according to client’s requirement.

Technical Environment: ORACLE 6.0, Pro*C,SQL

Duration: Apr’91 – Aug’91 Project:Tool Development for Microsoft. Involved in development of the tool for DOS which functioned like AWK in Unix system. The tool takes the program written in the language same as AWK language in UNIX as input and processes it and does the activity specified in the Language.

Technical Environment: C, LEX, YACC

Duration: Mar’90 – Jan’91 Project:Software Development in DPS Software Ltd. Involved in construction of various systems like payroll system, insurance system using COBOL. Involved in maintaining a software, which acts like Index Sequential Access method in COBOL for C file. Technical Environment: COBOL, C, UNIX

Contact this candidate