Occupation:Datawarehouse Designer |
Location:Bellevue, WA |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary Over 7+ years of IT experience in Data Warehousing and Business intelligence along with Requirement Analysis, Application design and development, testing, implementation and maintenance of Data Warehouse and Data Mart systems within various industries including Software and Insurance industries. * Technical lead for providing database solutions and managing the team. * Proficient in understanding the requirement from the client and converting it to technical tasks. * Handles daily scrum and tracks status effectively from the whole team. * Experience with creating Analytical reports using Power BI for the Microsoft Leadership. * Extensive experience in SSIS, Analysis services and SQL development. * Experience in Migration of On-premise DB to Azure SQL. * Extensive experience supporting and providing solutions for data Analyst. * Extensive experience in development and design of ETL solutions methodology for supporting data transformation and processing * Experience using Data Modeling Tools like Erwin. * Expertise in designing and developing Data marts and Data Warehouses using multi-dimensional Models such as Snow Flakes and Star schema while implementing decision support systems. Experience Summary Microsoft Bing Ads via Cognizant, Bellevue, WA, USA Business Intelligence (BI) Lead Jun 16 to Present Consultant for design and development using Azure SQL, SQL Server Databases, ETL, SSIS, SSAS within the Bing advertising team powering pay per click advertising in Bing and Yahoo search engines Key areas of impact: 1. Migration from On-premise to Azure SQL. 2. Lead for the solution to come up with alternative for SSAS cubes. 3. Worked on Power BI reports for extracting the customer critical data for analysis. 4. Performance tuned the Daily monitoring jobs and workflows. 5. Provided Automation solutions using internal Ads Pulse reports. 6. SME for the current system and handled multiple major releases involving multiple team synchronizations. 7. Involved in critical migration of cubes to Azure databases. 8. Leading the project for using an Excel ad-in for giving the similar experience of the cube.
Accomplishments
Highlights:
Keywords
