VARUN JANJUA
ANALYST
Paschim Vihar
Summary
Experienced data management professional with a proven track record in organizing, analyzing, and maintaining complex data systems. Demonstrated expertise in fostering team collaboration, ensuring data integrity, and meeting project goals. Adaptable to changing needs and highly reliable in delivering results. Proficient in database management, data analysis, and relevant software tools. Recognized for exceptional problem-solving abilities and effective communication skills.
Overview
10
10
years of professional experience
6
6
Certifications
Work History
DATA MANAGEMENT ANALYST II
Honeywell Technology Solutions Lab Pvt. Ltd
10.2023 - Current
- Creating the Peoplesoft Query as Per Requester Requirement and Optimizing it to give proper and Accurate data
- Query updating and modification in Peoplesoft and Alteryx workflows
- Acted as a trusted resource for the resolution of data-related issues, working closely with other analysts to troubleshoot problems and develop creative solutions.
- Reduced manual data entry errors by creating user-friendly templates and standardized input formats.
- Provide trainings to New HRGs about important peoplesoft Navigations and also explain the impact of this Data accuracy on Down Stream Applications
- Developed comprehensive documentation on data requirements and specifications for internal knowledge sharing and training purposes.
- Supported the successful migration of legacy systems to new platforms by ensuring consistent data mapping and seamless transfer of information.
- Developed and modified programs to meet customer requirements.
HRIS ANALYST II
Honeywell Technology Solutions Lab Pvt. Ltd
04.2022 - 10.2023
- Creating the Peoplesoft Query as Per Requester Requirement and Optimizing it to give proper and Accurate data
- Query updating and modification in Peoplesoft and Distribution List changes in RPA config Files
- Have A Complete Understanding HRDA BOT includes Completed understanding of Configuration files, along with Scheduling of the reports
- Engage in Discussion with BOT Team to Address any Concern related to Configuration files or any batch Failure for quick resolution and optimal performance
- Responsible for Scheduling the Query in Redwood Tool along with Maintaining the Queue to Check which report has Executed or not
- Responsible to raise Concern with redwood team if Scheduling of the query is unexpectedly affected due to patch and update
- Have a Complete understanding of Salesforce Tools and also Supported the team in Assignment of cases
- Provide data for Several Audit request such as Payroll and internal audit request
- Delivering the standard reports
HRIS ANALYST
Sunova Tech Solution
08.2021 - 03.2022
- Provide support for HR Systems Applications Like Peoplesoft, Cornerstone, Phenom Peoples, HireRight and Quest
- Provide Resolution for daily Service Request tickets of users, like Data Access issue, Connectivity issue or Tool Access
- Provide Data Level Access in HR System for New joiners and Provide Addition Access as Requested by the user
- Provide Support in AUDIT Process like monthly Audit and Daily Audit
PeopleSoft Developer / Technical Consultant
SOA IT Solutions PVT LTD
06.2016 - 12.2019
- Have gone through the application functionality and understood the business process of Procurement Module
- Worked closely with business/functional users and architects for gathering requirements on the enhancements identified in the system and improve the quality of the Applications
- Prepared technical specifications documents for internal design according to the department standards and business requirements
- Took major part of bug fixing and Enhancement activities
- Provide production support & resolve daily Service Request tickets of users like connectivity, access, security, navigation, and data issues
- Maintaining PeopleSoft user security using user profiles, roles & permission lists
- Respond quickly and effectively to the critical production issues and taking responsibility for fixing those issues through bug fixing and Change Requests
- Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
- Developed various PS queries in order to help the client day-to-day activities
- Wrote People Code programs for online validations and for functional processing
- Did code level changes in application engine for batch processing
- Customized all the SQR report for new modification and change modification
- Helped client to reorganize their data-by-data request and data corrections
- Used Process monitor and Process Scheduler for Monitoring all the processes and scheduling recurring processes and for setting up reports to run at specified time
- Involved in Unit Testing and Systems Integration Testing
Technical Consultant
SOA IT Solutions PVT LTD
06.2016 - 06.2017
- Involved in customization of records, pages, People Code, Components
- Created Run-Control Record's and Pages to run the Application Engine Programs Created Audit records for important transaction tables
- Modified People Code as per the requirements to implement the customer's business rules and validations
- Created process by SQR and ran them from process scheduler
- Retrofitted and did code level enhancement in SQR
- Responsible for unit testing of the customized/modified applications and PeopleSoft delivered fixes and patches
- Used Process Scheduler for scheduling recurring processes and for setting up reports to run at specified time and updating the run control parameters as per current requirement
ORACLE DBA
VAS info solutions Pvt. Ltd
03.2015 - 05.2016
- Installation and Configuration of Oracle databases on Linux platforms
- Part of core Production DBA team administering the physical aspects of the database such as creation of Tablespaces, Users
- Maintaining production databases Design and implementation of backup and recovery processes AND scheduling backups
- Automation of backup and recovery, tasks in all environments – development, test, and production
- Monitored tablespaces & their growth and took proper actions
- Performing exp/imp for logical backups
- Creating ASM Instance, Creating ASM Disk groups, Adding/dropping disks
- Generating AWR Report, ADDM Report to monitor database performance
- Dealing with Block corruption Using RMAN
Education
Bachelors in computer application -
IGNOU
Certification in Computers - undefined
IGNOU
Senior Secondary - undefined
Dav Public School
Secondary - undefined
Dav Public School
Skills
SQL proficiency
Data security
Data migration
Data quality assurance
Business intelligence
Data mapping
Real-time analytics
Data warehousing
Report development
Certification
Oracle Applications Cloud Data 2016 Implementation Specialist
Personal Information
- Father's Name: Late Mr. Anil Kumar Janjua
- Date of Birth: 03/17/90
- Nationality: Indian
- Marital Status: Married
Timeline
DATA MANAGEMENT ANALYST II
Honeywell Technology Solutions Lab Pvt. Ltd
10.2023 - Current
HRIS ANALYST II
Honeywell Technology Solutions Lab Pvt. Ltd
04.2022 - 10.2023
HRIS ANALYST
Sunova Tech Solution
08.2021 - 03.2022
PeopleSoft Developer / Technical Consultant
SOA IT Solutions PVT LTD
06.2016 - 12.2019
Technical Consultant
SOA IT Solutions PVT LTD
06.2016 - 06.2017
Oracle Applications Cloud Data 2016 Implementation Specialist
02-2016
Oracle Applications Cloud Operations 2016 Implementation Specialist
02-2016
Oracle Applications Cloud Reporting 2016 Implementation Specialist
02-2016
ORACLE DBA
VAS info solutions Pvt. Ltd
03.2015 - 05.2016
Completed Oracle Certified Admin (OCA) level in 05/2014
05-2014
Completed Training on Oracle Database Administration
02-2014
Completed Oracle Certified Professional (OCP) in 02/2015
02-2014
Certification in Computers - undefined
IGNOU
Senior Secondary - undefined
Dav Public School
Secondary - undefined
Dav Public School
Bachelors in computer application -
IGNOU