Summary
Overview
Work History
Education
Skills
Core Qualification
Timeline
Generic

ADITYA KAWALI

Mumbai

Summary

Dynamic Senior Associate with extensive experience at BNP Paribas India, excelling in SQL development and ETL processes. Proven track record in leading teams to optimize data warehousing solutions, enhancing client interactions, and delivering impactful results. Skilled in Python programming and fostering collaboration to drive project success.

Overview

11
11
years of professional experience

Work History

Senior Associate (Senior SQL/SSIS/ORCALE/PYTHON developer – Team Leading)

BNP Paribas India
08.2021 - Current
  • Provide full lifecycle support to clients from initial client interaction and requirements analysis through design, coding, testing, debugging, implementation and integration.
  • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications. Involved with business and functional people to collect and gather requirements.
  • Handling Scrum calls and planning the sprint for upcoming release.
  • Understand the business process and design SQL/Oracle database, SSIS Package and Python.
  • Sole participation in development and creation of Data warehouses.
  • Worked on all activities related to the development, implementation, administration and Support of ETL processes using Microsoft Visual Studio.
  • Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
  • Automation of ETL process to run on monthly basis and Handled Incremental Database maintenance.
  • Optimizing SQL jobs and queries.
  • Project Details: ATP (Abnormal Trading Pattern), this project detect any abnormal trading pattern for financial security like equity securities and derivative securities. Once this Trade is detected it’s notified to BA (Business Administer) through the Front Application.
  • To detect Abnormal Trading Pattern for Trade, Functional Specification are provided by the BA Team based on which required SSIS package, SQL/Oracle query and Store Procedure etc. are created and data is moved to Front end Application.

Senior SQL developer and Power BI Developer

Smollan India PVT.LTD.
12.2018 - 08.2021
  • Participated in application discussions, gathering requirements for back-end functionality.
  • Designed SQL databases aligned with mobile platforms and business processes.
  • Developed comprehensive data warehouses, optimizing data flow and storage.
  • Created and maintained database objects, ensuring integrity and performance through constraints and custom functions.
  • Coordinated with business and operations teams to deliver professional reports using Cognos and Power BI.
  • SMART (Smollan Mobile Analytical & Reporting Tool) projects development and delivery for Hindustan Unilever Ltd (HUL) as well as South East Asia (SEA) countries (Thailand, Malaysia, Taiwan, Myanmar) and South Africa.
  • The SMART is the android based platform having functionalities like Enhance Brand Activation; Sales and Marketing establishment. Application that able to revolutionize the way they work by making it easy to capture, access and use information ‘ON THE GO’. After Synchronization of data with MS SQL DB, using IBM Cognos and Microsoft Power BI platform, SMART professional reports & Dashboards, Cognos report bursting, auto mailers.

SQL Server Developer/Analyst/Support/SSIS developer

HCL Technologies Limited
Mumbai
08.2014 - 11.2018
  • Company Overview: Client: Nomura Services India Pvt Ltd
  • Rich experience in all stages of Project Development including requirement gathering, writing specifications, designing & documenting, reporting needs of the Client as well as carrying out all stages of development, testing, implementation.
  • Construct complex SQL queries with sub-queries, stored procedures and functions as per the functional needs in the Business Requirements Document (BRD).
  • Worked on all activities related to the development, implementation. Administration and Support of ETL processes using SQL Server SSIS.
  • Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
  • Client: Nomura Services India Pvt Ltd
  • Project Details MyReports: This is an application Used by users to generate report based on parameters entered. This application is used by number of team in Organization as this application had ability run multiple Reports on different database at a time. Comprehensive report system provides reports about the carrier, customer, sale representative commission and billing reports.
  • Accordant: This Application is used by Nomura to monitor desk locations, assets plan, employee deck location in the organization etc. The project was to enhance and develop new functionality to the application on the database side for Asia, Europe and USA region.

Education

B.Tech - IT

Mumbai University
Mumbai
01.2013

Diploma -

Bhausaheb Vartak Polytechnic
Maharashtra
01.2010

SSC -

ST. Lawrence High School
Maharashtra
01.2007

Skills

  • Team leadership
  • SQL development
  • ETL and SSIS processes
  • Oracle database design
  • Python programming
  • Data warehousing
  • Client interaction

Core Qualification

Good Hands On: MS SQL Server 2014, 2018, Microsoft Visual Studio 2019 and 2013, Oracle Database 12c and 19c, Python

Timeline

Senior Associate (Senior SQL/SSIS/ORCALE/PYTHON developer – Team Leading)

BNP Paribas India
08.2021 - Current

Senior SQL developer and Power BI Developer

Smollan India PVT.LTD.
12.2018 - 08.2021

SQL Server Developer/Analyst/Support/SSIS developer

HCL Technologies Limited
08.2014 - 11.2018

B.Tech - IT

Mumbai University

Diploma -

Bhausaheb Vartak Polytechnic

SSC -

ST. Lawrence High School
ADITYA KAWALI