MARINA STEIN

** ******* **** **, ********, NJ ***43

E-MAIL: adhddt@r.postjobfree.com PHONE: 856-***-****-CELL 856-***-****-HOME

OBJECTIVE

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, Database Analysis, Dashboard Reporting, Graphs and Charts, Quality Assurance, SQL Query Analyzer.

RELATED WORK EXPERIENCE

05/2019-11/2019

03/2018-09/2018

09/2017- 02/2018

01/2014-12/2016

07/2012-09/2013

08/2011-06/2012

05/2010 07/2011

08/2009 02/2010

03/2009 - 07/2009

City of Philadelphia (Mayor’s Office of Labor Relations)

Data Analyst Temp contract assignment Philadelphia, PA

Provide support for Labor Relations team converting data from ACCESS database to LaborSoft software.

Exported Grievance and Arbitration historical data from Access database to Excel. Created new Grievances, Arbitration and Complains cases in LaborSoft and genetated reports. Create ad-hoc reports checking for invalid and missing data and provide suggestions for improvement.

Analyze, clean, research data, find missing information and check for duplicate records. Create and analyze KPI.

Using EXCEL generated Weekly/Monthly Performance Improvement Reports. Resolving data discrepancies in Reports. Created SQL queries using SQL Query Analyzer.

Collect, maintain, manipulate data in Excel, research, scrub and ensure data validation for accuracy and integrity.

Based on user’s request analyzed data and created Graphs for visual presentation. Provided support for HR dpt.

Campbell Soup - Food Company Camden, NJ

Data Analyst Temp contract assignment

Support 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 US Sales portfolio. Assist with database marketing.

Gather required information provided by a third party data distributor such as Walmart, Amazon and Item Master. Run Error Reporting in Lansa. Created Graphs to present Nutritional Fact data of the Product.

Using EXCEL collected, maintain, manipulate, scrub data. Extract data from Business Object Data Warehouse.

Improve quality of PIM database. Conduct data mining to identify trends and solutions for E-Commerce data.

Created Reports of Campbell 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.

TD Bank – Banking Company Mt Laurel, NJ

Data Analyst Temp contract assignment

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. Verizon billing validation Telecommunications (voice, wireless, DSL data) for accuracy using Rivermine TEMS software and Verizon VEC portal. Update TEM database with active circuit information, and suggested improvement.

Beacon Health Options on behalf of Horizon Blue Cross Blue Shield of NJ

Quality Data Analyst - Behavioral Health and Wellness Company Mt Laurel, NJ

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 BCBS 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 and Master 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. HIPAA violation. NCQA quality measure.

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 in SQL Query Analyzer to respond to the ad hoc requests.(Autism, ADHD, Opioid use measure)

PHH Corporation - Mortgage company Mt Laurel, NJ

Vendor Reporting Analyst Temp contract assignment

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 mortgage company, and performed QC data validation. Supported outsourced vendors in USA, India and Philippines.

Created Charts and Graphs to present data. Improve accuracy of current SLA and Dashboard reports.

Using ACCESS created database, queries, forms, tables, reports.

Coca-Cola - Soft Drinks and Beverage company Philadelphia, PA

Sales Data Analyst Temp contract assignment

Performed Sales analysis and maintained 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, supply chain.

Provided support by creating reports for Marketing and HR departments.

GlaxoSmithKline - Pharmaceutical company Philadelphia, PA

Data Steward Temp contract assignment

Using EXCEL prepared Weekly/Monthly Inventory Summary Reports to support Data Management team.

Master Data management cleanup. Internet research, compile data, QA and data mining using Salesforce.

Implemented and loaded Contracts information into CARS software : Price, Product, Customer information and conditions relating to Vaccine purchasing. Reviewed Contract information for Rebate payment.

SunGard Financial Systems - Software and IT services company Voorhees, NJ

Data Coordinator Temp contract assignment

Responsible for data validation, database cleansing and changes to SunGard Customer and Vendor profile info. Researched and analyzed various information sources using SUN Systems software and websites.

Lockheed Martin - Defense and Security company Moorestown, NJ

Report Analyst Temp contract assignment

Responsible for creating Access database to support Request for Proposal project. Crystal Report.

INFORMATION TECHNOLOGY CONSULTING EXPERIENCE SUMMARY

1990-2007

Computer Programmer/Consulting job for a various company:

American Water Works Co( Utility Company ) AS/400 Programmer - Voorhees, NJ

The Rubin Organization. ( Real Estate Mgmt Company ) AS/400 Programmer - Philadelphia, PA

Cigna Insurance Co. ( Insurance Company ) AS/400 Programmer - Voorhees, NJ

Johnson Matthey Inc. ( Precious Metal Refinery ) AS/400 Programmer - Deptford, NJ

EDUCATION

2003-2004

2001-2002

1993-1995

1981-1982

The Cittone Institute. Mt. Laurel, NJ

Business Administration Specialist

MS Excel 2003, MS Access 2003, Word, PowerPoint 2003 A/R, A/P, G/L, O/E, Payroll, Billing, Oracle, Java

CSC Technical Institute. Cherry Hill, NJ

Client/Server Software Development Course

VB, VB Script, Crystal Report, HTML, Transact-SQL, Oracle, RDBMS, Java Script, SQL, ASP

Info Source Inc. Philadelphia, PA

IBM AS/400 Computer Programming Course

RPG 400, PDM, SDA, DFU, CL, Query

Delehanty Technical Institute New York, NY

Engineering, Drafting and Design Course - 1000-hours

Contact this candidate