Sri Sowmya Rupa Putta

ad3kwm@r.postjobfree.com

Phone: 512-***-****

LinkedIn: https://www.linkedin.com/in/sri-sowmya-rupa-putta-a5906417a/

PROFESSIONAL SUMMARY:

Over 8+ years of experience and hands on working knowledge in Business Intelligence Reporting applications in various domains of Health care and IT industry with expertise in Analysis, Reporting Services, Tableau, Power BI.

Complete understanding and participated in full software development life cycle (SDLC) process.

Strong experience in MS SQL Server with Business Intelligence in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.

Excellent experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management.

Possess extensive knowledge in Business modeling and Data modeling.

Experienced in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, SSIS Packages with proper control & data flow elements.

Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages.

Experienced in using transformations like Aggregate, Lookup, Data conversion and Merge Join.

Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.

Proven experience in Design, Construction and Maintenance of Data Marts using dimensional modeling techniques.

Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP and Data modeling like Dimensional data modeling, Start Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, using SQL Server Analysis Services.

Experience in creating the MDX queries to access cubes and dimensions (SSAS) and DAX queries to access Tabular reports. Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Excellent knowledge of creating Matrix Reports, List Reports, Chart Reports and Drill-down Reports.

Creating, modifying, deploying, and browsing Cubes with multiple fact measures and multiple dimension hierarchies in SSAS.

Expert in defining queries for generating Drill down reports, Crystal reports, Parameterized reports, linked reports, Sub reports, Matrix dynamics & Filters and Charts in SSRS

Extensive experience in report generation using SQL Server Reporting Services (SSRS) from relational databases and OLAP cubes using Report Designer and Report Builder.

Hands on experience in creating Ad hoc, Dynamic reports using templates.

Proven efficiency in identifying and resolving data quality and consistency issues with due diligence.

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

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

Restricted data for users using Row level security and User filters.

Provided 24/7-production support when needed.

TECHNICAL SKILLS:

LANGUAGES

T-SQL, PLSQL, Python, DAX, MDX, ADO.Net

METHODOLOGIES

Waterfall, Scrum and Agile

ETL &BI TOOLS

SQL Server Integration, Reporting and Analysis Services (SSIS/SSRS/SSAS), Informatica Power Center 8.6.1/8.1.1, Hadoop, Sqoop, Tableau, Power BI, Spark, ADF, Databricks

DATABASE TOOLS

SQL Server Management Studio (SSMS), SQL profiler, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio.

VERSION CONTROL TOOLS

SVN, GIT, GitHub, Gitlab, Jenkins

DATABASES

MS SQL Server, Postgres, MySQL, DB2, Oracle 10g, MongoDB

OPERATING SYSTEMS

Unix, Windows, Linux

CLOUD TECHNOLOGIES

Azure, Amazon Web Services

EDUCATION:

Master of Science: Computer Science

University of Central Missouri, Warrensburg, MO

PROFESSIONAL EXPERIENCE:

Expert Business Consulting LLC Sept 22- Till date

Role: Business Intelligence Engineer

Client: eleVIVO, Gettysburg, PA.

Project: eleVIVO provides focused resources to low vision professionals across the US and its territories. eleVIVO enables professionals to tailor services to their clients’ individual needs, including access to clinical trials and high-quality videos, blogs, and instructional pages to mitigate a severe shortage of educational options for the blind or visually impaired adult.

Responsibilities:

Design and implement Extract, Transform, Load (ETL) processes to integrate data from various healthcare sources, including Electronic Health Records (EHRs), billing systems, and other clinical and administrative databases.

Develop and maintain data models that align with healthcare data structures, ensuring accuracy, efficiency, and support for reporting and analytics.

Design, develop, and maintain healthcare-specific reports and dashboards to track and visualize key performance indicators (KPIs), operational metrics, and clinical outcomes.

Implement analytics solutions to support clinical decision-making, including the analysis of patient outcomes, treatment efficacy, and adherence to clinical guidelines.

Create reports and dashboards related to healthcare financials, including revenue cycle management, cost analysis, and reimbursement optimization.

Develop BI solutions to analyze population health data, identify high-risk patient groups, and implement strategies for proactive care management.

Establish and track quality and performance metrics in accordance with healthcare industry standards and regulatory requirements.

Generate reports and analytics to support healthcare compliance reporting, ensuring adherence to regulations such as those outlined by the Health Insurance Portability and Accountability Act (HIPAA).

Implement and enforce data governance policies and security measures to protect patient privacy and maintain data integrity.

Utilize predictive analytics to forecast patient volumes, optimize resource allocation, and identify potential healthcare trends.

