Viral Shah Email & Phone Number

Arlington, VA, US

Vienna, Virginia, United States

• Leveraged my leadership skills and expertise in data quality, SQL, and ETL to guide a team of data engineers01, championing best practices while delivering impactful SQL and ETL solutions. Mentored 15+ developers/risk.
• Collaborated with the CTO to design and implement a new Change Control Process, now used by all tech teams, which significantly enhances incident response and ensures rapid system restoration and created KPIs for them.
• Managed vendor engagement for data-related inquiries, collaborating on quote acquisition and answering any technical questions
• Designed and implemented an automated cloud solution using AWS S3 and Terraform to ship logical backups to cold storage, ensuring compliance with data retention regulations and reducing storage costs by 30%
• Redesigned back-testing process of our Risk Models to improve total execution time by 60% with complete accuracy
• Implemented new edge tools such as Puppet manifest and Ansible playbooks to streamline process of building new Postgres servers, resulting in 50% reduction in time required for server setup, feature improvements and.

Vienna, Virginia

• Led semiannual DR simulations, ensuring database readiness, and resolving gaps, exceeding CFTC compliance requirements.
• Automated RBAC for database access, eliminating manual effort by 100% during employee onboarding and departure
• Planned and executed major Postgres upgrades of 20+ servers, achieving 20% performance and reliability gains
• Streamlined onboarding through peer reviews & in-depth data service trainings for rapid integration of new team members
• Improved data warehouse performance by 30% through materialized views for the Risk & Strategic Team for production workflow
• Optimized query performance by 10-50% with indexing, joins, and vacuuming, enhancing data retrieval and system responsiveness

• Built interactive dashboards in Datadog and Splunk to monitor trends on server metrics, relating to increasing disk usage, transaction burn rate and xmin horizon age
• Applied skills using Tableau and SQL in data collection, data analysis and reporting to procure data from databases to create reports requested by the client in a timely manner
• Designed and analyzed solutions for the other teams to address data related concern like performance tuning, query writing, etc. Successful in making queries faster by 10 – 50 % using indexes, joins and/or vacuuming.
• Formulated data access policy, role permissions for users to comply with the internal audit policies
• Migrated data from Oracle to PostgreSQL using standard ETL Process methodologies while maintaining data integrity
• Modified Oracle procedure, triggers, and Talend jobs to make them compatible with the new PostgreSQL system

College Park, Maryland

• Ensured data integrity while creating a new normalized database to map data from the old database in MySQL
• Perform data cleaning of the historical data in R before migrating it to the new system to maintain data uniformity
• Develop SQL queries and codes in PHP to capture functional requirements and provide back-end functionality
• Perform database administration responsibilities such as database back-up import/export in MySQL Workbench
• Maintain documentation using MS Excel and MS Word that provides overview of the complete database system

College Park, Maryland

• Conducted exploratory data mining to study collaborative problem solving in online communities like StackExchange using Python and R
• Devised queries on Data Explorer of the StackExchange.com to fetch data related to user and their activity on the site
• Developing research methods like surveys using Qualtrics for the participation of different users to analyze their online activity based on their feedback
• Organize, classify and identify relevant tags of questions that occur more frequently to perform clustering in MySQL
• Designed algorithm to build co-occurrence matrix identifying a pairwise strength of relationships between user defined tags

Arlington, Virginia

• Designed a new database system in MySQL that stores aircraft details of different manufacturers in one place
• Automated the process to populate its data using Shell and Python
• Achieved normalization by removal of duplicate records; Identifying and fixing discrepancy in the historical data
• Created triggers to perform additional database operations required at every insert operations

College Park, Maryland

• On Campus - Part Time position
• Make sure the customer has pleasant buying experience along with ensuring transparent transaction at the cash register
• Sorted approximately 12000 books and managed the book supply to meet the student’s demand at the start of the semester and handled the returning of the books after the semester end

Andheri Seepz ODC 3

• Worked as Technology Consultant for a large banking client
• Assisted in ensuring seamless service delivery by maintaining databases on numerous servers
• Identified areas of process improvement and automation to reduce time and human error
• Conducted database installations and migration with 95% efficiency in SQL Server
• Analyzed and provided timely update to client in the form of inventory sheets, weekly and monthly team reports using MS Excel
• Worked on Incident Management System to resolve ticketing requests of different teams within the given deadline

Mumbai Area, India

• Ensured students have completed their assignments for Engineering Mechanics and point out their mistakes of approximately 3000 students
• Provided better techniques of presenting their answers when consulted which helped them in getting better grades

MIDC Andheri

• As an intern was trained in Ruby on Rails and Software Development process
• Worked closely in ensuring smooth deliverable for a client’s website by designing database structure for Ruby on Rails

Master’S Degree, Information Management

Pursuing Master's in Information Management specializing in Data Analytics. Currently studying and working on projects that involves.

Bachelor'S Degree, Computer Engineering, First Class With Distinction

Activities and Societies: Computer Society of India - VCET Chapter Organizing Technical Head of Computer Society of India - VCET Chapter.