Worked for clients National Grid, Kemet Corporation, Agriculture Bank of Chain, Henkel, Philips & Telstra

Client UnileverSCDG- Supply Chain Data Gateway application is an enterprise class data warehouse system that aims to provide a single source of truth for Unilever’s supply chain related data items. Raw data is sourced from 4 regions (AAR, Europe, Americas, India Sri-lanka) and loaded into an SCDG region specific raw database. SCDG then processes each regional database and transfers transformed data into a fifth global Mart database.Responsibilities• Requirement Analysis • Documentation •Data ware House Loading •Designing Packages for loading DWH and Batch Import process •Development • Testing • Application DeploymentTechnologies: Microsoft Visual Studio 2012, C# MVC, Entity Framework, SQL Server 2012 and MSBI 2012, Source Tree, Team City, UTrack

Worked on Support & Development Projects like Markets Data Warehouse (MDW), BAU MI Reporting, which includes LBG’s Data Staging, Data Warehouse with Cubes & Dynamic reports used by various teams.MDW is data warehouse which provides management information to the business instantly and in a self-service manner. It is also to be the authority and central source of MI reporting. Reconciliations of expected transactions will be performed after each successful MDW ETL against source systems and include reports to identify any missing records in the MDW data store, the results are used to instigate further investigation with the respective Group IT System Support teams and Markets Operations Processing teams.BAU MI Reporting is a collection of SSIS packages and tables that contains details of LBG warehousing and reporting data. The contents are updated daily Monday-Friday from the Group Data Warehouse. Other data is extracted from CrisP(Oracle db) and MDW(Deals)

Requirement Analysis and meetings with clients. Designing of High and Low level design documents. Preparing Test cases for the tasks. Development and code integration in VSS. Unit, Module and Integration testing and preparing test logs. Query Optimization & Integration Services  Projects Gconnect is a retail customer facing internet website that allows our customers to view GMI information 24/7 without having to contact their GMI sales rep.  The intent is to improve customer service by providing better access to information but not replace contact with the rep.  The site has two major components: content (documents) and a product search.   CustomerView is an internal extranet website for GMI representatives only.  It has two main features: Managing customer contacts and managing GCONNECT contents.Responisibilites Requirement analysis and weekly meetings with the customers Created web services for fetching and transferring the data from other sources Written complex stored procedures and query optimization Generate business layer code which communicates the Application and data layer Unit, Module and Integration testing and preparing test logs

Worked on enhance dot release of the of QQSMQuick Quote Service Module is a windows application that generates Service quotes for the Nortel networks products or parts based on criteria like Customers, Regions & Discounts. This will help various Service Groups to create stand-alone Service Quotes as well as combined Sales & Services quote. Quick Quote Services Module is the corporate sanctioned Global Services quote tool for Carrier (Wireless, Wire line and Optical) Services globally. It applies commercial rules to create a quote.

Medlab.Net is a web application which deals with managing labs by keeping track of accessions which is the vital information for the lab hence connecting the patient with various parameters Like Doctor, Nursing Homes, Insurance Companies etc. the patient accession is connected with master information consisting of profiles, test categories, tests and diagnosis. The system also manages accession results and invoices hence giving a complete control on the lab management. The Security for the System is well organized, based on Users and User GroupsTechnologies Asp.Net, Vb.Net, Ms SQL Server, Crystal ReportsPrinter spooler is a windows Multi-threaded application which prints the data from an excel file on the smart cards parallel on multiple printers. We use Magicard printers and it’s SDK which has its external functions. The other module is chip writing which writes the customer’s secure data and encrypt it using java card readerTechnologies C#, Dot Net 2010 Framework and MS Sql Server 2000Responsibilities Was Involved in Requirement Analysis and Specifications. Created project Design documents and Business process diagrams designing using Visio. Generated tables, stored procedures and database diagrams. Also worked on Unit and Module Testing. Participated in full life-cycle of project development. DB Normalization and Exporting and Scripting as an DB Admin