Sai Charan kuchi EmailID:ad33xr@r.postjobfree.com Phone no: 512-***-****

SUMMARY:

Data Analyst and Power BI Developer with 6+ years of Industrial working experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure Power BI for building, deploying, and managing applications.

Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Power BI, Azure Databricks, Azure Analysis Services, SQL server Integration Services, SQL Server Reporting Services Reporting Services and Tableau.

Proficient in Tableau Desktop for creating interactive and visually appealing data visualizations, dashboards, and reports.

Experience in connecting Tableau to various data sources including Oracle Database, Excel, SQL Server, and cloud-based platforms.

Strong knowledge in Power BI using SQL Server 2012/2014/2016/2018.

Strong experience in Synthesizing the Business Requirements, Data Models and determining Key performance indicators to evaluate key factors crucial to the success of Organization.

Experience in data modeling, analytics, and visualization with a deep focus on the Looker platform.

Experience in data profiling, cleansing, and validation to ensure data quality and consistency throughout the ETL pipeline

Proficient in designing and implementing ETL processes to extract data from various sources, transform it according to business rules, and load it into target databases.

Implement ETL process in Alteryx to extract data from multiple sources and schedule workflows.

Proficient in Oracle Database management, including installation, configuration, and administration.

Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL SSRS, Tableau and Power BI.

Expert in maintaining and managing Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for executive level Business Decision.

Responsible for designing, building, and testing workflows in Alteryx.

Created hierarchies in Tableau reports using visualizations like Bar Chart, Line Chart, etc.,

Worked with both live and import data into Power BI for creating reports and managed relationship between tables in Power BI using star schema.

Familiarity with Oracle PL/SQL for developing complex business logic and data processing workflows.

Performed transformations like Pivoting, Unpivoting, and Splitting of the columns using Power Query.

Strong understanding of data integration patterns and best practices for designing scalable and maintainable ETL solutions.

Experience in developing and maintaining SSIS packages to integrate with different resources like MySQL, Oracle, SQL Server.

Proficient in configuring and managing Data Gateways for seamless and secure data transfer between on-premises and cloud environments.

Hands on experience using the version controls like GIT.

Worked on configuring various data adapters for MySQL, Oracle, SQL Server, Teradata, Flat, Delimited Files, JSON.

EDUCATION:

Bachelor’s degree from CMR Engineering College, May 2018.

Master’s degree in computer science from Southern Arkansas University, July 2023.

PROFESSIONAL EXPERIENCE:

Client: Traveler’s (IDetaSystems) JAN 2023 – Present

Role: Data Analyst/ Power BI Developer

Project: As a Data Analyst, I crafted and deployed reports aimed at delivering actionable insights to enhance customer decision-making processes. Proficient in business intelligence methodologies, I specialized in data integration, warehousing, modeling, and database management. My expertise extends to leveraging the capabilities of Tableau and other BI tools to empower organizations with data-driven solutions.

Responsibilities:

Created analytical reports and provided valuable and relevant business insights for internal and external clients.

Created action filters, sets, parameters, and calculated sets for preparing worksheets and dashboards in Tableau.

Adheres to strict security protocols and procedures in handling sensitive data.

Experience with Tableau for Data Acquisition and data visualizations.

Cleaned and transformed data using Power BI’s Query Editor to prepare ETL processes to optimize reporting datasets.

Knowledge of scheduling and monitoring ETL jobs, error handling, and logging mechanisms for troubleshooting and auditing purposes.

Created data models and tables within Power BI to support efficient, optimized data warehousing and reporting workflows.

Ability to create calculated fields, parameters, and sets in Tableau for dynamic and customized visualizations.

Experienced in using scheduling tools and platforms such as Microsoft Power BI, Tableau, or other relevant tools to orchestrate data refreshes.

Created, optimized, and maintained Looker dashboards to provide actionable insights, improving decision-making processes across multiple departments.

Led the development and implementation of comprehensive checklists and procedural documents for support activities in Power BI.

Experienced in tuning of long-running SQL queries using SQL server built-in tools like SQL Server profiler, Execution plan and creating indexes.

Experience in publishing and sharing Tableau workbooks and dashboards on Tableau Server or Tableau Online for collaborative analysis.

Environment: Oracle Database Server, Looker, Tableau 2020.3.1, Tableau Server, Pyspark, Python, Azure SQL Database, Power BI, Power BI Gateway, Power Query, MS SQL Server 2016/2014/2012/2008, MS Excel, Windows 10/11.

Client : Southern Arkansas University Dec 2021 – May 2022

IT Support Specialist (Part time)

Responsibilities:

Utilized the Power BI platform to transform the data and produce reports.

Performed data model design and implementation.

Integrated different data sources and created data sets within Power BI.

Understood the ETL involved in creating data sets for reports.

Reported components from multiple data sources.

Created technical documentation related to reports and software, including technical designs, functional designs, use cases, and test case documentation.

Documented DAX code and approach to the management of Power Bi Books.

