Archit Wagle

Background

About Archit Wagle

Having 9+ yrs total experience in business intelligence domain with hands on expertise in data warehousing, analytics & BI reporting area. Currently associated with Tata Consultancy Services Limited in the role of Senior Business Intelligence (BI) developer. Having over 3 years experience at onsite working on international IT projects with leading European clients based out of Germany & Denmark; handling end-end BI solution development & operations.Current Location: München, GermanyTechnical experience- Database - Microsoft SQL Server, Oracle PL/SQL developer, Impala SQL query engine & Teradata- Writing PL/SQL, TSQL queries, views, stored procedures- OLAP cube - Microsoft SQL Server Analysis Services (SSAS)- Writing MDX queries, expressions & DAX functions- Data visualization/BI reporting tools: Tableau, Microsoft Power BI, Microsoft SQL Server Reporting Services (SSRS), Microsoft Performance point services (PPS), Excel- ETL: Microsoft SQL Server Integration Services (SSIS) & Oracle PL/SQL packages- Data virtualization using Denodo VDP 7.0Roles and responsibilities- Interacting with BI application product owners & business analysts for requirement definition - Requirement understanding & analysis- Data analysis- Develop & enhance database/data warehouse design & ETL packages- Develop & enhance SSAS OLAP cube solutions- New development & implement CR's in BI reporting / front end solutions- Unit testing/data content verification- Operations support & solution maintainence- Support business owners & end-users queries- Prepare POC's & case-studies- Onsite coordinator & Team lead- Technical documentationRecent project key deliveries- Implemented Data virtuality use cases on Denodo- Delivered interactive & dynamic pricing analytics tool & web analytics dashboards on Tableau- Delivered SSAS multidimensional (OLAP) analytical solutions for multiple projects- Delivered complex financial cost management reporting solution on SSRS using SSAS cube dataset (MDX)- Automation : Creation of dynamic partitions in SSAS cube using SSIS package- ETL enhancements & OLAP cube performance improvementsIndustry/domain experience- Sales, Marketing & Distribution : Infineon Technologies AG- Shipping, Finance, Profitability, Activity Based Costing : Maersk Line A/S- CRM analytics : AccentureExternal certifications- Tableau Desktop specialist- Microsoft certified professional (70-433,70-461,70-463)Soft Skills- Good communication skills- Good team player- Quick learner- Problem solving- Hands-on mentality