SINDHU THIRUKOTTIYUR VASANTHAKUMAR
Austin,TX
Summary
Skilled Principal Software Engineer(Data) with over 18 years of industry experience, adept at quickly mastering and applying new technologies. Proven track record of successfully adapting to and implementing advanced solutions in diverse company environments. Dedicated to continuous learning and driving innovation in data engineering. Its a new skillset that I learn in every company I have worked for.
Overview
20
20
years of professional experience
Work History
Principal Software Engineer
Dell Secureworks
Remote
07.2021 - Current
- Domain : Cybersecurity
- Tech Stack: AWS, Golang, Python, Terraform, Gitlab, Kafka, Kubernetes.
- Collaboration: Worked with Data Engineers, Product Owners, and Managers from other teams focusing on third-party integrations and alerts.
- Real time distributed data processing with Kafka as source: Designed and architected third-party data ingestion pipeline from Kafka to OpenSearch
- Collaborated with another engineer during coding to expedite the project.
- Real time distributed data processing with Dynamodb as source: Designed and architected native data ingestion pipeline from Dynamodb to OpenSearch
- Collaborated with another engineer during coding to expedite the project.
- Monitoring and Dashboarding: Monitored critical in-house applications and AWS systems using Datadog, creating 10+ dashboards and 30+ alarms, reducing incident response time by 40% and improving system uptime to 99.9%.
- Code deployment with CI/CD: Deployed code using GitLab CI/CD pipeline and utilized Terraform for AWS infrastructure management.
- Code Reviews: Conducted code reviews with a focus on clarity and simplicity to ensure understanding by developers of all experience levels.
- Cost Reduction: Worked with Directors to propose, identify and implement cost-saving measures, resulting in a 15% reduction in AWS operational expenses.
Data Engineer
Amazon
Austin, TX
05.2017 - 07.2017
- Domain: Retail
- Tech Stack: EMR, Spark SQL, Scala, Redshift
- Proposed, owned and code EMR based Big data solution using Spark SQL/Scala
- Each region data would run on its own EMR cluster
- The EMR jobs are scheduled to run via Airflow
- Approximately 49GB of data is processed every hour.
- Design, implement, and operate stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications
- Optimize(d) Redshift ETL Pipelines with more than 5000 lines of code
- Improved SQL performance by 60%.
- Built data models to enable 40+ data scientists and analysts arrive better decisions in Supply Chain Domain.
- Built data pipelines using Redshift, Scala, Python and Spark SQL.
- Worked on providing near real time data provision for analytics using S3 -> SNS -> SQS -> ETL. Built data pipelines and data quality mechanisms around it.
- Used Airflow for ETL Orchestration using Python.
- Migrated Oracle ETL jobs to Redshift ETL Jobs
- Lead weekly metrics meeting covering 16 systems for a team of 19 engineers
- Used Git for all version controlling.
Technology Lead - Intel Corp (Contract)
Infosys Limited
Santa Clara, CA
07.2013 - 05.2016
- Involved in creating logical and physical data models, cubes of both OLAP and OLTP Enterprise Systems using Erwin as a tool for large Enterprise Warehouse models.
- Closely interact with Product Owners of various business groups within Intel to understand their requirements.
- Propose solutions that reduce the turnaround time to convert data into meaningful information.
- Lead the analytics team
- Enhance the in-house Meta data driven OLAP cube generator
- This cube generator is a .NET solution which uses AMO objects to create SSAS Cubes
- Improved the logging feature of this solution which reduced the bug fixing time by 50%.
- Create and Fine Tune SQL Procedures, Triggers, Views, Tables and Monitor and analyze current database, provide performance improvements.
- Create PowerPivot reports which convert the information stored in multidimensional cubes into visual information for easier analysis and reporting.
- Work in Agile Environment with iterative development model, plan scrum meetings, sprint planning sessions and coordinate sprint retrospective.
- Led cross-functional teams to successfully deliver complex technology projects within agreed timeframes and budgets.
Technology Lead/TPM - Microsoft (Contract)
Infosys Limited
Seattle, WA
12.2008 - 06.2013
- Create dashboards using SSRS with both SQL and OLAP Cube as source
- These reports are used to check if various orgs are meeting their business goals.
- Involved in designing of logical and physical RDBMS Models for the Enterprise Data Warehouse system of Legal and Antipiracy data.
- Create T-SQL Procedures, views and tables.
- Monitor or track project milestones and deliverables.
- Architect ETL using Informatica 9.0 and SSIS
- Teradata would be extracted from various sources on a daily basis
- The Informatica jobs were used to do both full load and incremental load.
- Requirements gathering by interacting with Business and writing the Functional specification document using scenario-based engineering.
- Sole owner for Database modeling, architecture and design for V1.0 project which included both RDBMS and DWH.
- Led cross-functional teams to successfully deliver complex technology projects within agreed timeframes and budgets.
Module Lead/ Software Engineer - Target (contract)
Wipro Technologies
Chennai
08.2007 - 11.2008
- Worked on data transformation and pipelines of the large warehouses in Target. Used Ab Initio.
- Mentored junior team members, fostering their growth and development within the company.
Module Lead - Capital One Auto Finance (contract)
Wipro Technologies
Dallas,TX And Chennai, India
08.2004 - 08.2007
- Worked on the in house loan application of Capital One Auto Finance.
- Visual Basic/ ASP.NET/ SQL
- Championed best practices in software development methodologies among team members, contributing to an environment of constant learning and growth within the organization.
Education
MS (Software Systems) -
BITS, Pilani, India
06.2008
Bachelor of Engineering in Electronics & Instrumentation -
Madras University, India
04.2004
Skills
- Cybersecurity, Finance, Retail/Supply Chain, High Tech
- AWS – Redshift, EMR, Lambda, DMS, Kubernetes, Kafka, Docker, Scala, Spark SQL, Big Data, SQL, SSRS, SSAS C#NET , Git, Python
- Cross-Functional Communication
- Database programming
- Programming Languages
- New employee mentoring
- Distributed Systems
Work Authorization
H1-B
Awards And Acknowledgements
Amazon Austin Sustainability Ambassador. Lead the zero-cup challenge initiative for the entire Amazon Austin site comprising of 6000 + employees. The usage of number of disposable cups reduced by 50%.
Timeline
Principal Software Engineer
Dell Secureworks
07.2021 - Current
Data Engineer
Amazon
05.2017 - 07.2017
Technology Lead - Intel Corp (Contract)
Infosys Limited
07.2013 - 05.2016
Technology Lead/TPM - Microsoft (Contract)
Infosys Limited
12.2008 - 06.2013
Module Lead/ Software Engineer - Target (contract)
Wipro Technologies
08.2007 - 11.2008
Module Lead - Capital One Auto Finance (contract)
Wipro Technologies
08.2004 - 08.2007
MS (Software Systems) -
BITS, Pilani, India
Bachelor of Engineering in Electronics & Instrumentation -
Madras University, India