Profile

User Profile

Sunil P. Kher
Experience Summary

• Over Twelve years of experience as Senior Technical Lead and Programmer analyst for Client-Server applications using C++, Java, Sybase and Unix.
• Possesses a thorough knowledge of Object Oriented (Various) Methodologies, Analysis, Design and Programming for applications with 3-tier architecture.
• Good experience in Business And System Requirement analysis and Software Engineering.
• Very Good RDBMS experience in Sybase (including Stored Procedures and some DBA experience, also implemented Business Rules using Rules & Triggers)
• Working knowledge of Oracle 7.x and MS Access
• Extensive database connectivity experience using ODBC, Sybase Open Client, Tuxedo
• Good experience with Sybase IQ for data warehousing purposes
• Very good Shell programming skills using various shells and also using nawk and Perl
• Networking experience with TCP/IP Sockets
• Very Good experience with design and analysis tools such as Rational Rose, Erwin and Turbo Analyst
• Has been working on various platforms including SunOS, Solaris, WinNT and HP-UX workstations
• Good experience for automated testing using tools such as WinRunner

Technical Skills

Programming Languages: C, C++, Java
Relational Databases: Sybase, Oracle, MS Access
Database Connectivity: ODBC, JDBC, Tuxedo, Sybase Open Client
Messaging, Queues: MQ, Tibco
Operating Systems: Windows, Unix, Linux
Hardware Platforms: IBM PC Compatibles, SunOS, Solaris, HP-UX Workstations
Netowrking: TCP/IP, Sockets programming
Unix Shell Scripting: Shell script, experience with C and Korn shell, Perl and Nawk
Others: Erwin, Turbo Analyst, Sybase IQ, RougeWave, STL, RiskScript, Rational Rose, Winrunner, Clearcase, PVCS

Professional Experience

Oct 98 - To date Technical Design Lead , Federal Express, Orlando, FL

Project: Online transaction processing for Real invoicing (Currently ongoing)
Revenue Cycle Controls Server is an engine developed track Revenue earned and billed by Federal Express. Currently the engine is showing signs of performance degradtion due to extremely high number of transactions that are being processed. Looking at the further volume of transactions that is expected to flow through the system, an idea is being worked upon which involves storing the Controls data in some kind of data warehouse format. Sybase IQ was one of the possibilities that was explored to do the same.
Role:
• Active participation in Requirement analysis phase
• Created a number of Use Cases from the requirements
• Designed generic data capture API for various types of transactions coming from different engines in the transaction route
• Involved in creating data model needed for generic data capture API
• Coded and tested the generic capture API in C++ along with needed SQL stored procedures
• Designed and coded a shell script wrapper and a test client for testing the data capture API
• Currently involved in product testing for this project
Software/tools: C++, Tuxedo, Sybase, Unix, Rational Rose, Unix Shell Scripting (nawk & Perl), Tibco, MQ

Project: Proof of Concept project for Controls Data Warehousing with Sybase IQ
Revenue Cycle Controls Server is an engine developed track Revenue earned and billed by Federal Express. Currently the engine is showing signs of performance degradtion due to extremely high number of transactions that are being processed. Looking at the further volume of transactions that is expected to flow through the system, an idea is being worked upon which involves storing the Controls data in some kind of data warehouse format. Sybase IQ was one of the possibilities that was explored to do the same.
Role:
• Active participation in Requirement analysis phase
• Created a number of Use Cases from the requirements
• Designed the database model using Erwin and existing data model in Sybase SQL ASE and was also involved in creating DDL for some of the tables
• Coded various translation applications needed to move certain portion of production data to the new Sybase IQ tables
• Coded various SQL stored procedures to copy current application logic in Sybase IQ
• Created various reports for comparison between both approaches
Software/tools: Sybase IQ, Sybase SQL Adaptive Server Enterprise, SQL, Erwin

Project: Revenue Cycle Control Reporting Engine
Revenue Cycle Controls reporting engine is used by Management to track various revenue activities for an invoicing cycle. The reporting engine generates some pre-defined daily, weekly and monthly reports and these can be viewed by various users depending upon their level of security. Also, the users have the flexibility of creating ad-hoc report queries and generating output as desired. The front end for the engine is developed in Java using PowerJ and it connects to the Sybase database on the backend using JDBC calls. Some Tuxedo servers written in C++ were also used for data extraction.
Role:
• Active participation in Requirement analysis phase alongwith Window layout designs
• Participated in development of logical and physical data model
• Designed the object model and was also involved in creating various class diagrams, sequence diagrams and data flow diagrams
• Coded different reporting classes and Window layouts
• Coded some of the Tuxedo servers in C++
• Was involved in product testing using WinRunner
Software/tools: C++, Unix, Tuxedo, Java, JDBC, Sybase, Rational Rose, WinRunner

