SANJAY K. PARIKH 1844 Scenic Dr, #138 Modesto, CA 95355 (209) 579-7711 http://sparikh.tripod.com E-mail: sanjay_usa@yahoo.com HIGHLIGHTS: - Oracle RDBMS, PL/SQL, SQL*Plus, Reports and Forms 5 years - Oracle DBA 2 ½ years, Backup & Recovery, replication, conversion, migration, SQL*Loader, indexing, advanced query, data cleanup and performance tuning - Informix RDBMS, ISQL, 4GL, ESQL/C, SPL, and triggers 8 years - Informix DBA 4 years, SE, IDS 7.3, logical/physical modeling, load, backup, restore, tuning and optimization - UNIX System Administration 2 ½ years - Informix to Oracle conversion 2 years - Shell programming, sed & awk 9 years, Perl 3 years - Full life cycle development - Experience in Batch Processing and CRON jobs 9 years - Experience with Extraction, Transformation & Load (ETL) 6 years - Experience with client/server environment like PowerBuilder 1 year - Adapt easily to new environments and deep interest in learning new things - Exposure to Apache, WebLogic, DB2, EDI, Data warehouse, Java and C++ SKILLS: Database:- - Oracle RDBMS - versions 7, 8, 8i, SQL*Plus, PL/SQL, Developer 2000, 6.0, 6i, Reports 2.5, 6.0, 6i, Forms 4.5, 6.0, 6i & Graphics 2.5 - Informix RDBMS - versions 4, 6, 7, Informix 4GL, ESQL/C, SPL, triggers and other Informix Utilities - DB2, Microsoft Access, SQL Server, MySQL, Gupta SQLbase, WatcomSQL, dBASE IV Programming:- PL/SQL, Informix 4GL, Shell, awk, Perl, Oracle Forms & Reports, HTML, Crystal Reports, Java, C, C++, PowerScript, Pascal, FORTRAN, BASIC, LISP, AT&T 3270 Escort Client/server:- PowerBuilder, ObjectView 3.1,NewEra Software:- Toad, SQL Navigator, TOra, ErWin, WebLogic, PVCS, Microsoft Excel/Word/Outlook, ClearAccess, AutoCAD, OrCAD Systems:- Solaris, HP-UX, Sequent, SUN, X Windows, Windows 95/98/NT/2000, Linux, SCO, AT&T 3B2 UNIX, DOS Hardware:- IBM PC and compatibles Microprocessors:- 80X86, 8085, 8080, Z-80 EDUCATION: The City College of New York, The City University of New York M.S. Computer Science, June 1993 University of Bombay, Mumbai, India B.S. Electronics Engineering, July 1989 CERTIFICATION: Brainbench Certified Unix Korn Shell Scripting, November 2001 Brainbench Certified Master's level Oracle PL/SQL, November 2001 EXPERIENCE: Synovation Incorporated, Modesto, CA 2/02 - 10/02 Oracle DBA - Production DBA Support · Participated into daily DBA activities, monitoring database activities, growth, adding tablespace, checking alert logs on various client sites, used Enterprise manager, Tora and Toad. · Created Perl scripts which monitored Oracle databases using DBI::ORACLE. · Created hot backup scripts that could handle Oracle database on Unix and Windows platforms, using Perl and Oracle PL/SQL scripts. · Helped developers in optimizing performance and advanced query. - Installation of Oracle, setting up different schemas. - Setup different Synovation clients on Oracle database, which involved converting Mainframe data into Oracle, setting up lookup tables. - Conversion · Developed Perl script for creating conversion tables from the field defn. · Created PL/SQL scripts to generate control files for the SQL Loader. · Developed procedures to do data mapping and cleaning. · Worked with the client on daily basis to alter scripts for the lookup table changes. Created Perl script to read Excel files and load data into Oracle. - Migration of Synovation Clients to different versions, involving creating/maintaining migration scripts. - Created Perl scripts to process XML files and US Postal zip codes CD from USPS. - Setup test multimaster replication system. - Exposed to WebLogic. SP Contract Services LLC, Beaverton, OR 8/01 - 2/02 Sr. Systems Analyst/Oracle DBA - Designed the database for the Financial application. Created control files to load the data. Recovered tables from the exports. - Developed Packages, Stored Procedures and Database triggers using PL/SQL. - Created Perl scripts * To interact Oracle, Web, Outlook, Excel and Access. * To download web pages, process it and change Excel files, update Oracle database and generate reports in HTML. * To extract text files and transform them to load into Oracle database. * To send an email from Outlook. * To create graphs in Excel, which queried the data from the database. Menlo Logistics, Portland, OR 5/99 - 8/01 Contractor - Production Support of SMS Application on the daily basis on Oracle and Informix systems · Involving looking into PL/SQL code, Informix 4GL code, running SQL queries, EDI transactions, log files and data files. ( On average 10 emails a day, querying why orders didn't processed, report didn't run, didn't get report, when orders would drop, setting up lane, change carriers, etc. ) · Used UNIX shell scripting, awk and PL/SQL skills to identify/extract duplicate orders and shipments in mission critical situations. · Used Korn shell and Perl to maintain the CRON and to page the on-call, when orders were not processed or the CRON was down for certain time. · Used Korn shell and awk on variety of projects including automating add/delete mail distribution program, parsing distribution file for maillist, creating update and insert statements, ftp files to remote machines and parsing some of the data in EDI 856 transactions. Used telnet to work on Unix. · Optimization of Informix code, made the batch run finish in 7 to 8 minutes from 20+ minutes. · Optimization of Oracle queries using explain plan feature. · Performed oncall duties. - Development and maintenance of variety of projects for Shipment Management Systems (SMS) including Customer Specific Routing logic, Pallet Height Restriction and Freight Forwarder using for Oracle PL/SQL (used SQL Navigator and PVCS) and Informix 4GL (used vi and rcs). - Setup different Menlo clients like Hewlett Packard, Dr. Pepper and Nortel Network on Oracle using Designer, PL/SQL and SQL*Loader, and on Informix using ISQL. - Used SQL Navigator to work on Oracle schema objects. - Converted Depots in Informix platform to Oracle platform, involving · Verifying Informix 4GL code and PL/SQL code for the functionality. · Setting up variety of tables including lanes, part master and orders. · Developing, constructing and unit testing extraction, transformation & load (ETL) routines. · Running system test. - Created/maintained Oracle Reports and Forms. Created shell and SQL*Plus scripts to run the report from the CRON. - Created Triggers and Stored Procedures in Informix to monitor part master changes using dbaccess. - Written test plans, documentation and testing. Created adhoc reports. - Worked with end user to gather information to design functional specs. - Written technical specs for all the development and maintenance work. Fleetsafe, Atlanta, GA 3/98 - 6/99 Informix DBA - Production DBA Support of Informix database. · DBA activities like backup, restore, logical/physical modeling, monitoring activities, growth, tune up, etc. · Maintenance of the Informix 4GL code. · Setting up new clients into system, which invloved writing shell and awk scripts to load data into database. · Created adhoc reports. · Optimized Informix 4GL reports. - Helped converting Informix programs into Visual Basic/SQL Server platform. SIEMENS 10/98 - 12/98 Contractor - Worked with a team of 25+ programmers to convert cobol like programs into Informix 4GL. - Created a shell to do some of the manual checks. Home Depot, Atlanta, GA 8/98 - 10/98 Contractor - Developed a new application using Informix 4GL on HP-UX, to do User and Group maintenance, and it will reside in all the 670+ stores of the company. - It interacts with LDAP server using C functions. - Written test plans, documentation and performed testing. - As this application will be used in South American and Canadian stores as well, so programmed such a way that the messages, error, screen prompts, screen help and other display statements would show up in the Native Language. Financial Service Corporation (FSC), Atlanta, GA 7/97 - 7/98 Contractor - Created a program for the insurance business using Oracle7, extensive use of Oracle PL/SQL and Oracle Forms. - Used shell and awk on variety of projects including to find out Y2K problems in Informix 4GL coding, to retrieve information about the Informix 4GL library functions and to do update statistics for the tables - Changed coding of fund/SERV application according to NSCC Y2K compliance - Converted PowerScript code into Informix 4GL. - Maintenance of the Informix 4GL coding. Created adhoc reports. Worldspan, Atlanta, GA 9/95 - 6/97 Contractor - WIP(Work-In-Progress) Database Enhancements: Subscriber Billing Designed and developed a Subscriber Billing System to track all the business with travel agents who subscribe to this CRS ( Computerized Reservation System ). This system is implemented using Informix RDBMS on HP9000/887 running HP-UX 9.04. Was responsible for the design of all the screens and coding of the system using Informix version 7.1. Tested the application and integrated it into the main (WIP) system. - PA Bill System ( Participating Airline Billing System ) Database Enhancements Added several enhancements to the PA Bill system. Improved statement appearance, tested printing of invoices, streamlined menus, added functionality to customer screen and allowed isql queries. - Integrated all the monthly and weekly reports into one main program and generated reports. Saved a lot of system time by changing programs and making them run faster. For instance one report was taking 2 days (Saturday and Sunday) to run, after rewriting made that report to run in 1.5 hours during normal business hours. Created adhoc reports depending upon the requirements. RCS, Inc. / NYNEX, New York, NY 8/93 - 8/95 Systems Analyst - Developed application programs in PowerBuilder and ObjectView for Trouble Reports and Employee Records. These applications were calling C routines to massage the data that used to come from NYNEX databases, inserted data into local database, did queries, did calculations in Microsoft Excel, used DDE (Dynamic Data Exchange) to transfer data between Microsoft Excel and application, and generated reports. Used Gupta SQLbase as the back end database and ClearAccess as a report tool for the ObjectView projects. Trouble report application saved client's 48 working hours. - Used Informix ESQL/ISQL to manipulate large sets of data on AT&T 3B2 UNIX systems also used Informix 4GL report utilities to design and implement report programs to client's specifications. Programmed in Escort to emulate the mainframe screen. (ETL) Extract the data from the flat file, transform it into data that can be loaded into Informix Database. Program used to get the information about thousands of circuit by getting into NYNEX databases such as TIRKS, LMOS, CIMAP, ICAB and ICRIS. - Installed, setup, upgraded and maintained UNIX operating system use CPIO, TAR and system utilities to do file backup to tapes and diskettes. - Setup and maintained the TCP/IP network among AT&T minicomputers and use rlogin, telnet, ftp, rcp utilities in TCP/IP to communicate and transfer files. - Installed, setup and maintained the IBM SNA(System Network Architecture) software to establish a communication network between AT&T 3B2 computer and IBM mainframe computer. - Setup the interface of the mainframe printer and PC so that printer output goes into the computer file. Then the data is used to generate reports. This setup avoids paper handling and within no time reports are generated which used to take days. - Programmed in Shell, used awk and sed Unix utilities. Fall Internship Program at NYC Tranist Authority, Brooklyn, NY 10/92 - 12/92 Intern in Information Systems Dept. - Generated various MIS reports in SupportMagic. Reports were generated, based on user and/or client requests from a Help Desk Database. Compex Systems, Mumbai, India 4/90 - 6/91 Engineer Executive - Supervised the Production of the personal computers at the card level generated its user documentation, and supported the customers. Ruma Electronic Industries Pvt Ltd, Mumbai, India 1/89 - 3/90 Jr. Engineer Executive - Developed CAD Software for the IBM PC-AT motherboard, and its technical and user documentation. - Developed library in OrCAD - Supervised the production of PC card sets at the component level, 101 key Keyboard and the PCs, was responsible for Materials Management and Production Planning Dept. REFERENCES: Available upon request.