VIJAY
Email: ***********@*****.***
Phone: 405-***-****
SUMMARY
Over Nine-year career span:
*
Extensive experience with Analyzing, Designing, Development, and Implementation of business applications in Client Server technology and file server technology with an exposure to different platforms and software systems
*
Extensive experience in development of applications in Microsoft .Net technologies, Visual Basic 5.0/6.0, SQL server 2005/2000/7.0, Oracle 9.x with SQL, PL/SQL, Informix 7.x and MS Access
*
Expertise in generating reports using Crystal Reports 6.x and Data Report Designer
*
Extensively created and used Stored Procedures, ActiveX Controls and ActiveX Components Used ADO/ADO.NET, RDO and DAO
*
Expertise in Web Applications using HTML, DHMTL, C#, ASP/ASP.NET, VB Script, Jscript, MTS, Visual Interdev, IIS and Apache
*
Excellent communication and interpersonal skills
*
Team player, capable of working independently
TECHNICAL SKILLS
Internet Tools : Visual InterDev 6.0, MS Front Page ’98, HomeSite
GUI Tools : Visual Studio 2005/2003, Visual Basic 5.0/6.0
Web Servers : Internet Information Server 5.0, Netscape Enterprise Server, MTS
Application Servers : Netscape Application Server
Scripting Lang’s : JScript, VbScript.
Languages : DHTML, HTML, C#, ASP, ASP.net, Cold Fusion, Java, Jsp, SQL, PL/SQL,
C++
RDBMS : Oracle 9i/8i/7.x, SQL Server 2005/2000/7.x, Informix 7.x, Ms Access 7.0/2.0.
O/S : Windows XP/2000/NT/9x, and HP UNIX.
QUALIFICATION
Bachelor’s Degree in Computer Science and Engineering from Kuvempu University, India.
Work Experience
*
Working as Sr. Software Engineer at Factor Inc., A Division of W.R Hess Oil Company, Oklahoma City, OK from August 2001 to till date.
*
Worked as Programmer Analyst at Innovation Software LLC, New Jersey from July 2000 to 2001 July.
*
Worked as Programmer at Cybertel Software Ltd, Hyderabad from November’97 to June 2000
PROFESSIONAL EXPERIENCE
Factor Inc., Oklahoma City, OK Aug’06 to Till Date
Sr. Software Engineer
FUELTRAK
Home Heat Truck Automation module, completely automates dispatching, delivery and invoicing processes. Using a mobile truck PC and printer in the delivery truck, FuelTrak completely eliminates paper tickets and manual dispatching. The Automation process integrates with ExecuTrak, transferring the value of the data to the home office system to eliminate the need for integration software.
Automating the dispatching and delivery processes offers the benefit of:
*
Paperless delivery tickets.
*
Invoices printed at the customer’s site.
*
Automatic validation of daily meter readings.
*
Electronic wireless dispatch of same day “will call” orders.
*
Delivery ticket reconciliation.
Responsibilities:
*
Involved in GUI designing using WinForms and WebForms of the Desktop application
*
Involved in design and implementation of the Business layer and SQL procedures and triggers using T-SQL.
*
Designed & Developed Components using C#.NET, ADO.NET, Multi-Threading and MVC pattern.
*
Extensively used Binding Sources, Custom Attributes, Stored Procedures, Triggers, XML.
*
Involved in debugging high severity defects and critical enhancements.
*
Used Reporting Services, Dundas Chart .NET and third party ActiveX controls.
*
Used ADO.NET objects and XML for Database interactions.
Environment: Windows XP, Visual Studio.NET 2005, C#, .NET, XML, ADO.NET, Informix, MS Project, Rational Rose, UML,
Factor Inc., Oklahoma City, OK Jan 05 to July 06
Sr. Software Engineer
STORE TRAK
StoreTrak is a fully integrated Web based system for use in retail locations. Whether the locations are full service convenience stores with fuel, lottery, money orders and fast food operations or simple fuel and soft drink locations, StoreTrak provides store managers with a simple, user-friendly method of reporting daily sales. StoreTrak is fully integrated with existing ExecuTrak software. StoreTrak’s daily components are comprised of the various entry screens that you will utilize on a daily basis for entering store reports, invoices, and other daily activities.
Benefits of StoreTrak: StoreTrak is fully integrated with your existing ExecuTrak software. This translates to:
*
Minimal additional setup information
*
Sales data available immediately
*
Price changes and updates immediately available to the managers
*
Streamlined point-of-sale processes
*
Tighter inventory controls
*
The ability to have separated over and shorts for fuel, money orders and lottery in addition to the cash over and short already available
*
The ability to have multiple bank accounts for each store
*
Merchandise receipts paid with money orders are automatically posted in the money order reconciliation.
*
Streamlined data entry means fewer entry errors
*
Web based applications used in conjunction with broad band internet connections virtually eliminate phone line and other communication issues
*
Every application in this system is internationalized.
Responsibilities:
*
Understanding and analyzing the client’s requirement
*
Involved in GUI designing using Win Forms of the desktop application
*
Analyzed and Designing the system in .NET Architecture with Rational Rose.
*
Designed & Developed Components using C++, C#.NET, ADO.NET.
*
Involved in debugging high severity defects and UAT.
*
Frequent interaction with offshore team in India and reconciled their work on onsite.
Environment: Windows 2000, Visual Studio.NET 2005, C#, .NET, C++, XML, ADO.NET, T-SQL, SQL Server 2000, VSS, MS Project, Install Shield.
Factor Inc., Oklahoma City, OK Jun 04 to Dec 04
Sr. Software Engineer
DATATRAK
Simply stated, DataTrak allows you and selected employees to view management reports through your web browser. This functionality is available for computers that are connected to your Local Area Network (LAN) and to remote PCs. This powerful tool gives you access to significant amounts of real time data, and important data alerts, enabling you to make important management decisions and monitor the-day-to-day activities of your profit centers. To learn more about viewing reports, see "How The Process Works." Important and useful features of DataTrak include the following:
*
Management Reports
*
ExecuGraphs
*
Data Alerts
Responsibilities:
*
Involved in requirements capture system analysis and design.
*
Involved in Project planning, Design document preparation.
*
Coding in ASP.net, HTML, and JavaScript.
*
Responsible for Trouble shooting, and tracking the technical problems and closure.
*
Extensively involved in designing and developing the web interfaces.
*
Developed User Controls to customize the GUI.
*
Developed ASP.net pages using HTML, DHTML, CSS and VBScript.
*
Extensively used JavaScript, for the Client Side validations.
*
Developed Reports using Crystal Reports and developed Uploaded functionality for uploading into web server.
Environment: Windows 2000, ASP, HTML, Java Script, CSS, ADO.NET, T-SQL, SQL Server 2000, VSS, MS Project.
Factor Inc., Oklahoma, OK March’01 to Jun’04
Software Engineer
EXECTRAK
ExecuTrak is the leading petroleum marketing and C-Store main office business information system available in our industry today. New Client/Server technology puts your PCs to work.
More “user-friendly” application environment, providing greater ease of use and facilitating more rapid learning of new functions. Both the keyboard and the mouse functions are active, and data entry personnel as well as casual users will find the system accommodating to operate, design, develop and maintain database (Informix) Management programs for petroleum marketer and store automation in Unix, Windows and distributed computing environments using Informix, VB 5.0/6.0, VC++, ODBC, COM/DCOM and Crystal Reports.
Account Payables (AP): AP Module manages all aspects of payable accounts and integrates with the Retail, Wholesale, Fuel Management, and General Ledger modules to simplify the way customer post payable invoices, make vendor payments, generate management reports, and maintain their payable accounts.
Accounts Receivable (AR): AR allows user to define customer classes, taxes, finance charges, terms, and statement cycles. AR is fully integrated with Inventory, General Ledger, Fuel Management, Wholesale, Retail, and Tax Control modules.
Automated Dunning and Track Collection Actions: The Automated Dunning module automates the way a company collects on past due accounts by flagging customers according to your schedule and their customer type. The system generates the appropriate dunning letter and notifies the customer automatically via mail, fax, or email. The second program, Track Collections Activity, is used to schedule and/or record actions taken by collectors or the automated dunning program, on a case by case basis.
Consolidated Fuel Dispatch: Is an advanced module that offers you integrated order entry, dispatch scheduling, and truck tracking functions. Print loading tickets and dispatch tickets as needed to dispatch fuel for delivery to both customers and profit centers.
Fuel Management: Module tracks all information about a load of fuel from the point of purchase through delivery to actual billing for the load. The system automatically maintains tax, cost, freight, and pricing information, eliminating the need for the operator to make decisions during entry.
Advanced Financial: it provides you with several tools for monitoring and reporting your company's financial activities.
Heating System: Provides you with a powerful and flexible tool for managing your LP gas and fuel oil operations, it allows you to schedule deliveries and create heating system delivery tickets for customer.
Wholesale Inventory: Wholesale Inventory program incorporates all of the functions necessary for creating and maintaining your inventory.
This program allows you to:
Service Management: Service & Maintenance module automates and simplifies your service and maintenance operations for both customers and profit centers. Regardless of the type of service you provide, the module's flexibility allows you to customize it to your specific needs.
This module makes it possible for you to:
General Ledger: Module allows you to customize your general ledger to meet the unique requirements. It eliminating the need for you to print and store the various reports and journals.
Advanced C-Store/Price Book: Module enables you to electronically receive, translate, and preview C-store item Price book data, then accept, alter, or delete the data before it is put into permanent tables within ExecuTrak.
Retail Sales: Retail Sales Module allows you to create price books for C-store merchandise and manages all aspects of retail marketing. It integrates with the General Ledger, Fuel Management, Tax Control and Inventory Control. System offers flexibility for entering shift reports.
Sales Order Entry: Sales Order Entry Module provides a quick and efficient method for recording customer sales orders. System allows you to record a sales order, place items on backorder if necessary, and print picking tickets to use when filling orders. System provides you with key information such as customer purchase history, customer quantity on hand, and product pricing information.
Bank Reconciliation: Is the process of verifying that all bank transactions are recorded properly by you and by the bank. Furthermore, the reconciliation process identifies which items (checks, EFTs, deposits, etc.), have cleared the bank and which have not.
Payroll: Payroll module offers complete integration with the general ledger to simplify the payroll process and ensure the accuracy of your payroll.
Role and Responsibilities:
*
Performed the requirement analysis for the development of this application.
*
Involved in Database Design and Implementation, GUI Design & Development
*
Used the Stored Procedures to display the Product Details.
*
Experienced in Data-Driven web application using Data source support by ODBC.
*
Wrote database Triggers, Procedures and Functions to maintain data.
*
Created Reports using Crystal Reports.
Environment: VB 6.0, Informix, Crystal Reports 6.0, Windows 2000, Informix 7.0.
American International Group, New York, NY Aug’00 – Feb’01
Programmer/Analyst
Custom Elements Interface (AIG)
This software allows the high-profile clients (JC Penny, Boeing etc.) insured by AIG to capture, analyze and audit custom fields during the interview process of claim reporting. This software module acts as a distributed component to be used by other AIG applications namely Account Service Database, Claims Strategic Initiative and IntelliRisk. It has two components-- Maintenance and Viewer. Integrates with other applications inheriting their look and feel and security architecture.
Role and Responsibilities:
*
Performed the requirement analysis for the development of this application.
*
Developed forms using HTML, Server side Coding ASP.
*
Used the Stored Procedures to display the Product Details.
*
Experienced in Data-Driven web application using Data source support by ODBC.
*
Wrote stored procedures in SQL Server 7.x in order to process data from the database to the respective pages.
Environment: ASP, SQL Server 7.x, Java Script, HTML, CSS, Windows NT.
ASRC, India. Sept' 99 to Jun'00
Programmer/Analyst
This is a reengineered Project. The Project was converted from Developer/2000 as Front-end and Oracle 6.0 as backend on UNIX, to the newer version in Visual Basic 6.0 with Oracle 8.0 on Windows NT. The new version is an Integrated Package consisting of the modules viz., Fiscal, Membership, Personnel, guesthouse and Inventory. It incorporated with many advances such as:
*
The No. Of Screens have been reduced for better and simpler navigation to the user.
*
All transactions made at various departments have been integrated and information gets updated into the Fiscal Module.
*
Provides advance information to users such as expiration date of a membership.
Role:
*
Extensively used Visual Basic as the front-end with Oracle as a back-end through ODBC connectivity.
*
Developed Stored Procedures, Functions and Triggers using PL/SQL.
*
Designed Methods for analysis in Visual Basic.
*
Created Forms for all Menus attached to the VB MDI Form.
*
Involved in the Design and Development of Visual Basic Forms.
*
Developed Sub-Procedures for Class Modules using Visual Basic.
Environment: Visual Basic 6.0, SQL Server 7.0, Windows NT 4.0. Crystal Reports 5.0
Kamat Lingapur Hotel, India. Aug' 98 to Aug' 99
Programmer/Analyst
I was part of the team, which developed an Integrated Hotel Management System to centralize all functions of various departments associated with the hotel. The departments associated with this three star Hotel are Front Office, Food and Beverages, House Keeping, Minor Operations Department, Personnel Administration, Accounts, Purchasing, Stores and Inventory and Maintenance. At Front Office the system effectively maintains Guest Information, handles Reservation and Registration. Provides summary for all transactions by a guest at different departments. Under Food and Beverages, the system links all the outlets like Restaurant, Banquet Hall, Bar and Room Service with Kitchen and as well as with Front Office. The system supports by alerting the housekeeping department and Operations Department about necessary amenities at the time of guest check in, or handling complaints lodged by a guest. Personnel Administration module maintains complete information of the employee, time entry, recruitment, salary payments, leaves, loans etc.
Role:
*
Effective use of VB (Active X Controls) made the software more user friendly and easy access to the database.
*
Generated complex reports that included Graphs and Charts, in Crystal Reports, using Stored Procedures written at the back-end for enhanced processing time.
*
Wrote database Triggers, Procedures and Functions to maintain data.
*
Involved in Database Design and Implementation, GUI Design & Development and Integration Testing.
*
Designed most of the forms, which included all data entry dialogs.
*
Created Reports using Crystal Reports.
*
Implemented and trained the users.
Environment: Visual Basic 5.0, Informix 7.X, Windows NT, Crystal Reports 5.0
Mahalakshmi Cooperative Urban Bank Ltd., India. Feb’98 to July’98
Programmer
'Bank-On' Is a Powerful tool for day-to-day analysis of operations, understanding one's Own Business Dynamics and take positive Management Decisions for growth and all-round Excellence. For more operational efficiency the whole system is divided into various modules viz., Customer Related operations, BackOffice Operations, Financial Management and Personnel Administration, which is totally interlinked and work as a cohesive team. It is a user-friendly system that facilitates the customer with better and fast service, backed up with more accurate data. Also Establishes links with BackOffice operations and Financial Accounting. Provides necessary reports for both front office and back office operations. The System also evaluates the day-to-day business by the organization and provides necessary MIS reports, there by facilitating the management to take necessary decisions.
Role:
*
Extensively used Visual Basic as the front-end with Oracle as a back-end through ODBC connectivity.
*
Developed Stored Procedures, Functions and Triggers using PL/SQL.
*
Designed methods for analysis in Visual Basic.
*
Created forms for all menus attached to the VB MDI Form.
*
Involved in the design and development of Visual Basic forms.
*
Developed Sub-Procedures for Class Modules using Visual Basic.
Environment: Visual Basic 5.0, Oracle 6.x, Windows NT. Crystal Reports.
Dr. REDDY LABS, India. Nov’97 to Jan’98
Programmer
This software has been developed to maintain the database of all the drugs produced by the organization, raw materials, Quality control, Formula, batch number and the employees of the organization. The substance of each medicine, the price of each raw material, expiry period, its temperature ranges, and other various specifications are stored in the database. With help of the data maintained, the cost estimation of each medicine is drawn.
Role:
*
Developed forms for Raw materials stock, quality control testing, Formula Number; batch number, customers, and suppliers
*
Involved in designing the tables
*
Developed reports for raw material storage, finished goods stock, Tablets, Orals, Capsules, daily reports, sales, and purchase.
Environment: Visual Basic 5.0, Ms Access, Windows 95, Crystal Reports.