Amudha M.

Amudha M.

Senior Software Engineer

India
Hire Amudha M. Hire Amudha M. Hire Amudha M.

About Me

Amudha is a Senior SQL Developer with 8+ years of extensive experience in SQL Server, SSIS, and Informatica. She develops BI solutions encompassing ETL processes and reporting using SSIS, T-SQL programming, and PL/SQL procedures. Amudha has demonstrated expertise in extracting, transforming, and loading data from diverse sources using SSIS, import/export data, and bulk insert methodologies and optimizing Informatica mappings and sessions for enhanced performance. With foundational knowledge in Power BI and SSRS, she is also skilled in resolving complex ETL challenges and liaising with source system owners.

ADF 7 years MSSQL 10 years T-SQL 8 years

Work history

Marina Bay Sands (MBS)
Marina Bay Sands (MBS)
Team Lead
2023 - 2024 (1 year)
Remote

  • Worked on tables and procs based on the application team requirements and did performance tuning for the existing database procs.

  • Updated configurations for the new packages in the existing SSIS template.

  • Validated data between Source and Staging destination server based on the package loading from source to staging.

  • Loaded the fact table from the staging by updating configurations of the existing SSIS template.

SQLMicrosoft Data Transformation Services (now SSIS) SQL Server Management Studio (SSMS) DatabasesDataproc Performance Tuning
T-Mobile
T-Mobile
Team Lead
2022 - 2023 (1 year)
Remote

  • Worked on tables and procs based on the application team requirements and did performance tuning for the existing database procs.

  • Loaded data from feed file to Teradata through Aptitude and validated the data between Teradata and Snowflake during the migration.

  • Executed job commands in Unix and loaded data manually into Teradata using Control-M jobs.

  • Reprocessed failed records by fetching the error log, reloading the missing 3-dimension data and loading the failed records.

TeradataSnowflakeTeradata SQL Assistant Control-M PythonSQLPerformance Tuning Unix
Loyalty & Tournament – Casino Gaming
Loyalty & Tournament – Casino Gaming
Team Member
2021 - 2022 (1 year)
Remote

Worked on tables and procs based on the application team requirements and did performance tuning for the existing database procs.

SQL Server Management Studio (SSMS) Microsoft Data Transformation Services (now SSIS) Azure DevOpsGaming
Amgen
Amgen
Team Member
2018 - 2021 (3 years)
Remote

  • Worked on the implementation of change requests from the client.

  • Created Informatica and SSIS packages to extract data from various sources and load it into the data warehouse on a daily basis.

  • Worked on an intercontinental commercial reporting application, extracting medicines, patients, physicians, and pharmacies details from various sources and loading them into the data warehouse.

SQL Server Management Studio (SSMS) InformaticaMicrosoft Data Transformation Services (now SSIS) Data Warehouse
SNHU Reporting
SNHU Reporting
Team Member
2014 - 2018 (4 years)
Remote

  • Extracted student information from Oracle to a local server using SSIS and transformed the data to another server using FTP.

  • Worked on the implementation of change requests from the client.

  • Created SSIS packages to extract data from various sources and load it into the data warehouse on a daily basis.

SQL Server Management Studio (SSMS) Microsoft Data Transformation Services (now SSIS) ToadOracleFTP Data Warehouse

Education

BE Computer Science and Engineering
BE Computer Science and Engineering
Balaji Institute of Engineering and Technology, Chennai - India
2010 - 2014 (4 years)