Roy Sam Email & Phone Number

Dallas/Fort Worth Area

4+ years of experience in PeopleSoft/DBA Administration. Worked with FSCM 9.2 / PT8.60.06 upgrade, HCM 9.2 /PT 8.58.10, Installed and configured FSCM/HCM latest PUMS Working as a primary administrator for Payroll integration process Working as a primary administrator for ASG Zena interface scheduler Working as a SQL DBA for ERP databases.  Expertise in installation, configuration, setup, and management of PeopleSoftInternet Architecture (PIA) environment. Excellent understanding of PeopleSoft Architecture including Web server,Application server, Batch server and Database servers and troubleshooting all production issues Creating, Installing and Configuring a Secure Socket Layer (SSL) Certificate on aWebLogic Server in a PeopleSoft environment. Having good experience in Application Designer, Data Mover, and ConfigurationManager. Created multiple Application server and Web server domains on separate hostsystems to access one database, an effective strategy for performance and tuning. Configuring the report nodes, servers for process scheduler and configuring theRen server as well. Configuring Integration Broker in PeopleSoft Applications. Expertise in PeopleSoft Project migrations from one environment to anotherenvironment using Application Designer. Experience in PeopleSoft Update Manager and PeopleSoft update images. Experience in configuring/handling Change assistant. Experience in applying Maintenance Packs, Tax Updates, CPU Patches and bundles. Experience in People Tools Upgrade/PeopleSoft Application upgrade. Experience in installation and configuration of Elasticsearch. Creating/managing PeopleSoft user profiles, privileges, and roles. Experience in Batch monitoring and troubleshooting batch related issues. Worked with Oracle support to resolve the PeopleSoft product issues. Knowledge of basic RDBMS (Oracle) and SQL concepts. Good presentation and communication skills to provide support to the customer.

Dallas/Fort Worth Area

• Migrated, Installed, Monitored and Patched, MS SQL 2008-2016 databases for BuySpeed Online (BSO), GIS, CAD, and City of Fort Worth custom database tiers using Red Gate Solar Wind and other tools.• Implemented and Maintained various maintenance plans across multiple tiers and servers with different backup and restore strategies to include transactional replication, automatic and manual failover, log shipping and development of COFW’s own in house database restore system (currently in testing).• Requirements gathering, develop and implement SSRS, SSIS, reports, stored procedures, advanced queries, views, triggers, functions, indexes, and clusters.• Performance tuning for application and database support across all tiers.• Rotating on-call DBA for all COFW database infrastructure.• Database Admin for basic data services such as User Access, Logins, Database Roles and Permissions across multiple tiers.• Provide DBA Support for ongoing BSO database issues and reporting including the critical Fiscal Year End process.

Dallas/Fort Worth Area

● Administrator BuySpeed Online (BSO) – Administer, Support, Maintain, and Develop the COFW Purchasing System. ● BSO user support requests and technical requests to fix errors in the BSO-PSFT transform and correct encumbrances.● BSO - SSRS Report request development.● BSO - Auditor and PIR data requests.● Team Leader SSRS / SSIS FY Year End Project – Develop and maintain Interface process and reports for critical COFW Fiscal Year End Process.● Team Leader SSIS Inventory Project – Develop and maintain monthly GL interface process for COFW.● Team Leader SSIS / QA Accounts Payable ACH Payroll project – Develop and maintain employee ACH request process and work flow for reimbursements.● Team Leader PCard Project – Develop and Maintain monthly PCard GL interface for COFW.● Team Leader SSRS Report Migration Project – Convert 300 reports from 5 servers to one SSRS 2012 server.

Fortworth,Texas

 Managing finance System Purchasing module - Supports administers, maintains and develops enhancements to the City's financial management system called Buy speed online. Leading Fiscal year-end process: - This is the very important project I’m handling every year, writing full code for managing all operations like Reqs, POs, Credit Memos and Invoices as part of Fiscal year-end Process Leading SSRS/SSMS/SSIS Projects: - Developed Many reports/Interface processes for ERP, Finance, and purchasing.  SSRS V12 Implementation Project: - Took lead for a project to convert all 2005 and 2008 SSRS reports (more than 300 reports) to 2012 version Developing and managing ERP Interface jobs for various applications like inventory, Payroll, and P-Cards. Developed and maintains an interface process for inventory to produce GL and summary report by Store procedure, SSIS Package and report.  Analyzing Budget issues and suggesting proper actions to be taken by users based on my research by checking Budget to Actual report in People soft and SQL findings in BSO. Special request /Audit process: - Pull the information for Reqs, Pos, Invoices, Receipts, and Checks by Special request for departments, users and management  Developing, Modifying and Implementing the Store Procedure, SSRS Reports, and SSIS Packages as per the Customer Requirement. Assisting ACH processes by validating data and flow of actions by SQL. Maintain and monitor the weekly process for handling OTV and their checks by Store procedure and SQL Job  Resolving Job failures and Database issues, Troubleshoot and problem solve in a BSO and ERP production environment Sending Memo to all Vendors and Users regarding City address change and BSO Upgrade: - Developed a customized integrated process with help of SQL and SSIS Package to send bulk emails to more than 31,000 people for recent city address change and Buy Speed Upgrade

Oklahoma City, Oklahoma Area

Government Organization

Kerala ,India

Doha , Qatar

Pune Area, India

Master Of Computer Applications (Mca)

Bachelor Of Computer Science(Bsc), Computer Science