Data Analyst Big

+1-610-***-**** My LinkedIn

FAIYAZ HUSSAIN SHEIK ******************@*****.***

SUMMARY

Experienced Data Analyst specializing in data engineering, with a focus on designing, developing, testing, and debugging big data applications using various technologies in hybrid cloud environments (GCP and AWS). Skilled in writing, analyzing, and tuning complex SQL queries, writing ELT jobs, and optimizing ETL processes. Proven ability to import and export large amounts of data in various formats (CSV, JSON, Parquet) and solve complex performance problems related to big data usage. Seeking a role where I can leverage my expertise to contribute to a dynamic team environment.

EDUCATION

Master of Science in Business Analytics University of New Haven, Connecticut Dec-2023

Master of Computer Applications Osmania University, India Jun-2017

Technical Skills

Programming Languages : SQL, Python, R, PL/SQL, Bash

Data Analysis & Visualization Tools : Power BI, Tableau, Grafana, Visio, Matplotlib, Seaborn, Looker Studio, Mode, Qlik

Data Formats : CSV, JSON, Parquet

Databases : Oracle, MySQL, SQL Server, MongoDB, Teradata

Cloud Technologies : AWS (Redshift, S3, Lambda), Azure, Google Cloud, Snowflake, BigQuery, PowerQuery

ETL & Data Integration : SQL Loader, MS Dynamics 365, SAP, Unix Shell Scripts, ERP System

CI/CD & DevOps Tools : Jenkins, Bamboo, Ansible, Maven, Terraform, Docker, Kubernetes

Web Services & APIs : REST, SOAP, AWS, Microservices, Flask

IDEs : SSMS, RStudio, DBeaver, Anaconda, PyCharm, VBA

Other Tools : MS Office Suite (Excel, Word, PowerPoint, Outlook), Google Sheets Jira, DBT Compiler, Puppet, SSRS

PROFESSIONAL EXPERIENCE

Data Analyst – PeopleTech Group Inc, MI, USA

Client – General Motors Mar 2024- May 2024

Data Analysis CRM Python SQL Tableau AWS Data Wrangling Data Cleaning Data Mining Data Extraction ERP System

Developed and maintained business intelligence dashboards and reports using Tableau to communicate trends, patterns, and predictions.

Collaborated with sales and marketing teams to collect and analyze data on car sales and customer preferences, increasing sales conversion rates by 15%.

Led the implementation of ERP system integration, resulting in a 20% increase in operational efficiency.

Utilized SQL and Python to extract, clean, and preprocess data from various sources, reducing data processing time by 25%.

Conducted in-depth data analysis to identify sales trends and provide recommendations for sales strategies, increasing forecast accuracy by 30%.

Employed AWS tools for data storage, warehousing, and visualization, enhancing data accessibility and reporting capabilities.

Spearheaded robotics process automation initiatives, leading to a 15% decrease in process cycle time.

Data Analyst – Wipro Limited, India

Client – GE Healthcare Technologies Inc Feb 2021- Aug 2022

Power BI SQL Python Data Visualization Data Engineering Predictive Modeling HIPAA Compliance Dashboard Design SSRS

Partnered with business stakeholders to gather requirements, execute analytics requests, and provide domain expert support.

Developed dashboards and reports using Power BI, increasing data visibility and enhancing sales and marketing insights by 25%.

Utilized SQL and Python for data extraction, preprocessing, and analysis, improving data processing efficiency by 20%.

Ensured data quality and HIPAA compliance, maintaining 100% compliance throughout the project.

Conducted in-depth analysis of data sets and trends, identifying anomalies, outliers, and trend changes to uncover valuable insights and opportunities for process optimization.

Developed and maintained data warehouse architecture, reducing data retrieval time by 30% and enhancing reporting accuracy.

Designed and generated SSRS reports, ensuring accurate and timely delivery of key metrics to stakeholders across the organization.

Proficient in designing, developing, and optimizing ETL processes using various tools and programming languages to ensure efficient data ETL of workflows.

Data Analyst – Wipro Limited, India

Client – Citibank NA Oct 2018 - Jan 2021

Data Analysis Data Modeling SQL Python Machine Learning Tableau Docker RESTful APIs MS Dynamics 365

Extracted and analyzed data using SQL and Python, reducing data retrieval times by 20%.

Conducted exploratory data analysis (EDA) using Matplotlib and Seaborn to identify key trends, improving decision-making processes by 15%.

Developed machine learning models with scikit-learn to predict and forecast loan defaults, achieving an 85% accuracy.

Maintained comprehensive documentation of BI solutions and systems, including process flow diagrams and data specifications.

Produced over 50 comprehensive reports and visualizations using Power BI, enabling stakeholders to make data-driven decisions efficiently.

Deployed predictive models using Docker and created RESTful APIs with Flask, streamlining predictive analytics integration.

Junior Data Analyst – Wipro Limited, India

Client – Wipro Consumer Care & Lighting Jul 2017 - Sep 2018

SQL Python Tableau Data Cleaning Data Preprocessing Machine Learning Data Governance SQL Server Management Studio (SSMS)

Queried relational databases using SQL and Oracle, improving data retrieval efficiency by 15%.

Utilized Python for data cleaning, preprocessing, and data science and data engineering, reducing data processing errors by 20%.

Investigated system or process-related issues, providing timely resolution and recommending process improvement opportunities.

Implemented machine learning algorithms for demand forecasting and inventory optimization, achieving a 10% improvement in inventory management.

Documented insights using Microsoft Office Suite and ensured version control with Git, enhancing project documentation and collaboration.

ACADEMIC PROJECTS

Microsoft Power BI Project

Risk Analysis Historical Data Data Visualization

Conducted a comprehensive risk analysis using Power BI, leveraging historical data to identify potential risks and opportunities for the organization.

Applied statistical analysis techniques on historical data to uncover trends, patterns, and anomalies, contributing to informed decision-making.

Created interactive dashboards in Power BI, showcasing historical data trends, risk assessments, and recommended action plans for strategic decision-making.

Interactive Data Visualization Shiny App

R Programming Shiny App Data Visualization User-Defined Graphs

Developed an interactive Shiny application using R programming, offering a user-friendly interface to generate custom graphs from diverse datasets.

Implemented a flexible system that allows users to choose any dataset format, including SQL, Excel, or CSV files, enhancing data accessibility and usability.

Designed the Shiny app to dynamically generate graphs based on user-defined preferences, enabling the selection of X and Y axes for tailored visualizations.

Additional Informational

Skills – Leadership, Quick Learner, Strong Attention to Detail, Problem Solving, Project Management, Self-Starter, Client Relations, Troubleshooting & Testing Skills, Strong Communication Skills, Collaborative Team Player, Data Governance, Customer Facing, Adaptability to Change, Customer-facing, Time Management, Creative Problem Solver, Solid Project Management Skills, Ability to Manage Multiple Projects Simultaneously, strong interpersonal skills, ability to work cross-functionally and team player.

Accomplishments at Wipro Limited

Handled different roles for Wipro expertise in data analytics and business intelligence.

Other Initiatives:

Organizing Donation Drives during Covid times: Coordinating and leading efforts to collect food, toiletries, masks, sanitizers, and other essential items through donation drives within the community.

Partnering with Organizations: Collaborating with local charities, food banks, or non-profit organizations to streamline the distribution process and reach a larger number of people in need.

Community Outreach: Raising awareness within the community about the needs of underprivileged individuals and encouraging others to contribute through donations or volunteer work.

Ensuring Safety Measures: Implementing safety protocols to ensure the health and well-being of both volunteers and recipients during the distribution process.

Contact this candidate