SUMMARY

• Senior Information Architect, Database Architect and Data Warehousing professional with extensive experience in the financial services industry.
• Effective leader in developing and motivating large technology on - shore and off-shore teams.
• Technology leader with Extensive hands-on experience in developing and executing strategies to promote optimal utilization of emerging technologies.
• Recognized as thought leader, change agent and strategic partner with proven record of success in leading large projects. Highly skilled in designing Data warehouses/marts, MDM (Master Data Management), OLTP (Online Transaction Processing), BI/DSS (Decision Support Systems) and OLAP (Online Analytical Processing) applications. Proficient in DB2, ER Studio, Sybase, MS SQL Server, ERWin, ETL processes and BI reporting technologies.

TECHNICAL SKILLS

Technologies: Business Intelligence, Data Warehousing, Big Data, MDM, SOA, Enterprise Information Architecture (EIA), Enterprise Service Bus, Portal/Dashboards, Predictive Analysis

Databases: DB2, Oracle, MySQL, Sybase, MS SQL Server

Languages: Python, PHP, C#, .Net, ASP.NET, Java, JSP, XML, VB, JavaScript, CSS, SQL, Perl

Tools: ER Studio, ERWin, Informatica, Oracle Data Modeler, MS SQL Server Integration Services (SSIS), MS Projects, MS PowerPoint, V

PROFESSIONAL EXPERIENCE

Confidential, NY

Principal Architect - Data Strategy

Responsibilities:

• Delivered target architecture and roadmap for next generation Enterprise Client Data Service. Evaluated over 100 current state of Client onboarding processes and systems. Documented process inefficiencies and data quality issues. Designed framework for the target future state. Discussed and prioritized various interim initiatives to reach the target state.
• Designed data model for storage of core Client Reference Data, Party Master, Legal Entities, Client Hierarchies, Client Relationships to other Clients as well as Accounts, Limits and Restrictions. Usage of machine learning and natural language processing to digitize contract documents. Further extended the design to store Client-Services catalog and Netting rules for Counterparty Risk, AML and FATCA processes.
• Designed a crowd sourcing platform for collaboration of client data along with approval process to apply/promote changes to central Client data repository.
• Designed data syndication layer to publish client data in batch and real-time formats.
• Evaluated Data Virtualization and Data Lake tools and technologies

Environment: ER Studio, MS SQL Server, Oracle

Confidential, NJ

Data Analytics Solution Architect

Responsibilities:

• Architect responsible for assessing current state, designing and implementing Data road map to meet business requirements using Big Data, SQL and NoSQL technologies.
• Architected Consolidated Exposure data warehouse and dimensional data mart by bringing Deal, Credit Lines, Collateral, Guarantee, Cash flow and Risk metrics information for each counterparty across all IHC entities.
• Designed end to end architecture for FATCA compliance. Designed integration between DWH, Customer MDM, KYC, AML and vendor product for capturing Tax Forms, Validation and Tax Withholding rates. Designed Tax Data Mart for TaxOps.
• Designed treasury data mart to consolidate cash flow exposure to the bank for various Management and ad-hoc reports. Architected integration with Oracle OFSAA LRMS and ALM modules for 2052A Fed report generation. Designed intraday near real time data flows to enable Basel III and Dodd-Frank stress test scenarios.
• Architected and designed logical and physical data models for the Global Core Banking data warehouse. Designed dimensional reporting data marts for use by Finance, Operations, Enterprise Risk and Compliance across all lines of business. Analyzed source data procured from various regional and head-office applications, conformed data into dimensions and created several fact tables to meet complex business requirements.
• Managed and lead a team of data architects and data modelers, mentored and reviewed their work. Created WBS, estimated effort, work allocation and ensured timely delivery at every phase of development.
• Defined processes for documenting logical and physical data models. Implemented best practices for data warehouse design using wide range of BI technologies and disciplines including Type 2 SCDs, Star-Schema, Snow-flaking etc. Presented and reviewed design changes with users, BAs, DBAs, ETL and BI team members. Published revisions along with change logs. Drove conversation leading to standardization of data types for amount and rate columns.
• Actively contributed to cross-team initiatives such as CDW design. Worked closely with DWH Enhancement design, ETL and BI teams. Designed confirmed dimensions which are now being utilized by CDW as well as Product marts. Brainstormed and introduced Type-7 dimensions, Link tables and Durable ID generation to allow flexible reporting across varying time horizon - As of date vs. As of today.
• Maintained a library of design documents including Data dictionary, ER diagrams, Design standards, ER Studio macros and Naming standards. Designed and implemented data retention, data archival and data purging policies.

Environment: Embarcadero ER Studio, ERWin, DB2, Oracle, Informatica, Business Objects, Python