Gayathri Punniyamoorthy

Project: IDP.

Client: Bank of Montreal.

Role: Developer (Development and Testing)

Tool: SSIS, DB Visualizer, and SQL Server.

Roles and Responsibilities:

• Designing and developing ETL packages based on the client requirement using Microsoft SQL Server Integration Services (SSIS) to extract data from various sources, transform it, and load it into multiple destinations.
• Deploying the packages using GitHub and Ansible pipeline.
• Performing unit testing and bug fixing.
• Doing impact analysis using Power BI and SQL.
• Working on ad hoc requests, major issues, and resolving production issues.

Project: Automation.

Client: Multiple banking and insurance clients.

Role: Developer (Development and Support)

Tool: SSIS and SQL Server.

Roles and Responsibilities:

• Requirement gathering, designing, and developing ETL packages based on the client's requirements.
• Using Microsoft SQL Server Integration Services (SSIS) and SQL, extract the data from various sources, transform it, and load it into databases.
• Designing and developing data transformation solutions using SSIS components, such as Data Flow Task, Data Flow Transform Tasks, Data Flow Containers, For Each Loop Containers, and Script Components.
• Developing complex SQL stored procedures in SQL Server, and integrating them with SSIS to automate the jobs, to avoid manual intervention on daily data load and integration activities. Monitor, diagnose, and maintain deployments.
• Performing unit testing and performance tuning to improve database performance.
• Fixing UAT and production issues.

Project: Supply Chain Management and Process Production in ERP.

Client: Kanan Latex Industries and Jyothy Ceramic Industries Pvt. Ltd

Role: Developer (Development and Support)

Tool: EDK, DCUBE, RDW reports, SQL Server Management Studio, and Jasper Reports.

Roles and Responsibilities:

• Requirement gathering from the client, designing the module using EDK, and developing the code using SQL Server Management Studio.
• Developing integrated stored procedures, functions, and complex queries using SSMS.
• Designing RDW, DCUBE, and Jasper reports using EDK.
• Performing unit testing and performance tuning to improve database performance.
• Fixing UAT and production issues.

Project: Real Estate Solutions (ERP).

Client: DLF.

Role: Developer (Development and Support)

Tool: RVW, RDW reports, and SQL Server Management Studio.

Roles and Responsibilities:

• Designing the module (RVW and RDW reports) using EDK and developing the codes using SQL Server Management Studio.
• Performing unit and UAT testing, and fixing issues.
• Doing performance tuning and improving query performance.

Project: Supply Chain Management (Procurement, Inventory, and Repair Order in Aviation)

Client: AMGH, COBHAM, ADAC, AIRINDIA, GHC, etc.

Role: Developer (Development and Support)

Tool: RVW, RDW reports, and SQL Server Management Studio.

Roles and Responsibilities:

• Resolving production issues for multiple customers.
• Performance tuning to improve database performance.
• Designing and developing code based on the client's request.
• Working on multiple ad hoc requests.