It's me Vana

SQL Developer and Power BI Developer with 4.4 years of experience at Tata Consultancy Services (TCS), delivering enterprise-level analytics and reporting solutions for global clients. Started career on the PepsiCo project (1 year), working on ServiceNow Administration and SQL development, and currently supporting the Saudi Telecom Company (STC) project (3.4 years) as a SQL Developer and Power BI Developer. Strong expertise in Power BI dashboards, star-schema data modeling, advanced DAX, Oracle SQL, SingleStore SQL, data marts, data profiling, and Kafka-based incremental pipelines, enabling scalable, secure, and high-performance BI solutions.

SQL Developer | Power BI Developer - Tata Consultancy Services (TCS)

(2020-10)

Saudi Telecom Company (STC) Project – 3.4 Years

• Designed and developed enterprise Power BI dashboards for telecom B2B users, supporting executive and operational reporting.
• Built scalable and optimized star-schema data models to improve report performance and usability.
• Developed advanced DAX measures for KPIs, SLA metrics, YoY/MoM trends, and business performance indicators.
• Implemented Row-Level Security (RLS) to ensure secure, role-based data access.
• Applied incremental refresh strategies to efficiently manage large datasets.
• Developed and optimized complex SQL queries, views, and stored procedures using Oracle SQL and SingleStore SQL.
• Performed data profiling to analyze data completeness, accuracy, uniqueness, and consistency.
• Designed and maintained data marts for agreement and quote analytics.
• Conducted data validation and reconciliation between source systems and reporting layers.
• Identified and resolved data quality issues such as null values, duplicates, and data mismatches.
• Integrated Kafka-based incremental pipelines to load new and updated records into reporting tables.
• Supported near real-time reporting by aligning Kafka ingestion with Power BI datasets.
• Monitored pipelines and resolved load failures, latency issues, and lock wait timeouts.
• Worked closely with business analysts and stakeholders to gather requirements and translate them into BI solutions.
• Provided production support, root cause analysis, and performance tuning for reports and data pipelines.

SQL Developer | ServiceNow Administrator - Tata Consultancy Services (TCS)

(2019-10 - 2020-10)

PepsiCo Project – 1 Year

• Worked on ServiceNow Administration, supporting ITSM modules such as Incident, Problem, Change, and Service Requests.
• Developed and optimized SQL queries for operational and reporting requirements.
• Supported SLA tracking, operational dashboards, and data analysis for business users.

Bachelor of Technology - Mechanical Engineering - DMSSV H College of Engineering, Machilipatnam