Sql Server Data

Jangamreddy

EMAIL: **************@*****.*** PHONE: 609-***-****

NOTE: VISA STATUS – H1B only work Corp to Corp

Security Clearance: Public Trust Security Clearance

PROFESSIONAL SUMMARY

* ***** of diverse experience in all phases of software development life cycle (SDLC) especially in Analysis, Design, Development, Testing and Deploying of applications and Implementing N-tier Client / Server application using Object oriented design methodologiesinAgile Scrum and Waterfall methodologies.

Very well developed and supported client side functionality with many rich UI features, user friendly design approaches, responsive web pages with performance functionalities in the web applications and Single Page Applications (SPA) usingAngularJS1.5.x, JQuery3.0/2.0/1.0, JSON, HTML5/4, AJAX, XML/XSL/XSLT/XHTML, CSS3, Bootstrap 3.x/2. x.

Proficient in implementing Filters, Validations, Controllers, components, Directives, Routings, Factory and Services in AngularJS 1.5/2.0 based on MVC and MVVM Patterns.

Expertise in building Web Services using WSDL, UDDI, SOAP Protocol and consuming/publishingWeb and architected enterprise N-tier software agent using WCFweb servicewith features versioning, security, optimization and reliability.

Extensively implemented and consumed WEB API 1 and WEB API 2, used HTTP methods (verbs-GET, PUT, POST, PATCH, DELETE) to do CRUD operations, supportJSON orXML data exchange formats and also implemented Security, Caching.

Extensive experience in Object Relational Mapping (ORM), Entity Framework Code First, Database First approache, implemented the Features Security, Performance and Migrations etc.

Created Entity classes, relationships between entity classes using different ORM’s likeEntity Framework 6/5/4.3/4.1, Nhibernate, LLBL Gen Pro Frameworkto manage relational data as objects and used LINQ to Entities to massage the data.

Strong hands on setting up connections and working on the Relational Database Management (RDBMS) like SQL server 2012/2010/2008 and Oracle 12c/11g /10g.

Working experience in data modeling and implementing tables, views, storedprocedures, functions, and Triggers using T-SQL and PL/SQL on Relational Database Management (RDBMS) andworked with MS-SSIS and MS-SSRS for the data integration and data reporting services. Good knowledge of creating reports with Crystal Reports 9/10 and Tableau.

Having excellent analytical, Problem solving, communication skills, Quick learner and excellent team player.

TECHNICAL SUMMARY

Programming Languages

C++, C# .Net (4.0/3.5/3.0), VB.NET (10.0/9.0/8.0), SQL

Web Technologies

ASP.Net MVC 5/4/3, ASP.NET 4.5/4.0/3.5/3.0/2.0, Silverlight 4.0/3.0, Prism(MVVM), ASP.Net Ajax Toolkit 3.0/2.0, VB Script

UI Technologies

Angular 2, AngularJS, HTML5, JavaScript, JQuery 3.0/2.0/1.0, CSS, Bootstrap 3/2,Telerik UI for Silverlight, Kendo UI

.Net Frameworks

.Net Framework 4.5/4.0/3.5/3.0/2.0/1. *

Middleware

Databases

WCF, Web API, ADO.NET, Web Services, Nhibernate, Enterprise Library

MS SQL SERVER 2014/12/10/08/05, Oracle 12c/11g/10g/9i, NOSQL, MONGODB

Reporting Tool

Testing Frameworks

SQL Server Reporting Services (SSRS 2008/2005), MSBI, Crystal Reports, Tableau

NUnit, Junit, MS Test, MOQ, Unity, Fakes, Karma-Jasmine

Modeling Tools

UML, MS Visio 2010/07

Version Control Tools

GIT, Subversion, Team Foundation Server 2013/12/10

EDUCATION QUALIFICATION

Bachelors in Computer Science, GITAM UNIVERSITY. INDIA

PROFESSIONAL EXPERIENCE

SHIPCOM WIRELESS– Houston, TX. Feb 2016 – current

Full Stack Developer

District of Colombia Courts (Federal)

Description:The application responsible for warehouse inventory management and administration activities that include maintaining Par Levels / ROP, Tracking the assets using GPS and GIS Devices to show them on Bing Maps and on Building Floors ordering items in shopping carts and performing cycle counts to ensure inventory accuracy and tracking of the expired product. The application also includes demand recognition, approval, and procurement process, receiving, storing and delivery of items to the customers. Primarily focuses on Alerts, Dashboards and Reporting while performing different activities like Put away Receipts, Pick Order, Fulfillment, Inventory Adjustments, Cycle Count, etc.

