| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Business Intelligence Data Analytics Naperville, IL Data Analytics Big Aurora, IL Data Analytics Business Intelligence Bartlett, IL Data Analyst Analytics Sycamore, IL Data Analytics, Market Research, Communication, Problem Solving Elgin, IL Data Analytics Software Development Bolingbrook, IL Communication, Data Analytics, working with a team, Organization Chicago, IL |
|
Click here or scroll down to respond to this candidate Candidate's Name
Bartlett, IL Street Address | PHONE NUMBER AVAILABLE | EMAIL AVAILABLEData AnalystDetail and customer service-oriented database/data analyst professional with experience in evaluating and providing information in the pharmacy benefits management, direct marketing and payroll service fields; experience in SQL and Access to crunch data to meet client and vendor needs. Self-starter as well as a valued team member with both corporate and non-profit working experience.Areas of ExpertiseData Analytics and Management | Project Manager | Product Selection | Analytics and Metrics | Reporting Tools | Advanced Excel Spreadsheet Functions | Microsoft Access | Data Mining | Database Management | Data Quality Assurance Processes | Query Tools | Database Programming and SQL | Data Collection Management | Data Profiling | Trend Analysis | Documentation | Power BI | Drug RebatesExperienceCVS Health, Buffalo Grove, IL 12/2014 - 08/2023Data Analytics ConsultantPut together company mailings in Access and SQL to book of business clients, members, and prescribers. Coded in fields in .sas file templates to build a list for mailings. Modified .sas file templates to plug in new data fields and information. Supported mailing collateral with information on lowering drug costs using generics, government warning releases, and formulary purges. Mail merged word templates using Excel. Pulled data in SQL to create instructions for customers picking up their prescriptions at CVS Retail Pharmacies. Successfully troubleshooted and resolved data integrity issue with Medicaid letters. Able to bring mailings and printing back in house and saved company $150,000 a year,
Paylocity, Inc, Arlington Heights, IL 09/2008 - 10/2014Partner Integration Support AnalystSet up file transmission of 401K Programs, HSA, FSA, and unemployment to various vendors for Paylocity clients which helped clients eliminate the task of uploading their 401K contributor and benefits information manually to their 401K vendors. Troubleshot issues with transmissions that had missing and/or bad data file information and discrepancies in amounts between what was in report and what was being reported on the data file to the vendor. Worked with vendors to get client information for compensation reports by developing queries in Access and SQL. Developed and enhanced skills in SQL. Created a way to setup queries in SQL to help clients get their financial and benefits downloaded into an Access environment.Additional Relevant ExperienceIndependent Contractor, Data AnalystConsulting work for Veritas Document Solutions, Inktel and Dell. Helped saved clients up to 15% in postage costs by sending out individual pieces at a lower per piece rate from USPS. Analyzed and tracked Email marketing results using advanced Excel programming. Produced master database of account reps, vendors and support team information for a Fortune 500 computer company using Excel and Access programming. Produced mailing lists for clients using Visual Basic and FoxPro programming. Imported customer data from Excel and Access to create a list ready for client mailings, which saved clients 10% on UPS delivery costs. Executed a streamlined process of importing data for several large clients to increase productivity. Extracted customer data and created medical cards using Access and SQL queries, which led to helping clients send out timely information to their customers for up to 15% less in postage costs.American Foundry Society, Schaumburg, IL, Information Services SpecialistThe Nonprofit Trade Organization for the Foundry Industry executed database extractions for company led mailings and Email promotions using Access queries and FoxPro. Increased class attendance by 5% through database mining of extracting expired membership names and workers who had not been to an AFS class in 2 5 years. Reorganized database by eliminating duplicate and bad records, implemented, and executed extraction of names for outside mailings (between 5,000 25,000 pieces) for conferences and/or AFS classes at the rate of 2-3 mailings a week. Assisted in transition of AFS membership/subscriber database into an SQL based software package. Maintained network functionality of servers as well as associated computers.EducationBachelor of Arts (BA) in Business AdministrationDrake University, Des Moines, IA |
