Tushar Vilas Kute.

Mobile: +91-9892545665
E-mail: tushark14@yahoo.com

Objective:

Currently having 15+ Years of experience using DW technologies Snowflake, AWS/DevOps and Development,
Maintenance and Support client/server Applications

I seek a dynamic and challenging career in the Information Technology and Software Development Industry Which
gives responsibility, opportunity for good career, where I can effectively contribute my skills. I would also like to make
positive contribution towards promoting team spirit and own professional growth.

Technical Qualification:

 Completed 3 Year Course GNIIT (Graduate in Information Technology) From NIIT (2003-2007).
 Completed I.T.I Course in Computer Operator and Programming Assistant (C.O.P.A) from LMTI Institute.
 Completed Oracle 10g Database Developer Course and ETL and Data Science Course.
 Completed Snowflake & AWS & DevOps Trainings.
 Completed 30 and 40 W.P. M Typing Certification.

Oracle Certification:
- Oracle® 10g: Database Administration Workshop II.
- Oracle® 10g: Database Administration Workshop I.
- Oracle® 9i: Introduction to SQL.

Educational Qualification:

Education University Period

Master of Computer Application (MCA) Sikkim Manipal July, 2014
Bachelor of Commerce (B.com) Mumbai March, 2005

Software Skills:

Software
Operating Systems Window 2007,2010 and Linux/Unix
Programming Languages SQL, PL/SQL, Asp.net, C#, MVC, Jquery, HTML, Python, Vb.net, VB
Databases/ETL Tool Oracle 9i /10g/12c and SQL server 2015,2018, Informatica,SQL BI
Tools and Utilities TOAD, Sql*Plus, Putty, Oracle SQL Developer, Crystal and SSRS Reports
Cloud Technologies Data Enginnering, Snowflake, AWS Solution Architecute & DevOps

Professional Summary:

 Technical expertise in Oracle SQL & PL/SQL and Snowflake & ETL Tool.
 Snowflake: Architecture, Micro-Partitioning, Clustering, Query History & Caching, Snowpipe, Tables,
Views(Standard, Secure & Materialized), Time Travel, Fail Safe, Tasks, Streams, Zero-Copy Cloning, Secure
Data Sharing, Snow SQL
 Worked as AWS solution architect and AWS DevOps Engineer.
 Writing SQL query, Functions, Stored procedures, packages, Cursors, and Triggers.
 Experienced in troubleshooting of issues pertaining to Application and Database, User Errors, Production
Server and Database related errors.
 Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new
technical concepts quickly & utilizing the same.
 Control user access to resource and information.
  Predicting the future storage and other resource requirements for the production database.
 Identifying resource bottlenecks in the production system and carrying out performance tuning exercises.
 Development of new Change Request and Bug Fixing.
 Creating and managing tablespaces and rollback segments.
 Post Delivery maintenance, enhancement and upgrade of various PLM modules
 Maintenance and Support of Applications developed using Oracle 9i and 10g.
 Excellent technical analysis, multitasking, problem solving skills and team player.
 Production Support and End-User query resolution.

Experiences:

 Working as Data Engineer/Lead Engineer in CRISIL LTD., Mumbai from Oct 2022 to till date.

Description:

EWS Product was created for the banking use of software. This System used to tracking Loan.
Designed and implemented ETL pipelines for ingesting and processing large volumes of data from various sources.
Built and maintained data warehousing solutions using Snowflake, allowing for faster data access and improved
reporting capabilities.

 Snowflake lead developer, Snowflake administration.

 Manage AWS Data Lake in cloud and migrate data to Snowflake.
 Exposed to Snowflake Architecture, Worked on Snowflake's warehouses, roles, databases, schemas, and
Resource Monitor.
 Exposed on Micro-Partitions, Data Clustering. Performed re-clustering of the table using clustering keys to
optimize data retrieval.
 Loaded on-prime JSON/XML data to Snowflake using SnowSQL CLI.
 Created Integration objects, file formats, stages, and used COPY INTO/Snowpipe to ingest
CSV/PARQUET/JSON data continuously from AWS S3 bucket.
 Experienced in Continuous Data Protection Lifecycle: Time Travel, Fail-Safe zone.
 Queried Historical Results/Data based on Timestamp, Offset, Query ID

1. Project : Early Warning Signals

Role : Lead Engineer
AWS, Snowflake, Data warehousing, Oracle 19c database, ETL & Reporting
Technologies Used :
Tools

 Working as Lead Data Engineer/AWS & DevOps in L&T (Heavy Engineering, Defence), Mumbai
from Feb 2010 to Sept 2022.

Description:

We are using in house developed different software application like Enquiry and Registration, Design, Estimation and
Bill of Material in these software program we are using oracle database for develop new application and maintaining
existing application & performing daily activities, backup strategy, Optimizing the performance of production database,
application support & development my role & responsibly are as follows.

Key Roles for these Projects:

 Experienced in full project life cycle development including Requirement gathering from business
users, Estimation, Design, Coding, Testing, Implementation, Warranty support and live support
 Create the workflow between the maker and checker.
 Requirements and Analysis: Understanding the requirements of the client or users, to analyze the functional
and technical aspects of the requirement in detail.
 Involved in designing table structure, creating views, sequences and overall schema for a project as and when
required.
 Experienced in creating database objects like Tables, Stored Procedures, Views, Indexes, Cursors, Triggers,
