Sql Server Software Development

Vandana Kumari

CONTACT INFORMATION

Address: *** ***** ****’s Ave, Apt# 10S,

Jersey City, New Jersey-07306, USA

Email: *********.***@*****.*** Mobile: +1-201-***-****

PROFILE SUMMARY

Around 14 years of experience in Full Stack Development, design, coding and testing of business/commercial applications using Angular,.Net, Akka.net, ASP.Net, WCF, Web API, ASP.Net MVC, Razor, C#, JavaScript, Ajax, JQuery, Angular JS, Bootstrap, SQL Server,,Visual Studio .Net,SQL Server.

●Master of Computer Application from UP Technical University, Lucknow (U.P.), India.

●Designed and developed multi-tier applications with exposure to all tiers(Back end, Middle tier, Front end)

●Experience to work on Real Time Market Data

●Excellent experience in Angular,.NetCore and SQL Server

●Good understanding of Equity, Fixed Income,Securities, Derivatives and Research Domain

●Strong professional .Net Development experience in various applications based on Object Oriented Programming (OOP), Client/Server, N-tier architecture, Web based and Internet Technologies. Experience in all phases of software development life cycle (SDLC) including Release Management.

●Good Understanding of object oriented concepts and various Design Patterns

●Strong in Agile/Scrum software development, Test Driven Development (TDD) and Issue tracking tools like Jira

●Hands on experience in DevOps and Continuous Integration tools like Jenkins, Ansible, Bitbucket, Git, Team Foundation Server.

●Implemented WCAG accessibility standards in .NET applications with hands-on experience using JAWS for screen reader testing. Strong experience in CMMI (Capability Maturity Model Integration )and Quality assurance processes

●Working Experience in Finance and Telecom domains.

●Work culture experience with all levels of organization. Capable to work well on individual assignment as well as within team environment.

●Ability to Design Projects, Monitor and delegate work to meet deadlines. Good in problem solving techniques with ability to meet customer expectations.

●Dedicated and hard working with good communication skills.

●Recognized multiple times by awards and client kudos.

EXPERIENCE SUMMARY

●Worked as a Full Stack Application Developer with Bank of America Client.

●Worked as Technical Architect – Full Stack Developer with Sopra Steria, India from June 2014 to October 2016

●Worked as Lead Consultant at Genpact – Headstrong Capital Market Noida from July 2010 to June 2014

●Worked as Software Engineer with HCL Technologies Ltd. Noida from Apr 2007 to June 2010

TECHNICAL SKILLS

Programming Languages

Typescript,Angular, C#, .NET,.Net Core

Databases

SQL Server 2005/2008/2012/2014/2016

Development Tools

Visual Studio Code,Visual Studio, PyCharm,

DevOps, Tracking, Versioning Tools

Jenkins, Git, Ansible, Bitbucket, Microsoft Team Foundation Server (TFS), IBM Synergy, Visual Source Safe 6.0

Web Technology

Angular,HTML, CSS, XML, Java Script, AJAX toolkit, jQuery, JSON, Angular JS, Bootstrap, XSL, XSLT, XML Schema, XSD

.NET Technologies

.NET Framework, Akka.Net,ASP.NET, ASP.NET MVC 5.0/4.0, Web Forms, Windows Forms, Web Services, Web API, WCF, ADO.NET, Entity Framework, Enterprise Library, Microsoft BizTalk server

PROFESSIONAL EXPRIENCE

Project: Legal Tech Services January 2024 - May 2025

Role: Angular/.Net Full Stack Developer

Legal Tech Service is a next-generation compliance and legal tech platform designed to simplify and streamline regulatory requirements. The mission is to empower businesses by offering an intuitive, integrated solution that addresses the full spectrum of compliance needs—from chartered accounting and company secretarial services to legal compliance management and litigation support. this application specializes in areas such as corporate, labor, legal and Compliance

By unifying accounting and legal services within a secure, AI-driven platform, LETEServices reduces regulatory burden and enhances operational efficiency across multiple sectors.

Designed and developed modular and reusable components using .Net Core and Angular

