SHAHRUKH AWAN
Data Analyst
Windsor Mill,MD
Summary
Results-oriented data analyst with a strong background in CRM solutions, and ERP Systems. Skilled in data integration, data validation, and data quality assurance processes. Proficient in software development lifecycle (SDLC) and agile methodology. Experienced in data visualization using tools such as Tableau and Microsoft Excel. Proven track record of leveraging data to drive insights and support decision-making in manufacturing, quality, and business performance. Strong communication and public speaking skills, with a keen eye for detail and accuracy in data analysis. Adept at collaborating with cross-functional teams and building effective relationships with stakeholders to deliver successful outcomes.
Overview
10
10
years of professional experience
Work History
Data Analyst
WESCO
Chicago, IL
02.2023 - Current
- Extract, clean, and preprocess data from multiple sources, including Odoo ERP system, to ensure data accuracy and consistency
- Develop interactive and insightful reports and dashboards using Power BI for various business units and stakeholders
- Analyze data trends, patterns, and anomalies to provide actionable insights and recommendations
- Manage data integration and synchronization between Power BI and Odoo ERP system
- Ensure data integrity and troubleshoot any data-related issues
- Design and maintain data models to support reporting needs, including data hierarchies and relationships
- Continuously optimize data queries and report performance to ensure timely access to critical information
- Implement and enforce data governance best practices to maintain data quality and security
- Collaborate with cross-functional teams and subcontractors to understand data requirements and deliver actionable insights
- Maintain clear and organized documentation of data sources, transformations, and reporting processes.
Manufacturing Data Analyst
Catalent Pharma Solutions
Harmans, MD
08.2022 - 02.2023
- Serve as a data steward to create and modify data within the ERP system, collaborating with other subject matter experts across functions
- Resolve data usage issues in a timely manner and monitor data quality using Microsoft Excel
- Review and approve manufacturing records, change controls, investigations, and analytical data
- Utilize data visualization techniques, such as Pivot Charts and VLOOKUPS, to review manufacturing validation protocol and reports.
Salesforce Business Analyst
Cisco Systems
Herndon, VA
04.2021 - 07.2022
- Implement and maintain Salesforce customizations, including custom fields, objects, layouts, workflows, and validation rules
- Utilize CRM solutions and Salesforce CRM toolkit to manage employee data
- Map process activities to identify operational inefficiencies and propose solutions
- Manage a team of 25 employees, overseeing hiring, training, and professional growth.
Quality Business Performance Analyst
AstraZeneca
Gaithersburg, MD
04.2019 - Current
- Develop and implement analytical and data visualization solutions to drive insights in scientific and business applications
- Build relationships with stakeholders and ensure utilization of information resources and services
- Stay updated with trends, standard methodology, and new developments in analytics
- Compile data from multiple sources to prepare reports and create visualizations using Microsoft Word.
Clinical EHR Data Analyst
Centers for Advanced Orthopedics
Rockville, MD
03.2019 - 02.2021
- Focus on metrics and reporting to assess EHR effectiveness and guide optimization decisions
- Work with team members to gather information, provide guidance on data reporting needs/solutions, and develop metrics
- Stay updated with technology and clinical practices related to areas of responsibility
- Implement healthcare systems for patient status monitoring, quality tracking, and home care management.
Data Analyst
Accenture
Reston, VA
05.2018 - 12.2018
- Research and compile tailored monthly analytics and reports for senior management using Pivot Charts and
- VLOOKUPs
- Design test plans for quality assurance of data flowing from source systems
- Utilize data analysis skills to identify and resolve data errors in reports.
Business Analyst
Asta Crs
Ashburn, VA
10.2017 - 04.2018
- Design Excel spreadsheets to estimate costs of custom projects for clients
- Perform independent analysis of R Studio and model resulting data
- Utilize critical thinking skills to resolve data errors in MySQL reports.
Support Technician and Front-End Associate
Kohl's Store
Gaithersburg, MD
11.2013 - 11.2018
- Provide excellent customer service, address customer concerns, and manage a high volume of customers
- Apply sales forecasting techniques and strategic planning to drive sales and profitability
- Generate visualizations, such as bar graphs, trend lines, and pie charts, to represent sales data.
Education
Master of Science - Health Informatics Administration
University of Maryland - College Park
05.2022
Bachelor of Science - Exercise Science
Salisbury University
12.2018
Associate of Arts - Health Fitness
Montgomery College
05.2017
Skills
- Health Informatics
- Project Management
- Data Analysis
- Health Policy and Regulations
- Information Security
- Communication
- Problem Solving
- Interpersonal Skills
- Adaptability
- ERP Systems
Work Preference
Work Type
Full TimeWork Location
RemoteImportant To Me
Work-life balanceHealthcare benefits401k match4-day work weekWork from home optionFlexible work hoursCareer advancementCompany CulturePaid time offTimeline
Data Analyst
WESCO
02.2023 - Current
Manufacturing Data Analyst
Catalent Pharma Solutions
08.2022 - 02.2023
Salesforce Business Analyst
Cisco Systems
04.2021 - 07.2022
Quality Business Performance Analyst
AstraZeneca
04.2019 - Current
Clinical EHR Data Analyst
Centers for Advanced Orthopedics
03.2019 - 02.2021
Data Analyst
Accenture
05.2018 - 12.2018
Business Analyst
Asta Crs
10.2017 - 04.2018
Support Technician and Front-End Associate
Kohl's Store
11.2013 - 11.2018
Master of Science - Health Informatics Administration
University of Maryland - College Park
Bachelor of Science - Exercise Science
Salisbury University
Associate of Arts - Health Fitness
Montgomery College
Similar Profiles
NICHOLAS VARGANICHOLAS VARGA
Inventory Manager at WESCOInventory Manager at WESCO
Annalee Elias-BarelaAnnalee Elias-Barela
Shipping Clerk at WESCOShipping Clerk at WESCO
Ryder LalondeRyder Lalonde
Shipping and Receiving Associate at WescoShipping and Receiving Associate at Wesco
Ivory WinterIvory Winter
Sale Associate at WESCOSale Associate at WESCO
Dorothea BowersDorothea Bowers
Customer Host at WalmartCustomer Host at Walmart