Full Stack Developer

DHARMISHTHA R. TANNA

Mobile: +1-408-***-****

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

SUMMARY:

●10 years of experience in Analysis, Design, Development, Implementation and Testing of enterprise IT applications in Energy and Petrolium, Oil and Gas industry.

●Lead both onsite & offshore teams in projects involving core and advanced Microsoft technologies (ASP.NET, C#.NET, MVC, ADO.NET)

●Strong experience in designing and developing applications using MVC (Model View Controller).

●Strong experience in designing services with WCF Restful Services.

●Good experience working with Angular JS for developing framework to build a single-page application.

●Strong experience with ORM framework using NHibernet and Entity Framework to automate database activities.

●Good experiences working with SQL SERVER for maintaining the application Data and Querying the required data.

●Good experience programming with LINQ in data access layer for CRUD operation.

●Extensive experience with MS SQL Server 2008/2012 T-SQL. Proficient in writing stored procedures, Functions, Cursors, ETL Packages, and Database Triggers using SQL and Oracle

●Expertise on ADO.Net components such as Datasets, Data Adapter, Data Reader, Data View, Data Table and expertise in Web Forms.

●Worked in projects that follow Waterfall and Agile methodologies.

●Well versed with Software Development Life Cycle (SDLC) and involved in all the phases of the life cycle - Requirements gathering, Analysis, Design, Development, Code Reviews, Unit Testing and Integration Testing.

●Strong experience writing DB queries, Stored Procedures/Functions, Views and optimizing SQLs.

●Proficient in Source Code Management and Versioning tools like VSS and TFS.

●Handled Production Support tasks involving batch jobs monitoring and debugging, database and application support.

●Proven Ability to lead, manage project resources, interact with clients, coordinate and work in achieving high levels of productivity and efficiency in complex, dynamic and challenging environment.

●Have worked across all stages of Requirement Analysis, Design, Development, Testing, System Integration, Release & Implementation, Post implementation support

TECHNICAL SKILLS:

Microsoft .NET Technologies

Microsoft .NET, Web Services, RESTful WebAPI,WCF, MVC, LINQ to SQL, NuGet packages

Front End Frameworks

AJAX, AngularJS, HTML5, ASP.NET, CSS3, XML, XSL, WSDL, JQuery

Development Tools

Visual Studio 2002 - 2015, Framework 1.1 – 4.5

Web Servers

IIS 5.1/IIS 6/ IIS 7

Languages

C#,VB 6.0, VB.NET, VBScript, JavaScript, JSON, XML/XSL, T-SQL,PL-SQL, PHP, VBA, jQuery

Databases

SQL Server 2000 - 2016, Oracle 8/9i, MS Access, MySQL

Operating Systems:

WINDOWS XP/2000/NT/2005/2008/2010

SQL Server Tools

Enterprise Manager, SQL Profiler, Query Analyzer

Testing Framework

Unit/Integration testing framework NUnit

Object-relational Mapper

NHibernet, Entity Framework

Reporting Tools

Seagate’s Crystal Report Version 8.0/9.0, Crystal Report For .NET, Data Report

Version Control Tools

Microsoft Visual Source Safe, TFS (Team Foundation Server)

CERTIFICATIONS:

●Microsoft Certified Professional in web applications with C#

●Microsoft Certified Professional in SQL Server

EDUCATION QUALIFICATION:

●Master of Computer Applications from Saurashtra University, Rajkot, India in Apr. 2003

●Master of Commerce from Saurashtra University, Rajkot, India in Apr. 2000

●Bachelor of Commerce from Saurashtra University, Rajkot, India in Apr. 1998

PROFESSIONAL EXPERIENCE:

Client: Hewlett Packard Enterprise, Palo Alto, CA, USA

Duration: May 2017 - till date

Project: MediaX

Role: Sr. .Net Developer

Working on various web applications to support Media Solutions of HPE. Architecting an integration tool of different web applications which are currently used for Event Booking and Scheduling, Project budgeting and billing etc. This tool will be commonly used by internal as well as external company resources to request event, get budget for the event and billing purpose to company. This tool will be used to generate Reports like yearly and monthly events billing/budget/pending and executed bills etc.

Using .NET Core 2.0 and MS SQL Server 2016 for the development of new integrated tool. Using many JQuery Plugins to support UI development. All applications are responsive apps which supports all the devices, so using Bootstrap and JQuery Plugins extensively.

Responsibilities:

●Following Agile Methodology for the software development.

●Working on various web applications like Event scheduling, Project budgeting and billing, Announcement broadcasting under Media Solutions for HPE.

●Working on internal as well as external web applications.

●Designed the integration of various web applications following MVC architecture. Using webAPIs to create services to support multiple internal and external web applications.

●Used Single Sign On for all the web applications developed for HPE and HPI.

●Database design using ER-diagram.

●Written complex SQL queries, Stored Procs, Triggers, Joins and database Views.

●Developed SQL Jobs to automate Monthly and Weekly survey data collection.

●Involved in developing the UI using HTML, JavaScript, JSON, JQuery, and AJAX.

●Supported in creation of RESTful webAPI to build HTTP Service to connect the system to a broad range of clients.

●Worked system requirements, project design and planning, coding and automation testing using Selenium

●Using TFS as the repository and version control.

Environment: Visual Studio 2017, ASP.NET MVC5, C#.NET, Java script/JQuery, LINQ-to-SQL, Stored Procedures, T-SQL, JSON, Ajax, HTML, IIS, CSS, RESTful web services

Freelancing, Training Projects

Duration: Jan 2014 - Jan 2016 (Remote)

Project: Inventory and Stock/Job Management System

Role: Sr. .Net Developer

Inventory and Stock/Job Management application was developed a graphic design company to manage their Inventory and Job details. Application authenticate/authorize role based user and keep tracks of all the ongoing and completed graphic jobs with revenue details.

Responsibilities:

●Worked for all phases of SDLC of Web Application Development, Deployment and Support.

●Following MVC architecture using ASP.net MVC 5 and AngularJS

●Involved in the gathering requirements from various sources.

●Analyzed, designed and developed forms based on the requirements.

●Worked on user authentication and role based authorization. Developed data layer logic for user logging which lets user to access only the specified services according the roles.

●Database design using ER-diagram.

●Written complex MySQL queries, Stored Procs, Triggers, Joins and database Views.

●Involved in developing the UI using AngularJS, HTML, JavaScript, JSON, JQuery, and AJAX.

●Working on controller, ng-controller and ng-model in Angular JS.

●Using Routing in ASP.Net MVC and AngularJS to page navigation.

●Worked on two way data binding, a very strong feature of AngularJS for front end development.

●Created Custom HTML tags using Directives in AngularJS.

●Supported in creation of RESTful webAPI to build HTTP Service to connect the system to a broad range of clients.

●Worked system requirements, project design and planning, part of coding and Unit Testing using NUnit

●Using GITHub as the repository and version control.

Environment: Visual Studio 2015, ASP.NET MVC5, C#.NET, .Net Framework 4.0, Java script/JQuery, LINQ-to-SQL, Stored Procedures, T-SQL, Angular JS, JSON, Ajax, HTML, IIS, CSS, RESTful web services, XML, XSLT, MySQL, GITHub

Client: ABB via IBM India Pvt Ltd., Bangalore, India

Duration: Nov 2008 - Mar 2012

Project: CCP (Common Configurator Plateform)

Role: Sr. .Net Developer

The Common Configurator Platform (CCP) is a Marketing & Sales tool. CCP supports the tender and order activities for Power Products Division. CCP’s structure and flow permits it to aid the user in managing their compliance to Power Product’s systems and procedures. CCP Tracks all quotations from opportunity stage to order transaction, tracks customer segment information, order registration and processing.

Through the use of configurators, CCP connects to external applications using web services, MQ series etc. Configurators are used to specify the requirements of a particular product from a factory. With the help of configurators Users can choose a particular product, configure it according to their specifications, ratings, voltage, price, quantity and can order a product in a particular Factory location.

Responsibilities:

●Worked on n-tier architecture web application design and development, Testing, Implementation and Support

●Involved in various phases of the project including planning, analysis, estimation and implementation.

●Graphical User Interface (GUI) was designed using ASP.NET MVC4 and the business logic was coded in C# [MVC Controllers].

●Written complex queries using T-SQL to retrieve data from database.

●Performed normalization of tables in database and written SQL queries using T-SQL.

●Involved in developing the UI using HTML, JavaScript, JSON, JQuery, and AJAX.

●Developed various web services (Service Oriented Architecture) using WCF in C#.NET and consumed by web application and other systems like Configurators.

●Developed a communication layer that is used for consuming Web Services, (SOAP, UDDI, and WSDL, RPC) and this layer was used while fetching the products.

●Created the User controls and worked on custom controls for the presentation layer.

●Worked on building REST based Web Services.

●Used NHibernet(ORM) for Database operations.

●Created tables, triggers, and Stored Procedures in database for reports.

●Involved in coding and unit testing before releasing to QA.

●Involved in creating ETL packages and SSRS reports for the application.

●Writing module Level code implementation using C#.

●Configuring the entire project in TFS and used TFS as source code control.

Environment: Visual Studio 2010, ASP.NET MVC 3, C#.NET, .Net Framework 4.0, WCF, Java script/JQuery, LINQ-to-SQL, Agile, Stored Procedures, T-SQL, JSON, Ajax, HTML, IIS, CSS, SOAP, LINQ, web services, XML, XSLT, Team Foundation Server (TFS), SQL Server 2010.

Client: Chevron Corporation, San Ramon, CA, USA

Duration: Aug 2007 – Aug 2008

Project: STRATA(Site Assessment and Remediation Technical Resource Administration Tool Application)

Role: Senior .Net Developer

STRATA provides facility of online Project Management System tool. Managers can create their Strategic Plan, project plan, Work breakdown Structure, Service Order Request and Approval, Plan Execution, set milestones, define tasks, assign resource to projects and Close Project through STRATA. It uses MS Project Server and its capabilities, and it is tightly integrated with MS .NET capabilities to provide an integrated tool to the business users.

Responsibilities:

●Understanding the functional and business aspects, complex codes and interfaces of the application in order to fix issues

●Providing offshore production support; working on tickets, code changes and enhancements.

●Key player in requirements gathering and analysis, data gathering and analysis and project requirements for this application which is developed using waterfall methodology.

●Created functional prototypes, design templates and mockups for the entire application.

●Played a major role in coming up with the business requirements for the project, the project plan and workflow.

●Worked on MS Project Server to connect to ASP.Net pages and fetch project data.

●Written LINQ queries to get data from database.

●Designed the application using an n-tier Architecture that promotes a clear separation of the presentation, business logic and data access tiers.

●Followed Waterfall methodology approach in application.

●Assisted in the design and development of reports using crystal reports.

●Used WPF, AJAX and JQuery to build a rich user interface.

●Used Visual Source Safe as source code control.

●Developed and used various Web forms, Custom Controls and User controls using ASP.NET, C# and JavaScript.

●Created tables, triggers and stored procedures, Indexes, ETL Packages, Views using SQL server 2005.

●Perform coding, unit testing and functional testing as per the design and requirements.

●Responsible for product customizations as per customer requirements.

●Perform unit testing and integration testing and signing

●UAT from client.

●Upgradation of existing application from ASP.Net 1.1 to 2.0.

Environment: .Net 3.5, ASP.Net, ADO.Net, AJAX, JSON, HTML, JavaScript, CSS, MS Visual Studio 2005, LINQ, Waterfall, Stored Procedures, WPF, Oracle 10g, Crystal Reports, T-SQL, PL/SQL, Web Services using Service Oriented Architecture.

Client: Chevron Corporation via L & T Infotech Pvt Ltd., Chennai, India

Duration: May 2006 – July 2007

Project: CRITTER (Consolidating Reporter of IT Total Expenses Realized

Role: SME / Sr. Software Developer

ITC (Information Technology Company) provides all IT related products and services to the company and its other operating companies. Critter is a reporting tool developed on Singleton architecture to view ITC costs from an organizational perspective as well as to provide historic trends. Critter melds data from SAP Business Warehouse and MetaDirectory (application that stores the people information) and is updated on a monthly basis using SQL Server ETL Packages when new ITC SAP data become available. Critter currently handles 12 Million transaction records for generating the report. Critter displays reports in both graphical and tabular formats for the most current 12 months of ITC data. Critter also provides for a hierarchical view of the data by allowing supervisors to view aggregate costs for their entire teams, as well as to view individual costs by drilling down to specific people

Responsibilities:

●Understanding the functional and business aspects and prepared business requirement document for this application.

●Followed Waterfall methodology for the project development life cycle.

●Designed and developed application using n-tier architecture in ASP.NET framework.

●Involved coding, unit testing and functional testing as per the design and requirements

●Worked extensively on ETL Packages to retrive data from SAP Business Warehouse and MetaDirectory (application that stores the people information) and is updated on a monthly basis using SQL Server ETL Packages when new ITC SAP data become available

●Worked on stored procedures and creation of tables/views/triggers and using SQL for all the back-end functionalities.

●Performed normalization of tables in database and written SQL queries using T-SQL.

●Developed UI Pages using ASP.Net web forms, html, CSS, JavaScript and JQuery.

●Implemented forms authentication in application. For some of the internal applications, implemented windows authentication.

●Designed and developed common components using WCF services.

●Consumed Web Service from ASP.Net application using Http client

●Used Master pages, User controls, Custom controls to suit user's needs.

●Used Visual Source Safe for Version Control.

●Generated reports using the SQL Server Reporting services (SSRS)

●Involved in the process of defect tracking & bug fixing during UAT Phase.

●Created the UI framework using ASP.NET, JavaScript and JQuery.

Environment: Visual Studio 2005, C#, ASP.NET, WCF 3.0, JavaScript, HTML, SOAP, CSS, XML, SQL Server, Crystral Reports, SSRS

Client: Net Access India Pvt Ltd., Chennai, India

Duration: Aug 2005 – May 2006

Project: Container Tracking System

Role: .Net Developer

Designed and Developed Container tracking desktop application to keep track of voyage containers of a shipping company. The application was designed in N-tier architecture and developed using C#, WPF, Generics, XML, SQL Server.

Responsibilities:

●Interacted with the end-users and business analyst to identify business requirements and gather the requirements for business logic fulfillment, Analysis and coding of the application.

●Involved in enhancing already existed applications which were written in both VB.NET and C# as well.

●Designed and developed the C# components for implementing business logic in middle tier in 3-tier application interacting with SQL Server database using Managed provider using ADO.NET.

●Created a rich user interface using WPF and AJAX with JQuery.

●Developed complete Data access layer Component using C#.

●Developed Crystal Report to generate various reports Implemented Form Based authentication and Role based authorization to authenticate users.

●Used ADO.Net Technology to connect the forms to data sources such as MS SQL Server and Xml files for manipulating data in database.

●Developed SQL queries, T-SQL stored procedures, Functions, triggers to handle the business rules data integrity and for various data transactions.

●Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like excel Access and Oracle.

●Used in Source Code Control Systems like MS Visual Source Safe (VSS) and Team Foundation Server (TFS), Cruise Control .NET

●Performed extensive Unit testing, developed Test Plans, Test Cases.

●Visual SourceSafe was used to maintain the version and source control.

●Perform coding, unit testing and functional testing as per the design and requirements.

●Deployed web application on Internet Information Server for production.

Environment: ASP.NET, C#.Net, XMLSQL Server 2008, Visual Studio .NET 2005,.NET Framework 3.0, Stored Procedures, IIS 6, MSMQ, UML, Oracle, WinForms, XML, XSL, ASP .NET, VB.NET, Oracle, Crystal Reports and JavaScript.

Client: Bitscape IT Solutions Pvt Ltd., Ahmedabad, India

Duration: May 2004 – Mar 2005

Project: E-Governance

Role: .Net Developer

E – Governance was developed for the State Government, follows the rules and policies of Govt.of India, to decrease paper work and increase work efficiency in Government Offices. E - Governance application is developed for atomizing the Government Property Management with Tax collection work and maintains areas, society and property details maintenance with financial year. Multilingual and user authentication support were given in application. Various Certificates like Birth/death/residence/income/ can be generated either in English or in selected local language.

Responsibilities:

●Involved in complete life cycle of project including Design, Development, Unit Testing and Implementation.

●Developed an N-tier application with UI in the presentation layer, Business logic in the middle layer using C#, ASP.NET and SQL Server in the backend.

●Involved in the requirement discussion & gaps in them with Client during UAT phase.

●Designed and developed web pages using ASP.NET and implemented code-behind logic in C#.

●Worked extensively on OOPS concept of C# using Inheritence, Polymorphism, Abstract class etc.

●Migrated database from MS Access to SQL Server 2000.

●Worked on Client Side validation as well as Server side Validation by using JavaScript and ASP.NET Validation Controls.

●Used Master Page for the Header and Footer of the page for consistent look across all the pages.

●Used Data grid and Data list objects extensively to add, update and delete recrods.

●Used ADO.Net extensively for data retrieving, querying, storage and manipulation.

●Application was developed to support multilingual interface.

Environment: ASP.NET 2.0, C#.NET, VB.Net, SQL Server 2000, XML, ADO.NET

Client: Poonam Infotech, Baroda, India

Duration: May 2003 – May 2004

Project: Production Manager

Role: .Net Developer

Production Manager application was developed for a Pharmaceutical Company to provide support in production, Purchase and Sales Department with Financial Accounting. Application supported to store and manage Pharmaceutical product production information with batch numbers and expiry details. Also supported sales details/report with financial transactions.

Responsibilities:

●Involved in complete life cycle of project including Design, Development, Unit Testing and Implementation.

●Designed desktop based application using Winforms and Window Service.

●Designed and developed web pages using ASP.NET and implemented code-behind logic in VB.net

●Migrated database from MS Access to SQL Server 2000.

●Worked extensively on User Controls to resue code through out application.

●Used Data grid and Data list objects extensively to add, update and delete recrods.

●Used ADO.Net extensively for data retrieving, querying, storage and manipulation.

Environment: ASP.NET 2.0, VB.Net, SQL Server 2000, XML, MS Access

Contact this candidate