Build scalable and efficient data framework for ingesting and preparing data and create developer obsessed technical solutions using AWS.o Manage Ads away team program to allow other engineering teams to build and launch metrics and reports for revenue producing programs in Amazon Ads ($467 million (2022), $1.2 Billion (2023))• Identified opportunities for self service and automation in the Ads systems and launched the Leapfrog program too Increase the speed of delivering features to advertisers by automating data pipelines, building ETL and orchestration tools adding new metrics from ingestion to reporting from 3 weeks to 15 days with quality certification and governanceo Decrease the load for internal scrum teams and data investigation tickets by building accurate runbooks o Implemented Partner Give Back to invite engineering investments from partner teams towards system simplificationo Achieve quick measurable engineering excellence through swarm efforts, specially for confidential initiatives• Bar raise the standards of on call responsibility and technical documentation for quick design decisions• Organize and Judge Hackathon projects to promote fresh ideas and thinking• Negotiate and prioritize tasks in roadmaps across Ads org to influence business teams and drive quick decision making process

• Identifying potential for cost savings through ETL, storage optimization, budget allocation• Reducing Snowflake credits usage by moving ETL to Databricks using Spark• Accountable for the Content, Ads and Sessions data engineering functions• Set up an Architecture Book of Knowledge with whitepapers, guidance documents, system designs and RFE/RFP for POCs• Designed and facilitate feature driven data mart for the Data Science team for ML and AI modeling• Designed experimentation pipeline with real time ingestion in DRUID for Operational Analytics team• Implement the data architecture strategy for Hulu/Disney Streaming Services and set the vision for data platform, data infrastructure and end to end data solutions across analytics, data management, data governance, storage and access• Promote and develop data architecture best practices, guidelines, procedures and repeatable and scalable frameworks• Deeply understand current data solutions, identify improvements, options & tradeoffs, define target state solutions and propose pragmatic investment roadmaps, including recommendations to retire, build or enhance data platforms• Conduct technical war rooms on critical projects with sensitive SLAs• Develop and sponsor proofs-of-concept and idea blueprints to demonstrate recommended approaches• Tech Lead for the subscriber 360/content 360/ ads 360 projects combining data from multiple domains • Analyze data and industry models as needed using dimensional modeling to allow for Vertical/Horizontal Database Scaling for Read vs Write optimization.• Designed and developed Content Metadata pipeline for VOD and Live data from disparate sources• SME for Hulu’s content and ads metadata• Drove PII compliance across all data engineering teams• Migrated governed and CMM certified data warehouse from Hive to Snowflake

• Well verse with interacting with managers at all levels including C level, VP and Directors. • Implemented policies around data governance, Metadata management, ETL guidelines and framework• Created and maintained Data Profiling framework for the ETL packageso Developed and implemented strategic product roadmap to maximize sales revenue and achieve corporate strategic goalso Responsible for gathering requirements about data marts to build Bus Matrix o Facilitated the division of tasks between Business Intelligence Analytics, Framework and Data Services o Created Logical and Physical Data Models for laying out the strategy to develop the EDWo Designed dimensional schemas, developed integration packages, to test, maintain, and supported LegalZoom EDW.o Translated project requirements into functional and non-functional specifications for integration, BI reports & applications.o Responsible for architecting and building an enterprise level Operational Data Storage to gather data from all internal and external sources including Salesforce, Filenet, Google Analytics, Questionnaire data, NPS.o Created an Enterprise level BI reporting/analytical platform to satisfy multiple teams within the organization with intuitive navigation of data and eliminating the need of overtraining. • Managed initiatives with third party vendors for key business relationships designed towards maximizing sales• Frequently research and conduct PoC on new and emerging technologies and best practices and made recommendations • Established protocols for communication between local and offshore teams to maintain a high quality of programming practices and manage work queues without overwhelming the current team members• Enforced monthly project demos and peer code analysis not for critique but exchange of ideas• Developed the Life Time Value reports and its coefficient for predictive analysis.• Automated the process of extracting data from Google Analytics to be used with the EDW

Appraised within the first six months of joining the company with positive remarks.Worked on the Enterprise Data Warehouse solution using SSIS, SSAS in conjunction with SSRS. It involved :• Collaborating with internal and external stakeholders to understand the client’s business situation and develop data driven insights that can be understood and implemented to drive marketing strategies • Managing project requirements, analytic plans, SOWs, project timelines, for the management of deliverables • Lead a team to completion of our IT infrastructure expansion to other business domain besides Real Estate Developers• Prepared the Data Warehouse Project scope and a detailed project plan• Gathered requirements and design of data warehouse and data mart entities.• Developed end-to-end project architecture including source data profiling, ETL design and reporting (SSAS, Dundas)• Designed Conceptual, Logical and Physical database models.• Developed dimensional Modeling as Data Warehouse architect– STAR schema by analyzing and discovering key business domains and processes.• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 0, 1 and 2 changes.• Utilized custom Reporting Objects to create custom solutions for different industries• Designed and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.• Provided on-call support to production system to resolve any issues. • Other roles included :o DB monitoringo Creating and Maintaining highly available Test, Development and Production environments.• Responsible for heading the merger of two companies (IT, Operations). o Planning the IT operations and their streamlining o Understanding of the two architectures to identify common process workflowso Created processes / ETL packages to integrate the data between the two databases

o Going through the requirements and coming up with database design and application architecture.o Create end-to-end data pipeline design and maintain the sameo Lead a team of developers to develop strategy for optimizing database performance in web/mobile platformso Providing consultation on SQL Server architecture to our development teams.o Installing, configuring, administering and securing our production servers (dual fail over clusters).o Coming up with custom-tailored backup/restore and disaster recovery plans for production servers through DTS.o Troubleshooting performance issues and fine-tuning queries and stored procedures.o Implementing and administering database replication between SQL Server databases as well as dissimilar databases.o Writing code and creating jobs to automate repetitive tasks.

• Frequently involved in the maintenance and evolution of the various Stored Procedures on the back-end to provide functionality on the font-end. Optimized T-SQL for real time execution through techniques like clustered and non-clustered indexing. • Responsible for the front end management of the web services. o Projects included the evolution of the content management system in XML and ASP. o Implemented and helped evolving the backbone DLL files for all the primary operations such as provisioning of new clients and authentication. o Highlight projects included "Multiple Channel Support".  Tracking and customizing channels based on the user location and providing functionality specific to the same.  Mostly involved cookies. • Transition of the web services to .NET framework.• Stabilize the website for simultaneous access. Included memory management, resource sharing, connection management.• The main system for the voice recognition, developed in JAVA with the web services developed in ASP, JSP.• Skill sets used are MS SQL SERVER 2000, T-SQL, ASP, VB.NET, ASP.NET, XML, XSL, JavaScript, VBScript, CSS, SQL.