Summary
I have 5 years of diverse experience in the development and analysis of software. I have been actively involved in requirement study, systems analysis, system design, development, testing, rollout and administration of several client server systems based on Vantive, Vantive for Communications, Vantive eSales, SFA, CALL CENTER, Oracle, Sybase, SQL Server, DB2 and Integrating vantive with paging system. I have experience in the installation and configuration of the Actuate Reporting System on NT as well as developing different reports within the Vantive space. I also have experience in web technologies .I also had experience in DB2/CICS on IBM ES/9000 platform. I have interpersonal skills and a team player.
Education
Bachelor of Engineering (Computer Science) 1992-1996
Technical Skills
Operating Systems : Win NT, Windows 95,98, Unix, HP-Unix, MVS, and MSDOS
Software : COBOL, JCL, SQL, PL/SQL and Visual Basic 6.0
Database : SQL Server 6.5,Sybase, DB2, and Oracle
Web Development : ASP, JSP, HTML, XML, VBScript, JavaScript, IIS, and MTS
CRM : Vantive 7.0,Vantive 8.0, Vantive 8.2,Vantive for Communications
OLTP : CICS
Reporting Tools : Actuate 3.x, Crystal Reports
Internet Tools : Visual InterDev, Visual SourceSafe
Project Experience Mar 2000 to till date (Vantive Consultant) Allied Riser Communications Inc., Dallas, TX, USA
Member of the team that implemented Vantive Enterprise in ARC and integrating with the paging system. Point of contact for questions involving all areas of Vantive implementation
System Specifications: Vantive Server on Windows NT 4.0 using Microsoft SQL Server 6.5 as the database engine, implemented with the primary server located in Atlanta.200 named users using a mixture of Windows 95/NT 4.0 workstation / 2000 Professional PCs and laptops. Application customized to reflect ARCs Standard Operating Procedures especially the process relating to opportunity management and integrated with the Oracle based ERP system.
Modules implemented Sales, Support, Helpdesk and eSales
Project 1: Data Synchronization from Oracle to SQL Server 6.5 using Vanperl
Project team strength / time frame Project Leader with 1 analysts /configurations) / 2 months.
Role: Analyst / Configurator responsible for design, development, implementation and testing of data sync utility.
Major tasks done
Developed an application in Perl using Vanperl to register new employees in the ARC Vantive System
Configured Vantive Enterprise using VantiveTools. Modifications carried out to objects in all three layers. Database extended to accommodate integration with the ERP System and to generate a unique reference number (formatted according to existing guidelines) for each Employee from the ERP System
Loaded master employee list. A Perl batch Module was developed to cleanse and sync the data into Vantives Interface Tables
Created workflow processes / policies / programs to enforce business rules. Eg. Sending emails to customer support members when error occurred, triggering the creation of a new problem report in the Vantive System
Project 2: Vantive Notification Rules For Helpdesk and CCC Using SQL Utility
Project team strength / time frame Project Leader with 4 analysts /configurations) / 4 months.
Role : Analyst / Configurator responsible for design ,development, implementation and testing of Notification Rules .
Major tasks done
Integrating vantive with the external paging system.
Created Stored Procedures to dynamically get emailids based on severity
Created Stored Procedures to dynamically format email to pager and regular mails
Configured SQL Mail Utility for sending mails from the Database Server
Project 3: Enhancement Of Lead Management and Asset Management
Project team strength / time frame Project Leader with 4 analysts /configurations) / 6 months.
Role : Analyst / Configurator responsible for design ,development, implementation and testing of Enhancement Of Lead Management and Asset Management.
Major tasks done
Subject Matter Expert on all User side and Business Purpose issues for Vantive
Investigated feasibility of desired enhancements, initial requirements gathering, and construction of Functional Requirements and Functional Design documents.
Gathered end user requirements and created plans for developers.
Provided ongoing support, troubleshooting, enhancements, and business process analysis.
Implemented a Category Subcategory feature that allowed the customer care rep to select various combinations, and then have the incident automatically routed to the correct department based on his backside administration.
Customized vantive foms to reflect data and business layer modifications
VantiveVBA used for data validation and accomplishing application pre-launch tasks
Dec 1999 to Feb 2000 (System Analyst) OneSoft Inc., McAllen, VA, USA
Member of the team that implemented One Commerce in www.ephones.com and www.allpets.com .
System Specifications: Windows NT 4.0 using Microsoft SQL Server 6.5 as the database engine. SQL Sever 7.0,ASP, XML, XSL, and Visual Basic 6.0
Project team strength / time frame Project Leader with 12 analysts /configurations) / 5 months.
Role : System Analyst responsible for design ,development, implementation and testing of Active Server Pages using ADO and handling database cleanup.
Major tasks done
Ephones WorkStation
Was involved in development, testing of the Active Server Pages, xml for the Totally Wireless Inc., CA.Worked on the following websites development using the OneCommerce Product that is used for Internet shopping of Cellular Phones (www.ephones.com).
Allpets WorkStation
This project is a part of Allpets site developed by Onesoft Corp. The site is developed for pet lovers who can get all the information like pets market, parade of breeds ,pets show details etc and order by registering an account for them. This workstation module in the application software includes Custom Station where the customer information is stored, Admin station where administrator privileges can be given, sales station where we can keep track of the products comes under specific categories. Materials for the Pets (www.allpets.com) .
Aug 1999 to Nov 1999 (Vantive Developer) NEW, Sterling, VA, USA.
Member of the team that implemented Vantive Customer Support.
System Specifications: Vantive Server on HP-UNIX 4.0 using Sybase as the database engine. 500 users using a mixture of Windows 95/NT 4.0 workstation / 2000 Professional PCs and laptops. Vantive Customer support application customized to handle claims processing for extended warranty of Allison Transmission Division (ATD)
Project team strength / time frame Project Leader with 14 vantive application developer / 4 months.
Role : Vantive Application Developer responsible for design ,development, implementation and testing of Customized Vantive forms and utility.
Major tasks done
Provided ongoing support, troubleshooting, enhancements, and business process analysis.
Customized vantive foms to handle the claim processing system of ATD
VantiveVBA used for data validation and accomplishing application pre-launch tasks
Apr 1999 to Jul 1999 (Technical Engineer) Vantive Europe, Germany
Project 1: Pre-Sales Effort for BMW Corporation, Munich, Germany
System Specifications: Vantive Server on Windows NT 4.0 using Microsoft SQL Server 6.5 as the database engine. Application customized to requirements of BMWs Sales and Call Center.
team strength / time frame Project Leader with 4 vantive application developer / 4 months.
Role : Vantive Application Developer responsible for design ,development, implementation and testing of Customized Vantive forms and utility.
Major tasks done
Customized vantive foms to the requirements pf BMW.
VantiveVBA used for data validation and accomplishing application pre-launch tasks
Vantive Perl used for data uploading from the external systems.
Project 2: Installation of Vantive Sales Module for Vorworkef, Wuppertal, Germany
System Specifications: Vantive Server on Windows NT 4.0 using Oracle as the database engine.
Project team strength Vantive Installation Engineer.
Role : Vantive Installation engineer responsible for installing Sales Force Automation.
Major tasks done
Creating Tablespaces, loading vantive data using vantive perl application
Configuring the vantive server and Database Server
Mar 1999 to Apr 1999 (Vantive System analyst) COE, Bangalore, India
System Specifications: Vantive Server on Windows NT 4.0 using Oracle as the database engine.
Modules implemented Sales, Support, Helpdesk ,Actuate Report Server 3.2
Project team strength Project Lead with 2 analysts
Role : Vantive system analyst responsible for installation of Vantive Enterprise.
Major tasks done
Installation of Vantive Enterprise, Setting Up the database server and configuring the Vantive Server.
Configured Vantive Enterprise using VantiveTools.
Integrating Actuate with Vantive
Nov 1998 to Feb 1999 (Application Developer) Sterling Software, Reston, VA, USA
Member of the team that implemented Vantive Sales Force Automation, Vantive On The Go.
System Specifications: Vantive Server on Windows NT 4.0 using Corporate Database as Microsoft SQL Server 6.5 and Sybase Anywhere as the Consolidated database engine, implemented with the primary server located in Reston.200 named users using a mixture of Windows 95/NT 4.0 PCs and laptops. Application customized to reflect Sterling Software Standard Operating Procedures especially the process relating to Lead,opportunity management .
Project team strength / time frame Project Leader with 4 vantive application developer / 4 months.
Role: Vantive application developer responsible for customization of vantive screens
Major tasks done
Created Mobile database for Sales Rep to their laptops.
Created Stored procedure to enforce their Business rules.
Created workflow processes / policies / programs to enforce business rules.
VantiveVBA used for data validation and accomplishing application pre-launch tasks
December 1996 to Oct 1998 (Software Engineer) Florida Software Solutions
System Specifications: ES/9000, MVS using DB2 as the database engine. Uses COBOL, VS-COBOL II, CICS, VSAM and JCL
Project team strength Project Leader with 20 Software Engineer
Role: Software Engineer responsible for Coding, debugging and testing
Y2K Enablement of Banking Account System
The main objective of this project is to solve the Year 2000 problem, to analyze the source code given by the client, which includes four modules. The source code is analyzed for identifying different date fields having Year 2000 problem. To scan the source code and to find out date fields with its usage and type. The impact analysis reports are generated using Revolve tool. Once the codes identified conversion is carried out using copybooks.
InsurancePolicyManagementSystem
Norwich Union Insurance Corporation covers a wide range of insurance such as Life Insurance, Health Insurance, Fire Insurance, Motor Vehicle Insurance, Aviation Insurance, General Insurance, Marine Insurance, Shopkeeper Policy, Transportation Policy and Accident Insurance. This Project is developed as a process of automation for insurance policy management including motor vehicle Insurance, fire, marine, aviation and other insurances. The system, which has the policy proposals, claims, accounts and reports.
May 1996 to October 1996 - (Programmer Analyst) Cyberdyne Software, India
System Specifications: BORLAND C, MS-COBOL; Operating System: MS-DOS, Windows 3.1
Project team strength Project Leader with 4 Programmer Analyst
Role: Programmer Analyst responsible for Coding, debugging and testing
Inventory Control System (Spartex Suppliers Private Limited)
This system has completely automated to cope up with sales, purchase, conversions, on approval and other transactions for a range of textile goods and reports like sales and purchase registers and statements like Item wise/Quality-name wise stock statements are generated. Collecting information from the related persons and existing manual system and contributed to the design of the system after sufficient analysis.
Document Editor
This project creates a document editor. This project is responsible for creating a text file, saving a file, editing the files. This project has the following features:
1. Multi Document Interface
2. Bitmapped Menu Selection
3. Scrolling Functions
|
