Uploaded File
add photo
Mayor
mayorconsulting@yahoo.com
773-236-5640
Chicago, IL 60827
Systems Programmer
7 years experience W2
0
Recommendations
Average rating
11
Profile views
Summary

Experienced and highly motivated IT professional with 6 years plus of supporting next-generation Database Applications in Oracle, SQL Server, and MS Access. An oriented Systems Programmers who excels at learning quickly and meeting or exceeding expectations. I have excellent communications skills, ability to grasp new concepts, and effectively assimilate relevant information from several sources within limited timeframe. I am self-motivated and possess ability to prioritise, multitask and manage time effectively as a team leader, part of a team, or individually. Installation and configuration of Oracle software and Microsoft SQL server tools.

  • Experienced in creating database users, assign required privileges, grant tables, grant permission, and roles to business end user, also to maintained database security. creating backup policies for database users and system databases. performance tuning of Oracle database and Microsoft SQL server database. Oracle PL/SQL, SQL scripting, comfortable reading, executing, and developing.
  • Setting up equipment for employee use, performing proper cable management etc.
  • Ability to work efficiently and accurately in a fast-paced working environment. EMPLOMENT HISTORY

Experience
Systems Programmer
Information Technology
Sep 2019 - present
Chicago, IL
As a key component of the Platform care team, I am responsible for reviewing, analyze, develop, install, modify, migrate, and support major subsystem software components in the company large computing environment across multiple production data centers. Represent as Oracle Super User with the ability to perform data extraction for Migration, data manipulation and table creation for database migration or data import and export into Cloud Environment. remotely and hands-on Microsoft Windows operating system administration, folder structures and file server changes.
  • Accessing Oracle database with industry standard tools for data migration into Cloud environment.
  • Responsible for Data Migration from Sub-System (Legacy) into Cloud environment or systems (AWS).
  • Responsible for application Supports during Data Migration Go-Live and Implementation.
  • Managing system applications (Image Center), user Security, integration, and workload automation built on Oracle ERP and Utilities applications.
  • Utilize Oracle advance tools (ICView) for data migration from Legacy systems into Cloud environment
  • Installs, maintains, and supports operating systems and/or its components and subsystems.
  • Analyze and provides technical support for a production processing applications system.
  • Provides technical assistance to implementation team in analyzing application errors, performance issues, and consumption before and after Go-Live migration into the Cloud Systems.
  • Support processing and scanning systems, Rimage, I-Tran, and Data Center systems and Applications.
  • Utilize Vice versa for File Transmission Workflows, File Folder Structure and File Servers.
  • Creates and maintains complete documentation as it relates to Data migration status and support.
  • Other related tasks assigned as needed.
Data Center ERP Oracle Windows
Remove Skill
Application Service Supports
Information Technology
Feb 2018 - Aug 2019
Chicago, IL
I provided level 2 technical and applications support for customer's on company Transportation Management Systems (TMS), on company web applications at customer service request. Communicate with customers on update, upgrade, and policy impact. Troubleshooting end users web applications interface, extract, manipulate, and configure needful data within database application systems for customers' business usage. Working with customers, vendors, and various internal stakeholders to ensure web applications, company TMS, and databases meet business requirements.
  • Routinely run SQL scripts on SQL Developer or TOAD, to ensure data accuracy and compatibility for database application systems, and Transportation Management Systems (TMS).
  • Extract, manipulate, and configure needful Master Data into database systems for business usage.
  • Execute PL/SQL procedure, and manage routine operations and transactions on Oracle databases.
  • Provide customer support for business applications, and internal request on JIRA ticket issues.
  • Collaborate with developers to Support and maintain web applications developed on Java/J2EE.
  • Support business consultants, customer reps to discuss EDI creation, usage, and other sources.
  • Utilize KIBANA to monitor log files, web applications and database transactions error.
  • Resolving and storing JIRA ticketing issues into Release Management (RM) for Backup, Archival, and Disaster Recovery on production and clone database systems.
  • Complied with company operations and security procedures by participating in all control functions.
  • Executing Master Data files and scripts for business and supports requirements.
  • Daily upload Master data into database system per customer and internal request for business use.
  • Monitor database server through Linux OS for TMS applications implementation.
  • Troubleshooting TMS software and hardware applications for customers transaction and usage.
  • Execute PL/SQL procedure to set up new users and grant access into the company TMS applications.
  • Attend bi-weekly meeting to contribute to team effort and accomplished related results as needed.
