Sql Server .Net

******@***********.*** Teja Sunkara

703-***-**** Ext 122

.NET/Web Designer/Full-Stack Developer

Summary:

Around 7+ years of extensive experience in Analyzing, Designing, Development, Coding, Debugging and installation of different modules using Microsoft .NET/Front End Technologies.

Extensive experience in Object Oriented Programming Concepts (OOPS).

Experience in working extensively on Server side & Client-side JavaScript, jQuery, JSON, Ajax, DHTML, HTML/HTML5, CSS/CSS3, XHTML, XML, and VXML.

Development of 3 Tier, N-tier distributed architectures and MVC architecture.

Experienced in analyzing, designing, developing, testing, and deploying Enterprise applications using Microsoft .NET technologies such as .Net Framework, Visual Studio .NET, ASP.NET, C#.NET, ADO.NET, VB.NET, AJAX, JQuery, Ajax, WCF, WPF, WIF, WWF, a Web Services, LINQ.

Experienced in building cross browser compatibility applications using Angular.js, React.js, Kendo UI, Node.js, Knockout.JS, Native JavaScript, Typescript, Ext.js, and have knowledge in other JavaScript Frameworks like Require.js, and. Backbone.js, Ember.js.

Worked on ASP.NET Controls (Data controls, Validation controls, Common controls).

Extensive experience on implementing the AJAX features using JavaScript and jQuery.

Good Experience on MS Azure Cloud Architecture (MS Azure Pack (Private Cloud), PaaS and IaaS) assessments and experience working among technologies such as Xamarin. IOS, Android etc.

Proficient with SQL queries and good understanding of stored procedures with regards to MS SQL, Oracle, DB2 databases and Experience in SSIS, SSAS, SSRS and LINQ.

Experience in implementing web security technologies like Advanced Encryption standard (AES), Windows Identity Foundation (WIF), Security assertion markup language (SAML), OAuth2, Open Web Interface for .NET (OWIN), and Secure Sockets Layer(SSL).

Extensive experience in handling Internet Information Server(IIS), Creating and configuring the virtual directories, mapping them to physical folders and configuration of the applications for domain authentication, Data Transformation Services (DTS) in SQL Server.

Worked on HTML5 Apps, Google API's and IPAD and iOS apps.

Experience in designing User interface patterns and User interface applications with the help of Adobe products like Adobe Dreamweaver, Adobe Photoshop, Adobe Fireworks, and Adobe Illustrator CS6.

Significant experience in web development tools like APTANA STUDIO, Photoshop, Flash, Illustrator, Spring Tool Suite, Eclipse, Notepad++ and Firebug.

Experienced in using Front End editors like Dreamweaver, Espresso, Text Mate, Sublime Text2 and Microsoft Expression Web.

Strong knowledge in cross browser compatibility issues and W3C standards. Good Knowledge in using Dojo Components and integrating back-end applications with AJAX driven web 2.0 front-end using OO JavaScript framework.

Familiarity with SharePoint technologies such as SharePoint 2013/Online out-of-the-box(OOTB)

capabilities, SharePoint Designer 2013/2010, and InfoPath.

Experience in Agile methodologies such as Extreme Programming, Waterfall Model, and Test-Driven Development.

Strong communication, collaboration & team building skills with proficiency in grasping new technical concepts quickly.

Excellent analytical and communication skills with capability to handle new technologies.

Technical Skills:

Web Technologies

HTML/HTML5, CSS/CSS3, DHTML, XML, XHTML, XSLT, JavaScript, Typescript, AJAX, jQuery, JSON, Bootstrap, ANGULAR, Backbone.JS, React.JS, Angular.JS, Node.JS, Knockout.JS and Ember.JS etc.

.NET Technologies

ASP.NET, VB Script, MVC5, ADO.NET, AZURE, Web Services

Packages

VS2015, VS2013, VS2010, VS2008, Visual Source Safe, TFS, Enterprise Library, Application Blocks, and AJAX.

Web Security Technologies

Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), Windows Identity Foundation (WIF), Windows Workflow Foundation (WF) RESTFUL, SAML2.0, LINQ, Open Web Interface for .NET (OWIN), Managed Extensibility Framework (MEF), OAuth2.

Adobe Applications

Dreamweaver, Illustrator, Photoshop, Photoshop Elements

Web Servers

IIS 8.0/7.0/6.0/5.0, HTTP Web server, Apache Tomcat, WebSphere, Web logic.

Database

SQL Server, ORACLE, MySQL

Development Tools

Sublime Text, Notepad++, Eclipse, Visual Studio, NetBeans, SharePointDesigner

UML

Rational rose, MS Visio

Version Control

Clear Case, TFS, SVN, GitHub

Programming Languages

C, C++, VB, and C#

