Solution Architect
Crossover
Total years of experience :18 years, 4 Months
• Aurea Compliance Manager: Built using ASP.net, C#, SQL Server, SharePoint API, jQuery, Bootstrap, REST, JSON, AJAX - is a multitier architecture project covering functionalities like enterprise document management, scheduling, notification, lifecycle and periodic review etc. I am involved in bug fixing, enhancement of existing modules & design and development of new module/feature.
• HPRO: A complete solution for Homeopathy Clinic that includes patient management, Rubrics management, diagnosis and follow ups. Developed using Python, Django, PostgreSQL, AngularJS and bootstrap.
• PRA Security Group and Permission - Developed PowerShell script to implement custom permission on 200k documents in 1000 studies/site collection.
• PRA Audit Response - Developed application using PowerShell and CSV to make the clinical studies compliance to audit requirement.
• Online Banking and GST Registration: Developed/enhanced various modules of Online banking for one of the leading banks using ASP.net, MVC, C#, SQL Server, JavaScript and jQuery.
• Sync DB: Designed and developed this module that initiates workflow as soon as customer data is saved into local database server. After multiple approvals the data finally is stored into core banking system. It was developed using C#, .net, XAML, SOAP, SQL Server and Oracle.
• Migration and Intranet Revamp: SharePoint migration from 2010 to 2013. Customization through web part development using C#, JavaScript and jQuery. Incorporation of UI design into SharePoint.
• Centralized Advertisement Program: This project was about streaming media to the terminals/screens through centralized server. The project includes:
o Media (mostly video files) upload and approval.
o Scheduling.
o Streaming
o Dashboard with live status of screens and Reports.
The project was done for Abu Dhabi Airport Company using ASP.net, C#, VLC Media, SQL Server, JavaScript and jQuery.
• Minutes of Meeting: Option to record meetings, agendas, task items, follow-ups. Assignment of tasks, task completion status, alerts. One clicks creation, email, publishing of Minutes of Meeting document (MS-Word). It was developed using SharePoint API, Open XML, C#, Asp.net.
• Designed and developed custom clearance module for Abu Dhabi Airport Company. This was bilingual application (Arabic and English). The technology used were ASP.net, C#, JavaScript, jQuery and SQL Server.
• TRANSLite® - Transport Management System: This was a classic AJAX based project using ASP.net, C#, JavaScript and XMLHttp and SQL Server. Enhanced and reduced response time for the report’s module. Maintenance, bug-fixing and customer support.
• SCM - Clearance Software used by one of the major logistic company: Designed and developed using C#, ASP.net, JavaScript and SQL Server.
• Loyalty Calculation: Loyalty calculation has been performed on client’s sales database which was having 5 years of sales data that amounts to around 70 GB of space. The system first migrates the data from sales database to portfolio optimizer database and then updates the Loyalty Status column after performing calculation on existing data. The system was developed using ASP.net, C# and TSQL.
o Provide approach together with pseudo code covering error handling, error logging and performance issues to client’s IT Team.
o Authored migration and loyalty calculation scripts.
o Performed manual testing and introduced Clustered & Non-clustered indexes on tables involved in calculation.
o Did Profiling and tuning of the system using SQL Server Profiler.
• Mecklai Price Ticker: Mecklai Price Ticker has been developed as a product that displays the rates of domestic and international currencies in real time. The ticker also displays the forward rates of the USD/INR, open/high/low/previous day closing rates of commodities, and NSE/BSE indices. It was having option to customize the ticker.
o System Design
o Mock development.
o Web service and application development.
o System testing on various versions of Windows.
o Versioning of product, auto detection of new version through client application and option to download and install the new version.
• Co-ordination with the business process team to enhance MRM (Mecklai Risk Manager) and Provided technical support to the existing and new clients.
• Onsite requirement gathering and coordination with internal team.
• Development and testing in a team and on individual assignments.
• Process understanding of Coil creation.
• Understanding and documentation of the requirement for Auto decision of coil over dimension tolerance.
• Development of Algorithm for auto decision.
• Development, testing and UAT of application on AS/400 and Mainframe systems.