![Resume_Atlanta_Wesley11_25_2014_1_1[1]](https://cdn.slidesharecdn.com/ss_thumbnails/e66bbcc9-5a8c-439a-8281-3e4d7fe09f88-160125215424-thumbnail.jpg?width=560&fit=bounds)
More Related Content
Viewers also liked (12)
Similar to RESUME_Bharat_Sethi_4_MS_SQL (20)
RESUME_Bharat_Sethi_4_MS_SQL
- 1. R E S U M E Bharat Sethi Contact No.: - +91-99304-45601 Email: - bsethi24@gmail.com Objective: - A Challenging and fulfilling career with the fast growing Organization & to endure myself with the organization expectations & beyond by making best efforts for it. Ex p e r i e n ce S u m ma r y IT MS-SQL Development MS-SQL Administration Team Lead 8 Years 9 Months 7.6+ Years 3.2+ Years 1+ Years Skills: - S. No. Category Particulars 1. Operating Systems MS-DOS, Windows 2008, 7, 2003, 2000, XP 2. RDBMS/DBMS MS SQL Server 2008, 2005, 2000, MS Access, Windows FoxPro I 3. SQL Tools Microsoft SQL Server Management Studio (MSSMS), Microsoft SQL Server Debugger, Query Analyzer, Enterprise Manager, SQL Server Profiler, SQL Server Agent (Jobs scheduling), SSIS, DTS etc. 4. Workload Automation BMC Control-M, Ms-Dos command scripting 5. Languages / Scripting T-SQL (Stored Procedures, Functions, Triggers, etc.), VB 6.0, C, FoxPro I 6. Source Control Mgmt. IBM Rational Team Concert (RTC) 7. Web Server Application Internet Information Services 6.0 for HTTP & FTP services. 8. Packages MS-Office XP, 2010, 2007 9. Computer Basics IBM Lotus Notes, IBM SameTime, MS Outlook, MS Lync, Web Designing in HTML & Ms- Front Page etc. Education & Qualification: - S. No. Examinations / Course Name Year of Passing Percentage University 1. B. Com With Computer 2003-2004 57 % (Aggregate) DAVV 1 of 4 RESUME_Bharat_Sethi
- 2. Organizational Experiences: - I. HSBC Software Development (I) Pvt. Ltd, Pune: December 2014 to Till Date Designation : Senior Software Engineer RESPONSIBILITIES: - 1. Managing BAU team and activities as a Senior member of team, 2. Coordinate Production releases & their Pre-Post activities, 3. MS-SQL 2008 Databases and SSIS Development, Performance improvement, 4. Processes Automation, 5. Batch processing through Control-M II. Marlabs Software (P) Ltd: February 2013 to December 2014 (Client: - HSBC) Designation : Tech. Lead- DBA Marlabs Software is a CMMI Level 3 company and founded in 1996 with headquarters in Piscataway, New Jersey (USA). I am working onsite with client HSBC Software Development (India) Limited (HSDI), PUNE. Web: http://www.marlabs.com RESPONSIBILITIES: - 1. Managing Production releases & their Pre-Post activities, 2. MS-SQL 2008 Databases and SSIS Development, Performance improvement, 3. Member of BAU Third Line team, 4. Processes Automation, 5. Batch processing through Control-M III. Zee Learn Limited (Essel group) HQ, MUMBAI: October 2011 to October 2012 Designation : Database Manager Zee Learn Limited is the Education arm of Essel group. Zee Learn has various MIS Systems with back-end of MS-SQL 2008 to manage their different-different businesses. Web: http://www.ZeeLearn.com RESPONSIBILITIES: - 1. Administration & Development of MS-SQL 2008 Databases, 2. Database servers, backup server administration, 3. Back-end working through MS-SQL 2008 to fulfill the requirements and to solve the issues raised by Centres & HQ, 4. MIS Generation through MS-SQL 2008 as per Management & Centres requirements like Dashboard reports, ageing reports etc. 5. SQL Server Agent used to automate various SQL processes like Log-Shipping, Backup- Restored of Production DBs, Servers Connectivity checking, MIS Auto mails with & without Attachment, Enquiries Auto-Responder mails etc. 6. Write MS-DOS command scripts (Batch programs) to automate the processes etc. 2 of 4 RESUME_Bharat_Sethi
- 3. IV. PT education HQ, INDORE: January 2006 to October 2011 Designation : Senior S/w IT Executive (MS-SQL Database Developer) PT education is an Educational Institution, which has Centers across India to provide Best Education for MBA Entrance, MCA and English as well as for Abroad Studies. PT education has an ERP solution with back-end of MS-SQL 2005 to manage Centre & Head Quarters level working. Till April-2007, it was Desktop based solution & from May-2007 onwards it's Online Web environment solution. RESPONSIBILITIES: - 1. Managing dedicated Web Servers, Online ERP Software & its all Centres Consolidate MS-SQL 2005 Database & other MS-SQL Databases, 2. Writing SQL Store Procedures, Views, Functions, Triggers to fulfill the Management requirements & for Annual Strategic Meetings with Centres, 3. Optimizing existing SQL Objects to improve performance, 4. Automation of MS-SQL data requirements between different servers, 5. Support to Centers & HQ for this ERP solution, Project Experiences: - I. PT education HQ, INDORE - 1. Migration of PTPRABANDHAN ERP solution from DESKTOP to Online WEB environment. RESPONSIBILITIES DURING THIS PROJECT: - i. Co-ordination between teammates & Software team to understand various modules of Desktop based ERP & to prepare the detailed documents of the requirements ii. Testing of WEB ERP solution iii. Support to Software Team in Database design iv. Data migration from MS-SQL 2000 to 2005 (It's not only IMPORT - EXPORT process through DTS as New DB has many changes in its structure). In this migration PT education team strength was 2 - Mr. Animesh Upadhyay (IT Head) & Me 2. Migration of Web ERP solution from one Web Server to another Web Server (Windows 2003 with IIS 6.0), 3. Managing Web Server independently etc. 4. With the help of MS-SQL, build the process to get Image and/or any format file from Web Server to local system or vice versa without using FTP and/or without Enabling MS-SQL XP_CMDSHELL etc. 3 of 4 RESUME_Bharat_Sethi
- 4. II. Zee Learn Limited HQ, Mumbai (Maharashtra) 1. Production DBs log backups from Production to Backup server Implemented automated process of logs backup-restore from Production to Backup server, 2. Many new reports generated with Auto Mailing system to improve the MIS & help the organization to take the right decisions on right time like "TAT reports for Indents", "Fees Ageing reports", "Auto Responder mails to Enquiries", "Daily basis Zone wise Enquiries mails to responsible persons" etc., 3. Auto-Escalation process designed & implemented for Helpdesk module. So, if raised Issue not responded at current level in given time duration, will automatically escalate to next level. 4. Single Sign On (SSO) Zee Learn has more than 5 WEB Applications with separate logins. To automate logins into Permitted applications through Intranet, implemented SSO process. Complete working done through back-end with one extra login page designed by developers. 5. Inventory Management To manage the Templates (set of Products) Inventory without affecting current system, designed back-end logic to fulfill requirement. This module working done by 3 members I. HOD & 1 Developer HOD to understand the current system & Developer who Designed UI to enter Templates Inward/Outward entries at Dispatch locations & II. Me - Designed back-end logic to incorporate this process in daily dispatches (Indenting) system. 6. City Master & all related tables City sync. & removal of Duplicate, Wrong entries City master is there since the MIS development started, but, with lots of Duplicates & Wrong entries. Not to say that it is not an easy task to organize Master tables which is in use since more than 2 years. To achieve the same huge manual working is required. But, to minimize it, design some SPs to Find & replace complete DB for specified Numeric and Character values. Personal Information:- Date of Birth : - 24th March, 1984 Sex : - Male Marital Status : - Married Nationality : - Indian Languages Known : - Hindi, English Present Address : - Flat No. 203, IInd Floor, Chandan Shilp Apartment, Road No. 13-E, Tingre Nagar, PUNE (Maharashtra) - 411032 Date: -16-December-2015 Place: PUNE Bharat Sethi 4 of 4 RESUME_Bharat_Sethi