Summary:

• Proven Technical lead with experiencein delivering complex projects that involves full life cycle implementation, customization upgrade and support of PeopleSoft Applications such asCore HR, Compensate Employees and self-service MSS, ESS , Applicant,eBenefits, ePay, ePerformance,North America Payroll, Top 100, Enterprise Performance Management and Bolt-on Relocation, B-net, Medical Invitations, Common Salary Review, Year End Process
• Over Eight years of experience in ERP Application Development using PeopleSoft and RVW 2.0
• Proficient in People Tools such as Application Designer, Application Engine, Upgrade Assistant, Maintain Security, File Layout, Component Interface, Process Scheduler, Tree Manager and PS Query
• Extensive knowledge in developing and customizing reports using reporting tools such as SQR and Crystal Reports
• Adept in handling upgrade projects such as PeopleSoft Finance and HRMS Application upgrade from 8.9 to 9.1
• Conversant incoding complex Stored Procedures, Functions, Views and Triggerinvolving T-SQL to store and retrieve data from SQL server 2000/2005 and Oracle 9i databases
• Experienced in working with Huntington Business Solution HBS system for managing employee timesheet and leave management
• Planned and architected business applications such as HRMS, Payroll and Tax modules using Ramco Virtual Works RVW

Technical Skills:

• Reporting Tools PeopleSoft Query, SQR, Process Scheduler, N Vision, Crystal Report VI
• Development Tools Application Designer, PeopleCode, Application Engine, Process
• People Tools People Tools 8.51/8.49
• Web Technology ASP.NET, XML
• Languages C,C , VB.NET, JAVA, J2E, JSP, Servlets, Java Beans, JDBC, Java
• RDBMS Oracle 9i, MS-SQL Server 2000 / 2005
• Operating System Windows XP/2008/7, Linux
• ERP Package PeopleSoft HRMS 8.9/9.1, PeopleSoft FIN 8.9/9.1, RVW 2.0
• Supportive Tools Visual SourceSafe, Quality Center 9.2, Salesforce, SharePoint

Professional Experience:

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Responsible for creating PID Project initiation document , and establishing business process flow for the Self Service ESS and MSS , Compensation and Bolt-on Modules
• Migrated Employee leave management from Accrual leaves to Paid Time Off PTO methodology in HBS system
• Handled creation of Company Branch Department CBD , Establishments, Job code and security mapping in Tree Manager
• Resolved critical issues on portal solutions Pagelets by working closing with the end user
• Optimized Application Engine which improved the process execution time to complete in 20 minutes
• Automated to receive monthly file directly from vendor usingSFTPmethod and there by improved overall customer experience
• Enacted SQR to fetch terminated employees details and attached the script to SQR nightly batch process
• Validated Workflows to send emails for both Delegation and Job Change Request sections in Manager Self Service
• Established workflow for sending email notification to supervisor for approval when a user modifies their communication preference
• Customized SQL views, records and PeopleCode functions comprising SQLExec and Scrollselect
• Troubleshot and resolved locked/ABEND Application Engine program issues by analyzing state and temporary tables
• Proposed and identified the solutions to operate with minimum developments and operational efficiency
• Prepared Runbook which defines all processes involved in Employee self-service, compensation and Bolt-on modules
• Liaison and communicated with team to develop and conceptualize the requirements of clients
• Participated in deep technical discussions on various modules with peers which enabled the team to resolve issues within SLA

Environment:: PeopleSoft HCM/EPM 9.1 application, People Tools 8.51,Oracle 9i, Windows 7, UNIX, Process scheduler, SQR reports, HBS, Salesforce

Confidential

Senior Peoplesoft Engineer

Responsibilities:

• Led the People Tools upgrade from 8.49 to 8.51 which involvedapplying numerous customizations and reengineering non-functional components to streamline business processes
• Improvised PeopleCodeto use SQL.Fetch instead of SQLExecfor efficiency and emphasized the usage of delivered functionality to exclude absolute customization
• Modified custom SQR reports and processes by including new fields and modified table joins to for better error handling
• Worked with Oracle to obtain a patch for critical issue related to component buffer in PeopleSoft delivered code
• Identified the requirements and customized objects for retrofitting during PeopleSoft upgrade using Fit/Gap analysis, Keep/Drop analysis and Compare Report for General Ledger GL , Accounts Payable AP , Account Receivable AR , Purchasing PO , Asset management AM , eprocurement eProc modules
• Provisioned Business Units, Ledgers, Ledger Groups and Bank accounts and also created Accounting and Journal entry templatesfor PeopleSoft upgrade project
• Owned the critical issue identified during SIT/UAT testing phase and facilitated the team to find the root cause and resolve it
• Identified test scenarios and prepared technical specifications, test data for unit and system integration testing
• Refined the performance of SQR programs and various processes by defining it in Process Scheduler
• Devised the queries by adding to query tree for providing the results in nvision report
• Involved in development phase meetings for Business Analysis and requirements document reviews for vendor management
• Strategized, planned and developed the operations for Vendor Management module and executed them to generate desired results
• Customized the dispatch Purchase Order process and setup AWE for purchase order approvals
• Resolved post production support issues during upgrade project which led to meet the efficiency within SLA timeline

