VIPUL MEHROTRA E-Mail vipul24mehrotrayahoo.co.in Contact 91-9229286861 JOB OBJECTIVE Seeking mid-senior level assignments in the domain of Business Development / Business Analysis / Public Relations / Corporate Communications / Networking / Oracle Apps Database Administration / Event Management in any sector PROFILE SUMMARY A budding experienced professional in Business Development, Business Analysis, Public relations, Networking, Oracle Apps Database Administration, Event management and Project Management. Well versed with the concept of database administration, software installation and patching, scripting, cloning, BCP Business Continuity Plan, systems analysis, network administration and Business Development. Gained exposure in Oracle Apps Database Administration activities encompassing database planning, design, installation, configuration, disaster recovery planning back up and recovery, etc. Expertise in concepts of end-to-end planning and implementation from scope management, to activity sequencing, effort cost estimation of projects. Deft in administering High Availability Production Databases Oracle under UNIX, Solaris, Oracle Applications, Networking, and Windows platforms. An effective communicator with good people management and motivational ability, leadership, ownership, initiative, client management, creativity, problem solving, presentation and analytical skills. CORE COMPETENCIES Business Development Business Analysis Network Management Oracle Apps Database Administration Training Management Event Management Team Management Project Management Business Management WORK EXPERIENCE Seprsquo11 ndash Julyrsquo13 Wipro Infotech Ltd., Gurgaon as Software Engineer Oracle Apps Database Administrator Key Result Areas Steering installation and administration of Oracle Database Supporting the team members and maintaining the database as per the security standards Heading Database Structure, Storage Allocation, Table/Index segments, Database Access, Roles and Privileges Resolving database performance related issues and supporting the new joinees DBA with getting access to server, explaining them the process and helping them to get comfortable Working on RAC 10g environment , taking care of BCPBusiness continuity plan, database and application cloning, backups using RMAN, patching, weekly server reports and weekly and daily checklists and issues reported by the client in a 247 support project PART TIME EXPERIENCE Octrsquo09- Mayrsquo11 HCL CDC HCL Infosystems Ltd. Education , Bhopal Assignments Handled Octrsquo09 ndash Seprsquo10 Public Relations Officer at MP Nagar, Bhopal Decrsquo10 ndash Mayrsquo11 Centre Business Head at Bittan Market, Bhopal EDUCATION 2013 COBC, FCPA, UCF L2.1 EAS Apps DBA with 92 from Wipro Ltd. 2010 Network Technologies and Devices CCNA module 86 and SUCHCEH module from HCL Infosystems Ltd., Bhopal 2011 B.E. Hons. in Information Technology from Laxmi Narain College of Technology Science, Bhopal, RGTU 2007 XII Science from Kendriya Vidhyalaya No. 2, Bhopal, Central Board of Secondary Education 77.6 2005 X from Kendriya Vidhyalaya Mathura Cantonment, Central Board of Secondary Education 76.6 IT SKILLS Technologies known C, C, Oracle Apps DB, Network designing and implementation, RUEI Operating Systems Windows 98, XP, XP Professional and 2007, Solaris, UNIX Office Suits Microsoft Office 98/2000/2003/2007/2010 TRAININGS ATTENDED AND PROJECTS Title Network Technology Devices CCNA module Description This training was designed for working and configuration of networking devices like CISCO 2950 switch, CISCO 2500 and 2600 series router. It was based on topologies designed in the simulator i.e. packet tracer 5.0 which were implemented live on the networking devices mentioned above. Implementation involved networking contents like IP addressing, subnetting, dynamic routing using the protocols, virtual LAN, Inter VLAN routing, etc. Title LAN Management- Project for 786 Independent Air Defence Brigade Description During this project, the local area network LAN of an office was configured and properly managed by the use of the VLAN concepts, properties of sharing in Windows XP Professional, inter VLAN Routing and other necessary requirements. The whole topology of an office was configured on Packet tracer 5.0 and after correcting the errors the whole topology was configured live using 2642 Router and 2950-24 Switch of CISCO. Other projects Title Data Cruiser 1Minor Project and Data Cruiser 2 Major Project Title Industries for Rural Development OTHER ACCOLADES Holds the merit of being awarded o A certificate from Red Shield Institute of Information Technology for successfully completed the course in ldquoBasic Programme Windowsrdquo in 2000 o All India Talent Search Examination Certificate of Merit in 2004 o Scholarship by Gyan Ganga Group of Institutions in 2007 Received certificate on o Jawaharlal Nehru KVS Regional Science Exhibition for project on lsquoIndustries for Rural Developmentrdquo in 2005 o Microsoft and HCL for participating in New Look Efficiency in 2009 Successfully organized national level mega technical festival for o TECHNO-SPIRE for HCL CDC, MP Nagar BHOPAL in April 2010 o TECHNO-SPIRE RETURNS for HCL CDC, BITTAN Market, Bhopal in October 2010 Accredited for receiving appreciation for o Routerrsquos Basic Configuration Workshop Coordinator in Planet Engineersrsquo-09 Yuva Utsav in 2009 o Being a devoted YUVA Youth for Welfare member in 2009 o Water Saving Awareness Campaign named ldquoBlue Revolutionrdquo supported by YUVA, RGPV, Dainik Bhaskar and My Fm in 2009 Was founding member of FACITS Forum for Assistance of Computer Science and Information Technology Students and started Technospire venture for HCL CDC, MP Nagar and Bittan Market Bhopal HCL Infosystem Ltd. Education . PERSONAL DETAILS Date of Birth 24th November, 1989 Address B-003, Shalimar Regency, G-2, Gulmohar, E-8, Arera Colony, Bhopal ndash 462019 Linguistic Abilities English and Hindi Please refer to the annexure for the project details ANNEXURE Title IT Oracle Apps Database Support Description This project is based on making daily and weekly checklists, patching, cloning, checking for spaces on the mount points, monitoring the application and the database. Other day to day activities involved checking for consistent backups, clearing old archives, compiling procedures and packages on userrsquos requests, monitoring and resolving database locks, analysing long running concurrent requests and coordinating with the developer to reduce the running time of the requests, cleaning inactive sessions whenever users complaint of latency in the application. Worked on RAC 10g environment if some issue comes in it, managed the production issues on Unix environment. Here, shell scripting is also a part of the project. Title Data Cruiser Major Project Description This project was aimed to map security while configuring the network of an office and while establishing the WAN between the offices of the companies. Successfully covered the concepts of VLAN, dynamic routing using RIP, Frame-relay, IP phone, inter VLAN, wireless routing, server configurations and their practical implementations by using simulator packet tracer 5.2. Title Technospire Project Description This project was an event that was aimed to give the trainings and maximum exposure of the technologies that are being used in the corporate such as JBOSS, VLAN, IBM Tivoli, 2600 series Routerrsquos and switchesrsquo configurations, etc. to the undergraduates. This event was basically aimed to make the undergraduates capable and getting ready for the corporate easily, to know the things that is completely different from their syllabus and actually helpful for them to move ahead or getting selected in the corporate industry. I started this project in my tenure of HCL CDC MP, Nagar, Bhopal being a Public Relation Officer and then i took this project in HCL CDC Bittan Market, Bhopal as well being there as a Center Business Head.