Sql Server Manager

S hashivrat Pandey

L : We s t D e s M o i n e s, I A 5 0 2 6 5 P: 515-***-**** E:

***********@*****.***

Experience Overview

• Extensively worked in ASP.Net, C#, MVC 5, SQL Server, Web Services, Web API, Window Service,

WCF, Entity Framework and other Microsoft technologies.

• A Senior Application Design & Development Engineer, with over 11 years of experience in Software Design

& Development using Asp.Net, C#, SQL Server, Web Services and over 5 Years working with MVC, WCF,

Entity Framework, JQuery and other related Microsoft latest technologies

• Extensive experience of working in Test driven development (TDD) and Agile Development Environment.

• A technocrat; having in-depth experience of complete SDLC including designing, testing, integration,

maintenance, enhancements, and production support.

• Designed documents for Use Case, High Level design, Low Level design through various UML diagrams

• Strong experience in Windows Socket programming. Developed multithreaded TCP/IP transaction servers

to integrate Point of Sale systems like VeriFone, Ingenico etc.

• Experience in integrating Payment Gateway like IPCharge, Authorize.Net, PayPal, Blackboard etc.

• Worked on multilingual applications based on Windows Phone and PDA running on WinCE

• Experience in integration of Google Gear and Veriplace location service in the applications

• Worked on integrating Magnetic Card Reader devices like Magtek, VeriFone etc.

• Extensively worked on making web application compatible to PCI/PA-DSS standards

• Worked on ETL tool like SSIS and reporting applications based on SSRS

• Capable to research and expand the new leading Technologies. Excellent communication skills & leadership

abilities and loyal work ethics.

Skills Set

Software Languages C#.NET, VB.NET, VB6.0, PL/SQL.

ASP.NET, ASP.Net MVC5.0, JavaScript, WCF, JQuery, Knockout, AJAX,

Web Technologies

Web Services, XML, XSL, XHTML, AngularJS, Telerik Controls

Databases SQL Server 2000/2005/2008/2012, MYSQL, DB2, Oracle, Mongo DB, SSIS, SSRS

Middleware ADO.Net, Entity Framework

Operating Systems Windows 8/7/2003/2000/XP/NT/95/98, WinCE.

Modeling Languages/ Tools UML, MS Visio

Source Code Control CVS, VSS, PForce and TFS

Methodologies OOAD, OOP, UML

Architecture Client/Server, Distributed n-tier, MVC, MVVM and SOA, multitenant architecture

Others HTML, Java-Script, XML, JQuery, SOAP, Resharper, Fiddler, Fxcop, Fortify

Professional Experience

Future Health Software, Urbandale, IA Team Lead February 2015 –

Till Date

Project: FHS Reporting

• Involved in complete analysis phase of the application that includes identifying all the UI fields on report and

database fields from source table

• Designed complete mapping of the database fields and written sample SQL queries that helped as guide for

writing extraction logic

• Worked on SSIS package to retrieve data from source database and populate the warehouse database

• Worked on SSRS to show reports as per the pattern decided during analysis phase

• Designed and developed complete frontend of this application using MVC5

Technologies: SQL Server 2012, SSRS, SSIS, MS Visio, SQL Server BI Development Studio, Asp.net MVC5

Farmers Mutual Hail, West Des Moines, IA Senior .Net Developer September 2014 –

January 2015

Project: CloudNet

• Developed complete functionality of Assign Yield module

• Responsible for all the modifications in terms of defect fixing and new development tasks for the modules

like Production Reporting, Combined Database, Scratch Database

• Worked on complex business logic for validating and adding High Risk agricultural land into application

based on RMA database and RMA website

• Fixed around 50+ defects of different modules under CloudNet Application

• Responsible for joining daily standup meeting and share my knowledge for fixing impediments for other team

members

Technologies: C#, ASP.NET, JavaScript, JQuery, Oracle, Visual Studio 2013, Pforce, Resharper, MVVM framework

Textura Corp, West Des Moines, IA Senior .Net Developer February 2014 –

June 2014

Project: Enterprise Shared Services (ESS)

• Involved in designing the architecture of Single Sign On application

• Designed complete framework of ESS solution based on MVC5 and ASP.Net Web API and Implemented

Dependency Injection, Repository Pattern, Unit of Work and Mocking framework for Unit test of entire

application.

• Attended standup, sprint planning, retrospective meetings for each sprint. Involved in pointing tasks and white

boarding for each stories in a sprint

• Followed complete Test Driven Development (TDD) for execution of this project

• Developed multiple Web API that serves Login, Registration and User settings functionalities for all dependent

applications.

• Developed UI for single sign on based on MVC5, Entity Framework and SQL Server. Written test methods of

entire solution.

