SUMMARY:

• Over 16 years of architecture, management, and development experience in banking & telecommunication industry, with exposure to Europe, Middle East and Asian Pacific markets,
• Big Data, Enterprise Data warehouse and Business Intelligence applications full life cycle experience with progressive levels of business discovery, analyzing, designing and implementation in financial and telecomm industry,
• Experienced with high - performance, distributed and massively scalable architectures,
• Experienced in Architectural Blueprint documentation and review process of various projects and provide feedback and improvements,
• Lead and participate in POC (proof-of-concept) for new technologies and tools to be utilized in the Big Data development team.
• Successfully implemented various data warehouses, business intelligence applications, Banking host systems and financial operational systems .
• Strong analytical and problem solving skills, experience in leading direct reports as well as cross functional teams to launch products end to end, collaborated with marketing to drive product usage through marketing campaigns
• Experience of Digital Channels data integration (ATM/CDM, SMS Alerts, Internet Banking, Mobile Banking, e-statement, Debit card, & Call Center) with EDW for establishing strategies to promote alternate channels.
• Experience of business unit management including P&L responsibilities, product performance and introducing new revenue generating products.
• Experienced with Vendor Management, Contract Negotiation and developing RFP/RFI/SLAs.

TECHNICAL SKILLS

Skills / Tools: Big Data

Cloudera, Hive, HDFS, Hue, Impala, HBase, Ranger, Storm, Splunk, NiFi, Solr, Ambari: Cloud AWS

Databases/Data warehouse: Confidential, SQL Server, ORACLE, HBase, Cassandra

Data Modeling Tools: Erwin, Power Designer

LDM: FSLDM, Comms LDM, Travel LDM, ARTS reference model (Retail)

Utilities: Confidential Analyst Pack, Confidential Load and Unload Utilities

Software development languages: T-SQL, SQL/PLSQL, ASP, VB, Unix C, Scala, Python

BI Tools: Cognos, MicroStrategy, SAS, TeraMiner, Informatica, Informant

Scheduling Tool: Control-M, Oozie

Data Profiling: Atacama

CRM Platform: Confidential -CRM, Microsoft CRM Dynamics

PROFESSIONAL EXPERIENCE:

Sr. Data Architect

Confidential

Environment: Cloudera, Podium, Postgres, Oozie, Scala, Presto, FS-LDM, Talend Metadata Manager, Power Designer 16, Oracle

• Gathered requirements to ingest raw data into Cloudera Hadoop eco-system as part of Confidential enterprise program to enable provisioning of data as a service, analytics, and global warehousing across all lines of business,
• Prepared system requirements specification, revised incoming data collection, data mapping/outgoing data collection.
• Collaborated with data scientists, solution designers, developers, enterprise architects, QA, BAs, DAs, PMs internally and across LoBs, including LoB business users at all levels
• Knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation on HIVE.
• Developed Conceptual, Logical, and Physical Data Architectures for Compliance project (FATCA*), this exercise includes FSLDM alignment with addition of more than 400 custom entities to support FATCA and CRS regulations. The conceptual and logical models were developed for business users and analyst understanding and alignment. (*FATCA - Foreign Account Tax Compliance Act in Canada.)
• Ran extensive data profiling exercise (using ATCAMA) for detailed data analyses, this exercise helped identify data gaps in the initial phases of the project,
• Work with development teams (onshore and offshore) to deliver transformation specifications and mapping documents,

Sr. Solution Architect

Confidential

Environment: Oracle, Confidential, SQL Server, Cognos, Microstrategy, Informatica, Control-M, Erwin, Hadoop-Horton&Works

• Being a part of the EBI (Enterprise Business Intelligence) Team for Confidential, one of the largest wireless provider in Canada, responsible for integration architecture and other aspects of the data warehouse strategic planning. Along with other architects on the team, provide architectural guidance as per Confidential BI standards.
• Responsible for defining the information architecture and technology infrastructure along with the design of multi-dimensional data models and the Business Intelligence delivery solutions
• Responsible for Business discovery exercise transform requirements into high level solution.
• Data profiling, data model changes and ensure LDM/PDM synchronization with new enhancements.
• Responsible for identifying all technological components involved and time & effort costing for budget approvals.
• Facilitated Project Management stream for identifying project scope, tasks & risks
• For approved projects developed Solution Design Document (high level), LDM/PDM, Database Design Specs, and functional ETL specification (Detailed level) as per Confidential BI Standards.
• Arranged walkthrough with involved stakeholders to ensure adherence to the established solution design specifications.
• Responsible for cost & effort estimations of new projects and enhancements at Confidential existing operational & analytical data warehouse

