Vijayapal Reddi Morthala

Experience

• 

  Procter & Gamble

  Jan 1997 - Apr 2005

  •Ensuring the ETL requirements are documented per business expectations. •Lead the ETL design and development walkthroughs and present to Data Architects, Managers & Business Analysts.•Lead the development work, ensure the development is in progress per the design and make sure the quality.•Participating in data model and database design reviews to make sure ETL Meta Data columns are in.•Define & design re-usable transformations, mapplets, lookups, sequence generators, etc.•Review and verify work of ETL developers prior to migration.•Develop implementation plans for ETL objects, ensuring coordination with DBA’s, Migration owners, Data Architects, Testers, etc.•Applied advanced performance tuning skills on ETL mappings, sessions and SQL’s.•Design & Develop the purge process to maintain the monthly loads smoothly. Developed purge process through stored procedures, parameter files. Show less • Responsible for gathering business requirements and document in SRS - standard template. • Responsible for creation of logical data models based on entity-relationship diagrams. The models were developed in accordance with the rules of referential integrity and normalization. • Create Data modelling and generate ER Diagram using Erwin. • Create DDL scripts, database objects like Tables, Indexes, Synonyms, and Sequences etc. • Experience in writing packages, stored procedures and triggers using PL/SQL.• Create stored procedure and user defined functions.• Populate the oracle Database Tables from flat files using SQL*Loader.• Design and developed PL/SQL procedures, packages. Show less

  • Application Architect & Software Engineer Lead

    Jun 2001 - Apr 2005

  • Associate Consultant (AST)

    Jan 1997 - Jan 2005
• 

  PNC

  Jun 2006 - now

  Manages all aspects of organizational data; establishes and maintains procedures and policies for planning, designing, and maintaining the data services are delivered in a high-quality and profitable manner. Oversees the integrity, infrastructure, maintenance, and extraction of organizational data.Partner with business leaders and technology architects on product data development for advanced Analytics support.Build and execute the vision of the Data Science Innovation by delivering machine learning-backed services and data products to support business functions.Assists in the development of major organizational activities and goals to ensure important data needs are anticipated and met.Optimize and standardize production platforms, reduce complexity, and introduce innovative solutions that provide new business capabilities, reduce the total cost of ownership, and create a competitive advantage. Show less • Designs, develops, and optimizes highly complex, specialized data warehouses, with flexible and scalable data and spark data pipelines architecture, to support business users and Business Analytics applications.• Works with IT and business customers to develop requirements for designing the overall data architecture.• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using 'big data' technologies and tools• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational, efficiency and other key business performance metrics• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs• Extracting data from different sources, transforming, and loading it to the Central repository using ETL tools Hive, Impala, Python, Spark, and Power Center Informatica;• implementing a wide range of operations such as data processing, access, storage, governance, security and operations using Hive, Impala, Cloudera manager, and Cloudera Navigator;• identifying ways to improve data reliability, efficiency, and performance using Unravel;• Provide Hadoop onboarding sessions to LOB users to give an overview of Hadoop environment along with best practices using Cloudera Hadoop platform. Show less

  • Data Technology Manager

    Apr 2020 - now

  • Solution Architect Sr - Data & ETL

    Jun 2006 - Mar 2020