Candidate Name
Email: cadidateEmail@[Link] Mobile: +91- 9000040001
PROFESSIONAL OBJECTIVE:
Looking for a challenging assignment in Enterprise application development to effectively utilize my
abilities, expertise and collaborate with the team to build the best possible solution.
Work Summary: -
[Link] Organization Designation Duration Location
1 Microsoft Ltd Trainee July 2016 - July 2017 Mumbai
2 Google Manager Aug 2017 – Till Date USA
Skills: -
Database MS SQL Server 2008 & above , MySQL, Mongodb
SQL Server SQL Server Management Studio, SSIS.
Reporting SSRS, Tibco Jaspersoft studio.
Tools
Tools and Ms Visual Studio 2012 , Ms Office, CMD, PostMan, Visual Studio Code
Utilities
Experience Summary: -
4+ years of experience in HRP Product Development & implementation across various
sectors like
(Retail, Hotels, Automobile Industry, Financial Services, Media, BPO and Logistics).
Implementation of Ramco HRMS Software for a Leading BPO with 30K+ [Link] in a period
of 1
year in lieu of SAP Success Factors.
Product Upgrade for the Automobile Giant TAFE & TMTL Motors Ltd by replicating the SAP
Features & complex logics builded on ABAP to SQL.
Extensive experience in Query writing, tuning complex sub-queries and stored procedures.
Creating MIS reports based on the business requirements.
Maintaining database, maintenance roles and safeguards (Procedures, Scripts, function,
etc.,) to
increase performance.
Designing & developing SSIS packages to import/export data from MS Excel, Flat Files, SQL
Server & manipulation of data based on the Business needs.
Using SQL profiler to debug Transact-SQL statements and stored procedures, Monitor the
performance of an instance of the SQL Server Database Engine.
Fixing Bugs/defect in Software after Major Release and updating them as a consolidated
Post-fix.
Very Adept in Human Resource Management System (HRMS) domain.
HCM (Hire - Retire)
Clients : Conneqt Business Support Solutions (Quess), TAFE & TMTL Motors Ltd,ITC Hotels,
Landmark Group, DTDC, Qube Cinemas Inc.
Technology : RVW , SQL Server 2008/2012.
Tools : Dcube Reports, Crystal Reports, DW Reports, SSIS & SSRS.
Module : HR Induction, Payroll, Leave management, Time & Attendance, Travel &
Reimbursement, Performance Management System.
Description:
Ramco HCM is a global talent management application that has been designed to facilitate a
changing
work environment. Its flexible architecture is designed to handle proliferating employment,
measurement, and wage models, and it provides an integrated HR services experience. Beyond its
ability to address the needs of multiple industry verticals, the product differentiates itself and
Simplify HR strategy by automating traditional HR transactions and driving business benefits across
functions.
Key Role as a Developer:
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Redesigned the data
• Development of Pay-element rules based on business requirements.
• Making structural changes to the databases when design changes are to be implemented
• Client interactions for problem resolution.
• Database administration tasks in SQL server 2008 such as Creation of Backup schedules, SQL
profiler, Attaching and detaching the databases, Backup and Restoring the Databases.
• Creation of Re-usable Scripts & other SQL related jobs for minimizing human intervention.
• Re-creation of Automated scripts based on the business demands.
• Implemented TY2021 Indian Statutory Changes & Covid-19 PF Changes.
Projects Details:
Tata Business Software Solutions
• Builded Workflow Archival Scripts that significantly helped to increase database Performance.
• Tuned the SQL scripts to greater extent, thereby reducing the memory utilization.
• Developed MIS reports, for the business needs.
• Aligned Team members on critical issues.
• Training Users about the functionality of the tool and false move that are done in tool.
• SFTP File-based attendance package designed for monthly attendance.
• Training-cum Offer Letter has been designed and coded.
TAFE (Tractors and Farm Equipment Limited)
• Implemented Custom-build Separation Module, PMS Module.
• Executed Attendance Logic from the Bio-metric Data source.
• Implemented Complex hour based salary process calculation logics in payroll for Union Staff &
Workers.
• Developed Annual Appraisal Payment Report based on rate of payment & working days.
• Designed and coded MIS Reports for Annual Rating Letters depended on PMS Rate grades.
• Automatic User Role Mapping & other privileges are implemented during employee id creation.
PERSONAL DETAILS:
Name : Name Surname
Gender : Male
Date of Birth : 12th Aug 1994
Father Name : Name Surname
Marital Status : Single
Nationality : Indian
Languages Known : English, Hindi, Marathi
Educational Qualification: Bachelor of Engineering in Computer Science from Dhanalakshmi College
of Engineering With the aggregate of 75%