Customer Service Sql Server

Sandeep

.Net Developer

PROFESSIONAL PROFILE

Around 5 years of IT experience in software design and development using Microsoft Technologies like ASP.Net MVC, C#, WCF, WPF, Web Services, ADO.Net, Entity Framework, Silverlight

Experience in developing UI applications using JavaScript, CSS, JQuery, Angular JS and HTML

Experience in Importing data from different sources like Web Services, XML data source, Oracle and SQL Servers using SSIS.

Strong Understanding of Data structures, Algorithms,Object-Oriented Design, Design patterns like singleton, factory, MVC, MVVM

Experience using Fusion Charts for a dynamic data representation.

Software Developer/programmer with history of productive and successful project launches

Involved in analyzing requirements, designing systems, testing, debugging, implementing and documenting various complex systems

Experienced in Designing Rich Interactive Web Pages using ASP.Net User Controls, and Custom Controls

Experience in working with LDAP using C#.Net

Experience in Web Services and Windows Communication Foundation (WCF).

Proficient in implementing AJAX functionality to improve the responsiveness

Extensive experience in working with LINQ to Objects, LINQ to SQL and LINQ to XML

Have Good experience in a fast paced Agile Methodology Development Environment

Specialist in development of web applications and windows based applications using WPF (MVVM pattern).

Experience in handling various backend data sources such as MS SQL Server 2000/2005/2008, MS Access, and XML Data source

Expertise in creating Constraints, Indexes, Views, Stored Procedures, Triggers and User Defined Functions using T-SQL

Possess high analytical with exceptional problem solving and troubleshooting skills

Quick adaptation to newer technologies and challenges

A good team player with ability to communicate new ideas and solutions clearly to the team

Self-motivated and self-starter to work on problems to find solutions and troubleshoot issues

Technical Skill Set

Programming Languages

: ASP.NET, C# (4.5), VB.NET, WPF, WCF, LINQ, PL/SQL

Development Tools

: Visual studio .NET 2008/2010/2012/2013, Fiddler

Web Technologies

: HTML/CSS, HTML5, SOAP, Web services, UML

Relational Database Tools

: MS SQL SERVER 2005/2008 R2, Oracle, SQL Developer,SSIS

Scripting Languages

: Angular JS, Java Script, JQuery, XML, AJAX, JSON

Education

Bachelor’s Degree in India

Masters in Computer Science (University of Illinois at Springfield, USA)

Professional Experience

Verizon Wireless, Little Rock, AR Oct 2015 – Present

Sr.Net Developer (Full Stack)

Verizon wireless is a leading company in wireless technologies. Verizon Wireless has the stability, resources, expertise, and passion to discover, develop, and bring to market groundbreaking solutions to solve the biggest web development problems that face the world today and tomorrow. VZW and NCC is the internal project pertaining information of metrics and statistical data relating to customer service.

Responsibilities

Responsible for Designing, coding, developing and implementing application using C#, VB.NET, ASP.NET MVC and Angular JS.

Responsible for importing Data from different sources using SSIS.

Responsible for creating Stored Procedures and Reports relating to Dashboards created based on client requirements which were used to analyze everyday metrics of customer service representatives and Business.

Responsible for developing Dashboards using AngularJS, C# and VB.NET.

Wrote complex Reusable directives using AngularJS.

Developed reusable controls using ASP.NET MVC and C# in the .NET Framework 4.0.

Used ADO.NET extensively for data retrieving, querying, storage and manipulation.

Performed unit testing on every new version before sending it for User Acceptance Test (UAT).

Handled Configuration (Session, authentication and authorization, custom errors, tracing and so on) or the online transactions by the customer and creating user login and privileges.

Acted as a DBA to a group to set permissions and mentored the group in using T-SQL.

Extensively used Fusion charts to dynamically display data in pictorial representation for a better understanding to Business.

Environment

C# 4.5, Visual Studio 2013, ASP.NET MVC 5.0, JavaScript, AngularJS 1.5, JQuery, VB.NET, SSIS, ADO.NET, SQL Server 2012, XML, HTML, CSS, Bootstrap.

Amazon Development Center April 2012 – July 2014

End Client - Cox Digital Solutions

Software Engineer

Cox Digital Solutions is one of the leading advertising solutions with over 1300 sites in the US. It enables the publishers to offer standard ad solutions that go beyond standard banners ads. It supports rich text, image, flash and video ads. This website provides its customers to upload and display their ads on different websites. It has different revenue models based on clicks and impressions. It provides the user to create and manage networks, sites, publishers, advertisers, campaigns, media buys and publish their ads on different sites and networks. Cox digital solutions interface is user friendly and time saving for the publishers.

Role & Responsibilities

Developed Presentation layer (Web Forms) using ASP.Net, HTML, and JavaScript and C#.

Involved in Windows based product on Excel using WPF and WCF with C# 4.0

Created advertisements like flashy ads, video ads etc. and uploaded them in this project

Worked on Cascading Style Sheets, HTML, Ajax and XML

Extensively used Grid Views sorting, paging and export to excel sheet

Worked on Code Smith a third party tool used to create database functions i.e. business layer

Majorly worked on Bug Fixing and unit testing of application

Conducted knowledge transfer sessions to new people in project

Created views for data retrieval for the Pivot charts and tables

Implemented GUI using HTML, XML, Ajax control library, CSS and Web Form Controls to create web pages, developed Master Pages, classes for reuse.

Implemented AJAX support for better user experience and good performance.

Used several server side controls like Data Grid, Calendar control, and validation controls.

Used ADO.Net and strongly-typed datasets to insert, update, delete, and retrieve data from a SQL Server 2005 database.

Environment: ASP.Net with C#.NET, MS SQLServer2005, HTML, CSS, Team Foundation Server, XML, AJAX

Thatikonda Info Solutions, India Sep 2010 – Feb 2011

Junior Developer

End client – (Kum & Go, West Desmoines, IA)

Kum & Go is a convenience retailer in the U.S. The File Translation Service is a Windows Application that converts a File from one type to another (from EDI to PDI) when a vendor inputs a raw EDI file. The application encrypts it and then converts it into a PDI file which is decrypted later by a PDI Mapper. Application also allows the user to enter the vendor details, stores the input file and the resulting PDI folder into each folders on the local server. Created a web application which allows the user to gather information for each of the respective Vendor.

Design, coding, debugging and testing of web interfaces (User Interfaces) using ASP.Net, C#.Net and ASP.Net AJAX controls.

Responsible for developing a Data Access Layer using ADO.Net Entity Framework.

Designed and developed data access layer to retrieve the data back and forth to SQL Server database using C#. Net, ADO.Net and Data Access Application Blocks.

Responsible for writing SQL Queries, Stored Procedures, Views, Indexes and Tuning the Performance of the Queries in SQL Server 2008 R2.

Developed some reusable libraries for Database Interaction and some reusable services for multiple modules in Application by developing some Class Libraries and Web Services.

Involved in Testing, Deployment and Maintenance of the project.

Environment

.Net Framework 3.5, C#.NET, Visual Studio 2004, ADO.NET, SQL Server 2008, XML, HTML, CSS, JavaScript.

Contact this candidate