Akshay Pawar

Software Engineer

Pune, Maharashtra, India6 yrs 8 mos experience

Highly StableAI Enabled

Key Highlights

Expert in SQL development and AI solutions.
Mentored teams as a Google Gemini AI Trainer.
Proven track record in optimizing data solutions.

Stackforce AI infers this person is a SQL Developer specializing in AI and E-commerce solutions.

Contact

Skills

Core Skills

SqlAi DevelopmentData ManagementBusiness Intelligence

Other Skills

Python (Programming Language)Large Language Models (LLM)PythonSSISSQL Server Management StudioAzureDatabasesPower BIMicrosoft OfficeProduct Information ManagementProduction SupportSQL Server Reporting Services (SSRS)Extract, Transform, Load (ETL)Amazon Web Services (AWS)Pandas (Software)

About

I am a SQL Developer experience delivering data-driven solutions across AI and E-commerce domains. My expertise lies in SQL development,SSIS, SSRS, prompt engineering for AI models Currently, I working with Bytes software on the Google Gemini AI Tool, where I specialize in model evaluation, SQL prompt creation, and AI code quality benchmarking. I focus on breaking and improving AI models using real-world SQL challenges, ideal code solutions, and unit test validations using Python-based frameworks. In previous roles at NTT DATA, I developed and optimized complex SQL procedures, supported large-scale data warehousing, and built end-to-end data solutions for product management, financial systems, and enterprise reporting. My work has helped improve system performance, streamline processes, and provide clean, actionable insights to stakeholders. Notable Achievement: Chosen as a Google Gemini AI Trainer, mentoring teams on prompt quality, model behavior evaluation, and functional testing of AI-generated SQL code. I thrive in cross-functional environments, love solving deep technical challenges, and am passionate about pushing the boundaries of AI and data science through practical application and creative thinking.

Experience

6 yrs 8 mos

Total Experience

2 yrs 7 mos

Average Tenure

1 yr 6 mos

Current Experience

Bytes software services

Sr SQL Developer

Nov 2024 – Present · 1 yr 6 mos · Maharashtra, India · Remote

Project Name : Deep Mind LLM
System : Artificial Intelligent
Roles : SQL Developer
Project Detail Description:-
The LLM Deep Mind project focuses on evaluating the robustness of Gemini AI Tool in
code generation, particularly for SQL queries and associated unit test cases.
The primary objective is to design Model Breaking prompts that intentionally challenge the AI model,
pushing it toward logical or functional failure points.
The goal is to deeply assess the model's code and test case generation abilities and enhance its
reliability by systematically identifying failure patterns.
Responsibilities:-
Design Complex SQL Challenges: Create sophisticated SQL-based questions, involving database
schema creation and data scenarios, aimed at challenging the AI model’s understanding and
generation capabilities.
Model Response Evaluation: Critically assess the AI model’s SQL query and unit test case outputs for
correctness, functionality, and logical coherence.
Ideal Code Development: Write the correct or "ideal" SQL solutions and unit test cases
corresponding to model-breaking prompts, serving as a baseline for evaluation.
Prompt Engineering (PE): Apply advanced Prompt Engineering techniques to restructure or finetune prompts, increasing the difficulty level and exposing model weaknesses.
Prompt Hinting (PH): Introduce Prompt Hinting strategies to guide the model subtly toward more
accurate outputs without revealing the solution directly.
Unit Testing and Validation: Create comprehensive Positive, Negative, and Edge Case unit tests for
the model's SQL outputs.
Validate both the model-generated code and manually written ideal code using Python-based unit
testing frameworks (e.g., unittest, pytest).
Quality Assurance: Document observed failures, gaps in logic, functionality issues, and test case
inaccuracies systematically for further analysis and model retraining inputs.

Python (Programming Language)Large Language Models (LLM)SQLAI Development

Ntt data

SQL Server Developer

Sep 2022 – Sep 2024 · 2 yrs · Pune District, Maharashtra, India · Remote

Project Name : PIM/DAM Enterworks
Client : Resideo, US
System : E-Commerce
Roles : SQL Developer
Project Detail Description:-
Resideo is a newly spun-off company from Honeywell and focus on their Home Comfort, Safety,
Security, Energy Efficiency, Fire and Low-voltage Products.
This offers more than 3500+ products and also provides professional services to homeowners.
Customer.Resideo.com is a B2B platform for Residential Comfort and Combustion products for US
and Canada customers.
Responsibilities:-
Analyzing PIM/DAM Production support issues and fixing it.
Writing and optimizing SQL queries and statements.
Monitoring and maintaining Azure Data Server for security, backup, and data recovery.
Monitoring Production services on daily basis.
Setup new users/roles to data stewards and business admins in all three environments.
Maintaining scheduled jobs and validating data feed running on daily/weekly and monthly in
production.
Migrate PIM code from lower environment to higher environment (from DEV to QA and
Production).
Updating specifications file to send data from PIM to Resideo websites.
Handling new change requests from EMEA and North America data stewards teams, Requests like
language report generation, templates creation for data management.
Patching validation for DEV, QA and Production environments every quarter of the year.
Handinling Resideo External Distributors Syndication requests.
Setup a new Resideo Self-Service distributor setup and give demo.
Creating procedures, fuctions and other database objects.
Gather data volume exported from PIM on daily/weekly/monthly basis and maintain graphical
view in confluence.
Perform ad hoc data import/export of PIM/DAM.
Validate databse refresh from Production to lower environment.
Generate Image variants in lower environment after database refresh.
Enterworks product level issue analysis and work with product team to get a resolution.

SSISSQL Server Management StudioSQLData Management

Tata consultancy services

SQL Developer

Jun 2019 – Aug 2022 · 3 yrs 2 mos · Pune District, Maharashtra, India · On-site

ProjectName : Financial Analysis
Client : Wells Fargo, Charlotte,US
System : Banking
Roles : SQL Developer
Skilled Used : SQL, Power BI
Project Detail Description: -
Wells Fargo financial provides millions of customers with financial resources to meet and manage the
credit needs and to achieve the financial goals. This financial services industry is the largest, fastest
growing, most fragmented industry in the world.
Responsibilities:-
Designed and developed efficient database structures, including tables, relationships, and
indexing strategies.
Designed and developed interactive Power BI dashboards and reports to deliver
actionable insights on financial performance and customer trends.
Integrated SQL data models with Power BI for real-time visualization and reporting.
Optimized Power BI datasets and visualizations for faster performance and better
usability.
Wrote and optimized complex SQL queries for data retrieval, manipulation, and reporting.
Developed and maintained stored procedures, functions, and triggers to automate repetitive
tasks.
Monitored and fine-tuned database performance using indexing, query optimization, and execution plan analysis.
Ensured data integrity, consistency, and accuracy across relational databases.
Extracted, analyzed, and reported data using SQL queries and Business Intelligence (BI) tools.
Managed user access, roles, and permissions to secure sensitive data.
Collaborated with application developers to integrate databases with software solutions.
Provided database support to business teams, assisting with ad-hoc queries and data analysis.
Maintained comprehensive documentation of database schemas, queries, and processes for
future reference.