IntuitTL/SM
Sep. 2014 - Jan. 2016Bangalore IndiaClient: INTUIT, Role: Scrum Master, From: 9/2014 to 1/2016
o DSU to know what is achieved, what's planned to do & impediments, Sprint review by sprint end, Product backlog grooming with PO. Mkting and scrum team for introspection of features, Used planning poker method to estimate story points, broke down large story points to tasks, Retrospect by sprint end for learning.
• Developed Complex SQL queries with Joins & T-SQL, cursors, user defined functions, stored procedure, Views, trigger to implementing business rules & transformations.
• Created SQL job Alerts, schedule SQL Server Integration Service packages using SQL Server Agent job & JAMS Scheduler.
• Worked closely with business users to implement logical & physical data modeling using Erwin data modeler.
• Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc. & load data to target tables by performing different kinds of transformations using SSIS.
• Used various SSIS tasks such as conditional split, derived column etc., for data scrubbing, including data validation checks during staging, before loading data to data warehouse.
• Used ETL to implement slowly changing transformation, to maintain historical data in data warehouse & SQL Server Reporting Services.
• Collaborated to perform current environment assessment, defining future state DW architecture, developed business cases to implement DW strategy & formulating migration plan.
• Supported application dev team with data samples, DB issues, updates/new releases. & deadlock issues, best practices in structuring SQL queries, debugging unexpected SQL results, etc,.
• Used tools - DB engine tuning advisor, SQL profiler, & windows performance monitor for monitoring & tuning MS SQL server performance.
• Worked with developers, DBAs, & systems support personnel in elevating & automating successful code to prod.
• Used Github & TFS for repository towards SCM, Used Jenkins automation deployment.