Post Job Free

Resume

Sign in

Project Sql Server

Location:
Seattle, WA
Salary:
100000
Posted:
June 22, 2014

Contact this candidate

Resume:

Swayam Padhi

acen81@r.postjobfree.com

425-***-****

PROFESSIONAL SUMMARY:

* Overall near about 7 years of Software Application Development, testing and implementation experience with Web based and N-tier Architecture involving all stages of Software Development Life Cycle (SDLC).

* Expertise in developing Web-based applications using C#,ASP.NET, ADO.NET, JavaScript, Jquery,HTML, CSS, SQL-Server 2008, Oracle 9i and Visual Studio 2012/08/05.

* Extensive working experience with different methodologies like Agile (Scrum) and Waterfall methodologies.

* Current project worked a lot on MVP design pattern and Nunit using Just Mock.

* Experience Working on Windows Communication Foundation (WCF)using restful service.

* Excellent working experience in Object Oriented Analysis & Design (OOAD) concepts including inheritance, polymorphism and Abstraction.

* Worked extensively with different ADO.NET objects to interact with database and good experience in using ADO.Net objects such as SQL Connection Object, SQL Command Object, Data Reader, Dataset and Data Adapter.

* Working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures and Functions using T-SQL and PL/SQL in SQL Server.

* Experience using Source Code Control Systems like Accurev, Microsoft Team Foundation Server.

* Learned agile Scrum method of implementation and cleared agile scrum for Practitioners certification, follow scrum in true spirit.

* Actively participated in all Ceremony of scrum i.e. Daily standup, Sprint planning, Sprint retrospective, Story estimation and some time in story grooming.

* Ability to prioritize tasks/Multitask and execute them to perfection and able to work in a high pressure environment and capable of working in a team and as an individual.

TECHNICAL SKILLS:

.NET Technologies

ASP.NET, ADO.NET, WCF RestFull Service

Programming Languages

C#, C, C++.

Web Technologies

HTML, CSS, JavaScript, JQUERY

Database Technologies

MS-SQL Server 2008 / 2005, Oracle9i, MS-Access, Sybase

Web /Application servers

MS Internet Information Server (IIS)

IDE

Microsoft Visual Studio .NET 2012/10/05

Operating Systems

Windows 7/XP/NT/2003/2000

Configuration Tools

Accurev, MS Team Foundation Server

Framework

Microsoft .NET Framework 4.0 3.0, 2.0

Testing Tools

N-Unit, NCover, Debugger

Other Tools

Interwoven-TeamSite,CrystalReport HighStock.JS,CCNet,AnthilPro,Vesion One and Spira(Scrum)

WORK EXPERIENCE:

Organization

Joining Date

Relieving Date

Cognizant Technology Solution(CTS)

12/06/2010

Cont. Till Date

IGATE Global Solution

06/14/2007

11/26/2010

PROFESSIONAL ASSIGNMENT:

ShareBuilder -Seattle, WA Jan2013-Present

Project: Transfer-In and ISSO

Role: .Net Developer

Project Description:

ShareBuilder is a US based online stock brokerage firm.

Transfer-In is a project which helps the customer to transfer or save or to edit their existing Stock, mutual fund or options. Earlier it was a manual process customer used to buy stock and call broker dealer for any kind of modification, now after this project all process was automated. It was a high value generated project for the customer.

ISSO: After the merger of Capital One with ShareBuilder in organizational level they want user to sign in any platform and they can go to any either Capone account or SB account. Apart from that removing image and phrase and moving user name and password into one step was the key objective of this project.

Responsibilities:

* Development was done using C#/ASP.NET using MVP architecture.

* Worked closely with Business Teams and Technical Design Architects to understand the flow and client enhancements to the existing applications.

* Developed and consumed WCF Services to access the data layer with the presentation service.

* Write Nuint test for all stories, in all three layers i.e. in Web Layer, Middle tier and Data tier.

* Developed all the stories related to Omniture, which helps the client for reporting purpose.

* Created new User Controls for general reusability.

* Created Stored Procedures, Triggers, Views and User Defined Functions for easy data accessibility.

* Participated in daily scrums and weekly meetings with the project sponsors to meet expectations and deadlines

* Involved in Unit testing, Build and integration testing for the interfaces.

* Involved in deployment of the application on the production servers.

