Mridul Kumawat Mob # +91–9739672420, +91-8073844712
Email:mridul.kumawat86@gmail.com
Professional Summary
➢ Professional Seasoned Developer with 10+ years of IT experience in Product Development and
Implementation of various enterprise e-business solutions and n-tier architectures leveraging the
power of Microsoft Technologies for various business domain like ETRM (Power & Energy), Banking
& Financial Services (BFSI), Education and CPG.
➢ 10+years of experience in Design, Analysis and Development of web and windows-based
application in Microsoft .NET Technologies using Visual Studio. NET, C#.NET, ASP.NET, WPF, WCF, Web
Forms, Win forms, Microsoft Azure, ADO.NET, CSS, Web Services, Windows Services, LINQ, SQL Azure
and JavaScript.
➢ Provided strategic architectural directions and executions for various software projects.
➢ Authored and participated in architectural review and exploration.
➢ Experience in analysis, design, and development with state-of-the-art-technology in Internet,
Intranet, Client Server and Stand-alone Applications.
➢ Designed and implemented Service-Oriented Architecture solutions.
➢ Conceptualized and designed application user interfaces to enhance user experience.
➢ Worked very closely with Global Project Teams including IT architects, Operational Architects
to ensure the solution is compatible and a long term fit for the company.
➢ Attended workshop in London from External vendors on Trading domain.
➢ Ensured efficient user operation by creating program evaluation support documentation.
➢ Carried out application database upgrades, database backups, database restore, database
performance, backup scripts, deployment of patches and maintained data files and
transaction logs.
➢ Used codes and flowcharts to develop technical documentation and reports.
➢ Supported work flow management infrastructure components in alignment with business
objectives.
➢ Reconciled interface of external and internal application systems.
➢ Adapt in writing Documentations, preparing Requirement Specifications, Questionnaires and
Analyzing domain specific issues.
➢ Sound Functional knowledge on advance electronic banking payment systems such as RTGS
(Real Time Gross Settlement) and NEFT (National Electronic Fund Transfer). Familiar with
SWIFT & SFMS messaging formats.
➢ Have been awarded with innovation award for data mining tool in Shell.
➢ Trained and mentored junior/fresh grades programmers in programming methodologies and
best practices in London, UK.
➢ Certified SCRUM MASTER.
Technical Skills
Languages C#,Visual Basic 6.0, XML, VC++
RDBMS MS SQL Server 2008/2012, Oracle 10g, My SQL
1
Distributed Technologies Web Services, WCF
Web Technologies ASP. Net, C# .net, ASP. Net MVC, LINQ, XML, Web API,XHTML,
jQuery, WCF, Silverlight,Anti XSS, JavaScript, Ajax,VB Script
Windows Technologies WPF, Win Forms,Windows Services
Tools VSTS, Crystal Reports, IBM MQ Series, Dev Express, Telerik, JIRA,
BugZila, ReSharper, SM9
Microsoft Development Platforms Visual Studio.NET 2017/2015/2012/2013/2010/2008/2005
Cloud Technologies Microsoft Azure
Configuration/Version Management TFVC, Visual Safe Source, SVN
Application Servers IIS 7.0
Employment History
Shell India Developer/Technical Analyst Oct 2015- Present
EAFT Technologies India Pvt. Ltd Tech Lead April 2014 – Sep 2015
ITC InfoTech Pvt. Ltd. Associate IT Consultant (SSE) August 2011 – April 2014
Logica Pvt. Ltd (Now CGI) IT Consultant (Software Engineer) May 2008 – August 2011
Qualification
➢ B.E. in Computer Science and Engineering (2007), University of Rajasthan, India
Work Experience
Shell India Pvt. Ltd, Oct 2015 to Present
Current Responsibilities:
❖ Design, Development and Testing of Trading & Supply application using Asp.Net C#, WPF,
WCF and C# related frameworks in Energy Domain (Power Trading).
❖ Create Solution Architecture based upon Microsoft Azure Services.
❖ Design solution for various system components using Microsoft Azure.
❖ Configure & Setup Azure Hybrid Connection to pull data from trading exchanges systems.
❖ Working as BA & Developer for current projects.
❖ Stake Holder Engagement/Customer requirements review and requirement compliance.
❖ Working with ASP.Net, C#, Web Services, Windows Services, XML, Java Script, WPF, SQL
SERVER, Oracle.
❖ Responsible for Designing & Implementation for sub systems with in the application.
❖ Understanding the Requirement and preparing Technical specification, User Manual,
Deployment/Release Documents.
❖ Worked on SM9tool for Enhancements, PAL4, Change & Release Process.
2
❖ Setting up of code review checklists, code review process, defect fix life cycle and other
processes within the project.
❖ Reviews – Code, Unit Test Case, IAD, HLD, LLD.
❖ Developed Windows Services(Straight Through Processing) to extract the data from source like
Exchanges (EPEX, APX, Trayport) and N2ex for UK, Netherlands, Swiss & Germany Power
Markets.
❖ Design & Developed solution to feature Intraday Trading Feature for all the UK power market.
❖ Developed HTML and ASP.NET pages to meet the business requirements and also involved in
replacing HTML pages with redesigned ASP.NET pages.
❖ Tools and Technology evaluation and prototyping for the product.
❖ Design and implementation of Authorization module – using roles and permissions, for a web-
based application.
❖ Performance analysis of web applications using fiddler and http watch, also tuning of stored
procedures.
❖ Part of Release Management team.
❖ Shadowing a project as Technical/Solution Architect.
❖ Running a Developer forum across departments in Shell.
Current Role:
❖ Developer (Individual Contributor) and BA.
❖ Stake Holder Engagement.
❖ Developing and Enhancement of Existing Product.
❖ Developing E-Trading Platform for NW power desk.
1) Trayport Automated Trading
Client: Shell Trading NW Desk
Technical Environment: .Net 4.6.2, C#, WCF, WPF, SQL Server, Multithreading, LINQ, XML, Microsoft Azure
Role: Developer & BA (Individual Contributor- End to End development)
Team Size: 4
Enabling shell traders to put Ghost/Hidden and Stop Limit rules/orders and then based upon
business logic execute the orders into deal/trades. Auto trading puts shell traders in the market to
get Aggressed or Initiated based upon their preferences.
Application consists of Desktop Client as GUI an server side component to get the best available
price in the market for trade to be captured based upon auto trading algorithm.
2) STP (Straight Through Processing):
Client: Shell Trading & Supply Front Office
Technical Environment: C# (Version 4.5) Windows Service, WPF, Oracle, Multithreading, LINQ, XML.
Role: Developer (Individual Contributor- End to End development)
Team Size: 3
STP (Straight through Processing) is a windows service framework that processes SAP trades, XML
files, Extract Trades from Exchanges, Third Party API’s being populated in ALIGNE (Trading
Application) database and feeds into Aligne ETB directly via the Aligne Importer.
Application makes use of Enterprise Library 5.0 components to address Logging and Exception
Handling.
3
EAFT Technologies India Pvt. Ltd, April 2014 to Oct2015
Responsibilities:
❖ Design, Development and Testing of Education products using Asp.Net C# and related
frameworks.
❖ Customer requirements review and requirement compliance.
❖ Working with ASP.Net, C#, Web Services, Windows Services, XML, Java Script, WPF, SQL
SERVER, IIS.
❖ Technical Lead responsible for unblocking technical challenges.
❖ Responsible for producing design and architecture for sub systems in the application.
❖ Understanding the applications and preparing Technical specification and User Manual.
❖ Developed a New Product for EAFT for Generating test paper in WPF.
❖ Worked on BugZila for reporting and maintaining for incidents.
❖ Part of Android App design team.
❖ Reviews – Code, Unit Test Case, IAD, LLD.
❖ Developed HTML and ASP.NET pages to meet the business requirements and also involved in
replacing HTML pages with redesigned ASP.NET pages.
❖ DB Design such as Schema creation and Created Store Procedures, Functions, Triggers, Indexes
and Views using T-SQL in Development.
❖ Have used SQL profiler for query and procedure optimization.
❖ Tools and Technology evaluation and prototyping for the product.
❖ Improvement of performance of the product and device (Teacher & Student Devices).
❖ Part of Domestic Professional Services team.
3) Product – CLS(E-Campus)
Client: BVB Engineering College (Hubli), NITTE, VMU (Tamil Nadu), PES IT (Bangalore), Kunsappkolan (Delhi) etc.
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server, JavaScript, LINQ, XML, Web service, HTML, CSS,
XML, IIS.
Role: Technical Lead
Team Size: 5
Collaborative Learning System (CLS) is a product, integrated end-to-end solution for universities and
schools. CLS’s delivery platform is built upon, best-in-class tablet computers that provides true
mobility and with ease to both teaching staff and students. The backend services of CLS are built
using Web technologies which enable administrative and teaching staff to configure management
information and collect statistics all the time.
CLS solutions take a modular approach to digitization, Provides the flexibility to embrace the best
solution that is suitable for their needs for digitizing textbooks or automating attendance in
classrooms and so on.
4) Product -TPG (Test Paper Generator)
Client: Product of EAFT
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server, LINQ, XML, Web service, IIS.
Role: Technical Lead
Team Size: 2
4
TPG (Test Paper Generator) is an EAFT’s application enables user(s) to create/generate exam paper
for a specific semester in a cost-effective manner and in very less time. This application product is
intended to be used in educational institutes.
ITC InfoTech Pvt. Ltd, India Aug 2011 - April 2014
Responsibilities:
❖ Responsible for development Master Pages & Farmer Module using ASP.Net C# (Version 4.0)
to support 3-Tier architecture.
❖ Understanding of various domains like Core and retail Banking and FMCG to ensure domain
specific applications development.
❖ Developed Critical Transaction from Front-End to Back-End modules such as Farmer, Crop Life
Cycle, Harvesting, Green Tech and Search Engine for ITC Products, Bulk Upload, Android and
Web Portal Synchronization.
❖ Understanding the applications and preparing Technical specification and User Manual.
❖ Used logging, caching and data access application blocks and developed the applications.
❖ Generated a high-level function hierarchy through analysis of information needs.
❖ Used case diagrams, class diagrams, sequence diagrams and activity diagrams for pictorial
representation of process using UML.
❖ Designed and implemented flexible data access components for extracting data from various
database systems using ADO.Net, XML, C#.NET and SQL Server 2012.
❖ Used Presentation Layer as CSS which allows customization of layout, color based on the user
selection using XSLT, XML and CSS.
❖ Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, Data View for consistent
access to SQL Server data sources.
❖ Handled Run Time Errors & Design Time Errors by implementing appropriate Error Handlers.
❖ Developed the security infrastructure for authenticating and authorizing user access as well as
performing other security related tasks such as Impersonation, LDAP authorization, 3DES
Algorithm, Password management policy.
❖ Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development
and Production environment for SQL Server.
❖ Responsible for Configuration Management of the project by using module developed with latest
version in TFS.
❖ Reviews- Documents, Code.
❖ Used ASP.NET, HTML, to create dynamic web pages using ASP.NET Web Server Controls and
user controls.
❖ Developed a Search Engine for all the ITC products available in all the segments.
❖ Development of screens and report layouts.
❖ Perfumed Load Testing Using Visual studio 2012 for Search Engine website.
❖ Customer Demos for the various life cycle of product.
❖ Worked on configuration and web deployments into SIT, UAT and Production.
❖ Worked with third party tool Dev Express.
5) Product –SAFAL
Client: ITC ILTD
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server 2008, JavaScript, MVC, Visual Studio 2013,
ADO.NET, Web Forms, IIS 7, Windows 7, Dev Express 13.1 and TFS.
Role: Senior Developer
Team Size: 12
5
Agri -Business Division (ABD) - ILTD is the Leaf Tobacco arm of ITC Limited. A century old
refinement in systems and processes ensures that ILTD is synonymous to “The One Stop Shop for
Quality Indian Tobaccos” globally. Our forward and backward integration across the value chain has
made us the biggest in terms of range, quality and quantity procured, processed and exported.
• “SAFAL” is a solution expertise given to the business which will give an overall analysis of
Tobacco Cultivation.
• The main feature of this application is to bring a automated solution with better overflow,
monitoring and access control which overcomes the existing data collection & reporting through
excel.
• Analysis is made on Farmer - Business relationship and production of tobacco leaf for the
upcoming season.
• Based on the analysis, the system can give a solution to the business of how much production
yield can be made for the upcoming season.
6) Project –BankTrade
Client: National Commercial Bank (Saudi Arab)
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server, JavaScript, LINQ, XML.
Role: Senior Developer
Team Size: 8
BankTrade application enables the user to choose from the different modules such as Credits, Funds
Transfer, Loans, Guarantees, Reimbursements and Reports. BankTrade deals with the Customer
information which includes loans, Credits or Letter of Credit, Account details. All such details can be
viewed using report module.
7) PQRS-Product Quality Rating System
Client: ITC Limited
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server 2008, JavaScript.
Role: Senior Developer
Team Size: 5
PQRS(Product Quality Rating system) is a Web based transaction entry system for Quality control
function for ITC Confectionery category. This will create the data for the basis of QlikView reporting
& dash boarding which will focus on two key metrics for quality control Product Quality Rating
System (PQRS) & Product Quality Index (PQI).
8) ITC Konnect(Store Locator)
Client: ITC Limited
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server2005, JQuery, LINQ and WPF.
Role: Senior Developer
Team Size: 4
ITC Connect is a web application designed for ITC Connect Admin. The system is accessible by the
end user with the role Admin and User. The purpose of the system is for Admin to manipulate the
master data like adding and Updating User, customer and product details etc.
6
9) Customer Management Information
Client: Santander Bank UK.
Technical Environment: ASP.Net with C# (Version 4.0), SQL Server, XML, JavaScript & jQuery.
Role: Senior Developer
Team Size: 12
Customer centric organizations tend to see higher customer satisfaction levels, product holding
ratios and retention levels, all of which drive revenue. This is to take Customer Segments and
Portfolios for Relationship Management into the Retail bank. It makes Retail suite of Management
Information reports breakdown by Customer Segment, by Portfolio, and is entirely Account centric
as opposed to providing data aggregating the Customer’s holdings.
10) Tezy(Incident Tracking Tool)
Client: Santander Bank UK.
Technical Environment: ASP.Net with C# (version 3.0), ADO.NET, JavaScript and Oracle.
Role: Developer
Team Size: 4
An incident tracking tool (also trouble ticket system, support ticket or incident ticket system) is a
computer software package that manages and maintains lists of issues, as needed by the
organization. Incident tracking tool is used in customer support to create, update, and resolve
reported customer issues. It also often contains knowledge base information on containing
information on each customer, resolutions to common problems, and other such data.
Logica Pvt. Ltd(Now CGI), India May 2008 - Aug 2011
Responsibilities:
❖ Actively participated in Analysis and design phase.
❖ Enhancement and maintenance of the applications.
❖ Developed .ASP pages with Java Script as Client Side Scripting and VB Script as Server Side
Scripting.
❖ Used COM+ objects to deal with database to maintain the application written in ASP.
❖ Handled scalability and performance issues and provided support for deliverables.
❖ Written documentation for IAD and bug fixing.
❖ Developed Modules like Reconciliation, CRR reports, SOD, EOD.
❖ Developed Export to excel Windows service.
❖ Hands on experience working with JIRA.
❖ Created and maintained Messages using Web sphere MQ.
❖ Threat modeling for the modules like Anti CSS and SQL Injection code.
❖ Design and Develop CSS.
❖ Database table, Stored Procedure, Triggers and User defined function creation.
❖ Executed database performance tuning.
❖ Presentation of New modules to entire team.
7
11) RTGS Readiness
Client: All financial institutes regulated by RBI.
Technical Environment: ASP.Net with C# (version 2.0), Oracle, ADO.NET, ASP, JavaScript, Ajax, XML,VC++ and IBM
MQ Series, IIS.
Role: Developer
Team Size: 16
Logica’s Real Time Gross Settlement (RTGS) and National Electronic Fund Transfer (NEFT)
product enabled web based system, deals with Customer and Inter-Bank Payments. The system
comprises of three main modules namely Quaestor Payment Hub and Quaestor Liquidity Manager and
Quaestor Security Manager. The main features are listed below.
➢ QPH serves as a hub that has the capability to convert messages from any banks internal
format to any international format such as SFMS, SWIFT.
➢ QLM is a solution that provides the hands on for treasury department to control and manage
the payments that flows out of the banks.
➢ QSM serves as a security manager bundling both QPH and QLM. All users, roles and password
control could be done using this module.
Date:
Place: Mridul kumawat