Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic

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

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
VARUN JANJUAANALYST