Responsibilities:

Designed and developed new and enhancements to software applications that include requirements analysis to gain an understanding of business needs to develop level of effort estimates, software design and development, unit testing, performing design and code reviewsand development of technical documentation.

Developed Single Page Applications (SPA) based on client side JavaScript framework AngularJSMVC Pattern.

Created AngularJS Controllers, Scope, Model, View, Services, Factory etc., which isolate scopes, perform operations in UI like traversing HTML document, event handling.

Creating Custom Directives of elements attributes types for achieving tasks like re- usable components (multi-field form elements, background file uploads, etc.), auto complete, pagination and validation textboxes.

Extensively used Telerik objects like Rad Date Picker\Panel Bar\Menu\Combo Box\Grid\Tab controls to meet performance issues.

Created custom controllers, services in AngularJS and integrated with KendoUI to show large amount data in grid.

Developed application level code to interact with API's, rest web services using asynchronous, JSON, Node.js, XML.

Developed REST APIs that allow sophisticated, effective and low cost application integration and multi-tier web applications with the use of Web Services using ASP.Net Web API.

ImplementedAngularJS to handle asynchronous(AJAX) communication with our Rest API for various requirements.

Used Entity Framework 6 - Reverse Engineering approach andCode first approach.

Worked Extensively on Integrating Tableau Report with .NetUI and Applying UI filters to tableau report with C#.Net as Code behind language.

Designed database in SQL Server 2014 and created stored procedures, functions, views to reduce the complication of SQL queries and triggers to enforce entity relationships.

Involved in troubleshooting, monitoring, optimization of SQL Server2014 database procedures and T-SQL code.

Created unit testing cases using Karma-Jasmine where each test case is written in a user friendly Jasmine languageusing simple describe, it, Expect, before each and after each block’s and performed continuous intergration and deployments using TeamCity.

UsedJIRA for bug tracking and issue tracking and daily stand up to sync up with Team for current sprint status Implementation and Maintenance with extensive experience with agile methodologies.

Environment:VisualStudio2015/13,AngularJS 1.5.8, ASP.Net MVC 5, C#,HTML5, CSS3, Bootstrap, JavaScript,Typescripts, Node.JS,WCF,WEB API,Entity Framework, JSON, SQL Server 2014,LINQ, Repository pattern,Active Directory, MS Excel, XHTML, XML, IIS 8.0, IIS7,HTTP, HTTPS, AZURE,SharePoint, SQL, T-SQL,TTD, Continuous IntegrationTeamCity, GIT.

People 2.0 – West Chester, PA. Feb 2015 – Jan 2016

Senior .Net Application Developer

Human Resource and Payroll

Description:People 2.0 is a rapidly growing, leading provider of comprehensive back office services for independent staffing companies. Which includes payroll, financing, insurance, consulting and a range of essential support services. Worked in five interconnected projects, involving core windows application, web application, Outlook Add-ins, job scheduler, and job portals.

Responsibilities:

Involved in Design, Developing and enhancing of company’s proprietary suite of Microsoft applications of staffing software used in company operation which include Windows Winforms application, web applications, web services and other 3rd party integrations.

Designed and developed Applications usingASP.NETMVC5 Pattern, Angular.JS, C#, HTML, Razors, CSS, Bootstrap, JavaScript, JQuery for client side validation and partial pages loads.

Designed Layout page to achieve consistent look and feel for all views in the application and also developed responsive Login page with authentication and validation.

Implemented Action filters such as Authorize, HandleError, OutputCache to handle specific behavior of each controller and used View Data, View Bag, Temp Data for data communication between Controllers and Views.

Developed the Repository layer using dependency injection by injecting the Context class from Data access layer into the repository class to achieve a decoupled layer.

Integrated Content Management functionality into existing browser-based solutions through the use of Restful / WEB APIs and Web Services for client, including JSON data formats and Attribute Routing.

Worked on WEB API to fetch data from third party data providers and syncing between various systems and Implemented WEB API Services for CRUD operations with HTTP verbs GET, POST, PUT and DELETE.

Responsible for developing WCF Services to exchange data between Desktop and Central Application and consumed WCF service, which is based on SOA (Service Oriented Architecture)andimplemeted Security standardards of OWASP.

