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
Data Modeling
Data science
Power-BI
Data Anlaytics
Postgresql
Oracle Database
Business Analysis
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
Oracle Certified Associate in 11g and Sql.
PGP in Data Analytics & Machine Learning.
Similar Profiles
R Rama KrishnanR Rama Krishnan
Customer Care Executive at Page Point Services (INDIA) PVT. LTD.Customer Care Executive at Page Point Services (INDIA) PVT. LTD.
Courtney McCormickCourtney McCormick
Sales Support at Page & Pearce Real EstateSales Support at Page & Pearce Real Estate
J Anna ChenJ Anna Chen
Contract Photographer at Real PageContract Photographer at Real Page