ANTONY R JAYARAJ

Contact: 510-***-**** E-Mail: ad3uxe@r.postjobfree.com

Data Build, Integration & Analytics Engineer

Forward-thinking senior Engineer with years of multi-national and multi-cultural experience in directing the execution of exceptional business standards with expertise and certification in Data Integration, Data Builds, Data Analytics and Data Science Business Transformation Service Strategy & Direction Technology and Operations Customer Engagement Data Analytics and Data Science Team Leadership & Development SUMMARY:

Qualified and well-rounded Data Build, Analytics, Data Science, BI professional with Project Management and Leadership experience

Experience in managing multiple clients on engagement, data delivery and independent infrastructure setup

Leading and managing different Data build, Data Analytics and Data Science teams on Consumer, eMail and Auto products

Working closely with product managers to help shape data build and data science products

Understood business use cases and requirements from Clients and converted them into well-articulated problem statement documenting the same for Project development needs

Responsible for Budget planning, Schedule planning and Resource profiling for all project phases

Experience in Data Analytics and Data Modelling in Python 3.8.5, SQL SERVER 2008/2012/2014/2016

Data Engineering and Modelling using Anaconda Jupyter Notebook 6.1.4, Google Colab, Python 3.8.5 for Machine Learning platform

Certified Artificial Intelligence and Machine learning professional with experience in developing various algorithms and predictive models based through Classification, Regression, Clustering, Decision Tree, K-Means, Artificial Neural Network and Natural Language Processing

Working on migration of data products to Snowflake for data integration, analytics and sharing

Extensive experience in Extraction, Transformation and Loading of data using SSIS 2008/2016 R2/ SQL Server 2008/2012/2014/2016, Datastage 8.7/9.1 Parallel/Server Jobs and in Informatica 8.1/9.6.1

Extensively worked on DataStage Designer, Manager and Director

Working on SSIS 2008/2016 R2/ SQL Server 2012/2014/2016 Packages for Data Integration

Development and scheduling SSIS packages as SQL server agent jobs with performance tuning and monitoring

Experience in database development skills using Oracle SQL, DB2 to write SQL queries, functions.

Designed jobs with various stages like Oracle Connector, DB2 connector, Aggregator, Transformer, Joiner, Lookup, Remove Duplicates, Change Capture, Funnel and Filter in Datastage.

Designed various jobs with stages like Complex Flat File, Sequential File, and Datasets. Involved in design and development of various transformation logics by using expression, filter, joiner, lookup, rank, and router using Informatica.

Developed system documents like Functional Specifications, Technical Specifications, and User Manuals etc.

Self-motivated, highly committed to responsibilities. Excellent communication skills and ability to mentor team members and can perform well within cross-functional teams.

TECHNICAL SKILLS:

Integration/Analytics Tools: Pandas, NumPy, Scikit-learn, Keras SQL Server 2008/2012/2014/2016 R2, Datastage 8.7/9.1 and Informatica 8.1, 9.6.1

Reporting Tools: Matplotlib, Seaborn, Cognos 8.1, MSTR 9.01(Admin), SSRS Databases: Oracle 9i/10g, DB2, SQL server 2008/2012/2014/2016 Languages/Framework: C, C++, C#, Java, Python, CSS, Java Script, JSP, Servlets, JDBC, Struts, Hibernate, EJB, SQL, UNIX Shell Scripting, HTML.

Operating systems: Windows 98/XP, NT, 2012/2016 R2, Linux Tools /DB/Packages: RADAR, Eclipse, VSS, SVN, TFS, Apache Tomcat, Visual Studio, Anaconda Jupyter Notebook, Google Colab., Notepad++, EditPlus, Microsoft Excel, SQL*Plus, TOAD, MS Visio, Putty P R O F E S S I O N A L B A C K G R O U N D

Data Engineering Manager (Data Products) Visionblox Jan 2024 - Ongoing Started building teams in Technology for Products. Designing and developing new products. Model building in Data Analytics and Machine Learning. Leading deployment team in product deployment in different platforms. DEFINING ATTRIBUTES: Enterprise Architecture Deployment Leadership Build Leadership Automation Design and Implementation

