TECHNICAL SKILLS

• Microsoft office
• MS Exce Vlookup
• Pivot tables,trends
• AD - hoc reports
• VBA,MACRO
• SAP
• ,NET
• SUIT
• SQL
• CRYSTAL
• SHAREPOINT

PROFESSIONAL EXPERIENCE

Technical Consultant

Confidential, Irvine, CA

Responsibilities:

• Pathnostics Lab (IHC, FISH, Micro, PGX, Case Management, Histology) & Element 7 (Toxicology)
• Worked with IHC, FISH, Microbiology, Case Management, histology, HR, Finance, Purchasing and logistics to Analyzes and identifies Continuous Service Improvements leveraging source data like vital axis for new and existing functions in alignment with automation opportunities focused on simplifying existing processes and the processes supporting workflow.
• Design, develop, test, tune and execute reports, extracts, and interpretations of data utilizing multiple tools.
• Structured datasets to build insightful solutions to complex problems, and present the results in visually engaging and intuitive reports and dashboards using PowerPoint, Visio & Publisher.
• Clearly convey the key insights the data reveals in a visual format that is grouped, summarized, and formatted to be easily understood and actionable.
• Work with IT and related parties in resolving data issues and improve data environment. Have ownership of marketing data.
• Document business and technical reporting methodology, best practices and related rules for generating reports to ensure results accurately represent the underlying data and can be replicated by other Analysts.
• Create Levy Jennings report to overlook for the error caused by machine to view and report to the upper management in dashboards.
• Analyzes business workflow and system needs for conversions and migrations to ensure that encounter, recovery and cost savings regulations are met focusing on Quality Management.
• Prepared high level user documentation and materials with screenshots and step by step guide so the end user can understand process.

Auditor

Confidential, Garden Grove, CA

Responsibilities:

• Post room charges and taxes to guest accounts.Post guest charge purchase transactions not posted by the front office cashier.
• Transfer charges and deposits to master accounts.
• Verify all account postings and balances.
• Monitor the current status of coupon, discount, and other promotional programs.
• Track room revenues, occupancy percentages, and other front office statistics.
• Summarize results of operations for management.
• Prepare of End of day procedure.
• Run end of day process in property management software (PMS).
• Understand principles of auditing, balancing, and closing out accounts.
• Operate PMS, typewriters, and other front office equipment

Data Analyst

Confidential, Irvine, CA

Responsibilities:

• Importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes using VBA,EXCEL,ACESS,SQL, and in - house programs.
• Design, develop, and own reporting dashboards used by the entire company every day
• Make recommendations on how to optimize player experiences based on reporting results
• Identify critical product metrics and make recommendations on what data to collect.
• Support and influence various teams as the consumer insights expert.
• Explain trends in player behavior and system performance to the executive team.
• Prepare, modify, and develop selected recurring and ad-hoc financial schedules and related notes for management reporting.
• Collaborate with teammates and provide technical solutions to optimize data management and improve business processes.

Data Analyst

Confidential, Orange, CA

Responsibilities:

• Data mining Using Venders and Channels and distribution data sources to cleansing, extracting and resolving problem to populate trend based on ad-hoc reporting.
• Responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, Power Pivot, Formulas, Access, SQL,Powerpoint.
• Dealing with clients: channels and distribution (best buy, Costco, bjs, pacific sales ECT.) On daily basis thru emails/phone calls/faxes.
• Worked with SAP, Net suite, Power Pivot, SQL, Advance Excel Formulas, MACRO, VBA ACESS reporting to: Reporting directly to Head of department/Council of the Company.
• Communicate with management and user community to share knowledge, manage expectations, execute initiatives, and provide status/progress and period-end reporting.
• Supervise, coach and train master data resources to accomplish customer service and master data governance objectives. For example working with logistic data to create invoice from VBA created templet.
• Detect potential data breach / data ex-filtration transmissions and prevent them by monitoring, detecting and blocking sensitive data while in-use (endpoint actions), in-motion (network traffic), and at-rest (data storage).
• Suggest process improvements to enhance and sustain the efficiency and effectiveness of the services performed within the master data area.
• Add to and update entries for the Standard Operating Procedures documents.
• Research historical data to map trends and determine how they will influence the business.
• Prepare and present reports, charts, and tables detailing these market factors to company heads to help inform production strategy decisions.
• Collecting data from Vendersand assemble a database. Reporting on Trends of sales and Returns of the units % of sales and returns analysis Call times and price ratio of Call center services Reporting directly to Council/ Manager: Tuner Activation Project

Outdoor Salesman

Confidential, Anaheim, CA

Responsibilities:

• Selling product outdoors on wagons while constantly interacting with our Guests.
• Displaying strong cash handling with or without a cash register.
• Preparing and delivering food and merchandise products.
• Answering Guest questions.
• Taking and assembling Guest orders.
• Serving entrees and beverages.
• Stocking and replenishing food.
• Physical demands include constantly walking or standing, pushing/pulling, lifting inventory, and frequently bending/twisting/kneeling.

Outdoor Salesman

Confidential, Buena Park, CA

Responsibilities:

• Capturing Guests’ experience at Knott's berry Farm with high - quality photos taken with the latest in digital photography technology
• Proactively approach Guests to offer photo opportunities
• Inform Guests of the variety of Photo Imaging services available
• Take and fulfill orders
• General cleaning, stocking items and keeping inventory
• Physical demands include continuously holding, carrying and lifting up to 15 pounds of photography equipment, frequent walking/standing, and frequent bending/twisting/kneeling