Business Intelligence Data Analyst

Saicharan Chinthyreddy

Cincinnati, OH ******************@*****.*** +1-551-***-**** LinkedIn

Career Objective:

Detail-oriented Data Analyst with 5 years of experience in data analysis, business intelligence, and dashboard development. Adept at leveraging data-driven insights to optimize decision-making and business processes. Seeking to drive impactful solutions through advanced analytics and cross- functional collaboration.

Professional Summary:

5 years of experience in data analysis, business intelligence, and stakeholder collaboration across the insurance and banking domains.

Proficient in SQL, Python, Power BI, and Tableau, with expertise in building dashboards, conducting impact analyses, and crafting data-driven narratives.

Hands-on experience with data visualization tools (Power BI, Tableau) and cloud platforms

(AWS – Redshift, S3, Glue).

Extensive experience in building ETL pipelines using Databricks and Snowflake, ensuring efficient data transformation and integration across diverse sources to support business intelligence and analytics.

Skilled in identifying and solving complex business problems through advanced statistical methods and machine learning techniques.

Integrated multiple data sources, including SQL databases, REST APIs, JSON, and XML, using Databricks and Azure Data Factory, ensuring consistent and reliable data pipelines.

Managed the end-to-end business analytics lifecycle, including requirement gathering, data extraction, transformation, and reporting, ensuring alignment with business goals.

Strong communication skills for presenting insights and building effective working relationships with cross-functional teams.

Technical Skills:

Business Intelligence & Reporting: Power BI, Cognos, SSRS

Databases & Query Languages: SQL Server, Oracle, PostgreSQL, T-SQL, PL/SQL

Data Modeling & ETL: Informatica PowerCenter, Informatica Cloud, Star & Snowflake Schema, Tabular & Multidimensional Models, Power Query, DAX, MDX,TOAD 10.5.

Data Processing & Analytics: Advanced SQL, Data Normalization, Business Intelligence Analytics

Cloud & Big Data Technologies: AWS (Redshift, S3, Glue), Oracle Cloud (ATP, ADW)

Programming & Scripting: Python, R, SQL, Java, HTML, PL/SQL

Methodologies: Agile, Scrum, Waterfall, SDLC

Other Tools: JIRA, Postman, Toad, WINSCP, Excel (Advanced formulas, macros and data analysis)

Professional Experience:

Sr. Data Analyst – Pfizer Deloitte Dec 2020 – Dec 2022 Description: Led data analytics and automation for the Pfizer Transparency Reporting System

(PTRS), ensuring regulatory compliance and financial transparency in pharmaceutical transactions. Designed interactive Power BI dashboards, providing real-time insights into transactions, claims, and reimbursements, reducing discrepancies by 40%. Automated data extraction and ETL pipelines using ICEDQ, cutting manual effort by 60% and accelerating financial reporting cycles. Enabled better healthcare analytics by integrating HCP profile data, claims, and financial transactions strengthening risk assessment and revenue optimization. These contributions improved reporting accuracy, compliance tracking, and operational efficiency, enabling Pfizer to mitigate risks, enhance audit readiness, and ensure seamless regulatory submissions.

Developed and maintained Power BI dashboards for finance and operations teams, ensuring seamless data visualization and reporting.

Designed Tableau dashboards for cross-functional teams, driving data-driven decision-making.

Assisted in ETL data pipelines using Talend, automating the extraction of data from SQL Server to Amazon S3.

Designed business intelligence solutions by integrating data from SQL Server, Oracle, and PostgreSQL.

Developed and optimized PL/SQL scripts for ETL processes, improving data processing efficiency by 30%.

Developed automated reports and dashboards using Excel VBA macros, reducing manual effort by 60%.

Data Analyst – Healthfirst Cognizant Oct 2018 – Dec 2020 Description: Delivered data-driven solutions to enhance HEDIS compliance, ensuring regulatory adherence and improved patient outcomes. Developed complex SQL queries and automated ETL process, enabling real-time tracking of preventive screenings. Streamlined claims and encounter data analysis, reducing manual reporting by 50% and increasing data accuracy. Partnered with clinical teams to optimize patient outreach, driving an 18% boost in screening rates and improving CMS Star Ratings, leading to higher reimbursements and quality scores.

Developed dashboards and visualizations for business users utilizing Microsoft tools such as SQL Server Reporting Services (SSRS) and Power BI to analyze data and deliver insights.

Collaborated in an Agile environment, participating in scrum meetings, sprint planning, and stakeholder presentations, ensuring the timely delivery of high-impact data solutions.

Provided ad hoc analysis to uncover customer behavior patterns, driving a 10% increase in upselling opportunities.

Leveraged advanced Excel features, including pivot tables, VLOOKUP, & macros, to perform complex data analysis and streamline reporting processes.

Validated Master Data Management (MDM) concepts and ensured data consistency across multiple dimensions.

Enhanced CI/CD pipelines for SQL deployments, incorporating automated testing, reducing deployment errors by 25% and increasing code reliability. Certifications:

AWS Certified Solutions Architect – Associate (In Progress)

Certified Scrum Master (CSM)

Education:

Master’s in Computer Science Wright State University, USA GPA: 3.6/4.0 Jan 2023 – Dec 2024 Bachelors CVR College of Engineering GPA: 8.6/10 June 2014 - May 2018

Contact this candidate