Summary
Overview
Work History
Education
Skills
Websites
Skills And Expertise
Certification
Timeline
Generic

Jaswanth Vallabhaneni

Naperville,IL

Summary

Senior engineering professional with deep expertise in data architecture, pipeline development, and big data technologies. Proven track record in optimizing data workflows, enhancing system efficiency, and driving business intelligence initiatives. Strong collaborator, adaptable to evolving project demands, with focus on delivering impactful results through teamwork and innovation. Skilled in SQL, Python, Spark, and cloud platforms, with strategic approach to data management and problem-solving.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Senior Database Engineer

Morningstar Investments Inc
09.2016 - Current
  • Migrated On-premises data systems to cloud for TAMP and other high revenue applications
  • Migrated the data systems including databases and ETL processes to AWS native solutions as part of enterprise strategy to move to cloud
  • This helped in modernizing the applications and saving about 250k per year in terms of infrastructure costs
  • Providing support to the high revenue applications for stability and maintenance on daily basis, there by improving customer satisfaction.
  • Automated some of the processes by building pipelines for code deployments and other recurring tasks there by reducing the manual hours for the resources thus saving on operational costs.
  • Migrated ETL processes to Lambdas and Glue (Spark Engine) thus working towards the organization goal of moving away from traditional data centers.
  • Analyzed current processes within the organization to identify opportunities for streamlining related workflows using advanced features available within modern databases.

Senior ETL Developer

Baxter (Resource Point LLC)
06.2015 - 09.2016
  • Built a data integration layer between various source systems to Coupa data layer.
  • Helped the organization move away from JRE to Coupa by building a data hub layer integrating data from various sources for coupa and consolidating data from JRE.

Senior Developer

HSBC (Resource Point LLC)
06.2013 - 05.2015
  • Helped the organization build various Federal mandatory reporting applications like RegW and BASEL
  • Built various jobs that involved complicated reporting logic for building the mandatory reports in time further avoiding penalties
  • Built various reusable components that is used by other developers and saved on several development hours by team

Senior Developer

Sears Holdings Corporation (Resource Point LLC)
02.2012 - 05.2013
  • Built the necessary ETL jobs for generating reports on the effectiveness of SYWR program
  • The reports generated were used by leadership to track the effectiveness of SYWR program launched in efforts to boost the dwindling sales at stores
  • Helped in migrating the warehouse from Netezza to Teradata by building the necessary ETL processes and data consolidation
  • In efforts to reduce the costs of the existing warehouse system Sears decided to move away from Netezza to Teradata
  • Rewrote various ETL processes from Netezza to Teradata

Lead ETL Developer

Walgreens (TCS)
06.2011 - 02.2012
  • Lead both on-shore and off-shore teams to support the business-critical applications and work on the enhancements
  • Provided 24
  • 7 support for business-critical applications like pharmacy data and DI systems including enterprise warehouse
  • Built the ETL layer for advertising application to promote offers to regain the customers

Senior ETL Developer

Walgreens (TCS)
06.2009 - 06.2011
  • Involved in reengineering the PBM Billing system to separate out the adjudication system and billing system to make its response time to a reasonable limit
  • Built the ETL processes for the new system
  • Walgreens had an integrated PBM billing and adjudication system which over the years has begun to slow down due to the data load
  • We have reengineered this system and built an ODS layer to help separate out the billing system data and adjudication data by making the system response faster
  • Involved in building ETL jobs for Mail Management System
  • A prescription ordering though mail system was built to help people order their prescriptions without having to visit the store

Education

B.E - Electronics and Communication Engineering

Anna University
Chennai, India
05-2006

Skills

  • Languages/Scripting : Python, Unix shell, Powershell, Terraform
  • Tools/Services : SSIS, DataStage, Spark, Lambdas, Glue(Spark)
  • Databases : Sql Server, PostgreSQL, Trino, DynamoDB, S3, Trino
  • Cloud Technologies : AWS

Skills And Expertise

Sql, Python, Spark / PySpark, Hive, Pandas, Datastage, SSIS, Glue, Lambdas, Sql Server, Teradata, DB2, Netezza, Oracle, Hive, S3, DynamoDB, Postgres, Trino, Shell, Bash, Powershell, Terraform, AWS Solutions Architect Associate, IBM Websphere 8.0 Developer

Certification

  • AWS Certified Solutions Architect – Associate - Amazon Web Services (AWS).

Timeline

Senior Database Engineer

Morningstar Investments Inc
09.2016 - Current

Senior ETL Developer

Baxter (Resource Point LLC)
06.2015 - 09.2016

Senior Developer

HSBC (Resource Point LLC)
06.2013 - 05.2015

Senior Developer

Sears Holdings Corporation (Resource Point LLC)
02.2012 - 05.2013

Lead ETL Developer

Walgreens (TCS)
06.2011 - 02.2012

Senior ETL Developer

Walgreens (TCS)
06.2009 - 06.2011

B.E - Electronics and Communication Engineering

Anna University

Similar Profiles

CREATE PROFILE
Jaswanth Vallabhaneni