Rahul Chellani Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Client 1:E2E delivery of 15 talent acquisition dashboards in tableau resulting 60% reduction in manual reporting time, 30% reduction data processing time & 40% increase data driven decision making. Delivered R&D Data Warehouse for analytics & forecasting resulting 50% reduction in report development time.•Led team of 5 members for e2e project management - requirement gathering, defining scope/timelines of phases, created BRD•Identified KPIs, data sources & visualization… Show more Client 1:E2E delivery of 15 talent acquisition dashboards in tableau resulting 60% reduction in manual reporting time, 30% reduction data processing time & 40% increase data driven decision making. Delivered R&D Data Warehouse for analytics & forecasting resulting 50% reduction in report development time.•Led team of 5 members for e2e project management - requirement gathering, defining scope/timelines of phases, created BRD•Identified KPIs, data sources & visualization requirements. Collaborated with solution architect, database & UI teams, Tableau developers•Led sessions to understand data(availability, size, audit columns, load type, PII columns),Created data mapping, dataflow pipeline, automating complete process•Built interactive dashboards with important KPIs•Performed various testing(data validation, functionality, performance), created test scripts & benchmarks•Published dashboards to server and showed demo to internal stakeholders, clients•Used Jira to track tasks/progress with Agile methodology. Created epics, user stories with acceptance criteria & performed story point estimationClient 2: Delivered database with tax related data – clean, consistent, errors free resulting 50% reduction in data anomalies.Migrated 18 HR dashboards 910 metrics from MSTR to Power BI resulting 30% increase in operational efficiency.•Led team of 10 members - UI, DB, QA. Worked with legal & architects for blueprint of PII & technology to use•Performed feasibility % check, data gap analysis & documented KPI metrics details•Led requirement analysis, effort estimation, created project plan with milestones & timelines, Jira stories•Created confluence page & source to target mapping•Redesigned & developed new Power BI dashboards•Supported as SME to Power BI developers, UI team for visuals development•Worked with scrum master during sprints to do backlog grooming, capacity planning, prioritize/commit items, review status during stand-up, identify/remove blockers Show less

Pune, Maharashtra, India

• Extracted & connected to data source, cleaned & transformed data, loaded massive datasets using SQL, Power BI and data science techniques. Created custom SQLs, joins and relationships• Built hierarchies, DAX calculations (in Power BI), LOD calculations (in Tableau)• Created interactive reports using Power BI with different graphs, measures, filters, aggregations, DAX calculation• Created interactive dashboards using Tableau with important KPIs, graphs, calculated fields, different… Show more • Extracted & connected to data source, cleaned & transformed data, loaded massive datasets using SQL, Power BI and data science techniques. Created custom SQLs, joins and relationships• Built hierarchies, DAX calculations (in Power BI), LOD calculations (in Tableau)• Created interactive reports using Power BI with different graphs, measures, filters, aggregations, DAX calculation• Created interactive dashboards using Tableau with important KPIs, graphs, calculated fields, different filters, sets & parameters, groups, LOD calculations, aggregations, hierarchies• Published the reports & dashboards to the server, scheduled data refreshes & set row-level security as requiredTableau Projects: • COVID-19 Dashboard• Marketing Campaign Analytics Dashboard• Australia Retail Sector Forecasts Analysis Dashboard• Financial Performance Dashboard• Twitter Sentiment Analysis Dashboard• Healthcare Data Visualization• E-commerce Trends Analysis• Supply Chain Management Dashboard• Human Resource Analytics• Credit Card Fraud Detection Dashboard• Personal Vehicle Sales Performance Global Data Analysis Dashboard• UK Bank - Customer Segmentation Analysis DashboardPower BI Projects:• Sales Data Visualization & Predictive Sales Forecasting• Employee Performance Metrics & HR Analytics Dashboard• Website Traffic Analysis• Market Basket Analysis• Healthcare Claims Fraud Detection• Global Supply Chain Optimization• Portfolio Risk Management• Social Media Analytics Dashboard• Retail Data Analytics Dashboard• Customer Churn Analysis• Financial Data Analysis• Sports Analytics DashboardMachine Learning & Deep Learning Projects:• Directing customers to subscription through app behavior analysis • Amazon Alexa review ratings classifications • Predicting likelihood of e-signing a loan based on financial history. • Traffic sign image recognition using convolutional neural networks • Stock price prediction using recurrent neural networks• Conversational Chatbot Show less

Pune Area, India

Clients – EMEA Region Clients• Consulted clients and accounts managers to understand the requirements/expectations• Implemented end to end SAP BusinessObjects XI 3.1, Business Intelligence 4.0/4.1/4.2 on Win, Unix and Linux• Created multiple components, global scripts and parent child relationship in design studio with high complexity, attribute view, analytical view and Calculation view by using HANA Studio.• Developed crystal reports, web intelligence reports, lumira… Show more Clients – EMEA Region Clients• Consulted clients and accounts managers to understand the requirements/expectations• Implemented end to end SAP BusinessObjects XI 3.1, Business Intelligence 4.0/4.1/4.2 on Win, Unix and Linux• Created multiple components, global scripts and parent child relationship in design studio with high complexity, attribute view, analytical view and Calculation view by using HANA Studio.• Developed crystal reports, web intelligence reports, lumira discovery and designer reports/dashboards.• Used cascading filters, performance tuning, profiling for each loop, arrays and dynamic visibility.• Grant access to end users based on roles at semantic level. Scheduled & published reports using BI Launchpad.• Supported clients to configure HCM cloud-based SAP SuccessFactors. • Attended agile/scrum sprint ceremonies and actively communicated with Product Managers, remote teams regarding current and future development features.• Created official SAP documents used globally by their clients. Show less

Pune Area, India

• Responsible for maintenance and features upgrades of www.vertika.tv website and marketing campaigns.• Did requirement analysis by interviewing client via phone, email or personally and designed solutions for them.• Coordinated with designers and back-end team members on the project. • Implemented the required changes per client requirements, supported QA and production support team. • In daily status call, share update to client and demonstrate the updated features at regular… Show more • Responsible for maintenance and features upgrades of www.vertika.tv website and marketing campaigns.• Did requirement analysis by interviewing client via phone, email or personally and designed solutions for them.• Coordinated with designers and back-end team members on the project. • Implemented the required changes per client requirements, supported QA and production support team. • In daily status call, share update to client and demonstrate the updated features at regular interval.• Fixed the defects reported by client and internal QA team. Show less

Pune Area, India

• Projects: CreativeCredit.in, EraHealthCares.com, ZionEducation.com, JyotiRestaurant.com• Developed websites and marketing campaigns for several local businesses.• Did requirement analysis interviewing clients and designed solutions for them.• Created new websites or redesigned current once to improve user experience, features and performance• Designed logos, website artifacts and printable brochures.• Did extensive SEO work for clients to improve their rank in search… Show more • Projects: CreativeCredit.in, EraHealthCares.com, ZionEducation.com, JyotiRestaurant.com• Developed websites and marketing campaigns for several local businesses.• Did requirement analysis interviewing clients and designed solutions for them.• Created new websites or redesigned current once to improve user experience, features and performance• Designed logos, website artifacts and printable brochures.• Did extensive SEO work for clients to improve their rank in search engines. Show less

Post Graduation Diploma In Big Data Analytics, Big Data Analytics

Bachelor Of Computer Science, Computer Science