Post Job Free

Resume

Sign in

Management Sql Server

Location:
Morton Grove, IL
Posted:
January 18, 2016

Contact this candidate

Resume:

Samit Shah 267-***-****

acs5sh@r.postjobfree.com

PROFESSIONAL SUMMARY

12+ plus yrs. Experience as Tech lead and Senior Developer doing analysis, design, implementation, development and enhancements of commercial Applications using ASP.NET MVC, .NET Framework 4.0,3.5,2.0, C#, ASP.NET, VB.NET, ASP, VB6.0, ADO.NET, SQL Server 2008/2000/7.0, Web Services, WCF, WPF, Visual Studio 2010, 2008, 2005, HTML, ActiveX, JavaScript, VBScript etc.

Hands on experience in Software Engineering, Database Management System (SQL, PL/SQL, T-SQL), Client Server Architecture and Interface, OOADM, TCP/IP, OOPS, Microprocessor, Operating System, System Software, Data Communication, Parallel Processing, Data File Structure, Operation Research, Computer Graphics, Statistics, Accounting and Financial Management.

Expertise in design and development that involves ER Modeling, Relational database schema, functional dependencies, Normalization of tables, Stored Procedures etc.

Ability to quickly understand and utilize new technologies and suggest possible application enhancements.

A team player with excellent interpersonal, communication and presentation skills.

Educational Qualification

Master in Computer Application from L. D. College Of Eng., Ahmedabad, July 2000

B. Sc. (Chemistry) from R.G. Shah Science College, Ahmedabad, May 1996

TECHNICAL SKILLS

.NET Technologies

.NET 4.0/3.5/2.0, WPF, WCF, ADO.NET, LINQ,Web Services, Json Web Services, VS2010/2008/2005, Asp.net MVC

Programming Languages

C#, C, C++, BASIC, Java 1.1,PHP, Java Script, VB Script, JQuery, Bootstrap, Angular JS

Web Technology

ASP.NET 4.0/3.5/2.0, AJAX.NET, CSS, HTML, XHTML

Web Servers

Windows Azure, Cloud, IIS 7.5, IIS 6.0

Databases

MS SQL Server 2008/2005/2000/7.0, Oracle 11g, 8.x

Methodologies/OOAD

MS Visio 2003, UML

Operating Systems

Windows 2008/2003/XP, Windows – NT, Windows 9x, MS-DOS 6.22, Unix V, Linux 2.0.0 (Slackware)

Version Control

TFS, SVN, VSS

PROFESSIONAL EXPERIENCE

Project Name: JMS & POS - Systems

Role: Sr. Software Developer

Client: IMS Inc., Morton Grove, IL Duration: May 2015 – Present

Project Description: JMS application contains various modules. Job management module, SKU Management, Communication between JMS & JDE System by web API, Dynamic Content management & Admin User role management module, customer/institutional orders billing, other institutional and MIS reports etc.

Roles and Responsibilities:

Develop comparison routine for SKU’s and all related data between JMS and JDE System with multi-threading and parallel tasks using Quartz jobs.

Compass Integration system upload files to SFTP server by using Go Anywhere projects.

POS is the e-commerce website for Order processing & SKU management system.

Requirement gathering, analysis and time estimation, implementation on prod server.

Problem solving on production environment.

Environment: ASP.NET MVC 4.0, Web API, WCF,SQL Server 2012, Telerik – kendo controls, Ajax, jQuery, Bootstrap, CSS3, HTML etc.

Project Name: Data Migration & OSS-Web

Role: Team Lead / Sr. Software Developer

Client: Evidia Bio-sciences Inc Duration: Dec 2013 – April 2015

Project Description:

OSS application contains two modules. Client management module covers Doctors information along with other users like patients, lab staff etc as part of this system. Reporting module contains various reports for all users, prescribed laboratory tests to patients, customer/institutional billing, other institutional and MIS reports.

DataBridge application is design as intranet application for internal users. It’s a bridge between two existing applications.

oThis application is used for data verification and updates, apply discounting, pricing calculation and various reports.

oSSIS packages are design for Data-migration from Oracle to SQL Server and SQL Server to ADS database.

Roles and Responsibilities:

Team Management, architecture design, database design and technical specification documentation.

Requirement gathering, analysis and time estimation, implementation on prod server.

Apply SSIS package related changes, UI and functional changes in application.

