Sai Kumar
*******@*****.***
Tableau/BI/SQL Developer
Professional Summary:
Accomplished BI/SQL/ETL Developer and Tableau Consultant with around 6 years of experience delivering enterprise-grade data solutions.
Strong expertise across the full SDLC—from requirements and design through development, deployment, and production support.
Demonstrated excellence in data visualization and reporting using Tableau, Power BI, SSRS, and OBIEE, delivering executive dashboards, KPI frameworks, and self-service BI solutions that enable strategic and operational decision-making.
Proficient in LOD expressions, DAX, advanced calculations, and predictive analytics to build dynamic, high-impact dashboards.
Deep SQL Server (2014/2012/2008) expertise with advanced proficiency in T-SQL, stored procedures, functions, triggers, performance tuning, indexing strategies, and schema design for both OLTP and OLAP environments.
Strong ETL development experience using SSIS, Informatica, Azure Data Factory, and Stitch ETL to integrate data from SQL Server, Oracle, XML, Salesforce CRM, Snowflake, Flat Files, AWS, and Azure Data Lake into enterprise data warehouses.
Skilled in workflow design, debugging, error handling, auditing, and performance optimization.
Hands-on experience in data warehousing and OLAP development using SSAS (cubes, dimensions, measures, KPIs, MDX), along with star and snowflake schema modeling to support advanced analytics and scalable reporting.
Proven background in cloud migration and modernization, including transitioning legacy on-premises systems and SSRS/Excel reporting to Snowflake, Azure, and Tableau/Power BI ecosystems for improved scalability, automation, and performance.
Strong understanding of data governance, compliance, and security, including HIPAA standards, PII protection, access management, and row-level security to ensure data integrity and regulatory compliance.
Highly collaborative, with experience working closely with executives, clinical teams, financial analysts, and business stakeholders to gather requirements, translate needs into scalable BI/ETL solutions, and align analytics with organizational objectives.
Adept in Agile/Scrum environments, delivering iterative BI solutions, managing enhancements, and ensuring consistent business value through sprint cycles.
Valued for technical leadership and mentorship, guiding BI developers and analysts in best practices for visualization, ETL development, architecture, and performance tuning.
Excellent communicator with the ability to bridge business and technical teams, conduct training sessions, promote user adoption, and foster a strong data-driven culture across the organization.
Technical Skills:
Category Tools & Technologies
Operating Systems Windows Server 2019, Windows 11, UNIX
BI & Visualization Tableau Desktop, Tableau Server, Tableau Prep, Power BI, SSRS, OBIEE, Google Analytics, Eloqua
ETL & Data Integration SSIS, Informatica, Azure Data Factory, Stitch ETL
Databases & Platforms SQL Server (2014/2012/2008 R2/2008), Snowflake, Oracle, Azure SQL Database, Azure Data Lake, AWS RDS, OLTP/OLAP Systems
Data Warehousing Star Schema, Snowflake Schema, Dimensional Modeling, OLAP Cubes (SSAS), MDX, Erwin
Reporting & Dashboards Interactive Dashboards, Drill-Down/Through Reports, KPIs, Custom Visuals.
Programming & Querying T-SQL, PL/SQL, DAX, Spark SQL, U-SQL, Stored Procedures, Functions, Triggers.
Web Technologies HTML, WML, XML, SharePoint, SSIS, SSAS, SSRS, Power BI, Cognos, Domo, Birst, Tabular Editor, DAX Editor
Certifications:
1)Tableau Certified Associate Certification
2)SQL Server Certified Associate
Professional Experience:
Client: AmeriHealth Caritas, Philadelphia, PA Aug 2024 – Present
Role: Sr Tableau/BI/SQL Developer
Responsibilities:
Led the design and delivery of enterprise-wide BI solutions using Tableau and Power BI, integrating data from Snowflake, Azure Data Factory, AWS, and SQL Server to support cross-functional, data-driven decision-making.
Modernized the reporting ecosystem by migrating legacy SSRS reports to Power BI, enabling automated, interactive, and visually rich analytics for improved operational efficiency.
Reengineered KPI and clinical reporting dashboards in Power BI using advanced DAX calculations, bookmarks, drill-through, and parameterized filtering, significantly enhancing data accessibility for clinical and administrative teams.
Established robust data governance and access control frameworks to ensure HIPAA compliance, safeguard clinical data privacy, and maintain security across all reporting workflows.
Implemented standardized visualization lifecycle management practices, optimizing dashboard design, version control, and publishing processes for consistent and scalable BI delivery.
Built and automated ETL pipelines using Azure Data Factory to deliver near real-time analytics for research and clinical trials, supporting predictive models, advanced reporting, and data science initiatives.
Created advanced Tableau dashboards incorporating calculated fields, LOD expressions, set actions, and parameter-driven interactions to provide deeper analytical insights.
Partnered with clinical, financial, and administrative stakeholders to identify reporting gaps, define KPIs, and develop actionable, insight-driven dashboards aligned with organizational priorities.
Improved dashboard performance through query optimization, data source consolidation, and efficient extract strategies, resulting in faster load times and enhanced user experience.
Mentored junior BI developers, providing guidance on Tableau and Power BI best practices, data modeling, and performance tuning, fostering a culture of continuous improvement and excellence.
Environment: Tableau Desktop, HIPAA, Tableau Server, Power BI, Snowflake, Salesforce, BambooHR, Talent, Stitch ETL, Azure
Client: Nelito Systems Pvt. Ltd, India Jul 2022 – Aug 2023
Role: Sr Tableau/BI Developer
Responsibilities:
Collaborated with physicians, researchers, and insurance teams to design interactive dashboards that accelerated patient insurance approvals, improved clinical decision-making, and supported better patient care outcomes.
Led the end-to-end design, development, and deployment of KPI and operational dashboards for Finance, Sales, Marketing, Call Center, and Policy Management, integrating data from SQL Server, Oracle, Salesforce, Snowflake, Azure SQL, Azure Data Factory, and Google Analytics.
Built real-time business performance dashboards tracking critical metrics such as call volume, service levels, abandoned call rates, and policy sales, enabling data-driven operational and executive decisions.
Managed Tableau Server and Power BI environments, overseeing user provisioning, content governance, extract scheduling, security, and performance optimization.
Implemented row-level security, role-based access controls, and advanced calculations to safeguard sensitive PII/EPIC data while enabling detailed, granular analysis for business leaders.
Created and automated interactive dashboards and visualizations—including bar, pie, scatter, and histogram charts—to track real-time and historical business trends across multiple departments.
Conducted stakeholder workshops to gather requirements, deliver user training, and promote adoption of Tableau and Power BI for reporting, analytics, and self-service BI.
Designed and optimized Snowflake data warehouse models and Azure Data Factory pipelines to ingest, transform, and prepare call center, chatbot, and telephony data for analytics.
Modernized the reporting landscape by migrating legacy SSRS and Excel reports to interactive Tableau and Power BI solutions, improving automation, usability, and reporting efficiency.
Performed data validation, profiling, and cleansing to ensure consistent, accurate, and high-quality data for enterprise reporting and analytics initiatives.
Applied visualization best practices and performance tuning techniques to standardize dashboard development, reduce load times, and ensure scalability across BI platforms.
Supported executives with actionable insights into staffing efficiency, customer service performance, and marketing ROI, leveraging predictive analytics and advanced Tableau/Power BI calculations.
Environment: Tableau Desktop, Tableau Server, Power BI, SQL Server, Snowflake, Azure SQL Database, Azure Data Factory, Google Analytics, Salesforce, Cisco CUIC, Windows Server
Client: SPPS Systems Pvt. Ltd., Hyderabad, India Jan 2021 – Jun 2022
Role: BI/SQL/ETL Developer
Responsibilities:
Designed and developed Tableau dashboards for Information Security teams, delivering insights on system vulnerabilities, compliance posture, and incident management trends.
Built interactive Power BI dashboards using advanced DAX calculations to integrate and analyze Salesforce CRM data, improving visibility into sales performance and operational metrics.
Developed, tested, and deployed SSIS ETL workflows to extract, transform, and load data from SQL Server and XML sources into the enterprise data warehouse.
Authored and optimized complex T-SQL queries, stored procedures, and views to support ETL pipelines and downstream reporting requirements.
Maintained, enhanced, and troubleshot existing SSIS packages, improving performance, ensuring reliability, and validating data accuracy across scheduled workflows.
Delivered ad-hoc reporting and analytical support using SSRS and SQL for cross-functional business teams.
Collaborated closely with business stakeholders to gather requirements, validate ETL logic, and ensure adherence to data governance and quality standards.
Performed data profiling, cleansing, and reconciliation activities to enhance data quality, consistency, and readiness for reporting and analytics use cases.
Environment: SQL Server 2014/2012, SSIS, SSRS, Tableau, Power BI, Salesforce CRM, XML, Windows Server.
Client: Rockline Solutions, India Sep 2019 – Dec 2020
Role: Jr SQL Developer
Responsibilities:
Developed stored procedures, triggers, and user-defined functions to support data transformation, business logic execution, and backend processing for financial applications.
Designed, implemented, and maintained SSIS packages to automate ETL workflows, moving data from OLTP systems into OLAP environments for reporting and analytics.
Created SSRS reports with drill-down, drill-through, and parameterized features, enabling business users to explore account performance and operational insights.
Assisted senior developers with database schema design, indexing optimization, and performance tuning efforts to ensure robust and scalable systems.
Conducted unit testing and debugging of T-SQL scripts, SSIS workflows, and SSRS reports to ensure accuracy, stability, and optimal performance.
Provided ad-hoc reporting support and performed data validation for Finance and Operations teams to meet ongoing analytical needs.
Documented ETL processes, report requirements, and stored procedure logic to support knowledge sharing, operational continuity, and audit compliance.
Environment: SQL Server 2008 R2, SSIS, SSRS, T-SQL, Windows Server
Education:
Master’s in computer science from Harrisburg university, PA