Nov 2024 – Mar 2025 · 4 mos · Noida, Uttar Pradesh, India

• Managed end-to-end data pipelines from GCP to Snowflake, delivering seamless analytics for Tableau and Power BI reporting while overseeing Jira-based sprint planning, task assignments, and timely delivery of product features and enhancements.
• Designed and implemented enterprise Snowflake account structures with multi-account strategies, cross-cloud deployments, and comprehensive RBAC frameworks featuring custom roles, role hierarchies, and least-privilege access principles.
• Configured SAML 2.0 and OAuth integrations with enterprise identity providers (Okta, Azure AD) for secure authentication, plus established resource monitors with automatic suspension thresholds and credit usage alerts for cost optimization.
• Implemented Snowpipe for automated real-time data ingestion, Change Data Capture (CDC) for data synchronization, and developed stored procedures for complex transformations while ensuring platform scalability through strategic indexing, partitioning, and clustering.
• Established network security policies including IP whitelisting and private connectivity solutions, ensuring platform security and compliance across the media analytics environment

Jan 2021 – Oct 2024 · 3 yrs 9 mos · Noida, Uttar Pradesh, India

Jul 2018 – Dec 2020 · 2 yrs 5 mos · Noida Area, India

Mar 2017 – Jul 2018 · 1 yr 4 mos · Gurgaon, Haryana, India

Sep 2014 – Mar 2017 · 2 yrs 6 mos

• Microsoft Platform knowledge on Azure, Power BI, Sql Server, the Microsoft BI .
• Business Intelligence design and implementation using Microsoft Business Intelligence stack (SSIS, SSAS and SSRS)
• SQl Server 2016 experience
• PowerBI using tabular models, Power Pivot, Power BI Desktop & Power query
• SSAS tabular data model design, optimisation and query using DAX
• SSIS design and development of ETL workflows, SSIS automation
• Complex MDX scripting
• MOLAP,ROLAP
• Data warehouse solution architecture
• Client engagement including prototype reviews and requirements gathering
• Data modelling: Dimensional/Kimball, 3NF/Inmon
• Business process analysis and modelling
• Documentation (business focused, technology focused and project focused)

Mar 2014 – Sep 2014 · 6 mos

• Report Studio:
• Worked with various kind of reports like list report, cross tab, chart, Repeater and combination reports.
• Developed Complex reports which involved multiple prompts (value prompts, Data & time prompts, Text box prompts) and Filters, Conditional formatting, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created Reports using Render variable and conditional Block.
• Customized the reports by adding calculations, conditions, functions and providing Security in Framework Manager.
• Implemented Master Detail Relationship and Drill-through reports.
• Involved in scheduling and deployment of the reports.
• Transformer:
• Hands on knowledge of Designing and creation of Cube using Power play Transformer.
• Creation of regular/calculated dimensions, measures and calculation in Cognos Transformer.
• Apply security at Cube.
• To debug the Cube using analysis studio.
• Involved in Production Support and understanding existing business processes, data analysis requirements.
• Framework Manager:
• Designing and Development knowledge of Framework Manager Models based on Star Schema with layered approach.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, namespaces, Model query subjects, query items and complex calculations in Framework Manager.
• Worked with entity-relations in Framework manager.
• Implementation knowledge of different level of Security in Framework Manager.

Mar 2012 – Feb 2014 · 1 yr 11 mos

• Working as a Cognos Report developer.Intrested in learning new tools related to datawarehousing.