Environment: PeopleSoft FIN 8.9/9.1 application, PeopleTools 8.49/8.51, Oracle 9i,Windows 7,Process scheduler, SQR reports, N-Vision, PS Query, Salesforce

Confidential

Peoplesoft Developer

Responsibilities:

• Analyzed high level requirements for HRMS PeopleTools upgrade from 8.49 to 8.51 and led the project
• Performed Impact and Fit/Gap analysis on HR, Benefits Administration and Payroll modules for adding enhancements, customizations and retrofitting
• Extensively used PS Query for developing Ad-hoc reports for Employee Self-service module
• Owned the standardization of field and record names in SQR and met the standards of PeopleSoft 9.1 delivery process
• Proposed and implemented customized workflow notification in work list/email templates to meet the critical business requirement
• Developed new SQR programs to generate flat files by extracting the payroll related data from PeopleSoft HRMS database
• Simplified the naming standards for customized objects to minimize impact on PeopleSoft objects
• Audited the data consistency periodically between PS query and Oracle database data to meet the highest level of operation standards and significantly reduced production issues
• Worked closely with end users on user acceptance testing and thereby enriched customer experience on final product
• Enhanced the consistency of retirement notifications in Application Engine process by factoring Employee Birth and Service Dates in retirement calculation
• Trained business users and provided go-live support

Environment: PeopleSoft FIN 8.9/9.1 application, PeopleTools 8.49/8.51, Oracle 9i, Windows 7, Process scheduler, SQR reports, PS Query, Quality Center

Confidential

System Analyst

Responsibilities:

• Automated the new candidate hiring steps in recruitment module such as generating Interview letters, Employment Offer letters etc. using XML Publisher/SQR which enabled the client to hire more candidates in short period of time
• Prepared design documents summarizing the design sessions, scope, table set up values, business process flows and strategies
• Generated SQR report for payroll team to provide employee information and benefits
• Integrated vendor details into Payroll System and Accounts Payable module using SQR
• Designed Application Engine Process and modified SQR to calculate Retirement indicators based on Employees Birth Service Dates
• Created new component interface and Application Engine and automated the modification of employee job code and pay scale for internal transfers
• Analyzed PeopleCode and Application Engine trace to resolve PeopleCode and Application Packages issues in Employee and Manager Self-service work flow transactions
• Conceptualized the globalization of Job Codes which paved way to standardize the Position Management Information based on Global Job Codes
• Debugged and improved user experience on SQL/SQRs by analyzing performance related issues using Load lookup and Arrays
• Supported customers in generating Ad-hoc reports using PS Query for department salaries, salary plans, deduction, Benefit Programs, salary change Report and salary Mass Updates
• Provided on-call support to payroll functional team to quickly resolve any issues during initial project rollout phase

Environment: PeopleSoft HRMS 8.9 application, PeopleTools 8.49, Oracle 9i, Windows2008, Process scheduler, SQR reports,Crystal reports VI, PS Query, SharePoint

Confidential

System Analyst

Responsibilities:

• Developed, Enhanced and Supported Indian statutory reports and Indian Taxes Modules using RVW 2.0 and Crystal Report VI as reporting tool
• Enforced the usage of constraints and Indexes on creating tables for better performance
• Extensively used DML scripts to perform modification tasks like Insert, Update and Delete data in database tables
• Analyzed stored procedures and queries using SQL Profiler to improve response time
• Performed negative scenario testing on Tax modules and identified complex problems that occurs rarely in production environment
• Created separate workflow for Employee grievance management and integrated it into global workflow
• Handled escalation for critical production issues on HRMS application
• Created Technical specification documents, Data Flow diagrams, ER diagrams, Dependency documents
• Mentored the junior engineers on the team and guided them to achieve success on their tasks
• Maintained Change control and Release Management processes of all database objects like Tables, views, procedures and Triggers etc. using Visual SourceSafe

Environment:: RVW 2.0 application, RVW tools, MS-SQL 2005, Windows XP, Crystal reports VI, Visual SourceSafe

Confidential

Programmer

Responsibilities:

• Optimized the design of HRMS application which paved the way for best performer award in response to highest level of customer satisfaction
• Integrated external web applications to RVW 2.0 in order to generate reports after designing Screens as per customer requirement
• Embedded rule sets within the stored procedure to determine eligibility in reimbursement module
• Configured pay rules, pay groups, pay quotes and pay calendar for Payroll module in Ramco Virtual Works RVW
• Coded the web user interface html,.js to upload the images and documents to Ramco Virtual Works RVW
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool
• Build and maintained SQL scripts, indexes and complex queries for data analysis
• Used bulk processing for better performance and easy retrieval of data as a part of performance tuning on stored procedures
• Conceptualized Workflow routing / e-mail notification for Employee Self-service module in HRMS application
• Created Functions and Triggers for the validation of input data to proactively catch errors and meet the optimum business standards
• Supported customer in deployment of deliverables in HRMS and Tax modules
• Customized the template and stored procedure in staffing module to accommodate their unique requirement in generating Offer Letter and Appointment Letter for new recruits
• Designed and generated monthly medical benefits reports claimed by employees using RVW 2.0 and Crystal Report VI as reporting tool
• Setup regular meetings with clients and served as point of contact to resolve critical issues and requirements proactively

Environment: RVW 2.0 application, RVW tools, MS-SQL 2000, Windows XP, Crystal reports VI, Visual Source Safe