Environment:.NETFramework4.0,ASP.NET3.5/4.0,ADO.NET,WCF,CSS,SQL Server 2008R2, T-SQL, Sybase,HTML,C#, Visual Studio 2010/2012, AccuRev, JavaScript, Jquery, Sybase, Cruise control, Version1(Sprint planning Tool),Agile Methodology

NBC Universal, CA July –Dec 2012

Project: Accion iPad Application

Role: .Net Developer

Project Description:

Accion iPad Application is native application which will provide flexible user friendly intuitive options in iPad device. Entire application is developed by referring existing web application model features. Restful Web Service component layer will provide the services to iPad layer. IPad layer will consume these services and provides required information in the application. RESTful services will make use of existing Business/DAO layers and will provide required information to iPad layer. This application includes image/video uploading features which will enable users to upload production related shooting images/videos. The key feature of this application is Accion users can be able to view latest updated data in existing Web application and vice-versa. This application is protected by SiteMinder Security layer component. Every call from iPad application to Web Service is intercepted by SiteMinder component which sits in IIS and performs authentication/Session validations through SMPolicy Server. This Application is developed by using Agile Methodology process.

Responsibilities:

* It was a project which gave me a good exposure to create WCF service.

* As per the UX design developing WCF restful service in JOSN format which will be consumed by Ipad team.

* Implemented security mechanism using site minder and exception handling using fault contract.

* Testing web service in NBCU dev. environment before deploys the build to QA team.

* Creating web services catalog and mapping document and shared with ipad dev and Web service testing team.

* Going through the Wireframe and preparing query log if there are any clarifications.

* Fixing defects raised by WS testing and Ipad dev. Team.

* Execution method for this project was on Agile- Scrum

Environment: .Net Frame Work 3.5, Visual Studio 2010, ASP.Net, C#, WCF, Restful service,TFS, Agile Methodology.

HMH INC, Boston Jan 2012-June 2012

Project: HOTS

Role: .Net Developer

Project Description:

HOTS was designed to provide structure around the process of creating information for a book (what are the programs, what are the products, what are the pages, what are the specs, what are the assets that satisfied those specs, managing the process of premissioning for spec’ed images, etc.). HOTS is a suite of tools that support end-to-end management and development of programs. It simply manages the information used in defining books.

Responsibilities:

* Understood the complex application and did enhancement as per the business requirement

* The application was on VB.Net so learned the coding style of VB.net.

* Created and modified few reports which was created using SSRS

* Communicating with Onsite team as well as with client BA for requirements and clarifications.

* Estimating required effort for assigned user stories and distributing the effort within team.

* Implemented Agile-Scrum for the project

Environment: VB.NET, SQL Server 2005, SQL Server Management Studio, Spira(Sprint Planning Tool)

Kaplan Inc., NJ Feb 2011 – Dec 2011

Projects: KARMA,ITRM

Role: .Net Developer

Project Description:

KARMA: Karma Admin Web portal presents various web pages which deal with instructor pay roll and pay checks. The Kaplan admin users are allowed to roll out pay dates across months and set them as templates. These template pay dates are then used to set up actual pay dates to various Kaplan instructors. The portal also has provisions to map campuses, locations and accounts. The portal also consists of Export reports module where payroll related data is transformed into Xml files which are then sent across to SunGard system to generate Letter Of Engagement (LOE).

ITRM: This is a collocation of various applications. I work with LeadImport and KuReport.LeadImport application help in generating LeadImport Id for student who all are trying to register themselves with Kaplan University. KuReport application help in generating report for vendors based on selected criteria, and sending the report as an attachment in email.

Responsibilities:

* Learned MVC and did enhancement as per the business requirement in the project which was created in mvc 1.0

* Understood the Payroll process application(KARMA) which was already developed, it helped me to do the further enhancement.

* Got a better understanding of code smith tool, which helped to create the entity .

* Attending scrum meetings and Sprint planning meetings.

* Implementing the functionality as per requirements.

* Coordinating with testing team related to defect fixing.

* Defect fixing and issue resolving.

* Demo preparation and providing demos for stake holders.

Environment: ASP.net 3.5 with MVC framework 1.0, C#, WCF 3.0, ADO.net, IIS 7.0, SQL Server 2005, Microsoft Enterprise Library, Code Smith tool,TFS

Philip Morris, VA Aug–Nov2010

Project: Altria Companies Employee Community Fund Survey

