Sql Server Sales

Ajay Jaiswal

Cell No: +* ***- ***- ****, Email Id: **********@*****.***

CAREER HIGHLIGHTS

** + years of experience in analysis, design and development of client/server, web based and n-tier application. Expert in developing windows applications, web applications in Microsoft Visual Studio .Net IDE using, VB.NET, C#,ASP.NET, ADO.NET and SQL Server.

Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update relational database.

Extensive experience in SQL Server Database design, Database maintenance, developing T-SQL queries, stored procedures, and triggers using SQL Server.

Extensive experience on Alchemex Reporting (Sage Intelligence) Business Intelligence SageX3

Extensive experience on Sage Enterprise Intelligence Business Intelligence Reporting tool

Expert in debugging an application using the debugging tools provided by the Visual Studio.NET IDÉ.

Experienced with full Software Development Life Cycle (SDLC) with proven ability to translate and document business requirement into technical specification and software requirement specifications

Proven track record of delivering project on time by utilizing organization, planning and team management skills. Ability to communicate complex requirements clearly and precisely to individuals with different technical background including members of the multi-disciplinary team, management, clients.

Bachelor’s degree in Computer science; Certified Sage ERP X3 Consultant

TECHNICAL HIGHLIGHTS

Microsoft Technologies VB.NET, ASP.NET, VB 6,C#

Languages C, C++

Web Technologies ASP, ASP.NET, HTML, JavaScript, VBScript, DHTML

JQuery

Databases Technology MS SQL Server, Oracle, MS Access, ADO, ADO.Net

Application Servers: IIS, Apache

Report Writer Crystal Reports, Data Report

ERP Sage ERP X3 V6

Business Intelligence Sage Intelligence-financial Reporting

Sage Enterprise Intelligence, SQL Server Reporting Service, SQL Server Integration Service

CAREER HISTORY

ERP Consultant 2014-till Date

IWI Consultancy (IT Consultancy)

Designed, developed and integrated “Macros” using VB.NET,C# and VB 6 to Sage ERP 300

Analyzing customer’s business requirements, business solution objective and mapping them to Sage X3 ERP solution

Identifying potential opportunity for additional revenue generation by providing business solution to customers.

Customized SAGE X3 ERP Screen, Reports and Import and Export Templates

Designed and developed Web based mobile application to integrated Sage ERP 300 using C#, SQL Server, Asp.net and JQuery.

Designed and developed reports using business intelligence tool such as Sage Enterprise Intelligence and Sage Intelligence-financial reporting tool

Senior .Net Developer 2010-2014

Harleys Ltd (Importer, Distributor & Exporter of Pharmaceutical products)

Designed, developed & integrated Web & Windows based Business Intelligence tools using Microsoft Technologies to present information to users in required format from the Sage X3 ERP SQL Server Database

Designed & developed Web based application for Sales Representatives using Microsoft Technologies (C#, SQL Server, ASP.NET)

Designed and developed windows based Payroll System using C# and SQL Server

Used N-tier architecture for presentation layer, the Business and Data Access Layers

Written stored procedures, triggers using SQL in SQL SERVER 2005.

Worked intensely on the User Interface.

Prepared project implementation plans, tracked project execution, managed changes and executed implementation of Sage ERP X3 within 6 months using budget of 200,000 USD with team size of 2 functional and 1 technical members

Customized SAGE X3 ERP Screen, Reports and Import and Export Templates

Performed Patch integration, Workflow Management, Process designing, User rights management

Provided training of Sales, Purchase and Inventory modules to ERP 50 plus Users

Designed and developed reports using Sage Intelligence-financial reporting tool

Senior .NET Developer 2007-2010

Nanosoft Technologies Ltd. (Providing Customized Business Software Solution)

Gathered, analyzed and translated business requirements into the software requirement specifications and technical specification for customized software solution for Pharmaceutical industries with 80+ users

Designed and developed complex logical and physical database design of multiple modules including Finance, Purchase, Sales and Inventory

Managed, coached and motivated a team of 5 developers to ensure high quality of the delivered product

Designed, developed and tested business logic components using Object Oriented Programming Methodology to encapsulate complex business requirement.

Wrote and tested stored procedures and triggers to improve database performance

Contributed to team success by meeting key project milestones and overall project deliverables on time and within budget, while adhering to development and quality standards

Participated in development and review of test plans and test scripts ensuring adherence to agreed upon business requirements

Designed and developed complex Crystal reports for Sales & Accounting Modules

Programmer Analyst 2005-2007

Benson Informatics Ltd. (Providing IT Services)

Designed, developed and implemented Software business solutions such as Payroll, Inventory Management System, and Accounting System

Conceptualize, designed and developed web portal for buying and selling cars online using Asp.Net, VB.Net and SQL Server

Led the team of 2 developers and 1 function expert to design and develop Inventory and accounting software followed by multiple successful implementations of the product

Operation Manager 2002-2004

E-Learn InfoTech (New Horizon Franchises Training Institute)

Managed operational activities of Learning Center including batch and course scheduling, course designing

Conducted practical and theory sessions for Visual Basic, MS SQL Server, C++ courses

Presented seminar on future computer technologies such as Mobile Application Development to final year students

Mentored and motivated 5 to 6 junior faculty for advance computer training

Team Leader/ Analyst 2001-2002

Poonam InfoTech (Providing Business Software Solution)

Conducted business and technical studies, prepared software requirement specification, designed, developed and implemented software business solutions for Multi Level Marketing Company with more than 3000 Members

Led a team of 4 developers to deliver a customized software solution

Designed and developed generic modules for team members to utilize across the projects

Software Engineer 2000-2001

CYN Corporation (Providing IT Consultancy)

Developed a COM components/business layer for Intranet solution

Wrote complex code using Java scripts, stored procedure, ASP.Net

Preformed testing and debugging of existing visual basic programs

Developed and designed Crystal Reports

EDUCATIONAL QUALIFICATION

Bachelor of Computer Science, Osmania University (Evaluated by World Education Service)

TRAINING AND CERTIFICATIONS

SAGE ERP X3 Application (Finance & Distribution) - 2014, SAGE ERP X3 Implementation, 2014, SAGE ERP X 3 Technical, 2014

Contact this candidate