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

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

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

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

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