OUSMAAN SHAHID
DATA ANALYST
***************@*****.*** 201-***-****
PROFESSIONAL SUMMARY
Analytical and detail-oriented Data Analyst/Entry with 4+ years of experience transforming complex data into actionable insights to drive business success. Certified in Google Data Analytics, with expertise in data visualization, predictive modeling leveraging tools like Tableau, Power BI, Python, and SQL. Skilled in analyzing website traffic and user behavior to optimize digital performance and ROI. Adept at identifying trends and developing data-driven strategies that enhance operational efficiency, boost revenue, and reduce costs. A collaborative problem-solver with a proven track record of delivering impactful analytics solutions aligned with organizational objectives. Passionate about leveraging data to uncover opportunities and fuel innovation in dynamic environments.
EDUCATION
BACHELORS IN COMPUTER INFORMATION SYSTEMS
Ashworth College, Norway, Georgia Graduated in 2024 GOOGLE DATA ANALYTICS CERTIFICATION
Google, New York Graduated in 2024
EXPERIENCE
DATA ANALYST
Feb 2021 - Oct 2023 Emergent Wireless Solutions, New Jersey, USA Assisted in analyzing datasets to uncover trends and provide actionable insights that supported decision-making processes.
Created basic reports and visualizations using tools like Tableau and Power BI to present data in a clear and accessible format.
Supported data preparation and cleaning efforts, ensuring data accuracy and consistency across projects. Worked closely with team members and senior analysts to support data-driven projects aligned with business objectives. Contributed to the development of simple predictive models, aiding customer behavior analysis. Key Contributions
Participated in a sales data project that contributed to a $250K revenue increase through data insights. Helped automate basic reporting tasks, improving efficiency and saving 10+ hours per month. Supported the creation of a customer segmentation framework to improve targeted marketing efforts. STEM INSTRUCTOR
Oct 2023 - Sep 2024 ARENA STEM, New Jersey
Designed and implemented STEM curriculum for all grade levels or for specific programs Facilitated hands-on experiments and projects in specific subjects like robotics, coding, physics, etc. Implemented differentiated instruction to accommodate various learning styles and abilities Guide and support students in understanding and applying scientific principles, technological skills, engineering concepts, and mathematical reasoning
Utilized technology tools and software to enhance learning experiences, such as [Creality/Phyton]. Led interactive sessions where students assembled, programmed, and tested drones, Sphero robots, and robotic arms while using 3D printers to design and create functional models. Collaborated with colleagues to align curriculum with state standards and educational best practices Developed and implemented a comprehensive STEM curriculum, integrating drone dynamics, robotics (including Sphero and robotic arm technology), and 3D printing to enhance hands-on learning Developed, conducted hands-on workshops where students built and programmed drones, Sphero robots, robotic arms, and robotic Lego systems, incorporating block-based coding and Python for enhanced interactivity Collaborated with colleagues to create interdisciplinary projects, integrating drones, robotics, coding, and 3D printing across the broader curriculum
PROJECTS
GOOGLE SHARE DATA THROUGH THE ART OF VISUALIZATION Describe the use of data visualizations to talk about data and the results of data analysis. Identify Tableau as a data visualization tool and understand its uses. Explain what data driven stories are including reference to their importance and their attributes. Explain principles and practices associated with effective presentations. Worked with team members and clients to align visualizations with business needs and ensure effective communication of findings.
Designed engaging and impactful visual narratives to communicate complex data trends and insights to non-technical audiences.
GOOGLE PROCESS DATA FROM DIRTY TO CLEAN
Define different types of data integrity and identify risks to data integrity. Develop basic SQL queries for use on databases.
Apply basic SQL functions to clean string variables in a database. Describe the process of verifying data cleaning results. Utilized tools like Google Sheets, Excel, and SQL to clean and organize raw, unstructured data, removing inconsistencies, duplicates, and errors.
Identified data anomalies and implemented solutions to resolve errors that could impact downstream analysis. Partnered with team members to define data requirements and establish processes that aligned with project goals. GOOGLE ASK QUESTIONS TO MAKE DATA-DRIVEN DECISIONS Explain how the problem-solving road map applies to typical analysis scenarios. Discuss the use of data in the decision-making process. Demonstrate the use of spreadsheets to complete basic tasks of the data analyst including entering and organizing data. Describe the key ideas associated with structured thinking. Defined clear, actionable business questions to guide data collection and analysis processes. Extracted relevant data from multiple sources, ensuring alignment with the project's key objectives. Formulated hypotheses based on initial data exploration to address business challenges and uncover potential opportunities.
Leveraged tools like Excel, SQL, and Python to analyze datasets and generate meaningful insights. Presented data-driven recommendations to stakeholders, providing clear evidence to support strategic decisions. Created visual aids using Tableau and Google Sheets to simplify complex data and effectively communicate findings. Worked with cross-functional teams to align analysis goals with organizational priorities, ensuring actionable outcomes. Refined analysis based on feedback and additional questions, promoting continuous improvement in decision-making processes.
GOOGLE FOUNDATIONS: DATA, DATA, EVERYWHERE
Define and explain key concepts involved in data analytics including data, data analysis, and data ecosystems. Conduct an analytical thinking self assessment giving specific examples of the application of analytical thinking. Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics. Describe the role of a data analyst with specific reference to jobs. Gained foundational knowledge in data lifecycle stages, including collection, storage, analysis, and visualization. Gained hands-on experience with tools such as Google Sheets, SQL, and basic visualization tools to manage, analyze, and present data.
GOOGLE ANALYZE DATA TO ANSWER QUESTIONS
Discuss the importance of organizing your data before analysis by using sorts and filters. Convert and format data.
Apply the use of functions and syntax to create SQL queries to combine data from multiple database tables. Describe the use of functions to conduct basic calculations on data in spreadsheets. Conducted initial exploration of datasets to identify key variables, trends, and potential questions to answer using data analysis.
Collaborated with team members to develop specific, actionable questions based on business needs and the available data.
GOOGLE PREPARE DATA FOR EXPLORATION
Explain what factors to consider when making decisions about data collection. Discuss the difference between biased and unbiased data. Describe databases with references to their functions and components. Describe best practices for organizing data.
Conducted thorough data cleaning to remove inconsistencies, duplicates, and errors, improving data quality and reliability.
Documented data cleaning and transformation processes, ensuring transparency and repeatability for future projects. GOOGLE PROCESS DATA FROM DIRTY TO CLEAN
Define different types of data integrity and identify risks to data integrity. Apply basic SQL functions to clean string variables in a database. Develop basic SQL queries for use on databases.
Describe the process of verifying data cleaning results. Applied data cleaning techniques to transform raw, unstructured datasets into clean, usable formats, ensuring data accuracy and consistency.
Validated cleaned data against predefined rules and standards, ensuring integrity and accuracy for reliable analysis. GOOGLE DATA ANALYTICS CAPSTONE CASE STUDY
Identify the key features and attributes of a completed case study. Apply the practices and procedures associated with the data analysis process to a given set of data. Discuss the use of case studies/portfolios when communicating with recruiters and potential employers. Gain a competitive edge by learning AI skills from Google experts. Defined business objectives and key questions, identifying relevant datasets to analyze and support data-driven decisions.
Gathered raw data from multiple sources, cleaned and preprocessed it using Python, SQL, and Excel ensuring accuracy and consistency for analysis.
Conducted in-depth exploratory analysis to uncover patterns, trends, and insights within the data, using statistical methods and visualizations.
Applied statistical techniques and built basic predictive models to answer business questions and predict future trends based on historical data.
Created compelling visualizations and interactive dashboards using Google Data Studio, Tableau, and Power BI to communicate findings and insights clearly.
Provided actionable recommendations and strategic insights to solve real-world business problems, guiding decision- making with data-backed evidence.
CERTIFICATIONS
SHARE DATA THROUGH THE ART OF VISUALIZATION
https://coursera.org/share/2d9d57c93b74ceef5c25a270d7cac99b ASK QUESTIONS TO MAKE DATA-DRIVEN DECISIONS
https://coursera.org/share/ebc8955ec2d789fa218f1fcd298c767d FOUNDATIONS: DATA, DATA, EVERYWHERE
https://coursera.org/share/0a3fa0c16e49b932714a4772f27729d5 ANALYZE DATA TO ANSWER QUESTIONS
https://coursera.org/share/b3d8305b4cf0715e6197349b4e1a0dc5 PREPARE DATA FOR EXPLORATION
https://coursera.org/share/b82e2f7fce3d411106fe0cab3c683e16 PROCESS DATA FROM DIRTY TO CLEAN
https://coursera.org/share/be904a1030d88f690b5893daf2919b82 GOOGLE DATA ANALYTICS CAPSTONE: COMPLETE A CASE STUDY https://coursera.org/share/1f8325aa9fb430ead50ba846c699143b SKILLS
SQL/MS ACCESS/R TABLEAU INNOVATIVE AND SKILLED IN CREATIVE THINKING TEAMWORK/ABILITY TO WORK COLLABORATIVELY SQL EXCEL (ADVANCED) DATA VISUALIZATION MS OFFICE ABILITY TO WORK UNDER TIGHT DEADLINE
STRONG WRITTEN & VERBAL COMMUNICATIONS SKILLS COLLABORATION & TEAM BUILDING GOOGLE ANALYTICS MACHINE LEARNING PREDICTIVE MODELING DATA-DRIVEN REPORTING