Business Intelligence Data Analyst

Ramya Padamati

Contact Number: +1-616-***-**** Email: ***********@*****.***

Data Analyst Business Intelligence Data Visualization

●Over 5 years of IT experience in data analysis, data warehousing, and business intelligence across OLTP and OLAP environments.

●Strong expertise in the full Software Development Life Cycle (SDLC) including requirement gathering, system design, implementation, testing, and maintenance.

●Skilled in relational and dimensional data modeling using star and snowflake schemas for enterprise-level reporting and analytics.

●Hands-on experience in developing and optimizing ETL processes, supporting scalable data pipelines and efficient data integration.

●Proficient in tools like ERwin and PowerDesigner for designing logical and physical data models, including forward and reverse engineering.

●Strong SQL, PL/SQL, and T-SQL development skills with experience in writing stored procedures, triggers, functions, and performance-tuned queries.

●Extensive experience working with databases such as Oracle, SQL Server, Teradata, DB2, and Microsoft Access.

●Proven ability to conduct JAD sessions, collaborate with business stakeholders, and translate requirements into actionable data solutions.

●Designed and deployed interactive dashboards using Power BI and Tableau to visualize key performance indicators, enabling real-time decision-making across business units.

●Ensured all data processing pipelines and reporting dashboards were developed in compliance with HIPAA regulations, maintaining patient confidentiality and data security across all stages of data collection, transformation, and visualization.

●Adept at data warehouse design principles, including fact and dimension modeling, and understanding of metadata and data lineage.

●Experienced in database performance tuning, query optimization, indexing strategies, and cache management.

●Solid understanding of enterprise data architecture, data governance, information lifecycle, and Master Data Management (MDM).

●Excellent communication, leadership, and documentation skills; known for fostering knowledge sharing and data standards across teams.

Technical Skills:

●Data Analysis & BI: KPI dashboards, clinical tracking, Alteryx, process optimization

●Programming: SQL, PostgreSQL, Python (pandas, NumPy, scikit-learn, TensorFlow), R, SAS, JavaScript, C#, VBA, SPSS

●CRM Tools: Salesforce, Zoho CRM

●Databases: SQL Server, Oracle SQL Developer, Oracle Clinical, Azure SQL, Snowflake

●Visualization & Reporting: Power BI, Tableau, DAX, Power Query, Excel (Advanced, VBA), Google Data Studio, Looker

●Cloud & Big Data: Azure (ADF, Blob, Synapse), Apache Spark, CI/CD pipelines

●Tools: Git, GitHub, JIRA, Confluence, Slack, Medidata, REDCap, Microsoft Office

●Soft Skills: Analytical thinking, stakeholder communication, cross-functional collaboration, documentation

Professional Experience:

GE Healthcare Dallas, TX Feb 2024 – Present

Data Analyst

●Extracted, transformed, and modeled large datasets using SQL Server, PostgreSQL, Teradata, and Snowflake to support real-time analytics and reporting pipelines.

●Built scalable data pipelines and machine learning models using Python (pandas, NumPy, scikit-learn, TensorFlow) to forecast trends and improve decision-making.

●Developed KPI-driven dashboards using Power BI and Tableau, incorporating DAX, Power Query, and live connections to Snowflake for optimized reporting.

●Conducted data exploration, cleaning, and advanced statistical analysis in R, SPSS, and SAS to support clinical, marketing, and operational use cases.

●Automated report generation and validation processes using VBA in Excel and data-driven scripts in C#.

●Developed backend APIs and reporting logic using JavaScript and SQL to feed into internal CRM and BI tools.

●Designed and executed A/B testing strategies using Python and R to measure the effectiveness of outreach campaigns and user engagement tactics.

●Ensured HIPAA-compliant data handling and audit trails by applying role-based access and secure logging across Snowflake and other cloud platforms.

●Collaborated in Agile environments using Git, GitHub, JIRA, and Confluence to version control pipelines, document logic, and track feature delivery.

●Built data quality validation frameworks using Python, SQL, and Snowflake's scripting to ensure consistency across ingestion layers.

●Extracted CRM data from Salesforce and Zoho CRM, merging with Snowflake datasets for unified business reporting and insights.

●Presented dashboards and predictive insights to cross-functional stakeholders, translating technical outputs into business strategies.

