Name: Dr. Apurba K. Saha

Mission: Work as a senior DBA maintaining or designing high-end databases (for fifteen years at Columbia University) for different applications. In addition, possess thirty-eight years of experience in design, analysis & generation or testing of Software applications of various types including system utilities, financial, academic, HR, banking & transportation systems.

Introduction: Apurba Saha got his Ph.D. from Computer Science Dept. at CUNY Graduate Center in 1998. In past he has worked on various database models such as hierarchical, network, relational and object-oriented models. Lately he has been using Oracle, AWS Athena, PostgreSQL, Sybase ASE, SQL Anywhere and also MS SQL Server (V 2008, 2012 etc.), DB2 etc. performing data integrations, BI & data analytics, data visualization, database programming, server/client installations, configurations, performance tuning, migrations, report generation, security setup etc. Lately he had also been engaged in projects like ETL doing data integration from multiple remote sources onto remote target data warehouse using ODI, BI & data analytics & visualization on public Cloud environment, database migration from SAP to MS SQL or adding SSIS & SSRS features, setting up backup/restore process, capturing & analyzing performance monitor data and is highly interested in all aspects of analytics including machine learning. Sometimes he has worked as a member of DBA team along with system administrators, developers & business analyst team. He has acquired AWS Solutions Architect Associate certification and also completed a certification course called “Machine Learning” conducted by Stanford University.

Summary: Create & tune high-performance Database servers, upgrade them to the state of art technology, add further add-on features, monitor & research their performances, ensure their secured operation, design Databases & maintain their quality performances. Design plans & software for suitable Database backups & restorations. Design, analyze & develop or test Software applications on various architectures like client-server, 3-tiers, object-oriented etc.

Contact Address : 450 Island Road, Apt# 15

Ramsey, NJ 07446

Phone no/e-mail : 1-201-***-**** / 1-201-***-**** (USA)

addpn9@r.postjobfree.com, addpn9@r.postjobfree.com

Field of Expertise: Databases, BI/Data Analytics, Data visualization, Data Integration, Application Software, Internet-based Software, GUI Programming, Programming Languages, Data Structures, Operating Systems, Computer Architecture.

Operating Systems used: AWS Cloud, Windows 10, 2008, AIX, Linux, Windows XP, Windows 2003, Windows 2000, VMWare, Oracle Cloud.

Datbases used: Oracle 12C, PostgreSQL, AWS Aurora, AWS Athena, MS SQL Server, Sybase ASE (including 16.0, 15.7, 15.5, 15.0, 12.5 versions), Sybase SQL Anywhere, MS Access, UDB/DB2.

Tools used: SQL Developer, Oracle Express Edition, ETL tools (like ODI Studio, Oracle RCU, Oracle Administration Server etc.), AWS Aurora, AWS S3, AWS Athena, AWS QuickSight, AWS SageMaker, Visual Studio, GitHub, Jira, MS SQL Studio, MS SQL Server Configuration Manager, TSM Client, SSMA tool, Python Anaconda IDE, Oracle Enterprise Monitor (OEM), Service Now, SCCS (SAP Control Center System), DB Artisan, SQL Programmer, Dev-Ops, Sybase Central for Java, Emacs, MS PowerPoint, MS Excel, MS Office, Visual Studio, Google Chrome, Gmail, Outlook, IE, Putty, vi, Winzip/unzip, VPN, Unix tools (awk, sed, tar, sccs, xmail etc.), i-Dashboard, Web-Sphere, Adobe Acrobat, SCOM etc.

Programming Languages used: C#, T-SQL, PowerShell, Python, Perl, Shell (Korn, Bash, Bourne), PL/SQL, MS-DOS Shell, MATLAB, XML/XSL, Java, Java Servlet, Java Applet, JavaScript, VB, C++, C, Pascal, COBOL.

Hardware Architectures used: AWS EC2, P700 Series (IBM), Intel Server (X64, 32-bit), Dell Desktop, VMWare virtual systems on customized hosts using blades, Dell Laptops.

Languages spoken: English, Bengali, Hindi, Spanish.

Educational History:

No

Degree Obtained

Year of Passing

Instituition

Major

1

Ph.D.

1998

Graduate School & University Center, CUNY, NY

Computer Science

2

M.E.

1981

Indian Institute of Science, Bangalore,India

Computer Science

3

B.Tech.

1979

Indian Institute of Technology (IIT), Kharagpur, India

Electronics & Electrical Communications Engg

4

Higher Secondary Degree

