Resume 7

Age/Sex : 32 Years/ Male

MCA Distinction
BSc Physics Distinction

Financial, PayRoll, Inventory, Order Entry, Production, Accounts, Marketing,Travel, ALM Insurance, Dental Insurance, Logistics

8 Years of Extensive Experience in Client / Server , OO/UML , Middle Tier Environment using Rational Rose, Delphi, Oracle, SqlServer
As Tech Lead/Sys Architect, Senior Analyst, Designer, Developer
Of which 5 years in USA with fortune 500 clients.

Visa Status : Needs New Visa

• Client Server/ GUI : Delphi , VB.NET / VB, JBuilder
• RDBMS : Oracle 8, SQL Server , DB2
• OO Languages : Object Pascal, Java, C#, VB.NET
• UML Tools : Rational Rose 2000
• Distributed Object Services : COM/ DCOM, RMI, MIDAS, Web Services .NET
• Web Exposure : ASP.NET, VB.NET, XML, CSS, XSL

• Used Rational Rose for modeling Inventory ,Booking, Billing, Receipts, Load Maintenance , FleetMaintenance, Vessel Contracts, WareHouse Management, Administration/Security Modules.
• Involved in interacting with User Groups, User Managers .
• Involved in interacting with Business Analysts.
• Involved in creating the Activity Diagrams, Sequence Diagrams at the Analysis level for Various Modules.
• Involved as an Architect to have COM/Midas configuration for different Com units across Servers.
• Involved in the technical aspect of creating Web Services to be ported across the Net compliant with .NET using XML.
• Invloved in the development of modules like WareHouse, Inventory.

• Used Rational Rose 2000 for modeling Business, Office, Summary and Agreement Modules, Provider, License, Region, Network Modules.
• Has done Analysis and Design for Modules like Perform Business Query, Maintain Provider, Maintain BOL, Maintain Business, Maintain License, Maintain region use cases.
• Created Class Diagrams, Sequence Diagrams, Activity Diagrams for the above modules at the Analysis and Design levels.
• The project is overall n tier using Delphi/Java Delphi is connected to Java with Corba Architecture.
• Involved in interacting with Business Analysts , Users .
• Involved in interacting with UI Managers, User Managers.

• Involved into writing Business Objects, COM Objects.
• Involved in the Gator Broker, SSA Search Architecture.
• Analysis and Design of the modules is done using UML
• Involved in the backend work for writing specifications for stored procedures triggers and packages.
• Auto Submit Request for VRU and Web is developed using Delphi5, using COM DCOM Technology. There are basically 5 Com DLLs like Consumer, VRU and Web , Request and Request Type , Entity Lock and also Com Exe Submit Request. It is developed in such a way that every COM Object has a corresponding Delphi Unit associated with it. Also used other Com servers are Gator, DBAccessor for db Methods , and SSA Search . Com Servers and Clients are deployed in different sites across states. Packages are used to add, get, and update data from the Oracle. Used are ADO, COM/DCOM and OLE DB.
• The overall project is built on a n tier architecture.

• Involved as a Systems & Software Analyst for the data migration. From Btrieve to Oracle.Source Data for ALM comes from SqlServer, Btrieve, and Informix. .PAM portfolio Accounting System is the centre piece of the system And stored in Btrieve.
• Involved in User Meetings, Design Meetings. Data from PAM will be ported to Oracle Staging Area.
• From there, using Stored Procedures and Packages Will be transported to the Real Data Store.

• Involved as a Sytstems/ Programmer Analyst for the conversion from XBase to RDBMS.
• Was Working as a Systems & Design Analyst.
• Involved in writing Specs in converting XBase front end to Visual Tool, Which includes the overhaul of Y2K.
• Involved in writing Specs for the Stored procedures, Triggers, Packages

• Involved in the front end design flows and involved in the coding of Critical Transaction Modules like Skeleton - Create, Update, Copy, Customer List Copy, ReAssignAll , TurnDowns, Called History, ELT Counter, ELT Offer , AreaLookUp, Contract Activity, Carrier Assignment And Access Interface.
• Skeleton is a template for the Order , which will be converted to the Order any time.
• ELT is the Electronic Load Tender.
• Skeleton and Order contain Stops Details like Shipper, Receiver, and upto a max of 16 Intermediate Stops Shipper/Receivers , NonStops Detail like BillTo, Solicitor, Rater, Custom Broker.
• Also it contains orderClassifications and Stop Requirement for Shipper and Receiver.ELT is used as an Interface between OrderEntry and Customers.
• The whole program is done using Delphi 3.0 ClientServer, using MultiTier architecture.
• Implementation is by using TProvider and TQuery on the dataModule, and TClientDataSet , and TDataSource on the Form using MIDAS architecture.
• The whole project is built on OOPS Structure. All the Modules are built as Packages. All the Modules contain ReUsable Classes.

• Mainly to be used for the Customer Requirements , who has got a large Clientele.
• The various modules in this part are Customer Forms, Narratives, requirements, Examiner Instructions, Special Instructions, Supplies and Mailing Address, Lab Details, Addons and Extensions.
• Requirements is based on different Choice Types which will be Type Policy, State, Age Amount Insured etc.
• Forms part is based on the Type Plan, State and Form Number.
• Special & Examiner Instructions are based on the Customer Requirements.
• Requirements and Forms are done using Tree Structure.
• Stored Procedures, Triggers, Sequences are Created and used extensively in the BackEnd Part.
• From the FrontEnd part, Implementation is done using Object Oriented Method.All the Modules are built as packages.
• Concept of three tier Architecture is used so that Provider ,Query , ClientDataset are used.

• Multiple Database Support
• Online Transaction Processing with support from CRS
• Docketing - Registration of Domestic/International Air Bookings, Rail, hotel Allocation- Work Allocation to the personnel
• Booking/Blocking of Seats - From Application through Galileo
• Ticketing - Issue and Printing of Tickets from Agents Stock.
• Handling of Ticket StocksBilling
• Fare calculaton based on the Fares as on Date for Dom/Int and Extended Services
• Cancellations/ Credit Notes- Based on Cancellation Type
• Reports - Export to Excel

Contribution : Design, Development, Testing and Implementation

• Exhaustive Customer List, Product List, Market Segments, Budget Preparation
• Enquiry of Products
• Conversion of Enquiry to Offer
• Conversion of Offer to Order
• Conversion of Order to Receipts
• Multiple Offers against an Enquiry
• Multiple Orders against an Offer
• Partial Delivery of the Order
• Multiple Invoices for the Order and Multiple Receipts for Invoice
• Exhaustive Management Information
• Peformance Includes Budget Vs Actuals, Current Year Vs Previous Year, Market Segment wise, Product Category wise
• Business Statistics maintained at Supervisory level.

Contribution : Design, Development, Testing, Implementation

• This was designed to process
• The keep track of the inventory of Electronic Components, Billing, Payable, Receivables etc.
• Involved in the Development of the above modules.

Contribution : Development, Testing

Financial Accounting includes General Ledger, Trial Balance, Trading account, Profit and Loss Account, Balance Sheet, Cash Inflow and Outflow, accounts Payable, Accounts Receivable Also Planning, Costing, Budgeting production Scheduling, Requisition, History Keeping.