Data Analyst Resume Templates in Word Format Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Profile & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Cora Smith

309 Ford Road Apt E-16, Bristol, PA 19001 | CoraSmith@gmail.com | 609-332-9876

Data Analyst: Extensive experience with gathering customer requirements, translating requests into efficient workflow, and integrating data across applications to address in/external customer concerns.

 

Work Experience

Artech, Data Analyst (Sept 2011-Jan 2012), Consultant for GSK, Philadelphia, PA

Manually scrubbed data and resolved errors within large data sets, requiring the collection of confidential data from external sources. Created ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs (data modeling). Implemented and documented data extraction processes across multiple sources.

TFI Resources, Data Analyst (May 2011–Aug 2011), Consultant for Jones Group, Bristol, PA

Created ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs. Implemented data extraction processes from multiple SAP modules including invoice creation and inventory tracking. Lead work sessions with business stake holders to assess requirements. Provided Access training and support to supervisors as requested.

Regent Systems, Inc., Data Analyst (Oct 2009–Apr 2011), Philadelphia, PA

Documented and reviewed data requirements for creating ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables. Wrote scripts to QA user data. Designed tools for extraction, input, manipulation and clean up of large sets of user data from multiple sources. Manually scrubbed data and resolved errors, requiring the collection of confidential data from external sources.

Paragon, Operations Analyst (Jul 2009-Sep 2009), Consultant at Merck, Blue Bell, PA

Searched both in-house and online databases for healthcare provider data. Cross-referenced between databases with common name variations and misspellings. Collated findings into PDF files. Shared responsibility for training, quality assurance and revising written processes (SOP’s) within a 20 person team. Adhered to strict procedures for sensitive legal information (attorney work product).

Apex, Sourcing Analyst (Apr 2009–Jul 2009), Consultant at VWR, West Chester, PA

Lead sessions to gather data modeling requirements and management needs to develop standardized reports and pivot tables in MS Excel. Sourced spend analysis in MS Access using SQL queries to identify trends & potential opportunities. Proactively identified cost avoidance, opportunities/trends (positive & unfavorable) for sales improvement based on statistical analysis using SAP. Created ad hoc MS Access tools, MS Excel reports and pivot tables based on business needs.

AdvantageMS, Data Analyst (Aug 2008-Mar 2009), Langhorne, PA

Manually scrubbed data and resolved errors within large databases, requiring the collection of confidential data from external sources. Created ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs (data modeling). Implemented and documented data extraction processes across multiple sources.

TekMark, Business Analyst (Jan 2008-May 2008) Consultant at Veridign, Philadelphia, PA

Created ad hoc Access databases using SQL queries to analyze large data sets from multiple sources (data modeling). Facilitated business requirements sessions: reviewed, analyzed, and evaluated business systems and user needs as they related specifically to information quality. Created ad hoc MS Access tools & MS Excel reports and pivot tables based on business needs.

Paragon, Account Analyst (Aug 2005-Jan 2008) Consultant at BMS, Hopewell, NJ

Designed and implemented tools for extraction, input, manipulation and clean up of large sets of user data from multiple sources. Created and maintained an Access database to monitor User Account Creation process. Documented and reviewed data requirements for creating ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs (data modeling). Created and maintained user accounts in Oracle Clinical.

Devon Consultants, Data Analyst (Mar 2005-Jul 2005) Consultant at MEDecision, Wayne, PA

Designed tools for input, manipulation and clean up of large clinical data sets from MS Excel. Created ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs (data modeling). Coded content data, performed data matches and created resolution procedures to ensure quality control. Managed multi-user documents in SharePoint and Documentum.

Oxford Legal, Data Analyst (Nov 2004-Mar 2005) Consultant at Dechert, Philadelphia, PA

Designed, implemented, and maintained several Access databases. Imported data files, changed initialization parameters, and created resolution procedures to ensure quality control. Created ad hoc MS Access tools & MS Excel reports and pivot tables based on business needs (data modeling). Provided Access training and support.

New Jersey Parent Teacher Association, Data Analyst (Apr 2002-Aug 2004), Trenton, NJ

Redesigned, updated and maintained Access database for tracking membership and accounts receivable data. Created ad hoc MS Access tools, SQL queries, MS Excel reports and pivot tables based on business needs (data modeling). Developed tools to automate calculations and data migration process. 

Skills

Data Modeling - Extensive experience with gathering customer requirements, translating requests into efficient workflow, and integrating data across applications to address in/external customer concerns.

SAP – Familiarity with inserting, extracting and manipulating data, creating data matches and applying resolution procedures.

Microsoft Access - Strong grounding in the synthesis of data into valuable and accessible reports for users at multiple levels. Vast experience with designing and executing databases and modifying structures to suit changing customer requirements.

SQL – Familiarity with writing queries on the fly to import, extract and manipulate data, create data matches and apply resolution procedures.

Microsoft Excel - Skilled at creating large spreadsheets tables including importation and management of data, vlookups, processing and modeling of primary data to create reports, pivot and derivative measures.

Education

Kean University, Union, NJ (1992-1998)

Over 120 credits of undergraduate coursework in Geology and Philosophy. Dean’s List 4 semesters, Theta Phi Alpha National Service Sorority.

Download Resume Format