Implement Data access layer using Entity Framework 6 Code-First Approach to retrieve and store data in entity models and LINQ to interact with the database.

Developed Microsoft Exchange,Outlook, Excel solutions and Implemented Single Sign on (SSO) for logging into multiple related websites and providing external Logins using OAuth.

Created Tables and Views on the SQL Server. Written SQL Scripts such as Packages, Stored Procedures, Functions and Triggers to manipulate and retrieve data from SQL Server databases.

Developed unit tests and performed unit testing using MS Test.

Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS).

Environment:VisualStudio2013/10,.NET 4.5,ASP .NET MVC5,Angular.JS 1.4, HTML5, C#,JQuery 3, JavaScript,WinForms, Repository pattern, ADO.NET, Infragistics tools, Entity Framework 6,Web API, WCF, Azure,TFS 2012, LINQ, Microsoft Enterprise Library, MS Excel, SQL Server 20012,T- SQL,SSRS, SSIS, Fiddler, SOAP UI,XML, IIS 7.0, MS Test,AGILE.

Equifax - Alpharetta, GA April 2014 – Jan 2015

.Net Full Stack Developer

Payroll & Insight Reporting

Description:Payroll and Insight Reporting is part of the claims team in Equifax. This application mainly deals with unemployment and payroll process of the clients. Whenever an employee is laid off from the company he can claim unemployment benefit from his employer. Payroll application receives payroll data from the client and provides payroll information to other applications. Insight Report handles all kinds of reports related with unemployment process of client.

Responsibilities:

Implemented the project according to the Software Development Life Cycle (SDLC) and programming by using fast paced agile methodology, involving task completion, user stories, and iterations.

Developed MVC application by using Layouts to have consistent look of and to add styles to each page in application and Implemented Partial views (user controls), Master Pages, Strongly Typed Views and Complex Views.

Involved in development of MVC 5/4 patterns for client server interaction.

Implemented UI using MVC, HTML5, XML, CSS3, JavaScript, AJAX, bootstrap to create responsive web pages, developed Layouts.

Implemented MVC Architecture on client side and creating Models, Controllers, and Views Scope etc. Using coded frontend interface with Bootstrap, JQUERY, CSS and HTML5.

Implemented Get, Post by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.

Built a robust and scalable application that calls a data service based on the Service Oriented Architecture (SOA) paradigm and built using WCF.

Built WCF clients to make synchronous calls to Web Services over SOAP and HTTP and persist data to flat CSV files.

Developed system services SOA application platform for use by all web applications utilizing WCF services.

Used bindings to control the construction of the Windows Communication Foundation (WCF) channel stack at runtime and partial post back validations to manipulate data on web pages using AJAX.

Used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.

XML Serialization and Deserialization was used before and after data transmission.

Implemented CRUD functionality with Entity framework in ASP.NET MVC for sorting, filtering and paging.

Written SQL Scripts for creating database tables with foreign key relations in Oracle DB using PL/SQLandCreated Tables, Stored Procedures, Triggers and Views in Oracle database.

Have used SQL Server Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, modify data and designed SSIS Packages to transfer data between servers, load data into database and Scheduled the jobs to do these tasks periodically.

Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Implemented Unit Testing through MS Testand created tests for all functions used in the application.

Utilized the TFS source control software to keep track of new and past versions of code written in my application.

Environment:VisualStudio2012/10, .NET 4.5, ASP.NET4.0,MVC 4.0/5.0, C#, HTML5, CSS,JQuery2.0/1.0, JavaScript, Bootstrap, WCF, Web API, Ajax, XML, Ado.Net, Repository pattern, LINQ, SSIS, SSRS,MS Test, Visio 2012, IIS 7.0, Oracle 12c, Windows Server 2008 R2/2008, SharePoint,TFS 2010, PL/SQL.

Horizon Blue Cross Blue Shield -Newark, NJ Sep 2012 – March 2014

.Net Web Developer

Project: Reimbursement Policy

Description: This project implemented a reimbursement policy, with guidelines, for Pre-Admission Testing (PAT) and a systemic solution for adjudicating claims falling within defined criteria. The goal of the project was to eliminate the manual procedure of identifying the over payment claims, usually done by the means of an external vendor, and replace it with a home-grown systematic solution.

Responsibilities:

Involved in all the phases of the Project Life Cycle and also analysis of the system based on N-tier architecture.

Migrated the existing tool Legacy Applications with enhanced features for Business Analysts and Product team (Billing) reports from ASP.Net 1.1 to ASP.Net MVC 3.0.

