Feb 2022 – Present · 4 yrs 1 mo · Gurugram, Haryana, India

• Developed data architecture models including roadmap planning, integrations, and optimization of data warehouse efficiency, aligning with business requirements and customer strategies.
• Designed and implemented a highly scalable data warehouse on Snowflake, achieving a 20% improvement in data processing speed.
• Led the design and execution of customized data models to fulfill organizational data requirements and align with strategic business needs.
• Built and enforced data control frameworks for rigorous data quality validation and monitoring.
• Proficient in T-SQL, ETL packages, and BI reporting using SQL Server Management, SSIS, BI Suite, Tableau and Power BI.
• Developed transformation pipelines in Snowflake leveraging Python and DBT for scalable, automated workflows.
• Formulated and executed schemas and dimensional structures tailored for enterprise-grade data warehousing solutions.
• Spearheaded adoption of Power BI and Tableau, enabling advanced analytics and visualization that drove data-informed decision-making across the organization.
• Devised a scalable data architecture capable of supporting 5x growth in data volume.
• Led the development of robust data warehousing solutions, increasing data retrieval speed by 60% and improving team productivity by 20%.
• Deployed a highly efficient ETL system, resulting in a 25% rise in data processing speed and a 15% boost in system performance.
• Managed and mentored a team of BI developers and analysts, fostering innovation, collaboration, and technical excellence.
• Streamlined data models and schemas to enhance accessibility and optimize query performance.
• Established scalable governance frameworks ensuring data accuracy, privacy, security, and compliance.
• Provided technical leadership and mentorship, guiding teams through complex projects and skill development.
• Played a key role in continuous improvement initiatives, identifying opportunities for process refinement and system enhancement.

Aug 2013 – Jan 2022 · 8 yrs 5 mos · Gurugram, Haryana, India

• Designing a predictive analysis system for the counterparty risk using AI.
• Design a strategic & real-time data analytical tool.
• Create SSBI (Self Service Business Intelligence) for the business.
• Designing & developing an efficient Data warehouse database.
• Developing Power BI and Tableau as enterprise BI solutions to reduce the FTE cost.
• Performance optimization of the Queries, store procedures
• Deployed a highly efficient Extract, Transform, Load (ETL) system, leading to a 25% rise in data processing speed and a 15% increase in system performance.
• Manage a team of BI developers and analysts, providing guidance and fostering a culture of innovation and collaboration.
• Devised and executed streamlined data models and schemas to improve data accessibility and optimize query performance.
• Implemented ETL processes utilizing SSIS for extracting, transforming, and loading data from diverse sources into the data warehouse.
• Provided mentorship and guidance to team members, delivering technical leadership and assistance.
• Played a key role in ongoing improvement initiatives, identifying avenues for process refinement and enhancement