Data Analyst Power Bi

Naresh Patel

Data Analyst

Lowell, MA-*****

Phone: 978-***-**** @mail: ************@*****.***

Expertise in Data Analysis with 10+ years of experience. Skilled in statistical analysis, predictive modeling, data visualization, and database management. Collecting, processing, and analyzing large and complex datasets to drive successful business solutions. Present real time graphical data using analytical tools like Power BI Report development with Visualizations, Functions and DAX Queries, Tableau, MS Excel with Pivot & Advance Functions, MS SQL Server including SSIS, SSRS, SQL Query Building, writing different types of user queries for analyzing data. Extract, transform, and load large sets of unstructured data into structured information for analysis, decision-making, and reporting. Perform data analysis and recognizing key problem areas to assist in root cause identification. Designed and implemented predictive models and algorithms to identify patterns and trends.

Experience in implementing and providing end user training over Microsoft Dynamic Navision ERP for growth of business. Improving business standards by collecting, analyzing, and transforming data from various departments like Sales & Marketing, Warehouse, Planning & Production, Purchase, Finance into ERP. Designed and implemented predictive models for sales & marketing to identify patterns and trends. Create datasets and prepare reports for finance & auditing. Experience with IT Administration Providing technical support for professionals, including troubleshooting software and hardware issues. Supporting all major OS, Windows Server environments, configuring ADDC, defining group policies, creating users and assigning roles, troubleshooting complex problems. Support & maintain data backup providing data storage structures. Configure Outlook for mail distribution. Technical & Analytical Skills

• ETL Architecture

• Data Flow Architecture

• Data Warehouse Design

• Data modelling, Visualization technologies,

Report development using Power BI, Tableau

• Dashboard Design presenting KPI

• Anchor data storytelling

• Extensive knowledge of all major Operating

systems and Databases

• Project Management using SCRUM technology

• Team Management (Onsite/Offshore)

• Understand the Business Requirements

• Business Process Improvement

• Project Scheduling using MS Project

• Strategic Planning

• Microsoft Dynamics Navision ERP

Work Experience

Quality Analyst Jan 2023 - Current

Cirtec Medical, Lowell, MA, USA

• Hands-on experience of organizational skills in Quality Inspection and analysis environment

• Control, analyze and generate analytical reports of inspected data

• Review and revise GMP documents using GDP such as SOPs, log reports, test methods, work instructions and write certificate of analysis

• Schedule and organize calibration and maintenance of lab equipment’s

• Provide mentoring and training to junior analysts of lab instruments and processes Data Analyst Nov 2010 to Nov 2022

Cadmach (Zydus Cadila Pharma Group), Ahmedabad, Gujarat, India

• Implemented ERP to collect, aggregate, and analyze business, inclusive of Warehouse Management, CRM, Finance.

• Developed and maintained dashboards and reports using advanced data visualization tools such as Tableau, Power BI, Excel and SQL to identify trends and patterns in large datasets.

• Designed real time drill-down graphical reports to optimize and analyze forecast of demand and supply, reducing response time and efficiently achieving objectives in increasing sales.

• Lead the development of a predictive model that improved customer retention by 20% and increased revenue by 15%.

• Reduced report production time by 50% by developing automated data cleaning and processing scripts.

• Data verification activities of various documents related to the entry, compilation, and reporting of analytical data to be presented at Zydus Cadlia & Overseas group of companies IT Executive Apr 2006 to Oct 2010

Madhu Industries & CTM Mills, Ahmedabad, Gujarat, India

• Configured and implemented IT initiatives to produce measurable business value

• Analyzed sales, operational data to align with company vision

• Guided implementation of company-wide enterprise security strategy for network and hardware, data protection and endpoint protection

• Analyzed architecture design, implementation, testing and deployment needs to define project requirements Network Administrator Mar 2002 to Feb 2006

Microsolve Computers, Ahmedabad, Gujarat, India

• Configured networks for smooth, reliable operation to meet business process

• Developed, build process and configured network automation

• Implemented software installation, maintained hardware and troubleshoot to support availability to end users Centre Head & Support Engineer Oct 1998 to Mar 2002 NIIT Limited, Mahemdabad, Gujarat

• Provided detailed technical documentation, network diagrams, process flow charts

• Demonstrated strong analytical troubleshooting and problem solving skills

• Installed and tested software applications managed patches, data backup and configured servers Education

• Bachelor in Science (Gujarat University, India)

• Diploma in Computer Application (NIIT)

• Certification in Quality Management (NIIT)

• Certification in Cyber Security, CISP, CCSP, CompTIA Security+

Contact this candidate