Data Analysis Analytics

ANANTH KANAPARTHI

www.linkedin.com/in/ananth-kanaparthi-a01521158/ ******.**********@*****.*** 305-***-****

DATA ANALYSIS MANAGER

A Data Analysis Leader with 15+ years of experience in data analytics with strong understanding on data modeling, data architecture and a proven track record of implementing data-driven strategies that drive business growth. Strong expertise in analyzing large datasets, creating actionable insights, and providing technical guidance to improve team productivity and accuracy in data analysis. A natural leader, with critical thinking, fine problem solving and confident decision-making abilities coupled with attention to detail, passion for creative data presentation, expert technical writing skills and critical judgement.

PROFESSIONAL EXPERIENCE

Capital One Auto Finance Data Analysis Manager Jun 2022 – Present

●Designed & managed team that implemented data pipelines that streamlined cloud data processing by reducing warehouse cluster run time by 15% that resulted in ~ $250K annualized savings.

●Conducted monthly data workshops and mentored several analyst teams teaching SQL query optimizations and data storage techniques reducing cloud compute and storage by ~$300K a year.

●Managed a team of 5 data analysts and 2 data engineers to build and maintain a KPI reporting suite including MBR/QBR metrics to support 6 areas of business, process and operations.

●Built data pipelines to capture data from streaming platforms including Kafka, maintained the data lakes, corresponding snowflake tables and served the role of performing data steward.

●Managed team that built Jupiter notebooks, Data bricks notebooks for ad-hoc data analysis, monthly business review reporting, executive leadership insights and strategic recommendations.

●Facilitated agile project management using Jira sprint boards that helps manage team workload and prioritize customers requests.

●Advised leadership on a new collaborative strategy for business, operational and process teams to better align project plannings bringing synergies and efficiencies that were adopted by other teams

●Ensured all email communications for the mainframe cutover project were all clear, concise and succinct so that there was no ambiguity or misunderstandings.

Capital One Principal Risk Data Analyst Jul 2015 – May 2022

●Developed presentation layer strategy for metrics table migration into Snowflake cloud environment streamlining data consumption patterns while reducing query run times by ~10%.

●Identified transaction patterns for money laundering activities escalated to the Enterprise AML team resulting in 90% case resolution within a 60 day time frame for 99% of the cases.

●Built framework to implement an advanced fraud scoring system for predictive models partnering with data science teams increasing detection accuracy by 35% & fraud recovery rates by 30%.

●Utilized past experience and expertise to develop insights into reporting tool decision making for the auto auction pricing initiative to avoid ambiguities encountered during data validations.

●Developed KPI dashboard to validate accuracy of our Know Your Customer (KYC) and Customer Due Diligence Program (CDDP) data against third party Lexis-Nexis and JD Power data.

●Designed & implemented data quality comparison script automation between platforms and various source data files leveraging Python Jupyter notebook for simple and easy execution.

Fannie Mae Senior Business Analyst Jan 2012 – Jun 2015

●Reviewed data architecture documentation, inspected existing reporting systems and developed strategies to enhance the report accuracy and consistency.

●Communicated with senior management to define and drive technical strategy as well as providing direction for upcoming reporting requests.

●Developed a reporting framework which addressed the department’s strategic objectives by leveraging prior technical knowledge around a forward-looking data architecture and design.

●Troubleshooted and resolved various ad-hoc reporting issues that significantly reduced the error rate in existing production reports.

●Documented methodology, data reports and model results and communicated to all relevant team managers to share knowledge.

Verizon Communication Data Analyst Oct 2007 –Dec 2011

●Built marketing campaign lead list reporting using problematic and intricate segment data to develop market ready campaign targets for agents to assist in increasing cross sales and up sales.

●Performed data cleansing, data homogenization using SAS programming via both ad-hoc programming and macros creation.

●Learned and instituted query tuning and several query optimization techniques to improve the code quality as well as improve execution time.

●Well-versed on over 20+ SQL optimization and SQL fine tuning best practices to generate highly efficient execution of SQL code.

●Achieved an understanding of advanced SQL concepts and techniques to assist in the developing auto-generated SQL scripting that automated and minimized process flow errors by 25%.

EDUCATION

Master of Business Administration University of Texas, Dallas

Master of Science Florida International University, Miami

TECHNICAL SKILL SUMMARY

Operating System

Windows, UNIX, Mainframes, Shaw

Cloud Technologies

Amazon Web Services, Snowflake, Databricks

DBMS/Databases

Teradata, Oracle, SQL Server, Snowflake, AWS Aurora, PostgreSQL

Scripting Languages

UNIX Shell, DB2, SQL, PL/SQL. T-SQL, Python, Spark

ETL & Reporting Tools

Tableau, Amazon Quick site, Informatica, SAS, Spot Fire, Power BI

Project & Version Mgmt

Jira, SCRUM, SDLC, IBM Rational DOORs, GITHUB

Office Tools

MS Office, Google Workspace, G Suite, VBA

FUNCTIONAL EXPERTISE

Process Automation Data Analytics and Data Governance

Data Architecture Mentoring, leadership and Teamwork

Financial Data and Modeling Risk Analytics and Audit Compliance

PROFESSIONAL CERTIFICATIONS

Databricks Certified Data Engineer AWS Certified Solution Architect Associate

AWSCertified Developer Associate SAS Certified Base Programmer

VOLUNTEERING EXPERIENCE

Conducted Financial Literacy workshops for High school and College students

Built Data solutions via ProBono initiative for non profit organizations

Trained Undergrad university students in career readiness camps

Contact this candidate