Syed Sarfaraz Ahmed Portfolio

Intro

Hey there, data voyagers! 👨‍💻 I'm a B.Tech graduate from KG Reddy College of Engineering and Technology, riding the waves of technology with a penchant for delving deep into the vast data oceans. Proficient in MS Excel, MySQL, Python, and the enchanting world of Power BI, consider me your go-to wizard for anything from Data Analysis, Cleaning, Visualization to crafting intricate models. My journey through the realm of data began at Trainity, where I honed my skills under expert guidance. The certification journey has been nothing short of a thrilling adventure, with badges from Forage, Simplilearn, Internshala, Microsoft, and Cisco – covering Python, Data Science, Data Visualization, and Data Analysis. As the proud holder of the coveted Data Analytics Essentials certification from Cisco and Microsoft, I'm equipped to decipher the complexities of data landscapes. Fresh off my AWS Cloud expedition as an intern at F13 Technologies, where I bagged six AWS partner accreditations, I've now set sail for a new horizon at Amazon as a Controllership Specialist. It's not just a job; it's a gateway to honing my professional acumen and diving into the depths of data analytics. Join me as we decode data together and unleash the potential of this exhilarating journey! 💻✨

Controllership Specialist

Amazon - Hyderabad - Full Time

Dec-2023 to Present

• Investigate, troubleshoot, and resolve invoice quality issues, demonstrating a keen attention to detail and utilizing strong deep-dive skills.
• Engage in key stakeholder calls, both internal and external, demonstrating superior verbal and written Communication skills, strong organizational abilities, and effective stakeholder management.
• Leveraged advanced SQL skills to efficiently extract, manipulate, and merge data from diverse databases and systems, simplifying complex data for easy analysis and business decision-making.
• Work alongside the program management team to update and enhance existing tools, contributing to the automation of support processes, and actively participating in the documentation of systems.
• Creating SOP’s, Audit documents and Quarterly business reports for decision making and strategic planning.

AWS Cloud Intern

F13 Technologies - Remote - Internship

Jul-2023 to Nov-2023

• Lead a 5-member team in researching companies that successfully migrated to AWS and also to complete multiple projects.
• Hosted a Dynamic Website using AWS - EC2, RDS and S3.
• Learned about Application of Different Cloud Services.
• Completed Multiple AWS Partner Accreditations.

Data Analytics Intern

Trainity - Remote - Internship

Aug-2022 to Nov-2022

• Completed a guided internship under Experienced Data Analyst and Data Scientists, gaining practical experience in data analysis.
• Analyzed business case studies and addressed problems by applying data analysis techniques.
• Utilized Visualization tools to create insightful visual representation of the data.
• Applied the Data Analytics life cycle, Using SQL and Python to extract, clean, analyze and visualize data.
• Built Key Performance Indicators table and used different metrics to convey the analytics in an efficient manner.

SURVEY BREAKDOWN

Personal Project

Tech Stack - Power BI (Power Query, DAX)

• This project is dedicated to examining and breaking down the results of a survey conducted among professionals in the field of data analysis and provide relevant visualization for the analysis
• Created a dashboard with Power BI to represent different relations and scenarios in people are facing in their professional career
• Cleaned, Transformed and processed the data by using DAX and Excel learnings
• To view the project click Here

COVID ANALYSIS

Personal Project

Tech Stack - SQL, Excel

• Utilized SQL to extract data from 2 different related tables from Covid Deaths and Vaccines databases using JOIN and VIEW
• Transformed and filtered data by using aggregating and filtering function to improve reporting process
• Exploratory Data Analysis on "Covid disease in India and Across Globe" and "Covid vaccination in India and Across Globe". Report some quantities to see the pandemic behavior from Jan-2020 to Apr-2021.
• To view the project click Here

DIVERSITY & INCLUSION

PwC Virtual Experience - Forage

Tech Stack - Power BI, Excel

• Creation of a dashboard in Power BI reflecting all relevant Call Centre's Key Performance Indicators (KPIs)
• Performed data cleaning and text analysis to successfully identified the major complaints for each airline
• Performed Data Cleaning and Preprocessing using Excel then connected the dataset to Power BI to generate powerful visualization and drew insights from it
• To view the project click Here

IG CLONE

Intership - Trainity

Tech Stack - SQL, Excel

• Created a Database with 7 different tables which could represent different features of Instagram
• Utilized SQL to extract data from 2 different related tables from Covid Deaths and Vaccines databases using JOIN and VIEW
• Transformed and filtered data by using aggregating and filtering function to improve reporting process
• This Dataset consist of multiple table which represent different feature similar to that of Instagram such as Users, Photos, Comments, Likes and others.
• Performed and provided solutions for different KPIs
• To view the project click Here

EDA - BANK LOAN CASE STUDY

Internship - Trainity

Tech Stack - Python, Excel

• This case study aims to give you an idea of applying Exploratory Data Analysis (EDA) in a real business scenario.
• In this study, apart from applying the techniques from EDA module, you will also develop a basic understanding of risk analytics in banking and financial services
• Utilized Python to analyze the entire dataset and gain insights on which customers are capable of repaying the loan
• Aggregated and visualized the data by using pandas, matplotlib and word to compile a professional report
• To view the project click Here

About

Top Skills : Microsoft Excel, Microsoft Power BI, SQL, Python and Data Analysis

Greetings! I am a dedicated data enthusiast holding a B.Tech degree in ECE from KG Reddy College of Engineering and Technology. My professional narrative revolves around the enchanting world of data, where I wield proficiency in MS Excel, MySQL, Python, and the captivating realm of Power BI. From decoding complex datasets to cleaning intricate information and crafting visually stunning visualizations, I am your trusted data sorcerer.

My journey into the data realm commenced with a guided internship at Trainity, offering me the chance to apply my skills in a practical setting and accumulate invaluable hands-on experience. This marked the beginning of my relentless pursuit of knowledge, earning certifications from distinguished institutions such as Forage, Simplilearn, Internshala, Microsoft, and Cisco. My expertise spans across Python, Data Science, Data Visualization, and Data Analysis, culminating in the recent attainment of prestigious certifications in Data Analytics Essentials from both Cisco and Microsoft.

Recently, I completed my internship as AWS Cloud Intern at F13 Technologies. Throughout this engagement, I have demonstrated my commitment to staying at the forefront of cloud technology by achieving six AWS partner accreditations.

The next chapter in my journey brings me to Amazon as a Controllership Specialist. This role marks a pivotal point in my professional evolution, allowing me to leverage my skills while delving deeper into the intricacies of data analytics. The challenges and opportunities that come with this position align seamlessly with my career aspirations, promising growth, and a platform to contribute meaningfully to Amazon's mission. Join me on this exciting venture as we navigate the dynamic landscapes of data and professional development!

Contact

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';