Amelraj DAVID
Seattle,WA
Summary
Accomplished Data Modeler/Data Architect with deep expertise in designing conceptual, logical, and physical data models for transactional systems, data warehouses, data lakes, and advanced analytics platforms. Adept at translating complex business requirements into scalable, high‑quality relational, dimensional, and NoSQL data structures. Strong collaborator skilled in facilitating workshops, aligning cross‑functional teams, and defining enterprise data standards and governance practices. Experienced in building metadata repositories, data dictionaries, and lineage documentation to strengthen transparency and control. Proficient in ERwin, PowerDesigner, ER/Studio, and cloud‑native modeling across GCP, AWS, and Azure. Committed to continuous improvement, performance optimization, and delivering robust data architectures that support reliable, end‑to‑end data pipeline
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Architect
HCL America
12.2021 - Current
- Design and implement data workflows that connect revenue lifecycle systems with Pros SPOM pricing models.Analyze Cart, Quote, Invoice, and Line Item structures to build accurate data mappings into SPOM‑compatible formats.
Develop and maintain ETL/ELT pipelines and custom APIs to support scalable, secure data integration.
Transform cart‑level transactional data into invoice datasets for analytics, reporting, and ML model training.
Validate data quality, completeness, and integrity across multiple upstream and downstream systems.
Enable pricing optimization by preparing high‑quality datasets for machine learning and recommendation models.
Collaborate with engineering, pricing, and analytics teams to troubleshoot issues and refine data workflows
Lead Data Modeler
Wipro
07.2017 - 07.2021
- Led requirement‑gathering sessions, analyzed FRDs, and secured business sign‑off for data‑modeling initiatives.
• Built and published enterprise‑wide reusable data models using Erwin Model Mart and ER Studio.
• Designed logical and physical data models for loan, investment, trade, campaign, and fund‑transfer systems, including S2T mappings.
• Collaborated with source teams to obtain SOR data, performed data‑gap analysis, and applied data‑cleansing techniques for consistency.
• Reverse‑engineered databases and BI objects to identify KPIs, facts, and dimensions for reporting solutions.
• Developed transaction and hierarchy tables supporting GMIS stores and Central Europe supply‑chain reporting.
• Created semantic‑layer views and database entities for MicroStrategy and Business Objects analytical reporting.
• Mentored and guided a team of 8–10 members through modeling, coding, configuration, and testing activities.
• Managed model updates, change requests, and production deployments including FSLDM table creation.
• Monitored Teradata performance metrics, optimized non‑compliant queries, and ensured efficient resource usage.
• Led production‑support activities, resolving data anomalies and preparing turnover, release, and implementation plans.
• Supported development teams with impact analysis, code reviews, Autosys scheduling, data archival, and SIT issue resolution.
Education
Masters in Engineering - Power Electronics
Anna University
Chennai , TN05-2009
Bachelors Degree in Engineering - Electrical And Electronics Engineering
Bachelors in Engineering
Anna University , Chennai04-2005
Skills
- Snowflake, Teradata 14, Google Big Query, Oracle, MongoDB (NoSQL), Azure SQL, GCP
Dimensional & Canonical Modeling, Domain Driven Design (DDD), Semantic Layer/Ontology, EDW Architecture
Erwin r97, SAP Power Designer, Oracle Data Modeler, ER Studio
Teradata CLDM (R15), Teradata FSLDM (R9)
SQL (Advanced), Informatica, Ab Initio, DataStage, dbt
Apache Airflow, Prefect, Autosys
Power BI, Tableau
LinuxPython (basic), Shell Scripting, Git based CI/CD
Accomplishments
- Key contributor in building the FK People Analytics system from the ground up; recognized with the Pat on the Back award.
- Redesigned a major enterprise data store into FSLDM structures for the world’s largest banking client.
- Played a pivotal role in securing Level 2 Support transition from a competitor in 2013.
- Delivered DWH and SQL training to a 20‑member project team, strengthening overall competency.
- Honored with the Infosys Insta Award (2012) and Infosys Award for Excellence (2013).
- Revamped Stores and Supply Chain data models, introducing materialized views and optimizing queries to achieve ~5× performance improvement.
- Active member of the Data Modeling & Legacy Practice since 2017, contributing to enterprise standards and best practices.
- Reduced Teradata CPU usage by 0.35 and saved 500 GB permanent space for a large retail data warehouse through targeted optimization.
Certification
- Google Cloud Certified
- Senior Big Data Engineer
Timeline
Data Architect
HCL America
12.2021 - Current
Lead Data Modeler
Wipro
07.2017 - 07.2021
Masters in Engineering - Power Electronics
Anna University
Bachelors Degree in Engineering - Electrical And Electronics Engineering
Bachelors in Engineering