Aanand Channa

SQL Developer

Professional Summary Mobile No: 901-***-****

adbeef@r.postjobfree.com

I work as a Technology Evangelist (Database and BI) with Linkit Software Corporation. I have been a part of the industry for more than eight years. During my career I worked in India, mostly working with SQL Server Technology – right from version 2000 to its latest form. I worked on many performance tuning and optimization projects for high transactional systems. I received my Bachelor of Commerce from the Shivaji University of Kolhapur. Additionally, I have having knowledge of many technologies like, Developer 2000, Visual Foxpro, PHP, Zend framework, C#, C, C++.

Is a Consultant for MS Sql 2000/2005/2008, MySql. PHP, Zend framework, C#, Visual Foxpro 9 Worked in Software professional with over eight years of consolidated experience in Web and Desktop application development projects using Developer 2000, Visual Foxpro 9, Sql 2000/2005/2008 technologies. Possesses rich experience across post-design phases of Analyzing, designing, developing, coding and Reporting Services SQL Analyzer, performance tuning and development skills Diagnosing of faults, Clustering, Database design, Strong knowledge of DML, TSQL, DDL, Ability to create complex SQL queries, stored procedures, packages, functions, triggers, views, tables & indexes, SSIS packages, DTS packages and associated activities including Development, Creation of databases objects and structures, Managing large scale databases, Maintenance of SQL Server networking environment, SQL Implementation of SQL 2000/2005 to SQL 2008, and Strong knowledge in SSRS, Trouble-shooting and Support.

TECHNICAL PROFICIENCY

SQL Server 2008, SQL Server 2005

Performance Tuning & Query Optimization

Database Architecture

Achievement

Skills Profile

Technical

OPERATING SYSTEM

Windows 2000/2003/XP/2007/2008 server.

ENVIRONMENT

Desktop and Web.

DATABASE

MS 2005/2008, MYSQL5, Access Database, ORACEL 8i,9i.

REPORT

CRYSTAL REPORT

CMS

DRUPAL,JOOMLA.

FRAMEWORK

ZEND FRAMWORK.

TEMPLATE ENGINE

SMARTY.

LANGUAGE

DEVELOER 2000, VISUAL FOXPRO VER: 6-9, PHP5, C, C++, C#

CLIENT SIDE SCRIPT

JAVASCRIPT,JQUERY.

ARCHITECT EXP

ERD, ETL, DML, DDL, TSQL, DESIGN PATTERN, PERFORMANCE TUNING, DATABASE OPTIMIZITION, SSIS, SSAS, SSRS.

Analyzing, designing, developing, coding and Reporting Services SQL Analyzer, performance tuning and development skills, Diagnosing of faults, clustering, Database Design, Strong knowledge of DML, TSQL, DDL, Ability to create complex SQL queries, stored procedures, packages, functions, triggers, views, tables & indexes, SSIS packages, DTS packages and associated activities including Development, Creation of databases objects and structures, Maintenance of SQL Server networking environment, SQL Implementation of SQL 2000/2005 to SQL 2008.

ARCHITECT TOOL

ENTERPRISE ARCHITECT, MYSQL WORKBENCH.

FINANCIAL APPLICATION

TALLY ERP 9, WINGS.

OTHER

Toad, Excel Micros,

PROFESSIONAL EXPERIENCE

SQL Developer and Support for Visual FoxPro - May 2012 to till date

Fox IT Solutions Pvt. Ltd., Hyderabad

Handling New Projects

Application development in Visual FoxPro

SQL Server and Business Intelligence

Designed complex query, understand exiting complex procedures,

Database designing, Handling new requirements of clients

Delivered 100+ Hands-On-Lab (HOL) in different cities

Conducted various corporate trainings and workshops in several leading IT Industries

Delivered numerous technical sessions in prominent technology conferences around the world

Designed and employed complex Database Architecture; applied innovative strategies to make the database be of high availability and scalability

SQL Developer and Visual FoxPro Developer - Aug 2007 to May 2012

Complitsol, Hyderabad

Application development in Visual FoxPro

SQL Server and Business Intelligence

Delivered 100+ Hands-On-Lab (HOL) in different cities

Conducted various corporate trainings and workshops in several leading IT Industries

Delivered numerous technical sessions in prominent technology conferences around the world

Implemented End-to-End Business Intelligence (BI) stack solution

Leader in the development of our OLAP Data Warehouse Reporting Initiative

Designed and employed complex Database Architecture; applied innovative strategies to make the database be of high availability and scalability

Visual Foxpro programmer and SQL Supporter – Jan 2001 to Jul 2007

Katare Spinning Mills Ltd, Solapur, India

Introduced tactical advancements and performance improvement in Query Optimization

Application development in Visual FoxPro

Formulated and presented new ideas through Data Model Documentation and ensured that the documentation was updated

Established standards for SQL installations, maintenance, tuning and coding

Provided training, mentoring, and feedback to team members to enhance communication and performance

Owner of the current operational data structures; have initiated optimizations and reconfigurations, as needed

Envisioned and presented employees’ ideas on the concepts of technologies to the Management to enhance Staff development and boost team spirit

Achievement in my technology:- I have built a Financial application in Visual Foxpro, Ms Sql, My Sql for general clients which can ease workload of any project. You have to enter the information of any type of business accounts and that application will get created with the function of

1.Company Creations

2.Accounts Ledger

3.Groups

4.Maintain accounts with multiple years

5.Voucher Transactions

Contra

Payment

Receipt

Journal

Debit note

Credit note

Sales

Purchase

Sales Return

Purchase Return

6.Transactions Displays Methods

Trial Balance

Ledger-wise

Group-wise

Balance Sheet

Profit & Loss Accounts

7.Transaction prints methods

Schedule Summary

Balance Sheet

Profit & Loss Accounts

Trial Balance

Ledger-wise

Group-wise

Sales register

Purchase register

Journal register

Debit note register

Credit note register

Daily summary

Outstanding statements

Inventory details

Print setup

8.Data Recovery Tools

9.Import and export into excel and csv formats

EZM(Easy maintenance of veichle and equipment)

August 2007 –2012

Client

Linkit Software Corporation, USA

http://linkitsoftware.com/

MS Sql 2000/2005/2008, Visual Foxpro 7,9 and My Sql

Below is the feature of EZM Desktop

Maintenance Scheduling: Easily Schedule both routine and non routine preventative maintenance! Features include: Routine preventive maintenance scheduling and frequency (daily, weekly, monthly, etc.) Automatic calendaring is done by EZ Maintenance CMMS maintenance software of preventive maintenance on an ongoing basis. If maintenance is missed or overdue, EZ Maintenance CMMS software “flags” the missed maintenance in red and posts an alert. When the work is actually done, EZ Maintenance CMMS maintenance software will automatically reschedule the subsequent maintenance in line with its normal frequency.

Equipment Tracking: Track equipment by class, category, and individual equipment serial number or identifier. Schedule preventive maintenance by time span (days, weeks, months, etc.) or by hours of use. EZ Maintenance CMMS maintenance software provides history reports for each piece of equipment, including all costs. EZ Maintenance CMMS maintenance software provides for both worker and management sign offs on all completed work.

Maintenance Work Orders: EZ Maintenance CMMS preventive maintenance software produces a work order for each preventive maintenance to be completed, which can be assigned to a specific worker. Work orders can be batch printed. Work orders can contain step by step instructions coupled with a required parts and materials list. The work order can be printed, and contains a signature line for the person performing the work to sign confirming completion of work. EZ Maintenance CMMS preventive maintenance software also provides for the creation of emergency or “non-scheduled” work orders.

Parts and Materials: EZ Maintenance CMMS work orders contain all parts and materials required for individual preventive maintenance procedures, and prints them out on individual work orders.

Full Inventory Control and Tracking: EZ Maintenance CMMS contains a full inventory control module. Preferences can be set to use the full inventory module, to use inventory pricing only, or to not use the inventory module at all in day to day maintenance operations. If EZ Maintenance’s inventory module is set to track pricing only, EZ Maintenance will track the cost of materials used in maintenance and, if so desired, the retail price of those materials. The full inventory module will deduct maintenance materials from inventory when work orders are issued, issue P.O.s and Requests for Bids, track materials costs and retail pricing, list and tracks all vendors and allows for the setting of minimum and maximum levels of inventory. When inventory levels run low, EZ Maintenance’s alerts the operator to reorder, and tracks all materials ordered against P.O.s issued.

List And Track Outside Customers Or Vendors: EZ Maintenance allows for the entry of full customer/vendor information and to have that information appear on specific work orders.

Alerts: EZ Maintenance protects you against missing or falling behind on maintenance. The first screen to appear when EZ Maintenance is opened shows all maintenance due that day, and any maintenance overdue. The main screen shows red markers on any area where maintenance items are overdue, and all individual,overdue maintenance events appear in red.

Maintenance Calendars: EZ Maintenance CMMS not only produces print outs of all preventive maintenance schedules for all or any piece of equipment, but will produce actual monthly calendars showing all scheduled preventative maintenance, and the days on which it is to be done.

Bar Coding: EZ Maintenance CMMS will produce bar codes to identify equipment by serial number, or internal control number. To start a maintenance procedure, operators can simply “swipe” the bar code attached to a specific piece of equipment.

Environment: SQL 2005, PHP 5, C#,Zend framework,docterine,pear,smarty.

Jobmaster(Easy maintenance of veichle and equipment)

Aug 2007 – 2012

Client

Linkit Software Corporation, USA

http://linkitsoftware.com/

Visual Foxpro 7,9 and My Sql, PHP,C#, MS Sql 2000/2005/2008

Job Master manufacturing software has everything needed to control and track production, from quote to shipping. Running your business requires you manage both production and job related administration. Job Master manufacturing software does it all…and it's designed for set up and implementation even by non sophisticated computer users.

Quotation module Develop quotes quickly and easily! Users can quickly quote items factoring in such costs as materials, labor, taxes, and overhead/profit markups. Markups can be done as a percentage or a dollar amount. Customer discounts can be included. A history may be kept of all quote revisions as well as a complete history of all quotes customer by customer.

Sales Order A simple mouse click transforms a quote into a sales order. An entire quote can become a sales order, or only certain line items from the quote can be selected to appear in a sales order. As an option, sales orders can be created directly without first preparing a quote. The Sales Order Module keeps an optional history of all revisions to each individual sales order, as well as a complete history of all sales orders on a customer by customer basis.

Shop Traveler/Work Order Module Users, with simple mouse clicks, can quickly create each job's step by step production procedures and inspection requirements, certification requirements, materials needed and deadlines. A mouse click on the “lot split” button allows an order to be split up into multiple shop travelers to be produced at separate times. Shop travelers/work orders can be bar coded, allowing a "swipe" of the bar code to move a job from step to step in the production cycle.

Inventory Module Job Master manufacturing inventory software is tracked as it is received and used. Inventory may be deducted as shop travelers are created. Minimum and maximum inventory levels for items can be set. Users are “flagged”: if inventory levels fall below a pre set amount, or if inventory ordered/received exceeds the maximum pre set amount. If a shop traveler calls for more inventory than is on hand, a prompt allows users to create a P.O. to reorder.

Shipping Module In the shipping module, all completed items appear on a list of product to be shipped. The shipping work screen allows selection of quantity to be shipped, destination, and entry of the number of boxes to be used and the weight. A packing slip and invoice are produced with mouse clicks. If only part of an order is shipped, the packing slip details not just what is being shipped but the balance remaining. The invoice bills only for what is actually shipped, and a running balance is kept of what product is owed to the customer.