Project: Revenue Cycle Controls Analysis Driver
Revenue Cycle Controls Analysis Driver is used to analyse the transactional data stored in Sybase tables. The driver looks at past data and detect the trend of how the revenue flow is going to be affected for the future invoicing cycles by predicting the expected values using the historical data. It also calculates anomaly for current invoicing cycle revenue flow. The driver is written using C++ with STL and LAPack provided by RogueWave software.
Role:
• Active participation in Requirement analysis phase
• Was involved in discussions and testing phase for choosing which tools and algorithm to use for prediction and anomaly calculation using Shell programming with nawk and Perl
• Was involved in data warehousing data model design to store the historical data in Sybase tables to be used by the prediction algorithm
• Designed the object model and was also involved in creating various class diagrams, sequence diagrams and data flow diagrams
• Coded prediction algorithm using RogueWave LAPack and STL from C++
• Generated test model and test plans for the test team
Software/tools: C++, RogueWave, Sybase, Unix, Shell Programming with nawk and Perl

Project: Revenue Cycle Controls Server
Revenue Cycle Controls Server is an engine developed track Revenue earned and billed by Federal Express. It is also used to generate various reports for management. Using these reports, various places where revenue leakage can occur can be traced. All of the server executables are written using C++ to parse the various data files sent from various sources and then storing this data in Sybase tables. The data is sent to this server by various other invoicing engines using publish and subscribe mechanism like Tibco and also by messaging components like MQ.
Role:
• Active participation in Requirement analysis phase
• Created a number of use cases from the requirements in Rational Rose
• Designed the object model and was also involved in creating various class diagrams, sequence diagrams and data flow diagrams in Rational Rose
• Coded various interfaces using C++, Unix shell programming with nawk and Perl including Revenue Update, Generate Invoices and also Format and print invoices.
• Generated test model and test plans for the test team
• Was involved in product testing with other entities like Print Vendors
Software/tools: C++, Tuxedo, Sybase, Unix, Rational Rose, Unix Shell Scripting (nawk & Perl), Tibco, MQ

Jan 98 - Sep 98 Software Consultant
Project: Back office trading system analysis
Client: Rabo Bank International, New York
Description: The bank trades in various accounting areas including Money market derivatives. The back office system software used is called Devon. This essentially is a process server which provides API calls to the database and data warehouse. Since the user interface provided by Devon is slightly difficult for the users and not adequate for all their requests, the main task is to develop a friendly interface to the Devon system. This was developed using C++ on the unix side and API calls provided by the Devon system are used as along with the Open Client Library. A variety of reports as requested by the users were developed using mainly Perl, Awk and shell scripts.
An user interface is developed for querying the database using various search criteria. This acts like a search engine. The interface is developed using C++ and the actual search is associated with Sybase SQL stored procedures. A number of related tables for the search engines storing data about user-ids, priorities, history and audit are modeled.
Another Back Office software used by the Bank is called RiskWatch. An interface was also developed to transfer the data from Riskwatch to Devon and vice versa using RiskScript. Since the data format needed by both these systems differs, a number of cross reference tables were built. Some code was also developed to compare the various risk reports produced by these two systems.
Software: Unix, C++, Perl, Shell Scripts, Awk, Sybase RDBMS, RiskScript.

Oct 97 – Dec 97 Software Consultant
Project: Database administration and support
Client: Societe Generale, New York
Description: The responsibilities include
• installing and upgrading the Sybase SQL Server XI and application tools
• allocating system storage and planning future storage requirements for the database system
• creating primary database storage structures and objects
• modifying the database structure, as necessary, as informed by application developers
• writing stored procedures, triggers
• enrolling users and maintaining system security
• controlling and monitoring user access to the database
• monitoring and optimizing the performance of the database
• planning for backup and recovery of database information
• backing up and restoring the database and maintenance of archives on tapes
Mr. Kher is also involved in logical database design and application development using Sybase SQL. He was the major contributor when the database was moved from Sybase SQL Server X to Sybase SQL Server XI.
Software: Unix, Shell Scripts, Awk, Perl, Sybase RDBMS

