SUMMARY:

Seeking a challenging position as Data Analyst with the ability to utilize computer, organizational, analytical, and Report writing skills using EXCEL data manipulation, ACCESS database, Crystal Report, Database Analysis, Dashboard Reporting, Graphs and Charts, Quality Assurance, SQL Query Analyzer

PROFESSIONAL EXPERIENCE:

Confidential, Camden, NJ

Data Analyst

Responsibilities:

• S upport PIM team by analyzing and manipulating, importing, exporting, data from Salsify Product Information Management software.
• Set up Items in Salsify, load PIM data to select customer portal, auditing and customer publishing process to ensure speed - to-shelf for total Confidential portfolio.
• Gather required information provided by a third party data distributor.
• Using EXCEL generated Weekly/Monthly Performance Improvement Reports. Resolving data discrepancies in Reports.
• Create ad-hoc reports checking for invalid and missing data.
• Collect, maintain, manipulate, research, scrub and ensure data validation for accuracy and integrity to improve quality of PIM database.
• Conduct data mining to identify trends and solutions for E-Commerce data.
• Created Reports of Confidential and Pepperidge Farm items that have missing Preparation Instruction on Label.
• Using ACCESS database created Claim DB for Organic, Non-GMO and Gluten-free Products.
• Created Charts and Graphs to present Nutritional Fact data of the Product.

Confidential, Mt Laurel, NJ

Data Analyst

Responsibilities:

• Collect, maintain, manipulate, research, scrub and ensure data for accuracy and integrity to improve quality of database.
• Using Excel created statistical Reports, Dashboards and develop metrics, analyze and monitor KPI.
• Investigated missing data analysis, data validations, data quality, data management.
• Confidential Telecommunications billing validation (voice, wireless, DSL data) for accuracy using Rivermine TEMS software and Confidential VEC portal.
• Update TEMS database with active circuit information, and suggested improvement for the project workflow.

Confidential, NJ

Quality Data Analyst

Responsibilities:

• Design and develop Reports/Scorecards/Dashboards using Pivot Tables, Graphs and Charts for QM and Clinical departments to monitor projects performance and presenting SLA results to the Confidential Client.
• Using Excel created statistical Reports, develop metrics, analyze and monitor Key Performance Indicator, and provide suggestions for improvement to Clinical upper management.
• Exported Pharmacy data from Excel to other sources. Measure QA Data Performance to ensure quality and goal are met.
• Developed and maintained ACCESS DB (tables, query, forms, menu, reports) for Pediatric Pharmacy project.
• HEDIS Follow up After Hospitalization (FUH-7/30) reports.
• Perform data quality analysis and validation, conduct data mining to identify trends and solutions to improve quality of Clinical data.
• Created Charts and Graphs to present data for Patient’s Hospital Readmission project.
• Write query using SQL Query Analyzer to respond to the ad hoc requests.

Confidential, Mt Laurel, NJ

Vendor Reporting Analyst

Responsibilities:

• Created Month-End productivity and department statistics reports for company’s upper management.
• Monitor KPI and Outsource Vendors company’s metrics on the regular basis.
• Produces monthly Dashboards reporting and ensured that it comply with contract and SLA requirements.
• Measure and track historical trends and external factors impacting the quality and performance of the Confidential, and performed QC data validation. S upported outsourced vendors in USA, India and Philippines.
• Created Charts and Graphs to present data. Improve accuracy of current SLA and Dashboard reports.
• In order to see accurate information performed data cleansing and data validation to improve quality of data.
• Using ACCESS created database, queries, forms, tables, reports.

Confidential, Philadelphia, PA

Sales Data Analyst

Responsibilities:

• Performed Sales analysis and maintained full service Space-to-Sales marketing system for all PA distribution centers.
• Responsible for extracting Sales market data from Confidential using FASET system, populated Supercharge Excel model and performed data analysis for each outlet.
• Run and analyze Supercharge full service detail reports for all distribution centers, supply chain.
• Supported Driver’s Management team by providing Route spreadsheet information. Provided support by creating reports for Marketing and HR departments.
• Perform reports auditing to ensure correct S-to-S and input data in accordance with the Supercharge guidelines.

Confidential, Philadelphia, PA

Data Steward Temp contract assignment

Responsibilities:

• Created and maintained ACCESS database. Generated queries, forms, tables, macros and reports.
• Using EXCEL prepared Weekly/Monthly Inventory Summary Reports to support Data Management team.
• Extracted data from SQL into ACCESS and populated EXCEL spreadsheet.
• Master Data management cleanup. Internet research, compile data, QA and data mining.
• Implemented and loaded Contracts information into CARS software system including Price, Product, Customer information and conditions relating to Vaccine purchasing.
• Reviewed Contract information related to legal entity to determine correct child-parent relationship and provide accurate purchasing quantity for Rebate payment.