.Net Data

YOGESH SHARMA

Contact # 404-***-**** Email Id:******.****@*****.***

Objectives

- I am seeking a Senior Consultant position using Visual Studio 2013, 2015. I use C# to develop WebForms (ASP.NET), ASP.NET WEB API REST, WCF Services, ASP.NET MVC 4.0, 5.0, C# WinForms/WPF. Front end (Client side) application development using JavaScript, JQuery, HTML5, CSS, Bootstarp and framework like Ext.JS

- My main interest is developing with .Net 4.5 using Asp.Net, ASP.Net Web API, Asp.Net MVC, AJAX, WPF, using WFC Services, LINQ, Entity Framework, LINQ to SQL and ADO.Net to access SQL Server 2008 (or Oracle) Databases. Ultimately, to display in an efficient intuitive User Interface design to provide a great and consistent User experience (UX) across the trio: Web, Windows, and Mobile.

- Technologies that interest me are C#,, Asp.Net MVC, XAML, LINQ and Entity Framework, WCF Web Services, Asp.Net Web Api, Winforms, Asp.Net Webforms, JQuery, Angular.jS, Ext.JS, KnockOut.JS and JavaScript for client side. Along with Pl/Sql Oracle programming and T-sql for Sql Server development

- I prefer Agile environments with positive work values. This is easy with daily Scrums, or short progress meeting, and I am very confident I will deliver with better speed and lower cost.

Education

- M.S, in Computer Science, The University of Nottingham, UK

Technical Skills

-Programming skills: Visual Basic 6, VBA, .Net Frame Work 4.0/4.5, VB.NET, C#. NET, Crystal Reports, ASP.NET, LINQ to Object, LINQ to SqlServer, WEB SERVICES, Web API’s, SOAP, Razor, WSDL, XML, XAML, XSD XHTML, HTML, XSLT, SOAP, COM, DOM, ADO.NET, THREADING, Generics, Extension Methods, Serialization-Deserialization, WPF, Microsoft Expression Blend, Silver light 3.0, WWF, WCF, MVVM, ASP.NET MVC 4

-AJAX, JavaScript, JQuery, JSON used on the client side to create asynchronous web applications

-HTML 5 and CSS 3 for structuring and presenting content for the World Wide Webhttp://web

-Good exposure of C, C++

-Sql server 2005 and Sql Server 2008, Sql, T-SQL, PL/SQL, packages, triggers, cursors, store procedures, functions

- Microsoft Office: MS Word, MS ACCESS, Power Point, EXCEL

- Strong Agile (Scrum) and Lean, TDD and BDD (NUnit, MSTest, Moq)

- Oracle 10g, 9i, 11

- Expertise in version-controlling tools TFS, GIT, SVN, Perforce, VSS, WSS for Change Mgmt

- Excellent experience in software unit testing and efficient at fact-finding, root cause analysis and bug fixing. Hands on with Test Driven Development (TDD)

- Experienced in Waterfall & Agile Development methodologies

Sage Software, Atlanta, Georgia

.Net Staff Consultant June 2016 to till date

Working as a .net developer on a Payment portal, which will serve as a web app for the users across the globe to try and buy Sage-One accounting software. Portal is an Asp.Net MVC application that has its DocumentDB data up on Azure cloud storage and Salesforce as a back-end processing system. The entire code base for the application lives in Git repository and is accessed through Visual Studio. Team Services is used to do build and deployment.

Wrote security mechanism in C# for doing basic authentication

Implemented logging and put all the logs in Azure through Cloud Storage Account accessed through Blob client into container for Blob service

Implemented custom model validation to validate model properties

Customized Swagger-UI using JQuery and JavaScript to generate custom API Documentation

Used C# libraries provided by Swagger to customize model/model schema on the UI page

Configured logging and tracing using Azure portal

Environment: .NET Framework 4.5, Visual Studio 2015, C#.net, ASP.Net Web API-REST, Sql Server 2008 R2, LINQ, Microsoft Azure Cloud, JQuery, JavaScript, Swashbuckle, TFS, GIT

