Data Analyst Business Intelligence

Nilesh Bamhane

Senior Data Analyst

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

• Results-driven Business Intelligence and Data Analytics professional with 16+ years of hands-on experience designing, building, and managing enterprise BI and data warehousing solutions across Banking, Telecom, and Healthcare.

• Leading end-to-end BI solution design, data modeling (dimensional & relational), and ETL/ELT pipeline development across SQL Server, Oracle, Teradata, and using cloud data platforms like AWS(S3),Snowflake.

• Proven ability to enhance data quality, lineage, and profiling to ensure accurate, compliant, and high- confidence analytics across enterprise ecosystems.

• Built interactive, executive-level dashboards and semantic models from the ground up using Power BI, enabling real-time visibility and C-level decision support in Agile environments.

• Adept at transforming complex datasets into clear, visually impactful reports that influence key decisions.

• Extensive experience in designing Star and Snowflake schemas, managing source-to-target mappings, and streamlining complex data transformations and cleansing processes.

• Implemented data governance, data management, and lineage with tools like Collibra, alongside advanced SQL optimization and data validation for reliable, compliant reporting.

• Experience in data transformation, cleansing, and source-to-target mapping; well-versed in designing Star and Snowflake schemas for analytical workloads.

• Experienced in sales analytics, vendor engagement, market research, and executive reporting—delivering insights that enhance strategy, operations, and organizational performance.

• Led BI and analytics teams through full project lifecycles, promoting Agile best practices, mentoring junior analysts, and driving continuous improvement in data capabilities. Core Competency

• Data Governance & Integrity • MDM & Reference Data • Data Lineage & Cataloging (Collibra)

• Source-to-Target Mapping (STTM) • Data Profiling & Quality • RCA & Data Remediation Planning

• Data Warehousing & Compliance • Data Modeling & Mining • Metadata Management & Reporting

• SQL Optimization ETL/ELT

Informatica PowerCenter

• Project Management: Agile

(Scrum), JIRA, Confluence

• Cloud Platform – AWS(S3), Snowflake

• BI Solutions (Power BI, Advance

Excel)

• DBMS – Teradata, Oracle, SQL

Server

• SDLC, Workflow Development

Professional Experience

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

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

• Developed and maintained interactive BI dashboards using power BI to visualize data quality metrics and regulatory KPIs, enabling data-driven decisions across leadership and operational teams.

• Led enterprise-wide data governance initiatives, including metadata curation, lineage mapping, and classification in Collibra, ensuring compliance with financial and regulatory standards.

• Collaborated cross-functionally to define business intelligence requirements, translate them into technical specifications, and support scalable cloud-based data integration and reporting solutions.

• Conducted proactive data profiling and root cause analysis to identify anomalies, drive improvements in data accuracy, and support forecasting and financial reporting functions.

• Managed governance documentation, policy updates, and exception tracking processes, aligning BI practices with enterprise risk, compliance, and audit requirements.

• Facilitated governance operations by supporting committee logistics, triaging inquiries, and ensuring consistent stakeholder engagement and SLA adherence. Business Data Analyst Nov 2018 – Sep 2023

Barclays Global Service Center Pune, India

• Spearheaded data governance initiatives to standardize and integrate Master and Reference Data, ensuring regulatory compliance, data accuracy, and consistency across systems while resolving data anomalies.

• Designed and optimized data models, ETL/ELT processes, and automated reporting solutions using SQL, Tableau, and Teradata, ensuring efficient data flow and real-time updates for data-driven decision-making.

• Developed and maintained KPIs, scorecards, and interactive BI dashboards, providing actionable insights that empowered leadership to make informed decisions and improve operational performance.

• Conducted comprehensive data discovery and root cause analysis using SQL/PL-SQL, identifying and resolving data quality issues to ensure consistency and accuracy in reporting and analytics.

• Collaborated with cross-functional teams to gather business requirements and streamline ETL processes, ensuring seamless integration of on-premises and cloud-based data sources to support business objectives.

• Managed the integration of diverse data sources into the Enterprise Data Platform, ensuring data quality, completeness, and consistency across systems to support enterprise-wide analytics and reporting needs. Project Lead (Data Management) Feb 2017 – Oct 2018 IDBI Bank (IDBI Intech) Navi Mumbai, India

