Vijay Anand

Rajendran

Technology Manager

Personal Info

Address

**** ******* ********* - *** ***

Boca Raton

Florida - 33433

Phone

312-***-****

E-mail

ac6e5z@r.postjobfree.com

Date of birth

1982-01-01

Resident Status

Permanent Resident

LinkedIn

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