VIJAYAKUMAR JANAGIRAMAN

Reno, Nevada *****

775-***-****

ad2ilw@r.postjobfree.com

linkedin.com/in/vijayakumar-janagiraman

SUMMARY

A technically proficient, highly analytical senior solutions architect specializing in Oracle Cloud ERP, with comprehensive global and domestic expertise in software engineering, database management, continuous improvement, reporting and documentation, and modules implementation. Facilitates architectural design on analysis of requirements, proof of concepts, system mapping, and gap analysis reports. Played a key role in Fusion HCM & ERP Implementation project and support. Involved in developing complex BI Publisher Reports and OTBI Reports for Customers. Ability to work in a team environment with matrix reporting structure, actively participate in project meetings, walkthroughs within work groups. Excellent problem solving, decision making, communication and interpersonal skills.

Software Architect ERP Implementation Oracle Cloud Oracle HCM Cloud Oracle ERP Cloud FAW

Interface Development System Mapping Requirements Gathering Fit Gap Analysis

Technical Architectural Product Management Data Migrations Features Implementation JIRA

Application Support Deliverables Oversight Cloud Computing Agile Methodologies Scrum Data Conversion

TECHNICAL SKILLS

Oracle Fusion Cloud – HCM & ERP (GL), Oracle OTBI, BI Publisher, Dashboard, APEX, FAST Formula, HCM Extract, Business Intelligence Cloud connect console (BICC), HCM Data Loader (HDL), File-Based data Import (FBDI), ADF Desktop Integration (ADFDI), Smart View, PeopleSoft XML Publisher, PS Query, SQR, Oracle Database SQL, PL/SQL, Business Requirements, Architectural Design, Technical Design, User Acceptance Testing, Agile Methodologies, PeopleSoft HRMS 8.0 - 9.2, PeopleSoft Financials 8.0 - 9.1, PeopleTools 8.18 - 8.55, Application Designer, Application Engine, Component Interface, Application Package, Workflow, PeopleCode, File Layout, Integration Broker and Data Mover

EXPERIENCE

TRINET HR SERVICES, Reno, Nevada

Oracle Fusion HCM & ERP – Solution Architect, 2019 –2023

Lead Architect on implementation of Oracle HCM & ERP Cloud and migration of Data from PeopleSoft HCM & FIN application.

Lead solution architect in Implementation of Oracle fusion HCM workforce; acted as functional setup manager; and configured HR Setups, workforce structures, person attributes, reference data sets, user defined tables, and flex fields.

Loaded data through HCM Data Loader on all HCM setup and workforce data; worked on all data load issues, corrected errors; and collaborated with business to address data fixes.

Design, Development and Unit testing on HCM Extract, Fast Formula, Business Intelligence Cloud connect console (BICC), Oracle OTBI Reports, BI Publisher Reports and Dashboards

Worked closely with Business users and played a key role in the implementation of Enterprise structures, Business Units, Chart of Accounts configuration, Value Set Mappings, Security rules, Intercompany Setup & Subledger Accounting.

Played key role in setting up GL approval workflow configuration for Journal Approval and Intercompany Approval.

Played a major design and development role in Creating, maintaining, and troubleshooting the custom Oracle Business Intelligence Cloud Connector (BICC) extract processes.

Acted as general ledger architect, playing pivotal role in setting ERP configuration under setup and maintenance and later acting as single point of contact for configuration workbook maintenance.

Designed and played key role in Journal interface between internal systems from sub ledger accounting (i.e., P2P, I2C, asset, HCM payroll, and cash management) and external systems (vendors like GTreasury and Master Tax)

Worked on day-to-day activity on interface errors, effectively addressing and correcting errors through configuration changes, FBDI templates, and ADFDI templates.

Performed fit gap analysis between Xactly Sales Compensation and Oracle Incentive compensation and later designed solution based on business requirements.

Led configuration, set-up, and implementation of Oracle Incentive Compensation module.

Designed and created OTBI reports, BI reports, smart views, and dashboards based on user requirements in HCM, General Ledger, AP, AR, and Incentive Compensation Modules.

Facilitated architectural solution for migration of data from PeopleSoft to Oracle Fusion System. Performed technical architectural design, analyzed data points between PeopleSoft and Oracle Fusion systems, and designed technical requirements.

Led cross-functional teams in using Scrum methodology to deliver complex projects on time and within budget.

Extracted and transformed data from diverse Oracle Cloud applications into FAW. Developed custom data models and cubes for advanced analysis.

Designed and developed on integration between Oracle SaaS and external systems using REST APIs.

Involved in cloud application page personalization.

Proficient in writing SQL Queries, stored procedures, functions, packages, using PL/SQL, SQL.

Good knowledge in fusion security.

Involved in the Functional analysis of requirements and prepared Proof of Concept (POC), Functional Requirement Documents (FRD), System mapping and Gaps analysis reports.

TRINET HR SERVICES, Reno, Nevada

Principal Solution Architect, 2015- 2019

Lead solution Architect for PeopleSoft HCM, Benefits, Payroll and Financial Application (AP, AR, GL, Billing and Asset Management)

