Sql Server .Net
Resume:
Radhika S Panchal
************@*****.***
SUMMARY:
5+ Years’ experience in .NET Framework and extensive project implementation skills in C#, VB.NET, ASP.NET, ADO.NET, SQL and .NET Framework Class Library.
Expertise in all phases of software development life cycle: Insightful experience in project planning, designing application, formulation of deployment strategy and creation of software products as per client requirements.
Experience in publishing and consuming web services and WCF services
Experience using the NUnit testing frameworks. Practical Test Driven Development experience.
Solid work experience in analyzing and identifying business system requirements and framing business rules by working along with clients and their existing system.
Extensive project experience in developing n-layered windows/web forms applications.
Strong database design/implementation skills in RDBMS like SQL Server 2008/2012.
Proficient in design of SQL reports and development of Reports using SQL Reporting services and Crystal Reports.
Strong Object-oriented Analysis and Design (OOAD) concepts and programming skills. Actively utilized Service Oriented Architectures (SOA) in development practices.
Experience in incorporating .NET interoperability with legacy COM components and .NET components.
Good working knowledge of advanced .NET features like .NET Remoting, Reflections API, Generics and Message Queuing.
Project experience in .NET framework 3.0/3.5/4.0/4.5 working on Windows Communication Foundation.
Good hands on experience of MVC 3.0/4.0/5.0 with razor and asp engine.
Good exposure to Windows Presentation Foundation and Workflow Foundation.
Expertise in data accessing using ADO.net and LINQ to SQL.
Experience on working with SQL Server 2008/2012.
Experienced in software methodologies like Agile, Scrum etc.
Well-versed with development of stored procedures, functions, packages and triggers.
Excellent team player with strong interpersonal skills. Highly motivated, enthusiastic and self-starter.
Personal Skill includes Strong time & results oriented discipline, able to work in an organized fashion in teams & independently, Capable of communicating at all levels - individuals & groups, Self-directed and maintain a proactive approach to problem Solving and Have excellent oral & written communication skills & solid interpersonal skills.
TECHNICAL SKILLS:
Frameworks and Languages Microsoft .NET 3.0/3.5/4.0/4.5, C#, VB.NET, ASP.NET,
ADO.NET, SQL
Scripting Languages JavaScript, JQuery, Angular JS.
Web Technologies HTML, DHTML, CSS, AJAX and SOAP
IDE Visual Studio 2010/2012/2013/2015 SQL Server Management
Studio and Toad
Testing NUnit
RDBMS MS SQL server 2008/2012, Oracle and My SQL
Application Servers IIS 6/7
Software Development Process Models Waterfall, Iterative, Incremental, SCRUM, Agile
Operating System Windows 7/8/10
Tools MS-Office, MS-Visio.
EDUCATION DETAILS:
MS in Computer Science, Hood College, Frederick, Maryland, USA
Bachelor in Computer Application, India
PROFESSIONAL EXPERIENCE:
GEICO, Chevy chase, MD Jan 2016 – Currently here
.NET Application Developer
GEICO is an American auto insurance company headquartered in Chevy Chase, Maryland. It is the largest auto insurer in the United States. GEICO is now rewriting policies with an application called EDGE, with the objective to enhance the application features and develop an enriched user interface.
Responsibilities:
Developed, tested and deployed the applications in an agile/scrum environment.
Involved in all Software Development Life Cycle phases including requirement analysis, implementation and estimating time-lines for the project.
Participated in gathering and co-coordinating requirements, design, and implementation for the application.
Responsible for designing the User Interface by coding in HTML5, CSS3, AngularJS, bootstrap to build a SPA - Single Page Application
Implemented dependency injection in C# using frameworks like AutoFac.
Implemented Angular Service calls using Angular Factory and AngularJS controllers to maintain each view data.
Leveraged Angular JS resources for all data access, encapsulating URLs and standardizing data access interfaces.
Created message handlers in Web API to implement global level authentication
Worked with MVC/Web API routing prefixes on the controllers.
Used XUnit, Moq for backend test cases and 'Jasmine' for AngularJS test cases.
Used Fiddler/Postman for debugging Web services
Used authentication and authorization filters for implementing authentication and authorization in the application
• Used XML/JSON data formats to communicate data within the application.
Designed and developed stored procedures for SQL Server 2012 database.
Responsible for writing SQL queries, stored procedures, views and user-defined functions.
Data Access Layers for the application were implemented for data input, query, retrieve and management.
Environment: WEB API, Angular JS 1.5, MVC, C#, Entity Framework, .NET Framework 4.5, Visual Studio 2015, SQL Server 2012, TFS 2013, Postman, Fiddler.
Verizon, TX June 2015– Dec 2015
.NET Developer
Verizon.com is one of the highly used online ordering applications in the United States of America. Using this web application, consumers can place online orders of all Verizon products such as Voice, Data, TV and Wireless. As part of this project, the ordering application was completely revamped based on consumer usage, studies & surveys. Worked with a monthly production release timeline, during which design and development was performed based on the requirements from the Verizon Business Team.
Responsibilities:
Involved and performed all the steps in the SDLC including initial system analysis, identifying functional design specification, architecture design, development and testing.
Used N-tier architecture for Presentation layer, the Business and Data Access Layers and were coded using C#.
Customizing frontend as well as backend to integrate the new products for Order Placement and Completion.
Web application security was monitored by logging sessions and cookies in database.
Apart from content management, page hit/orders counts, IP of user was stored for temporary periods.
Created a unique, personalized and innovative user experience for every visitor according to how the customer browses the website.
Responsible for overseeing the common functionality for persisting the user data among the different applications.
Heavily used ASP.NET Server Controls, Validation Controls and User Controls.
Extensive use of Cascading Style Sheets and JavaScript for dynamic user interface and browser compatibility tests.
Analyzing requirements, proposing UI solutions and developing IT requirements.
Reusable AJAX based web controls were designed & developed for best user-experience.
Environment: Visual Studio 2012, C#, ASP.NET, ADO.NET, TFS, SQL Server 2008, AJAX and LINQ.
AmeriChoice, AZ Dec 2014– May 2015
.NET Developer
As part of the franchise model initiative, the Hospitality, Assessment, and Reminder Center (HARC) is making calls to and receiving calls from members on behalf of the various AmeriChoice health plans. These include Welcome Calls, Health Risk Assessments (HRAs), and others. In order to make these calls, the HARC receives member data from various health plans and stores it in an accessible database. The results of each call are then stored in a HARC database from where the data can be included in reports sent to the health plans.
Responsibilities:
Performed all phases of the SDLC from creating design documents (which included application term definitions, project scope, requirements, use cases, class designs, database designs…) to designing, developing, testing and installing in the development server.
Extensively used OO design and UML diagrams such as use case, class and sequence diagrams during the design phase using Microsoft Visio.
Authenticated users against the Microsoft Active Directory service by using the Lightweight Directory Access Protocol (LDAP) and retrieved a list of security groups and distribution lists to which the user belongs to, which is used for .NET role-based authorization.
Used .NET Framework Class Libraries and created ASP.Net pages in C# containing the business logic and provided data access logic using ADO.Net objects.
Implemented WCF Services in C# based on SOAP protocols using XML extensively for data transfers in the business layer.
Used WPF for creating, and improving certain user controls features including context menu items, which involved the use of XAML code.
Designed multiple screens using Master Pages and User Controls. Extensively used JavaScript to provide Client-Side validations and for dynamic user interface.
Used Form based Authentication for authentication purposes and used ASP.NET validation controls such as Regular Expression Validator and Custom Validator to validate the information provided by the user.
Exported data within database to user as downloadable files in XML format.
Designed SQL Server Database Architecture and design. Worked on development of Stored Procedures to facilitate the transactions. Also, developed Triggers to initiate event based processes.
Used SSIS to do ETL operations to get/post data to FTP folders.
Used LINQ to SQL in data access layer to access data.
Developed reports for the different domains using SQL Server reporting Services.
Environment: Visual Studio 2012, C#, ASP.NET4, 4.5, ADO.NET, SQL Server 2008, AJAX and LINQ.
Durga Food Company, India Jan-2011– Dec 2013
Designation: Jr .Net Developer
Durga Food Company is a 3-tier web enabled system, which deals with Purchase/Sales orders, Inventory tracking and Accounting. Ordering interface is used by the Rep Centers or directly by the end users to place the orders online, to change the existing orders and to track the status of the orders.
Responsibilities:
Involved in design, coding and documenting.
Communication Framework Design and Development.
Windows Services Developed using VB.
Used various ActiveX Control as part of the UI development.
Designed and developed web pages using ASP & JavaScript.
Wrote Queries, Stored Procedure and Triggers for High performance Web and Windows Service Application in Oracle Database.
Environment: Visual Studio 2010, C#, ASP.Net, JavaScript, Pl/SQL.
Contact this candidate