Sarita Adhikari

• A ONPREM and Cloud enthusiast with more than 6+ years of experience focusing Microsoft SQL Server and Business Intelligence 2022, 2019, 2017 and 2016 versions, Azure PaaS Services. • Highly experienced in software development life cycle, business requirement analysis, design, programming, database design, data warehousing and business intelligence concepts, Star Schema and Snowflake Schema methodologies. • Experienced on PaaS Services for Data ingestion, transformation, and storage of data from ONPREM to Cloud and vice versa, worked on Cost Optimization by porting live reporting data to ONPREM from Cloud storage partitioned based on time series. • Conversant with Data Distribution algorithms like Round Robin, ASCII and Replicator, implemented Data Partitioning using Round Robin in Data Warehouse built using Azure MS SQL PaaS service. • Proficient in the implementation of Relational Database Management Systems, Implemented third normalization form in OLTP Database MODELING and Star, Snowflake Schemas in OLAP Dimensional MODELING. • Well experienced on Server less Azure Data Factory Author and Monitor features in order to build Cost efficient pipelines to port data from multiple sources. • Implemented Azure Data Factory Integration Runtimes to execute SSIS packages, collecting ONPREM data scenarios, Parametrized Linked Services and re used existing Data Sets across most of the activities in a Pipeline. • Working knowledge of disaster recovery and high availability solution like replication, transaction log shipping, mirroring, and clustering. • Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis. • Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC. • Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3rd party tools. • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all. • Experience in Microsoft