Shangamitra Rajavelu
PL/SQL Developer;Data Analyst
Chennai
Summary
IT Analyst with 6.5 years experience in managing large-scale, complex databases. Skilled in SQL and database management systems with the precedence in the following: SQL programming language proficiency with the ability to write complex queries and optimize SQL code. Understanding of the software development life cycle, including requirements gathering, design, development, testing, and deployment. Familiarity with database performance tuning techniques such as indexing, query optimization, and query tuning. Strong understanding of database design and data modelling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
6
6
years of professional experience
2
2
Certifications
2
2
Languages
Work History
SQL Developer/Data Analyst (Snowflake, Power BI, MSSQL)
Tata Consultancy Services
05.2024 - Current
- Ensured data integrity by implementing referential constraints, foreign keys, primary keys, unique indexes, check constraints, etc., within database schema
- Proficient in Joins queries and window functions like rank, dense rank, row number etc
- Developed and created data models in Power BI in collaboration with team members along with interactive dashboards
- Worked on DAX queries, calculated columns, RLS, star schema, snowflake schema, OLAP databases
- Extensively used page, report, visual and drill through filters in power bi
- Optimized and fine-tuned complex queries
- Experienced in Snowflake Clone and timetravel
- Created Paginated reports using SAP and Crystal in addition to power BI reports
- Worked closely with project managers to deliver quality results within deadlines
PL/SQL Developer (MSSQL, Power BI)
Tata Consultancy Services
10.2021 - 04.2024
- Created complex queries, functions, procedures, triggers and cte’s/subqueries for data extraction and data manipulation
- Collaborated with Infrastructure Migration team to migrate SQL databases from On-Premises to Azure
- Designed and implemented star schema and OLAP models to enhance data retrieval efficiency
- Developed Data Visualization and dashboards using POWER BI
- Wrote optimized SQL queries for integration with other applications
- Automated manual reports using SSIS, and Utilized Power BI to create daily, weekly, and monthly dashboards
- Worked closely with the data warehouse team to develop and implement data analysis scripts using Python and SQL to model transactional data, and generating comprehensive reports from extensive business and market datasets
PL/SQL Developer (Oracle, Informatica)
Tata Consultancy Services
09.2018 - 09.2021
- Streamlined customer inquiries process by writing ad-hoc queries
- Designed database tables, structure and storage procedures and developed complex SQL queries to extract, analyze, and manipulate data from multiple databases
- Created mappings, sessions, workflows, and implemented best practices for data extraction, transformation, and loading
- Troubleshooted and resolved issues related to batch loads and slow running queries or deadlocks, data quality, and performance tuning
- Worked in designing, developing, testing, and implementing ETL processes using Informatica PowerCenter
Skills
- Advanced PL and SQL programming
- Performance Tuning
- Stored procedures development
- SQL Optimization
- Report preparation
- Object-Oriented Programming
- Data modeling
- Data integration
ProgrammingLanguages:
- SQL ,PL/SQL
- Python (Pandas, NumPy,SQLalchemy,Matplotlib)-Secondary
- Unix
Tools/Software:
- SQLserver,OracleDeveloper,IDERA,SSMS,SSIS
- Snowflake
- Informatica 1053
- Power BI,SAP BO 41/43,SAP Crystal report 2020
- Autosys
Soft Skills:
- Analytical Thinking
- Teamwork and collaboration
- Problem-solving
- Team supervision
- Shift scheduling
- Overseeing daily activities
Certification
Azure Data Fundamentals, DP 900
Timeline
Power BI Data Analyst Associate, PL300
01-2025
SQL Developer/Data Analyst (Snowflake, Power BI, MSSQL)
Tata Consultancy Services
05.2024 - Current
Azure Data Fundamentals, DP 900
02-2023
PL/SQL Developer (MSSQL, Power BI)
Tata Consultancy Services
10.2021 - 04.2024
PL/SQL Developer (Oracle, Informatica)
Tata Consultancy Services
09.2018 - 09.2021
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
R. Kishore KumarR. Kishore Kumar
Vice President at RBS Business Services Pvt. LtdVice President at RBS Business Services Pvt. Ltd