CHANDRAKANT PATIL GENERAL : Seven+ years experience in systems analysis, project management, design, development, business process re-engineering, solutions on Informix database and Informix 4GL, Powerbuilder, Informix New Era, Informix SQL, Informix ESQl/C as development tools. EDUCATION : B.S. (Computer Science) M.S. (Computer Management) SKILLS : Database Technologies : INFORMIX RDBMS SE & Online 5.01, 6.0, 7.2, Oracle 6.0 GUI Tools : Powerbuilder 4.0, Informix NewEra 1.1, Informix ViewPointPro Languages : INFORMIX 4GL, Powerscript, C, INFORMIX ESQL/C, INFORMIX SQL, Java, Javascript, C++, HTML CASE Tools : Silver Run DFD, ER Win, Visio, Turbo Analyst, Data Architect 6.0, "Continuus" software management tool Operating Systems : UNIX, MS-DOS, OSF-1, Novell Netware, Windows Special Interests : Web Development, Data Warehousing EXPERIENCE Dec. 98 - Present AT&T, New Jersey, USA High Speed Data Services Group June 98 - Nov. 98 Evolving Systems, Denver, Colorado, USA Pilot+ Billing and Rating System for CDPD Applications Consultant Working on customisation of the Pilot+ product, a billing and rating system for CDPD applications, for customers such As GTE, Teleflex, Bell Atlantic. Product is developed using Fourgen, C, shell, C++, INFORMIX RDBMS 7.2 and is ported to mulitple OS platforms such as HP-UX, Sun Solaris. Entire source and data control is done through "Continuus" a software management tool Responsibilities - - Study of Product Architecture and software mangement tool - Study of different customer specific releases of the product - Requirement Analysis through interaction with customers - System Development and Testing - System Documentation Sept. 97 - June 98 Columbia Sportswear, Portland, Oregon, USA Order Management & Processing Consultant Working on enhancing new features to the Order Management Processing system and interfaces to proposed JD Edwards system on AS400, using Informix 7.2 Online, Informix 4GL, Fourgen under AIX v3.0. Also working on a seperate project to handle Distribution Centre Inventory Receipts and Adjustments updates into the current system. Responsbilities - - Requirement Analysis through user interaction - Develop Process Models - Develop code using Informix 4GL - Writing of shell scripts and creation of test environments to interface current system with proposed JD Edwards system July 96 - August 97 OfficeMax, Cleveland, Ohio, USA Financial Reporting Consultant Working on enhancing new capabilities to existing Financial reporting system using 4GL, Informix ESQL/C, shell and fmli. Perform DBA activities. Feasibility study and requirement analysis for migration of existing system from existing Unisys platform to HP platform. Also involved in analysis and requirements gathering for "Source of Sale" project which is an enhancement to the existing system Responsibilities - - Maintain and streamline backend processes - Perform Housekeeping operations - Performance tuning and database administration - Enhancements to existing system as per user requirements and query optimisation - Setting up of test environments for migration process - Preparation of URS for redesign of existing system under Oracle. - Data Modeling - System Documentation Oct 95 - May 96 Hewlett Packard, Singapore Singapore Institute of Management,Singapore System Executive & Consultant Developing a Course Administration Client/Server application for the Singapore Institute of Management, a management education institution, using INFORMIX NewEra 1.1, ViewPointPro and Informix RDBMS 7.0 Responsibilities - - Understand the business requirements and develop the process model - Data modeling, database design and setting up of system environment - Design and develop GUI standards for the application - Design a working prototype of the client's application using NewEra Jan 95 - Oct 95 NexGen, Bombay, India SR-91 Toll Accounting System for CALTRANS USA Systems Executive Developing an automated toll collection system for CALTRANS using Powerbuilder, INFORMIX On-line RDBMS 6.0, ESQL/C and 4GL Responsibilities - - Setting up Communication Protocols between the India and USA offices - Preparing the Unit Test and Integration test Plans - Setting up the Informix 4GL coding standards - Using ERWin to create the Data Model - Using Powerbuilder to develop screens in the application - Creating Management Reports using Informix 4GL - System Testing Jan 95 - Oct 95 NexGen, Bombay, India Change Management System System Executive For a large software development effort, uncontrolled changes lead to chaos. The set of activities that have been developed to enable orderly control of changes throughout the system life cycle is the CMC (Change Management System) Responsibilities - - Study and Analysis of existing character based system - Design the ER model using ERWin - Using Powerbuilder 4.0 to develop the various front-end screens - Using Informix 5.01 and Informix 4GL for report generation - Documenting SDS, DDS and User Manuals - Unit testing of the individual screens and the entire system as a whole Mar 94 - Jan 95 Symbiosis Institute, Pune, India Maintenance Monitoring System Systems Executive Maintenance Monitoring System was developed to keep track of the execution of maintenance contracts undertaken by the Symbiosis Computer Consultancy. Involved in the Analysis, Design and Development of the system in Informix 5.01 SE RDBMS and Informix 4.1 GL Responsibilities - - Analysis of the current manual process and user requirements - Writing a feasibility report for developing the system in Informix/Unix - Creating the Data Flow Diagrams and designing the Data Dictionary - Creation of the database and various tables in Informix - Designing and developing the input forms, various reports and other output documents in Informix 4GL - Documentation using PageMaker Mar 94 - Jan 95 Symbiosis Institute, Pune, India Student Information System Systems Executive Requirement gathering, analysis, design and development of a Student Information System, which helped in maintaining the data of the students who are granted admission to any of the institutes of the Symbiosis Society Responsibilities - - Requirements gathering of the current manual process across different institutes of the Symbiosis society - Designing the system and documenting all the necessary items - Development of the system in Informix 4GL/UNIX - Testing and implementation of the system May 93 - Feb 94 Notre Tecsoft, Pune, India Cane Accounting System Consultant Requirements gathering, designing and development of a generalised package for the Sugar Industry. Various modules involved were Cane Accounting, Cane Harvesting, Soil Sampling, Financial Accounting, Payroll and general MIS Responsibilities - - Requirement Analysis for many sugar industries - Liaise with the team and involvement in the team design of the application - Involved in designing the modular approach for the development of the application - Developments of modules in Informix 4GL - Design, development and implementation of the MIS module April 92 - Oct 92 Hindustan Petroleum Ltd., Bombay, India Premium Calculation and Montoring System Management Trainee Involved in the development of a housing loans premium calculation and monitoring system Responsibilities - - Design documentation using Turbo Analyst CASE tool - Building up the database in dBASE IV DBMS - Development of the system in dBASE IV - Integration of the system to the existing centralized LOAN system - Implementation of the system at the corporate office.