1973

Baranagore Ramkrishna Mission School, Baranagore, WB, India

Science

Employment History:

No

Employer

Years of work

Designation

Type of work

1

MLogica Inc.

2019-2020

DBA & Developer

Database monitoring, BI, ETL, Data Integration, Application Programming in C#.

2

JIS University, Kolkata, India

2018 - 2018

HOD, CS Dept.

(Installed Oracle, SQL/Plus, SQL Developer and other tools)

Teach in class like “Database Systems & Programming”, “C++ Programming”.

3

Columbia University, NY, USA

2002 - 2017

Senior DBA

Installing, configuring, securing, monitoring, opening DB servers (Sybase ASE, MS SQL), developing DB utilities etc.

4

ABN Amro Bank, NY, USA

2000 - 2002

Senior Software Developer

Design, Analyze & develop web-based applications using Java, JavaScript, XML/XSL, Web-Sphere etc.

5

Aspen Technology, NJ, USA

1997 - 1999

Software Engineer

Design & develop their optimization software using C++ and encryption.

6

United Parcel Service, NJ, USA

1990 – 1995

Software Developer

Design & develop GUI ERP application programs on OS/2 platform.

Training: . Self-trained on OBIEE, ODI, AWR reports. Completed 80 hours long AWS Solutions Architect Associate course from Udemy Training Institute. Attended a partial training course on “Python Programming” from Coursera. Self-trained on Python programming on data analysis using data structures such as lists, dictionary, tuples and sets etc. Attended complete 11-weeks (Aug ’18 – Oct ’18) online course on “Machine Learning” from Stanford University, CA and obtained pass certificate.

Principal responsibilities (at CUIT):

1.Work on Installing & deploying Oracle ETL tools integration remote data sources with a central Data Warehouse implementing multi-dimensional data and have BI tools run data analytics services for mLogica.

2.Direct (a team) & implement many BI/data analytics projects on Amazon AWS Cloud environment using various AWS services including extended SQL, Python libraries etc. for mLogica.

3.Develop & test scripts to generate various health check & performance reports for AWS Aurora Database in a web-based 3-tier cloud platform for mLogica.

4.Develop multiple object classes in C# using various in-house and .Net libraries & exchange from shared multi-user remote GitHub repository for mLogica.

5.Conduct research on viable open source software platform & libraries for data analytics, data mining & machine learning and compare their pros and cons for mLogica.

6.Install Enterprise edition MS SQL Server (V 2008, 2012, 2014), SSMS; setup connectivity to all other local & servers, setup all key services (like Data Services etc.) with right authentication, setup Server Studio product.

7.Use SSMA tool for migrating data from Sybase to SQL Server. Worked to migrate (& convert) many different projects & applications from Sybase to MS SQL Server platform participating on various phases as hot database migration, post-conversion, data format translation, parallel testing etc.

8.Develop additional scripts (in T-SQL, Korn Shell, Bash, Windows cmd, Perl) to implement exact user security models on SQL Servers as in production Sybase servers or test servers, development servers etc.

9.Regularly schedule automated runs for data access reports (using PowerScript jobs) with request from security control groups.

10.Created AdventureWorks DB and from SQL Data Tools and using SSIS, implemented a project of data integration onto this database.

11.Install & maintain very high performance Open-ended reliable & secured Database server systems (for testing, development, Q&A, production etc.) for various application systems etc. (on a 24/7 schedule), create & maintain their own Databases on behalf of Columbia University . Plan & implement precise Database back-up &, restore systems in order to avoid any data loss. These servers were Sybase V 12.5, V 15.0.3, V 16 SP01 etc.

12.Implement a very precise & high-performance Database monitoring system that will monitor all the existing databases and generate alerts whenever any parameter exceeds normal limits.

13.Work to apply upgrades to Database Systems, Backup software (Third Party) on timely basis.

14.Developed and later maintained various in-house backup, restore scripts (in Korn Shell, Perl, Windows cmd etc.) to add new features (like compression, encryption etc.) and schedule efficient backups/restores using schedulers.

15.Write programs to capture system monitor data, generate various reports like list of costliest queries, CPU utilization report, various costly resources report, unused index report etc.

16.Maintain various utility programs for performing automated error diagnosis & cleaning, DB defragmentation, DB statistics or alert generation, High Availability setup and scheduled them to run on various servers.

17.Support high performance drivers for various applications including JDBC driver, ODBC driver, SybPerl, DBI driver etc.