Designed REST API. Deploy application to IIS.

Environment: ASP.NET MVC 4.0, Web API, Oracle 11g, SQL Server 2012, Advantage Database Server, SSIS (Visual Studio 2008), Telerik – kendo controls, JQuery, Bootstrap, Data Reports

Gateway Technolabs - June - 2006 to Nov 2013

Project Name: Create new Architecture and Migration System to Cloud (E&O – T&A)

Role: Sr. Software Developer

Client: Aditro –Sweden Duration: Dec 2012 – Nov 2013

Project Description:

Developed framework using MVC architecture to make existing application compatible for Cloud environment.

We have made changes in existing systems E&O (Employment & Organization) and T&A (Time & attendance) by using new framework to make it cloud compatible using multi tenant data architecture.

Roles and Responsibilities:

Involved in making nugget packages for existing binaries.

Involved in making changes in existing WCF services to make it cloud compatible.

Implemented single sign on functionality with security framework using Microsoft certificate for user authentication.

Implemented all the framework related changes, authentication changes, Menu and UI changes for new version of E&O application and make it compatible with Azure Emulator 2.1 on cloud environment.

Involved in kick off of project meeting at Sweden office.

Implemented scrum and agile methodology with different team and TFS as a Bug/Issue & task reporting tool.

Team Management, architecture and database design, technical specification documentation

Analysis of system and time estimation, implementation on production server.

Environment: ASP.NET MVC4.0, SQL Server 2012, .NET Framework 4.5, 4.0, WCF, Windows Azure Emulator 2.1, TFS 2012, TenantDB, TFS.

Project Name: Invoice & Purchase Management System(IoF)

Role: Sr. Software Developer

Client: Aditro – Sweden Duration: Jan 2012 – Nov 2012

Project Description:

This system has been developed for Purchase life cycle. It includes Purchase order, Invoicing, Buyers, suppliers, materials in and out and overall flow of the business.

It includes following features

oPurchase invoice: It is used for creating of purchase invoices and send invoices in different formats across all the users in workflow.

oOrder processing: It’s about handling of create and send orders and change order before invoicing.

oAlso manage other processes like accounting and posting, purchasing and material in and out, delivery surveillance, supplier details and agreement.

Roles and Responsibilities:

Team Management, architecture and database design.

Requirement gathering, analysis and time estimation, implementation on production server with IIS configuration.

Work allocation, Time and resource management, research work and data processing etc. by using mantis as a bug reporting tool for issue tracking & enhancement for production issues, time estimation & solving issue with in team.

Environment: ASP.Net 4.0, C#, VC++, MS-SQL Server 2008, ASP, Telerik & Ajax Toolkit.

Project Name: Online Email Marketing Mgmt. system, Assembly Engine & Maintenance

Role: Sr. Software Developer

Client: Thindata (TC), Canada Duration: Oct 2009 – Dec 2011

Project Description:

The objective of application is to optimize and enhanced different existing applications and migrate into new cutting edge robust technology along with new business processes.

This system includes following different applications

oDA, Send Mail, Dynamic link Missing checker component, VB Script Error notification

oAAQ, Misc Services and PLJ(Prepare Launch Job) applications

oCommon Import Utility for custom specific import has two parts Queue Generator and Queue Importer.

oIt is the utility which has to process the recipient’s data in very optimum time and memory uses for Email Marketing System.

oRetrieve the xml files from FTP having all the details about recipients, de serializes XML files, create demographics as number of nodes XML has.

oCreate broadcast and Divide xml into chunk of CSV as number of demographics

oUsed DTS and core logic to map with the database object and transfer data from CSV to real database object.

oDevelop background SQL jobs by using Stored Procedure with Cursor implementation.

Roles and Responsibilities:

Requirement gathering and existing system analysis.

Work, time and resource management

Involved in R&D database transaction logs, configure application on IIS.

Environment: ASP.NET Framework 2.0, 3.5, C#, VB.NET, SQL Server 2008, 2000, ASP, VB, Ajax Toolkit.

Project Name: Online Vehicle Advt/Booking Management system

Role: Team Lead / Sr. Software Developer

Client: exportWagon – Netherlands Duration: Oct 2008 – Oct 2009

Project Description:

The objective of this application is to maintain vehicles stocks, display and order booking.

This system includes different modules are as follows

