Ms Access/excel Specialist Resume
Spartanburg, SC
SUMMARY:
- Successful IT Analyst overseeing all phases of IT infrastructure, hardware and software projects. Experience in scope planning, schedule development, legal research, corporate compliance, budget and cost control. Technical, operational planning, strategy development and application. Excellent soft skills, interpersonal skills, strong communication, presentation, analytical, and problem solving skills.
- Customer service driven, detailed oriented and great rapport working in a diverse, international team environment. Backed by strong credentials, ensures that projects meet business objectives and a proven history of on - time, on-budget, and high-quality project completions.
TECHNICAL SKILLS:
Skills: Advanced Microsoft Access, Excel and PowerPoint Advanced MS Windows and Office skills MS Visio, MS Project Management HTML5, CSS3, JavaScript, Java, VBA Reporting & Documentation; Develop and run complex queries and reports across systems to analyze, test, and validate data integrity; Develop and run complex queries and reports across systems to analyze, test, and validate data integrity Budgeting & Cost Controls; Strong analytical, organizational, and communication skills; Payroll/ Benefits SQL, SAP, ASP, SharePoint IT Consultant/ E - Learning Trainer Web Developer/SEO Writer Data Analysis, Metrics, Conversion, SAS, SPSS
PROFESSIONAL EXPERIENCE:
MS Access/Excel Specialist
Confidential, Spartanburg, SC
Responsibilities:
- Processed errors in SAP, created SOP’s in MS Word, ran queries in MS Access and Processed Test Orders in SAP.
MS Access Developer
Confidential, Greenville, SC
Responsibilities:
- Created SQL statements and queries for Access tables, reports.
- Converted data from Excel spreadsheets and programmed an Access database for Human Resources department. Created tables, forms, queries, reports that presented information easily readable, accessible for managers and users. Analyzed data and programmed applications utilizing Excel and Access.
Marketing/Excel Administrator
Confidential, Greenville, SC
Responsibilities:
- Sorted data from Excel spreadsheets; manipulated data into desired formats, queried MS Access database using SQL statements/SQL Server databases, determined sales territories, created, formatted, and designed reports, created PowerPoint presentations, created pivot tables, utilized/coded programming logic for spreadsheets, consolidated spreadsheets for managers, analyzed data and assisted Senior Project Management Team.
Excel Programmer/Specialist - Project Manager
Confidential, Spartanburg, SC
Responsibilities:
- Created, formatted, and designed reports for proprietary Excel templates. For MS Excel spreadsheets coded macros, created & developed applications, programmed and ran visual basic for applications (VBA). Coded programming logic for spreadsheets, created pivot tables, charts and formulas. Analyzed data and assisted/taught Project Management Team data set components in a user friendly manner. Created excel templates/user manual for staff members.
Web Designer - Marketing Consultant
Confidential, Duncan, SC
Responsibilities:
- Web Development and Design for Non-Profits, Churches, and Community Organizations. Manages and executes business process planning activities. Analyzes business critical processes and recommend improvements. Assist customers with computer based in Microsoft E-Learning courses.
Paralegal / Programmer Analyst
Confidential, Duncan, SC
Responsibilities:
- Developed IT project management, requirements management, deliverables management, resource management for US and International Vendor community. Business Analyst - Analyzed complex problems, interpreted operational needs, and developed integrated, creative solutions, database queries/SQL. Researched government and business contracts for Defense and Automotive Industry standards. Created monthly reports / metrics for Managers, Stakeholders and Board Members utilizing MS Excel and Project Management software. Assisted in developing company Information Technology Infrastructure.
- Taught Continuing classes in Computers (basic to advanced), MS Office Suite software, and Programming techniques to novice users. Instructed Introduction to Computers classes to adult learners. Have proxied for absent teachers at Middle Schools and High School technical centers.
Data Compilations Specialist
Confidential, Greenville, SC
Responsibilities:
- Provided compilation of data to support a variety of GE programs, initiatives and reports. Compiled, verified, and entered part transactions data from multiple sources. Followed up with source data providers as needed to resolve incomplete information. Reviewed and assessed a range of reports from field service and repair shops. Determined configuration, operations, part disposition, and part condition. Communicated with data suppliers as required to ensure the highest possible data quality. Designed, modified, documented, and enhanced reports utilizing Crystal Reports software. Designed and enhanced SQL queries.
- Performed data mining and queries of the database. Prepared data files for importing and/or exporting. Used SAP software as company departments continued to grow. Maintained advanced MS Access and Excel features for varying projects - V-Lookups, Macros, Pivot Tables, Formulas. Creation of mail merges, queries, templates and tables for relational databases.