Sheetal Patil Email & Phone Number

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and to achieve data consistency.• Extensive experience integrating, migrating, converting and cleaning data using SSIS and T-SQL commands.• Expert in creating, configuring and fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS). • Experience in Transforming data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).• Strong experience in performance tuning, and query optimization using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.• Expertise in designing reports using various tools like SQL Server Reporting Services (SSRS), Power BI, Tableau and Microsoft Access/Excel spreadsheet. • Experienced in generating on-demand and scheduled reports for business analysis or management decisions using SSRS and other reporting tools.• Expert in developing Data Driven Subscription Reports and setting securities for reports.• Expert in designing and developing Power BI graphical solutions and interactive dashboards as per business requirement documents. • Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.• Hands on experience in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization.• Experience in creating Functional Specification Document (FSD) for business requirements.• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star Schema, Snowflake Schema, Fact Tables, Dimensional tables and granularity of dimensions. • Experience in working with version control tools such as Microsoft Visual Source Safe, Team foundation server (TFS).• Coordinating and tracking all projects for seamless releases using TFS, JIRA and SharePoint.• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.