Kumar Nagendra Email & Phone Number

• Discovered current state of business using human centered design, defined problem statements, translated functional requirements to technical requirements by creating user stories, wireframes, and workflows• Created reports and dashboards using Power BI Desktop and Report Server and maintained Power BI Dashboards on servers• Imported data to Power BI from multiple sources like SQL server, MySQL, Oracle, Excel, CSV, JSON, XML, Web URL, Azure SQL Database and Azure Analysis Services Database by using different storage modes in Power BI• Extracted and analyzed data using SSAS and Power query and Pivot tables in MS Excel, Power BI• Experienced and passionate developer implementing new emerging Microsoft-related technologies like PowerApps.• Configured schedule refresh and Incremental refresh to keep dashboards and reports up to-date with on premise data sources when published to the Power BI Service• Experience in working with Agile and Sprint methodologies.• Worked on building Office 365 solutions including Power Automate (Flow), Power Apps, CDS, Dynamics 365, SharePoint Online.

• Worked with Product Managers and Business Analysts to gather and understand business and data requirements• Worked directly with user groups to determine reporting needs and translating those needs into deliverables that best fit business needs.• Worked on Data preprocessing, Exploratory Data Analysis, Data Profiling, Data Migration and Data Integration on various subject areas• Performed Data preparation, Extract-Transform-Load(ETL) and Data Integration from multiple data sources in Alteryx• Proactively automated Microsoft Excel dashboard through integration of Python libraries – NumPy, Pandas, Matplotlib and Seaborn• Performed migrating and performance tuning SQL queries from HANA/HIVE to Snowflake and created views in Snowflake• Created visualization in Power BI by using Bar Charts, Column Charts, Tree Map, Line Charts, Area Charts. KPI, Key Influencers, Filled map, Cards, Matrix, Scatter Chart, Decomposition Tree etc.• Integrated custom visuals based on the business requirements in Power BI Desktop.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management

India

• Created user stories, functional design documents, technical design documents and wire frames• Created Star Schema and Snowflake Schemas in ER Studio• Configured Tabular models in Azure Analysis Services and Implemented Partitions on larger datasets• Extracted data from SQL server, Oracle, Flat files, and Excel using SSIS and cleansed the data• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc requests• Created a monthly data integrity dashboard using Power BI• Worked on Installation and Configuration of Power BI Desktop, Power BI Report Builder, Power BI Service, and on-premises gateway• Effectively handled relationship cardinality (one-one, one-many, many-one, many-many) in Power BI Data Modeling• Created reports by implementing slicers, cascading slicers, filters, hierarchies, and conditional formatting in Power BI

India

• Worked with Internal and External Stakeholders to understand reporting requirements• Assisted project managers to build project plan, estimation, and resource allocation• Created and maintained database schema, tables, views, stored procedures, and indexes for betterperformance using SQL Server.• Used multiple database systems such as SQL Server, MySQL, PostgreSQL, and Oracle to analyze and tie data together from multiple sources• Created, Configured, and tuned ETL workflows using SQL Server Integration Services (SSIS)• Performed Data preprocessing in SQL and Excel to handle missing values, null values, data spillage and normalization• Took ownership of daily data preprocessing and analysis using SQL and created reports on a weekly, monthly, and quarterly basis• Automated Microsoft Excel reports by writing VBA scripts• Used advanced Excel functions – Lookups, Pivot Tables, COUNTIF, SUMIF, IFERROR, Slicers, Conditional Formatting and Power Pivot in reports and dashboards• Created dashboards in Excel using bar graphs, pi-charts, slicers, and pivot tables