Pavan K.

Pavan K. Email and Phone Number

Data Analyst @ Capital One
Fairfax, VA, US
Pavan K.'s Location
Fairfax, Virginia, United States, United States
About Pavan K.

Data engineer with expertise in converting complex business requisites into sophisticated data architectures, predictive models, and comprehensive analytical reporting solutions.•Proficient in the complete lifecycle of machine learning processes encompassing Data Acquisition, Data Preparation, Data Manipulation, Feature Engineering, Application of Machine Learning Algorithms, Model Validation, and Data Visualization.•Experienced in Machine Learning, Mathematical Modeling, and Operations Research, with proficiency in R and Python.•Proficient in Python and its libraries such as NumPy, Pandas, Scikit-Learn, Matplotlib, and Seaborn.•Experienced in working with deep learning frameworks TensorFlow, Keras, and PyTorch, and employing Databricks for efficient management and deployment of these models.•Proficient in utilizing Integrated Development Environments (IDEs) such as Jupyter Notebook, Visual Studio Code, and Sublime Text for software development and data analysis projects.•Experienced in Big Data, HDFS, Map Reduce, and PySpark.•Skilled in constructing Data Warehousing and ETL pipelines utilizing Spark, Airflow, and various cloud-based technologies, with significant experience in leveraging Databricks for scalable big data solutions and machine learning workflows.•In-depth knowledge of Cloud Infrastructure like AWS S3, AWS EC2, AWS EMR, Sagemaker, AWS Lambda, Docker, and extensive use of Databricks for streamlining data processing and analytical tasks.•Successfully operates within a high-pressure, multitasking environment, demonstrating proficiency both independently and as an integral member of a collaborative team.•Expert in deploying and managing big data architectures and applications using Databricks’ unified analytics platform to drive operational efficiency and insight.

Pavan K.'s Current Company Details
Capital One

Capital One

View
Data Analyst
Fairfax, VA, US
Website:
capitalone.com
Employees:
63917
Pavan K. Work Experience Details
  • Capital One
    Data Analyst
    Capital One
    Fairfax, Va, Us
  • George Mason University
    Data Science Researcher
    George Mason University Oct 2023 - May 2024
    Fairfax, Virginia , Us
    •Developed interactive sales analytics dashboards for business stakeholders, providing real-time insights into product performance, market share, and sales trends, leading to more informed decision-making.•Played a pivotal role in a forecasting project that contributed to a 15% increase in company revenue, as the leadership team made effective use of the data-driven insights derived from the project's findings to predict consumer preferences, maintaining optimal•inventory levels, introducing new products, planning promotional activities, pricing strategies and market expansion.•Conduct cost-benefit analyses to ensure the solutions are efficient and effective.•Employed a robust data modeling approach employing star and snowflake schema techniques to support complex analytics in the CPG industry, enhancing decision-making processes and enabling the identification of market trends and consumer preferences.•Spearheaded end-to-end ETL development using Databricks, Python, and SQL, emphasizing data quality checks and validation, resulting in a 20% reduction in data anomalies and improved data reliability.•Thrived in an environment focused on data engineering-related services, with extensive use of Apache Airflow for workflow orchestration, ensuring data pipelines operated seamlessly and reliably.
  • Deloitte
    Data Engineer
    Deloitte Jun 2021 - May 2022
    Worldwide, Oo
    • Developed Dashboards and Reports with Excel, SQL Server, SharePoint List, and Report Server data sources using Power Bl Service Desktop tool.• Involved in database development using stored procedures, triggers, views, and cursors.• Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.• Involved in creating MDX, DAX, Cubes, and Tabular models using SQL Analysis Services (SSAS).• Wrote efficient Stored Procedures for the Optimal Performance of the system.• Embedded Power Bl reports on the SharePoint portal page and managed access to reports and data for individual users using Roles.• Generated dashboards in POWER BI Desktop and POWER Bl Service using super-fast slice and dice and modern data visualization features.• Designed and developed a new ETL/SSIS package that loads data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.• Designed a dimensional data model of the OLAP database using Erwin.• Automated Power Query refresh using PowerShell script and Windows task scheduler.• Used various sources to pull data into Power Bl such as Sol Server, Oracle, SQL Azure, etc.• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.• Used Power Bl Desktop to develop data analysis of multiple data sources to visualize the reports.• Responsible for creating and changing the data visualizations in Power Bl reports and Dashboards on client requests.• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from the Tabular Model.• Deployed Dashboards, Reports, and Data sources in the Power Bl Service.
  • Vellore Institute Of Technology
    Community Outreach Volunteer
    Vellore Institute Of Technology Dec 2018 - May 2021
    Vellore, Tamil Nadu, In
    • Spearheaded the strategic development of community outreach programs, focusing on specific community needs, resulting in increased program effectiveness and community impact.• Orchestrated collaborative efforts with NGOs to expand the reach and sustainability of outreach initiatives, resulting in increased participation.• Implemented data analytics tools to assess program performance, allowing for data-driven adjustments and optimization of resources, leading to measurable improvements.• Established mentorship programs for underprivileged youth, providing valuable guidance and skill development opportunities, resulting in improved academic performance.• Acted as a passionate advocate for the community, representing the university in discussions and initiatives addressing pressing social issues, ultimately fostering positive change and community well-being.
  • Vellore Institute Of Technology
    Graduate Teaching Assistant
    Vellore Institute Of Technology Sep 2018 - May 2021
    Vellore, Tamil Nadu, In
    Collaborated with faculty to refine course materials, incorporating the latest industry trends and research to ensure students received a cutting-edge education.Implemented innovative teaching methods, such as flipped classrooms and hands-on projects, to foster student engagement and critical thinking skills.Provided personalized guidance to students, addressing their unique learning needs, and offering additional resources for comprehensive understanding.Assisted in guiding undergraduate students in research projects, nurturing their research skills, and fostering a culture of academic exploration.Contributed to the development of assessment tools, enabling continuous improvement in curriculum delivery, and provided constructive feedback to aid student development.

Pavan K. Education Details

  • George Mason University
    George Mason University
    Data Modeling/Warehousing And Database Administration
  • Vellore Institute Of Technology
    Vellore Institute Of Technology
    Computer Science
  • Sri Chaitanya College Of Education
    Sri Chaitanya College Of Education
    M.P.C
  • Sri Chaitanya Techno School, Bangalore
    Sri Chaitanya Techno School, Bangalore
    Secondary Education

Frequently Asked Questions about Pavan K.

What company does Pavan K. work for?

Pavan K. works for Capital One

What is Pavan K.'s role at the current company?

Pavan K.'s current role is Data Analyst.

What schools did Pavan K. attend?

Pavan K. attended George Mason University, Vellore Institute Of Technology, Sri Chaitanya College Of Education, Sri Chaitanya Techno School, Bangalore.

Who are Pavan K.'s colleagues?

Pavan K.'s colleagues are Alyssa Ayres, Robert Nelson, Brandon Gomez, Claire Mount, Slavisa Djukic, Jahnavi Rao, Percy Rovelo.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.