Q-Square Lab Solutions, Atlanta, Georgia

Sr. Software Engineer December 2015 to May 2016

Working as Senior Software Engineer for an ERP (Enterprise Resource Planning) system, which will run all the operations for a “Clinical Trial Management System” for instrumenting Multi-National Pharma Companies to conduct trial for their newly discovered medicines. Participating in a team of 11 members and primarily writing background services and frameworks in .Net.

Wrote Custom Tracing and Logging Framework using C# to write logs into oracle Database, at various severity levels such as Debug, Error, Information, Warning and Critical etc. Also designed tables in oracle database for supporting the same framework

Stood up symbol server in order to obtain full call stack of errors and exceptions on the production server

Wrote Asp.Net Web API RESTFUL service for supporting business defined event processing, using Web API 2.0. Also designed oracle database tables to define business rules for event processing and doing CRUD operations on the same tables through the service

Wrote another Asp.Net Web Api RESTFUL service to fetch configuration settings from oracle database tables for various applications rather than having to access the same from web.config files

Created interop assemblies from Legacy Code written in C++ and VB 6.0 by Hewlett-Packard and used to them to write C# code in order to do automatic printing of requisition forms called TeleForms. Added to same to a Asp.net Web Api RESTFUL service so that after getting XML data from client as a Post request the interop assembly can perform certain operations and Web Api can send requests to various printers in order to print the forms in a batch

Wrote Asp.Net Web Api service for tracking the shipments in form of container containing kits from several sites like doctors’ offices and other clinical trial labs from all over the world for supporting shipment and tracking module of CTMS system

Environment: .NET Framework 4.5, Visual Studio 2015, C#.net, ASP.Net Web API-REST, Oracle11g, ADO.Net, ODP.NET, LINQ, EF 6.0, SVN

Intergraph Corporation, Huntsville, Alabama

.Net Software Consultant September 2014 to November 2015

Working as software consultant (in a scrum team of 8 members) for a product called Networks that has two different front ends one for desktop users called GeoSpatial Portal and the other one for mobile users called Mobile Map Works. These are written in Asp.net and JavaScript libraries and ExtJS framework respectively with Asp.net Web API restful services in the middle tier talking directly to Oracle 11g as database as well as through Legacy COM Servers. This product is going to be a “Planning and Power Outage” Management tool for several Electricity and Energy Companies through out the world.

Wrote C# programs for automatic deployment of the Web API services in IIS 7.0 using web deploy packages (created through batch scripts). Customized web deploy XML files using Linq to XML for custom deployment, used AppCmd programmatically to configure various application pools for each one to have its own worker process i.e. w3wp.exe

Contributed in writing Asynchronous C# programs for getting claims for a given user outs of an Active Directory for authorizing the already authenticated user

Created interop assemblies from Legacy Code written in C++ and VB 6.0 for writing C# code in order to manipulate registry keys of DCOM objects for ACL’s like Launch and Activation permissions, Access Permissions and Identity for by passing an existing Legacy Component Install

Wrote Unit Tests for C# programs for Test Driven Development

Worked with source code repository called Perforce for checking in, checking out, shelving, comparing code changes etc. Also used the same Perforce client for fetching the private code lines of an existing Legacy Product called GTech and subsequently running some batch files for getting legacy Dlls out of this product registered in to GAC (from one build cycle to the other) for pulling out Legacy Objects for writing Web API services’ components/pieces

Used JustCode 3rd party Telerik functionality for conforming to coding standards and removing Visual Studio warnings for cleansing the code

Wrote JavaScript code for getting the content updates every time a user logs on to the system using Mobile Map Work front end client using HTML5 APIs

Wrote C# program to clean up stale message queues, come into existence when Web API services communicates with COM Servers

Queried oracle database using Sql Developer for every new publish and upgrade of data to determine differences between various versions of same database used across different onsite and off shore teams

