We provide IT Staff Augmentation Services!

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

Hire Now