.Net,sqlserver

Hema Devi Banala

Contact: 626-***-****

E-Mail: **.****@*****.***

SUMMARY:

Full stack development specialist with strong knowledge of .NET technology (ASP.NET, C#, VB.NET); front-end tools (JQuery, JavaScript, CSS, HTML), relational databases and tools (SQL Server, ORACLE, DB2, SSIS, SSRS) and numerous third-party tools. Experience includes proposing solutions for complex projects, delivery of high quality products in time, software design, development, maintenance, testing and implementation.

SKILLS:

NET technology: Versions 1.1 – 4.5, ASP.NET, C#, VB.NET, MVC, MVVM, WCF, SSRS, SSIS, Entity Framework and Web API.

Languages and tools: HTML, JavaScript, JQuery, Angular JS, LINQ, CSS, SQL, TSQL, PL/SQL, IIS, TFS, SVN, GITHUB.

Databases: SQL Server 2005/2008/2014, ORACLE, DB2, MS Access

Operating Systems: WINDOWS

EDUCATION:

2004 Bachelors of Technology in Computer Science

J.N.T.U University, Hyderabad, India.

PROFESSIONAL EXPERIENCE:

CVS Caremark, Buffalo Grove, IL 06/17-09/17

Sr.Net Developer

Responsible for implementing solutions for Mail Order and Pack station. The systems handles the prescription drugs are available through our preferred mail order pharmacy. The system is written in ASP.NET MVC, C#.NET and interface SQL Server as a database.

Develop modules to check the tote weight and to select best packing material based on the type of the medication using ASP.NET MVC, C#.NET and SQL server.

Redesign existing application to implement JQ grid. The application was written using ASP.NET MVC, C#, Web API.

Added new functionality to SSIS package that process data from SQL Server and creates .csv files to shared location and scheduled job to run on a daily basis.

Make required modification to existing vendor source code and maintained in TFS.

Perform unit testing and handled production deployment.

Technologies: HTML, JavaScript, CSS, JQuery, JQ grid, .NET, ASP.NET, C#, MVC, Web API, Entity Frame work SQL Server 2014, SSIS, TFS.

One West Bank/ CIT Bank, Pasadena, CA 07/13-05/17

Sr.Net Developer

Played key role in design, development, testing, and implementation of Branch Payment System to allow Branches to accept the payments from customers, allow managers to verify and approve the payments and easy loan search screen and admin screen. The application was developed in .NET 4.5 frame work (ASP.NET, C#).

Created SQL Server stored procedures and functions.

Developed SSRS reports to generate the payment history for selected period.

Enhanced existing application to create n tier architecture for Internet hosted application.

Gathered business requirements and created and scheduled SSIS packages and jobs to maintain the database.

Created SSRS reports and deployed into SharePoint for Business access and created subscription to run few reports on daily basis.

Handled datacenter migration from West to East.

As a team member participated in setting up SFTP environment for data transfer among the vendors and the client.

Prepared unit and system test cases.

Technologies: HTML, JavaScript, CSS, JQuery, .NET 4.5, ASP.NET, C#, MVC, Entity Frame work, LINQ, SQL Server 2012, SSIS, SSRS, TFS and GITHUB.

JP Morgan, Newark, DE 09/12-07/13 Sr.Net Developer

Developed, tested and implemented and the administration of user interfaces and tools using VB.net. The tools provide the ability to process data and upload the results to the Mainframe Systems.

Assisted with automation of private banking department’s manual processes by supporting/fixing VB.net code to speed processes and maximize accuracy.

Developed modules to bind windows applications to display data from database.

SQL Server stored procedures and functions.

Create Unit tests.

Gathered requirements from business analysts

Technologies: VB.NET, SQL Server 2008 R2, SSRS, XML, AJAX, SVN.

First Data, Melville, NY 02/12-09/12

Sr.Net Developer

Developed and implemented project management tool designed to facilitate collaboration across CCIS teams. This tool supports a process theme of information sharing across functional areas and employing automation and integration whenever possible to reduce process steps and time and ultimately reduces time to revenue for implementations and conversions

Developed application using Visual studio 2010, Asp.net and C#.net.

Involved in Database design and table creation.

Developed SQL server Report Models and deployed into SharePoint server for Adhoc Reports

Created SSIS packages to load the data from access DB, excel, .csv files to centralized SQL server.

Create Unit tests.

Gathered requirements from business analysts.

Technologies: ASP.NET, C#, SSIS, SSRS, SQL Server 2008, TFS.

Northern Trust, Chicago, IL 07/11-02/12

Consultant

Developed application is to produce a repository for cash flow data independent of IDP. This will be accomplished by building upon the IDP-RTT development work to push cash flow data in real-time and de-coupling the consumers from RTT’s database.

Created stored procedures, functions and views to exchange data between application and database.

Made enhancements to existing IDP modules.

Developed Crystal Reports per customer request.

Technologies: .NET, HTML, JavaScript, AJAX, ASP.NET, C#.NET, XML, SQL Server, Control M tool, Crystal Reports.

Northern Trust, Hyderabad, India 08/10-07/11

Developer

Developed applications to fetch all the details of the affected shareholders of a corporate action and distributing the amounts to the shareholders using Visual studio 2003, 2008, WCF, WPF, C# and Crystal Reports XI and Mainframe database as backend.

Developed new modules for Announcements, Distributions, Receivables, Reversals and RCCI.

Made enhancements to the code (ASP.NET/C#) and stored procedures of existing GCA application.

Unit testing for the enhanced code along with the unit test Scripts and test logs.

Provided Business transition to trainees.

Developed and implemented web services to pass data between web site and internal system.

Prepared unit and system test cases and technical documentation.

Technologies: Visual studio 2003, 2008, WCF, WPF, C# and Crystal Reports XI, TFS and DB2.

Sony Distribution Back Bone (Sony DBB), Hyderabad, India 11/09-08/10

Developer

Participated in building, modifying, maintaining, optimizing web pages.

Created new pages, templates and modules taking to consideration cross-browser issues.

Extensively used multithreading and used third party tools to Zip/unzip large files and process them to store into database.

Coordinated integration of front end solutions with back end development team.

Implemented Unit testing by using NUNIT.

Resolved urgent production issues.

Daily status meeting onsite counterpart to keep post the status of tasks.

Technologies: C#, Asp.net, Reflection, Windows Services, WCF, Multi-Threading, LINQ, XML and SQL Server 2008

UTi ADM Services [Universal Transport international], Chennai, India 01/09-11/09

.NET developer

Developed the application to automate the all activities of a warehouse. Receiving the goods, placing them into warehouse, put away, all Inbound and outbound jobs, shipment and etc.

Developed new parameterized queries and stored procedures for ORACLE database.

Provided required modification to Web applications that supported system-specific datasets.

Migrated the existing Microsoft Access Project applications to Web environment using ASP.NET and VB.NET

Supported and maintained Windows Service for goods order processing system.

Prepared Unit/Assembly test Scripts and Test Logs and also executed Test cases.

Used Remedy tool for bugs tracking.

Technologies: ASP.NET 2.0, Vb.net, Ajax 1.2, ORACLE, MS access and SQL server 2005, Remedy Tool

MSC OIPG TESTKIT, Hyderabad, India 02/08-09/08

Software Engineer

Was responsible for overall design, development, maintenance, testing and implementation of the Share point portal for MSC OPIG Team.

We developed a share point portal. In this portal we have maintained centralized document library, where all documents will be stored. In this site user can add new teams, can store business related data, can see on running project, and can see their status in the form of charts.

Created sub sites and implemented key based search function for the entire application.

Involved in Unit testing and Integration Testing of all sub sites.

Created full crawl key based search.

Co-ordinate with the Client for the requirements.

Daily status meeting onsite counterpart to keep post the status of tasks.

Technologies: C#, Moss2007, SharePoint Designer 2007 and HTML

Microsoft Office offline Training Courses Hyderabad, India 02/08-09/08 Software Engineer

The scope of the system is to provide the office online courses to offline in Different languages like German and English. While using this application user feels like online Training courses. This is an Intranet based application.

Users have to install this application from CD and they can start learning the Courses (i.e. Word, Excel, and PowerPoint).

Created Offline training courses for Word and Power point.

Created Flash files and collected assets from online and integrated with flash files

Involved in Unit testing and Integration Testing of all sub sites.

Integration of Flash files with html files.

Daily status meeting onsite counterpart to keep post the status of tasks.

Technologies: VBA, Excel macros, HTML, XML

Contact this candidate