18.Use new features such as Database clustering, XML data generation, Java functions, PCI & PCA etc.

19.Use various GUI tools for monitoring supported Databases like SCC, OEM, DB Artisan etc.

20.Learn latest changes on MS SQL Server, Sybase and apply them at work.

21.Manage security (server-level, Windows individual or Group level authentication etc.) on servers, generate Data Analytics reports (data access, sensitive data access etc.) on various platforms (like MS SQL Server, Sybase etc.) for various Security teams, monitor performances.

Before Columbia University:

22.Design & develop various international applications on OS/2, MVS platforms using Databases.

Achievements at last Work-place:

Database Systems (presented seminars):

1.Installed ETL tools like JDK, SQL Developer, Oracle 18C Express Edition, ODI Studio 11g, Oracle RCU, WebLogic domain Admin server 10.3. Run all these components to create master & work repository, user schema etc. Followed through specified demo ETL project to migrate data from source repository to remote target repository using complex mapping methods (and data transformations) and pre-built knowledge modules. This is a landmark step to complete before working on full-scale ODI-DW-OBIEE-Oracle Cloud operating environment. Analyzed Oracle AWR report to analyze a query stalled for 4 days. Worked on why index load had been failing in jobs.

2.Directed & implemented three data analytics projects on Amazon AWS Cloud environment using tools like AWS S3 (repository for data), Athena (for data preparation & analytics), QuickSight for data visualization and building dashboards and GitHub repositories. In one of these projects directed the team into building application in AWS SageMaker (using Jupyter Notebook, SciKit-Learn toolkit, Python, Dockers) using ML models to learn and then predict future stock prices.

3.Develop scripts to generate various health check reports in AWS Aurora Database in a web-based 3-tier cloud platform. Write up a final report on recommendations about databases in the project.

4.Developed & tested many object classes in C# using various in-house and .Net libraries & exchanged with centralized shared multi-user remote GitHub repository after merging conflicts.

5.Make a list of a few recommended viable open source software platform & libraries for data analytics, data mining & machine learning which included items like GreenPlum DB, TensorFlow, Keras, SciKit-Learn etc.

6.Successfully migrated many application databases from Sybase to MS SQL Server.

7.Setup post-migration T-SQL procedures in order to generate comparison data analytics reports comparing databases on MS SQL Server and Sybase server.

8.Created many Windows scripts for daily/weekly full, transaction backup/restores (TSM level or native) (and many other types) for various databases on MS SQL Servers.

9.Created Windows PowerShell scripts for generating consolidated Excel spread-sheet full data access reports on all MS SQL servers (local or remote) for all sensitive data.

10.Installed & configured Sybase ASE, Backup, XP, Monitor servers (versions 11.5, 12.5,15.0.3, 15.7, 16) some being on AIX, some on Linux, some on Windows platforms. Applied upgrades & patches. Enhanced various startup options in server start-up jobs. Ran ‘bldsrv’ utility to re-build server using either GUI or resource file.

11.Installed Sybase ASE 16 and observed server operation after setting kernel mode to ‘thread model’ or ‘process model’.

12.Installed & tested job scheduler within Sybase ASE 16.

13.Migrated all in-house utility jobs to run with ASE 16 and have them co-exist with ASE 15 jobs.

14.Installed & configured ASE client and also ASE SDK (Software Developer Toolkit). Worked with users to run all the client utilities like ‘bcp’, ‘isql’, ‘optdiag’, ‘ddlgen’, ‘defncopy’ etc.

15.Installed & configured BMC Recovery Manager (from BMC Software Co) as the Backup/restore Software on all DB servers. Later upgraded & tested Backup/Restore Software to most current version on some servers. Later, switched to IBM TSM backup/restore system.

16.Installed OEM 11G client & configured OEM (Oracle Enterprise Manager from Oracle) 11G server to monitor various parameters on our servers and their hosts so that when any parameter value exceeds pre-set limits (can be changed) then alerts (as email or text or phone messages) are generated for responsible parties. Installed OEM 12C client on some ASE servers.

17.Installed SCC (SAP Control Center) server (another DB monitor from SAP) & configured it on Linux platform to monitor various parameters on our DB servers so that when any parameter value exceeds set limits (can be changed) then alerts (as email or SMS or phone messages) are generated for responsible parties. For this purpose, scripts were written in Bash on Linux (Redhat server).

18.Developed & implemented monitor data capturing into historical database for almost all of the monitor tables. Developed many programs to generate various reports to be sent by emails to important developers on a daily basis.

