Sql Server Engineer
Resume:
Sharad Kumar Singh
Senior .NET Developer
********************@*****.***
*** ******** ****** *** **, Glendale CA - 91205
PROFESSIONAL SUMMARY:
** ***** ** ** ********** with exceptional skills in all phases of software development life cycle (SDLC) and involved in Analysis, Design and Development of high scalable Multitier Web Applications, Distributed Applications and Web Services based on Microsoft .NET technologies.
Proficient in using Microsoft.NET Framework 4.0/3.5/2.0, C#, ASP.NET, IIS, ADO.NET, Web Services, XML, HTML, jQuery, Angular.js, Entity Framework and MVC3/4/5
Expert in creating Web Forms, Win Forms, User Controls, Customs Controls
Development experience using Visual Studio.Net, Visual Source Safe, Team Foundation Server
Experienced in Database Design and Development using MS SQL Server, MS Access & Oracle
Good working knowledge on web technologies like HTML, XHTML, DHTML, XML, XSLT and JavaScript
Expertise in OOAD (Object Oriented Analysis and Design) concepts using UML and also experienced with OOPS
Ability to function in a small team where team members typically have multiple responsibilities from development, debug to benchmarking
Self-motivated with strong interpersonal, written/oral communication skills and capable of working independently as well as in a team
TECHNICAL SKILLS:
Languages: .Net Framework 1.1/2.0/3.0/3.5/4.0/4.5, C#, ASP.Net, ADO.Net
Databases: Oracle 8i/9i/10g, SQL Server 2000/2005/2008
Reporting Tools: MS Access, MS Excel
Tools: Visual Source Safe, IIS, MS Team Foundation Server.
Methodologies: OOAD, OOPS, UML.
Microsoft technologies: Web services (Soap), WCF, MVC 3/4/5
Web Technologies: AJAX, XML, XSLT, HTML 5, Java script, jQuery, Angular.js, CSS
EDUCATION:
Master in Computers Applications (MCA), New Delhi, INDIA
Bachelor in Computer Applications (BCA), New Delhi, INDIA
Microsoft Certification in .net framework 4.0
PROFESSIONAL EXPERIENCE:
City National Bank (USA)
Sr. Software Engineer
Project: CRR (Client Risk Recommendation)
Role: Sr .Net Engineer
The aim of the Digital CRR (Client Risk Recommendation) project is to build a web-based system that will enable and support the end-to-end Client Risk Recommendation (CRR) operational process. It standardizes the process of collecting data for the Client Risk Recommendations as much as possible, across the different CNB divisions (Commercial Banking Services, Private Client Services, Entertainment, Real Estate Division, Special Assets Division etc.). It also optimizes end-user experience and process time by pre-filling available client profile and financial data on the form.
Responsibilities:
Development of different modules with the help of jQuery, Bootstrap, Keno UI, C#, HTML, and SQL Server 2008.
Worked on different modules of project like Guarantors, Fees, Interest rates, Credit Terms etc.
Design the Models for the Vies and Data Model.
Creation of new User interface and client side interactions using HTML, Bootstarp, Kendo UI, CSS, jQuery and JavaScript etc.
Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts
Involved in Maintenance/Enhancements of the application.
Involved in UI build release, defect and bug fixing.
Environment: C#, MVC, jQuery, Bootstrap, Ajax, LINQ, SQL Server 2012, Telerik Kendo UI, Team foundation server (TFS).
City National Bank (USA)
Sr. Software Engineer
Project: TMOS (Treasury Management On-Boarding System)
Role: Sr .Net Engineer
Treasury Management On-Boarding System (TMOS) is a banking web application which is used for setting up services for clients. A package is created with products and services for a customer and these are submitted to Adobe Life Cycle after client’s signature. Each of the products follows a separate work flow and is integrated with other systems. The application follows Windows Authentication and package can be created based on the authorization levels a user has.
Responsibilities:
Development of different modules with the help of jQuery, C#, HTML, and SQL Server 2008.
Worked on different modules of project like EASI LINK products, Maintenance Request etc.
Involved into design and development of complex queries, stored procedures for different modules like Guarantors etc.
Design the Models for the Vies and Data Model.
Creation of new User interface and client side interactions using HTML, Asp.Net controls, CSS, jQuery and JavaScript etc.
Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts
Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Involved in Maintenance/Enhancements of the application.
Involved in UI build release, defect and bug fixing.
Environment: C#, Asp.Net, jQuery, Ajax, LINQ, SQL Server 2012, Team foundation server (TFS).
Deloitte (USA)
Sr. Software Engineer
Project: WOTC
Role: Sr .Net Engineer
WOTC stands for the Work Opportunity Tax Credit and is a program that rewards companies with tax incentives for employing individuals who belong to groups that have had a hard time either finding or maintaining employment. The program benefits the government, the company and the applicant in different ways. WOTC (Work Opportunity Tax Credit) is a government program designed to stimulate employment by providing tax credits to employees who meet specific criteria. Deloitte Tax (“Deloitte”) is an independent third party who administers the WOTC program on behalf of your company. Deloitte coordinates the WOTC and the certification process for your company.
Responsibilities:
Development of different modules with the help of jQuery, C#, HTML, and SQL Server 2008.
Worked on different modules of project like Payroll Import, Location Import, Employee Retrieval and questionnaire etc.
Involved into design and development of complex queries, stored procedures for different modules like Payroll Import etc.
Creation of new User interface and client side interactions using HTML, CSS, jQuery and JavaScript etc.
Worked in development of window service to run the stored procedures in queue.
Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Involved in Maintenance/Enhancements of the application.
Designed and developed Stored Procedures, Views and Triggers.
Environment: C#, Asp.Net, jQuery, Ajax, LINQ, SQL Server 2008, Aspose.cells, Telerik Kendo Rad Grid, Team foundation server (TFS).
Assigncorp (USA)
Sr. Software Engineer
Project: Grapple (http://www.grapple.co/)
Role: Sr .Net Engineer
Grapple is a task management system that helps in streamlining work responsibilities and collaboration. It keeps track of the tasks with their status and helps avoid the email cluttering. It involves several components like portfolios, projects, tasks, comments, attachments, user accounts and user's role. Portfolio is the major component that keeps major functionality areas. Projects keep multiple tasks and project team. User can perform actions based on their role on a task. For example user can create, view, modify, delete tasks, assign or reassign tasks, follow, add attachments, set priorities, set reminders, download and print the tasks as PDF etc. Users can also update their profile, set email notifications preference, and manage their subscription.
Responsibilities:
Development of different modules with the help of jQuery, C#, HTML, MVC framework and SQL Server 2012.
Worked on different modules of project like Subscription, Projects, Tasks, Comments, User profile and User connections, auto reminders for tasks etc.
Involved into design and development of complex queries, stored procedures for different modules like Project stats, task summary, User profile and connection, auto reminders for tasks, email notification etc.
Creation of User interface and client side interactions using HTML, CSS, jQuery and JavaScript etc.
Worked in development of batch process to send auto reminders.
Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Involved in Maintenance/Enhancements of the application.
Designed and developed Stored Procedures, Views and Triggers.
Involved in UI build release, defect and bug fixing.
Environment: C#, Asp.Net, AngularJs, Ajax, MVC, LINQ, SQL Server 2012, WCF, Team foundation server (TFS), Telerik Kendo UI
Infogain Pvt. Ltd. (India)
Sr. Software Engineer
Project: RC-Desktop (Repair Center - Desktop)
Client: Mitchell International
Role: Sr .Net Engineer
This is a desktop application used by Body Shops in USA and Canada. This is an old application being converted into web application. This is a very vast application. Some of the modules are in web technologies used in win forms. Most of the features are licensed based according to different clients.
Responsibilities:
Exposure in interacting with clients to understand their specifications & customize solutions to meet the requirements
Created features in web technologies of Labor assignment, labor payment for new client Sterling.
Developed UI using Telerik Kendo UI, user controls, layouts and styles which inputs the data and display the data for the web applications using ASP.NET.
Involved in Design, Documentation, Coding in .NET Application using C#.NET. Involved in Writing, Modifying Stored Procedures in SQL Server database
Automation testing of newly created pages by developing automation code in Visual Studio 2010.
Participated in gathering the Test Data requirements and also involved in Test Automation Code Review process.
Reported new bugs, resolved and closed the existing ones with respect to the product testing.
Responsible for Stabilization (Code Freeze) before the Release.
Coordinating onsite and off-shore team members in daily sync up calls and updating status to the clients.
Used Agile scrum methodologies for development cycles in multiple sprints.
Environment: .NET 4.0/4.5, C#, MS Visual Studio 2010, MS SQL Server 2012, Web API, jQuery, MVC 4,
HTML5, Telerik Kendo UI
Assign Infotech Pvt. Ltd. (India)
Sr. Software Engineer
Project: PFC (Pharmacy Finance Collaborative)
Client: Kaiser Permanente
Role: Senior .NET Developer
This application works as a pluggable stand-alone application to provide graphical reports to its consumer applications which belong to medical domain of Kaiser Permanente and need to show Patient specific details in graphical format.
Responsibilities:
Involved in System Study, Requirement Gathering
Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts.
Involved in the Design of the Application using ASP.Net, Entity Framework,
Developed various forms using AJAX Extended Controllers and created XML documents for embedding data into the controllers.
Develop a calculation engine that calculates the mathematical formulas specific to the project requirement in C#.
Involved in the Design of the Application using ASP.Net, Entity Framework.
Coordinating onsite and off-shore team members in daily sync up calls and updating status to the clients.
Involved in Design, Documentation, Coding in .NET Application using C#.NET. Involved in Writing, Create Stored Procedures in Oracle database
Environment: ASP.NET 4.0, C#, MS Visual Studio 2008/2010, ADO.NET, Oracle 10g, LINQ, Web Services, SOAP, WCF, Entity Framework, JavaScript, Jquery, Scrum, MVC 4.
Project: Initiative Dashboard
Client: Kaiser Permanente
Role: ASP .NET Developer, Application Developer.
Initiative Dashboard is an Application for Reporting purpose. It basically shows the information about certain metrics (medicines) details. Metrics are categorized in to category (Initiatives). Similar types of medicines are grouped into one initiative then there.
Responsibilities:
Done code refactoring and rewrite the code of the some modules.
Change the export into excel functionally as it was not working for bulk data.
Fixes some of the major production issue and implement missing functionality.
Extensively used OOPS concepts in developing code in C#.
Implemented export functionality for all the list views which have capability of exporting the records into excel
Sessions and View state objects were used to store the state of the user.
Involved in Database Design of the application, creating Complex Queries, tables and indexes and wrote stored procedures, using Oracle 10g.
Created tables, views, stored procedures and functions to manipulate data.
Expertise and experience in performing different kinds of testing like Smoke, Black Box, White Box, GUI, Stress and User Acceptance (UAT) of Web and Client/Server Applications.
Implemented Agile Scrum methodology for the business modeling.
Involved in the production support
Environment: Visual studio 2010, .Net Framework 3.0/3.5, C# .Net, OOPS, ASP.Net, ADO .Net, CSS,
Java Script, JQuery, HTML, TFS, Oracle 10g, AJAX, IIS 7.0, WCF.
Project: POE (Proactive Office Encounter) Reports
Client: Kaiser Permanente
Role: Senior .NET Programmer.
Proactive Office Encounters (POE) is a region-wide in-reach system that engages staff & physicians to proactively address both preventive & chronic care needs at each patient encounter in primary or specialty care. POE relies on standardized workflows to provide timely & accurate member specific info to the health care team. Clinical strategic goals are monitored with this tool. This program leverages the skills of back office support staff by identifying care gaps for each member before, during & after an encounter, and provides checklists for use with both adults & pediatric patients.
Responsibilities:
Create a new User interface using HTML, CSS and jQuery
Rewrite the code to improve the performance application
Involved in System Study, Requirement Gathering
Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts.
Involved in Design, Documentation, Coding in .NET Application using C#.NET. Involved in Writing, Modifying Stored Procedures in Oracle database
Environment: Visual Studio.NET 2010, ASP.Net, C#, jQuery, ADO.Net, Oracle 10g, XML.
Project: RAS (Resource Allocation System)
Client: Kaiser Permanente
Role: Senior .NET Developer
The objective of the project is to automate the Resource Allocation process to projects and agreements among projects. In this application user can fill the timesheet based on allocated Projects and their tasks. Tasks are assigned to a resource based on allocated projects. This project is totally based on projects, project’s task. Project assignment, task assignment, de-allocation of projects and tasks and fill the timesheet on the basis of assigned tasks.
Responsibilities:
Involved in SDLC documentation, Development and Unit Testing of the application.
Developed the Application using C#.Net and Oracle as the Backend.
Involved in writing queries, stored procedures and functions using Oracle SQL Developer.
ASP.Net is used for the front end User Interface, ADO.Net for the database connections.
Developed Test Cases and implemented unit testing of various modules and also managed code in VSS.
Developed sequence diagrams and class diagrams using UML methodology.
Interacted with clients in Maintenance phase of the project, Involved in Documenting the Enhancements.
Development using C#.NET to incorporate business.
Involved in analyzing and designing various modules along with modified existing requirements to represent the design of the system using UML.
Implemented securities like Authentication and Authorization using Form-based & Window-based authentication.
Involved in analysis of functional requirements and designing of system.
Involved in development of Test Cases for Unit Testing.
Environment: .NET Framework 3.5, C#, ASP.NET, ADO.NET, Oracle 10g, SQL Developer, jQuery.
Project: Adhoc Data Request and Analysis (ADRA)
Client: Kaiser Permanente
Role: .NET Developer
ADRA provides a mechanism for the department members to place a request for a desired report. To be able to place a request, the requester must register himself/herself with the application. On receiving a request; the designated admin user will assign a request to an Analyst.
Responsibilities:
Involved in complete design and development of the application
Developed web pages and code behind files using C#
Worked on various OOPS concepts like Inheritance, Polymorphism, and Encapsulation
Design and development of class libraries in business tier in C#
Implemented transactions using ADO.NET objects
Developed Stored Procedures, Functions, Views, in Sql Server
Developed sequence diagrams and class diagrams using UML methodology
Involved in developing the Front end GUI with ASP.NET
Developed a Module that enables the administrator to provide access rights to users based on their credentials.
Involved in web service integration with other systems.
Involved in database activities like designing tables, writing stored procedures, functions, queries in the application.
Communicated with many groups in order to integrate the new enhancement into the regular flow.
Participated in design reviews, test case reviews, code reviews and testing.
Environment: C#.Net, ASP.NET, Microsoft Visual Studio, SQL Server 2005, HTML, CSS, JavaScript,
XML, TFS
Project: AIIntranet
Client: Assign Infotech Pvt. Ltd.
Role: .NET Developer.
The objective of the project is to automate the Organization process like create work packets,
Manage Leaves, Action Items, Employee Management, Client Management and Project Management.
This project has timesheet, billing process and HR management system also.
Responsibilities:
Preparation of architectural designs for each of the components that were assigned for development.
Responsible for designing, developing and testing the Due Date Module using ASP.NET, HTML,
CSS, JavaScript and SQL Server 2005 as database.
Product Report tool was designed and developed using ASP.NET, XHTML, HTML, JavaScript and SQL Server 2005 as database.
Created type libraries from the existing C# dll's and these dll's are consumed in the Middle Tier Architecture.
Gave extensive production support.
Environment: C#.Net, ASP.NET, Microsoft Visual Studio, SQL Server 2005, HTML, CSS, JavaScript,XML, TFS.
Contact this candidate