Utilized, and optimized the use of, multiple large data sets.

Facilitated conversations to translate business requirements into the technical data requirements needed to develop solutions.

Client: Think & Learn Pvt Ltd (BYJU’S) DEC 2020 – JUL 2021 Role: Data Analyst/ Power BI Developer

Project: Byju's is an Indian multinational educational technology company. "As a Data Analyst, I conducted data analysis on user engagement, course performance, and customer behavior. I also tracked the effectiveness of marketing campaigns and sales efforts, contributing to content delivery improvements and informed marketing strategy decisions by developing reports and dashboards.”

Responsibilities:

Design, configure, and document Tableau Data Source and Extract.

Loaded datasets from multiple sources (Excel, Power BI Datasets, SQL Server Databases, Analysis services, Files, Stored Procedures, Views) into Power BI datasets.

Design, configure, and document Tableau Data Source and Extract.

Developed custom visualizations in Looker to cater to niche business requirements, leading to more informed and nuanced business decisions.

Experience in integrating Oracle Database with other enterprise systems and applications through APIs, web services, or middleware platforms.

Involved in Configuring and Upgrading the on-Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.

Utilized advanced Power Query techniques to optimize data cleansing and transformation processes, enhancing the accuracy of support reports.

Ability to optimize ETL workflows for parallel processing, partitioning, and distributed computing to improve performance and scalability.

Knowledge of data governance frameworks and data stewardship processes for ensuring data quality and integrity throughout the ETL pipeline.

Spearheaded Looker training sessions for new team members and non-technical stakeholders, enhancing company-wide data literacy and empowerment.

Created reports in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, etc.,) developed and dashboards.

Defined, and planned outcomes and partnered with Data-warehouse developers to build appropriate data models.

Worked on data analytics using SSAS Tabular Model and Excel.

Environment: Power BI, Power BI Gateway, Tableau Prep, Power Query, Alteryx, Pyspark, Python, Visual Studio, Tableau 2019.3, Azure SQL Database, Oracle Database, Tableau Server, Excel, MS SQL Server, SSAS, DAX Studio, MS Project.

Client: VSigma IT Labs Pvt Ltd JAN 2020 –NOV 2020 Role: Data Analyst/ Power BI Developer

Project: “Operational research Project in Telecom” The primary objective of this operational research project is to efficiently assign telecom users to specific plans in a way that minimizes costs while ensuring that certain business conditions or constraints are met. The project aims to optimize the allocation of users to plans, considering various factors and requirements.

Responsibilities:

Interpreted data, analyzed results using statistical techniques, and provided ongoing reports Design and create data reports and reporting tools to help business executives in their decision-making, Perform statistical analysis of business data.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements and helped.

Analyzed and mined business data to identify patterns and correlations among the various data points, Manipulating, cleansing & processing data using Excel, Access, and SQL.

Analyzed raw data, drawing conclusions & developing recommendations Writing SQL scripts to manipulate data for data loads and extracts.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.

Created calculated fields, bins, sets, parameters, and hierarchies using Tableau Desktop.

Data audited, created data reports & monitored all data for accuracy.

Responsible for loading, extracting, and validating client data.

Used Optimization algorithms like “Differential Evolution”, “Dual Annealing”, “Brute” which will give multiple combinations with all the conditions satisfied for the client to choose the desired one.

Worked on data shaping, transformation, and modeling in Power BI using Power Query and DAX.

Created reports and dashboards in Power BI using Power Query, DAX Functions, visuals (charts, Graphs, etc.,).

Environment: Power BI, Tableau 9.1, Alteryx, Tableau Desktop, Tableau Prep, SQL Server 2012/2016, Azure, Excel, Python, Pyspark, Server Integration services (SSIS), Jupyter.

Client: Cognizant JAN 2017 – DEC 2019

Role: Data Analyst

Project: As a Data Analyst I used to analyze data related to Facebook Marketplace. This can include tracking user activity, monitoring transaction trends, generating reports on marketplace performance, and creating Dashboards for business insights.

Responsibilities:

Understood business requirements in the BI context and designed data models to transform raw data into meaningful insights.

Experience in documenting ETL processes, data mappings, and transformation rules for knowledge sharing and compliance purposes.

Developed workbooks and dashboards using Tableau 8.3 visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographical maps, using local and global filters.

Define best practices for Tableau report development.

Utilized Power BI to build interactive and visually appealing dashboards and reports.

Developed visual reports, key performance indicators (KPI) scorecards, and dashboards using Power BI desktop.

Analyzed data and presented data through reports that aid in decision-making.

Proficiency in Oracle Database upgrade procedures, including compatibility analysis, testing, and post-upgrade validations.

Created relationships between data and developed tabular and other multidimensional data models.

Charted creation and data documentation explaining algorithms, parameters, models, and relations.

Environment: Visual Studio, Power BI, Tableau Desktop, Alteryx, Tableau Server 8.1/8.2, Excel, MS SQL Server, Azure, Excel, Python, Pyspark.

Contact this candidate