Post Job Free

Resume

Sign in

Project Sql Server

Location:
Tampa, FL
Salary:
$100K-$110K
Posted:
May 24, 2017

Contact this candidate

Resume:

Sushma Nalam

Mobile: +1-407-***-****

Email ID: ac0gxe@r.postjobfree.com

Experience Summary

I possess 9years of experience in the Information Technology. As part of my assignments, I have been in Requirement Analysis, Application Development, Functional Studies, Quality Reviews and Testing.

Extensively worked on C#, SQL Server 2005/2008 R2 / 2012.

Having 6+ years of experience in .Net Windows applications and 2+ years of experience in Web applications.

Experience in C#, SQL Server 2008, ADO.NET, LINQ, Entity Framework, XML, WPF, WCF and Web API with good proficiency in Windows Form and WPF Applications.

Experience with Full Software Development Life Cycle (SDLC).

Experience in Object Oriented Programming (OOPS), Object Oriented analysis, design (OOAD) and development using C# on Windows platforms.

Experienced in XML family of specifications (XML, XML Schema, XPath and XQuery).

Extensive experience in database analysis, design, and normalization and data manipulation processes using SQL Server.

Experience on design patterns, SOLID principles, MVVM, MVC and MVP architectures.

Experience in Azure for .NET applications.

Experience in Multi threading and TPL

Provided Architecture and Solutions for different types of applications.

Good written and oral communication skills.

Experience in Agile development methodology.

Experience to work with MVC 4.0 and JSON.

Education Qualification

Title of the Degree with Branch

College/University

Year of Passing

B.E(Electronics and Communications)

P.D.A College of Engineering Gulbarga (Karnataka)

2002 – 2006

Certifications

NCFM:

Financial Markets - Beginners Module.

Exam:70-536:

Microsoft .NET Framework-Application Development Foundation

Relevant Project Experience

Organization: Health Grid – US (Orlando)

Project #1

Title Care Narrative

Client Health Grid

Technologies MVC 4.0, WebAPI, Service Bus, JSON, Entity Framework

Tools Visual Studio 2015 Development Edition

Team Size 4

Role Full Stack .Net Developer

Period Feb 2017 – Mar 2017

Project Description

This project is to provide an application to the end users to reduce the paper work done at the hospitals when there are visits. All the patient details will be entered and stored in the database for future reference. This project is executed using the Agile methodology.

Role and Responsibilities

Developed multiple Web API.

Worked on with the Service Bus to push the messages to the subscribers.

Incorporated major changes into the existing functionality of User management where I used Telerik controls to have a searchable checked 3 level list box.

Development of new requirements.

Regular scrum calls with product owners in the scrum meetings and daily Sprint meeting.

Organization: Accenture - India

Project #2

Title Notification Platform

Client Microsoft

Technologies WebAPI, Azure Service Bus, JSON, SMTP

Tools Visual Studio 2015 Development Edition with GIT

Team Size 10

Role Team lead

Period Dec 2015 – Mar 2016

Project Description

This project is to provide the platform to communicate amongst multiple applications and send notifications to the end users on demand. Notification Platform is hosted in Azure and any application that subscribes to Notification platform, can trigger the notifications to end users. This project is executed using the Agile methodology.

Role and Responsibilities

Leading the team technically.

Analyzing the existing application to incorporate new requirements.

Development of new requirements.

SPOC for the application to interact with external teams on making them understand the process of subscription to Notification platform.

Build migrations to multiple environments.

Defects tracking and fixing.

Regular calls with product owners in the scrum meetings.

Organization: Cognizant Technology Services- India

Project #3

Title Odyessey Migration

Client Credit Suisse

Tools Visual Studio 2013, Nuget Package Manager, JIRA

Team Size 1

Role Individual Contributor

Period Oct 2015 – Dec 2015

Project Description

This project is to migrate the existing applications to Odyssey and ensure that the code, JIRA, Confluence are up to date in Odyssey. The builds need to be triggered from the Odyssey.

Role and Responsibilities

Leading the migration activities.

Build migrations to multiple environments.

Regular calls with product owners in the scrum meetings.

Project #4

Title Exception Lifecycle Management

Client Northern Trust

Technologies WCF, WPF

Tools Visual Studio 2008 Development Edition, SQL Server Management Studio 2012

Team Size 4

Role Team lead

Period Mar 2015 – Aug 2015

Project Description

