SUMMARY

• Seasoned HR and Payroll professional with around 14 years of experience with ERP - PeopleSoft Suite and 5 years of experience in Reporting and Analytics
• Certified Project Management Professional (PMP) with prior experience of leading and managing small to mid-sized teams (5-10 members)
• SQL Expert with experience working with large level datasets, performing complex joins and creating cross tab and summary level reports.
• Well versed Analytics professional with expertise in Alteryx for Data Mining and dashboards with Tableau
• Currently involved in Data Science projects with Confidential to analyze headcount reporting, potential leavers and critical employees.
• Key member in a project implementation for a leading resorts company in Florida (USD 640,000)
• Showcased product features and vendor capabilities to client teams (pre-implementation phase)
• Led a 6 person team for a 7 month implementation and eventual roll out to other properties in Bahamas, Paris and South Africa.
• HR Process redesign with recruiter teams and payroll members
• Post graduate diploma in Management from one of India’s top management schools.
• Involved in all aspects of ERP implementations - From RFP response and project scoping to areas such as presales and user training.
• Machine learning - Currently a novice in this field but comfortable with Python and Data Science concepts. Working on beginner level projects at present.

TECHNICAL SKILLS

ERP Suites: PeopleSoft HCM, JD Edwards

Time Keeping: Kronos

Analytics: Tableau, Alteryx, Cognos Report Studio, MS Office suite, SSIS

Scripting: JavaScript, UNIX Shell Scripting

Open Source: Python, Visual Basic, C++

Operating Systems: Windows 3.1, Windows NT, Windows 95, Windows 2000, UNIX (Sun Solaris, HP AIX)

Database: Oracle (10g, 9i, 8i, 8, 7), SQL Server, SQL Anywhere

PROFESSIONAL EXPERIENCE

Confidential

HRIS Project Lead

Responsibilities:

• HRIS Technology Lead with expertise in PeopleSoft and Time Keeping
• Data conversion for companies acquired by Jarden Corporation - Integration of all company HR data into the existing system.
• POC implementation for new modules/PeopleSoft product features
• Integration of Kronos with SAP - Inbound and Outbound
• Tested web services approach of integration between PeopleSoft and Kronos
• Expertise with use of Workforce development toolkit and WIM interfaces.
• Currently building a data science project for SVP HR to predict potential leavers - using ML algorithms past 3 years of history data and looking for trends. Initial round of insights was shared with the CHRO.
• Headcount reporting - Provide Finance with accurate details of active and terminated employees across all Business units for reporting purposes.
• Managed a reporting team of 4 to perform data governance and validation strategies for data collection from various HR & Payroll departments.
• Centralized US, Canada and International employee data in a master table to track headcounts and monitor changes.
• Created reports to split by BU and send headcounts by division to division heads on a monthly basis.
• Recruiting dashboards in PeopleSoft - Job opening submissions by recruiter, Closed job reqs, # of offers accepted/rejected.
• Alteryx - Develop solutions for preparing data, combining data from multiple sources
• Integration of Alteryx with Tableau to build dashboards.

Confidential

Senior ERP Analyst

Responsibilities:

• ERP 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
• Involved in database and platform migration across vendors.
• Performance tuning for Payroll Calculation - SQL tuning of Payroll jobs
• Automation of all payroll interfaces (custom) - DDP and Check print processes.
• Work on issues/enhancements with current processes in CPS
• Compensation - Work on redesign of step progression and compensation rules for teachers
• COBOL analysis - Prepare flow documents for delivered T&L pay sheet load program
• Bolt on customization for viewing teacher evaluation ratings in PeopleSoft
• Analyze payroll issues - Look at incorporating best practices for the customer
• Integration of PeopleSoft HR with Taleo for hiring of teachers across CPS Schools

Confidential

Consultant

Responsibilities:

• Technical analyst for PeopleSoft Time and Labor for Hartford Insurance
• 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
• Technical and functional analysis for support issues and document resolutions and fixes.
• Analyze SQR reports for errors in employee T&L data or report lay out issues.
• Create new SQR Reports for T&L reporting requirements.

Confidential

Consultant

Responsibilitis:

• Structuring PeopleSoft solution approaches, business process reengineering and understanding of business problems.
• Respond to client RFPs for project timelines or resource estimations.
• Defend bid proposals against competitors

Confidential

Project Lead

Responsibilities:

• 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 Confidential corporate.
• Requirements gathering and preparation of file templates.
• Create detailed design documents for the SQR interfaces.
• Code and test plan reviews.
• Coordinated among project managers at APAC region to ensure parallel execution of interfaces.
• Spearheaded a solution accelerators team to develop new ideas in speeding implementation.
• Presented recommendations for product enhancements and designed solutions/workarounds.
• Achieved 40% process improvement and savings of USD 800,000 for the client.
• Solution architect for new projects in PeopleSoft for Confidential

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Presales - 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.
• Design application engine programs and component interfaces for handling data migration for applicant data, employee job data and set up information (master HR data such as job openings, SetIDs and jobcodes).
• 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.