Skip to content
View Pradeepkarra1's full-sized avatar

Block or report Pradeepkarra1

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Pradeepkarra1/README.md

👋 Pradeep Karra | Senior Data Analyst & Engineer

Building scalable data solutions across Finance, Banking, and Enterprise Analytics

📍 USA | 📧 pradeepkarra1@gmail.com | 📞 +1 (989) 506-3088 🔗 LinkedIn: linkedin.com/in/karra-pradeep

🎯 About Me

Senior Data Analyst with 6+ years of proven expertise delivering AI-driven analytics and scalable data solutions across financial services, banking, and enterprise environments.

I specialize in:

  • Data Engineering: ETL pipeline development (Informatica, SQL, Python, Databricks, AWS Glue)
    • Business Intelligence: Interactive dashboards and KPI analytics (Power BI, Tableau)
      • Data Quality & Governance: Ensuring accuracy and integrity across complex data ecosystems

        • Cloud Architecture: AWS, Snowflake, Databricks implementations

          • Analytics & Insights: Advanced SQL, statistical analysis, anomaly detection, forecasting

          • AWS Certified Data Engineer | Google Data Analytics Professional | Lean Six Sigma Green Belt

          • Master's in Information Technology (Business Data Analytics) – Central Michigan University

          🏆 Key Achievements

          ✅ 35% improvement in data accuracy at CMU Athletics through systematic data validation & reconciliation ✅ 65% enhancement in ETL throughput on AWS Glue and Kafka streaming pipelines ✅ 30% reduction in integration failures through advanced systems analysis and root-cause investigation ✅ Real-time fraud detection system reducing detection time from 3 hours to 2 minutes ✅ 92% accuracy forecasting models for attendee behavior and revenue pacing ✅ Automated reporting solutions reducing manual report preparation from 7-8 hours to < 1 hour

          💻 Technical Skills

          Programming & Scripting: Python | SQL | VBA | DAX

          Databases & Data Platforms: SQL Server | MySQL | Oracle | PostgreSQL | DB2 | MS Access

          ETL & Data Engineering: Informatica | Databricks | AWS Glue | Kafka | dbt | Airflow | SQL-based ETL | Data Quality Validation

          Business Intelligence & Analytics: Power BI (DAX, Power Query) | Tableau | Excel (VBA, Pivot Tables, Power Query) | KPI Dashboards | Advanced Analytics

          Cloud Platforms: AWS (Certified) | Azure | Snowflake | Databricks | GCP

          Specializations: Time-Intelligence Modeling | Anomaly Detection | Forecasting | A/B Testing | Data Governance | Systems Analysis

          💼 Professional Experience

          Deep LLC | Senior Data Analyst – Data Integration, ETL & BI Analytics

          Oct 2025 – Present

          • Designed and deployed customized SQL-based ETL pipelines moving data across order management, logistics, and operational systems, achieving 35% improvement in data accuracy
            • Applied systems analysis to identify root causes of data mismatches across EDI (ANSI X12), JSON, and relational sources, reducing integration failures by 30%
              • Built interactive Power BI dashboards with dynamic KPIs, advanced DAX measures (rolling averages, YoY growth, time intelligence), and pivot-style reporting
                • Leveraged Databricks for large-scale data transformations and validation, ensuring high-quality analytics delivery
                  • Performed comprehensive data profiling and anomaly detection, resolving data quality issues at source level

                    • Collaborated with Finance, Operations, Risk, and IT teams in Agile cycles to deliver client-aligned analytics solutions

                    • Central Michigan University | Data Analyst – Business Intelligence & Data Reporting

                    • Aug 2023 – May 2025

                    • Developed ETL workflows using SQL and Databricks to transform data from enterprise systems, building trusted reporting datasets
                    • Converted manual Excel-based reporting into interactive Power BI dashboards, improving stakeholder data access
                    • Authored SQL-based transformation logic automating recurring workflows, reducing report prep time from 7-8 hours to under 1 hour
                    • Created advanced DAX measures leveraging CALCULATE, FILTER, ALL, RELATED, DATEADD, TOTALYTD functions for complex KPIs
                    • Designed scalable data models transforming raw operational data into structured business dimensions

                    • Mentored junior analysts and conducted rigorous dashboard validation across multiple filters and scenarios

                    • Genpact – Google Pay | Senior Data Analyst & Data Engineer

                    • Jul 2021 – May 2023

                    • Engineered ETL data pipelines using SQL, Python, and Databricks, standardizing and consolidating large transactional datasets from disparate sources
                    • Applied systems analysis to assess data quality across enterprise datasets, identifying and remediating duplicates, format mismatches, and mapping inconsistencies
                    • Configured Power BI and Tableau dashboards consolidating disconnected reporting views into centralized analytics solutions
                    • Wrote complex SQL queries (joins, CTEs, aggregations, subqueries, window functions) against SQL Server and Oracle for financial and operational analysis
                    • Developed advanced DAX measures supporting percentage growth, conditional business rules, rolling trends, and dynamic KPI calculations
                    • Automated recurring reporting workflows, replacing manual Excel processes with scalable, reusable data pipelines

                    • Investigated reporting discrepancies by tracing data lineage, identifying incorrect joins and mapping gaps

                    • ICICI Bank | Data Analyst – Financial Services & Transaction Analytics

                    • Jun 2019 – Jul 2021

                    • Extracted and analyzed transaction-level data from core banking systems using SQL and Excel, supporting operational and risk reporting
                    • Applied systems analysis to identify duplicate records, delayed updates, and incorrect field mappings in financial data systems
                    • Built ETL-style data workflows using SQL and Power Query, cleaning and transforming transaction data for compliance and operations teams
                    • Designed operational dashboards with exception monitoring, fraud flagging, and transaction trend visibility

                    • Automated recurring financial reporting workflows using SQL formulas and validation checks, reducing turnaround time

                    • Performed anomaly detection on transaction data to identify processing bottlenecks and potential fraud patterns

                      • 🎓 Education

                      Master of Science, Information Technology (Business Data Analytics) Central Michigan University | May 2025 | GPA: 3.75/4.0

                      Bachelor of Technology – Electronics & Communication Engineering St. Martin's Engineering College | May 2019

                      🏅 Certifications & Credentials

                      ✅ AWS Certified Data Engineer – Associate ✅ AWS Certified Cloud Practitioner ✅ Google Data Analytics Professional Certificate ✅ Databricks Fundamentals Certification ✅ Lean Six Sigma Green Belt

                      🔧 Tools & Systems Expertise

                      ERP & Core Banking Systems: SAP, Oracle Financial Systems, ICICI Core Banking Data Integration: Informatica, EDI (ANSI X12), JSON parsing, relational databases Methodologies: Agile, Lean Six Sigma, Systems Analysis, Data Governance Documentation & Collaboration: Technical documentation, stakeholder management, cross-functional leadership

                      🎯 Currently Open To

                      🌟 Senior Data Analyst / Data Engineer roles in:

                    • Fintech & Payments | Banking & Financial Services | Enterprise Analytics

                    • 📍 Locations: US-based (Texas) | Remote-first preferred | Open to relocation

                    • 💡 Looking for opportunities to drive data-driven decision making and build scalable analytics solutions that deliver measurable business impact.

                      • 📌 What I'm Building

                      This repository serves as my professional portfolio. You'll find:

                    • ETL pipeline implementations and data engineering best practices
                    • SQL optimization techniques and complex query examples
                    • Power BI/Tableau dashboard architectures

                    • Python scripts for data analysis and automation

                    • Cloud-based data solutions (AWS, Databricks, Snowflake)

                      • 📞 Let's Connect!

                      💬 Open to discussing data engineering, analytics architecture, and scalable data solutions. 📧 Email: pradeepkarra1@gmail.com 🔗 LinkedIn: linkedin.com/in/karra-pradeep 📱 Phone: +1 (989) 506-3088

                      Happy to collaborate on data projects, discuss best practices, or explore new opportunities!

                      Last updated: June 2026

