Gaurav Mathur

As a Data architect responsible for solutioning Data pipelines, Designing data models, Data analysis and Quality assurance.

As a Information architect responsible for end to end solution design for Semantic layer. includes preparing System use cases, Data modeling, Data profiling & Data quality. SaFE implementation.

As a senior Data modeler interacted with business users to add new data to existing data model based on each country local financial institutions requirements.

• Interacted with Data Stewards to gather data dictionaries for all source systems. • Designed, Developed and Maintained Data model for client and defined how the data would be stored, consumed and access aross different systems. • Performed Data Profiling and Defined DQ rules. Define Archival policy and maintain key definations. • Created Logical/Physical Data Model and DDL for Staging Layer, Intermediate staging layer, Atomic layer and Aggregate Layer. As a deliverable prepared docs like Mapping doc, Lineage Doc, Data Dictionary doc. • Defined downstream Data Access layer for Data mart. • For standardization and Reusability used glossary model (Abbreviation list) and enforced Naming Standards for LDM & PDM. • Enhance Performance by applying table partitions and basic Indexing on tables considering data volume, data growth and usage. • Analyzed reporting requirement and prepare Aggregate model accordingly. Ensure model suffice current reporting requirement and future needs. Helped reporting team to map reporting columns with Aggregate layer. • Conducted Model walkthrough sessions with Architecture team & Business. Managed multiple stakeholder in a project through effective Technical and communication skills. • Integrate 5 years of legacy data to data model. • Part of entire SDLC lifecycle from Requirement gathering to Deployment.

• Performed various roles in multiple development projects such as Team Lead / Teradata Consultant, Physical Data modeler and Application Architect. • Lead Team size ranging from 4 to 15 members. • Prepared various design documents like HLD, LLD, PDM, Data modelling enhancements and Architecture Diagram for new applications. • Design robust Teradata flow, bteq design, Table design as part of LLD. Prepare volumetric data for new applications and participate in capacity management calls. • Optimized various Teradata related transform and load process by analyzing overall flow of application and at micro level perform Query tuning by fixing queries taking max time/resources and at macro level by recommending change in ETL flow. • Designed and developed Event Data Store for each event data mart in EDW. Successfully splitting application into EDW and EDS. Application architect for BAGS [Business Aggregate] application. • Did impact analysis for migration of EDW from TD13 to TD14.10 and supported the production migration of Teradata. • Prepared Test strategy document, review test case doc, Coordinate UAT with clients, review CRQ process docs. • Manage development project by maintain development tracker, RAID sheets, Issue tracker and scoping sheets. • As a Team lead collaborate with Operations, Change Manangement & DBA team for deployment. Review Handover document to support team for development project. • Guide team members to use Teradata tools like TPT, Viewpoint, ColStats and Data mover. • As Technical consultant prepared assets like Query tuning tips, TPT generic script for loading data from One Teradata server to another, Query to create one to one view for all tables in a database. • Additionally as a stretch assignment worked closely with Teradata center of excellence team (COE) in IBM to conduct Method Adoption Workshop (MAW), Project review sessions,Teradata Coding standards, Teradata interviews and Teradata Training programs.

As a Sr. Teradata consultant my role was to: • Look for queries that are performing badly that can be tuned to take less resource. • Recommend Database Design changes that can significantly improve performance of workload. • Test and document the changes recommended. • Give presentation to clients about design changes. • Create deployment plans and scripts. • Requirement Analysis (BRD) • Scoping releases (WBS), Preparing Release plan (Deployment plans). • Preparing Functionality and Design specification document • Data modelling. • Prepare BTEQ code / MLOAD / FASTExpo script. • Load / Unload data, in application database from other databases, using TD utilities (Mload using AMJ) and Fast Export. • Created Macro / Store Procedures / Triggers for application. • Design and Development of various modules. • Design, develop applications in ASP.NET and provide support • Maintenance of development code with every change.

• Development of prototype for the application • Develop sub-modules like escalation, allocation, scheme management of Sales, Payment capturing sub-module of transaction and preparation of reports through crystal reports.. • Given demos of this software to Sahara’s sales and marketing head of SICC and his team and gave training to end users and managers on this software