Kalyan Chakravathi Email & Phone Number

Lewisville, Texas, United States

● Designing and implementing Power BI dashboards and reports for business stakeholders.● Collaborating with data engineers to integrate and transform data from various sources for use in Power BI.● Creating and maintaining data models and visualizations in Power BI, ensuring accuracy and consistency across all reports.● Created SSIS packages to perform filtering operations and to import the data on a daily basis from the legacy data sources to SQL Server 2016.● Creating complex SQL scripts to transform legacy data in staging areas using SSIS packages.● Configuring SSIS packages for run time parameters and config files.● Used SSIS for Extracting and Merging data from different sources to single source.● Scheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day data.● Scripting using SSIS packages for data cleansing, encrypting and decrypting sensitive information.● Created SSIS packages to automate different FTP’s files and emailing to different clients.● Created SSIS packages using various Transformation to generate underlying data for the report and to export the cleaned data from Excel, CSV, Flat file and MS Access to data warehouse.● Generated reports from SQL Server Database and OLAP data warehousing.● Deployed Reports to Report Manager and Troubleshooting for any errors during execution.● Scheduled the Reports to run on the daily and weekly basis in the Report Manager and email them to the directors and analysts to review in Excel sheet.● Creating and maintaining Tableau dashboards, reports, and data visualizations for business stakeholders.● Collaborating with data architects and engineers to optimize data architecture and ensure data quality and accuracy in Tableau.● Developing and maintaining Tableau Server, ensuring scalability, reliability, and security of Tableau environments.● Developing and implementing Python-based solutions for data manipulation, analysis, and visualization.

India

● Designed ETL Packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of SSIS transformation.● Modified the existing SSIS packages to improve the performance of data loading.● Used various SSIS tasks such as Conditional split, Derived column, data validation checks etc. during staging, before loading the data into various sources.● Successfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizard.● Creating and maintaining SAS programs for data analysis, modeling, and reporting.● Collaborating with data scientists and business stakeholders to translate business requirements into SAS-based solutions.● Building and maintaining SAS ETL processes to ensure accurate and timely data processing and integration.● Configured and Maintained Report Manager and Report Server for SSRS.● Created Drill Down Report, Summary Report, Sub Report and Parameterized Reports in SSRS.● Generated ad-hoc reports using MS SQL Server Reporting Services.● Experience working with Multi-Dimensional Expression (MDX), functions and statements to create complex calculations.● Created user defined hierarchy in dimensions.● Developing and maintaining QlikView dashboards, reports, and visualizations for business stakeholders.● Collaborating with data architects and engineers to optimize data architecture and ensure data quality and accuracy in QlikView.● Creating and maintaining QlikView Server, ensuring scalability, reliability, and security of QlikView environments.● Moved data from old legacy systems to new sources based on the given requirement.● Design and Implemented database application using MS SQL Server 2012 and Business Intelligence (BI) tools to support transaction and business decision making.● Evaluated database performance and performed maintenance duties such as tuning, backup and restoration.