Somashekhar Hiregoudar

Senior PeopleSoft HCM Consultant

PROFESSIONAL SUMMARY

Over 15 years of experience as a Techno/Functional consultant in PeopleSoft HCM Modules (Core HR, Benefits, T&L, Payroll, Financials (AP, PO,GL) EPM Modules (Financial warehouse, RWC)

Experienced in gathering Business requirements, Systems requirements. Performed Gap / Fit/Feasibility analysis. Designed Conceptual solution to fill the gaps identified and Technical design to customize PeopleSoft HRMS and Financials modules to meet the client requirements.

Expertise in module Implementation, Support, Configuration, Development, Upgrade, Interfacing,

Data Conversion, Approval framework, Operational and Management Reporting.

Worked extensively on PeopleSoft versions 7.5 through 9.2, on People Tools, Enterprise Integration solutions, Application Designer, Application Engine, People Code, Component Interface, App Packages, Data Administration Tools, Reporting Tools like SQR and Crystal Reports and PS/Query, Process Scheduler,

Activity guides, Work Centers, Dashboard, Related Content Service framework, XMLP, AWE

As a UAT Test lead designed and developed test cases, test plans, test strategy to perform System, Integration testing and UAT and effectively communicated with Users and development team.

Proficiency in analyzing and translating complex business requirements to technical requirements,

managing large project teams and managing major North American Clients.

Oversaw design and reviewed code and assure adherence to best practices. Possess exceptional communications skills (both verbal & written). Understanding of Agile .

TECHNICAL SKILLS

ERP Package: PeopleSoft HCM, Peoplesoft Financials, Peoplesoft EPM, (Application-9.2/9.1/8.9/8.8/8.4x/7.5x, Tools 7.5/8.0/8.3/8.42/8.47,8.55)

Databases: IBM-DB2, ORACLE 10g/9i/8i, MySQL 5/4, M.S. SQL Server 2000/2005

Testing & Ticketing: IBM-Rational (Test Manager, ClearQuest & Req Pro) and Mercury (Quality Center

Software Enterprise Edition 9.0), Peregrine, BMC Remedy, Service Now

Operating Systems: UNIX, Win XP/2000/NT/98

EDUCATION:

Bachelor of Engineer in Computer Science – 1995.

Attempted 2007 CFA exam.

PeopleTools 8 Application Developer Certified Expert / OPN Certified Specialist

Clients:

Entergy, Pentair, Caterpillar, Abercrombie & Fitch, Dow Jones, Citigroup, Rabobank, GE, Compaq, Seagram’s, HTA

PROFESSIONAL EXPERIENCE:

Entergy Inc. (IBM ) – HCM Benefits consultant Dec 15 – Mar 17

Pentair Inc. (IBM ) – HCM T&L SME Jul 13 – Mar 17

Responsibilities

Managing technical team, Planning, Defining scope,Estimation, Documentation, Development, Quality control,

Training and team Leadership. Work on IBM Tools like RTC, RPM, and IPWC for Project Monitoring.

Involved in Functional & Technical design of major Enhancements and interfaces of Benefits and HR module involving various vendors.

Monitored Oracle Support for regular updates for bug fixes, patches, POC

Work allocation and ensure efficient resource utilization to execute the entire project life cycle

Involved in defining test strategies during Unit and SIT Cycles and communicated to all stake holders.

Expertise on attachment framework, Benefits Life Event setup, event maintenance, approval functionality

Designed and developed various company specific benefits and payroll related customization (Interim retire process, BIBO Adjustments, One Time payment, Insurance $amount caps on ESS pages to name few.

Lead and facilitate business process improvement change. Provide business expertise and input to the design, improvement and overall solution architecture of the Time & Labor 9.1 & upgraded 9.1 to 9.2.

Analyze Human Resources/ Time & Labor/ Payroll/ Time Capture business processes, Coordinates with onsite team members and interact with client for new development work, estimation and delivery.

Configured Time and labor related to Time reporter Enrolment, Workgroups, Task groups, Schedules, AWE, Kaba TCD

Configured multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service, Adhoc and Dynamic group and AWE Framework

Created custom Workgroups, Schedules, both template-built and custom Rules and Rules Programs.

Configured rules for Overtime, California Overtime, Additional Straight time, Holiday for FT and PT, Comp time and Meals, Custom exceptions for over or below scheduled hours, meal break, and overtime in Time and Labor.

Developed robust custom Auto Enrollment AE batch process for enrolling / disabling Time reporters during hiring/termination/Bu/department changes.

Actively involved in resolving Time administration related issues, performance issues, Dynamic group creation. IB Messaging (TLSTLIB and TLSTLOADER), Payable time discrepancies, and approval routing.

Interact with Oracle for patches regarding upgrade issues on T&L 9.1 on Timesheets, Time admin and batch approval process and bundle upgrades.

Environment: PeopleSoft HRMS 9.2, People Tools 8.55, Oracle, Windows 10 and Unix, Service Now

CATERPILLAR Inc. (IBM) – HRMS Tech Lead Aug 10 – Jul 13

Responsibilities:

Single point of contact for Bangalore AMS team, led 15-member team working on mainframes, Java and Peoplesoft.

Involved in production support of HCM modules covering Recruitment, Salary Planning, ePerformance and various other modules.

Coordinate with onsite team members and interact with client for new development work, estimation and delivery. Involved in creating Oracle Service request and resolving the technical and functional bugs.

Carry out Analysis, design Development and testing of new requirements

Involved in generating status and monthly metric reports.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.47, DB2, Windows XP and Unix, Weblogic6.1, Jolt,

BMC remedy.

Abercrombie and Fitch, Columbus, OH (BIS Inc.) – HCM Techno Functional Lead - Nov 07 – Feb09

Responsibilities:

Involved in the project from requirement phase to testing (Unit to UAT), did requirement gathering and prepared business process mappings for core HR and Time and Labor modules.

Developed conversion process to convert stores, home office and distribution center associates in SQR to feed the data from CHR system to PS, developed interfaces between POS and PeopleSoft using Integration framework

Customized TL_ST_LOADER AE program to keep POS & PS in Sync.

Customized Time and Labor Rules to capture the exceptions as per business requirements for both work and compensation rules. Used the delivered rule engine TL_TA_RULES as the frame work.

Effectively worked on Integration Broker, designed various Application Messages (Integration Broker) to publish data from PeopleSoft to other applications in an Synchronous and Asynchronous mode. The response messages were received using Subscription Messaging.

Configured TRC, TRC program& Lists, Workgroups, Rules/Rules Template/Definitions, Schedules setup.

Created functional design artifacts, developing test plans/strategies, developing test scripts, performing detailed and thorough testing and actively led the walkthroughs of artifacts.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.47, DB2, Windows XP and Unix, Weblogic6.1, Jolt, Quality Center

Rabobank International, NJ(BIS Inc.) – ETL Developer Mar 07 – Oct 07

Responsibilities:

Actively interacted with Business users gathering the Phoenix implementation requirements

Was involved in the decommissioning of the old interface/maps developed over the IBS system.

Was involved in the mapping of the new data elements from Phoenix to Peoplesoft data structures

Did impact analysis and developments for phase by phase transition of IBS to ACBS system for Loan and Facility systems. Ereports maintenance screens to reduce RFC needed by adding auditing facility.

Worked on IBS CIF / DDA / NS Decommission Taking backups, deleting references, adjusting parameter files, updating ETL code. Participated in the UAT Cycles for Phoenix conversion.

Used version control to maintain versions of different development objects from Peoplesoft, Database, ETL

Environment: PeopleSoft 8.x EPM 8.x, Ascential Datastage 7.1, Oracle 9i/10G, Application Engine, Component Interface, File Layout, PS Query, Work Flow, SQR, Crystal Reports 8.5, Windows 2000 and UNIX.

Dow Jones, South Brunswick, NJ (BIS Inc.)- Techno Functional Consultant Nov 06- Mar 07

Responsibilities:

Conducted Fit-Gap analysis to bring Lawson ERP modules to PeopleSoft Financials as well as corresponding changes to PeopleSoft EPM as required.

Worked in a Support role for EPM Financial Reporting, Supply Chain Data Mart for Vendor performance reports using Cognos, Crystal and nVision Reports.

Developed Monthly Financial Reports, in PeopleSoft EPM Financial data warehouse, also produced several ERP Drill through reports, in PeopleSoft GL using PeopleSoft nVision tool.

Modified custom ETL maps using Informatica for custom chart fields tables and also to bring the custom Ledger tables

Created Jobstreams Meta data, developed a mechanism for scheduling these jobs streams using PeopleSoft process scheduler batch processes.

Provided functional support and debugging the errors produced during the month end close GL processes and provided solutions as workarounds to close the books and post the adjustment journals as required.

Involved in merger and acquisition of Factiva into PeopleSoft FSCM and as well PeopleSoft EPM. Also involved data conversion to bring Factiva data into PeopleSoft FSCM and EPM as a single system.

Rabobank International, NJ(BIS Inc.) - Lead Developer May 06 – Oct 06

Responsibilities:

Was involved in analysis of existing data maps for MM and FX modules, rewrote the new ETL maps for Money Market and Forex data and integrated them with the existing warehouse structures.

Modified the Unix DIFF shell scripts and Jobcode to alter the source and configuration.

Modified the ETL load method, and coordinated with reporting team for deriving the reporting layer for

MM/FX modules (8.8 Calypso Implementation)

Conducted Unit testing and migrated Peoplesoft and ETL objects to UAT environments.

Did user training on Ascential datastage 7.1

Citigroup (GCG), LIC, NY(EAPT Solutions Inc.) – EPM Tech lead Jul 05 -- Mar 06

Upgrade and BASEL II implementation

Responsibilities:

Actively interacted with Business users to gather and understand complete requirements to build the Risk framework to satisfy the BASEL II requirements for Retail and Wholesale Exposures.

Involved in Upgrade activities from PeopleSoft 8.3 EPM to 8.8 prior to BASEL II implementation Conducted Impact analysis for heavily customized EPM 8.3 and provided support for 8.8 upgrade.

Using PeopleSoft EPM 8.8 Enterprise Warehouse solution built custom processes to capture risk and Finance Decomposition and FRS data for various business Units.

Defined Portfolio attributes, references data elements to control Credit inbound process.

Involved in building the reconciliation process to reconcile Credit data against Decomp and FRS Data at BU/OU/FDL account level. Implemented complex BET (Basel Edit Triggers) to validate the Portfolio Risk data to comply with risk model done in SAS.

Designed workflow / approval routing path process from ODS layer to Warehouse Layer.

Designed & Automated Risk Enrichment process for applying the Risk Parameters (PD, LGD, EAD) to the Risk data. Involved in splitting the Retail Pooled Data into Sub pools and further enriching the Portfolio data to apply the regulatory segments (OR, QRE, RM) to further submit to Reveleus for RWA calculations. Migrating projects between environments help the team build Test scripts to test the end to end functionality of Basel II reporting. Involved in designing to receive the RWA values from Reveleus. Involved in the discussions for LEA (Legal Entity Aggregator) handoff for retails exposures

Environment: EPM 8.8/8.46,Application Engine,CI,Unix,Oracle9i, Crystal Reports, PS Query,Tree manager

Rabobank International, NJ (EAPT Solutions Inc.) – Lead developer Jan 04 – Jun 05

8.8 EPM Implementation

Responsibilities:

Developed interfaces to load the files to the file server, creating dynamic tables, file layouts and loading the data for the manual driver/ and basis data for the financial allocations. Capture Counter Party information

Developed CodeBlock to create detail transaction/instrument level ledger from the Instrument data coming from various sources of loan processing systems(ACBS,IBS), equity finance systems, money market systems (IBS, IFLEX), FX systems(IBS), and trading systems.

Developed a reconciliation mechanism between instrument level ledgers with PS ledger coming out of PS/GL. Provided drill down capability from the ledger to the instrument level ledger to the transaction level.

Expertise in Data Warehouse’s design, development and implementation phases of the Decision Support Systems for the reporting needs of the end users. Expertise in Ascential Datastage and Data loader.

Set up and run the Data Loader to populate reporting tables in the Enterprise Warehouse

GE CIS, NY (Birlasoft Inc.) – HRMS Tech Lead Apr 02 - Dec 03

Responsibilities:

Worked on enhancements, interfaces, customizations based on Service Requests by business users for PeopleSoft online objects and non-PeopleSoft objects related to custom reports and processes.

Worked on both inbound and outbound interfaces using SQRs, AppEngine and component interfaces.

Designed and modifying existing SQR interfaces/reports with proper impact analysis. Reports included Absence History, Emp Review Audit, and dept. Salaries using SQR, Crystal Reports for HR to name a few.

Debugged Application Engine, PeopleCode, Component Interface and SQR. Proficient in using traces (online PeopleCode, AppEngine, SQR & Cobol traces) and debugging tools.

Worked on PeopleSoft Security, online application & data and had good exposure to security administration.

Worked with Payroll Users in updating Paysheets and calculating salaries for a specific pay period to perform pay in Payroll module and used pay calculations to calculate employee's gross pay and process manual checks. Applied regular tax updates, patches & bundles to all relevant instances.

Supported Payroll (Payroll Administration – PaySheet, PayCalc and PayConfirm Processes) and worked on issues related to payroll.

Environment: PeopleSoft HRMS 8.3, PeopleTools 8.19, Oracle 8i,WindowsNT/2K/XP, Sun Solaris 2.8

Compaq Computer Corporation - (UK) - HRMS consultant Apr 00 - Mar 02

Responsibilities:

Participated in Analysis and design. Involved in HR and Payroll Setups for company information, establishments, location, department, salary grades, job codes and pay groups Worked on scheduling various daily, weekly, and monthly reports of regular and non-regular workforce

Worked with Payroll SQR Reports to issue Payroll Register, Payroll Check Register, Other Earnings Register, Payroll Error messages and Payroll Summary Report. Customized the People Code for compensation rates and codes.

Used Maintain Security to give access to the customized menu and created permission lists, users, roles and assigned roles to users. Securities that were dealt with included Operator Security, Object Security, Query Security and Row Level Security

Participated in Component level testing, Regression Testing, Pressure Testing, Technical Documentation and implementation.

Chivas Brothers (Seagram‘s UK) Scotland - PeopleSoft Technical Consultant Dec 98 - Apr 00

The project was for the wine manufacturing division at Chivas Brothers Limited (Seagram’s), UK. The primary focus of this project was to implement Manufacturing modules to replace the existing mainframe based MRP (control manufacturing) system to PeopleSoft, this part being the part of their business process-reengineering project.

Responsibilities:

SQR interface and Reports and Panel customization and data migration

Developed the interface between WMS residing on Dec Alpha and PeopleSoft NT server (Oracle) by spooling at regular intervals and transfer valid Lot id, item id, storage levels, production id’s

Developed and printed Reconciliation reports depicting the difference between production data (WMS) and PeopleSoft data (Oracle), Customized freight modification panels.

Environment: PeopleSoft 7.5, People Tools, PeopleCode, SQR 3.0, Crystal Reports 4.0 & PS-Query, oracle 7.x, Windows and Unix

HINDUSTAN Thomson Associates, India – Application Developer Oct 97 - Nov 98

Automation of various phases of an advertising media (Press, Radio, TV). Phases involved Campaign, Planning, Estimation, Date & Material Scheduling, Billing, Reports and Housekeeping.

Responsibilities:

Design of ER model of cinema and press modules, coding and preparing test plans for press module and active interaction with the client, was involved in SQL Query Optimization, writing procedures, triggers and business rules, finalizing naming conventions of all the databases objects across modules.

Environment: Sybase 10.0, Power builder 4.0, ER-WIN

NIIT Ltd India – Systems Executive Mar 97 to Sep 97

Responsibilities:

Training Clients in Sybase system 10,Unix shell scripts and C++ part of the quality team for implementing Quality in the development work process.

R.B Electronics, India - Developer Mar 96 to Feb 97

Integration and automated information within various departments between the regional and head office to obtain up to date information in the form of various annexes as per the ISO standards.

Responsibilities:

Developed screen layouts, procedures for user interactions with the System, which allowed the user to generate customized reports such as resource Occupancy chart, detailed and module milestone chart, batch occupancy list, Defaulters, dropout, irregular students list, performance sheet of every student after the Exam, feedback of the faculties in terms of GPA.

Environment: Oracle 7.3, Developer/2000(Forms 4.5, Report 2.5) and window-NT

Contact this candidate