Linux SQL
Remove Skill
Database Operations Support
Information Technology
Jun 2016 - Dec 2017
I work with business end users on data warehouse transformation and migration activities, to conform with existing Oracle and SQL Server database landscape. I participated in developing function specification for data extraction, transformation, and loading (ETL) for a new data warehouse. I also assist with data reports generation for business usage on Oracle Business Intelligence (OBIEE).
  • Performed data manipulation, data integration, and data extraction from company RDBMS.
  • Analyze user needs and develop software application reports from Back Office Operations.
  • Building and maintaining SQL queries scripts for data analysis and data extraction.
  • Querying Oracle database engine with SQL*Plus and SQL Developer to generate reports.
  • Working with development team, vendors, and various internal stakeholders to ensure all reports meet documented requirements.
  • Creating and executing database report queries as requested for business use.
  • Debugging and maintaining exiting code on C#, and VB.Net applications.
  • Routinely run SQL queries to ensure data accuracy and compatibility with data reporting.
  • Managed existing PL/SQL scripts to manipulate data from RDBMS for development team.
  • Analyze data in a newly developed data warehouse, to ensure accuracy and quality assurance.
  • Data entry tasks with development team for conversion to the new developed systems.
  • Analyze data contained in the database for data accuracy and integrity of various reports.
  • Utilize Microsoft SQL Server and SQL Server Management tools to developed reports.
  • Developed reports with Oracle Business Intelligence (OBIEE) for business end users, and developers.
OBIEE Oracle SQL SQL Server
Remove Skill
Database Management - INTERNSHIP
Information Technology
Jan 2015 - May 2016
Belleville, IL
As a student, I support areas of design and administration of the Oracle database. I work directly with Senior Database Developer and Administrator. I perform Oracle Database Administration on Oracle Enterprise Manager 11g and 12c, on RMAN, SQL*PLUS, RAC, ASM, SQL Developer, Windows, and Linux.
  • Installation and upgrade of Oracle software and creation of user defined databases.
  • Creating backup policies for user databases and system databases.
Database Backups DBA Oracle
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Information Technology, Information & Data Security
Governor State University 2022
Information Technology, Database Development & Management
Southwestern Illinois College 2017
Management Information Systems
National Institute of Information Technology 2010
Certifications
PROFESSIONAL CERTIFICATE
Certificate, Database Administration (DBA)
CompTIA A+
Skills
Oracle
2021
3
SQL
2019
2
Data Center
2021
1
Database Backups
2016
1
DBA
2016
1
ERP
2021
1
Linux
2019
1
OBIEE
2017
1
SQL Server
2017
1
Windows
2021
1
Awards
role privilege permission to inexperienced users of the database, 0
Performed daily incremental backup and full weekly backup using , 0
Analyze manipulate develop generate and extract needful data fro, 0
Run SQL query & scripts on SQL Developer or SQL Plus to ensure d, 0
Handled multiple projects and meet deadlines provided weekly sta, 0
Managed and developed PL/SQL procedure function and packages for, 0
Monitoring Oracle systems health supporting functional Oracle is, 0
Monitoring and optimizing SQL Server and Oracle database perform, 0
Maintain database integrity user security and overall database p, 0
Utilized database tools to ensure full coverage of the applicati, 0
Maintained and performed database repeatable process and associa, 0
TECHINICAL SKILLS, 0
Technician Skills: Windows OS Linux OS. Installation of a Server, 0
Programming & Database Skills: Java Programming SQL Oracle PL/SQ, 0