Sql Server Software Engineer

SIRISHA TANNERU

M: 469-***-****

Email: ******************@*****.***

Experience Summary

Having 7+ years of IT experience in software design, development and implementation.

Strong skills in .Net Framework 4.5/4.0/3.5/2.0, ASP. NET, VB.Net, C#, ADO.NET, SQL Server 2010/2008/2005/2000, MVC, WEB API(2.0)

Developed C# applications from scratch with minimal supervision.

Designed some web applications using HTML, HTML5, CSS, CSS3, Angular JS

Designed, developed and produced solutions to software reconfiguration to comply with, HIPAA 5010

Having hands on experience in using AJAX toolkit and involved in development of AJAX Based Web Applications.

Experience with source code management systems like SVN.

Strong understanding of object oriented programming (OOPS) principles.

Proficient in all phases of the Software development lifecycle (SDLC).

Experience in SQL Server, writing database queries using joins, Indexes and creating Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using T-SQL, Maintaining Database,

Hands on Entity Framework 4.

Experience in Query Optimization.

Experience in reporting and analysis using Crystal Reports with the .net environment.

Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML.

Developed and Debugged Single web Page Applications.

Experience in using Tortoise SVN, TFS(2012) for Version Controlling.

Interaction with Client and gathering requirements, analyzing and working with team accordingly

Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual. Strong team player with excellent inter-personal, written and oral communication skill.

Good Understanding on IIS configurations

Hand of experience on Angular JS

I have 1 year of front end development experience in Angular JS

Have a good Heath Care Domain Knowledge.

Hands of experience on continues integration

EDUCATION:

Bachelors of Technology (Informational Technology) completed in May 2008 from Jawaharlal Nehru Technology University, A.P.

TECHNICAL SKILLS:

Operating System

Windows Flavors

Languages

C, C++, VB.NET, ASP.NET, .NET Framework,MVC,WEB API, Web services, C#,WCF and WPF

Databases

MS SQL Server 2010/2008/2005/2000

Tools

Crystal report,Entity Framework 4

PROFESSIONAL EXPERIENCE:

Currently working as Dot Net Specialist in ViaTech Publishing, Dallas, TX from 29th Feb to till Date

Worked as Module Leader in R Logic Technologies, Bangalore from 01 Nov 2011 to March 2015

Worked as Software Engineer in Mind Tree from July 2008 to Oct 2011

ACHIVEMENTS:

Received Q2 2013 Spot award for the outstanding performance in project execution in R Logic Technologies, Bangalore

PROJECT PROFILE:

Project #1

Title : Ogrs Fulfillment

Client: UHG

Location: Dallas, Texas

Operating System: Windows XP

Tools: C# .NET, Visual Studio 2008, ASP.Net, ADO.NET, Crystal Reports, Sql Server 2008,MVC 4,Angular Js and WPF.

Team Size: 7

Role: Dot Net Specialist/Team Lead

Duration: Feb 2016 to Till Date

Project Description

Ogrs Fulfill is a website. Where Approval Page, Users, QC page, Checkout Page, Checkout Summary, Favorite’s Etc… are the modules. In approval page according to customer requirement we customized the page like depending on the roles of the person accessing the page can approve or cancel the order. We have made changes to the password depending on the HIPAA rules.

Role and Responsibilities

Interacted with business analysts for Need Analysis and to define Business and Functional Specifications.

Made some changes according to HIPAA 5010.

Interacted with Clients for Requirement Gathering and Project Maintenance.

Designed and developed the application frontend in ASP.NET 3.5, C#.Net 3.5.

Worked on the back end programming using SQL Server 2008R2.

Check In, Versioning control in the SVN tortoise.

Created User stories and tasks in the Rally.

Worked on JavaScript, AJAX and JQuery library for client side programming.

Involved in Daily Scrum meeting in agile methodology to update the onshore team.

Involved in the planning and fixing of security issues identified by the-fortify static code analyzer.

Created UTC and performed unit testing of the code.

Involved in the bug fixing and creating required artifacts like root cause analysis, technical approach document

We are migrating the project from Web Applications of asp.net to MVC.Net.

We are developing our front using HTML5, CSS3, Angular JS.

Project #2

Title : Force Routing System.

Client: R Logic

Location: Bangalore

Operating System: Windows XP

Tools: C# .NET, Visual Studio 2008, ASP.Net, ADO.NET, Crystal Reports, Sql Server 2008, MVC 4

Team Size: 7

Role: Module Leader

Duration: June 2013 to March 2015

Project Description

In FRS system Inventory management, Production management, Customer management, Logistics management are the modules. In Inventory management material request, material approval and material issuing are sub modules. In Production management according to customer requirement the FRS system is customized. FRS and SAP has common Data base. Inflow and outflow modules are related to SAP. Routing algorithm is configured in FRS system based on customer process flow. FRS Access to users are given based on their level of access rights system credentials are provided.

