MOHAMMED IFTHEKHARUDDIN
Senior BI Developer
Bengaluru
Summary
Business Analyst with 7 years of experience driving data extraction, transformation, and reporting initiatives to enable strategic, data-driven decision-making. Skilled in gathering and documenting business requirements, analyzing processes, and delivering actionable insights using advanced analytics and data visualization tools. Proficient in Microsoft SQL Server, Tableau Prep, Alteryx, Power BI, MicroStrategy Workstation, Microsoft Access, and Tableau Desktop. Experienced in writing stored procedures, optimizing SQL queries and joins, and managing complex data models. Strong background working in Agile environments using Jira (Kanban) and GitHub to streamline workflows and support cross-functional collaboration. Adept at translating data into clear, meaningful reporting to align technical solutions with business objectives
Overview
7
7
years of professional experience
2018
2018
years of post-secondary education
4
4
Languages
Work History
Technical Senior Business Analyst
Wells Fargo
12.2024 - Current
- Spearheaded the Output Management Transaction project, resolving client-reported trade confirmation discrepancies to improve accuracy and service quality.
- Managed and prioritized Jira tickets across multiple projects, ensuring timely resolution and alignment with business requirements.
- Performed impact and gap analysis for Jira requests, ensuring technical feasibility and alignment with business objectives.
- Utilized advanced SQL procedures to investigate and diagnose errors in trade confirmation data, ensuring timely identification of root causes.
- Ensured adherence to Agile/Scrum processes by maintaining properly groomed backlogs, and updating ticket statuses regularly.
- Analyzed and validated PDF trade confirmations and statements to ensure accuracy, completeness, and compliance with internal standards.
- Developed SQL scripts to extract and validate critical data for the Confirm QC process, enhancing operational efficiency, and reducing manual checks.
- Performed detailed verification of email communication flows between Venture IIO and Mobius, ensuring proper compliance tracking, and audit readiness.
- Conducted mid-month and month-end trade confirmation reviews using Broadridge samples, strengthening quality checks, and improving data integrity.
- Executed UAT trade sample reviews to support the transition from Venture to Broadridge, identifying gaps early, and facilitating a smoother vendor migration.
- Managed the phased migration from Venture to Broadridge, streamlining and automating the trade confirmation and statement generation process.
- Led requirement-gathering workshops to translate business needs into clear functional requirements, project objectives, and deliverables.
- Maintained strong stakeholder alignment through transparent communication, timely updates, and proactive management of expectations across teams.
- Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
Senior Business Analyst
Metro Global Solution
09.2023 - 12.2024
- Led the development of the FSD and Vulnerability Dashboards, coordinating cross-functional stakeholders to define, refine, and validate FSD requirements.
- Engineered scalable data structures by building analytical cubes using MSI Developer, and integrating them with objects to support robust dataset generation.
- Designed and translated Figma wireframes into detailed technical dossiers, ensuring full alignment with UX and design standards.
- Ensured data accuracy and reliability through rigorous quality checks, leveraging GCP to execute and validate complex SQL queries across datasets.
- Managed the end-to-end dossier development lifecycle, including environment provisioning, QA testing, defect resolution, and code reviews.
- Oversaw the production deployment of dossiers, administering post-launch maintenance, enhancements, and progress tracking through Jira.
- Enhanced Looker Studio reporting capabilities by integrating Google platform services with GCP, streamlining data extraction, and visualization workflows.
- Elevated team capabilities by creating structured training modules for interns, and conducting in-depth project walkthrough to support onboarding and knowledge transfer.
- Advanced team expertise by developing training modules for interns, and leading comprehensive project walkthrough.
Senior Business Operations Analyst
Wells Fargo
01.2022 - 09.2023
- Automated migration from MS Access to Tableau using Alteryx ETL workflows, ensuring accurate data transformation and alignment with legacy business logic.
- Automated 22 manual reports by migrating from MS Access to Tableau, leveraging Tableau Prep for ETL optimization
- Optimized ETL processes using Tableau Prep and Alteryx, reducing data load times by 50%, and accelerating reporting cycles.
- Resolved 30+ Jira tickets per sprint across multiple client projects, ensuring the timely delivery of business-critical solutions.
- Monitored Jira, Confluence workflows to track progress, identify bottlenecks, and support on-time delivery of sprint commitments.
- Streamlined Tableau data source distribution across development projects, enabling consistent integration, and scalable reporting infrastructure.
- Designed and deployed interactive Tableau dashboards with bar charts, KPI tables, and dynamic filters to support strategic business decisions.
- Led User Acceptance Testing (UAT), coordinating stakeholder access to Tableau test environments to expedite feedback and approval cycles.
- Implemented version control and facilitated peer code reviews via GitHub, enhancing collaboration, traceability, and stakeholder engagement.
- Improved report deployment efficiency by transitioning from email-based delivery to direct Tableau Server publishing, increasing accessibility, and reducing manual effort.
- Developed advanced table calculations and custom filters in Tableau to meet unique business requirements, demonstrating analytical precision and adaptability.
Business Operations Analyst
Wells Fargo
06.2020 - 11.2021
- I optimized the Microsoft Access and CID Reporting project, leveraging advanced SQL queries to extract data from diverse database servers and convert it into various formats, including flat files and Excel.
- Expertly interpreted client needs from JIRA requests, ensuring precise data delivery for critical reporting.
- Generated Jira dashboards and reports to track team performance, sprint progress, and KPI metrics for management reviews.
- Developed and disseminated customized reports via Microsoft Access to key internal teams—Tax, Finance, and FCT—adhering to strict daily, weekly, and monthly schedules.
- Collaborated within a team to gather and analyze end-user requirements, enhancing the Business As Usual (BAU) processes, and identifying issues in existing MS Access report executions.
- Utilized Teradata to craft queries and extract WCIS data, facilitating the generation and implementation of EMEA reports.
Business Analytics Practice
JK Techno Soft Ltd
08.2019 - 05.2020
- Designed the enhancement of Sony Music Analytics dashboards, focusing on advanced filter implementation including level of detail expressions.
- Engineered sophisticated audio platform dashboards for industry giants such as Sony, enhancing data visualization through advanced filters, user preferences, and chart interactions.
- Utilized a comprehensive suite of filtering techniques, including extract, data source, dimension, measure, and table calculations to refine and optimize data visualization.
BI Analyst
JK Techno Soft Ltd
10.2018 - 08.2019
- Optimized the Trainline Support Project, concentrating on meticulous needs assessment and comprehensive data analysis from source databases.
- Crafted a sophisticated dashboard featuring advanced filters, elevating data interaction and strategic decision-making capabilities.
- Demonstrated proficiency in SQL for efficient and robust data extraction, facilitating flawless integration with reporting platforms.
- Engineered and executed cutting-edge visualization and report-level filters within Power BI, enhancing data presentation and insights.
Education
Bachelor of Engineering - Mechanical Engineering
GM Institute of Technology
Davangere, Bengaluru10-2018
Skills
Tableau Desktop
Achievements
Received the Spotlight Award for playing a pivotal role in designing and delivering high-impact reports from an Insights & Performance (I&P) perspective and proposing reporting solutions to multiple business units. Successfully created and implemented 12 critical business and regulatory reports, recognized for improving decision-making, data visibility, and operational efficiency. Enhanced several existing regulatory reports by adding meaningful insights, improving accuracy, and increasing usability for end users.
Independently automated 22 manual reports using scheduled workflows, significantly reducing data-quality risks and eliminating errors caused by manual updates. Additionally, supported team development by transitioning BAU processes, creating detailed procedure documents for reporting controls, and mentoring colleagues to strengthen process understanding and execution
GITHUB
- GitHub Activity
- I have made a branch on GitHub for this additional personal dashboard development on the power bi.
- Https://github.com/ifthekharK/Work-File
Timeline
Technical Senior Business Analyst
Wells Fargo
12.2024 - Current
Senior Business Analyst
Metro Global Solution
09.2023 - 12.2024
Senior Business Operations Analyst
Wells Fargo
01.2022 - 09.2023
Business Operations Analyst
Wells Fargo
06.2020 - 11.2021
Business Analytics Practice
JK Techno Soft Ltd
08.2019 - 05.2020
BI Analyst
JK Techno Soft Ltd
10.2018 - 08.2019
Bachelor of Engineering - Mechanical Engineering
GM Institute of Technology