Built and consumed secure RESTful APIs

developed Enforced role-based and policy-based authorization using .NET Identity and JWT

Authored detailed technical documents, architecture diagrams, and API documentation for technical team

Project: Operational Excellence Aug 2019 - Aug2020, Dec 2020 – Mar2022 Client: Bank of America, NY

Role: Angular/.Net Full Stack Developer

This project aims to provide financial advisors at Bank of America with a robust and flexible platform for generating a wide variety of Consultant and Security Coverage forms. These forms are dynamically created based on the advisor's focus area—whether in Equity or Fixed Income coverage—and are tailored to specific consultants and investment strategies within the firm.

The platform is designed with a high degree of dynamicity and configurability, enabling users to create forms on the fly depending on the security types and the financial sector involved. The system intelligently adapts to different asset classes, allowing the creation of forms for instruments such as Equity instruments, including common and preferred stocks, stock options, and equity-linked derivatives, enabling advisors to document coverage for both long and short positions, valuation models, market outlooks and Fixed income instruments, such as corporate bonds, government securities, municipal bonds, and structured products.

Responsibilities:

●Involved in design, coding, development and deployment of application.

●Excellent experience in Angular, created dashboard dynamic tiles using angular latest libraries.

●Created Drag and drop feature to generate a dynamic form in Angular.

●Good experience to work on Stock Charts,Equity,fixedIncome coverage. Good understanding of Securities, derivatives and Research Domain

●Created an approval workflow with a tool based on biztalk and xml configurations.

●Using BizTalk Server for the business logic implementation and harmony tiles for the configuration

●Creating and configuring ports, Flat file processors, Flat file assemblers and disassembler for the flat file processing

●Using XML, XSD, XPath and XSLT for transforming XML in BizTalk application

●Involved in BizTalk application deployment and BizTalk server configurations

●Good experience in following best practice of coding.Worked on Oracle stored procedures

●Actively participation in scrum call and good knowledge of domain to understand business need for the efficient implementation

●Mentor daily activities guided, helped team in resolving the technical issues. Actively reviewing the technical estimates provided by the team

●Made team aware of the correct technical approach needs to be followed and helped them following the technical process.

Environment: Angular, .Net api, .Net, Market Data Libraries, BizTalk server. XSD, XML, XSLT

Project: Alpha Capture Trade Ideas Jul 2017 – Mar2019

Client: Bank of America, NY

Role: .Net/Angular Full Stack Developer

This project involves developing a global platform for creating and distributing Sales Trade Ideas across Equity, Fixed Income, and Derivatives. The application enables real-time idea generation, targeted client dissemination, and performance tracking using live market data. It integrates with research reports, market data feeds, and analytics tools to evaluate idea effectiveness.

The project also supports the development and maintenance of key tools within the Research Authoring, Workflow, and Collaboration space—critical for content creation, distribution, and compliance in the Global Research business.

Responsibilities:

●Involved in coding, development and deployment of application.

●Experience to work on Real Time Market Data

●Excellent experience in Angular 2,4 and 6.

●Used akka.net for the asynchronous actors processing

●Good experience to work on Stock Charts,

●Good understanding of Equity, Securities, Sales and Research Domain

●Using web api for the creation and distribution of Ideas.

●Using BizTalk Server for the business logic implementation and harmony tiles for the configuration

●Consuming WCF services in BizTalk application,

●Creating and configuring ports, Flat file processors, Flat file assemblers and disassembler for the flat file processing

●Using XML, XSD, XPath and XSLT for transforming XML in BizTalk application

●Involved in BizTalk application deployment and BizTalk server configurations

●Good experience in following best practice of coding.

●Actively participation in scrum call and good knowledge of domain to understand business need for the efficient implementation

Environment: Angular 6, akka.net,WCF, .Net, Market Data Libraries, BizTalk server, XSD, XML, XSLT, WCF service, Angular

Project: OCEAN - Sopra Steria, Noida Mar 2015 – Oct 2016

Client: Orange, France

Role: Technical Architect- Full Stack Developer

