Post Job Free
Sign in

ASP.Net and SQL Server Developer

Location:
Cincinnati, OH
Posted:
April 02, 2015

Contact this candidate

Resume:

Awantika Pandey

Mobile: 513-***-****

E-mail: **************@*****.***

SUMMARY:

• Over 7 years of software development experience using Microsoft Technologies in web applications by

working as a software engineer at TATA CONSULTANCY Services.

• Experienced in developing applications using Microsoft Visual Studio.NET 2005/2008/2010, ASP.NET,

C#, WCF, WPF, Ajax, JQuery, JSON, LINQ, SharePoint, HTML 5, CSS, Bootstrap, XML Web

Services, SQL Server Reporting Services

• Experience with SQL Server including data modeling and stored procedures

• Experience with .Net design patterns like MVC, MVVM and software development models like Agile,

Waterfall.

• Experience in creating Low level design documents based on the functional Requirements.

• Experience in gathering required information from client and to formulate functional design document.

• Experience in Working with SOA and Multi-tiered applications.

1 EDUCATION:

Masters in Computer Applications

Bachelors in Computer Applications

TECHNICAL SKILLS:

• .NET Technologies: C#.NET, ASP.NET, WCF, WPF, XML Web Services, Bootstrap, HTML 5, LINQ, CSS

• Design Patterns: MVC, MVVM, N-Tier Architecture, SOA Architecture

• Software Development Models: Agile, Waterfall

• Languages: C, C#, JavaScript, AJAX, JQuery, JSON

• Databases/Servers: SQL Server 2005 & 2008, SharePoint server 2010

• IDE/File Repository : Visual Studio 2008/2010, Team foundation server, Tortoise SVN

• Operating Systems: Windows 2000//2003/XP/7

• Reporting Tools: SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

E-Capital Program 05/13 – Till Date

Client: Procter & Gamble Inc., Cincinnati, United States

Title: Team Lead, Software Programmer

Description:

It involves the end to end analysis, design and development of all E-Capital program projects. The projects

under E-Capital program include the forecasting of capital and expense, management of technology,

initiatives and schedules on a centralized platform, generation of monthly cross charge reports for initiatives,

automation of Global Center Line process to provide configuration required to manufacture a product. The

projects executed to achieve the program goals were GEM Forecasting, iExpense, Technology Integration

Planning, Chassis Design Engineering, Global Centerline and Auto Lot Code.

Responsibilities:

• Discussions with clients to formulate the Functional requirements and build an

understanding of application design.

• Creating low level design document based on the functional design requirements.

• Code development

• Designing and developing database

• Designing the user interface based on the Functional Design, User interface and Low

Level Design documents.

• Creating and executing the unit test cases to assure good quality delivery.

• Running and correcting the issues identified through tools: FX Cop and Style Cop

• Participating in code reviews and user acceptance testing process to ensure smooth

delivery

• Resolving issues through phases of testing

• Performance Enhancement in Application

• Database Optimization

• Handling application deployment in different environments for testing

• Working in onshore-offshore model to mentor and lead team at offshore

• Code Development to consume WCF services and process XML files

• Maintenance of application code repository using Team Foundation Server in different

branches

• Designing and developing reports for the application

Environment: IBM Think Centre, Windows 7, C#, Asp.net4.0, JQuery, JSON, LINQ, Ajax, Bootstrap,

HTML 5, CSS, VS 2010/2012, SQL Server 2008, SSRS, SharePoint Server 2010, Web services, WCF, MVC,

Team Foundation Server 2012, N-Unit

Real Time Operations Management System 05/11 – 04/13

Client: Cardinal Health Inc., Dublin, USA

Title: Team Lead, Software Programmer

Description:

The project involves the analysis, design and development of new pharmacy management system for

Nuclear Pharmacy Services (NPS) business unit of Cardinal Health. This deals with catering to all the daily

operations of pharmacies for all the NPS locations. This system comprises of all the processes like order

management, order fulfilment, inventory, shipping, licensing, health physics, security and waste management

of pharmacies.

Responsibilities:

• Discussions with clients to formulate the Functional requirements and build an

understanding of application design.

• Creating technical design document based on the functional design requirements.

• Coding and designing the user interface based on the Functional Design, User interface

and Technical Design documents.

• Unit testing.

• Correcting issues using FX Cop and Style Cop to comply with programming rules.

• Participating in code reviews and user acceptance testing process to ensure smooth

delivery.

• Fixing issues identified during all phases of testing

• Providing development support during the testing process

• Performance Enhancement in Application

• Database Optimization

• Handling application deployment in different environments for testing

• Working directly to mentor and lead team

• Code Development to consume Web services and process XML files

• Maintenance of application code repository using Team Foundation Server in different

