Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dheeraj

Bangalore

Summary

A goal-oriented professional targeting assignments in SQL, PL SQL Development, SQL server, BI Developer.

A focused professional with over 6 years of experience on SQL and PL SQL Development with proficiency in Oracle, MySQL, and SQL Server and BI Tools. Currently excelling as a SQL Developer & BI Developer at Accenture, creating reports. Expertise in designing, implementing, and managing databases using SQL; skilled in writing complex queries, stored procedures, and optimizing performance to ensure efficient data retrieval and manipulation. Experience in managing an entire gamut of activities including designing solutions as per customer needs, developing applications, migrating applications, ensuring ontime delivery, implementing process automation, engineering, and so on. Proficient in T-SQL for writing stored procedures, triggers, constraints, and indexes; experience in automating SQL scripts and integrating data from diverse sources such as SharePoint, Azure Data Lake, SQL Server, and Excel. Capable of analyzing large datasets to identify trends, patterns, and anomalies; experience in troubleshooting data issues and providing solutions to enhance data quality and integrity. Specialized in creating complex data models, interactive dashboards, and reports in Power BI; strong capabilities in using DAX functions, optimizing reports, and implementing Row-Level Security (RLS). Strong knowledge of data warehousing methodologies, including star and snowflake schemas; experience with ETL processes, data validation, and deploying data into Power BI services.

Overview

6
6
years of professional experience

Work History

SQL Developer & Data Analyst

Accenture
Bangalore
10.2021 - Current
  • Company Overview: At GAP, the world's leading fashion company with 3,352 stores worldwide
  • Gathering requirements from the client and analyzing the feasibility of fetching data from multiple sources
  • Creating database and database objects like tables, stored procedures, views, triggers, rules, defaults, user-defined data types, and functions
  • Involving in unit testing, user acceptance testing to check whether the data is loading into the target, which was extracted from different source systems according to the user requirements
  • Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins
  • Executing assigned tasks related to SQL Server and Power BI, ensuring efficient and accurate data extraction, transformation, and loading (ETL) processes
  • Interpreting business requirements within the Business Intelligence (BI) context and designing robust data models in Power BI to transform raw data into actionable insights
  • Automating Power BI reports using Power Automate, streamlining data extraction from various sources to ensure timely and reliable report updates
  • Deploying reports securely on Power BI Cloud, implementing Row-Level Security (RLS) to restrict data access based on user roles and permissions
  • Automating report distribution using subscription methods to ensure stakeholders receive timely updates without manual intervention
  • Managing and resolving tickets related to Power BI and SQL Server through ServiceNow, maintaining a high level of service delivery and customer satisfaction
  • At GAP, the world's leading fashion company with 3,352 stores worldwide

SQL Developer & Data Analyst

Capgemini
Bangalore
02.2021 - 07.2021
  • The project aims to automate new cruise booking requests for Virgin Voyages, streamlining processes to enhance user experience and reduce Average Handling Time (AHT)
  • Engaged in developing intricate database processes using MS SQL for batch or ETL and SSIS packages specializing in translating business requirements into technical specifications and subsequently designing and executing tailored solutions
  • Utilized T-SQL to construct user functions, views, indexes, user profiles, RDBMS, data dictionaries, and ensuring data integrity; writing T-SQL code for historical data pulls per specification
  • Collaborated with clients to gather and clarify requirements for business intelligence solutions
  • Utilized BI tools such as Power BI and Tableau to create various data visualizations, including bar charts, tree maps, line charts, scatter plots, and others
  • Designed and implemented primary database objects such as views and indexes based on logical and user requirements
  • Created and maintained production and sales reports for various departments using SSRS
  • Optimized ETL processes and proposed new systems to improve efficiency and accuracy of data integration
  • Evaluated and implemented strategic changes to enhance existing business intelligence systems
  • Utilized Power Query within Power BI to transform and cleanse data through pivoting and unpivoting
  • Managed source code in Team Foundation Server (TFS), ensuring timely updates and documentation of development status

SQL Developer & BI Developer

Fincare Small Finance Bank
Bangalore
10.2018 - 08.2020
  • Developed automated reporting solutions to meet RBI compliance requirements for Microfinance Institution (MFI) products
  • Played a role in issue resolution during integration and UAT phases; actively contributed to application enhancements based on user requirements
  • Developed Korn Shell Scripts for job scheduling, batch processing, and database transactions
  • Led a team of 3 members and managed releases into production without bugs using version control
  • Administered PL/SQL triggers and master tables for the automatic creation of primary keys
  • Assisted the Application Development Team in preparing technical designs and performing construction activities
  • Documented recurring issues and solutions that led to decrease in issue resolution time and an improvement in overall team efficiency

Education

Bachelor of Technology -

GITAM University
Vishakapatnam
06-2018

Skills

  • Database Optimization
  • SQL / PL SQL Development
  • ETL Process Management
  • Data Management / Modelling
  • SQL Scripting
  • Requirement Gathering
  • Performance Tuning
  • Data Analysis & Visualization
  • Software Development Life Cycle
  • Stakeholder Collaboration
  • Critical Thinking
  • Communication
  • Problem-solving
  • Decision-making
  • Team Player
  • SQL
  • Pl SQL
  • MS SQL
  • XML
  • Python
  • MySQL
  • PowerBI
  • Tableau
  • Nano BI
  • Azure Data Lake (ADLS)
  • Azure Data Factory (ADF)
  • ServiceNow
  • Power Automate

Timeline

SQL Developer & Data Analyst

Accenture
10.2021 - Current

SQL Developer & Data Analyst

Capgemini
02.2021 - 07.2021

SQL Developer & BI Developer

Fincare Small Finance Bank
10.2018 - 08.2020

Bachelor of Technology -

GITAM University
Dheeraj