Role: .Net Developer

Project Description:

The purpose of this project is to launch an online customizable survey system which is directly managed by Altria employees to vote for charity organization.

Responsibilities:

* Created the Data base as per the requirement following normalization technique.

* Implementing the functionality as per requirements.

* Implemented all the client side validation using Jquery.

* Delivering Enhancements and Change requests.

* Coordinating with testing team related to defect fixing.

* Defect fixing and issue resolving

* Demo preparation and providing demos for stake holders.

Environment: ASP.net, C#, SQL Server, JQUERY, TFS, VSS

Phillip Morris, VA Mar-July 2010

Project : CantBeattheexpericen.com

Role: NET Developer

Project Description:

The CantBeatTheExperience.com is a content based corporate web site. This project includes the development of a whole new web site for Altria. The content of the application is maintained in Interwoven Team site. The development of project includes team site template development and respective dot net template development. Focuses on campus recruitment and activities.

Responsibilities:

* Developed the application as it was using Interwoven Team site it gives me a better understanding of the CMS product.

* Created new template as per the requirement using Team Site which was written in scripting language.

* Estimating required effort.

* Creating new template, Editing Existing Template in team Site.

* Delivering Enhancements and Change requests.

* Coordinating with testing team related to defect fixing.

* Defect fixing and issue resolving

Environment: Visual Studio .NET 2008, Interwoven Team site (CMS) and Blueprintcss Frame work, TFS, VSS

Phillip Morris, VA July 2009-Feb 2010

Project : Altria.com Redesign Website Development

Role: .NET Developer

Project Description:

The purpose of this project is to launch a brand new website for ALTRIA CLIENT SERVICES.This website will provide users with rich interactive content. Altria.com is a dynamic and content-driven application using Interwoven Team Site Content Management System. The website is being developed using the advanced web development techniques like XHTML 4.0, Image sprites, JQuery, CSS 2.1 and 3.0 to provide the rich user interface.

Responsibilities:

* Communicating with Onsite team as well as with client BA for requirements and clarifications.

* Estimating required effort.

* Implementing the functionality as per requirements.

* Creating new template, Editing Existing Template in team Site.

* Delivering Enhancements and Change requests.

* Coordinating with testing team related to defect fixing.

* Defect fixing and issue resolving

Environment:Visual Studio .NET 2008, Interwoven Team site (CMS) and Blueprintcss Frame work, TFS, VSS

Phillip Morris, VA Nov 2008-June2009

Project : USSTC Website Development and Maintenance

Role: .NET Developer

Project Description:

The objective of this project is to deliver a new US Smokeless Tobacco Company (USSTC) internet web site. The business objective of the new US Smokeless Tobacco Company web site is to:

USSTC Website development Project came into existence since Philip Morris USA acquired a company named UST (US Smokeless Tobacco Company) – America’s leading manufacturers of Smokeless Tobacco. Dismantling existing ustin.com and developing a new website confirming to Altria’s Website Standards was one of the major requirements of this project.

This website will provide users with rich interactive content. Designs delivered by Y&R (Young & Rubicams – design creative’s partner of Philip Morris USA) are used for designing the .NET Templates.

Responsibilities:

* Implementing the functionality as per requirements.

* Creating new template, Editing Existing Template in team Site.

* Delivering Enhancements and Change requests.

* Coordinating with testing team related to defect fixing.

* Defect fixing and issue resolving.

Environment:Visual Studio .NET 2008, Interwoven Team site (CMS) and Blueprintcss Frame work, TFS, VSS

Phillip Morris, VA Jan-Oct 2008

Project : ALCS Trade License Tracker System

Role: .NET Developer

Project Description:

The PM USA Sales Compliance department has a need for tools that will provide easy access to accurate Trade License data, an easy-to-use interface to reporting, and automation and support of their existing processes. This project will provide the Sales Compliance department with a user-friendly web-based interface to License compliance data and reporting systems required by PM USA business rules. The project should decrease turn-around time in License compliance tracking and reporting.

Responsibilities:

* Prototype design

* Coding .NET Modules.

* PL/SQL Tables, Views & Procedures creation.

* Unit, Integration & Functional Testing

Environment: Visual Studio .NET 2005, Oracle 9i, TFS.

Education: Bachelors of Technology, NIST, BPUT, ODISHA, INDIA. 2007



Contact this candidate