Reviewed and analyzed code for data transfer, validated data, and led team during successful migration

Understood client requirements, prepared and developed detailed design document, drafted technical design and unit testing documents, developed code, and performed unit testing

Interacted with business and functional analyst, performed architectural design, and developed solutions. Led functional analysis and design and prepared functional requirement doc for new development modules.

Played Key role in performing fit gap analysis between PeopleSoft systems and Oracle applications. Architected data migration between two systems, including design, review, testing, and maintaining conversion standards .

Lead design architect for Impact analysis on Maintenance packs for PS (HCM, FIN), Tax Updates and Year End Processing (W-2 & 1099)

TRINET HR SERVICES, Reno, Nevada

Principal Application Engineer, 2010- 2015

Operated as product technical leader for PeopleSoft modules.

Worked to architect, design, and code review all technical activities

Collaborated with Oracle support on all PeopleSoft-delivered bugs to provide fix and apply updates in client’s PeopleSoft environment after careful impact analysis on customizations

Acted as single contact to apply Peoplesoft deliverables, including bundles, patches, and tax updates, in client environment after careful impact analysis, design, and development

Worked and collaborated with end user on collecting requirements and preparing requirement document as well as coordinating or approval before passing onto development

Led functional analysis and design and drafted functional requirement document on all new development modules.

Led design and code review on all technical activities.

Provided guidance on all offshore resources to maintain work per design and standards.

Facilitated review and testing for all deliverables for project.

Performed fit gap analysis on client requirements.

Played key role in setting up code standards for deliverables.

Led team in offshore and on-prem for successful deliverable of project requirements.

ADDITIONAL EXPERIENCE

HEXAWARE TECHNOLOGIES, Iselin, New Jersey, Team Lead and Onsite Coordinator (Contract) TriNet HR Services, 2008-2010. Served as PeopleSoft techno-functional analyst for PeopleSoft HRMS and payroll applications. Worked on daily tickets raised by customers, including analyzing for different cause (i.e., user education, code bugs, data setup, and process failures) Prepared design, coding, testing, and deployment on year-end forms for Canada for different customers using XML publisher and Application engine process . Worked with end user on collecting requirements and preparing requirement document as well as coordinating for approval before passing onto development. Managed design and code review on all technical activities.

HEXAWARE TECHNOLOGIES, Iselin, New Jersey, System Analyst, Unisys Corporation (Contract), 2007-2008. Maintained direct client interaction for collecting standards and activity in Unisys. Facilitated knowledge acquisition on Unisys delivered usage and customization setup. Prepared knowledge acquisition document on Unisys Peoplesoft environment. Designed payroll interface setup in PeopleSoft application to interface with payroll vendor for payroll calculations. Acted as functional contact for all customizations and development related to benefits administration. Led preparation of functional design and configuration documents. Designed extensive and exhaustive functional test plans for system integration testing for base benefits

HEXAWARE TECHNOLOGIES, Iselin, New Jersey, Upgrade Consultant, Cingular Wireless Services (Contract), 2006. Managed impact analysis on retrofit activities for SQR, application engine, file layout, workflow, and component interface. Modified vendor interfaces for sending AT&T information from Peoplesoft 8.9 environment. Maintained direct client interaction for collecting upgrade activity requirements. Performed impact analysis and designed solutions for PS 8.9 interface to third-party vendors. Ensured effective coordination with business and testing team. Created detailed functional specification, technical design, and unit testing for client requirement. Performed change control activities to proper migration of objects across instances.

HEXAWARE TECHNOLOGIES, Iselin, New Jersey, Techno-Functional Consultant, Cingular Wireless Services (Contract), 2005-2006. Conducted analysis on data conversion activities between AT&T wireless system and Cingular Wireless system. Developed process for merging AT&T employees’ information into Cingular Wireless system. Designed interfaces for sending AT&T information to vendors from Cingular systems. Maintained direct client interaction for collecting conversion activity requirements. Led impact analysis and designed solutions for data conversion activities. Completed analysis of customer requirement. Managed development, testing, and implementation of new enhancement requirements from client. Oversaw fit gap analysis for new customization requirements.

HEXAWARE TECHNOLOGIES, Chennai, India, Techno-Functional Consultant, AT&T Wireless Services (Contract), 2004-2005. Provided direct client interaction for collecting enhancement requirements. Detailed functional specification, technical design, and unit testing for business requirements from client. Completed analysis of customer requirements. Generated impact analysis report on client requirement. Completed development, testing, and implementation of new enhancement requirements from client. Led development of time and labor reports and interfaces. Conducted fit gap analysis for new customization requirements. Prepared test plans, test cases, and unit testing. Offered and provided production support on Peoplesoft HRMS and payroll activities.

EDUCATION

UNIVERSITY OF NEVADA, RENO, Reno, Nevada, M.B.A, Finance, 2015

BHARATHIDASAN UNIVERSITY, Tamil Nadu, India, B.S., Engineering (Information Technology), 2004

CERTIFICATIONS

Oracle PL/SQL Developer Certified Associate

Oracle PeopleTools Application Developer Certified Expert

LANGUAGES

Fluent in English, Tamil

Contact this candidate