Data Analyst Analytics

Riddhi Patel

Data Analyst

Email Id: *****.*******@*****.***

Contact: +1-774-***-****

PROFESSIONAL SUMMARY:

● 5+ years of IT experience in the field of Business/Data analysis, ETL Development, Visualizations, and various applications using BI tools.

● Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.

● Over 2+ years of experience in Data visualization with expertise in creating interactive reports and dashboard using Business intelligence tools like Tableau, Power BI and Google Data Studio.

● Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.

● Good understanding of Relational Database Design, OLAP concepts and methodologies.

● Experience in Working with different industries like Hospitality, Automobile, Medical, Retail and Banking.

● Experience in creating functional/technical specifications, data design documents based on the requirements.

● Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

● Experience working with Web Analytics tools like Google Analytics, Google Tag Manager and Adobe

● Identify opportunities to automate manual data entry processes for business results, resulting in a reduction of over 30+ work hours per month.

TECHNICAL SKILLS:

BI Tools Tableau Desktop, Tableau Server, Power BI, MS Excel Database MS SQL Server, SSIS (ETL)

Programming Python, R, SQL

Applications MS Excel, MS Word, Outlook, PowerPoint Others

Selenium, Google Analytics, Google Tag Manager, Adobe Analytics, JIRA, Google Data Studio

CERTIFICATIONS:

● Visual Analytics with Tableau, Coursera Certificate

● Google Data Analytics, Coursera Certificate

EDUCATIONAL QUALIFICATION:

● Master of Technology: Data Science & Analytics - 2016 Ahmedabad University, Gujarat, India

● Bachelor of Engineering: Computer Engineering - 2012 Gujarat Technological University, Gujarat, India PROFESSIONAL EXPERIENCE:

Client: American AFC, Westborough, MA, USA Nov 2023 - Continue Role: Adult Foster Care Outreach Coordinator

Responsibilities:

● Explain the AFC program details, benefits, and caregiver support services to potential candidates.

● Collaborate with, Assistant Director of the program, Registered Nurses, and Care Managers to conduct comprehensive assessments of potential members' eligibility for the program.

● Maintain accurate records of caregiver interactions, enrollment status, and other relevant information.

● Preparation of data reports for members and vendor. Client: Milestone Internet Marketing Sep 2018 - Sep 2022 Role: Business Intelligence Analyst/ Data Analyst

Responsibilities:

● Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide the business insights and identify data trends to inform business decision making for the organization.

● Designed, developed, tested and maintained Tableau Functional reports based on user requirements.

● Extensively involved in creating charts and graphs using measures and dimensions data from various databases using data blending concept.

● Created interactive reports and dashboard in Tableau for cross functional teams with filters and parameters and calculated sets in order to improve strategies and operations.

● Wrote Custom SQL to support business requirements.

● Design, Create and automate weekly, monthly and quarterly ecommerce/non-ecommerce dashboards.

● Identify, measure and monitor key performance indicators, with continual recommendations impacting site, content marketing and e-commerce.

● Identify opportunities to automate manual data entry processes for business results, resulting in a reduction of over 30+ work hours per month.

● Involved in creating automation programming scripts to collect data for research and marketing team. Client: NsquareIT Digital Agency Apr 2018 - Aug 2018 Role: Data Analyst

Responsibilities:

● Collect customer requirements, determine technical issues, and design reports to meet data analysis needs

● Perform basic statistical analysis and transformed project data requirements into project data models.

● Produced monthly reports using advanced Excel spreadsheets functions.

● Experience in Working with Medical industries.

● Hands-on exploratory data analysis (EDA) using python. Client: Milestone Internet Marketing Jul 2016 - Apr 2018 Role: Jr. Business Intelligence Analyst

Responsibilities:

● Collected, cleaned, and analyzed data using SQL and Excel to generate insights on customer behavior, market trends, and campaign effectiveness.

● Execute and maintain reports for external and internal support.

● Developed and implemented basic ETL (Data Extraction, Transformation, and Loading) processes to load data from source to target tables.

● Worked with team to understand business needs and translate those needs into actionable reports in Tableau and Google data studio.

● Performed report optimizations and analysis using advanced Microsoft excel function like pivot tables and VLOOKUP function.

● Involved in gathering requirements, analysis, documentation, maintenance, management, prototyping, and coordination between the business owner and the technical team.

● Performed select queries and table joins using SQL and exported data to excel for formatting and report generation.

● Created and maintained the Data Mapping and Data Requirement documents.

● Utilize the google analytics/Adobe Analytics to track visitors flow and interaction throughout the website and provides the analysis and insights.

Client: Government Polytechnic Sep 2012 - Aug 2014 Role: Assistant Lecturer

Responsibilities:

● Mentoring over 100+ students, designing, and grading assignments, exams and projects for RDBMS and SQL programming.

● Delivered lecture on Database management System to graduate and undergraduate students.

● Provided academic advising and tutorials to students.

● Actively participated in serving on departmental, campus, and College committees.

Contact this candidate