PATRICIA RUGGLES

• Create requisitions for internal orders and purchase orders into Oracle Financials for projects.
• Ensure material is processed to correct accounting categories and coded properly for vertex taxation.

Environment: Oracle Financials, WATTS, UET

• Produced monthly reports using advanced Excel spreadsheet functions, which help management with employee performance reviews.
• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Utilized data visualization tools to effectively communicate business insights.

• Troubleshot issues with websites and fixed scripting and use issues which produced a more user-friendly interface with Chapter members.
• Configured and purchased domains for websites.
• Conceptualized, planned and executed original designs for wide range of website properties.
• Maintained exceptional customer service ratings for company on Francisco Garces Chapter website.

• Created/modified over 1000 SQL Queries via TOAD data modeler and exported data from Oracle into Excel for periodic and exception reporting; creating various types of graphs and summaries which helped the system run more proficiently.
• Prepared and presented reports to management on purchasing trends and cost savings to aid in decision making.
• Conducted spend analysis to identify cost-saving opportunities.
• Created and maintained portfolio of qualified vendors to expand options.
• Managed database of vendor details and pricing information to maintain organization.

• Counted and distributed daily tills to Cashiers prior to opening windows for customers, which helped them start there day efficiently, responsibe for Petty Cash requests, updated case files with latest information.
• Responded to inquiries from callers seeking information.
• Composed sensitive, confidential reports and documentation.
• Managed records and data transfer, ensuring traceability and improving operations through automated systems.
• Updated Family Services court cases with latest information
• Processed efficient and accurate customer check-out including cash, check and credit cards.
• Counted and balanced cash drawer with accuracy as cash handler
• Handled customers while providing high standards of efficiency, accuracy, and consistency.
• Prepared daily deposits.
• Updated case files.

• Provided spiritual guidance, emotional support and direct care to residents, family members and staff which helped raise wellness and spiritual guidance.
• Provided spiritual care through visitation, counseling, and prayer.
• Met with individuals, discussed issues compassionately and determined appropriate type of involvement to meet spiritual needs.
• Comforted family members, offered attentive listening and high level of emotional support.
• Led programs such as worship, study, fellowship, and service opportunities.
• Interacted with local community, building relationships with civic organizations and other churches.
• Self-motivated, with a strong sense of personal responsibility.

