Lokesh Naidu Allam

3+ years of experience in SQL development and data analysis, including writing complex SQL queries, joins, and subqueries across relational databases.

Experience in creating Power BI reports and dashboards using Power Query, DAX, and data modeling for reporting and analysis needs. Involved in data preparation, transformation, and reporting, supporting data accuracy and consistency. Worked with SQL Server, MySQL, and PostgreSQL, with basic working knowledge of Microsoft Azure, including Azure SQL Database.

SQL/Power BI Developer at TCS (2022-02 – 2025-06)

• Developed and optimized SQL queries to support data extraction, transformation, and loading (ETL) processes for the CELCOM customer data management system.
• Designed and maintained database schemas, tables, stored procedures, views, and triggers to support efficient data storage, retrieval, and automation.
• Performed data analysis, validation, and quality checks to ensure data integrity, consistency, and accuracy across reporting and operational datasets.
• Conducted SQL performance tuning and query optimization to improve application responsiveness and reduce execution time.
• Provided database production support and troubleshooting, ensuring timely issue resolution and minimal impact to business operations.
• Collaborated with cross-functional teams to gather requirements and support solution design and system-related upgrades.
• Assisted in data preparation and query support for reporting and analysis, with basic exposure to tools used for report and dashboard creation (Power BI).
• Gained basic exposure to Microsoft Azure, including Azure SQL Database concepts and cloud-based data environments.

SQL Developer at CELCOM Digi (2022-02 – 2025-06)

Network Modernization & Customer Data Integration SQL support for integrating and modernizing customer and network data as part of 4G/5G-ready network initiatives.

• Developed and optimized SQL queries to support ETL processes for customer data management systems.
• Provided SQL production support and troubleshooting, ensuring minimal downtime and timely issue resolution.
• Performed data validation and consistency checks during data integration activities.
• Monitored database performance and identified bottlenecks through regular audits and query reviews.

SQL Developer at TCS (2022-02 – 2025-06)

Enterprise Reporting & Data Quality Support System SQL-based reporting and data preparation support for business and operational analysis.

• Created and maintained SQL queries, views, and stored procedures to support reporting and analytical requirements.
• Assisted in data preparation, transformation, and validation to ensure accurate and reliable reporting datasets.
• Provided query support for reports and dashboards, with basic exposure to Power BI reporting tools.
• Gained basic exposure to Azure SQL Database, supporting cloud-based data environments and understanding data access patterns.

B.Tech in ECE – MBU Mohan Babu University (2021-07)