This project is to develop the application for automating the process of Exceptions lifecycle. These exceptions are the feed from downstream applications. Based in the assets created the exceptions are created. These exceptions should be addressed based on the cause and Age of the Exception. All the exceptions that are closed still remain for the history process till 3 months. This application helps user to maintain the exceptions using this ELM tool. This project is executed using the Agile methodology.

Role and Responsibilities

Leading the team technically as well as process related.

Major screens are developed by me.

Build migrations to SIT environment.

Defects tracking and fixing.

Regular calls with product owners in the scrum meetings.

Project #5

Title Rules Engine

Client Northern Trust

Technologies WCF, WPF, SQL Server

Tools Visual Studio 2008 Development Edition

Team Size 1

Role Single Resource (POC)

Period April 2014 – Feb 2015

Project Description

This project was to develop the application for automating the process of validating the assets by creating the Rules and run those assets over the rules. Running the rules was automated to schedule the run at different frequencies like Daily, Weekly, Monthly or Ad-Hoc basis. Once the rules are run over the assets, the status of the assets for passed or failed was also tracked using one of the automated screens. Where the business was able to check the asset info, and track them.

Role and Responsibilities

Major modules are developed by me.

Entire Phase-2 development was developed with me with merely no UAT defects.

Along with the project as a Single resource I have also worked on multiple dockets for other application AIP Home.

Resolving Production and UAT Issues.

System, Integration testing.

Included in additional tool developments like automating the JCL creation which is an additional effort spent.

Project #6

Title Assets Institutions and Pricing Systems GUI

Client Northern Trust

Technologies WCF, WPF

Tools Visual Studio 2008 Development Edition

Team Size 5

Role Team Lead

Period June 2013 – March 201

Project Description

This project was to develop the applications for creating the assets and provide the functionality to maintain the assets that are being coded. These securities are then launched in the market. This is a very huge project that was implemented in Small Talk technology. Which is been migrated to .NET using the WPF technology. This project has another sub project that is Rules Engine. This is part of application is used to create the rules and run the assets over these rules to make sure that the created assets are meeting the criteria. There are multiple dockets being developed as part of this application.

Role and Responsibilities

Major modules are developed by me.

Only offshore resource for developing the Rules Engine project

Resolving Issues.

Guiding team in all aspects.

Code reviews done at every stage.

System, Integration testing.

Project #7

Title Amex GCT - Millie MFCoE 2011(AZURE .NET Applications)

Client AMEX

Technologies WCF, ASP.NET, Entity Framework

Tools Visual Studio 2010 Ultimate

Team Size 4

Role Team Member

Period September 2012 – June 2013

Project Description

This project was to develop the applications for Azure environment. There were different applications from client which had communication with other applications. The three applications that I worked on were GSM Gateway, Payroll Task management, Alert Management.

GSM Gateway: - This application is a procurement system. The application is used to place the orders for purchasing the items (like Books, laptops etc.). The User places an order using this application, and followed by the Utility Team which is actually involved in the transactions.

Payroll Task Management: - This application is used for managing the tasks. Application is developed for handling the tasks management for 48 Markets. Based on the Market selection, the User will be redirected to the market specific Tasks and its details. The application provides the option of SLA if the task is not completed by the given Due Dates.

Alert Management: - This application was to create a WCF service that sends alerts for registered applications for the given inputs.

Role and Responsibilities

Developed POC for all the three applications.

Developed Alert Management POC single handedly.

Developed major modules of Payroll Task Management and GSM Gateway applications.

Resolving Issues.

Guided new team members.

Involved in UI activities.

Manual Testing.

Included in Organizational activities like C2 and Codenizant.

Project #8

Title Scorpio

Client Invensys

Technologies WPF, XML

Tools Visual Studio 2010 Ultimate

Team Size 20

Role Team Member

Period January 2011 – Oct 2011

Project Description

Scorpio is the first project of the Next Generation Visualization Program. The Scorpio project is responsible for developing the Next Gen rendering engine for HMI / Process Graphics. The rendering engine created by Scorpio shall be hosted by the new visualization runtime host being delivered by the Stinger project. The three main development themes of Scorpio are:

Graphic Runtime Module to display Process Graphics within the Viewer host.

Maximize performance to improve startup times and reduce steady state CPU utilization with Process Graphics.

Programmatic APIs for converting graphics (AA symbols and InTouch Windows) to a format required by the Graphic Runtime Module.

Graphics Performance Index (GPI) calculation to give the user an idea of how expensive their graphics may be at runtime.

Role and Responsibilities

Involved in development of core functionalities – Custom Properties, WCC etc.

Resolving CRs, Writing Automated Unit Test Cases, Manual Testing and Taking performance reports.

