Vignesh Subramanian Email & Phone Number

Oakland, California, Us

Serve as a technical lead and data architect for a team of Data Engineers with varying skill sets to build a first-class Data and Analytics Infrastructure PlatformImplement the strategic initiative roadmap by interfacing with Engineering, Growth Marketing, Product and other cross-functional groups to ensure strategies and processes alignment with business objectives.Architected and managed implementation of several data intelligence products and that power the marketplace analytics teams and product insightsImplement thredup's datawarehouse to help support our enterprise data usage

Oakland, California, Us

Design and build Redshift data warehouse to support entire organization Business Inteliigence needs.Design and develop ETL/ELT (Extract, transform and load) data flows and processes to bring data from various data sources such as transactional systems,click stream event data,external vendor API’s etc to Redshift data warehouse.Developing Data marts for complex Analytical models around heterogeneous data sets of Clickstream data and OLTP systems and other external data sources in our Data warehouse.Build dimensional models in thredup’s business intelligence tool ‘Looker’ for Reporting and Dashboard purposesCreate data pipelines for advanced data mining and prediction projects.Collaborate and work with the Engineering team on creating and validating data models for new operational systems or features in the productApply creative solutions in optimizing database performance, monitor key metrics and take relevant actions in case of failures.Optimizing database/data warehouse performance and developing mechanicms to monitor /impove data quality and consistency.Tech Stack: Redshift, SQL, Python, Spark, Kinesis and Airflow BI tools: Looker, Tableau, and Amplitude

Interface with Business Analysts and customers to develop business requirements and translate it into functional specifications and design documents, develop implementation and test plans and deploy the analytical applicationsDesign and develop ETL solutions/data acquisition strategies to support the data needs of enterprise data warehouses and reporting applicationsPerform dimensional modelling for building facts and dimensions for data warehouses and develop T-SQL scripts and SSIS packages to load and update data into the DW and build cubes using SSASAdminister and implement the design for the process/software to create report generation script for ‘scorecard’ reports for mines and modify databases to meet client’s needsDesign and support of analytical tools, reports, OLAP cubes and implement security measures to safeguard information in the database. Work with the software engineering team to design the data layer and functionalities of an electronic document data capture application. Analyze the use of NoSQL technologies to fit the needs of the applicationCreate Conceptual model based on the business process and identify the entities, attributes and relationships and convert the conceptual model to the logical data model for mining application systemsCreate and maintain database maintenance plans, indexing, and database email, error handling mechanisms in SSIS packages and email alerts for Job/step failure in SQL jobs.Implement and maintain Web-based applications integrated with a variety of data sources using ASP.Net framework and C# programming and develop web-based dynamic dashboards using DevExpress

79409, Tx, Us

Developed in-house web applications that involved all phases from the UI to backend/Reporting for the use by staff and faculty This involved mainly using using ASP.net/C# ,Oracle 10g and SQL Server.Designed the architecture,database model, interfaces to support a web based student teacher evaluation system and developed stored procedures,views for the data flowModeled data marts,created SSIS packages for ETL, cube development using SSAS and Excel for analysis.Data Analysis to report useful findings on academic data using SPSS and SASGenerating reports using SSRS and Crystal reports and SAS EG.

Mumbai, Maharashtra, In

Programmer analyst in capital market infrastructure design and development team that is responsible for providing solutions to financial exchanges.Analyzing the requirements and developing the business logic for components such as Clearing, Depository services and Corporate Actions.Analyzing the requirements specification and designing and implement the data model, batch process and reports.Developing XML structures for communication services that facilitate exchange of messages between external participants and the system.Perform unit testing and taking active part during the system and integration testing phases.

Master Of Science (M.S.), Management Information Systems, Business Intelligence & Analytics

Bachelor Of Engineering (B.E.), Computer And Information Sciences, General

All India Secondary School Certificate Examination