Data Warehouse Engineer

Harish Babu Chekuri

Sr. ETL and Data Warehouse Engineer

Email: ad5xry@r.postjobfree.com

Phone: 425-***-****

PROFI LE SUMMARY:

• Nearly 9+ years of involvement in the IT industry and wealth of expertise in ETL and Data Warehousing.

• A proven track record in comprehensive Business Intelligence (BI) Analysis, spanning from initial business evaluation to post-implementation support.

• Well-versed in the entire software life-cycle (SDLC), including implementation, upgrades, production support, and enhancements, possesses the experience to lead projects through all phases of development.

• Excels in seamlessly integrating and optimizing both structured and unstructured data using diverse database products, technologies, and methodologies.

• Known for the ability to create inventive solutions for an array of enhancement needs and code-related challenges, this professional consistently delivers effective outcomes.

• A keen aptitude for collaborating effectively with diverse business teams, a solid track record of understanding and aligning technical solutions with specific data requirements.

• Highly skilled in designing, developing, and fine-tuning Extract, Transform, Load (ETL) processes, ensuring data accuracy, dependability, and uniformity within data warehousing environments.

• Proficient in Software Development Life Cycle (SDLC) processes, a deep comprehension of various Agile development methodologies, including Waterfall, Scrum, and Agile Framework principles.

• Hands-on experience in Big Data, Data Analytics, and Streaming applications, enabling contributions to the evolving landscape of data management and analysis.

• Backed by a history of successful project implementations, process enhancements, and substantial cost savings, well- prepared as an ETL and Data Warehouse Engineer.

TECHNICAL SKILLS:

• Proficient in coding, debugging, and optimizing software applications.

• Skilled in enhancing and updating existing software for improved functionality.

• Experienced in addressing and resolving software-related issues and bugs

• Strong ability to design comprehensive and scalable systems.

• Proficient in system architecture, including component selection and integration.

• Skilled in system implementation, ensuring smooth transitions and minimal disruptions.

• Adept at conducting thorough business analysis to gather requirements.

• Effective team leadership with experience in guiding and motivating teams.

• Proficiency in assigning tasks, setting priorities, and tracking progress.

• Comprehensive understanding of the entire software development life cycle.

• Proficiency in project planning, requirements analysis, design, development, testing, deployment, and maintenance.

• Skill in adhering to SDLC methodologies, including Agile, Waterfall, and Scrum.

• Experience in managing projects through each phase, ensuring on-time and on-budget delivery.

• Expertise in integrating various data sources into a unified system. EXPERIENCE:

Cloud Data Warehouse Engineer

TIAA GBS Apr’17 - Present

Responsibilities:

• As a Cloud Data Warehouse Engineer, responsible for collaborating with development teams to design and construct data warehousing solutions that leverage cloud technologies. This includes architecting solutions that are scalable, cost- effective, and capable of handling regulatory reporting requirements.

• Involves in planning, developing, and executing the migration of data and platforms to cloud-based environments. This includes migrating an Enterprise Staging Platform from Oracle to Hadoop Big Data, as well as moving Data Warehouse data from Teradata to Teradata Intelli Cloud and Snowflake.

• Responsible in optimizing multiple data warehouses to create a unified data store. This optimization encompasses enhancing existing ETL (Extract, Transform, Load) processes, data extraction methods, and downstream applications to improve data flow efficiency and performance.

• Acquired deep subject matter expertise in various applications, such as UDS (Retirement and Retail Data) and Enterprise Staging Platform (ESP). Allows to provide valuable insights and guidance.

• Leadership role in both development and production support teams during various migration projects. This includes overseeing the planning, execution, and successful completion of these projects, often involving significant cost savings, such as the migration to Snowflake.

Accomplishments:

• SME for UDS and ESP applications. Migrations to Snowflake resulted in saving almost 4M dollar.

• Lead for Migration projects, Lead for Staging, Streaming and Data Quality teams. Worked as solution architect in Snowflake migration.

ETL and Data Warehouse Engineer Aug’13 to Mar’17

IBM

Client: TIAA

Responsibilities:

• Analyzing user requirements, performing impact analysis, and generating system requirements are crucial tasks in data engineering, especially in ETL and data warehousing projects. These responsibilities involve understanding business needs and translating them into technical solutions.

• Collaborating with project teams and presenting business solutions to clients are essential aspects of an engineer's role, ensuring that data solutions align with business goals and requirements.

• Actively participating in data modeling and business modeling indicates proficiency in structuring and optimizing data for efficient storage and retrieval, a key skill in data warehousing.

• Working directly with product owners and stakeholders to elicit their feedback showcases effective communication and the ability to align technical solutions with business needs.

• Partnering with Development Leads to identify opportunities for better collaboration and process improvements demonstrates a proactive approach to enhancing data processes, which is relevant in ETL and data warehousing.

• Performance analysis and tuning related to ETL processes and database queries are critical responsibilities in data engineering, as optimizing data workflows is essential for efficient data warehousing.

• Working with various teams to deliver data to business teams on time highlights the importance of timely and accurate data delivery, a key objective in data warehousing. Accomplishments:

• Single point of contact between Project Management and IT groups from solution planning to Implementing solutions on various enhancements and process improvements.

• Optimized and Implemented solutions for various data issues and process issues.

• Became SME for the domain knowledge and data for one of the warehouses (RMW - Relationship Management Warehouse)

SKILLS SET:

Operating Systems : Windows Platforms, AIX, LINUX

Technologies : Datastage, PL/ SQL, Shell scripting, Hadoop Cloudera, Spark, PySpark, C, C++, Java, Python Database : Oracle, Teradata, MSSQL, Hive, Snowflake Tools : Putty, Star Team, DAC, Teradata Viewpoint, SQL developer, Autosys 11, WS FTP Pro, Serena, GitHub, Jenkins

EDUCATION:

• B-Tech. (Computer Science Engineering) from Amrita Viswa Vidyapeetham University, Coimbatore in 2013

• Senior Secondary (11th & 12th) from Narayana Junior College, Nellore in 2009

• Secondary from Modern High School, Ramachandrapuram in 2007 AWARDS & PROMOTIONS:

• IBM Eminence and Excellence award for the “Best Team Player” for the years 2014 & 2015

• IBM Service Excellence Award for the year 2015

• IBM Manager choice award for “putting the client first” for the years 2015 & 2016

• Top performer and contributor for the years 2014 & 2015

• Promoted from 6G(Associate System Engineer) to 6A(System Engineer) in 2014

• Promoted from 6A(System Engineer) to 6B (System Manager) in 2016

• TIAA Gold Award for the years 2017,2019,2020,2021,2022

• TIAA Titan Award for the years 2020, 2022

• Promoted from Analyst to Associated in 2019

• Promoted from Associated to Senior Associate in 2021

Contact this candidate