About
Results-driven Data Analyst with 9+ years of experience specializing in complex SQL query optimization, Power BI dashboard engineering, enterprise data modeling, and automated ETL workflows. Proven track record of boosting reporting efficiency by 30%+, enhancing SQL execution performance by 25%+, and reducing manual data prep by ~40% across Retail, Healthcare, Banking, and Telecom sectors.
Skills & Expertise (24)
Work Experience
Data Analyst
Tata Consultancy Services Ltd. (TCS)
Nov 2022 - Present
Led enterprise data modeling (LDM, PDM, CDM) and data analytics initiatives using Python (Pandas, NumPy) and SQL across retail, banking, and healthcare domains, boosting report generation efficiency by 30%. Developed end-to-end Source-to-Target Mapping (STTM) documentation defining business logic, data transformation rules, and pipeline schema structures. Engineered and optimized complex SQL queries and PL/SQL scripts across Oracle SQL, MS SQL Server, and Snowflake, achieving a 25%+ performance enhancement. Built interactive Power BI dashboards with complex DAX measures and Power Query M logic to deliver real-time operational insights to executive stakeholders. Automated recurring data ingestion and reporting workflows using Python scripts, SQL, and Power Query, reducing manual data preparation effort by ~40%. Implemented rigorous data governance standards, including validation, standardization, and quality profiling, to maintain high data consistency across production database environments. Collaborated with Data Architects, SMEs, and business stakeholders to design ER diagrams, metadata structures, and schema enhancements using ER Studio. Executed deployment validation activities and schema consistency checks across high-volume enterprise databases to ensure zero post-deployment data accuracy issues.
Data Analyst – Telecom Analytics (Project: BSNL CDR2)
Tenet Computer & Communications Pvt. Ltd.
Jan 2022 - Sep 2022
Analyzed large-scale operational billing datasets, Call Detail Records (CDR), and transaction logs using Python (Pandas/NumPy) to identify system anomalies and enhance revenue reporting accuracy. Prepared key operational KPIs and executive analytical reports from raw database records to drive strategic decision-making. Supported database schema updates, data migrations, and validation scripts across DEV, QA, and PROD environments. Executed automated data validation routines and integrity checks using Linux Shell Scripting to prevent data corruption and ensure compliance.
Data Analyst
Shreya Life Sciences Pvt. Ltd.
Mar 2017 - Jan 2022
Analyzed complex relational datasets and optimized SQL queries and PL/SQL procedures to significantly boost business report generation speed. Designed custom analytical queries, database routines, and ETL logic tailored to dynamic business analytics requirements. Built analytical dashboards, commercial performance reports, and data audit summaries to accelerate operational growth. Authored technical documentation, data models, analytical finding summaries, and query optimization recommendations.
Education
Bachelor of Technology (B.Tech.) in Computer Science - Netaji Subhas Institute of Technology, Patna
2009 - 2013 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Open to Relocation
Skills (24)
Click a skill to find developers with the same skill
