Sql Server .Net
Resume:
Pranith
acs0ri@r.postjobfree.com
SUMMARY
1.8+ years of IT professional works experience in Software Architecture, designing, development and implementation of n-Tier Client/Server Web and windows based Application domains using Microsoft .NET framework3.0/3.5/4.0/4.5.
2.Well Versed in all phases of System Development Life Cycle (SDLC) from investigation of initial requirements through analysis, design, development implementation and documentation Support.
3.Development Experience on Various Microsoft Technologies like C#, ASP.Net, ADO.Net, MVC 2.0/3.0/4.0/5.0, LINQ, Web Services using WCF, Windows services.
4.Experience in UI development, UX design, Frontend development, Flash with Action script, rich user interface design, development, documentation, web specifications, standards, media (screen, mobile, touch interface) compatibilities, application architecture, visual design, wireframes, project and team management.
5.Extensive knowledge in web Designing and Development of user interfaces using HTML/HTML5, XHTML, CSS/CSS3, JavaScript, Angular.JS, Node.JS, Knockout.JS, JQuery, Bootstrap with in-depth knowledge of the architecture and the framework.
6.Had developed Single Page applications using the AngularJS framework.
7.Proficient in RDBMS concepts including writing Stored procedures using TSQL in MS SQL Server 2005/2008/2008R2/2012 and good experience on PL/SQL in Oracle 8i/9i/11g and also Access to include Physical Design and Logical DB Architecture, Backup, Restore, Performance tuning and Data integration.
8.Extensive experience in using SQL Management Studio, SQL Server Business Intelligence Solutions like DTS (Data Transformation Services), SSRS (SQL Server Reporting Services) &Crystal Reports, SSIS ( SQL Server Integration Service Packages), SSAS (SQL Server Analysis Services)
9.Worked on .net third party tools like Telerik MVC controls, Kendo UI Controls, DevExpress and JQuery UI controls
10.Good Exposure to Version control tools TFS (Team Foundation System), Gitlab, Tortoise SVN, VSS (Visual Source Safe).
11.Good experience of working with Agile Methods, Scrum and Waterfall technologies.
12.Good Knowledge and experience in using design frameworks like MVC, MVVM, and MVP and design patterns like Singleton, Observer, Façade, Abstract Factory and Factory.
13.Extensive experience in OOAD Technology developing Use Cases, Sequence Diagrams, Class Diagrams and Deployment Diagrams using Enterprise Architect and MS Visio.
14.Planned and Organized testing phases including Unit testing(NUnit) &Integration testing, writing Test cases, generating Test scripts and reviewing test results & taking corrective actions, Bug analysis and fixes in Web-industry standards, trends.
Technical Skills:
MS .Net Technologies
Microsoft .Net Framework, ASP.Net, MVC, Silverlight, Web Forms, Win Forms, WPF, WCF, ADO.Net, LINQ
Web Technologies
Web Services, WCF, SOAP, WSDL, AJAX, XML, XSL,XSLT
Web Servers
IIS 5.0, IIS 6.0, IIS 7.5
Programming Languages
C#, JavaScript, VBScript, HTML, CSS, DHTML, PHP
Client side Technologies
JavaScript,, JQuery, KnockOut.Js, AngularJs and Node.JS
Frameworks
Microsoft .Net 4.5/ 4.0/ 3.5/3.0
Databases
SQL Server 2012/2008/2005, Oracle 10g, 11g, PL/SQL,
BI tools
SSIS, SSRS, SSAS
Version Controller
TFS, Microsoft Visual SourceSafe
Database Tools
SQL Server Query Analyzer
Software Packages
MS-Office 2003/ 07/10/13
Other Tools
ERwin, MS Visio, MS Project, Git
Operating Systems
Windows NT/95/98/2000/2008/2012, XP, UNIX, Linux
Methodologies
Agile and Design Patterns-Factory
Professional Experience:
MONSANTO, Chesterfield, MO March'2015 – Till Date
Role: .NET/UI Developer
Description: Monsanto is the leading Agriculture product based Company which is headquartered at Creve Coeur, MO. My project is to develop a single developer web application for the seed request fulfilment. This application is built using HTML5, Bootstrap, JavaScript, and AngularJs for the UI and MVC WebApi services for creating the service layer and SQL Server 2008 and Oracle Sql developer 4.0 in the backend. The application was developed using the most current technologies for creating a responsive UI that can be viewed on Desktop, Tablet, or Smartphones. AngularJs and JQuery, Java Script were used as client side technologies to make the application real-time and provide two way data binding to increase the user responsiveness and intractability of the application in real time. The application leveraged REST Architecture for making the get and post calls to get the data from and to the database using MVC WebAPI in the service layer.
Responsibilities:
Actively involved in the requirement gathering from the user.
Used Target Process to plan and track the project tasks.
Actively involved in scrum meetings for requirement analysis, task analysis, and progress discussions.
Designed web pages and wireframes for applications using MS Visio.
HTML5, Razor, JSON, HTML helpers Web-Server controls were used to create View Engines.
Bootstrap is used for making the pages responsive with the changes in User Interfaces
AngularJS was used to make the web applications dynamic and is used for making DOM manipulation.
Designed GUI using the HTML, JavaScript, CSS, Jquery, AngularJs and Custom Controls.
Involved in developing client side scripting using Angular.Js.
Developed ASP.NET, MVC application in Test Driven Development environment.
Worked with various AngularJs Expressions, Directives, Filters and Controllers.
Worked with web services when the service requested is of HTTP.
Implemented and Deployed SSIS packages for Data migration from traditional platforms.
Have used the Cordova framework to build the barcode scanner and ionic framework to integrate the application into the mobile.
AngularJs was used for creating the controllers, Factories, Services, Custom Directives.
Custom validations were done using JQuery and JavaScript.
Designed data access layer using Entity Framework model and successfully created Entity Models.
Worked with the SQL Server 2008 and Oracle sql developer 4.0 as database.
Used LINQ to Sql writing data access classes, complex T-SQL Stored Procedures, triggers, views to capture and modify data.
Used Gitlab and Tortoise SVN for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Environment: MS Visual Studio 2013 and 2013 IDE, C#, ASP.NET, MVC 5.0, SQL Server 2008, ADO.NET, JavaScript, Query, AngularJS, Entity Framework 5.0, XML, Bootstrap, HTML5, AJAX and Windows 2012 Server, Cordova and ionic framework.
PEPSICO, PLANO, TX Feb'2014 – Mar’2015
Role:.NET/UI Developer
Description: PepsiCo is one of the leading food and Beverage Company with variety of products which is headquartered at Purchase, New York. The company is in over 200 countries whose net revenue is around 43.3 billion every year. My project is to develop a web application to maintain the company distribution list and calculate the total amount of products sold by each distributor and then calculate the profit of the company. This application is built using HTML5, Bootstrap,, JavaScript, JQuery, AngularJs, aapa Telerik Kendo UI Controls, MVC WebApi, WCF for creating the service layer and SQL Server 2008 for backend database. The application was developed using the most current technologies for creating a responsive UI that can be viewed on Desktop, Tablet, or Smartphones. AngularJs and JQuery, Java Script were used as client side technologies to make the application real-time and provide two way data binding to increase the user responsiveness and intractability of the application in real time.
Responsibilities:
Involved in peerreview meetings to analyse, verify and validate the Design, Code and proposed solutions to the business issues.
Using agile methodology for software development.
Actively involved in scrum meetings for requirement analysis, task analysis, and progress discussions.
Following Onshore/Offshore model for project development.
Designed web pages and prototypes for applicationsusing MicrosoftExpression Blend and created wire frames using MS Visio
Implemented the Object Oriented programming concepts in developing ‘Tracking’ and ‘Statistical analysis’ modules using ASP.Net MVC 4.0.
HTML5, Razor, JSON, HTML helpers Web-Server controls were used to create View Engines.
Bootstrap is used for making the pages responsive with the changes in User Interfaces
AngularJS was used to make the web applications dynamic and is used for making DOM manipulation.
AngularJs was used for creating the controllers, Factories, Services, Custom Directives
JavaScript, JQuery was used to develop custom validations to validate the various inputs related to power components and their CLLI inputs given by users.
Security Form Based Authentication and Role Based Authorization were implemented in ‘Storing equipment’ module to identify Administrator and give him privileges to enter new equipment and their manufacturer and location details.
Designed data access layer using Entity Framework model and successfully created Entity Models.
SQL Server 2012 was utilized as the data repository.
Used LINQ to Sql writing data access classes, complex T-SQL Stored Procedures, triggers, views to capture and modify data.
Used Visual Source safe for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
Used Crystal Reports to generate reports and create charts, tables which are used for thorough analysis of performance of Power components.
Environment: MS Visual Studio 2012 and 2013 IDE, C#, ASP.NET MVC 4.0, SQL Server 2012, ADO.NET, JavaScript, Query, AngularJS, WCF, Entity Framework 5.0, NUnit, XML, Bootstrap, HTML5, AJAX and Windows 2012 Server.
CenturyLink Technology Solutions- Dublin, OH, Oct’2012 – Feb’2014
Role: .Net/UI Developer
Description: CenturyLink Technology Solutions brings together the technology, services and expertise that power some of the largest brands in the world. A global leader in cloud and managed solutions, CenturyLink Technology Solutions helps make businesses more agile, secure and sustainable with end to end solutions that deliver bottom line results. My project was to develop an intranet scorecard application which generates the User Interface for partners and Account team. . The Partners will be able to see their account and its subsidiary accounts compliance status, Revenue & Competency status using the Scorecard portal screens. Scorecard Portal will fetch the compliance data from the database and display the reports on the screen. My role was to design, develop and deliver a web portal that allows the users to check the competencies, progress, rating and expiry. I have designed presentation pages using ASP.Net MVC, Razor, HTML, JavaScript, JQuery, CSS and JSON as the data transfer methods from Controller to Views. Used KnockOut.JS for creating Dynamic views and developing MVVM pattern for inducing two way binding. Used WCF for creating Business Service Layer and Entity framework 5 for creating Data Access Layer. We have used Oracle 10g as the backend and SQL server for session control.
Responsibilities:
Designed and developed intranet web application using ASP.NET MVC framework.
Designed User Interface for the project using HTML and CSS.
Maintained existing UI Applications and upgraded them using CSS 3, jQuery,AJAX, JavaScript, JSON and HTML 5
KnockOut.JS was used for the Form Validations attaching new behaviour to DOM elements.
Designed UI using the HTML5, JavaScript, CSS, jQuery, Knockout.Js, Bootstrap (Twitter- Type ahead).
Developed Web API MVC application using C# .Net
Used Knockout.js to create rich, responsive display and editor user interfaces with a clean underlying data model.
Worked with business system analyst to understand the requirements to ensure that right set of UI modules have been built
Developed application level code to perform client side validation using jQuery and JavaScript
Wrote jQuery function while implementing various UI Screens across the whole web application (both consumer facing as well as internal application)
Involved in writing application level code to interact with Controllers and Web Api’s, using AJAX, JSON and XML.
Used JQuery controls and Kendo UI controls for creating Rich User Experience. And creating Result Grids, Modal Windows, Date Pickers, Graphs and other controls.
Developed, Maintained, enhanced and recommend solutions that best suit the business and technological needs from the Enterprise application standpoint
Defined technical requirements based upon business requirements
Strong communication, analytical and interpersonal skills working within cross-functional teams
Worked on cross browser compatibility issues and fix the bugs pertaining to various browsers
Built complex desktop-style UI using HTML, CSS, JavaScript and AJAX, including configuration wizards and interactive reports
Environment: C#.Net MVC, KnockOut.JS, BootStrap,HTML, XHTML, CSS, JavaScript, jQuery, AJAX, XML, JSON, Adobe Dreamweaver and Adobe Photoshop,
Sun Trust Bank, Atlanta, GA Jun’2011 – Sept’2012
Project: Online Banking Application
Role: .NETDeveloper
Description:Loan Processing Systemis an applicationwhich helps the employeesin applying, processing a loan request. Thissystem wasbuilt to help the usersin Loan processing. Aprospective client can use this system to decide the proper loan suitable for him/her and also apply for it. Client can use the system to monitor the whole loan-processing task, to make a decision about the loanand to automate other thingslike periodic payments. The system was engineered using .NET framework with C# as coding language,Angular JS,MVC for creating User Interface and the backend database was developed and maintained on Oracle.
Role and Responsibilities:
Designedand developedintranet web application using ASP.NET MVC framework.
Designed UI using jQuery, jQuery UI and CSS.
Created dynamic and interactive user experience with extensive use of AJAX and jQuery.
Displayed data efficiently using functionalities provided by JQGrid API.
Decreased the page response time using the server side asynchronous JavaScript, AJAX and JSONtechnique.
Responsible to improve the responsiveness of the overall application using HTML5, Angular.Js.
Used JavaScript for client side validations.
Created efficient and compatible service calls to different applications to transfer data using WCF.
Used Entity Framework for working with Relational data and LINQ for updating the data.
Used Razor Viewsto enable fast coding and quickly integrate server code into HTML markup with a minimum of keystrokes.
Used Telerik controls toolkit for rich user interface.
Used Repository Pattern for data persistency and easy management ofdata flow to and from the database.
Developed Stored Procedures, Views and Functions c and optimized using indexes.
NUnit were used for unit testing.
Used JIRA for tracking defects and business requirements.
The Agile methodology was used throughout the project, with a 20-minute stand-up meeting every morning, regular retrospective meetings, Test Driven Development (TDD) was also enforced and code reviews were done before each commit.
Fixed issues reported by QA and UAT teams.
Environment:jQuery, .NET Framework, Visual Studio, ASP.NET MVC3, C#, AJAX, Automapper, HTML/HTML5 and Angular.JS, NUnit, Sql server.
Client: Lincoln Financial Group, Philadelphia, PA Sep’2010 – May’2011
Role: Web Developer
Project: eLSPT (Electronic Link Solutions Planning Tool)
Description: Lincoln Financial Group (LFG) is a diversified financial services organization, headquartered in Philadelphia, PA. Lincoln companies offer financial, retirement and estate planning services and a variety of financial and investment products in five distinctive business areas - insurance and annuities, individual and group retirement plans, group benefits, mutual funds and investment management. ELSPT provides the Planners with the ability to propose, plan and compare new Portfolio with the existing one. Provide various planning and diagnostics tools to facilitate planners in proposing various investment plans for the investors.
Responsibilities:
Designing of Web Pages for ‘Online Personal Banking’ module using Visual Interdev and writing client side validations using JavaScript.
Developed Custom client side Validations using JavaScript, JqueryUI to validate the customer input and detect the client browsers when users register for ‘Online Banking’ and ‘Online Bill Payments’.
Developed custom controls, user controls using C#, ASP.Net which were used through the development of application.
Developed & maintained Web Forms with ASP.Net, Silverlight and C#.Net.
Developed Silverlight Components for showing Rich UI Reporting details for Super users and embedded them into ASP.Net page.
Developed advanced user interfaces using JQuery and Silverlight.
Implemented Forms Based Authentication and Role Based Authorization to give a privilege to ‘Customers’ to edit their personal information and view their transactions and pay their bills and ‘Admins’ were given a privilege to access details of all customers and modify them.
Created Complex Stored Procedures and triggers to perform automated rules, for capturing Customers and their Account details and updating to related tables.
Developed XML Web services to get the transactions data of customers and displayed them to users using ADO.Net components Grid View.
Also consumed the Web Service of USPS to track/validate the address given by user in ‘Registration’ and ‘updating personal Information’.
Responsible for creating DLL for report design in HTML format and calling them from ASP pages to provide more security for reports.
Created Stored Procedures, triggers and views for the data access are implemented and tested using Oracle 9i, SQL Scripts and SQL Server 2008.
Used Crystal reports control in .Net to display multiple level totals, Monthly Transaction reports, charts to analyze data for customers.
Used SQL Reporting Services to create, manage and deliver reports in tabular, graphical forms from data sources for Higher Level Managers to analyze them easily.
Environment:Visual Studio 2005/2008, .NET Framework 3.5, C#, ASP.NET, Silverlight, C#,VSTS,Web Services, SOAP Restful services WPF, Java Script, JQuery, XML,T-SQL,Oracle9i, SQL Server 2008, Win forms, ADO.NET, HTML.
Client: ICICI Bank, India May’07 – Aug’10
Project: Recovery Tracking System
Role: .Net Developer
Description: The major activity of the organization is to involve financial recovery services to Master Card which is a credit card issuing agency. Recovery tracking system application records all the recovery information about when the customer is contacted and this information will be passed to the respective agent in a timely manner. The process of tracing all such activities is the purpose of the application. For developing the application ASP .Net, ADO .Net, MS SQL Server 2005, C#, HTML, CSS, JavaScript were used. The application involved collecting information, analysis and presenting of the information from a XML file generated as part of existing web service.
Responsibilities:
Participated in collating requirements, design and prototyping the initial design.
Design and development class diagrams using UML methodology.
Worked on claims processing by routing claims and other tasks to the right person at the right time.
Used ASP.NET for front-end and C# in the Business and Data Access Layers to write Validation objects.
Developed Web Forms using C# and ASP.NET.
Developed Windows Forms application in .net framework.
Design and develop databases, Tables, Stored procedures, triggers, cursors, using SQL Server 2005.
Worked on Cascading Style Sheets (CSS) for styles.
Used JavaScript for client side validations.
Used ADO.NET for database interactions using Data Adapters, Data Reader and Dataset.
Developed and consumed Web Services using C# from web client.
Designed Web Forms using ASP and VB.NET.
Interface with Application Users and other team members to solve data issues and customer requests.
Used Execution plans and query optimization techniques for performance tuning of SQL in reports.
Built distributed application with .net remoting.
Used SQL Query Analyzer for troubleshooting SQL queries.
Implemented MVVM architecture.
Used SVN for configuration management.
Environment: ASP.NET, C#, ADO.NET, VB.NET, T-SQL, Microsoft Visual Studio.NET 2005, XML, XSL, HTML, CSS JavaScript, Web Services, WSDL and MS Visual Source Safe.
Contact this candidate