Bharat Warkar

Bharat Uttam Warkar Sai Shrishti ,Plot No 11 servey No 582/583 Pantnagar Gali no 1, Jadhawwadi, Chikhli Pimpri Chinchwad, Pune 412114 -/- –-Summary Technical Support Engineer with Total 5+ years in IT infrastructure . Planning, Deployment, Management and maintenance Local Area. Sr. Technical Support Engineer (SQL) with Aforeserve.Ltd Sr. Technical Support Engineer, with Bombay Vintage Pvt Ltd. Skills Proven proficiency at Data Transformations like Derive Column, Conditional Split, Aggregate, Union all, Merge join, Lookup, Sort & Execute SQL Task to load data into Data Warehouse. Ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints Supporting users as needed. Responsible for installation, configuration & troubleshooting. Professional Course Linux Basic. Microsoft certification in Active directory (70-640). Diploma in Basic Computer & Application. Advance diploma course in Hardware & Networking. MS-CIT Experience Bombay Vintage pvt.ltd Sr. Technical Support Engineer, May 28th 2019 -15th March 2020. SQL Development: Ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints). Interacting with clients for requirement gathering, system analysis, documenting, tracking, communicating bugs, performance analysis and resolving problems, provide training. Set the process flow as per client requirement. Documenting all the configuration settings for new/existing servers, troubleshooting steps for common issues and other day to day activities for easy reference. Responsible for Database support, troubleshooting, planning and migration. Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention using SQL Profiler. Aforeserve.com.Ltd (HP india ltd) Sr. Technical Support Engineer, January 2017- 10th March 2019 Table creation, Adding Foreign & Primary Keys, writing various DDL and DML commands. Rebuilding the indexes at regular intervals for better performance. Monitored and modified Performance using execution plans and Index tuning. Interact with report owners to establish/clarify their requirements and develop report specifications. Resolve end user reporting problems through collaboration with IT and Operations. Project Description: Basically this system is the combination of various modules this portal designed for the collection of the all business data and transactions of customer / Agents business from all branches of company. For generations of the MIS Reports for based on the daily transactions. To maintain the employee data for this organization, to handle issues from each branch. Responsibilities: Table creation, writing various DDL and DML commands. Monitored and modified Performance using execution plans and Index tuning. Work with all levels of development from analysis through implementation and support. Interact with report owners to establish/clarify their requirements and develop report specifications. Resolve end user reporting problems through collaboration with IT and Operations. Designed and developed the SSIS Packages. Created SSIS packages with OLEDB Source, flat file source, Excel source and used multiple transformations to load data on SQL server. Generated multiple Enterprise reports using SSRS such as drilldowns, drill through and sub-reports. Education Interest Traveling, Photography, Tech-savvy. Affiliations Working as a Core IT Operations team Personal Information Name:  Mr. Bharat U. Warkar Date of Birth:  14th May 1989. Languages         :  English, Hindi, Marathi. Date: Yours truly, Place: (Bharat U. Warkar)