Application Systems Analyst Resume Profile
Professional skills
- Expertise in Client/Server Programming, ERP implementations, CRM applications, and Database Administration.
- Experience with complete software life cycle system analysis, design, testing, implementation and support .
- Highly enthusiastic and motivated with great communication skills
Technology
- Applications PeopleSoft Financials, HCM/HRIS/HRMS V 4.9 9.2, PeopleTools 4.9 - 8.54, Hadoop, EPIC, SAP Fico, Siebel V 99 2000, and Oracle Developer 2000, VBA, MS Word, MS Excel, MS Visio, Medical applications.
- Languages SQR, Pro C, SQL, PL/SQL, Java, Visual Studio, Ada, CORBA, C , C.
- Automated testing tools Load Runner, QTP 8.x, and Selenium.
- Systems Windows Visio, Vista, 8.x, XP, 2000, NT, and 98 , UNIX, SunOS, VAX/VMS.
- Databases Oracle 11.x, 10.x, 9.x, 8.x and 7.x , Object Store OOD , SQL Server, MS Access.
- TIBCO TIBCO Rendezvous v6.x, TIBCO Hawk 3.x, TIBCO Active Enterprise 3.x, TIBCO Portal Builder, and TIBCO MessageBroker.
- Reports Crystal, Oracle Reports, Actuate, nVision, SQR.
Experience
Confidential
Offshore Support: PeopleSoft Application Systems Analyst
- Involved in analysis, design, coding and testing Stages of development work for Educational Information System software for Schools, and institutions. Closely worked with technical team. The application also has parent access module.
- Setup database with seed data and System testing.
- Created custom module, SQR and Crystal reports in PeopleSoft application to accommodate access of legacy system data.
- Data mapping, denormalization and data migration from legacy system to custom module for panels and reports.
Environment: PeopleSoft V 9.0 9.2 Financials, HCM , PeopleTools V 8.52 - 8.54, Visual Studio, Java, Ajax, SQL Server 2008, Application Designer, App Engine, PeopleSoft Integration Broker, Component Interface, Secure Enterprise Search SES , PeopleSoft Report Manager, Process Scheduler, Crystal Reports, PeopleCode, SQR, Oracle 11.x, , Windows - XP, Vista, 8.x.
Confidential
Application Systems Analyst
- Involved in analysis, design, coding and testing Stages of development work for Educational Information System software for Schools, and institutions with. Closely worked with technical team. The application also has parent access module.
- Setup database with seed data and System testing.
- Created custom module, SQR and Crystal reports in PeopleSoft application to accommodate access of legacy system data.
- Data mapping, denormalization and data migration from legacy system to custom module for panels and reports.
Environment: PeopleSoft HCM V 8.0 -9.0, PeopleTools 8.52, PeopleCode, Application Designer, App Engine, PeopleSoft Integration Broker, Component Interface, Secure Enterprise Search SES , Security Administrator, PS Query, PeopleSoft Report Manager, Performance tuning, Crystal Reports, , SQR, Oracle 11.x, , Windows - XP, Vista, 8.x., Visual Studio, Java, Ajax, SQL Server 2008.
Confidential
Application Systems Analyst
- Analyzed, resolved, and documented errors caused by Interface servers from EPIC Health Information Systems to MUSE Cardiology Software to track EKGs . Configured EKG Machine GE MAC to accommodate new IP addresses and domain account login.
- Production support and admin tasks like roles, profiles and user creation MUSE, iVault, iSite applications.
- Data migration from application of Trace Master EKG machine to MUSE application.
- Worked on Xcelera implementation project. Coordinated with Networks team, Vendors, Server Operations, Data Center teams to get accounts, IP address, VPN Tunnel and training setup for the new servers and users.
- Researched and analyzed MRS application and documented workflow for 3 divisions within PAMF organization.
- Maintained SharePoint with current documents for IT imaging team.
Environment: MS Word, MS Excel, MS Visio, Project server, Medical applications EPIC, PCS, MUSE, MRS, PowerScribe , UNIX, Windows 2003 Server, Windows XP, SQL Server 2003.
Confidential
PeopleSoft Consultant HRMS
- Developed adapters for HR and Benefits modules which convert data from PeopleSoft HRMS 8.4 to Oracle 11.5.10 HRMS applications, using Oracle 11i APIs.
- Involved in functional and technical specifications and preparing documentation.
- Designed conversion methodology and data mapping.
- Configured Oracle 11i HRMS application to convert data.
Environment: People Soft 8.4 HRMS HR, Benefits , PeopleTools 8.52, SmartDB 10.x, App Engine, PeopleSoft Integration Broker, Component Interface, Secure Enterprise Search SES , PeopleSoft Report Manager, Oracle Database 9.x, Oracle Applications 11.5.10, UNIX, Windows 2000 Server.
Confidential
Siebel System Administrator/ Oracle DBA
- Successfully upgraded and migrated Oracle Database from 8.15 to 8.17 on Sun E450 to Sun E420.
- Responsible for 24x7 monitoring and fixing of problems with the Siebel CRM system and eSupport application and servers. Day to day administration of Siebel eCRM system including maintenance of tables, installation of thick and thin Siebel client software, and resolution of end-users requests.
- Enhancements to system as per user request, supported eServices application. Created and formalized backup procedure for Development and Production Oracle databases.
- Contributed towards the upgrade of Siebel system from 6.0.12 to 6.2.1.
- Installed TIB/Hawk and created rules to monitor production system.
Environment: Siebel V99 and 2000 CRM, VBA, TIBCO RV, TIBCO Hawk, Actuate 4.5, Oracle 8i, UNIX and Windows NT and 2000.
Confidential
PeopleSoft Consultant HRMS
- Developed custom panels, records, created and added fields to the existing PeopleSoft delivered record definition, process definitions, menu items and wrote required PeopleCode for the new panels to run interface programs.
- Performed database-related work like alter, create, truncate and drop test tables and fine-tuned SQR programs and SQL queries written by team members.
Environment: PeopleSoft HR V 7.5, Windows 98, Oracle 8.04, and MS Binder.
Confidential
PeopleSoft Consultant HRMS, Payroll, Base Benefits
- Developed custom panels, records, process definitions, menu items and wrote required PeopleCode for the new panels to run interface programs.
- Converted data from Legacy system Mainframe to PeopleSoft using SQRs, data mapping.
- Modified and enhanced SQR programs, crystal, nVision, Process Definition, run control panels, Menu items, and Panel groups created by programmers.
- Trained end-user to access and run new interface program.
Environment: PeopleSoft HR, Payroll, Benefits V 7.01, SQR 3.1, Crystal Reports 5.0, Windows 95, UNIX, Oracle 7.3.
Confidential
PeopleSoft Developer Analyst - Financials
- Responsible for the conversion of A/R and customer related data to store into Data Warehouse tables using SQR reports to deformalize and upload data.
- Wrote SQR programs to generate A/R Statement and Aging reports off data warehouse tables.
- Added PeopleCode to provide more functionality to the new/existing panels. Forum Fixes for Version 6.1 provided by PeopleSoft and enhanced PeopleSoft provided SQR programs for different Financials modules.
Environment: PeopleSoft Financials V 6.1, 7.0, and 7.5, Oracle Forms 3.0 and 4.5, SQR 3.0, Crystal Reports 5.0, Actuate, Windows NT 4.0, UNIX, Oracle 7.3
Confidential
PeopleSoft Consultant HRMS, Payroll and Benefits
- Responsible for technical and functional conversion of payroll data from ADP to PeopleSoft.
- Developed new SQR programs, and enhanced existing SQR programs to upload data to currently existing PeopleSoft Payroll and Benefit modules.
Environment: PeopleSoft V 4.9 and 5.11, PeopleTools, PeopleCode, SQR 2.5, Oracle 7.1, UNIX, Windows NT 4.0, and Novell Netware.