Role and Responsibilities

Interacted with business analysts for Need Analysis and to define Business and Functional Specifications.

Designed and developed the application frontend in ASP.NET 3.5, C#.Net 3.5.

Worked on the back end programming using SQL Server 2008R2.

Check In, Versioning control in the SVN tortoise.

Created User stories and tasks in the Rally.

Worked on JavaScript, AJAX and JQuery library for client side programming.

Involved in Daily Scrum meeting in agile methodology to update the onshore team.

Involved in the planning and fixing of security issues identified by the-fortify static code analyzer.

Created UTC and performed unit testing of the code.

Involved in the bug fixing and creating required artifacts like root cause analysis, technical approach document

Project #3

Title: R-Logic Intellectual Management System (RIMS).

Client: R Logic

Location: Bangalore

Operating System: Windows XP

Tools: C# .NET, Visual Studio 2008, ASP.Net, ADO.NET, Crystal Reports, Sql Server 2008, Angular JS

Team Size: 8

Role: Sr. Software Engineer

Duration: Nov 2011 to May 2013

Project Description

RIMS is a system of controlling FRS system. FRS user creation and user credentials are configured in RIMS. Business Logic of customers are configured in the RIMS application.

RIMS is mainly used by the managers to view the parts status, the station in which currently the parts are available, and to generate the reports like shipment report etc. It is also used to give the Job allocation to the respective employee for the parts. Logistics Delivery Chalan are created In RIMS. Generating Reports based on business requirement.

Role and Responsibilities

Interacted with business analysts for Need Analysis and to define Business and Functional Specifications.

Designed and developed the application frontend in ASP.NET 3.5, C#.Net 3.5.,MVC 4

Worked on the back end programming using SQL Server 2008R2.

Check In, Versioning control in the SVN tortoise.

Created User stories and tasks in the Rally.

Worked on JavaScript, AJAX and JQuery library for client side programming.

Involved in Daily Scrum meeting in agile methodology to update the onshore team.

Involved in the planning and fixing of security issues identified by the-fortify static code analyzer.

Created UTC and performed unit testing of the code.

Involved in the bug fixing and creating required artifacts like root cause analysis, technical approach document

Project #4:

Title: Demand Chain Management

Location: Bangalore

Client: J C Penny, USA

Role: Software Engineer

Environment: C#. Net, Asp.Net, Net, Ado.Net, VB.Net,SQL Server 2008 R2

Duration: Dec 2009 to Sep 2011

Demand Chain Management: The DCM application is used to deliver basic merchandise to JCP stores which contribute 34% of Merchandise sales $. The reporting for DCM is currently created and maintained as ad hoc by the Merchandise Operations department.

This report suite which consists of 32 reports needs to move to IT where it can be maintained and supported in a production environment 24/7. This project supports the company initiative to improve merchandise relevancy by helping the Allocation associates determine the correct offering of products in the right place at the right time in the right quantities.

Responsibilities:

Responsible for analysis, design, coding and testing the application

Undertake Enhancement Change Requests that involves coding in C#, ASP.Net, ADO.Net, SQL Server

Involved in complete SDLC doing OO Analysis and Design using Visio (UML)

Involved in both low level and high-level design of the application. And creating flow charts, data flow diagram.

Involved in Design and Development of Case Management Module.

Created Web Forms using ASP.Net, C#.Net

Analyze the work and prepare business requirements, technical design/specification, test plan documents.

Developed Win Forms user interface projects with initial layout and base controls

Developed code behind files data access components and classes in VB.NET, C#.

Designed and developed a Web Interface/GUI in ASP.NET.

Designing the Layout of User Interface using Visio and class diagrams using UML.

Developed stored procedures, triggers and DTS in SQL Server 2000 in underwriting database.

Testing the application for performance issues and data integrity using NUnit.

Involved in integration and deployment of .Net components.

Writing Test Cases Using N Unit.

Designed and implemented application using .NET Framework 3.5

Created Reports using Crystal reports 9.0.

Environment: C# .NET, Visual Studio 2008, ASP.Net, ADO.NET, Crystal Reports, SQL Server 2008 and Windows XP

Project #5

Title: Marketing

Location: Bangalore

Client: Branch Banking and Trust, USA.

Role: Software Engineer

Environment: C#. Net, Asp.Net, Net, Ado.Net, SQL Server 2008 R2

Duration: July 2008 to October 2009

Marketing is a project under BB&T. The system begins with source data from existing extracts and third party data, which will be extracted and will be filtered, by using different types of search conditions. The data will be loaded onto the webpage by using Marketing Database, Client grouping database, and Transaction database

Responsibilities:

Design and developed an Window pages using C#.net.

Involved in all the phases of the applications development.

Interacting with Clients for analysis of the specifications provided by them.

Delivering the trials without any defect.

Developing SQLs whenever the customer needed

Contact this candidate