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.
-
Data AnalystCapital OneFairfax, Va, Us -
Data Science ResearcherGeorge Mason University Oct 2023 - May 2024Fairfax, 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. -
Data EngineerDeloitte Jun 2021 - May 2022Worldwide, 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. -
Community Outreach VolunteerVellore Institute Of Technology Dec 2018 - May 2021Vellore, 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. -
Graduate Teaching AssistantVellore Institute Of Technology Sep 2018 - May 2021Vellore, Tamil Nadu, InCollaborated 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 UniversityData Modeling/Warehousing And Database Administration -
Vellore Institute Of TechnologyComputer Science -
Sri Chaitanya College Of EducationM.P.C -
Sri Chaitanya Techno School, BangaloreSecondary 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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial