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

• 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

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

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