Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sony Kumari Thakur

Greater Noida

Summary

With a proven track record at Accenture, I excel in PL/SQL development and project management, enhancing query performance by 30% and mentoring teams for productivity boosts. Expert in database optimization and adept at fostering stakeholder collaborations, my approach combines technical prowess with leadership finesse to drive significant business advancements.

Overview

10
10
years of professional experience

Work History

Associate Manager

Accenture
Noida
09.2021 - Current
  • Designed and optimized complex PL/SQL stored procedures, triggers, and functions, achieving a 30% improvement in query performance for critical business processes.
  • Led the creation and maintenance of database schemas for scalable solutions supporting 10+ cross-functional applications, ensuring 99.9% data availability.
  • Collaborated with stakeholders to develop ETL processes for migrating over 50 million records from legacy systems, ensuring zero data inconsistencies.
  • Mentored junior developers on best practices in database design, PL/SQL optimization, and error handling, improving team productivity by 20%. Implemented database monitoring and tuning strategies, reducing query execution time by 40% through indexing and optimization.
  • Participated in code reviews and adhered to best practices for coding, security, and compliance standards. Mentor and provide technical leadership to junior developers, reviewing their code and guiding them in database best practices.
  • Create and maintain comprehensive documentation for all database objects, processes, and solutions. Collaborate with both technical and non-technical stakeholders.
  • Created monthly reports outlining progress on key initiatives.
  • Evaluated performance of team members and provided consistent coaching to improve skills.
  • Handled responsibilities successfully in manager's absence.
  • Developed and implemented strategies to ensure cost-efficient operations.
  • Mediated conflicts between employees and facilitated effective resolutions to disputes.
  • Prioritized and delegated tasks for efficient completion within team environment.
  • Maintained accurate records of employee attendance and payroll information.
  • Reviewed employee performance and provided ongoing feedback and coaching to drive performance improvement.
  • Planned and led team meetings to review business results and communicate new and ongoing priorities.

Technical Lead

HCL
Noida
12.2019 - 09.2021
  • Developed and managed stored procedures, views, and functions to support real-time data analysis for high-traffic applications with 5K+ concurrent users.
  • Performed extensive performance tuning for Oracle databases, improving system scalability by 25% and reducing downtime by 15%.
  • Automated daily batch processes for data integration, cutting manual effort by 40 hours per month.
  • Conducted code reviews for the team, ensuring adherence to security and compliance standards.
  • Supported QA teams in executing test plans for database changes, reducing bugs in production by 35%.
  • Recommended improvements to facilitate team and project workflow.
  • Assessed code during testing stage to determine potential glitches and bugs.
  • Performed root cause analysis for production incidents and identified permanent fixes.
  • Managed multiple tasks within tight deadlines while ensuring quality control throughout the process.
  • Developed and maintained technical documentation for software systems.
  • Collaborated closely with team members to achieve project objectives and meet deadlines.

Senior Software Engineer

NIIT
Greater Noida
05.2019 - 11.2019
  • Created optimized SQL queries and triggers for enterprise-level applications, reducing data retrieval times by 50%.
  • Collaborated with application developers to build custom data solutions, enhancing system functionality for more than five business-critical applications.
  • Documented database objects and processes to standardize development and maintenance practices across the team.

  • Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.
  • Assessed code during testing stage to determine potential glitches and bugs.
  • Documented software designs and architecture for future reference and maintenance.
  • Collaborated with team members to ensure successful project completion within timeline constraints.
  • Performed unit testing on created database code prior to release.

Senior Software Engineer

Decimal Technology
Gurugram
05.2018 - 10.2018
  • Provided application support for the AVCD application, resolving tickets and troubleshooting issues to ensure system stability.
  • Gained familiarity with Power BI code for data visualization while addressing user requirements. Collaborated to document recurring issues, improving support processes.
  • Worked as L2 operation and resolved tickets raised by users

PLSQL Developer

Indiamart Intermesh LTD
Noida
01.2015 - 04.2018
  • Designed and implemented database structures for an e-commerce platform handling over 1 million product listings, ensuring high data availability.
  • Optimized stored procedures and indexing strategies, reducing query response time by 30%.
  • Managed database security protocols, ensuring compliance with organizational standards and mitigating potential risks.
  • Built automated reports for senior management, streamlining data insights, which were used by management in decision-making.
  • Analyzed code and corrected errors to optimize output.
  • Designed and developed complex SQL queries for data analysis and extraction to support business requirement.
  • Worked on some DBA level task to create and maintain test database environment ,kill any stuck/long running queries in the database, create database user and provide necessary privileges,take backups of database using impdp and expdp

Education

Bachelor of Science - Computer Science

Greater Noida Institute of Information Technology
Greater Noida
03-2015

12th - Science

Sunshine Prep High School
Bihar
03-2010

10th -

Sunshine Prep High School
Bihar
03-2008

Skills

PL/SQL Development

Query Optimization and Performance Tunings

Data Migration and ETL Processes

Database Design and Normalization

Stored Procedures, Functions, and Triggers

Agile and Scrum Methodologies

Cloud Database Technologies (AWS, Redshift)

  • Presentations
  • Public speaking
  • Staff training and development
  • Project management

Timeline

Associate Manager

Accenture
09.2021 - Current

Technical Lead

HCL
12.2019 - 09.2021

Senior Software Engineer

NIIT
05.2019 - 11.2019

Senior Software Engineer

Decimal Technology
05.2018 - 10.2018

PLSQL Developer

Indiamart Intermesh LTD
01.2015 - 04.2018

Bachelor of Science - Computer Science

Greater Noida Institute of Information Technology

12th - Science

Sunshine Prep High School

10th -

Sunshine Prep High School

Similar Profiles

CREATE PROFILE
Sony Kumari Thakur