Sneha C Email & Phone Number

Around 8 years of experience in implementing BI solutions in Healthcare, Banking, Health insurance, and P&C industries using MSBI Stack (SSIS, SSAS, SSRS, and Power BI).Involved in all phases of SDLC from requirement gatherings through post-deployment of application systems in large and small organizations using Agile methodology.Proficient in creating packages as part of ETL – extracting data from heterogeneous sources like Excel, Flat file, OLEDB source, and loading to SQL Server databases using SSIS (2016/2014/2012/2008/2005).Experienced in using various SSIS control flow items like execute SQL task, Data Flow task, Send Mail Task, File system task, Bulk Insert Task, for-each Loop, and Sequence Container.Experienced in debugging SSIS packages using checkpoints, breakpoints, and error handling by configuring send mail tasks using event handlers.Proficient in logging the runtime information into different log providers like SQL Server, and Text File using SSIS Logging to increase the performance of SSIS packages.Designing & maintained databases on Microsoft’s cloud computing platform of SQL Azure in performing an incremental load of data into DW using SCD, Lookup.Experienced in transforming the data as per business needs using different transformations like Conditional split, Merge join, derived column, data conversion, and Fuzzy lookup in SSIS.Experienced in performance tuning of long-running SQL queries using SQL server built-in tools like SQL Server profiler, Execution plan, and also by creating indexes.Strong Experience in designing diverse reports like tabular, matrix, parameterized, drill through, ad-hoc, linked reports, charts, and sub-reports both for operational and regulatory needs using SSRS (2008/2012/2014/2016).Employing various Tableau functionalities like Tableau Extracts, Dynamic Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending, and Maps, etcHandling experience in working with query editor (Power BI) to extra data from heterogeneous sources, perform data cleansing and shaping and load them to the data model region.Strong experience in story narration for business users by creating worksheets in Tableau using various objects like calculated fields, actions, filters, parameters, groups, sets, and hierarchies.Ability to work in tight schedules and efficient in time management and highly motivated team player with the intensity of delivering high-quality outputs within the deadline.