Information Technology Human Resources
Resume:
Shiva Banihashem
Plano, Texas
mailto:********@*****.***
SUMMARY:
• Fifteen (15) years of experience in Information Technology in the Analysis, Design, Development, Implementation, and Testing of business application systems (SDLC)
• Knowledge and experience in HTML, CSS, JavaScript, React, Redux, and utilizing Git workflow
• Knowledge and experience in C, and C++
• Four (4) years of experience in Data Modeling, Database Design, Development, Administration, and Production support for DB2 and Oracle Databases
• Three (3) years of experience in Unix and Shell scripts
• Experience in JavaScript
• Eight (8) years of experience in COBOL and SQR programming in mainframe and client-server environments
• Fifteen (15) years of experience in Performance Tuning Queries and SQL in DB2 and Oracle PeopleSoft Related Experience
• Two (2) years of experience in PeopleSoft Database management in Oracle
• Three (3) years of experience as Technical Lead in four (4) PeopleSoft HRMS Upgrade projects
• Eight (8) years of experience in customization and implementation, upgrade, security administration, and production support of People Soft 8.9/8.3/8.0/7.5/7.0/6.12/5.12/4.1 HRMS HR, Payroll, Payroll Tax updates, Base Benefit, Benefit Administration, Administer Training, Competency Management, Recruit Workforce, eApplications (eRecruit, eApplicant, eManager modules) using PeopleTools, People Code, SQR, PSQuery, Crystal Reports, Application Designer, Application Upgrade, Business Interlink, Application Engine and Component Interface
• Involved in the fit gap analysis and implementation requirements gathering based on functional requirements
• Excellent skills in creating HRMS Interface Programs based on design specifications between Application Systems and Peoplesoft. Skills in creating conversion programs from Legacy HR systems to PeopleSoft and vice versa.
• Strong Data Migration / Conversion experience from legacy systems to Peoplesoft systems and SQL Performance tuning
• Knowledge in PeopleSoft Open Integration Technology tools, Application Engine, Integration Broker, and Flat File processing using file layouts, Business Interlink, XML, Application Messaging, and File Processing
• Strong knowledge and experience in reporting and analyzing tools such as SQR, PS Query
• Three (3) years of experience in payroll tax updates.
• Experience in production support, troubleshooting, and resolving PeopleSoft HRMS problems
• Customizing application modules based on organizational needs and requirements.
• Worked on full-cycle Peoplesoft implementations, (technical development and enhancement of Peoplesoft HRMS)
• Involved in unit tests and UAT of the application. 2
EDUCATION
Algonquin College. Ottawa, Ontario BCS Degree in Computing Science (Honors) OTHER TRAINING
Lambda School. Silicon Valley, CA Jul/2019-Apr/2020 Full Stack Web Development Online Course
Learned to develop various web applications using HTML, CSS, LESS, JavaScript, React, and Redux. Wrote production-ready code using ReactJS, Redux, and CSS on the Frontend and NodeJS and Express on the backend to build Single page applications.
Environment: Windows 10, GitHub, Git Bash, NodeJS, Visual Studio Code, Codesandbox PeopleSoft PeopleTools 8.9/8.1Delta, PeopleTools I, II Security and Administration
Application Migration and Upgrade
DCI Building Distributed Client/Server Applications ORACLE Fast Track in Oracle database management
SQL Server Administration
Performance and Tuning
IBM Skill Dynamics SQL Workshop
DB2 Fundamentals
PLATINUM Technology Database Administration for DB2 Bachman Information Systems Model-Driven Analysis Techniques Algonquin College Project Management
AWARDS
Gandalf Award in computer technology
Digital Canada Award in computer technology
Curt Moser Mathematics Award
References: Available upon request
3
SYSTEM KNOWLEDGE
Software Life Cycle Implementation:
Front End Web Development using agile software development and Git workflow on all projects. Design original user experiences across a range of web and mobile platforms from ideation to wire-framing and to the final product.
Data Conversion programming, Data Mapping, Database Administration, Database Design/Testing, Disaster Recovery,
Environment Set-Up, Fit Gap Analysis, Production Support, System Design, UAT and, Unit Testing
Developing various Interface programs and reports
PeopleSoft Modules: Human Resources, Benefits Administration, and Payroll PeopleSoft Tools: Application Designer/Upgrade, Application Engine, Portal Business Interlink, Import Manager, Process Scheduler, Data Mover, Object Security/Operator Security, PeopleCode, PSQuery, Crystal, Workflow Administrator
PeopleSoft Application Experience:
Self Service, Personnel Administration, Compensation, Deductions, Recruitment and Positions Management, Earnings, Payroll, Base Benefits, Benefits Billing, Salary Administration, Upgrades, fixes, and Tax updates Software: People Tools 8.48/ 8.19/7.56/7.01/6.0/5.12, DB2, Oracle, Pl/SQL, Toad, GitHub, Visual Studio Code, Microsoft products
Operating Systems: Microsoft Windows 11/NT/XP, MVS/TSO, UNIX, Linux, Git Bash Computer Languages:
C, C++, XML, HTM, CSS, LESS, JavaScript, Java, React, Redux, API, SQR, SQL, COBOL, REXX, JCL, CLIST
4
EMPLOYMENT HISTORY
Midway Auto Group. Addison, Texas Feb/2009-Present Managing Family business assuming setting up an automated Auto Industry system for day-to-day operation from administration and security including maintaining and debugging the web and mobile app for the business Environment: Windows 11, QuickBooks, Autotrader, Financing RouteOne, Auto Raptor, IDMS for Auto dealership
March 1997/February 2009
JC Penney Inc. Plano, Texas PeopleSoft Consultant
Information Technology – HR Systems
HR/Payroll Compliance Projects
- Developed an Ad-hoc process to create Worklists for associates to sign FCRA and trigger Background Check transactions to be sent to the third-party vendor using Application Designer, PeopleCode, Portal, Workflow tools, and SQR program
- Developed and modified various SQR programs to create worklists for associates
- Modified various PS customized online HR applications using Application Designer, PeopleCode, Portal, Workflow tools
- Designed, constructed, and modified various SQR programs for HR/payroll system: Inbound, Outbound, and Data Conversion
- Provided technical support to resolve various HR/Payroll online and batch production issues Environment: Oracle 10.2/, PeopleSoft HRMS 8.9, Windows XP FedEx Kinko’s. Dallas, Texas
Information Technology – HR Systems PeopleSoft Consultant PeopleSoft HCM 8.9 Upgrade Project
- Provided technical support to facilitate the upgrade process of PeopleSoft HCM 8.3 to 8.9
- Analyzed compare reports between the customized PeopleSoft HCM 8.3 and delivered PS HCM 8.9,
- Performance tuning of customized and delivered Views/SQLs used in online and batch programs
- Participated in unit and user acceptance testing
- Provided production Support for HR system
- Made enhancements to the Payroll Audit Online and Batch system PeopleSoft Realtime Outbound Project
- Designed and developed real time, outbound interfaces for Self Service Job Requisitions, Applicant, Manager, and Recruiter modules using XML, Application Designer, PeopleCode, Business Interlink
- Designed and Developed batch, outbound interface for PeopleSoft HRMS Security using XML, Application Designer (Application Engine, PeopleCode, Business Interlink), and Process Scheduler 5
HR Data Conversion to PeopleSoft
- Designed and constructed SQR programs to perform data conversion for HR module converting Departments, JobCodes, and Employee Job records (Current and History information)
- Designed a process using SQR programs and Process Scheduler and Windows NT Process Scheduler to retrieve and convert information from Finance database and update PS HRMS database
- Developed PeopleCodes for Event-Driven payroll, batch interfaces Environment: Oracle 8i, Windows NT, PeopleSoft HRMS 8.3/8.9 Citizens Communications (Frontier). Plano, Texas Senior Analyst/Programmer Information Technology
- Designed and constructed SQR programs for HR, Payroll, and Benefit interfaces and reports
- Provided production Support
- Applied Tax updates and fixes to PeopleSoft HRMS.
- Customized various PeopleSoft online objects using PeopleTools and PeopleCode
- Responsible for PeopleSoft security administration.
- Developed Query reports using PeopleSoft Query and SQL Environment: Oracle, Windows NT, PeopleSoft HRMS 7.56/8.0 Parkland Hospital. Dallas, Texas
Information Technology
PeopleSoft HRMS 7.5 Upgrade project
- Designed and constructed SQR for data conversion, interfaces, and organizational reporting programs
- Provided Production Application Support
- Applied Tax updates to PeopleSoft HRMS
- Participated in upgrading and customizing SQR programs from PeoplSoft V6.10 to V7.54.
- Conducted parallel testing for HR and Payroll modules between PeopleSoft HRMS 6.10 and 7.54 Environment: Oracle 7.3/8.04, Windows NT, HP UNIX, PeopleSoft 6.10/ 7.54 Texas Instruments. Plano, Texas
Human Resources Systems
Benefits Billing Outsourcing /Profit Sharing Projects Texas Instruments Benefits Billing Project:
Designed and developed a process, using SQR, Unix (HP-UX), and JCL to gather benefits billing data from PeopleSoft HR and Benefit modules, and mainframe data files and, process, and reformat the data to be sent to the billing company.
Profit Sharing Project:
Designed and developed an SQR, Unix, and JCL process to calculate and pay profit sharing for Texas Instruments employees. This process interacted with and updated PeopleSoft Benefit and Pay Tables. It also created various 6
reports for the HR and Benefit group to determine eligible and non–eligible employees and the amount of Profit- sharing paid to each employee.
Environment: Oracle 8.04, Windows NT, HP UNIX, PeopleSoft 7.01 Frito-Lay, Inc. Dallas, Texas PeopleSoft Consultant Information Technology Systems
PeopleSoft HRMS 7.0 Upgrade Project
- Installed PeopleSoft HRMS 7.0 and set up client workstations
- Set up and maintained the security of PeopleSoft HRMS 7.0 databases
- Coordinated the upgrade of PeopleSoft HRMS (HR, Benefit and Payroll modules) from V5.12 to 7.0
-Upgraded PeopleSoft HRMS and PeopleTools Version 5.12 to 7.01and reapplied customization on HR, Benefit, and Payroll modules - provided support and guidelines to HR group to accomplish the PeopleSoft upgrade,
- Assumed Application DBA responsibilities: Creating and altering PeopleSoft database objects and responsible for HRMS 5.12 data conversion
Environment: MVS/TSO V5.2, DB2 V4.1, Centura SQLNetwork V4.01, Windows NT 4.0, PeopleSoft 5.12/7.0 Nationwide Insurance. Columbus, Ohio PeopleSoft Consultant Human Resources Information System
PeopleSoft 6.0 Upgrade Project
- Coordinated the upgrade of PeopleSoft HRMS from V5.11 to 6.0 assuming the following roles: Upgrading PeopleSoft HRMS V5.11, People Tools upgrade from Version 5.12 to 6.01.05, running and analyzing compare reports between the customized Peoplesoft HRMS 5.11 and 6.0 release, providing support and guidelines to HR group to accomplish the PeopleSoft upgrade
- Assumed Application DBA responsibilities: Writing UNIX and Oracle scripts for database backup and recovery, creating and altering PeopleSoft database objects
Environment: Oracle 7.2, Windows 95, UNIX System V 4.3, PeopleSoft 5.11/6.0, Windows NT 3.5.1 Government of Canada Analyst/Programmer
Jan/1993-Mar/1997
Citizenship and Immigration Canada. Ottawa, Ontario Information Management Technology Branch
PeopleSoft HRMS Implementation Project
Database Administrator
- Responsible for implementing and maintaining GOC release of PeopleSoft HRMS database on multiple Sybase 4.9.2 SQL Servers on HP UNIX
- Primarily responsible for installing and upgrading SQL Servers, performance tuning of SQL Servers and setting up backup and recovery procedures.
- Responsible for CIC HRMS data conversion, data mapping and loading PeopleSoft HRMS (HR, Benefit and 7
Payroll modules) databases using MS Access, Visual Basic, and PeopleSoft Import utility.
- Used People Tools to Customize GOC release of PeopleSoft HRMS objects and SQR programs PeopleSoft HRMS Upgrade Project
- Coordinated the upgrade of PeopleSoft HRMS V4.1 to V5.11 assuming the following roles: installing Sybase 11.02 and PeopleSoft V5.1, upgrading Sybase V4.9.2 to V11.02, People Tools upgrade from Version 3.23 to 5.12, running compare reports and migrating customized objects from CIC customized PeopleSoft database to GOC release of PeopleSoft 5.1
Environment: Oracle 7.2, Windows 3.1/NT, HP UNIX 9000 series, PeopleSoft GOC 4.1/5.1, MS Access 7.0, Visual Basic, ErWin, Banyan Vines
Revenue Canada, Customs and Excise. Ottawa, Ontario Information Technology Branch, DB2 Group
GST/TRANDS Projects
Goods and Services Tax system to collect and maintain GST information for Revenue Canada and Travelers National Database System collecting and maintaining information from all borders of Canada for all travelers DB2 Database Administrator
- Implemented and maintained the Travelers National Database in DB2, developed conversion programs in COBOL II to convert and load data into the Traveler National Database
- Developed and maintained a physical data model for TRANDS database in Bachman
- Technical support for the physical and logical GST (Goods and Services Tax) database components
- Responsible for the migration of GST database objects and DB2 utilities including BMC using PLATINUM Migration utility and Change Request System, an online enquiry system developed by Revenue Canada to be used as change management for GST systems
- Maintenance of DB2 procedures for Backup/Recovery
- Development of ISPF front-end for DB2 group to facilitate the maintenance of DB2 infrastructure Environment: DB2, MVS/TSO, ISPF Dialog Manager, CLIST, JCL, REXX, COBOL, PLATINUM utilities, Windows 3.1, Bachman
Contact this candidate