Working closely with Sales managers to engage new clients at the national level

Involving in Client consultation to understand objectives and provided strategic recommendations

Established, managed, retained and grown a diverse set of accounts through pro-active engagement strategies

Designed different Data Models for product databases

Built Data Retrieval Management from various sources and prepare data for analysis

Building Data Analytics and Machine Learning Platforms for model building

Perform Data Analytics with EDA, Data visualization on Skewness and treated outliers using Matplotlib and Seaborn

Regression, Classification, Clustering, Dimensionality model building using Machine learning algorithms on 3rd party data for targeted campaigns and clustering Consumer data

Model building using Python on Anaconda Jupyter web-based, interactive environment with NumPy, Pandas, Scikit-learn, Tensorflow/Keras and pipelines

Built Natural Language Processing model for trend analysis on consumer data using live feeds

Enhancing models using Online and Mobile signals streaming data

Working on migration of data products to Snowflake for multi-cluster warehouse

Knowledge of Snowflake Database, Schema and table structure

Developing multiple SQL Server Integration packages (SSIS) and Jobs for Data Extraction, Integration and Loading (ETL)

Developed C# classes using Visual studio and stored procedures in SQL Server for data processing

Worked with Excel, CSV, Text, XML, JSON files for both source and target datasets

Built multiple DataMarts in SQL Server specific to data products with Star and Snowflake schemas

Improved build with performance tuning on Queries, normalization, and DataMart build

Combine data files for use in suppression or enrichment (combining of different output formats to aid in targeting)

Designed, Developed, and Implemented build Automation

Quality Assurance - Verify accuracy of data pulled and revise methods of data retrieval by following a standard process

Review quality and data integrity, and send them to internal clients or external agencies Technical Manager (Data Products) Porch Group Media Jan 2016 – Jan 2024 Lead different build teams in Technology for Products. Designed and developed new products. Model building in Data Analytics and Machine Learning. Lead deployment team in product deployment in different platforms. Engaging with Sales and Clients on operations. DEFINING ATTRIBUTES: Enterprise Architecture Operational Leadership Deployment Leadership Build Leadership Sales guidance Automation Design and Implementation

Planned and implemented Enterprise Architecture with chronic builds on different products

Lead and managed different verticals on Data build, Data Analytics and Data Science teams on Consumer, eMail and Auto products

Managed several Clients on data delivery based on the Products built

Worked closely with Sales managers to engage new clients at the national level

Involved in Client consultation to understand objectives and provided strategic recommendations

Established, managed, retained and grown a diverse set of accounts through pro-active engagement strategies

Designed different Data Models for product databases

Built Data Retrieval Management from various sources and prepare data for analysis

Built Data Analytics and Machine Learning Platforms for model building

Performed Data Analytics with EDA, Data visualization on Skewness and treated outliers using Matplotlib and Seaborn

Regression, Classification, Clustering, Dimensionality model building using Machine learning algorithms on 3rd party data for targeted campaigns and clustering Consumer data

Model building using Python on Anaconda Jupyter web-based, interactive environment with NumPy, Pandas, Scikit-learn, Tensorflow/Keras and pipelines

Built Natural Language Processing model for trend analysis on consumer data using live feeds

Enhanced models using Online and Mobile signals streaming data

Worked on migration of data products to Snowflake for multi-cluster warehouse

Knowledge of Snowflake Database, Schema and table structure

Compile and prepare reports on data build for reporting (SSRS) dashboard

Developed multiple SQL Server Integration packages (SSIS) and Jobs for Data Extraction, Integration and Loading (ETL)

Developed C# classes using Visual studio and stored procedures in SQL Server for data processing

Worked with Excel, CSV, Text, XML, JSON files for both source and target datasets

Built multiple DataMarts in SQL Server specific to data products with Star and Snowflake schemas

Improved build with performance tuning on Queries, normalization, and DataMart build

Combine data files for use in suppression or enrichment (combining of different output formats to aid in targeting)

Designed, Developed, and Implemented build Automation

