SUMMARY

• Senior data architect focused on building interactive slice - and-dice reporting stacks on top of VLDBs (Very Large DataBases), as well as delivering fast MOLAP dashboard in Cognos.
• Lead business intelligence solutions architect / developer, designing master business rule blueprints then converting these blueprints into functional analytical systems, including with VLDB back ends.
• Experienced finance systems specialist. Delivered multi-tiered reporting and data mining solutions servicing portfolio accounting, profitability, operational risk, VAR, and momentum analytics
• Lead data modeler. Designed large logical ERDs for both analytical (Data Warehouse / Data Mart) and transaction data models. In addition, migrate logical ERDs into Physical models and deliver associated data dictionaries.
• Lead developer: wrote data bus servicing APIs that seamlessly pulls data from a set of heterogeneous sources, apply statistical, operational, semantic, and other operations to the flow, then broadcast results into several recipient data stores.
• Metadata specialist, responsible for the design, implementation, and support of a large MDM (Master Data Management) repository that also collects (via ETL tools such as Informatica) profiling data for core entities.
• Senior integration architect, delivering large scale automated transformations workflows of data residing in repositories servicing transaction grade systems into analytical databases, an exercise that includes massive amount of type inheritance modeling and casting.
• Experienced project manager, regularly transforming exchanges with business personnel into detailed business flows, business mappings, and project plans for teams of resources in the US and India,
• Senior Big data specialist, with several deliveries in Hadoop, Mongo, and other platforms.

TECHNICAL SKILLS

OLAP: Splunk, MicroStrategy, Cognos.

Database: MS-SQL Server, Sybase, DB2, Oracle.

Coding: PHP, Java, Python.

Big Data: NoSQL, Hadoop, Mongo, MapReduce

Data Warehousing: Ab Initio, DataStage, Informatica

Data Modeling: ER/Win, ER/Studio

PROFESSIONAL EXPERIENCE

Confidential, NYC

Senior Analytics Data Architect

Responsibilities:

• Develop advanced analytical dashboards that address the following areas: finance & audit, portfolio accounting, risk metrics, VAR reporting, portfolio performance, hedging performance, and system resource consumption
• In addition to live interactive dashboards, I delivered several canned report sets to structure statistics and graphs of accounts, hedge pools, and portfolio based on user-defined rules obtained through my business analysis efforts. These canned reports continue to undergo extensive on-going customization. Core analysis focused on:
• Mark- to-market derivatives analysis.
• Materializing linkage between specific assets / liabilities and hedging instruments
• Abstracting hedging relationships into executive documentation.
• Compliance reporting
• Income statement volatility management (via hypothesis formulation and testing)
• Continue to deliver several dashboard out of own advanced Option reporting framework that was primarily developed for compliance reporting. In this platform, the NPV of an option is split into two components, allowing limited reporting of Time value only in the Income statement.
• Deliver end-to-end analytical solutions including:
• Reverse-engineer transaction systems into physical models
• Draw logical models out of these physical models
• Develop star-schema based EDW (enterprise data warehouse) ERD (entity relationship diagram) from the said logical models
• Snowflake the said EDW ERDs
• Superimpose partition schemes on the EDW ERD, delivering subject-specific data mart ERDs
• Forward engineer EDW and data mart ERDs into physical databases
• Design and implement many OLAP physical and soft cubes, with the former utilizing a third layer of extraction into a dense, fast proprietary data set
• Architect responsible for delivering an SOA (Service oriented architecture)-grade data consumption model that offers on-demand consistent schema views.
• Act as a lead business analyst, collecting (often vague) requirements from business partners, transforming them into structured system flows, and then transform all into a detailed project plan with resources, timelines, and phased deliveries
• Develop large, multi-phase, multi-mapping ETL graphs that automate data transformation from production transaction sources into T+1 analytical data warehousing schemas. Tools used are Informatica, Ab Initio, and DataStage
• Responsible for enterprise MDM (Master Data Management) repository, which contains several schemas covering reference data, operational metadata, functional metadata, financial instrument reference, and index reference.
• Publish several types of data dictionary grade reference data and metadata including:
• Type encapsulation, inheritance, sub-typing, and cross-typing
• Homonyms, synonyms, and antonyms.
• Pass-through entities and attributes (a.k.a. cross-link attributes / entities).
• Business-label defining attribute set (e.g. attributes defining a “Household”).