Pratibha Shetty

Pratibha Shetty Contact No:-- Objective: To achieve a challenging position in a professional organization, where I can enhance my skill and strength in conjunction with the organization’s goal. Working experience 14+ year, of experience in the SQL Server 2000/2005/2008/2012/2016 (SQL Developer),SSIS/SSRS/Power BI/SAS/OneKey/Tableau, able to handle any Business Intelligence Tools. Education:  10th from Maharashtra Board with 72% in year 2003  12th from Maharashtra Board with 66% in year 2005  BSC.IT From Mumbai University with 60% in year 2008  MBA-IT From Mumbai University with 65% in year 2011 Major Strengths: SQL Server (2016,2012,2008 ,2005 and 2000), Crystal Report (11,10,8.0),Crystal Report with Asp.Net ,SQL BI (SSIS and SSRS). Performance tuning & Optimization of RDBMS Database / Application / Server, including complex query optimization. Analyzed Execution Plans to troubleshoot potential performance issues Computer Proficiency: RDBMS : Programming Languages Operation Systems Networking Reporting Tool : : : : SQL Server (2000/2005/2008/2012/2016), ORACLE 9i,Sybase,DB2,NOSQL VB, HTML,DHTML, Xml. Windows 9x, Windows 2000. Knowledge of Networking. Crystal Report XI , One Key Agile (Reporting Tools),IZENDA, Tableau etc.. Project Details: Project 1: Site Onrole Tools Used Team Members Role Duration CLIENT-NBFC : CMS : Sql server 2005/2008/2012/2016,Oracle 10g, BO XI, One Key ,SAS , POWER BI :6 : Project Manager - IT : From Aug 2019 To till Date Role:  Working on SQL 2000/2005/2008/2012/2016, NoSQL (Mongo DB),SAP R3 DB, Oracle , MAIA,SAS , POWER BI etc.. (Various Reporting Tools).  Handing Vendors for Various Projects.  Implemented Various Automation Process NBFC  Performance tuning & Optimization of - RDBMS Database / Application / Server, including complex query optimization.     SFDC (Salesforce) - Reporting & Dashboard Implementation SFDC Implementer AWS Cloud Automation – Bulk Download including Security rights Seamless Integration with Multiple Systems - ( OLAP / SMS / EMAIL / Whatsapp / AWS Cloud) Project 2: Site Tools Used Team Members Role Duration : NBFC : Sql server 2000/2005/2008/2012/2016,Oracle 10g, BO XI, One Key , SAS , POWER BI :6 : Team Leader (BI – Business Intelligence) : From Dec 2016 To Jul 2018 Role: Working on SQL 2000/2005/2008/2012/2016, DB2,Sybase,NoSQL (Mongo DB),SAP R3 DB, Oracle , MAIA , BOXI ,SAS , POWER BI etc.. (Various Reporting Tools) as a Team Leader, Developer, BA (Project Coordinator) Implemented Various Automation Process For NBFC, Commercial Finance, Credit & Collection Team. Performance tuning & Optimization of RDBMS Database / Application / Server, including complex query optimization. Project 3: Onrole Tools Used : SOFTWARE COMPANY( IT Service). : Sql server 2000/2005/2008/2012,Oracle 10g, BO XI, One Key , Tableau :8 : Team Leader (BI – Business Intelligence) : From 1st March 2013 To Dec 2016 Team Members Role Duration Description a Service Based Company, Deal in BI,CRM and ERP. Role: Working on SQL 2000/2005/2008/2012/2016, DB2,Sybase,NoSQL (Mongo DB),SAP R3 DB, Oracle , MAIA , Tableau, Izenda, BOXI ,SAS , POWER BI etc.. (Various Reporting Tools) as a Team Leader, Developer, BA (Project Coordinator) Performance tuning & Optimization of RDBMS Database / Application / Server, including complex query optimization. Implemented Various Automation Process. Max Data Size Handled: 900 GB+ (SQL) Data approx. Project 4: Site Tools Used Team Members : Banking and Financial services : Sql server (2000 & 2005), Crystal Report 11,VB.Net 2005 :4 Role Duration : Assistant Manager : From 18 August 2010 To 29 Feb 2013 Description this company Basically Involve in Share Markets. Role: 1: Handling Database & Support Team (Application : SAGE CRM, OneKey(Reporting Tools), FOLKLORE(Core HR Application) , E-HIRE (HR Recruitment Software) SOLUS,Zicom (Attendance System) OmniFlow (Internal Approval Application) Knowledge Sync (Automatic Sending Mail Server) ) 2: Continuous Vendor Interaction for Implementing Application & Changes with TAT. 3 : Internal User Co-ordination , from support point of view & Enhancement Point of View 4: Handling ,Application & Database Server , Implemented Various Automation Process. 5: as a Developer, Working on T-SQL ( Creating Stored Procedure, Views, trigger, functions ,DTS,Jobs, working on Performance Tuning, Code optimization),SSIS,SSRS and efficiently deploy SSIS Package for Database Maintenance Task. Project 5: Site Tools Used Team Members Role Duration : 4004 Incorporated ( Unisource Group ) : Sql server 2005, Crystal Report 11 :5 : SQL Developer/Crystal Report Writer : From 18 June 2009 To 5th August 2010 Description : 4004 Incorporated is a Retailing Company (MNC), Role: Working on T-SQL ( Creating Stored Procedure, Views, trigger, functions ,DTS),Designing Database and also Developing Various type of Report (like: Merchandising report, Sales Report,Inventory Report ,Weekly and Daily report) using Crystal Report XI) Project 6 Client Site Tools Used Team Members Role Duration : AMW(ADVERTISER MANAGEMENT WORK FLOW : Parle Product ( Pvt.) Ltd. : Mediaware InfoTech (Pvt ) Ltd. : ORACLE 9i, ASP.Net ,SQL Server 2000 :3 : Back End Programmer/Technical Support : From June 2008 To 15 June 2009 Description : It is controlling the budget of advertiser and it provides monitor the spot, which appear in TV, channel &radio stations. it automate all dealing of advertiser Role: Working on T-SQL ( Creating Stored Procedure, Views, trigger, functions ,DTS) , and Providing Technical Support of SQL Server 2000/Oracle 9i/Asp.Net Project 7 : RadixInfosolution. Tools used Team Members Role Duration : ASP.NET , Sql Server 2000 :5 : Site Maintenance. : 4 months Description: Radix Info Solution mainly working in Website Development of Educational Institute. Project 8 Tools used Team Members Role Duration : Xpert Media. : VB 6.0, SQL Server 2000, Crystal Report 8.0 :3 : Design & Development & Data Analyst. : September 2008 to January 2009. Description: This system is basically a product beneficial for the Ad. Agencies, a complete ERP package, which work as a mediator between the clients like the Maruti, Pepsi etc. and the publication such as TOI, HT etc. The Ad. Agencies can very easily make an estimate in specific region, city or in a certain language as per the client need and under the plan limit. Large amount of data about the publication’s ad. Rate, language, circulation, edition, size, insertion, position, category all like these are provided with this software on the basis of which Ad. Agencies can be able to plan and estimate of any area in all over India. Campaign, Estimate, Release Order, Invoicing, Accounting package including Profit & Loss, Balance Sheet, CRM, Inventory are the modules of this application. Personal Details DOB : 6th August 1987 Marital Status : Married My Strengths : Ability to take full responsibility of the Task assigned to me. Zeal to learn new things fast. Date: Place: (Pratibha Shetty)