Sap Warehouse Management Technical Analyst Resume
Atlanta, GA
SUMMARY
Seeking to secure a position in the IT field that will enable me to utilize my education and experiences to better serve an organization.
Technical Skills Summary
- Database Development
- C/C++ Programming
- Access/Excel/MS Office 03-10
- Oracle 9i/SQL Plus
- Stored Procedure programming
- Database Management
- .Net/2.0
- SAP/SA400
- COBOL
- UNISYS
- Data Analysis
- UNIX
- WIN2000/07
- DBASE2
- SQL Server 2000-2008
Education
BS, Computer Science Technical Engineering Program
Computer Technician
Professional Experience
Confidential, SAP Warehouse Management Technical Analyst Atlanta, Ga 11/2009-Present
Preformed SQL Server Management tasks including:
- Trouble-shooting and manage SQL job and generating reports daily.
- Configure SQL connections using SSIS.
- Maintaining the health of the database integrity.
Supported various Manager with tasks associated with the SAP Inventory Systems including:
- Data input, clean-up, Report Development Data Mining and configuration.
- Document technical process, Analyze and validate the reports and work instructions.
- Representing the concerns of IT regarding inventory processes.
- Providing information and system support for year-end inventory, Audits using Excel Macros.
Supported and Maintain Crystal Reports for inventory and agency related statistics.
- Assist in updating, writing SQL Queries reports, and Crystal 8.5 to Crystal 11
- Assist with crystal reports writing and maintaining Crystal reports.
- Assist in configuring Crystal Reports for Data Link Viewer.
- Assist in training staff and configuring machines for Data Link Viewer.
- Assist in report creation to meet the ongoing needs of staff.
Provided general assistance and support with all software and hardware related departments using SAP Inventory management System.
- Trouble-shoot and install all software and hardware products to ensure working properly through LAN, WAN and pinging.
- Solved customers issues with products daily and Compose and produce reports, documents and related material.
Confidential - Infrastructure Analyst/Manager Oakwood, GA 03/2007 - 10/2009
- Participated in projects, attend meeting as needed to discuss concerns of IT regarding inventory processes, and Team organizations. Assisted with customer system problems, managed 100+ customer networks for Tier One Automotive Supplier.
- Participated in the development of departmental processes and procedures including ITIL and PMI based implementations. Maintained and developed software and hardware for production and time keeping systems. Served customers by providing product and service information; resolving product and service problems.
- Participated in departmental strategic planning, financial planning and maintained financial accounts by processing customer adjustments as required. Ensured data preservation for all critical systems files and prepared product or service reports by collecting and analyzing customer information, also resolved technical problems and referred irresolvable issues at the Helpdesk level to the appropriate escalation path.
- Worked with a variety of the phone company products and network integration services, including VOIP(Voice over Internet Protocol) SMDS(Switched Multi-megabit Data Services) , ISDN(integrated services digital network), video conferencing, routers, switches, network issues over LAN and WAN, TCP/IP, HTTP,FTP,POP3,SMTP,CPEs, Active Directories and multiplexers, Also resolved product or solved problems by clarifying the customers complaint; determining the cause of the problem; selecting and explaining the best solution to solve the problem; expediting correction or adjustment; following up to ensure resolution.
- Performed routine maintenance, Inventory Tracking using SQL and maximo system daily , monitoring and purchased computer, telecom, video equipment, various printers etc. Also created and maintain various databases using SQL PL,MS Office Suite applications such as Word, Excel Macros, PowerPoint, Access , Data Mining and Create Crystal Reports to assist in inventory updating, writing, maintaining, configuring and repair software installations, basic troubleshooting on printers, and Troubleshooting to resolve system problems and component hardware.
Technical Analyst-Confidential- Atlanta, GA 08/2003- 01/2007
- Performed data storage, security, integrity, preventive maintenance activities such as Troubleshooting, Data Mining, restores technical service and equipment issues by analyzing, identifying, and diagnosing faults and symptoms using established processes, scripts, and procedures; helps identify and analyze problem causes, patterns, and trends; recommends corrective action where appropriate; SQL Server, create crystal reports and performance management functions for relational Database Management Systems (DBMS) also Provided second-tier technical support and resolution of internal and external customers/users on auto-provisioning application problems; Performed data analysis for inventory systems using appropriate tools and system transactions such as AWACS system daily to support recommendations.
- Developed and maintained System and database documentation Log all incoming calls into problem-management database and help-desk systems; follows established procedures to document problems and recommends modifications to procedures as required.
- Designed and implemented databases and report distributions based on functional area priorities and needs using C++ Programming, Stored Procedure programming, Unix System(Solaris), SQL Plus, Excel, and MS Access.
- Communicated with management, technicians, and end-users to provides information and system support for year-end inventory and audit, development of automated solutions research problem, make recommendation for solution and repairs or rebuild systems to appropriate specifications.
Reporting Analyst-Confidential, Atlanta, GA 02/2002-07/2003
- Created several monthly statistical reports using Crystal Reports, Power Point Presentations, MS Excel/Access. Information utilized in budgeting, workload statistics and annual projections.
- Generated biweekly Payroll reports to monitor salary expenses against workload activity. Defining, documenting, and managing business/project requirements.
- Developed and supported database applications for the monitoring of revenue, workload and overall staff productivity and Marketed Company Services and attended Pre-bid Conferences. Also develop and introduce improvement projects.
- Updated data, importing and exporting data from data collector in multiple formats, and performed database normalization and indexing using CAD.
- Supervised of support staff in overseeing day to day operations
Analyst/Medical Records Clerk- Confidential, Decatur, GA 05/2001- 01/2002
- Developed and maintained MS Access/SQL database applications for the monitoring of patients clinical activity.
- Designed, debugging, enhancing, documenting, Troubleshooting and testing software applications to meet business process requirements using helpdesk software.
- Configured all servers and workstations to system requirements using Windows NT. Simulates or recreates user problems to resolve operating difficulties; recommends system modifications to reduce user problems.
- Performed statistical analysis by data mining and manipulating several different sources for submission to state regulatory agencies on a regular basis(i.e. weekly, monthly, quarterly, etc). Required adding performance data to existing files and transposing data from one file to others to complete the required analysis.