Ramesh Uppala

As a Senior Data Engineer, I spearheaded mission-critical migration and optimization initiatives to enhance operational efficiency and data-driven decision-making:

• Orchestrated seamless migration of over 400 Amazon Fulfillment Technologies databases and 18,000+ ETL jobs from Oracle to Postgres, ensuring zero disruption to critical data pipelines.
• Designed highly scalable, backfillable pipelines and denormalized datasets optimized for efficient analytical processing.
• Developed comprehensive data quality testing framework and implemented solutions adhering to data compliance standards like GDPR, PAPG, and COPPA.
• Streamlined operations by implementing best practices, reducing overhead and enhancing stability.
• Mentored and led team of data engineers, fostering professional growth and collaboration.
• Influenced feature development in homegrown ETL platforms and partnered with AWS Redshift teams for enhancements.
• Automated processes and optimized data management, driving significant cost savings and improved efficiency.
• Migrated legacy systems to cloud-based platforms, bolstering scalability and cost-effectiveness.
• Optimized data pipelines through advanced ETL processes and robust database architecture, enabling seamless integration and rapid analysis capabilities.

Lead Data Engineer - Client Engagements

• Designed and implemented scalable, end-to-end ETL infrastructures and dimensional data models for clients, AmericanExpress and VeriskHealth.
• Architected and deployed large-scale ETL pipelines for processing Clickstream data at American Express, that feeds into 100 normalized and denormalized datasets.
• Identified patterns across data lakes/warehouses and provided comprehensive solutions to address data engineering challenges.
• Optimized SQL and ETL performance through rigorous tuning efforts.
• Collaborated with onshore and offshore teams, facilitating seamless knowledge transition, providing technical guidance, and hands-on ETL development/support.

Lead Data Engineer - Client Engagements

• Interfaced directly with clients such as HCA, Schneider, and HPG to gather business and functional requirements, translating them into robust, scalable, and operable data solutions backed by agile architectures.
• Designed and implemented complex, end-to-end ETL pipelines, ensuring efficient data ingestion, transformation, and loading processes.
• Developed automation scripts in UNIX shell for hierarchical file validations, including XMLs, streamlining data processing workflows.
• Orchestrated ETL processes using enterprise-grade tools like Control-M, ensuring seamless integration and scheduling of data pipelines.
• Led and mentored a team of data engineers in an onsite-offshore delivery model, fostering collaboration and knowledge sharing.
• Partnered with business teams to develop and deliver critical daily, weekly, and monthly reports, enabling data-driven decision-making.

Data Engineer - ETL and BI Reporting

• Developed robust ETL pipelines to extract, transform, and load data for business intelligence (BI) reporting solutions.
• Designed and created ad-hoc reporting universes using Business Objects Universe Designer, enabling flexible and self-service data analysis.
• Developed frontend user report interfaces with Java scripting, incorporating validations and enhancing user experience.
• Contributed to quality assurance efforts by preparing comprehensive unit test cases and test plans, ensuring data integrity and system reliability.
• Performed thorough unit testing and bug fixing during the QA testing phase, resolving issues and optimizing system performance.