Sneha C Email & Phone Number

San Jose, Ca, Us

Experience with Level of Detail (LOD) expressions for analysis and complex aggregations at different dimensional levels to provide deeper insights into the available dataWorking Extensively with Advanced analysis Actions, Calculations, Dynamic Parameters, Background Images, Maps. Trend Lines, Statistics and table calculationsBuilt reports in Tableau using advance functions like LoD Expressions, Parameters, Sets, Groups, and Quick table calculationsStrong understanding in advanced Tableau features like table calculations, aggregates, calculated fields, Dynamic parameters, quick filters, action filters, context filters, cascading filters, drill downs, hierarchiesDeveloping advance chart visualizations in Tableau like Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problemsPerformed extensive task in excel such as Pivots Tables, VLOOKUP, conditional formatting and data manipulation and cleaning for large number of data setDeveloping and reviewed SQL queries with use of join clauses in Tableau Desktop for validating static and dynamic Parameters data for data validationDesigned, developed and implement different forms of visualizations for daily business use to see Budget and Forecast provided features like parameters, actions, calculated fields, sorting, and groupings in Tableau dashboardsInvolving in reviewing business requirements and analyzing data sources from MS Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau DesktopInvolving in Performance tuning the data heavy dashboards and reports for optimization using various options like Extracts, Context filters, Data source filters, Indexing and Partitioning in data source etcImplementing Advance analytics like Reference Lines, Trend Lines to see planned orders, open orders, current Inventory etc.

Green Bay, Wi, Us

Worked on OLAP & OLTP including Dev, Analysis, QA, and Prod. Extensive programming knowledge in T-SQL .NET framework with Visual Studio.Design data integration ETL packages from different databases to destination and data warehouse. Proficient in star schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies, and facts.Working on SSIS ETL performance tuning, adjusting fast load techniques, cleaning data, debugging, error handling, event handling, re-running failed packages using checkpoints, troubleshooting using breakpoints, and other tuning techniques.Using several control flow tasks sequence container, For Loop, For Each Loop; ActiveX Script Task, CDC task in SSIS, data flow task, Bulk Insert Task, Execute SQL, File System Task, and Script Task, Several Data Flow Transformations: Look Up, Cache transformation, Conditional Split, Derived Column, Row Count, Script Component, Merge Join and Union All.Developed complex Talend ETL jobs to migrate the data from flat files to Oracle database creation of the documents for Tableau user support and trained Power users on the self-servicing capability of the toolDevelop load scripts to extract, transform and load data (ETL) into Tableau applications creation of data dictionaries, and identified the data items required for the dashboardsConsistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needsInteracted with business users and performed Gap Analysis of Client requirements marked up the dashboards and walk through the end usersDeveloped complex Talend ETL jobs to migrate the data from flat files to Oracle database Understanding existing business model and customer's new requirements

Valley Forge, Pa, Us

Involved in Technical and Business decisions for Business requirement, Interaction with Business Analysts, Client team, and Development team through Agile Kanban process.Creating Azure Data factories for loading the data to Azure SQL database from Cosmos platform complex power BI dashboards.Designed web applications, desktop applications and modules using ASP .Net, VB .Net, T-SQL, HTML, JavaScript and/or XML.Provided high availability for IaaS and PaaS role instances for access from other services in the C#.Net with Azure Internal Load Balancer.Designed on Object Oriented principles and developed the product using HTML, CSS, JavaScript, ASP.NET, C#, and SQL technologies on SDLC and SCRUM, Agile Methodology, Iterative Development.Developed, deployed and monitored SSIS Packages for new ETL Processes performed the role of Scrum Master in daily stand-up calls.Developed, deployed and monitored SSAS cubes performed Column Mapping, Data Mapping and Maintained Data Models and Data Dictionaries.Design and schedule the Autosys process to execute daily, weekly and monthly jobs used recently introduced Power BI to create self-service BI capabilities and use tabular models.Created SSIS Packages to Extract and load data from and to different sources and targets like SQL Server, Text Files, Excel and CSV feed them to COUPA cloud server.Involved in development and implementation of SSIS, Azure Cloud services created Complex ETL Packages using SSIS which upsets data from staging table to database tablesInvolved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files and some Legacy systems. Expertise in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.

New York, Ny, Us

Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and automated stored procedures.Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis and scheduled SQL jobs to run SSIS packages on a daily basis using SQL Server Agent.Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, for each loop container.Writing VB.NET and C# coding in Script task and script component managing and automating Control flow, Data flow, Events and Logging for SSIS packages.Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS). Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS) promoted RDLs to Reporting Service Server.Defined relationships between Dimensions and Measure groups OLAP design SSAS 2008R2 for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.Defined Granularity with in a measure group and drill through actions resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Master'S Degree, Computer Science

Bachelor Of Technology - Btech, Computer Science