RUBY PANDEY
*rd floor, Near Kalighat temple, Mobile: +91-876*******
Kolkata - 700026 Email: acx3l5@r.postjobfree.com
Career Objective
Looking for a challenging position in a company where my professional integrity, Qualification, knowledge skills and enthusiasm will be effectively utilized to the best of my ability. It should provide me a continuous learning experience and opportunity for growth with a high degree of responsibility.
Academic Qualification
PG Diploma in Business Administration from Symbiosis Centre for Distance Learning – 63.5%, Year 2013
Bachelor of Computer Application (BCA) from Fatima College, Madurai – 82.1%, Year 2008
HSC from Seventh Day Adventist Matriculation Higher Secondary School, Madurai – 75.2%, Year 2005
SSLC from Seventh Day Adventist Matriculation Higher Secondary School, Madurai – 82.7%, Year 2003
Awards & Certifications
Daimler India Commercial Vehicles Pvt. ltd:
Innovation Award (October 2012)
Honeywell Technologies Solution Pvt ltd:
Team Excellence award (December 2010)
Partner Award (July 2010)
Team Excellence award (November 2009)
Skill sets
MIS generation and benchmarking across global units
MS Office tools: Excel, PowerPoint
Have worked with International customers from all regions (APAC, EMEA, USA & CAN)
Very good exposure to People soft Query Reporting 8.3, MS Office tools
Experience in creating Scorecard using HR dashboard
Experience in running GHRT (Cognos) Reports
Auditing and framing of Internal control checks
Very good knowledge in Lean Concepts
Hands-on Experience in 5S implementation
Professional Experience
Daimler India Commercial Vehicle Pvt Ltd., May 2012 – March 2014
Department : Cost Planning, Finance & Controlling
Designation : Manager
Roles and Responsibilities
Handling Bill of Material costing for the Trucks parts
Supplier Evaluation on Production category in OSA (On Site Assessment)
MIS reporting to Daimler Group entities on KPIs
Automation using Advanced Excel
Responsible for preparing PowerPoint presentation for top management
Trainer for MS Advanced Excel
5S Champion for the entire team
Driving employee engagement related activity to the entire team
Previous work Experience
Honeywell Technologies, September 2008 – July 2011
Project Title : PeopleSoft Query Management
Role : HR Sr Ops Specialist - PeS Rpt
Roles and Responsibilities - PeopleSoft Query Reporting
Using Query Manager - Searching for Existing Queries, Editing Existing Queries, Creating Simple and Complex Queries, Working with multiple tables.
Adding Criteria to Queries, Refining Criteria, Using Multiple Criteria Statements, Using the Effective Date Field as Criteria.
Describing Runtime Prompts, Creating Runtime Prompts, Creating Multiple Runtime Prompts.
Defining Query Expression, Creating Simple Expressions, Using Expressions in Criteria, Using Prompts in Expressions.
Creating Any Joins, Creating Outer-Joins and Inner-Joins, Using Sub queries, creating a Single-Value Sub query, Creating an In-List or Not-In-List Sub query, Creating a Exits or Does-Not-Exist Sub query, working with Unions.
Add/delete/modify/schedule/run queries & ensure appropriate controls audits are in place.
Generating the reports using PeopleSoft 8.3 Query tool.
Audit the report values with PeopleSoft database.
Reviewing customer Access before we send the reports.
Supporting in Data Analytics for HR Scorecard Project, Bravo Project & Quality of hires Survey project.
Handling Customer Calls effectively for clarifying their Service Requests.
Running various reports (Census, Cubes, turnover analytics etc) from Cognos tool.
Using Siebel 8.0 for tracking all Service Request.
Regularly conduct 5S audit for team
Technical Knowledge
Operating System : Windows XP, 2007
Database : Oracle 9i
Tools & Software : People soft tool, SIEBEL 8.0,
Standard/Process : Six-sigma Process, Lean Principles
Office Automation Tool: MS Office
Brief Summary of the Project
Honeywell International is a Fortune 100 diversified technology and manufacturing leader, serving customers worldwide with aerospace products and services; control technologies for buildings, homes and industry; automotive products; turbochargers; and specialty materials. Honeywell Technology Solutions a CMMI Level 5 company works on a number of projects in the Aerospace and Automation and Control Solutions domain. AERO, ACS, TS, SM & CORP are the five SBG’s in Honeywell.
1.PeopleSoft Query Reporting: The requests for reports mainly come from HR Community. The requests come from the customers via smart form in Siebel. It lists all the fields needed in the output and the criteria for the population. The user’s security access rights are checked before it is processed. If needed, prior approval should be taken from the Corporate Compensation department while giving out confidential data. The request is processed using PeopleSoft 8.3 query tool, SQL Developer and the output is exported into MS excel. The file is password protected if there is compensation information or other confidential data. The output is finally delivered to the customer via e-mail and the request is logged into Siebel for metrics collection.
2.GHRT Tool (Cognos): It is an online reporting and data analysis tool which uses Cognos Business Intelligence, that integrates and stores multiple sources of HR information into one global repository and enables the global HR population to sort and query data about the Honeywell census and workforce.
3.HR Scorecard Project (Executive Reports): This Project is about to gather information from various sources and do calculation & complex Pivots to arrive at metrics on monthly basis to report Scorecard to Honeywell Leadership people. This scorecard includes Staffing, Turn Over, compliance, Six Sigma, HPD and VOC metrics.
4.Quality of Hires Project: This Project is about to pull Employee reports who joined Honeywell 3 & 12 months ago respectively. Apply the Calculation, Do Audit & Finally we will upload into Share point site which in turn sends survey automatically to the respective employee’s reporting manager. The results of Survey would be downloaded by the staffing team & reported to Leader Ship People.
Personal Dossier
Father Name : R C Pandey
Nationality : Indian
Marital status : Married
Language Known : English, Hindi and Tamil
Date of Birth : 11-Mar-1987
DECLARATION:
I hereby declare that the above furnished details are true to my knowledge.
Date:
Signature
Place: Kolkata
(Ruby R Pandey)