Database Developer Sql

VIRENDRA POUNIKAR

Database Developer

********************@*****.*** 915-***-****

https://www.linkedin.com/in/virendrapounikar

Summary:

Experienced SQL Developer with over 4 years in T SQL, SSMS, MySQL, PLSQL and Power BI.

Proficient in writing complex and optimized T-SQL queries, including stored procedures, views, temp tables, table variables, indexes, Trigger, DDL, DML, DCL, TCL command and CTEs. Skilled in designing, developing, and deploying SSIS-based ETL solutions.

Experienced in both OLAP and OLTP systems, data modelling, reporting, and analysis. Adept at collaborating with diverse teams to deliver high-quality, scalable solutions that meet business requirements.

Develop and maintain Power BI dashboards and reports, providing insightful data visualizations. Write and optimize DAX queries for advanced data analysis.

Passionate about continuous learning and improving technical skills. Work Experience:

Company Name: - ITFMS Infotech Pvt Ltd.

Project 1 : Drona (Sep 2024 to Current)

Client : Mahindra and Mahindra

Type : Web Application

Role : Database Developer and DBA.

Description:

Drona is a specialized product developed for Mahindra & Mahindra, catering to both the Automation Division and Farm Division. The Automation Division focuses on manufacturing automobiles such as cars, trucks, and two-wheelers across multiple locations, including Pune, Mumbai, and igatpuri. Meanwhile, the Farm Division is responsible for manufacturing JCBs and three-wheelers at locations such as Nagpur, Haridwar, and other manufacturing sites. The project aims to enhance operational efficiency by automating production processes, optimizing data management, and ensuring seamless integration across manufacturing units. Role / Job Responsibilities

Database Development: Design and implement efficient database schemas, stored procedures, and functions for optimized data processing.

Business Intelligence & Reporting: Build Power BI dashboards and reports for real-time data visualization.

Performance Tuning: Optimize large queries and indexing strategies to improve system efficiency.

Technical Collaboration: Work closely with Business Analysts, development teams, and clients to understand and implement business requirements.

Production Support: Troubleshoot and resolve database performance issues, data inconsistencies, and system integration challenges.

ETL & Data Integration: Develop and manage ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data efficiently across different systems. Company Name: - C3IT Software Solution Pvt Ltd.

Project 1 : Processo (Jun 2021 to July 2024)

Client : ABFRL, Shopper Stop, Bajaj, Crescent

Type : Web Application & Mobile Application Project Role : Database Developer.

Description:

Processo offers everything you need for an efficient operation and a connected workforce. Digitize your operations and capture evidence of task completion with enforced Time, Location, Identity and Device compliance. Reach, engage and align your workforce with this mobile-first flexible platform. Processo works on all devices with a Teams App as the front end. Processo redefines & raises the bar for operational efficiency and compliance through intelligent process automation. It is specifically designed for businesses that rely on frontline workers for their daily operations by automating routine tasks, approvals or more. It promotes self- audits taking away the need for inspections; enforcing location and identity compliance for evidence capture . Role / Job Responsibilities

SQL Development for Data Availability: Developed UDFs, Stored Procedures, and SQL Views to support the Power BI team, ensuring smooth data flow from backend to frontend. Created executive reports and dashboards to improve report generation speed.

Data Analysis and Efficiency Improvement: Monitored and analysed data to identify patterns and enhance the efficiency and speed of data integration, enabling quicker data availability for clients.

Documentation and Mentorship: Prepared comprehensive documentation, including Data Directory, ERD, and DFD, using Erwin and ER Studio, to support project handovers and guide new joiners and interns, streamlining the onboarding process.

Migration to T-SQL: Successfully migrated the analytics project from SQL Server, resulting in faster data processing and better performance.

Portal Migration and Optimization: Spearheaded the migration of the OLTP portal from SQL Server, optimizing SQL components to improve portal performance and reduce page load times.

Collaboration and Fast Deliveries: Worked closely with Mule and .NET teams for seamless integration and timely delivery of solutions, improving deployment efficiency. Project 2 : B2B Shopper Stop revamp (Oct 2023 to Jul 2024) Client : Shopper Stop

Type : Web Application

Role : Database ETL Developer (Support)

Description:

B2B Shopper Stop: Web application providing vendors access to sales, stock, invoice, and purchase order

(PO) data via SSRS reports.

Role / Job Responsibilities:

SQL Development for Data Availability: Developed UDFs, Stored Procedures, and SQL Views to support the Power BI team, ensuring smooth data flow from backend to frontend. Created executive reports and dashboards, increasing report generation speed.

ETL Package Creation and Data Integration: Designed and implemented ETL SSIS packages to integrate data from SAP to SQL Server, utilizing various SSIS transformation modules, resulting in a reduction in data processing time.

Performance Optimization: Optimized execution times for SSIS packages processing large datasets, reducing run times and enhancing data processing efficiency.

Technical Skills:

Languages: SQL Server, Oracle SQL, MS-SQL, Snowflake SQL.

SQL Languages: T-SQL, PL/SQL, MySQL.

Tools/Software: SQL Server Management Studio (SSMS), SSIS, SSRS, MS Office (Advanced Excel), Draw.io

(DFD/ER).

Database Management: Stored Procedures, Views, Indexes, Trigger, CTE’s, DDL/DML/DCL/TCL commands, UDF Functions, Query Optimized,

Data Modelling: Normalization, Fact Tables, Dimension Tables, Schema Star.

Concepts: DBMS, RDBMS, OLAP, OLTP, Data Modelling, ETL & ELT, Agile Methodology, Data Mining. Technology Migration (SSMS).

Education:

CDAC - Diploma in Advanced Computing

Sunbeam Institute of Technology, Pune Feb 2020 – Feb 2021

BE – Electronics and Telecommunication

SB Jain Institute OF Technology and Management, Nagpur Jun 2015 – May 2018 Declarations:

I here declare that all information furnished above is true to the best of my knowledge and belief. Place: Pune Name: Virendra Pounikar

Date

Contact this candidate