SUMMARY:

• Solid understanding of Database concept, SQL Server Administration, SQL, Data Modeling and Database related products.
• Over 10 years of PeopleSoft experience adept at implementing, upgrading, testing and supporting PeopleSoft applications, including FSCM, HRMS and CRM modules.
• Solid understanding of PeopleSoft Internet Architecture (PIA) administration, configuration and tools.

TECHNICAL SKILLS:

Database: Oracle 10g and 11i, SQL Server 2000, SQL Server 2008 R2, ODBC, BEA WebLogic 9.2, BEA Tuxedo, MS Access

Programming: SQL, T - SQL, PL/SQL, PeopleCode, SQR, PeopleSoft Query, HTML

Applications and Tools: PeopleSoft FSCM 9.0, PeopleSoft HRMS 8.9, PS Application Designer, Data Mover, nVision, Crystal Report, PeopleSoft Trace, TOAD, ftp Client, Oracle SQL Navigator, Oracle Client, SQLServer Enterprise Manager, SQLServer Management Studio, Microsoft FrontPage, Microsoft IIS, Microsoft SharePoint Designer, Telnet, Micro Focus COBOL, vpn and Remote Desktop, ADP EV4, WORKDAY (Saas), HP Quality Center 11

PROFESSIONAL EXPERIENCE:

Senior Data Integration Engineer

Confidential, Quincy, MA

Responsibilities:

• Convert PeopleSoft HRIS 8.5 to WorkDay (Saas). Responsible for data mapping for core PeopleSoft delivered tables to WORKDAY environment. Developed SQL scripts to extract, cleanse and load to target environment. Convert SQR programs and PS Queries to WorkDay reports using Report Writer. Document defects in tracking tools(SharePoint, HP ALM-QC11) and collaborated with business and development team to ensure functional requirements are met.

Java Application Support Engineer

Confidential, Natick, MA

Responsibilities:

• Provide first level software application support for external clients via vpn and remote desktop. Trouble shoot, resolved and documented customer issues. Maintained and monitor server software applications.

PeopleSoft Developer/Administrator

Confidential, Peabody, MA

Responsibilities:

• Created and maintained PeopleSoft Pure Internet Architecture (PIA), including Application Server, Process Scheduler, and WebServer (UNIX and NT). Defined portal’s process scheduler, Web Service and Integration Broker as required. Created multiple Process Scheduler instances for load balancing. Administered and troubleshoot all aspect of server issue as needed. Setup COBOL, nVision environment from PeopleSoft file servers. Created and modified security related to Roles and Permission as needed.
• Installed PeopleSoft Change Assistant and setup Environment Management Framework (EMF), and administered patches, updates and maintenance packs (MP) as required.
• Support PeopleSoft FSCM 9.0, including Billing, Account Payables, Account Receivables, Inventory, Cost Accounting and other modules. Support PeopleSoft HRMS 8.9 includes Self-Service module and ADP payroll interface.
• Responsible for PeopleSoft HRMS 8.5 to 8.9 upgrade and later assisted in UNICODE database conversion for multi-language HRMS, applied multi-language PeopleTools and Language Packs (French, Danish and Simplified Chinese). Involved in PeopleSoft Financial upgrade from 8.x to 9.0.
• Developed and modified custom pages and other components as required. Created and modified SQR, Application Engine, PeopleSoft Queries and Crystal Reports as needed. Diagnosed error process using PeopleSoft trace tools and contact Oracle ‘My Oracle Support’ as needed.
• Compiled Micro Focus COBOL as required in both Windows and UNIX environment. Installed multi-language PeopleBooks and Verity for FSCM and HRMS. Created Archive Objects and used Data Archive Manager to archive Vendor Masters, Customers and CM Accounting Line data.
• Installed Oracle client tools and established connectivity to databases via ODBC. Evaluate SQL Server 2008 R2.

PeopleSoft Technical Analyst/Database Analyst

Confidential, Malden, MA

Responsibilities:

• Created and maintained SQL Server 2000 DTS to transport PeopleSoft production data between an Informix database and an Oracle database. Performed routine DB backup/restore and monitor job streams.
• Created and maintained SQL Server Stored Procedures and Triggers to steam-line routine processes. Managed database privileges to users in various environments.
• Managed PeopleSoft CRM installation and configuration activities, including three major PeopleSoft upgrades spanning from version 7.5 to 8.8. Communicated with the PeopleSoft Service Group to resolve HelpDesk tickets related to PeopleSoft systems.
• Developed and modified PeopleSoft Objects including PeopleCode, application engine, and user interface components. Used Application Designer to setup PeopleSoft tables. Teamed with functional analysts to develop PeopleSoft module reports using SQR, Crystal Reports, and PeopleSoft queries.
• Identified gaps between business requirements and delivered vendor applications. Proposed system redesign solutions and enhancement options to effectively close the gaps. Worked closely with Project Management Team and stakeholders to ensure successful system integration and fast issue resolution.
• Installed PeopleSoft Workstation, Oracle client and established ODBC connectivity for users.

Junior SQL Server DBA/PowerBuilder Developer

Confidential, Boston, MA

Responsibilities:

• Installed and support SQL Server in development, test and production environments, established ODBC connectivity to databases and monitor system performance. Grant privileges to users to access systems and databases.
• Developed and maintained scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically. Monitored server performance, database and transaction log growth and error logs.
• Running imports/export utilities, off-line backup, on-line backup various SQL server Applications utilities. Created and maintained DTS packages and used BCP utility to transfer data between SQL Server databases.
• Planned and implemented various Transact-SQL statements, cursors, stored procedures and triggers.
• Designed, developed, tested and deployed five major client/server applications for internal customers using PowerBuilder 4.0 and 5.0.02. Migrated PowerBuilder code for all applications from version 4 to 5, then from version 5 to 6. Conducted auditing and modification for all PowerBuilder applications for the Y2k compliance.