Quality Assurance - Verify accuracy of data pulled and revise methods of data retrieval by following a standard process

Review quality and data integrity, and send them to internal clients or external agencies

Performed internal audits: Gather data from various sources/applications and databases to validate audit steps; evaluate quality assurance

Involved in Data delivery operations in different Platforms for customers ACHIEVEMENTS

Successfully implemented Enterprise Architecture for all 3rd party data

Implemented Data Analytics platform on EDA

Successfully designed and built DataMarts for Platforms

Implemented automated data deployment across platforms

Worked directly with Sales, Account Managers and Clients for change requests on Data Products

Built Data Science Team to upskill Artificial Intelligence and Machine Learning techniques in Enterprise Architecture

Leadership award for retaining and growing Clients Technical Lead (Data Integration and Build) L&T Infotech Jan 2012 – Jan 2016 Leading different Integration and Build teams in Technology for Products. Worked with Home Depot and Bright Star teams to implement Enterprise Architecture in their respective environments. Worked on Sales dashboard on daily and weekly jobs DEFINING ATTRIBUTES: Enterprise Architecture Database Design Deployment Leadership Build Leadership Dashboard Leadership Scheduling Interface Risk Analysis

Enterprise Architecture implementation with different feeds from departments

Worked on all business requests and issues to ensure client programs were operating with maximum efficiency and profitability

Worked closely with various levels of management, both internally and externally, providing effective communications with senior leadership

Defined mapping rules (source to target) using technical document (TDS) and business requirement document (BRD)

Worked with Excel, CSV, Text, XML, JSON files for both source and target datasets

Built DataMarts in SQL Server with Star and Snowflake schemas

Designed Datastage server and parallel Jobs

Designed and developed jobs in UC4 for scheduling interfaces.

Monitored jobs in UC4 (production/QA/Dev)

Review of Test Cases (Unit Test/Interface Test/Functional test)

Lead and guided team to develop jobs with various stages like Oracle Connector, DB2 connector, Aggregator, Transformer, Joiner, Remove Duplicates, Change Capture, Funnel, Filter, etc. for ETL process

Mentored team to develop, test and deploy the code in production environment

Involved in Risk analysis and effort estimation

Ensured quality deliverables and responsible for Internal Audits. ACHIEVEMENTS

Enterprise Architecture implementation based on feeds

Successfully designed and built DataMarts for quick counts and retrieval

Implemented automated jobs in scheduler

Managed Onsite-Offshore model

SPOT Award for Leadership

MANAGEMENT Award for resource management

Data Specialist IBM India Pvt. Ltd Sep 2010 - Dec 2011 Senior member in Data Integration team worked on Global Replenishment system for Walmart. Designed, Developed, and Implemented SQL and windows jobs. Scheduled jobs for Automation. Onsite-Offshore Project Management DEFINING ATTRIBUTES: Project Management Database Design Deployment Leadership Report Analysis Scheduling Interface Document Management

Responsible in designing and documenting based on requirement

Defined mapping rules for Data transformation using Technical Design Spec. (TDS)

Responsible for extracting the data from flat files using DataStage.

Involved in designed Datastage parallel Jobs which involves various stages.

Designed jobs with various stages like Oracle Connector, DB2 connector, Aggregator, Transformer, Joiner, Remove Duplicates, Change Capture, Funnel, Filter, etc. for ETL Process

Designed various jobs with stages like Complex Flat File, Sequential File, and Datasets.

Designed sequences with stages like Job Activity, Sequencer, Nested Condition, etc.

Have created Projects and managed groups as Administrator

Involved in creating scripts in UNIX for FTP jobs.

Involved in executing the interface from UNIX end.

Prepared Test Cases and executed the same.

Used RADAR for project management

S C H O L A S T I C S & C E R T I F I C A T I O N S

Master of Science (Computer Science), University of Tulsa, OK

Bachelor of Engineering (Computer Science), Bharathidasan University, TN, India Certification:

PGP – Artificial Intelligence & Machine Learning, University of Texas, Austin, TX

GNIIT certified from NIIT, Chennai, India

Contact this candidate