Assisted QA team members to do Performance Testing of the Web API services in the Performance Lab and Intergraph Cloud and documented the entire process from a Developer’s perspective for finding bottlenecks like request throttling, thread pool starvation, consumption of various CPU types like physical and logical by various COM servers and their speeds in terms of average response time for displaying data on the client side. Also maintained test scripts for regression testing at a later stage to ensure the performance should remain the same or become better with further changes in the code

Contributed in writing Razor code for Sample Client application since real clients were under development at the same time during SDCL as services were

Attended week long Microsoft Azure Cloud workshop formally organized by Intergraph

Environment: .NET Framework 4.5, Visual Studio 2013, C#.net, ASP.Net Web API-REST, Oracle11g, ADO.Net, ODP.NET, Linq, ExtJS JavaScript, Json objects, HTML 5, COM, DCOM, Sql Server 2012, Perforce

Bartlett and West Atlanta, Georgia

Asp.Net Web Developer February 2014 to August 2014

Worked as an Asp.Net Web developer in a team of 12 members, on a Rail Road Project for Norfolk Southern Rail Road Company Atlanta. Contributed in the creation of first phase (called Base Line Web App) a highly sophisticated security system for Train Navigation called Positive Train Control (PTC).

Mainly responsible for processing and functionality of middle tier Asp.Net Web API REST service in a 3- tier Web App

Front End UI was created by the team (using MVC pattern JavaScript ExtJS) which consumes MapService for displaying Spatial Data along with Web API REST service created by me to display attribute data for performing real time CRUD operations by the engineers on board a Train Locomotive (Engine)

Gained working knowledge of TFS for, creating new design documents hierarchy, creating source control tree, querying assigned tasks and checking in source code against those tasks, compare changes between different versions of source code i.e. server code and newly checked in source code for the same application and bug reporting/comments etc

Configured Json file for all the meta data of Oracle Database Tables part of different schemas for eventually deserializing Json data to C# objects i.e. POCO classes, DTO (Data Transfer Objects) to populate data retrieved from Oracle (using ADO.Net and Managed Oracle Client by executing Oracle select, update, insert and delete stored procedures in the Database) into various class fields using LINQ

Developed understanding of Web API Http request pipeline, hence wrote code for maintaining sessions through cookies based on various Roles which are further fetched from another service called RBA service developed by the client

Coded special ApiController inside Web API for updating Geometry field (Shape field/column inside Oracle Tables) using HttpWebRequest (on the run by sending URL encoded data- checked using Fiddler Request-Response) as if update data is coming from a WebForm with Json data input from the user and posting it for an input to another ArcGIS service

Reviewed high level and low level client design documents and developed understanding of how various processes and their work flows/business logics function among different departments of a train company in order to write C# code for Database integration among these departments

Used Autofac DI container for getting interface implementation of various interfaces and its events for especially resolving constructor’s parameters of controllers and other classes to obtain instance of ILog (an interface of Log4Net dll) for writing DEBUG, Error and Info to logging files

Used SoapUI web service testing application for representational state transfers (REST). Its functionality covered web service inspection, invoking, simulation and mocking, functional testing, load and compliance testing

Environment: .NET Framework 4.5, Visual Studio 2012, C#.net, ASP.Net Web API-REST, Oracle11g, ADO.Net, Managed Oracle Client, Linq, ExtJS JavaScript, Json objects, TFS

WINSOFT Pvt Ltd, India

OFFSHORE -BlinkBox.com, London, UK

Asp.Net MVC Developer January 2012 to December 2013

Worked on developing and extending the http://www.blinkbox.com website.

I was involved heavily to convert the site from ASP.NET Web Forms to MVC/Razor

Overhauled the URL routing to MVC and replaced the flash video player with a custom Silverlight player using MVVM and Microsoft’s Smooth Streaming API

