Project Sql Server

Tejashri.K

[pic]

SUMMARY:

. * years of experience in designing and developing Web-based

applications using ASP.NET (3.5, 4.0), C#, SQL Server 2005/2008,

Visual Studio 2005/2010

. Good experience in all stages of SDLC involving meet up with client to

gather the requirements, analyzing, designing, preparing HLD,

implementation, Unit testing, deployment, Support & Maintenance

. Experience in WCF, Web Services, SOAP. Worked with source control

systems like Team foundation server (TFS), Visual Source Safe (VSS)

. Worked on ADO.NET, LINQ, Web Service, JQuery, AJAX and JSON

. Worked with MVC 4.0, 4.5

. Used RDLC and SSRS for reporting purpose

. Experience in Linq to sql, Linq to entity, entity framework

. Worked on SAAS (Software As A Service) systems

. Worked extensively with Data Adapter, Dataset, Data reader as a part

of ADO.NET to access and update database

. Experience in using Master page, CSS and HTML to maintain uniform look

and feel of the web application.

. Developed applications using AGILE methodology and was a part of SCRUM

team

. Expert in debugging an application using the debugging tools provided

by the VisualStudio.Net

. Experience in UAT support, production maintenance and service and code

optimization

. Experience in creating Jobs and Schedulers using SQL Agent in SQL

Server 2008

. Functional domain experience involves Insurance and

Telecommunications.

. Used N-Unit for creating test cases

. Used HTML, HTML5, CSS3 for improving UX

. Created SSRS reports from scratch as well as using wizard and embedded

in web pages.

. Experience in Perl scripting

. Workable knowledge of WPF

. Experience in n-tier layered architecture

. Experience in leading and supporting team, offshore co-ordination,

customer and client relationship

. Goal oriented team player, Self-motivated, hard working professional,

quick learner and communication skills

. Able to manage multiple projects simultaneously in an organized

manner, work on tight schedules and deliver high quality applications

on time

AREAS OF EXPERTISE:

Programming Languages C#, Perl

Web Technologies ASP.NET (4.0, 3.5), ADO.NET, Web Services, Linq,

HTML, HTML5

Database SQL Server 2008, 2005

Reporting Tool RDLC, SSRS

ORM Entity framework

Scripting & Style JavaScript, JQuery, CSS

Tools Visual Studio 2008/2010, Visual Source Safe,

Team Foundation Server

OS & Package Windows XP/Vista/7/8/8.1 & MS Office Tool

PROFESSIONAL EXPERIENCE:[pic]

Project: Insurance Policy Tool March 2014 - Till

Date

Client: Guidewire Software,Inc - Exton, PA

Description:

Guidewire PolicyCenter supports agents, underwriters, and service

representatives across the entire policy lifecycle-from quote and issuance

through changes, renewals, and audits

Responsibilities:

. Responsible for analysis, design, coding and debugging the

application.

. Extensively used ASP.net for with C# acting as a code behind.

. Created various Web Forms & User Interfaces Screens using ASP.Net.

. Developed master pages to maintain same look and feel of Web Page

. Involved designing the database and normalizing the tables.

. Created a number of various user controls for the application.

. Used AJAX advanced techniques for textbox autosuggest.

. Used ADO.NET for the storage and the retrieval of data from the

database.

. Created database tables and implemented SQL Stored Procedures,

triggers, and complex queries in SQL Server 2008.

. Used Web Services for exposing some important financial calculation

functions to all other applications.

. Perform unit and system testing on queries, reports.

. Used Javascript and jQuery for client side validations

. Creating SSRS reports from scratch and embed in web page.

. Created Sub reports in SSRS reports.

. Used query parameters to filter report data.

. Used Team Foundation Server for version controlling.

Environment:

C#.NET, ASP.NET, ADO.NET, AJAX, SQL Server2008, HTML, Microsoft Visual

studio.NET 2008, SSRS.

Project: Profit and Loss Reporting Tool Aug 2013 - Jan

2014

Client: PNC Financial Services Group, Inc - Pittsburgh, PA

Description:

PNC Bank is one of the largest and most diversified financial groups. PNC

(FSG) wanted to work on a web-based management of Profit and Loss reporting

tool providing real time performance of its various clients to senior

management. Web based application which was built for Real Estates clients

