Customer Service Financial Systems

Roy Chris Rosales

**** ******** **.

Naperville, IL 60565

Cell phone: 630-***-**** Email: ********@***.***

Summary of Experience

I have 20 years experience in the IT Industry and Customer Service, much of which has been in diversified Systems Management,,conversations, migrations Analysis and Programming, on Marketing, Peoplesoft and Financial Systems. Additional work has been Maintaining and Enhancing Cellular Billing Systems, Financial Systems and implementing them along with and third-party vendor software pkgs previous experience includes five (5) yrs of working on developing and creating SQL and ACCESS Data Warehouse Databases, including SharePoint & Website content development and maintenance.

Technical Summary:

Software: EDS, SharePoint Content Manager, DB2 Data Base tools, Crystal-Reporting, ACCESS reporting, Oracle OBIEE-Dashboards and reporting

Vendor software: Microsoft Office, Excel, Word, WIN10, LOTUS Notes Database Design, DBS/AMPS Mfg. Pkg., FTP,SAP,MSA/GL & Financial Pkg. Application,, Enablon, ETQ, Database Products, Cobal, OBIEE-Oracle-BI-Certification,

Operating Systems: IBM Mainframe,MVS,JessII, JCL, ISPF,CICS, VSAM, DOS, OS2, AS/400, TCPIP,ODBC,OLTP, EDI, DB2, SQL7

Professional Experience:

Jan 2021 to April 2023 Allied University Security

Recruiter.

Contacted candidates from recruiting pipeline daily, sent emails to perspective

Candidates on interview conformation. Perform status in (ICMIS).

Scheduled Interviews base on the Operations Managers schedules.

Generated and submitted offer letters

Made appointments for finger printing and for Background on occasion did E-variations

Performed Candidate follow-up on applications status, fingerprints and Background. Attended and Interviewed candidates at career fairs.

Proctor / HR-Coordinator.

Duties include the setting class rooms for instructional learning, insuring laptops are pointing to proper Apps. Prepare overhead projectors insure they are functioning correctly and are at the proper modules depending on level of class percipients. Insure adequate supplies for students are in place. Monitor classes to insure proper flow continues answer any questions that may arise as it pertains to material being covered.

Hr Duties, Insure students are in proper class. Collect l I9 documentation as required by law. Updated status in (ICIMS) Insure docs are originals and valid make sure the finger print and background check forms are filled out correctly and after submit control numbers to IFDPR website for approval. Contact individuals with results. Insure all new employees’ fill out all On boarding docs and view office code of conduct video and answer questions that may arise. generate Identification card for new employees.

Sept 2012 to Aug 2018 Majestic Construction

Projects Coordinator

Negotiated contracts with vendors for projects.

Purchased dept laptops and work stations installed tracking software

Ran scripts for batch jobs and ran reports on project status

Setup ACCESS Database and Excel sheets to allow for more automated revenue acknowledgement and job flow of Materials per project and costs

Successfully managed multiple teams during residential multi family renovations.

Communicated with various vendors on workflow and schedules to assure on time deliverance.

Worked with owner to acquire bids from contractors for large scopes jobs.

Delivered blueprints to city municipalities for purpose of obtaining permitting.

Reviewed code requirements and allowances with city inspectors

Attended municipality inspections.

Nov 2007 To July 2012 United Air Lines

Database Administration.

Environmental Health & Safety Systems Analyst

Directed the EHS team in performing various tasks involving responding customer’s requests including SLA terms data mined various types of audit data to be imported into viable information

Performed upgrades to the Environmental Safety Quality Audit Systems by either inserting code or running upgrades to the system.

Ran SQL Queries for various types of data reports from the environmental data warehouse Access Database and at times creating different Access Databases and OBIEE Reporting.

Supported upgrades and maintenance to the United Environmental

Web Site, adding new pages when needed.

Designed and created the Voluntary Disclosure Database used by legal and QA dept. Maintain and support the ESSAP and EDS web base Audit Systems.

