Hyderabad, Telangana, India
Developed, implemented, and optimized stored procedures and functions using T-SQL to enhance database performance and functionality.
Designed and developed analytical data structures to support business intelligence and reporting requirements.
Managed and maintained critical databases, ensuring data integrity, availability, and security.
Diagnosed and resolved complex system issues using advanced debugging tools like SQL Profiler, improving problem resolution times.
Conducted regular database backups and implemented recovery processes to prevent data loss and ensure business continuity.
Collaborated with cross-functional teams to integrate database functionality into web applications and portals.
Created web-based dashboards and reporting tools for data visualization, aiding in decision-making processes.
Provided expert consultation on database design, optimization, and troubleshooting to internal stakeholders.
Documented analysis results, provided performance improvement feedback, and revised programs to increase operational efficiency.
Managed the Email Marketing Database and Organizational Database, ensuring comprehensive data collection and integrity.
Implemented database normalization techniques, data cleaning processes, and indexing strategies to optimize query performance and reduce redundancy.
Managed user accounts, granting and revoking access based on organizational requirements.
Monitored server performance, conducted query optimization, and implemented best practices to improve database performance and responsiveness.
Utilized Power BI and DAX (Data Analysis Expressions) to create interactive visualizations and perform advanced data analysis.
Developed and maintained Power BI dashboards and reports, providing key insights to stakeholders.
Managed Power BI Service, including data refresh scheduling and sharing reports and dashboards with stakeholders.