Ajay Shirsat

About Ajay Shirsat

14+ years of IT Experience in Database Design, Development, Business Intelligence…

Experience

1. Associate Manager

   Duck Creek Technologies

   Jun 2021 — Present · Mumbai, IN

   Extract, Load and Transform data in Data management, DBT, Fivetran, DWH, Snowflake, Data Warehouse, Data modeling.•Development in DBT, Snowflake, ELT, DWH, Data Warehouse and Power BI.•Collaboration with multiple audiences to understand requirements for metrics reporting via dashboards (including Product Support, Engineering, Finance, HR, and other departments to support our Business Intelligence Strategy) •Creation of Cloud-specific, as well as ad hoc reporting to provide business metrics for OnDemand management and other teams•Cost Analysis related to Cloud Infrastructure,Measuring on-going run costs (utilize tools to provide detailed costs, using multiple measures for validation of costs to strategy) and validate compliance with forecast and infrastructure blueprint with Power BI•Develops and maintains moderate to high complexity technical documentation and processes•Estimate, analyze, and the Software Product Development Lifecycle with Agile methodology•Debugs and resolves high complexity report bugs or issues working independently and finds the real root cause, providing a fix without collateral damage•Build, execute and maintain DBT, Snowflake and Power Bi.•Perform monthly financial reporting of costs, working with our SaaS Operations, Customer Service Managers, Compliance,Finance and others.•Responsible for understanding compliance measures, used at various levels within the organization and for different audiences.•Working with deployment methods for Power BI, data gateway options, row-level security, data query design in Power BI and use of M for query development.•Data modeling techniques, data models, Referential Integrity using Microsoft SQL Server.•SharePoint and Microsoft Teams document management and team collaboration, including Power Automate.•Microsoft Azure platform (portal, concepts, costing, deployment techniques, monitoring).