Detail-oriented and results-driven IT professional with over 17 years of extensive experience in strategizing, designing, and delivering Enterprise Data Warehouses, Business Intelligence, and Analytics systems within the Financial Industry. Recognized for strong expertise in Big Data enablement, encompassing Data Architecture, Data Sourcing, Data Cataloging, Data Curation, Data Preparation, Data Blending, Data Provisioning, Data Analysis, and Consumption. Proficient in planning, developing, and executing strategies that have launched new products, opened lucrative channels, and significantly grown revenues.
Accomplishments:
AML Scenario Optimization: Collaborated with subject matter experts to analyze Anti-Money Laundering (AML) scenarios, identify issues, and design solutions, optimizing alert generation for regulatory reporting.
Spark-based Configurable Data Services: Designed Spark-based configurable data services for the Enterprise Data Platform (EDP), covering various aspects such as ingestion, control validation, data quality assurance, standardization, surrogate key management, and more, enhancing operational control and data provisioning.
Inline Data Quality Engine: Developed and deployed an inline Data Quality Engine for a major financial institution, facilitating Regulatory Audits by conducting daily scans of billions of records, streamlining compliance processes, and enhancing regulatory adherence.
Cloud-Native Architectures: Designed and implemented cloud-native architectures to meet business requirements with minimal risk, incorporating robust security models, data anonymization strategies, and multi-tenant support.
Real-time Messaging Architecture: Designed a real-time messaging architecture for operational auditing, integrating mainframe-originated messages with AWS DMS and processing them through Spark Streaming for seamless data processing.
Core Competencies:
Data Architecture
Design Patterns & Solutions
Data Modeling
ETL/ELT
Big Data Technologies
Cloud Computing
Metadata Management
Technical Skill Set:
Functional Modules: Finance (Banking), Data Warehousing, Data Modeling & Business Intelligence.
RDBMS: Snowflake, Teradata, Azure Synapse, MySQL, RedShift.
Cloud: AWS, Azure.
Big Data: Databricks, Apache Spark, Spark SQL, Impala, Hadoop, Apache Hive.
Programming: UNIX/Linux Shell Scripting, Python, Scala, Java.
Operating Systems: Windows NT/2000 Server, HP-UX 11.1, IBM-AIX.
ETL: Ab Initio GDE, Informatica.
Scheduling Tools: Control-M, TWS.
Key Responsibilities:
Facilitated the development of source-to-target mapping documents.
Conducted defect analysis and devised effective solutions.
Undertook thorough data profiling and devised comprehensive approaches.
Led defect analysis and triage efforts to identify root causes.
Acted as a liaison between development teams, SMEs, and business users.
Evaluated the existing Technology Landscape and developed migration strategies.
Assessed project requirements, established KPIs, and mitigated risks.
Developed solutions incorporating machine learning models.
Designed and managed data pipeline architecture.
Orchestrated intricate enterprise data processing workflows.