only, where it can enlist the existing profiles of customers. And upon

request its history of transactions can be retrieved.

Responsibilities:

. Experience in N-Tier architecture for Design and Development of n

-layered web application.

. Designed and developed application using C#, ASP.Net and Entity

Framework.

. Involved in designing the User Interface mainly focusing on easing

access to registration, plans and features available on the website

using HTML 5, CSS3, JavaScript, JSON, JQuery.

. Fix any code issues; find any bug and debugging with developer Tools

before code to move on Acceptance, QA and PROD Environment.

. Focused on improving readability, utility, and overall UX Process.

. Used AJAX Toolkit to Update Web Control, Data Binding based on user

selection with partial post back.

. Used Session State, Cookies, View Data and Temp Data to persist and

transfer data between web pages.

. Experience in creating and using web services and WCF

. Created SSRS reports and embedded in web pages and email.

. Used query parameters to filter report data.

. Used SSIS for data migration.

. Used JavaScript and JQuery extensively for performing client side

validations and Debugging with Firebug.

. Used LINQ for querying in memory collection & database object.

. Manually unit testing every code before deploying to different

environment.

. Used TFS to maintain the versions of the application.

. Used Agile methodology for development

. Was part of Sprint

Environment:

.Net Framework 4.5, Microsoft Visual Studio 2013, ASP .NET MVC 4.0, C# 4.0,

ADO .NET Entity Framework, HTML5, CSS 3, JavaScript, AJAX, JQuery, JSON,

LINQ.

Project: Risk Management Tool Oct 2012 - June 2013

Client: Overture Financial, Inc - New York, NY

Description:

RMT is a customizable platform, that makes risk & compliance management

easy. User can track, manage and report on Risks, CSA, Health and Safety

Incidents, Conflict of Interest Declarations, Audit Outcomes, Policies,

Contracts, Incidents, Customers and more. A type of user can also create

own registers without IT. Workflow lets admin assign tasks, and you can

link records to related documents.

Responsibilities:

. Participated in meetings with Business users and with other project

teams to ensure that the volatile business requirements reflect in the

project development

. Used C# as language to develop code behind business logic.

. Followed the N-Tier Pattern, separating the business, presentation and

data models.

. Used JQuery for making application more user friendly and interactive.

. Applied Themes and CSS styles for UI design of WebPages and Used Ajax

and JavaScript to minimize number of Page Refresh.

. Used MVC design pattern to develop application.

. Wrote Stored Procedures, Triggers and SQL Queries in SQL Server 2008.

. Extensively used SSRS to create reports.

. Prepared Unit Test plan and Test Cases for Enhancements.

. Mapping the business requirement to the technical specification and

detailed design documents.

. Provide extensive production Support, and fix problems in a short span

of time.

. Used TFS for version controlling.

Environment:

.Net Framework 4.0, Microsoft Visual Studio 2010, ADO HTML, CSS,

JavaScript, AJAX, JQuery, JSON, LINQ, SQL Server 2010.

Project: Sales prompter tool Aug 2011 - July 2012

Client: Tech Mahindra Business Services-Mumbai, India

Description:

Advisors had to toggle between many screens to gather information and to

enter information. This tool had a single screen for advisors which

displayed information from five different tools, thus reducing the AHT of

call. Tool is connected to different databases, so advisor can enter data

at only one place. Tool had admin console to insert data. One module also

had feature of url scrapping from GSMarena website.

Responsibilities:

. Set meeting with client to gather the requirements.

. Involved in project designing and database designing process.

. Making effort estimation and creating project plan accordingly.

. Supporting team members for any issues.

. Assigning modules to team members.

. Analyze the requirements and make HLD to get confirmation from

client.

. Used hidden fields and JQuery to make tool user friendly.

. Used Entity framework as ORM.

. Creating sql procedures and functions.

. Setting up weekly Scrum meetings.

. Interacting with testing, UI and infra team.

. Unit Testing.

. Support & Maintenance

Environment:

VS 2010, MVC 4.0, Entity framework, SQL Server 2010

Project: Password keeper May 2011 -

July 2011

Client: Tech Mahindra Business Services-Mumbai, India

Description:

An intranet website, which provides functionality of saving passwords and

applications. Passwords are stored in an encrypted form. User can also send

