Summary
Overview
Work History
Education
Skills
Projects
Languages
Personal Information
Certification
Languages
Websites
Timeline
Generic
VAIBHAV SHIVAJI PATIL

VAIBHAV SHIVAJI PATIL

Pune

Summary

Dynamic Associate Manager at SS&C GlobeOp Financial Services with expertise in SQL Server,SSRS,SSIS and strong leadership skills. Successfully created and optimized complex stored procedures and reports, enhancing enterprise analytical capabilities. Proven ability to multitask and collaborate effectively, driving project success and improving operational efficiency. Seasoned Application Support Engineer with significant experience in software troubleshooting, system updates, and user training. Possess strong technical skills coupled with a knack for problem-solving and customer service. Demonstrated ability to drive process improvements resulting in enhanced software performance. Committed to maintaining up-to-date IT skills through continuous learning and professional development courses.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Associate Manager (Application Support)

SS&C GlobeOp Financial Services Pvt.Ltd
Navi Mumbai
07.2022 - Current
  • Creating and maintaining jobs.
  • Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
  • Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.
  • Writing the stored procedures and user-defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.
  • Creating SQL server reports based on the requirements using SSRS 2017.

Database Developer

Inventurus Knowledge Solutions(IKS Health)
Navi Mumbai
02.2021 - 07.2022
  • Strong time management skills with ability to participate in multiple projects/work streams simultaneously as well as strong analytical/problem solving skills.
  • Solid technical proficiency with SQL Server with advanced knowledge of performance tuning.
  • Excellent organizational skills and ability to handle multiple tasks.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins to implement business rules.
  • Created parameterized reports using Report builder.
  • Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
  • Performed unit testing and path testing for application.
  • Created triggers for cascading update and delete operations to maintain data integrity.
  • Worked with ADO.NET objects to connect to the databases.
  • Used SSRS to create versatile reports and presentations for business groups.
  • Optimized query performance and populated test data.
  • Maintained the database using Procedures, Functions, and Triggers.
  • Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages.
  • Writing new stored procedures and modifying existing ones and tune them such as they perform well.

Sr.Software Engineer and Support Engineer

Rsmart Aviation Software Solution Pvt Ltd
Navi Mumbai
12.2018 - 05.2020
  • Communicated with the client to obtain an understanding of their environment, challenges, escalation processes and apply that information to support the smooth transition to the new help desk application.
  • Identified and escalated issues with the migration to ensure they were addressed and resolved.
  • Derived and tracked action items to ensure the project is completed on time and with minimal downtime to the client.
  • Resolved user tickets for front-end issues.
  • Hands on Experience with SQL queries. provide on call support.

Sr.Software Engineer

