Post Job Free
Sign in

Project Sql Server

Location:
Dearborn, MI
Salary:
60000
Posted:
April 04, 2019

Contact this candidate

Resume:

HARSHA SRI VUNDAVALLI

+1-313-***-**** ********@*****.***

LinkedIn Profile: https://www.linkedin.com/in/harsha-sri-vundavalli-203077101 SUMMARY

• Around 3 years of strong professional .Net experience in various applications based on Object Oriented Programming (OOP), Client/Server, N-tier architecture, and Web based Technology, Using Microsoft Technologies in Finance, Insurance and Healthcare domains and applications -Letter Engine, First Search and Payment Transaction reporting-banking sector for JP Morgan Chase bank.

• Worked on MVC module to build applications for banking sector which follows agile development.

• Hands-on experience in working with SQL Server in writing database queries using joins and in creating Tables, Indexes, Views, Stored procedures, Functions and Triggers and maintaining databases, report generation and fine-tuning queries for better performance.

• Experienced in all phases of Software Design Lifecycle (SDLC) like Analysis, Design, Implementation, Testing and Deployment, Test Driven Development (TDD).

• Experienced in Software Design Models such as Agile (Scrum) and Waterfall model along with Use Cases and UML diagrams.

• Extensive experience in .Net Architectural Components, .Net Framework, Database Maintenance, ASP.NET XML.

• Proficient in programming languages C, C++, C# and java.

• Comfortable in working with stored procedures, packages and functions using SQL and PL/SQL.

• Experience in leading projects by preparing designs based on the requirements and mentoring team members efficiently and successfully by paying strict attention to detail.

• Awarded Best Student Award, President Gold Medal for securing highest grades in undergrad among all the branches in the University.

• Awarded Best Employee of the year by JP Morgan Chase, the Customer of the project which I worked for in Tata Consultancy Services. EDUCATION

Master of Science in Computers and Information Sciences Sept 2017 - May 2019 University of Michigan – Dearborn GPA: 3.78/4.00

Relevant course work- Web Information Management, Data Analytics in Software Eng, Database Systems, Embedded Systems, Enterprise information systems.

GITAM University June 2012- April 2016

Bachelor of Technology in Computer Science and Engineering GPA: 4.00/4.00 TECHNICAL SKILLS

Programming Languages: .NET, C#, C, C++, Java, PL/SQL Modeling Technologies: - MATLAB, Simulink

Web Technologies: HTML, CSS, Angular2, JavaScript, XML. Databases: Oracle 11g, MS SQL Server, MySQL

Operating System: Windows, UNIX, Android

PROFESSIONAL EXPERIENCE

University of Michigan Dearborn- Teaching and Research assistant Sept 2017- June2018 Department of Computer and Information Science

• Worked on developing an attack project for a buffer overflow vulnerability using a pre-built Ubuntu 12.04 virtual machine to work on the Address Space Randomization, The Stack Guard Protection Scheme and Non-Executable Stack.

• Also worked on developing, improving the accessibility, testing and fixing errors in the attack work and helped students to work on the same.

• Effectively handled multiple projects in parallel and coordinated with different teams and resolved server issues.

• Successfully taken up different project roles at project level and worked on deliverables through all phases of Software Development Life Cycle (SDLC).

Tata Consultancy Services- Designer & Developer BFS (Banking & Financial Services) Aug 2016 – Aug 2017 Customer: JP Morgan Chase, Wilmington-USA

• Determined the feasibility of client requirements, analyzed business requirements and provided solution using agile methodology with MVC Concepts.

• Environment that was developed in MS Visual Studio.NET 2008, .NET framework 3.5, C#, ASP.NET 3.5, HTML, CSS, XML, JavaScript, AJAX, ADO.NET 3.5, MS SQL Server 2008.

• Delivered the Solution Design Document after studying the requirements critically.

• Prepared the Design application for credit card online payment functionality and delivered the Technical Design Document after the unit testing of the deliverable.

• Resolved number of production issues without the support of any support team.

• Developed XML and Master Files based on the business requirement.

