Ajay Shah

**** *********** **

Waxhaw, NC *****

704-***-****

addkom@r.postjobfree.com

PROFESSIONAL EXPERIENCE

Software Engineer with 30 year’s experience in Dynamics SL Consulting (Solomon IV) and providing custom solutions to improve and extend features provided by Dynamics SL ERP System.

TECHNICAL SKILLS

Software Development: SQL, VB.NET, ASP.NET, Dynamics SL SDK

Reporting Tools: Crystal Reports, Sql Server Reporting Services

Databases: SQL Server, Oracle

ERP: Microsoft Dynamics SL

Financial Reports: Management Reporter, FRx

DYNAMICS SL PROJECTS

These are some examples of projects I have independently developed and implemented to provide a feature rich experience to Dynamics SL users:

Custom Crew Time Card System: Allows creation of crews, associating employees with crews, input of crew time cards in ASP.NET web forms as well as custom Time Card screen in SL. Procedures are written to automate creation of payroll time cards. Developed associated reports.

Job Management: Created a custom Jobs Screen that facilitates input of Jobs, Phases and Tasks. Additional screens are developed to input driver delivery tickets and creation of GL batches. This is a simplified custom Project Management system used by this company instead of out of box Dynamics Project Module, which they found too complicated for their operation.

Email Feature: A custom contact management screen and report distribution screen is developed to provide a simple and easy to use email functionality. This options is used by user to send out Invoices and AR Statements by using Database Mail feature of SQL Server. Automated email delivery of several custom data snapshots is developed to provide management team with information such daily sales report, daily deposit, cash balances, new customer additions, new service call additions, etc.

AR Feeder Screen: AR Feeder screen allows rapid creation of AR Invoices in simplified format. It also allows user to import invoices from excel. A procedure is written to roll-up this data and create Standard AR Invoices in AR Module.

Create IN Issue batch from AR Module: AR Invoice screen is customized to allow input of Inventory ID and cost from Inventory Module. A custom procedure is written to create Inventory Issue batches from AR Invoices. This process allows client to use simple interface between AR and Inventory module instead of using Order Management module.

Store Ticket system: This is a custom Point of Sale system developed by using VB Tools. Users can sale items from store by using hand held UPC Scanner. Ticket printing is done on a thermal printer. Store tickets can be created for internal employees or external customers. A procedure is written to push the data to employee deduction or AR Invoice depending upon type of customer.

Service Call Scheduling Screen: This screen was developed for a client to dispatch the crews to job site. The standard out of box Dynamics SL Service dispatch screen was limited in its features and also appeared to be very slow in performance. The new screen was developed to improve the performance and color code different state of Job to provide a quick and feature reach experience to the users in a fast paced operational environment.

Interfaces between Dynamics SL and Third Party Applications: Many interfaces have been written to import and export data from and to Dynamics SL screens such as Journal Entry, AR Invoice and Memo, AP Invoices, etc. The interfaces include screens to map data between two systems, import and validate the data in Dynamics SL and push the data to final Dynamics SL input screen.

Positive Pay: A Positive Pay screen has been developed to allow user to export the AP checks to the bank.

Export AP Checks: An interface is written to export AP Checks to external printing facility such as bank.

Custom Modules: A complete set of modules to provide automation of business processes that are not covered by Dynamics SL set of modules has been developed for multiple end-user companies. Such custom modules include setups screens, data input screens, reports and procedures to integrate the data with core financial modules.

Dynamics SL Upgrades, Implementation and End User Support: Over past 25 years, I have implemented Dynamics SL at more than 100 client locations. These implementations have included conversion of data from accounting systems such as Quick Books, Peach Tree etc.

Email Reports: I have written many management reports that are dispatched to recipients every day by SQL jobs or based on database triggers. Such reports provide instant notifications to the management team on important transactions and mile-stones in application database. EDUCATION

Bachelor of Engineering (Mechanical)

Diploma in Computer Programming

PROFESSIONAL CERTIFICATION

Sql Server 2008 R2

