Nikhitha Chaluvadi Email & Phone Number

United States

-Modified the existing packages by making changes in the stored procedures according to the requirement.-Designed and documented the entire Architecture of Power BI. -Involved creating effective reports, dashboards, and publishing into Power BI service -Creating the roles for the dashboards, sharing the developed dashboards to the client in Power BI. -Successfully integrated custom visuals based on business requirements in Power BI desktop. -Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards. -Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.-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. -Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).-Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory. -Used various data flow transformations like conditional split, look up, derived column etc. -Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic. -Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL. -Worked with SSIS tool suite like Conditional Split, Lookup, Multicast and Derived Column. -Used script task in SSIS to design complex SSIS packages using Python.-Involved in performance tuning for new databases and existing databases by using SQL profiler.

United States

-Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping and worked with various data transformations like Merge, Sort, Conditional Split and Multicast.-Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations. -Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. -Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.-Generated custom and parameterized reports using SSRS. Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI. Knowledge of publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborates using workspaces, apps, and to get quick insights about datasets. Experience in publishing Power BIDesktop reports created in Report view to the Power BI service.-Created basic reports using confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

-Worked with Pharma Client in migrating their reports from MicroStrategy to Microsoft Power BI. -Worked extensively in developing end-to-end solutions for data visualization to the client. -Involved in Testing Rigorously, develop intuitive reports connecting to different data sources and in sprint plans, retrospective meetings and UAT meetings. -Developed confidential proprietary analytical tools and reports with Microsoft Excel, Power Pivot, and PowerPoint. -Created SSIS package to pull all events and programs data from the database server and SharePoint lists. -Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS. -Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

-Created and built the reports for a US-based Insurance Company in Power BI and got their customer data and Count from the SQL database as per the Dynamic parameter keys. -Designed, developed, and tested various Power BI and Tableau visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases. -Used and created various visualizations in reports like scatter plots, box plots, Sankey charts, bar graphs, Gantt charts, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end-users to utilize the full functionality of the dashboard. -Integrated Power Apps with Power BI to optimize data workflows, allowing users to seamlessly transition between data analysis and data entry tasks within a single platform. -Developed more than 6 Microsoft Power Apps in which canvas apps like Attendance, Incentives, Associate Insights, E-Prescriptions, and some Model-driven apps namely Rapid Assist, QR Scanner, Mileage Tracker.

-Created highly responsive web applications that enhanced user engagement and satisfaction. Leveraging a skill set encompassing HTML, CSS, JavaScript, and React JS. -Performed data cleaning depending on the requirement using SQL to ensure data quality and completeness to ensure proper accuracy of data.-Implemented basic canvas applications using Microsoft PowerApps.

Master Of Engineering - Meng, Computer Science

Bachelor'S Degree