Gopala K.

Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.  Created Azure ETL pipelines to load data from web API/ Google Big Query database to Azure Data Lake and load data from Azure data lake storage blob to SQL Server Database, and scheduled Triggers for daily loads by implementing Copy Data, Data Flow, Delete, Execute Pipeline, Lookup, Stored Procedure, Set Variable, Web Azure Data Factory Pipeline Activities.  Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.  Involved in developing the process for the CI/CD using Azure DevOps and GitHub.

Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings.  Used different Control Flow Tasks and Data Flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats, involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.  Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.  Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment.