Anandh C.

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 LARAVEL 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 • Web and E-commerce designing in ASP and PHP. • 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 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 [login to view URL] 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 [login to view URL] 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.