Worked in carrying out rework of the site’s content pages to use an HTML5 semantic, templated mark-up and CSS/Less approach, to move the scripting from Prototype to JQuery and services use from WS to REST

Worked in a team of four, used agile practices such as BDD(SpecFlow)/TDD, feature- based sprints and kanban boards maintain a fortnightly release cycle of updates to the live site

Extensively worked with Jquery to manipulate DOM in selecting/managing/manipulating elements forms etc. Also generated HTML content from inline and remote data.

Additionally used Jquery to perform asynchronous operations, including Ajax.

Environment: .NET Framework 4.0, Visual Studio 2010, C#.net, ASP.Net MVC 3, Web API-REST, Sql Server 2008, ADO.Net, HTML5, CSS, JavaScript, JQuery

WINSOFT PVT Ltd, India

OFFSHORE-British Petroleum, London, UK

Sr.Software Engineer May 2011 to November 2011

Built a web portl in order to figure out which sales, accounts and threshhold population that support a British Petroleum gas station through out the UK

Developed N--Tier application in .Net using 3 layers approach. Presentation layer developed using ASP.Net with C#, Business Layer developed using C#, and Data access layer developed using ADO.Net in C#

Developed ASP.NET Web forms, unit tested business layer and data access layer using C#, Application blocks, design patterns and .NET Enterprise services

Extensive use of Web Services and Web Methods

Implemented XSLT for XML data transformation

Developed User Controls, Custom Controls, Master Pages and Reusable ASP.NET page template

Used ADO.NET technology to build Data Access Components

Implemented Singleton design pattern

Developed web interfaces using Ajax

Involved in customizing the third party Data grid controls(Telerik)

Used Devpartner studio (DPS) tool for debugging and testing

Used Microsoft Enterprise Library to handle the exceptions and logging

Customizing Forms and Views

Implemented server side and client side validation controls and JavaScript

Environment: .NET Framework 4.0, Visual Studio 2010,C#.net,ASP.Net, Web Services, Telerik, Ajax, Sql Server 2008,ADO.Net,XSLT,SAP.Net,VSS

Real Estate Website Development & Auction Portals

.Net Developer Gharabari.com, India January 2010 to March 2011

A real estate web application is developed with three main panels which are the user panel, advertiser panel and admin panel. Basic purpose of the website is to buy/sell and rent property throughout India.In the real estate website, two different types of users are considered, a client who is interested in buying a property and an advertiser who wants to sell the property. There is an admin panel for the administrator to control the various activities.

Designed and developed Web Forms using ASP.NET data controls, web controls, user controls and custom server controls.

Developed and designed the User Interface using ASP.NET controls, HTML, DHTML and CSS

Used ASP.NET Validation Controls and Java Script for client side validations in the Web Pages

Worked with multi-tiered architecture and involved in UI, Business and DAL for Access Data Layer.

Used JQuery and AJAX to build Rich UI.

Developed tables, views, stored procedures and Functions to perform automated rules, updating to related tables using SQL Server.

Used Datasets, Data Readers, and Data Grids extensively to retrieve, display and manipulate data from database.

Implemented Asp.net Membership API for providing authorization roles for different uses

Worked on cross browser (PC/Mac/IE/Firefox/Safari/Chrome/Opera) compatibility issues for websites

Used XML and XSLT for Transferring Data.

Migrated Business application database using Access to SQL Server 2008

Applied Ajax to the some of the presentation layer pages using XmlHttpRequest, JSON, APS.NET and C#.

Wrote JavaScript in between HTML mark up structure to do client side validations

Used Google Maps API to embed Google Maps into web pages ( by means of Ajax, JSON and JQuery) as API provides a number of utilities for manipulating maps and adding content to the map through a variety of services, allowing creation of robust maps applications on the website

Environment: - Visual Studio 2008,C#, VB.net, SQL Server 2008, AJAX control toolkit, JavaScript, CSS, XML, IIS 6.0/7.0, JQuery, JSON, SSRS, SVN

