Sql Server Asp.Net

Amit Patel.

Senior .Net, BI, Azure Developer

Brampton ON Canada L6P 1V2

Phone: 647-***-****

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

https://www.linkedin.com/in/2648patel/

Professional Summary:

15+ years of experience on Microsoft Technologies and extensively on .NET Platform encompasses many projects of full Software Development Life Cycle covering – Feasibility study, Requirements analysis & gathering, Systems Analysis, Software Architecture, Project Deliverables, Solution Development, Testing, Debugging, Deployment, Implementation, Documentation, User Training, and Post Implementation Support delivering to major clients in both the public and private sectors.

13+ years of experience in .NET in using .Net Platform Framework (.net 1.1 -4.6 and .net core 1.0 to 3.0), MVC, C#, VB.NET, ASP.NET,Visual Studio Code, Visual Studio 2022 to 2005, ADO.NET, LINQ to SQL, Win/Web Forms, Windows Services, Web Services, WCF, Web API, Web Controls, User Controls, JavaScript, VB 6.0, XML, XSLT, XSD, JSON & Code repository tools like TFS, VSS and GitHub

Extensively worked in SQL Server 2019 to 2005, Created numerous simple to complex SQL Queries involving joins, sub-queries with Views, Stored Procedures, UDFs, Triggers, Tables, Cursors, SSRS, SSIS, T-SQL, Data Modeling, Data Management & Integration, database optimizing and tuning, SQL Query Analyzer, SQL Management Studio.

5+ years of experience in the retail sector for financial services credit card reward bonus system.

5+ years of extensive Functional domain expertise in clinical research data collection.

4+ years of experience on Content Management System, E-Commerce Application, Store-front management and Contact management system.

2+ years working with GCP Cloud environment using GCP cloud, big query, big bucket, schedule query, stored procedure and views

1+ year experience in reactJS and NodeJS for front end and back end application

Extensive working with Agile/Scrum development methodologies to ensure delivery of high quality work

Sound experience in designing N-Tier Application Architecture, Design Patterns using Object Oriented Pattern (Factory, Abstract Factory, Builder, Prototype, Iterator, Observer, Command etc.), Web, Intranet, Client-Server targeting MS Technology

Able to work with and maintain relations with staff and clients on all levels

Capable of rapidly learning new technologies and processes.

Technical Skills:

Microsoft Technologies

Visual Studio 2019 to 2008, Visual Studio Code, IIS, SSIS, SSRS

Cloud environment

GCP, Azure Cloud, ADF

Scripting Language

ReactJS, NodeJs, JQuery, Java script, AngularJS, VB Script, CSS, HTML, XHTML

Programming Language

C#.Net, VB.Net, MVC, ASP.Net, Web API, XML, XSLT, C, C++, VB 6.0

Databases

SQL server 2019, 2017, 2016, 2014, 2012, 2008, 2005, Oracle 7i

XML Technologies

XML, XSL, XSLT, XPath, SOAP, WSDL

Code Repository Tools

Team Foundation Server (TFS), Visual SourceSafe, Git Hub

Operating Systems

Windows 11, 10, 8 and 7, Windows XP, Windows 2000/9x

Others

MS Office, MS Access, Data Structure, Telerik controls, EarthSoft EQuis 6.0

Professional Experience:

Senior Software Consultant (Contract) – Walmart Canada May 2018 – Jan 2025

WMRMC Bonus Reward: Responsible for calculating reward bonus points for different types of offers based on user spending on WM Master Card.

Collaborating with bank for payment data and merging with WM data in GCP using configurable offers to calculate and generate daily data file and send back to Bank

Product Planning: Responsible for design and development of product launch planning applications for private brand products, generating reports for after launch analysis for business team to take decision.

Responsible for design, development and deployment for product planning with agile methods

Separate client and server modules and design and build Web API and frond end client modules

Creation of new ETL (Extract, Transform, Load) using Microsoft’s SSIS toolset, Azure SQL, ADF, GCP Cloud, optimize existing ETL execution time and SSRS for reporting.

Train users in the operations, processes, templates and workflows used to new system. Provide help desk like support to end users.

Data Migration Consultant (Contract) – Canadian Nuclear Laboratories Feb 2017 – Mar 2018

Public/Federal organization with highly secure environment.

Migrate data from spreadsheets(Excel) and other sources into an environmental data management system using enterprise class COTS (Commercial Off The Shelf) software

Execute enterprise class workflows for data migration

Cleanse and transform data to prepare it for migration, using ETL (Extract, Transform, Load) principles and practices, Microsoft’s SSIS toolset, Excel, and any other tools the team selects

Interact with clients to resolve issues related to data migration

Generate reports and documentation that reflect the status of migration data and activities, and the environmental database

Attend status meetings, submit periodic status reports and weekly timesheets

Software Consultant (Contract) – Crawford & Company, Waterloo Nov 2016 to Jan 2017

Responsible for automate internal process of two system work flow using RPA software (AutoMate, UiPath)

Environment: Robotic Process Automation Software, Microsoft Exchange server, SQL server 2014

