Madhavalu V.

Madhavalu V.

Expert Data Engineer with extensive experience in data warehousing tools and reporting tools

Visakhapatnam , India

Experience: 9 Years

Madhavalu

Visakhapatnam , India

Expert Data Engineer with extensive experience in data warehousing tools and reporting tools

9 Years

Now you can Instantly Chat with Madhavalu!

About Me

  • Extensive experience in Data Warehousing with good knowledge on ETL tools Informatica Power Center and code based ETL using Teradata Stored Procedure and BTEQ
  • Extensive Experience in writing Teradata Stored Procedures, TPT, BTEQ...
  • Extensive Experience in writing Teradata Stored Procedures, TPT, BTEQ, FLOAD, MLOAD scripts etc.
  • Experience in implementation of Marketing Data mart.
  • Specialized in a variety of SAS Techniques and ETL tools and well versed with the Build and Deployment automation process.
  • Extensive experience in Production Support.
  • Experience in creating Tableau Dashboards and publish the data quality reports to Business Team

Show More

Portfolio Projects

Consultative Analytics Platform

Company

Consultative Analytics Platform

Description

Responsible in gathering Business requirements and create a mapping document to analyze how the metrics can be derived

Create Features and User Stories in Rally to define the work identified

Create Extract queries to pull data from Data Marts on Teradata.

Create Extract data sets in SAS from variety of sources like Data Marts, Data Lakes

Migrate data from legacy databases to Corporate Warehouse on Teradata

Develop business logics using SAS and create Metric Data sets

Using the Metric Datasets create XML and design the report using HP Exstream and python-pptx

Show More Show Less

Tools

Agile Git Jenkins

Report Rationalization and Automation

Company

Report Rationalization and Automation

Description

  • Identify reports with a high percentage of common fields
  • Identify reports with common business definitions, review actual reports and consolidate similar reports
  • Migrate from non-strategic sources to strategic sources (Data lake)
  • Automate any manual effort involved in in Data Capture, Data Cleansing, Manipulation, Validation and Data Distribution.

Show More Show Less

Enterprise Data Quality

Company

Enterprise Data Quality

Description

  • Involved in Project Designing and preparing mapping documents
  • Analyzed source data for cleansing and applying business rules using Teradata SP
  • Performed Unit testing the code for functionality and integrity
  • Extensively used Informatica client tools Source Analyzer, Mapping Designer, Workflow Designer and Workflow Monitor
  • Extensively created dashboards, stories in Tableau to look and feel as per the business requirements using different analytical views

Show More Show Less

Marketing Data Mart ( MRKDM)

Company

Marketing Data Mart ( MRKDM)

Description

  • Responsible in gathering Business requirements and mapping them into Staples proprietary ETL techniques and Data modeling techniques and propose client an effective Enterprise data warehouse and Enterprise Operational data store solution using the framework.
  • Develop ETL and database loading frameworks for the application using Staples ETL design techniques using Informatica and Teradata (TPT, BTEQ & Macros) utilities.
  • Develop business logics using Teradata stored procedures
  • Strong understanding on Staples Retail Domain, Applications and data warehouse which helps in resolving the issues involved in daily data load process within the SLA time.
  •  
  • Responsible for building enhancements as per changing business requirements and implementing industry standard solution using Staples framework for ETL design and data modeling for Marketing Data Mart in Staples data warehouse.
  • Responsible for facilitating user acceptance tests with the business users.
  • Responsible for performing promotion of developed code into production environment.
  • Understanding business process and requirements to effectively manage the project as per Staples specific standards and guidelines.
  • Will provide software testing (unit and system) services for all development work prior to the production implementation.
  • Conduct post implementation analysis to assess software effectiveness and usability.

Show More Show Less

Claims Data Mart (CDM)

Company

Claims Data Mart (CDM)

Description

  • Requirements gathering at client location and Business Analysis in support of Data Warehousing efforts.
  • Designed ETL specification documents.
  • Created Tables, Keys (Primary, Secondary, PP..) and indexes in the Teradata DB.
  • Imported, created and edited the table definitions using Informatica Designer.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries.
  • Recommended tuning options to source/target database to gain optimum performance.
  • Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings.
  • Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
  • Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects by creating shortcuts.
  • Created Schema objects like Indexes, Views, and Sequences.
  • Writing Teradata procedures for processing business logic in the database. Tuning of SQL queries for better performance.
  • Used the Slowly Changing Dimensions – Type II in various mappings.
  • Testing and maintaining of Informatica mappings.

Show More Show Less

Tools

Eclipse

Delphi Intelligent System

Company

Delphi Intelligent System

Description

  • Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
  • Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects by creating shortcuts.
  • Created Schema objects like Indexes, Views, and Sequences.
  • Writing PL/SQL procedures for processing business logic in the database.
  • Unit and integration testing on Informatica mappings.
     

Show More Show Less

Tools

Eclipse