Overview
Work History
Education
Skills
Disclaimer
Timeline
Generic

SHUBHAM SHERE

Pune

Overview

3
3
years of professional experience

Work History

Personal Loan Tel Binding (PLTB)

09.2022 - Current
  • Designed Code to extract data from SQL Server as per the business requirements
  • Implemented various simple to complex SQL queries
  • Feed collection from multiple source and table
  • Tracking feeds
  • Provide data to call center and back ends
  • Manipulating, Cleansing and processing data using Excel and SQL
  • Responsible for loading, extracting and validation of data
  • Analyzing the business requirements and systematically designed and created a complete schema including tables, functions, relationships, stored procedures, views, triggers
  • Implementing the import and export of data using SSIS, SQL Server
  • Work Experience on Power BI Tool: Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
  • Analyzing data and present data through reports that aid decision-making
  • Convert business requirements into technical specifications and decide timeline to accomplish
  • Create relationships between data and develop tabular and other multidimensional Data models
  • Chart creation and data documentation explaining algorithms, parameters, models, and relations
  • Perform DAX queries and functions in Power BI
  • Create customize charts and custom calculations as per requirements
  • SQL querying for best results, use of filters and graphs for better understanding of data
  • Expertise in Power BI, DAX, SQL Server, Data Warehousing concepts
  • Create dashboards and interactive visual reports using Power BI
  • Understand business requirements in BI context and design data models to transform raw data into meaningful insights
  • Design and develop of reporting data module for Monthly, Quarterly & Yearly
  • Analyze current ETL process, define and design new systems
  • Redefine and make technical/strategic changes to enhance existing Business Intelligence systems

Associate Software Engineer

11.2021 - 09.2022
  • Strong skills in SQL development on SQL Server
  • In-depth grasp of SQL joins, sub queries, definition and manipulation statements
  • Extensive experience in SQL, T-SQL in SQL Server 2008, 2012, 2016 platforms
  • Experience in creating Tables, Views, User Defined Functions
  • Experience in ETL using SQL Server Integration Services (SSIS) to build and support Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions
  • Experience in job schedule, monitor and support for ADF (Azure Data Factory)
  • Project: RBL indus collection
  • Customer Account, Banking, Billing data process and movement for collection processing and EDW
  • Responsibilities: Create SQL jobs, Create complex queries involving correlated sub queries, Merge statement, write SQL query to load incremental data, Create temporary tables and views and create stored procedures using multi-table joins, CTE, Create ETL package to daily data load process using SSIS on the basis of requirements, Changes in existing process/SQL Procedures and SSIS Packages as per requirements and deployment, Daily monitoring of SQL jobs, Procedures and SSIS packages, Resolve daily issues and resolving Azure tickets
  • Project: ATOS MASTERLOAD
  • Schemes, dealers, and scheme dealer related data movement to ATOS
  • Responsibilities: Create SQL jobs, Create temporary tables to upload files, Create ETL package to daily data load process using SSIS on the basis of requirements, Changes in existing process/SQL Procedure and SSIS Packages as per requirements and deployment, Process daily master files and generate files using stored procedures and upload using SSIS Packages
  • Environments: SQL Server 2016, EDW, Oracle, SQL Server Data Tools 2015 (for SSIS), Win SCP(SFTP)

Education

Bachelor of Engineering - Mechanical

Savitribai Phule Pune University
Pune

Diploma - Database

Skills

  • Azure DevOps
  • SQL Server Management Studio (SSMS)
  • SSRS
  • BCP
  • EXCEL
  • DATABRICKS
  • Power BI
  • MS SQL Server
  • SFDC

Disclaimer

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

Timeline

Personal Loan Tel Binding (PLTB)

09.2022 - Current

Associate Software Engineer

11.2021 - 09.2022

Bachelor of Engineering - Mechanical

Savitribai Phule Pune University

Diploma - Database

Similar Profiles

CREATE PROFILE
SHUBHAM SHERE