Praveen N Email & Phone Number

United States

Collaborated with Subject Matter Experts and Product Owners to outline data requirements and source-to-target mapping crucial for advancing analytics initiatives within the Manufacturing and Supply Chain (M&SC), facilitating seamless interactions between applications, databases, and platforms.Established a Data Warehouse and integrated data from disparate systems (Salesforce and SAP), coordinating with various teams to consolidate databases into a unified Universe.Enhanced Power BI reports' interactivity by incorporating storytelling elements like bookmarks, selection panes, and drill-through filters, and developed custom visualizations using the R-Programming Language.Implemented machine learning with Python to translate text from multiple languages into English for analytical purposes, utilizing Power BI to construct analytical dashboards for rapid data insights.Managed Power BI Service workspaces, scheduled data refreshes, and supervised apps and workbooks maintenance, leveraging DAX functions to formulate measures and calculated fields for logical data visualization.

Miami, Florida, United States

Collaborated closely with business partners and analysts to gather requirements and translate them into system work.Defined and created various standard IT project deliverables across all project lifecycle phases, while collaborating with team members at different levels.Utilized Agile and Scrum methodologies to elaborate and record requirements using EPICS and User Stories, ensuring clarity for the development team.Created backlog items in Azure, prioritized them in each sprint, and converted product vision into user stories, aligning them with corporate strategy.Developed reports and dashboards using Tableau Desktop and published them using Tableau Server, including advanced chart types and visualizations.Created dynamic reports in Tableau Desktop using filters and published various interactive data visualizations, dashboards, reports, and workbooks.Developed Power BI reports using Power BI Desktop and published them onto Power BI services, creating models for Marketing Analysis and Financial Reporting.Designed and developed stored procedures, queries, and views as necessary, extensively using joins and sub-queries for complex queries involving multiple databases.Created SSIS packages for uploading files and databases into the SQL Server data warehouse, optimizing ETL/ELT data transformations.Scheduled and monitored ETL jobs in SSIS, resolving issues associated with ETL Data Warehouse Failure.Interacted extensively with ETL and Report developers, quality assurance engineers, and project teams regarding scheduling, requirements, design, implementation, testing, and support.Created Change requests in Service Now for Production ETL and Tableau Report Deployments, and managed MDR Data extracts to Salesforce.Pulled data from JDEdwards into the Data Warehouse and provided it to the field operation team for monthly break-even analysis.Managed analytical data for the Production Environment.

Raleigh, North Carolina, United States

Collaborated with Business Units to define business strategy and establish a centralized reporting capability for analytical and ad-hoc reporting, ensuring accurate information availability to decision-makers.Transitioned from high-level concepts to a detailed understanding of business problems, component design, and implementation, conceptualizing and articulating business and technical solutions clearly and concisely.Acquired data from multiple sources for Tableau data visualizations, creating user-friendly and dynamic dashboards with various elements such as KPIs, Heat Maps, Scatterplots, Bar Charts, Slicers, Drill down, and Drill up.Published, scheduled, and refreshed reports to Tableau Server 2019.x and later versions, while also developing and supporting reporting solutions, dashboards, and scorecards using Microsoft BI technologies like SQL, Power BI, and Excel (Power Pivot).Ingested data from corporate sources and performed necessary transformations in Power BI query editor, designing models with Power BI Desktop, and publishing them on Power BI Services for availability to the Data Analytics Team.Utilized Power BI Desktop to develop diverse visualizations like Stacked Bar and Column Charts, Table, Matrix, Pie, and Donut Charts, alongside developing accurate and performant calculations in DAX for large datasets.Leveraged Power BI services to share reports with business users, deploying models and reports from Development to Production, and administering users/groups/roles.Developed T-SQL stored procedures, triggers, and views, and made modifications to tables for data extraction, loading, and transformations, including the creation of complex T-SQL Queries, Stored Procedures, Indexes, Functions, and Views for efficient data storage and manipulation.Environment: Power BI Desktop and Power BI Services, Tableau Desktop, LDAP, Oracle 11g, Toad for Data Analysis, Informatica, JavaScript, Microsoft Office 365

Hyderabad, Telangana, India

Attended daily scrum meetings with the team to address project challenges and progress.Extracted data for reporting from various sources including SQL Server, SQL Server Analysis Services, Azure SQL Database, Azure SQL Data Warehouse, and Salesforce.Developed complex SQL statements, including stored procedures and common table expressions (CTEs), to extract data from the data warehouse server for report generation.Generated complex reports in Tableau employing functionalities like context filters, hierarchies, parameters, LOD Expressions, and time intelligence.Built interactive and storytelling dashboards within Tableau workbooks using dashboard actions and published them on the Tableau Server, setting up report refresh schedules.Employed Data Analysis Expressions (DAX) to create measures and calculated fields for data analysis in both Tableau and Power BI.Developed Power BI reports with various visualizations like line charts, doughnut charts, tables, matrices, KPIs, scatter plots, and box plots.Enhanced interactivity of Power BI reports using storytelling features such as bookmarks, selection panes, and drill-through filters.Designed and implemented SSIS packages for ETL processes, maintaining and optimizing performance for slowly running packages.Responsible for accurately reporting on the financial aspects of the company's operations on a daily/weekly/monthly basis.Evaluated returns and risks for various types of investments, assessing risk tolerance for customers.Created ad-hoc reports including YTD, YOY, MTD, and MOM analysis for income statements and cash flow based on business unit requests.Implemented reports among Power BI, Tableau, SSRS, and Python reports.Environment: Power BI Desktop, Power BI Service, Project Online, SQL Server 2016/2017, SSRS, SSIS, DAX, Tableau, Microsoft Azure, Python, SharePoint, Visual Studio, Scrum/Agile, BI Development Studio (BIDS), MDX, XML, SQL Profiler, TFS, MS Office, Windows 10/7, Data Analyzer