RENUKA SINGH
Pune
Summary
Results-driven SQL Developer/DBA experienced in enterprise SQL Server, T-SQL, ETL, and Data Warehousing within Banking, Financial Services, and Telecom sectors. Achieved significant performance improvements through SQL performance tuning, automation of ETL workflows, and robust database development. Focused on enhancing team efficiency and productivity, contributing to company profitability through effective negotiations and upselling techniques.
Overview
2
2
Languages
1
1
Certification
11
11
years of professional experience
Work History
SQL Developer & DBA
India Pvt. Ltd
Pune, Maharashtra
01.2021 - Current
- Design and develop complex T-SQL Objects including stored procedures, views, functions and dynamic SQL supporting enterprise client applications.
- Optimise long-running SQL queries using execution plans, indexing strategies and query refactoring, improving performance significantly. Reduced query execution time by ~93%, from 45 minutes to 3 minutes, through execution-plan analysis, indexing and query refactoring.
- Developed parameter-driven ETL frameworks to ingest data from files and databases into staging and target layers, ensuring data integrity and availability.
- Build and support SQL Server-based integration solutions, with hands-on exposure to Azure Data Factory (ADF) for select data movement and transformation tasks.
- Develop cross-server solutions using Linked Servers for enterprise reporting and synchronised updates.
- Own database design, schema development and data auditing/validation to ensure secure, compliant data handling.
- Influence Database architecture, scalability and long-term technical improvements across enterprise applications.
- Provided production support and conducted incident analysis, root cause analysis, and deployment support for business-critical systems, enhancing system reliability.
- Collaborated with global business users, architects, and application teams in Agile delivery; conducted code reviews and technical mentoring to improve code quality and team skills.
Senior Software Engineer
Accenture
01.2019 - 01.2021
- Implemented Azure DevOps CI/CD pipelines for automated database deployments across 3 environments, reducing manual deployment effort and improving release consistency.
- Conducted SQL code reviews and optimised performance across 15-20 production workloads, leveraging execution plans, indexing, and query refactoring to decrease execution time by 40% for critical queries.
- Developed and deployed 30+ SSIS ETL packages and reusable T-SQL components to enhance enterprise data platforms and automate data integration workflows.
- Developed and Deployed SSIS ETL packages and reusable T-SQL components for enterprise data platforms.
- Managed 5 applications across development, UAT, and production environments, balancing competing priorities while ensuring timely delivery and production stability.
Associate Consultant
Capgemini
01.2016 - 01.2019
- Delivered Informatica ETL solutions and executed enterprise data migration projects, enhancing data flow and integrity through effective mappings, workflows, and validation processes.
- Designed logical and physical data models for data warehouse initiatives, translating business requirements into tables/entities with appropriate keys, relationships and data-integrity constraints.
- Collaborated with global banking and telecom clients across diverse project teams and regions, contributing to Agile ceremonies, requirement discussions, technical design, and production support, ensuring alignment with client needs.
- Previously, generating the scripts manually took approximately 2 hours for a batch of objects. After automating the process with VBA, it took around 5–10 minutes, so the manual effort was reduced by approximately 90–95%.
Education
Bachelor of Engineering - Information Technology
SSIPMT
Raipur, C.GSkills
- Microsoft SQL Server
- T-SQL
- SQL Server Management Studio (SSMS)
- SQL
- SQL programming
- T-SQL programming
- PL/SQL
- MySQL
- Stored Procedures
- Views
- UDFs
- Triggers
- Dynamic SQL
- CTEs
- Window Functions
- MERGE
- Transactions
- Indexes
- Joins
- Performance Tuning
- Execution Plans
- Indexing
- Query Optimization
- Blocking Analysis
- ETL
- ETL tools
- SSIS
- Informatica
- ETL development
- Data Migration
- Data Warehousing
- Dimensional modelling
- OLTP/OLAP
- Schema design
- Normalization
- Database design
- Data validation
- Data auditing
- Data Modelling
- Cross-server solutions
- Azure Data Factory (ADF)
- Azure DevOps
- Azure Fundamentals (AZ-900)
- CI/CD
- CI/CD implementation
- Git
- TFS
- Job Scheduling
- Agile methodology
- Agile collaboration
- Agile practices
- Analytical skills
- Incident analysis
- Root cause analysis
- Communication
- Effective communication
- Mentoring
- Stakeholder engagement
- Results-oriented
- Logical reasoning
- Best practices documentation
- Relational database management
- Performance tuning
- Query writing
- Database analysis
- Query writing
- Data Modelling
- Best practices documentation
- Agile methodology
- Relational database management
- Effective communication
- Results-oriented
- Logical reasoning
- Agile practices
Certification
- Microsoft Azure Fundamentals (AZ-900)
- AWS Certified Cloud Practitioner Foundational
Accomplishments
- Automated repetitive SQL development activities, reducing manual effort by approximately 50% and improving consistency of generated scripts.
- Delivered end-to-end SQL and ETL solutions across 20+ enterprise projects for global banking, telecom and other client environments.
- Developed reusable T-SQL frameworks and components, standardizing common database development patterns and improving maintainability and deployment consistency.
- Resolved high-priority production incidents within SLA, performing root-cause analysis and implementing corrective fixes to minimize business disruption.
Languages
English
Upper Intermediate
B2
Hindi
Advanced
C1
Interests
- Exploring emerging AI & data technologies Knowledge sharing Reading Travel
Timeline
SQL Developer & DBA
India Pvt. Ltd
01.2021 - Current
Senior Software Engineer
Accenture
01.2019 - 01.2021
Associate Consultant
Capgemini
01.2016 - 01.2019
Bachelor of Engineering - Information Technology
SSIPMT