Paramesh Eswaran Email & Phone Number

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

• Proficiently contributed to the development of .NET Core APIs.• Demonstrated expertise in designing and implementing SQL schemas.• Successfully managed version control for .NET Core source code.• Consistently ensured adherence to coding standards, fostering code maintainability.• Responsibly handled client work orders and diligently resolved issues to meet their expectations.• Actively participated in technical discussions with clients, fostering effective communication.• Employed performance-tuning techniques to optimize SQL queries, enhancing system efficiency.

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

• Proficiently crafted dynamic procedures to handle various operations, enabling flexibility and adaptability.• Developed robust DTS packages utilizing SSIS control flow tasks and analysis service processing tasks to efficiently extract, transform, and load data from OLTP database to the campaign database, enhancing data integration processes.• Designed and implemented ETL data flows using SSIS, facilitating seamless data extraction from SQL Server and smooth migration and transformation of data from Excel Sheets, contributing to a more streamlined data management process.• Leveraged notification services to generate user-friendly error messages and communicate them via emails, ensuring timely awareness of critical issues.• Actively involved in performance tuning of existing T-SQL code, optimizing query execution and enhancing overall system performance.

Chennai, Tamil Nadu, India

Sotheby’s International Reality: It has real estate website, where all the listing of real estate will be posted every day. Data is being processed to the website on the everyday basis. Listing feeds will be received from the clients and data will be processed to the website through the ETL process.• Redesigned and tuned Stored Procedures, Triggers, Tables, UDF, Views, Recursive CTE and Indexes and able to increase performance of queries. • Developed DTS packages to extract, transform and load into campaign database from OLTP database. • Used SSIS control flow task, analysis service processing task to individually process partitions and dimensions and updating cube as changes occurs in underlying DataWarehouse.• Designed ETL data flows using SSIS and created mappings/workflows to extract data from SQL Server and data migration and transformation from Oracle/Access/ExcelSheets using SSIS. • Involved in all phases of report life cycle (authoring, managing and delivering). • Used notification services to generate error messages and send them to user through e-mails.• Involved in tuning the existing T-SQL code for performance improvement. • Followed the best practices in writing T-SQL for universal readability and re usability of code.

Coimbatore, Tamil Nadu, India

Internship