Tushar Chavan
Montreal
Summary
Seasoned Architect and BI Developer with 18+ years of experience in designing and implementing data-driven solutions.
Expertise in leading the architecture, development, and optimization of reporting solutions, translating business requirements into actionable insights, and enhancing business intelligence infrastructure.
Senior Manager and BI Architect at Capgemini with 18 years of experience in architecting solutions using Tableau, QlikView, SAP Business Objects, and Microsoft Power BI, with 12 years at Morgan Stanley as a Business Intelligence Analyst and SME for dashboarding and reporting.
Extensive experience in all SDLC phases, including analysis, design, testing, and implementation. Skilled in effort estimation, risk analysis, test case generation, and proficient in defect tracking with ALM/QC and JIRA.
Skilled in creating and optimizing reports and dashboards with a focus on usability, performance, and data warehousing, including architecture, schema design, dimension modeling, SCDs, and performance optimization.
Proficient in automation, SQL, VBA, Power Query, Python and Excel to streamline reporting and improve efficiency.
Led and delivered technical training for senior management and business users, enhancing their engagement with complex systems.
Strong T-SQL expertise, including designing and optimizing stored procedures, views, triggers, and functions to enhance database performance.
Managed and executed releases across multiple environments, ensuring smooth deployment through change management processes, and contributed to version upgrades, migrations, post-migration testing, UAT, and production releases.
Experienced in QlikSense and DOMO, creating prototypes and delivering user training to drive adoption.
Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills.
Ready to tackle new challenges and advance organizational objectives with dedication and enthusiasm.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Senior Manager / BI Architect and Lead
Morgan Stanley
08.2012 - Current
- Architected reporting frameworks and BI solutions, including development and maintenance of interactive reports and dashboards using various BI tools - Tableau, Qlikiew and SAP Business Objects suite
- Implemented techniques to integrate multiple datasets efficiently
- Automated data refresh schedules and managed permissions
- Administered scheduling, access control and data security, ensuring integration with multiple environments
- Led environment migration and version upgrades
- Conducted analysis of business data to identify trends and key metrics that supported business decisions and define KPIs and improve reporting accuracy
- Created stored procedures and views for reporting needs, providing production support and ensuring smooth deployments during SIT, QA, and UAT phases
- Led requirement analysis and prepared technical design specifications
- Managed the complete software development lifecycle, including design, implementation, SDLC documentation, managed QA and UAT review cycles, testing, release notes, managing defects, releases, and tasks using JIRA
- Conducted regular client meetings to gather requirements and demonstrate dashboards
- Oversaw turnover control for migrating reports, dashboards, and universes across environments
- Reporting Tools: Tableau, Qlikview, Microsoft Power BI, Business Objects, DOMO,
- Database: Sybase ASE, Postgres, SQL
Application Developer
JP Morgan
09.2010 - 08.2012
- Involved in the full development life cycle of the reporting application
- Responsible for development and performance improvement of Webi, Crystal reports and Universe
- Administration - Scheduling reports in the CMC based on time and files based events
- Generating Crystal reports using OLE objects handling complex design issues
- Created proofs of concept for innovative new solutions.
- Reporting Tools: Business Objects
- Database: Sybase ASE, Oracle
BI Associate
Bank of America Continuum India
07.2007 - 06.2010
- Contributed to the entire development life cycle of the reporting application
- Involved in design and development of different reports and universe including Database structure and modeling
- Developed complex reports with drill-down functionality using hyperlinks, providing detailed insights for users
- Extracted, transformed, and loaded data from flat files and relational tables into datamarts and databases
- Designed and maintained database tables, functions, stored procedures, triggers, and optimized SQL queries
- Managed user accounts, roles, and access control, and handled group management in CMC
- Reporting Tools: Business Objects
- Database: SQL Server, Oracle
Education
Master of Computer Applications - Computer Science
University of Mumbai
India01-2007
Skills
- Tableau
- QlikView
- Power BI
- Business Objects
- Data Modeling
- SQL, Postgres, Sybase, Oracle
- Advanced Excel, Power Query, Python
- Project Management
- JIRA
Certification
- SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.2
- Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0
- Web Designing from ZAP InfoTech, Mumbai, India
- Diploma in Cyber Law conducted jointly by Asian School of Cyber Laws and Government Law College, Mumbai, India
Timeline
Senior Manager / BI Architect and Lead
Morgan Stanley
08.2012 - Current
Application Developer
JP Morgan
09.2010 - 08.2012
BI Associate
Bank of America Continuum India
07.2007 - 06.2010
Master of Computer Applications - Computer Science
University of Mumbai
Similar Profiles
Meeta VermaMeeta Verma
Director at Morgan StanleyDirector at Morgan Stanley
Andrew CucuzzaAndrew Cucuzza
Market Manager at Morgan Stanley Private Bank, N.A.Market Manager at Morgan Stanley Private Bank, N.A.
Eliana ValdiviaEliana Valdivia
Digital Virtual Engagement Associate - Wealth Management at Morgan StanleyDigital Virtual Engagement Associate - Wealth Management at Morgan Stanley