Expert Data Engineer with extensive experience in data warehousing tools and reporting tools
Visakhapatnam , India
Experience: 9 Years
Timezones: CDT | CST | EDT | GST | HKT | IST | SGT
Willing to travel to client location: yes
Part Time - Available Immediate
One month pay or $6,400.00
- 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, 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
Data & Analytics
Consultative Analytics Platform
SkillsInformaticaPythonStatistical Analysis Software - SASTeradataInformaticaPythonStatistical Analysis Software - SASTeradata
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 dataShow More
Report Rationalization and Automation
SkillsAgile Software DevelopmentPythonStatistical Analysis Software - SASTeradataAgile Software DevelopmentPythonStatistical Analysis Software - SASTeradata
- 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
Enterprise Data Quality
SkillsInformaticaStatistical Analysis Software - SASTeradataInformaticaStatistical Analysis Software - SASTeradata
- 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
Marketing Data Mart ( MRKDM)
SkillsIBM DB2 ProgrammingInformaticaStatistical Analysis Software - SASTeradataIBM DB2 ProgrammingInformaticaStatistical Analysis Software - SASTeradata
- 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 u
Claims Data Mart (CDM)
- 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
Delphi Intelligent System
- 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 simpl
Accenture India Private Limited Chennai
Application Development Specialist
2018/02 - 2019/04
As an Application Development Specialist,
I closely work with the Business team to gather requirements, work with Architects and end users.
Later create Features and User Stories to define the work identified.
Responsible iShow More
HCL Infosystem Chennai
Senior Technical Analyst
2014/11 - 2018/02
As a Senior Technical Analyst,
I was responsible in writing Techincal Design Document based on Business Use cases.
Get Design Documents signed off from Business and Architects.
Responsible in delivering the Application endShow More
NTT Data UK, Bangalore & Chennai
Senior Software Developer
2011/01 - 2014/11
Sriram Engineering College India
Bachelor of Engineering (BEng, BE, BSE, BESc, BSEng, BASc, BTech, BSc(Eng), AMIE,GradIETE)
2005 - 2009
Are you legally authorized to work in the United States ?
Do you or will you require sonsorship for a US employment visa (e.g. H-1B) ?
To discuss your project with Madhavalu, sign up.We'll connect you two when your job is posted.
english - Conversational
I like to travel a lot. I often go to trekking and some off-drives.
Have won ACE award for leading a team and succesfully implementing the Marketing Data Mart
Have won many star performace awards for deliveries.