Designed Graphical User Interface (GUI) using ASP.Net MVC 3, HTML, JavaScript, JQuery.

Implemented entire backend of the application in C#.NET, using various object oriented features like classes, interfaces, inheritance, and polymorphism.

Designed and developed various abstract classes, interfaces, classes to construct the business logic in Model and Data Access Layer using C#.Net.

Used WCF for interoperability with other platforms, technologies and for building the custom solutions.

Performed CRUD operations with WCFRestful services using Web Get, Web Invoke.

Developed Razorviews with strongly typed view models and helpers, partial views andimplemented Get, Post by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.

UsedJQuery to perform validations and catch the events on client’s browser.

Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, Configuring optimizations and Securing the web application.

Used bindings to control the construction of the Windows Communication Foundation (WCF) channel stack at runtime and used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.

Developed Web Services and invoking them by using XMLSOAP and WSDL for creating proxy classes.

Used Web Services (SOAP, WEB API) for communicating with other application and components.

Used LINQ to Entities for retrieving the data efficiently and Just in Time manner.

Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008 R2 and Created ad-hoc reports Using Report Builder.

Used data from different XML, EDI, HL7, and HIPAA transactions and developed reports in different formats as of client requirment.

Converted Data Transformation Services application to SQL Server Integrated Services (SSIS) has assigned.

Performed Unit testing of the applicationusing Nunit and subsequently handled the debugging issues.

Used TFS team foundation server for source control, reporting, check-in policies, build schedule and project tracking.

Environment: ASP .NET MVC 3.0,HTML, CSS,JavaScript, JQUERY, WCF, WEB API, AJAX, LINQ,XML, ADO.NET, Entity Framework 6.0/4.0, Windows Server 2008 R2/2008, Oracle 10gR2, PL/SQL, IIS 7.0, TFS 2010, NUNIT,MICROSOFT VISIO, EDI, HL7, and HIPAA.

Client: Verizon Wireless – Jersey City, NJ July 2011 – Aug 2012

.Net Developer

Project: POS (Point of Sale)

Description:POS (Point of Sale) application for store representatives to take care of customer transactions. POS application is the global search and processing screen for all types of customer details. Customer module: provides details of personal information, status, type, Account details, Customer Eligibility, Billing information. Service module: contract details, device information, Features & Promotions info, Airtime usage details. Billing module: Balance due and payment due date info, option to pay bill, view deposit, Payment Activity details, invoice history.

Responsibilities:

Actively involved in Software Development Life Cycle including Analysis, Design, Implementation, Testing, Maintenance and Support activities of project solutions.

Extract requirements from legacy application and implement them in WPF, MVVM, Prism way with best practices.

Implemented bootstrapper, Module catalog, prism Unity, Modularity, prism librariesin XAML (WPF) using MVVM, WinForms.

Designed and developeddifferent WPF Patterns in Silverlight related software modules, Window manager, XAMLData grid and XAMLspreadsheet using 3rd party GUI components.

Created Web services, which are used to communicate to the other departments.

UI (User Interface) was developed using ASP.NET web server controls, XAML,WPF toolkit and Telerik Rad Controls.

Developed WPF applications in creating animations using animated controls like story board, double animation.

Implemented object-oriented design usingmultithreaded programming, TCP/IP and client/server architecture.

Created Entity Framework Database First Modelfor ASP.NET application used LINQ to Entities and LambdaExpressions for the data access layer.

Used LINQ to Entities heavily for CRUD operations, massage the data, various LINQ operators to improve the performance by reduce the roundtrips to database.

Used web server controls like Login Control, Menu Control and Substitution Control extensively in designing web forms.

Developed SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the historic data.

Create T-SQL joins and sub-queries for complex queries involving multiple tables.

Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in MSSQL Reporting Services (SSRS).

Created packages using SSIS for extracting data from flat files, MS Excel files, OLEDB, MS Access to SQL Server database.

Implemented unit test and integration test using MStest, which was also used for debugging the program.

Conducted comprehensive testing of developed objects in development and QA environments, including regression testing before any changes are released to the Production environment to minimize bugs.

Environment: .Net Framework 3.5/2.0, WPF, MVVM, WCF, Prism MVVM,Dependency Injection, Silverlight, XAML, Infragistics, Entity Framework 4.0, WCF, VB.NET7, LINQ,LambdaExpressions, ADO.Net, Visual Studio 2010/2008, NUNIT, Microsoft Enterprise Library, TFS 2010, IIS 7.0, AJAX, Windows Server2003, SQL Server 2008 R2, UML, XML.

