Created SSIS package to upload the data from the clients. We get approximately 100k records per week in claims

• Part return approval process first from the supervisor than from the engineer.
• Using Azure cloud services to maintain, upload the data in SQL server.
• Autogenerate emails when a new part is created and 48 hours before the due date for part return analysis.
• Multiple uploads for pics for each test.
• Capability to do different tests based on the customer.
• The capability of uploading/Searching the final analysis report that was created by an engineer.
• Multilingual capability.
• Translation of textboxes on the fly for the default language currently used by user.

Created Custom reporting for the client per requirment. The data was coming from the database that was loaded using SSIS package

Designed and developed the project to fulfill all the business requirements . After initial data was pulled from the railroads.