password reset requests in one click. Admin can manage applications, and

can also view password reset requests. All the activities are logged in

database.

Responsibilities:

. Participated in meetings with Business users and with other project

teams to ensure that the volatile business requirements reflect in

the project development.

. Used C# as language to develop code behind business logic.

. Followed the N-Tier Pattern, separating the business, presentation

and data models.

. Applied Themes and CSS styles for UI design of WebPages and Used

Ajax and JavaScript to minimize number of Page Refresh.

. Used AJAX Toolkit to Update Web Control, Data Binding based on user

selection with partial post back.

. Wrote Stored Procedures, Triggers and SQL Queries and LINQ in SQL

Server 2008.

. Used Linq queries to fetch and modify data from database.

. Used Cryptographic encryption class to store passwords in database.

. Mapping the business requirement to the technical specification and

detailed design documents.

. Provide extensive Production Support, and fix problems in a short

span of time.

Environment:

VS 2010, MVC 4.0, Entity framework, SQL Server 2010

Project: Ncash Sep 2010 - April

2011

Client: Tech Mahindra Business Services-Mumbai, India

Description:

Intranet ticket system to claim different types of expenses. Raised ticket

would go through a fixed flow for approval and claim was either accepted or

rejected. Also has facility to take print of the form and approved claim if

required

Responsibilities:

. Involved in Design, Development, Implementation and Testing Phases

of the Tool.

. Set meeting with client to gather the requirements.

. Analyze the requirements and make HLD to get confirmation from

client.

. Worked on Per Diem claim module.

. Consistent adherence to SLA in providing the reports to end users

on daily basis. Supporting the clients

. Job monitoring and Production Support.

. Used JQuery to enhance user experience.

. Used client side as well as server side validations.

. Creating stored procedures, views in SQL Server 2005.

. Used lambda expressions to create or fetch data from database.

. Unit Testing.

. Fixing UAT defects raised by the business.

. Developed HLD for the users.

. Provide extensive Production Support, and fix problems in modules

developed by all developers.

Environment:

VS 2008, C#/ASP.NET (3.5), Oracle 9i, TFS 2008, Jquery, LINQ, web services

Project: Risk Management System June 2009 - Aug 2010

Client: Tech Mahindra Business Services-Mumbai, India

Description:

Managers can submit risks and higher authority can view and rate risks.

There are action plan users who work on these risks and implement action

plans.

Responsibilities:

. Responsible for analysis, design, coding and debugging the

application

. Set meeting with client to gather the requirements.

. Used C# as language to develop code behind business logic.

. Followed the N-Tier Pattern, separating the business, presentation

and data models.

. Applied Themes and CSS styles for UI design of WebPages and Used

Ajax and JavaScript to minimize number of Page Refresh.

. Developed and consumed Web Service.

. Wrote Stored Procedures, Triggers and SQL Queries in SQL Server

2008.

. Used Linq queries to fetch and modify data from database.

. Effectively participated in weekly client communications

. Created reports using SSRS.

. Gathered all requirements from various business customers

. Provide extensive Production Support, and fix problems in a short

span of time.

Environment:

VS 2010, C#/ASP.NET (4.0), SQL Server 2008, TFS, linq to entity, RDLC,

JQuery

Achievement:

Award of good work done on the project by provided inputs on the projects

and delivered system as per the requirements with managed the task

perfectly on time.

Achievement:

. Got recognition as good team player.

. Gave workshop for jQuery and N-unit testing.

. Got awarded 4 times for good work done in several projects.

. Take participation in several activities and build team spirit.

Project: Activity logger Feb 2008 - May

2009

Client: Cenveo Publishers - Mumbai, India

Description:

Employees could check in to system everyday and log their activities

timely. Report was generated and displayed to reporting managers. Employees

could also view their

own reports. Reporting manager can add new projects or activities to

project master and activities master.

Responsibilities:

. Participated in the whole life cycle of the project including design

phase of the project, which was designed using ASP.net, C# and ADO.

. Developed the application using ASP.net, C# with SQL Server as the

backend.

. Validation was done using validation control in ASP.net.

. Coded stored procedures, functions for the improved performance.

. Involved in creating .NET Reports to present the data in different

views.

. Developed the front-end screens using Web forms

. Involved in UAT and Production across the application

Contact this candidate