Deepak Damodaran Email & Phone Number

Cumming, Ga, Us

Cumming, Ga, Us

Atlanta, Ga, Us

Teaneck, New Jersey, Us

Teaneck, New Jersey, Us

Extensive experience in Data Engineering field including data ingestion from On-Prem databases to Cloud data warehouses like Snowflake and GCP BigQuery.Solid experience and understanding of architecting, designing and operationalization of large scale data and analytics solutions on Snowflake Cloud Data WarehouseDeveloping ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQLProficient experience in splitting, validating and processing of files, automated data movements using Python scriptsHands-on experience in GCP BigQuery to build datasets, tables and complex SQL’s to load various ETL layers, loading data from Cloud Storage and working in Composer environment

Teaneck, New Jersey, Us

O2 DWBI Understanding the business requirements and acquire enough information to estimate user stories.•Intensive data analysis to proactively find out existing data behaviour in order to design and develop code efficiently and write unit tests when implementing user stories. •Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked•Impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existingData Warehouseapplications that run in a production environment.•Perform the design and extension of data marts, meta data, and data models•Fine-tune the existing scripts and process to achieveincreased performance and reduced load times for faster user query performance.•Writing complexTeradata SQL queriesto join or any modifications in the table and to implement the business logic.•Study the PL data model which includes documentation of allEntities, Attributes, Data Relationships, Primary and Foreign key Structures, Allowed Values, Business Rules and Glossary Terms.•Understand and modified the existing CLDM (Communications Logical Data Model) for various subject areas like Party/Customer, Subscriber and Account to design and develop Smartphone and WIFI application for strategic decision making and campaigning•Created the database design document for building the data mart that includes all the fact and dimension tables and the business rules to be transformed during the ETL process for these tables.•Prepare Process Flow Diagram and participating inbuild/reviewof theBTEQ Scripts, Review Unit Test Plans&System Test cases•Provide quick productionfixesand proactively involve in fixing production support issues.•Develop high performancepresentation layerfor reporting and analytics.

Teaneck, New Jersey, Us

Inmarsat Customer Conceptual Data Model•Identify the business units and respective stakeholders to conduct workshops for Discovery and Analysis phases to Study the Inmarsat Business Model and identify Customer centric areas for data modelling.•Understandthe existing business AS-IS and TO-BE process which will be a foundation for Customer data model. •Study and document the TMforum’s eTOM Level 3 business process for all domains to understand the customer touchpoints in Inmarsat’s business. •Prepare a Requirements Traceability Matrix (RTM) document which maps Inmarsat’s Customer focus areas with Industry Standard Business Process (eTOM) and relevant SID (Shared Information Data Model) entities which will enable to build a data model.•Build a Context data diagram for Inmarsat Customer Billing and Customer Support process and verify the accuracy with business users and enhance the Context diagram and use RTM as an input to create a Conceptual Model for Customer domain•Study the Inmarsat Component Business Model (CBM) and identify Customer centric areas for data modelingAnalyze existing billing data and customer hierarchies to come up with TO-BE process which can be fitted into model.•Involved with data profiling for multiple billing sources and answered complex business questions by providing data to business users and suggesting data quality rules to be implemented.•Study the SID framework related ABE’s (Aggregated Business Entities) for Customer and Party domain and map them to relevant entities and attributes•Prepare data dictionary to provide a textual description of data objects and their inter-relationships in a language that business can understand.•Create a Technical Landscape Analysis document which consists of underlying list of applications and technologies used, data categories like master/transactional, data volumetric and database objects

Teaneck, New Jersey, Us

O2 DWBI Understanding the business requirements and acquire enough information to estimate user stories.•Intensive data analysis to proactively find out existing data behaviour in order to design and develop code efficiently and write unit tests when implementing user stories. •Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked•Impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existingData Warehouseapplications that run in a production environment.•Perform the design and extension of data marts, meta data, and data models•Fine-tune the existing scripts and process to achieveincreased performance and reduced load times for faster user query performance.•Writing complexTeradata SQL queriesto join or any modifications in the table and to implement the business logic.•Study the PL data model which includes documentation of allEntities, Attributes, Data Relationships, Primary and Foreign key Structures, Allowed Values, Business Rules and Glossary Terms.•Understand and modified the existing CLDM (Communications Logical Data Model) for various subject areas like Party/Customer, Subscriber and Account to design and develop Smartphone and WIFI application for strategic decision making and campaigning•Created the database design document for building the data mart that includes all the fact and dimension tables and the business rules to be transformed during the ETL process for these tables.•Prepare Process Flow Diagram and participating inbuild/reviewof theBTEQ Scripts, Review Unit Test Plans&System Test cases•Provide quick productionfixesand proactively involve in fixing production support issues.•Develop high performancepresentation layerfor reporting and analytics.

Bangalore, Karnataka, In

AT&T Inc.: EMERGING BUSINESS MARKETS•Analyzing and profiling data present in oracle database and use InformaticaETL and Teradata tools and utilities to load data into Teradata database which acts as a reporting layer. •Designed the logical and physical data model using MS Visio based on the requirement, interacted with non-technical end users to understand the business logics. •Created/Enhanced Teradata Stored Procedures/ functions to provide output in the required format.•Daily Email notifications of Informaticaload jobs are created using shell scripts in Linux. •Coordinate with the front end team to provide with the necessary stored procedures and packages and the necessary insight into the data.•Perform Data verification by analyzing source and target reconciliation reports for any deviation and report the same. •Understand the business requirements and provide the reporting data according to fast changing needs.•Managed stakeholder expectations in terms of communication, progress reporting and facilitation in the delivery of software.

Bangalore, Karnataka, In

Telecom Domain –VERIZON: Enterprise Data WarehousingWorked closely with business clients on providing tactical solutions and designing logical data models accordingly and generate use case scenarios based on user requirements.•Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.•Handle requests for enhancements over the existing data-model to handle newer types of data and also provide data in the required format for downstream extracts.•Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.•Provided quick productionfixesand proactively involved in fixing production support issues. •Involved in writingcomplex SQL queriesand has worked on testing primary index and skew ratios before populating data into tables using sampling techniques and explain plan in Teradata