• Estimated the efforts for the design cycle and delivered well within the project deadline with zero effects.

• Worked on extensive Documentation, Concept design. Tata Consultancy services – Initial training Program- Software Developer June 2016– Aug 2016

• Lead the team in the project to develop Mobile Phone Validation Tool using MVC Structure.

• Developed an enhanced layered architecture that would allow the client to validate the mobile phones form various areas with services as per the requirement and send automated campaigns to customers based on their loyalty.

• Worked extensively with .Net, MVC, XML files & ASP.NET AJAX. Technosoft solutions Private Limited –.net developing intern Jul 2015-May 2016

• Design and Development of n-tier distributed architecture using MS VS. NET, C#, ASP.NET 3.5, HTML, CSS, XML and MS SQL server.

• Developed User controls using ASP.NET and C#, SQL Server and used them dynamically in the web pages using Master pages and CSS

• Coded and optimized ADO.NET for data access and Created Custom Validation Controls for validating the data in the user Control and used ASP.NET validation controls for server-side validation.

• Environment that was developed in MS Visual Studio.NET 2008, .NET framework 3.5, C#, ASP.NET 3.5, HTML, CSS, XML, JavaScript, AJAX, ADO.NET 3.5, MS SQL Server 2008, Win 2000/2003/2007/XP.

• Extensively used ASP.NET web server controls for the Presentation tier for data modifications.

• Worked on Data Binding and Data Grid controls.

• Generated Summer Review Reports using PL/ SQL Reporting Services 2008.

• Used Edit Item Templates and Footer Templates extensively for editing and adding rows.

• Involved in bug fixing and release planning meetings.

• Created Views, Stored Procedures and Triggers of the Application database on SQL Server.

• Object oriented programming for the development of Data Access and Business objects using C#.

• Developed programs of database components including Stored Procedures.

• Involved in the database design and designed tables using T SQL.

• Used data grid controls for displaying the data.

• Used Grid View control extensively for data display, dynamic generation of rows, and user input inside template columns.

• Implemented XML, JavaScript, Web Services using C#.NET

• Performed validations using Validation Controls and Interface developing by AJAX.

• Actively participated in Team meetings and client meetings for development of the application in waterfall environment. Techno soft solutions Private Limited – Android Apps Intern May 2014 – Jun 2015

• Underwent rigorous training and several brainstorming sessions on Java, Advanced Java collections & Mobile Apps.

• Obtained hands-on experience on Java Collections, JDK, Eclipse IDE and Oracle SQL Database Connection.

• Developed a Geocoding Android Application used to get the location of a user-Uses: GPS Tracking System, Sending and receiving SMS.

• Documented Forms and Reports adhering to Apps standards. ACADEMIC PROJECTS

Adaptive Light control- Using Simulink -MATLAB and Arduino (Ongoing Project) Jan2019-April2019

• We are implementing one of the safety feature of advanced driver assistance system, ADAPTIVE HEADLIGHTS.

• Adaptive headlights are helpful when driving on winding roads at night, during twilight, or in other low-light conditions. When going on the curve, the straight beam of light could blind the vehicle coming from opposite direction. Or while cresting a hill, it is difficult to know where the road is going and whether any vehicle is approaching from other side. This can lead to dangerous accidents.

• To avoid such incidents our project would have the interaction with the sensors and the microcontroller and the actuators.

• There will be sensors to detect the amount of light (day/night/low light), to detect gradient/tilt on the road surface and to sense the turning of the steering wheel. Using Arduino board and Arduino programming a feedback control system will be implemented. LEDs and/or LCD and motors will be used (as actuators) to show the result of the control mechanism Masters Project – The Planning GURU’s - Event Management system Sep2018-Dec 2018

• The Planning GURU’s - Event Management System is complete end to end solution to cover all aspects of event management process for small and large events to be organized. This was developed using Microsoft .NET Framework, SQL Client and .NET Data Provider. The validations were done using JavaScript and xml authentications