Audits were performed at all united stations and entered into the United ESSAP system, and then monitored for completion & closure of findings that may have been identified. .

The EHS-EDS is a web based audit system is used by United Auditors as well as external customers (consultants) to enter audits perform at the station. These audits are also monitored for findings completion.

Updated to tables and database are performed on regular base in response to Audit questions; company Surveys, changes to FAA or EPA regulations or changes in personnel & compliance.

Additionally, maintained current ground equipment Department website and SharePoint sites; oversaw the Department Budget (8.7 mil) was crucial. Assurance that there is no over charging, and that the budget is always within a plus or minus 10% of forecast per mo.

Generated accruals report and department forecast monthly and reported it the corporate controller.

Maintained the accurateness of Asset Management System, Purchase Order and Contracts System, Proposal and Assignment Order System. Duties also include those of the Audit Program Manager, monitor and track all Environmental audits perform at all United station by putting together and audit schedule and assign a qualified consultant to ensure that Environmental Audits are performed in an accurate, timely and safe manner.

Nov 1998 To Jul 2006.

Computer Associates Data Base systems Administrator

Supporting SQL 7, Ingres 2.5, 2.6, and 3.0 also supported the Db2 Database’s on Unix, Sun/os and Linux and Win2000 servers and IBM Mainframes. Our group also supported the development of existing applications groups,creating new databases, tables and performing all enhancements to existing ones.

We assigned logins, new user ids, Printer and Terminal Address, performed audits. Most Sizes of the databases range from 12 gigs to 300gig, ranging from 150 to 300 tables. Most of Ingres and Unix is command line level.

Coordinated database checkpoints, restores, Maintained, installed, and tested all new releases and fixes and provide technical support to the application Developers as needed. Evaluated third party software for use internally.

Feb 1996 to Nov 1998 Cincinnati Bell Information System, Itasca, IL

Sr. Programmer Analyst /CICS technical Support.

Lead role in stabilizing and installing large CICS/MVS environment, which consists of seven (7), CICS regions, over 300 VSAM databases and approx. 40 programmers who are responsible for developing large portion of the AT&T Wireless GUI system to interface with the CBIS mainframe systems. Additionally as a DBA, also performed all DASD and Database Management Functions required to ensure client server applications ran successfully with no down time to the customer. Mentored and trained Jr. level analysts on the processes of legacy systems, CICS commands, VSAM, IDCAMS and related database structures.

Responsible for training the Customer Service Reps of the department on the functionality of the Macro/Cell system. Prioritize and distribute the work assignments to members of the team in the local office. Maintain data integrity and ensure all Databases are current. Generate weekly reports for management for continued evaluation on “space availability” and “utilization”. Provided employee review input when required.

In the absence of upper management, assume responsibility for all departmental needs and the efficient and effective running of the Macro/Cell system as well as the Client Server applications.

March 1991 December 1993 Ameritech Cellular, Hoffman Estates

Manager Corporate Systems.

Reported to the Corporate Controller.

Managed the Corporate IT department which consisted of a multi-platform environment. Including Systems Administration of the AS/400 all on-line systems the ES9000 and the nightly production flow. Maintained staffing of both consultants and internal employees to ensure a smooth and consistent flow of mainframe and client server applications, as well as system operations. Negotiated new system release schedules, prioritized users service requests. Coordinated the design and development of new and existing systems. Prepared budgets, forecasting and planning of future required hardware.

Responsible, departmentally, for completing and validating all system releases. Worked with internal organizations and multiple business units to understand the customers requirements in order to develop the plans and manage the execution of the system test. Responsible for generating the annual reviews of 25 professional employees.

Education: A.S.S Degree in Computer Science Morton College

I.S.S Certif in Information Systems C D Institute

OBIEE/Dashboards/Reports training at oracle training center.

In Denver 2011

OSHA 10-hour Certification 2009

Contact this candidate