Rahul Vaidya
Chesterfield,VA
Summary
Highly skilled Senior Data Architect with 20+ years of experience with proficiency in designing and implementing robust data architectures, managing database systems, and optimizing data retrieval. Strengths lie in understanding complex business requirements and transforming them into effective data models. Proven ability to lead cross-functional teams, deliver critical projects on time, and enhance overall data performance for improved decision-making processes.
Overview
23
23
years of professional experience
Work History
Senior Data Architect
Magellan Health
Richmond, VA
05.2020 - Current
- Developed an enterprise data architecture plan to ensure data is consistent and secure across multiple systems.
- Designed a logical and physical data model for the organization's database system, ensuring scalability and maintainability.
- Implemented ETL processes to integrate disparate datasets into the organization's big-data platform.
- Determined optimal approaches for storing, managing, analyzing, and visualizing large volumes of complex data.
- Performed detailed analysis on existing data sources to determine their suitability for integration into the new architecture.
- Ensured that all development teams are following best practices regarding the design of databases and other related components.
- Created a data warehouse model to store and manage large amounts of structured and unstructured data.
- Developed and managed enterprise-wide data analytics environments.
Senior Data Architect
Capital One
Richmond, VA
10.2018 - 05.2020
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Performed statistical analysis on customer data to identify patterns and correlations.
- Automated daily reporting processes with Python scripting techniques.
- Created unit tests for existing and new Python code using PyTest framework.
- Troubleshot, debugged, and fixed issues related to existing Python codebase.
- Utilized Pandas library for data analysis, manipulation, and visualization purposes.
- Employed Git version control system for tracking changes in source code repositories over time.
Senior Data Analyst
CarMax
Richmond, VA
10.2017 - 09.2018
- Created data visualizations in Tableau to present findings to stakeholders.
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Established KPI metrics and monitored performance of data analysis projects.
- Provided data-driven recommendations for marketing campaigns and product development initiatives.
- Collaborated with cross-functional teams across departments such as Sales, Marketing, Finance.
- Analyzed and tracked data to prepare forecasts and identify trends.
- Analyzed competitive market strategies through related product, market or share trends.
Senior Data Analyst
Capital One Bank
Richmond, VA
03.2015 - 10.2017
- Developed shell scripts to automate and streamline system administration tasks.
- Managed source control repositories like GIT and Subversion for versioning code bases.
- Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
- Developed Python scripts to automate data extraction from various sources, such as databases.
- Supported initiatives for data integrity and normalization.
- Performed exploratory data analysis using Pandas, Numpy and Matplotlib libraries in Python.
- Created dashboards in Tableau to monitor key performance indicators.
- Utilized SQL queries to extract relevant information from relational databases.
Project Manager
Amgen
Thousand Oaks, CA
11.2013 - 03.2015
- Analyzed data from various sources such as surveys, interviews, focus groups. to inform decision-making related to projects.
- Presented findings from data analysis in a clear, concise manner that was easily understood by stakeholders at all levels of the organization.
- Negotiated contracts with vendors and suppliers based on company objectives and budget constraints.
- Ensured compliance with applicable laws, regulations, policies and procedures throughout the life cycle of each project.
- Facilitated resolution of conflicts between team members when necessary.
ETL Architect / ETL Team Lead
Genworth Financial
Richmond, VA
03.2004 - 10.2011
- Developed and implemented ETL processes to extract, transform, and load data into a central repository.
- Designed, built and maintained efficient ETL architectures for various source systems.
- Created technical design documents for all ETL development projects.
- Monitored performance of ETL jobs on a daily basis using automated tools such as SQL Server Agent Jobs or Unix Shell Scripts.
- Provided leadership and guidance to team members, ensuring that tasks were completed on time and to a high standard.
- Conducted performance appraisals for team members, providing feedback and identifying areas of improvement.
Software Engineer
Mahindra & Mahindra
Mumbai, Maharashtra
03.2002 - 06.2004
- Analyzed user requirements to develop software solutions and created technical specifications.
- Conducted unit tests on code modules to verify accuracy and functionality of program logic.
- Monitored system performance and troubleshoot issues in production environment.
- Collaborated with cross-functional teams to ensure quality assurance throughout the development process.
- Created detailed design documents, test plans, user manuals, release notes and other related documentation.
Education
Bachelors in Engineering - Electronics And Telecommunication
Mumbai University
Mumbai India11-2002
Skills
- Business intelligence tools
- Python Programming
- Change management processes
- ETL development
- Data Analytics
- Data integration
- Data Modeling
- Performance Tuning
- Team leadership abilities
- SQL
- Database Design
- Data Visualization and Presentations
- Software Development Life Cycle (SDLC)
- UNIX platform
- Data Analysis
- Informatica platform
- Data formatting
- Process Improvement
References
References available upon request.
Timeline
Senior Data Architect
Magellan Health
05.2020 - Current
Senior Data Architect
Capital One
10.2018 - 05.2020
Senior Data Analyst
CarMax
10.2017 - 09.2018
Senior Data Analyst
Capital One Bank
03.2015 - 10.2017
Project Manager
Amgen
11.2013 - 03.2015
ETL Architect / ETL Team Lead
Genworth Financial
03.2004 - 10.2011
Software Engineer
Mahindra & Mahindra
03.2002 - 06.2004
Bachelors in Engineering - Electronics And Telecommunication
Mumbai University
Similar Profiles
Sinota OduSinota Odu
Lead Scrum Master at Magellan HealthLead Scrum Master at Magellan Health
Garrett SontagGarrett Sontag
Master Resilience Trainer at Magellan HealthMaster Resilience Trainer at Magellan Health
SARAH A. BURRAGE, PhDSARAH A. BURRAGE, PhD
Senior Training Program Specialist (PMO) – Business Innovations at Magellan HealthSenior Training Program Specialist (PMO) – Business Innovations at Magellan Health