Sql Server .Net
Resume:
Bharat
*************.*+**@*****.***
TOOLS/METHODS
C#, C, C++,
Visual Basic, SQL,
.NET, C#.NET,
ASP.NET 2.0/3.0/3.5/4.0/4.5,
ADO.NET, WCF,
WPF, MVC,
CSS, Oracle 12,
AJAX,
PL/SQL, HTML5,
CSS3, XML, SSIS, SSRS, T-SQL,
JavaScript, Typescript, WIN Forms, LINQ
XML, HTML, XHTML,
MS-SQL Server 2005/2008/2012,
MS Access
Visual Studio 2005/2008/2010/2012, Microsoft Dynamic CRM
Win7/Vista/XP/NT/Server 2000/2003/2008
CLIENTS
Wellcare
Kindred Healthcare
United Health Group
Equinix Inc.
L Brands
Nevada Health Link
Colloquy
Panini Infotech
RELEVANT EXPERIENCE
Bharat is an accomplished .Net Developer with 8+ years of experience in software development using OOPS, SQL Server 2000/2005/2008/2012, MongoDB, WIN Forms, CouchDB, C#, ASP.NET, .NET Framework 2.0/3.0/3.5 /4.0/4.5, Oracle 12, HTML, CSS, MVC4.0, Java Script, Typescript, LINQ, SSIS, SSRS, AJAX, Web Services, Web Api, WCF, WPF, Visual Studio 2008/2010/2012.
SKILLS INVENTORY
Proficient in building Web Applications using HTML, AJAX, JAVA SCRIPT, OOPS, XML and CSS.
Professional in .Net Development experience in various applications based on Object Oriented Programming (OOP), Client/Server, N-tier architecture, Web based Technology.
Extensive experience in Database design, Modeling and Database maintenance in MS SQL Server environment.
Strong knowledge in implementing N-Tier Architecture in Windows and Web based, Client/Server, internet and distributed applications in Microsoft Technologies.
Proficient in designing and developing web applications, WPF, WCF services, and windows applications.
Having good knowledge of Importing and exporting of bulk data, backing up and restoring databases in SQL Server.
Experience using Ajax Extensions and Toolkit Controls including: AutoComplete, Update Panel etc.
Experience using Agile and Scrum methodologies
Experience in .NET security features such as Authentication and Authorization (Authorizing Users and Roles).
Hands on Experience in databases such as MYSQL, Oracle, CouchDB, MongoDB(NoSql).
Highly organized with the ability to manage multiple projects and meet deadlines.
Adaptable to new software technologies, quick learner and also can work efficiently as an individual.
Strong analytical and dynamic trouble shooting skills coupled with excellent communication skills and able to work individually and as a team.
CHRONOLOGICAL SUMMARY OF EXPERIENCE
Senior .Net Developer
WellCare, Tampa, FL February 2016 – Present
Project: Preferences July 2016 – Present
Preferences is the project where enrolled Members or Providers will have some mode of communication based on their priority like EMAIL, USPS, FAX, SMS, PHONE. The priority of the project is to provide some of the applications in WellCare with preferences opted by member and all the details based on the parameters sent by those applications, it can offer all the details related to it.
Development based on Requirements with TDD approach.
Designed and developed the application in .NET Framework 4.5 using C#.Net.
Used Windows Authentication for Internal Users using the membership and role provider.
Developed the Business Layer using C#.Net for the Data Access Layer.
Developed the Application Logic, Validation Checks and Business rules for the Business Layer using C#.Net .
Deploying the code to the environments, creating the Application Pools in IIS and managing the site.
Worked closely with QA for bug fixes to ensure the efficiency and accuracy of the code.
Involved on development of Web API with REST, JSON.
Used AJAX for faster & interactive web experience with AJAX controls Toolkit.
Writing Packages and modify rules in existing package procedures.
Configure and Publish events to IBM Message Queue.
WCF Services implementation.
Designed architected, programmed Web based Application and Libraries.
Created stored procedures and triggers to retrieve and split stored SQL data.
Prepared Technical design documentations, Unit Test document and functional description at each stage of the application to assist the client.
Validated all the data using Advance Rest Client.
Environment: ASP.NET, C#, WCF, WEB API, XML, JSON, Web services, IIS, Advance Rest Client, Oracle 12, Visual Studio 2012, TFS, MQ Explorer, SOAPUI.
Project: GA-Rebid Enrollment February 2016 – July 2016
This project providing health care services to Members of: Medicaid, PeachCare for Kids, and Georgia Families 360 . This project involves in collecting the enrolled members information, will be used to associate Providers(Primary Care Physicians, Dental Providers, Behavioral Providers) and Support Community members(Individuals/Organizations) to the members to Members across multiple Well Care organizations.
Development based on Requirements with TDD approach
Designed and developed the application in .NET Framework 4.5 using C#.Net.
UI Development / CSS implementation
Used Windows Authentication for Internal Users using the membership and role provider.
Developed the Business Layer using C#.Net for the Data Access Layer.
Developed the Application Logic, Validation Checks and Business rules for the Business Layer using C#.Net.
Worked closely with QA for bug fixes to ensure the efficiency and accuracy of the code.
Used AJAX for faster & interactive web experience with AJAX controls Toolkit
Writing Packages and modify rules in existing package procedures
Configure and Publish events to IBM Message Queue
WCF Services implementation.
Designed architected, programmed Web based Application and Libraries.
Created stored procedures and triggers to retrieve and split stored SQL data.
Prepared Technical design documentations, Unit Test document and functional description at each stage of the application to assist the client.
Validated all the data using WCF test client.
Environment: ASP.NET, C#, Oracle 12, Visual Studio 2012, TFS, CSS, JavaScript, MQ Explorer, SOAPUI, Bootstrap.
Senior .Net Developer
Kindred Healthcare, KY March 2015 – January 2016
Project: Managed Care
Managed care specializes in project management and design that learns quickly and adapts to fast changing and diverse enterprise environments with implementations of healthcare information and also provides all the patient records like charge files, accommodation data, payer information, visit data, physician information, Diagnosis data, Therapy data with respect to facilities that works directly with state, federal agencies, health plans, to design and implement cost- effective strategies that improve care for people with complex and high-cost needs. It provides unique venues where Medicaid and other public and private purchasers can work together, share best practices and design programs that reward high quality care. This is an exciting, fast-paced company with a challenging career opportunity with carefully selected, developed and retained qualified team.
Responsible for requirement gathering and preparing the Requirement Specification Document.
Designed and developed the application in .NET Framework 4.5 using C#.Net.
Used Windows Authentication for Internal Users using the membership and role provider.
Used WPF and WCF to communicate between DAL and other business components
Developed the Application Logic, Validation Checks and Business rules for the Business Layer using C#.Net.
Created Web Forms for referring clinics to submit information about the patients.
Experience in using Sql to LINQ, LINQ to objects.
Coding the presentation layer using WPF and silver light and service layer using Windows Communication foundation technology
Gained Knowledge about Web Analytics and Webmaster tools.
Developing the process and plans to improve the career goals.
Experienced in WinForms application development using C++, WCF.
Worked on formatting SSRS reports using the Global variables and expressions
Designed architected, programmed WinForms, Web based Application and Libraries.
Contributed software engineering expertise in the development of products through the software lifecycle.
Introduced methodologies and best practices that enhance product definition, release processes and customization of applications to user needs.
Experience in object-oriented programming, developing, testing and debugging code, designing interfaces.
Quickly learn and master new technologies, successful working in both team and self-directed settings.
Implemented indexing for various tables in the database for improving performance of the application.
Created stored procedures and triggers to retrieve and split stored SQL data.
Prepared Technical documentations, user manuals, installation and user guides and functional description at each stage of the application to assist the client.
Validated all the data using WCF test client.
Used Asynchronous JavaScript and XML(AJAX) techniques to improve performance.
Extensively used both Dataset and DataReader to gather data from database and used Grid View, Data List, Detail View and Repeater controls to display the data in a desired format.
Involved in AGILE Methodology for the software development process.
Performed Code review and Unit Testing for better performance.
Earned Recognition for innovative ideas in user interface design.
Environment: .Net Framework 4.5, C#.Net, SSRS SQL server 2012, WPF, Multithreading, LINQ, WCF Services, Windows Applications, Windows Services, WIN Forms, MVC 4.
Senior .Net Developer
United Health Group, MN July 2014 – February 2015
Project: UHCG Emerald October 2014 – February 2015
UHCG Emerald is a group of applications, which includes Enrollment, Case Management, Transport and Claims Assistance. All these applications are interconnected on each other. Enrollment is the key application used to create the enrollments products, Creates individual enrollment and Blanket enrollments for travel, medical, security and assistance products. Enrollment application internally uses entity management services to get core entity level information. Case Management application is developed to create and manage different types of cases like medical and transport cases efficiently. Each case is tagged to a case manager to deal with the case. Case Manager opens a new case based on the request and the case is sent for review by medical review team. If it is medical case and transport is required for medical treatment, then Transport case will be created to handle the transport. Transport application will create a mission for the case to arrange the transportation from injured place to the hospital/care center. Claims assistance is used to handle the claims processing and payments. Claims Assistance will deal with the entire financial Summary for a particular case to be paid or to be covered.
Use to gather the required information and maintain the documentation.
According to the requirement use to Analyze and involved in designing and development.
Involved in database to create tables, stored procedures.
Involved in the Analysis, Requirements gathering and Development of the project.
Experience working within development frameworks (MVC Architecture) and web services.
Used Java-Script extensively for performing client side validations
Involved in writing Queries, Stored Procedures and Triggers to pull the data in database
Used ASP.NET, ADO.NET, SQL-statements to develop server-side data base connections
Web forms were implemented using various server controls like Grid view, Calendar, and various validation controls.
Updated dashboard front end to support multiple dashboards and their CRUD operations using typescript.
Converted grunt build tasks to gulp to decrease build times in an angular node project.
Working on Deployment to QA. Fortunately got an opportunity to work closely with QA for bug fixes to ensure the efficiency and accuracy of the code.
Involved in developing the Detail Design documents.
Developed the new User Interface and modified the existing User Interface.
Experience in designing and implementation web applications using ASP.NET including client-side scripting using JavaScript.
Communicating for the status and progress of Interface related activities on regular basis to Onsite and offshore leadership
Implemented the Business logic in C#.NET, where all the Business Objects are written in developing the whole Application.
Extensively used Data bound controls like Grid view, Data List and Data Repeater controls.
Participated in (SQL Server) database designing and database programming (database tables, stored procedures, functions, triggers etc.).
Used Visual Source Safe for Project management.
Finally A good team player with strong ability to learn and adapt new skills and makes efforts to do the work at hand and manage time effectively
Environment: .Net 4.5, C#.Net, MVC 4, ADO.Net, JQuery, Javascript, Typescript, HTML 5, Web API 2.2, SQL Server 2012.
Project: Global Intelligence Center July 2014 – October 2014
The Global Intelligence Center is the hub for online tools such as World Watch® for security intelligence, Medical Intelligence Reports for medical intelligence, TSM Essentials Travel Briefing for quick, 2-page briefings on popular city destinations, Airline Risk Rating for a review of commercial airlines, Travel Security Manager for monitoring employee travel and risk, Daily Security Alerts sign-up to receive daily briefings of global events
Involved in the complete life cycle of the project.
Responsible for developing and implementing Workflows.
According to the requirement use to Analyze and involved in designing and development
Involved in design, development, testing and quality assurance of the product.
Configured web.config file for the configuration of the entire Web Application.
Performed debugging and exception handling in support to the software development.
Prepared analysis, design documents, estimation, for different component and functional modules required by the system.
Integrated Umbraco Content management site as admin site.
Participated in writing Stored Procedures for performing optimization and other database operations such as complex SQL queries etc.
Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
Responsible for developing and implementing Workflows.
Performed bug Tracking and Reported using Quality Center.
Performed Unit Testing and Integrated Testing.
Involved in unit and manual testing of the application.
Ability to conceptualize, document, and communicate project ideas and plans.
Enthusiastic and Quick to learn new applications and tools and willing to take individual responsibilities.
Environment: .NET Framework 4.0, C#.NET, ASP.NET, Umbraco, WCF Web Services, AJAX, JQuery, HTML 5, CSS, SQL Server 2012.
Senior .Net Developer
Equinix Inc., Sunnyvale, CA June 2013 – June 2014
Project: Loan Organization System
Loan Organization System processes the loans, creates Service Requests in Branch and Call Center. Preprocessing of the loans is done to verify the eligibility and to approve the loan for the customer. When Service Request is created in Branch or Call center it must be routed to respective group, based on certain parameters like Location, Channel, Branch and Status. Escalation is required to keep track of processing of Service Request.
Designed, developed and enhanced the application in .NET Framework
Developed application in ASP.NET using C# in code behind Pages.
Used AJAX for faster & interactive web experience with AJAX controls Toolkit
Designed and created templates using Cascading Style Sheets (CSS), which can be used through all the forms to have a unified look.
Implemented design pattern for developing the Web Application.
Used ASP.NET Validation Controls and developed JavaScript to perform various Client side validations.
Knowledge in Mondodb which supports various features such a s embedded douments, No Foreign hey constraint, No declared schema. etc.
Designed, developed user interface look and feel and functionality for web users using XML, HTML, JavaScript, XHTML, CSS and using ASP.NET and C#.NET.
Extensively used Data bound controls like Grid view, Data List and Data Repeater controls.
Created Stored Procedures, Indexes, Views and Triggers using SQL Server.
Generated periodic summary reports, Sub reports, Drill Down reports, Matrix reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
Created and consumed Web Services to expose the application functionality for different applications running inside the company & outside, implementing a Service Oriented Architecture.
Involved in unit and manual testing of the application.
Environment: .NET Framework 4.0, C#.NET, ASP.NET, WCF Web Services, WIN Forms, PL/SQL, MVC,WPF, Visual Studio 2008, Silverlight, AJAX, JQuery, HTML, MongoDB, CSS,T-SQL, SQL Server 2008.
.Net Developer
L Brands, Columbus, OH April 2012 - May 2013
Project: FRESCO-Phase 2 Design
L Brands Inc. is an American fashion retailer based in Columbus, Ohio. Its flagship brands include Victoria's Secret and Bath & Body Works. In Fresco creating Users, User groups and assigning those privileges.
Involved in the Analysis, Requirements gathering and Development of the project.
Involved in developing the Detail Design documents.
Developed the new User Interface and modified the existing User Interface.
Involved in developing the application using WPF.
Used Windows Presentation Foundation (WPF) for creating graphical user interfaces.
Implemented the Business logic in C#.NET, where all the Business Objects are written in developing the whole Application.
Worked with User controls and ASP.Net controls in .Net 4.0 .Used ADO.NET for retrieving, querying and manipulating data in the database.
Extensively used Data bound controls like Grid view, Data List and Data Repeater controls.
Created Stored Procedures, Indexes, Views and Triggers using SQL Server 2008.
Developed Web Services and invoked them by using XML, SOAP and WSDL tool for creating proxy classes.
Basic Knowledge in CouchDB which is a document database server, accessible via a RESTful JASON API.
Participated in (SQL Server) database designing and database programming (database tables, stored procedures, functions, triggers etc.).
Developed web pages to display the status details to customers using ASP.Net and C#.net.
Implemented AJAX controls to increase the performance of the web application.
Involved Testing and Debugging.
Used TFS (Team Foundation Server) for version controlling.
Used Visual Source Safe for Project management.
Environment: .NET Framework 3.5, C#.NET, ASP.NET, WCF, WPF, MVC, PL/SQL, Visual Studio 2008, AJAX, XML, JavaScript, CouchDB, SQL Server 2008, T-SQL.
.Net Developer
Nevada Health Link, Las Vegas, CA January 2011 - March 2012
Project: HIX Nevada
Nevada Health Link is to help individuals and small businesses easily shop for, compare and buy health insurance. Customers will be able to make side-by-side comparisons of plans from different insurance companies, so that they can pick the plan that's right for their needs.
Designed, developed and enhanced the application in .NET Framework 3.5.
Involved in defining and creating technical details from the inputs obtained by the business user
Extensively used design patterns to ease of code maintenance and reusability
Designed Web-based ASP.NET Intranet applications linked to firm-wide SQL databases
Client side validations with Jscript and Server side validations with ASP.NET
Developed classes that contained both business and data access logic
Developed business objects in the business layer and called these business objects from the presentation layer for data binding, etc.
Developed custom solutions using .NET technologies including C#, WCF, web services, Application pages, Workflows, ADO.Net, LINQ
Used various data control and display elements like Data Grids, Data Sets, Data Views, and Data Adaptors to extract data from the backend
Used ADO.NET extensively for retrieving, querying and manipulating data in the database.
Wrote SQL Queries, Stored Procedures, Functions, and Triggers on SQL Server
Developed test cases and performed unit testing
Environment: .NET Framework 3.5,Visual Studio 2010, ASP.NET, C#,SQL Server 2008, ADO.NET, SSRS, Web Services, AJAX, JavaScript, JQuery.
.Net Developer
Colloquy, Cincinnati, OH October 2009 – December 2010
Colloquy is a company that supports institutions of higher education in their delivery of online education. In support of this, Colloquy has a database of students, programs, and courses. It shares this information with Colloquy partners, and to receive updates to it from them, on a regular basis (in some cases daily, in other cases more frequently.
Involved in low level designing like class diagram, entity diagram and DB structure using Software Architect. Involved in coding using .Net framework 3.0.
Designed and developed a web application using .net framework and visual studio 2005.
Developed User controls to increase the reusability and to improve the performance.
Used complex LINQ queries to satisfy business requirements and support end users.
Used Grid View and List View for displaying data.
Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.
Provided session level security and password authentication using session objects and cookies.
Implemented source control and version control using Team Foundation Server.
Writing SQL script for changing production data in database
Involved in designing and developing Tables, stored procedures, views using SQL Server 2008.
Environment: .NET Framework 3.0, C#.NET, ASP.NET, MVC, Visual Studio 2005, AJAX, LINQ,T-SQL, JQuery, SQL Server 2008.
Software Engineer
Panini Infotech, India Jan 2009 - September 2009
Project: VPN
It is web-based application, which is used primarily in the visa application center to process the visa entry and update/track the application. The application is used to allocate the time slot for appointment, open interview dates, updated the tracking status of application and data entry of the applicants.
Developed the scanning module, which allows the user to scan barcode and register into system.
Developed allocation module for interview allocation.
Developed allocation report generation module.
Involved in Stored procedure optimization of existing modules.
Developed supporting application-to-application support activity.
Fixing critical issues occurs during operations.
Designed and implemented SQL Server 2005 database tables, views, triggers and stored procedures and configure using SQL Server Management Studio.
Worked with clients to generate functional requirements, create business rules documents
Environment: C#.NET, ASP.NET, Visual Studio 2005, AJAX, LINQ, T-SQL, JQuery, SQL Server 2005.
Contact this candidate