Technical Support Analyst Resume
SUMMARY:
- Skilled IT professional with an expertise in Oracle and extensive experience working in Component Part Manufacturing and Inventory Control, Finance, Health and Safety, and Business Service industries. Leverages leadership and project management skills to work across technical teams and business units to develop and deploy IT solutions that respond to business needs across international and domestic teams, both remotely and in - person as needed.
- Business/IT Analysis & DesignApplication supportDevelopment & Testing ShippingEDIProduction Support Materials ManagementE-Commerce GatewayPlanning & Scheduling Systems & Program Design Systems Implementation Systems Migration Oracle Purchasing & ReceivingTeam Leadership Project Management Supply Chain ProcessesAnalyze root causes
TECHNICAL SKILLS:
Databases: Oracle 11g, 10g, Hadoop
Business Applications: FREENAS, VPN, Oracle e-Business Suite, Oracle ERP, R12, 11.5.10, OM, PO, INV, MRP, WIP, EDI, ANSI X12, 824, 840, 860,997, EDIFACT, EDIFACT, DESADV, APERAK, RECADV, DELFOR, DELJIT, Mercury Test Director, Remedy, PVCS, Quality Center, System Development Life Cycle (SDLC)Platforms: OpenVMS, Linux, HP HPUX, IBM AIX, SUN Solaris, MVS, Windows 7/NT/200x/XP
Languages/Development Tools: Unix Scripting, PL/SQL Developer, Oracle SQL developer, SQL* Loader, PL/SQL, SQL, SQL Plus, Oracle Discoverer, Net backup, Toad, FTP, Microsoft Office, Visio, MS Project, Foresight EDISIM, SQL navigator, Jira
PROFESSIONAL EXPERIENCE:
Confidential
Technical Support Analyst
Responsibilities:
- Transition Operations ownership to other application owners after transition to ITOC.
- Monitor previously owned systems to make sure continuity of systems and customer contacts are fully maintained.
Operations Support Analyst
Confidential
Responsibilities:
- Learn OpenVMS, an open source OS, without formal to support multiple legacy systems
- Primary and backup analyst for multiple critical systems in the EU space
- Support GM European pricing system (GMEP) daily production cycle, create Oracle ad-hoc repots
- Primary lead operations analyst, plan and implement migration from Russelsheim data center to Warren/Milford data centers with migration team for GM European systems.
- Developed system interface documentation, detailing inbound and out bound data file names, jobs, and sources for system interfaces.
- Operations system owner for multiple GM systems, Created or update system documentation for all systems, Change control lead for owned systems
Confidential
PL/SQL Developer
Responsibilities:
- Modernized UNIX scripts to follow Confidential standard UNIX template.
- Updated and executed existing UNIX work scripts to obtain reporting data for various clients.
- Modified ETL process and Oracle stored procedures to work with new client layout for dealer tradeshow questionnaire and prioritizing of hot customer lead data.
Confidential
PL/SQL Developer
Responsibilities:
- Create ETL processes and scripts to SQL load customer data to Oracle. Created Oracle stored procedures to derive run date and division from load file name. Created scripts to use “sqoop” to load Oracle ETL data to Hadoop database.
- Lead developer on Proof of Concept project to use Hadoop open source database to store customer data. Create multiple scripts to load data direct to Hadoop database, define external table structures in Hadoop. Customer approved Proof of concept and has approved additional ongoing development using Hadoop as a data warehouse for further dashboard development.
- Execute ad hoc requests for data extracts and data deletions as required by customer tickets in Jira system.
Confidential
Oracle Business Analyst
Responsibilities:
- Technical relationship management role, managing activities of 3rd party technical resources for Oracle Sun hardware environment.
- First level system administrator, monitored and maintained Oracle Solaris server hardware daily.
- Member of five person IT staff responsible for general IT issues in addition to Oracle support.
- Provided system, user, and security administration for the Oracle environment. Provided daily production support for Oracle system modules Order Management, Finance, Manufacturing, inventory.
- Prepare for Sox Audit and provide data requested for Sox Audit compliance in the ERP system.
- Member of hardware migration team to upgrade and replace outdated servers, responsible for testing EDI connectivity, configured and tested scan gun hardware to ensure connect to new environment.