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, AS/400, Dashboard Reporting, Graphs and Charts, SQL Query Analyzer, Data mining, Quality Assurance

RELATED WORK EXPERIENCE:

Confidential, Mt Laurel, NJ

Data Analyst

Responsibilities:

• Collect, maintain, manipulate, research, scrub and ensure data for accurancy and integrity to improve quality of database.
• Using Excel created statististical Reports, Dashboards and develop metrics, analyze and monitor KPI.
• Generated a new and run existing Reports resolving data discrepancies.
• Create ad - hoc reports.
• Investigated missingdataanalysis,datavalidations, dataquality,datamanagement.
• Review, analyze, update TEMS database with correct invoice amount, active circuit information and suggested improvement for the project workflow.
• Created Charts and Graphs to present month-to-month comparison data

Confidential, NJ

Quality Data Analyst

Responsibilities:

• Measure and QA Data Performance to ensure quality and goal are met
• Maintain integrity, cleanliness and consistency of data. Organize, extracted and formatted data from various sources.
• Using Excel created Weekly/Monthly Reports, develop metrics, analyze and monitor Key Performance Indicator, and provide suggestions for improvement to Clinical upper management. Exported data from Excel to other sources.
• Developed and maintained ACCESS database (tables, query, forms, menu, macros) for Pediatric Pharmacy project.
• Generated a new and Run existing Reports using Vlookup and Pivot Table, resolving data discrepancies.
• Create ad-hoc reports, validation reports checking for invalid and missing data.
• Perform data quality analysis and validation, conduct data mining to identify trends and solutions to improve quality of Clinical data. Collect, maintain, manipulate, query, research, scrub and ensure data accuracy and integrity.
• Created Charts and Graphs to present data for Patient’s Hospital Readmission project. Performed Quality Assurance
• 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, monitor, and track historical trends and external factors impacting the quality and performance of the mortgage company, and performed QC data validation. Provided support to outsourced vendors in USA and India
• 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, macros.
• Created Reports that monitore performance of outsorced Vendors in India and Phillipines for turnaround time

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 JD Edwards 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. Supported Driver’s Management team by providing Route spreadsheet information.
• Perform reports auditing to ensure correct S-to-S and input data in accordance with the Supercharge guidelines. Provided support by creating reports for Marketing and HR departments. Internet research, data mining, auditing.

Confidential, Philadelphia, PA

Data Steward

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. Created reports using Crystal Report
• 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 and entered Contract information related to legal entity to determine correct child-parent relationship and provide accurate purchasing quantity for Rebate.
• Performed Global Product Add, Reconciliation and Rebate payment using CARS software.

Confidential, Voorhees, NJ

Data Analyst

Responsibilities:

• Responsible for data validation, database cleansing and changes to Confidential Customer and Vendor profile information.
• Determine and approve data changes
• Researched and analyzed various information sources using SUN Accounting Systems software and websites to determine name, mailing address, credit ratings, legal structure and parent contact.