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
Bangalore07-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