rkikani

BE-IT with Over 4 Year 5 Month of Experience as DBA, SSIS, Reporting Service & SQL Developer Rakesh Kikani Mobile – 099798-75012 , BRIEF OVERVIEW § Expertise in working in Fast-paced, High-Tech Environments requiring skills in Scheduling, Management and Team building § Strong Technical, Administrative Exposure in various segments of Information Technology § Experience across functional area of Software and Automation § Track record of providing Excellent Customer Satisfaction and Management of workload § Core competency in MS SQL Server 2000 and 2005, SSIS, Reporting Service, VB, Windows Server, Visual Studio 2005 § Proficient in Client/Server Technology, Data warehousing, Software Engineering, System Administration, Database Administration, MIS, Application Programming PROFESSIONAL SUMMARY KNOWLEDGE OF Operating Systems : MS Win9x, Win 2k, Windows XP, Windows 2000 Server, Windows 2003 Server, Fedora Core Linux, UNIX RDBMS : MS SQL Server 7.0, MS SQL Server 2000, Oracle 8 and MSSQL Server 2005/2008, SSIS , SSRS Development Tools : Microsoft Visual Basic 6.0, Microsoft Visual Studio .Net 2005, Lotus Domino Designer R6. Report Development : Seagate Crystal Report 7.0,Seagate Crystal Report 12.0,MSSQL Report Tool Administration : Co-ordination with hardware vendors, network solution providers Design & : Radio Frequency & Bluetooth Transmitter Project for Barcode Implementation scanning and online data Transfer to the server. PROFESSIONAL EXPERIANCE Augure India– Database Analyst Integrator – From 1st August 2007 to Present Ø A France based company to provide service and Data related to Politician, Journalists, and Media of different countries. The Client of Augur is MICROSOFT, HSBC, Nestle etc and another International Luxurious Companies like Richmonde, Nissan, Hors Antenne. Ø Taking Training of Augure Application in Paris (France) from 30-Sep-2007 to 22-Oct-2007. Ø My Job responsibilities are to develop SSIS to integrate new content provider. Design and Create new database, develop Sp, Function, Triggers, Backup-Restore database of new content provider, Design and Develop Biography of Contact using MSSQL Reporting Service Projects: Factory: Factory System is designed for to integrate and enriched the clips received from different provider in to standard Augure Format. Development Platform : Visual Studio 2005 Team size : 6 Role : Database Design, Develope and Integrator BackOffice: Backoffice System is designed for to help the collection team to collect data from website in proper format. Development Platform : Visual Studio 2005 Team size : 4 Role : SQL Developer and Data Integrator Mandrake Mandrake System is designed for to generate automatic CSV from Database and deliver it to clients. Development Platform : Visual Studio 2005 Team size : 3 Role : SQL Developer and DTS Developer Content Provider Integration Content Provider Integration is designed to integrate different content provider in standard Augure format. Currently there are 4 different content providers for different countries. Development Platform : Visual Studio 2005 Team size : 1 Role : SQL Developer and DTS Developer and Report Developer Reliance InfoSolution Ltd. , Posting at IPCL, Silvassa (Aug 2005 – July 2007): Ø A Member Company of India’s largest private sector company Reliance Industries Limited & in the elite group of fortune 500 companies. The existing setup at Silvassa location is the second largest setup in the world in terms of Machinery, Volume and Production capacity in the field of Texturising Manufacturing Sr. DBA (MS SQL Server) And Sr Software Developer Work Profile: Administration of SQL Server v Data Base Designing : • Responsible for handling the Data Base Designing, Data schema, Tables, Rules, Constraints, Defaults and Views. • Accountable for the Creation of Stored Procedures, Triggers and Cursors. v Security • Creation of SQL authentication user list for Mixed Security Mode/ NT user list for NT Authentication Security Mode. • Creation of and mapping of NT user group to SQL server / Database Roles. • Assigning Server level Privilege to Respective Application User / Project Groups. v Monitoring • Monitoring of Server Performance through SQL Performance Monitor. • Monitoring of Disk Space for SQL 7.0, SQL 2000 Servers. v Backup / Restoration • Complete Database Backup, Differential Backup for Database according to Different Application Requirement. • Scheduling the Backup of Transaction Logs. • Complete Responsibility of Restoring the Database at Critical Time Zone v Schedule Jobs & Alerts • Scheduling of Jobs (Stored procedures) & Alerts notification via SQL server agent and SQL Mail. v Tuning • Index Tunning through Index Tuning Wizard. v Data Transformation Services • Creation and Scheduling of DTS Packages, SQL scripts for application working on Heterogeneous Data Environment. v Implementation of Replication Services • Various Replication ( Snap Shot ,Push, Pull ) are Implemented as per the requirement of different applications v Data Warehousing • Data warehousing For Decision Support Systems - MIS Report System. Projects: Bobbin Tracking System Bobbin Tracking System has been designed to have a complete online tracking of Texturising Machine production (in terms of yarn bobbins) which is approx. 65,000 in nos. per day. The software ensures the flow of product property information from the machine to packing area to avoid the mixing and production loss. The same has been achieved by scanning of barcode sticker at various checkpoint stations. Development Platform : VB 6.0, MS SQL Server 7.0 Team size : 5 Role : SQL Developer, VB Developer Quality Management System Quality Management System has been designed to have a complete Quality Information about POY (Partially Oriented Yarn), PTY (Polyester Texturising Yarn) like Denier, Filaments, Ply, and Shrinkage etc. As well as it also contains Information about Yarn Testing Results. Development Platform : VB 6.0, MS SQL Server 7.0 Team size : 3 Role : SQL Developer, VB Developer Machine History System Machine History System has been designed to have a complete Machine Information such as which type of Belt is used in Machine, Machine Speed, Pulley Diameter, Pressure, Air, Doff time, Coning Oil etc. Also it contains history of batches that were run on the Machine and Information of all Batches. Development Platform : VB 6.0, MS SQL Server 2000 Team size : 4 Role : SQL Developer, VB Developer Rejection Management System Rejection Management System has been designed to have a complete information about Rejected Material which are Rejected when produced and there are some problem because of Machine Electrical Breakdown or Mechanical Breakdown or not matches some Standard Quality Criteria Development Platform : VB 6.0, MS SQL Server 2000 Team size : 2 Role : Project Leader, SQL Developer,VB Developer Management Information System Management Information System has been designed to have complete information about Machine, Raw Material Quality, Complete Product Quality, Machine Utilization, Total Production Loss, Total Production etc. So it contains all information related to Managerial Reporting. Development Platform : VB 6.0, MS SQL Server 2000 Team size : 3 Role : Project Leader, SQL Developer,VB Developer IT-Help Desk This project was developed to help the IPCL Users to face their daily problems regarding computers hardware and software. Development Platform : Lotus Notes Domino Designer R6. Team size : 1 Role : Desiging and Developing(coding) the System Pulley Changeover System Pulley Changeover System has been designed to have complete information about Pulley Change on Different Machine. It displayed which pulley should be used for Machine according to the Batch change on the Machine. Development Platform : Visual Studio .Net 2005 Enterprise Edition Team size : 1 Role : DBA,VB.Net Developer,SQL Developer EXTRA CURRICULAR ACTIVITIES 1. Project on “Mark sheet Generation” using VISUAL BASIC and back end Oracle. 2. Project on “Gujarati Linux” translate Fedora Core Linux environment in to Gujarati language environment in Technical Festival 2005 in SVMIT College. 3. Project on “Job Distribution in Linux” using C in Technology Festival in Fedora Core Linux. 4. Seminar of Final Year on “Digital Image Processing” 5. Project on “Share Market Management” using ASP as front-end and Oracle as back-end. ( Final Year Project) 6. Get First prize in Treasure Hunt Competition in TechFest-2004 in SVMIT College. EDUCATION Year Qualification University/Board 2005 B.E- I.T VNSGU,SUARAT ACHIEVEMENTS (CERTIFICATION) v MCP (Microsoft Certified Professional) /MCDBA(Microsoft Certified Database Administrator) • 70-228( Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition) • 70-229(Designing and Implementing Database With Microsoft SQL Server 2000 Enterprise Edition ) • 70-306(Developing Windows-based Applications with Microsoft Visual Basic .NET) • 70-290(Managing and Maintaining a Microsoft Windows Server 2003 Environment) [login to view URL] Transcript ID(748603) Access Code(09091983) STRENGTHS • Achievement & result oriented with excellent communication, presentation & interpersonal skills. • An optimist individual with proven strength in problem solving, co-ordination and analysis. • A good team player with ability to lead a team by example and motivate them to achieve desired objectives. • An aggressive individual with a progressive attitude & aspiration to win against all odds. PERSONAL DETAILS Date of Birth : 09th Sep 1983. Languages Known : English, Hindi, and Gujarati Interests and Activities : Sports, Traveling, Reading Magazines and Books Trouble Shooting. Current CTC : 6.45 Lac per annum Expected CTC : Negotiable Notice Period : 30 Days Nationality : INDIAN Passport No : G0141719 valid up to Dec-2016 REFERENCE Available on Request Regards, Rakesh Kikani Mobile - 099798-75012