Manager Data
Resume:
AFJAL KHAN P
PEOPLESOFT APPLICATIONS ARCHITECT / ADMINISTRATOR
EMAIL : ******@*****.***
TEL : 510-***-****
PROFESSIONAL OVERVIEW
Over 6 and half years of work experience in designing, Implement, deploying,
supporting and maintaining Peoplesoft financial, hrms, campus solutions, epm,
crm and portal warehouse applications on Oracle 10g and sql server databases.
Have got hands on experience to design, install PIA, application server’s,
batch servers and databases for development and production environment
infrastructures. Well versed with People tools application designer, data
mover, change assistant for updating/migrating updates and Peoplesoft objects
between databases. Experienced with applying tax updates on different
environments. Configured Peoplesoft users, single sign-on and maintained
Peoplesoft security. Supported integration broker messaging between
Peoplesoft applications. Have used etl tools ascential datastage, informatica
for loading data into epm system.
TECHNICAL SKILLS
PEOPLESOFT TECHNOLOGY (VERSION 8.4X, 9.0)
PeopleSoft PeopleSoft People Tools 8.40, 8,49, fin9.0,
HCMS9.0, 8.9, EPM9.0, 8.9, 8.8, Campus
Solutions 9.0, Portal9.0, Application Designer,
Change Assistance, PeopleSoft Security, Data
Mover, Application Engine SQR, Process Scheduler,
XML Publisher, Configuration manager, Process
Monitor, Query manager, Weblogic, Tuxedo
App.Server, Messaging technology Integration
broker.
Oracle BIEE, Hyperion Oracle BIEE, BI Server, Client, BI Application,
DAC Administration, BI publisher, Administrator,
Presentation server, Catalog manager DAC,
Hyperion9.3.1 Essbase, Planning, Reporting &
Analysis, FDM, Strategic Finance
Languages People Code, SQL, PLSQL, C/C++, Java
Reporting Tools SQR, nVision, Crystal / Query, XMLP Reports
Data Bases Oracle 10g, RAC, Enterprise Manager Grid Control,
MS SQL Server
ETL Tools Ascential Data stage, Informatica8.5
OS & Servers Windows 98, 2000, 2003Server / NT, XP, Solaris,
HP-UNIX, Linux, Java 1.5, BEA Tuxedo, Weblogic,
OAS, RAC, Cobol, VMware ESX Server, MS VSS and
STAT.
PROJECTS:
LexisNexis, OH May 2009 – Till Date
PeopleSoft Applications Administrator
PeopleSoft HCMS & Portal Implementation
• Install Peoplesoft HR, Portal; troubleshoot the weblogic connectivity with
application server issues.
• Installed & Configured Peoplebooks Multilanguage support for HR and Portal
applications.
• Configured & Troubleshooting the Report repository configuration settings.
• Configured XML Publisher, ExcelTO CI configuration setup.
• Installed Tools patch, Multilanguage Maintenance packs, for HR & Portal
Environments.
• Create & Configured demo, dev, test, config, uat and prod environments.
• Cloning and deployment of the development instances, create user profiles,
managed the user access to the application.
• Worked with audit reports, project migration between the environments.
• Installed and configured the Change Assistant, managed the process of
applying the MP’s.
• Worked with data mover to load data, update the database, worked with
Report repository configuration.
• Build the projects; give the component access to the user, page level,
read-only access.
• Configured Integration broker, gateways, load connectors, troubleshoot the
ping utility.
• Installed & configured the data model (ERDiagram) to view data dictionary.
• Working with security team to configure SSO between Portal & HR
applications.
• Environment: Peoplesoft 9.0 HRCS, Portal, Fin, PeopleTools 8.49.16, Oracle
10g, Server, Client, XML Publisher, Bea Tuxedo, WebLogic9.1mp3, Linux4,
Windows 2003 Server, Java 1.5, Putty.
NGB Inc, CA Feb 2008 – Apr 2009
PeopleSoft Applications Architect / Administrator
• Designed PIA architecture for load balancing and fail over, Installed
People Tools HCM, FIN applications and database Software.
• Design weblogic Peoplesoft instances, application server domains and
Process scheduler servers. Configured application server’s, web Logic pia
instance’s process scheduler servers and report repository.
• Created PeopleSoft databases, user profiles, roles and permission lists
• Refreshed PeopleSoft environment, project migrations, run audit reports
• Setup integration broker for messaging and troubleshooting errors.
• Involved in installation verification test (IVT), track the issues and
resolve them.
• Installed people books and configured help functionality.
• Tracing application server, batch server programs and pia pages.
• Monitor PeopleSoft processes through process monitor, run jobs, manage
reports repository.
• Reconfigure application server domains, batch server domains and Re-
installing pia architecture instance.
• Tested Jolt fail over and Created process schedulers and configured load
balancing through master scheduler.
• Installed Hyperion Essbase System9 server and clients, Administration
Server services, Administration Services, Reporting and analysis
• Configured and managed the Hyperion Essbase system9, Created new database
in Essbase system9, Application (outline), dimensions and members,
attributes and setting up the properties for the Outline
• Worked with Hyperion’s scripting language, understand the relation between
the dimensions and attributes
• Create, modify Dimensions, dimension member Formulas and Calc Scripts
writing, creating Rules files, assign the rules file to according to the
data file, Load data in to the Essbase database using the administration
Service Console
• Installed and troubleshoot the Excel AddIn’s for Hyperion Essbase system9.
Installed MS Office, Create, modify/customize the reports in excel
Spreadsheet, Administering setup of the Essbase on MS Excel and security
of users
• Worked with Sparse and dense, Hyperion Essbase system9 Block Storage
applications. Worked with Hyperion Server General Backups, and Recovery
• Worked with taking backup of Hyperion Essbase System, Starting shutdown
the Essbase Administration Server Services, Essbase servers accordingly.
• Environment: PeopleSoft 8.49, FIN8.8. 8.9, HR 8.9, SQL Server 2005 and
Oracle 10g, Hyperion 9.1.3, UNIX, Windows2003 server, Java, BEA Tuxedo,
and Weblogic server.
HWS Colleges, NY Oct 2007 – Nov 2007
PeopleSoft applications administrator
• Monitor and supported Peoplesoft fin, hr, epm, Campus Solutions, crm and
portal applications
• Configured ascential datastage server and Clients, Created dataStage
projects, importing dsx Files, ETL data loading, data mining, compiled
maps, loading data, resolve issues for the maps that failed, worked with
GSC to create support cases and apply the changes required for the maps.
• Support and providing assistance to the developer’s and PIA end users.
• Supported dev, test, training, configuration, qa, staging environments and
several developers.
• Installed Oracle Peoplesoft products, hr, fin, epm, Campus Solutions,
applications, and configured with the oracle database.
• Setup the Peoplesoft pub/sub settings, broker dispatchers, handlers, for
messaging, and manage async messages, Configured people books help.
• Created and configured the appserver domains for various databases and pia
instance configuration. Data file sizing and managed space allocation.
• Validated database objects, PeopleSoft tables, data synchronizations,
object definition synchronizations, update data and migrate PeopleSoft
projects between the environments.
• Regenerating/reconfiguring psappsrv.cfg file, reinstall pia after people
tools upgrades.
• Installed Micro Focus Net Express and compiled cobol programs Maintenance
of App, web, Batch (Process Scheduler) servers, Configured SMTP servers on
HCMS, CRM databases.
• Environment: PeopleSoft9.0 HCM, FIN, EPM, Campus Solutions, CRM and
Portal, People Tools 8.48, Win2003, Oracle 10G, OAS, Java1.5, BEA Tuxedo,
COBOL Micro Focus Net Express4.0, SQR Reports.
VC Technologies, NJ May 2007 – Sep 2007
PeopleSoft applications architect / administrator
• Designed peoplesoft architecture for web, application server and process
scheduler server layers. Configured application servers for load balancing
and fail over.
• Supported people tools updates, Configured change assistance and applied
patches, tax updates, ran audit reports and re-build records.
• Created peoplesoft databases, application server domain’s, pia, batch
servers and refreshed environments, establish connectivity for the
developer’s and PIA users. Managed cobol programs, nvision, Crystal and
SQR programs.
• Installed people books and configured help functionality. Configured
integration broker and supported messaging between nodes.
• Managed user profile creations, Roles, Permissions lists, security and
Single Sign-on, exporting security and importing security into refreshed
databases.
• Extensively used people tools application designer and data mover
• Environment: PeopleSoft8.8 Fin and HR People Tools 8.48, Tuxedo, Java 1.5,
Web Logic 8.1x, MS SQL Server2005, Windows 2003, SQR, Data Mover, Change
Assistance.
IBM India Pvt. Ltd Dec 2006 – Mar 2007
PeopleSoft applications architect / administrator
• Designed peoplesoft architecture environment for web, application server
and batch servers. Create peoplesoft demo, dev, test, config databases.
Established user connectivity and granted permissions for pia users.
• Installed Oracle server software and databases for Peoplesoft
applications.
• Supported developers for access to non production databases, object
migrations, manage operator security, define roles and permission lists
• Defined and documented the PeopleSoft DBA roles and responsibilities for
Financials and Supply Chain implementation version 8.4 Applied fixes
bundles and updates during Q & A testing
• Manage messaging between finance and hr applications, applied people tools
patches, refreshed databases, helped install nVision clients, rebuilding
objects and views, compiling Cobol programs
• Monitor job runs and debug job failures, open GSC support tickets, trace
programs for finding causes of failures and provide solutions.
• Environment: PeopleSoft8.9 HCMS, FIN8.8, People Tools 8.45, 8.47, Linux,
Windows2003/ NT, Oracle 9i, MS SQL Server2000 SP4, Java, BEA Tuxedo,
Weblogic 8.1SP3.
JOLT - Infosys Technologies Inc Sep 2005 – Dec 2006
JCPenney, Plano, TX
PeopleSoft applications architect / administrator
• Involved in designing a work plan of H/W and software for Peoplesoft Tools
and Application installs
• Architecting PeopleSoft internet architecture of web server, app domains,
pia sites, and designs the batch servers for running reports and defining
security
• Create operators, migrate projects, rebuild views, indexes and rebuild
cache
• Setup integration gateway, node configuration, portal content urls updates
• Assisted in troubleshooting application errors, Setup Multiple development
and testing PS instances
• Manage and controlled the configuration and application of patches/fixes
to PeopleSoft production environments
• Worked with LDAP directories, enabling sign on People Code for LDAP
authentication and establishing a secure LDAP connection between the
application server and the LDAP server
• Regenerating/reconfiguring psappsrv.cfg file, reinstall pia after people
tools upgrades
• Support design tools set for Enterprise Resource Planning applications.
Troubleshoot and provide solutions
• Installing Weblogic service packs, install pia as windows service, start,
stop, copy, move, delete pia servers
• Download the required the upgrade scripts, patches, documentation, release
notes
• Identifying the customizations, comparing with the latest release notes
• Involved in upgrade process of people tools, applied patches downloaded
from the customer connection
• Exporting and copying the projects, building the updated people tools
projects, loading the data, created views/triggers, Integration broker
setting, Updated security tables, password management, managed roles &
permission lists
• Worked with data mining tool to analyze the data from different aspects
• Creation and modification of Data Mover scripts, Data migration &
extraction
• Migrating projects across various environments, Running the SQR Programs
after upgrade
• Experience with applying Tax Updates on different environments as Demo,
Dev and Test db’s
• Managing/creating users profiles, privileges, roles and Permission lists
• Troubleshooting issues on PS related Issues, and Monitoring Dev, Test and
Prod Databases
• Setup pub/sub settings, broker dispatchers, handlers, recycle count for
messaging, manage async messages.
• Environment: PeopleSoft HCM, Fin 8.9, People Tools 8.47, 8.45, Windows
2003, 2000/NT, Oracle 10G, 9i, Java1.5, BEA Tuxedo, Weblogic8.1SP3, Data
Mover, SQR and MS Visual SourceSafe.
Vishwam Solutions, India Apr 2003 – Sep 2005
Peoplesoft Infrastructure Support Engineer
• Designed peoplesoft architecture for web, app and process scheduler
environments. Involved in installation of MS SQL Server software, created
seed database, and installed the PeopleSoft databases, Installed and
configured java for PeopleSoft HR and Financials application
• Worked closely with the developers to resolve the issues, Setup Multiple
development and testing PeopleSoft instances, Startup and shutdown the
Application, web and Process Scheduler Servers.
• Create operators, migrate projects, rebuild views, indexes and Tables,
Participated in the development of system design specifications for
production
• Resolve portal timeout errors, Setup gate way urls for application
messaging
• Creation and modification of Data Mover scripts, Data migration &
extraction, Migrating projects across various environments
• Installed and Configure the Report Repository for the reports to be
generated, Configuration PIA, app server, Batch server and load balancing
• Managed user creations, permissions and object security
• Generated a detailed listing of roles, permission lists and user profiles
used in the project and also according to the specific modules
• Fixing PS query corruptions encrypt decrypt passwords, grant roles
• Installing Web logic service packs, install pia as windows service, start,
stop, copy, move delete pia servers
• Installed and configured PeopleSoft People Books for PeopleTools, HRMS and
Financials
• Startup Shutdown the application, Batch (Process Scheduler) and Web
Servers depends of the requirement.
• Environment: PeopleSoft HRMS 8.8, FIN 8.8 People Tools 8.4x, MS SQL
Server2000, Windows2000/NT, Java1.3, BEA Tuxedo, Weblogic8.1, Data Mover
and SQR.
EDUCATION AND TRAINING:
• Bachelor of Computer Science and Engineering degree from JNTU, India.
Hyperion 9.1.3
• Installed Hyperion Essbase System9 server and clients, Administration
Server services
• configured and managed the Hyperion Essbase system9
• Created new database in Essbase system9, Application (outline), dimensions
and members, attributes and setting up the properties for the Outline
• Worked with Hyperion’s scripting language, understand the relation between
the dimensions and attributes
• Create, modify Dimensions, dimension member Formulas and Calc Scripts
writing, creating Rules files, assign the rules file to according to the
data file, Load data in to the Essbase database using the administration
Service Console
• Installed and troubleshoot the Excel AddIn’s for Hyperion Essbase system9
• Installed MS Office, Create, modify/customize the reports in excel
Spreadsheet, Administering setup of the Essbase on MS Excel and security
of users
• Worked with Hyperion Server General Backups, and Recovery
• Starting and shutdown the Essbase Administration Server Services, Essbase
servers accordingly.
OBIEE 10.1.3.3.1
• Install OLAP database software and create OLAP database, Install OBIEE
software and Applications, install ETL Informatica services.
• Configure Informatica admin console, connect to Source and olap database,
restore repository, Configure DAC client and import metadata, loading
Data.
• Publishing- bi publisher reports created from answers request and from bi
server, Developing reports and maintains formats, using it with bi
answers, delivers and dashboards, Adding bi xml publisher reports to
dashboards,
• Creating report layouts with bi publisher, DAC Server and Client
configuration.
• SQL Server 2000 and Oracle 10g, ETL Tools Informatica and ascential.
Contact this candidate