RESUME

Sumit .B. Dundale.

Mobile : +919*********

E-mail ID : adik58@r.postjobfree.com

Permanent Address: Gurukrupa Colony Dighi Road Bhosari Pune - 411039.

Career Objective

To secure Mid level position as IT professional that would entrust me with leveraging SQL/ORACLE Database and Linux administration skills to deliver lucrative results for rapid-growth corporations.

Academics

Degree

Year of Passing

Institution

Board/

University

Percentage

MCS

(Comp Sci)

2017

PCCCS.

Pune University

60 %

BCS

Apr 2015

PCCCS College

Pune University

51 %

H.S.C

(Science IT)

Feb. 2009

Dr. D.Y. Patil College

Pune University

52 %

S.S.C.

Mar. 2007

S. M. V School

Maharashtra State Board

73 %

TECHNICAL SKILLS

Languages : SQL, PLSQL, SQL loader,

Databases : SQL DB, ORACLE 11g DBA, Influx DB, Snowflake DW

Database Administration : Database architecture, Administration, RMAN Cloning.

Platforms : Linux (RedHat & ORACLE 11g), Windows 8.1

Tools & utilities : Export/Import, expdp/impdp (data pump),

Grafana, AWS

Other Software's : SQL server 2014/12,

Visual Studio 2013, AWS redshift

TRAINING & SUMMARY

Completed ORACLE DBA training from focus Datatech pvt ltd.

Oracle SQL/PLSQL -

Strong knowledge of Oracle 9I, 11G SQL commands

Hands-on experience on writing SQL queries using JOINS.

Knowledge of SQL Set operators like UNION, MINUS, INTERSECT

Transaction control (TCL operations) using Commit and Rollback.

Good understanding of Oracle locking during DML operations – Insert,

Update, Deletes, Strong in SQLPLUS.

Know-how of loading data into Oracle tables using SQL loader.

Ability to identify data loading errors using Bad file,

Discard files and Log files.

Sound knowledge of Oracle SQL DDL Operations like Create, Alter, Drop.

Knowledge of other oracle objects like Sequence,

Synonym, Views, Indexes.

Good knowledge about STORED PROCEDURE, TRIGERS, Functions, view.

Creating INDEXES and checking for performance optimization.

Admin 1 & 2 -

Have working knowledge of Oracle installations.

Have working knowledge of Oracle Database Architecture (10G/11G).

Have working knowledge of User Management.

Have working knowledge of Table space Management.

Have working knowledge of Control files Multiplexing,

Log files multiplexing.

Have working knowledge of Oracle Networking Configuring

(Listener.ora & Tnsnames.ora file).

RMAN Cloning the database server, backup based and active based.

Have working knowledge of Password file Management,

DB Link connectivity

Have working knowledge of Data Pump, Data pump using Network Link.

Influx DB (Time series database)-

It is used for High availability storage and retrieval of time series data in fields such as operations monitoring

Creating data visualization and real time data analytics using grafana.

Monitoring time series data and creating dashboards using Grafana.

Snowflake DW-

Loading data into snowflake DW.

Creating virtual data warehouses and loading data as well as run the queries also capable of doing both of these tasks concurrently.

Using sigma computing performed data visualization and real time data analytics.

PROFESSIONAL EXPERIENCE

Overall 3+ years of experience in SQL,PLSQL, SQL server /ORACLE DBA .Competent diligent and result oriented professional offering over Newscape Consulting pvt ltd in ORACLE/SQL DBA.

Company Name

Role/Description

Total Experience

Newscape Consulting Pvt. Ltd

Oracle application DBA / Developer

Current Working Company 9 months

Prognosticsoft Solutions Pvt. Ltd

SQL Database Developer

1 Year 6 Month

Concentrix Daksh Services

US Healthcare Query Support

1 year 6 Month

PROJECTS & INITIATIVES

Project Name- patient billing System (ADMI-PBS)

Technology- SQL server 2018,

Role and Responsibilities-

Creating SQL server configuration, installation and load full setup.

Creating source data to target data mapping.

Writing stored procedures in PLSQL and developed the code.

Creating indexes and checking for performance optimization.

Creating wrapper programs, SQL Scripts.

Backend Testing.

Description-

Patient balance statements are used to identify the patient balances and print the same for sending it to customer via a third party print vendor. The current AS400 system has a statement program

That generates this statements and certain other reports. The whole patient balance statement program flow and certain reports are migrated into SQL server 2018.

In the proposed system the same statement program will be rewritten as various stored procedures which are called in sequence by wrapper program & the data in the SQL server tables that is filled by this stored procedures is displayed onto UI using the angular platform. A separate SQL stored procedure exist to pull the data from the SQL server tables using various business validations, to generate the patient billing statements to be utilized by third party vendor. This program was also migrated from AS400 to SQL server.

Project Name- Load OMOP-CDM data into AWS REDSHIFT (Cloud platform)

Technology- AWS cloud platform, REDSHIFT

Role and Responsibilities-

Creating New Databases on cloud and load Healthcare specific data.

Load data into AWS REDSHIFT cloud platform using different services.

User management assigning new Roles to user, Grant and Revoke permission to user.

Storage Management

Ec2 instance connectivity.

Create Visualization and perform real time data analytics.

Description-

In this project we can load healthcare specific data (OMOP-CDM) into AWS .The COPY command uses the Amazon Redshift massively parallel processing (MPP) architecture to read and load data in parallel from multiple data sources. You can load from data files on Amazon S3, Amazon EMR, or any remote host accessible through a Secure Shell (SSH) connection. After that finally we can Visualize the data using achilles tool and perform real time data analytics on that.

Project Name - Snowflake data warehouse automation and data ingestion.

Technology – Snowflake (Cloud data platform).

Role and Responsibility-

Create virtual DW and load data into snowflake.

User management

Storage management

Using Sigma Computing Visualize data and perform real time data analytics.

DW Automation and data ingestion.

Description-

In this project we are generating the data in snowflake DW and working on data warehouse automation and data ingestion. After that finally we can visualize the data using Sigma computing and perform real time data analytics on that and creating dashboards.

Achievements, Awards & Certifications

Successfully Completed Life Skills Training conducted by GTT and NASSCOM Foundation.

.

Completed ORACLE DBA training from Focus Datatech Pvt.Ltd.

Interests & Hobbies

•Swimming.

•Wrestling.

Declaration

I hereby declare that the above information provided is true to the best of my Knowledge and belief.

Date:

Place: [Mr. Sumit B. Dundale]

Contact this candidate