Operating Systems

Microsoft Windows

Education: Bachelors of Technology, Computer Science, Andhra University, India

Work Experience:

Sr. NET/ Full-Stack Developer

Client: CVS Health, Greensboro, NC June 2016 to Present

Description: CVS Health Corp. engages in the provision of health care services. It operates through the following segments: Pharmacy Services, Retail or Long-Term Care, and Corporate. The Pharmacy Services segment offers pharmacy benefit management solutions. NOVALOGIC, is a web-based medical application, which integrates all the insurance providers on a single platform. It helps the staff and technicians to look up for patient insurance details and claims etc. I was involved in developing this Application using C#. ASP.NET, MVC, XML, Adobe Photoshop, JavaScript technologies to include Angular.JS, Knockout.JS, Typescript, HTML5, CSS3, jQuery, Ajax etc.

RESPONSIBILITIES:

Involved in requirements gathering, and visual designing, coding, testing and deploying.

Involved in creating UX designs including mockups and wireframes for Web application using Adobe Photoshop.

Designed banners, prototypes as per the business requirements.

Implemented UI using MVC 5.0, HTML5, XML, CSS3, Typescript, Knockout JS, AJAX, jQuery and kendo Controls to create responsive web pages, developed Master Pages.

Used Angular.js for creating custom directives for re-usable components (multi-field form elements, background file uploads, etc.).

Involved in Developing, and Testing of the n-tier application using MVC 5.0, ASP. NET 4.5, Visual Studio.Net 2015.

Developed middle layer using C#.Net and ASP.NET MVC5.0.

Designed dynamic and multi-browser compatible pages using HTML5, jQuery and Typescript.

Used Cascading Style Sheets (CSS) for a unified look and feel of the application.

Used Single Page Application(SPA) with Angular JS.

Involved in bug fixing on functionality, performance and designing issues with Typescript and jQuery

Modifying the pages/responsive pages using CMS (SharePoint, Adobe CQ5).

Following agile methodologies (Scrum) and Test-Driven Development.

Using TFS to maintain the version control history during development.

Worked on Code First approach for the MVC and Entity Framework for designing the models.

Its web based N-Tier application developed using RESTful WEB Services and WIF, WWF, Data Services (Data Access Layer) as Business Service Tier and ASP.NET as Presentation Tier.

Created and used User Controls and Custom Controls.

Used Master pages, Update Panel, Rad Grid, Tab Strip, Mask Edit and Extender controls.

Implemented client-side validations using Typescript and jQuery and Angular.JS and server side ASP.NET validation.

Involved in performance tuning and query optimization.

Used forms based Authentication and role bootstrap based Authorization for security.

Used SSRS to generate reports and integrated with asp.net web page using report viewer.

Succeeded with project timelines and managed associated task lists to completion.

Design, develop, and maintain web based applications to enhance the performance and reliability of our current applications.

Maintenance/Enhancement of Project and handling/fixing bug on daily basis reported by Help Desk.

Worked directly with cross-functional teams of business stakeholders, Technical Team, and Designers to design, develop, and implement UI for websites.

Participated in Sprint Planning and User Story Grooming sessions and suggesting can-do and cannot-do in each Sprint.

Environment: .Net Framework 4.5, MVC 5.0, C#, Visual Studio 2015, HTML5, CSS3, Typescript, Angular.JS, Knockout.js, Adobe AEM, Adobe Photoshop, Bootstrap, jQuery, SharePoint, Agile, Web Services WCF, RESTful, WIF, WWF XML, XSD, XSLT, SQL SERVER 2014, SSIS, SSRS, SSAS, VSS, Telerik Kendo controls, UML and MS Visio.

Sr. Software Designer/ Developer

Client: EPICOR, Los Angeles, CA November 2014 to May 2016

Description: Epicor Software Corporation, is a global business software Company based in Austin, Texas. It provides industry-specific business software designed around the needs of manufacturing, distribution, retail, and services organizations. It also provides Customer Relationship Management(CRM), supply chain management(SCM) and human capital management(HCM) software to business customers in both Software As a Service(SaaS) and On-Premises Deployment models. The project uses ASP.NET, Javascript, Bootstrap, Azure, Angular.js, jQuery and AJAX in the front end, SQL server as a database.

RESPONSIBILITIES:

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

Converted the web sites to web applications to make Azure compatible.

Involved in deploying desktop applications, web applications, websites and console applications to the Microsoft Azure Cloud.

Extensive mobile UI design and implementation experience, including prototyping.

Built native iOS and Android applications using Android SDK, IOS SDK in Xamarin.

Implemented Angular.js Controllers to maintain each view data and Service calls using Angular Factory.

Involved in designing and development of services in C#.NET which communicate with the data base and render the data back to the client consuming the service.