• Exported/Imported data to/from Oracle, MS Access and Excel for periodic and exception reporting; creating various types of graphs and summaries, which helped users and management make important business decisions.
• Produced daily and weekly reports – account movement, Service Tickets matrix reports and cost center spending
• Conducted design reviews and collaborated with customers, stakeholders, and end-users in developing, implementing and maintaining internal database applications per design for easy transitioning.
• Lead on all phases of Software Development Life Cycle (SDLC) for IT Security, Finance, IT support to include appraisals, writing project plans, heading design reviews, writing test plans, and writing end-user documentation
• Collaborated with customers, stakeholders, and end-users in developing, implementing, and maintaining internal database applications per design specifications as directed by Project Team Lead.
• Responsible for managing all phases of Software Development Life Cycle (SDLC) on multiple projects to include appraisals, writing project plans, heading design reviews, writing test plans, and writing end-user documentation
• Created data models, stored procedures, reports, database routines and maintenance plans.
• Responsible for monthly deliverable, which included data loading/downloading from/into various sources, such as Excel or other data systems.
• Created UNIX batch processes to automate database maintenance activities for backup, restore, and optimization of object store repository.
• These batch processes freed up traffic on server; allowed for faster system response time for end users; production initiatives were met, and productivity increased by 55%.
• Configured, modified, and maintained workflows for IT processes.
• Project Lead and System Administrator for BMC Remedy Ticketing System and System Center Service Manager 2012 R2 Ticketing System.
• Created, modified, and maintained workflows for IT processes using NASA Access Management System
• Developer/System Admin for IT ticketing system using BMC Remedy with Oracle Database
• Developer/System Admin for IT ticketing system using Microsoft Service Request Ticketing Systems with SQL Server Database
• Modified Apex and ColdFusion front end of multiple software applications and Oracle/SQL Server database architecture, et al.: Budgeting Tool, Asset Management Tool, and NASA Dryden Personnel System.
• Successfully interpreted data to identify key metrics and draw conclusions
• Managed planning and development of design and procedures for metrics reports
• Developed new reports and delegate tasks to team members
• Successfully interpreted data to draw conclusions for managerial action and strategy
• Used statistical techniques for hypothesis testing to validate data design interpretations
• Presented data and conclusions to team to improve strategies and operations
• Proposed solutions to improve system efficiencies and reduce total expenses
• Conducted data modeling in coordination with finance department
• Collaborated with other departments to create scheduled and ad hoc reports
• Analyzed and tracked data
• Coordinated with staff to clean data in accordance with regulations
• Assisted in training of junior data analysts
• Worked on product life-cycle projects with engineering and development staffs.
• Responsible for several monthly reports submitted to management.
• Regularly updated company database programs to include new data gathering needs.
• Configured and maintained center’s ticketing systems, et al.: Microsoft Service Management Center System and BMC Remedy Ticketing System; Provided monthly Service Call matrix reports and other ad-hoc reports as needed using Crystal Reports, Excel, and SSRS.
• Managed all phases of Software Development Life Cycle (SDLC) for multiple software applications et al.: Logistics's SCLogic Shipping/Receiving module, and Microsoft Service Management System for Service Requests.
• Created data models, stored procedures, database routines and maintenance plans, UNIX batch processes to automate database maintenance activities for backup, restore, and optimization of object store repository
• Configured, modified, and maintained IT process workflows
• First point of contact for phone calls and emails from NASA Armstrong employees at Edwards AFB regarding IT issues and queries
• Handling Severity 1 & 2 issues up to Situation Management point of contact
• Client escalation process up to client owned status & resolution
• Escalate issues to different support teams which were out of scope for service desk
• Creating new credentials for users for NASA Armstrong hosted applications
• Administering, approving & escalating the flow of service requests
• Enabling and disabling global NASA Armstrong Employee Accounts across all Center domains
• Hands-on experience on MS Service Management Service Center and BMC Remedy for ticketing/page management
• Documenting changes and troubleshooting procedures to streamline the work process for quick tracking of issues
• Day to day operations involve ensuring high degree of responsiveness, customer satisfaction and adherence to project metrics
• Configure and install MS Service Management Service Center and BMC Remedy Software updates.

• Responsible for end-to-end design of customized data tracking applications for Finance/Budget Management Systems, and IT Vulnerability Systems
• Lead on all phases of Software Development Life Cycle (SDLC) for IT Security, Finance, IT support to include appraisals, writing project plans, heading design reviews, writing test plans, and writing end-user documentation which involved design reviews, project planning, and deployment.
• Responsible for end-to-end design of customized software applications for Finance/Budget Management Systems, IT Vulnerability Systems. Both tools have proven to be invaluable source of information for budget managers and IT security.
• Coordinated project design reviews, maintained project milestones, and Gantt charts.
• Maintained and monitored project plans, project schedules, work hours, budgets, and expenditures.
• Organized, attended, and participated in stakeholder meetings, prepared presentation materials.
• Documented and followed up on important actions and decisions from meetings.
• Ensured project deadlines were met.
• Made sure team had tools they needed to execute projects, created project schedules with milestones, due dates and estimates for materials that were required.
• Helped document every phase of project, as well as made summary reports and presented to organization’s management team.
• Worked with team members in field or on site who had project issues.
• Kept morale of team members and built relationships with them to develop a strong, cohesive working unit and supported their impact on success of every project

• Created, scheduled and organized project plans to implement SAP upgrade, and report information to project managers, project sponsor, and project
• These plans were instrumental in making upgrade smooth and easy transition
• Prepared SAP training tools via simulations and presentations for Finance, Procurement and Human Resource transactions
• I created SAP procurement training instructions for SAP Boot Camp
• SAP training tool became part of IBM’s intellectual capital and was used to promote SAP to potential customers
• Training tools were delivered on time to SAP training classes and were well received by trainers and end users
• Created scripts to store cookies for tracking student progression through SAP web-based training module
• WBT was part of IBM’s Intellectual capital and was used as training modules
• Modified/converted forms to newer versions
• This resulted in improved usability, leading to increased efficiencies.