Mohit Sharma

InsightsFirst

Make data-driven decisions for your supply chain needs through marketing, supply, and competitive capabilities. Can track recent moves, from pricing to partnerships, investments and publications. Keep track of what’s happening in competitor sector or market. Gather and store all intelligence in a central location. Utilize business intelligence tools like Power BI or Tableau for integrated reporting-

Responsibility:-

Development of front end, stored procedures and web api. Integration of power bi api in the application.

Collect business requirement and assign tasks to team members.

Technology Used:

Angular , .Net core, Sql server 2012, Aspose, Micro front end services

Syngenta

Syngenta AG is a global company that produces agrochemicals and seeds and is based in Basel, Switzerland. As a biotechnology company, it conducts genomic research. It’s a web based portal in which analysis of crops production on the basis of various factors is done based on the data provided and various reports are prepared in the form of charts and tabular data. Chart data as well as charts are exported in power point and excel form.

Responsibility:-

Development of upload data functionality. Web forms containing the charts, export functionality are developed. Currently working on the enhancements required by the client

Technology Used:

• Angular , Web Api2, Sql 2012, Aspose, Fusion charts

Vontobel Investment Banking-Switzerland

This is a web based application that helps the user to view the daily index levels for indices that are being calculated on the basis of some methodology using windows service. Apart from this user can identify the indices whose levels do not match with provided source levels and actions are required on the indices. In this app there is a functionality in which automated reports are sent over mail and user can also view the reports on the portal.

Responsibility:-

Development of an index on-boarding wizard in which a step-by-step process is followed to upload the indices data which save a lot of manual backend process. A reporting dashboard is also developed to view and export the client required reports.

Technology Used:

• MVC, Entity Framework, JSON, JQuery, Angular 6

Citigroup - Financial Modeling – Unites States

Client is the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Client provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Client’s core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients.

Responsibility:-

Implementation of business logics on equities and debentures of major

investment bank. My responsibilities include management and

development of the build on SourceTree and Github.

Technology Used:

• C#, NUnit, Latex, Xml , Excel-Addins (Client Provided), Latex

MI Portal

MI portal is a web based Market Intelligence portal integrated with SharePoint environment which offers a rich set of flexible and fixed charting capabilities that make creating and customizing charts simpler and helpful in effective decision making and reporting.

Role &Responsibility:

Charts:-

Fusion charts tool is used to render different types of chart based on various filter parameter in the entire application.

PowerPoint export:-

• Developed a module which is used for exporting the charts with tabular data into the PowerPoint slide(s) throughout the portal.

Excel export:-

• Developed a module which is used for exporting the tabular data into the excel sheet(s) throughout the portal.

Major project:-

• Developed a module which is used for CRUD operation for major project. Proper validation is maintained and also URL is validated while submitting the form in this section.

Manage Role:-

• Developed a module which is used for CRUD operation for custom Role. Entire portal page name with access right are listed before creating a Role. According to that Admin will create/update/delete the custom role. While deleting a Role, a message is displayed the no. of active and inactive user(s) assigned to that role.By creating a custom role admin can give the limited access to the user. When that user willaccess the portal, only assigned page(s) will open otherwise it will show an unauthorized access page.

Country news, reports, and references:-

• Developed a module which is used for listing the country specific news, reports and references (major projects). User can easily able to find the country specific news, reports and references (major projects) by changing the country.

Other responsibility:-

• Coding of different modules assigned to me using C# language in Business Layer.

• Database design and writing store procedure & query as per the requirement.

• Undertook Defect analysis and fixes as well as self-testing.

• Executed code debugging for analyzing the changes on existing code due to ongoing changes in the business.

Technology Used:

• Application Programming Languages : C#.net, WEB APIs 2.0

• Framework: Dot net 4.5, Dapper (ORM), Entity Models

• IDE: Microsoft Visual Studio 2013

• Backend Tool: MS SQL Server Management Studio 2012

• Others: JavaScript, jQuery, HTML, CSS, CSS3, Bootstrap Library, AJ

CIP Portal

CIP Portal is basically a competitor intelligence portal integrated with SharePoint environment which offers a rich set of flexible and fixed charting capabilities that make creating and customizing charts simpler and helpful in effective decision making and reporting.

Role &Responsibility:

Charts:-

Fusion charts tool is used to render different types of chart based on various filter parameter in the entire application.

.

Responsibility:-

• Coding of different modules assigned to me using C# language in Business Layer.

• Database design and writing store procedure & query as per the requirement.

• Undertook Defect analysis and fixes as well as self-testing.

• Executed code debugging for analyzing the changes on existing code due to ongoing changes in the business requirements.

Technology Used:

• Application Programming Languages : C#.net, WEB APIs 2.0

• Framework: Dot net 4.5, Dapper (ORM), Entity Models

• IDE: Microsoft Visual Studio 2013

• Backend Tool: MS SQL Server Management Studio 2012

• Others: JavaScript, jQuery, HTML, CSS, CSS3, Bootstrap Library,Ajax

This is designed to provide a remote interface to home appliances, to provide control and monitoring on a computer or a web browser. This system can control HVAC(heating, ventilation and air conditioning), lighting, audio-visual, shading, security(camera and sensors) .

Roles & Responsibilities:

§ Participated in system analysis and design.

§ Coordinate with stakeholders to collect and analyze project requirement data.

§ Contribution to requirement gathering, SRS and Technical design specifications.

§ Timer Functionality-for equipments to work according to timer.

§ Responsible for coding for many modules .

§ Was involved in the development of database.

§ SQL database optimization, query performance improvements.

§ Review .Net and SQL code to conform to Standards.

§ Unit Testing.

Environment : Windows Application in .NET C#-4.0, SQL 2008