Crystal Reports

Microsoft Dynamics SL (Solomon IV) – Installation, Financials, Customization

Microsoft CRM 1.1 Installation and Configuration, Customization, Professional

EMPLOYMENT HISTORY

Company: Confidential

Title: Technology Architect

Date: Jan 2019 – To Date

Responsibilities:

Use expertise in Microsoft Dynamics SL ERP system to strategically design, develop and implement in-house information systems and networked software architectures that support core organizational functions. Provide technical leadership across the organization, from strategic decision making down to the project planning level.

Ensure that proposed and existing systems architectures are aligned with organizational goals and objectives.

Provide high-value Dynamics SL technology support to the overall enterprise.

Design, develop, and oversee implementation of end-to-end integrated systems.

Develop, document, communicate, and enforce a policy for standardizing systems and software as necessary.

Company: Microsoft Partner

Title: Senior Software Engineer / Principal Consultant

Date: Since April 2000 – Jan 2019

Responsibilities:

Independently develop and deliver business solutions to clientele. Responsibilities on each project include

Gather Business Requirements

High Level Design, Low Level Design

Process Flow Diagrams, Use Case Diagrams, Time and Resource planning

Data Modeling, Logical and Physical Database Design

Application Programming – Business Rules, User Interface, Database Stored Procedures, Triggers, SQL

Create Test Plans, Quality Control

Create Documentation - Technical, User Guides

Implementation on Staging Server, User Acceptance and Testing

Implementation on Production Server, Live Support

Version Control

Also responsible for End User Support on Functional and Technical aspects of ERP System – Microsoft Dynamics SL (Solomon IV).

Database Migration from legacy system into ERP system using DTS, SSIS and custom VB6 and SQL Programming tasks. Successful database migration projects include Peachtree to Solomon IV, QuickBooks to Solomon IV.

Skills Gained and include Sql Server Database Design and Development, Transact SQL, Stored Procedures, Triggers, SSRS, SSIS, Crystal Reports, VB.NET, ASP.NET, C#, Infragistics Tool Set, VB6.

Very Strong understanding and experience in Dynamics SL Database Structure and underlying Process Flow

Company: DUBAL

Title: DOCUMENTATION SPECIALIST

Date: NOV-1998 To APRIL-2000

Responsibilities:

Technical Documentation on Oracle Financials (ver 10.7.0 SC)- Modules GL, AR, Metal Invoicing.

Creation of user training scripts, documentation of DUBAL specific workflow & customization, descriptive Flex Fields, running dummy transactions with the user cocoordinator.

Online documentation using authoring tool – developing HTML & HLP based online help.

Created Technical User Specifications and documentation on Oracle Financial System

Access based cabling system

Online Help - using HTML / HLP authoring

Workflow Analysis using VISIO 4.0 software

Company: Eastern Falcon

Title: Senior Software Engineer

Date: NOV-1991 To Nov-1998

Responsibilities:

Design and Develop Custom Applications using knowledge and experience in Business Basic, Cobol, Clipper, FoxPro, Visual Basic, MS Access

Install and Implement Solomon IV Accounting and Hospitality Applications.

Develop interfaces – online and offline between Front Office, Back Office and Point of Sale applications by using interface protocols.

Project Management

Personnel and Payroll Software - Database Design and Application Programming in Visual FoxPro.

Point of Sale - Database Design and Development using Business Basic on SCO Unix Operating System

Point of Sale - Database Design and Implementation, Project Leader of Development Team - using Visual Basic, Access Database.

Human Resources and Payroll - Database Design and Implementation, Project Leader of Development Team - using Visual Basic, Access Database

Company: POLYGRAPH

Title: PROCESS ENGINEER

Date: Aug-1989 To Sept-1991

Responsibilities:

Business Application development in Clipper and FoxPro

Computer Aided Process Planning System - design and development using Clipper

Computer Aided Tool Costing System - design and development using Clipper, FoxPro

Implementation and training of AutoCAD software - programming in Autolisp

Contact this candidate