About Me

I am a hard working business intelligence data warehouse professional, experienced in Hadoop Ecosystem, Microsoft Power BI, Scala, Python, R and SQL Server. I received a BBA in Computer Information Systems from Georgia State University and recently finished a MS in Business Analytics from University of Houston. I have current knowledge of data analysis, data clean up, interpretation and visualization using modern programming languages and visualization tools.

Contact Details

Ifraz Ahmed
Houston, TX
IfrazAhmedProfessional@gmail.com

Download Resume

Education

University of Houston

Master of Science in Business Analytics • December 2021

• Developed R applications for data transformation, management and visualization.
• Created entity relationship diagrams, and data models for organization within a DBMS.
• Applied statistical modeling to data sets to uncover trends useful to business.
• Performed data understanding and research understanding phases of CRISP-DM to predict CLABSI infection for Texas Children's Hospital.
• Reported on cases and deaths involving COVID-19 using a S3 dataset to uncover why certain countries managed the pandemic better than others with similar population density and demographics.

Georgia State University

Bacherlor of Business in Computer Information Systems • May 2018

• Plugged in source code from GitHub into IBM Watson to predict an individual’s personality traits from sample text entered by the user.
• Team leader responsible for upgrading the existing systems in Golf Course Country Club that is experiencing increased stress on its bookings, maintenance and human resource departments due to growth in membership.
• Created mathematical and graphical models using Microsoft Excel to interpret data into meaningful information.
• Developed skills that are overlooked in business such as active listening, how to have unpleasant conversations, and working across cultural and ethnic differences.

Georgia State University (Study Abroad)

Study Abroad Program in Nantes, France • January 2017

• Analyzed business case studies throughout various countries and identified tangible factors of success from companies that include Bank of Santander, Li & Fung Distributors and Neopets.com.
• Networked with French students and faculty to increase cultural awareness and understand cultural differences.
• Adapted to a foreign language by developing priceless intercultural communication skills.

Work

Internal Revenue Service

Data Science Fellow • June 2021 - August 2021

• Improved existing processes and methods for aggregating and using operational data to conduct research and support high priority IRS operations.
• Engineered ETL workflow by creating a scp connection between IRS Server and EdgeNode within the Hadoop Cluster.
• Designed documentation using white paper methodology for easy replicability of SparkR environment.
• Improved processing times and increased stability of R code through the implementation of SparkR.
• Performed transformations and actions on SparkR DataFrames for statistical analysis, validation, program stability, and performance improvements.

University of Houston

Instructional Assistant • December 2020 - May 2021

• Provided supplemental instruction for MBA and MS students in Quantitative Analysis (QA) and Financial Accounting (FA).
• Assisted students in understanding and internalizing fundamental concepts in QA and FA through one-on-one and group tutoring sessions.
• Collaborated with professors to highlight key topics discussed during class for supplemental instruction.

Harris County Public Health

Data Warehouse Intern • May 2019 - August 2019

• Developed Microsoft Power BI Reports visualizing at risk populations within Harris County based on household income and school enrollment with geo location, year and other relevant filters.
• Created scalar functions and stored procedures in SQL Server to validate the data contained within Power BI Reports.
• Developed a python script to extract veterinary public health data into python, apply transformations for data clean up, and load back into the correct directory to be used within the data warehouse.
• Created a program that utilized four fuzzy logic algorithms to give a confidence rating on how close an input matches a record in a table.

Digi-Safari

Hadoop and Spark Developer Boot Camp • March 2018 - July 2018

• Transformed data in Spark leveraging SQL Context and Hive Context APIs to discover most profitable variables.
• Performed import and export operations on customer data between RDBMS and HDFS operating Sqoop.
• Ingested data into Spark-Shell using Avro, Parquet, JSON, CSV, TSV, and text file formats; transformed into DataFrame; performed SparkSQL queries and saved back on to HDFS applying Gzip compression.
• Designed external tables in Hive, ingested JSON formatted files from HDFS, and ran queries using Hive Query Language.
• Leveraged RDD APIs to calculate aggregations of orders inside spark-shell environment.
• Installed, configured, and tested Hadoop Ecosystem inside a virtual machine environment in Virtual Box.

Languages

Programming Languages

  • Apache Spark (Spark-Shell)
  • Python
  • R
  • HDFS (Unix)
  • Apache SQOOP
  • Hive
  • SQL

Motivational Quotes

  • Five Percent of the Challenge Is the Strategy. Ninety-five Percent Is the Execution

    Carlos Ghosn

  • “Education is the most powerful weapon which you can use to change the world.”

    Nelson Mandela

Get In Touch.

If you are interested in learning more about what I can offer you and your organization please do not hesitate to shoot me an email at IfrazAhmedProfessional@gmail.com.

Error boy
Your message was sent, thank you!