Technologies: C#, Asp.Net,ASP.Net MVC 5.0, Web API, SQL Server 2012, Visual Studio 2013, Team Foundation

Server, WinXp, MS Visio, moq, Resharper, Fiddler.

Accenture Services, Bangalore, India Team Lead April 2010 –

Dec 2013

Project: Dell Premium E-Commerce

• Worked on page size optimization for Premier tool application used by Sales Rep. of Dell for configuring online

stores of premier customers.

• Implemented Partial Page Post back for all the pages in premier tool application

• Enhanced loading time of web pages in Portal Application designed for Dell's premier customer

• Worked on removing Link Server task to make two SQL Server Database independent to each other

• Developed WCF Service to implement AKAMAI caching for pages in Premier Portal Application

• Designed architecture and developed Software & Peripheral module of Premier Portal application in MVC 2.0

framework.

• Worked on Pricing, Custom Fields and Roster modules of Dell Premier Tools application on migrating existing

application to new architecture.

• Unit Testing for all the modules by mocking different layers of the application

• Developed WCF services to act as an adapter for external systems like Configuration, Authentication, and

Software & Peripheral etc.

Technologies: C#, Asp.Net,ASP.Net MVC 2.0,SQL Server 2008, Visual Studio 2010, VSTS, HP Test Director, WinXp,

MS Visio, moq, Resharper

ISTS Infotech Pvt. Ltd. Noida, India Team Lead May 2006 –

April 2010

• Led a team of 5-6 professionals, reported to the Senior Project Manager and involved into architecture design,

development and process improvement.

• Single point of contact between Client & developer to understand business requirements. Involved in

requirement analysis, client presentations and developed RFP response, functional specifications and design

documents.

• Developed framework for window Socket communication and divers for IBM POS device.

• Developed an HTTP module called view manager module, which identifies the request browser (mobile/PC) and

redirect the page accordingly. View manager also specify the CSS to be used according the height and width of

mobile's screen

• Integrated Google Gears and Veriplace to get the geographical location of customer to display the promotions

near to that location.

• Implemented checkout process with IPCharge payment Gateway for PC based application

• Designed and developed e-Wallet application for CNG, Denmark This application is based on Multitenant

architecture. Implemented white labeling feature for different merchant associated with CNG. Worked on Fund

Transfer, Deposit, Wire transfer and Balance Inquiry modules

• Reviewed ePOS application of Sequoia and analyzed the gap for getting PCI certification. Developed webserver

which handles all payment transactions. The application is PCI certified.

• Visited Lagos, Nigeria and produced an RFP Document to Exchange Data System for their proposed application

to fetch Nigerian Stock Exchange data and integrate to their stock broking application

• Developed Quick Charge application for MM Hayes which allows their employees to pay their meal expenses at

cafeteria through their badge

• Developed multi-threaded window socket based transaction application to integrate VeriFone Point of Sale

device and developed APIs to expose data to other applications like payroll system etc.

• Developed transaction server for Magtek to read data from Magnetic Card Reader device and implemented

authentication based on data read.

• Worked on Cingular Prepaid Recharge application of Blackhawk Network. This application was developed in

Dot net Nuke (DNN)

• Developed Sciconics application which is a multilingual windows mobile application designed to send message

with 1000 templates in different languages

• Developed a TAPI based personal outbound dialing application that runs on different Windows Mobile and

other windows based PDAs.

Technologies: C#, Asp.net, SQL Server, Dreamweaver, Visual studio, VC++, WinCE, Mantis bug tracking system,

Tortoise CVS, DNN, MS Visio, HP-IPAQ, HTC Window Mobile, IPhone, Blackberry devices

Vglobal Technologies – Allahabad Software Engineer May 2005 - April

2006

• Involved in design & development for several clients at different locations and provided business solutions.

• Developed Drug Inventory Management System for a leading Doctor’s clinic

• Developed an innovative application for customers to buy, sale and exchange their holiday's week.

• Involved in writing test cases and testing applications in development environment

Technologies: C#, Asp.net, SQL Server, Dreamweaver, Visual Studio

iTouch Technologies - Bangalore India, Software Engineer Jan 2004 - April

2005

• Involved in developing a system that helped the user to search through the database for the available property

based on the customized search criteria. Responsible for complete development of customer profile module

• Worked on Reports module that generates detail report of employee, allotted houses and list of vacant houses.

• Involved in unit testing and deployment of applications

• Designed multiple HTML website using Adobe Dreamweaver

Technologies: C#, Asp.net, SQL Server, Dreamweaver, Visual studio

Education

• B.E (Computer Science) from Magadh University (2003)

• MCTS (.NET Framework 2.0 Web Applications)

• Certified Technology Architect Associate under Accenture Architect certification program.

Contact this candidate