Design the User Interface by coding in HTML5, CSS3, Angular JS, Entity Framework, Bootstrap to build this SPA Single Page Application.

Extensively involved in coding with Angular.js and java script to add functionalities and effects like Accordion, Infinite Scroll bar, Slider bar, Draggle/Droppable, Resizable, Progress bar.

Developed user interface by using the React.js, Flux for SPA development.

Implemented client-side Interface using React.js.

Prepared architecture plan to create the Azure Cloud environment to host migrated IaaS and PaaS role instances for refactored applications and databases.

Experience in planning and executing the application migration to a cloud environment based on Windows Azure Pack.

Utilize Photoshop for different temples design and layout standard for better resolutions.

Effectively used JQuery a concise JavaScript for traversing HTML document, event handling and AJAX interactions.

Migrated web application from Angular.js 1.6 to Angular.js 2.0 for implemented data transform and exported existing controls

Delivered engaging and visually compelling web pages with user-friendly UI that are cross-browser

rich and web compatible.

Worked with type definition files using Typescript.

Developed a WebApi and Mobile Services based back end service.

Querying the databases using the Powershell scripts.

Developed responsive, elegant views for web designing using the Angular JS 2.0 and Bootstrap Frameworks.

Implemented CRUD functionality with Entity framework in ASP.NET MVC.

Used Bootstrap 3 framework for making responsive web designing and mobile-first web interface.

Created Typescript controllers for the different pages in the views using Typescript.

Created Directives, Services, Filters using Angular.js with Typescript.

Worked with Xamarin IOS creating User Interfaces and using its UI controllers.

Used preferences with encryption for Android and adding server-side scripts to Azure Mobile Services to implement validations.

Worked with DB team for Data CRUD Operations, Stored Procedures.

Used Team Foundation Server (TFS) as version control of the source code.

Performed Unit testing and System testing and prepared required documents for testing.

Environment: AngularJS 2.0, JavaScript, Web Storm 11, Xamarin, React.JS, Bootstrap 3, TypeScript, Jquery, HTML, JDK 8, Subversion, CSS3, WEBAPI, REST, Eclipse Luna, Powershell, Equity Data, SQL Server 2012, IaaS, PaaS, Asp.Net 4.5, C#, Web Design with Cross-Browser, MVC and Entity Framework.

.NET/ Web DEVELOPER

Client: Memorial Hermann Health System, Houston, TX December 2012 to October 2014

Description: Memorial Hermann Health System is the largest not-for-profit health system in Southeast Texas. It brings together all aspects of health system-care delivery, physicians and health solutions to create a truly integrated health system. The company’s facilities include acute care hospitals, rehabilitation hospitals, cancer centers etc. The project uses HTML/HTML5, CSS/CSS3 and Angular.js in the front-end. The middle layer was designed using ASP.NET Web Forms.

RESPONSIBILITIES:

Used N-tier architecture for presentation, business, and data access Layers.

Designing web pages and mobile apps through concept, design, and implementation phases with the use of Adobe Photoshop and Illustrator.

Developed presentation layer (user interface) using ASP.Net Web forms.

Implemented several classes in the application using C#.NET and ADO.NET to call from Data Access Layer to Business Logic Layer and to code behind file.

Used Telerik controls to create SharePoint web parts.

Implemented AngularJS Controllers to maintain each view data.

Worked on SharePoint Adapter services send approved and denied orders to SharePoint site.

Created, customized, SharePoint Portal Sites, permissions for users on various sites, updated content, and created custom navigation i.e. structuring document folders, quick launch etc.

Designed and developed the UI using React.JS Framework and implemented MVC hybrid design pattern.

Designed and developed Node.js Application using Single Page Application Architecture.

Worked on CSS 3.0 making sure compatible in all the browsers as required.

Contributed to UX design of patient facing mobile application.

Worked on integration of WIF with mobile apps

Expertise in Designing and Developing Datasets per the requirement.

Involved in Report Generation using SSRS.

Worked on Single Sign On application in SAML2.0

Developed Web Services using SOAP and invoked them by using XML.

Designed and developed the View, View Model and Controller for registration screen using Knockout.JS Framework.

Worked on Single Sign On using WIF and SAML2.0.

Designed and developed data access layer using Entity Framework for security module.

Breakdown the User story effort into tasks list an estimate the tasks and feed it into TFS.

Architecting, Code construction and unit testing and code review

Writing and executing the Unit Tests and check the code in TFS through gated check in.

Provide support in code deployment to the QA, Stage, and Production environment.

Writing stored Procedures and optimizing the SQL queries.

Assigning and coordinating the work effort with the offshore team and assist the team in resolving blocks.