Production Management Numerous tools are provided for the monitoring of production and output. At any time, the job status of a particular order can be checked including where it is in the production cycle, and the work remaining. Date range reports can be pulled detailing how much product was actually shipped during a given time. Other reports detail such things as work in production and the dollar value of that work. Managers can also easily review missed or approaching deadlines.

Network/Multi-User Ready Job Master job shop software is ready to install on any Windows or Novell network. Job Master is multi-user ready out of the box. Numerous reports and printouts are contained in Job Master job tracking software from production output to sales commissions due. Click here to view samples.

Environment: MS Sql 2000,Visual Foxpro 9.

Katare Spinning Mills Ltd

It is one of the Mumbai stockiest price quote, Hotel Tripursundari

it is one of the Hotel

SQL Supporter

Jan 2001 – July 2007

Client

Katare Spinning Mills Ltd.

Katare Spinning Mills ltd is a manufacturing of Yarn product where they maintaing 1200 employee’s.

Responsibilities:

•Maintaing Accounting Appication with using MS Sql 2000 which is developed by me.

•New Implementation as per users and client requirements

•Generate MIS reports

•Create custom MIS reports

•Use optimized queries

•Use procedure,functions, DML query

•Use visual foxpro classes

•Use windows API functions

The 5th Generation contracting system is an impressive suite of fully integrated software, which is developed to meet the requirements of the wide range of contractors in the construction sector.

The Modules

CONTRACT COSTING LEDGER

SUBCONTRACTORS MANAGEMENT SYSTEM

SUBCONTRACTORS CREDITORS SYSTEM

CREDITORS LEDGER

GENERAL LEDGER

CONTRACT SALES SYSTEM

DEBTORS LEDGER

PURCHASE ORDERING

STOCK CONTROL

FIXED ASSET LEDGER

INTERNAL PLANT COSTING

INTERNAL PLANT MANAGEMENT

EXTERNAL PLANT SYSTEM

PAYROLL MANAGEMENT

CONSTRUCTION PAYROLL

DOCUMENT PROCESSING SYSTEM

SALES ORDER SYSTEM

QUOTATIONS

ESTIMATING

BUDGET MODULE

AUDIT MODULE

SYSTEM MANAGER

REPORT GENERATOR

POINT OF SALE

Purchase ordering

This module is one of the important modules for this financial software where system can create order and each order can create supplier, product, he can create purchase order for each supplier and make the auction. Accounting can be create for data warehouse and for inventory.

Employee management system

This module is for handling employee in that system. The business logic of this system is to create timesheet entry for a particular employee regarding what site he has chosen and calculation will be happen according to his timesheet entry and split cost will occur is needed. there is one section for maintenance one for enquiry,one for report, one for entry’s maintenance section employee has been managed. In entry part timesheet entry will occur and in report part payroll report will get generated.

Subcontractor management system

This module is for handling vendor and subcontractor. First in Admin section currency, vat, general, chart will get entered then company,company module, user will be created there and profile will get handled over there. After that in subcontractor section account and account contract will get created then general, general ledger subcontractor option, bank detail will be entered. After that batch will get created and in that batch certificate will be created and allocated cost will happen thereafter that certificate will updated and payment entry for certificate will be entered against one batch. In en query section we can enquire create batch, account contract and payment, In report section report for tax,vat, RCTDC form will created

Plant Automotion System

This module is for handle plant .In this section there will be one main warehouse from where plant item will go to site through on hire entry, consumable item is also there .suppler used to supply item in data warehouse.

G.M Pawle & co., Chartered Accountant

Sep 1997-dec 2000

G. M. Pawle & co. is one of the most reputed tax consultant in india. This portal is made inorder to make good knoledge in company’s accounts and audit

1. Maintaining various companies accounts

2. Do auditing for various companies

Education

•Graduation (bachlore of Commers) from Shivaji University, Kolhapur in 2000

•Senior Secondary from MSBSHSE, Pune in 1997

•10th from MSBSHSE, Pune in 1995

Contact this candidate