Desikan Ramaswamy
1320 S.
Elmhurst Road, #203
Mt Prospect,
IL – 60056
847 258 3145
(Home)
Ø
Over 7 years of IT
experience as a Programmer/Analyst using a variety of products and technologies
including Visual Basic/ASP/ActiveX/COM/.NET, Java – Server & Client side
(Servlets/JSP/EJB/JMS/JNDI/JDBC/AWT/Swing), C/C++, Tuxedo (OLTP services using
ATMI), iPlanet, WebLogic, Oracle, Informix, SQL Server, Access and MS Office
products.
Ø
Strong in component
development using Visual Basic, Java, JOLT, Tuxedo and Microsoft Office Suite
(VBA) programming.
Ø
Experience with RDBMS
development using Oracle, Sybase, SQL Server including SQL, query optimization
and tuning of large databases.
Ø
Experienced in full
life cycle implementation of large systems.
Ø
Experienced in handling
global customers (Avon Products, United Airlines) and extensive interaction
with end users – internal as well as external.
|
Platforms worked |
Windows 98/NT/2000/XP,
UNIX, MS-DOS |
|
Programming
Languages and API |
Java, C, Windows SDK,
Perl, COBOL |
|
RDBMS |
Microsoft Access,
Oracle 8i, MS SQL Server, Informix, Sybase, Visual FoxPro |
|
DBMS |
FoxPro 2.6b |
|
GUI |
Visual Basic 6.0 |
|
Other Products |
VBA, Excel, Access,
PowerPoint, Word and applications development for the MS Office Product
Suite, Lotus Notes |
|
Middleware/Web
based technologies |
Tuxedo 6.5 (ATMI,
JOLT), WebLogic, MTS, IIS 4.0 |
|
Technologies |
COM, COM+, ActiveX components,
ADO, DAO, RDO, ODBC, Servlets, JSP, JDBC, RMI, ASP, MS Office Object Model,
OLE, DDE, .NET |
|
Miscellaneous |
Documentum,
SalesLogix, VP Expert |
Ø
Masters Degree, in Computer Applications, Indira Gandhi National Open
University, India, 2001.
Ø
Bachelors Degree, in Mathematics from University of Madras, India,
1995.
Ø
Diploma in Systems
Management from National Institute
of Information Technology (NIIT), India, 1996.
Ø
Tuxedo Applications Development conducted by BEA Systems.
Ø
BEA WebLogic Server Application Development conducted by BEA
Systems.
Ø
Advanced Java training conducted by BEA Systems.
Ø
Brain Bench (formerly Tekmetrics) certified C, C++ and Master
Visual Basic Programmer.
UNITED AIRLINES, Chicago,
IL, USA - Analyst-Applications Development, Oct 1999 till date
Gate Assignment and Planning
System – GAPS/GAPSLITE
GAPS & GAPSLITE are unique applications
that display flight gates and their usage. GAPS is a standalone application built using Visual
Basic. GAPSLITE is a version of GAPS that can be run from the web and provides most
of the features of GAPS. GAPS uses sophisticated
optimization techniques to assign gates to flights based on several complex criteria. GAPS is the lifeblood of United operations
and aids the gate controllers and planners in planning and efficient
utilization of resources. GAPS &
GAPSLITE display all United flights. As
more mainline United flights get replaced by United Express flights, it becomes
imperative to be able to display United Express information within the
applications. GAPSLITE uses Java
Applets to
interface with the end user. These
Applets talk to Servlets running within iPlanet which communicate with EJBs running within WebLogic to perform the business
processes as well as talk to an Oracle database.
Interface to the legacy mainframe system is made possible through
specialized OLTP Tuxedo services using ATMI which are also accesed
using JOLT. Real-time flight related updates are
obtained by the application by subscribing to Tuxedo Event brokers. The application uses 2 phase
commits across
domains provided via the Tuxedo ATMI API .
Environment:
Ø
Support and maintenance
of GAPS/GAPSLITE applications.
Ø
Responsible for
obtaining the flights dump for all United Express flights.
Ø
Provide the
functionality to GAPS & GAPSLITE applications to add
non-United/United Express flights to existing gates as well as the ability to
carry forward these flights to each week on days selected by the user.
Ø
Interaction with
different user groups such as Operations and Ramp control
Ø
Responsible for the
development of OLTP Tuxedo services using ATMI as well as Tuxedo domain
configuration.
Avolar – (United BizJet Holdings)
Played a lead role
in several key initiatives at Avolar.
Designed and developed an application using Visual Basic for all
users across Avolar to be able to track issues as well as the action
taken with regard to the resolving these.
This application was built in a very short time frame and proved to be
extremely valuable to users. The
application tracked roughly 50-75 different parameters. Built the ability to generate reports based
on any criteria that the user can determine. Solely responsible for the content for the Avolar.com
website. Some of the key enhancements
that were done to the website included the ability to post new press
releases in a convenient manner, as well as the automation of the page
generation and publishing. This was
a very unique process and the automation was developed using VBA within
Outlook. Made several significant
changes to the form handling features on the Avolar.com website including sever
forms processing automation. Involved
in managing documents with Avolar using Documentum. Played a key role in supporting the Avolar sales
and marketing forces using SalesLogix.
Environment:
Ø
Analysis, Design,
Development, Testing, Implementation and Support of EAR (Employee Action
Request) – an application to track and monitor issues (operational, vendor
related or any issue) for all users within Avolar.
Ø
Responsible for
managing the content on the Avolar.com website.
Ø
Responsible for
supporting the document management system using Documentum.
Ø
Supporting the Avolar
Sales and Marketing force using SalesLogix.
Ø
Coordinate with
offshore resources (in India) to ensure orderly and prompt resolution to issues
and project progress.
Ø
Worked on automating
several tasks, including automatic generation of HTML files for new press
releases and automatic forms processing from the Avolar.com website using
script automation techniques.
Ø
Interaction with
different user groups such as Operations, Customer experience, Sales and
Marketing.
Baggage Connection Manager - BagCon
Responsible for the maintenance and subsequent
release/deployment of a unique application to aid ramp supervisors in
monitoring flights to prioritize and transfer bags between connecting
flights. The application uses a
sophisticated GUI built using Java Applets, that communicate with Java Servlets running on iPlanet. The servlets communicate with EJBs running under WebLogic that communicate with the
mainframe system to obtain data that is displayed by the client. The application is very unique and extremely
scalable and
can be very easily deployed to other airports/hubs wth very minimal
alterations. This application will help
the company improve its baggage performance numbers by focusing on
short connections, interline transfers, local change of itinerary bags and late
check bags by assuring that the bags travel together with the customers. The application will yield a 5% improvement resulting in
savings of roughly $.75 million for each United hub.
Environment:
Ø
Maintenance of Baggage
connection manager (BagCon) at O’Hare.
Ø
Responsible for
modyfying and deploying BagCon at Denver.
Ø
Coordinate with other
resources within United to ensure orderly and prompt resolution to issues and
project progress.
Ø
Worked on automating
several tasks, including customizing the application to support multiple
airports/hubs in addition to filtering the relevant data.
Ø
Interaction with
different user groups such as Operations and Ramp control
Revenue Management
Worked on an application
to display United's inventory and demand forecasts. This Visual Basic application interacts with an Oracle database
as well as middleware services in Tuxedo (which talk to a Unisys mainframe
system) to process enormous volumes of data and display relevant information to
analysts who can then make flight level or market level adjustments. Built a web-based application to
present the schedules, bidding and trading information for pilots and flight
attendants using Java servlets as well as Tuxedo. The Java servlets communicate with OLTP
services using JOLT to process information and updates to the system. Built automated tools using Excel and Word
to generate graphs and customized messages.
Automated the generation of Tuxedo code using Visual
Basic.
Environment:
Ø
Development &
support of applications to analyze the inventory and demand for flights in all
of United’s markets.
Ø
Design &
Development of Automated Reports in Excel to generate graphs for United’s
intranet website.
Ø
Development &
support of tools to analyze the inventory and demand for flights in all of
United’s markets.
Ø
Design and development
of decision support reports for all of United’s markets.
Ø
Design, development and
maintenance of middleware components in Tuxedo that talk to a Unisys mainframe
system.
Ø
Development of Java
Servlets and JSP components on iPlanet and WebLogic to populate the schedule
data onto web pages.
Ø
Coordinate within as
well as between teams to ensure project progress.
Ø
Interaction with
clients (Pilots, Flight Attendants and Revenue Management users).
SUNRISE LOGISTICS, INC.,
New York, NY, USA – Consultant, Nov 1998 – Oct 1999
Avon Products
Built
a tool using Visual Basic used to update existing databases. The tool interprets commands from a script
file (text format) and performs relevant actions. Developed a script language to enable the tool to comprehend
specific commands. The script file is
organized into sections and each section can link to other sections. Each section contains commands to add,
delete or update a field, create tables, create indexes, create querydefs, or
even execute specific SQL statements.
The tool is also capable of handling variables and performing basic file
operations like copying, deleting etc, in addition to being capable of spawning
external programs and sharing data. The
tool was mainly designed for updating existing PC Avon databases and optionally
run patch routines downloaded from Avon servers. In addition, developed server side applications that receive data
from PC Desktop Avon applications to update a Sybase database that also
aids in planning and generating various reports for different management
levels.
Environment:
Role:
Ø
Design, development and
implementation of the tool.
Ø
Development of a new
customized script language to enable tool to comprehend commands for performing
actions.
Ø
Development of
versioning and chaining support.
Ø
Development of parser
component using ActiveX, COM, DAO, ADO technologies.
Ø
Development of Excel
macros and Access applications to different tasks.
Ø
Development of word
templates and macros to generate automatic mails.
Ø
Development of
reporting tools in Visual Basic to produce HTML reports intended to support
different groups of managers within Avon.
SOFIST INDIA, Chennai,
India – Senior Analyst/Programmer, Oct 1995 – Oct 1998
Worked
on a wide range of projects. Built an
invaluable software solution for advocates, judges and officers of the
judiciary. Provides instantaneous information about various Income Tax related
cases from 1933 onwards. Involved in the development of a query engine
operating on various parameters of judicial information to produce results from
large volumes of information. The system included nifty features such as backtracking
and storing queries as well as an extensive copy protection and text
compression engine built in. Worked on
another Enterprise information system for computerization of functional areas
such as Financials, Purchasing, Sales and Manufacturing. Provides seamless
integration of the various departmental functions by facilitating instantaneous
on-line information retrieval.
Environment:
Role:
Ø
Developed and supported
2 versions of a Legal Information System (ITR OnLine)
Ø
Headed the development
team of 7 and coordinated the software development activities within the
organization.
Ø
Headed the development
effort involving complete rewrite of the Legal Information System in Visual
Basic.
Ø
Developed ActiveX
components to implement a mover control as well as a list box with the ability
to display images.
Ø
Developed a text
comparison engine to highlight differences in different amendments of various
acts.
Ø
Designed a proprietary
text compression engine using “C” to compress/decompress volumes of judicial
information
Ø
Implemented copy
protection for the product as well as security, access privileges and the
ability to control different flavors of the product for different customers.
Ø
Developed a tool for
online customization of databases for an enterprise wide management system
(SofAcc) in Visual FoxPro.
Ø
Developed a tool to
generate screens automatically with the ability to include customized data
along with computational fields.
Ø
Developed customized
solutions like an Order Processing system, Garment module – SofGem, Costing
module and more.
Ø
Involved in the support
of clients for the Legal Information System as well as the Enterprise wide
management system.
Built
customized solution for tracking inventory and production and tools for
reporting. Built a tool for the
automation of the entire deposit mobilization, collection/renewal activities
for a finance company. Developed a complex hierarchical report detailing the
links between each agent, and his/her immediate superior (upto 10 levels),
using the report builder in FoxPro.
Environment:
Role:
Ø
Designed and developed
customized solutions for Modern Food Industries Ltd., Sanmac Motor Finance,
etc.
Ø
Involved in the study,
design and development of a customized solution for tracking inventory and
production.
Ø
Developed a reporting
system with the ability to include optional columns.
Ø
Designed a package for
the automation of the entire deposit mobilization and collection/renewal
activities.
Ø
Developed a complex
hierarchical report detailing the links between agents, their immediate
supervisors etc upto 10 levels.
Ø
Placed in the top
10% in the Competence in Software Technology exam conducted by
National Center for Software Technology, India in 1995.
Ø
Recipient of the
Bhavishya Jyothi Scholarship instituted by National Institute of Information
Technology (NIIT) in 1992.
Ø
Recipient of the
“Certificate of Excellence” awarded by NIIT, India for having stood first
during Professional practice.
Ø
Participated in several
inter-college cultural events and won various prizes.
Ø
Participated in the
Inter college Mathematics competitions (Matrics) conducted by Loyola College
and won accolades.