Data Analyst Business Intelligence

Nilesh Bamhane

Business Intelligence Data Analyst Reporting Specialist

+1-647-***-**** ******.*******@*****.*** LinkedIn Profile Summary:

Accomplished Data Analyst with 16+ years of experience in data analytics, data warehouse development, and integration in agile environments. Adept at performing data profiling, cleaning, wrangling, and validation with a strong background in SQL query writing and data quality checks. Proven ability to collaborate across cross-functional teams, vendors, and stakeholders to develop and implement data governance frameworks and deliver business insights. Expertise in working with large-scale Enterprise Data Lakes, Data Warehouse and proficiency in tools like Tableau, Power BI, and more. Strong leadership in managing data integration projects and enhancing reporting capabilities. Core Competencies:

• Data Analysis & Insights • Data Visualization • Data Governance & Integrity

• KPI & Metric Analysis • Data Modeling & Mining • Metadata Management & Reporting

• SQL, PL/SQL & ETL Development • Data Auditing & Profiling • Agile Project Management (Scrum)

• BI Solutions (Tableau, Power BI, Excel) • Data Warehousing & Architecture • Stakeholder & Vendor Management Professional Experience:

Business Intelligence Analyst Scotiabank (via ABN Tech Corp.) Jan 2024 - Present

(Transitioned from freelance consultant in Canada to full-time role in the USA in Feb 2025) Wealth Management

• Led data governance and lineage initiatives for regulatory and financial reporting, ensuring data accuracy and classification in Collibra.

• Developed Tableau dashboards to track data quality metrics and presented insights to senior leadership for data-driven decisions.

• Worked cross-functionally to optimize data models and streamline cloud migration strategies for more efficient data integration and access.

• Conducted data profiling and audits, uncovering data anomalies and ensuring accurate forecasting and financial decisions.

Business Analyst Barclays Nov 2018 – Sept 2023 Enterprise Data Platform (EDP)

• Developed and optimized data models, reports, and dashboards in Tableau and SQL, enhancing data accessibility, reliability, and automation, while reducing processing time.

• Collaborated with stakeholders to understand business needs, translating them into technical solutions for enhanced business decision-making and data reporting.

• Supported the design and implementation of data governance practices that improved data quality and compliance across enterprise-wide reporting systems. Project Lead IDBI Intech (IDBI Bank) Feb 2017 – Oct 2018 Enterprise Data Warehousing (EDW)

• Led the design and implementation of BI and analytics solutions for financial reporting and analytics, improving operational efficiency through automation.

• Produced interactive Tableau dashboards, empowering business users with real-time data insights on customer behavior and sales performance.

• Optimized ETL processes to ensure consistent and accurate data transformation across large datasets, streamlining reporting and reducing data discrepancies. Senior Consultant Acrotrend (Nuffield Health) Jan 2016 – Feb 2017 Marketing & Customer Analytics

• Managed data governance and reporting protocols, ensuring data consistency and accuracy across marketing analytics platforms.

• Developed and automated ETL solutions, ensuring timely and accurate data delivery for decision-making and strategy development.

• Analyzed customer engagement and usage data to optimize platform features and drive growth. Consultant Capgemini (Barclays) Nov 2013 – Jan 2016 Data Quality & Database Performance Optimization

• Led data quality improvement initiatives, resolving database performance issues and enhancing reporting capabilities.

• Generated statistical reports and conducted trend analysis to optimize business performance and inform management decisions.

Software Engineer Syntel May 2013 – Nov 2013

Data Quality & Reporting Systems

• Identified and resolved data quality issues, ensuring integrity and control throughout the data management process.

• Established a centralized reporting environment, improving team productivity. Senior Executive Vodafone Aug 2010 – Apr 2013

Marketing Ops. & Customer Analytics

• Led data analytics projects to drive strategic business decisions by managing the creation, tracking, and re- forecasting of the annual sales budget, improving financial performance and goal alignment.

• Analyzed market trends, user behavior, and customer relationships to generate actionable insights, enhancing product profitability and refining business strategies for improved company performance. Assistant Manager Axis Bank Dec 2008 – Aug 2010 Credit-Card Analytics

• Developed dashboards and analytics to track customer spending, manage delinquency, and drive revenue growth, collaborating with cross-functional teams (Marketing, Collections, Fraud, Risk) to align strategies and present actionable insights.

• Managed pre- and post-launch analyses for credit card products, evaluating campaign performance, revenue impact, and high-net-worth (HNI) customer behavior to deliver strategic insights that informed business decisions.

Data Analyst eClerx (DELL) Aug 2007 to Dec 2008

• Generated online sales reports and analyzed customer purchase trends to assess Dell.com market performance, providing actionable insights to optimize customer experience and drive revenue growth.

• Developed KPIs and comprehensive reports, leveraging business intelligence data to conduct root cause analysis and identify opportunities for improving Dell.com performance and enhancing overall customer satisfaction.

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