SUMMARY

• Analyst with experience of 5+ years interpreting and analyzing data in order to drive successful business solutions. Motivated, teamwork - Oriented, highly organized, attention to detail and Accurate individual.
• Proficient Knowledge in Statistics, SQL,MS Excel. Outstanding ability in understanding Business operations and Analytics tools for effective analysis of data. Expertise in Statistical Analysis, Data Extraction, Data Mining.
• Ability to generate new reports and dashboards using BI tools like Tableau and Power BI.

PROFESSIONAL EXPERIENCE

Technical Advisor

Confidential

Responsibilities:

• Providing thorough support and problem resolution for the customer
• Displayed courtesy and strong interpersonal Skills with all customer interactions
• Researched issues on various computer systems and databases to resolve complaints, answer inquires and outline solutions. Inform customers about issue resolutions progress
• Managing Different brands and achieved to help over 150k customers
• Accessed documented procedures tools and manuals to provide support on company supplied hardware and equipment
• Gathered customer and technology information to determine technical support level; elevate calls to appropriate support level as necessary using - SQL, MACROS & DATA MANAGEMENT

Technical Consultant

Confidential

Responsibilities:

• 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 - SQL & TABLEAU, Power BI
• Clearly convey the key insights the data reveals in a visual format that is grouped, summarized, and formatted to be easily understood and actionable. Using Complex formulas and macros
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Maintained knowledge with accurate and up to date information relating to current policies, procedures and troubleshooting techniques
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports. Experience in creating different visualizations using Bars, Lines and Pies, Donuts, Pareto, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Motion Chart, and Highlight tables.
• Designing and Developing Dashboards using Tableau for various ROI metrics. Automate monthly reports into Tableau Workbooks and Dashboards.
• Accomplishments Worked with R&D to Develop Medicine Resistance Tool to Populate Reports for Patients

Auditor

Confidential

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 t 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 using - Oracle, PEOPLESOFT, FUSEBOX

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

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. 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
• 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 Venders and 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