State farm Insurance, Bloomington, IL Nov 2010 – Jun 2011

.Net Consultant

External Tracking System

Description: External Tracking System for State Farm Insurance is a web-based application to be used internally and built to assist the IES (Internal External Staffing) Function personnel in the collection and accurate reporting of information associated with external associates. It includes managing of Vendor information, External Associate information, Contact information, Work order creation and approval process, and Invoice generation.

Responsibilities:

Involved in full life-cycle of the project from requirements gathering to transition using Agile SCRUM Methodology.

Created User Controls, Custom controls, Data Access Layer, Business Logic Layer classes using VB.NET and .Net 3.5 for web pages.

Defined and implemented customized configurations settings for application local Web.Config file for incorporating user authentications and authorizations via role based security in order to restrict accessibility to certain module.

Developed application using ASP.NET for server process & user interface and VB.NET Code Behind.

Designed & Developed ASP.NET User Controls and used ASP.NET Web Forms controls and Migrated VB 6.0 to VB.NET.

Developed Web Forms for User Interfaces using ASP.NET and VB.NET using Server Controls, HTML Controls and User Controls.

Created Custom Validation Controls for validating the data in the User Control and used ASP.NET Validation Controls for server side validation and Java Script for client side validation.

Worked with ADO.NET to interact with the SQL Server 2008 (i.e. retrieving, updating and inserting data into the tables) for Alerts.

Used ADO.NET components like SQL Connection, SQL Command, Data Adapter, Data Set, Data Reader, Grid View and Details View for database connection and database communication.

Developed Stored Procedures, Triggers, and Views in SQL Server 2005 for accessing the database.

Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques.

Implemented Stored Procedures, Joins and Views in SQL Server at the backend level. Cascading Style Sheets (CSS) was used for consistent look of the site.

Developed various stored procedures for the data retrieval from the database and generating different types of reports using SQL reporting services (SSRS) and Crystal Reports.

Extensively Used TFS (Team Foundation Server) for the maintenance and status of the developers for development of application.

Environment:C#.Net3.0, ADO.Net, Win Forms, VB.NET7, VBA, IIS 6.0, Web Forms, Crystal Reports, SSRS, SSIS, Server Controls, ASP.NET 3.5/4.0, .Net Framework 3.5/4.0, WCF Web Services, PL/SQL, VSS, SQL Server 2008, Visual Studio 2008.

Infotech Solutions, Hyderabad, India Sep 2008 - Oct 2010

Jr.Net Developer

Hospital Management System (HMS)

Description: This is a comprehensive and integrated Hospital Management System for a Super Specialty Hospital. This package is used to computerize the activities of a servicing system. This package contains four modules. They are Administration, Patient Care System, Health Services and Auxiliary Services. Each module is having sub modules with in this sub modules will maintains storing, registering, details of joining patient details, and over all day activities maintains one particular database.

Responsibilities:

Successfully organized initial set of requirements into master list of Use Cases.

Involved in development of Web Forms, Classes using C#.NET that incorporates both N-tier architecture and database connectivity.

Created event driven Web Forms using ASP.NET and implemented form validation and used Grid view control throughout the application.

Designed and developed various abstract classes, interfaces, Inheritance to construct the business logic using VB.Net, ADO.NET and SQL.

Developed extensive Stored Procedures and Triggers in SQL Server and Developed Classes for connecting to the SQL Server Database.

Created SQL Server procedures, Triggers, Views and query optimization is done using SQL profiler.

Developed programs for accessing the database using ADO.Net to execute queries, and to manipulate the data in the database.

Designed and developed Crystal Reports based on Design Specification and the Prototype.

Used controls like Group, Cross-Tab, Picture, Pie Charts and Bar Charts in Crystal Reports.

Worked on Crystal Reports for Reports Module. Maintained Version control using Team Foundation Server (TFS).

Done Code review, Debugging, Bug Fixing, Unit testing and Integration testing and Production support.

Environment: C#2.0,.NET Framework 2.0/3.5, VB.NET7, ASP.Net 2.0/3.5, HTML4, CSS, VSS, ADO.NET, SSRS, Web Services, JavaScript,SQL Server 2005, Team Foundation Server 2008, Visual Studio 2005/2008, MS Unit.

Contact this candidate