Lead Data And Solution Architect Resume
SUMMARY:
- A pragmatic result driven professional with over 20 years of global experience working with leading global financial services and software services organisations
- Experience in working with senior management including CIO’s, CDO’s, Directors across diverse key IT and Data Management initiatives
- Created and implemented value creation strategies in large greenfield, transformation and regulatory programmes and was successful in building methodologies and frameworks thereby providing value adds in - terms of cost reductions, delivery optimisation and operational efficiencies
- Extensive hands-on experience in leading architecture, design, development, implementation, maintenance, support, governance and migration of large-scale mission critical applications and platforms in an enterprise performing various roles - Enterprise Architect, Solution Architect, Technical Lead / Architect, Lead Data Architect, Delivery Lead, Lead Integration Architect, Design Authority, Application Developer
- Successfully established and chaired application and data Design Authority governance processes at project, programme and enterprise levels to establish design and development of information systems best practices and assess against them to minimise technical debt, optimise / rationalize processes and achieve business goals
- Proven experience in development of data strategy, data standards, data architecture roadmaps in adherence to data strategy and data policies, data quality measures and remediation and data classification taxonomy (data families, data domains, sub-domains)
- In-depth experience in development of data models, data warehouse, data integration, data virtualisation, data migration, master/ data management, meta-data management, data lineage, data discovery, data profiling and data analytics
- Successful background working with stakeholders to develop Technology Strategy Planning and Roadmap, Architecture framework that aligns strategy, processes, and IT assets with business goals
- Experience of working in collaboration with project managers, architects, developers and working groups to avoid redundancy, minimize expenditures, and improve overall synergy within organization
- In-depth experience establishing best practices and guidelines for selecting, developing, and implementing information systems within enterprise
- Successfully architected and designed wide spectrum of applications and solutions with varied complexities considering Business architecture, Application architecture, Data architecture, Technology architecture, business drivers and business requirements
- Leadership experience in current state assessment, defining target state, building road map with multiple viewpoints and managing architectural roadmaps across architectural teams in the global environment
- Proficient in multiple industry standards & frameworks TOGAF, Archimate and Zachman
- Good understanding of big data technologies, Data Lakes, Data Fabric, Model Ready Datasets, Hadoop Ecosystem (HDFS, MapReduce, Spark, Hbase, MongoDB, Cassandra, PIG, Hive, Kafka, Flume, Sqoop etc.), cloud implementations
- Experience in providing technical oversight, consultancy,, mentoring development & testing teams across geographical locations in an onsite / offshore / outsourcing model
- Adept at working at Senior level and influencing key decision makers
- Extremely capable as an individual contributor and as a team leader with a background in managing diverse multi-location teams whilst carrying a pragmatic “can do” and lead by example attitude
- Enterprise Technical and Data Architecture
- Enterprise Application Integration (EAI)
- Technical Assurance & Governance
- Strategy & Planning
- Development and production support
- Design Authority - Chair & Assessor
- Consolidation & Rationalisation
- Fortress Architecture Framework
- Zachman
- TOGAF
- People Management (individual, team & dept)
- Business Case Development
- IT Project Management & Programme Governance
- Mentorship & Personal development
- Influencing & Negotiation skills
- Audit, Regulatory & Compliance
TECHNICAL SKILLS:
Technology and Tools: Data Flows UML & Data Modelling Logical & Physical Meta Data Management (Semantic & Data Lineage) Data Warehouse Enterprise Service Bus (ESB) Messaging / Brokering Design Patterns Software & Systems development life cycle Messaging Standards - SWIFT, ISO20022 & FpML Agile/Large Scale Agile Systems Development Agile database refactoring Test Driven Development Specification By Example Metastorm ProVision, MagicDraw, XMLSpy, Enterprise Architect, ERWin, ER Studio Data Architect, Power Designer, IBM Data Architect Informatica Meta Data Manager, Collibra, Ab Initio Mule ESB IBM Websphere MQ, IBM Websphere Message Broker Java, C++, C, PL/SQL, XML, XSD, XSLT, IBM WAS, Apache Tomcat, Spring, Hibernate, JUnit Oracle, Sybase, MS Sql Server, Marklogic Unix, Linux, Windows Eclipse, Fitness, Clearcase, Subversion, Perforce, GitHub
PROFESSIONAL EXPERIENCE:
Lead Data and Solution Architect
Confidential
Responsibilities:
- Setup working groups for all BUK data domains within respective data families to capture business metadata for critical data elements and onboard onto bank-wide business metadata governance tool Collibra for data domain activation
- Seeking approval and sign-off from respective data domain owners for domain activation and presenting domain activation papers at various data management councils(DMC) for approvals
- Collaboration within various Confidential teams and vendors to setup a Data Quality team to drive end to end DQ implementation
- Leading Data Quality team to document DQ business and functional requirements and map technical metadata with close coordination with SME’s, business and technical architects
- Close coordination with data and technical architects of BUK platforms to map data controls and identify any gaps in the end to end data flow on the legacy platforms and strategic Hadoop platform
- Leading Solution design to implement data lineage using Ab Initio and integrating with data management tools
- Active contribution into Group DQ forums to drive DQ metrics standardisation and reporting at various DMC’s
- Reviewer and key voice of BUK transactional data domains on the Consumer Customer logical data model governance forum
- Assess as-is data platform, define future state data platform and perform gap analysis to drive future state data platform (including physical implementation) applying data lake and modern data architecture principles
- Design and architect data consumption layers for multiple use cases including analytical data models, data exploration, visualization, reporting and data science workbench
- Ensure an integrated definition of data for enterprise information; Develop design and best practices to ensure the accuracy, validity, and reusability of data
- Provide strategic input & frameworks on long term requirements related to data architecture, data integration and data security as needed
- Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise
- Communicate, present, articulate complex technical architecture solutions to developers, architects and business stakeholders
- Ensure all solutions adhere to established data/information standards and strategies
- Leading solution architecture, design and data model to build Consumer Credit Risk, finance and treasury data warehouse and reporting on Hadoop data fabric to meet BCBS239 commitment
Data Consultant
Confidential
Responsibilities:
- Created efficient best practice and framework to capture front to back data flows using IBM Data Architect tool thereby building meta-data repository of all point-to-point connections and data flows in a single repository that is governed, versioned and managed
- Successfully created strategic consumer ready data models using meta-data repository and enabler to drive rationalization, optimization, efficiencies and economies of scale and significantly improve operational risk
- Successfully established data design authority governance process and executed as a chair and assessor for all traded risk programmes / projects across the GBM
- Working in collaboration with GBM enterprise technical architects, business architects and SMEs to align data models and data exchange formats XML, JSON etc… and data protocols
- Design authority and reviewer of data architecture including data models of data providers and data consumers for alignment and rationalisation and a key contributor into the group GBM governance forum
- Involved in Software selection and vendor evaluation for ETL & Data Virtualisation tools to implement consumer ready data models that could efficiently work with big data Hadoop platform and existing legacy systems
- Instrumental in choosing and onboarding data management practice onto IBM IDA for GBM
Data Architect Lead
Confidential
Responsibilities:
- Involved in defining Risk data aggregation & reporting data and IT strategy in line with banks data and IT strategy along with syndication with business clusters for sign-offs
- Established integrated business & IT Design Authority function across the bank to measure the compliance of various data projects in adherence to BCBS239 principles and chair of DA in capacity of assessor
- Domain analysis to determine and catalogue authoritative and/or golden data sources for Risk aggregation & reporting for all principle risk types
- Led Credit Risk reporting data warehouse solution architecture and design(data flows, data modelling - logical and physical) along with establishment of a new project team to deliver this initiative
- Successfully led fit-for-purpose evaluation of ZDLC - a code harvesting tool and it’s procurement for development of data lineage capability
- Solution design of E2E integrated architecture & design of semantic & data lineage capability across the bank for risk aggregation & reporting using Collibra, ZDLC & Ab Initio
- Involved in Data Governance tool (Collibra) selection and procurement process
- Involved in establishment of data management capability across Risk, Finance & Treasury to consolidate and govern risk aggregation & reporting Business Glossary, Data dictionaries, Business Processes, Data Taxonomies and Data Models
- Analysed credit risk reports data attributes and mapped to the business data classes
- Organised and led several information architecture related workshops latest being including “Banking Book Synergies” across Risk, Finance & Treasury to establish a common data platform that would drive data standardisation, consistency, integrity, quality, efficiency and productivity
- Defining data architecture principles in adherence to BSBC239 and group data policy and syndication with all business clusters for sign-offs
- Analysed IFRS9 data dictionary and defined logical data model for impairments data store for model outputs, expected loss calculation, stage allocation and reporting capability
- Analysis and design of E2E data flows for IFRS9 Classification & Measurement, impairments calculations, Hedge Accounting and reporting group risk and finance areas
- Impact analysis of Risk & Finance logical data models and recommending changes to the physical data models
- Design of schema-on-read & schema-on-write information models to enable big data implementation
- Defined design authority framework to assess data and systems designs of group functions and business clusters
Data Architect Lead
Confidential
Responsibilities:
- Solution architecture roadmaps for cash processing and reporting - regulatory, operations & MIS
- Prioritisation & planning of application delivery components inline with the architecture roadmap and strategic vision
- Successful adoption, governance and implementation of ISO 20022 message components to drive creation of Securities processing information model standardising information exchange / data flows between business applications
- Standardising information exchange messaging platform using ESB and driving use of EAI patterns to solve integration issues
- Information modelling & governance (concept, business, logical & physical) of account and party data for custody & securities business
- Conducting reviews - Business Requirement Documents, System Design Documents by means of permit to build governance process
- Standardised message sequence solution across programme enabling consistency to address out-of-sequence message processing
- On boarding system interfaces on to standardised tool - MDR, to provide data & interfaces lineage
- Creation of standards, best practices & involved in evolution of key architecture principles across the programme
- Guiding application delivery teams in designs driving standards & best practices for consistency
- Managing non-confirmative designs via exception process and collaborating with teams to articulate remediation plans following standards & best practices
- Member and contributor of IBML (derived from FpML) information modelling team to drive adoption
Technical Lead / Architect
Confidential
Responsibilities:
- Design authority for CMPP and responsible for data architecture - governance, modelling, migration, archiving and performance improvements of CMPP
- Created a CMPP cash event generic message model working in collaboration with IBTCP information architect and CMPP business analysts
- Designed and developed statements data repository and its adapter process using Java, Message Adapter Framework, spring, hibernate
- Designed and developed highly efficient and scalable data migration utility to migrate 1.2 million cash events data from CER to CMPP near real-time
- Proof of Concept of core building blocks, Operational Data Store(ODS) and ODS API evaluating fit for purpose more focused on performance and scalability
- Instrumental in on-boarding of EMEA, NA & ASIA secondary nostro cash management on to CMPP by addressing key performance issues
- Conducted design, code & test script reviews
- Mentoring & of vendor and new JPMC Bournemouth & ITC Mumbai staff including knowledge transfer session to senior technical architects
- Involved in hiring process for ramping up Bournemouth and ITC Mumbai development teams
- Created Oracle developers best practices guide
Technical Architect
Confidential
Responsibilities:
- Presales of implementing and integrating applications using Salesforce platform
- TLM implementation and integration consultancy focusing mainly on middleware integration, maximising TLM usage, data cleansing and performance optimization
- Proof of Concept to integrate in-house built software applications with Salesforce.com platform using reverse proxy pattern to safe-guard firms confidential private information
Technical Lead / Architect
Confidential
Responsibilities:
- creating application development architecture roadmaps inline with business process translating business requirements into technical requirements/specifications and creating design documents leading the team of developers / testers, setting-up development standards, evangelising best practices, leading design / code reviews, automating development workflow process, resource forecasting verseeing source code configuration management, build and release process into production along with L3 support initiatives to reduce development / application set baseline costs, interaction with business and/or operation colleagues, involvement in strategic initiatives, building charge-back costing model of application to the respective businesses liaison with other technology & architecture groups within bank to share, learn & implement corporate-wide technology initiatives strategy for rationalization, consolidation, upgrade and migration of hardware and software products on a timely basis instrumental in RFI & RFP process for strategic Cash Management vendor product evaluation, creating proposal documents, templates requesting information, analysing received proposals from vendors and evaluating proposals using functional point analysis driving PoC’s of new technologies such as MAF (Mule ESB), tiger reports & EXT JS to evaluate fit for purpose strategically instrumental in driving test automation strategic agenda of core processing from cash management working closely with business analysts, vendor resources and test centre
- As a interest, a) provided solution architecture and best practices consultancy to bullion markets applications benefiting them to achieve cost-effective and resilient global processing platform b) articulating idea’s into business case and presenting them to senior managers seeking approvals
Technologies: Sun Solaris UNIX, Java/J2EE, JDBC, JUnit, Oracle9i/10g, MS SQL Server2000, PL/SQL, Stored Procedures, Websphere Application Server, Apache, Tomcat, Websphere MQ/WBIMB, XML, XSD, XSLT, EJB, Servlets, JSP, DataAccessBeans, HTML, Clearcase, Autosys
Systems Analyst
Confidential
Responsibilities:
- Re-engineering design using RAD methodology, CA-OpenRoad code walk through, CA-OpenRoad code re-engineering / migration to Visual Basic6.0
- Enhancements to existing database schema of Oracle and MS SQL Server, tools and utilities written in VB and VC++
- Creating COM objects, coding embedded SQL, troubleshooting, maintenance and defect fixing of server-side 'C', VB and CA-OpenRoad code, analysis and optimisation of SQL queries
Analyst Developer
Confidential
Responsibilities:
- Client Interaction, requirement gathering, analyse, comprehend and translating business requirements into technical specifications, design, produce VB Code, testing
- Database design (logical and physical), database creation on Lydian, ER/Data flow diagrams, SQL optimisation
- GUI designing, coding, testing, support, packaging, distribution, documentation, demonstrations and presentations
Systems Developer Consultant
Confidential
Responsibilities:
- Client Interaction, requirement gathering, analyse, comprehend and translating business requirements into technical specifications, design, produce VB Code, testing
- Database design (logical and physical), database creation on Oracle8i lite, ER/Data flow diagrams, SQL optimisation
- GUI designing, coding, testing and support
- Packaging, distribution, documentation, demonstrations and presentations
Navision Consultant
Confidential
Responsibilities:
- Product development and enhancement using C++
- Code reviews and walkthroughs
- Updating design UML design documents
- Creating and enhancing COM objects, coding embedded SQL
- Troubleshooting, maintenance and defect fixing of server-side 'C', & C++ code, analysis and optimisation of SQL queries
Systems Executive
Confidential
Responsibilities:
- Product development and enhancement using C++
- Design objects using OOAD and creating / updating design documents
- Designed and coded automatic application framework code generation in C++
- Designing and coding complex data structures, code reviews, walkthroughs, troubleshooting, maintenance and defect fixing of server-side 'C', & C++ code, analysis and optimisation of SQL queries