User Profiles, User defined functions, Relational database integrity & observing Business rules.
  Involved in deciding table level constraints and indexes required for the system.
 Involved in Coding, Code reviewing, testing and debugging of PL/SQL stored sub-programs / Packaged sub-
programs before being delivered for production use.
 Interacting with the client on various forums to discuss the status of the tasks and clarify any queries regarding
the functionality etc.
 Analyzing the issues logged by Client & Identifying poorly performing SQL and optimizing the same
 Identifying poorly performing SQL and optimizing the same.
 Monthly reconciliation of reports, analyzing in case of discrepancy.
 Review of code fix and Unit test cases and Analyzing the PL/SQL code and SQL queries to resolve issues.
 Monitor and train junior team members using the system, using reports and writing and executing complex
queries.
.

1. Project : HE-IEMQS 1.0 and IEMQS 2.0 Software Applications

Worked as a Process Champion and Team Lead for HTE BU.
Technically involved in code review, coding, unit testing, integration testing,
Role : code promotion, creation and maintenance of databases Fixing, Production
Support and Functionally involved in project meeting, playback presentation,
requirement analysis etc.
Technologies Used : SQL Server 2016, ASP.NET MVC 4.5,C#, SSRS and SQL BI Reports etc.

2. Project : FWH and HX Mechanical Design Software Applications

Worked as a Project Management, Lead Data Engineer
Technically involved in Understand and Explained the Business
Requirements and Functionality. Architecture, Application Designing and
Role :
Database Designing. Impact analysis before going to change the existing
Code, Giving Training to Business and Operation Team and Providing
Project Support etc.
Technologies Used : SQL Server 2016, ASP.NET MVC 4.5,C#, SSRS and SQL BI Reports etc.

3. Project : HE-Informatica Project

Creating mapping, sessions, workflow, filter and joins, Involved in the
Architecture & design for the Error handling and CDC logic implementation
Role :
and Creating stored Procedures for Migration, Testing of the stored
procedures and Shell scripts.
Technologies Used : informatica, Oracle 11g, Informatica tools, shell scripting, admin console
4. Project : HE-ERP LN Implementation (Project VIBGYOR)
Role : Providing technical assistance to the upgrade team
Technologies Used : Infor Dynamic Tool, SQL Server

5. Project : Enquiry Registration & Bill of Material

Oracle Lead Database Developer cum DBA
Created database objects like Tables, Stored Procedures, Views, Indexes,
Role : Cursors, Triggers, User Profiles, and User defined functions, Relational
database integrity & observing Business rules.
Involved in deciding table level constraints and indexes required for the
system, Production support and training to end users etc.
Technologies Used : Oracle 9i & 10g VB 6.0

6. Project : Standard Flanges Project and Engineering Hours booking system

Role : Oracle/SQL Database Developer cum DBA and VB 6.0 Developer
Technologies Used : Oracle 10g, VB 6.0 ,Seagate Crystal Reports

7. Project : Estimation & Rate Master Software Application

Role : Oracle Database Developer
Technologies Used : Oracle 10g, C#.net, Crystal Reports, SQL Loader, PLSQL Developer
 8. Project : Database Migration from ORACLE to SQL Server
Role : Software Developer
Technologies Used : Oracle 10g,SSMA tool, VC++,VB 6.0, SQL Server, Crystal Reports

9. Project : HX Design Software

Oracle Database Developer cum DBA
Created database objects like Tables, Stored Procedures, Views, Indexes,
Role : Cursors, Triggers, User Profiles, and User defined functions, Relational
database integrity & observing Business rules.
Involved in deciding table level constraints and indexes required for the
system, Production support and training to end users etc.
Technologies Used : Oracle 9i, VC++, Crystal Reports

 Working as Software Engineer in B T Infosys Pvt. Ltd, Mumbai from May 2008 to Feb 2010

1. Project : PV Design Software

Role : Software Developer
Technologies Used : Oracle 10g, VC++,VB 6.0, SQL Server, Crystal Reports

2. Project : Drawing Registration Software System

Role : Software Developer
Technologies Used : SQL Server, VB.net,

3. Project : Automation of CRS Drawing

Role : Software Developer
Technologies Used : Oracle, VB.6.0, UG Nx tool

 Worked as Software Developer Trainee in IBS Bespoke Solutions, Mumbai from Sept 2007 to Feb 2008.

Description:

Forum and Errors Product was created for the internal use of software developers. This System used to track runtime
errors & exceptions of an application during development. Each & every exception & error is tracked into database.

1. Project : Forum and Errors

Role : . Net & SQL Server Developer
Technologies Used : VB.net and SQL Server

Description:

Shadow is a complete inventory management Software. This Software can handle all day-to-day transactions of
organization with Lots of reporting functionality.

2. Project : Shadow
Role : . Net & SQL Server Developer
Technologies Used : VB.net and SQL Server
Personal Information:

Date of Birth : March 14, 1984.

Permanent Address : Latif Bhai Chawl, Barve Chowk, Ganesh Nagar, Sainath Nagar Road,
Ghatkopar (West), Mumbai – 400 086.

Marital Status : Married.

Gender : Male.

Languages Known : English, Hindi and Marathi.

Passport No : K4055385

Place: - Mumbai

Date: -

(TUSHAR VILAS KUTE)