Sairaj Shirole

Overall having 5 years of experience in Data Management (as a Data Architect & DBA). Specialized in data warehousing, analytics & business intelligence solutions. Experienced in data warehouse modeling techniques 3NF, Star schema, Snowflake (extended star schemas), and Data Vault (1.0 & 2.0) enterprise modeling techniques. Involved in designing integration ETL& ELT, data flow/pipeline architecture, data modeling levels (conceptual, logical, physical), DB design. Supported ERP data-driven scalable data warehouse applications for IaaS & PaaS environment. Created E-R & DFD. Achieved slowly changing dimensions (SCD) methodologies. Created strategic roadmap, mindmap for data warehouse, and BI initiatives. Competent in query optimization & performance tuning, access & security administration, backup & restore, DB objects creation (table 2nf,3nf, views, Stored procedures), High availability (AAG), database mirror, replications & log Shipping.