Data Architecture Principal

Ajoy Tiwari

***** ****** *******,*******, **,****5

****.***@*****.***

Phone : 510-***-****

LinkedIn Profile:https://www.linkedin.com/ajoy-tiwari-763ba1101

Professional Summary

Strategic thinker .Methodical,Analytical, results-driven Lead/Principal Data and Technology Leader with over 15 years of experience spearheading the design, development, and optimization, scalable Data architecture . Expert in building high performance teams . Driving innovation,delivering data solutions in accordance with objectives of organization . Adept in providing critical valuable insight for data driven decision-making.

Core Competencies

• Data Architecture & Engineering

• Cloud Platforms (AWS, GCP)

• Big Data (Spark, Kafka)

• ETL/ELT Design & Development

• Real-time Data Streaming with Apache Flink

• SQL,Python, PL/SQL,Shell Script

*. Oracle, Snowflake,Mysql

• Data Warehousing (Redshift,, BigQuery,Oracle)

• Data Governance & Security

* Abinitio,.informatica

• Leadership & Team Management

• Agile / DevOps Methodologies

• Stakeholder Engagement

* GitHub,Jenkins, UCD

Professional Experience

AVP / Technology Leader`

WellsFargo – San Leandro

Ja-2005 – Present

• Directed a team 7 -8 engineers and analysts; conducted code reviews, performance tuning, and mentoring sessions to improve te [#] am output and morale.

• Collaborated with business owners, analytic teams to provided the data fast and timely manner . It was achieved by creating and data model and query optimization team.

*. Worked closely with data analysts to model data for analytics and forecasting, improving reporting accuracy and speed 50%.

• Established data quality and governance standards, including lineage tracking and auditing using tools like Abinitio, Python and java

* Designed end-to-end ETL/ELT pipelines using python, Abinitio, Informatics, reduced load time from 3 hours to 45 minutes .

*. Designed a process and implemented to detect the false positives Isolation Forest Algorithms

* Designed data models to provide clean data for AI/ML training models .

• Improved pipeline reliability and reduced data delivery SLA breaches by implementing monitoring, alerting, and retry mechanisms.

• Contributed to a unified data warehouse consolidating siloed data and reducing report generation time by 70%.

• Developed scalable data pipelines in Python and SQL to support business intelligence and reporting initiatives.

•

•

Data Engineer / Team Lead

ABB – Santa Clara,CA

Jan -1999 – [Jan 2005

*. Architected the Database for fast insertion of Data every 2 minutes, 5 minutes and hour

*. Implemented the database to available 24 by & TAF failover in less than a 2 minute

*. Created a a insertion framework for loading 800GB of data to be inserted into 20K tables using Pro*C

* Also Architected Warehouse Database for analytics and Projection ( Predictive analysis

•. Performance tuning

Education

B.Tech in Computer Science & Egg, North Eastern Regional Institute of Science and Technology

Certifications

• Oracle Certified Professional

• Google Cloud Professional Data Engine

Technical Skills

Languages: Python, SQL Java, C, Shell Scripting

ETL Tools : Abintio, Informatics, Python

Deployment Tools : Github, Jenkins,UCD

Cloud Platforms: AWS (S3, Glue, Redshift, Lambda), GCP (BigQuery, Dataflow), Azure

Databases: Oracle, Mysql

Contact this candidate