Data Analyst Power Bi

Avinash Reddy Vinjamuri Data Analyst

Colorado, USA +1-720-***-**** ****************@*****.*** LinkedIn GitHub Portfolio PROFESSIONAL SUMMARY

Results-driven Data Analyst with 4+ years of experience delivering data-driven solutions in Tech and FinTech domains, specializing in dashboard development, data pipeline automation, and advanced analytics. Proficient in Python, SQL, Power BI, Tableau, and cloud ecosystems like AWS, Azure, and GCP, with hands-on expertise in Databricks, Spark, and modern ETL tools (Airflow, SSIS, Informatica). Adept at cross-functional collaboration in Agile environments, with a consistent track record of enabling data-driven decision-making, improving compliance reporting, and supporting enterprise-wide digital transformation initiatives. TECHNICAL SKILLS

Programming & Scripting: Python (Pandas, NumPy, Seaborn, Matplotlib), R, SQL (T-SQL, PL/SQL), Bash, VBA Data Visualization: Power BI, Tableau, Looker, Plotly, Seaborn Databases & Data Warehousing: MS SQL Server, MySQL, PostgreSQL, Snowflake, MongoDB, Oracle, Google BigQuery Cloud & Big Data Tools: AWS (Redshift, S3, Lambda), Azure Data Factory, GCP, Databricks, Apache Spark, Hadoop ETL & Data Pipelines: SSIS, Informatica, Talend, Alteryx, Airflow, EZCap BI & Reporting Tools: SSRS, Excel (Power Query, Pivot Tables, Macros), Crystal Reports Finance & Fintech Tools: Tableau CRM, Salesforce Analytics, Risk Modeling, KYC/AML Dashboards Version Control & Project Tools: Git, JIRA, Confluence, Agile/Scrum Statistical & Analytical Methods: A/B Testing, Hypothesis Testing, Regression Analysis, Time Series Forecasting PROFESSIONAL EXPERIENCE

Data Analyst, IBM Jan 2024 – Present Remote, USA

• Designed and deployed 25+ interactive dashboards using Power BI, Tableau, and Looker, integrating data from Snowflake, BigQuery, and Excel to surface real-time KPIs for executive stakeholders, reducing reporting cycle time by 40%.

• Spearheaded end-to-end ETL pipeline development with Azure Data Factory, SSIS, and Alteryx, automating the ingestion and transformation of 1 million+ rows daily from AWS S3, SQL Server, and Salesforce, boosting pipeline reliability by 95%.

• Conducted deep-dive analyses using Python (Pandas, NumPy, Seaborn) and SQL (T-SQL) to identify subscription revenue leakage; findings drove business rule changes that recovered over $300 K in annual revenue.

• Collaborated with DevOps and engineering teams to optimize Apache Spark workflows in Databricks, cutting job runtimes from 2 hours to under 45 minutes, accelerating insights delivery and improving SLA adherence.

• Automated data validation processes with Bash scripts and SQL queries, enhancing data integrity and reducing QA time by 50%; partnered in Agile sprints to build cloud cost dashboards using AWS Redshift and Tableau, uncovering $300 K+ in resource savings within the first quarter of launch.

• Led a compliance initiative to automate monthly audit reports via SSRS and Excel (Power Query, Macros), slashing preparation time from 8 hours to 2 hours and ensuring 100% on-time audit submissions for 12 consecutive quarters. Data Analyst, Infosys Jan 2020 – Jul 2022 India

• Delivered 30+ executive dashboards using Tableau CRM and Salesforce Analytics Cloud for a leading banking client, enabling real-time monitoring of credit risk and KYC/AML compliance metrics and reducing violations by 22% YoY.

• Rebuild core data pipelines with Informatica, Talend, and SSIS, cutting data latency by 65% and improving data availability for BI teams across three continents, accelerating reporting and decision-making.

• Designed and implemented fraud detection models using Python (scikit-learn, pandas) and SQL, detecting anomalous patterns with 92% accuracy and preventing over $1 M in fraudulent transactions within six months.

• Automated ingestion of transactional and loan data from Finacle into AWS Redshift via Airflow, reducing manual processes by 80% and enabling real-time analytics across 2 M+ customer records.

• Created custom reporting solutions with SSRS, Crystal Reports, and Excel VBA, improving time-to-insight for monthly financial and customer segmentation by 50%.

• Spearheaded a data governance initiative and collaborated with cross-functional teams to define KPIs and develop three new analytics modules for risk, lending, and investment reporting, enhancing metadata documentation, validation rules, and master data quality—boosting data trustworthiness by 40%, streamlining audits, and improving risk assessment efficiency by 22% enterprise-wide. EDUCATION

Master of Science in Management and information systems Aug 2022 – May 2024 Denver, USA University of Colorado (GPA 3.9/4)

CERTIFICATIONS

• Data Analytics Virtual Experience – Accenture [Link]

• Power BI Job Simulation – PwC Switzerland [Link]

• Excel Skills for Business – Goldman Sachs Virtual Program [Link]

• Python for Everybody Specialization – Coursera, University of Michigan [Link]

• Machine Learning with Big Data – Coursera [Link]

• AI for Everyone – Coursera, Andrew Ng [Link]

• AWS Certified Cloud Practitioner – Amazon Web Services [Link]

• Microsoft Certified: Azure Fundamentals [link]

Contact this candidate