AXIS Bank, Gurgaon, India

C# /Asp.Net Developer September 2008 to December 2009

Axis Bank is one of India’s most dynamic financial services organizations offers a wide range of financial products and services. The company serves his customers in personal and commercial banking and wealth management. In this project, Axis Bank developed a banking application, Personal Online Banking (POB), which involves in transmission and transaction of financial information through Electronic Data Interchanges under a secure environment. This application enables account holders to perform basic banking operations like Balance Enquiry, Online Bill Payments and Fund Transfer between the existing accounts etc.

Applied Master Pages, Themes, and CSS for a consistent look and feel for Page design.

Wrote WCF services for processing loans, house mortgages, interests and principle amounts for various category of customers.

Created Content Pages, User Controls, Web Forms and HTML Pages for different banking services and modules using ASP.NET 2.0, XHTML and C#

Used JavaScript to create Client-Side Dynamic content UI and ASP.NET 2.0 and C# to modify and Add Server Controls for Dynamic Server-Side Code.

Created Site Map to implement Navigation Path and Page Access Control according to Users' Membership and Identities

Implemented Banking Security Features using ASP.NET Login Controls, Personalization, Membership, Authentication and Authorization.

Created Synchrony and Asynchrony Event Handler in designing and Building the Web Server Architecture.

Created a large number of Classes and Interfaces to implement Business Logic and Data Manipulation.

Extensively worked on Consuming, Calling, Transmitting and Processing Web Services.

Used SMTP mail class of .NET for users to send mail with suggestions, receive any alerts from the bank, receive confirmation notifications etc.

Used XSLT for XML data transformation in the application and Schema to check the validity of XML Document at various stages.

Used ADO.NET objects, DataSet, DataTable and DataAdapter for manipulating, retrieving, storing and displaying data from SQL Server 2005 Data Source.

Environment: .Net Framework 2.0, ASP.NET 2.0, ADO.NET, C#, Visual Studio 2005, Web Services, XML, T-SQL, SQL Server2005, SVN

Telcordia Technologies, AT&T’s Next Generation Outside Plant Engineering (NGOSPE) project

GIS .NET Developer, Huntsville, AL December 2007 to June 2008

Mainly involved in GIS software development for customizing the ArcGIS desktop i.e. ArcMap’s Graphical User Interface (GUI) for the telecom infrastructure

Did analysis of HLD (high level designs) and DDD (detailed designed documents) to understand the business requirements followed by programming practices in order to include new features inside AcrMap

Extensively customized ArcGIS using ESRI ArcObjects in C#. Net for the Telecommunication Network

Contributed in the development of a Telecom specialized software named Network Engineer sitting above the ArcMap for the AT&T’s business needs

Installed and configured ArcSDE as a middleware ArcMap and Oracle 10g

Wrote code using C# and NEAutomation.dll (Network Engineer automation) for a special requirement called JAM (job access management) using JAM API so that field engineers can access data while conducting a real time inspection of the telecom infrastructure in the field

Did coding inside ArcEngine to import and export XML data files to create new redline features in the form of polygon, line and point

Supported database creation and configuration in Oracle 10g on stand alone machines

Did conversion of some of the existing projects written in VB6 to C# .NET

Examined and integrated several codes obtained from certain foreign companies involved in the same project as a part of the AT&T’s NGOSPE project

Widely used ArcCatalog for the creation of business tables and feature classes as versioned and non-versioned objects

Developed complete understanding of the “A” tables, “D” (delta) tables and reconciliation in a given editing session

Reported some of the core issues with the product (Network Engineer) such as amendment to existing libraries and assemblies to make customization easy for the fellow developers

Got exposure towards ArcGIS Server, its functionality, programming protocols and web applications/web services

Serco Gulf Engineering Ltd, Cambridge, UK

GIS Analyst February 2006 to August 2006

Project aiming at laying down new gas pipelines in Britain and getting rid of old decommissioned infrastructure gas pipelines using diverse data sets viz. landline, airborne Lidar data mainly