branches

• Designing and developing reports for the application

Environment IBM Think Centre, Windows XP, WPF 4.0, Web Services, C#, Asp.net4.0, JQuery, Ajax,

HTML, CSS, VS 2010, DB2, Team Foundation Server 2010, SQL Server, MVVM,N-Unit, Crystal Reports

SAAS Portal Application 10/09 – 04/11

Client: British Telecom, UK

Title: Team Lead, Software Programmer

Description:

This project involves the analysis, design and development of portal application to enable small and medium

business customers to order their PSTN, Broadband services on-line through web.

Responsibilities:

• Discussions with clients to formulate the Functional requirements and build an understanding of

application design.

• Involvement in daily and weekly status reporting regarding the application for release tracking

purposes

• Coding and designing the user interface based on the Functional Design, Wireframes and Technical

Design documents.

• Creation and execution of BDD (Behavior Driven Development) test cases to ensure compliance to

programming standards.

• Creation and execution of the unit test cases to assure good quality delivery.

• Participating in code reviews and user acceptance testing process to ensure smooth delivery.

• Using FX Cop and Style Cop to have programming rules compliant code.

• Resolving issues and providing support through testing and maintenance phases.

• Performance Enhancement in Application

• Database Optimization

• Handling application deployment in different environments for testing

• Working directly to mentor and lead team

• Code Development to consume Web services and process XML files

• Maintenance of application code repository using Team Foundation Server in different branches

Environment: IBM Think Centre, Windows Server 2003, WCF, C#, Asp.Net 3.5, JavaScript, JQuery, Ajax,

HTML, CSS, VS 2008/2010, SQL Server 2005, SOA, XML Web Services, Team Foundation Server 2010

SHASTA Portal Application 09/08 – 09/09

Client: Microsoft Corp, USA.

Title: Senior Software Developer

Description:

The project involves the analysis, design and development of Shasta portal application for Microsoft

Corporation. This application deals with the management of all contracts, invoices, organization, product and

reporting data related to the OEMs (Original Equipment Manufacturer) which Microsoft deals with

Responsibilities:

• Discussions with Business Analysts based on the Functional Specifications document to cover the

functionality and technical issues.

• Creating technical design document based on the functional design requirements.

• Coding and designing the user interface based on the Functional Design, User interface and

Technical Design documents.

• Creation and execution of manual test cases on the application and logging the defects to ensure the

correctness of application

• Coordination with the development team to ensure good understanding for quick bug fixing

• Creation and execution of automation test scripts based on all the test scenarios across the

application

• Identification of test case scenarios to cover all the areas of application

• Fixing the issues identified in the automation scripts and stabilizing all the existing scripts.

• Unit testing.

• Correcting issues using FX Cop and Style Cop to comply with programming rules.

• Participating in code reviews and user acceptance testing process to ensure smooth delivery.

• Performance Enhancement in Application

• Database Optimization

• Handling application deployment in different environments for testing

• Working directly to mentor and lead team

• Code Development to consume Web services and process XML files

• Maintenance of application code repository using Team Foundation Server in different branches

Environment: KAF Automation tool, C#, Asp.Net 3.5, JavaScript, JQuery, Ajax, HTML, CSS, VS 2005/VS

2010, SQL Server 2005/2008, SOA, XML Web Services,Team Foundation Server 2010

Bug Tracking System 06/08 – 08/08

Client: Tata Consultancy Services

Title: Software Developer

Description:

The project involves the design and development of a web application which tracks the issues raised by the

user. This application deals with the management, analysis, assignment and status tracking of the bugs raised

by the user.

Responsibilities:

• Discussions with Business Analysts based on the Functional Specifications document to cover the

functionality and technical issues.

• Creating technical design document based on the functional design requirements.

• User interface designing and code development based on the functional requirements of the

application

• Using FX Cop and Style Cop to have programming rules compliant code.

• Identification of test case scenarios to cover all the areas of application

• Creation and execution of unit tests based on all the test scenarios across the application

• Fixing the issues identified in the code during testing process

• Handling application deployment in different environments for testing

• Maintenance of application code repository using Tortoise SVN in different branches

Environment: C#, Asp.Net 3.5, JavaScript, JQuery, Ajax, HTML, CSS, VS 2005, SQL Server 2005,

Tortoise SVN

CERTIFICATIONS:

• Microsoft Certified Technology Specialist in Developing web applications with C#.NET and Visual

Studio.net

o Microsoft .NET Framework 2.0 - Application Development Foundation. (70-536)

o Microsoft .NET Framework 2.0 – Web-Based Client Development. (70-528)

o Microsoft .NET Framework 2.0 – Windows-Based Client Development. (70-526)



Contact this candidate