Vijay Vasant Vichare
(B.Com+PG[IT])
Nalasopara,West
Summary
Seeking a challenging position in a good and rapidly expanding company to work in team environment that would expose me to the latest developments in the field of IT and widen the spectrum of my knowledge and skills along with having good learning capabilities on new tools. 10+years of experience in VBA Automation reports & backend MS Access, SQL 2K,2K5,2K8 MIS reporting. Dashboard creations in Tableau desktop and public, PowerBI, Data analysis and presentation. Worked on user interface development & generation reports through SQL reporting tool. Backend database troubleshooting activity, HTML web page desiging.
Overview
17
17
years of professional experience
5
5
years of post-secondary education
1
1
Language
Work History
Manager (IC) Role
Ugam Solutions Pvt Ltd
Goregaon, Mumbai, Maharashtra
05.2020 - Current
- Sample cleaning for various projects by using client sampling tool like BASE SAS 9.4, SSIS (ETL tool), Sampling 2.5 etc
- With backend troubleshooting with MS-SQL
- Understand the requirements from client on reports and Automate the reports on click and view basis by using skill of VBA, advance Excel, SAS macro, SQL
- Data analysis reports and dashboard creation using Tableau Public and desktop, PowerBI tool
- Knowledge of R-studio and python framework
- Sample data management for various projects
- Start to end process of Email deployment system for various projects by using HTML coding for preparing email templates according to client requirements
- Daily, Weekly, Monthly reports creation and presentation of team performance along with their project progress in graphical way with valid comments, meetings etc. etc.
Assistant Manager
SBI General Insurance Ltd
Mumbai
11.2014 - 04.2020
- Understand the requirements from stakeholder on reports and Automate the reports and dashboard on click and view basis by using skill of VBA, advance Excel, SAS EG, SAS VA, Oracle BI
- Follow up for data from Datawarehouse team
- Analysis on various area like Sales & marketing, Branch Performance, Call centers records, Autodebit analysis, Health policies data analysis etc. etc.
- Data analysis reports and dashboard creation using migration tool of Tableau Public and desktop
- Training on VBA to team members
- Development of claims tracking system automation in MS-Access and Access macro for Crop Insurance department
- Collation of huge data in oracle sql developer and maintain database, Querying, building reports in excel through macro with db connection of Oracle / MSAccess database
- Creating macros to build up the vendor payement form, payment request for, bank service charges request form in Word and PDF format and mailing it to respective banks or vendor automatically through VBA coding.
Sr. MI Developer
WILLIS UK Processing India PVt. Ltd
Vikhroli, Mumbai
07.2011 - 10.2014
- Analyses of data & like overall daily/weekly/monthly/MIS reports report accordingly & automate them by using Excel, VBA (Macro), SQL
- Prepare various reports need by top management by using SSRS
- Make DTS packages of required process which is a daily manual work
- Deliver reports/data within deadline i.e
- On daily/weekly/monthly/quarterly basis
- Trouble shooting with complicated queries by using MS-SQL2K/2K5/2K8
- Create/alter/drop or delete/update/insert table query, create/alter Store Procedure or Triggers, Joins, views, indexing, Schedule jobs, Automate mailer etc
- Handling all client related queries, Quality data, monthly appraisal data, Backup of database
- Conducted training on VBA, Excel or any expertise for the team members & other team.
Ugam Solutions
Mumbai
07.2007 - 02.2011
- Market Research & Analytic organization, Form reports trough user interface development & generates reports by using SQL reports
- Interaction & development for ERP/ERM Reports
- Generate reports from MR Studio script & verify the same for all over projects
- Analyses of data & like overall daily/weekly/monthly/MIS reports report accordingly & automate them by using Excel, Macro, SQL
- Trouble shooting with complicated queries by using MS-SQL2K/2K5/2K8
- Create/alter/drop or delete/update/insert table query, create/alter Store Procedure or Triggers, Joins, views, index, Schedule jobs, Automate mailer etc
- Handling all client related queries, Quality data, monthly appraisal data, Backup of database,
- Assign roles to users, upload samples
- Knowledge of Designing and Creating database models, Data Transfer through DTS
- Databases Maintenance using DBCC Tools, Backup & restore of Database
- Zenta, Hiranandani, Powai, Mumbai : Business Process Outsourcing organisation
Sr. MIS Executive
Zenta Pvt. Ltd.
Mumbai, Maharashtra
06.2006 - 07.2007
- Generate reports from front end & verify the same for all over 6 projects
- Trouble shooting queries by using MS-SQL2000/2005
- Data search by using Toad
- Create/alter/drop or delete/update/insert table query, create/alter Store Procedure or Triggers, Joins, views, index etc
- Handling all client related queries, Backup of database
- Knowledge of Designing and Creating database models, Data Transfer through DTS
- Databases Maintenance using DBCC Tools, Backup & restore of Database
S/W support engg
Colgate Palmolive (I) Pvt. Ltd
11.2005 - 05.2006
- Install the software provided by company, make the registry setting
- Configuration setting etc
- Installation of Palmtops
- Trouble shooting queries by using MS-SQL, Sybase SQL
- Create/alter/drop or delete/update/insert table query, create/alter Store Procedure or Triggers, joins, Views, index etc
- Make batch file, scheme, invoice changes etc
- Backup of database, restore backup, dump & load process
- Upload & download of data, verify or check that data etc
- Etc.
Data Analyst cum Admin Assistance
SPJIMR, Research Institute
Mumbai
10.2004 - 11.2005
- Export the admission data from MS-SQL to Excel
- Handle the admission data in Excel & make the analysis & Automate reports
- Handle the workload report of all the faculties, collate them & give the monthly summary & cumulative report
- Check the mails, handle the queries
- Search the information from internet
- Other academic kind of work like grading of marks, handle other software kind of program etc.
Contractor of S/W, Database Support
Ambika Software
Mumbai
06.2002 - 10.2002
- Checking the data of all chemical products & print the reports
- Trouble shoot queries in MS-SQL & prepare reports as per requirement
- Convert that data into PDF (Acrobat) files
- Convert that PDF files into notepad files etc
- Etc.
Education
B. Com. - Accounting And Finance
Mumbai University
Mumbai 06.1998 - 05.2000
PG (IT) - Information Technology
NIIT Ltd.
Mumbai 04.2002 - 09.2005
Skills
VBA Automation reports & backend MS Access, SQL 2K,2K5,2K8 MIS reporting Dashboard creations in Tableau desktop and public, Data analysis and presentation Worked on user interface development & generation reports through SQL reporting tool Backend database troubleshooting activity
LinkedIn and Coursera certification of Tableau dashboard creation and story telling, PowerBI
Various SAS Certificates completed via LinkedIn (SAS 94 Cert Prep : 01 to 14)
SAS Visual Analytics Trained by SAS center Bandra Exam scrore (65/100)
SAS EG training from SAS center Churchgate
Took training of SQL server 2008 conducted by HCL Technology
Took Oracle DBA training from SQL STAR INTERNATIONAL LTD
Knowledge of Tableau, Python, R studio, Power BI
Additional Information
- Microsoft Certified Professional (MCP) in SQL-Sever 2000
- Exam Number : 070-229
- Date of Exam : October15, 2005
- Score in Exam : 977 out of 1000
- NIIT National IT Aptitude Test [NITAT] 2005 certificate.
- [ Out of 36955 candidates who took the National IT Aptitude Test 2005, scored among the Top 30%(70 Percentile) ]
- [ Date of Issue -: 30th June 2005 ]
Accomplishments
- Value Award for FY 2019-20 for High performance in SBI general insurance limited (Felicitation in Thailand)
- Value Award for FY 2014-15 for High performance in SBI general Insurance limited.
- Awarded as Ideal team member of the month in Willis UK Processing India Pvt. Ltd.
Timeline
Manager (IC) Role
Ugam Solutions Pvt Ltd
05.2020 - Current
Assistant Manager
SBI General Insurance Ltd
11.2014 - 04.2020
Sr. MI Developer
WILLIS UK Processing India PVt. Ltd
07.2011 - 10.2014
Ugam Solutions
07.2007 - 02.2011
Sr. MIS Executive
Zenta Pvt. Ltd.
06.2006 - 07.2007
S/W support engg
Colgate Palmolive (I) Pvt. Ltd
11.2005 - 05.2006
Data Analyst cum Admin Assistance
SPJIMR, Research Institute
10.2004 - 11.2005
Contractor of S/W, Database Support
Ambika Software
06.2002 - 10.2002
PG (IT) - Information Technology
NIIT Ltd.
04.2002 - 09.2005
B. Com. - Accounting And Finance
Mumbai University
06.1998 - 05.2000
Personal Information
Strengths :
· Very committed to my work.
· Organized.
· I have good grasping power.
· Willingness to learn something new.
· I like to interact with peoples & work with team.
· Hard working.
Interest :
Playing chess, carom, volley ball, Drawing cartoons, Greetings, Writing poems, Watching TV mostly Entertainment, Animal planet & National
Geography etc. etc.
Personal Information
Strengths :
· Very committed to my work.
· Organized.
· I have good grasping power.
· Willingness to learn something new.
· I like to interact with peoples & work with team.
· Hard working.
Interest :
Playing chess, carom, volley ball, Drawing cartoons, Greetings, Writing poems, Watching TV mostly Entertainment, Animal planet & National
Geography etc. etc.