Roy Sam

Roy Sam Email and Phone Number

Senior PeopleSoft Systems Admin at City of Fort Worth @ City of Fort Worth
fort worth, texas, united states
Roy Sam's Location
Fort Worth, Texas, United States, United States
Roy Sam's Contact Details

Roy Sam personal email

n/a

Roy Sam phone numbers

About Roy Sam

Roy Sam is a Senior PeopleSoft Systems Admin at City of Fort Worth at City of Fort Worth. He possess expertise in software development, microsoft sql server, html, it management, ccna and 17 more skills. He is proficient in Arabic, English, Hindi and Malayalam.

Roy Sam's Current Company Details
City of Fort Worth

City Of Fort Worth

View
Senior PeopleSoft Systems Admin at City of Fort Worth
fort worth, texas, united states
Website:
fortworthtexas.gov
Employees:
2824
Roy Sam Work Experience Details
  • City Of Fort Worth
    Senior Peoplesoft Systems Admin - Erp, It Solutions
    City Of Fort Worth Jun 2019 - Present
    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.
    View
  • City Of Fort Worth
    Sr It Programmer Analyst \ Dba (Sql) - Database Design And Support , It Solutions
    City Of Fort Worth Oct 2017 - May 2019
    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.
    View
  • City Of Fort Worth
    It Programmer \ Analyst Ii - Financial Management Services
    City Of Fort Worth Dec 2014 - Sep 2017
    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.
    View
  • City Of Fort Worth
    It Programmer \ Analyst I - Financial Management Services
    City Of Fort Worth Feb 2014 - Nov 2014
    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
    View
  • Oklahoma State Tax Commission
    It Consultant
    Oklahoma State Tax Commission Sep 2013 - Feb 2014
    Oklahoma City, Oklahoma Area
    Government Organization
    View
  • Mz College Of Engineering
    Associate Professor
    Mz College Of Engineering Dec 2011 - May 2013
    Kerala ,India
  • Safari Group Of Companies
    Information Technology Analyst
    Safari Group Of Companies May 2010 - May 2011
    Doha , Qatar
    View
  • Tata Consultancy Services
    Information Technology Analyst
    Tata Consultancy Services Jun 2008 - May 2010
    Pune Area, India
    View

Roy Sam Skills

Software Development Microsoft Sql Server Html It Management Ccna Systems Analysis Java C# Database Design Microsoft Office Leadership Project Management Ssis Ssrs Business Intelligence Asp.net .net Visual Studio Vb.net Ssas 2008 Crystal Reports Oracle Pl/sql Development

Roy Sam Education Details

Frequently Asked Questions about Roy Sam

What company does Roy Sam work for?

Roy Sam works for City Of Fort Worth

What is Roy Sam's role at the current company?

Roy Sam's current role is Senior PeopleSoft Systems Admin at City of Fort Worth.

What is Roy Sam's email address?

Roy Sam's email address is ro****@****gov.org

What is Roy Sam's direct phone number?

Roy Sam's direct phone number is +181721*****

What schools did Roy Sam attend?

Roy Sam attended University Of Kerala, University Of Kerala.

What are some of Roy Sam's interests?

Roy Sam has interest in Social Services, Showing Initiative And Teamwork, Civil Rights And Social Action, Science And Technology, Human Rights, Health.

What skills is Roy Sam known for?

Roy Sam has skills like Software Development, Microsoft Sql Server, Html, It Management, Ccna, Systems Analysis, Java, C#, Database Design, Microsoft Office, Leadership, Project Management.

Who are Roy Sam's colleagues?

Roy Sam's colleagues are Thomson Sherri, George Blackwell Iv, Darron Buchanan, Thomas Taber, Paul Schmidt, Mica Jones, Dale Johns.

Not the Roy Sam you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.