Amelraj David

Work with the business intelligence team to gather requirements for the database design and model
Understand the data needs of the company or client
Collaborate with the development team to design and build the database model
Engage the development team to implement the database
Determine the business needs for data reporting requirements
Adjust access to the data and the reports as needed
Work closely with the development team to implement data warehouse and reporting
Understand the company’s data migration needs
Work with the development team to implement the migration
Work with data scientists to determine metadata querying requirements
Help to implement the querying
Help determine and manage data cleaning requirements
Help determine data security needs and implement security solutions

Coordinating with customers and stakeholders to understand the project needs and reporting requirements
Preparing function specification document
Ensuring the effective translation of business requirements into conceptual data model
Development and maintenance of logical data model & physical data models using Model Mart in Erwin
Generating strategies for reference data/ master data management
Liaising with business, database administrators, and application developers to conduct design reviews, validation and implementation of developed models
Supporting development team in understanding data model and mapping rules
Performing data profiling on source system, making gap analysis assessments and assigning standard name for new columns brought inside the data warehouse
Networking with the source team in order to receive SOR data at the right time
Performing data gap analysis and driving the data requirements clarification with source systems
Backing BI person to understand the data model and providing the necessary support in data quality and data availability
Teaming up with data mining users to create reporting data structures
Preparing upstream and downstream mapping documents including documentation of the transformation rules based on business requirements
Preparation of project plans and effort estimates
Assisting UAT including user training

Analyses the Functional requirement document and drives the requirement gathering phase with business users to determine the business requirements and gets sign off
Used Model Mart features of Erwin for creating, managing and publishing Enterprise wide reusable data models
Created a data model for loan system in order to evaluate the consequence of loan defaulters and recoveries and also created S2T mapping documents
Developed a model to capture investment, trade, campaign events, fund transfer events etc.
Designed physical data model based on the approved Financial Services Logical Data Model
Collaborate with Data mining users to create reporting data structures
Interacted with the Source team so as to get the SOR data at the right time
Performed data gap analysis and driven the data requirements clarification with source systems
Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
Led & mentored team of 8 to 10 members
Conducted knowledge transfer sessions and delivered regular instructions
Designed transactions and hierarchy tables for GMIS stores and supply chain of Central Europe to support reporting user needs
Reverse engineered the database and report objects and identified the data elements in source system, key performance indicators, facts and dimensions required for development of BI reports
Built data model and ensured timely creation of table orchanges
Created database entities /semantic layer views to support Microstrategy & Business Objects reports on Customer Buying Patterns, Sales Comparison, Vendor Performance, Labour Forecasting, so on
Successfully developed and maintained logical and physical Data Models using ER Studio
Updated the data model after each change requests or new initiatives
Directed junior associates during coding and/or configuration & testing processes
Sharing best practices with team
Created FSLDM tables into production environment through scripts generated through Erwin
Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
Developed project plans, undertook effort estimation and prepare FSLDM Mapping documents
Pre-check the Teradata Performance Metrics in UAT phase and send it to Senior Architect for approval
Tracked resource usage of Teradata through performance metrics and resolved non-compliant/ poor performing queries such that system impact of Load Ids is within the threshold limit
Drove smooth operations through resolution of queries for line of business and users
Functioned as Subject Matter Expert for Core Sustainability Flows
Steered production support activities including: Development of Production Support Turnover Document and Implementation & Release Plans, Resolution of data anomalies in production environment
Resolution of queries of Line of Business, Analytical Users, Source and Target Systems of CDM encompassing process flows, job scheduling details, data models descriptions on code values, so on
Conceptualised and designed effective scheduling strategy for Teradata Scripts in Autosys
Undertook validation of data in warehouse through repeated set of queries and ensure accurate loading of target tables including resolution of discrepancies through validations
Supported application development teams with impact analysis, code reviews, Autosys jill changes, data archival, manual loads and implementation runs
Created Teradata code to implement business requirements post signing of requirement traceability matrix
Pulled source data by using Multi-load, Tpump & Fast Load Scripts
Processed business logic using Bteq/Shell Scripts
Sent data to downstreams using FTP & NDM scripts
Prepare Test cases
Performed functional testing in Development region
Works closely with Business Analyst to resolve SIT issues

Designed transactions and hierarchy tables for GMIS stores and supply chain of Central Europe to support reporting user needs
Reverse engineered the database and report objects and identified the data elements in source system, key performance indicators, facts and dimensions required for development of BI reports
Built data model and ensured timely creation of table orchanges
Created database entities /semantic layer views to support Microstrategy & Business Objects reports on Customer Buying Patterns, Sales Comparison, Vendor Performance, Labour Forecasting, so on
Successfully developed and maintained logical and physical Data Models using ER Studio
Updated the data model after each change requests or new initiatives
Directed junior associates during coding and/or configuration & testing processes
Sharing best practices with team
Created FSLDM tables into production environment through scripts generated through Erwin
Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
Developed project plans, undertook effort estimation and prepare FSLDM Mapping documents
Pre-check the Teradata Performance Metrics in UAT phase and send it to Senior Architect for approval
Tracked resource usage of Teradata through performance metrics and resolved non-compliant/ poor performing queries such that system impact of Load Ids is within the threshold limit
Drove smooth operations through resolution of queries for line of business and users
Functioned as Subject Matter Expert for Core Sustainability Flows
Steered production support activities including: Development of Production Support Turnover Document and Implementation & Release Plans, Resolution of data anomalies in production environment
Resolution of queries of Line of Business, Analytical Users, Source and Target Systems of CDM encompassing process flows, job scheduling details, data models descriptions on code values, so on
Conceptualised and designed effective scheduling strategy for Teradata Scripts in Autosys
Undertook validation of data in warehouse through repeated set of queries and ensure accurate loading of target tables including resolution of discrepancies through validations
Supported application development teams with impact analysis, code reviews, Autosys jill changes, data archival, manual loads and implementation runs
Created Teradata code to implement business requirements post signing of requirement traceability matrix
Pulled source data by using Multi-load, Tpump & Fast Load Scripts
Processed business logic using Bteq/Shell Scripts
Sent data to downstreams using FTP & NDM scripts
Prepare Test cases
Performed functional testing in Development region
Works closely with Business Analyst to resolve SIT issues

Analyses the Functional requirement document and drives the requirement gathering phase with business users to determine the business requirements and gets sign off
Used Model Mart features of Erwin for creating, managing and publishing Enterprise wide reusable data models
Created a data model for loan system in order to evaluate the consequence of loan defaulters and recoveries and also created S2T mapping documents
Developed a model to capture investment, trade, campaign events, fund transfer events etc.
Designed physical data model based on the approved Financial Services Logical Data Model
Collaborate with Data mining users to create reporting data structures
Interacted with the Source team so as to get the SOR data at the right time
Performed data gap analysis and driven the data requirements clarification with source systems
Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
Led & mentored team of 8 to 10 members
Conducted knowledge transfer sessions and delivered regular instructions