Summary
Overview
Work History
Education
Skills
Languages
Honors And Awards
Languages
Timeline
Generic
Priyanka Rao

Priyanka Rao

Bangalore

Summary

Experienced and dedicated Data Analyst with identifying efficiencies and problem areas with data streams while communicating needs for project. Ability to synthesize Quantitative information.

Comprehensive SQL Developer accomplished at leading database projects for customers and completing each project on time and under budget. Exceptionally skilled in designing and maintaining SQL scripts and providing technical support and guidance to staff and clients.

Overview

9
9
years of professional experience

Work History

SQL Developer

Tata Consultancy Services
Bangalore
05.2021 - Current
  • Analyzed reports and fixed bugs for optimization and performance.
  • Created and scheduled data driven and standard subscriptions in SSRS using data source from SQL server
  • Strong communication(verbal and written) and influencing skills and ability to navigate a global matrixed organization including Creating, directing, participation, supporting, and/or coordinating Virtual teams to achieve objectives
  • Analyzed business requirements and translated them into logical data models.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
  • Designed complex reports using SQL Server Reporting Services.
  • Implemented ETL processes using SQL and additional tools to migrate data across different systems.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Led the migration of databases to new platforms or versions, minimizing downtime and data loss.
  • Optimized SQL queries and stored procedures, reducing execution time by significant percentages.
  • Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
  • Tested databases and performed bug fixes.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.

ETL Developer

Inova Software Services
Bangalore
05.2016 - 04.2021
  • Worked on all phases of Data Warehouse development Lifecycle, from gathering requirements to development, Testing, deploying and solving production issues
  • Demonstrated expertise in ETL tools (Datastage,Talend) to pull the data from different sources like MS SQL server, MySQL and Netezza
  • Ensured databases and archives are protected from Security breaches and data losses
  • Creating jobs in Datastage for reading the source data from SQL to other sources such as Oracle, Salesforce etc
  • Updating Compass Data Mapping document consisting All of the Data models like Invoice, Orders, Local Items, Customer site, Contact and other Master tables in SQL Database
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Resolved complex issues related to ETL process through debugging existing code or writing new programs.
  • Implemented best practices while developing ETL packages like error handling, logging.
  • Analyzed large volumes of data to determine trends and patterns that can be used to improve business processes.
  • Exceeded customer satisfaction by finding creative solutions to problems.

Education

MBA - IT Network Security

ICFAI
Bangalore
07-2019

Bachelor of Science - Electrical, Electronics And Communications Engineering

Dayananda Sagar College of Engineering
Bangalore
06-2015

Associate of Science - PCMB

Sri Bhagawan Mahaveer Jain College
Bangalore
03-2011

Skills

  • MySQL
  • MS SQL Server
  • SSRS
  • Visual Studio
  • GIT
  • Query Optimization
  • Error handling
  • ETL Datastage
  • Data warehouse
  • Data modeling
  • Business requirements analysis
  • Bug fixing
  • Report writing skills
  • Excellent communication
  • Root-cause analysis
  • Query execution plans
  • Multitasking Abilities
  • Software development tools: JIRA
  • SQL reporting
  • Performance evaluation and optimization

Languages

  • English
  • Hindi
  • Kannada
  • Telugu

Honors And Awards

  • Vice-Captain in ASC Public School
  • Help age India
  • Smart Professional Java course
  • Star Team Award
  • Winner of arts in painting
  • Winner in basketball at school level.

Languages

Telugu
Proficient
C2
Kannada
Proficient
C2
English
Proficient
C2
Hindi
Proficient
C2

Timeline

SQL Developer

Tata Consultancy Services
05.2021 - Current

ETL Developer

Inova Software Services
05.2016 - 04.2021

MBA - IT Network Security

ICFAI

Bachelor of Science - Electrical, Electronics And Communications Engineering

Dayananda Sagar College of Engineering

Associate of Science - PCMB

Sri Bhagawan Mahaveer Jain College
Priyanka Rao