Database Design, C# Coding, Unit Testing, Maintainability Designing

Created SQL Server Stored Procedures and C# coding for data interaction

User Requirements, Collecting Test Data, Creating Automation Design, Testing, UAT and Deployment

Outbound Integration (Integration with External Systems), Desiging approval work flow, Coding, testing

Purchase Order is fetched from Microsoft Dynamics, Vendors login into Portal and creation & submission of invoice; facilitated internal approval of workflow and invoice is created back in Microsoft Dynamics using the RPA Bot

Data from the Portal is fetched, automation tool creates Sales Order, Purchase Order and invoice in the Microsoft Dynamics with Invoice validation and status reporting

Client creates an outbound request from the internal ERP system for outsourcing purchase of an Item. User creates a request for item and submits requests to the intermediate buyer to get different quotations, recommended quotations are checked out and inbound data creates the Purchase Order in the clients EBD system

Vendors on boarding Module with workflow, document repository and automation for uploading data in Microsoft Dynamics

Data is downloaded in excel format and internal statistical computation is done to produce detailed analysis on critical components based on procurement lead time statistical

Suppliers input ASN Number, material number, quantity, etc. details in the Vendor Portal, Automation Bot gets supplier, Login into Client Portal, Search for Part Number and updates ASN Number, get the results from the site and updated back data for success or failure. Orchestrator Job is scheduled for performing this entire activity

Automated Login to Client Sites and fetch data for the last two days transactions then update the internal database and create reporting

Automated testing developed using Katalon studio and C#. Login automatically and test for errors based on test sample data. These automated test cases send reports on email for success or failure of test

Web reporting using Tree Map and other charts of Google Visualization API which were used to create a drill down report using flask and Python

Developed SSIS interface to gather data and provide forecasting data to vendors. Client: P&G.

Kalido Support: Everyday transactional data is fetched from the FTP Location and cleansing is done on data. ETL is done with data using Kalido Data Warehouse Solution. Data for Dashboard is processed, and email is sent to clients using SSRS Subscription.

Data is fetched AD servers into FTP Location for ETL/ Data Cleaning and loading into RDBMS. Further data is processed through MS SSAS and Cube is produced to provide BI Reporting data. It worked as a data source for clients on Excel Pivot. The design was validated by the Microsoft team and published the Case Studies in Microsoft Site.

A global leadership and sales potential and performance measurement firm Chally Group Worldwide utilizes industry leading research, predictive analytics and advisory services to clients. Client is having a large number of tables that has gained huge data over the years. Redundant Data Structures were propagated. A new optimized structure for reporting to be created and a data synchronization to be done with existing structure so that old application still runs.

A Web based data warehouse report (PHF to License Report): Insurance Company recruits agents by filling Personal history Form (PHF) and tracking their life cycle through training and examination before providing the license. System accumulates data from various data sources based on time and manager dimension and aggregate in a centralized repository. Drill down reports are provided that have nth level drill down feature in hierarchical manner.

A Web based Instrument (Cheque/Draft/Cash) Deposition System, which creates deposit batches for banks, sends emails to clients and accepts acknowledgement. Bank sends the CMS files (Clear/Bounce data in excel files) which files are uploaded and validated in the system. Systems verify and reconcile the instruments based on the predefined business rules and provide exceptions. System is also built on highly users friendly interfaces.

A Web based Fixed Assets Management System, which was designed to be interoperable with other business systems/ ERPs and should work as a standalone system too. Multiple financial years, multiple ways of depreciation calculation (Income Tax/Written down Value), Multiple Organizations/Units can work together. The system creates Asset classification based on the purchase voucher from the ERP system.

Windows application to generate barcode for Finished Goods Inventory, the application is integrated with legacy system (manufacturing ERP solution- MFG PRO). Application Data is updated in the Progress database. I have created windows application in C# which gets barcode data and updates in Progress 9a.

The project involves migration of the ERP application built on Visual Basic 6.0 to VB.Net 2.0 and SQL Server 2000 to 2008. In addition, diverse databases were merged into a single unified database. It was a large project that had challenges.