Business Intelligence Power Bi

Created with

Rubal Vilku

*****.*****@*****.*** +1-970-***-**** LinkedIn Tableau Public

Previous

role

Business Intelligence and Reporting

Analyst at American Homes-Colorado

Experience Property, Enterprise, Marketing

Technologies SQL, Python, Tableau, Power BI, MySQL, Confluence, Excel, Salesforce, JIRA,

Active Directory, ServiceNow, Zoho

At work I'm best at...

I love to solve problems and take pride in my

exceptional memory skills. I am trained dentist and have quite good knowledge of customer support,

sales, healthcare and technology.

• Tracked relevant KPI’s and metrics for the Leasing department such as occupancy rates, lease expirations and renewals.

• Conducted thorough Quality Assurance and User Acceptance Testing on developed and enhanced SQL codes, dashboards, and reports to ensure they were production ready.

• Employed advanced data visualization techniques, including Level of Detail (LOD) Expressions, Time Intelligence, Scatter Plots with Trend Lines, Tree maps and Heatmaps to present complex data intuitively.

• Utilized SQL proficiently to extract, manipulate and query data for filtering, sorting and aggregating large and complex datasets.

• Worked with more advanced analysis in SQL using Views, joins, subqueries, stored procedures, CTEs, and Windows/Analytical functions such as ranking and partitioning.

• Participated in SQL query optimization initiative aimed at enhancing query performance, optimizing efficiency and reducing processing times.

• Developed and managed ETL processes using Talend to efficiently extract, transform, and load data from multiple sources into the Azure SQL data warehouse, ensuring accurate and timely data availability.

• Developed comprehensive data models to structure and organize the organization’s data, facilitating accurate reporting and forecasting.

• Collaborated with stakeholders across multiple departments, traveled quarterly to headquarters to gather new requirements, support go-live phases of dashboards, integrated reports, etc., and facilitate Power BI/Tableau adoption through training and SOP documentation. Work experience

Business Intelligence and Reporting Analyst, American Homes-Colorado Aug 2022 - Feb 2024 (1y 6m) REIT- Real estate investment trust

Property

SQL Python Tableau Power BI MySQL Confluence

• Developed new, while maintaining existing- interactive reports and dashboards using Tableau and Power BI.

Created with

• Utilized Tableau Desktop for comprehensive dashboarding and reporting, incorporating interactive filters, calculated fields, data blending, LOD, tooltips, and more. Leveraged SQL alongside Tableau to encode business logic.

• Built robust data visualization dashboards by analyzing complex datasets, utilizing Tableau, MS Excel

(charts, graphs, pivot tables, etc.), and SQL for larger datasets.

• Created customer reports and dashboards including but not limited to monthly and/or weekly CBRs, QBRs, Ad hoc and White glove report requests and SLA reporting for variously defined service levels of customer

• Led efforts in designing and generating billing reports for customer overage for 'Flex on demand’ service by analyzing data center's usage reports with the contracted values. Improved report quality by identifying data discrepancies and performing trend analysis to identify customers billing overages

• Built Tableau Dashboard that identified the areas where the tickets were taking the longest time to close across the datacenters in different geographies. This aging-ticket trend analysis enabled the organization to make a conscious decision in hiring resources with specialist skills to tackle these issues and bring down the ticket turnaround time significantly and thus helping in customer delight.

• Leveraged ServiceNow to extract meaningful data pertaining to SLA reporting and analysis. Furthermore, I handled adhoc tasks such as creating maintenance windows for planned outages, utilizing the impersonation feature to pull data from authenticated users, and assigning tickets to relevant teams. Additionally, I also worked on creating LiLo (Log in/out) reports. I have experience working with other platforms including Salesforce, where I map deliverables with defined SLA, OLA, and GMSA. I also utilize Viewpoint QuickBase for event outage root cause analysis, documentation, and have proficiency in tools like Zenoss, and EDW.

• Facilitated Root Cause Analysis (RCA) on incidents related to critical events/outages. Interacted effectively with teams from various disciplines to find the resolution of problems and communicating improvement recommendations to account executives, thereby ensuring streamlined service restoration.

• Established excellent working relationships with stakeholders and with internal resources while maintaining independence/objectivity to enable fluid communication of reporting and analysis requirements

• The Middle East, and Asia

• Managed large volumes of mobile traffic and messaging products. Generated leads and acquired potential

Lead Business Intelligence and Reporting Associate, SunGard Availability Services Sep 2015 - May 2019 (3y 8m) Datacenter provider

Enterprise

SQL Excel Salesforce Power BI MySQL JIRA Active Directory ServiceNow

• I was responsible for data collection, data cleaning, data processing, presentation and data visualization for analysis and reporting in support of ITSM's Continual Service Improvement goals based on metric-driven methodology to support business operations, recognize improvement opportunities, and accurately measure the influence of those improvement efforts Business Development Executive, Cellent Technologies Aug 2013 - Sep 2015 (2y 1m) Bulk SMS marketing, Mobile advertisement, transactional SMS Marketing

SQL Excel Salesforce Power BI Zoho

• Worked in the capacity of Business Development Executive and was responsible for generating business for Europe,

Created with

• Customers through cold calling, emailing, and market research. Maintained Forecast Funnel and sales pipeline for

• Effective tracking using Zoho CRM

• Built partnerships with aggregators and mobile carriers for better rates through bulk purchasing, thus upselling for

• Greater profit margins and providing attractive prices to our customers

• Led meetings with prospective customers, positioned Cellent and its offerings, followed up with

• Customers/leads, and nurtured relationships leading to closing deals

• Collaborated with multiple cross functional teams to assist in supporting and building the right solutions for our

• Customers, ensuring high retention rates and overall client satisfaction Education

R.K.D.F College Aug 2008 - Oct 2015 (7y 2m)

Bachelor's (B.D.S)

Snippets

Tableau Public Profile public.tableau.com

Please have a look at some of my Dashboarding work at Tableau Public https://public.tableau.com/app/profile/rubal.v/vizzes At work I'm best at...

I love to solve problems and take pride in my exceptional memory skills. I am trained dentist and have quite good knowledge of customer support, sales, healthcare and technology.

I'm making a career change because...

I want to work from Home, due to my current

preferences. I can dedicatedly work for 40 hours a week.

Languages

English, Hindi

More about me

Contact this candidate