Pinned Loading

  1. Self-Healing-Data-Pipelines Self-Healing-Data-Pipelines Public

    🤖 AI-powered self-healing data pipeline using Isolation Forest anomaly detection & Google Gemini LLM to auto-detect failures, diagnose root causes, generate recovery plans, and execute remediation …

    Python 3 1

  2. AI-Pizza-Delivery-Chatbot AI-Pizza-Delivery-Chatbot Public

    AI-powered pizza delivery chatbot built with n8n using Google Gemini. Features intelligent order management, menu retrieval, and order status tracking with conversation memory.

    Python

  3. machine-learning-levels machine-learning-levels Public

    Step-by-step machine learning projects using Python and Jupyter notebooks with datasets for classification, regression, time series, and NLP.

    Jupyter Notebook

  4. MagnifyScents-Sales-Analytics MagnifyScents-Sales-Analytics Public

    Sales & Marketing Analytics for MagnifyScents perfume brand — KPI dashboards, revenue insights, customer segmentation, and pivot analysis using Microsoft Excel

  5. telco-churn-prediction telco-churn-prediction Public

    📉 ML project predicting telecom customer churn using the IBM Telco dataset — compares Random Forest, Logistic Regression, Gradient Boosting & SVM with hyperparameter tuning, 5-fold cross-validation…

    Python

  6. Dashboard-Migration-automation-across-BI-tools Dashboard-Migration-automation-across-BI-tools Public

    Migrate BI dashboards between Tableau, Power BI, and Looker — AST-based formula transpiler, honest confidence tiers, zero silent data loss.

    Python