Now you can Instantly Chat with Mrinmoy!
About Me
- Total 15 years of experience in analysis, design & development of web based applications. Currently working as a full stack dotnet developer in Angular 8 a...
- 6 years of working experience in the United States at different client locations.
-
Primary Skills:
C#.net (1.0, to 7.0), Dotnet Core (1.1, 2.0, 2.1, 2.2), PCF, ASP.net, Microsoft Dotnet Framework (1.1 to 4.7), WCF, RESTful Services, Microsoft MVC (4, 5, 6), WebAPI 2, MSTest, DI, Object Oriented Programming, SOLID Principles, SSIS (ETL), SSRS, Entity Framework (4, 5, 6) , Entity Framework Core (1.1), LINQ, EP Plus, SQL Server (2000 to 2016), SQLite, AD/IAM, XML, XSLT, SAML, SSO, HTML (4, 5), CSS, JavaScript, jQuery, jQuery DataTable, BootStrap, Responsive UI, JSON, Angular 6, 7, 8, Material Design, SignalR, Chart.js, Microsoft Visual Studio (2003 to 2019), IIS (6.0, 7.0, 7.5), VSS, TFS, GitHub, GitLab, Agile/Scrum
Education:
- B-Tech in Computer Science & Engineering from Netaji Subhash Engineering College, India in 2004.
Skills
Portfolio Projects
Description
I worked as a full stack dotnrt developer in this project. Here I worked in Agile mode with the team.
The project consists of many dotnet core based microserices and few Angular and AngularJS based UI applications. I worked as a developer in both microservices and UI applications.
Developed the single page UI using Angular 8 and followed the material design approach.
Created WebApi to connect to the TFS, get work item details and download attachments.
Used Entity Framework Core as ORM tool between the database and MVC controller.
Written huge number of LINQ and Lambda expressions for data communications.
Used CORS and developed huge numbers of Microservices using .NET Core 2.2.
Used UI-Router to route between Angular component and AngularJS pages.
Deployed the UI and services to the Pivotal Cloud Foundry.
Used XUnit to create unit testing functions in the server side.
Wrote Jasmine and Karma based Angular unit tests.
Description
Created MVC5 based web application in C#.net.
Designed the application and the EF Code First Database with SQL Server 2016.
Used Unity Container to do the Dependency Injection between Controller, BLL and DAL. Defined the dependency in the web configuration file.
Created custom HttpModule to assign the database defined roles to the user principal.
Applied and validated Anti Forgery Token in all forms to prevent Cross Site Request Forgery.
Created custom mvc filter to handle and log the application errors globally.
Used jQuert DataTable with server side paging.
Used BootStrap as the primary component for responsive UI designing.
Used OpenXML and EP Plus to import data from excel spreadsheet.
Used Chart.js to create graphical dashboard and developed different SSRS reports.
Developed SSIS package and scheduled in SQL Agent to fetch user information.
Used MSDB SQL Email to send reminders through SQL Agent job.
Used Report Viewer to display report in the MVC View.
Created MSTest based Unit Testing functions.
Show More Show LessDescription
Used both razor engine and jQuery to GET/POST data between client and server.
Used Entity Framework code first approach and LINQ/Lambda expressions extensively for database operations in the MS Sql and MySql databases.
Used Bootstrap calendar plugin to display the test schedules of the whole year in yearly calendar mode in the browser with update/delete options.
Used jQuery DataTable extensively in many web pages for pagination, search, sort, export etc.
Created scanner client console using .net core to make it deployable in the linux and mac OS.
Read security certificate and trust chain information and stored the details in the database.
Implemented huge numbers asynchronous task based WebAPI actions and provided functionality to cancel operations using the CancellationToken feature.
Used encryption and hashing techniques to ensure maximum possible security of the secure data. Read encrypted data of the X509 certificate to figure out the certificate details and expiry date.
Used ping and port scan functionality in the scanner console and retrieved certificates from the open host-ports.
Used SQLite DB engine in the scanner client application to store the intermediate certificate scan results.
Used SignalR library to keep client and server in sync with the real time update.
Used Tinymce html editor in few places to provide option to input rich html data in the system.
Used SqlDependency to schedule certain daily DB and Sync operations.
Given feature to the admin to create html forms and elements dynamically and associate those with the main form based on different selected values. Admin can create different types (Textbox, DateTime, DropDown, Checkbox Group etc.) of questions, create different forms and then attach questions with the forms as needed.
Validated users identity from Active Directory through the OWIN authentication methods
Used .Net Directory Services to get and search user information from the Active Directory.
Used Chart.js for displaying reports with different types of charts in the web page.
Used OpenXML and EP Plus to export different reports in Microsoft Excel format.
Description
Designed and developed huge number of SSIS packages for data migration and integration operations between different internal and external systems.
Used C# in the SSIS script components.
Wrote performance effective SQL queries, Views, Stored Procedures, Functions, and Triggers in SQL server 2008 extensively.
Designed and worked on complex solutions for the data integration to the Salesforce environment and other applications.
Used 'Script Component', 'Conditional Split', 'Derived Column', and ‘Data Flow Task with dynamic expression' in the SSIS packages.
Worked with multiple teams to create integrated solutions as per the business requirement.
Description
Used 3-layer architecture to design and develop Presentation Layer, Business Logic Layer and Data Access Layer.
Used Typed Datasets in few cases for the data communication between Data Access Layer & Database.
Implemented form based authentication and role based authorization to regulate the access to the application.
Performed data validations using validation controls such as Required Field Validator, Compare Validator, Range Validator, Regular Expression Validator and Custom Validator.
Used custom JavaScript functions to change the behavior of validation controls dynamically.
Used ASP.NET client side and server side state management techniques.
Used ADO.NET Connection and Command objects extensively to execute SQL stored procedures and Queries.
Designed and developed Stored Procedure, Views and SQL functions in SQL Server 2008.
Created Stored Procedure to return number of columns dynamically using PIVOT statement.
Description
Used SOAP based WCF services extensively for the data communication between the Silverlight UI and the data access layer.
Used Entity Framework for the data access operations.
Wrote SQL queries and complex Store Procedures in SQL server 2008.
Designed and developed different SSIS packages for ETL operations – dealt with huge amount of internal and vendor data.
Designed SSIS package to fetch user details from LDAP server.
Description
Designed and developed WCF powered SOAP and Restful services using .NET framework 4.0.
Used http verbs GET, PUT, POST and DELETE methods for MVC Web API services.
Used Entity Framework for the data access operations.
Wrote SQL queries and Store Procedures in SQL server 2008.
Used MVC 4 and Razor engine for the UI.
Also used HTML5/CSS3, jQuery and AngularJS in some of the UI pages.
Created Stored Procedure and SQL Server Agent Job for moving aggregated IAM message in summary table automatically.
Worked in the Agile environment. Used Pivotal Tracker tool to manage the backlog and tasks.
Description
Used Microsoft Silverlight 5 for the user interfaces.
Designed and developed huge number of WCF Services for the data communication mechanism between the Silverlight UI and the SQL Server database.
Used ADO.Net components like DataSet, DataReader and DataAdapter in the data access layer for the database operations.
Wrote SQL Scripts, Stored Procedures, Functions and Views in SQL Server 2008.
Prepared large volume of SQL scripts for migrating data and structure of the customer's production database during each new release of the product.
Created SSIS application using VS BIDS for storing viewer's statistics of the Showtime Boxing event into the database from text data files through ETL.
Used VS BIDS and SSRS to develop different textual and graphical reports.
Created a console application in C# Dot Net for renaming the excel sheets of the reports and for sending the report to clients through email.
Gathered requirements from the product owners and managed our offshore team in India – worked as an onsite offshore coordinator.
Description
Used 3-tier architecture to design and develop Presentation Layer, Business Logic Layer and Data Access Layer.
Implemented multilingual feature and provided language translation feature through asp.net resource (.resx) files.
Created web based admin website for creating and deploying new web based user web sites dynamically. Predefined different Themes for the admin to select for the public website.
Implemented impersonation process in the admin site to dynamically create the Virtual Directory, Database and copy application files and DLLs for the public website.
Used DES password encryption technique for the impersonated windows user account.
Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#. Used Dundas Chart in the dashboard for few graphical reports.
Used ADO.NET in the DAL and written Stored Procedures, Functions and Views extensively.
Used Microsoft Team Foundation Server (TFS) for the purpose of version control and source code maintenance needs.
Description
Implemented form based authentication and role based authorization to regulate the access to the application.
Designed and developed various interfaces, classes to construct the business logic using C#.
Performed data validation using validation controls such as Required Field Validator, Compare Validator, Range Validator, Regular Expression Validator and Custom Validator.
Given option to the user to upload product details in particular XML format and XSLT is used to show that information in user friendly style in the UI.
Used ASP.NET client side and server side state management techniques.
Used ADO.NET Connection and Command objects, DataReader, DataSet and DataAdapter extensively in the DAL for different database operations.
Designed and developed Stored Procedures, Views and Functions in SQL Server 2005.
Description
Gathered requirements from the client, designed the application and the database.
Distributed tasks among the team members and worked together as team and guided team with technical and logical help.
Created Perl-CGI based web application for the admin to define PDF parsing rule/logic and view the evaluated information. Used MySQL as the database management system.
Used Cron based scheduling mechanism to automatically start the PDF parsing process.
Used PDF2HTML to convert the PDF into XML file.
Used regular expressions extensively to read required data from the XML file dynamically.
Designed web pages with HTML, CSS and JavaScript.
Created custom pagination using hyperlink and MySql data fetching logic.