oCars advertisement and order booking from buyers. It includes variety of search methodology, dealer management, buyer management, vehicle management, sharing methodology between different dealers, news-letter generation for upcoming new cars.

oCron job for data transfer from third party web services to our database

oAdmin management.

The features included in the system are as follows: search module covers (Quick Search, Details Search, PKW Search, LKW Search on vehicles), Dealer module covers new vehicle management, dealer information, stock managements etc., Buyers module cover order booking for vehicles, buyer information management etc., Corn utility covers data transfer from 5 different third party web services and import data into exportwagen system.

The other features are the whole system is multilingual with 16 existing languages, URL rewriting for public site, communications between buyers and dealer, admin site vehicle management, content management, user managements, language management.

Roles and Responsibilities:

Team management, architecture and database design,

Requirement gathering, system analysis, estimation, implementation on production server.

Developed online news-letter generation system for upcoming new cars through data and send to the entire subscribers dealer, buyer etc.

Import/export vehicles data form XLS files to exportwagen database and vice-versa.

Environment: ASP.NET Framework 2.0/3.5 - C#, VB.NET, MS-SQL Server 2005, Ajax Toolkit.

Project Name: Resort Management system

Role: Team Lead / Sr. Software Developer

Client: Zion Ponderosa Resort – Mountain UT, USA. Duration: Oct 2007 – Sep 2008

Roles and Responsibilities:

Team management, knowledge transfer, estimation for whole system and database design.

Requirement gathering, system analysis, SRS generation, design and implement with UAT testing on production environment.

Environment: ASP.NET 2.0 - C#, MS-SQL Server 2005, Infragistic WebGrid, Crystal Reports, SQL Server 2005 Reporting Services.

Project Name: Concrete Pumping Automation -eNETDispatch

Role: Sr. Software Developer

Client: Custom Pumping & Island Aggregate, Canada. Duration: Jun 2006 – Sep 2007

Roles and Responsibilities:

Knowledge transfer, estimation of system, client interaction, SRS generation, design and implement and integration testing for all the four application on production environment.

Analyze system, allocation of work, time management, data processing, make suitable environment for whole team to work and give deliverable on time.

Develop module to communicate with live server with data synchronization using BITS (Background Intelligent Transfer Service) and .NET remoting.

Environment: ASP.NET 2.0 - C#, MS-SQL Server 2000, SQL Server 2000 Reporting Services.

Company Name: Sarjen Systems, Ahmedabad Dec. 2003 to May 2006

Project Name: Field Force Reporting (Sales Force Automation)

Role: Senior Programmer

Client: (1) Cadila Pharmaceuticals Ltd. – India

(2) Intas Pharmaceuticals Ltd. – India Duration: Oct 2005 – May 2006

Environment: C#, ASP.NET, VB.NET, MS-SQL Server 2000, Crystal Reports 8.5, VSS etc.

Project Name: Desktop CRM

Role: Senior Programmer

Client: (1) Cadila Pharmaceuticals Ltd. – India

(2) IPCA Laboratories Ltd. – India Duration: Apr 2005 – Sep 2005

Environment: C#, ASP.NET, VB.NET, MS-SQL Server 2000, Crystal Reports 8.5, VSS etc.

Project Name: Sales & Distribution System (PharmaNET)

Role: Senior Programmer

Client: (1) Unichem Laboratories Ltd. – India

(2) Novartis – India Ltd. (For SANDOZ Division)

(3) Intas Pharmaceuticals Ltd. – India Duration: Dec 2003 – Mar 2005

Environment: C#, VB6, MS-SQL Server 2000, Crystal Reports 8.5, VSS etc.

Company Name: SMG Infosolutions Jan. 2003 to Nov 2003

Worked on various projects of Stock market and Finance domain are as follows as Senior Programmer

1.Project Name: Auto Demat Delivery System for Ahmedabad Stock Exchange as TL

2.Project Name: Credit Society Management System for SBI H.O.

Company Name: Shah Investor’s Home Ltd, Sep. 2001 to Dec 2002

Worked on various projects of Stock market and a portal are as follows as a Programmer

1.Project Name: Business Solution for Capital Market System

2.Project Name: NSDL Depository Participant BackOffice Management System

3.Project Name: E – Comm Portal B2B / B2C for Talent Info-way Ltd., Ahmedabad



Contact this candidate