System Administrator Resume
4.00/5 (Submit Your Rating)
Fort Lauderdale, FL
Highlights of Qualifications:
- Ten years experience of analyzing, designing, maintaining and developing enterprise applications in Oracle (SQL, PL/SQL, Forms & Reports 2000 / 6i / 9i, Oracle database 8i / 9i / 10g) and Microsoft (Crystal Reports, SQL Server 2000), MySQL.
- Organize workload efficiently and work hard to accomplish tasks with high qualities
- Demonstrate rapid ability and strong desire at learning new technologies and job functions
- Liaison between technology and the business clients to improve business processes and support critical business strategies.
- 9 years experience in Lawson System Administration including successful implementation and upgrades.
- Participant of multiple companies’ mergers and acquisitions with emphasis on data migration and ERP systems integration.
- Communicate efficiently and interact well with business users, fellow workers, project leaders and managers
- Work calmly under high-pressure situations, and consistently meet deadlines
- Perform as a team player, and remain highly motivated and self-directed when working individually
- Have strong technical and analytical skills to be able to identify underlying causes of issues and develop effective solutions
Databases:
- Oracle (version 8i / 9i / 10g), MySQL (version 4 / 5.1), DB2. Database programmer and design, installation, analysis, normalization and tuning.
Tools:
- Oracle Forms & Reports 6i, 9i, Oracle Enterprise Manager.
- Designer 9i, SQL*Plus, SQL*Loader, Toad
- Crystal Reports
- SharePoint
- Expert with MS Office applications: Word, Excel, Outlook, Visio, PowerPoint, Access, and Project.
Programming languages:
- PL/SQL, SQL, Java, XML, Perl, MicroFocus COBOL.
Operating systems:
- Solaris (ver. 8, 9 and 10), RedHat (ver. 4 and 5), CentOS (ver. 4 and 5), MS Windows 2000, XP, Vista & 7, VMware Workstation (ver. 6),
February 2000 May 2009
Confidential,Fort Lauderdale, FL, USA acquired by Confidential,Beloit, WI, USA
ERP System Administrator / Developer
- Developed custom applications using Oracle10g Developer Suite. PL/SQL, Oracle Forms/Reports, triggers, pipes, functions and procedures. Used SQL*Loader and Toad.
- Involved in migrating warehouse database from Oracle 9i to 10g database.
- Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements. Used EXPLAIN PLAN, TKPROF to tune SQL queries.
- Administered Lawson ERP System. Subsystems: Finance, Procurement, Material Management, WMS, Distribution, Add-Ins, Process Flow, Crystal Reports.
- Programmed Data Interfaces that Exchange Lawson data with WMS, JDEdwards, Experian and CMS (Perl, PL/SQL). Prepared and performed data upload during 2 business acquisitions in 2006 and 2007. Prepared and performed data upload into AS/400 DB2 System in 2009.
- Designed and co-implemented of in-house Business Intelligence system and Branch Operating procedures (Java, Linux, Apache Tomcat, Ant, MySql, Oracle, Perl). Projects included Route Sheet System, Work Order System Cycle Count System and Customer Pricing Applications.
- Provided technical requirements, specifications and validation documents. Supplied test data and performed tests for developed projects. Ensure a high level of communication among the members of development team.
- Trained and supported business users
- Created ad hoc reports for management.
May 1999 December 1999
Saville System, Edmonton, Canada; Europe Division - Galway, Ireland acquired by Confidential,Minnetonka, MN, USA
Sr.Oracle Programmer
- Part of the Saville Europe Div. project teams, responsible for analyzing, designing, developing, unit-testing and maintaining the PL/SQL, Forms/Reports applications and involved in customization of Convergent Billing Systems for telecommunication clients. Examined to enhance applications and system performance.
- Environment: Unix, Oracle 8i, Oracle Financial, PL/SQL, SQL, TOAD.
October 1996 April 1999
Confidential,Kraków, Poland and Confidential,Dortmund, Germany
Jr. Oracle/C++ Programmer
- Software developer involved in various projects such as Warehouse Management System, Cargo center, Accounting and Billing. Follows the software development life cycle (SDLC) process.
- Environment: SAP, Oracle Financial, TOAD, Quantum Software, Stored Procedures, Crystal Reports, Visual Basic 6.
Education and Certificates:
Master of Business Administration
Master of Science, Computer Science
J2EE Java Development Course
Lean Six Sigma Green Belt