Harika Karanam

About Harika Karanam

Enthusiasm is the yeast that makes your hopes shine to the stars” – I firmly believed in this quote from my childhood. From a young age, my zeal and passion for learning and upgrading skills have helped me very much academically. Gradually I have developed a taste for analyzing and problem-solving. I strongly believe that in any industry to keep in pace with the emerging competitors and maximize profits, analytical skills are required extensively. A result Driven Software Professional With around 7 +Years Of experience, Progressively Responsible Experience in Data Analysis and Support of Business Intelligence, Data warehousing, Data mining, DBMS and Data Modelling using Confidential SQL Server Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, SQL, Physical, logical database design and Performance tuning.Proficiency in R and Python, with an emphasis on data manipulation and visualization.Experienced in creating and developing Power BI Dashboards into rich look.Working with analytical techniques like Linear Regression, Logistic Regression, Time-series models, Classification Techniques.STRENGTHS: Communication * Responsible * Team Player * Organized * CreativeAREA OF EXPERTISE: Microsoft SQL Server 2014/2016Power BITableauExcelData ManipulationData CleaningData ValidationData AnalysisMS OfficeTECHNICAL SKILLSBusiness Intelligence & Reporting Tableau,Power BI, QlikviewNo SQL Database HBase, Cassandra, MongoDBHadoop Distribution Horton Works, Cloudera, MapReduce, SPARKBuild and Deployment Tools Maven, Sbt, Git, SVN, JenkinsProgramming and Scripting SQL, Shell Scripting, Python,R programming, Pig Latin, HiveQLDatabases Oracle, MY SQL, MS SQL Server, DB2,PostgreSQLAnalytics Tools Tableau, Power BI, QlikviewDevelopment Tools PyCharm, VS code, Jupiter NotebookCloud Services EC2, EMR,S3, Redshift, EMR, Lambda, Athena,Dockers, Terraform, Databricks,Kubernetes, Glue,Dynamo DB, RDS,SQS,SNSThank you for visiting my profile, Happy to connect!Harika Karanam(+1) 9••••••••@gmail.com

Experience

1. Senior Data Analyst

   Capital One

   Apr 2024 — Present · TX, US

   LedtheIntentvsExecution analysis process by evaluating business expectations against real-time operational data, ensuring alignment between defined objectives and actual outcomes; leveraged Snowflake to write complex SQL queriesthat integrated data from multiple tables to deliver insights that improvedstrategic decision-making. Proactively managedandmonitoredend-to-end data pipelines, ensuring seamless data flow across D1, D2A,andD2BMetriclayers;conducted in-depth RootCause Analysis (RCA) to diagnosediscrepancies, collaborated with relevant teams to implement data corrections, and ensured minimal disruption to downstreamprocesses. Providedcomprehensive Production Supportbyconsistently tracking the health of data pipelines and Tableau dashboard refreshes; identified data inconsistencies, swiftly analyzed data lineage across Snowflake layers, and applied targeted fixes to restore data accuracy and ensure uninterrupted reporting. Investigated and resolved dealer payment discrepancies by conducting deep data analysis across multiple layers in Snowflake; traced data anomalies back to their source, collaborated with relevant teams to correct data errors, and ensured payments were accurately reconciled, reducing escalations and improving dealer satisfaction. DevelopedaBookoutDiscrepancyDashboardthatidentifiedfraudulent dealer activities, such as overcharging Capital One for undelivered vehicle features; designed a custom SQL query to dynamically calculate values like principal, APR, and tenure to validate against notes recorded in the Defender UI, improving fraud detection accuracy and ensuring funds were recovered efficiently. BuiltaLoanOutstanding Dashboardthatflagged high-risk accounts with critical investigation findings and outstanding balances exceeding 240days, enabling the collections team to prioritize overdue accounts and improve recovery strategies.

Education

• The University of Texas at Dallas

  Masters, Business analytics

• Godavari Institute of Engineering & Technology (GIET), NH-5, Chaitanya nagar, Velaguvanda Village, Rajanagaram(M),Rajahmundry,PIN- 533296 (CC-55)

  Bachelor of Technology - BTech, Electrical and Electronics Engineering