Simran Chavan

Background

About Simran Chavan

IT Professional with 18+ years of cross-functional and technical experience in Leading, Design, Development, Implementation, Maintenance and Management with exposure to Banking, Accounts and Financial Services Domains. Managed 30+ team of development, Testing, BSA’s, and Support members and responsible for end-to-end project deliveries. Provided Technical Leadership in the area of data techniques including data access, design, integration and implementation. Setting the direction for Data-As-A-Service by defining goals and objectives, planning projects and delegating assignments. Involved in various data warehouse, cloud, software application, CRM, reports migration projects. Experience in extracting transforming and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and Azure Data Lake Analytics. Data Ingestion to one or more Azure Services -(Azure Data Lake, Azure Storage, Azure SQL, Azure DW, Synapse) and processing the data in Azure Databricks. Created Data Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources to targets like Azure SQL, Blob storage, Azure SQL Data warehouse. Expertise in writing SQL, Oracle, Access, Hive, T-SQL Queries, PL-SQL, Dynamic-queries, sub-queries. In-depth knowledge of data warehousing methodologies. Experienced in Hadoop Big Data technologies, Hive, Pig and integration tools such as Pyspark. Experience with Databricks / SSIS / PySpark to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database. Proficient in analyzing and validating data using Python, PySpark, Shell Scripting & PowerShell. Experienced with Power BI, Tableau and Alteryx data visualization reporting. Troubleshoot production problems mainly associated with performance using SQL Profiler and Performance tuning. Optimized performance of the production system by modifying indexes, redesigning stored procedures and implementing partitioned views. Proficient in overall Defect Management/Problem solving including tracking bugs and reporting using HP ALM, Quality Center and Jira. Expertise in Job Scheduling environments CA Workload Automation AE (AutoSys Edition) Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high-stress environments. Ability to adapt to new methodologies, tools and technologies and domains depending on the job responsibilities