Srinivasan Manoharan

About Srinivasan Manoharan

Principal Data Engineer/Snowflake Architect, Azure/AWS, BI/DW Architect, currently engaged with Data Analysis, BI Solutions, and Data Modeling. Having extensive knowledge and experience in Data Analysis, OLAP and OLTP system design and development, ETL Design & Development, Data warehouse project management, Client interfacing, and Technical issue resolution.• Proficient with database architecture tools and programs • Proficient with Azure (Relational and DW) and Azure Data Services (ADF, ADLS, DataBricks).• Created Pipelines in Azure Data Factory using Linked Services/Datasets/Pipeline to Extract, Load, and Transform data from different sources like Azure Data Lake, Blob storage, Azure SQL, Snowflake, Azure Data warehouse, write-back tool, and backward.• Responsible for designing and implementation of data warehouse in Snowflake.• Understand the value of architectural design and the standards of best practice.• Design and build data pipeline from DB2, SQL Server, Delimited data files processing to target HIVE warehouse. Analytics using Hive and Impala as a query engine• In-depth knowledge of database performance tuning, including complex query optimization.• Strong expertise in data analysis, migration, modeling, integration, and data warehousing concepts.• Ability to translate and present the ideas into design and implementation.• Work in a team environment and the potential of providing an individual effort.• Expertise in data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.• Possess knowledge of conceptual, logical, and physical Data Modeling using various tools.• Backed by strong technical skills, steered the team to successfully resolve technical challenges.• Having good exposure in Hadoop ecosystem components Hive, Scoop, and Impala.• Planned, directed, and managed data warehouse projects and OLTP systems.• Ability to resolve issues timely and effectively has helped me win appreciations from the client.• Perform detailed data analysis on the source and target system. Build a system for AML, Risk modeling, Anomaly detection, real-time analytics & dashboard.• Design, develop and lead a team for reports/dashboards using SSRS and PowerBI.

Experience

1. Principal Data Engineer

   Fidelity Investments

   Nov 2022 — Present · Durham, NC, US

Education

• Avichi Hr. Sec. School

  Secondary School Leaving Certificate (SSLC)

  1990 — 1991

• University of Madras

  Bachelor’s Degree, Business Administration

  1996 — 1999

• Thiru Seven Hills Polytechnic

  Diploma in Computer Technology, Computer Technology

  1993 — 1996

• Holy Angels Mat. Hr. Sec. School

  Higher Secondary Education, (Biology, Physics, Chemistry, Mathematics)

  1992 — 1993

• Annamalai University

  Master’s Degree, Software Engineering

  2008 — 2010