
Ritesh Kumar Kesharwani
- C#.NET Architect
- Woodbury, MN
- Member Since Jun 17, 2023
Ritesh Kumar Kesharwani
§ Microsoft Certified MCSD, MCAD, and MCPD
§ Infosys Certified Technology & .NET Architect
§ Agile B2 Training Completed
Project: Bond Application, Travelers, St. Paul, MN, USA Oct 2014 to Present
Client: Travelers Insurance
Description: Bond application is handling multiple LOBs for Travelers like: Policy creation, Document Generation, Rating Calculations, User Maintenance, Authority rules and roles maintenance etc. As an architect I am responsible for application architecture, technology enhancement, remediation and major refactoring to make sure application are aligned with latest technology and speed up for future maintenance and development. Assessment activity majorly targeted for Root cause analysis, Performance bottle neck, Maintainability, Scalability, Technical debt, Reliability and Speed to market.
Role and Responsibilities: Technology Architect
ü Responsible to do complete end to end assessment of existing system.
ü Solution recommendation based on current business demand and latest technology trend
ü Gather requirement from business, analysis and prepare technical document and Proof of Concepts
ü Application development using C#.NET, WCF, WWF, MVC, Unity 4.0 and .NET Framework 4.5
ü Develop database objects using PL/SQL with SQL Server 2014
ü Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.
ü Working in application functional Development, Enhancement and Bug fixes, and updated in SVN.
ü Participated in code, design reviews and use Tools (Re-Sharper) for code quality improvements
ü Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project
ü Responsible to deliver complete integrated product to client.
Project: FRAME Nov, 2013 to Sep 2014
(Forecast Refinement Application for Maintenance Execution)
Client: Alstom, Paris
Description: FRAME tool is developed as web application to do train maintenance execution forecasting for multiple projects running in multiple locations. This tool can be handled all kinds of maintenance activity like Preventive Maintenance, Corrective Maintenance and others. This tool helps user to calculate ETC (Estimation to Complete) for train, One project can have multiple trains and can be executed in multiple locations, FRAME application uses centralized database so that this application can be used globally by multiple users. Past year’s data used to import from different interfaces using SSIS package and in FRAME application forecasting can be done from current year onwards up to project completion date. Normally one project life cycle timing is up to 40 years. This application is capable to maintain and execute complete train life cycle data.
Role and Responsibilities: Technology Architect
ü Responsible to prepare Application Architecture and Database design as per business requirement
ü Requirements elicitation and translation to technical specifications
ü Application development using C#.NET, ASP.NET, LINQ, Angular JS,AJAX,HTML, Open XML SDK, PL/SQL SQL Server 2008 and Java Script for client side validation.
ü Working in application functional Development, Enhancement and Bug fixes, and updated in Team Foundation Server (TFS).
ü Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.
ü Develop automated unit test framework using Rhino Mocks.
ü Define RDBMS models and schemas. Work in performance tuning of database schema
ü Participated in code and design reviews and also used tool (Re-Sharper,TFVC) for code quality improvements
ü Responsible to deliver complete end to end integrated product to client.
Projects 3
Project: Frictionless Campaign Management (FCM), Balboa Aug, 2012 to Oct 2013
Client: Microsoft Corporation (Ads Display Group), Redmond, USA
Duration: From Aug, 2012 to Oct 2013
Description: Balboa is a multi-release initiative to completely redesign Microsoft display sales tools, processes, and roles from order to cash. He is working as Technical Architect at onsite and offshore and his core responsibility to analyze technical requirements for new features, execute and deliver all high quality features on time. He is involved for application architecture design, database design, and requirement analysis and responsible to deliver high quality product on time. He also involved to develop WCF services, troubling shoot production issues, design and manage database schemas.
Role and Responsibilities: Technology Architect
ü Gather requirement from business, analysis and prepare technical document and Proof of Concepts.
ü Architecture Design and Development
ü Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products
ü Application development using.NET MVC (Model View Controller) pattern, C#.NET, AJAX, Angular JS, CSS3.0, JQuery, LINQ, Entity Framework, VSTS 2012, .NET Framework 4.0, WCF Service, WWF, Windows Azure SDK 1.8, PL/SQL, SQL Server 2012, NUGET Package, and Team Foundation Server.
ü Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
ü Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.
ü Application automation using Rhino Mocks and code review using Re-sharper
Project Title: SDPvNext (Service Delivery Plan) Jan, 2011 to Jul 2012
Client: Microsoft Corporation (RXD Group), Redmond, USA
Description: This project help user to create value triangle which will describe issue/risk, improvement point, goals and value. Top manager can create multiple SDPs and look into each value and improvement points. Review, Notification, Issues/risk import, Gantt chart view features also implemented in this project. This project developed using Silverlight 5.0, .NET Framework 4.0, C#, WCF, SQL server 2008, LINQ, and Entity Framework. This project also uses Open XML SDK 2.0 to generate report in MSWord 2010 format; report can be generated for multiple languages.
Role and Responsibilities: Technology Architect
ü Responsible to ramp up in Silverlight 5.0 and implements the modules as per business requirement
ü Gather requirement from business, analysis and prepare technical document and Proof of Concepts
ü Application Development using Silverlight 5.0, .NET Framework 4.0, C#, WCF, PL/SQL, SQL server 2008, LINQ, and Entity Framework, Open XML SDK 2.0.
ü Develop and deploy application into Window Azure.
ü Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk.
ü Perform performance optimizations on .NET frameworks
ü Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support.
ü Define RDBMS models and schemas. Work in performance tuning of database schema, migrations and slowly changing dimensional databases
ü Responsible to get work done from offshore team and guide/unblock them for any issues
ü Develop and implement class diagram, sequence diagram.
ü Review code and unit test plan.
Project: Annual Process Integration (API) Jul, 2008 to Dec 2010
Client: Microsoft Corporation (HRIT Group), Redmond, USA
Description: API takes care of maintain employee annual performance appraisal. Manager can see their direct repots (employee who is reporting to their manager) performance data, whole year work items and training done by the employees. HR (Human Resource) person can also see all the employees’ data. This project helps HR, Manager and Employee to see all their organization related data into one place. Previously they have to go to multiple application to their complete data, like for training data, performance history, direct reports etc. have different applications. Here Employee can submit their work items done and give the feedback for the work and their manager, then manager can see employees data, approve or reject the comments and again give the feedback and finally sent it to HR. now based on the data he received he will do the employee appraisal.
Role and Responsibilities: Technical Architect/Lead
ü Perform performance optimizations on .NET frameworks
ü Prepare estimations, release plan and road map for future releases
ü Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support.
ü Responsible to implement architecture as given
ü Database design for given modules
ü Develop and implement class diagram, sequence diagram
ü Coding for critical modules using ASP.NET, C#.NET using MVC pattern, AJAX, JQuery, Telerik, Silverlight, WCF 4.0 and PL/SQL using SQL Server 2008.
ü Create High Level Document and Details Design Document
Project: Customer Service Center (CSC) Mar, 2007 to Jun 2008
Client: Boeing, USA
Description: This portal was developed for Boeing business users to search, view and download different Boeing product families. This project developed in web application using ASP.NET 2.0 with four Layer approach. In this project I used Xceed component for split the file and merge using win zip utility at client end. If documents size is greater than 10MB then user can split then document into his desire size and download one by one and use win zip version 9 or higher to merge downloaded file at their end. Only PDF file can be viewed and all other format documents can be downloadable.
Role and Responsibilities: Technical Lead
ü Responsible to implement architecture for the application
ü Responsible to create proof of concepts (POCs) for the application
ü Develop and implement class diagram, sequence diagram
ü Help team technically
ü Coding using ASP.NET, C#.NET, Web Services, PL/SQL, SQL Server 2008 and Crystal Report
ü Create Detailed Level Document
ü Code Review and unit test
Project: Project Management Dec, 2006 to Mar 2007
Client: Worley Persons, Austria
Description: This application is developed to maintain Worley Persons project management like estimation, forecasting export and import data and maintain their sale data. This was window application developed using DOTNET Remoting with five Layer approach. So that later if client want to call this application through web service so he can migrate this application without changing UI, Business and Data Access Layer, This approach will also help to segregate this application in the distributed environment like in the window application our UI can be in one server and Business and Data Access Layer can be in the different layer.
Role and Responsibilities: Technical Specialist
ü Responsible to implement architecture for the application
ü Responsible to create proof of concepts (POCs) for the application
ü Develop and implement class diagram, sequence diagram
ü Application Development using VB.NET, PL/SQL using Oracle and Crystal Reports.
ü Create Detailed Level Document
ü Code Review and test code
ü Responsible to coordinate with offshore team and get work done
Project: Lead Management System Apr, 2006 to Nov 2006
Client: Urban Science, Detroit, USA
Description: Urban Science is a software solution development company in Detroit, US to provide software solution to Automotive Industry. Lead Management System works for all the car dealers equally and fulfill their requirement. Customer can put a request to purchase a car online and based on the customer data lead will go to dealer then dealer will response to that customer for his request this is whole process called Lead management system. We have use latest dot net technology called Workflow Foundation (WWF) July CTP that does lots of activities like validate the lead, validate customer data, validate customer email address, clean the lead, check duplicate lead if any, score the lead based on the customer data and finally sent back response to dealer saying the lead status like: lead is valid or duplicate etc.
Role and Responsibilities: Technical Specialist
ü Responsible to implement architecture for the application
ü Develop and implement class diagram, sequence diagram
ü Help team technically
ü Coding using ASP.NET 2.0, C#.Net, Window Workflow Foundation (WWF), MSMQ, XML, HTML, PL/SQL using Oracle and TFS
ü Create Detailed Level Document
ü Review and test code
ü Responsible to coordinate with offshore team and get work done
Project: Customer Appreciation Program (CAP) spec Sep, 2005 to Mar 2006
Client: Tennessee Pacific Group, USA
Description: Tennessee Pacific group has a music site name passalone.com and songtouch.com they are doing good business with site in all over the world major in Europe. Using this site Tennpac group are selling songs album and songs. CAP is a module in this site, they are introducing new promotion scheme for their regular customers. Only Admin he can create, modify and delete the program as per scheme can do CAP creation. In each program admin will create a no of levels, which will decide the threshold values and awards points for a customer. Based on each purchase user will be awarded with some rewards points, this rewards points can be used to purchase new song too. If admin change the program in between then all the user points will be recalculate based on new threshold value and awards points.
Role and Responsibilities: Sr. Development Engineer
ü Requirement gathering and analysis
ü Prepare High Level and Low Level documents
ü Developing Forms, Procedure, business logic, data access component
ü Coding in ASP.NET or C #. NET and responsible for developing Test Plans
ü Unit Testing, Integration Testing and Prepare unit test cases,
ü Documentation, design and configuration,
ü Creation Low level design documents which includes class and sequence diagram using Rational Rose
ü Code review and application performance tuning
Project: Omnicell Pharmacy Solution Apr, 2005 to Aug 2005
Client: Omnicell Pharmacy, Houston, TX, USA
Description: Omnicell Pharmacy is leading Product company in USA, It supply machines to the hospitals for maintain their inventory system. Canister and Carousel is a drug storage machine, their drug can be arranged in proper manner. To arrange drugs for hospital and distribute these drugs to patients all work done by Omnicell Pharmacy Solution. This software directly connects to the machine called Carousel and Canister. Basically machine creates separate drug of package for patient according to their dose. It helps to the customer for faster drugs supply to the patient. The patient detail information, hospital and all kind of drug information store and maintain by this software.
Role and Responsibilities: Sr. Development Engineer
ü Onsite and Offshore Coordinator
ü Requirement gathering and analysis
ü Prepare High Level and Low Level documents
ü Developing Forms, Procedure, business logic, data access component
ü Coding in ASP.NET or C #. NET and responsible for developing Test Plans
ü Unit Testing, Integration Testing and Prepare unit test cases,
ü Documentation, design and configuration,
ü Creation Low level design documents which includes class and sequence diagram using Rational Rose
ü Code review and application performance tuning
Project: Omnistation Sep, 2004 to Mar 2005
Client: Omnicell Pharmacy, Houston, TX, USA
Description: Omnistation Tool actually it is a data upload tool. When Onmicell pharmacy solution installs in any hospital then hospital data is require running this application, that time this tool load all the related information from excel sheet to SQL server Database. This tool also do data validation, new database creation, attachment and detachment of database. All database queries are written in the form of XML to make this tool generic.
Role and Responsibilities: Development Engineer
ü Requirement gathering and analysis
ü Prepare High Level and Low Level documents
ü Developing Forms, Procedure, business logic, data access component
ü Coding in ASP.NET or C #. NET and responsible for developing Test Plans
ü Unit Testing, Integration Testing and Prepare unit test cases,
ü Creation Low level design documents which includes class and sequence diagram using Rational Rose
Project: Bus Pass and Ticket Generation System Mar, 2004 to Aug 2004
Client: APSRTC Hyderabad, India
Description: The web application is to enable APSRTC to issue various types of Bus Passes across 22 online Centers to Different Commuters viz., Students, NGO, General and Physically Handicapped. The application aimed to 3 different types of users namely, Manager, Supervisor and Operators with Security and Maintainability. The Important modules in the application are I) Issue of Tickets II) Stock Indent and Allotment III) Reports. Operator will issue Tickets as well as Passes for the eligible commuters. The system verifies the eligibility and captures the Photograph and can immediately issues the same. Stocking Module takes care about the accountability, from stock arrival to allocation to different centers and hence operator, Reports which plays crucial roles for Decision Making and enhancement of the Services of APSRTC.
Role and Responsibilities: Consultant
ü Requirement gathering and analysis
ü Prepare High Level and Low Level documents
ü Developing Forms, Procedure, business logic, data access component
ü Coding in ASP.NET, C #/VB. NET and responsible for developing Test Plans
ü Unit Testing, Integration Testing and Prepare unit test cases,
ü Creation Low level design documents which includes class and sequence diagram using Rational Rose
Project: Sales and Funnels Management System (Pegasus) Aug, 2003 to Mar 2004
Client: Hewlett Packard (hp), Singapore
Description: Sales and Funnels Management System it has two modules one is offline that is developed in Visual Basic for company Sales Representatives they can store client information such as deal information etc. and second module is online module that is developed in .NET for company higher management like country Manager, regional Manager they can see the client information and can accept or reject the deal. Offline module can synchronize the data to online basically it is a data transfer from Access to SQL server. This system flow is: sales rep can cerates deal and send to the web after synchronization now manager can see, modify, approve or reject and give some comment on that deal now sales rep can see that deal status within a second by synchronization.
Role and Responsibilities: Consultant
ü Developing Forms, Procedure, business logic, data access component
ü Prepare High Level and Low Level documents
ü Coding in ASP.NET, VB. NET and responsible for developing Test Plans
ü Unit Testing, Integration Testing and Prepare unit test cases,
Project: Sourcing Vendor Master May 2003 to Aug 2003
Client: SaraLee Corporation, USA
Description: Sara Lee Corporation continues to accelerate the outsourcing of its branded products. Many divisions have successfully developed outside sources and they have created effective business relationships with them. SaraLee has plants for development of a diversified supplier network. By monitoring the quality on a monthly basis and analyzing trends, the sourcing team can identify problems before they are significant. Also by sending the performance measurements to the supplier, the supplier can work on its internal process to improve quality and achieve higher quality product for SaraLee overall. SQL Star International Ltd. Received a request from SaraLee branded apparel global sourcing for software development..
Role and Responsibilities: Consultant
ü Developing Forms, components such as DLL, ActiveX controls for data conversion,
ü <span