Data Fulfillment Specialist Resume

SUMMARY

Dedicated business support with experience as a Business, Data Analyst/ Reporter focusing on application of technology to business functions in the areas of health care services, production, software industry
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 (SSRS and SSIS)/ knowledge of relational database system
Data/ Reporting Analyst, Spreadsheets, Dashboards, Database Creation, 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 and saleforce.com

PROFESSIONAL EXPERIENCE

Data Fulfillment Specialist

Confidential

Responsibilities:

Write scripts in Microsoft FoxPro to query different tables to pull data, use a propriety tool to fulfill queries
Generate customized count reports to illustrate Healthcare provider data diversity and disperse for clients’ requests
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

Confidential

Responsibilities:

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

Confidential

Responsibilities:

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

Project Manager Assistant

Confidential, Irvine, CA

Responsibilities:

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