Shruti Patil

• AIB: (Allied Irish Bank)
• Designed and built end to end solutions to meet diverse client requirements for AIB.
• Designed project architecture flow and solution design for various source systems.
• Conducted proof of concepts to assess feasibility and sustainability of solutions.
• Worked as a data modeler to design and implement data architecture supporting the data vault model.
• Developed Python and Azure functions for preprocessing data and landing semi structured data into Snowflake,streamlining data management and analysis processes.
• AIG::(American Insurance Group
• Worked for Insurance based client as Lead data engineer where I have worked on Snowflake as DWH and IICS as ETL tool.
• Majorly handled the query optimization part and designing the requirement solution
• Analyzing the source data and preparing the plan for implementation.

The goal of the GMDL-MVP Program is to establish a Data Virtualization and Business Intelligence (BI) Platform for the Grid Modernization Program to support AMI, EAM, DMS/OMS.
• Worked on generating visualizations for report to business extracting snowflake data using Snowsight and PBI.
• Worked with data frame using pandas to manipulate data including cleansing, data fill, slicing and inspection.
• File handling in python and plotting different charts for data analysis using matplotlib.
• Develop a Source system Analysis specification with an analysis of data from various source systems and data profiling
• Collaborate with data architects to translate requirements into technical specifications.
• Perform system impact data analyses including upstream and downstream impacts, propose solutions, and build functional specifications.
• Built a conceptual Data Model for the application. Create a Logical Data Model (LDM) and Physical Data model.
• Analyze the Customer data from the various source system and build the Source to Target document for reporting / final core table design
• Built Informatica SCD1/SCD2 mappings as per business requirement.
• Developed complex TDV views and data models for PBI consumption.
• Worked on Migrating data from AMFM to ADMS (Utility Systems – GE product) to standardize the utility data.
• Worked on New requirements of including and integrating GAS data in the existing TDV views and Dashboards.
• Managed complex Outage related data (OMS) to and built a module to send notification to the customer During and Post Storm as per the preferences selected.
• Worked on Various sources like CCS, HES, MDMS, EIP, OMS, AMFM, ADMS, ESRI etc.

SSBT managed the Data warehouse for the State street bank. Data Warehouse being Teradata and data coming from heterogeneous sources. This was built on metadata framework.
• Worked on Metadata based Data Governance Framework that involves Teradata 16.10, Query Grid (connector between Hadoop and Teradata)
• Understand requirement and prepare requirement specification document
• Prepare low level design document
• Firsthand experience in troubleshooting various issue related to Oracle Goldengate replication, as we have data source from Exadata, Oracle and IBM to Teradata system.
• Created and Modified the OGG replicators as per business needs of clients.
• Helped in setting up basic TASM rulesets for few business applications to maintain the system performance after migration. Maintenance of stats regularly.
• Used Teradata Load utilities like FASTLOAD, MULTILOAD and BTEQ
• Worked on various business reports like Monthly, Biweekly, System

Worked on SQL over the version 2000/2005/2008R2 and 2012 Database Administration ,
• Hold over SSIS and SSRS Deployments
• Experience in Migration of Databases from 2005 to 2012.
• Experience in Database refresh/ Restore.
• Worked on high availability solution like Log shipping and mirroring
• Experience in IIS over the version 6.0, 7.5 and 8.0 Administration.
• Experience in Deployment / Retirement of Web Application
• Creating application pools/Virtual directory
• Experience in Troubleshooting errors in IIS websites