Surya Mohan

Experience

• 

  VI Solutions, Bangalore

  Dec 2019 - Jan 2020

  Intern Trainee

  Responsibilities:● Assist with prototyping, schematic capture, debugging, hardware bug tracking, functional verification and signal characterization.● Efficiently develop complex software in the LabVIEW programming environment.● Accurately estimate the timelines required to develop LabVIEW programs.● Practice effective revision control of programs that are developed.● Develop a server environment where users are placed in a queue and only one user is allowed access to the hardware.● Modify the LabView programs suitable to the server program.● Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL dB package Show less

• 

  Tata Consultancy Services

  Jan 2021 - Jan 2022

  Data Anlytics Engineer

  ● Responsible for loading structured, unstructured, and semi-structured data into Hadoop by creating static and dynamic partitions.● Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.● Designed, developed Data Stage type1 load jobs to load Warehouse and Mart tables.● Developed complicated jobs using various Data Stage Stages such as Database, Join, Lookup, Change Capture, Peek, Column generator, Transformer, Sort, Remove duplicates.● Implemented Data Parallelism through jobs, which deals with data, divided into segments and operates on each segment simultaneously through the Data Stage partitioning techniques to segment data.● Moving ETL pipelines from SQL server to Hadoop Environment. Developed and optimized SQL queries for data extraction, transformation, and reporting.● Convert SAS code to SQL to load data warehouses using ETL jobs.● Developed the Batch cycles for scheduling the jobs by using Control-M. Show less

• 

  Ikonicsoft

  Jan 2023 - May 2023

  Jr Data Engineer

  ● Knowledge of Azure Cloud Services (Paas, Saas, laaS), Storage, Data-Factory, Data Lake (ADLA S ADLS), Azure Monitoring, Active Directory, Synapse, Key Vault, and SQL Azure.● Design and implement ETL and data movement solutions using Azure Data Factory, and SSIS..● Created Notebooks that extract raw data from a Data Bricks database, transform it, and then insert it into a cleansed Data Bricks database.● Designed and developed the data warehouse models by using Snowflake schema.● Created PowerShell scripts to automate ADF pipeline triggers using Airflow.● Developed stored procedure, lookup, execute pipeline, data flow, copy data, and azure function features in ADF.● Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.● Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility. Show less