SP

Swopna Pillai

Technical Architect (data Services & Bi) at Excelitas

Swopna Pillai has extensive work experience in the field of data services and business intelligence. Swopna has served as a Team Lead for Excelitas Technologies Corp., where they designed, developed, and maintained an Enterprise Data Warehouse and BI platform. Swopna also led efforts to integrate M&A with the data warehouse.

Prior to this, Swopna worked as a Data Warehouse Engineer III and Team Lead for First Republic Bank. In this role, they led efforts for client conversion to the bank's new online banking platform and was responsible for designing and developing SSIS packages and informatica workflow. Swopna also provided on-call production support for data warehouse jobs.

Swopna has worked at Visa Inc. as a Staff Systems Engineer, where they created and maintained SQL Server database objects, SSIS packages, and relationships for Visa's IT assets in CMDB. Swopna improved the performance of SSIS packages by redesigning and fine-tuning them, resulting in a three-fold improvement. Swopna also developed various AIE jobs to load configuration items from the staging database to CMDB and improved query performance.

Before Visa, Swopna worked at Pacific Cheese Co. as a Senior Applications Developer, where they designed and implemented SQL database-driven applications and integrated the warehouse management system with Navision ERP. Swopna also created routines for importing and exporting vendor files using SSIS and generated departmental reports in SSRS.

Swopna's work experience also includes roles at CooperVision, eBay, Art.com (AllPosters.com), Guidester, and Sumitomo Silmax, where they held positions such as Sr. Software Consultant, Software Consultant, Software Engineer, and Senior Applications Developer. In these roles, they were responsible for designing, developing, and implementing various database-driven applications and systems, integrating API, and improving system performance.

Overall, Swopna Pillai's work experience showcases their expertise in data services, business intelligence, database management, system integration, and application development.

Swopna Pillai has a Master of Business Administration (MBA) degree in Business Administration and Management from California State University, Monterey Bay. Swopna also has a Bachelor's degree in Electronics and Communication Engineering from Bharathiar University. In addition to their degrees, they have obtained various certifications including a Certificate in Data Science from the University of California, Irvine Division of Continuing Education in 2023, an ITIL® Foundation Certificate from AXELOS Global Best Practice in 2015, a Certified ScrumMaster certification from Scrum Alliance in 2014, a Microsoft Certified Technology Specialist (MCTS) certification from Microsoft in 2014, and a Microsoft Certified IT Professional: Database Developer 2008 (MCITP) certification from Microsoft in 2013.

Location

San Francisco, United States

Links

Previous companies


Org chart

No direct reports

Teams


Offices

This person is not in any offices


Excelitas

3 followers

Excelitas Technologies® Corp. is a leading industrial technology manufacturer focused on delivering innovative, market-driven photonic solutions to meet the illumination, optical, optronic, sensing, detection and imaging needs of our OEM and end-user customers. Serving a vast array of applications across biomedical, scientific, semiconductor, industrial manufacturing, safety, security, consumer products, defense and aerospace sectors, Excelitas stands committed to enabling our customers’ success in their many various end-markets. Our team consists of more than 7,500 professionals working across North America, Europe and Asia, to serve customers worldwide.


Employees

5,001-10,000

Links