CHIRAG PATEL

ANALYST/CONSULTANT

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.

ac8vyk@r.postjobfree.com

PROFESSIONAL EXPERIENCE

Technical Advisor/Analyst 2016 - Present

Fixya.com

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

Technical Consultant

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

Auditor

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.

Data Analyst

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

Frisco, TX

714-***-****

CERTIFICATIONS

EDUCATION

TECHNICAL SKILLS

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

DeVry University

CIS – Computer Science

Fullerton College

Diploma

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

SQL Expert

Dashboard & Stories

JAVA

PEOPLESOFT

DATA MANAGEMENT

MS OFFICE SUITE

TEAM LEADERSHIP

A

ACCOMPLISHMENT

STRENGTH

TYPICAL DAY

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

Contact this candidate