Data Analyst Resume
4.00/5 (Submit Your Rating)
Charlotte, NC
SUMMARY
- Over fifteen years of business office experience including the healthcare and aerospace industries. Ten plus years were in a technical environment
- Strong troubleshooting ability with an understanding of networking and computing concepts.
- Strong IT application experience to organize, analyze data, develop spreadsheets, and articulate reports
- Excellent oral, written, and interpersonal communication skills
- Analytical, detailed and result oriented with exceptional multi - tasking strategies and strong organizational skills
TECHNICAL SKILLS
- Marketing Management, New Jersey City University, pending B.A. Degree
- Client Server Specialist, Alphatrain Microsoft Certification Business School
- Microsoft Office user specialist, WOSA Technologies, Certificate
- Graphic Design, ACECS Inc., Certificate
- Computer Skills and Training
- Microsoft Office Suite Proficiency (Word, Excel, PowerPoint, Publisher, Outlook, SharePoint) Power BI
- Adobe Photoshop CS5, Pro Presenter Church Worship Software for Mac, Joomla, WordPress
- Content Server (formerly LiveLink), Ariba, DirectWorks, Aerovantix (Online Supplier Sourcing, Collaboration Tools) SAP, Business Objects (Reporting, Data extraction)
PROFESSIONAL EXPERIENCE
Confidential Charlotte, NC
Data Analyst
Responsibilities:
- Data auditing for daily and monthly data files to prepare for evening upload and processing.
- Develop and design reports/dashboards using Power BI desktop and PowerPoint.
- Scrub data lists from various systems to prepare them for merging with other data sets using Excel functions such as VLookup and Pivot table.
Confidential, NC
Data Analyst
Responsibilities:
- Create market segmentation reports by compiling data from six different systems to identify various analytical views of the market.
- Support the Senior Analyst with various assignments dat require compiling large amounts of data or scrubbing data lists.
- Scrub data lists from various systems to prepare them for departmental mass emailing/newsletters; using Excel functions such as VLookup, Proper, Left, Right, Countif, Fuzzy Lookup, Trim, Concatenate, etc.
- Upload scrubbed data lists to an Email Management App; MailChimp.
- Made decisions based on the data/information gatheird dat lined up with the vision of the company.
- Manage the MailChimp application weekly to remove all outdated data lists, unsubscribed and bounced emails.
- Manage the Unsubscribed and Bounce Google Sheets weekly.
Confidential, NC
Executive Office Marketing Support
Responsibilities:
- Extract, complied, and tracked data to generate reports.
- Compose comparison spreadsheets for researched analysis and recommendation.
- Marketing research on various vendors for major office equipment and smart technology.
- Preparation and checking of proposals and contracts
- Made decisions based on the data/information gatheird dat lined up with the vision of the company.
- Train staff on the smart technology.
- Coordinate with the web developer with redesign of the company’s website.
- Design graphics for events, announcements, and social media.
- Assist marketing manager with coordinating successful and creative marketing strategies involving multi-channel marketing through direct mail, email, and internet marketing.
- Responsible for all website edits and updates using Joomla and WordPress.
- Coordinate workshops and seminars as requested. (Smartboard)
- Train and manage marketing volunteers.
Confidential, NC
Data Analyst/Supply Chain
Responsibilities:
- Content Server Administration (formerly Livelink) create internal & external users accounts; troubleshoot any account accessing issues, update existing accounts and remove any inactive accounts
- Directworks Administration (formerly Co-exprise) create internal & external user accounts; troubleshoot any account accessing issues, update existing accounts and disable inactive accounts
- Verify each Denied Party Screening (DPS) per new supplier/user requests for compliance before account creation in Directworks
- Extract, complied, and tracked data to generate reports.
- D&B Supplier Risk Manager User Administration-create user accounts.
- Research supplier’s affiliation with merges and buyouts via internet & D&B
- Validating spend, OTIF & savings data between systems: SAP, Aerovantix & Business Intelligence tools (Aerolytix) using pivots & Vlookup etc.
- Direct (product) supplier mapping (global supplier & supplier commodity) Data Warehouse
- Update training materials to change all Goodrich references to UTC Aerospace Systems references (words, logos, etc.) post integration, merger.
- Team player dat was willing to do what it took to get a job done when special projects were requested.
- Utilize SCM Data Warehouse (Business Objects Webi) for quick lookups on supplier metrics
- Generate Ad-hoc Direct reports.
- Produce Supplier Scorecards upon requests
Confidential, NJ
Data Base Administrative/Sales Support
Responsibilities:
- Extract, compiled and tracked data, and analyzed data to generate reports.
- Develop a monthly business information Metric Report from the compiled halpdesk mailbox daily request
- Troubleshoot IDOC system errors due to order processing failure
- Responsible for completion of all data entry and updates in SAP
- Coordinate office structure through SRM (Service Request Management) for relocating employees & new hires
- Assist Human Resources with recruiting process; coordinating interviews
- Dedicated to excellence in customer service
- Organize and coordinate details for trade shows, special events and meetings
- Review and prepare contract documents for signature and counter-signature
- Update Master Contract database onto MS Excel spreadsheet
- Prepare and maintain Excel spreadsheets/track contract activities/update amendments and addendums