• Planning Guru’s project has been designed in such a way it would make an adequate preparation for a system to control and monitor the process details, planning, monitoring and closing the required event life cycle.

• This project provides the event organizers to create an event, update an existing event, and take care of the details of the event tasks on the daily basis which would be helpful to calculate the amount, which would also help in notifying the customers about the events through email.

SAP Implementation Case Study Sep2018 – Dec 2018

• Implemented a thorough research and paper Works by understanding the concept of ERP system of a manufacturing company like DELL.

• Have documented the benefits of having SCM, how the success of the company is measured and all the implementation procedures which it has followed as the life cycle model.

• Understood the concept of the whole process that defines a method to implement the SAP ERP enterprise resource planning software in an organization. Documented a study process on the Managerial Accounting Methods like Activity-based accounting and Throughput accounting. With a thorough research have understood and document the process of raising a honey bee farm and how it's sold and how the business functions for each of the functional areas of operation work.

• With the help of the SAP software have worked on how the navigation works and how the sales order has been created, how does a purchasing cycle work and how do we create an invoice. with the help of the SAP software was able to create and understand the concepts of each.

Online Course Registration System Jan 2018 – April 2018

• Developed an Online Course Registration System project in.Net, which helps the students or the users to register for the online courses. It is developed with ASP.Net as a front end and c# as the coding language. MySQL is used as a database. This application has an administrator module who would look after the addition, deletion and search courses as well. Library management system Application Jan 2018 – April 2018

• Developed a Library management system Application that focuses on developing a computerized system to maintain all the daily work of the library.

• This application has many features which are generally not available in normal library management systems. To reduce the problem of the traditional manual operation which is time-consuming and inconvenient, this project proposes a library management system designed and implemented using c++ as the coding language and SQL server Online student profile management system Sept 2017 – Dec 2017

• This is a web-based application that provides students to submit their program of study in an easy and efficient manner. This application mainly allows the students to enter their personal information and to choose core as well as non-core courses of their choice. This was developed in a .NET framework and code in C# .NET. This uses SQL server 2005 as a database for storing and retrieving of data. This project is implemented using C#.NET on Microsoft visual studio 2005. Hospital Management System Sept 2017 – Dec 2017

• The software was implemented using the tools C#.NET, Visual Studio 2013 will consist of major functionalities of managing hospital records which includes managing doctor and patient details generating patient's report as well as the patient’s bill and also describes the architecture and system design.

Evaluation of software Quality Metrics of an open source Sept 2017 – Dec 2017

• Developed a series of software metrics that considers various quality indicators present in open source repository using ‘Understand’ Predict metrics of future version of the Open Source using ‘WEKA’. Evaluated the metrics of Open Source using Find Bugs’ and ‘PMD’ Store locator Aug 2015 – April 2016

• Worked on a simple store locator project using Angular 2 where this would help to locate different websites or a store we wanted to search for by clicking on the link.

• This project was created using Node and Angular CLI globally with which we can be able to create an angular project. To start the google maps we have implemented Angular Google Maps (AGM) through the app modules and then later have add CSS Styling in order to view a proper map. With the help of the angular components latitude and the longitude we can identify the location of the store. Employee Management System Application Aug 2015 – April 2016

• Employee Management System Application was designed in ASP.Net as the front-end, C#.Net as the coding language using MS SQL as a database. The main purpose of this application is to organize and manage the set of employees working in an organization Employee can update his or her details after login. Information like educational qualification, technical experience, personal information can be registered

Sports Eve Application Aug 2014– April 2015

• Desktop application designed using C#.NET, Visual Studio 2013, in which user can register a member in the Eve for various activities and events.

Online Train Reservation System Aug 2014 – April 2015

• Backend creation of a database implemented using HTML5, CSS3, PHP, JavaScript, Oracle database and MySQL, which stores the information regarding the users who have registered for the site and the train status, is displayed according to user choice. Online Portal for Library Management Aug 2013 – April 2014

• Online portal implemented using HTML5, CSS3, PHP, JavaScript, Oracle database and MySQL to enable easy and efficient management of the entire library system.



Contact this candidate