Organization: Tata Consultancy Services- India

Project #9

Title ICOMMS

Client Tata Tele Services ltd

Technologies WCF, ASP.NET

Tools VSTS 2005, Clear Case

Team Size 24

Role Module Leader

Period July 2010 – November 2010

Project Description

This project is about developing and enhancements of the web applications for the TATA INDICOM, TATA DOCOMO etc. The web sites created helps in launching the new plans in the market, computing the commissions and claw backs payable to dealers. The tools help in setting the targets to the dealers and their subordinates.

Role and Responsibilities

Involved in requirements gathering and analysis for various enhancements of the EBS, EBS CAD, GSM-EBS, G7SM-EBS-CAD, SAP MDM and QPP applications.

Excel report generations.

Mentoring junior resources in project.

Allocating work to team members and monitoring their progress.

Taking sessions & providing guidance to team for giving better understanding of the code to new joiners.

Bug fixing and troubleshooting.

Good practical understanding of implementation and good understanding of technology and its application.

Project #10

Title BNE Branch Number Expansion

Client Morgan Stanley Smith Barney

Technologies ASP.NET, C# 2.0/ 3.5/1.1, Web Services, WCF

Tools VSTS 2008/2005/2003, IBM DB2 Service Centre v8.1, SQL Server 2005, Synergy

Team Size 45

Role Module Leader

Period Sep 09 to Jun 2010

Project Description

Client is making a joint venture program with the other leading bank of USA; hence it is in shortage of office. Currently the client supports 999 offices which it actually wants to enhance till 99999 for its business purpose. Hence all the applications that are used by the client have to be modified to support 99999 offices. There were around 300 applications that were getting impacted. The program was divided to two phases strategically and Tactical. The Tactical approach was on high priority. Tactical approach was to make reclaim the office that was unused so that till the strategic approach comes into production, the reclaimed offices can be used.

Role and Responsibilities

Impact analysis of around 35 applications.

Remediated the applications.

Worked with the web services and WCF.

Mentoring junior resources in project.

Allocating work to team members and monitoring their progress.

Taking sessions & providing guidance to team for giving better understanding of the code to new

Joiners.

Bug fixing and troubleshooting.

Project #11

Title Authoring Bench

Client Nissan Motors,

Technologies Winforms, XML

Tools VSTS 2005, VSS

Team Size 8

Role Module Leader

Period Oct 2008 – Sep 2009

Project Description

Client is currently using the F/Checker and TAS Diagnostic tools for diagnosis of the Electronic Control Unit (ECU). The test and the operations to be performed are hard coded in these tools. Client has a requirement to allow the end users to create the test and the operations required for the diagnosis. Hence, Client has requested TCS to develop this tool. The tool shall allow the end user to program the tests and operation using the flowchart and generate the required configuration files based on the flowchart.

The main functions of the Authoring Bench Tool are:

To import the ECU specification files

To create test and operation using the flowchart drawing

To generate configuration files from the Scenario and Sequence flowchart and ECU Specification file used in the flowchart

To manage the project and its components such as System, Family, Scenario and Sequence.

Role and Responsibilities

Developed Prototype for Authoring Bench tool.

Requirements gathering and Explorations.

Developed the User-friendly GUI interface using Visual Studio .Net 2.0

Generating Intermediate Scenario and Sequence files.

Testing and Bug Fixing.

Written STP for the application.

Project #12

Title Entry Edit Tool

Client Nissan Motors

Technologies WinForms, C#

Tools SQL Server 2005, VSTS 2005, VSS

Team Size 9

Role Team Member

Period May 2007 – Sept 2008

Project Description

Client has an existing Automatic Evaluation System for testing the ECUs of an automobile. Automatic Evaluation System is the Automatic Testing Tool used in Japan for testing various functionalities of vehicles. The AES consists of Entry, Edit, Execution, Judgment and Analysis modules. The purpose of the AES is automating testing operations in order to improve the efficiency of evaluation process.

The main functions of the Entry-Edit Tool are:

To automate phases of testing of a vehicle.

I have supported intranet server by using .net remoting.

It has two main modules: Data processing module, code generation.

oData Processing Module: It processes data over 80 rules.

oCode generation: C++ code will be generated from C#.net. We have used template based approach. Automatic compilation will be done and C++ dlls will be generated.

Role and Responsibilities

Requirements Analysis.

Developed Prototype for Entry Module.

Developed the User-friendly GUI interface using Visual Studio .Net 2.0

Developing the three critical modules of Entry.

Written Stored Procedures.

Implemented Windows service



Contact this candidate