Did connectivity of front-end spatial database package. i.e. Arc View with back-end (geodatabase, metadata and attribute data) in oracle 9i by means of Arc SDE as an access engine

Supported in creation of Geodatabase, attribute data and metadata in RDBMS (Oracle 9i)

Took cold backups and hot backups at database level.

GIS software development. i.e. writing Avenue scripts in Arc View3.3 for customising set of analysis tools that can be used to analyse and interpret a diverse set of data mainly for the maintenance of gas pipelines

Gas Pipeline Design and mapping duties for entire countywide distribution system

Processed pipeline risk segments by route geoprocessing

Handling GIS concepts and fundamentals such as map projections, co-ordinate systems, cartographic standards, data quality, sources of error in spatial data, spatial and geostatistical analysis, raster/vector conversion etc

Monthly report writing and documentation for different stages of project appraisal in order to achieve business targets with in specific time frame and budgetary constraints

Environment Agency Regional Headquarters, Solihull, Birmingham, UK

GIS VB 6 Developer May 2005 to January 2006

Worked in building a national a layer giving spatial and aspatial attributes of the “Historical Landfill Site” using OS data, British Geological Survey data and all the hardcopy scans availed from various area offices through out England.

Acted as team leader as a part of the team leading rotation programme. During my tenure as team leader my main responsibilities were to conduct team meeting consisting of 10 professionals with mixed skills, managing technical as well as management side of the project, preparing report on project appraisal in order to achieve business targets with in specific time frame and budgetary constraints, focusing on each individual’s performance and keeping tab on the progress made during my stint to monitor data processed and analyzed

Indexing of OS tiles from OS data (Ordinance Survey) by writing a Visual Basic Script in Arc Map visual basic editor itself so that different regions could be intersected depending upon the area to be processed

Developed customised tools using ArcObjects and Visual Basic 6.0

Making different file formats compatible from one type of GIS environment to the other type by means of major components of Arc GIS 9.1 such as Arc tool box

Wrote Marcos (VBA) in order to Customize MS Access in order to manage and store attribute database in Access.

Did geocoding, georeferencing, queries, joining (attribute & spatial data), field calculations. Also dissolving, merging, labelling and symbolization.

Customised (added new customer toolbar) User interface in ArcMap, wrote VBA scripts to calculate centres (X, Y) and areas of buffered polygons

Assisted in launching final product (which is a spatial layer consisting of Landfill site polygons) on the web (intranet) with the help of Arc IMS with Window 2000 as platform and .NET environment so that one can inspect into a given location when buying a new house on the Internet just by paying the concerned agency a nominal amount.

Infoterra Ltd, Astrium Company of European Aeronautic Defence and Space, Leicester, UK

Digital Mapping Analyst September 2004 to January 2005

Worked in land parcel mapping project to underpin boundary capture and provide national level capture programmes to high quality specification and on schedule to deliver maps to DEFRA (Department for Environment Food & Rural Affairs), Govt. of UK

Extensively used MasterMap data, as a part of the company’s policy to determine the capabilities and object nature of OS MasterMap to be used to its full potential for future Clients with developing geoinformation strategies and GIS system architectures to cope with the loading of MasterMap data and the potential impact of the Positional Accuracy Improvement Program

Worked on Map production of land parcels mainly consisting of landholdings and meadows

Programming with Arc Info workstation using AML language for processing vectorised data for quality check/assurance in terms of removing anomalies viz. gaps, overshoot, undershoot and dangling polygons with emphasis on modular programming

Took cold backups and hot backups at database level

Querying the spatial data with Arc view and attribute data with the help of SQL in oracle 9i consisting of massive database worth 4 million agricultural fields and information related to these fields through out England and Wales.

Designed and Coded a Graphical User Interface (GUI) and made it’s Open Database Connectivity with the attribute data in Oracle server mainly to update existing attribute data in

Contact this candidate