umeshkumar99

UMESH KUMAR VERMA EXPERIENCE SUMMARY Ø I have over Nine years of total IT experience in Client/Server and WEB application development in India as well as US. Ø Extensively used Visual Basic, SQL Server, MS-Access, Oracle, Crystal Reports, Win API, ASP, VBScript, HTML, ASP.Net, C#. Ø Created complex Database triggers and procedures Ø Proficient in Windows 2000/2003, Windows ’98/Xp, MS DOS, Front page Express, Visual Interdev, MS Office products. Ø Has excellent project life cycle experience, team Spirit and experience in end user interaction, looking forward for challenging software assignments and constantly upgrading the skill sets by observing the latest trends of the IT industry. Ø Knowledge WCF, Design Patterns, UML & Web Services ACADEMICS Ø B.E. (I.E.) from Dr. B.A. Marathwada Univ., Aurangabad, [login to view URL] Sep 1995 Ø ADSET Diploma from ASSET International in 1998. Duration Organization Designation April 2009- till date IMSI Team Leader Nov 2005 – April 2009 SPANCO Ltd. Senior Software Engineer Aug 2001 – Oct 2005 ITCE Senior Software Engineer Jan 2001 – April 2001 Computech Corp Software Consultant v TechMahindra Ltd. v April 2009 –till date(6 month) Project: BBCL Videocon Designation:- Team Leader As a TL to lead for support engineer. My responsibilities include to monitor all application developed in .Net & resolve the issue if any ASAP and to entertain for Change requests if any from the customer. Client Name BBCL Title IBS(Implementation & Maintenance(Troubleshooting & Coding also)) Summary It is a Web based CRM application for BBCL Call center agents/Agencies/ Executives of BBCL. It has basically three modules CSR(CRM), Configuration, & Report module. CSR is web based application which is used for dealing with D2h prepaid customers which include Work orders, Financial account creation. CSR Configuration module is Window based application which is used to configuration of Master data for CSR module. Report module is a SRRS application of SQL 2005 to generate different types of reports as per the customer requirement. Other modules include ISM for integration with other application, BMS module which is Windows service application which provides services like Work order generation, Letter generation, Print shop etc. IBS application is integrated with SAP, IVR & Pysis application using Web Services & flat files. Environment MS Windows 2003/ Xp, C#, ASP.Net 3.0 using Visual Studio 2008, Dot net framework 3.5, Ajax, WCF, Oracle 10g RAC(Unix), SQL Server 2005(Clustered Environment), SSRS Team Size 5 Architecture SOA architecture v SPANCO Ltd. 2. Nov 2005 –April 2009 (38 months) SPANCO is a company in Telecommunication & Service provider in the field of BPO Designation: Senior Software Engineer Responsibilities: ü Developing software using Microsoft Technologies (VB, SQL, COM+, SOAP, ASP,C#,ASP.net, Crystal Reports). ü Involved in Design, development & Implantation stages ü Client Interaction. Projects Client Name DLF Pramerica Life Insurance Title Admin Module for LC Summary It is a Web based application for DLF Life Insurance Leads which are generated from Outbound calls. The generated leads are assigned to the BDM, then to Life Consultant. Various reports are available for Leads status. Other screens are designed to update the leads, Admin module for managing the users, Web services to send the mail & prepare the SRS & AT documentation. Environment MS Windows 2003/ Xp, SQL Server 2005, Crystal Reports 8, C#, ASP.Net 2.0 using Visual Studio 2008, Dot net framework 3.5, Ajax,UML2.0 Team Size 3 Duration Nov 2008 to Jan 2009 Role Team Lead with team size of 3 people Websites Url [login to view URL] Architecture 3-Tier Architecture Client Name UBICO Title Web based Tracking System for RF System Installation Summary It is a Web based application for UBICO which is used to Upload data through different web pages for different stages of RF installation. & prepare the SRS & AT documentation. It provides different reports for different RF installation stages & as per the requirement, Automated E-mail using Web services. Environment MS Windows 2003/ Xp, SQL Server 2005, Crystal Reports 8, C#, ASP.Net using Visual Studio 2008, Dot net framework 3.5, Ajax,UML2.0 Team Size 3 Duration June 2008 to Jan 2009 Role Team Lead with team size of 2 people Architecture 3-Tier Architecture Client Name MTNL Delhi Title Unified Call center(Maintenance Project) Summary It is a CRM application integrated with IVR developed for the Call Center of MTNL. It caters all kind of services which the MTNL is providing like GSM, Broad Band, PSTN, CDMA, LC etc. I am working as a Project Leader. My role is to interact with the client, taking inputs & impart modules to my team members. Maintaining the entire Software & hardware. Environment MS Windows 2003/ Xp, MS Visual Basic 6.0, COM+, Visual Source Safe, Visual Interdev, ASP, VB Script, Java Script, SOAP 3.0, SQL Server 2000,Oracle9i & Crystal Reports 8, C#, ASP.Net 2.0 using Visual Studio 2005 Team Size 12(maintenance Engineers)+2(Software Engineer) Duration Jun 2008 to Jan 2009 Role Project Lead Architecture 3-Tier Architecture Client Name BSNL Patna Title Call center for Land Line, Broadband & WLL Services Summary It is a CRM application integrated with IVR developed for Call Center by BSNL Patna. I was working as a Project Leader. My role is to interact with the client, SRS documentation preparation taking inputs & impart modules to my team members, help them out in problems if any, demonstrate the module to client & AT part. The main features includes Ø Entry of new Complaints & Request through Inbound screen. Ø Outbound /Marketing calling through outbound screen Ø Offline dumpers for complaints & requests. Ø Providing information to the CCE through HTML pages & Query Search for the information to be searched. Ø Sending of Bills & application forms through E-mail, SMS & Fax. Ø Generating various reports using Crystal reports & ASP Ø Created VB packages for importing database & Bills from BSNL Oracle database. Environment MS Windows 2003/ Xp, MS Visual Basic 6.0, Visual Interdev, C#, ASP.Net 2.0 using Visual Studio 2005, Java Script, SQL Server 2005,Oracle9i & Crystal Reports 8. Team Size 2 Duration Jan 2008 to May 2008 Role Team Leader with team size of 2 people Client Name BSNL Pune Title Call center for Land Line Summary It is a CRM application integrated with IVR developed for the Call Center by BSNL Pune. I was working as a Sr. Software Engineer. The main features includes Ø Entry of new Complaints & Request through Inbound screen. Ø Outbound /Marketing calling through outbound screen Ø Offline dumpers for complaints & requests. Ø Providing information to the CCE through HTML pages & Query Search for the information to be searched. Ø Sending of Bills & application forms through E-mail & Fax. Ø Generating various reports using Crystal reports & ASP Ø Created crone packages for importing database & Bills from BSNL. Environment MS Windows 2003/ Xp, MS Visual Basic 6.0, COM+, C#, ASP.Net 2.0 using Visual Studio 2005, Java Script, SQL Server 2000,Oracle8 & Crystal Reports 8. Team Size 8 Duration Feb 2007 to July 2007 Role Module Leader with team size of 2 people Client Name MTNL Delhi Title Unified Call center Summary It is a CRM application integrated with IVR developed for the Call Center by MTNL Delhi. It caters all kind of services which the MTNL is providing like GSM, Broad Band, PSTN, CDMA etc. I was working as a Module Leader for GSM process & prepare the SRS & AT documentation. The main features includes Ø Entry of new Complaints & Request through Inbound screen. Ø Providing information to the CCE through HTML pages & Query Search for the information to be searched. Ø Sending of Bills & application forms through E-mail, Fax & SMS. Ø Tracing of complaints & requests through outbound screen. Ø Handing of entered Complaints & requests through Web based Nodal Application Ø Generating various reports using Crystal reports & ASP Ø Developed COM+ component for IVR & CRM package Ø Created crone packages for importing database & Bills from MTNL Environment MS Windows 2003/ Xp, MS Visual Basic 6.0, COM+, Visual Source Safe, Visual Interdev, ASP, VB Script, Java Script, SOAP 3.0, SQL Server 2000,Oracle9i & Crystal Reports 8, DTS Packages, C# ,ASP.Net 2.0 using Visual Studio 2005 Team Size 15 Duration Nov 2005 to Jan 2007 Role Module Leader with team size of 4 people Architecture 3-Tier Architecture v ITCE v Aug 2001 – Oct 2005(50 months) ITCE is a company in Computer Education & Software Development in Microsoft Technologies Designation: Senior Software Engineer Responsibilities: ü Developing software using Microsoft Technologies (VB, SQL, ASP,Crystal Reports). ü Involved in Development & Implantation stages. Projects Client Name Indian Air Force (Subroto Park) Title IT Return System Summary It is an application developed for Indian Air Force (Subroto Park) to facilitate the filing of IT return for their officers all over India. The main database store Distributor Detail, Customer Detail, Category, Quality, Item & Sales related details, etc .The main features includes Ø Entry of new officer’s details. Ø Entry of new Assessment year, lots and or circle for a particular year. Ø Filing of IT return and finalizing of IT Return to the IT Department. Ø Searching of records by Officers Service number and by their name. Ø Generating different type of reports as per the customer requirement. Environment MS Windows Xp / 2000, MS Visual Basic 6.0, Visual Source Safe, MS SQL 2000, Oracle 8i, Crystal Reports8. Team Size 5 Duration 11 months Role Senior Programmer(Development & Implementation) Client Name Amit Marbels Pvt. Ltd. Title Inventory Control for Import and Export of Marbles Summary It is a multi-user application developed for a Marbel House which Import and Export different types of Marbles from different countries. Ø Entry of New Marvel Categories & Qualities. Ø Entry of New Stock of marbles. Ø Entry of Outward or delivery of items to the customer. Ø Generating reports like Customer detail, Date wise Sales, Category wise sales, Bill, Salesman wise Sales. Environment MS Windows Xp / 2000, MS Visual Basic 6.0, SQL 2000, Crystal Reports8 Team Size 3 Duration 5 months Role Programmer(Development & Implementation) Client Name Crocodile Garments Showroom Title Garments Sales & Inventory System Summary It is a multi-user application developed for a Garments Showroom. The main database store Distributor Detail, Customer Detail, Category, Quality, Item & Sales related details, etc .The main features includes Ø Registration of New Distributors. Ø Registration of New Customer who are regular. Ø Registration of New Garment Category, Quality & Items. Ø Generating reports like Customer detail, Date wise Sales, Category wise sales, Bill, Salesman wise Sales. Ø Updation of Inventory from local to central database and vise versa on regular interval Ø Bill Generation Environment MS Windows 98 / 2000, MS Visual Basic 6.0, MS Access, SQL Server2000, Crystal Reports8 Team Size 3 Duration 4 months Role Programmer(Development & Implementation) Client Name Mohini Finance Title Finance Management System Summary It is an multi-user application developed for a finance company. The main database store Distributor Detail, Customer Detail, Finance related details, etc .The main features includes Ø Registration of New Distributors. Ø Registration of New Customer who are entitled for the loans. Ø Generation of reports of customer distributor wise. Ø Generation of report of Ø Generating reports like Accounts detail, Customer detail ,Item consumption ,Pending orders Environment MS Windows 98 / 2000, MS Visual Basic 6.0, MS Access, SQL Server2000, Crystal Reports8 Team Size 3 Role Programmer(Development & Implementation) Duration 5 months Client Name ARM AGRO EXPORT PVT. LTD. Title Sales & Inventory Management System Summary It is a multi-user application developed for a Agro Products Company. To manage sales and marketing division of a nation wide organization through distributed software .The main functionality includes Ø Addition of personnel information of Employee C & f, Distributor, Retailer, SR, Retailers within that area, category, brands within that category. Ø Order entry that includes S R name, Party name, Distributor name, Quantity of order for a brand Ø Processing the order. Ø Generating Day wise report of SR keeping track of orders of SR’s Ø Generating monthly reports of SR, SO and ASM and comparing it with sales target set for that particular month. Ø Generating monthly brand wise report within a category and comparing it with sales target. Ø Generating party wise (C and F, Distributor And retailer wise.) reports for a duration. Ø Monitoring the distributor Stock, Searching for the missing orders Ø Keeping track of all the counters (Retailer) ordering less than the minimum quantity. Ø Keeping track of order received, order Executed, order pending, order cancelled. Environment MS Windows 98 / 2000, MS Visual Basic 6.0, MS Access, SQL Server2000, Crystal Reports8, DTS Packages Team Size 4 Role Programmer(Development & Implementation) Duration 7 months Client Name Silica InfoTech Title Hardware Sales, Service & Inventory System Role Programmer Ø Involved in the preparation of program specifications. Ø Involved in the development and implementation of both the front-end VB as well as database part-using SQL Server and MS Access. Ø Involved in the prototyping part. Ø Developed various reports using Crystal Reports 8 Summary It is a multi-user application developed for a company. The main database store Vendor Detail, Item Detail, Customers detail, AMC Detail, Non AMC detail, etc .The main features includes Ø Registration of AMC customers. Ø Providing Services to the AMC & non AMC customers. Ø Automatic purchase order for the items Ø Generation of Quotation details Ø Cancellation for Quotation Ø Generating reports like Accounts detail, Customer detail ,Item consumption ,Pending orders Environment MS Windows 98 / 2000, MS Visual Basic 6.0, MS Access, Oracle8, Crystal Reports8 Team Size 3 Duration 6 months Client Name [login to view URL] Title Promotional Sites of the company Summary Ø Description about their products, technology, company information & management details. Ø Online registration of customers. Ø Feedback of the customer Role Programmer Environment MS Windows 98 / 2000,ASP, HTML, Front Page Team Size 2 Duration 2 months Role Programmer Computech Corp. Jan 2000 – April 2001 (15 months) Computech is a company in Software Development /Consulting having offices in India & US. Projects Client Name Pharmacia & Upjohn, Kalamazoo, MI Title Intranet Conference Booking System Summary The Application enables the P & U Employees all over world can take part in Audio / Video Conference between metro cities any time round the clock, this system enables the user to book a time slab for the conference at any moment. The software (ASP) is placed in P & U Main server at Kalamazoo, MI and can be accessed all over the world thru the WAN network setup of the company. All the Conference bookings will be mailed to the Administrator who is in charge of making arrangements for the Conference (Audio and Video). Role Software Consultant Ø Designed the front end for user interaction using HTML and Visual InterDev 6.0. Ø Provided different links for the user to navigate through the availability chart with the Hyperlinks so that the company staff can book the conference round the clock from any P & U center around the world. Ø Designing and developing Active Server Pages using VB Script and JavaScript. Ø Designed the Mail system, Announcements and Tips & Tricks page between the P & U employees around the world. Ø Created normalized database tables in Ms Access and linked with SQL Server 7.0. Environment ASP, HTML, DHTML, Visual InterDev 6.0, VBScript, Java Script, IIS4.0, SQL Server 7.0 & Windows NT 4.0. Team Size 3 Duration 4 months(Development & Implementation) PERSONAL PROFILE: Name : Umesh Kumar Verma Date of Birth : 16th July 1973 Father’s Name : Late Sh. M.C. Verma Nationality/Status : Indian/Married having one 7 year old kid Passport Number : H3781956 valid till 2019(Delhi) Permanent address : RZH-375, Lane NO.-5,RAJ NAGAR-II,PALAM COLONY,NEW DELHI-45 Mobile : [login to view URL] Landline : 011-25362555 Email Address : umesh_kuamr99[at]yahoo[dot]com, umesh.kumar99[at]gmail[dot]com Non IT Experience Worked as a Service Engineer in Sunitron Electronics Pvt. Ltd & Spectrum Associates from 1996 to 1998 Date : Place: (Umesh Kumar Verma)