Work closely with cross-functional teams, including clinicians, administrators, IT professionals, and other stakeholders to ensure alignment between BI solutions and organizational goals.

Collaborate with healthcare IT vendors to integrate external data sources and tools into the BI infrastructure.

Identify opportunities for continuous improvement in BI solutions, staying current with emerging technologies, and implementing best practices in the healthcare analytics space.

Environment: MS SQL Server 2022, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Toad, Oracle, Power BI, Hive, PostgreSQL, Jira, Confluence, Trello, Azure Devops, RESTful APIs, SOAP, Python, Tableau, R Programming.

Expert Business Consulting LLC Aug 21- Sept 22

Role: PowerBI Developer

Client: Blue Cross Blue Shield, Chicago, IL.

Project: Blue Cross Blue Shield (BCBS) is a federation of independent health insurance companies in the United States. These entities provide health insurance coverage for individuals, families, and businesses, offering a range of medical services. BCBS organizations establish networks of healthcare providers, manage care services to control costs, and promote wellness and preventive care initiatives. They may offer disease management programs, pharmacy benefit management, and telehealth services. Additionally, BCBS entities participate in government-sponsored healthcare programs like Medicaid and Medicare. With a focus on data analytics and business intelligence, BCBS aims to analyze healthcare trends, assess provider performance, and continually adapt to meet the evolving needs of their members.

Responsibilities:

Integrate healthcare data from various sources, including Electronic Health Records (EHRs), claims data, patient satisfaction surveys, and other healthcare-related databases.

Develop Power BI data models that align with healthcare data structures, understanding concepts such as patient demographics, diagnoses, procedures, and healthcare provider information.

mplement and enforce security measures to ensure compliance with healthcare data privacy regulations such as Health Insurance Portability and Accountability Act (HIPAA).

Develop dashboards and reports that provide insights into clinical performance, patient outcomes, and other key healthcare metrics.

Create visualizations that support population health management, tracking health trends, and identifying opportunities for preventive care.

Build reports related to healthcare financials, including revenue cycle management, reimbursement analysis, and cost optimization.

Develop visualizations that assess and analyze patient satisfaction data, helping healthcare organizations improve the overall patient experience.

Design reports that track and analyze healthcare quality measures, such as adherence to clinical guidelines, readmission rates, and patient safety indicators.

Collaborate with stakeholders to identify and track key performance indicators (KPIs) relevant to healthcare operations, ensuring data-driven decision-making.

Implement data governance practices specific to healthcare data, ensuring accuracy, consistency, and reliability.

Environment: Power BI desktop, Power BI service, Power Query Editor, DAX, Data Modelling, Microsoft Power Automate, ETL, Azure Data Factory, Azure SQL Database, Azure Data Lake Storage, and Azure Analysis Services, Power BI REST API, SQL Server, Oracle, MySQL, Excel, SharePoint, Python.

Serge Software Technologies, Hyderabad Jun 16- Jul 21

Role: Tableau Developer

Client: MyBenefitsLab, Florida Institute for Reproductive Medicine, Jacksonville, FL

Project: MyBenefitsLab is an online wellness marketplace where clients can order discounted wellness blood

tests and doctor consultations from the ease of their computer, tablet or smartphone. Additionally,

MyBenefitsLab delivers internal blood test ordering platforms to wellness service providers across the

nation making their wellness program testing more affordable and efficient.

Responsibilities:

Collaborated with business analysts and end-users to understand their data visualization needs.

Gathered requirements for dashboards, reports, and data visualizations.

Connected to and import data from various sources, such as databases, spreadsheets, and cloud-based data storage.

Cleansed and transformed data to ensure accuracy and relevance for analysis.

Implemented Extract, Transform, Load (ETL) processes as needed.

Designed and created interactive and visually appealing dashboards and reports using Tableau Desktop.

Developed efficient and optimized data visualizations that convey insights effectively.

Implemented filtering, sorting, and grouping features to enhance user interactivity.

Conducted exploratory data analysis to identify patterns, trends, and outliers within the data.

Implemented calculated fields and custom calculations to derive new insights from the data.

Optimized Tableau dashboards and reports for performance, ensuring quick response times and efficient data rendering.

Fine-tuned queries, aggregations, and filters to enhance overall performance.

Stayed updated on Tableau features, updates, and industry best practices.

Identified opportunities for improvement in existing Tableau solutions and implement enhancements.

Environment: MS SQL Server 2017, Tableau desktop, Tableau server, Tableau online, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SVN, Excel, SQL, Oracle, MySQL, ETL, AWS, Azure, R Programming, Python, HTML, CSS, Java script, GitHub, Jira.

Contact this candidate