May 97 – Sep 97 Software Analyst
Project: Dow Jones Telerate Data Feed Interface
Client: Habib Bank AG Zurich, Dubai
Description: Dow Jones Telerate Data Feed provides information needed by the financial institutions such as foreign exchange rates, cross currency rates, precious metal rates and related news items. This data is to be formatted in the way the user needs it and the feed can be queried by the users for the information they need. The feed can be parameterized for these queries.
Software: C++, Unix, Shell Scripts, Awk, TCP/IP Sockets, Sybase SQL server, DB library.
Dow Jones Telerate Data Feed provides information needed by the financial institutions such as foreign exchange rates, cross currency rates, precious metal rates and related news items. This data is to be formatted in the way the user needs it and the feed can be queried by the users for the information they need. The feed can be parameterized for these queries. Mr. Kher was responsible for the requirement analysis, software design, development, testing and implementation of this project. Developed the user interface for customized queries to be executed by the users. A message handler was developed which keep on tracking on the data feed on a serial port and decodes the information received. At the same time, it also fires some queries to the feed with a set of preset parameters. The users are allowed to set up personal parameters using the interface. Once the data is read from the feed, it is stored in the tables for further processing and some user’s querying purposes. Mr. Kher did data modeling and development of SQL stored procedures for analyzing this data. The user is allowed to execute some customized queries on this data and also set up alarms for particular events.

Jan 97 – Apr 97 Software Analyst
Project: Customer Credit Analysis
Client: Habib Bank AG Zurich, Dubai
Description: The Credit Analysis System was developed to keep track of credit liability for business purpose. Various factors like current liability, history of the customer and prevailing market conditions influence the decision making process. The system was designed to give the user a track record of the customer credit history. Mr. Kher was responsible for the requirement analysis, software design, development and testing of this project. A GUI was developed to execute customized queries for the current credit liability and the history of the customer. Routine reports detailing the customer credit history were developed. Developed Sybase SQL stored procedures to populate some of the tables from the history data. Mr. Kher did the data modeling for this project. An interface was provided to the user to convert data into a specific format to be reported to the central bank as also to read the data from the central bank reports and dump into the database. Some data was also being read from on line feed provided by some other banks regarding the credit reports of the customers. This involved lot of cross reference tables.
Software: C++, Unix, Shell Scripts, Awk, Java, JDK, Sybase SQL server, DB library.

Apr 96 – Dec 96 Software Analyst
Project: Data Warehousing and others
Client: Habib Bank AG Zurich, Dubai
Description: Instead of using the tools like Sybase IQ for data warehousing, other methods are used to store the data so that even the history data can be accessed at a faster rate. This mainly involves storage of calculated data and slight de normalization.
Mr. Kher was responsible for the requirement analysis, software design, and development of this project. He was involved in the data modeling for the tables needed for the data warehouse as also in writing the SQL stored procedures for populating these tables. Some components were developed to execute customized queries on this data. The system also does some non-financial tasks like attendance, appraisals, staff salary and time sheets. Mr. Kher was involved in the development of user interface, data modeling and reporting scripts for these modules. The tools used for the development also mostly developed on site instead of using third party tools.
Software: C++, Sybase SQL server XI, DB library, Unix, Unix Shell Scripts, Awk.

Aug 93 – Jul 94 Software Analyst
Project: Automation of Bombay Stock Exchange
Client: Bombay Stock Exchange, India
Description: A three phased automation of the Bombay Stock Exchange.
The automation of Bombay Stock Exchange was done in three phases. The first phase involved the input of market information by the user and it’s display to the brokers and queries can be executed on this data. In the second phase, the brokers used to upload their transactions to the exchange and the settlement process was being done on line with reports being made available to the brokers. The third phase involved actual on line trading consisting of notification, confirmation and net amounts. Mr. Kher was responsible for the requirement analysis, software design, development, testing, implementation and user training for all the phases of this project. He was also involved in the data modeling for this project. The project consisted of the following modules: User interface for inputting market information, Display of market of information on ticker tapes, Report generation for market information, User interface for brokers to input transactions, User interface for brokers to convert transactions from / to a given format, Upload / Download of broker data, Settlement of broker transactions, Report Generation for settlement, User interface for the operators for system maintenance, User interface for data entry, Ask/Bid query processing, and Report Generation.
Software: Visual C++, Windows 3.1, Sybase SQL server, DB library, Unix, Unix shell scripts, Perl, Awk


Education
B.E. Computer Science and Engineering, Regional College of Engineering, Nagpur, India.
M.Tech. Computer Science and Engineering, Indian Institute of Technology, Bombay, India.

Training/Workshops attended
Sybase SQL Server V XI DBA workshop, Dubai.
Sybase IQ Training Course, Dubai.
Member of Sybase Adaptive Server Beta Version Testing Team.

Buyer Activity

Provider Activity