Power Bi Sql Server
Resume:
CHAKRADHAR KOTTE
E-Mail: ***************@*****.*** Mobile: +1-945-***-**** Location: Texas, US
LinkedIn: https://www.linkedin.com/in/chakradhar-k-875b81271
Tableau Developer
Power BI & Tableau Development
Data Integration & ETL Processes
Enterprise Data Management
Power BI Reports & Dashboards
Performance Optimization
Data Warehousing
SDLC
SQL Server Development
Database Development
Continuous Improvement
DAX Calculations
Stakeholder Collaboration
Analytical & Problem-Solving
Interpersonal Skills
Team Leadership
Diligent IT professional expertise in transforming complex datasets into clear, interactive reports and dashboards that drive strategic business actions.
Excellent team player with an analytical bent of mind and passionate about unlocking actionable insights from data, helping businesses enhance their decision-making processes through powerful, custom-built Microsoft Power BI solutions.
PROFILE SYNOPSIS
Rich experience in Business Intelligence & Tableau Development, SQL development, data integration techniques using SSIS and Azure Data Factory, and full System Development Life Cycle (SDLC).
Expertise in handling healthcare data, finance, supply chain management, sales and marketing, and customer complaint management domains, with deep knowledge of the Facets data model and ETL processes.
Proven ability to develop complex SSAS cubes, design and deploy ETL processes, generate dynamic Power BI reports with drill-through/drill-down capabilities, develop dashboards, and ensure data refresh schedules for timely updates.
Leveraging skills in ServiceNow for ticket management, change request handling, and service request tasks, ensuring efficient incident resolution and process management.
Advanced understanding of agile methodologies such as CI/CD, Application Resiliency, and Security.
Strong communication, interpersonal, presentation, coordination, people management, and leadership skills while working with people at all levels.
TECHNICAL SKILLS
Operating Systems: Windows 7/8.1/10/19 RDBMS: SQL server 2012, 2014, 2016,2017,2019
Languages T-SQL, C# Microsoft BI Tools: SSIS, SSAS, SSRS, Power BI Cloud: Azure, Snowflake
SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence, Development Studio, SSDT, Oracle 12c.
Reporting Tools: SSRS, Power BI, MS Excel Tableau desktop,Tableau Server Tools: TFS, GIT, ServiceNow
Configuration Tools: Team foundation server, GitHub, GitLab
ACCOMPLISHMENTS
Awarded Top Performer of the Year for optimizing SIAM reporting and improving Gmail & Google Drive file sync processes.
Received "Pat on the Back" award for successfully implementing the CIO dashboard in 2020.
Recognized as Best Programmer in 2022 for automating data load from data warehouse to analytics database.
CAREER SNAPSHOT
WORK EXPERIENCE
Senior BI Developer Cisco Systems, Texas Apr 2023-Apr 2024
Business Collaboration: Partnered with business teams to deeply understand their analytical and reporting needs, identifying critical metrics.
Data Marts: Worked with data architects and analysts to design data marts tailored for reporting purposes.
Dashboard Development:
oDeveloped and published dashboards from scratch on Tableau Server, enabling the business reporting team to effectively showcase quarterly and quarter-over-quarter results.
oCreate and maintain Tableau dashboards that transform complex data into clear, actionable insights.
oUtilized Tableau's robust visualization capabilities to present data in a meaningful and comprehensible manner. Implement best practices for data visualization to enhance user understanding.
Data Integration: Integrate data from various sources (e.g., SQL databases, cloud data warehouses) into Tableau, ensuring data accuracy and consistency.
Cross-functional collaboration: Collaborated with cross-functional teams to gather, analyze, and document business requirements and translate them into technical specifications. Performed data cleansing, manipulation, and modelling to ensure data accuracy and integrity. Conducted data validation and testing to identify and resolve any issues or errors.
Design comprehensive Tableau dashboards to visualize complex data sets, ensuring clarity and actionable insights.
Stakeholder Collaboration: Collaborate with stakeholders to gather requirements and translate business needs into effective data visualizations.
Performance Optimization: Optimize Tableau dashboards for performance, including efficient data extraction and query execution, to ensure minimal load times and a smooth user experience.
Advanced Analytics: Utilize Tableau's advanced analytics features, such as calculated fields, parameters, and table calculations, to provide deeper insights and drive data-driven decision-making.
User Training and Support: Conduct training sessions for end-users and stakeholders, empowering them to leverage Tableau for their analytical needs. Provide ongoing support and troubleshooting.
Data Prototyping: Developed data analysis prototypes using Power Pivot and visualized reports with Power View & Power Map.
Project Management: Lead & manage Tableau development projects, ensuring timely delivery, within scope, and on budget.
Dashboard Creation: Built comprehensive Tableau dashboards showcasing KPIs and advanced analytics, including calculations, parameters, maps, and scatter plots.
Complex Custom Calculations: Created various Business Intelligence dashboards with global filters, calculated columns, and measures, employing complex DAX calculations and Query Editor Transformations.
Snowflake Integration: Designed and developed Tableau reports and dashboards utilizing Snowflake data sources.
Stakeholder Collaboration: Worked closely with business stakeholders to understand their reporting needs and deliver insights through impactful Tableau visualizations.
Senior BI Developer Roche Diabetes Care, Barcelona Aug 2020-Mar 2023
Designed and developed SSIS packages to extract, transform, and load data into SQL Server databases, ensuring data integrity for SSAS cubes. Stayed current with Tableau best practices and emerging features to enhance dashboard capabilities.
Led the strategy for Enterprise Data Management, supporting robust data governance programs and collaborating with data architects to design efficient data marts.
Rendered technical leadership & mentorship to junior team members, fostering a culture of continuous learning & innovation.
Conducted performance tuning and troubleshooting of PowerBI solutions, identifying and resolving technical issues to ensure optimal performance and user experience.
Developed SSIS packages to import data from SAP systems and to load incrementally into Fact and Dimension sql tables.
Prepared and maintained Snowflake tables, views, and stored procedures, optimizing SQL queries for enhanced performance.
Crafted dynamic Tableau dashboards using various visualizations, leveraging Power Query for data cleansing and transformation. Provided insights about improving or automating processes and adding value to the team.
Integrated Tableau reports into .NET web applications with web services, applying row-level security & managing user roles.
Built and executed test cases, performed unit and regression testing using HP ALM tools and utilized Team Foundation Server for version control. Determined the best implementation strategy to satisfy the architect's design requirements.
Collaborated with business teams to gather requirements, define business metrics, and deliver customized Tableau solutions, continuously improving data solutions and reporting capabilities.
BI Developer Blue Cross Blue Shield of Louisiana, Hyderabad Nov 2017-Jul 2020
Developed and optimized Stored Procedures, Packages, and Views for efficient data retrieval and manipulation based on specific business requirements.
Utilized dynamic SQL queries to enhance query flexibility and adaptability.
Implemented complex ETL processes with SQL Server Integration Services (SSIS) for data extraction, transformation, and loading into the Data Warehouse.
Formulated and maintained SSRS reports for accurate and timely term letters for providers.
Provided support and maintenance for Tableau reports and dashboards, including upgrades, enhancements, and performance tuning for executive needs.
Associate Developer Coveo Info Solutions, Hyderabad May 2014-Oct 2017
Created SQL queries, stored procedures, views, indexes, and functions for efficient data handling.
Developed SSIS packages to centralize and cleanse data from various sources.
Designed and modified SSAS cubes and measures using MDX for historical data extraction.
Supported Tableau reports, ensuring data accuracy and resolving issues.
Automated processes and optimized SQL Server configurations, security, and backups for enhanced performance.
ACADEMIC DETAILS
Bachelor of Technology (Electronic and communications), Jawaharlal Nehru Technological University Hyderabad, 2014
Contact this candidate