NEWW KETAKDHAND

Bengaluru

Summary

Professional technical leader with proven ability to spearhead complex projects and drive innovative solutions. Adept in software development, systems architecture, and project management. Strong emphasis on team collaboration and delivering results in dynamic environments. Known for adaptability and reliability. Skilled in coding, debugging, and optimizing performance.

Overview

years of professional experience

Work History

Tech Lead / Senior Software Engg

Wipro Ltd

Bengaluru

09.2019 - Current

As a part of Anaplan integration which has both development and supporting work related to Cisco sales data application. Which involves the data migration from Hadoop to Snowflake with a minimal architectural change in existing system.
Data Transformation and loading within Snowflake using SNOWSQL and Shell script combination.
Involved on data summarization and ingesting process into Oracle for downstream consumption using Shell Script and Python script preparation.
Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures using Informatica and Python.
Involved on data unloaded process as flat file and ingested into Anaplan Hub.
Supporting Development, Internal/End to End testing teams during development and testing phases
Restored objects associated with data that may have unintentionally been lost using Time Travel concept
Obtained real-time data from production and carried out several actions using Zero-Copy Cloning concept
Designed, Optimized query performance and implemented data warehousing solutions using Snowflake using Snowflake CLI.
Collaborated with cross-functional teams to integrate Snowflake with other data platforms.
Developed Python scripts for data manipulation and automation.
Used COPY INTO to bulk load data from S3 staged file(s) to Snowflake database table.
Upload one or more data files to a Snowflake stage (named internal stage or table/user stage) using the PUT command.
Implemented data quality checks and validation processes using Stored Proc
Collaborated with data analysts and business stakeholders to understand data requirements.
Employer: Wipro Ltd (Sep 2019 - Till date)
Domain: Cisco Sales
Project: Cisco sales, Sales Coverage Crediting Compensation _EDW
Environment: Snowflake, Anaplan, Control-M, Informatica ETL, Oracle PLSQL
Role: Tech Lead / Senior Software Engg
Led cross-functional teams to deliver high-quality software solutions within established timelines.
Mentored junior developers, enhancing team capabilities and fostering professional growth.

Tech Lead

Tech Mahindra

01.2010 - 09.2019

Worked on CCP54 STE and Agent.com scenarios and managing the entire work stack respectively.
Create new Oracle user ids and arrange for the password resets of existing user ids and assigning Database Roles.
Developed, Customized and maintaining existing Oracle objects (Functions, Procedure, Package, Trigger and Batch Jobs) of the application.
Involved in data loading using SQL
Loader from various formats (delimited values, fixed position values) of flat files to the oracle database.
Worked on XML along with PL/SQL to develop and modify web automation of House Keeping activities for Oracle databases.
Responsible for Unit Testing and fixing the bugs for various scenarios.
Developed PL/SQL triggers, Created indexes on the tables for faster retrieval of the data to enhance database performance.
Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL
TRACE, TKPROF and AUTOTRACE.
Used Bulk Collections for better performance and easy retrieval of data.
Used standard packages like UTL_FILE, DBMS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
Responsible for creating scenarios with standard EIM process (EXPORT, REPLICATE, IMPORT and Report generation).
Creation/Building of scenarios for Agent.com and ensure timely delivery.
Interact with Agent.com STUB team to ensure successful delivery of requirements related to OVSTE-Agent.com interface.
Configuration management for Agent.com-related deliverables.
Responsible for the preparation of scope documents and send them for approvals.
Provide Performance Tuning guidelines and direct the team in constantly optimizing response times for both batch processes as well as online transactional systems.
Enable team members in understanding the Agent.com and STE scenarios and Stub call process.
Represent One view STE for Agent.com Environment in E2E test call independently.
Interaction in Show & Tell with Clients, End to End Solution Designers & Business Analysts to decipher the requirements
Peer review of test data of team members to ensure high quality outcome.
Supporting Development, Internal/End to End testing teams during development and testing phases
Extending help to Application Support Team for analysis/resolution of production issues
Employer: Tech Mahindra (Jan 2010 – Sep 2019)
Domain: Telecom
Project: One View STE (Strategic Training Environment), Agent.com TE.
Environment: Oracle 10/11g, Oracle SQL Developer, PLSQL, Java, VBA Macros, C#, .Net, XML, Siebel 7.8, Siebel 8.1
Role: Tech Lead
Spearheaded implementation of Agile methodologies, enhancing project delivery efficiency and team collaboration.

Education

Master of Science - Telecom and Software Engineering

BITS Pilani

Bachelor of Engineering - Computer Science

Visvesvaraya Technological University

Skills

Snowflake: Data warehousing, performance optimization, data sharing
Oracle PL/SQL: Database design, stored procedures, performance tuning
Control-M: Job scheduling, workflow automation

Python: Data manipulation, scripting, automation
Informatica: ETL processes, data integration
Salesforce CRM: to handle and manage customer transactions and their enquiries

PROFILE

Currently working as Senior Software Engg/Tech Lead in Wipro Ltd, Bengaluru.
Highly skilled Snowflake Developer with over 4.2 years of relevant experience in Snowflake Cloud and ETL
Over 8.5 years of programming experience as a Database Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
2 years of experience on Control-M, Salesforce, Python resolving conflicts and monitoring data sync.
Undergone various Cloud AWS, Machine-learning and python courses from udemy learning portal.

Awards

Received 'Bravo' award in FY13-14-Q4 for handling key functionalities., Received 'Long Service Award – 5 years' award in Jan 2015. techmahindra, Received 'Long Service Award – 5 years' award in Sep 2024. wipro, Internal training: Gen AI , Agile implementation, Lean six sigma yellow belt

Timeline