Ocean application is used for handling the service request for Orange customers and client. This application covers the full lifecycle of the ticket and operation created for providing and assisting the different categories of customers, it is a huge application which covers the different modules like Ticket and Operations management, resource, products, alarm and Intervention. It has integration to the different legacy application of orange like swan, Tethys and ocean legacy.

Responsibilities:

●Involved in coding, development and deployment of application. Actively participated in requirement gathering from client, Sprint Planning, Poker Planning and, agile retrospective

●Implementation of Continuous Integration. Used Agile methodology and SCRUM framework to study the system, consolidate the requirement, Establish inter process relation, for team communication and to produce high quality software

●Implemented WCAG accessibility standards in .NET applications with hands-on experience using JAWS for screen reader testing

●Implemented and consumed WCF services. Used XML, XSD, XPath and XSLT for transforming XML documents

●Developed and enhanced Component Library that can be used throughout different modules of application, using MVC and HTML5, CSS3, BOOTSTRAP. Designed the Views, Layout pages, and Partial views using to involve the features like Accessibility, responsiveness, performance. Followed all the recommendation of W3

●Developed common utility, critical models and framework for application using MVC 5.0, Jquery, HTML5, ASP.NET Framework, JQuery, AJAX, CSS3 and BOOTSTRAP.

●Designed web application using Web API with Angular JS and Used Entity Framework and Repository pattern to model and manage data from SQL Server

●Good experience in implementing SiteMapPath, Attribute Routing, Filters,Data annotation, Bundling and minification,new features of MVC 5 framework in the application

●Good experience in following best practices using tools like Resharper, StyleCop and FxCop.

●Performed unit tests using MS FAKES. Used TFS as a version control and JIRA for implementing agile process.

●Responsible for doing code reviews and maintaining the quality of the deliverables .Helped team in following best practices and optimization technique

●Mentoring the junior resources and providing maximum knowledge transfer to increase team productivity. Handled the team during project development and provided the technical assistance to team for solving any technical problems.

Environment: C#, MVC 5.0, Bootstrap, Enterprise Library, Entity framework, JQuery, HTML, CSS, AJAX, Design Patterns, XML, XSLT, LINQ SQL Server 2008, TFS, IIS 7.0, WCF service

Project: Notional TIPS Administrative Capita - Sopra Steria, Noida July 2014 – Feb 2015

Client: CAPITA, UK.

Role: Technical Architect-Full Stack Developer

Notional TIPs policies are part of Embassy platform which is planned to be administered separately. The Notional TIPs module is built to administer investments made by the associated policies and it is hosted in the Capita network. This application is responsible for Unit movements which involve, investment, partial disinvestment, full disinvestment, fund switch in and out, Unit and fund correction, Policy Enquiries, to maintain audit information of the user logged in to the system.

Responsibilities:

●Implemented Agile software development methodology and Test driven development

●Designed the Views, Layout pages, and Partial views using ASP.NET MVC, JQuery, AJAX, HTML5, CSS3 and BOOTSTRAP

●Used ASP.NET MVC with Razor View Engine, Entity framework for ORM mapping and Enterprise Library for the exception handling and logging.

●Developed and consumed WCF Web Service to access data layer components.

●Used Attribute Routing, Filters,Data annotation, SiteMapPath Bundling and minification features of MVC framework in the application

●Extensively used/modified jQuery to perform AJAX calls for creating interactive web pages on JSON response

●Involved in client meetings. Participated in all agile ceremonies like daily stand up, Poker Planning, agile retrospective

●Designed the User Interface framework, template layout using master page, HTML5, CSS3, Bootstrap, JQuery and Angular JS.

●Created Stored Procedures, Functions, Triggers, Views using T-SQL in SQL Server 20012 to insert, update, and delete data inside tables

●Developed common utility, critical models and framework for application

●Assisted build team in implementing architecture

●Provided technical training to onshore and offshore build team members

●Contributed in Code Review to improve the coding standards and maintaining the quality of the deliverables

●Used Resharper, StyleCop and FxCop tools for optimizing the code and adhering best practices.

●Performed unit tests using MS FAKES. Used TFS as a version control

●Handled the team during project development and provided the technical assistance to team for solving any technical problems. Guided team to follow best practices and optimization technique

Environment: C#, MVC 5.0, Bootstrap, Enterprise Library, Entity framework, JQuery, HTML, CSS, AJAX, Design Patterns, XML, XSLT, XSD, XPath,LINQ SQL Server 2008, TFS, IIS 7.0, WCF

Project: MSSB JV Project Portfolio Management Headstrong, Noida Jul 2010 – June 2014

Client: Morgan Stanley Smith Barney, US.

Role: Senior .NET Developer

MSSB JV PPM (Project Portfolio Management) Application is used by Morgan Stanley for Project and portfolio management involved in the joint venture of Morgan Stanley and Smith Barney. This project includes web and windows applications modules to manage Morgan Stanley JV SharePoint site. There is different Report generation engine which generates Reports in different forms like Microsoft project format, PPT and excel and upload them on SP site. Different Sync applications were involved to transfer and update data from various SharePoint site.

Responsibilities:

●Involved in requirement gathering, coding, development and deployment of application.

●Implemented business logic in C#.NET. Used ADO. Net for retrieving the data from the database.

●Involved in developing and consuming WCF services. Extensively used XML, XSD, XSLT to manipulate data fetched from the SP site and generated reports extracting information from XML data.

●Created data access layer to communicate with the SQL Server Database with ADO.Net objects

●Have extensively used Datasets and Data tables to retrieve and manipulate data and display it in an ASP.NET pages by using Infragistics controls

●Created, Stored Procedures, Functions, Triggers, Views using T-SQL in SQL Server 2008 to insert, update, and delete data inside tables

●Retrieve data from mainframe feed file and upload them on to MS SharePoint site.

●Create and maintain SharePoint lists and Workflow

●Data synchronization using SharePoint services for various client application.

●Developed Sync application for data sync between MS different SharePoint

●Assisted team in writing Unit Test cases for different modules

●Developed code for report generation engine like MPP and html

●Developed reports using infragistics components and tool

●Optimized and automated various SharePoint site update processes and for that developed batch/window services

●Helped team in following best practices and optimization technique

●Handled the team during project development and provided the technical assistance to team for solving any technical problems.

●Involved in CMMI level activities and successfully conducted CAM and CM audits

●Responsible for doing code reviews and maintaining the quality of the deliverables

Environment: ASP.Net 3.5, C# 3.5, MVC 2.0, Enterprise Library, SharePoint list and services, Web Services, JQuery, HTML, CSS, AJAX, Design Patterns, XML, XSLT, LINQ SQL Server 2005, IBM Synergy, IIS 6.0

Project: Online Mediclaim, HCL Technologies, Noida Feb 2010 – Jun 2010

Client: Genins India.

Role: Senior .NET Developer

The application automates the manual process of medical claims, streamlines the payout process and provides visibility to all stakeholders. User claims their medical bills online and system exports these claims in specified output format that further imported in the software of TPA.

Responsibilities:

●Involved in gathering and analyzing the business requirements and developing system requirement specification documents

●Involved in designing of database

●Documented HLD and LLD of system

●Used ADO.NET and its components DataReader, DataSet, DataAdapter and displayed data in Datagrid

●UI design and development using ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript.

●Extensively used T-SQL in constructing user defined functions, views, indexes, constraints, and relational database models and stored procedures

●Assisted other developers

●Coding of various modules of the system

●Testing and bug fixing

●Involved in CMMI level activities

Environment: ASP.Net 2.0, C# 2.0, HTML, CSS, JQuery, JavaScript, SQL Server 2005, XML, Visual Source Safe 6.0, XSD, Web service

Project: Smart Card Attendance and Leave Management System, HCL Technologies, Noida

Duration: Jun 2009 – Jan 2010

Role: Senior .NET Developer

SCA and LMS is the system of capturing attendance through smart card. The system is integrated with online roster (used for capturing shift timings of the users) and leave management system. It is integrated with SAP, hence attendance and leave information is directly used to process payroll.

Responsibilities:

●Involved in requirements gathering

●Participated in requirement analysis study

●Developed Window Services to transfer logs from smart card readers and update leave data

●Developed complex logic of manipulating logs with roster data

●Developed User Controls and extensively used HTML and Web Server Controls

●Handled maintenance, enhancement and development activities

●Completed database design process with documentation

●Developed business and data access layer,UI design and development using ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript

●Integrated with SAP module through Web Services

●Developed various reports to show attendance and leave data

●Developed module to apply, approve and reject leaves

●Developed Window Service to send email notifications to users in case of insufficient working hours

●Enabled functionality to read from excel sheet

●Created user defined functions, views, indexes, constraints, and relational database models and stored procedures

●Involved in maintenance and archiving of database

●Participated in various client meetings with the team to discuss improvements/amendments in the development of the application

●Involved in CMMI level activities

Environment: ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript, SQL Server 2005, XML, Visual Source Safe 6.0, Web Services

Project: KVB-CRM, HCL Technologies, Noida Nov 2008 – May 2009

Client: Karur Vysya Bank, India

Role: .NET Developer

The application is developed for Karur Vysya Bank, a large domestic bank that is outsourcing its ATM and Customer Helpdesk Operations. It is a real-time application, which captures details of all calls received, their follow-up and escalations. The system also generates customized reports for users.

Responsibilities:

●Involved in requirement analysis and building prototype

●Database design and development

●Developed User Controls and extensively used HTML and Web Server Controls

●Used ADO.NET and its components DataReader, DataSet, DataAdapter and displayed data in Datagrid

●Handled maintenance, enhancement and development activities

●UI design and development using ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript

●Coding of various modules of the system

●Testing and bug fixing.

●Provided support to users

Environment: ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript, SQL Server 2005, XML, Visual Source Safe 6.0

Project: Project Passion (SAP-PRU Integration), HCL Technologies, Noida Apr 2008 – Oct 2008

Client: HCL Technologies-BPO Services

Role: .NET Developer

This project is primary based on data exchange between HCL and SAP for automation of payroll processing. PRU is employee data base of HCL -BPO. Data exchange includes all details of employees starting from Hiring, attendance, cab details, bank details, leave details through web services.

Responsibilities:

●Involved in requirement analysis and building prototype

●Database design and development

●Developed User Controls and extensively used HTML and Web Server Controls

●Handled maintenance, enhancement and development activities

●Integrated with SAP module through Web Services

●Provided support to users

●UI design and development using ASP.Net 2.0, C# 2.0, HTML, CSS, JavaScript Coding of various modules of the system

●Testing and bug fixing

Project: Distance Learning Program, HCL Technologies, Noida Sep 2007 – Mar 2008

Client: HCL Technologies-BPO Services

Role: .NET Developer

This project was primarily for those Employees who enroll themselves for some distance learning program. This project includes Enrolment form, Pending Request Form, Pending Payment form and different Report that helps in reimbursement for the fees amount.

Responsibilities:

●Involved in requirement analysis and building prototype,Database design and development

UI design and development.Coding of various modules of the system, Testing and bug fixing

Project: Online Examination, HCL Technologies, Noida Apr 2007 – Aug 2007

Client: HCL Technologies-BPO Services

This project provides standard features of online examination system. Users can login into the system through corporate intranet site. Examiners can schedule exams for examinees. Features like question bulk upload through excel file, different types of questions, pause and resume exam etc. have been added and examiner can configure them.

Responsibilities:

●Involved in requirement analysis and building prototype Database design and development

UI design and development.Coding of various modules of the system, Testing and bug fixing

EDUCATION

Master of Computer Application, 2006

Invertis Institute of Management Studies, Bareilly affiliated to Uttar Pradesh Technical University, Lucknow (U.P.), India

Bachelor of Science, 2003

Bareilly College, Bareilly, affiliated to M.J.P. Rohilkhand University, Bareilly(U.P.), India

Contact this candidate