Data Analyst or Business Intelligence Analyst or Data Governance

Nilesh Bamhane

Senior Business Intelligence Analyst

Franklin, TN 37067 +1-615-***-**** ******.*******@*****.*** LinkedIn Profile Summary

• Senior Business Intelligence Analyst with 16+ years of experience delivering enterprise BI, data governance, and advanced analytics solutions across Banking, Telecom, and Healthcare domains.

• Expert in BI architecture, data modeling (dimensional/relational), and ETL/ELT pipeline development using SQL Server, Oracle, Teradata, Snowflake, AWS (S3), and Informatica.

• Skilled in designing executive dashboards and self-service analytics using Power BI and Tableau, driving insights for C-level decision-making in Agile environments.

• Proven leadership in implementing enterprise data governance, lineage tracking, and data quality frameworks using Collibra and advanced SQL tuning.

• Strong collaborator across IT, business, and compliance teams, delivering secure, scalable, and high- performing BI environments that support regulatory and strategic needs. Functional Expertise

• Mortgage & Financial Reporting Analytics (risk, compliance, customer satisfaction)

• KPI Design, Data Visualization & Self-Service BI

• SQL & DAX Querying, Power Query, ETL/ELT Development

• Cross-Functional Stakeholder Engagement

• Data Quality, Integrity Audits, and Metadata Management

• Data Modeling (Dimensional, Star, Snowflake) and Performance Optimization Technical Skills

•

•

•

Category Technologies / Tools

Data Platforms Snowflake, SQL Server, Oracle, Teradata, AWS S3 BI Tools Power BI, Tableau, SSRS, Advance Excel

ETL Tools Informatica PowerCenter, Custom SQL Pipelines Governance Collibra, Data Lineage, Profiling

Languages SQL, PL/SQL, Python (Pandas)

Methods Agile, Scrum, SDLC

Professional Experience

Business Intelligence Analyst Scotiabank (ABN Tech Corp.) TN, USA Feb 2025 – Present

(Contract- Full Time) ON, Canada Jan 2024 - Jan 2025

• Designed and maintained Power BI dashboards to visualize data quality and regulatory KPIs for executive and operations teams.

• Managed full lifecycle of BI projects: requirements gathering, data modeling, ETL mapping, SQL development, QA and delivery.

• Led enterprise data governance initiatives; executed metadata curation, lineage mapping and classification in Collibra.

• Conducted proactive data profiling and root cause analysis, improving accuracy of forecasting and financial reporting.

• Authored and managed governance documentation, policy updates, and SLA-based exception tracking.

• Supported data governance operations—committee coordination, inquiry triage, stakeholder engagement.

• Collaborated cross-functionally to define business intelligence requirements, translate them into technical specifications, and support scalable cloud-based data integration and reporting solutions. Business Intelligence Analyst Nov 2018 – Sep 2023

Barclays Global Service Center Pune, India

• Spearheaded MDM and reference data governance, integrating domains like customer and product for regulatory compliance.

• Developed dimensional and relational data models; led ETL/ELT pipelines using Informatica, SQL, and Teradata.

• Created interactive Tableau dashboards and KPIs, enabling leadership to make informed, data-driven decisions.

• Used SQL/PL-SQL for data discovery and issue remediation, including SQL query optimization to improve reporting reliability.

• Coordinated cross-functional initiatives to integrate on-premises and cloud sources into a unified analytics platform.

• Led data migration from on-premises databases to AWS S3 storage, reducing response times for historical data access and eliminating delays from backup tape retrieval for legacy datasets. Project Lead (Data Management) Feb 2017 – Oct 2018 IDBI Bank (IDBI Intech) Navi Mumbai, India

• Developed and maintained scalable BI solutions and automated reporting pipelines using Tableau, SSRS, and SQL, significantly enhancing report delivery speed and reducing manual efforts.

• Designed interactive dashboards and visualizations to track critical business KPIs, enabling real-time insights and strategic decision-making at the executive level.

• Engineered and optimized ETL workflows to ensure accurate, complete, and timely data delivery for financial and operational reporting, improving data reliability across systems.

• Created and managed dimensional and relational data models using tools like Erwin, supporting consistent reporting structures and enterprise-wide data standardization.

• Executed performance tuning for reports and dashboards, applying techniques such as aggregation, indexing, and cache optimization to improve user experience and load efficiency.

• Led internal data quality reviews and exception tracking efforts, collaborating with risk and compliance teams to ensure reporting integrity and adherence to governance standards. Senior Consultant Jan 2016 – Feb 2017

Nuffield Health (Acrotrend Solutions) London, England

• Developed and maintained ETL/ELT pipelines using Informatica PowerCenter, enabling seamless integration of multi-source data into centralized reporting systems for analytics and decision-making.

• Created detailed ETL documentation and standard operating procedures (SOPs) to align data workflows with audit requirements, improving transparency and compliance readiness.

• Collaborated with stakeholders to define governance metrics and deliver on-demand insights, supporting business units with actionable data for strategic planning and risk reduction.

• Automated real-time ETL processes to deliver customer and marketing analytics, improving responsiveness and enabling data-driven business decisions.

• Performed data validation, quality assurance, and issue remediation, ensuring accuracy and consistency across business intelligence platforms and reporting environments.

• Enhanced ETL performance through transformation tuning and efficient job scheduling, reducing data load times and optimizing resource utilization.

Consultant Nov 2013 – Jan 2016

Barclays (Capgemini) Pune, India

• Designed and implemented data quality dashboards and lineage audits, enabling proactive issue detection and enhancing trust in enterprise reporting systems.

• Streamlined data model and SQL code review processes, ensuring scalable, standards-compliant integration within large Teradata-based BI environments.

• Optimized query performance in Teradata by tuning SQL and analyzing control tables, resulting in reduced CPU usage and faster analytics delivery.

• Led data warehouse optimization initiatives, including dormant table cleanup, space management, and access audits to improve performance and data governance.

• Resolved critical data integrity issues through validation rule design and automated controls, significantly improving accuracy and consistency in downstream BI reporting.

• Collaborated with business and technical teams to align metadata, data lineage, and governance policies, ensuring compliance and consistency across ETL workflows and reporting layers. Software Engineer May 2013 – Nov 2013

Syntel Mumbai, India

• Collaborated with stakeholders to gather and analyze data requirements, translating them into actionable data and reporting solutions.

• Wrote and optimized SQL queries and ETL logic to support accurate data extraction, transformation, and loading across systems.

• Identified and resolved data quality and integrity issues, ensuring reliable and consistent data for analytics and reporting.

• Contributed to the development of a centralized reporting environment and supported team onboarding through effective knowledge sharing.

Senior Executive Aug 2010 – Apr 2013

Vodafone Mumbai, India

• Led end-to-end data analytics initiatives supporting strategic functions such as sales forecasting, budgeting, and financial performance tracking to inform executive decision-making.

• Delivered actionable insights by analyzing customer behavior, market trends, and product performance, directly contributing to revenue optimization and business growth strategies.

• Developed and optimized advanced SQL queries using Teradata utilities (FastLoad, MultiLoad, FastExport) to streamline large-scale data extraction, transformation, and reporting processes.

• Maintained high data quality through proactive warehouse audits and issue remediation, ensuring accuracy and consistency in business intelligence outputs.

• Collaborated with cross-functional stakeholders to define reporting requirements and conducted cost- benefit analyses, guiding product and service optimization decisions with data-driven recommendations. Assistant Manager (Card Analytics) Dec 2008 – Aug 2010 Axis Bank Mumbai, India

• Designed and delivered interactive dashboards, scorecards, and analytics to track customer spending, delinquency, and revenue trends, enabling strategic, data-driven decisions.

• Conducted pre- and post-launch analysis of credit card products and campaigns, uncovering customer behavior insights and measuring financial impact to refine future initiatives.

• Managed ETL processes and maintained a centralized Master Database, supporting consistent, reliable reporting and analytical access across multiple business functions.

• Improved database efficiency through SQL query tuning, space optimization, and data cleanup, enhancing data access speed and reducing system latency.

• Collaborated with cross-functional teams across Marketing, Risk, Fraud, and Collections, automating campaign tracking and streamlining reporting workflows for better performance monitoring. Data Analyst Aug 2007 to Dec 2008

DELL (eClerx) Mumbai, India

• Generated online sales reports and analyzed customer purchase behavior to evaluate Dell.com performance and support revenue growth initiatives.

• Designed KPIs and conducted root cause analysis using BI tools to uncover performance gaps and improve customer experience on Dell.com.

• Maintained and queried local and Citrix-based databases to support recurring and ad hoc reporting needs across teams.

• Conducted live website testing and content audits, ensuring accurate product categorization, image quality, and catalog updates.

Professional Certifications

• Teradata Vantage Certified Associate – Advanced SQL Engine Teradata

• Oracle9i SQL IZO-007 (OOC) Oracle

Education

• Master’s in computer science (MSc) University of Mumbai 2005 – 2007

• Bachelor’s in computer science (BSc) University of Mumbai 2002 - 2005

Contact this candidate