Janya Mehta
Data Analyst | 1.5+ yrs Experience in Banking Domain | Power BI | Excel | SQL | ETL | Python |Data Visualization & Reporting Automation
- Role
- Assistant System Engineer - Data Analyst at Tata Consultancy Services
- Location
- Bengaluru, KA, IN
- LinkedIn followers
- 500 followers
About Janya Mehta
I am a Data Analyst-in-practice with 1.5+ years of hands-on experience in data…
Experience
Assistant System Engineer - Data Analyst
May 2024 — Present · IN
Executed comprehensive data validation and ETL workflows in the Bancs banking domain, managing parameters for Accounts, Instruments, P&L Codes, Trial Balances, and Currencies across multiple entities.• Designed automated Excel-to-Power BI pipelines using Power Query for pre- and post-load validations, enabling real-time refresh and improving data transparency.• Developed interactive Power BI dashboards visualizing new accounts/instruments per entity, highlighting trial balance mismatches, and tracking currency coverage for business and UAT teams.• Built SQL-driven validation reports to cross-check Excel vs. database records, ensuring migration accuracy and early discrepancy detection within the ETL cycle.• Streamlined data quality checks and automated exception tracking, reducing manual validation effort by 50% and accelerating monthly parameter verification.• Collaborated with database administrators and functional teams to resolve inconsistencies, improving load success rate and enabling faster go-live for new entities and currencies.
Education
Bharati Vidyapeeth's College of Engineering
Bachelor's degree, Computer Science
Bharati Vidyapeeth's College of Engineering
Bachelor of Technology - BTech, Computer Science
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.