B.com -
Delhi University
Delhi, Delhi, India05-2016
Farukh
Ghaziabad
Summary
Excellent and Dynamic BI Professional with over 8+ years of experience in MIS, SQL, PowerBI, Analytics, Automation, Development, Reporting and Dashboard. Seeking opportunity to work in a friendly and fast-growing environment where my analytical and methodical skills will be of great value in achieving the company's missions and goals.
Education
Intermediate -
L.N. Girdhari Lal Sr. Sec. School
Delhi, Delhi, India06-2012
High School -
Sophia Inter College
Loni, UP, India06-2010
Skills
- SQL Development
- DDL, DML, DCL, TCL, DQL
- Databases and Database Objects like Schemas, Tables, Temp Tables, Views, Indexes, Stored Procedures, Cursor, Triggers, User Defined Functions
- Select, Insert, Update, JOINs, Partitions, Aggregations, Operators, SQL Clauses, Constraint, (Window, Date, Numeric, String and Advance Functions), CTEs, Sub-Queries, etc
- Backup (Full, Differential, Transaction Log) & Restore Databases
- Performance Tuning & Query Optimizations
- BI Development
- Power BI Desktop, Power Query and Power BI Service
- Data Modeling
- Star Schema, Snowflake Schema
- Snowflake
- Dax, MDX, M Language
- Reports & Dashboard
- Excel Automation
- VBA, Macros
- Advance Excel Function and Formula – (Vlookup, HLookup, Xlookup, Sumproduct, Index, Offset, Find, Mid, Left, Right, Max, Min, Maxa, Maxifs, Error Handling, Naming Range, If, Count, Counta, Countif, Sum, Sumif, Advance Filter, Nested If, Match, Indirect, Choose)
- Conditional Formatting, Pivot Table, Charts (Column, Line, Pie, Bar, Area, Histogram, Combo)
Languages
Hindi
First Language
English
Advanced (C1)
C1
Urdu
Upper Intermediate (B2)
B2
Timeline
BI Developer
Practus Advisors Pvt. Ltd.
05.2023 - 04.2024
BI Developer
Eazy ERP Technologies Pvt. Ltd.
04.2021 - 05.2023
BI Developer
Geton Infotech Pvt. Ltd.
11.2019 - 04.2021
Data Analyst
Oppo Delhi Pvt. Ltd.
06.2019 - 11.2019
Process Associate - MIS Executive
Competent Software Pvt. Ltd.
06.2016 - 06.2018
B.com -
Delhi University
Intermediate -
L.N. Girdhari Lal Sr. Sec. School
High School -
Sophia Inter College
Work History
BI Developer
Practus Advisors Pvt. Ltd.
Mumbai, Maharashtra
05.2023 - 04.2024
- Designing, developing, and maintaining Power BI Reports and Dashboards to meet business needs
- Gathering requirements from Stakeholders and translating them into data visualization solutions
- Creating Dataset and Dataflows within Power BI services to ensure accurate and efficient data analysis
- Using Premium Per User (PPU) License in Power BI
- Created Multiple Workspace in PowerBI Services for dividing the reports
- Installed Gateway to activate Scheduler for refresh the report on daily basis
- Created report in Mobile Layout mode for mobile apps like iOS, Android, and Windows devices, allowing users to access and interact with their reports and dashboards on the go
- Managing all Reports Access of the users and give them access according to their need
- Worked on BI Projects (B2B, B2C, P&L and Balance Sheet)
- Doing Changes in Report according to clients need
- Implementing security measures, such as Role-Based Access control and data encryption, to protect sensitive information
- Staying updated on the Latest Features and best practices in Power BI and data visualization
BI Developer
Eazy ERP Technologies Pvt. Ltd.
Gurugram, Haryana
04.2021 - 05.2023
- Develop and manage Power BI solutions
- Working on Power BI visualization tool and embedded the reports in Portals
- Created many attractive Dashboard with using multiple charts & graphs like combo chart, tree map chart, donut charts and map charts etc
- Worked on many BI Projects like (Sales Dashboard, CFY vs LFY Sales Compare, MTD, QTD, YTD Reports, Monthly, Quarterly & Yearly Sales Comparison, Category Wise Performance, Executive Dashboard, Performance Dashboard, Value Business Trend, Monthly Trend, Primary vs Secondary Sales Comparison, Target vs Achievement, Financial Year Wise Sales Comparison etc.)
- Write programming scripts and use common BI tools to analyze data and find past and present market trends
- Coordinate with the IT Department to make the necessary custom build software upgrades
- Postgres SQL Server skills including SQL objects development, performance tuning, data analysis and integration
- Doing Changes in the Reports of DMS like Columns Addition & Deletion and Calculations
- Enable Reports same as available in other Clients
- Adding Attributes in reports from another table
- Enable filters in DMS Reports
- Enable Forms of every Master like Item Master, Dealer Master, Distributor Master, City Master, State Master, Zone Master
- Having good knowledge of FMCG Data
BI Developer
Geton Infotech Pvt. Ltd.
Noida, Uttar Pradesh
11.2019 - 04.2021
- Maintain & Develop new Dashboards/Reports & manage multiple Task & Projects
- Create strategies for workflow models and design database structure into SQL server to prepare unruly data for Dashboard
- Create configurations Tables, Stored Procedure, User define function in SQL Server
- Initial point of contact for any new initiative around BI, Automation, Reporting or ETL/Data mining
- Introduced & implemented Microsoft Power BI for business growth and easily analyze the data with the help of dashboard
Data Analyst
Oppo Delhi Pvt. Ltd.
Delhi
06.2019 - 11.2019
- Prepare DSR (Daily Sales Report) for management
- Provide Monthly and Weekly agents performance report to the operation team
- Create Organization Revenue Tracker
- Cost Analysis
- Preparing Pay-out Report
- Created 5 Project with the help of VBA which has improved accuracy of work, time saving and increased volume in the business
Process Associate - MIS Executive
Competent Software Pvt. Ltd.
Noida, Uttar Pradesh
06.2016 - 06.2018
- Automation of various ongoing reports using VBA to saves time and manual efforts of the end users
- Expert in Advanced Excel and its features like Pivot Tables, Charts, Functions & Formula
- Data Maintenance, Reconciliation, Review, Analyses
- Discrepancy coming in the data and resolving the issue
- Worked on USA Property Document's like Tax Lien, Release Lien & Loan Documents like Deed, Deed of Trust, Mortgage, State Tax Lien, Federal Tax Lien, Release of Mortgage etc
- Responsible for giving Quality work to the organization
- Responsible for obeying any kind or rules & regulations made by the organization
Languages
- English
- Hindi
- Urdu
Personal Information
- Father's Name: Mr. Abrar Ali
- Date of Birth: 02/09/94
- Marital Status: Married
- Religion: Muslim
Disclaimer
I hereby declare that the above-mentioned information is true and correct to the best of my knowledge and I bear the responsibility for the correctness of the above-mentioned. (farukh)
Languages
- English
- Hindi
Personal Information
- Father's Name: Mr. Abrar Ali
- Date of Birth: 02/09/94
- Marital Status: Married
- Religion: Muslim
Disclaimer
I hereby declare that the above-mentioned information is true and correct to the best of my knowledge and I bear the responsibility for the correctness of the above-mentioned. (farukh)
Overview
8
8
years of professional experience
Similar Profiles
Suraj A SinghSuraj A Singh
Engagement Manager (India Delivery) at Practus AdvisorsEngagement Manager (India Delivery) at Practus Advisors
Nilima GuptaNilima Gupta
Assistant Manager-Client Success at Practus Advisors Private LimitedAssistant Manager-Client Success at Practus Advisors Private Limited
PRADEEP BANJANPRADEEP BANJAN
Manager - Client Success at Practus Professional Services Pvt LtdManager - Client Success at Practus Professional Services Pvt Ltd
Vidhya SagarVidhya Sagar
Advisory Specialist Master at DeloitteAdvisory Specialist Master at Deloitte
Khushi BhatnagarKhushi Bhatnagar
Physiotherapist Intern at Shri Mahant Indiresh HospitalPhysiotherapist Intern at Shri Mahant Indiresh Hospital