Visesh V.
Senior Data Integration Engineer @Gallagher Bassett
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Integration Engineer @Gallagher Bassett
Rolling Meadows, IL, US
Responsible for designing, developing, enhancing, maintaining and execution of extraction, transformation and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse using MS SQL Server Integration Services (SSIS). Implement Azure cloud components Azure Data Factory, Azure Data Analytics, Azure Data Lake, Azure Data Catalogue. Experience leveraging technologies such as Azure Data Factory, ADLS Gen 2, Logic Apps, Azure Functions, Databricks, SQL DW.Utilize design methodologies, object-oriented design and design patterns. Create reports, sub reports, charts, Tablix, Matrix, Hyperlink reports using Microsoft Power BI reporting tool. Work with other teams throughout the company to determine feasibility, business and functional requirements and technical designs on assigned projects, Provide ongoing support, maintenance and enhancement of systems. Leap between various application in a rapid development environment for rapid application development used SQL, Azure, Data factory, C#, T-SQL, Managed SQL server databases and DDL changes and implementing database schemas.
EDUCATION
University of Illinois Springfield
Master's degree, Computer Science
Jawaharlal Nehru Technological University
Bachelor's degree, Electrical, Electronics and Communications Engineering
ABOUT VISESH V.
IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.• Responsible for designing, developing, enhancing, maintaining and execution of extraction, transformation and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse using MS SQL Server Integration Services (SSIS).• Implement Azure cloud components Azure Data Factory, Azure Data Analytics, Azure Data Lake, Azure Data Catalogue. Participate in various phases of SDLC including design, coding, reviews, testing and Documentation.o Experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.o Handling team of Salesforce data extract for data ETL process, Data load and Data mapping verifications using DBAMP. o Intermediate experience with Salesforce integration Tools (DBAMP) with legacy platforms.o Experience in primary data analysis, mapping and migration from Oracle to SQL servero Extensive knowledge of normalization and relational database management systems.o Explore data in a Variety of ways and across multiple visualizations using Power BI. o Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.