Rushabh Kapadia

- As a Data Architect, day to day tasks included designing and optimizing database structures, managing data flow, and ensuring data integrity across enterprise systems

- With deep expertise in Power BI and SQL as core competencies, played a pivotal role in migrating 25+ complex Qlik Sense applications to Power BI.

- Engineered innovative solutions to replicate functionalities not natively supported in Power BI by implementing effective visual workarounds

- Spearheaded development of end-to-end solutions for new business requirements — collaborating directly with stakeholders, architecting robust data models, and crafting intuitive, user-centric dashboards from scratch

- Demonstrated advanced proficiency in Power BI through the development of complex DAX expressions and optimized data models, seamlessly integrating data from diverse sources including Excel, SharePoint, Oracle, SQL Server, and Snowflake.

- Possessing in-depth knowledge of the Power BI ecosystem, including Power BI Service, Dataflow, Bookmarks, and the implementation of Row-Level Security (RLS) for secure and scalable reporting solutions.

Project Name: - Heritage Project

• Leveraged strong SQL expertise to deliver reliable technical solutions and build trusted client relationships through clear communication and collaboration.
• Progressed from Developer to Techno-Functional Lead, driving end-to-end implementations for new business lines and resolving complex operational issues.
• Managed project and a team of 15 resources providing efficient solutions and adhering to process and timelines.
• Collaborated effectively with stakeholders to coordinate activities and align technical efforts with business goals.
• Developed and organized system infrastructure documentation and operating procedures, improving system controls and performance.
• Diagnosed and resolved system performance issues, enhancing usability and overall functionality.

• Analyzed new business requirements, collaborated with senior management for approvals, and translated them into actionable technical plans.
• Led technical design documentation, database design, and development of PL/SQL components including functions, procedures, packages, triggers, views, and complex queries.
• Oversaw end-to-end development lifecycle, including integration testing, defect logging, and validation of test scripts to ensure quality deliverables.
• Acted as a liaison between teams, clarifying requirements and tracking progress across development and QA activities.
• Conducted performance tuning of SQL queries and provided optimization recommendations across related projects within the same ISUs.