CRMpeople.com

Presents

Resume 798.

• Masters in Business Administration (MIS)

Bentley College, Waltham, MA 1998

• Bachelor of Technology (Electrical Engineering)

IT-BHU, India 1993

• Microsoft Certified Professional (.NET)
• Developing & Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET (70306)
• Microsoft Certified Solution Developer
• Designing & Implementing Desktop Applications with Visual Basic 6.0 (70176)
• Designing & Implementing Distributed Applications with Visual Basic 6.0 (70175)
• Microsoft Visual Basic 5.0 Programming (70165)
• Analyzing Requirements and Defining Solution Architectures (70100)
• Microsoft Certified Database Administrator

• Designing and Implementing Databases with Microsoft SQL Server 7.0 (70029)
• Administering Microsoft SQL Server 7.0 (70028)
• Installing, Configuring and Administering Microsoft Windows 2000 Server (70215)
• Implementing and Administering a Microsoft Windows 2000 Network Infrastructure (70216)

Project Lead 4/2002 – Present

• Led and Managed a team of 4 developers and testers in Onyx CRM Upgrade/Implementation project (version 3.0). The client is upgrading their Onyx CRM product from version 4.0 to version 5.01.
• Managed the development of customized OEAS step components for customizations related to expansion fields for Sales incidents and customized search for customers.
• Involved in customizing the stored procedures related to customizations for SLA (Service Level Agreement) notification and New contract notification.
• Created a detailed test plan for testing using Microsoft Project Plan software. The plan identifies and allocated tasks to appropriate resources and keeps track of project.

• Implemented a scalable web-enabled virtual IT/Recruiter Placement Agency application using ASP.NET that accessed business objects by means of XML Web Services. The Web User Interface was created through the execution of components using ASP.NET and HTML. All of the application data was persisted in a data source, using Microsoft SQL Server 2000.
• Created Web content using ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and data binding. Separated page code from content using code-behind pages, page controls, and components.
• Created and deployed serviced components (COM+ applications) applications into the global assembly cache.
• Created strongly named assembly to ensure safe use of the component contained within the assembly.
• Manipulated XML data within ADO.NET DataSet by means of XMLReader.
• Created complex business components using .NET class library assemblies and implemented them in a multi-tier environment.
• Implemented business and data extraction logic through the use of ADO.NET, and Web Service to manipulate a Microsoft SQL Server database through the use of stored procedures.
• Implemented debugging functionality by sending messages to the Application log in EventViewer.

Medfield MA

Technical Consultant (CRM Practice - Onyx) 1/2001 – 3/2001

• Created ASP pages that augment sales incidents with survey feature. These pages are similar to the surveys that are attached to the Companies and Individuals records that come out of the box for the Onyx Employee Portal. Creation of this functionality required creating tables, triggers and stored procedures that mirror the functionality of the surveys owned by the Individuals and companies. Made extensive use of JavaScript and CSS to implement this functionality.
• Identified the existing business rules and customized the stored procedures responsible for the sales, support and service incidents in the Onyx database based on those business rules.
• Involved in setting up the Log Shipping process that creates a directory structure on the SQL Server machine for backup of the database and sets up jobs that will backup the Onyx, Customer Portal and Membership databases at scheduled intervals
• Installed, configured and customized the Onyx Customer Portal and Onyx Employee Portal package (web based CRM products of Onyx) for a leading provider of comprehensive project management, control and execution software. The customizations to the package were based on the business rules that were identified during the solutions definition process. The customizations included making modifications to the stored procedures that have been written for a SQL Server 7.0 database and making changes to the ASP pages that are called by the IIS 5.0.
• Involved in migrating the CRM application from Win NT 4.0 operating system to Win 2000 operating system. This involved formatting the machine, installing Windows 2000 operating system, installing Site Server, Commerce Server, SQL Server on Windows 2000 and mapping all the Onyx Customer Portal users in the Onyx Customer Membership to the Site Server membership instance by creating an Active User Object. Also created the Commerce Server Site, which was the foundation on which other Onyx Customer Portal ASP pages were built.

