Sales Sql Server

Mohammed Nawaz

** ****** ******, ******, ** – ***65.

Home: 504-***-****

Cell: 504-***-****

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

Objective:

To continue to apply my IT Analytical and programming skills to a professional organization where I can

contribute to the Company’s growth and IT development.

Experience Summary:

15 years of Information Technology experience, including eleven years with Consolidated Companies, Inc.

d/b/a CONCO Foods Service located in Metairie, Louisiana. Very Strong skills in Application database

analysis, design, development, integration, interface, data extraction, implementation, administration,

documentation, support and ad-hoc reporting. Excellent oral, written, and interpersonal communication skills.

Managed multiple Projects both independently and as a team member.

Educational Summary:

• Bachelor of Commerce from Osmania University, India.

• 3 years Diploma in Systems Management from NIIT India.

Technical Skills:

Operating Systems : MS Windows Server 2000, 2005, 2008, Windows XP, 2007 UnixVer. 6.1

Databases : Microsoft SQL 2000, 2005, 2008, Access, Progress 10.2b

Languages : SQL, VB, FoxPro, C, Progress 10.2b

ERP Application : TDS (Target Data System) and QAD MfgPro

Other Application: Acorn Profit Analyzer (ABC), SalesLogix, SalesForce, RoadNet,

Lucas (Voice Activation for Picking and Loading)

Report Application : Business Objects, Crystal Reports, Actuate

Professional Training:

• Programming in Microsoft SQL Server 2005 Database, 2000 Database

• Microsoft 2003 – Manage & Maintain Microsoft 2003 Server

• Acorn Systems – Activity based Costing

Professional Experience:

September 1st 1999 – Present

Consolidated Companies Inc. /d/b/a/ Conco Foods Service Metairie, LA

Position: Business Data Analyst / Programmer

Provide technical and functional expertise to users in more than one area of the TDS ERP application

modules. Enhancement and modification to most modules of TDS application, integration, interface, data

extracts, support and administration of other software applications on SQL Server 2005, 2008 like RoadNet

application used for daily route planning, SalesForce for Salesman performance tracking, ADP for Payroll,

Lucas for warehouse picking and loading, Prophix and FAS used for budgeting and Fixed Asset, Management

Occasional administration, installation, upgrades applications running on Microsoft servers.

Support Logistics, Sales, Procurement and Finance as chief member of the cost object analysis group. Using

Acorn Profit Analyzer on SQL Server 2008 and Crystal Reports, design, develop and deploy various cost

object profitability and trend analysis reports on all dimensions like district, salesman, customer, Item, chain,

sic and buyer.

Responsibilities:

• Support users in all departments to ensure the smooth operation of production systems running on

various platforms

• System analysis, design, development, testing, implementation and documentation of enhancements

and modifications made to the production systems

• Support Logistics, Sales, Procurement and Finance as chief member of the cost object analysis

group. Using Acorn Profit Analyzer on SQL Server 2008 and Crystal Reports, design, develop and

deploy various cost object profitability and trend analysis reports on all dimensions like district,

salesman, customer, Item, chain, sic and buyer on a quarterly basis.

• Data extraction to logistic department for analytical and planning purposes

• Design and develop data interface for windows based applications running on SQL Server to

integrate with the primary ERP system running on Unix

• Administration and upgrade of applications running on SQL Server, database backups and restore

• Debug, modify and develop new reports using Crystal, SQL and Progress 4gl as requested by end

users and management

Project Undertaken:

• Worked as a team member in implementation of Target Data System for a Conco Warehouse in

Lafayette dealing with National/Regional contract vendors.

• Enhanced the payroll system to integrate and extract warehouse and operating employee’s

productivity data and calculate their pay off of their productivity data.

• Designed and developed programs to interface and integrate the Primary ERP system with other

applications running on SQL Server 2003, 2005 and 2008 such as Roadnet, SalesLogix, SalesForce,

Prophix and ADP.

• Designed and developed programs to automate

o Orders send thru various sources into primary ERP System

o Route data transfer to and from Road Net application on SQL Server 2003

o Checks data transfer to and from Chase Bank

o Warehouse Employees punch in/ punch out times from ADP software

o Data extract to customers, vendors on daily, weekly and monthly basis

• Upgraded Crystal Enterprise reporting tool from version 8 to Version 10 on SQL Sever 2005

• Migrated Activity Based Costing Application from an older version to the 2010 Version on SQL

Server 2008.

• Designed, developed and deployed reports using Crystal, SQL Database, Progress Database for end

users, customers, vendors, sales and logistic department

April 1st 1997 – May 31st 1999

Bluechip Computer Consultants Private Ltd. Bangalore, India

Position: Senior Programmer Analyst

Responsibilities included enhancements and implementation of add-on modules to QAD’s MFG/PRO ERP.

Work involved customizing the existing modules of the MFG/PRO system to follow the business logic and

processes used by the client, interaction with the end user in developing functional specifications for

enhancements and/or modifications, coding and testing those enhancements and/or modifications. Major area

of work involved working with Progress RDBMS and 4GL on Manufacturing, Distribution & Planning and

Sales modules of MFG/PRO ERP.

The following is a list of Projects for in a consulting capacity:

ROC (Regional Operational Center) - Hindustan Lever Limited, Bangalore India

• Contributed in Design, development and implementation of this entire module, .

• gather all sales requirements for the branch and also inter-branch

• The outputs generated immediate production and distribution plans for the overall factories under

the branch

• Optimized machine utilization for production by providing detailed machine wise production plans

using a “smoothening process”

• Complete distribution plan for the warehouses under the branch

• The module works on the concept of user defined time frames (buckets). It generates a firm

distribution, production and dispatch plans for the current bucket and a tentative plan for the next 12

buckets.

• Other outputs provided details of 13 week rolling production plan, forecast vs. actual sales and stock

cover and machine utilization reports.

OPAC (Oil Purchase Accounting Center) - Hindustan Lever Limited, India

• Contributed in the complete system development life cycle and implementation of this add-on

module of MFG/PRO.

• The module was used to purchase raw oil from suppliers through brokers.

• Manage supplier contracts, charge penalties when contracts are not met in due time and maintain

advances if any given to the suppliers.

• Lab Analyze when oil is received, accept or reject oil received based on the rebate percentage set in

the system.

• Designed and developed reports to provide details of oil volumes received over time periods,

suppliers. Price analysis based on the contracted and market rate.

• Retro billing suppliers based on QC and/or invoicing issues.

DPS (Dispatch Processing System) – Hindustan Lever Limited, India

• Implemented this add-on module of MFG/PRO, which helps to dispatch and sell finished goods

from the factory to the warehouse and redistribution stockists.

• Numerous reports were modified to generate a weekly dispatch plan, generate and print loading slips

and gate passes, daily stock status, dispatch details and inter unit transfers.

October 23rd 1995 – March 31st 1997

Hindustan Lever Limited, Bangalore, India

Position: Systems Consultant

Responsibilities included customization and implementation of various add-on modules to integrate other

related functions of the MFG/PRO ERP application, in Progress RDBMS on the UNIX (DEC Alpha)

Platform. The projects worked on included MFG/PRO Field Distribution Module (FDM) and Branch

Commercial Module (BCM).

FDM (Field Distribution Module) – Hindustan Lever Limited, India

Implemented these modules at various warehouse and branch locations to monitor sales, receipts, sales

returns, bank transactions, claims adjustment, check bouncing, and other transactions.

References Available Upon Request

Contact this candidate