19.Performed Disaster Recovery (DR) test for bringing up some application databases on a remote alternate site on an emergency schedule.

20.Implemented “password encryption” restriction on all database server for additional security.

21.Implemented various changes including password restriction rules to make our servers SOE (CUIT Standard Operating Environment) guideline compliant.

22.Implement resource governance on a server and setup various limits violating which messages would be posted into server log.

23.Installed Sybase ASE on Windows, created, designed & implemented DARTS Database.

24.Installed third-party software ‘i-DashBoard’ on a Windows 2000 server and hooked up with Sybase server and implement a full DWH dashboard display on GUI as a proof of concept.

Design & Development (papers presented at Columbia University seminars):

1.Added many new features to enhance in-house DB backup/restore scripts like sending alerts in case of failure in backup/restore jobs for example.

2.Created script for auto-tracking of Sybase backups using script.

3.Created high-level start-up & shut-down jobs for various Sybase servers in-house. Created one automated start/stop script (using Korn shell on AIX) that will start/stop all (or a few selected) servers on current LPAR (or host) and it can be run as part of host reboot.

4.Developed 3 different reports to display costly resources report, high CPU-intensive query report, high elapsed time-bound query report (in Excel spreadsheet form) automatically for a DB server on a daily basis.

5.Developed one report for unused indexes on application databases on a monthly basis. This report will list all indexes on various application databases that were not used for a month.

6.Developed one report for indexes that were unused on application databases continuously over a few (to be set) months. In addition, it will also list the number of contiguous months the index was not used.

7.Developed a utility program that will list all ‘dbcc checkdb’ errors in all application databases. Then it will try to correct those errors. Finally, it will display all the remaining errors that escaped correction.

8.Developed a program to defragment tables in one or more databases using various options. It may be opted to defrag some top used tables or defrag some most fragmented table or defrag some selected tables or all tables.

9.Developed a program to compute CPU utilization for each engine on captured monitor data.

10.Developed script for stripped/compressed backup/restore for DARTS.

11.Developed a program for checking error messages in server log and report as emails.

12.Developed a program for accepting a http request and retrieving data in XML format for web client.

Before Columbia University:

13.Design & develop international ACH payments application using Java/JDK. Build web-based 3-tier application made of EJBs, Java Servlets using XML, XSLT, DOM on WebSphere Application Server for ABN Amro Bank. Design & develop in-house library on OS/2 platform using C++ and Windows GUI toolkit library, DB/2 library for UPS. Developed application using SmallTalk/OS2 for UPS Company. Developed multi-national multi-currency Accounts Receivable systems using IMS DB on mainframe for American Express credit cards system.

Group Presentations:

1.Made presentations to our user group of FFE project on new features of ASE 15.7.

2.Every fortnight conduct user group meeting on all relevant updates on Database issues.

Conference presentations:

1.A proposed architecture of Intelligent Networks & its application in knowledge searching.

2.Principles & Architecture of Monitor Data Capturing, Sybase ISUG, 2014.

3.Submitted paper on “Adapting Monitor Data Capturing for ASE 16”, but was late.

4.Participated in a yearly conference on “Information Retrieval Systems” and conducted two sessions on 1) software components of Relational Database Systems, and 2) Algorithms used for query optimization in RDBMS. This conference had commenced at Calcutta Mathematical Society from Dec 5-6, ’18.

5.Conducted a seminar on “Automated Driving” at Indian Statistical Institute, Kolkata, India on Dec 24th, ’18.

Sybase webinar & Sybase user group seminars:

1.Attended ISUG 2014 conference on Sybase ASE, Replication Server, SAP HANA.

2.Attended ISUG 2015 conference on Sybase ASE architecture on upcoming versions.

3.Attended webinars on high volume Data Analytics.

Ph.D. Thesis topic:

A proposed knowledge Retrieval mechanism using knowledge searching on Intelligent Networks.

Past projects:

1.Developed banking applications on web-site for ABN Amro Bank (Java/JavaBeans).

2.Developed Package Management Software for AT&T (C/C++).

3.Developed Software for Engineering operations for AT&T (C/C++) (1 year).

4.Developed GUI-based software for optimal load distribution for a transportation Company (UPS) (C/C++) (5 years).

5.Developed multi-national multi-currency software for A/P system for American Express.

Academic Projects:

1. M.E. project : Design of a relational Database Management system on PDP 11 (Pascal).

2. Ph.D. project: Development of GUI based software using Unix/C/C++/Motif.

Contact this candidate