Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Ayub Shaik

Ayub Shaik

Hyderabad

Summary

Analytical thinker leverages problem-solving skills to drive continuous improvement. Works cross-functionally to adapt systems to changing business needs and formulate winning solutions.

Overview

9
9
years of professional experience
2
2
Certifications

Work History

Fact Data Analyst

Real Page India Pvt Ltd
01.2024 - Current
  • Responsible of handling entire commercial data from legacy system to identify the accurate data before migrated into Oracle cloud.
  • Responsible of maintaining documentation of any analysis completed and subsequent data enhancements.
  • Responsible of creating Data dictionaries from Target system and ERD.
  • Enhanced data-driven decision making by implementing advanced analytics tools and techniques.
  • Utilized data visualization tools(Power-BI) to effectively communicate business insights which helps C level executives to take a accurate decision.
  • Created DAX queries to generate computed columns in Power-BI.
  • Created Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
  • Developed customized data analytics solutions for specific client needs, leading to increased customer satisfaction.
  • Wrote and updated complex SQL queries to extract and merge data from variety of sources.
  • Translating business goals into Technical specifications.

Data Analytics and BI Administration

Vialto Partners
05.2023 - Current
  • Transformed the data and developed reports using the Power BI platform.
  • Created Power BI UX standards for the dashboards, ensuring consistency in design and ease of use for end-users.
  • Analyzed business requirements and created key performance indicators (KPI's) to effectively measure progress and success.
  • Developed dashboards utilizing different visualization such as charts, tables, matrixes and custom Charts.
  • Created DAX queries to generate computed columns in Power-BI.
  • Removed the noise in the data and performed transformations according to requirement.
  • Created RLS (row level Security) on financial data to restrict access to sensitive data and ensure data confidentiality and integrity.
  • Collaborated with cross-functional teams to identify the data sources.
  • Created interactive visuals to improve user experience and allow easy interaction between the Visuals.
  • Created bookmarks and buttons in Power BI reports to store default filter selections and improve analysis efficiency.
  • Implemented data analytics approach to evaluating operational processes and improving efficacy of sales.
  • Used client data, analytics, market trends and industry insights to effectively communicate value to new clients.
  • Translating business goals into technical specifications.

Data Integration Analytics

CBRE South Asia Limited
10.2021 - 05.2023
  • Gathering requirements from the Property Manager to understand the data to structure it into the PostgreSQL with the help of Data portal.
  • Generated and Ingested client Rent and financial files on monthly basis to the data portal with the help of python.
  • Analyzed business requirements and created key performance indicators (KPI’s) to effectively measure progress and success.
  • Utilized Power BI to design financial dashboards that highlighted critical KPI’s related to revenue and budget.
  • Developed dashboards utilizing different visualization such as charts, tables, matrixes and custom Charts.
  • Removed the noise in the data and performed transformations according to requirement.
  • Segregated the data according to the user’s requirement to create a separate config’s using PostgreSQL which helps user to check the monthly basis records in Yardi tool.
  • Worked with clients to understand business needs and translate those needs to actionable reports in Yardi.
  • Having good understanding on Commercial and financial investment business domain.
  • Converted data into actionable insights by developing financial dashboards.
  • Having good experience in mapping commercial and financial accounts in Yardi tool.
  • Showcased the model results in a user-friendly manner with interactive graphs developed using Power BI.
  • Coached to new interns and launched mentorship program for the new joiners.
  • Received rising star and performance Excellence award in Q1 , Q3 & Q4.

Technology Analyst

Infosys Limited
07.2019 - 10.2021
  • Built Machine Learning models for the retailer client based on the existing customer’s data and forecasted the sales for the next 15 days.
  • Performed Exploratory data analysis such as data dispersion, Correlation matrix on the given set of parameters and captured meaningful insights from the data using power-BI and Tableau.
  • Data processing was done on the data to handle Noise, remove influential observations.
  • Built regression models and tuned the models.
  • Multiple Linear Regression, Decision Tree, Random Forest machine learning models are used to sales forecasting in Python.
  • Showcased the model results in a user-friendly manner with interactive graphs developed using Python modules and Power-BI.
  • Monitoring Oracle Enterprise manager to analyze the database.
  • Monitoring Database growth and space administration.
  • Work with the system DBAs to implement changes and performance improvements.

Database Administrator

HCL Technologies
06.2016 - 07.2019
  • Database Creation (DDL,DML,DCL) and creating tables, indexes, synonyms, sequences & profiles.
  • Perform Back-up Restores from RMAN and Expdp and Impdp.
  • Monitoring Oracle Enterprise manager to analyze the database.
  • Killing Long running session for blocking impact on database performance.
  • Experience in trouble shooting and resolving database issues, blocking and deadlocking issues, connectivity issues and feasible preliminary knowledge on Linux knowledge.
  • Written SQL queries using joins to gather the relevant Data.
  • Experience in working Business Analysis and UAT.

Education

PGP in Data Analytics and Machine Learning - Computer Science

International School of Engineering
Hyderabad
09.2019 - 03.2020

B.Tech - Computer Science Engineering

St Martins Engineering College

Skills

Database programming and SQL

Certification

Oracle Certified Associate in 11g and Sql.

Timeline

Fact Data Analyst

Real Page India Pvt Ltd
01.2024 - Current

Data Analytics and BI Administration

Vialto Partners
05.2023 - Current

Data Integration Analytics

CBRE South Asia Limited
10.2021 - 05.2023

PGP in Data Analytics and Machine Learning - Computer Science

International School of Engineering
09.2019 - 03.2020

Technology Analyst

Infosys Limited
07.2019 - 10.2021

Database Administrator

HCL Technologies
06.2016 - 07.2019

B.Tech - Computer Science Engineering

St Martins Engineering College

Similar Profiles

CREATE PROFILE
Ayub Shaik