Usha Veeramachaneni
Minneapolis,MN
Summary
Around 17 years of IT experience in Analysis, Design, Development, Testing and Implementation of Data Warehousing and Data Integration solutions using Informatica(On-premise/Cloud) and PySpark(Azure Synapse) across Insurance, Banking and Medical devices manufacturing sectors.
Professional data engineering leader with strong focus on delivering impactful results. Extensive experience in designing and implementing scalable data architectures, optimizing data pipelines, and leveraging big data technologies. Known for collaborative team leadership, adaptability, and results-driven approach. Skilled in SQL, Python, PySpark, and cloud platforms, with keen ability to align technical solutions with business goals.
Overview
21
21
years of professional experience
Work History
Lead Data Engineer
US Bank
10.2022 - Current
- Currently working as Lead Data Engineer at US Bank from Oct 2022
Senior Data Migration Consultant
Medtronic
03.2022 - 09.2022
- Worked as Senior Data Migration Consultant at Medtronic from Mar 2022 to Sep 2022.
Senior Data Migration Consultant
Medtronic
10.2020 - 12.2021
- Worked as Senior Data Migration Consultant at Medtronic from Oct 2020 to Dec 2021.
Senior Data Integration Analyst
Allianz Life
12.2019 - 08.2020
- Worked as Senior Data Integration Analyst at Allianz Life from Dec 2019 to Aug 2020.
Informatica Consultant
Medtronic
02.2016 - 12.2019
- Worked as Informatica Consultant at Medtronic from Feb 2016 to Dec 2019.
Informatica Consultant
Medtronic
04.2008 - 12.2013
- Worked as Informatica Consultant at Medtronic from Apr 2008 to Dec 2013.
Software Engineer
DELL International Services Inc
09.2006 - 03.2008
- Worked for DELL International Services Inc as Software Engineer from Sep 2006 to Mar 2008.
Software Developer
Global Computer Enterprises Inc
08.2005 - 07.2006
- Worked for Global Computer Enterprises Inc as Software Developer from Aug 2005 to July 2006.
Education
Master of Computer Applications -
Skills
- Hands-on experience in building scalable ETL pipelines using PySpark for processing large datasets in distributed environments
- Experience in integrating PySpark with Azure Synapse Analytics for large-scale data movement, transformation, and analytics
- Experience in building data ingestion pipelines in Pyspark that extract data from Data Lake Hive views and load transformed data into Data warehouse for analytics and reporting
- Strong experience in writing complex SQL queries and integrating them into PySpark pipelines via JDBC, leveraging Spark SQL and DataFrames for large-scale data processing
- Proven experience as a Technical Lead, responsible for solution design, task planning, code reviews, and leading onshore/offshore teams to deliver high-quality data solutions aligned with Agile methodologies
- Hands-on experience in Enterprise Data warehousing, Data Integration and Conversion projects using Informatica Power Center 10/91/81
- Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse using Informatica Power Center, Informatica Cloud, Power Connect and Power Exchange
- Experience in integration and transformation of data from various data sources like Oracle, SQL Server, JDE, SAP and Siebel into formats like flat-file, XML etc
- Strong expertise in data conversions lifecycle – preparing technical specifications, coding and converting data from legacy systems using ETL tool into Target, performing validations against converted data and finally performing reconciliation
- Expertise in CA Workload Automation and Autosys - created several applications and scheduled them daily/weekly/monthly as per requirement Also created Power shell scripts accordingly
- Strong Knowledge of Data Warehouse Architecture, Star Schema, Snowflake Schema, Fact tables and Dimensional tables
- Performance tuning, troubleshooting, and debugging in Informatica, SQL queries, and stored procedures
- Collaboration with on- and off-shore development, QA teams, and business partners
- Quick learner and adaptive to new and challenging technological environments
- Data pipeline design
- Python programming
- Spark development
- ETL development
- Data quality assurance
Timeline
Lead Data Engineer
US Bank
10.2022 - Current
Senior Data Migration Consultant
Medtronic
03.2022 - 09.2022
Senior Data Migration Consultant
Medtronic
10.2020 - 12.2021
Senior Data Integration Analyst
Allianz Life
12.2019 - 08.2020
Informatica Consultant
Medtronic
02.2016 - 12.2019
Informatica Consultant
Medtronic
04.2008 - 12.2013
Software Engineer
DELL International Services Inc
09.2006 - 03.2008
Software Developer
Global Computer Enterprises Inc
08.2005 - 07.2006