Ashish Singh

Projects

Centrica - Supply of Gas and Energy in UK, Involved in client discussion and Involved in Data bricks with
Azure Cloud, SQL, Event Hub, Event Grid, Azure Data
Explorer, Function, Azure API Management.

London Stock Exchange Group (LSEG) (Offsite) - Worked as Azure Data Engineer for Financial Services for Microsoft data services around azure. Involve in discussion with client architect, defining technical scope and Implementation. Involved in Data Lake Ingestion/ Streaming POC with Azure Cloud, KQL, Event Hub, Event Grid, Azure Data Explorer, Function, Azure API Management.

Brokerage Process in the BOSS application: BOSS Application Client: UPS (United Parcel Services) About: Brokerage Process is the one which is carried out during the shipment of goods/documents from one place to another where the below activities are carried out. Receives the invoice information of the product to be shipped. Classifies the product based on the tariff provided by the Customs.

Prepares the required documents for customs declaration. Sends the scanned images of the invoice, images, declaration and other documents to a vendor (Xerox) retain and retrieve the data. Stores the shipment status information such as Hold, Release, etc. in the other UPS systems such as OPSys, and SQL Database. Prepares the brokerage charge, Customs Duty and VAT (wherever applicable) and send the same to billing system to charge the customer.

E-Claims Client: Dabur India Ltd. About: Process implemented for customer claims settlement to bring more accountability, control & faster settlement for our client. This process provide data interfacing with SAP to raise customer debit note and invoices for various purpose. Key users of application are sales, finance & logistic team. In this project we implement various business logic to define promotion cost. Day-to-day operations: Requirement gathering & documentation. Reports creation (drill down, matrix, tabular, linked & parameterized report through SQL SSRS). ETL Package creation using heterogeneous data sources (SQL server, flat file, xml, excel) and loading the data into destination table by performing different kind of transformation using SSIS. Developed various modules using Asp. Net, C# and WCF. Writing complex queries. Creating stored procedures, functions and triggers. Creating web forms through Using HTML, CSS and Ajax. Using JavaScript for UI validation. Deployment on staging server. Involved in handling incident management & change management requests.

Network Indexing Module. Client: Rajasthan Power Corporation About: Network Indexing Module (NIM) facilitate user to create and update electrical network hierarchy master database (NIMDB), separating it from existing GIS system. a) Create/update network master data for various network objects. b) Initial consumer indexing and consumer shifting as on required. c) Generate summary reports at various levels (GSS/33Kv/11Kv and substation). Day-to-day operations: Development in new modules and any change/update in existing modules. Partial Involvement in requirement discussion. Project maintenance. Handling business queries and call related to projects. Month end support in financial application.

Powertech Client: Powertech Transformers Pvt. Ltd. About: This project has a facility to maintain Master, Invoice, Ledger, Reports, and Gate pass. Customer orders for any product the system checks the stock of that item if not found a email is sent to the management for the shortage. Stocks will update by the incoming Invoice product quantity and price. After fulfilled these requirement, bill generated by the system and sent to supplier or customer. Day-to-day operations: Designing database and its connectivity using ASP. NET Running SQL queries for database testing.