Project Manager Data

Guity Niamanesh *******@*****.***

949-***-****, 949-***-**** Laguna Niguel CA 92677 www.linkedin.com/pub/guity-niamanesh/16/8b0/ba

Dedicated business support with experience as a Business, Data Analyst/ Reporter, Project & Production coordinator

focusing on application of technology to business functions in the areas of health care services, production, software

industry

Highlights of Qualifications

• Offer Strong knowledge of Microsoft Applications: advanced Excel (powerful user of Excel: pivot tables,

functions and dynamic charts), Access, Word, PowerPoint, Outlook

• Knowledge of Structured Query Language (SQL) and relational database system

• Data/ Reporting Analyst, Spreadsheets, Dashboards, Database Creation, Joins, Records & Inventory

Management and data collection

• Consolidated data from external sources to analyze the sales performance by product, by vendor, by region,

by salesperson and identified the key opportunities in sales/ the best-selling items

• Manipulate raw data to illustrate trends/ KPIs

• Run MRP, Order management including PO placement, tracking, expediting, date changes, coordinate

multiple warehouses

• Good ability to manage multiple types of software programs and working knowledge of NX-Trend, MAS

200, HCSS and Penta, Fish bowl, Ross, CRM, NTS, Concur, Act, eCW, Microsoft Map Point, Microsoft FoxPro, salesforce and

Act

Work Experience

Data Fulfillment Specialist/ SK&A (A Data Company), Irvine, CA Jul 2013-Jan 2014 (contract)

Data Analyst

• Translates customer requests into logical queries by writing scripts in Microsoft FoxPro (a database language) to query

various tables

• Generated customized count reports to illustrate Healthcare provider data diversity and disperse for clients’ requests & insert pivot

tables on the result set for sales department to communicate the results with clients

Database Analyst/ Reporter Housecall Medical Residential Group, LH, CA Feb 2013-April 2013 (contract)

• Cleaned and quality checked data to qualify for importing data into Act Database

• Scrubbed data against itself and against other data sets to find matched and unmatched fields

• Built charts on the result of summarized data

• Imported data into Microsoft MapPoint and allocated physicians to pertaining locations

Data Analyst/ Reporter Itron/ Edison, Irvine, CA Oct 2012-Dec 2012 (contract)

• Measured/ analyzed the performance of wireless meters (Edison SmartConnect Operations)

• Worked closely with team members and the director to define the analysis tasks

• Consolidated utility data of different districts to create a summarized report for passing client User Acceptance Test

Business Analyst/ Reporter United Health Group (Optum segment), Santa Ana, CA Mar 2011- Aug 2012

• Involved in Member Outreach Program (Payer Solution/ Risk Adjusting Factor) to run call campaigns, assist the program designer to

monitor Call Campaign Activities

• Queried the raw data in Access to prepare reports in Excel for presentation to clients to showcase key metrics/ trends, serve as a

medium between the designer of the program and clients and enhance the program

• Gathered agent level data and center level data to perform analysis on call center performance indictors

• Prepared extremely confidential data files deploy data files containing PHI information to vendors, clients and different departments

in a secure manner and comply with all internal policies for protecting health information

• Interacted with data and drill down in any view for Ad-Hoc requests

• Kept track of records in different data files

• Reconciled the call campaign results with claims data

Administrator/ Reporter Infogain (Software writing Company), Irvine, CA Aug 2010- Jan 2011 (contract)

• Provided administrative support, researched business information (Property & Liability Insurance) for the

Regional Director of Technology Development, summarized them and converted them to PowerPoint

presentations for business strategy

• Performed administrative tasks such as scheduling meetings, accommodating travel and hotel

arrangements,

planning company events, generating / maintaining equipment tracking record, being a liaison between office and property

management issues and provide some light IT support

• Created weekly Excel spread sheet reports, monthly expense report, brochures for different occasions and constructed a

local Intranet

Guity Niamanesh *******@*****.***

Project Manager Assistant (Pharmaceutical Company) Nexgen Pharma, Irvine, CA Feb 2009- May 2010 (contract)

Assisted a project Manager with complex Excel Technical documents: Quote Formula, Product Specification, RM quoting, BOM

Imported external data from external source into excel to calculate different parameters involved in manufacturing and displayed

the facts in charts for the project manager

Designed two databases: one of which was for all punch drawings and one of which was for raw materials, the first one aided

production development department and the second one aided purchasing department

Organized and reconstructed clients’ correspondence sent by email to ensure each request is addressed

Contacted punch drawing, bottles and caps testing companies on different issues and followed up through to ensure the timely

receipt of items without any flaw

Order fulfillment and Production coordinator (Biotech) QIAGEN, Irvine, CA May 2008- Dec 2008(contract)

• Responsible for running the MRP system to enter sales orders and preparation of shipment of items to

three warehouses in Switzerland, Germany and U.S.A.

• Planed the weekly production ahead of time for the lab production, determined the priority for product

type, and coordinated the flow of work between departments and warehouses/ followed up the applicable instruction and praised

by Business manager during his six-week leave for directing the production line

• Created and updated statistical reports, charts in Excel and Power Point to show the progress of work,

shipped items, and the status of items in each different warehouse and compiled the data resident in Sap database and convert it

to meaningful production forecast to better manage the production line and forecast the inventory solutions

Education and Training

Microsoft SQL Server 2008 Santa Ana/ Saddleback College, CA (2012-2013)

Software Testing Principles, Manual and Automation (Quick Test Professional & Quality Center), Execute test cases/ scripts,

document actual results, perform all aspects of defect tracking; create test data if required, on line training

Basic Web Design, Desktop Publishing, QuickBooks Training Orange County, CA

Office Computer Applications, British Columbia Institute of Technology, Burnaby BC

Completed Windows, Word, Excel, PowerPoint, Outlook

Visual Basic Programming language, Introductory to Programming, Programming Algorithms, pseudo code, British Columbia

Institute of Technology, Burnaby BC

B. A. English Shahid Beheshti University, Tehran Iran equivalent in Untied States

Includes Methodology, Translation, Modern and Classic Literature

Contact this candidate