SUMMARY
Self-motivated, dedicated, business focused, skilled professional with 19+ years of IT experience as project manager, administrator, leader and team member in designing, planning, developing, supporting and implementing solutions that facilitate company growth.
OBJECTIVE
Obtain a position where I can utilize my technical, functional and business expertise to create solutions that help make business decisions quicker and easier and aid in the next business objective
TECHINICAL EXPERTISE
ERP SYSTEMS
PeopleSoft HCM / HRMS, FSCM / Financial, EPM, Portal
DATABASES
ORACLE, MS SQL Server, MySQL, DB2, Access
OS / RELATED
Windows, HP-UX, Red Hat Linux, Oracle Linux, Ubuntu, Citrix, AIX, Virtual Box, VMWare Client / Server, MS-DOS, F5 Big IP,
PEOPLESOFT
Administration, Implementation, Upgrade, People Tools, Application Designer, Data Mover, Application Engine, People Code, PS Query, PeopleSoft Configuration Manager, Enterprise Components, Tree Manager, Excel to CI, Change Assistant, Upgrade Assistant, PUM, SES, PTF, Integration Broker, Environment Management Hub, PeopleSoft Security, SSO, LDAP Integration, Performance Monitor, Process Schedulers, Application Servers, Tuxedo, XML Publisher, Version Control and Change Management
FUNCTIONAL KNOWLEDGE
Core HR, Benefits, Time and Labor, NA Payroll, General Ledger, Account Payable, Account Receivable, Travel and Expenses, Procurement, Project Management, Program Management and Project Costing
WEB SERVERS
WebLogic, Microsoft IIS, Apache, Web Sphere, Tomcat
PROGRAMMING
People Code, SQR, COBOL, PL/SQL, Visual Basic, C, C++, Java, JavaScript, HTML, XML, PHP, Batch
SCHEDULING / MONITORING
BMC CONTROL-M, MARIMBA, REMEDY Monitoring, Jenkins-CI/Hudson-CI
CHANGE MANAGEMENT/ VERSION CONTROL/ DEFECT TRACKING TOOLS
HPSM, Clear Quest, HP Quality Center, Remedy, Quest STAT, PHIRE Architect, CAPI, CVS, Clear Case, Sub Version
BUSINESS PRODUCTIVITY TOOLS
Microsoft Office, Microsoft Project, Visio, Case Wise, Primavera, Lotus Notes
EXPERTISE
Leadership, Motivation, Teamwork
System Design and Development
Integration and Technology Development
Project Management / Coordination
Strategic Planning and Analysis
Time Management and Analytical Skills
Quality Assurance and Audit Control
Business Process Design
Communication and Interpersonal Skills
Creative Problem Solving Skills
Development/ Production Support
Fit-gap-analysis / Requirement Gathering
EDUCATION Bachelor of Science Degree in Computers Science, Andhra University, INDIA
PROFESSIONAL EXPERIENCE
PROJECT MANAGER / DESIGN LEAD, Richmond, VA (March 2016 – Current)
Key Accomplishments and Contributions
Design a creative club and mobile app which helps consultants and employers in sharing the information
Managed day to day activities project team members, planning, organizing and assigning work to technical team
Managed project plan, risk log, issues log and project team meetings, created status reports and performed other project related project management office activities
PS SYSTEM CONSULTANT, DOI-BLM, Boise, ID (Dec 2013 – Jan 2016)
Key Accomplishments and Contributions
Independently Supported PeopleSoft HCM9.0/8.49 application, WebLogic, Tuxedo, Servers, PeopleSoft Internet Architecture (PIA) and Developers and Production environments
Managed project plan, risk log, issues log, conduct stake holder meetings and project team meetings, created status reports and reported to program managers
Created/Maintained PeopleSoft Upgrade Project Plan (HCM 9.0 to HCM 9.2) and successfully Upgraded HCM Application/People Tools from HCM 9.0/8.49 to HCM 9.2/8.53
Installed new PeopleSoft Internet Architecture (WebLogic Webserver, Tuxedo, PTF, SES and XML Publisher) in Windows 2008 servers, SSL certificates from SHA1 to SHA2 and migrated the code trees, firewalls rules, security.
Performed Initial, MTP and final passes independently and support developers in every aspect.
Created a process for migrations according to Change Management Standards.
Perform/maintain database backups and refresh training environments on weekly basis.
Applied Oracle Security/Quarterly Patches and PeopleSoft Patches using PUM (PeopleSoft Update Manager).
Generated initial alter audits and worked with developers in identifying all the objects that needs to be retrofitted.
Worked with third party agencies and configured the Integration Broker and SSL authentications and configured Barracuda firewall rules to fit the business needs
Load/Modify/maintain/execute Change Assistant template as required for the environment.
Monitored Performance of Oracle/PeopleSoft application and tuned accordingly.
Trained new resource on PeopleSoft Support, maintenance and administration and prepared documentation.
Provide tracking and resolution of problem reports, Review OS event logs, backup logs, database logs, application logs and web server logs ensuring availability and reliability of system and database environment.
Provide technical/application expertise in the assessment and resolution of operational system incidents and technical issues and generated monthly reports.
Loaded customized PeopleSoft OVM template on OEL and added additional packages for client demo needs and used this as source for Training purpose/PeopleSoft Update Manager (PUM) Source.
Configure Oracle GRID, STANDBY database, perform DR exercise and day-to-day Oracle DBA activities.
Created agency support website using open source CMS, migrated content from old html website to new CMS website and configured/maintained security and other features
PEOPLESOFT CONSULTANT/SPECIALIST, Capital One, Richmond, VA (Jan 2012 - Apr 2013)
Key Accomplishments and Contributions
Design, build, configure, debug and support the PeopleSoft technical architecture for various environments of the Financial/Supply Chain Management, Human Capital Management, Enterprise Portal Solutions
Perform PeopleSoft Administration and application DBA duties, to include environment refreshes, upgrade, tuning, applying tax updates, PeopleSoft patches and Maintenance Packs to Finance, HCM and Portal environments.
Administer and effectively manage over 36 development, test and productions environments with over 140 application server domains and process schedulers domains on multi load balanced, highly secure virtual server environment and involved in performance turning and network configuration
Manage and Load balance Application Servers, Process Schedulers, Web Servers and architecture and Support 1TB+ Finance, 400GB+ HCM production environments, integration testing, performance testing, QA, test and development environments and Monitor Performance and provide metrics
Configure and maintain SSO, Integration between Finance, HR, and Portal and troubleshoot application messaging.
Scheduled PeopleSoft Jobs in Control-M, altered the existing jobs sequence, troubleshoot and monitor the logs.
Support PeopleSoft Payroll, Time and Labor module implementations, HSBC Integration, PeopleSoft code migrations and perform SOX and internal audits to monitor change control procedures and access controls
Participated in meetings and Involved in designing Functional specifications and User documentation for Time and Labor rules. Assisted functional users to create and modify the Business requirement specifications for rules.
Assisted to categorizing and establishing workgroups based on employee’s duties, jobs, departments and unions. Defined workgroup defaults and options.
Created Rule Programs. Added and Prioritized rules with in a Rule Program. Assigned Rule Programs to the related workgroups.
Developed Holiday Rules (Holiday Taken and Holiday Banked) for Full time and Part Time employees. Developed Exception Rules for Holiday, Over Time reporting hours
Assist with disaster recovery, capacity planning, release planning, firewall and security configuration activities
Provide feedback and suggestions to management for process improvement and critical metrics.
Work with various groups within the IT organization (Operations, Network & Security, development and Business System Analyst teams) to analyze security and existing infrastructure, recommends modifications that will enhance application performance and provide a stable and secure environment
PEOPLESOFT CONSULTANT/SDLC SPECIALIST, IBM, Richmond, VA (June 2008 – Dec 2011)
Key Accomplishments and Contributions
Installed PeopleSoft Internet Architecture on new Linux and windows servers and involved in Migrating and upgrading HCM 9.1, FSCM 9.1 and Portal 9.1 applications from old architecture to new architecture, upgrading and migrating Oracle database from 10g to 11g on HP UNIX servers.
Designed and implemented a load-balanced, multi-server PeopleSoft environment, tuned and load tested
Provided full technical support for migrations within PeopleSoft, implemented new business process, trained multiple teams on change to speed up the releases and minimize downtime and created oracle triggers to grant database security to tables and views also automatically which were being picked by PeopleSoft alter audit which is lacking in new people tools version and to support the new business process.
Managed PHIRE Architect implementation project independently, implemented PHIRE Architect, performed data mapping, loaded and migrated data from Quest STAT to PHIRE Architect, taught PHIRE Architect application to business users and technical teams and decommissioned Quest STAT which saved around 200K/year on license and support costs alone + infrastructure costs.
Decommissioned PeopleSoft Version Control System Quest STAT and Rolled out PHIRE Architect independently.
Cross trained support teams on day-to-day activities and developed support manual and prepared Software Configuration Management Plan (SCMP) document
Analyzed legacy system’s (Personal Payroll System) Time and Labor process along with Functional analysts for Fit-Gap analysis.
Developed Functional and technical requirements and worked with vendor on code changes and fixes
Gathered requirements and developed workflows and implemented CMMI Standards.
Provide on-call production support to PeopleSoft and Case Wise applications, provide operational management of the application support and manage service escalations (incident, change and release management).
Involved in upgrading the agents on servers, setting/testing BMC Alert set ups for PeopleSoft/PeopleSoft Internet Architecture (PIA) and resolve when not responding.
Assist in the administration of IT Controls to protect the confidentiality, integrity, and availability of files and processes running on the systems they administer and provide reports to IT Audit Team who manages Information Assurance and Security Compliances.
Worked on Functional and Technical specification documents for conversion of Budget balances and Budget detail journals load.
Responsible for design and development of Ledger import for Budget ledgers from existing system into PeopleSoft Commitment Control using File Layout and Application Engine process.
Created Interface for AP Invoices using Integration broker.
Created conversion programs to covert Budget beginning balances and Budget detail Journals using SQR and Budget journal import process.
Involved in setup of Budget definitions, Department and Fund Code tree setup
Worked on enhancements using People Code, Application packages, File Layouts and Application Engines.
Worked on converting GL Journals from existing system to PS using Journal Import process.
Responsible for loading cross walk tables.
Developed Reports using XML Publisher.
Worked on performance tuning processes.
Worked on developing test cases and test scripts and performed in system, integration and performance testing.
PEOPLESOFT SUPPORT LEAD / STAT ADMINISTRATOR, IBM, Richmond, VA (June 2006 – June 2008)
Key Accomplishments and Contributions
Provided full technical support for developers and migration teams within PeopleSoft
Administered Quest STAT and effectively managed over 48 development, QA and Productions environments on 52+ Windows, Linux, HP-UX and AIX servers
Involved in decommissioning PeopleSoft EPM and implementation of OBIEE which replaced EPM functionality
Support PeopleSoft Security and configure/fix PeopleSoft Security in all PeopleSoft environments
Scheduled Enterprise Jobs and adhoc jobs on Control-M servers and monitored PeopleSoft related jobs
Performed fit-gap-analysis of PHIRE Architect Product and provided information to management
Created functional requirements and developed them using People Tools Application Designer
Gathered Requirements and implemented new workflows to support new reorganization structure and CMMI Service Standards
Worked on Voucher errors to resolve issues and Worked on Voucher mass updates from Check to EFT and vise-versa
Support Finance Production GL, PO, AP, AR, AM and HRMS Application modules.
Responsible for workflow configuration for HR application and Involved in HRMS, Portal and Finance upgrades
PEOPLESOFT TECHNO-FUNCTIONAL CONSULTANT, Healthways, Nashville, TN (June 2006- June 2006)
Key Accomplishments and Contributions
Provided techno functional support to Time and Labor and Payroll modules
Gathered requirements and created new rules, modified existing TL rules to resolve production issues.
Setup and Modify Rule Programs, TRC’s, tested setup and performed migration to production environment
Wrote custom Report and created scripts to ease application maintenance on SQL Server 2005
PEOPLESOFT SPECIALIST/ STAT ADMINISTRATOR, Capital One, Richmond, VA (Apr 2004 – May 2006)
Key Accomplishments and Contributions
Provided support and migrations for PeopleSoft, STAT environments which are on Oracle and DB2 databases
Involved in implementation of PeopleSoft EPM, applied patches, configured and maintained security
Generate compare reports and analyze, participate in code review and Responsible for retrofit customization in to PeopleSoft Objects and file objects (like Record, Page, Application Package, PeopleCode, Integration Messages, AE and SQR).
Worked closely with developers and business analysts and maintain/troubleshoot the control-m jobs
Create and generate weekly release migration reports to management and sync them to all environments.
Created and administered Change Control Reporting process for Audit compliance.
Worked on Finance and HRMS application upgrade and People Tools upgrade and Oracle database upgrade to 11g.
Worked on resolving workflow issues in AP, PO and e-Procurement.
Worked on issues related to voucher creation, Payments, voids, positive pay, yearend processing and Bank Reconciliation.
Worked on custom process to archive Billing core tables.
Responsible for redesign of Return Payments fee transactions process to resolve duplicate transactions issue.
Worked on EDI Invoice load issues.
Involved in production support for AP, PO, AR, BI and GL modules.
Created technical design documents
PEOPLESOFT SPECIALIST, Capital One, Richmond, VA (Aug 2002 – Jan 2004)
Key Accomplishments and Contributions
Configure/Maintain PIA (WebLogic Webserver, Application Servers, File/DB Servers), perform environment refreshes and keep files/environment in sync across 2 different migration streams
Perform production and nonproduction migrations within PeopleSoft and in Quest STAT after implementation
Involved in code reviews and retrofitting, configuring LDAP groups for PS client delivery, software builds and testing
Implemented and supported QUEST STAT PeopleSoft version & Change Control Product and performed migrations
Configured PeopleSoft jobs in Control-M and running adhoc jobs on Control-M servers
Gathered requirements from business, technical, functional teams and designed workflows
Configure PeopleSoft Security and Object Security for Users, Maintain Integrity and Perform Audits.
Customized delivered Message and Message Channels, developed new Message and Message Channels
Involved in Positive Payment File Creation Process.
Involved in production support for AP, PO, AR, BI and GL modules.
Created technical design documents
Responsible for designing SSD’s (Solution specification documents).
Worked on Manager Self Service, Employee Self-service in HRMS
Responsible for design, configuration and development of workflow
PEOPLESOFT TECHNO-FUNCTIONAL CONSULTANT, Cingular Wireless, Dallas, TX (Feb 2002 – Aug 2002)
Key Accomplishments and Contributions
•Involved in Conversion from existing system into PS HRMS 8
•Developed Rules, Roles and Routings for Workflow
•Designed data mapping for Converting data in new system and developed SQR to convert Employee data
•Extensively used PeopleCode with Object oriented concepts like Rowset, RecordSet, Record, SQL Objects, and Arrays.
•Designed ApprovalRuleSets, RouteControl Profiles for Approvals up to 6 Levels and developed BusinessProcesses, Activities and Steps for workflow.
•Used Virtual Approval/Router functionality for approvals
•Updating the tables for e-Recruit for applying job, view job postings, Interview schedules and results. And e-Recruit Manager Desktop for creating the Job requisition, Job offer and Approval offer and preparing for New hire
•Designed, developed inbound interfaces from Mercer PRISM to populate e-Recruit,
•e-Compensation module tables
•Customized and developed Employee Self-Service and Manager Self-Service Pages like JobChange, Retirement, Termination, Bonus, Surplus, Leave Of Absence, Leave balances, W4 Page, State tax Pages with Request, Approval and Status Pages.
•Developed Component Interfaces to update database records after final Approvals.
•Developed Application Engine process for assigning timeout Worklists to Workflow Administrator/ Immediate Supervisor.
•Responsible for Design, Setup and Development of IVR Process using PS API (Application Programming Interface), Com BindingVisualBasic and C++. This process reads data from Third party Application VisualBasic/C++ and writes to PS Tables like TimeEntry (Elapsed Time), W4 Changes, Direct Deposit and W2 Reprint.
•Responsible for Installing External API and External client settings for the API, which builds PS driver files library files and Registry files for PS API.
•Involved in development of Application Engine process, which reads data from external systems XML files using File Layout functionality and PeopleCode. Valid records are inserted into staging tables and error records in error tables.
•Developed SQR Processes for Automatic Supervisor assignment, calculating grandfather retirement rules and sends e-mail to Supervisor.
•Developed Workflow notifications, which sends e-mail and Worklists to users, when New State tax data is added, Bargain-Unit/Union-Code is changed.
•Documented all the customization and development with unit test scripts.
•Created Dynamic rolls assignment process as a batch process using Application Engine, this process assigns roles like Employee self-service Manager Self-service.
•Developed an Application Engine process which creates New User Profiles for New hire and locks out Terminate or Retired employees profile and unlocks rehire employees user profiles and dumps processed data in staging process for reports.
•Responsible for design, development and testing of Employee Performance Evaluation with workflow approvals between Reviewing Manager, Approving manager and Employee Acknowledgement. Developed Component Interface process to update performance and Job tables.
TIME AND LABOR DEVELOPER, KPMG CONSULTING, Dallas, TX (Aug 2001 – Feb 2002)
Key Accomplishments and Contributions
Developed, Unit tested 52 custom TL Rules to support 16 Union Contracts across 50 states and 52000+ employees out of which 16 Complex Custom TL rules code was transferred to PeopleSoft Corp under code Exchange Program which got converted and delivered as core TL Rule templates in 8.3 version.
Worked extensively on Time Administration tuning and worked with PeopleSoft Customer Service to fix issues
Applied patches and bundles, reapplied customizations, promote them to production environment
Worked closely with Payroll and Call center employees to gather requirements and train users on time entry
Responsible for Configuring and customization of TCD (Time Collection Device) Interface, which uploads data from External Systems into PS using Application Messaging. This process reads data from CSV files processes and Publish message in Message Queue using PS FileLayouts and PeopleCode, then Subscription process subscribes to message and dumps in PS tables
Involved in configuring Time and Labor work groups, rule programs, rules, TRC, security and enrolling employees to TL and configuring payroll earning codes and pay groups, Performance testing, Tuning and testing TL and payroll
Gathered requirements and created functional specifications, developed application engine and flat file layout to load reported time on 3rd party time collection devices to TL
Responsible for Configuring and customization of TCD (Time Collection Device) Interface, which uploads data from External Systems into PS using Application Messaging. This process reads data from CSV files processes and Publish message in Message Queue using PS FileLayouts and PeopleCode, then Subscription process subscribes to message and dumps in PS tables
Customized delivered Message and Message Channels, developed new Message and Message Channels
Created new Application Engine & Component Interface program to move employees from some of the Jobcodes to another Jobcodes to make them qualify for new Pay Rate increase
Involved in Setting up Pasheets and Pay Calendar for Hourly and Salaried Employees
Responsible for Design, Setup and Development of IVR Process using PS API (Application Programming Interface), Com BindingVisualBasic and C++. This process reads data from Third party Application VisualBasic/C++ and writes to PS Tables like TimeEntry (Elapsed Time), W4 Changes, Direct Deposit and W2 Reprint.
Responsible for Installing External API and External client settings for the API, which builds PS driver files library files and Registry files for PS API.
EJB DEVELOPER, BBOX.net, Beaverton, OR (Dec 2000-Apr2001)
Key Accomplishments and Contributions
Developed JSP Pages for www.snapnames.com account management/domain acquire process.
Involved in developing the EJB’s that encapsulates the business logic of automatic expired domain acquisition
JAVA DEVELOPER, Digital Board Walk, Santa Monica, CA (Aug 2000- Oct 2000)
Key Accomplishments and Contributions
Developed Java Server Pages and EJB's for sports website and designed WAP pages for profile management
PROJECTS ROLES IN INDIA (1997-2000): JAVA DEVELOPER, VB DEVELOPER, ORACLE 2000 DEVELOPER