Rahul Dubey

• Design, developed and implemented Power BI dashboard, scorecards and KPI reports. Written effective DAX formulas and created effective visualization for executive management reporting.
• Assist end users with problem installing the Power BI desktop, installing, and configuring the personal and on-premises gateway, connecting to data sources, adding multiple users.
• Assisted users in configuring and troubleshooting Row-level security as per organization policy.
• Developed the report with the use of Power Pivot and Power Query.
• Hands on experience with Azure data lake analytics. Strong development skills on Azure: Data Factory and Warehouse, Blob and Storage Explorer.Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Data ingestion to one or more Azure services and processing the data in Azure Databricks.
• Expertise in SQL server development, AZURE, Power BI for building, deploying, managing applications and services through managed data centers.
• Excellence knowledge of JIRA & Confluence involving creation and management of custom, complex projects, workflows, JQL queries, custom fields, Rich filters, Plans, Structures, dashboards and reports.
• Expert in creating OLAP cubes, dimensions, business critical KPIs and MDX queries using Analysis Services.
• Experience in writing TSQL (DDL, DML, TCL and DCL), developing and creating objects, indexes, complex stored procedure, tasks, triggers and CTE.
• Developing and supporting applications based on Microsoft SQL Server 2014, Oracle 10g/11g (SQL, PL/SQL), Toad, SQL Developer and VBA Macros.
• Proven qualification in data modeling, analyzing requirement, planning, designing and implementing innovative database solution that meet or exceed challenging business needs.
• Good analytical and quantitative skills, with the ability to work with large data while maintaining a high attention to detail.

• End-to-End management of Analytics/BI projects, including Project planning, Tracking, Reporting, Governance, Stakeholders management and Budget management.
• Excellent knowledge of all the phases (Planning, Defining, Designing, Building, Testing, Deployment,) of software development life cycle (SDLC).
• Worked on projects using Agile methodologies and Waterfall model with CMMI level 3 documentation.
• Excellent written and verbal communication skills, ability to translate technical concepts into business language and business language into technical requirements.
• Enable leadership with required analytics and actionable insights such as budgeting and forecasting for Sales, Revenue, and Headcount planning in close collaboration with Finance and HR teams, identify and investigate deviations and help develop remediation actions.
• Lead project scoping activities, development of SOWs and ensure project costing is within defined norms.
• Lead steering committee and monthly status meetings with key stakeholders across geographies to ensure constant revenue stream and revenue growth, manage client escalations and address urgent project concerns.
• Proactively identify and mitigate project risks in collaboration with clients and cross functional teams to ensure alignment of project delivery with defined timelines, cost estimates and client expectations.
• Proactively identify delivery and support impediments, blockers and problems and take ownership their resolution removal.

To track and manage the releases and provide accurate picture to stakeholders.

• Guide team members on DAX functions for various fact calculations and efficient data visualization in Power BI.
• Ownership of delivery forecasting, variance analysis. Worked closely with Stakeholders and Functional leaders to create Ready to Integration and Ready for Deployment dates.

Project: Get data from multiple ticketing tools like Unites, JIRA, DEV ops, SFTP server, create KPI’s for about 80+ service areas, and create visuals, charts and graphs in Power BI.

• Lead the team and worked along to achieve all user stories defined in sprint plan.
• Regular client meeting for detail understanding and implementation of project requirements

Project: Track sales performance in real-time, identify trends, and make data-driven decisions to improve sales.

• Develop timely, accurate and insightful reports. Analysis field sales and sales management criteria related to sales performance.
• Create and execute weekly reports for field sales detailing about products, accounts, orders and shipping. Develop and track allocations of all new product launches, and identify risk/opportunity at macro level.

Project: Analytically and periodically, measure our delivery team performance against a best-in-class metric/target. Controlling/managing delivery teams expected performance level through this metric allows us to measure the pace at which teams need to improve to remain competitive.

• Design Power BI report to provide differences between actual and budgeted expenses/income.

Project: Track the performance and utilization of the employees.

• Design and develop time tracking utilization report with effective performance management program to track the employee productivity, billability and utilization.

Project: Normalizing and modeling datasets to build aggregates, which enables BUs to take better business decisions.

• Design metric and visualized report to identify cost center wise forecast and actual travel cost.
• Support L4/L5 level leadership in center performance review, automation of KPI Reports.

Project: Worked on developing DataMart for Tesco Retail Website using Data Warehousing/Data Mining.

• Created Data warehouse, data marts, stored procedures, triggers for setting up a reporting database.
• Automated end user reports using VBA and VB Script.
• Fine tuning database and server settings.

Project: Creation of simple and complex queries for data extraction for ad-hoc requests as well as daily reporting for senior management. Preparing dashboard for daily, weekly and monthly performance basis as per Business requirement.

• Corporate and strategic planning and forecasting model roll rate model.
• Dashboard Design as per timelines and goals of operations team.
• Process documentation and report automation.

Project: Basel II was ensuring that credit risk, operational risk and market risk are quantified based on data and formal techniques. Measured productivity for various teams which helps in deciding employee’s incentives.

• Improving current process in an efficient and proactive manner.
• Requirement gathering from stake holder.
• Optimized queries with common table expressions to simplify complex queries involving multiple tables