Software Consultant (Contract) – M&M Food Market, Mississauga Sep 2016 to Nov 2016

Responsible for design and development of Commitment to Excellence Review project that collect the store review from all regions by area manager.

Environment: Microsoft Visual Studio 2015, ASP.Net 4.5, C#.net, MVC 5, LINQ to SQL, IIS, SQL Server 2014, AngularJS, Javascript, JQuery and Bootstrap

Senior Software Developer – HealthDiary Inc, Toronto Nov 2010 to Sep 2016

Responsible for design and development of Electronic Data Capture System that revolutionized clinical research by making the collected data instantly available for reporting and analysis, allowing the researchers to be proactive and resolve any potential issues before they affect the study outcome

Environment: Microsoft Visual Studio 2013/2012/2010/2008, ASP.Net 4.5/4.0/3.5, C#.net, MVC, ADO.NET, LINQ to SQL, IIS, SQL Server 2014/2012/2008, SQL Server Reporting Server, SQL Server Integration Services, DBMS, SQL Profiler, javascript, AngularJS

Used N-tier architecture to implement designed requirement and enhance product to fulfill client requirement and responsible for unit testing with fixing bug in QA testing environment

Responsible team member to build Medication and safety tracking to record and keep track of Adverse Events(AE) and Serious Adverse Event(SAE) and receive real-time notification and alerts for events requiring follow-up and further audits

Team member for Visit Management that automate visit scheduling process to ensure that the visits are scheduled accurately as per study protocol as well as the user is notified of upcoming visits.

Slash 30% time to generate report by developing dynamic report generation module.

Design Database Tables, wrote stored procedure, functions, triggers and complex queries in SQL Server for developing projects

Created a variety of reports using SSRS, SSIS to import/export data from SQL to flat files, XML, Excel and vice versa.

Enhanced problem solving skills by acting as a highly dependable technical support person for a variety of the projects by fixing bugs within the software.

Greatly improved both verbal and written communication skills by gathering software requirements from clients and writing specification and design documents.

Deploy and maintain ASP.net Web application to testing (UAT) environment.

Backup and restore database and generate script to remove client personal and sensitive data for UAT database

CHILD Study: A Canadian longitudinal birth cohort study of 3500 children (born after 2010) involving 3500 moms and 2600 dads will examine the influences of genetic predisposition and environmental factors on children's development.

oDevelop Case Report Form (CRF) design module which became flag ship module for the HealthDiary and helped CHILD Study to build and manage around 200 questionnaires.

oBuild robust Lab Management Module to track, ship and store the human specimen like cord blood, meconium, urine, breast milk etc.

COSMIC Study: A Canadian Observational Study in Metastatic Cancer of the Prostate: A Study of ZYTIGA Use in the Community Urology Setting.

oDevelop Monitoring work flow to perform the Source Data Verification (SDV) utilizing Agile/Scrum environment

oConfigure iPad for study specific uses only & control each iPad using Meraki system by Cisco

Software Consultant (Contract) - Marlborough Stirling Canada, Toronto, May 2010 to Aug 2010

Responsible for development of Financial Software - “Mortgage underwriting, fulfillment and funding system” utilizing Agile/Scrum environment

Integration development of Third Party Services like “Experian Credit Check, Countrywide Valuation and Countrywide Conveyancing” using C#, WCF, XML, XSLT.

Code Development, Code merging, Web Service test scripts and code review between core code, Design Patterns company standards & Industry best practices, client specification, Interaction with QA team.

Migration (VB6 to .Net C#), Code Improvement, Code Review, numerous simple to complex SQL queries (T-SQL) involving joins, correlated sub-queries with Views, Stored Procedures, UDFs, Triggers, and Cursors using SQL Management Studio & SQL Query Manager and Bug Fixing for desktop & web applications modules from Visual Basic 6.0 & .Net 1.1 to C# & .net 2.0.

Software Developer – Plus One Technical Solutions, Ahmedabad, India. Aug 2005 to Feb 2010

Responsible for development of Content Management System that manages 43 web sites

Developed the web pages using ASP.NET, C#, HTML, and CSS for styling the Web pages and used OOPs Concept in business layer and write stored procedure at database layer. .

Developed web site publish module for web content management.

Used 3-tier architecture in C# to create web pages at presentation layer, Integrated PayPal payment gateway web service for E-Commerce sites

Develop XSLT to transform XML Data into different format like HSML, CSV and PDF

Migrated of classis ASP applications to ASP.Net and C#, MS Access to SQL Server

Environment: Microsoft Visual Studio(2005,2008), ASP.Net(2.0, 3.5), ADO.NET, IIS, SQL server(2005,2008), XML, XML Spy

Education & Certification:

Certificate – Good Clinical Practice ICH GCP, Informetica - Aug 2013, Toronto, Canada.

Master in Computer Application, North Gujarat University - May 2005, India.

oAccredited as 3-year Canadian master degree by WES in 2010.

Bachelor in Computer Application. North Gujarat University - May 2002, India.

oAccredited as 3-year Canadian bachelor degree by WES in 2010

Reference: Provide upon request.

Contact this candidate