Shruthi Blessy

About Shruthi Blessy

Data Engineer with extensive experience in conceptual/logical data modeling skills and with JAD sessions for requirements gathering, creating data mapping documents/writing functional specifications. Proficient in applying SLDC software development process to establish a business analysis methodology. Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging existing client-server-based applications). Knowledge of conducting data flow modeling and object modeling, case analysis and functional decomposition analysis. Hands-on experience in designing end-to-end ETL Strategy utilizing SSIS as ETL tool and authored multitude of SSIS packages for data migration purposes. Technical Forte: Database: SQL Server 2018, 2016, 2014, 2012, 2008/R SDLC: Agile, Scrum, Waterfall, and Spiral Data Modeling: ER-win, MS Visio Database Programming: T-SQL, Dynamic SQL, MDX, DAX Development Tools: BIDS, SSDT, SSMS Integration Tool: SSIS Analysis Services: SSAS, OLAP Cubes, Tabular Model Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Experience

1. Data Engineer

   General Dynamics Information Technology

   Jan 2021 — Present · New York, NJ, US

   Worked along with project managers to gather requirements for the data synchronization task, such as data scope, data mapping. Wrote Python scripts to load data from Web APIs to staging DB. Developed test cases in Excel and conducted manual testing / execution. Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance. Facilitated data collection sessions and analyzed data processes, scenarios, and information flow. Resolved multiple data governance issues to support data consistency at the enterprise level. Created dynamic SQL script to transfer data from multitude tables between databases. Worked with database objects like stored procedures, user defined functions, triggers and indexes using T-SQL to create complex scripts and batches. Used error handing techniques like try catch and error functions to create robust T-SQL code. Utilized dynamic SQL for user customizable queries to be answered by the OLTP Server. Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server. Developed data integration process from sources to data mart utilizing SSIS as ETL tool. Performed troubleshooting on SSIS packages on production servers based on error received and performed change management.