Environment: ASP.Net, C#.NET, ADO.NET, AngularJS, React.JS, Node.js, HTML5, CSS3, JavaScript, SSRS, SharePoint, XML, SOAP, WIF, SAML2.0, TFS, SQL.

. NET/Web Developer July 2011 to November 2012

Client: First Missouri State Bank - Poplar Bluff, MO

Description: This is mobile base application mainly focused on Mortgage Loans, Fixed income, Personal Financial Services and Wholesale Banking, offer a comprehensive array of innovative financial solutions to million customers. It has products like ATM transactions, Checking cards, Savings account and Credit cards. This was mobile web enables online transaction like online banking accounts, auto loans, etc. The project uses JavaScript, HTML5, CSS3, MVC, Angular.js in the front-end. The middle layer was designed using ASP.NET Web Forms.

Responsibilities:

Participated in requirement gathering and analysis with business users.

Used agile methodology for the software development.

Responsible for designing web pages using ASP.NET, C#, JavaScript, jQuery, Angular.JS and HTML controls.

Created Indexes, Views and Stored Procedures for quick and efficient retrieval of data using SQL Server.

Developed the application using various patterns including MVC, Singleton, Dependency Injection

Designed and Developed applications using ASP.NET, C#, WCF, MVC, SQL Server.

Worked with UI using Telerik Rad controls.

Extensively used CSS and Bootstrap for styling the HTML elements.

Developed multi-tiered ASP.NET MVC web applications using C#, HTML5, Knockout.js, CSS3.

Creating Visualization App and building real time pool application using Angular.js

Extensive use of Web Services, WCF Services and SOAP protocols.

Developed new features and maintained modules on n tier, multi-server, e-commerce web applications.

Developed back-end in C# using Entity Framework and LINQ to Entities.

Created Layout Pages for consistent look and feel for all web pages.

Created Cascading Style Sheets (CSS) to attain uniform style patterns throughout all the pages in the application.

Designed and developed intranet web applications using JavaScript and CSS.

Used AJAX controls like Calendar Control, Accordion, Modal Popup and Tab Controls in order to improve the performance and appearance of the application.

Implemented Caching and State Management strategies to improve overall performance of the application.

Used LINQ to retrieve information from XML data files and database.

Responsible for migrating data from source to destination table using SSIS packages.

Developed Reports used with SQL Server Reporting Services.

Used Team Foundation Server (TFS) to maintain the version control history during development.

Used AGILE development Methodology to ensure teamwork, collaboration and process adaptability throughout the life-cycle of the project.

Conducts 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.

Created SSIS packages for importing data from various data files/excel to the data source

Used Team Foundation Server for Source Code Control, project related document sharing and team collaboration.

Performed Unit Testing using Visual Studio integrated testing tools.

ENVIRONMENT: C#, .Net Framework 4.0/4.5, ASP.NET, HTML5, XML, JavaScript, JSON, Angular.js, Knockout.js, CSS3, XAML, AJAX, MS Visual Studio, SQL Server, TFS, SSIS, SSRS and IIS7.

. Net/ Web Developer

Client: HSBC Bank – India July 2009 to June 2011

Description: HSBC Bank is one of the largest financial institutions that offer services like banking, investment, and insurance. The bank provides online banking to support its renowned customers. The current application is a part of online banking that a customer uses to set up his e-bills payments, view online statements and do many other online activities. The application also supports intra bank transfer for a given customer. I was involved in developing this Application using C#. ASP.NET, WCF, XML, Web Services, Adobe Photoshop, JavaScript technologies to include HTML, CSS, jQuery, Ajax etc.

Responsibilities:

Involved in Coding, and Testing of the 3-tier web application using C#.NET, and .Net Framework.

Implemented several classes in the application using C#.NET and ADO.NET to call from Data Access Layer to Business Logic Layer and to code behind file.

Implemented validations using ASP.Net validation controls and JavaScript to perform client-side validations.

Developed fast loading images using Adobe Photoshop CS3.

Developed Web Services using SOAP and invoked them by using XML Used ASP.NET AJAX to develop the web pages.

Used XSLT to convert the XML documents into the HTML pages.

Used Caching Services (output level and fragment level) for better application performance.

Maintained the User Session using State Server Configuration.

Implemented form based security, checked the user login against Active Directory (internal users) or Database (external users).

Creating Queries and joins on multiple tables, Functions and Triggers using LINQ in SQL for inserting/updating/ deleting the data into the relational tables.

Implemented forms based cookie-less authentication and role based authorization for secured access to application.

Worked on Trace Viewer to develop test plans and implemented unit and system testing to ensure error-free application.

Environment: Visual Studio.Net, C#.NET, IIS, ASP.NET, AJAX, XML, SOAP, Adobe, Web Services, HTML, Windows NT, MS SQL Server and GitHub.

Contact this candidate