Home

Sravan Sravan Pachipulusu - Sr BI Engineer

[email protected]

Location: Plano, Texas, USA

Relocation: Open to Relocate

Visa: H1

Resume file: Sravan_Pachipulusu_BI_1791345631633.pdf Please check the file(s) for viruses. Files are checked manually and then made available for download.

SRAVAN PACHIPULUSU McKinney, TX | 3167710981 | [email protected] |LinkedIn | 9+ Years | H1B Summary Senior business intelligence developer with 10+ years of experience delivering business intelligence, reporting, and analytics solutions across healthcare and enterprise domains. Expertise in SQL, Tableau, Power BI, Salesforce, and Python, with a proven track record of developing executive dashboards, analyzing operational KPIs, and translating complex data into actionable insights. Experienced in requirements gathering, root cause analysis, data storytelling, and partnering with cross-functional stakeholders to drive process improvements and business performance. TECHNICAL SKILLS BI & Visualization: Power BI Desktop/Service, Tableau Desktop/Server, Sigma BI exposure, interactive dashboards, KPI scorecards, executive reporting, self-service analytics SQL & Data Modeling: Advanced SQL, complex joins, CTEs, subqueries, window functions, aggregations, query optimization, dimensional modeling, star schema, fact/dimension modeling, semantic models Data Warehousing & Platforms: Snowflake, Databricks, SQL Server, Oracle, modern data warehousing, ETL/ELT, data pipelines, data integration, data marts, data quality, validation, reconciliation Programming & Analytics: Python, Pandas, NumPy, PySpark, Matplotlib, R, scikit-learn, EDA, statistical analysis, data manipulation Machine Learning: Supervised learning, unsupervised learning, regression, classification, clustering, feature engineering, model evaluation, predictive analytics ETL & Automation: Alteryx, Python automation, reporting automation, data preparation workflows, APIs, scheduled refreshes, data reconciliation Modern Data Tools / Concepts: BigQuery exposure, dbt/Airflow concepts, cloud analytics platforms, data dictionaries, KPI definitions, documentation Delivery & Collaboration: Agile, Scrum, JIRA, Confluence, Git, requirements gathering, stakeholder management, UAT, testing, production support PROFESSIONAL EXPERIENCE ABBVIE / SOFTDATAS INC. - Data Scientist / Data Architect | Dec 2022 - Present Develop and maintain Power BI and Tableau dashboards supporting healthcare and enterprise KPI reporting, operational analytics, trend analysis, and stakeholder decision-making. Analyze complex business and healthcare requirements and translate them into scalable BI solutions, analytical datasets, and actionable insights. Partner with business stakeholders, Product teams, analytics teams, data scientists, and technology teams to define KPIs, reporting requirements, data definitions, and analytical objectives. Design and develop data models and semantic analytical datasets using dimensional modeling, fact/dimension concepts, relationships, and reusable reporting structures. Develop complex Advanced SQL using CTEs, window functions, complex joins, subqueries, aggregations, transformations, validation, and reconciliation. Develop analysis-ready datasets using SQL, Python, Pandas, PySpark, Snowflake, Databricks, APIs, and Alteryx for downstream BI and analytics. Integrate data from multiple sources and perform data profiling, cleansing, validation, reconciliation, and quality checks to improve consistency and reporting accuracy. Create interactive and aesthetically focused dashboards with KPI scorecards, filters, drill-through analysis, trend views, and stakeholder-oriented visual storytelling. Perform advanced analytics using Python, Pandas, PySpark, and statistical methods to identify trends, anomalies, opportunities, and business performance improvements. Apply supervised and unsupervised machine learning concepts including regression, classification, clustering, feature engineering, and model evaluation for analytical use cases. Establish and maintain ETL/ELT, refresh, data quality, and reporting workflows and troubleshoot issues across source systems, pipelines, SQL, and dashboard layers. Automate data preparation, reconciliation, and reporting processes using Python and Alteryx to improve efficiency and reduce manual effort. Maintain data dictionaries, KPI definitions, reporting standards, and technical documentation using JIRA and Confluence. Provide production support and cross-functional collaboration while independently managing priorities, resolving issues, and delivering analytics enhancements in Agile/Scrum environments. NOUS INFOSYSTEMS - Data Analyst / Data Scientist | Oct 2019 - Aug 2021 Built and maintained Power BI and Tableau dashboards delivering KPI reporting, operational analytics, trends, and actionable business insights. Gathered and analyzed business intelligence requirements and translated stakeholder needs into scalable reporting and visualization solutions. Designed and supported data models and analytical datasets for recurring reporting and business analysis. Developed complex Advanced SQL queries using joins, CTEs, subqueries, aggregations, and transformations. Performed data profiling, cleansing, validation, reconciliation, and quality checks to improve reporting accuracy. Created interactive dashboards and KPI visualizations with clear, stakeholder-focused presentation of business performance. Supported self-service analytics and repeatable reporting workflows enabling business users to access trusted information. Conducted advanced analysis using Python and statistical techniques to identify trends, anomalies, and operational opportunities. Supported ETL, refresh, and data-delivery processes and investigated issues across source data and reporting layers. Developed reporting automation and data-preparation workflows to reduce manual effort and improve consistency. Collaborated with business users, analysts, technical teams, and stakeholders throughout requirements, development, testing, and delivery. Applied machine learning and predictive analytics concepts where applicable to analytical datasets. Maintained technical documentation, reporting specifications, and analytical methodologies in Agile/Scrum environments. Provided production support and issue resolution for data discrepancies, dashboard issues, and stakeholder reporting requests. HCL TECHNOLOGIES - Business Intelligence Analyst | Oct 2018 - Sep 2019 Extracted and analyzed enterprise datasets using Advanced SQL and Python to support business intelligence and reporting initiatives. Developed Tableau dashboards and analytical reports communicating KPIs, trends, operational performance, and actionable insights. Gathered requirements and translated stakeholder needs into BI reporting, visualization, and analytical solutions. Designed and supported analytical datasets and data models for recurring and ad hoc reporting. Performed data cleansing, transformation, validation, and reconciliation across multiple enterprise data sources. Developed and optimized SQL queries involving complex joins, aggregations, subqueries, and data transformations. Conducted exploratory data analysis to identify patterns, trends, anomalies, and business opportunities. Supported dashboard refreshes and recurring reporting to ensure timely and accurate delivery. Performed data quality checks and investigated discrepancies across source systems and reporting outputs. Collaborated with business stakeholders and technical teams to define KPIs, reporting logic, and analytical requirements. Supported ETL workflows, testing, documentation, and production support throughout the BI lifecycle. Used Python and analytical methods for data manipulation, analysis, and repeatable reporting tasks. Applied data warehousing and dimensional modeling concepts to support reporting datasets. Maintained detail-oriented reporting and data validation processes to improve consistency and accountability. ACCENTURE - Analytics Consultant | Jun 2015 - Sep 2018 Supported enterprise BI and analytics projects involving data extraction, transformation, analysis, visualization, and stakeholder reporting. Developed SQL queries and data-processing workflows to prepare reliable datasets for reporting. Created dashboards and KPI reports communicating operational performance and business trends. Supported Tableau-based visualization and reporting across multiple business requirements. Performed data quality checks, reconciliation, validation, and transformation across source systems. Supported data modeling and analytical dataset preparation for enterprise reporting. Conducted business and operational analysis to identify trends, patterns, and actionable insights. Gathered business requirements and translated needs into reporting and analytics solutions. Developed repeatable data-preparation and reporting workflows to improve consistency. Collaborated with business users, technical teams, and project stakeholders throughout delivery. Participated in testing, UAT, documentation, Agile delivery, and production support. Investigated data and reporting issues and performed root-cause analysis. Supported KPI reporting and business performance analysis for stakeholder decision-making. Applied SQL/Python-based analytics and data preparation where applicable to business datasets. EDUCATION Wichita State University - Wichita, KS | Master of Science in Information Systems | Aug 2021 - Dec 2022 | GPA: 3.9 Keywords: business intelligence active directory rlang Kansas Texas