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.
Technical Advisor/Analyst 2016 - Present
Project: Research Customer feedback and search instances to provide KPI and Dashboards using PowerBI
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
Robert Half - Irvine, CA 2015 - 2016
Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
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
Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
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
IHG - Garden Grove, CA 2014 - 2015
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 (Contract)
St Joseph Medical corporate - Irvine, CA 2013
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
Built SSIS packages to extract, transform and load data to data warehouse
High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
Westinghouse Digital LLC 2009 – 2012
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
Big Data and Hadoop 2019
Python for Data Science 2019
Spark Streaming and Scala 2018
Java Programming Masterclass 2018
Analytics and Business Intelligence 2018
Machine Learning A-Z™ 2019
Amazon Web Service In Progress
Computer information system
CIS – Computer Science
Valencia High School
Data Mining, Data Management Fusebox, Peoplesoft, SAP, NetSuite
Trends, Forecasting, Modeling
BI-tools, Tableau, Dashboards
ServiceNow, GitHub, Access
Statistical, linear, regression analysis
SQL, JAVA, Python, VBA, Macros
Excel – Power Pivot, Power Query
Dashboard & Stories
MS OFFICE SUITE
R & D for T.V. patent to save $5-10 per unit leading into a total savings of over 10 million dollars
Help, Cleanse, optimize data to integrate into live system
Worked with R&D to Develop Medicine Resistance Tool to Populate Reports for Patients
Managing different brands & achieved to help over 150K customers at Fixya.com