• Created a COM component that was used to validate the access permissions of the research reports for different users. This component is used by the IIS for the web based CRM application. Also made modifications to the system parameters and national language table in the Onyx database to include additional tabs on the Onyx thick client.
• Made customizations to the stored procedures of incident inserts for Onyx’s Email Agent so that an automatic email is sent back to the user based on the domain from which the email originated.
• Integrated Onyx’s EnCyc product functionality with Onyx Customer Center. This integration allows an Onyx user to find a list of all the products in the EnCyc database that are related to a specific literature item.

Arlington MA

• Created ASP pages that are used in a wireless application to retrieve the data from an exchange mailbox. The connection to the Microsoft Exchange mailbox is made using exOLEDB as a data source provider. The information stored in the mailbox is retrieved using different URN (Unique resource namespace) schemas. The middle tier component houses the code for data retrieval and updates and passes the data back to the asp pages in the form of text string by parsing through the record set object that contains XML data. The string data returned to the client is again converted to XML and is transformed using XSL style sheets.
• Created ASP pages those are part of the presentation layer for a 3-tiered multilingual e-commerce application. These asp pages present the data to the user after accessing it from the database using Visual Basic objects. The session information for the user is managed using session parameters that are stored in the session object. The information is passed from one page to the other page using the session object that has been created in Visual Basic. The validation and update of the data entered by the user is done on the same page by posting the information back to the form. All the validation is done on the server side.
• Designed the SQL Server 7.0 database for a multilingual e-commerce application that is web based and will be used by different kinds of users depending on their permissions to view and modify the information in the database. Involved in design of the database schema and creating maintenance scripts. Created a number of stored procedures that are accessed by VB objects.
• Incorporated the business services component developed for a web-based Money Management System into the presentation layer by using ASP. The user information for the session was tracked using cookies.
• Involved in debugging the business component that was developed using Visual Basic 6.0. The functionality of the business component included creating, modifying and updating the information for a user. Role-based security was used for accessing and making changes to the data.

Boston MA

• Developed the front-end of a client/server application that is being used by Fixed Income traders to select the most optimal list of securities for trading based on the list of criteria entered by the trader.
• The traders can specify different parameters like the duration, the yield to maturity, coupon rate and the range of maturity date for the bond. The results returned by the generated query are displayed to the bond traders on ProtoView’s Grid Control and show the CUSIP number and the fund that hold the particular security. The trader can select the funds that they might be interested in reallocating and specify the order of priority. The information of the selected funds and their respective CUSIPS is sent to an Excel spreadsheet to find the optimal list for trading. The application supports both mortgage backed and non-mortgage backed trades and supports two legs of trade.
• The application was developed using VB 5.0 and made extensive use of COM components. The data that is displayed to the user accesses data from an Oracle 7 database using ADO 1.5 and Microsoft's ODBC Driver for Oracle.

• Developed an application used to update order information on a corporate web site for a worldwide manufacturing corporation. The application is a VB executable that accesses SQL Server 6.5 stored procedures. Also responsible for the maintenance of Crystal Reports used by the clients to track order information. This included the debugging of SQL Server 6.5 stored procedures and views.
• Developed enhancements for an order entry, order scheduling, invoicing accounts receivable and sales tracking application used by a large glass and windshield replacement company. The application is a VB executable that accesses SQL Server 6.5 stored procedures. Involved in coding, debugging and testing of modules, functions and reports.

Waltham, MA
Graduate Assistant, CET Department                                       1/1997-4/1998

• Developed and maintained the website of the Center for Excellence in Teaching Department.
• Assisted the faculty in various departments in their research by finding relevant articles on the WWW, Infotrac, Lexis and Bloomberg.

New Delhi, India
Engineer                                       12/1995-1/1997

• Involved in product launch of newly developed geared motors and gearboxes.
• Established and revised yearly sales target for the New Delhi Branch office.
• Interacted with the Original Equipment Manufacturers in plastics, steel, and cement industries.
• Coordinated with the head office and the factory regarding deliveries.

• Created the financial statements (Cash Flow statement, Fund Flow statement, income statement and balance sheet) for 5 years for a startup based on the projections compiled from various sources.
• Conducted a thorough financial analysis of the startup idea and calculated the financial feasibility of the project using different methods like calculating NPV for the project based on different discounting rates and cost of capital, the IRR and payback period.