Candidates About

Ruchi Khanna

Professional Synopsis

I am a senior software engineer (full stack) with 10+ years of experience with web technologies as ASP.NET, C#, SQL Server, JavaScript, HTML, Rest API, JSON, MVC, RAZOR. Having experience working as user interface, middle-tier and database developer, I can work independently on all phases of product development & guide team as required.

As a senior developer, I have been involved in research, development, analysis, designing, coding and testing phases.

Educational Qualifications

Skill Set

Platforms:                           Windows,

Skills:                                                     ASP.NET, C#, Web services, REST API,HTML, XML ,Javascript, Razor, SQL, TFS,Razor

Domain Knowledge:       Banking (Core + Retail), Insurance, Loans,e-Commerce

Tools                                      Visual Studio, SSRS, TFS, Microsoft SQL Server Management Studio,  Toad, SQL  Server,  SQL Server Management Studio,  SQL Server Business Intelligence Development Studio,Jira,Maccurel,Bamboo,BitBucket,Postman

SDLC:                                      Scrum, Agile

Design Pattern:                Waterfall, Singleton, MVC

Services:                             IIS

Professional Experience

Projects Worked:

1. VI

Client: Visalus Sciences                                 Duration: 4 months                         Team Size: 20

Environment: ASP.NET,C#, Web Services, XML, JavaScript, Razor, MVC, REST API, HTML,JSON, SQL Server 2016, Windows XP/2000,Visual studio 2015, Bamboo, maccurel, BitBucket, Jira,Postman.

Description: Vi is an ecommerce site for customers as well as back office. It provides an interface to buy and sell health products and live experiences, subscriptions, promote products and earn points to get free upcoming subscriptions. The products here are the health drinks, snacks, energy drinks. They have news feeds to display the 90 day challenge winners. They use payment gateway for buying the subscriptions.

Activities included:  My responsibilities included creating the entire workflow for Backoffice customers as well as promoters. I have written several REST APIs and consumed them. I used attribute based routing for endpoint urls and POSTMAN to test the API calls.I am also comfortable with HTTPRequest and HTTPResponse objects and used JSON as the data format.

 I have also used third party tool Exigo Services and consumed its services for database customer management.I have implemented facebook share/like,twitter and email share functionalities to refer the experiences to promote customers. We follow scrum call and Agile for daily updates. My role is a Full stack .net Lead software developer including SQL as the database. I have been involved in all the phases of software development lifecycle including requirement gathering, documentation, development, testing and deployment. I also interact with the sales team to formulize new policies and schemes for the promoters to enroll to new programs. The project used MVC as the design methodology and RAZOR as the view. It was a multilingual project and we consumed Resource files for the language culture info for translation.

Being a senior developer I even perform the code review before we perform merging to the respective branches.

Projects Worked:

1. NEXXRIS

Client: NexxRIS Teleradiology Partners                  Duration: 4 years                             Team Size: 4

Environment: ASP.NET,C#, Web Services, XML, JavaScript, AngularJS, HTML, SSRS, SQL Server 2008/2014 and SQL Server Business Intelligence Studio, Windows XP/2000, VS.Net 2 / VB. Net (4.0), TFS

CMS: Sitecore 8.0

Description: NexxRIS is product which provides an interface for creating requisitions assigning it to tele radiologist for feedback and generating reports. It also provides facilities to Admin for auditing the reports, generating discrepancies and resolving them.

Activities included:  My responsibilities included creating the entire workflow for creating the discrepancies, assigning it to the radiologist for resolution, gathering response from the committee and finally closing the discrepancy. I also created the screen for displaying the discrepancy log status using the SSRS reports pie charts which displayed how many discrepancies were logged, how many are on hold and how many have been resolved over a period of time. This product is live and is being used by more than 500 clients. My work also included integrating with Sitecore CMS 7.0 and show contents (policies, training guides, facility documents) based on the practice and user’s CMS administrative rights. I have developed all these modules from scratch and used my skills of ASP.net with c# to write the code for the same. Additionally I have incorporated standard XML macro templates for report generation. Also, I have used AngularJS (ng-) directives to sort and display data. I have used AngularJS to create custom filters and utilized them in my application to filter data. In addition to that I used AngularJS services and have created controllers and models in it. This project was based on 3 layered architecture and my responsibilities included working on all the layers per module. I have participated on all the phases of the software development cycle including requirement gathering from the client, documentation, development, testing and delivery.

Projects Worked:

1. SWIFT

Client: BUPA Health and Wealth                               Duration: 2 year                               Team Size: 4

Environment: Windows XP/2000, VS.Net 2 / VB. Net (4.0), PLSQL, TFS, NUnit, SVN, MVC, Razor

Description: SWIFT is product which provides the brokers an interface to sell policies for health insurance, renew the policies, sell products, choose payment options as per customer requirements, including methods and frequency ,apply for claims, check for claim status, documentation of the claims approved or rejected etc.

Activities included: I worked as a senior developer in the project creating the user interface in ASP.NET C#, middle tier and writing stored procedures using functions for complex calculations. My responsibilities also included creating user defined functions and report generation using SSRS. I was responsible to develop controller classes and collaborate with the view team in terms of JSON format thrown back. I also contributed into functional and technical analysis, coding, NUnit creation, testing, code review, final code delivery and retrospective. This application was using MVC as the design pattern and used Razor as the FrontEnd Platform

1. DRS

Client: MetLife Inc                                                           Duration: 1 year                              Team Size: 5

Environment: ASP.NET, C#, SQL Server 2005

Description: DRS is the system developed to automate all the manual process of reconciliation of information of various vendors and holding location thus achieving time saving and avoiding errors due to human negligence while generating Month end sheets, Out of balance analysis, Count analysis, Market Value Analysis etc. The system has gone live on production and in all we could achieve 1465hrs per year.

Activities included: Involved with development of the tool from beginning gave me the opportunity to work on design and development of web pages in ASP.NET. Later on, debugged & fixed issues & wrote complex calculations using mathematical functions in SQL server. User SQL query analyzer and studied execution plans for better performance.

Total time saving achieved by this system was more than 1935hrs/year.The application went live successfully and I was even awarded with ‘Pat on the Back’ for the same.

1. iTracker

Client: MetLife Inc                              Duration: 1 year                                            Team Size: 10

Environment: ASP.NET, C#, SQL 2005/2008

Description: iTracker is designed to keep track of investments made by a representative, broker and client. It has complete workflow for branch manager to create portfolios with clients. It also provides the reports on investments made during a selected duration. It helps users to categorize there holdings into various asset types with the help of pie charts

Activities included: Worked as Module lead, and was responsible for developing reports with pie charts using SSRS. Apart from database development I worked on research task providing proof of concepts for various technical & critical issues. My tasks also include requirement gathering, analyzing the task, estimating, maintaining documents as Query tracking sheet, creating functional specification, technical specification including use case diagram, class diagram, and sequence diagram using UML modeling language.

Projects Worked:

1. TAXSMILE                                                                            Duration: 1.3 years                                      Team Size: 20

Environment: Visual Studio.NET 2008, AJAX Control Toolkit, IIS 6.0, Visual C#. NET, JavaScript, HTML and SQL as database, Visual Paradigm for Design phase.

Description: Tax smile portal enables tax paying customer to fulfill statutory obligation of filing income tax returns in seamless manner. Taxsmile’s online fulfillment model encompasses the entire functional requirement for computation of Income, Computation of Taxes payable, Interest payable and Filing return in an electronic manner.

Activities included: I worked as a senior developer in the project responsible for developing 'Life Changing events-Purchase of First House' , 'What if-Purchase of Second House' and R&D part of sending Reports through Email in PDF format and handling Alliances like Kingfisher, Reliance, Infosys etc. Also, I handled the design and development phases of finalizing RTT, Use Case Diagram, Use Case Document, Activity Diagram, Domain Model, Class Diagram and Sequence Diagram etc.

1. RETAIL & CORPORATE INTERNET BANKING                          Duration: 2.8 years                          Team Size: 10

Environment: Visual Studio. NET 2005, IIS 6.0, C#, JavaScript, HTML and Sql Server 2005 as database

Description: The System enables the corporate users to pay their bills online for e.g. Electricity bills, Telephone bills, Water bills etc. It also allows the users to make payment for School Fees, Internet Payments, and Mobile Top Ups etc.

Activities Included: I worked as a developer on both BackOffice and Corporate module of RIB and worked on all the five layers viz.: Business layer, Data Access Layer, Data Object layer, Front End and the Web Service. I developed the Mobile Top Ups, Karmah (Electricity Bill Payment), Q-Tel (Telephone Bill Payment) Modules.

I also worked as a SQL developer writing stored procedures and functions, used primary and foreign keys to define relationships between the tables and used query analyzer to test