Aarij Majid Nadroo Phone:806-***-**** Email: ***********.***@*****.***
LinkedIn: www.linkedin.com/in/aarij-majid
Summary:
A highly skilled and versatile Data Analyst with over 4 years of experience in data collection, modelling, and visualization, utilizing tools like Excel, Tableau, SQL, and Power BI. Adept at analysing survey data and market insights to inform strategic business decisions. Proficient in IT infrastructure management and technical troubleshooting, with a 3+ year experience in front-end web development using HTML, CSS, and JavaScript. A strong collaborator with proven abilities in delivering actionable insights and optimizing system performance across various industries.
Skills:
6+ Years as Data Analyst with proficiency in Tableau, MS Excel, SQL, Python and Power BI.
6+ Years of experience in MS Excel.
4+ Years of experience in Tableau.
4+ Years of experience in Python.
4+ Years of experience in SQL.
4+ Years of experience using ETL functions
3+ Years of experience in Power BI.
2+ Years of experience in Workday.
2+ Years of experience of Data Analytics and Representation using Alteryx.
4+ Years of experience of Data Visualization and Prediction using Tableau.
4+ Years of experience of Data Modelling using MS Excel and Tableau.
4+ Years of experience of Data Representation and Analysis using MS Excel.
2+ Years of experience of online Data Acquisition using Google Forms, Google Surveys and SurveyMonkey.
1+ Years of experience of Process Controlling using SCADA Systems.
Education:
Master of Science in Computer and Information Science, Texas Tech University, Lubbock Tx, 2022
Bachelor of Technology in Information Technology, Lovely Professional University, Punjab India, 2020
Professional Experience:
USKA Corporation, Forest Hills NY.
Data Analyst, April 2023 – Present
Responsibilities:
Conducted data collection using various methods, including online surveys, social media polls, and web-based tools, to gather user feedback and market insights.
Analysed survey results and web data to identify trends, user preferences, and areas for product or service improvement.
Assisted in gathering and analysing employee data within Workday to generate workforce reports, supporting HR and business decisions.
Collaborated with cross-functional teams to ensure accurate data integration and reporting by maintaining data quality in Workday's modules.
Conducted basic troubleshooting and data validation within Workday, ensuring the integrity of employee and payroll data for internal audits.
Designed and distributed customized surveys across platforms like Facebook, Twitter, and Instagram to target specific customer segments.
Built and maintained data models and dashboards to track key performance metrics and support decision making across departments.
Developed and presented data driven reports and visualizations using tools like Excel, Alteryx, Tableau, and Power BI to stakeholders for actionable insights.
Collaborated with cross functional teams to provide recommendations based on data analysis, leading to improved business strategies and optimized marketing efforts.
Ensured data integrity by regularly cleaning and validating datasets, improving accuracy and reliability for analysis.
City of Dallas, Dallas Tx.
Department Technology Analyst, January 2024- August 2024
Responsibilities:
Analysed Department Programs: Evaluated objectives and information requirements to design and maintain computer databases for data gathering and classification.
Managed IT Infrastructure: Oversaw the maintenance of computer operating software, hardware, and network configurations within the department or division.
Evaluated IT Purchases: Planned and assessed software and hardware acquisitions to enhance system performance, including preparing cost analyses for maintenance and upgrades.
Developed and Maintained Software: Wrote programs to extract and analyse data from databases, developed reporting formats, and created information reports.
Processed Data from Sensors: Ran programs to analyse data from electronic sensors, compiled information, and set parameters for data collection.
Maintained Information Systems: Managed multiple interrelated computer and database systems, including updating documentation and handling change orders.
Resolved Network Issues: Analysed and addressed network problems and technical difficulties to ensure smooth operation.
Enhanced Applications: Modified and maintained existing software and applications to improve system efficiency and functionality.
Troubleshot Software Problems: Analysed and resolved user issues and software problems, implementing corrective actions and new designs as needed.
Conducted Training: Provided training to users, technicians, and less experienced personnel on system usage and best practices.
Supervised Technicians: Assigned tasks and oversaw the work of technicians monitoring field sensors to ensure accurate data collection.
Utilized Mathematical Models: Applied mathematical models on mainframe systems for engineering, scientific, and business-related analyses, including reservoir levels, water flow, and financial scenarios.
Ensured Reliable Attendance: Demonstrated regular, reliable, and punctual attendance as a key component of job performance.
Texas Tech University, Lubbock Tx.
Student Assistant (Part Time), July 2021 – June 2022
Responsibilities:
Administered computer systems and components to ensure seamless operation and reliability of library services.
Oversaw and updated the library’s relational database management system (RDBMS) to accurately track and record data such as student enrolments, book checkouts, and returns.
Ensured data accuracy and consistency through regular audits, data validation, and error correction procedures.
Provided technical support to library staff and patrons, resolving system issues and ensuring minimal downtime.
Performed routine database operations including backups, restores, and performance tuning to maintain optimal system performance.
Managed software updates, patches, and system upgrades to keep library IT infrastructure current and secure.
Created and maintained comprehensive documentation for system configurations, procedures, and troubleshooting guides, generated reports on database usage and system performance.
Worked with library staff to identify and implement solutions for data management challenges and system improvements.
Cloud Wave Technologies
Junior Data Analyst, January 2017- December 2020
Performed Data Cleaning and Validation: Ensured data accuracy and consistency through cleaning and preparation processes, making datasets ready for analysis.
Conducted Data Analysis and Reporting: Utilized tools like Excel, SQL, Alteryx and Python to analyze data, uncover trends, and generate actionable insights for decision-making.
Created Dashboards and Reports: Designed and maintained interactive dashboards and visual reports using Tableau and Power BI to present data insights to stakeholders.
Developed SQL Queries: Wrote efficient SQL queries to extract and manipulate data from relational databases, supporting analysis and reporting tasks.
Collaborated with Cross-Functional Teams: Partnered with marketing, finance, and product development teams to understand data requirements and provide analytical support.
CERTIFICATIONS
Google Advanced Data Analytics Certification
Excel Power Tools for Data Analysis from Macquarie University
Certification in Data Analysis using MS Excel
Certification in Introduction to MS Excel
Certified HTML Programmer
Certified in Data Handling using Python
CAMPUS and COCURRICULAR ACTIVITIES
VP Standards and Public Relations, Alpha Lambda Mu
Volunteer Event Coordinator, Muslim Student Association
Team Member, North India U 21 Cricket team (2014-15)