Senior Manager - Customer Intelligence

Confidential

Environment: Confidential, Cognos, SAS, SQL Server, (SSRS, SSIS, SSAS), Erwin, FSLDM, MS Excel, Power point

Executed successful data warehouse implementation with a team of 12 analysts. Data warehouse was the central data repository for various units including Risk, Finance, Consumer Business units & Sales.

• Designed and developed plans, strategies and standards for data for the enterprise data warehouse
• Use the Corporate Information Model to plan and develop the Logical Database Designs for many new systems.
• Customized FSLDM of all major subject areas related Banking Industry
• Integrate to consolidate enterprise data at EDW platform and enabled accessibility to all business units.
• Designed business intelligence layer with custom data model for predictive analysis.

Services render by the unit are as follows:

• CRM campaigns feed, tracking and gauge effectiveness
• Churn & basket affinity analysis
• Product penetration (financial & non-financial separately)
• Sales Performance Score Cards
• Dashboards for consumer business executive management
• Product bundling & pricing, customer attrition management.
• Telesales Outsourcing workshop & assessment at SCB (Singapore)

Manager

Barclays Bank PLC

Environment: Confidential, Cognos, SQL Server, MS Excel, Power point, ASP.net, SharePoint, Erwin, FSLDM, Unix

• In-house data warehouse deployment phases:
• Executed Business Discovery exercise with the management
• Build a Technical Roadmap
• LDM/PDM (FSLDM) customization
• Data Mart Consolidation
• Strategic concepts and high level design for an ETL Framework for consistent data movement throughout the organization and Global & Regional data feed.
• Data warehouse backup, restore and disaster recovery strategy
• Design a (denormalized) data model layer to effectively handle C-Level & senior management dashboards & ad-hoc reporting, this custom data model also hosted other subject areas like score cards, commission/incentive automation & performance dashboards
• Group & regional level financial reporting.

Worked on Barclay's various international assignments including Barclays Debit Card embossing outsourcing (Bahrain)Vision+ enhancement workshop (Singapore), Euronet assessment for ATM switch at Barclays

Manager - Business Analytics

Confidential

Environment: Confidential, SQL Server, Cognos, Oracle, MS Excel, Power point, ASP.net, Dundas, Unix, FSLDM, Erwin

• Data warehouse vendor selection, Data Integration tools, Database platform and Enterprise data model.
• Support the database architecture team to accomplish enterprise level objectives
• Designed a complete decision support system using Cognos.
• Maintained and prepared documentation of the data architectural process and progress e-channels integration with Confidential CRM end-to-end campaign management.
• RM workstation: Single view of customer portfolio for relationship managers of Asset & Wealth Managements, using Data warehouse
• ABN AMRO Credit risk models customization for local implementation (Hong Kong)
• Audit regional data warehouse ( Taiwan)

Business Intelligence Architect

Confidential

Environment: Confidential, Cognos, MS Excel, Power point, VB, Erwin, VISIO, VB, FSLDM, Erwin

• Enterprise data warehouse deployment (Retail Banking system, Credit Card, GL and Asset customer demographics)
• Developed strategies for the data acquisitions, data recovery, & enterprise level data consolidation
• Provide an in-depth expertise with data security, storage solutions, database virtualization and replication as well as other complex technical tools and solutions
• FSLDM customization
• Designed a complete Cognos based decision support system and A&B credit score cards
• Designed credit card data model as per CTL (Card tech limited) application requirements .

Professional Services Consultant

Confidential

Environment: Confidential, Cognos, Microstrategy, SAS, TeraMiner, MS Excel, Power point, ASP.net, VB, Erwin, VISIO, MS Project, Confidential Solution Methodologies (TSM), FSLM, DTS, Informatica.

• Deployed more than 8 data warehouses along with BI customized solution as Project Manager & Technical Lead role.
• Closely worked with existing and potential Confidential customers in identifying the business requirements and how Data Warehouse can help in meeting those requirements.
• LDM/PDM customization (Financial, Telecomms, Travel and Retail Industry)
• Prepared technical proposals
• Performed internal Audits for ongoing projects
• Conducted various Confidential products POCs including Gulf and European countries