Vijay Aruswamy Email & Phone Number

New York City, New York, Us

• Define and developed an analytics infrastructure to support strategic decision-making in a rapidly growing environment.• Provide technical leadership to design, build, and maintain a robust data ecosystem for product and engineering teams.• Drive data-driven discussions by translating insights into compelling stories for informed decision-making.

Cupertino, California, Us

• Led a team of data engineers in developing and executing data engineering strategies to support business objectives. Provide mentorship, guidance, and direction to ensure the team's productivity, growth, and alignment with goals.• Oversee the design, implementation, and maintenance of data infrastructure and systems. Which Includes managing Compute, Storage, Network resources, Databases, data pipelines/ETL processes and data lakes.• Establish and enforce data quality standards, data governance policies, and best practices for data management. Ensure data accuracy, consistency, and security throughout the datalifecycle• Collaborated with cross-functional teams to design and deploy complex data pipelines, delivering actionable insights and automation for better business processes.• Work closely with data scientists, analysts, and other stakeholders to understand their data requirements, provide support, and help translate their needs into effective data solutions• Lead the successful migration project from in-house infrastructure to a Cloud-based instance. Built, tested, and deployed an Active-Active system for data infrastructure• Implement monitoring tools and practices to proactively identify and address issues with data pipelines and systems. Respond to incidents promptly to minimize downtime and data loss.• Led the integration of NoSQL databases, including MongoDB and Cassandra, into our data infrastructure. • Key Achievements : Established a Data Lake infrastructure capable of hosting diverse data sources, alongside implementing lifecycle policies. Implemented near real-time data use cases utilizing Apache Kafka and Pinot. Led team of engineers through seamless migration activities, encompassing in-house and cloud infrastructures. Architected a reporting infrastructure, enabling analytics and management users to receive timely insights and the pulse of critical data.

Sunnyvale, Ca, Us

• Building Highly Available, Efficient, Scalable and Secure Database wherehouse Architecture (Data Ingestion, Transformation, Loading, Storing, Replicating) to support 3000+ user base with 740K queries on daily basis. • Early team member of the Data Service Operations team, which was responsible for maintaining massively scalable enterprise wherehouse, hadoop eco-system and analytical platform to deliver data driven solutions for business partners, product managers, data scientist and decision makers. • Collecting streaming data and maintaining BigData eco-system which consumes Identity, Behaviorial and social media data from our members. • Maintaining Workflows which generates data from various data ingestion pipelines (Kafka, Gobblin & Lumos) and maintain SLA.• Tune and troubleshoot performance issues with PIG, Hive and SQL scripts.• Responsible in building DWH system from ground-up cases when data-center builds within short duration.• Leading effort to maintain Active-Active DWH pipeline system • Built and maintain system to deliver hourly/Daily indicators to provide pulse of business to Executive team.

Sunnyvale, Ca, Us

Part of Team to Support Large Scale MPP Data Analytical Platform, which includes Hadoop, Pig, Hive, Teradata and Microstrategy.

Cisco has implemented next generation Data Warehouse built on Teradata Platform using 3NF data model. The Cisco Data Warehouse, now the Enterprise Data Warehouse (EDW), has evolved through an Enterprise Architecture initiative to enable subscribing systems to report consistent numbers as recipients of data from the EDW. This initiative is ERBI - Enterprise Reporting Business Intelligence, which enables reporting applications to receive "Single Source of Truth" (SSOT) measures from EDW. The project implemented advanced features that Informatica and Teradata are offering such as Push down Optimization, Fast Load, TPUMP and other Teradata utilities. Our team provides reporting needs for Finance analysts, decision makers and corporate executives on Cisco bookings, revenue and expense tracks.

San Jose, Ca, Us

eBay Inc. (eBay) provides online marketplaces for the sale of goods and services, online payments services and online communication offerings to a diverse community of individuals and businesses. eBay’s Keyword DataMart (KWDM) is part of Internet Search Marketing Group (IMS) and maintains single source of all Keyword's used to traffic with Search Partners (i.e., Google, Yahoo, MSN & etc). Keywords data are sourced with various systems like Sourjouner, Shopping.com, Stubhub.com, Shopzilla.com, Pro-Stores and various user communities uploads. On an average KWDM receives around 25-30 Million Keywords from the above sources with various formats. These keywords are parsed through Scrub & De-Dup process which validates and eliminate duplicate keywords in the system. Triton is the trafficking engine used to identify potential Keywords (around 110 Million out of 5 Billion keywords) for paid search marketing. After one day, KWDM receives cost data files from Partner search engine. After a week, all revenue data for those KW's are collected from Mediaplex (external medium). KWDM builds various Cost and revenue metrics from those feeds and will be used for reporting applications.

Us

Nationwide Insurance data warehouse infrastructure called FOCUS (Faster, Online, Customer-driven, User-friendly, Streamlined) in the areas of AUTO, Claims, and Property Insurance. FOCUS is the heart of Finance data infrastructure of Data warehouse that has redefined the role and operating model of Nationwide’s core finance functions, processes, and systems. Ares of work involvements in Mainframe scripts which executes Teradata Scripts to fetch Business Information for high level managements. Implementing new business requirements, understanding new business process flow, Design, coding, Implementation and production support activities are part of work.

Macquarie Park, Nsw, Au

Optus is the second largest Telecom service provider in Australia. Optus introduced third-generation mobile network called 3G services to its mobile customer base with the following additional services MMS, PTT(Push To Talk), Video Conferencing, Mobile To PC, PC To Mobile, IM(Instant massaging) and etc. Changes due to the above services impacts the following areas of Data warehousing Implementation Staging and Extraction Process, CLDM (communication Logical model), Downstream application interfaces. These changes have been tested using 'Gray box' approach with various like regression, Progression and baseline testing. Testing process will ensure that new 3G services are maintained as “business as usual” model in reporting application.

Dearborn, Michigan, Us

The Functional scope envisaged for Financial @ Speed of Thought (F@ST) application aims to provide the business user community with the ability to align vehicle financial events with respect to both Ford's book of accounts and the financial analysis data used for reporting and decision support. To achieve the above, F@ST application will take data feed from various source systems, with regard to Product development costs, the Part purchase prices, Part transfer prices, and vehicle manufacturing costs. The application will also provide functionality to synchronize, and aggregate all such vehicle financial events and will also facilitate analysis of sales revenue and contribution margin, at VIN level. F@ST would also facilitate the analysis of vehicle material costs for current model and near term forward model programs in a controlled environment using simulated vehicles. It will also provide option costs by vehicle configuration to enable material forecasting by option.

Chennai, Tamil Nadu, In

Aviation Maintenance application was customized for one of the world's largest Aircraft manufacturing Company, Boeing Inc. As well as this project is customized to other clients and MRO's (Maintenance Repair Organizations) for their specific requirements. The modules involved are Aircraft, Aircraft Configuration, Fleet Management, Fault Maintenance, Utilities, Hangar Maintenance, Engineering Task, and Maintenance of various work execution centers, Inventory and Purchase cycle. Personalized assemblies are the combination of above vertical product and the customized solution for companies of specific needs. The project is developed using MS-SQL Server 2000, Ramco Virtual Works, a model-based architecture and complete web-enabled set of workbenches for the application development, ASP and COM then converted into JSP, J2EE and Oracle enabled application according to the customer specification using various conversion and migration tools.