• Designed and automated ETL workflows to enhance the accuracy, completeness, and timeliness of financial and operational reporting, reducing manual interventions and increasing data reliability.

• Developed scalable BI solutions and automated reporting pipelines using tools like Tableau, SSRS and SQL, significantly improving reporting speed and productivity.

• Built and optimized Tableau dashboards to track key business KPIs, enabling real-time insights and executive-level decision-making across functions.

• Created and maintained data models and metadata repositories using Erwin, ensuring enterprise-wide consistency and adherence to data governance principles.

• Led performance tuning for dashboards and reports, applying techniques like aggregation, indexing, and cache optimization to improve load times and user experience.

• Facilitated internal data audits, exception tracking, and issue remediation, aligning with governance frameworks and collaborating with risk teams to mitigate control gaps.

• Standardized documentation practices for ETL logic, data lineage, and metadata definitions, supporting transparency, compliance, and audit readiness across financial datasets. Senior Consultant Jan 2016 – Feb 2017

Nuffield Health (Acrotrend Solutions) London, England

• Developed comprehensive ETL documentation and SOPs, aligning technical workflows with data quality goals and internal control standards for audit-readiness and operational consistency.

• Liaised with business stakeholders to define and track governance metrics, delivering ad hoc data insights that informed policy refinement and risk mitigation strategies.

• Led end-to-end ETL/ELT pipeline development using Informatica PowerCenter, ensuring scalable, high- performance integration of complex datasets from multiple sources.

• Automated ETL workflows to support real-time delivery of customer and marketing insights, significantly improving agility in business decision-making.

• Engineered ETL solutions incorporating APIs and flat file sources (CSV) to enable real-time booking capabilities and mobile app integration.

• Conducted data validation, quality checks, and governance reviews, ensuring trusted, consistent data across platforms and minimizing downstream reporting issues.

• Optimized ETL performance by addressing bottlenecks, tuning transformations, and improving job scheduling - reducing execution time and resource consumption. Consultant Nov 2013 – Jan 2016

Barclays (Capgemini) Pune, India

• Facilitated operational data governance by implementing data quality dashboards, conducting lineage audits, and integrating metadata standards across enterprise reporting systems.

• Standardized review procedures for data models, code approvals, and issue resolution, ensuring scalable and compliant integration within large-scale Teradata environments.

• Monitored and optimized Teradata performance by analyzing control tables and tuning inefficient SQL queries, significantly reducing CPU utilization and enhancing query responsiveness.

• Led warehouse hygiene initiatives such as dormant table cleanup, space reclamation, and access rights auditing to improve system efficiency, maintainability, and data security.

• Spearheaded data quality remediation by resolving integrity issues, defining validation rules, and establishing automated controls to improve data consistency and trustworthiness.

• Collaborated with cross-functional teams to enforce data governance policies, align metadata and lineage standards, and ensure compliance across ETL pipelines and BI 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 data analytics projects to support strategic planning, including sales budgeting, forecasting, and financial performance tracking.

• Analyzed customer behavior, market trends, and product performance to deliver insights that improved profitability and guided business strategies.

• Designed and optimized complex SQL queries and leveraged Teradata utilities (FastLoad, MultiLoad, FastExport) for efficient data processing.

• Ensured high data quality through routine data warehouse checks, issue resolution, and coordination with BI teams for accurate reporting.

• Collaborated with stakeholders to gather data requirements and conducted cost-benefit analyses to evaluate and optimize product offerings.

Assistant Manager (Card Analytics) Dec 2008 – Aug 2010 Axis Bank Mumbai, India

• Developed dashboards, scorecards, and analytics to monitor customer spending, delinquency, and revenue trends, supporting data-driven decision-making.

• Led pre- and post-launch analyses of credit card products and campaigns, providing actionable insights on customer behavior and revenue impact.

• Performed ETL activities and managed the Master Database used across teams for reporting and analytical needs.

• Optimized database performance through space management, data cleanup, and SQL query tuning to ensure efficient data access.

• Collaborated with business teams (Marketing, Collections, Fraud, Risk) to execute, automate, and monitor targeted campaigns and reporting workflows.

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