Landmark System and solution Pvt Ltd.
Navi Mumbai
11.2010 - 11.2018
  • Designs, develops and maintains a set of enterprise class web applications in ASP.NET technologies - both front end and back end (j Query, AJAX, ASP/HTML, CSS, C#, vb.net).
  • Reviews, analyzes, develops, and modifies applications.
  • Assist with root cause analysis to build long-term solutions.
  • Develop, maintain and support new mobile applications.
  • Analyzed complex queries tuned same optimize application system performance.

Education

MSc - Computer Science

Pune University
Pune
06.2009

BCS -

Dr.Patangrao Kadam Mahavidyalay Sangliwadi Sangli
Sangli
05.2007

HSC -

Mahatma Gandhi Mahavidyalay & Jr College
Savalaj
05.2004

SSC -

Adarsh Vidyamandir Vadgaon
Wadgaon
06.2002

Skills

  • Ability to Multitask
  • Leadership Skills
  • Communication Skills
  • Ability to Work in a Team
  • Ability to Work Under Pressure
  • Management Skills
  • ASPNET(C# and VBNET)
  • C
  • C
  • ASPNET MVC
  • Angular
  • XML
  • JSON
  • HTML
  • Oracle
  • Microsoft SQL Server
  • MySQL
  • SSRS
  • Crystal Report 10
  • DevExpress
  • JavaScript
  • Vbscript
  • JQuery
  • SQL Server Integration Services (SSIS)
  • SQL debug skills
  • Web development skills
  • AJAX
  • Web API
  • Batch job processing
  • Scheduling
  • Production support
  • Queries
  • Reports
  • Client ticket tracking system
  • Application-level issue resolution
  • Written and spoken English-language skills
  • Teamwork
  • Adaptability
  • Learning quickly
  • Implementing new procedures
  • Improving existing procedures
  • User support
  • Documentation
  • Complex Problem-solving
  • Client communication
  • Time management
  • Problem solving
  • Team collaboration

Projects

HR Module, Complete Builds Web based and mobile based HR Module using ASP.NET(C#,VB.NET),JavaScript, HTML, AJAX,WEB API. bootstrap. J query., Role Based User login (Corporate, User, Employee): Employee can access any data as per Role assigned to him/her., AD(Active Directory) Login: Here users are allowed to login into R smart with his system login for intranet users., File Digitization: Here we have created the central place where in user can upload the employee's documents and same can be downloaded by employee by logging into R smart and print. Documents are stored into database in binary format for security reasons., Dynamic Letter generation: Here, we have developed a program to generate certain letters like Offer letter, Appointment letters, Transfer Letters, Relieving Letters, Confirmation Letters dynamically using MS Word object., R smart E mailer: Emails are scheduled for various transactions events like intimation for Leave application by employee, Leave Authorization by manager, Leave Rejection by manager, Pay slip email to every employee after payroll done, Employee confirmation, etc., I Tax Projection and Computation: It exists, Income Tax calculation for every month with projection of income in financial year also Income Tax computation for tax refund or tax payable at the end of the financial year for form 16., Hire Craft integration for Offer module: Hire Craft integration for Offers module in R smart. Employee Offers are moved into R smart from application of client called Hire Craft and interchanged the employee data with its different status, also generated the required email intimations for Offer created, Office Items Indent for different departments., Web Services like Approval of Leave, Attendance and Reimbursement for Blackberry users: We did communication of client application and our application through Web Services for Leave approval, Attendance Exceptions and reimbursement transactions. These web services are called by client for Mobile applications on Blackberry phone., Employee Portal: Developed a Employee Portal, where in employee can view his dashboard for attendance calendar for month, today's attendance status, his pending approvals, Today's Birthdays, His favorite menus like attendance report, leave report, self attendance, His reporting hierarchy, Photos/videos shared by company, Notice board global or specific for department/location/division etc., Payroll Module improvements: Like consideration of Full and Final Settlements, Security and Training Deposits, Income Tax Calculations, PF and E SIC calculations, Arrears Calculations (With retrospective effects)., Office Asset Management: Office Asset Creation with asset location allocation, Office Asset Issue to employee and Receipt from employee, One time upload for Office Assets, Office Asset damage., 11/01/10, 11/01/18 RMS (Resource Management System), Designing, Coding and client Support, Client interaction to analyze the requirements RMS Project includes ground handlers with automated roster pattern. Daily and seasonal Flight handling, Shift Change. Manual Shift Upload., My Roster: Publish the staff roster on staff mobiles meaning they can check their duties, tasks and other alerts and updates. They are also alerted whenever there is change in their roster and duties and they are asked to confirm receipt. Staff is always up to the minute with roster changes and duty changes as management responds to a live and changing environment. User can upload shift data manual also., Request: Helps the staff to request for their permissible items such as shift preference, rest preferences, duty change or swap requests etc. Staff no longer have to find their manager and apply and await for maybe days for an answer and management have knowledge of what is granted what is declined and what is yet to be decided always secure in the knowledge that they are making leave decision based on factual awareness of the skill sets available if they grant a leave application., Approval: Managers have a quick access view to approve or reject the requests, wherever they are, on station or traveling even and with access to operational details they can make informed decisions quickly including for example overtime requests etc, all on the-go. A handy helpful tool for the managers, the team is just one-touch away., Flight Handling: We have imported Real Time as well as Seasonal flight data by taking data from FTP and S FTP. different airlines uses different format to provide data to us like SSIM, XML, Excel, .SIM. we have provided upload tool to import flight data. as per clients requirement we have 5 min, 15,min, 1 hours, and Mid night sink., Mobile Leave: Employee Can Apply Leave by using Mobile App. All the applied leave goes to RM for Approval. RM can Approve or Reject leave from anywhere by using his/her mobile phone once leave approved or Rejected notification will receive to Employee. Employee can check his/her leave balance., RsmartService: R smart Service called every 5,10,15,30,60 Min for Importing Employee data, leave, flight and leave balance data and will confirm feature dated employee status as confirmation, separation, joining etc., Importing Flight Data: Flight data imported by downloading file from Email attachment and from Google Drive and from FTP.

Languages

  • English
  • Hindi
  • Marathi

Personal Information

  • A/P. Vadgaon,Tal.Tasgaon,Dist.Sangli,Pin.416311,State.Maharashtra.
  • Date of Birth: 12/02/86
  • Nationality: Indian
  • Marital Status: Married

Certification

  • ASP.NET
  • APX
  • Geneva
  • Moxy

Languages

Marathi
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1

Timeline

Associate Manager (Application Support)

SS&C GlobeOp Financial Services Pvt.Ltd
07.2022 - Current

Database Developer

Inventurus Knowledge Solutions(IKS Health)
02.2021 - 07.2022

Sr.Software Engineer and Support Engineer

Rsmart Aviation Software Solution Pvt Ltd
12.2018 - 05.2020

Sr.Software Engineer

Landmark System and solution Pvt Ltd.
11.2010 - 11.2018

MSc - Computer Science

Pune University

BCS -

Dr.Patangrao Kadam Mahavidyalay Sangliwadi Sangli

HSC -

Mahatma Gandhi Mahavidyalay & Jr College

SSC -

Adarsh Vidyamandir Vadgaon
VAIBHAV SHIVAJI PATIL