Technical Environment: SQL Server, Oracle Clinical, SAS, R, Azure SQL, Teradata, Power BI, DAX, Python, Azure Data Factory, HL7, A/B Testing

Medpace Cincinnati, OH Jan 2023 - Jan 2024

Data Analyst

●Leveraged SQL Server, Oracle SQL Developer, and Teradata to mine data and generate operational reports supporting business processes.

●Built forecasting algorithms using TensorFlow and R to improve patient recruitment forecasts.

●Developed interactive Power BI reports utilizing DAX and Power Query to monitor protocol adherence and patient retention risks.

●Implemented data validation routines with Python, C#, and Alteryx to ensure dataset consistency.

●Extracted and analyzed CRM data from Salesforce and Zoho to assess and improve outreach campaigns.

●Streamlined reporting by automating workflows, increasing data accessibility for stakeholders.

●Conducted detailed analyses to identify data irregularities and recommended corrective actions.

●Partnered with cross-functional teams to gather requirements and deliver tailored analytic solutions.

●Authored comprehensive documentation on data processes, enhancing team knowledge and transparency.

●Participated in daily stand-ups and sprint retrospectives to align analytic efforts with team goals.

●Supported audit preparation through meticulous report validation and compliance checks.

●Provided end-user training on interpreting dashboards and data insights.

●Monitored data pipeline performance, proposing enhancements for scalability and reliability.

Technical Environment: SQL Server, Oracle SQL Developer, Teradata, Power BI, DAX, Power Query, Python, C#, Alteryx, TensorFlow, R, Salesforce, Zoho CRM

POWERSOFT GLOBAL SOLUTION LTD Banglore, India May 2019 - Dec 2021

Data Engineer

●Designed and implemented scalable ETL pipelines using Python, SQL, and Apache Spark to efficiently process large volumes of complex data.

●Managed and optimized data workflows across SQL Server, Oracle, Teradata, Snowflake, and Azure services such as Azure Blob Storage and Azure Functions for robust data storage and processing.

●Created and maintained Power BI dashboards to visualize key metrics and track pipeline performance for business stakeholders.

●Ensured compliance with regulatory standards, maintaining data security and audit readiness.

●Conducted advanced statistical analyses and anomaly detection to identify data quality issues and support continuous improvement efforts.

●Automated repetitive data processing tasks and legacy workflows using GitHub Actions, Azure DevOps, and CI/CD pipelines to increase operational efficiency.

●Collaborated closely with Quality Assurance and Business Intelligence teams to define and track key performance metrics for process optimization.

●Developed and maintained detailed technical documentation to facilitate knowledge transfer and team collaboration.

●Performed database tuning and query optimization to enhance performance of large-scale data operations.

●Integrated data from multiple sources to build cohesive datasets supporting downstream analytics and reporting.

●Troubleshooted data pipeline failures and implemented monitoring solutions to proactively detect issues.

●Supported migration and integration efforts involving Azure cloud platforms and on-premises data infrastructure.

●Participated in code reviews and adopted best practices to maintain high-quality, maintainable data engineering solutions.

●Worked within Agile teams, contributing to sprint planning, task estimation, and collaborative problem-solving.

Technical Environment: Python, SQL, Apache Spark, SQL Server, Oracle, Teradata, Snowflake, Azure Blob Storage, AzureFunctions, Power BI, GitHub Actions, Azure DevOps, CI/CD Pipelines

Key Projects:

●Built a machine learning model using TensorFlow to predict participant dropouts in clinical trials by analyzing demographic and engagement data, increasing trial completion rate by 15%.

●Created an interactive Power BI dashboard consolidating recruitment, enrollment, and protocol compliance metrics across multiple sites for real-time monitoring and streamlined reporting.

●Analyzed Salesforce data to identify trends in patient communications, improving outreach strategies and increasing patient enrollment by 20%.

●Designed a multi-layered Tableau dashboard integrating site performance, adverse event trends, and audit readiness metrics, enabling early risk detection and reducing compliance issues by 20%.

Education:

●Bachelor of Engineering in computer science (2016-2020): Malla reddy college of engineering (India);

GPA 7.00

●Masters in Data Science (2022-2023): Western Michigan University; GPA 3.56

Contact this candidate