Manager Data
Resume:
Vijay Anand
Rajendran
Technology Manager
Personal Info
Address
**** ******* ********* - *** ***
Boca Raton
Florida - 33433
Phone
*********@*****.***
Date of birth
1982-01-01
Resident Status
Permanent Resident
https://www.linkedin.com/in/vijay-anand-
rajendran-86a21941/
Skills
Database Scripting - SQL, PL/SQL
Data & Quantitative Analysis - SQL &
Excel
Python, R
Good
Data Visualization - Tableau and Power
BI
Cross Platform Integration
Research, Reports and Forecasting
Project Management
Business Intelligence (Microsoft BI)
Talented technology professional with over 14+ years of IT experience in multiple roles - Project Manager, Lead and Reporting & Analytics.
Extensive experience in ERPs such as PeopleSoft and Data Warehousing (Cognos) with expertise in data management tools such as Alteryx and Tableau. Deeply involved in Machine Learning and Statistics and a passionate Raspberry Pi Enthusiast in my spare time.
Specialties: ERP, Oracle, SQL, Cognos, Alteryx, Tableau, Python, Microsoft BI Experience
2015-04 -
present
Technology Manager
Newell Brands
Technology Manager/Lead for Corporate Office involved in integration of HR & Payroll data as well as predictive analytics projects.
Data Science & Analytics:
Currently involved in identifying potential leavers for the company and resource planning for divisions.
ERP - PeopleSoft HCM:
• Algorithm - Random Forest for classification
Predictor variables - Employee tenure, severance eligibility, satisfaction level, merit increase amount, promotion/demotion.
•
Data visualization - Used Power BI to build interactive dashboard of voluntary and involuntary terms
•
Insights determined - High correlation between severance eligibility, job satisfaction and manager track record to employee leaving
•
Findings - Communicated high level findings with VP of HR and CHRO via PowerPoint.
•
• Implemented Manager Self Service module in PeopleSoft.
• POC implementation for new modules/PeopleSoft product features.
• Specialist in real time integrations between PeopleSoft and 3rd party systems. 2013-09 -
2015-04
Sr ERP Analyst
Chicago Public Schools
ERP Technical Analyst with expertise in PeopleSoft NA Payroll and Time and Labor modules
•
• Upgrade workshop – Analysis of all pain points, customizations to redesign for 9.2
• Architect data solution for storing and analyzing teacher performance ratings - KPIs.
• Involved in database and platform migration across vendors.
• Performance tuning for Payroll Calculation – SQL tuning of Payroll jobs 2012-02 -
2013-04
Sr Business Analyst
Aon Hewitt
Analyze the PeopleSoft Time Admin application engine program and prepare support documentation
•
Create custom PS queries, SQL statements and reports for operations team in case of ongoing support and for time load process
•
Prepare Business Requirements Document for new enhancements highlighting design approach and impacts on existing system.
•
• Review test cases and unit test plans for application testing by vendor teams 2011-04 -
2011-12
Presales consultant
Infosys Technologies
Solution Architect:
Structuring PeopleSoft solution approaches, business process re-engineering and understanding of business problems.
•
• Respond to client RFPs for project timelines or resource estimations.
• Defend bid proposals against competitors
2008-06 -
2009-07
Project Lead/Manager
AIG Systems and Solutions
Project Management
Achievements:
Achieved 40% process improvement and savings of USD 800,000 for the client.
• Prepare project plan and effort estimations.
• Use SQL/PL SQL tools for data migration of core HR data from PeopleSoft to IDM Involved in study of client business processes, end-user training, identifying critical gaps and design of solutions/workarounds.
•
Set quality and process guidelines, communication protocols and configuration management as part of HCM ERP implementation for AIG corporate.
•
2003-12 -
2008-04
Sr Software Engineer
Hexaware Technologies
Responsibilities & Activities as PeopleSoft Consultant: Reporting & Analytics:
• Sales – Client presentations on the various modules and PeopleSoft benefits.
• Create As-Is and Fit-Gap documents during project study phase. Prepare data migration templates for various modules and use Excel to CI for master data migration.
•
• Review of data migration programs for Core HR data and TAM. Deployed and administered ETL jobs to refresh PeopleSoft data on to the ETL database
•
Used Cognos Query and Cognos Report studio to develop reports for users at Caterpillar – HR, Payroll and Benefits.
•
• Scheduled Queries and Reports according to user requirements. Built nightly snapshot jobs that pull data from several HR tables to refresh the master reporting table.
•
• Used Excel to CI for migration of Setup and Master data.
• Training junior resources on several technical features in PeopleSoft. Education
2009-08 -
2010-09
Indian Institute of Management Indore
• Focus areas included Human Resources and IT strategy. 2010-02 University of Pittsburgh - Katz - Executive Education 1999-04 -
2003-04
Bharathidasan University - Bachelors (Information Technology) Certificates
2016-12 PMP - Project Management Professional
2008-06 FPC - American Payroll Association
2004-03 PeopleSoft Technical Consultant
Courses
2018-01 -
present
Data Analysis & Machine Learning - Udacity
2018-02 -
present
Mathematics for Machine Learning - Coursera
Contact this candidate